02.09.2012, 11:22
Without spaces:
pawn Код:
new
Query[ 256 ],
DBResult:Result,
Field[ 30 ]
;
format(Query, sizeof(Query),"SELECT * FROM `Vips` WHERE `Nume` = '%s'", PlayerName(playerid) ;
Result = db_query(Database,Query);
if(Result)
{
if (db_num_rows(Result))
{
db_get_field_assoc(Result,"VipLevel",Field,4); P_DATA[playerid][Vip] = strval(Field);
db_get_field_assoc(Result,"VSkin",Field,4); P_DATA[playerid][p_FavSkin] = strval(Field);
}
else
{
P_DATA[playerid][Vip] = 0;
P_DATA[playerid][p_FavSkin] = -1;
format(Query,sizeof Query,"INSERT INTO `Vips` VALUES(NULL,'%s','0','-1')",PlayerName(playerid));
db_query(Database,Query);
}
db_free_result(Result);
}