Script Php

[Bleadd]

Hello everybody,

 

I'm a newbie about PHP and i need help with a script..

 

<form action="" method="POST">
<table>
<tr><td>Character Name:</td><td><input type="text" name="name"></td></tr>
<tr><td><input type="submit" value="Insert" name="submit"></td></tr>
</table>
</form>

<?php

$name = $_POST['name'];

$submit = $_POST['submit'];

if ($submit) {

include ('connect.php');

//hardcoding Kill Me

if ($name) {

$row = mysql_fetch_assoc(mysql_query("SELECT * FROM characters WHERE char_name='".$name."'"));
$obj_id = $row[obj_Id];

mysql_query("INSERT INTO `items` (`owner_id`, `object_id`, `item_id`, `count`, `enchant_level`, `loc`, `loc_data`, `price_sell`, `price_buy`, `time_of_use`, `custom_type1`, `custom_type2`, `mana_left`) VALUES
(".$obj_id.", 0, 4037, 1, 0, 'INVENTORY', 0, 0, 0, NULL, 0, 0, '-1');");
echo "<b>Your Item Has Been Inserted.</b>";

}
else {
echo "<b>This item does not exist.</b>";
}



}

?>

}

}

 

This code is useful for add an itembut i need to add a condition : If the player already get this object (4037 : coin of luck) the script get the number of CoL that he has and the script add 3 more CoL to the count and make an update request...

 

I tried for 3 hours but nerver success.. If someone can try ?

 

Sincerelly,

Bleadd

[adenaman]

the sql query is

SELECT  items.count from items, characters where characters.char_name='".$name."'" and characters.charId = items.owner_id and items.object_id=4037

--not sure about '".$name."'", never used php

 

this can return and empty row(null) if he does not have any or a number if he has them

 

and then update the row (UPDATE items SET count = ( count + 3) WHERE ...)

 

try this, maybe i made any mistake

[Bleadd]

And how can i make a condition like : if (count = 0)?

[Bleadd]

Bump

 

[josecarlosfl18]

You can try this...

<?PHP
$username="database_user";
$password="database_passwd";
$database="database_name";
$conexion=mysql_connect('server_address',$username,$password) 
or die("¿¡¡Cannot Connect to Database!!!");
$db=mysql_select_db($database) or die("I Dont Get to The Database");
$itemIdToCompare = 4037;
$result = mysql_query("SELECT  item_colum, character_id_colum FROM item_table_character WHERE item_colum='".$itemIdToCompare."", $conexion);
$num_rows = mysql_num_rows($result);
if ($num_rows > 0){
   echo("I Got the ".$itemIdToCompare." Item, can discount or wherever");
   } 
else {
   ... (code to folow in case of dont have the item)
}
mysql_close(); 
?>

 

That should work...

 

Credits By Me...