Shortening a MySQL Query?
#1

So this is my query, as it's so long it prevents players from registering.

pawn Код:
new DB_Query[5000];

mysql_format(Database, DB_Query, sizeof(DB_Query), "INSERT INTO `PLAYERS` (`USERNAME`, `PASSWORD`, `SALT`, `REGDATE`, `SCORE`, `KILLS`, `CASH`, `DEATHS`, `ADMIN`, `SKIN`, `TOKENS`, `DONATOR`, `NAMECHANGES`, `TOKENS`, `HEADSHOTS`)\
                VALUES ('%e', '%s', '%e', NOW(), '0', '0', '0', '0', '0', '29', '0', '0', '0', '0', '0')"
, pInfo[playerid][Name], pInfo[playerid][Password], pInfo[playerid][Salt]);
                mysql_pquery(Database, DB_Query, "OnPlayerRegister", "d", playerid);
Is there a way I can shorten it or divide it into two separate queries to make it work?
Reply


Messages In This Thread
Shortening a MySQL Query? - by Jing_Chan - 30.07.2018, 13:01
Re: Shortening a MySQL Query? - by Rufio - 30.07.2018, 13:04
Re: Shortening a MySQL Query? - by Jing_Chan - 30.07.2018, 13:26
Re: Shortening a MySQL Query? - by Calisthenics - 30.07.2018, 13:26
Re: Shortening a MySQL Query? - by Rufio - 30.07.2018, 13:29
Re: Shortening a MySQL Query? - by Jing_Chan - 30.07.2018, 13:33
Re: Shortening a MySQL Query? - by Rufio - 30.07.2018, 13:52

Forum Jump:


Users browsing this thread: 3 Guest(s)