Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql_free_result();
- new pName1[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName1,sizeof(pName1));
- format(query,sizeof(query),"SELECT * FROM `"TABLENAME"` WHERE Username = '%s' AND Password = '%s' LIMIT 1",pName1,md5(password));
- mysql_query(query);
- mysql_store_result();
- new intstring[128];
- new row[1024];
- mysql_fetch_row_format(row,"|");
- mysql_fetch_field_row(intstring, "Level");
- PlayerInfo[playerid][pLevel] = strval(intstring);
- mysql_fetch_field_row(intstring, "Admin");
- PlayerInfo[playerid][pAdmin] = strval(intstring);
- mysql_fetch_field_row(intstring, "DonateRank");
- PlayerInfo[playerid][pDonateRank] = strval(intstring);
- mysql_fetch_field_row(intstring, "Registered");
- PlayerInfo[playerid][pRegistered] = strval(intstring);
- mysql_fetch_field_row(intstring, "Sex");
- PlayerInfo[playerid][pSex] =strval(intstring);
- mysql_fetch_field_row(intstring, "Age");
- PlayerInfo[playerid][pAge] = strval(intstring);
- mysql_fetch_field_row(intstring, "Experience");
- PlayerInfo[playerid][pExp] = strval(intstring);
- mysql_fetch_field_row(intstring, "Cash");
- PlayerInfo[playerid][pCash] = strval(intstring);
- mysql_fetch_field_row(intstring, "Bank");
- PlayerInfo[playerid][pBank] = strval(intstring);
- mysql_fetch_field_row(intstring, "Skin");
- PlayerInfo[playerid][pSkin] = strval(intstring);
- mysql_fetch_field_row(intstring, "Drugs");
- PlayerInfo[playerid][pDrugs] = strval(intstring);
- mysql_fetch_field_row(intstring, "Materials");
- PlayerInfo[playerid][pMaterials] = strval(intstring);
- mysql_fetch_field_row(intstring, "Job");
- PlayerInfo[playerid][pJob] = strval(intstring);
- mysql_fetch_field_row(intstring, "PlayingHours");
- PlayerInfo[playerid][pPlayingHours] = strval(intstring);
- mysql_fetch_field_row(intstring, "AllowedPayday");
- PlayerInfo[playerid][pAllowedPayday] = strval(intstring);
- mysql_fetch_field_row(intstring, "Paycheck");
- PlayerInfo[playerid][pPayCheck] = strval(intstring);
- mysql_fetch_field_row(intstring, "Faction");
- PlayerInfo[playerid][pFaction] = strval(intstring);
- mysql_fetch_field_row(intstring, "Rank");
- PlayerInfo[playerid][pRank] = strval(intstring);
- mysql_fetch_field_row(intstring, "HouseKey");
- PlayerInfo[playerid][pHouseKey] = strval(intstring);
- mysql_fetch_field_row(intstring, "BizKey");
- PlayerInfo[playerid][pBizKey] = strval(intstring);
- mysql_fetch_field_row(intstring, "SpawnPoint");
- PlayerInfo[playerid][pSpawnPoint] = strval(intstring);
- mysql_fetch_field_row(intstring, "Banned");
- PlayerInfo[playerid][pBanned] = strval(intstring);
- mysql_fetch_field_row(intstring, "Warnings");
- PlayerInfo[playerid][pWarnings] = strval(intstring);
- mysql_fetch_field_row(intstring, "CarLic");
- PlayerInfo[playerid][pCarLic] = strval(intstring);
- mysql_fetch_field_row(intstring, "FlyLic");
- PlayerInfo[playerid][pFlyLic] = strval(intstring);
- mysql_fetch_field_row(intstring, "WepLic");
- PlayerInfo[playerid][pWepLic] = strval(intstring);
- mysql_fetch_field_row(intstring, "PhoneNumber");
- PlayerInfo[playerid][pPhoneNumber] = strval(intstring);
- mysql_fetch_field_row(intstring, "PhoneC");
- PlayerInfo[playerid][pPhoneC] = strval(intstring);
- mysql_fetch_field_row(intstring, "PhoneBook");
- PlayerInfo[playerid][pPhoneBook] = strval(intstring);
- mysql_fetch_field_row(intstring, "ListNumber");
- PlayerInfo[playerid][pListNumber] = strval(intstring);
- mysql_fetch_field_row(intstring, "Donator");
- PlayerInfo[playerid][pDonator] = strval(intstring);
- mysql_fetch_field_row(intstring, "Jailed");
- PlayerInfo[playerid][pJailed] = strval(intstring);
- mysql_fetch_field_row(intstring, "JailTime");
- PlayerInfo[playerid][pJailTime] = strval(intstring);
- mysql_fetch_field_row(intstring, "Products");
- PlayerInfo[playerid][pProducts] = strval(intstring);
- mysql_fetch_field_row(intstring, "CrashX");
- PlayerInfo[playerid][pCrashX] = floatstr(intstring);
- mysql_fetch_field_row(intstring, "CrashY");
- PlayerInfo[playerid][pCrashY] = floatstr(intstring);
- mysql_fetch_field_row(intstring, "CrashZ");
- PlayerInfo[playerid][pCrashZ] = floatstr(intstring);
- mysql_fetch_field_row(intstring, "Crashint");
- PlayerInfo[playerid][pCrashInt] = strval(intstring);
- mysql_fetch_field_row(intstring, "CrashVW");
- PlayerInfo[playerid][pCrashW] = strval(intstring);
- mysql_fetch_field_row(intstring, "Crashed");
- PlayerInfo[playerid][pCrashed] = strval(intstring);
- mysql_free_result();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement