24.01.2010, 11:53
Код:
case LOGIN_THREAD_ID:
{
if(IsPlayerConnected(LOGIN_PLAYER_ID))
{
mysql_store_result();
if(mysql_num_rows() == 1)
{
new Field[64];
for(new rcnt = 33; mysql_fetch_field(rcnt, Field); rcnt++)
{
if (rcnt == 33) PlayerInfo[LOGIN_PLAYER_ID][pAdmin] = strval(Field);
printf("Admin: %d", Field);
if (rcnt == 34) PlayerInfo[LOGIN_PLAYER_ID][pLevel] = strval(Field);
if (rcnt == 35) PlayerInfo[LOGIN_PLAYER_ID][pRegistered] = strval(Field);
if (rcnt == 36) PlayerInfo[LOGIN_PLAYER_ID][pRegZeit] = strval(Field);
if (rcnt == 37) PlayerInfo[LOGIN_PLAYER_ID][pSex] = strval(Field);
if (rcnt == 38) PlayerInfo[LOGIN_PLAYER_ID][pAge] = strval(Field);
if (rcnt == 39) PlayerInfo[LOGIN_PLAYER_ID][pExp] = strval(Field);
if (rcnt == 40) PlayerInfo[LOGIN_PLAYER_ID][pCash] = strval(Field);
if (rcnt == 41) PlayerInfo[LOGIN_PLAYER_ID][pBank] = strval(Field); // "Bank"
if (rcnt == 42) PlayerInfo[LOGIN_PLAYER_ID][pSkin] = strval(Field); // "Skin"
if (rcnt == 43) PlayerInfo[LOGIN_PLAYER_ID][pLastSkin] = strval(Field); // "LastSkin"
if (rcnt == 44) PlayerInfo[LOGIN_PLAYER_ID][pKoks] = strval(Field); // "Koks"
if (rcnt == 45) PlayerInfo[LOGIN_PLAYER_ID][pGras] = strval(Field); // "Gras"
if (rcnt == 46) PlayerInfo[LOGIN_PLAYER_ID][pMHx] = floatstr(Field); // "aGrasX"
if (rcnt == 47) PlayerInfo[LOGIN_PLAYER_ID][pMHy] = floatstr(Field); // "aGrasY"
if (rcnt == 48) PlayerInfo[LOGIN_PLAYER_ID][pMHz] = floatstr(Field); // "aGrasZ"
if (rcnt == 49) PlayerInfo[LOGIN_PLAYER_ID][pMHa] = floatstr(Field); // "aGrasA"
if (rcnt == 50) PlayerInfo[LOGIN_PLAYER_ID][pMH] = strval(Field); // "aGras"
if (rcnt == 51) PlayerInfo[LOGIN_PLAYER_ID][pMHZeit] = strval(Field); // "aGrasZeit"
if (rcnt == 52) PlayerInfo[LOGIN_PLAYER_ID][pCrashX] = floatstr(Field); // "Crash_X"
if (rcnt == 53) PlayerInfo[LOGIN_PLAYER_ID][pCrashY] = floatstr(Field); // "Crash_Y"
if (rcnt == 54) PlayerInfo[LOGIN_PLAYER_ID][pCrashZ] = floatstr(Field); // "Crash_Z"
if (rcnt == 55) PlayerInfo[LOGIN_PLAYER_ID][pCrashInt] = strval(Field); // "Crash_Int"
if (rcnt == 56) PlayerInfo[LOGIN_PLAYER_ID][pCrashW] = strval(Field); // "Crash_Welt"
if (rcnt == 57) PlayerInfo[LOGIN_PLAYER_ID][pCrashed] = strval(Field); // "Crashed"
if (rcnt == 58) PlayerInfo[LOGIN_PLAYER_ID][pCarLic] = strval(Field); // "AutoSchein"
if (rcnt == 59) PlayerInfo[LOGIN_PLAYER_ID][pFlyLic] = strval(Field); // "FlugSchein"
if (rcnt == 60) PlayerInfo[LOGIN_PLAYER_ID][pBootLic] = strval(Field); // "BootsSchein"
if (rcnt == 61) PlayerInfo[LOGIN_PLAYER_ID][pBikeLic] = strval(Field); // "BikeSchein"
if (rcnt == 62) PlayerInfo[LOGIN_PLAYER_ID][pWepLic] = strval(Field); // "WaffeSchein"
if (rcnt == 63) PlayerInfo[LOGIN_PLAYER_ID][pJob] = strval(Field); // "Job"
if (rcnt == 64) PlayerInfo[LOGIN_PLAYER_ID][pTruckSkill] = strval(Field); // "TruckSkill"
if (rcnt == 65) PlayerInfo[LOGIN_PLAYER_ID][pMechSkill] = strval(Field); // "MechanikerSkill"
if (rcnt == 66) PlayerInfo[LOGIN_PLAYER_ID][pJackSkill] = strval(Field); // "JackSkill"
if (rcnt == 67) PlayerInfo[LOGIN_PLAYER_ID][pBankSkill] = strval(Field); // "BankSkill"
if (rcnt == 68) PlayerInfo[LOGIN_PLAYER_ID][pPlayingHours] = strval(Field); // "SpielStunden"
if (rcnt == 69) PlayerInfo[LOGIN_PLAYER_ID][pPaydayZeit] = strval(Field); // "PayDayZeit"
if (rcnt == 70) PlayerInfo[LOGIN_PLAYER_ID][pPayCheck] = strval(Field); // "PayCheck"
if (rcnt == 71) PlayerInfo[LOGIN_PLAYER_ID][pDonator] = strval(Field); // "Premium"
if (rcnt == 72) PlayerInfo[LOGIN_PLAYER_ID][pFaction] = strval(Field); // "Fraktion"
if (rcnt == 73) PlayerInfo[LOGIN_PLAYER_ID][pRank] = strval(Field); // "Rank"
if (rcnt == 74) PlayerInfo[LOGIN_PLAYER_ID][pHouseKey] = strval(Field); // "HausKey"
if (rcnt == 75) PlayerInfo[LOGIN_PLAYER_ID][pGemietet] = strval(Field); // "MietKey"
if (rcnt == 76) PlayerInfo[LOGIN_PLAYER_ID][pBizKey] = strval(Field); // "BizKey"
if (rcnt == 77) PlayerInfo[LOGIN_PLAYER_ID][pSpawnPoint] = strval(Field); // "SpawnPunkt"
if (rcnt == 78) PlayerInfo[LOGIN_PLAYER_ID][pBanned] = strval(Field); // "Gebannt"
if (rcnt == 79) PlayerInfo[LOGIN_PLAYER_ID][pWarnings] = strval(Field); // "Verwarnungen"
if (rcnt == 80) PlayerInfo[LOGIN_PLAYER_ID][pCarLicSperre] = strval(Field); // "FahrVerbot"
if (rcnt == 81) PlayerInfo[LOGIN_PLAYER_ID][pBlitzPunkte] = strval(Field); // "BlitzPunkte"
if (rcnt == 82) PlayerInfo[LOGIN_PLAYER_ID][pPhoneNumber] = strval(Field); // "TelefonNummer"
if (rcnt == 83) PlayerInfo[LOGIN_PLAYER_ID][pPhoneC] = strval(Field); // "TelefonC"
if (rcnt == 84) PlayerInfo[LOGIN_PLAYER_ID][pInetC] = strval(Field); // "InternetC"
if (rcnt == 85) PlayerInfo[LOGIN_PLAYER_ID][pPhoneBook] = strval(Field); // "TelefonBuch"
if (rcnt == 86) PlayerInfo[LOGIN_PLAYER_ID][pNotizblock] = strval(Field); // "NotizBlock"
if (rcnt == 87) PlayerInfo[LOGIN_PLAYER_ID][pKoffer] = strval(Field); // "Koffer"
if (rcnt == 88) PlayerInfo[LOGIN_PLAYER_ID][pLaptop] = strval(Field); // "LapTop"
if (rcnt == 89) PlayerInfo[LOGIN_PLAYER_ID][pKanister] = strval(Field); // "Kanister"
if (rcnt == 90) PlayerInfo[LOGIN_PLAYER_ID][pErsteHilfe] = strval(Field); // "ErsteHilfe"
if (rcnt == 91) PlayerInfo[LOGIN_PLAYER_ID][pMorphium] = strval(Field); // "Morphium"
if (rcnt == 92) PlayerInfo[LOGIN_PLAYER_ID][pGPS] = strval(Field); // "GPS"
if (rcnt == 93) PlayerInfo[LOGIN_PLAYER_ID][pMaske] = strval(Field); // "Maske"
if (rcnt == 94) PlayerInfo[LOGIN_PLAYER_ID][pMaskeauf] = strval(Field); // "MaskeAn"
if (rcnt == 95) PlayerInfo[LOGIN_PLAYER_ID][pListNumber] = strval(Field); // "ListNummer"
if (rcnt == 96) PlayerInfo[LOGIN_PLAYER_ID][pJailed] = strval(Field); // "Verhaftet"
if (rcnt == 97) PlayerInfo[LOGIN_PLAYER_ID][pJailTime] = strval(Field); // "KnastZeit"
if (rcnt == 98) WantedLevel[LOGIN_PLAYER_ID] = strval(Field); // "WantedLevel"
if (rcnt == 99) PlayerInfo[LOGIN_PLAYER_ID][pProducts] = strval(Field); // "Produkte"
if (rcnt == 100) PlayerInfo[LOGIN_PLAYER_ID][pJobTimer] = strval(Field); // "JobTimer"
if (rcnt == 101) PlayerInfo[LOGIN_PLAYER_ID][pCarTime] = strval(Field); // "CarTime"
if (rcnt == 102) PlayerInfo[LOGIN_PLAYER_ID][pFightStyle] = strval(Field); // "KampfStil"
if (rcnt == 103) PlayerInfo[LOGIN_PLAYER_ID][pBoxen] = strval(Field); // "Boxen"
if (rcnt == 104) PlayerInfo[LOGIN_PLAYER_ID][pKungFu] = strval(Field); // "KungFu"
if (rcnt == 105) PlayerInfo[LOGIN_PLAYER_ID][pItems] = strval(Field); // "Items"
if (rcnt == 106) PlayerInfo[LOGIN_PLAYER_ID][pFalschgeld] = strval(Field); // "FalschGeld"
if (rcnt == 107) PlayerInfo[LOGIN_PLAYER_ID][pKredit] = strval(Field); // "Kredit"
//rcnt++;
}
mysql_free_result();
format(string,sizeof(string),">> Du wurdest eingeloggt. (Geld: %d, Level: %d)",PlayerInfo[LOGIN_PLAYER_ID][pCash],PlayerInfo[LOGIN_PLAYER_ID][pLevel]);
SendClientMessage(LOGIN_PLAYER_ID,COLOR_LIGHTGREEN,string);
}
else
{
Wrongattempt[LOGIN_PLAYER_ID] += 1;
printf("Bad log in attempt by %s (Total attempts: %d)",pName,Wrongattempt[LOGIN_PLAYER_ID]);
if(Wrongattempt[LOGIN_PLAYER_ID] >= 3)
{
mysql_free_result();
return Kick(LOGIN_PLAYER_ID);
}
mysql_free_result();
}
}
LOGIN_PLAYER_ID = INVALID_PLAYER_ID;
return 0;
Didn't tried the sscanf Method, because don't know how to make my code in sscanf.