[ScottCFR]

This is register:

Код:

format(query,sizeof(query),"INSERT INTO users (name, password) VALUES ('%s', '%s')",name,password);

This is update:

Код:

format(query,sizeof(query),"UPDATE users SET name='%s', password='%s', admin=%d, cash=%d, score=%d WHERE SQLid=%d",name,AccountInfo[playerid][Password],AccountInfo[playerid][AdminLevel],AccountInfo[playerid][Cash],AccountInfo[playerid][Score],AccountInfo[playerid][mglvl],AccountInfo[playerid][SQLid]);

This may be usefule GetPlayerSQLid:

Код:

format(query,sizeof(query),"SELECT SQLid FROM users WHERE name='%s'",name);

This is the SQL system I use:
https://sampforum.blast.hk/showthread.php?tid=122983