Problema user nou

[Jimmi]

Problema intalnita (descriere):Am trecut gm pe r39-3 si acuma cand intru pe server sa imi fac cont nou imi bag parola apas register si imi zice ca acest nume e deja folosit....desi baza de date e goala...
Ero(area / rile) / warning-(ul / urile):
Liniile de cod / sursa / script-ul(obligatoriu):

[13:50:06] [DEBUG] mysql_tquery - connection: 1, query: "", callback: "(null)", format: "(null)"
[13:50:06] [DEBUG] mysql_tquery - connection: 1, query: "", callback: "(null)", format: "(null)"
[13:50:06] [DEBUG] mysql_format - connection: 1, len: 100, format: "SELECT * FROM `players` WHERE `username`='%e';"
[13:50:06] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `players` WHERE `username`='Jimmi';", callback: "OnLoadPlayer", format: "i"
[13:50:06] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[13:50:06] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty
[13:50:06] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[13:50:06] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[13:50:06] [ERROR] CMySQLQuery::Execute[] - (error #1065) Query was empty
[13:50:06] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[13:50:06] [DEBUG] CMySQLQuery::Execute[OnLoadPlayer] - starting query execution
[13:50:06] [DEBUG] CMySQLQuery::Execute[OnLoadPlayer] - query was successfully executed within 35.160 milliseconds
[13:50:06] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[13:50:06] [DEBUG] Calling callback "OnLoadPlayer"..
[13:50:06] [DEBUG] cache_get_row_count - connection: 1
[13:50:06] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[13:50:14] [DEBUG] mysql_format - connection: 1, len: 256, format: " SELECT `id` from `players` WHERE `username` = '%e' LIMIT 1;"
[13:50:14] [DEBUG] mysql_query - connection: 1, query: " SELECT `id` from `players` WHERE `username` = 'Jimmi' LIMIT 1;", use_cache: true
[13:50:14] [DEBUG] CMySQLQuery::Execute - starting query execution
[13:50:14] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 11.751 milliseconds
[13:50:14] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[13:50:14] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 51)
[13:50:14] [DEBUG] cache_get_row_count - connection: 1
[13:50:14] [DEBUG] cache_delete - cache_id: 51, connection: 1
[13:50:14] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[13:50:14] [DEBUG] CMySQLHandle::DeleteSavedResult - result deleted
 

forward MySQLCheckAccount(sqlplayersname[]);
public MySQLCheckAccount(sqlplayersname[])
{
	new query[ 256 ];
	mysql_format( handle, query, sizeof( query ), " SELECT `id` from `players` WHERE `username` = '%e' LIMIT 1;", sqlplayersname );
	new Cache:r = mysql_query( handle, query );
	if( !cache_num_rows() ) return 0,cache_delete( r );
	else
	{
		return cache_get_field_content_int( 0, "id" ),cache_delete( r );
	}
}

si

if(dialogid == 12345)
	{
	    if(IsPlayerConnected(playerid))
	    {
			if(!response)
            {
                SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Info: {FFFFFF}Ai fost dat afara pentru ca nu ai acceptat inregistrarea.");
                Kick(playerid);
                return 1;
            }
		    if(strlen(inputtext) >= 4 && strlen(inputtext) <= 70)
		    {
				GetPlayerName(playerid, sendername, sizeof(sendername));
				new sqlaccountexists = MySQLCheckAccount(sendername);
				if (sqlaccountexists != 0)
				{
				    SendClientMessage(playerid, COLOR_WHITE, " ");
				    SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Info: {FFFFFF}Acel nume este deja folosit, alege altul.");
					return 1;
				}
				new tmppass[64];
    			mysql_real_escape_string(inputtext, tmppass);
       			if(strlen(tmppass) < 4)
     		    {
     		        new loginname[64];
					GetPlayerName(playerid,loginname,sizeof(loginname));
					ShowPlayerDialog(playerid,12347,DIALOG_STYLE_PASSWORD,"{FFFFFF}Logare","{FFFFFF}Scrie {0066FF}parola contului tau {FFFFFF}mai jos:","Logare","Iesi");
					gPlayerLogTries[playerid] += 1;
					if(gPlayerLogTries[playerid] == 5) { Kick(playerid); }
				}
				OnPlayerRegister(playerid,tmppass);
			}
			else
			{
				new regname[64];
				GetPlayerName(playerid,regname,sizeof(regname));
				ShowPlayerDialog(playerid,12347,DIALOG_STYLE_PASSWORD,"{FFFFFF}Inregistrare","{FFFFFF}Scrie {0066FF}parola contului tau {FFFFFF}mai jos:","Inregistrare","Iesi");
			}
		}
	}

Imagini / Video (optional):

http://imgur.com/IMTSEMpimi sciu parola, si nu ma da afara doar ca nu ma baga pe server(sa fac tutorialul etc...)http://imgur.com/waMxCfP

Ati incercat sa rezolvati singur?:Da, dar nu stiu cum....

[Jimmi]

upp

[WiDuAlK]

foloseste:

new name[MAX_PLAYER_NAME+1];
GetPlayerName(playerid,name,sizeof(name));

si in loc de

sqlplayersname

pune name.

[Jimmi]

TC