Hay habe das Problem das mein Account aufeinmal nicht mehr geladen wird gestern gings ja noch, hab da aber noch ein Tutorial eingebaut und nicht getestet.. davor gings noch :X (hab auch versucht ohne das Tutorial klappt nicht..)
Ausschnitt aus OnPlayerLogin:
[pwn]
print("Fange an Spieler zu laden..");
new line[1024]; //I know it's big D=
if(mysql_fetch_row(line)) //Fetches the line
{
print("fetch_row");
new data[3][128]; //The data strings
new d2[97]; //The data variables
new Float:data3[5];
print"sccanf start"); sscanf(line,"p|dssddddddddddddddddddddddddddddddddddddddddddddddddddffdddddddddddddddfffdddddddddddddddddddddddddddddddds",d2[94],data[0],data[0],d2[0],d2[1],d2[2],d2[3],d2[4],d2[5],d2[6],d2[7],d2[8],d2[9],d2[10],d2[11],d2[12],d2[13],d2[14],d2[15],d2[16],d2[17],d2[18],d2[19],d2[20],d2[21],d2[22],d2[23],d2[24],d2[25],d2[26],d2[27],d2[28],
d2[29],d2[30],d2[31],d2[32],d2[33],d2[34],d2[35],d2[36],d2[37],d2[38],d2[39],d2[40],d2[41],d2[42],d2[43],d2[44],d2[45],d2[46],d2[47],d2[48],d2[49],data3[0],data3[1],d2[50],
d2[51],d2[52],d2[53],d2[54],d2[55],d2[56],d2[57],d2[58],d2[59],d2[60],d2[61],d2[62],d2[63],d2[64],data3[2],data3[3],data3[4],d2[65],d2[66],d2[67],d2[68],d2[69],d2[70],d2[71],d2[72],d2[73],d2[74],d2[75],d2[76],d2[77],d2[78],d2[79],d2[80],d2[81],d2[82],d2[83],d2[84],d2[85],d2[86],d2[87],d2[88],d2[89],d2[90],d2[91],d2[92],d2[93],d2[94],d2[95],d2[96],data[2]);
printf("%s",line);
print("sscanf ende - setzte variablen");
PlayerInfo[playerid][pLevel] = d2[0];
PlayerInfo[playerid][pAdmin] = d2[1];
PlayerInfo[playerid][pDonateRank] = d2[2];
PlayerInfo[playerid][gPupgrade] = d2[3];
PlayerInfo[playerid][pConnectTime] = d2[4];
PlayerInfo[playerid][pReg] = d2[5];
PlayerInfo[playerid][pSex] = d2[6];
PlayerInfo[playerid][pAge] = d2[7];
PlayerInfo[playerid][pOrigin] = d2[8];
PlayerInfo[playerid][pCK] = d2[9];
PlayerInfo[playerid][pMuted] = d2[10];
PlayerInfo[playerid][pExp] = d2[11];
PlayerInfo[playerid][pCash] = d2[12];
PlayerInfo[playerid][pAccount] = d2[13];
PlayerInfo[playerid][pCrimes] = d2[14];
PlayerInfo[playerid][pKills] = d2[15];
PlayerInfo[playerid][pSKills] = d2[16];
PlayerInfo[playerid][pDeaths] = d2[17];
PlayerInfo[playerid][pArrested] = d2[18];
PlayerInfo[playerid][pWantedDeaths] = d2[19];
PlayerInfo[playerid][pPhoneBook] = d2[20];
PlayerInfo[playerid][pLottoNr] = d2[21];
PlayerInfo[playerid][pFishes] = d2[22];
PlayerInfo[playerid][pBiggestFish] = d2[23];
PlayerInfo[playerid][pJob] = d2[24];
PlayerInfo[playerid][pPayCheck] = d2[25];
PlayerInfo[playerid][pHeadValue] = d2[26];
PlayerInfo[playerid][pJailed] = d2[27];
PlayerInfo[playerid][pJailTime] = d2[28];
PlayerInfo[playerid][pMats] = d2[29];
PlayerInfo[playerid][pSafeMats] = d2[30];
PlayerInfo[playerid][pDrugs] = d2[31];
PlayerInfo[playerid][pSafeDrugs] = d2[32];
PlayerInfo[playerid][pLeader] = d2[33];
PlayerInfo[playerid][pMember] = d2[34];
PlayerInfo[playerid][pFMember] = d2[35];
PlayerInfo[playerid][pRank] = d2[36];
PlayerInfo[playerid][pChar] = d2[37];
PlayerInfo[playerid][pContractTime] = d2[38];
PlayerInfo[playerid][pDetSkill] = d2[39];
PlayerInfo[playerid][pSexSkill] = d2[40];
PlayerInfo[playerid][pBoxSkill] = d2[41];
PlayerInfo[playerid][pLawSkill] = d2[42];
PlayerInfo[playerid][pMechSkill] = d2[43];
PlayerInfo[playerid][pJackSkill] = d2[44];
PlayerInfo[playerid][pCarSkill] = d2[45];
PlayerInfo[playerid][pNewsSkill] = d2[46];
PlayerInfo[playerid][pDrugsSkill] = d2[47];
PlayerInfo[playerid][pCookSkill] = d2[48];
PlayerInfo[playerid][pFishSkill] = d2[49];
PlayerInfo[playerid][pSHealth] = data3[0];
PlayerInfo[playerid][pHealth] = data3[1];
PlayerInfo[playerid][pInt] = d2[50];
PlayerInfo[playerid][pLocal] = d2[51];
PlayerInfo[playerid][pTeam] = d2[52];
PlayerInfo[playerid][pModel] = d2[53];
PlayerInfo[playerid][pPnumber] = d2[54];
PlayerInfo[playerid][pPhousekey] = d2[55];
PlayerInfo[playerid][pPbiskey] = d2[56];
PlayerInfo[playerid][pFightstyle] = d2[57];
PlayerInfo[playerid][pWanteds] = d2[58];
PlayerInfo[playerid][pGangjail] = d2[59];
PlayerInfo[playerid][pKidnap] = d2[60];
PlayerInfo[playerid][pGutschein] = d2[61];
PlayerInfo[playerid][pBan] = d2[62];
PlayerInfo[playerid][pSpawnChange] = d2[63];
PlayerInfo[playerid][pInviteSperre] = d2[64];
PlayerInfo[playerid][pPos_x] = data3[2];
PlayerInfo[playerid][pPos_y] = data3[3];
PlayerInfo[playerid][pPos_z] = data3[4];
PlayerInfo[playerid][pCarLic] = d2[65];
PlayerInfo[playerid][pMotoLic] = d2[66];
PlayerInfo[playerid][pLkwLic] = d2[67];
PlayerInfo[playerid][pFlyLic] = d2[68];
PlayerInfo[playerid][pBoatLic] = d2[69];
PlayerInfo[playerid][pFishLic] = d2[70];
PlayerInfo[playerid][pGunLic] = d2[71];
PlayerInfo[playerid][pGun1] = d2[72];
PlayerInfo[playerid][pGun2] = d2[73];
PlayerInfo[playerid][pGun3] = d2[74];
PlayerInfo[playerid][pGun4] = d2[75];
PlayerInfo[playerid][pAmmo1] = d2[76];
PlayerInfo[playerid][pAmmo2] = d2[77];
PlayerInfo[playerid][pAmmo3] = d2[78];
PlayerInfo[playerid][pAmmo4] = d2[79];
PlayerInfo[playerid][pCarTime] = d2[80];
PlayerInfo[playerid][pPayDay] = d2[81];
PlayerInfo[playerid][pPayDayHad] = d2[82];
PlayerInfo[playerid][pCDPlayer] = d2[83];
PlayerInfo[playerid][pWins] = d2[84];
PlayerInfo[playerid][pLoses] = d2[85];
PlayerInfo[playerid][pAlcoholPerk] = d2[86];
PlayerInfo[playerid][pDrugPerk] = d2[87];
PlayerInfo[playerid][pMiserPerk] = d2[88];
PlayerInfo[playerid][pPainPerk] = d2[89];
PlayerInfo[playerid][pTraderPerk] = d2[90];
PlayerInfo[playerid][pTut] = d2[91];
PlayerInfo[playerid][pMissionNr] = d2[92];
PlayerInfo[playerid][pWarns] = d2[93];
PlayerInfo[playerid][pAdjustable] = d2[94];
PlayerInfo[playerid][pFuel] = d2[95];
PlayerInfo[playerid][pMarried] = d2[96];
strdel(PlayerInfo[playerid][pMarriedTo],0,128);
strins(PlayerInfo[playerid][pMarriedTo], data[2], 0, 128);
print("Ende mit setzen");
mysql_free_result();
print("free result");
}
print("Spieler wurde erfolgreich geladen");
[/pwn]
In der Console steht nur
[pwn]
[18:35:00] OPLogin Start
[18:35:00] Fange an Spieler zu laden..
[18:35:00] fetch_row
[18:35:00] sscanf start[/pwn]
Mysql Debug:
Alles anzeigen
Ausschnitt aus OnPlayerLogin:
[pwn]
print("Fange an Spieler zu laden..");
new line[1024]; //I know it's big D=
if(mysql_fetch_row(line)) //Fetches the line
{
print("fetch_row");
new data[3][128]; //The data strings
new d2[97]; //The data variables
new Float:data3[5];
print"sccanf start"); sscanf(line,"p|dssddddddddddddddddddddddddddddddddddddddddddddddddddffdddddddddddddddfffdddddddddddddddddddddddddddddddds",d2[94],data[0],data[0],d2[0],d2[1],d2[2],d2[3],d2[4],d2[5],d2[6],d2[7],d2[8],d2[9],d2[10],d2[11],d2[12],d2[13],d2[14],d2[15],d2[16],d2[17],d2[18],d2[19],d2[20],d2[21],d2[22],d2[23],d2[24],d2[25],d2[26],d2[27],d2[28],
d2[29],d2[30],d2[31],d2[32],d2[33],d2[34],d2[35],d2[36],d2[37],d2[38],d2[39],d2[40],d2[41],d2[42],d2[43],d2[44],d2[45],d2[46],d2[47],d2[48],d2[49],data3[0],data3[1],d2[50],
d2[51],d2[52],d2[53],d2[54],d2[55],d2[56],d2[57],d2[58],d2[59],d2[60],d2[61],d2[62],d2[63],d2[64],data3[2],data3[3],data3[4],d2[65],d2[66],d2[67],d2[68],d2[69],d2[70],d2[71],d2[72],d2[73],d2[74],d2[75],d2[76],d2[77],d2[78],d2[79],d2[80],d2[81],d2[82],d2[83],d2[84],d2[85],d2[86],d2[87],d2[88],d2[89],d2[90],d2[91],d2[92],d2[93],d2[94],d2[95],d2[96],data[2]);
printf("%s",line);
print("sscanf ende - setzte variablen");
PlayerInfo[playerid][pLevel] = d2[0];
PlayerInfo[playerid][pAdmin] = d2[1];
PlayerInfo[playerid][pDonateRank] = d2[2];
PlayerInfo[playerid][gPupgrade] = d2[3];
PlayerInfo[playerid][pConnectTime] = d2[4];
PlayerInfo[playerid][pReg] = d2[5];
PlayerInfo[playerid][pSex] = d2[6];
PlayerInfo[playerid][pAge] = d2[7];
PlayerInfo[playerid][pOrigin] = d2[8];
PlayerInfo[playerid][pCK] = d2[9];
PlayerInfo[playerid][pMuted] = d2[10];
PlayerInfo[playerid][pExp] = d2[11];
PlayerInfo[playerid][pCash] = d2[12];
PlayerInfo[playerid][pAccount] = d2[13];
PlayerInfo[playerid][pCrimes] = d2[14];
PlayerInfo[playerid][pKills] = d2[15];
PlayerInfo[playerid][pSKills] = d2[16];
PlayerInfo[playerid][pDeaths] = d2[17];
PlayerInfo[playerid][pArrested] = d2[18];
PlayerInfo[playerid][pWantedDeaths] = d2[19];
PlayerInfo[playerid][pPhoneBook] = d2[20];
PlayerInfo[playerid][pLottoNr] = d2[21];
PlayerInfo[playerid][pFishes] = d2[22];
PlayerInfo[playerid][pBiggestFish] = d2[23];
PlayerInfo[playerid][pJob] = d2[24];
PlayerInfo[playerid][pPayCheck] = d2[25];
PlayerInfo[playerid][pHeadValue] = d2[26];
PlayerInfo[playerid][pJailed] = d2[27];
PlayerInfo[playerid][pJailTime] = d2[28];
PlayerInfo[playerid][pMats] = d2[29];
PlayerInfo[playerid][pSafeMats] = d2[30];
PlayerInfo[playerid][pDrugs] = d2[31];
PlayerInfo[playerid][pSafeDrugs] = d2[32];
PlayerInfo[playerid][pLeader] = d2[33];
PlayerInfo[playerid][pMember] = d2[34];
PlayerInfo[playerid][pFMember] = d2[35];
PlayerInfo[playerid][pRank] = d2[36];
PlayerInfo[playerid][pChar] = d2[37];
PlayerInfo[playerid][pContractTime] = d2[38];
PlayerInfo[playerid][pDetSkill] = d2[39];
PlayerInfo[playerid][pSexSkill] = d2[40];
PlayerInfo[playerid][pBoxSkill] = d2[41];
PlayerInfo[playerid][pLawSkill] = d2[42];
PlayerInfo[playerid][pMechSkill] = d2[43];
PlayerInfo[playerid][pJackSkill] = d2[44];
PlayerInfo[playerid][pCarSkill] = d2[45];
PlayerInfo[playerid][pNewsSkill] = d2[46];
PlayerInfo[playerid][pDrugsSkill] = d2[47];
PlayerInfo[playerid][pCookSkill] = d2[48];
PlayerInfo[playerid][pFishSkill] = d2[49];
PlayerInfo[playerid][pSHealth] = data3[0];
PlayerInfo[playerid][pHealth] = data3[1];
PlayerInfo[playerid][pInt] = d2[50];
PlayerInfo[playerid][pLocal] = d2[51];
PlayerInfo[playerid][pTeam] = d2[52];
PlayerInfo[playerid][pModel] = d2[53];
PlayerInfo[playerid][pPnumber] = d2[54];
PlayerInfo[playerid][pPhousekey] = d2[55];
PlayerInfo[playerid][pPbiskey] = d2[56];
PlayerInfo[playerid][pFightstyle] = d2[57];
PlayerInfo[playerid][pWanteds] = d2[58];
PlayerInfo[playerid][pGangjail] = d2[59];
PlayerInfo[playerid][pKidnap] = d2[60];
PlayerInfo[playerid][pGutschein] = d2[61];
PlayerInfo[playerid][pBan] = d2[62];
PlayerInfo[playerid][pSpawnChange] = d2[63];
PlayerInfo[playerid][pInviteSperre] = d2[64];
PlayerInfo[playerid][pPos_x] = data3[2];
PlayerInfo[playerid][pPos_y] = data3[3];
PlayerInfo[playerid][pPos_z] = data3[4];
PlayerInfo[playerid][pCarLic] = d2[65];
PlayerInfo[playerid][pMotoLic] = d2[66];
PlayerInfo[playerid][pLkwLic] = d2[67];
PlayerInfo[playerid][pFlyLic] = d2[68];
PlayerInfo[playerid][pBoatLic] = d2[69];
PlayerInfo[playerid][pFishLic] = d2[70];
PlayerInfo[playerid][pGunLic] = d2[71];
PlayerInfo[playerid][pGun1] = d2[72];
PlayerInfo[playerid][pGun2] = d2[73];
PlayerInfo[playerid][pGun3] = d2[74];
PlayerInfo[playerid][pGun4] = d2[75];
PlayerInfo[playerid][pAmmo1] = d2[76];
PlayerInfo[playerid][pAmmo2] = d2[77];
PlayerInfo[playerid][pAmmo3] = d2[78];
PlayerInfo[playerid][pAmmo4] = d2[79];
PlayerInfo[playerid][pCarTime] = d2[80];
PlayerInfo[playerid][pPayDay] = d2[81];
PlayerInfo[playerid][pPayDayHad] = d2[82];
PlayerInfo[playerid][pCDPlayer] = d2[83];
PlayerInfo[playerid][pWins] = d2[84];
PlayerInfo[playerid][pLoses] = d2[85];
PlayerInfo[playerid][pAlcoholPerk] = d2[86];
PlayerInfo[playerid][pDrugPerk] = d2[87];
PlayerInfo[playerid][pMiserPerk] = d2[88];
PlayerInfo[playerid][pPainPerk] = d2[89];
PlayerInfo[playerid][pTraderPerk] = d2[90];
PlayerInfo[playerid][pTut] = d2[91];
PlayerInfo[playerid][pMissionNr] = d2[92];
PlayerInfo[playerid][pWarns] = d2[93];
PlayerInfo[playerid][pAdjustable] = d2[94];
PlayerInfo[playerid][pFuel] = d2[95];
PlayerInfo[playerid][pMarried] = d2[96];
strdel(PlayerInfo[playerid][pMarriedTo],0,128);
strins(PlayerInfo[playerid][pMarriedTo], data[2], 0, 128);
print("Ende mit setzen");
mysql_free_result();
print("free result");
}
print("Spieler wurde erfolgreich geladen");
[/pwn]
In der Console steht nur
[pwn]
[18:35:00] OPLogin Start
[18:35:00] Fange an Spieler zu laden..
[18:35:00] fetch_row
[18:35:00] sscanf start[/pwn]
Mysql Debug:
Quellcode
- [18:23:11] CMySQLHandler::Query(SELECT * FROM `players` WHERE `Name` = 'heidi' AND `Password` = '123') - Successfully executed.
- [18:23:11] >> mysql_store_result( Connection handle: 1 )
- [18:23:11] CMySQLHandler::StoreResult() - Result was stored.
- [18:23:11] >> mysql_num_rows( Connection handle: 1 )
- [18:23:11] CMySQLHandler::NumRows() - Returned 1 row(s)
- [18:23:11] >> mysql_fetch_row_format( Connection handle: 1 )
- [18:23:11] CMySQLHandler::FetchRow() - Return: 6|heidi|123|1|0|0|0|0|0|1|0|255|0|0|0|500|1000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|255|0|0|0|0|0|0|0|0|0|0|0|0|0|0|50.0|50.0|0|255|3|264|0|255|255|0|0|0|0|0|0|0|0|1684.9|-2244.5|13.5|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|No-one