Hallo,
Ich hab ein problem das beim einloggen die tabelle nicht geladen wird.
Plugin ist SA-MP MySQL plugin R5.
[18:52:40] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name` = 'Alex') - Successfully executed.
[18:52:40] >> mysql_store_result( Connection handle: 1 )
[18:52:40] CMySQLHandler::StoreResult() - Result was stored.
[18:52:40] >> mysql_num_rows( Connection handle: 1 )
[18:52:40] CMySQLHandler::NumRows() - Returned 1 row(s)
[18:52:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:52:40] CMySQLHandler::FetchField() - You cannot call this function now. (Reason: Fields/Rows are empty.)
[18:52:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:52:40] CMySQLHandler::FetchField() - You cannot call this function now. (Reason: Fields/Rows are empty.)
[18:52:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:52:40] CMySQLHandler::FetchField() - You cannot call this function now. (Reason: Fields/Rows are empty.)
[18:52:40] >> mysql_fetch_field_row( Connection handle: 1 )
[18:52:40] CMySQLHandler::FetchField() - You cannot call this function now. (Reason: Fields/Rows are empty.)
[18:52:40] >> mysql_fetch_field_row( Connection handle: 1 )
Alles anzeigen
Zum script:
print("Derbug 1");
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
print("Derbug 2");
if(GetPVarInt(playerid,"Gast") == 1)return true;
print("Derbug 3");
new query[128],wert[128];
print("Derbug 4");
printf("%s",SpielerInfo[playerid][sName]);
format(query,sizeof(query), "SELECT * FROM `accounts` WHERE `Name` = '%s'",SpielerInfo[playerid][sName]);
print("Derbug 5");
mysql_query(query);
print("Derbug 6");
mysql_store_result();
print("Derbug 7");
if(mysql_num_rows())
{
mysql_fetch_field_row("Banned",wert); SpielerInfo[playerid][sBanned] = strval(wert);
print("Derbug 8");
if(SpielerInfo[playerid][sBanned] == 1)
{
print("Derbug 9");
print("Derbug 10");
PKick(playerid);
print("Derbug 11");
}
mysql_fetch_field_row("BannedReason",SpielerInfo[playerid][sBannedReason]);
print("Derbug 12");
mysql_fetch_field_row("BannedFrom",SpielerInfo[playerid][sBannedFrom]);
print("Derbug 13");
mysql_fetch_field_row("MuteTime",wert);SpielerInfo[playerid][sMuteTime] = strval(wert);
print("Derbug 14");
if(SpielerInfo[playerid][sMuteTime] > 0)
{
print("Derbug 15");
killunmuteauto[playerid] = SetTimerEx("unmuteauto",60000*SpielerInfo[playerid][sMuteTime],0,"i",playerid);
print("Derbug 16");
mute{playerid} = true;
print("Derbug 17");
}
mysql_fetch_field_row("Adminlevel",wert);SpielerInfo[playerid][sAdminlevel] = strval(wert);
print("Derbug 18");
mysql_fetch_field_row("Premium",wert);SpielerInfo[playerid][sPremium] = strval(wert);
print("Derbug 19");
mysql_fetch_field_row("Sprache",wert);SpielerInfo[playerid][sSprache] = strval(wert);
print("Derbug 20");
mysql_fetch_field_row("Geld",wert);SpielerInfo[playerid][sGeld] = strval(wert);
print("Derbug 21");
SetPlayerMoney(playerid,SpielerInfo[playerid][sGeld]);
print("Derbug 22");
mysql_fetch_field_row("Cargod",wert);SpielerInfo[playerid][sCargod] = strval(wert);
print("Derbug 23");
mysql_fetch_field_row("Boost",wert);SpielerInfo[playerid][sBoost] = strval(wert);
print("Derbug 24");
mysql_fetch_field_row("Nos",wert);SpielerInfo[playerid][sNos] = strval(wert);
print("Derbug 25");
mysql_fetch_field_row("God",wert);SpielerInfo[playerid][sGod] = strval(wert);
print("Derbug 26");
mysql_fetch_field_row("Ramp",wert);SpielerInfo[playerid][sRamp] = strval(wert);
print("Derbug 27");
mysql_fetch_field_row("Antifall",wert);SpielerInfo[playerid][sAntifall] = strval(wert);
print("Derbug 28");
mysql_fetch_field_row("Allowpm",wert);SpielerInfo[playerid][sAllowpm] = strval(wert);
print("Derbug 29");
mysql_fetch_field_row("Allowgoto",wert);SpielerInfo[playerid][sAllowgoto] = strval(wert);
print("Derbug 30");
mysql_fetch_field_row("Spielzeit",wert);SpielerInfo[playerid][sSpielzeit] = strval(wert);
print("Derbug 31");
mysql_fetch_field_row("Kills",wert);SpielerInfo[playerid][sKills] = strval(wert);
print("Derbug 32");
mysql_fetch_field_row("Tode",wert);SpielerInfo[playerid][sTode] = strval(wert);
print("Derbug 33");
mysql_fetch_field_row("RegIP",SpielerInfo[playerid][sRegIP]);
print("Derbug 34");
mysql_fetch_field_row("RegDatum",SpielerInfo[playerid][sRegDatum]);
print("Derbug 35");
mysql_fetch_field_row("Cookies",wert);SpielerInfo[playerid][sCookies] = strval(wert);
print("Derbug 36");
mysql_fetch_field_row("Skin",wert);SpielerInfo[playerid][sSkin] = strval(wert);
print("Derbug 37");
mysql_fetch_field_row("sethomex",wert);SetPVarFloat(playerid,"sethomex",strval(wert));
print("Derbug 38");
mysql_fetch_field_row("sethomey",wert);SetPVarFloat(playerid,"sethomey",strval(wert));
print("Derbug 39");
mysql_fetch_field_row("sethomez",wert);SetPVarFloat(playerid,"sethomez",strval(wert));
print("Derbug 40");
mysql_fetch_field_row("sethomeang",wert);SetPVarFloat(playerid,"sethomeang",strval(wert));
print("Derbug 41");
mysql_fetch_field_row("Wslot1",wert);SpielerInfo[playerid][sWslot1] = strval(wert);
print("Derbug 42");
mysql_fetch_field_row("Mslot1",wert);SpielerInfo[playerid][sMslot1] = strval(wert);
print("Derbug 43");
mysql_fetch_field_row("Wslot2",wert);SpielerInfo[playerid][sWslot2] = strval(wert);
print("Derbug 44");
mysql_fetch_field_row("Mslot2",wert);SpielerInfo[playerid][sMslot2] = strval(wert);
print("Derbug 45");
mysql_fetch_field_row("Wslot3",wert);SpielerInfo[playerid][sWslot3] = strval(wert);
print("Derbug 46");
mysql_fetch_field_row("Mslot3",wert);SpielerInfo[playerid][sMslot3] = strval(wert);
print("Derbug 47");
mysql_fetch_field_row("Wslot4",wert);SpielerInfo[playerid][sWslot4] = strval(wert);
print("Derbug 48");
mysql_fetch_field_row("Mslot4",wert);SpielerInfo[playerid][sMslot4] = strval(wert);
print("Derbug 49");
mysql_fetch_field_row("Wslot5",wert);SpielerInfo[playerid][sWslot5] = strval(wert);
print("Derbug 50");
mysql_fetch_field_row("Mslot5",wert);SpielerInfo[playerid][sMslot5] = strval(wert);
print("Derbug 51");
mysql_fetch_field_row("Wslot6",wert);SpielerInfo[playerid][sWslot6] = strval(wert);
print("Derbug 52");
mysql_fetch_field_row("Mslot6",wert);SpielerInfo[playerid][sMslot6] = strval(wert);
print("Derbug 53");
mysql_fetch_field_row("Wslot7",wert);SpielerInfo[playerid][sWslot7] = strval(wert);
print("Derbug 54");
print("Derbug 55");
mysql_fetch_field_row("Mslot7",wert);SpielerInfo[playerid][sMslot7] = strval(wert);
print("Derbug 56");
mysql_fetch_field_row("Wslot8",wert);SpielerInfo[playerid][sWslot8] = strval(wert);
print("Derbug 57");
mysql_fetch_field_row("Mslot8",wert);SpielerInfo[playerid][sMslot8] = strval(wert);
print("Derbug 58");
mysql_fetch_field_row("Wslot9",wert);SpielerInfo[playerid][sWslot9] = strval(wert);
print("Derbug 59");
mysql_fetch_field_row("Mslot9",wert);SpielerInfo[playerid][sMslot9] = strval(wert);
print("Derbug 60");
mysql_fetch_field_row("Wslot10",wert);SpielerInfo[playerid][sWslot10] = strval(wert);
print("Derbug 61");
mysql_fetch_field_row("Mslot10",wert);SpielerInfo[playerid][sMslot10] = strval(wert);
print("Derbug 62");
mysql_fetch_field_row("Wslot11",wert);SpielerInfo[playerid][sWslot11] = strval(wert);
print("Derbug 63");
mysql_fetch_field_row("Mslot11",wert);SpielerInfo[playerid][sMslot11] = strval(wert);
print("Derbug 64");
mysql_fetch_field_row("Wslot12",wert);SpielerInfo[playerid][sWslot12] = strval(wert);
print("Derbug 65");
mysql_fetch_field_row("Mslot12",wert);SpielerInfo[playerid][sMslot12] = strval(wert);
print("Derbug 66");
}
print("Derbug 67");
mysql_free_result();
print("Derbug 68");
print("Derbug 69");
RegisterLoginKomplett(playerid);
}
Alle debug meldungen kommen an.
Könnt ihr mir bitte helfen?
MFG Martinez