[manchestera]

Ok i want to state i have never used mysql before, so i would like to make a setlevel cmd but i dont have a clue how i do it to affect the database this is the code i think i need and it would be great to get a example i could use to carry on with over info saved in mysql many thanks..

Код:

PlayerInfo[playerid][pLevel],

mysql_fetch_field_row(savingstring, "level"); PlayerInfo[playerid][pLevel] = strval(savingstring);

level INT(20)

mysql_query("CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(40), score INT(20), money INT(20), level INT(20), vip INT(20), kma INT(20), rank INT(20), kills INT(20), deaths INT(20), muted INT(20), jailed INT(20), frozen INT(20), mutedtimes INT(20), jailedtimes INT(20), frozentimes INT(20), banned INT(20), bannedby VARCHAR(24), logins INT(20), posx INT(20), posy INT(20), posz INT(20), posa INT(20), IP VARCHAR(15) )");

Some detail about things would be great aswell.

Many thanks.

[Luis-]

To update a table you could do this;

pawn Код:

mysql_query("update 'table_name_here' set 'level' = 'level here'");