SQLite Login/Register problem
#7

Code:
[11:42:26] 
[11:42:26] Filterscripts
[11:42:26] ---------------
[11:42:26]   Loaded 0 filterscripts.

[11:42:26] [db_log_queries]: CREATE TABLE IF NOT EXISTS `USERS` (`NAME`, `PASSWORD`, `MONEY`, `IP`, `ADMIN`, `LEVEL`, `EXP`, `KILLS`, `DEATHS`, `CASHBOX`, `HOTWIRE`, `DEATHMATCH`, `RACE`, `PEN`, `GUN1`, `GUN2`, `GUN3`, `AMMO1`, `AMMO2`, `AMMO3`, `HEALTH`, `ARMOR`, `POSX`, `POSY`, `POSZ`, `SKIN`)
[11:42:26] 
----------------------------------
[11:42:26]             Public Enemy LS: Remake
[11:42:26]                        RE-Coded by Flamehaze
[11:42:26] ----------------------------------

[11:42:26] Number of vehicle models: 14
[11:42:48] [connection] 127.0.0.1:56300 requests connection cookie.
[11:42:49] [connection] incoming connection: 127.0.0.1:56300 id: 0
[11:42:50] [join] [EvO]Flamehaze_ has joined the server (0:127.0.0.1)
[11:42:50] [db_log_queries]: SELECT `NAME` FROM `USERS` WHERE `NAME` = '[EvO]Flamehaze_' COLLATE NOCASE
[11:43:07] [db_log_queries]: INSERT INTO `USERS` (`NAME`, `PASSWORD`, `MONEY`, `IP`, `ADMIN`, `LEVEL`, `EXP`, `KILLS`, `DEATHS`, `CASHBOX`, `HOTWIRE`, `DEATHMATCH`, `RACE`, `PEN`, `GUN1`, `GUN2`, `GUN3`, `AMMO1`, `AMMO2`, `AMMO3`, `HEALTH`, `ARMOR`, `POSX`, `POSY`, `POSZ`, `SKIN`) VALUES('[EvO]Flamehaze_','pswtest','0','127.0.0.1','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0')
[11:43:07] [Warning] db_query: Query failed: 25 values for 26 columns
[11:43:07] The player has successfully registered
[11:43:32] [db_log_queries]: UPDATE `USERS` SET MONEY = '500', ADMIN = '0', LEVEL = '0', EXP = '0', KILLS = '0', DEATHS = '0', CASHBOX = '0', HOTWIRE = '0', DEATHMATCH = '0', RACE = '0', PEN = '0', GUN1 = '0', GUN2 = '0', GUN3 = '0', AMMO1 = '0', AMMO2 = '0', AMMO3, POSX = '1159499948', POSY = '-992965571', POSZ = '1096150080', SKIN = '105' = '91' WHERE `NAME` = '' COLLATE NOCASE
[11:43:32] [Warning] db_query: Query failed: near ",": syntax error
[11:43:32] The player has successfully saved his stats
[11:43:32] [part] [EvO]Flamehaze_ has left the server (0:1)
EDIT: I managed to fix the 26 columns error but then there's this:

Code:
[11:58:20] [db_log_queries]: UPDATE `USERS` SET MONEY = '30500', ADMIN = '0', LEVEL = '0', EXP = '1', KILLS = '0', DEATHS = '0', CASHBOX = '0', HOTWIRE = '0', DEATHMATCH = '0', RACE = '0', PEN = '0', GUN1 = '0', GUN2 = '0', GUN3 = '0', AMMO1 = '0', AMMO2 = '0', AMMO3, POSX = '1159498234', POSY = '-992965497', POSZ = '1096148473', SKIN = '105' WHERE `NAME` = '[EvO]Flamehaze_' COLLATE NOCASE
[11:58:20] [Warning] db_query: Query failed: near ",": syntax error
Reply


Messages In This Thread
SQLite Login/Register problem - by Flamehaze7 - 13.03.2017, 09:47
Re: SQLite Login/Register problem - by SyS - 13.03.2017, 09:49
Re: SQLite Login/Register problem - by Flamehaze7 - 13.03.2017, 09:55
Re: SQLite Login/Register problem - by SyS - 13.03.2017, 09:59
Re: SQLite Login/Register problem - by Flamehaze7 - 13.03.2017, 10:02
Re: SQLite Login/Register problem - by X337 - 13.03.2017, 10:41
Re: SQLite Login/Register problem - by Flamehaze7 - 13.03.2017, 10:52
Re: SQLite Login/Register problem - by w1z4rd - 13.03.2017, 12:07
Re: SQLite Login/Register problem - by Flamehaze7 - 13.03.2017, 12:27

Forum Jump:


Users browsing this thread: 1 Guest(s)