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

Threaded Mode
Help |errorid: 2014 | error: Commands out of sync; you can't run this command now
SHFaCeBook
Big Clucker
***
Posts: 106
Threads: 31
Joined: Jun 2014
Reputation: 0
#1

14.09.2014, 18:49
Hello , i have problem , server crash in many time , logs server


Код:
[15:05:49] errorid: 1054 | error: Unknown column 'playerLastLogin' in 'field list' | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE playeraccounts SET playerLastLogin = '13.09.2014 15:05' WHERE playerID = '0'
[15:06:38] [server] [cmd] Tester1 (ID 0): /ah
[15:06:42] [server] [cmd] Tester1 (ID 0): /n sd
[15:06:43] [chat] [Tester1]: qsd
[15:06:46] [server] [cmd] Tester (ID 0): /newbie
[15:06:47] [server] [cmd] Tester (ID 0): /newbie 1
[15:06:51] [server] [cmd] Tester (ID 0): /newbie 1
[15:06:57] [server] [cmd] Tester (ID 0): /report
[15:07:02] errorid: 1054 | error: Unknown column 'playerHouse' in 'field list' | resultid: -1 | extraid: -1 | callback: NULL | query: UPDATE playeraccounts SET playerBanned = '0', playerSeconds = '34', playerSkin = '186', playerMoney = '922795', playerBankMoney = '97137', playerHouse = '0', playerBusiness = '0', playerColor = '0', playerInterior = '3', playerVirtualWorld = '20001', playerHealth = '100.000000', playerArmour = '0.000000', playerBoatLic = '0', playerAccent = 'American', playerAdminLevel = '7', playerJob = '12', playerWeapon0 = '0', playerWeapon1 = '0', playerWeapon2 = '0', playerWeapon3 = '0', playerWeapon4 = '0', playerWeapon5 = '0', playerWeapon6 = '0', playerWeapon7 = '0', playerWeapon8 = '0', playerWeapon9 = '0', playerWeapon10 = '0', playerWeapon11 = '0', playerWeapon12 = '0', playerJobSkill2 = '1', playerMaterials = '0', playerHours = '12', playerLevel = '3', playerWarning1 = '', playerWarning2 = '', playerWarning3 = '', playerHospitalized = '0', playerFirstLogin = '0', playerAdminName = '(null)', playerPrisonTime = '0', playerPrisonID = '0', playerPhoneNumber = '-1', playerCarPaintJob = '-1', playerCarLock = '0', playerStatus = '1', playerGender = '1', playerFightStyle = '0', playerCarWeapon1 = '0', playerCarWeapon2 = '0', playerCarWeapon3 = '0', playerCarWeapon4 = '0', playerCarWeapon5 = '60', playerCarLicensePlate = 'CS-RO 56', playerCarTrunk1 = '0', playerCarTrunk2 = '0', playerPhoneCredit = '0', playerWalkieTalkie = '-1', playerFlyLic = '10', playerGunLic = '0', playerPhoneBook = '0', playerGroup = '0', playerGroupRank = '0', playerIP = '178.25.154.161', playerDropCarTimeout = '0', playerRope = '32', playerAdminDuty = '49', playerCrimes = '0', playerArrests = '0', playerWarrants = '0', playerAge = '49', playerCarMod7 = '0', playerCarMod8 = '0', playerCarMod9 = '0', playerCarMod10 = '0', playerCarMod11 = '0', playerCarMod12 = '0', playerHelperLevel = '0', playerClan = '0', playerClanRank = '0', playerPhone = '0', playerManager = '0', playerClanTagType = '0', playerHelpedPlayers = '0', playerHelperTokens = '0', playerHouseRented = '20', playerGlasses = '0' WHERE playerID = '341'
code in script :
1.
Код:
errorid: 1054 | error: Unknown column 'playerLastLogin' in 'field list' ........
pawn Код:
new year, month, day, hour, minute, second;
    getdate(year, month, day);
    gettime(hour, minute, second);
    format(playerVariables[playerid][pLastLogin], 20, "%02d.%02d.%d %02d:%02d", day, month, year, hour, minute);
    new query[256];
    format(query, sizeof(query), "UPDATE playeraccounts SET playerLastLogin = '%s' WHERE playerID = '%d'", playerVariables[playerid][pLastLogin], playerVariables[playerid][pInternalID]);
    mysql_query( query);
2 . when i enter in any house , i fail..
Код:
errorid: 1054 | error: Unknown column 'playerHouse' in 'field list' | resultid: -1 ........... '',see logs one''
pawn Код:
stock savePlayerData(const playerid)
{
    if(playerVariables[playerid][pStatus] >= 1 || playerVariables[playerid][pStatus] == -1)
    {
        new saveQuery[3500];
        if(playerVariables[playerid][pStatus] == -1) playerVariables[playerid][pStatus] = 0;

        format(saveQuery, sizeof(saveQuery), "UPDATE playeraccounts SET playerBanned = '%d', playerSeconds = '%d', playerSkin = '%d', playerMoney = '%d', playerBankMoney = '%d', playerHouse = '%d', playerBusiness = '%d'",
         playerVariables[playerid][pBanned], playerVariables[playerid][pSeconds], playerVariables[playerid][pSkin], playerVariables[playerid][pMoney], playerVariables[playerid][pBankMoney], playerVariables[playerid][pHouse], playerVariables[playerid][pBusiness]);

        format(saveQuery, sizeof(saveQuery), "%s, playerColor = '%d', playerInterior = '%d', playerVirtualWorld = '%d', playerHealth = '%f', playerArmour = '%f', playerBoatLic = '%d'", saveQuery, playerVariables[playerid][pColor], playerVariables[playerid][pInterior], playerVariables[playerid][pVirtualWorld], playerVariables[playerid][pHealth], playerVariables[playerid][pArmour], playerVariables[playerid][pBoatLicense]);

        format(saveQuery, sizeof(saveQuery), "%s, playerAccent = '%s', playerAdminLevel = '%d', playerJob = '%d', playerWeapon0 = '%d', playerWeapon1 = '%d', playerWeapon2 = '%d', playerWeapon3 = '%d'", saveQuery, playerVariables[playerid][pAccent], playerVariables[playerid][pAdminLevel], playerVariables[playerid][pJob], playerVariables[playerid][pWeapons][0], playerVariables[playerid][pWeapons][1], playerVariables[playerid][pWeapons][2], playerVariables[playerid][pWeapons][3]);

        format(saveQuery, sizeof(saveQuery), "%s, playerWeapon4 = '%d', playerWeapon5 = '%d', playerWeapon6 = '%d', playerWeapon7 = '%d', playerWeapon8 = '%d', playerWeapon9 = '%d', playerWeapon10 = '%d'", saveQuery, playerVariables[playerid][pWeapons][4], playerVariables[playerid][pWeapons][5], playerVariables[playerid][pWeapons][6], playerVariables[playerid][pWeapons][7], playerVariables[playerid][pWeapons][8], playerVariables[playerid][pWeapons][9], playerVariables[playerid][pWeapons][10]);

        format(saveQuery, sizeof(saveQuery), "%s, playerWeapon11 = '%d', playerWeapon12 = '%d', playerJobSkill2 = '%d', playerMaterials = '%d', playerHours = '%d', playerLevel = '%d'", saveQuery, playerVariables[playerid][pWeapons][11], playerVariables[playerid][pWeapons][12], playerVariables[playerid][pDonate], playerVariables[playerid][pMaterials], playerVariables[playerid][pPlayingHours], playerVariables[playerid][pLevel]);

        format(saveQuery, sizeof(saveQuery), "%s, playerWarning1 = '%s', playerWarning2 = '%s', playerWarning3 = '%s', playerHospitalized = '%d', playerFirstLogin = '%d', playerAdminName = '%s', playerPrisonTime = '%d', playerPrisonID = '%d', playerPhoneNumber = '%d'", saveQuery, playerVariables[playerid][pCarLic], playerVariables[playerid][pFlyLic], playerVariables[playerid][pGunLic], playerVariables[playerid][pHospitalized], playerVariables[playerid][pFirstLogin], playerVariables[playerid][pCrimeReason],
        playerVariables[playerid][pPrisonTime], playerVariables[playerid][pPrisonID], playerVariables[playerid][pPhoneNumber]);

        format(saveQuery, sizeof(saveQuery), "%s, playerCarPaintJob = '%d', playerCarLock = '%d', playerStatus = '%d', playerGender = '%d', playerFightStyle = '%d', playerCarWeapon1 = '%d', playerCarWeapon2 = '%d', playerCarWeapon3 = '%d', playerCarWeapon4 = '%d', playerCarWeapon5 = '%d', playerCarLicensePlate = '%s'", saveQuery, playerVariables[playerid][pCarPaintjob], playerVariables[playerid][pCarLock],
        playerVariables[playerid][pStatus], playerVariables[playerid][pGender], playerVariables[playerid][pFightStyle], playerVariables[playerid][pCarWeapons], playerVariables[playerid][pFPunish], playerVariables[playerid][pFWarns], playerVariables[playerid][pSpawnChange], playerVariables[playerid][pPremiumPoints], playerVariables[playerid][pCarLicensePlate]);

        format(saveQuery, sizeof(saveQuery), "%s, playerCarTrunk1 = '%d', playerCarTrunk2 = '%d', playerPhoneCredit = '%d', playerWalkieTalkie = '%d', playerFlyLic = '%d', playerGunLic = '%d'", saveQuery, playerVariables[playerid][pCarKM], playerVariables[playerid][pDrugs], playerVariables[playerid][pPhoneCredit], playerVariables[playerid][pWalkieTalkie],playerVariables[playerid][pFlyLicense],playerVariables[playerid][pGunLicense]);

        format(saveQuery, sizeof(saveQuery), "%s, playerPhoneBook = '%d', playerGroup = '%d', playerGroupRank = '%d', playerIP = '%s', playerDropCarTimeout = '%d', playerRope = '%d', playerAdminDuty = '%d', playerCrimes = '%d', playerArrests = '%d', playerWarrants = '%d', playerAge = '%d', playerCarMod7 = '%d', playerCarMod8 = '%d', playerCarMod9 = '%d', playerCarMod10 = '%d', playerCarMod11 = '%d', playerCarMod12 = '%d'", saveQuery, playerVariables[playerid][pPhoneBook],
        playerVariables[playerid][pGroup], playerVariables[playerid][pGroupRank], playerVariables[playerid][pConnectionIP], playerVariables[playerid][pDropCarTimeout], playerVariables[playerid][pDriveLicense], playerVariables[playerid][pRobPoints], playerVariables[playerid][pCrimes], playerVariables[playerid][pArrests], playerVariables[playerid][pWarrants], playerVariables[playerid][pRPoints], playerVariables[playerid][pCarMods1][7], playerVariables[playerid][pCarMods1][8],
        playerVariables[playerid][pCarMods1][9], playerVariables[playerid][pCarMods1][10], playerVariables[playerid][pCarMods1][11], playerVariables[playerid][pCarMods1][12]);

        format(saveQuery, sizeof(saveQuery), "%s, playerHelperLevel = '%d', playerClan = '%d', playerClanRank = '%d', playerPhone = '%d', playerManager = '%d', playerClanTagType = '%d', playerHelpedPlayers = '%d', playerHelperTokens = '%d', playerHouseRented = '%d', playerGlasses = '%d'", saveQuery,
            playerVariables[playerid][pHelper],playerVariables[playerid][pClan],playerVariables[playerid][pClanRank],playerVariables[playerid][pPhone],playerVariables[playerid][pManager],playerVariables[playerid][pClanTagType],
            playerVariables[playerid][pHelpedPlayers],playerVariables[playerid][pHelperTokens],playerVariables[playerid][pHouseRented],playerVariables[playerid][pGlasses]);

        format(saveQuery, sizeof(saveQuery), "%s WHERE playerID = '%d'", saveQuery, playerVariables[playerid][pInternalID]);
        mysql_query( saveQuery);
        
    }

    return 1;
}
and when player report , server crash
in logs
Код:
errorid: 2014 | error: Commands out of sync; you can't run this command now | resultid: -1 | extraid: -1 | callback: NULL | query: INSERT INTO `reports` (`player`,`message`,`time`) VALUES ('Nieo_Saints','Q','14/09/2014 18:26:42')
in pwn code
pawn Код:
CMD:report(playerid, params[])
{
    new string2[256],message[128],admins=0;
    if(sscanf(params, "s[128]", message)) return SCM(playerid, COLOR_GREY, SYNTAX_MESSAGE"/report [text]");
    {
        if(playerVariables[playerid][pRMuted] <= 0)
        {
            if(playerVariables[playerid][pDr] <= 0)
            {
                new query[128];
                format(query,sizeof(query),"SELECT * FROM `reports`");
                mysql_query( query);//
                new reportss = mysql_num_rows( );
                if(reportss == 69) return SendClientMessage(playerid, COLOR_WHITE,"{FFFFCC}Error: There're too many unreaded reports.");
                foreach(Player, i)
                {
                    if(playerVariables[i][pAdminLevel] >= 1)
                    {
                        admins++;
                    }
                }
                if(admins == 0) return SendClientMessage(playerid, COLOR_WHITE, "{FFFFCC}Error: There are no admins online.");
                new ya,ma,da,ha,mia,sa;
                getdate(ya,ma,da);
                gettime(ha,mia,sa);
                new str[512];
                format(str,512,"INSERT INTO `reports` (`player`,`message`,`time`) VALUES ('%s','%s','%02d/%02d/%d %02d:%02d:%02d')",playerVariables[playerid][pNormalName],message,da,ma,ya,ha,mia,sa);
                mysql_query( str);
                format(string2, sizeof(string2), "{F3FF02}Your Report Message was sent to the Admins.");
                SendClientMessage(playerid, 0xFFFFFFFF, string2);
                format(string2, sizeof(string2), "Report from %s [%d]: %s.",playerVariables[playerid][pNormalName],playerid, message);
                submitToHelpersAndAdmins(string2,COLOR_FRED);
                playerVariables[playerid][pDr] = 60;
            }
            else
            {
                SCM(playerid,-1,"Poti da un report o data la un minut.");
            }   
        }
        else SCM(playerid,-1,"You are muted from /report.");
    }
    return 1;
}
+rep for any helped me , i use mysql r5
Find
Reply
SHFaCeBook
Big Clucker
***
Posts: 106
Threads: 31
Joined: Jun 2014
Reputation: 0
#2

14.09.2014, 19:41
Bump!
Find
Reply
SHFaCeBook
Big Clucker
***
Posts: 106
Threads: 31
Joined: Jun 2014
Reputation: 0
#3

15.09.2014, 12:45
Bump! ''please help .
Find
Reply
SHFaCeBook
Big Clucker
***
Posts: 106
Threads: 31
Joined: Jun 2014
Reputation: 0
#4

15.09.2014, 14:38
Bump ! I still need help with it.
Find
Reply
SilentSoul
Gangsta
*****
Posts: 810
Threads: 17
Joined: Aug 2013
Reputation: 0
#5

15.09.2014, 14:40
Unknown column 'playerHouse' in 'field list' did you even create that table? check your mysql database if there is a table exists with name "playerHouse".
Find
Reply
AroseKhanNiazi
High-roller
*****
Posts: 1,349
Threads: 194
Joined: Jan 2014
Reputation: 0
#6

15.09.2014, 14:42
please don't bump before 24 hours
Find
Reply
SHFaCeBook
Big Clucker
***
Posts: 106
Threads: 31
Joined: Jun 2014
Reputation: 0
#7

15.09.2014, 15:18
Quote:
Originally Posted by SilentSoul
Посмотреть сообщение
Unknown column 'playerHouse' in 'field list' did you even create that table? check your mysql database if there is a table exists with name "playerHouse".
Thanks for answer , i have it in sql


pawn Код:
`playerHouse` int(100) NOT NULL DEFAULT '0',
pawn Код:
--
-- Structure de la table `playeraccounts`
--

CREATE TABLE IF NOT EXISTS `playeraccounts` (
  `playerID` int(12) NOT NULL AUTO_INCREMENT,
  `playerPhone` int(15) DEFAULT '1',
  `playerLevel` int(6) NOT NULL DEFAULT '0',
  `playerName` varchar(24) NOT NULL,
  `playerPassword` varchar(129) NOT NULL,
  `playerEmail` varchar(255) NOT NULL,
  `playerMoney` int(16) NOT NULL DEFAULT '10000',
  `playerPublicProfile` int(2) NOT NULL,
  `playerAdminLevel` int(6) NOT NULL DEFAULT '0',
  `playerRegistrationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `playerSkin` int(6) NOT NULL DEFAULT '60',
  `playerPosX` varchar(255) NOT NULL DEFAULT '1794.213256',
  `playerPosY` varchar(255) NOT NULL DEFAULT '-1862.133666',
  `playerPosZ` varchar(255) NOT NULL DEFAULT '13.576666',
  `playerBankMoney` int(16) NOT NULL DEFAULT '20000',
  `playerHealth` varchar(255) NOT NULL DEFAULT '100',
  `playerArmour` int(255) NOT NULL DEFAULT '0',
  `playerAccent` varchar(40) NOT NULL DEFAULT 'American',
  `playerSeconds` int(5) NOT NULL DEFAULT '0',
  `playerInterior` int(6) NOT NULL DEFAULT '0',
  `playerVirtualWorld` int(6) NOT NULL DEFAULT '0',
  `playerJob` int(3) NOT NULL DEFAULT '0',
  `playerWeapon0` int(6) NOT NULL DEFAULT '0',
  `playerWeapon1` int(6) NOT NULL DEFAULT '0',
  `playerWeapon2` int(6) NOT NULL DEFAULT '0',
  `playerWeapon3` int(6) NOT NULL DEFAULT '0',
  `playerWeapon4` int(6) NOT NULL DEFAULT '0',
  `playerWeapon5` int(6) NOT NULL DEFAULT '0',
  `playerWeapon6` int(6) NOT NULL DEFAULT '0',
  `playerWeapon7` int(6) NOT NULL DEFAULT '0',
  `playerWeapon8` int(6) NOT NULL DEFAULT '0',
  `playerWeapon9` int(6) NOT NULL DEFAULT '0',
  `playerWeapon10` int(6) NOT NULL DEFAULT '0',
  `playerWeapon11` int(6) NOT NULL DEFAULT '0',
  `playerWeapon12` int(6) NOT NULL DEFAULT '0',
  `playerJobSkill1` int(6) NOT NULL DEFAULT '0',
  `playerJobSkill2` int(6) NOT NULL DEFAULT '0',
  `playerMaterials` int(12) NOT NULL DEFAULT '0',
  `playerGroup` int(6) NOT NULL DEFAULT '0',
  `playerGroupRank` int(6) NOT NULL DEFAULT '0',
  `playerHours` int(12) NOT NULL DEFAULT '0',
  `playerWarning1` varchar(32) NOT NULL DEFAULT '(null)',
  `playerWarning2` varchar(32) NOT NULL DEFAULT '(null)',
  `playerWarning3` varchar(32) NOT NULL DEFAULT '(null)',
  `playerHospitalized` int(3) NOT NULL DEFAULT '0',
  `playerAdminName` varchar(24) NOT NULL,
  `playerFirstLogin` int(2) NOT NULL DEFAULT '1',
  `playerGender` int(2) NOT NULL DEFAULT '0',
  `playerPrisonID` int(2) NOT NULL DEFAULT '0',
  `playerPrisonTime` int(6) NOT NULL DEFAULT '0',
  `playerPhoneNumber` int(12) NOT NULL DEFAULT '-1',
  `playerPhoneBook` int(2) NOT NULL DEFAULT '0',
  `playerIP` varchar(32) NOT NULL DEFAULT '0.0.0.0',
  `playerHelperLevel` int(6) NOT NULL DEFAULT '0',
  `playerDropCarTimeout` int(12) NOT NULL DEFAULT '0',
  `playerRope` int(6) NOT NULL DEFAULT '0',
  `playerAdminDuty` int(2) NOT NULL DEFAULT '0',
  `playerCrimes` int(12) NOT NULL DEFAULT '0',
  `playerArrests` int(12) NOT NULL DEFAULT '0',
  `playerWarrants` int(12) NOT NULL DEFAULT '0',
  `playerPasswordToken` int(16) NOT NULL DEFAULT '0',
  `playerCarModel` int(6) NOT NULL DEFAULT '0',
  `playerCarModel2` int(6) NOT NULL DEFAULT '0',
  `playerCarModel3` int(6) NOT NULL DEFAULT '0',
  `playerCarModel4` int(6) NOT NULL DEFAULT '0',
  `playerCarMod0` int(6) NOT NULL DEFAULT '0',
  `playerCarMod1` int(6) NOT NULL DEFAULT '0',
  `playerCarMod2` int(6) NOT NULL DEFAULT '0',
  `playerCarMod3` int(6) NOT NULL DEFAULT '0',
  `playerCarMod4` int(6) NOT NULL DEFAULT '0',
  `playerCarMod5` int(6) NOT NULL DEFAULT '0',
  `playerCarMod6` int(6) NOT NULL DEFAULT '0',
  `playerCarMod7` int(6) NOT NULL DEFAULT '0',
  `playerCarMod8` int(6) NOT NULL DEFAULT '0',
  `playerCarMod9` int(6) NOT NULL DEFAULT '0',
  `playerCarMod10` int(6) NOT NULL DEFAULT '0',
  `playerCarMod11` int(6) NOT NULL DEFAULT '0',
  `playerCarMod12` int(6) NOT NULL DEFAULT '0',
  `playerCarMod20` int(6) NOT NULL DEFAULT '0',
  `playerCarMod21` int(6) NOT NULL DEFAULT '0',
  `playerCarMod22` int(6) NOT NULL DEFAULT '0',
  `playerCarMod23` int(6) NOT NULL DEFAULT '0',
  `playerCarMod24` int(6) NOT NULL DEFAULT '0',
  `playerCarMod25` int(6) NOT NULL DEFAULT '0',
  `playerCarMod26` int(6) NOT NULL DEFAULT '0',
  `playerCarMod27` int(6) NOT NULL DEFAULT '0',
  `playerCarMod28` int(6) NOT NULL DEFAULT '0',
  `playerCarMod29` int(6) NOT NULL DEFAULT '0',
  `playerCarMod30` int(6) NOT NULL DEFAULT '0',
  `playerCarMod31` int(6) NOT NULL DEFAULT '0',
  `playerCarMod32` int(6) NOT NULL DEFAULT '0',
  `playerCarPosX` varchar(255) NOT NULL DEFAULT '0.0',
  `playerCarPosY` varchar(255) NOT NULL DEFAULT '0.0',
  `playerCarPosZ` varchar(255) NOT NULL DEFAULT '0.0',
  `playerCarPosZAngle` varchar(255) NOT NULL DEFAULT '0.0',
  `playerCarPosX2` varchar(255) NOT NULL DEFAULT '0.0',
  `playerCarPosY2` varchar(255) NOT NULL DEFAULT '0.0',
  `playerCarPosZ2` varchar(255) NOT NULL DEFAULT '0.0',
  `playerCarPosZAngle2` varchar(255) NOT NULL DEFAULT '0.0',
  `playerCarColour1` int(6) NOT NULL DEFAULT '-1',
  `playerCarColour2` int(6) NOT NULL DEFAULT '-1',
  `playerCarColour21` int(6) NOT NULL DEFAULT '-1',
  `playerCarColour22` int(6) NOT NULL DEFAULT '-1',
  `playerAge` int(6) NOT NULL,
  `playerCarPaintJob` int(6) NOT NULL DEFAULT '-1',
  `playerCarLock` int(6) NOT NULL DEFAULT '0',
  `playerCarPaintJob2` int(6) NOT NULL DEFAULT '-1',
  `playerCarLock2` int(6) NOT NULL DEFAULT '0',
  `playerCarLicense2` varchar(32) NOT NULL DEFAULT 'LGY RPG',
  `playerStatus` int(6) NOT NULL DEFAULT '0',
  `playerBiography` longtext NOT NULL,
  `playerFightStyle` int(6) NOT NULL DEFAULT '0',
  `playerVIP` int(6) NOT NULL DEFAULT '0',
  `playerExpireVIP` int(64) NOT NULL DEFAULT '0',
  `playerCarWeapon1` int(12) NOT NULL DEFAULT '0',
  `playerCarWeapon2` int(12) NOT NULL DEFAULT '0',
  `playerCarWeapon3` int(12) NOT NULL DEFAULT '0',
  `playerCarWeapon4` int(12) NOT NULL DEFAULT '0',
  `playerCarWeapon5` int(12) NOT NULL DEFAULT '0',
  `playerCarTrunk1` int(12) NOT NULL DEFAULT '0',
  `playerCarTrunk2` int(12) NOT NULL DEFAULT '0',
  `playerCarKM2` int(12) NOT NULL DEFAULT '0',
  `playerPhoneCredit` int(12) NOT NULL DEFAULT '0',
  `playerWalkieTalkie` int(12) NOT NULL DEFAULT '-1',
  `playerAdminTitle` varchar(255) NOT NULL DEFAULT '(null)',
  `playerCarLicensePlate` varchar(32) NOT NULL DEFAULT '3VF4 TW0',
  `playerAdminPIN` int(4) NOT NULL DEFAULT '0',
  `playerHouseRented` int(6) NOT NULL DEFAULT '0',
  `playerCarLock3` int(6) NOT NULL DEFAULT '0',
  `playerCarLock4` int(6) NOT NULL DEFAULT '0',
  `playerCarKM3` int(6) NOT NULL DEFAULT '0',
  `playerCarKM4` int(6) NOT NULL DEFAULT '0',
  `playerCarColor31` int(6) NOT NULL DEFAULT '-1',
  `playerCarColor32` int(6) NOT NULL DEFAULT '-1',
  `playerCarColor41` int(6) NOT NULL DEFAULT '-1',
  `playerCarColor42` int(6) NOT NULL DEFAULT '-1',
  `playerCarPosX3` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
  `playerCarPosY3` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
  `playerCarPosZ3` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
  `playerCarPosZAngle3` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
  `playerCarPosX4` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
  `playerCarPosY4` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
  `playerCarPosZ4` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
  `playerCarPosZAngle4` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
  `playerCarPaintJob3` int(6) NOT NULL DEFAULT '-1',
  `playerCarPaintJob4` int(6) NOT NULL DEFAULT '-1',
  `playerCarMod60` int(6) NOT NULL DEFAULT '0',
  `playerCarMod61` int(6) NOT NULL DEFAULT '0',
  `playerCarMod62` int(6) NOT NULL DEFAULT '0',
  `playerCarMod63` int(6) NOT NULL DEFAULT '0',
  `playerCarMod64` int(6) NOT NULL DEFAULT '0',
  `playerCarMod65` int(6) NOT NULL DEFAULT '0',
  `playerCarMod66` int(6) NOT NULL DEFAULT '0',
  `playerCarMod67` int(6) NOT NULL DEFAULT '0',
  `playerCarMod68` int(6) NOT NULL DEFAULT '0',
  `playerCarMod69` int(6) NOT NULL DEFAULT '0',
  `playerCarMod70` int(6) NOT NULL DEFAULT '0',
  `playerCarMod71` int(6) NOT NULL DEFAULT '0',
  `playerCarMod72` int(6) NOT NULL DEFAULT '0',
  `playerCarMod90` int(6) NOT NULL DEFAULT '0',
  `playerCarMod80` int(6) NOT NULL DEFAULT '0',
  `playerCarMod81` int(6) NOT NULL DEFAULT '0',
  `playerCarMod82` int(6) NOT NULL DEFAULT '0',
  `playerCarMod83` int(6) NOT NULL DEFAULT '0',
  `playerCarMod84` int(6) NOT NULL DEFAULT '0',
  `playerCarMod85` int(6) NOT NULL DEFAULT '0',
  `playerCarMod86` int(6) NOT NULL DEFAULT '0',
  `playerCarMod87` int(6) NOT NULL DEFAULT '0',
  `playerCarMod88` int(6) NOT NULL DEFAULT '0',
  `playerCarMod89` int(6) NOT NULL DEFAULT '0',
  `playerCarMod91` int(6) DEFAULT '0',
  `playerCarMod92` int(6) NOT NULL DEFAULT '0',
  `playerAge1` int(6) NOT NULL DEFAULT '0',
  `playerFlyLic` int(6) NOT NULL DEFAULT '0',
  `playerGunLic` int(6) NOT NULL DEFAULT '0',
  `playerClan` int(6) NOT NULL DEFAULT '0',
  `playerClanRank` int(6) NOT NULL DEFAULT '0',
  `playerLastLogin` varchar(20) NOT NULL,
  `playerColor` int(11) NOT NULL DEFAULT '0',
  `playerAplicationID` int(11) NOT NULL DEFAULT '0',
  `playerManager` int(69) NOT NULL DEFAULT '0',
  `playerClanTagType` int(69) NOT NULL DEFAULT '0',
  `playerHelpedPlayers` int(100) NOT NULL DEFAULT '0',
  `playerHelperTokens` int(225) NOT NULL DEFAULT '0',
  `playerGlasses` int(50) NOT NULL DEFAULT '0',
  `rpgon` int(10) NOT NULL DEFAULT '0',
  `playerBoatLic` int(150) NOT NULL DEFAULT '0',
  `playerHud` int(69) NOT NULL DEFAULT '0',
  `playerHouse` int(100) NOT NULL DEFAULT '0',
  `playerBusiness` int(100) NOT NULL,
  `playerDays` int(255) NOT NULL DEFAULT '0',
  `playerBanned` int(69) NOT NULL DEFAULT '0',
  PRIMARY KEY (`playerID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1182 ;

--
-- Contenu de la table `playeraccounts`
--
Find
Reply
SHFaCeBook
Big Clucker
***
Posts: 106
Threads: 31
Joined: Jun 2014
Reputation: 0
#8

15.09.2014, 18:41
Bump , please help ..
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