SQL SYNTAX ERROR[UPDATED] - Page 2

lucas_7_94 · 08-03-2011 , 12:28 Re: SQL SYNTAX ERROR[UPDATED]

CREATE TABLE IF NO EXISTS mytable ( asd, asd , asd , asd );

davidto1995 · 08-03-2011 , 12:48 Re: SQL SYNTAX ERROR[UPDATED]

another error:

Code:

Plugin says: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1

After edited(shorter):

Code:

        len += formatex(MSG[len], charsmax(MSG) - len, "CREATE TABLE IF NOT EXISTS trmod (")
	len += formatex(MSG[len], charsmax(MSG) - len, "ClientName varchar(32), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "ClientExp INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "ClientFame INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "ClientMoney INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "ClientLevel INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "ClientGoldCoin INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "ClientNorNickGet INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "ClientSeNickGet INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "ClientAch INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "ClinetNicknameID INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_CountKill INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_CountKillKnife INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_CountKillGrenade INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_CountKillAwp INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_MakeGunNum INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_TreasureNum INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_MakeClothingNum INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_ConnectTimeSec INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_ConnectTimeMin INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_ConnectTimeHour INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_DieTime INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_TreatmentNum INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_ItemHave INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_GiveMoneyNum INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_MetalResources INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_UseAudioTimes INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_ChangeEquipTimes INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_DropGunTimes INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_JumpTimes INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_CountFireMiunsHealth INT(11), ")
	len += formatex(MSG[len], charsmax(MSG) - len, "CN_CountWaterMiunsHealth INT(11), ")

	for(new i; i < MAX_NICK; i++)
	{
		if(i == 50)
		{
			len += formatex(MSG[len], charsmax(MSG) - len, "CN_BOOL_IsUserHaveNickname_%i ENUM('0', '1'))", i)
		}
		else
		{
			len += formatex(MSG[len], charsmax(MSG) - len, "CN_BOOL_IsUserHaveNickname_%i ENUM('0', '1'),", i)
		}
	}

fysiks · 08-03-2011 , 13:00 Re: SQL SYNTAX ERROR[UPDATED]

Have you printed MSG so that you can look at the final output to see if it is correct? If so, what does the whole thing look like?

davidto1995 · 08-03-2011 , 13:01 Re: SQL SYNTAX ERROR[UPDATED]

Quote:

Originally Posted by fysiks

Have you printed MSG so that you can look at the final output to see if it is correct? If so, what does the whole thing look like?

i wil try it now

ps:tried.Cannot print it out completely since MSG is too long(i think)

lucas_7_94 · 08-03-2011 , 13:08 Re: SQL SYNTAX ERROR[UPDATED]

in console or save it in a log.

btw

Code:

for(new i = 0; i < MAX_NICK; i++)
            len += formatex(MSG[len], charsmax(MSG) - len, "CN_BOOL_IsUserHaveNickname_%d ENUM('0', '1')%s", i, (i == MAX_NICK) ? ")" : ",")

davidto1995 · 08-03-2011 , 13:20 Re: SQL SYNTAX ERROR[UPDATED]

Quote:

Originally Posted by lucas_7_94

in console or save it in a log.

btw

Code:

for(new i = 0; i < MAX_NICK; i++)
            len += formatex(MSG[len], charsmax(MSG) - len, "CN_BOOL_IsUserHaveNickname_%d ENUM('0', '1')%s", i, (i == MAX_NICK) ? ")" : ",")

tried.
console = a little part
log = half

optimized

fysiks · 08-03-2011 , 13:34 Re: SQL SYNTAX ERROR[UPDATED]

What is the value of MAX_NICK?

davidto1995 · 08-03-2011 , 13:43 Re: SQL SYNTAX ERROR[UPDATED]

Quote:

Originally Posted by fysiks

What is the value of MAX_NICK?

51

lucas_7_94 · 08-03-2011 , 13:47 Re: SQL SYNTAX ERROR[UPDATED]

little array maybe?

fysiks · *Last edited by fysiks; 08-03-2011 at 13:53.*

Also, note that in lucas's code the variable i will never be MAX_NICK.

Here is what I get from the code in post 12:

Code:

CREATE TABLE IF NOT EXISTS trmod (ClientName varchar(32), ClientExp INT(11), ClientFame INT(11), ClientMoney INT(11), ClientLevel INT(11), ClientGoldCoin INT(11), ClientNorNickGet INT(11), ClientSeNickGet INT(11), ClientAch INT(11), ClinetNicknameID INT(11), CN_CountKill INT(11), CN_CountKillKnife INT(11), CN_CountKillGrenade INT(11), CN_CountKillAwp INT(11), CN_MakeGunNum INT(11), CN_TreasureNum INT(11), CN_MakeClothingNum INT(11), CN_ConnectTimeSec INT(11), CN_ConnectTimeMin INT(11), CN_ConnectTimeHour INT(11), CN_DieTime INT(11), CN_TreatmentNum INT(11), CN_ItemHave INT(11), CN_GiveMoneyNum INT(11), CN_MetalResources INT(11), CN_UseAudioTimes INT(11), CN_ChangeEquipTimes INT(11), CN_DropGunTimes INT(11), CN_JumpTimes INT(11), CN_CountFireMiunsHealth INT(11), CN_CountWaterMiunsHealth INT(11), CN_BOOL_IsUserHaveNickname_0 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_1 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_2 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_3 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_4 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_5 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_6 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_7 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_8 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_9 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_10 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_11 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_12 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_13 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_14 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_15 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_16 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_17 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_18 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_19 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_20 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_21 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_22 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_23 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_24 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_25 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_26 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_27 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_28 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_29 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_30 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_31 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_32 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_33 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_34 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_35 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_36 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_37 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_38 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_39 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_40 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_41 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_42 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_43 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_44 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_45 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_46 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_47 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_48 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_49 ENUM('0', '1'),CN_BOOL_IsUserHaveNickname_50 ENUM('0', '1'))

Which is 3091 characters. So, MSG needs to be bigger than that. (Note that I did not use MSG when getting this to print

).