mysql skin
#1

help me, sometimes the script dosent load player skin
loading script:

Код:
stock Uzkraunam(playerid)
    {
       new Query[65];
    if(!IsPlayerConnected(playerid)) return 1;
    format(Query, sizeof(Query), "SELECT * FROM `Vartotojai` WHERE `Vardas` = '%s'", GetPlayerNameEx( playerid ));
    mysql_query(Query); mysql_store_result();
 
    mysql_fetch_field_row(Query, "Pinigai");        GivePlayerMoney(playerid, strval(Query));
    mysql_fetch_field_row(Query, "Patirtis");       SetPlayerScore(playerid, strval(Query));
    mysql_fetch_field_row(Query, "Lytis");          playerDB[playerid][lytis] = strval(Query);
    mysql_fetch_field_row(Query, "Drabuziai");      playerDB[playerid][drabuziai] = strval(Query);
    mysql_fetch_field_row(Query, "Uniforma");       playerDB[playerid][uniforma] = strval(Query);
    mysql_fetch_field_row(Query, "Darbas");         playerDB[playerid][specialybe] = strval(Query);
    mysql_fetch_field_row(Query, "Namuose");        playerDB[playerid][namuose] = strval(Query);
    mysql_fetch_field_row(Query, "Biznis");         playerDB[playerid][biznis] = strval(Query);
    mysql_fetch_field_row(Query, "Namas");          playerDB[playerid][namukas] = strval(Query);
    mysql_fetch_field_row(Query, "Ieskomumas");     SetPlayerWantedLevel(playerid, strval(Query));
    mysql_fetch_field_row(Query, "Masina");         playerDB[playerid][pcar] = strval(Query);
    mysql_fetch_field_row(Query, "Lockas");         UzrakintosM[playerid] = strval(Query);
    mysql_fetch_field_row(Query, "Lockas2");        AtrakintosM[playerid] = strval(Query);
    mysql_fetch_field_row(Query, "Direktorius");    playerDB[playerid][plead] = strval(Query);
    mysql_fetch_field_row(Query, "Pavaduotojas");   playerDB[playerid][dyrpavaduotojas] = strval(Query);
    mysql_fetch_field_row(Query, "Vadas");  	    playerDB[playerid][flead] = strval(Query);
    mysql_fetch_field_row(Query, "Kalejime");       playerDB[playerid][kalejimo_laikas] = strval(Query);
    mysql_fetch_field_row(Query, "Papildimas");     playerDB[playerid][papildimas] = strval(Query);
    mysql_fetch_field_row(Query, "Telefonostat");   playerDB[playerid][telefonostat] = strval(Query);
    mysql_fetch_field_row(Query, "Telefonas");      playerDB[playerid][telefonas] = strval(Query);
    mysql_fetch_field_row(Query, "Galimybe");       playerDB[playerid][galimybe] = strval(Query);
    mysql_fetch_field_row(Query, "Misija");         playerDB[playerid][misija] = strval(Query);
    mysql_fetch_field_row(Query, "Misija2");        playerDB[playerid][misija2] = strval(Query);
    mysql_fetch_field_row(Query, "Misija3");        playerDB[playerid][misija3] = strval(Query);
    mysql_fetch_field_row(Query, "Misija4");        playerDB[playerid][misija4] = strval(Query);
    mysql_fetch_field_row(Query, "Misija5");        playerDB[playerid][misija5] = strval(Query);
    mysql_fetch_field_row(Query, "Misija6");        playerDB[playerid][misija6] = strval(Query);
    mysql_fetch_field_row(Query, "Misija7");        playerDB[playerid][misija7] = strval(Query);
    mysql_fetch_field_row(Query, "Misija8");        playerDB[playerid][misija8] = strval(Query);
    mysql_fetch_field_row(Query, "Misija9");        playerDB[playerid][misija9] = strval(Query);
    mysql_fetch_field_row(Query, "Misija10");       playerDB[playerid][misija10] = strval(Query);
    mysql_fetch_field_row(Query, "NoriRukyti");     playerDB[playerid][NoriRukyti] = strval(Query);
    mysql_fetch_field_row(Query, "Mobsas");         playerDB[playerid][mobsas] = strval(Query);
    mysql_fetch_field_row(Query, "Alga");           playerDB[playerid][alga] = strval(Query);
    mysql_fetch_field_row(Query, "Praleista");      playerDB[playerid][praleista] = strval(Query);
    mysql_fetch_field_row(Query, "Pakelis");        playerDB[playerid][pakelis] = strval(Query);
    mysql_fetch_field_row(Query, "Kpakelis");       playerDB[playerid][kpakelis] = strval(Query);
    mysql_fetch_field_row(Query, "Cigaretes");      playerDB[playerid][cigaretes] = strval(Query);
    mysql_fetch_field_row(Query, "Rasti");          playerDB[playerid][rasti] = strval(Query);
    mysql_fetch_field_row(Query, "Rasti1");         playerDB[playerid][rasti1] = strval(Query);
    mysql_fetch_field_row(Query, "Rasti2");         playerDB[playerid][rasti2] = strval(Query);
    mysql_fetch_field_row(Query, "Rasti3");         playerDB[playerid][rasti3] = strval(Query);
    mysql_fetch_field_row(Query, "Rasti4");         playerDB[playerid][rasti4] = strval(Query);
    mysql_fetch_field_row(Query, "Rasti5");         playerDB[playerid][rasti5] = strval(Query);
    mysql_fetch_field_row(Query, "Rasti6");         playerDB[playerid][rasti6] = strval(Query);
    mysql_fetch_field_row(Query, "Rasti7");         playerDB[playerid][rasti7] = strval(Query);
    mysql_fetch_field_row(Query, "Rasti8");         playerDB[playerid][rasti8] = strval(Query);
    mysql_fetch_field_row(Query, "Rasti9");         playerDB[playerid][rasti9] = strval(Query);
    mysql_fetch_field_row(Query, "Faction");        playerDB[playerid][frakcija] = strval(Query);
    mysql_fetch_field_row(Query, "Pastatas");       playerDB[playerid][cbuilding] = strval(Query);
    mysql_fetch_field_row(Query, "Interior");       SetPlayerInterior(playerid, strval(Query));
    mysql_fetch_field_row(Query, "World");          SetPlayerVirtualWorld(playerid, strval(Query));
    mysql_fetch_field_row(Query, "Ispejimai");      playerDB[playerid][ispejimai] = strval(Query);
    mysql_fetch_field_row(Query, "VipIspejimai");   playerDB[playerid][vispejimai] = strval(Query);
    mysql_fetch_field_row(Query, "AdminIspejimai"); playerDB[playerid][aispejimai] = strval(Query);
    mysql_fetch_field_row(Query, "Seklos");         playerDB[playerid][seklos] = strval(Query);
    mysql_fetch_field_row(Query, "Zole");           playerDB[playerid][zole] = strval(Query);
    mysql_fetch_field_row(Query, "Banke");          playerDB[playerid][banke] = strval(Query);
    mysql_fetch_field_row(Query, "Narkotikai");     playerDB[playerid][narkotikai] = strval(Query);

    GivePlayerWeapon(playerid,mysql_fetch_field_row(Query,"Ginklas0"),mysql_fetch_field_row(Query,"Ammo0"));
	GivePlayerWeapon(playerid,mysql_fetch_field_row(Query,"Ginklas1"),mysql_fetch_field_row(Query,"Ammo1"));
	GivePlayerWeapon(playerid,mysql_fetch_field_row(Query,"Ginklas2"),mysql_fetch_field_row(Query,"Ammo2"));
	GivePlayerWeapon(playerid,mysql_fetch_field_row(Query,"Ginklas3"),mysql_fetch_field_row(Query,"Ammo3"));
	GivePlayerWeapon(playerid,mysql_fetch_field_row(Query,"Ginklas4"),mysql_fetch_field_row(Query,"Ammo4"));
	GivePlayerWeapon(playerid,mysql_fetch_field_row(Query,"Ginklas5"),mysql_fetch_field_row(Query,"Ammo5"));
	GivePlayerWeapon(playerid,mysql_fetch_field_row(Query,"Ginklas6"),mysql_fetch_field_row(Query,"Ammo6"));
	GivePlayerWeapon(playerid,mysql_fetch_field_row(Query,"Ginklas7"),mysql_fetch_field_row(Query,"Ammo7"));
	GivePlayerWeapon(playerid,mysql_fetch_field_row(Query,"Ginklas8"),mysql_fetch_field_row(Query,"Ammo8"));
	GivePlayerWeapon(playerid,mysql_fetch_field_row(Query,"Ginklas9"),mysql_fetch_field_row(Query,"Ammo9"));
	GivePlayerWeapon(playerid,mysql_fetch_field_row(Query,"Ginklas10"),mysql_fetch_field_row(Query,"Ammo10"));
	GivePlayerWeapon(playerid,mysql_fetch_field_row(Query,"Ginklas11"),mysql_fetch_field_row(Query,"Ammo11"));

	//Boolean's
	mysql_fetch_field_row(Query,"Admin");
    if(strval(Query)) playerDB[playerid][admin] = true;
    
    mysql_fetch_field_row(Query,"Vip");
    if(strval(Query)) playerDB[playerid][vip] = true;
    
    mysql_fetch_field_row(Query,"Savininkas");
    if(strval(Query)) playerDB[playerid][savininkas] = true;
	
	mysql_fetch_field_row(Query,"Teorija");
    if(strval(Query)) playerDB[playerid][teorija] = true;
	
	mysql_fetch_field_row(Query,"Uniformd");
    if(strval(Query)) playerDB[playerid][uniformd] = true;

	mysql_fetch_field_row(Query,"Uztildo");
    if(strval(Query)) playerDB[playerid][uztildo] = true;

	mysql_fetch_field_row(Query,"Aikstele");
    if(strval(Query)) playerDB[playerid][aikstele] = true;
    
	mysql_fetch_field_row(Query,"Teises");
    if(strval(Query)) playerDB[playerid][teises] = true;
    
     playerDB[playerid][pinigai] = GetPlayerMoney(playerid);
     
    if(playerDB[playerid][naujokas]) return 1;
		new Float:pos[5];
		new fetch[256];
 mysql_fetch_field_row(fetch,"X");
 pos[0] = floatstr(fetch);
 mysql_fetch_field_row(fetch,"Y");
 pos[1] = floatstr(fetch);
 mysql_fetch_field_row(fetch,"Z");
 pos[2] = floatstr(fetch);
 SetSpawnInfo(playerid,GetPlayerTeam(playerid),playerDB[playerid][drabuziai],pos[0], pos[1], pos[2],0,0,0,0,0,0,0);
 SpawnPlayer(playerid);
    mysql_free_result();
    
    if(playerDB[playerid][uniformd])
	    SetPlayerSkin(playerid,playerDB[playerid][uniforma]);
	    else
	    SetPlayerSkin(playerid,playerDB[playerid][drabuziai]);
    return 1;
    }
Reply
#2

sorry for DP but can someone help me?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)