Problem Mit Ingame Cash Shop

Synaptic

Hallo leute^^,

Also, ich habe ein kleines problemchen mit meinem Buy script D:

Der Standart funktioniert ja --> Er sendet das gekaufte item an die Postbox

ABER ! ich hab postbox wegen Dupe ausgebaut D:, also dachte ich mir das Item direkt ans inventar schicken ... naja kommen wir zum Code:

item zum Postkasten [Funktioniert]

PHP

<?php 


session_start();
if(!isset($_SESSION['id']) || !isset($_SESSION['user']) || !isset($_SESSION['pass']) || !isset($_SESSION['char'])){
header("Location: index.php");
} 
?>
<?php 
include "config.php";
?>
<?php
ob_start();
		$char = $_SESSION['char'];
		$user = $_SESSION['user'];
		$id = $_SESSION['id'];
		$itemids = $_GET['detail'];
		$page = $_GET['pages'];
		$topic = $_GET['categories'];
		// 1.Creating a Connection.
		$con = mysql_connect($server,$username,$password);
		if (!$con){
		die("Database connection failed: " . mysql_error());
		}
	
		//Selecting a Database CS.
		$csdb = mysql_select_db($db, $con);
		if (!$csdb){
		die("Database selection failed: " . mysql_error());
		}	
	
		//Perform database query on CS shop
		$shop = mysql_query("SELECT * FROM shop WHERE itemid='$itemids'", $con);
		if (!$shop) {
			die("Database query failed: " . mysql_error());
		}


		//Use returned data on CS
		$row = mysql_fetch_array($shop);
		$costdpt = $row['cost'];
		$itemid = $row['itemid'];
		$itemcount = $row['count'];
		$item_name = $row['name'];
		
		
		//Selecting a Database flyforfight .
		$flyforfightdb = mysql_select_db($flyffdb, $con);
		if (!$flyforfightdb){
		die("Database selection failed: " . mysql_error());
		}


		//Perform database query character
		$account = mysql_query("SELECT * FROM characters WHERE charname='$char'", $con);
		if (!$account) {
			die("Database query failed: " . mysql_error());
		}
		
		//Use returned data on flyforfight character
		$row2 = mysql_fetch_array($account);
		$name = $row2['charname'];
		$charid = $row2['id'];
		$accname = $row2['accountname'];
		$penya = $row2['penya'];		
		


		//Perform database query accounts
		$acc_sql = mysql_query("SELECT * FROM accounts WHERE username='$user'", $con);
		if (!$acc_sql) {
			die("Database query failed: " . mysql_error());
		}
		
		// 4. Use returned data on flyforfight character
		$acc_db = mysql_fetch_array($acc_sql);
		$acc_dpt = $acc_db['dpt'];
		if($acc_dpt >= $costdpt){
		$acc_total = $acc_dpt - $costdpt;
		if($itemids == ""){
		header("location: shop.php?categories=" . $topic . "&pages=" .$page . "&msg=1");
		}
		else{
		header("location: shop.php?categories=" . $topic . "&pages=" .$page . "&msg=2");
				
		//Selecting a Database flyforfight .
		$flyforfightdb = mysql_select_db($flyffdb, $con);
		if (!$flyforfightdb){
		die("Database selection failed: " . mysql_error());
		}
		 
		$sql = mysql_query("INSERT INTO mails VALUES ('$acc_total', '99000', '$charid', '0', '0', 'Deine Bestellung!', 'Viel Spass damit', '0', '$itemid', '0', '$itemcount', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1');");
		 	
		 	$q = "UPDATE accounts SET dpt='$acc_total'". 
			     "WHERE id='$id'";
			$result = mysql_query($q);
			header("location: shop.php?categories=" . $topic . "&pages=" .$page . "&msg=1");
	


}
		} else {
		 header("location: shop.php?categories=" . $topic . "&pages=" .$page . "&msg=2");
		}
		?>
<?php
 // Closing Connection
 if (isset($con)){
 mysql_close($con);
 }
?>

Alles anzeigen

Son und das ist meine Variante, Sie soll das item ans invi schicken (geht leider nicht)

PHP

<?php 
/* 
|====================================================|
|    Created By (c0san1j, rmoises, and vicky)        |
|====================================================|
*/
session_start();
if(!isset($_SESSION['id']) || !isset($_SESSION['user']) || !isset($_SESSION['pass']) || !isset($_SESSION['char'])){
header("Location: index.php");
} 
?>
<?php 
include "config.php";
?>
<?php
ob_start();
		$char = $_SESSION['char'];
		$user = $_SESSION['user'];
		$id = $_SESSION['id'];
		$itemids = $_GET['detail'];
		$page = $_GET['pages'];
		$topic = $_GET['categories'];
		// 1.Creating a Connection.
		$con = mysql_connect($server,$username,$password);
		if (!$con){
		die("Database connection failed: " . mysql_error());
		}
	
		//Selecting a Database CS.
		$csdb = mysql_select_db($db, $con);
		if (!$csdb){
		die("Database selection failed: " . mysql_error());
		}	
	
		//Perform database query on CS shop
		$shop = mysql_query("SELECT * FROM shop WHERE itemid='$itemids'", $con);
		if (!$shop) {
			die("Database query failed: " . mysql_error());
		}


		//Use returned data on CS
		$row = mysql_fetch_array($shop);
		$costdpt = $row['cost'];
		$itemid = $row['itemid'];
		$itemcount = $row['count'];
		$item_name = $row['name'];
		
		
		//Selecting a Database flyforfight .
		$flyforfightdb = mysql_select_db($flyffdb, $con);
		if (!$flyforfightdb){
		die("Database selection failed: " . mysql_error());
		}


		//Perform database query character
		$account = mysql_query("SELECT * FROM characters WHERE charname='$char'", $con);
		if (!$account) {
			die("Database query failed: " . mysql_error());
		}
		
		//Use returned data on flyforfight character
		$row2 = mysql_fetch_array($account);
		$name = $row2['charname'];
		$charid = $row2['id'];
		$accname = $row2['accountname'];
		$penya = $row2['penya'];		
		


		//Perform database query accounts
		$acc_sql = mysql_query("SELECT * FROM accounts WHERE username='$user'", $con);
		if (!$acc_sql) {
			die("Database query failed: " . mysql_error());
		}
		
		// 4. Use returned data on flyforfight character
		$acc_db = mysql_fetch_array($acc_sql);
		$acc_dpt = $acc_db['dpt'];
		if($acc_dpt >= $costdpt){
		$acc_total = $acc_dpt - $costdpt;
		if($itemids == ""){
		header("location: shop.php?categories=" . $topic . "&pages=" .$page . "&msg=1");
		}
		else{
		header("location: shop.php?categories=" . $topic . "&pages=" .$page . "&msg=2");
				
		//Selecting a Database flyforfight .
		$flyforfightdb = mysql_select_db($flyffdb, $con);
		if (!$flyforfightdb){
		die("Database selection failed: " . mysql_error());
		}
		 
		[COLOR="Red"]$sql = mysql_query("INSERT INTO inventory VALUES ('$itemid', '$charid', '1', '0', '0', '7200000', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0','-1');");[/COLOR]
		 	
		 	$q = "UPDATE accounts SET dpt='$acc_total'". 
			     "WHERE id='$id'";
			$result = mysql_query($q);
			header("location: shop.php?categories=" . $topic . "&pages=" .$page . "&msg=1");
	


}
		} else {
		 header("location: shop.php?categories=" . $topic . "&pages=" .$page . "&msg=2");
		}
		?>
<?php
 // Closing Connection
 if (isset($con)){
 mysql_close($con);
 }
?>

Alles anzeigen

Das rot markierte ist das von mir geänderte x:

hat einer vlt einen vorschlag ? btw ich benutzt gemoddete Caali Files.

MFG Synaptic

felix

Ich hab jetzt keine Caali Datenbank da, von daher kann ich nich
überprüfen ob dein string falsch eingefügt wird. Aber spontan, ohne den
Code zu überprüfen würde ich sagen das du vllt vergessen hast den
Inventory Slot festzulegen.

Nebenbei, Die Felder die Automatisch mit 0 ausgefüllt werden brauchst
du in deinem query nicht aufzuführen. Machs so wie in meinem Beispiel,
das ist wesentlich übersichtlicher.

PHP

$query = mysql_query("INSERT INTO table (spalte1, spalte2, spalte3) VALUES ('value1', 'value2', 'value3')")

Synaptic

Sache hat sich erledigt, kann geclosed werden.

~Synaptic

Problem Mit Ingame Cash Shop

Jetzt mitmachen!

SCHNELLZUGRIFF

HILFE & COMMUNITY

RECHTLICHES