1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Server Crash
Sreadon
Big Clucker
***
Posts: 90
Threads: 26
Joined: Feb 2011
Reputation: 0
#1

02.12.2011, 20:30
Hello,

My server crash because of this function, I'm a newbie in SQL, so if someone can tell me why it crash.. Thanks..

pawn Код:
new query[200], pname[24], savingstring[30];
    GetPlayerName(playerid, pname, sizeof(pname));
    format(query, sizeof(query), "SELECT * FROM utilisateurs WHERE Pseudo = '%s'", pname);
    GetPlayerName(playerid, pname, 24);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
        {
            printf("Checked MySQL Fetch PlayerConnect");
            mysql_fetch_field_row(savingstring,"PSQL"); PlayerSQL[playerid] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Email"); PlayerInfo[playerid][pEmail] = strval(savingstring);
            printf("PSQL DU JOUEUR: %d", PlayerSQL[playerid]);
        }
    mysql_free_result();
    // Fin de la requкte SQL.
    
    printf("Le MySQL Checked a йtй effectuй");
    if(fexist(string) && PlayerSQL[playerid] == 0)
    {
        gPlayerAccount[playerid] = 1;
        iniconnect[playerid] = 1;
        printf("Le fichier existe!");
        //LOGINSYS(playerid);
    }
    else
    {
        iniconnect[playerid] = 0;
        GetPlayerName(playerid, pname, 24);
        format(query, sizeof(query), "SELECT * FROM `utilisateurs` WHERE Pseudo = '%s'", pname);
        mysql_query(query);
        mysql_store_result();
        new rows = mysql_num_rows();
        if(!rows) // Le compte n'existe pas.., on le redirige vers le dialog d'enregistrement
            {
                gPlayerAccount[playerid] = 0;
                SendClientMessage(playerid, COLOR_GREEN, "Compte non dйtectй, initialisation de l'enregistrement");
            }
        else // Le compte existe obligatoirement.., on le redirige vers le dialog de login
            {
                gPlayerAccount[playerid] = 1;
                SendClientMessage(playerid, COLOR_GREEN, "Compte dйtectй, initialisation la connexion");
            }
    }
Find
Reply
Sreadon
Big Clucker
***
Posts: 90
Threads: 26
Joined: Feb 2011
Reputation: 0
#2

03.12.2011, 13:49
Sorry for the "UP", I've solved the first problem, but now with this, the server crash too.. I think it comes from mysql_fetch_row_format(query,"|") but don't know why, it work on Windows 7, but not on Debian 5.


pawn Код:
stock MySQL_Login(playerid)
{
    printf("MySQL_Login Appelйe!");
    new query[2000], pname[24], savingstring[200];
    GetPlayerName(playerid, pname, sizeof(pname));

    format(query, sizeof(query), "SELECT * FROM utilisateurs WHERE Pseudo = '%s'", pname);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
        {
            //printf("Checked MySQL Fetch");
            mysql_fetch_field_row(savingstring,"Level");         PlayerInfo[playerid][pLevel] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"AdminLevel");    PlayerInfo[playerid][pAdmin] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"DonateRank");    PlayerInfo[playerid][pDonateRank] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"UpgradePoints"); PlayerInfo[playerid][gPupgrade] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"ConnectedTime"); PlayerInfo[playerid][pConnectTime] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Registered");    PlayerInfo[playerid][pReg] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Sex");           PlayerInfo[playerid][pSex] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Age");           PlayerInfo[playerid][pAge] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Origin");        PlayerInfo[playerid][pOrigin] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"CK");            PlayerInfo[playerid][pCK] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Muted");         PlayerInfo[playerid][pMuted] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"MutedOOC");      PlayerInfo[playerid][pMutedOOC] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Respect");       PlayerInfo[playerid][pExp] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Money");         PlayerInfo[playerid][pCash] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Bank");          PlayerInfo[playerid][pAccount] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Crimes");        PlayerInfo[playerid][pCrimes] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Kills");         PlayerInfo[playerid][pKills] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Deaths");        PlayerInfo[playerid][pDeaths] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Arrested");      PlayerInfo[playerid][pArrested] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"WantedDeaths");  PlayerInfo[playerid][pWantedDeaths] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Phonebook");     PlayerInfo[playerid][pPhoneBook] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"LottoNr");       PlayerInfo[playerid][pLottoNr] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Fishes");        PlayerInfo[playerid][pFishes] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"BiggestFish");   PlayerInfo[playerid][pBiggestFish] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Job");           PlayerInfo[playerid][pJob] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"PayCheck");      PlayerInfo[playerid][pPayCheck] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"HeadValue");     PlayerInfo[playerid][pHeadValue] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Jailed");        PlayerInfo[playerid][pJailed] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"JailTime");      PlayerInfo[playerid][pJailTime] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Materials");     PlayerInfo[playerid][pMats] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Materialsf");    PlayerInfo[playerid][pMatsf] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Drugs");         PlayerInfo[playerid][pDrugs] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Leader");        PlayerInfo[playerid][pLeader] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Member");        PlayerInfo[playerid][pMember] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"FMember");       PlayerInfo[playerid][pFMember] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Rank");          PlayerInfo[playerid][pRank] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Char");          PlayerInfo[playerid][pChar] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"ContractTime");  PlayerInfo[playerid][pContractTime] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"DetSkill");      PlayerInfo[playerid][pDetSkill] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"SexSkill");      PlayerInfo[playerid][pSexSkill] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"BoxSkill");      PlayerInfo[playerid][pBoxSkill] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"LawSkill");      PlayerInfo[playerid][pLawSkill] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"MechSkill");     PlayerInfo[playerid][pMechSkill] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"JackSkill");     PlayerInfo[playerid][pJackSkill] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"CarSkill");      PlayerInfo[playerid][pCarSkill] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"NewsSkill");     PlayerInfo[playerid][pNewsSkill] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"DrugsSkill");    PlayerInfo[playerid][pDrugsSkill] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"CookSkill");     PlayerInfo[playerid][pCookSkill] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"FishSkill");     PlayerInfo[playerid][pFishSkill] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"pSHealth");      PlayerInfo[playerid][pSHealth] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"pHealth");       PlayerInfo[playerid][pHealth] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Int");           PlayerInfo[playerid][pInt] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Local");         PlayerInfo[playerid][pLocal] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Team");          PlayerInfo[playerid][pTeam] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Model");         PlayerInfo[playerid][pModel] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"PhoneNr");       PlayerInfo[playerid][pPnumber] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Car");           PlayerInfo[playerid][pPcarkey] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Car2");          PlayerInfo[playerid][pPcarkey2] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Car3");          PlayerInfo[playerid][pPcarkey3] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"House");         PlayerInfo[playerid][pPhousekey] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Bizz");          PlayerInfo[playerid][pPbiskey] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Pos_x");         PlayerInfo[playerid][pPos_x] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Pos_y");         PlayerInfo[playerid][pPos_y] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Pos_z");         PlayerInfo[playerid][pPos_z] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"CarLic");        PlayerInfo[playerid][pCarLic] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"FlyLic"); PlayerInfo[playerid][pFlyLic] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"FlyLicf"); PlayerInfo[playerid][pFlyLicf] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Skinf"); PlayerInfo[playerid][pskinf] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Skinfm"); PlayerInfo[playerid][pskinfm] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"FlyLict"); PlayerInfo[playerid][pFlyLict] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"BoatLic"); PlayerInfo[playerid][pBoatLic] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"BoatLicf"); PlayerInfo[playerid][pBoatLicf] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"FishLic"); PlayerInfo[playerid][pFishLic] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"FishLict"); PlayerInfo[playerid][pFishLict] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"FishLicf"); PlayerInfo[playerid][pFishLicf] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"LourdLic"); PlayerInfo[playerid][pLourdLic] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"LourdLict"); PlayerInfo[playerid][pLourdLict] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"LourdLicf"); PlayerInfo[playerid][pLourdLicf] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"MotoLic"); PlayerInfo[playerid][pMotoLic] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"MotoLict"); PlayerInfo[playerid][pMotoLict] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"MotoLicf"); PlayerInfo[playerid][pMotoLicf] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"GunLic"); PlayerInfo[playerid][pGunLic] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"GunLicf"); PlayerInfo[playerid][pGunLicf] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"GunLict"); PlayerInfo[playerid][pGunLict] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Gun1"); PlayerInfo[playerid][pGun1] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Gun2"); PlayerInfo[playerid][pGun2] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Gun3"); PlayerInfo[playerid][pGun3] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Gun4"); PlayerInfo[playerid][pGun4] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Ammo1"); PlayerInfo[playerid][pAmmo1] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Ammo2"); PlayerInfo[playerid][pAmmo2] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Ammo3"); PlayerInfo[playerid][pAmmo3] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Ammo4"); PlayerInfo[playerid][pAmmo4] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"CarTime"); PlayerInfo[playerid][pCarTime] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Payday"); PlayerInfo[playerid][pPayDay] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"PayDayHad"); PlayerInfo[playerid][pPayDayHad] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Watch"); PlayerInfo[playerid][pWatch] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"GPS"); PlayerInfo[playerid][pGPS] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Tante"); PlayerInfo[playerid][pTante] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Decodeur"); PlayerInfo[playerid][pDecodeur] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Crashed"); PlayerInfo[playerid][pCrashed] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Wins"); PlayerInfo[playerid][pWins] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Loses"); PlayerInfo[playerid][pLoses] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"AlcoholPerk"); PlayerInfo[playerid][pAlcoholPerk] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"DrugPerk"); PlayerInfo[playerid][pDrugPerk] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"MiserPerk"); PlayerInfo[playerid][pMiserPerk] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"PainPerk"); PlayerInfo[playerid][pPainPerk] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"TraderPerk"); PlayerInfo[playerid][pTraderPerk] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Tutorial");       PlayerInfo[playerid][pTut] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Robbank"); PlayerInfo[playerid][probbank] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Hotel"); PlayerInfo[playerid][pHotel] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"fpermis"); PlayerInfo[playerid][pfpermis] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"PointPermis"); PlayerInfo[playerid][pPointPermis] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Mission"); PlayerInfo[playerid][pMissionNr] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Warnings"); PlayerInfo[playerid][pWarnings] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"VirWorld"); PlayerInfo[playerid][pVirWorld] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Fuel"); PlayerInfo[playerid][pFuel] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Married"); PlayerInfo[playerid][pMarried] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"MarriedTo"); PlayerInfo[playerid][pMarriedTo] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"FishTool"); PlayerInfo[playerid][pFishTool] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Note1"); PlayerInfo[playerid][pNote1] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Note1s"); PlayerInfo[playerid][pNote1s] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Note2"); PlayerInfo[playerid][pNote2] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Note2s"); PlayerInfo[playerid][pNote2s] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Note3"); PlayerInfo[playerid][pNote3] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Note3s"); PlayerInfo[playerid][pNote3s] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Note4"); PlayerInfo[playerid][pNote4] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Note4s"); PlayerInfo[playerid][pNote4s] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Note5"); PlayerInfo[playerid][pNote5] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Note5s"); PlayerInfo[playerid][pNote5s] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"InvAmmo"); PlayerInfo[playerid][pInvAmmo] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Lighter"); PlayerInfo[playerid][pLighter] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Cigarettes"); PlayerInfo[playerid][pCigarettes] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Mask"); PlayerInfo[playerid][pMask] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"WT"); PlayerInfo[playerid][pWT] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"WTc"); PlayerInfo[playerid][pWTc] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Lang1"); PlayerInfo[playerid][pLang1] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Lang2"); PlayerInfo[playerid][pLang2] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Work"); PlayerInfo[playerid][pWork] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"CanRobTime"); PlayerInfo[playerid][pRobTime] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Locked"); PlayerInfo[playerid][pLocked] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Credits"); PlayerInfo[playerid][pCredits] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"ChangeSpawnVeh"); PlayerInfo[playerid][pCSV] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"Rename"); PlayerInfo[playerid][pRename] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"TypeVIP"); PlayerInfo[playerid][pTypeVIP] = strval(savingstring);
            //mysql_fetch_field_row(savingstring,"Email"); PlayerInfo[playerid][pEmail] = strval(savingstring);
            mysql_fetch_field_row(savingstring,"PasswordPanel"); PlayerInfo[playerid][pPanel] = strval(savingstring);
        }
        mysql_free_result(); // Fin de la requкte SQL.
     return 1;
}
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help