Contul nu se salveaza

[Tarzanus]

Problema intalnita (descriere): Pai, nu se salveaza cont-ul.
Ero(area / rile) / warning-(ul / urile): -
Liniile de cod / sursa / script-ul(obligatoriu): 

	if(dialogid == R_DIALOG)
	{
	    if(!response) return Kick(playerid);
	    szQuery[0] = EOS;
	    if(strlen(inputtext) < 3)
	    {
	        format(szQuery, 128, "{00FF00}Parola trebuie sa contina {FF0000}minim 3 caractere{00FF00}.", GetName(playerid));
			ShowPlayerDialog(playerid, R_DIALOG, DIALOG_STYLE_PASSWORD, "Inregistrare", szQuery, "Inregistrare", "Exit");
		}
		WP_Hash(PaccInfo[playerid][Password], 129, inputtext);
		mysql_format(Handle, szQuery, 512, "INSERT INTO `users` (`Name`, `Password`, `IP`, `Money`, `Level`, `VIP`, `Kills`, `Deaths`, `Hours`, `Mins`, `Secs`) VALUES ('%e', '%e', '%e', 0, 0, 0, 0, 0, 0, 0, 0)", GetName(playerid), PaccInfo[playerid][Password], GetIP(playerid));
		mysql_tquery(Handle, szQuery, "OnPlayerRegister", "d", playerid);
	    return 1;
	}

forward OnPlayerRegister(playerid);
public OnPlayerRegister(playerid)
{
	szQuery[0] = EOS;
	PaccInfo[playerid][ID] = cache_insert_id();
	format(szQuery, 128, "{00FF00}Salut {FF0000}%s{00FF00}, ai fost inregistrat cu succes.n{FFFFFF}Parola: {00FF00}%s", GetName(playerid), PaccInfo[playerid][Password]);
	ShowPlayerDialog(playerid, L_DIALOGs, DIALOG_STYLE_MSGBOX, "Inregistrare", szQuery, "Ok", "");
	PaccInfo[playerid][LGIN] = 1;
	return 1;
} 

Imagini / Video (optional): http://imgur.com/0N6X9G0,5477LAm#0
Ati incercat sa rezolvati singur?: Pai, am incercat sa fac altfel sistem-ul, si tot asa face..

[Tarzanus]

SOLVED , T/C.

Edited March 11, 2015 by Tarzanus

[#Teddy]

Verifica daca conexiunea la baza de date a avut succes, sau nu..accesand mysql log.

[Tarzanus]

Am verificat tot.

[#Teddy]

Incearca sa inlocuiesti asta:

if(dialogid == R_DIALOG)
    {
     if(!response) return Kick(playerid);
     szQuery[0] = EOS;
     if(strlen(inputtext) < 3)
     {
     format(szQuery, 128, "{00FF00}Parola trebuie sa contina {FF0000}minim 3 caractere{00FF00}.", GetName(playerid));
            ShowPlayerDialog(playerid, R_DIALOG, DIALOG_STYLE_PASSWORD, "Inregistrare", szQuery, "Inregistrare", "Exit");
        }
        WP_Hash(PaccInfo[playerid][Password], 129, inputtext);
        mysql_format(Handle, szQuery, 512, "INSERT INTO `users` (`Name`, `Password`, `IP`, `Money`, `Level`, `VIP`, `Kills`, `Deaths`, `Hours`, `Mins`, `Secs`) VALUES ('%e', '%e', '%e', 0, 0, 0, 0, 0, 0, 0, 0)", GetName(playerid), PaccInfo[playerid][Password], GetIP(playerid));
        mysql_tquery(Handle, szQuery, "OnPlayerRegister", "d", playerid);
     return 1;
    }

 

Cu:

 

if(dialogid == R_DIALOG)
    {
     if(!response) return Kick(playerid);
     szQuery[0] = EOS;
     if(strlen(inputtext) < 3)
     {
     format(szQuery, 128, "{00FF00}Parola trebuie sa contina {FF0000}minim 3 caractere{00FF00}.", GetName(playerid));
            ShowPlayerDialog(playerid, R_DIALOG, DIALOG_STYLE_PASSWORD, "Inregistrare", szQuery, "Inregistrare", "Exit");
        }
        WP_Hash(PaccInfo[playerid][Password], 129, inputtext);
        mysql_format(Handle, szQuery, 512, "INSERT INTO `users` (`Name`, `Password`, `IP`, `Money`, `Level`, `VIP`, `Kills`, `Deaths`, `Hours`, `Mins`, `Secs`) VALUES ('%s', '%s', '%s', 0, 0, 0, 0, 0, 0, 0, 0)", GetName(playerid), PaccInfo[playerid][Password], GetIP(playerid));
        mysql_tquery(Handle, szQuery, "OnPlayerRegister", "d", playerid);
     return 1;
    }

[Tarzanus]

La fel....

[kwnx]

La fel....

Sigur se conecteaza serverul cu baza de date?

[Mafia.]

Arata server.log

Edited March 10, 2015 by Mafia.

[Tarzanus]

----------

Loaded log file: "server_log.txt".

----------

 

SA-MP Dedicated Server

----------------------

v0.3z, ©2005-2014 SA-MP Team

 

[08:05:14] filterscripts = ""  (string)

[08:05:14] 

[08:05:14] Server Plugins

[08:05:14] --------------

[08:05:14]  Loading plugin: mysql

[08:05:14]  >> plugin.mysql: R38 successfully loaded.

[08:05:14]   Loaded.

[08:05:14]  Loading plugin: streamer

[08:05:14] 

 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

 

[08:05:14]   Loaded.

[08:05:14]  Loading plugin: sscanf

[08:05:14] 

 

[08:05:14]  ===============================

 

[08:05:14]       sscanf plugin loaded.     

 

[08:05:14]    © 2009 Alex "Y_Less" Cole

 

[08:05:14]    0.3d-R2 500 Players "dnee"

 

[08:05:14]  ===============================

 

[08:05:14]   Loaded.

[08:05:14]  Loading plugin: Whirlpool

[08:05:14]  

[08:05:14]  ==================

[08:05:14]  

[08:05:14]   Whirlpool loaded

[08:05:14]  

[08:05:14]  ==================

[08:05:14]  

[08:05:14]   Loaded.

[08:05:14]  Loading plugin: nativechecker

[08:05:14]   Loaded.

[08:05:14]  Loaded 5 plugins.

 

[08:05:14] 

[08:05:14] Filterscripts

[08:05:14] ---------------

[08:05:14]   Loaded 0 filterscripts.

 

[08:05:14] [MySQL]: Conectarea cu baza de date 'salam' a fost realizata.

[08:05:14] 

----------------------------------

[08:05:14]   Generation of Stunt v1

 

[08:05:14] ----------------------------------

 

[08:05:14] Number of vehicle models: 0

[08:05:35] Incoming connection: 127.0.0.1:55179

[08:05:35] [join] TestAccount2 has joined the server (0:127.0.0.1)

[08:05:42] [part] TestAccount2 has left the server (0:1)

[08:06:04] Incoming connection: 127.0.0.1:55180

[08:06:04] [join] TestAccount2 has joined the server (0:127.0.0.1)

[08:06:11] [part] TestAccount2 has left the server (0:2)

 

Cred ca poate fi de la asta, nu stiu   :

forward OnPlayerRegister(playerid);
public OnPlayerRegister(playerid)
{
	szQuery[0] = EOS;
	PaccInfo[playerid][ID] = cache_insert_id();
	format(szQuery, 128, "{00FF00}Salut {FF0000}%s{00FF00}, ai fost inregistrat cu succes.n{FFFFFF}Parola: {00FF00}%s", GetName(playerid), PaccInfo[playerid][Password]);
	ShowPlayerDialog(playerid, L_DIALOGs, DIALOG_STYLE_MSGBOX, "Inregistrare", szQuery, "Ok", "");
	PaccInfo[playerid][LGIN] = 1;
	return 1;
}

Edited March 10, 2015 by Tarzanus