Query server

luuney

I wanted to keep track of who is playing on my gameserver, at the end of the script a got this

  if($info["numplayers"]>0) {
                $start=$info["numplayers"]-1;

for($i=$start;$i>=0;$i--) {
    mysql_query ( "insert into players  ( Name) values 
                       ( ' ".$players[$i]["name"]." ')") ;

}

}

But now it adds all players that are playing on my server nomatter if its already in the database.
How do i make it that only the names that are not in the database are added?

jpmoriarty

why dont you just run a query that gets rid of every one first:
$sql = "delete * from players";
mysql_query($sql);

and then do your bit.

Will probably be easier and quicker than checking who exists and who doesnt and then just adding the ones that dont etc...

Just clear em all out first!

luuney

Originally posted by jpmoriarty
why dont you just run a query that gets rid of every one first:
$sql = "delete * from players";
mysql_query($sql);

and then do your bit.

Will probably be easier and quicker than checking who exists and who doesnt and then just adding the ones that dont etc...

Just clear em all out first!

This wouldnt work because i want to know who ever have played on the server not only at the moment i query it.

Gargouil

maybe you can add a column to you player table

column like IsPlaying and passing a 0 or 1

in this way you will have all the player name then when performing you above test.. reset all the player to 0 then turn to 1 the one who was playing

luuney

How do i do it if i want to check if the name exist i dont wanna add it and if the name doesnt exist in the database it must be added?

Gargouil

use the name column as the key
or define it unique..