(MySql) input line too long
#6

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:

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", "");
Reply


Messages In This Thread
(MySql) input line too long - by goldspy98 - 20.11.2013, 20:11
Re: (MySql) input line too long - by InglewoodRoleplay - 20.11.2013, 21:01
Re: (MySql) input line too long - by goldspy98 - 20.11.2013, 21:30
Re: (MySql) input line too long - by InglewoodRoleplay - 20.11.2013, 21:49
Re: (MySql) input line too long - by goldspy98 - 20.11.2013, 22:01
Re: (MySql) input line too long - by InglewoodRoleplay - 20.11.2013, 22:09
Re: (MySql) input line too long - by goldspy98 - 20.11.2013, 22:13
Re: (MySql) input line too long - by InglewoodRoleplay - 20.11.2013, 22:19
Re: (MySql) input line too long - by goldspy98 - 20.11.2013, 22:23
Re: (MySql) input line too long - by InglewoodRoleplay - 20.11.2013, 22:26

Forum Jump:


Users browsing this thread: 2 Guest(s)