Right I changed it... so im trying to think here.. that wasnt updating the rows.. could I just populate the creatures database randomly and have there x and y stored in there and just read it from the map... im very confusedddddddddddddddddddddddddd

this damn thing just wont update.... ////////////////////////Creature is dead delete then re add to database $mapcrsql="SELECT * FROM map WHERE mapr='". $_SESSION['mapr'] ."' AND mapc='". $_SESSION['mapc'] ."' LIMIT 1"; $mapcr_result=mysql_query($mapcrsql) or die("...

well you can use echo "". $var=[var] .""; its the same just highlights the code. like this awesomely cool sql join from a old game <?php $sql5="SELECT mitem.sid, mitem.name, mitem.type, muser.username, muser.slot1 FROM mitem inner join muser on mitem.sid = muser.slot1 WHERE ...

////////////////////////Creature is dead delete then re add to database $mapcrsql="SELECT * FROM map WHERE mapr='". $_SESSION['mapr'] ."' AND mapc='". $_SESSION['mapc'] ."' LIMIT 1"; $mapcr_result=mysql_query($mapcrsql) or die("<br>Could not get creature informati...

right but wont that delete the whole row??

I just want to update the crname and crhp to say blank or 0

I was thinking this $crmaxhp=$creatureinfo3['maxhpoints']; $updatecreature="UPDATE map SET crhp=0 WHERE mapr='$mapinfo3[mapr]' AND mapc='$mapinfo3[mapc]' limit 1"; mysql_query($updatecreature) or die("Could not update creature"); but im thinking that could possible work so would ...

Ok so I made it so that battle arena no longer exist and its mob's on the map instead.. I am trying to figure out is

if the mob is attacked then killed it should be erased and re spawned some where else.. how will I go about doing this in the attack.php page?

ok well.. if a mob or (monster) is higher then you. you will want to give the user less exp. that way they cant abuse the system and get the 30 exp from a mod that is 5 - 10 level's lower then them. the higher the level the lower the exp you want to give the player from that mob

shouldn't the $creature= $_GET['player'] should be $creature = $playerinfo3['creature'] unless you are doing something on the lines of PVP??

then ur not doing ur md5 right as they said make sure it is 32++ try 255 as the field size... and that is max. google md5 or hashing or sha as well there are more secure ways nowe with the new apache server that has come out that are more better and encrypted better!!!