[Mysql]Too Long Query (Idea Please)
#9

Quote:
Originally Posted by xxmitsu
Посмотреть сообщение
For example, I've made a query from the first 24 columns and the second query from the other ones.


Part 1:
Код:
format(Query, sizeof(Query), "INSERT INTO `members` (`id`, `playername`, `password`, `email`, `adminlevel`, `viplevel`, `viptime`, `score`, `onlinetime`, `faction`, `staticfaction`, `lastloginevent`, `lastlogineventtime`, `lastwinevent`, `lastwineventtime`, `totaleventcount`,`jailtime`, `deathcount`, `killcount`, `moneycount`, `bankmoneycount`, `nicknamecolor`,`weapon1`, `weapon2`) VALUES (mysql_insert_id()NULL, '%s', '%s', 'yourmail@hotmail.com','0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '5000', '0xFFFFFFFF', '0', '0');
Part 2:
Код:
format(Query, sizeof(Query), "INSERT INTO `members` (`weapon3`, `weapon4`, `ammo1`, `ammo2`, `ammo3`, `ammo4`, `skin`, `ingame`, `ip`, `spawnposx`, `spawnposy`, `spawnposz`, `crashx`, `crashy`, `crashz`, `fightstyle`, `homeno`, `stuntpoint`, `eventpoint`,`security`, `old1`, `old2`, `old3`, `old4`, `warningpoint`, `inevent`, `coupon1`, `coupon2`) VALUES ('0', '0', '0', '0', '0', '0', '0', '1', '%s', '2034.1202', '1007.9800', '10.8203', '2034.1202', '1007.9800', '10.8203','FIGHT_STYLE_NORMAL', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')", escpname, escpass, PIP);
PS: perhaps I haven't counted the number of columns right but you got the point..
I try..


Quote:
Originally Posted by ******
Посмотреть сообщение
If you are setting values for all the columns you don't need to specify them, just write them all in the correct order.
I have a new membership database, enter the value. If these values do not live down to the problem? Are you sure?
Reply


Messages In This Thread
[Mysql]Too Long Query (Idea Please) - by bkart - 28.12.2010, 21:34
Re: [Mysql]Too Long Query (Idea Please) - by xxmitsu - 28.12.2010, 21:36
Re: [Mysql]Too Long Query (Idea Please) - by DVDK - 28.12.2010, 21:41
Re: [Mysql]Too Long Query (Idea Please) - by _rAped - 28.12.2010, 21:41
Re: [Mysql]Too Long Query (Idea Please) - by bkart - 28.12.2010, 21:43
Re: [Mysql]Too Long Query (Idea Please) - by _rAped - 28.12.2010, 21:46
Re: [Mysql]Too Long Query (Idea Please) - by bkart - 28.12.2010, 21:46
Re: [Mysql]Too Long Query (Idea Please) - by xxmitsu - 28.12.2010, 21:48
Re: [Mysql]Too Long Query (Idea Please) - by bkart - 28.12.2010, 21:55
Re: [Mysql]Too Long Query (Idea Please) - by xxmitsu - 28.12.2010, 22:01

Forum Jump:


Users browsing this thread: 1 Guest(s)