input line too long
#1

Код:
./includes/gvc.pwn(94266) : warning 213: tag mismatch
./includes/gvc.pwn(94266) : warning 213: tag mismatch
./includes/gvc.pwn(95437 -- 95438) : error 075: input line too long (after substitutions)
./includes/gvc.pwn(95439) : error 017: undefined symbol "INSERT"
./includes/gvc.pwn(95439) : error 017: undefined symbol "INTO"
./includes/gvc.pwn(95439) : error 029: invalid expression, assumed zero
./includes/gvc.pwn(95439) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


5 Errors.
Code:

Код:
format(string, sizeof(string),
	"INSERT INTO `accounts`(`RegiDate`, `LastLogin`, `Username`, `Key`, `Ammo1`, `Ammo2`, `Ammo3`, `Ammo4`, `Ammo5`, `Ammo6`, `Ammo7`, `Ammo8`, `wSaveSlot1`, `wSaveSlot2`, `wSaveSlot3`, `wSaveSlot4`, `wSaveSlot5`, `wSaveSlot6`, `wSaveSlot7`, `wSaveSlot8`, `aSaveSlot1`, `aSaveSlot2`, `aSaveSlot3`, `aSaveSlot4`, `aSaveSlot5`, `aSaveSlot6`, `aSaveSlot7`, `aSaveSlot8`, `FacGuns1`, `FacGuns2`, `FacGuns3`, \
	`FacGuns4`, `FacGuns5`, `FacGuns6`, `FacGuns7`, `FacGuns8`, `Hambuger`, `Pizza`, `BanhMi`, `Hyperion`, `ThanhGo`, `HopGiay`, `TuaVitHP`, `ThungXang`, `ThungXangHP`, `JModel`, `Neon`, `C4Robbank`, `SuaBo`, `FacAmmo1`, `FacAmmo2`, `FacAmmo3`, `FacAmmo4`, `FacAmmo5`, `FacAmmo6`, `FacAmmo7`, `FacAmmo8`) VALUES (NOW(), NOW(), '%s', '%s', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', \
	'0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')", 
	GetPlayerNameExt(playerid), passbuffer);
	mysql_function_query(MainPipeline, string, false, "OnQueryFinish", "iii", REGISTER_THREAD, playerid, g_arrQueryHandle{playerid});
Reply
#2

Read my tutorials (linked below in my signature) that teach you exactly what you should not be doing now. What do FacGuns (which I assume means "Faction Guns") even have to do with "accounts"? If you're going to use SQL then don't treat it like a dirty file system. This looks like it should be normalized into two or three additional tables.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)