20.11.2013, 22:09
What plugin are you using, is it BlueG's R6, R7 or a different one?
Update:
Anyways, here's how I write my queries using the R7 MySQL plugin:
Update:
Anyways, here's how I write my queries using the R7 MySQL plugin:
pawn Code:
format(SQLQuery, sizeof(SQLQuery),"INSERT INTO `playerinfo` (`ipAdress`, `name`, `password`, `admin`, `moderator`, `vip`, `credits`, `language`, `timeMuted`, `timeJailed`, `banned`, `skin`, `spawnInterior`) VALUES ('%s', '%e', sha1('%e'), '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i')", PlayerInfo[playerid][ipAdress], PlayerInfo[playerid][name], PlayerInfo[playerid][password], PlayerInfo[playerid][admin], PlayerInfo[playerid][moderator], PlayerInfo[playerid][vip], PlayerInfo[playerid][credits], PlayerInfo[playerid][language], PlayerInfo[playerid][timeMuted], PlayerInfo[playerid][timeJailed], PlayerInfo[playerid][banned], PlayerInfo[playerid][skin], PlayerInfo[playerid][spawnInterior]);
mysql_function_query(mysqlConnectHandle, SQLQuery, true, "EmptyCallback", "");