28.12.2010, 21:55
Quote:
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'); Код:
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); |
I have a new membership database, enter the value. If these values do not live down to the problem? Are you sure?