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