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

You Say: ??
Код:
           format(Query, sizeof(Query), "INSERT INTO `members` (`id`, `playername`, `password`, `email`, `adminlevel`, `viplevel`, `viptime`, `score`, `onlinetime`, `faction`, `staticfaction`, `lastloginevent`, `lastlogineventtime`, `lastwinevent`, `lastwineventtime`, `totaleventcount`)", escpname, escpass, PIP),
			format(Query, sizeof(Query), "`jailtime`, `deathcount`, `killcount`, `moneycount`, `bankmoneycount`, `nicknamecolor`,`weapon1`, `weapon2`, `weapon3`, `weapon4`, `ammo1`, `ammo2`, `ammo3`, `ammo4`, `skin`, `ingame`, `ip`, `spawnposx`, `spawnposy`, `spawnposz`, `crashx`, `crashy`, `crashz`, `fightstyle`, `homeno`, `stuntpoint`, `eventpoint`)", escpname, escpass, PIP),
		 	format(Query, sizeof(Query), "`security`, `old1`, `old2`, `old3`, `old4`, `warningpoint`, `inevent`, `coupon1`, `coupon2`) VALUES (mysql_insert_id()NULL, '%s', '%s', 'yourmail@hotmail.com')", escpname, escpass, PIP),
 			format(Query, sizeof(Query), "'0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '5000', '5000', '0xFFFFFFFF', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '%s', '2034.1202', '1007.9800', '10.8203', '2034.1202', '1007.9800', '10.8203')", escpname, escpass, PIP);
			format(Query, sizeof(Query), "'FIGHT_STYLE_NORMAL', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0')", escpname, escpass, PIP);
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: 2 Guest(s)