MYSQL EXIST
#5

IF NOT ACCOUNT EXIST

Quote:

new query[64+MAX_PLAYER_NAME];
mysql_format(handle, query, sizeof(query), "INSERT INTO `TEST` (nick, hodnost, LOG) VALUES ('%s', 0, 0)", Meno(playerid));
mysql_query(handle, query);

IF ACCOUNTE EXIST

Quote:

new query[64+MAX_PLAYER_NAME];
mysql_format(handle, query, sizeof(query), "UPDATE `ASystem` SET LOG=1 WHERE nick='%s'", Meno(playerid));
mysql_query(handle, query);
mysql_format(handle, query, sizeof(query), "SELECT * FROM `TEST` WHERE nick = '%s'", Meno(playerid));
mysql_query(handle, query);

Reply


Messages In This Thread
MYSQL EXIST - by itachi - 23.02.2017, 20:42
Re: MYSQL EXIST - by BiosMarcel - 23.02.2017, 20:43
Re: MYSQL EXIST - by itachi - 23.02.2017, 20:45
Re: MYSQL EXIST - by Djole1337 - 23.02.2017, 21:19
Re: MYSQL EXIST - by itachi - 23.02.2017, 21:29

Forum Jump:


Users browsing this thread: 1 Guest(s)