21.04.2012, 10:56
pawn Код:
db_query(Database, "CREATE TABLE IF NOT EXISTS `USERS` (`ID` AUTO_INCREMENT,`NAME`, `PASSWORD`, `IP`, `SCORE`, `CASH`, `ADMIN`, `VIP`)");
pawn Код:
format(Query, sizeof(Query), "SELECT `NAME` FROM `USERS` WHERE `NAME` = '%s' ",name);
Result = db_query(Database, Query);
if(db_num_rows(Result))
{
new Field[ 20 ];
db_get_field_assoc(Result, "ID", Field, 30);
format(Query, sizeof(Query), "**%s has registred making the total of %i players registred.", name, Field);
SendClientMessageToAll(0xFFFFFFAA,Query);
}