Raised This Month: $ Target: $400
 0% 

SQL QUERY


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
davidto1995
Member
Join Date: Jul 2010
Location: hong kong
Old 08-01-2011 , 22:55   SQL QUERY
Reply With Quote #1

there are 26 errors
24 are undefined symbol "INT" line 291-314
1 is undefined symbol "ClientName" line 290
1 is invalid string <possibly non-terminated string> line290
Code:
Queries = SQL_PrepareQuery(SqlConnection, "CREATE TABLE IF NOT EXISTS TRMOD_DB (
	ClientName varchar(64), //line 290
	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), // line 314
	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 varchar(6),
	CN_BOOL_IsUserHaveNickname_1 varchar(6),
	CN_BOOL_IsUserHaveNickname_2 varchar(6),
	CN_BOOL_IsUserHaveNickname_3 varchar(6),
	CN_BOOL_IsUserHaveNickname_4 varchar(6),
	CN_BOOL_IsUserHaveNickname_5 varchar(6),
	CN_BOOL_IsUserHaveNickname_6 varchar(6),
	CN_BOOL_IsUserHaveNickname_7 varchar(6),
	CN_BOOL_IsUserHaveNickname_8 varchar(6),
	CN_BOOL_IsUserHaveNickname_9 varchar(6),
	CN_BOOL_IsUserHaveNickname_10 varchar(6),
	CN_BOOL_IsUserHaveNickname_11 varchar(6),
	CN_BOOL_IsUserHaveNickname_12 varchar(6),
	CN_BOOL_IsUserHaveNickname_13 varchar(6),
	CN_BOOL_IsUserHaveNickname_14 varchar(6),
	CN_BOOL_IsUserHaveNickname_15 varchar(6),
	CN_BOOL_IsUserHaveNickname_16 varchar(6),
	CN_BOOL_IsUserHaveNickname_17 varchar(6),
	CN_BOOL_IsUserHaveNickname_18 varchar(6),
	CN_BOOL_IsUserHaveNickname_19 varchar(6),
	CN_BOOL_IsUserHaveNickname_20 varchar(6),
	CN_BOOL_IsUserHaveNickname_21 varchar(6),
	CN_BOOL_IsUserHaveNickname_22 varchar(6),
	CN_BOOL_IsUserHaveNickname_23 varchar(6),
	CN_BOOL_IsUserHaveNickname_24 varchar(6),
	CN_BOOL_IsUserHaveNickname_25 varchar(6),
	CN_BOOL_IsUserHaveNickname_26 varchar(6),
	CN_BOOL_IsUserHaveNickname_27 varchar(6),
	CN_BOOL_IsUserHaveNickname_28 varchar(6),
	CN_BOOL_IsUserHaveNickname_29 varchar(6),
	CN_BOOL_IsUserHaveNickname_30 varchar(6),
	CN_BOOL_IsUserHaveNickname_31 varchar(6),
	CN_BOOL_IsUserHaveNickname_32 varchar(6),
	CN_BOOL_IsUserHaveNickname_33 varchar(6),
	CN_BOOL_IsUserHaveNickname_34 varchar(6),
	CN_BOOL_IsUserHaveNickname_35 varchar(6),
	CN_BOOL_IsUserHaveNickname_36 varchar(6),
	CN_BOOL_IsUserHaveNickname_37 varchar(6),
	CN_BOOL_IsUserHaveNickname_38 varchar(6),
	CN_BOOL_IsUserHaveNickname_39 varchar(6),
	CN_BOOL_IsUserHaveNickname_40 varchar(6),
	CN_BOOL_IsUserHaveNickname_41 varchar(6),
	CN_BOOL_IsUserHaveNickname_42 varchar(6),
	CN_BOOL_IsUserHaveNickname_43 varchar(6),
	CN_BOOL_IsUserHaveNickname_44 varchar(6),
	CN_BOOL_IsUserHaveNickname_45 varchar(6),
	CN_BOOL_IsUserHaveNickname_46 varchar(6),
	CN_BOOL_IsUserHaveNickname_47 varchar(6),
	CN_BOOL_IsUserHaveNickname_48 varchar(6),
	CN_BOOL_IsUserHaveNickname_49 varchar(6),
	CN_BOOL_IsUserHaveNickname_50 varchar(6)
	)")
it will be greatly appericiated if you would like to fix the code
davidto1995 is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 03:31.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode