Use mysql for register/load
#16

Don't work, if i set " PlayerInfo[playerid][pEmail] = 0; " To: " PlayerInfo[playerid][pEmail] = ""; "pawno give me that error
Code:
C:\Users\ouday\OneDrive\Desktop\Giochi\samp\samp rp\samp03DL_svr_R1_win32\gamemodes\gamemoderp.pwn(239) : error 047: array sizes do not match, or destination array is too small
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


1 Error.
but if i turn set " PlayerInfo[playerid][pEmail] = 0; " work... but

in the registration part, set in the db name and password to "NULL" and the email is ok, but when the player left the server, set the email like name and the psw, and i have in the db
name= "NULL"
password= "NULL"
email= ""
I don't know what i should to do for fix
take a look: https://pastebin.com/zvF2GkMB
Quote:
Originally Posted by Jeffry
View Post
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: 1 Guest(s)