mysql nesaugoja

[Sn0p]

	if(dialogid == 1)
	{
	    if(response)
	    {
	        new query[200],playerName[ MAX_PLAYER_NAME ];
	        GetPlayerName(playerid,playerName,MAX_PLAYER_NAME);
	        format(query,200,"SELECT Vardas,Slaptazodis FROM players WHERE Vardas='%s' AND Slaptazodis='%s'",playerName,inputtext);
	        mysql_query(query);
	        mysql_store_result();
	        new rows = mysql_num_rows();
	        mysql_free_result();
	        if(rows == 1)
	        {
				SendClientMessage(playerid,-1,"Prisijungete!");
				playerDB[playerid][authstate]=2;
	        }
	        else
	        {
	            SendClientMessage(playerid,-1,"Slaptazodis neteisingas");
       		    Kick(playerid);
	        }
		}
		else if(!response)
		{
		    Kick(playerid);
		}
	    return 1;
	}
	if(dialogid == 0) // registracija
	{
	    if(response)
	    {
	        if(strlen(inputtext) < 3)
	        {
	            SendClientMessage(playerid,-1,"{cccccc}[ Serveris ] : {ff0000}Slaptazodis per trumpas. (min. 3 raides/skaiciai)");
            	ShowPlayerDialog(playerid,0,DIALOG_STYLE_INPUT,"GRP - Registracija","Noredami zaisti privalote uzregistruoti savo saskaita ivesdami slaptazodi apacioje:","Toliau","Iseiti");
	            return 1;
	        }
	        new query[200],playerName[ MAX_PLAYER_NAME ];
	        GetPlayerName(playerid,playerName,MAX_PLAYER_NAME);
	        format(query,200,"INSERT INTO players (Vardas,Slaptazodis) VALUES ('%s','%s')",playerName,inputtext);
			mysql_query(query);
			SendClientMessage(playerid,-1,"Jus uzregistruotas!");
			playerDB[playerid][authstate]=1;
		}
	    else if(!response)
	    {
	        Kick(playerid);
	    }
	    return 1;
	}

neissaugo po registracijos mysql nerandu klaidos niekur

public SavePlayerData(playerid,bool:simple)
{
    new Float:coo[3],weps[2][12];
	for (new tmp=0; tmp<12; tmp++) GetPlayerWeaponData(playerid,tmp,weps[0][tmp],weps[1][tmp]);
	GetPlayerPos(playerid,coo[0],coo[1],coo[2]);
	
	new query[500],playerName[MAX_PLAYER_NAME];
	GetPlayerName(playerid,playerName,MAX_PLAYER_NAME);
	
	format(query,500,"UPDATE players SET MoneyPocket='%i', MoneyBank='%i', MoneyHome='%i', Biznis='%i', Wanted='%i', Car='%i', LastSession='%i' WHERE Vardas='%s'",GetPlayerMoneyA(playerid),playerDB[playerid][banke],playerDB[playerid][namuose],playerDB[playerid][biznis],GetPlayerWantedLevel(playerid),playerDB[playerid][pcar],gSession,playerName);
	mysql_query(query);
	
	format(query,500,"UPDATE players SET Gang='%i', Islead='%i', Lead='%i', Kalejime='%i', Job='%i', Drabuziai='%i', Uniforma='%i', Uniformd='%i' WHERE Vardas='%s'",gplayerDB[playerid][pgang],gplayerDB[playerid][islead],playerDB[playerid][plead],playerDB[playerid][kalejimo_laikas],playerDB[playerid][specialybe],playerDB[playerid][drabuziai],playerDB[playerid][uniforma],playerDB[playerid][uniformd],playerName);
	mysql_query(query);
	
	format(query,500,"UPDATE players SET Ginklas0='%i', Ginklas1='%i', Ginklas2='%i', Ginklas3='%i', Ginklas4='%i', Ginklas5='%i', Ginklas6='%i', Ginklas7='%i' WHERE Vardas='%s'",weps[0][0],weps[0][1],weps[0][2],weps[0][3],weps[0][4],weps[0][5],weps[0][6],weps[0][7],playerName);
	mysql_query(query);
	
	format(query,500,"UPDATE players SET Ginklas8='%i', Ginklas9='%i', Ginklas10='%i', Ginklas11='%i' WHERE Vardas='%s'",weps[0][8],weps[0][9],weps[0][10],weps[0][11],playerName);
	mysql_query(query);
	
	format(query,500,"UPDATE players SET Ammo0='%i', Ammo1='%i', Ammo2='%i', Ammo3='%i', Ammo4='%i', Ammo5='%i', Ammo6='%i', Ammo7='%i' WHERE Vardas='%s'",weps[1][0],weps[1][1],weps[1][2],weps[1][3],weps[1][4],weps[1][5],weps[1][6],weps[1][7],playerName);
	mysql_query(query);
	
	format(query,500,"UPDATE players SET Ammo8='%i', Ammo9='%i', Ammo10='%i', Ammo11='%i' WHERE Vardas='%s'",weps[1][8],weps[1][9],weps[1][10],weps[1][11],playerName);
	mysql_query(query);
	
	format(query,500,"UPDATE players SET Xp='%i', Mobsas='%i', Pastatas='%i', Lytis='%i', pos_X='%f', pos_Y='%f', pos_Z='%f' WHERE Vardas='%s'",GetPlayerScore(playerid),playerDB[playerid][mobsas],playerDB[playerid][cbuilding],playerDB[playerid][lytis],coo[0],coo[1],coo[2],playerName);
	mysql_query(query);
	
	format(query,500,"UPDATE players SET Interior='%i', Drugs='%i', License='%i', World='%i', Insurance='%i' WHERE Vardas='%s'",GetPlayerInterior(playerid),playerDB[playerid][narkotikai],playerDB[playerid][teises],playerDB[playerid][draudimas],playerName);
	mysql_query(query);

 	playerDB[playerid][authstate]=4;
}

[bebras]

O MySQL Log?

[Sn0p]

[05:39:23] >> mysql_connect( )

 

[05:39:23] CMySQLHandler::CMySQLHandler() - constructor called.

 

[05:39:23] CMySQLHandler::CMySQLHandler() - Connecting to "127.0.0.1" | DB: "grp" | Username: "root" ...

 

[05:39:24] CMySQLHandler::Connect() - Can't connect to MySQL server on '127.0.0.1' (10061) (Error ID: 2003)

[sancio__]

[05:39:24] CMySQLHandler::Connect() - Can't connect to MySQL server on '127.0.0.1' (10061) (Error ID: 2003)

Kad šį eilutė viska parodo. Neprisijungia prie mySQL serverio. Prisijungimo duomeniai neteisingi reiškia.

[Sn0p]

tai va būtent kažkoks šūdas ir yra...