Use mysql for register/load
#15

Change the following:
Code:
pEmail,
to:
Code:
pEmail[64],
-------
Code:
PlayerInfo[playerid][pEmail]    = 0;
to:
Code:
PlayerInfo[playerid][pEmail]    = "";
-------
Code:
cache_get_value_name(0, "email", PlayerInfo[playerid][pEmail]);
to:
Code:
cache_get_value_name(0, "email", PlayerInfo[playerid][pEmail],64);
-------
Code:
new playeremail = PlayerInfo[playerid][pEmail];
to:
Code:
new playeremail[64];
format(playeremail, 64, PlayerInfo[playerid][pEmail]);
-------
Code:
mysql_format(handle, query, sizeof(query),
        "UPDATE users SET email = '%d', level = '%d', admin = '%d', money = '%d', kills = '%d', deaths = '%d' WHERE id = '%d'",
        playeremail, livello, adminl, soldi, uccisioni, morti, idgiocatore);
to:
Code:
mysql_format(handle, query, sizeof(query),
        "UPDATE users SET email = '%s', level = '%d', admin = '%d', money = '%d', kills = '%d', deaths = '%d' WHERE id = '%d'",
        playeremail, livello, adminl, soldi, uccisioni, morti, idgiocatore);
-------


And make sure that "email" is defined as VARCHAR with LENGTH 64 in MySQL Database.
Reply


Messages In This Thread
Use mysql for register/load - by OuDayas - 13.01.2019, 13:12
Re: Use mysql for register/load - by Jeffry - 13.01.2019, 13:20
Re: Use mysql for register/load - by OuDayas - 13.01.2019, 15:15
Re: Use mysql for register/load - by Jeffry - 13.01.2019, 15:55
Re: Use mysql for register/load - by OuDayas - 13.01.2019, 16:21
Re: Use mysql for register/load - by Jeffry - 13.01.2019, 17:51
Re: Use mysql for register/load - by OuDayas - 13.01.2019, 21:03
Re: Use mysql for register/load - by Jeffry - 14.01.2019, 19:52
Re: Use mysql for register/load - by codExpert - 14.01.2019, 20:40
Re: Use mysql for register/load - by OuDayas - 15.01.2019, 11:08
Re: Use mysql for register/load - by Jeffry - 15.01.2019, 18:15
Re: Use mysql for register/load - by OuDayas - 16.01.2019, 00:55
Re: Use mysql for register/load - by Jeffry - 16.01.2019, 16:54
Re: Use mysql for register/load - by OuDayas - 17.01.2019, 21:35
Re: Use mysql for register/load - by Jeffry - 19.01.2019, 11:37
Re: Use mysql for register/load - by OuDayas - 19.01.2019, 18:43
Re: Use mysql for register/load - by Stefhan - 20.01.2019, 02:28
Re: Use mysql for register/load - by Jeffry - 20.01.2019, 09:41
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 12:35
Re: Use mysql for register/load - by Jeffry - 20.01.2019, 13:37
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 14:35
Re: Use mysql for register/load - by Jeffry - 20.01.2019, 15:29
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 16:07
Re: Use mysql for register/load - by Jeffry - 20.01.2019, 16:15
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 19:27
Re: Use mysql for register/load - by SymonClash - 20.01.2019, 20:23
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 20:39
Re: Use mysql for register/load - by SymonClash - 20.01.2019, 20:45
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 20:55
Re: Use mysql for register/load - by SymonClash - 20.01.2019, 21:07
Re: Use mysql for register/load - by OuDayas - 20.01.2019, 21:47
Re: Use mysql for register/load - by SymonClash - 20.01.2019, 22:11
Re: Use mysql for register/load - by SymonClash - 21.01.2019, 09:30
Re: Use mysql for register/load - by OuDayas - 21.01.2019, 22:58

Forum Jump:


Users browsing this thread: 2 Guest(s)