[goldspy98]

Quote:

Originally Posted by InglewoodRoleplay What plugin are you using, is it BlueG's R6, R7 or a different one?

I use a plugin of BlueG's but a more recent version the R34 (https://code.******.com/p/sa-mp-mysql-plugin/)

Wiki Samp: https://sampwiki.blast.hk/wiki/MySQL/R33


If it is not good if you can suggest another is because is the my first time I try use a system of mysql for SAMP.

---------------------

Quote:

Originally Posted by InglewoodRoleplay 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", "");

The version R34 not have the fuction mysql_function_query the equivalent fuction is mysql_tquery I think, you is better I use the version R7?