cant insert my weapon to player.
Posted: Sun Oct 10, 2010 6:47 am
I think i have it all covered, but obviously i dont =P
1* I have the structure and values asigned.
2* the DB also have misstext and hittext structure. both on playerweapons and the shop.
3* i also use lowercasings all over the place so i dont have to worry about that.
still i get the error "could not insert the damn weapon into backpack"
what am i missing ???
$playerid = $playerinfo3['id'];
$name = $iteminfo3['name'];
$misstext1 = $iteminfo3['misstext1'];
$misstext2 = $iteminfo3['misstext2'];
$misstext3 = $iteminfo3['misstext3'];
$misstext4 = $iteminfo3['misstext4'];
$hit = $iteminfo3['hit'];
$wlevel = $iteminfo3['level'];
$hittext1 = $iteminfo3['hittext1'];
$hittext2 = $iteminfo3['hittext2'];
$hittext3 = $iteminfo3['hittext3'];
$hittext4 = $iteminfo3['hittext4'];
$damage = $iteminfo3['damage'];
$randid = rand(1000,999999999);
$price = $iteminfo3['price'];
$itembought = "INSERT into playerweapons(pid, name, hit, level, randid, price, misstext1, misstext2, misstext3, misstext4, class, hittext1, hittext2, hittext3, hittext4, damage) VALUES ('$playerid','$name','$hit','$wlevel','$randid','$price','$misstext1','$misstext2','$misstext3','$misstext4','$class','$hittext1','$hittext2','$hittext3','$hittext4','$damage')";
mysql_query($itembought) or die("could not insert the damn weapon into backpack");
1* I have the structure and values asigned.
2* the DB also have misstext and hittext structure. both on playerweapons and the shop.
3* i also use lowercasings all over the place so i dont have to worry about that.
still i get the error "could not insert the damn weapon into backpack"
what am i missing ???
$playerid = $playerinfo3['id'];
$name = $iteminfo3['name'];
$misstext1 = $iteminfo3['misstext1'];
$misstext2 = $iteminfo3['misstext2'];
$misstext3 = $iteminfo3['misstext3'];
$misstext4 = $iteminfo3['misstext4'];
$hit = $iteminfo3['hit'];
$wlevel = $iteminfo3['level'];
$hittext1 = $iteminfo3['hittext1'];
$hittext2 = $iteminfo3['hittext2'];
$hittext3 = $iteminfo3['hittext3'];
$hittext4 = $iteminfo3['hittext4'];
$damage = $iteminfo3['damage'];
$randid = rand(1000,999999999);
$price = $iteminfo3['price'];
$itembought = "INSERT into playerweapons(pid, name, hit, level, randid, price, misstext1, misstext2, misstext3, misstext4, class, hittext1, hittext2, hittext3, hittext4, damage) VALUES ('$playerid','$name','$hit','$wlevel','$randid','$price','$misstext1','$misstext2','$misstext3','$misstext4','$class','$hittext1','$hittext2','$hittext3','$hittext4','$damage')";
mysql_query($itembought) or die("could not insert the damn weapon into backpack");