[Help] Lag :/ [+rep]
#1

Hello

i have probleme when i go Dealer shop to buy vehicle , i see all players AFK [lag] , and when i go other place .

norm , and when i go Drive car lag 1 minute or 1 maybe , is back norm , can any help me plzz


Mysql_Log

Код:
[19:21:13] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'CarJackerTime' in 'field list'
[19:21:13] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'GunoierTime' in 'field list'
[19:22:03] [WARNING] CMySQLResult::GetRowDataByName - field not found ("DisableTime")
[19:22:03] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CarJackerTime")
[19:22:03] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BusDriverTime")
[19:22:03] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GunoierTime")
[19:22:03] [WARNING] CMySQLResult::GetRowDataByName - field not found ("PizzaBoyTime")
[19:22:03] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CementTruckerTime")
[19:22:11] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET `DriverLicense` = '1'' at line 1
[19:29:50] [WARNING] CMySQLResult::GetRowDataByName - field not found ("DisableTime")
[19:29:50] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CarJackerTime")
[19:29:50] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BusDriverTime")
[19:29:50] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GunoierTime")
[19:29:50] [WARNING] CMySQLResult::GetRowDataByName - field not found ("PizzaBoyTime")
[19:29:50] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CementTruckerTime")
[19:29:56] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET `DriverLicense` = '1'' at line 1
[19:31:56] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'CarJackerTime' in 'field list'
[19:31:56] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'GunoierTime' in 'field list'
[19:41:22] [ERROR] CMySQLQuery::Execute[LoadedObjects] - (error #1146) Table 'samp_samp.objects' doesn't exist
[19:45:35] [WARNING] CMySQLResult::GetRowDataByName - field not found ("DisableTime")
[19:45:35] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CarJackerTime")
[19:45:35] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BusDriverTime")
[19:45:35] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GunoierTime")
[19:45:35] [WARNING] CMySQLResult::GetRowDataByName - field not found ("PizzaBoyTime")
[19:45:35] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CementTruckerTime")
[19:45:41] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET `DriverLicense` = '1'' at line 1
[19:52:01] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'CarJackerTime' in 'field list'
[19:52:01] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'GunoierTime' in 'field list'
[20:03:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("DisableTime")
[20:03:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CarJackerTime")
[20:03:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BusDriverTime")
[20:03:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GunoierTime")
[20:03:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("PizzaBoyTime")
[20:03:58] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CementTruckerTime")
[20:04:05] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET `DriverLicense` = '1'' at line 1
[20:05:25] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'CarJackerTime' in 'field list'
[20:05:25] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'GunoierTime' in 'field list'
Pawn Code for ['SET `DriverLicense] , i dont know where

pawn Код:
/*==============================================================================
                            OnAccountLoad(playerid)
==============================================================================*/

forward OnAccountLoad ( playerid ) ;
public OnAccountLoad ( playerid ) {
    SetCameraBehindPlayer(playerid);
   
    new
        temp[64],
        string[ 128 ],
        rows,
        fields;
    cache_get_data( rows, fields );
    if(rows) {
        cache_get_field_content( 0, "Level", temp), PlayerInfo[ playerid ][ pLevel ]                            = strval( temp );
        cache_get_field_content( 0, "AdminLevel", temp ), PlayerInfo[ playerid ][ pAdminLevel ]                 = strval( temp );
        cache_get_field_content( 0, "HelperLevel", temp ), PlayerInfo[ playerid ][ pHelperLevel ]               = strval( temp );
        cache_get_field_content( 0, "LeaderFaction", temp ), PlayerInfo[ playerid ][ pLeaderFaction ]           = strval( temp );
        cache_get_field_content( 0, "MemberFaction", temp ), PlayerInfo[ playerid ][ pMemberFaction ]           = strval( temp );
        cache_get_field_content( 0, "Oras", temp ), PlayerInfo[ playerid ][ pOras ]                             = strval( temp );
        cache_get_field_content( 0, "Varsta", temp ), PlayerInfo[ playerid ][ pVarsta ]                         = strval( temp );
        cache_get_field_content( 0, "Sex", temp ), PlayerInfo[ playerid ][ pSex ]                               = strval( temp );
        cache_get_field_content( 0, "Cash", temp ), PlayerInfo[ playerid ][ pCash ]                             = strval( temp );
        cache_get_field_content( 0, "Bank", temp ), PlayerInfo[ playerid ][ pBank ]                             = strval( temp );
        cache_get_field_content( 0, "Warns", temp ), PlayerInfo[ playerid ][ pWarns ]                           = strval( temp );
        cache_get_field_content( 0, "Job", temp ), PlayerInfo[ playerid ][ pJob ]                               = strval( temp );
        cache_get_field_content( 0, "Rank", temp ), PlayerInfo[ playerid ][ pRank ]                             = strval( temp );
        cache_get_field_content( 0, "MutedTime", temp ), PlayerInfo[ playerid ][ pMutedTime ]                   = strval( temp );
        cache_get_field_content( 0, "DriverLicense", temp ), PlayerInfo[ playerid ][ pDriverLicense ]           = strval( temp );
        cache_get_field_content( 0, "PilotsLicense", temp ), PlayerInfo[ playerid ][ pPilotsLicense ]           = strval( temp );
        cache_get_field_content( 0, "BoatLicense", temp ), PlayerInfo[ playerid ][ pBoatLicense ]               = strval( temp );
        cache_get_field_content( 0, "FishLicense", temp ), PlayerInfo[ playerid ][ pFishLicense ]               = strval( temp );
        cache_get_field_content( 0, "GunsLicense", temp ), PlayerInfo[ playerid ][ pGunsLicense ]               = strval( temp );
        cache_get_field_content( 0, "Skin", temp ), PlayerInfo[ playerid ][ pSkin ]                             = strval( temp );
        cache_get_field_content( 0, "Register", temp ), PlayerInfo[ playerid ][ pRegister ]                     = strval( temp );
        cache_get_field_content( 0, "AcceptedMember", temp ), PlayerInfo[ playerid ][ pAcceptedMember ]         = strval( temp );
        cache_get_field_content( 0, "FWarn", temp ), PlayerInfo[ playerid ][ pFWarn ]                           = strval( temp );
        cache_get_field_content( 0, "FPunish", temp ), PlayerInfo[ playerid ][ pFPunish ]                       = strval( temp );
        cache_get_field_content( 0, "WantedLevel", temp ), PlayerInfo[ playerid ][ pWantedLevel ]               = strval( temp );
        cache_get_field_content( 0, "WantedDeaths", temp ), PlayerInfo[ playerid ][ pWantedDeaths ]             = strval( temp );
        cache_get_field_content( 0, "JailTime", temp ), PlayerInfo[ playerid ][ pJailTime ]                     = strval( temp );
        cache_get_field_content( 0, "Kills", temp ), PlayerInfo[ playerid ][ pKills ]                           = strval( temp );
        cache_get_field_content( 0, "Deaths", temp ), PlayerInfo[ playerid ][ pDeaths ]                         = strval( temp );
        cache_get_field_content( 0, "TimpConectat", temp ), PlayerInfo[ playerid ][ pTimpConectat ]             = strval( temp );
        cache_get_field_content( 0, "ValoareContract", temp ), PlayerInfo[ playerid ][ pValoareContract ]       = strval( temp );
        cache_get_field_content( 0, "Respect", temp ), PlayerInfo[ playerid ][ pRespect ]                       = strval( temp );
        cache_get_field_content( 0, "DisableTime", temp ), PlayerInfo[ playerid ][ pDisabledTime ]              = strval( temp );
        cache_get_field_content( 0, "NDisabled", temp ), PlayerInfo[ playerid ][ pNDisabled ]                   = strval( temp );
        cache_get_field_content( 0, "Materiale", temp ), PlayerInfo[ playerid ][ pMateriale ]                   = strval( temp );
        cache_get_field_content( 0, "HouseKey", temp ), PlayerInfo[ playerid ][ pHouseKey ]                     = strval( temp );
        cache_get_field_content( 0, "RentHouse", temp ), PlayerInfo[ playerid ][ pRentHouse ]                   = strval( temp );
        cache_get_field_content( 0, "Arestari", temp ), PlayerInfo[ playerid ][ pArestari ]                     = strval( temp );
        cache_get_field_content( 0, "Droguri", temp ), PlayerInfo[ playerid ][ pDroguri ]                       = strval( temp );
        cache_get_field_content( 0, "BizKey", temp ), PlayerInfo[ playerid ][ pBizKey ]                         = strval( temp );
        cache_get_field_content( 0, "Card", temp ), PlayerInfo[ playerid ][ pCard ]                             = strval( temp );
        cache_get_field_content( 0, "CardPin", temp ), PlayerInfo[ playerid ][ pCardPin ]                       = strval( temp );
        cache_get_field_content( 0, "LoiallityPoints", temp ), PlayerInfo[ playerid ][ pLoiallityPoints ]       = strval( temp );
        cache_get_field_content( 0, "FishTimer", temp ), PlayerInfo[ playerid ][ pFishTimer ]                   = strval( temp );
        cache_get_field_content( 0, "RegisterDate", PlayerInfo[ playerid ][ pDateRegister ] );
        cache_get_field_content( 0, "LastLoginDate", PlayerInfo[ playerid ][ pDateLastLogin ] );
        cache_get_field_content( 0, "eMail", PlayerInfo[ playerid ][ pEmail ] );
        cache_get_field_content( 0, "IPRegister", PlayerInfo[ playerid ][ pIPRegister ] );
        cache_get_field_content( 0, "GPS", temp ), PlayerInfo[ playerid ][ pGPS ]                               = strval( temp );
        cache_get_field_content( 0, "Telephone", temp ), PlayerInfo[ playerid ][ pTelephone ]                   = strval( temp );
        cache_get_field_content( 0, "PhoneNumber", temp ), PlayerInfo[ playerid ][ pPhoneNumber ]               = strval( temp );
        cache_get_field_content( 0, "PhoneBook", temp ), PlayerInfo[ playerid ][ pPhoneBook ]                   = strval( temp );
        cache_get_field_content( 0, "CarJackerSkill", temp ), PlayerInfo[ playerid ][ pCarJackerSkill ]         = strval( temp );
        cache_get_field_content( 0, "CarJackerTime", temp ), PlayerInfo[ playerid ][ pCarJackerTime ]           = strval( temp );
        cache_get_field_content( 0, "BusDriverSkill", temp ), PlayerInfo[ playerid ][ pBusDriverSkill ]         = strval( temp );
        cache_get_field_content( 0, "BusDriverTime", temp ), PlayerInfo[ playerid ][ pBusDriverTime ]           = strval( temp );
        cache_get_field_content( 0, "FreePoints", temp ), PlayerInfo[ playerid ][ pFreePoints ]                 = strval( temp );
        cache_get_field_content( 0, "CarKey1", temp ), PlayerInfo[ playerid ][ pCarKey1 ]                       = strval( temp );
        cache_get_field_content( 0, "CarKey2", temp ), PlayerInfo[ playerid ][ pCarKey2 ]                       = strval( temp );
        cache_get_field_content( 0, "CarKey3", temp ), PlayerInfo[ playerid ][ pCarKey3 ]                       = strval( temp );
        cache_get_field_content( 0, "RobPoints", temp ), PlayerInfo[ playerid ][ pRobPoints ]                   = strval( temp );
        cache_get_field_content( 0, "GunoierTime", temp ), PlayerInfo[ playerid ][ pGunoierTime ]               = strval( temp );
        cache_get_field_content( 0, "FightStyle", temp ), PlayerInfo[ playerid ][ pFightStyle ]                 = strval( temp );
        cache_get_field_content( 0, "PlayerConnected", temp ), PlayerInfo[ playerid ][ pPlayerConnected ]       = strval( temp );
        cache_get_field_content( 0, "NewsTime", temp ), PlayerInfo[ playerid ][ pNewsTime ]                     = strval( temp );
        cache_get_field_content( 0, "WalkieTalkie", temp ), PlayerInfo[ playerid ][ pWalkieTalkie ]             = strval( temp );
        cache_get_field_content( 0, "Freqvence", temp ), PlayerInfo[ playerid ][ pFreqvence ]                   = strval( temp );
        cache_get_field_content( 0, "NMuted", temp ), PlayerInfo[ playerid ][ pNMuted ]                         = strval( temp );
        cache_get_field_content( 0, "PizzaBoyTime", temp ), PlayerInfo[ playerid ][ pPizzaBoyTime ]             = strval( temp );
        cache_get_field_content( 0, "CementTruckerTime", temp ), PlayerInfo[ playerid ][ pCementTruckerTime ]   = strval( temp );
        cache_get_field_content( 0, "RWKills", temp ), PlayerInfo[ playerid ][ pRWKills ]                       = strval( temp );
        cache_get_field_content ( 0 , "RWDeaths" , temp ) , PlayerInfo[ playerid ][ pRWDeaths ]                 = strval ( temp ) ;
        cache_get_field_content ( 0 , "FInvite" , PlayerInfo [ playerid ] [ pFInvite ] ) ;
        cache_get_field_content ( 0 , "FPTime" , temp ) , PlayerInfo [ playerid ] [ pFPTime ]                   = strval ( temp ) ;
        cache_get_field_content ( 0 , "PayDay" , temp ) , PlayerInfo [ playerid ] [ pPayDay ]                   = strval ( temp ) ;
        cache_get_field_content ( 0 , "ReferralName" , PlayerInfo [ playerid ] [ pReferralName ] ) ;
        cache_get_field_content ( 0 , "ReferralMoneys" , temp ) , PlayerInfo [ playerid ] [ pReferralMoneys ]   = strval ( temp ) ;
        cache_get_field_content ( 0 , "ReferralRespect" , temp ) , PlayerInfo [ playerid ] [ pReferralRespect ] = strval ( temp ) ;
        cache_get_field_content ( 0 , "WantedDownTime" , temp ) , PlayerInfo [ playerid ] [ pWantedDownTime ]   = strval ( temp ) ;
        cache_get_field_content ( 0 , "NONAFKTime" , temp ) , PlayerInfo [ playerid ] [ pNONAFKTime ]           = strval ( temp ) ;
        cache_get_field_content ( 0 , "JobHours" , temp ) , PlayerInfo [ playerid ] [ pJobHours ]               = strval ( temp ) ;
        cache_get_field_content ( 0 , "Laptop" , temp ) , PlayerInfo [ playerid ] [ pLaptop ]                   = strval ( temp ) ;
        cache_get_field_content ( 0 , "BestAtWAR" , temp ) , PlayerInfo [ playerid ] [ pBestAtWAR ]             = strval ( temp ) ;
        cache_get_field_content ( 0 , "WrostAtWAR" , temp ) , PlayerInfo [ playerid ] [ pWrostAtWAR ]           = strval ( temp ) ;
        cache_get_field_content ( 0 , "SantaHat" , temp ) , PlayerInfo [ playerid ] [ pSantaHat ]               = strval ( temp ) ;
        cache_get_field_content ( 0 , "BestAtPaintBall" , temp ) , PlayerInfo [ playerid ] [ pBestAtPaintBall ] = strval ( temp ) ;
        cache_get_field_content ( 0 , "NewUser" , temp ) , PlayerInfo [ playerid ] [ pNewUser ]                 = strval ( temp ) ;
        cache_get_field_content ( 0 , "MinuteOnline" , temp ) , PlayerInfo [ playerid ] [ pMinuteOnline ]       = strval ( temp ) ;
        cache_get_field_content ( 0 , "LottoNumber" , temp ) , PlayerInfo [ playerid ] [ pLottoNumber ]         = strval ( temp ) ;
        cache_get_field_content ( 0 , "LottoNumber2" , temp ) , PlayerInfo [ playerid ] [ pLottoNumber2 ]       = strval ( temp ) ;
        cache_get_field_content ( 0 , "RaceTime" , temp ) , PlayerInfo [ playerid ] [ pRaceTime ]               = strval ( temp ) ;
        cache_get_field_content ( 0 , "ClanMember" , temp ) , PlayerInfo [ playerid ] [ pClanMember ]           = strval ( temp ) ;
        cache_get_field_content ( 0 , "ClanLeader" , temp ) , PlayerInfo [ playerid ] [ pClanLeader ]           = strval ( temp ) ;
        cache_get_field_content ( 0 , "LastName" , PlayerInfo [ playerid ] [ pLastName ] ) ;
        cache_get_field_content ( 0 , "ArmsDealerSkill" , temp ) , PlayerInfo [ playerid ] [ pArmsDealerSkill ] = strval ( temp ) ;
    }

    AFKLoggin [ playerid ] = -1 ;
    format( string, sizeof( string ), ""GALBEN"Last login on the server: "ROSU2"%s", PlayerInfo[ playerid ][ pDateLastLogin ] );
    SCM( playerid, -1, string );
    format ( gString , sizeof ( gString ) , "%s" , PlayerInfo [ playerid ] [ pDateLastLogin ] ) ;
    LaptopLastLoginDate [ playerid ] = gString ;
    format( string, sizeof( string ), "%s", FormatRoDate( gettime( ) ) );
    PlayerInfo[ playerid ][ pDateLastLogin ] = string;
    format(SQLString, sizeof(SQLString), "UPDATE `users` SET `LastLoginDate` = '%s' WHERE `UserName` = '%s'", PlayerInfo[ playerid ][ pDateLastLogin ], PlayerName( playerid ) );
    mysql_function_query(gHandle, SQLString, false, "SendQuery", "");
   
    format ( string , sizeof ( string ) , ""CREM"You are a member %s since "ROSU2"%s" , FactionInfo [ PlayerInfo [ playerid ] [ pMemberFaction ] ] [ fName ] , PlayerInfo [ playerid ] [ pFInvite ] ) ;
    SCM ( playerid , -1 , string ) ;
   
    if( FactionInfo[ PlayerInfo[ playerid ][ pMemberFaction ] ][ fInWar ] == 1 ) {
        format ( string , sizeof ( string ) , ""ALBASTRU"Your faction (%s) it is in a territorial battle (Turf %d). Time remaining: %d." , FactionInfo [ PlayerInfo [ playerid ] [ pMemberFaction ] ] [ fName ] , TurfInfo [ FactionInfo[ PlayerInfo[ playerid ][ pMemberFaction ] ][ fTurfAtacked ] ] [ tSQLid ] + 1 , FactionInfo [ PlayerInfo [ playerid ] [ pMemberFaction ] ] [ fWarTime ] );
        SCM( playerid , -1 , string );
        format ( string, sizeof( string ), "%s - %d points", FactionInfo[ PlayerInfo[ playerid ][ pMemberFaction ] ][ fName ], FactionInfo[ PlayerInfo[ playerid ][ pMemberFaction ] ][ fWarScore ] );
        TextDrawSetString ( TextdrawRivalWar [ playerid ] [ 0 ] , string );
        TextDrawShowForPlayer ( playerid , TextdrawRivalWar [ playerid ] [ 0 ] );
        format ( string , sizeof ( string ) , "Time remaing: %d minutes", FactionInfo [ PlayerInfo [ playerid ] [ pMemberFaction ] ] [ fWarTime ] );
        TextDrawSetString ( TextdrawRivalWar [ playerid ] [ 1 ]  , string );
        TextDrawShowForPlayer ( playerid , TextdrawRivalWar [ playerid ] [ 1 ] );
        PlayerOnTurf [ playerid ] = 60 ;
    }
   
    if(PlayerInfo[playerid][pAcceptedMember] == 1) {
        PlayerInfo[playerid][pMemberFaction] = 0;
        PlayerInfo[playerid][pRank] = 0;
        PlayerInfo[playerid][pSkin] = FactionInfo[0][fSkinRank][5];
        PlayerInfo[playerid][pAcceptedMember] = 0;
        format(SQLString, sizeof(SQLString), "UPDATE `users` SET `AcceptedMember` = '%d', `MemberFaction' = %d, `Rank` = '%d', `Skin` = '%d' WHERE `UserName` = '%s'",
            PlayerInfo[playerid][pAcceptedMember],
            PlayerInfo[playerid][pMemberFaction],
            PlayerInfo[playerid][pRank],
            PlayerInfo[playerid][pSkin],
            PlayerName( playerid )
        );
        mysql_function_query(gHandle, SQLString, false, "SendQuery", "");
    }
    PlayerInfo[ playerid ][ pDriverLicense ] = 1;
    format( SQLString, sizeof( SQLString ), "UPDATE SET `DriverLicense` = '1'");
    mysql_function_query( gHandle, SQLString, false, "SendQuery", "" );
    gPlayerLogged[playerid] = 1;
    PlayerInfo[ playerid ][ pPlayerConnected ] = 1;
    format( SQLString, sizeof( SQLString ), "UPDATE `users` SET `PlayerConnected` = '1' WHERE `UserName` = '%s'", PlayerName( playerid ) );
    mysql_function_query( gHandle, SQLString, false, "SendQuery", "" );
   
    if( PlayerInfo[ playerid ][ pRentHouse ] == 0 ) {
        PlayerInfo[ playerid ][ pRentHouse ] = MAX_HOUSES;
        format( SQLString, sizeof( SQLString ), "UPDATE `users` SET `RentHouse` = '%d' WHERE `UserName` = '%s'",
            PlayerInfo[ playerid ][ pRentHouse ],
            PlayerName( playerid )
        );
        mysql_function_query( gHandle, SQLString, false, "SendQuery", "" );
    }
    if( PlayerInfo[ playerid ][ pPhoneNumber ] == 0 ) {
        new
            PhNumber = 1000 + random( 8999 );
        PlayerInfo[ playerid ][ pPhoneNumber ] = PhNumber;
        format( SQLString, sizeof( SQLString ), "UPDATE `users` SET `PhoneNumber` = '%d' WHERE `UserName` = '%s'",
            PlayerInfo[ playerid ][ pPhoneNumber ],
            PlayerName( playerid )
        );
        mysql_function_query( gHandle, SQLString, false, "SendQuery", "" );
    }
    if( PlayerInfo[ playerid ][ pFightStyle ] == 0 ) {
        SetPlayerFightingStyle( playerid, FIGHT_STYLE_NORMAL );
    }
    else if( PlayerInfo[ playerid ][ pFightStyle ] == 1 ) {
        SetPlayerFightingStyle( playerid, FIGHT_STYLE_BOXING );
    }
    else if( PlayerInfo[ playerid ][ pFightStyle ] == 2 ) {
        SetPlayerFightingStyle( playerid, FIGHT_STYLE_KUNGFU );
    }
    else if( PlayerInfo[ playerid ][ pFightStyle ] == 3 ) {
        SetPlayerFightingStyle( playerid, FIGHT_STYLE_KNEEHEAD );
    }
    else if( PlayerInfo[ playerid ][ pFightStyle ] == 4 ) {
        SetPlayerFightingStyle( playerid, FIGHT_STYLE_GRABKICK );
    }
    else if( PlayerInfo[ playerid ][ pFightStyle ] == 5 ) {
        SetPlayerFightingStyle( playerid, FIGHT_STYLE_ELBOW );
    }

    if( PlayerInfo[ playerid ][ pMemberFaction ] > 0 ) {
        format( string, sizeof( string ), ""GALBEN"[Group]: Member %s(%d) rank %d has connected to the server.", PlayerName( playerid ), playerid, PlayerInfo[ playerid ][ pRank ] );
        FactionMessage( PlayerInfo[ playerid ][ pMemberFaction ], -1, string );
    }

    if( PlayerInfo[ playerid ][ pAdminLevel ] > 0 ) {
        format( string, sizeof( string ), ""GALBEN"[STAFF INFO]: Admin %s(%d) level %d has connected to the server.", PlayerName( playerid ), playerid, PlayerInfo[ playerid ][ pAdminLevel ] );
        AdminsMessage( -1, string );
    }
    if( PlayerInfo[ playerid ][ pHelperLevel ] > 0 ) {
        format( string, sizeof( string ), ""GALBEN"[STAFF INFO]: Helper %s(%d) level %d has connected to the server.", PlayerName( playerid ), playerid, PlayerInfo[ playerid ][ pHelperLevel ] );
        AdminsMessage( -1, string );
    }
   
    if( strlen( FactionInfo[ PlayerInfo[ playerid ][ pMemberFaction ] ][ fAnunt ] ) > 0 ) {
        format( string, sizeof( string ), ""GALBEN"Family: (%s).", FactionInfo[ PlayerInfo[ playerid ][ pMemberFaction ] ][ fAnunt ] );
        SCM( playerid, -1, string );
    }


    TextDrawShowForPlayer( playerid, TextdrawClock[ 0 ] );
    TextDrawShowForPlayer( playerid, TextdrawClock[ 1 ] );
   
    format ( string, sizeof ( string ), "~w~WELCOME ~b~%s", PlayerName ( playerid ) );
    GameTextForPlayer ( playerid, string, 5000, 1 );
    TogglePlayerControllable ( playerid , true ) ;
    StopAudioStreamForPlayer ( playerid ) ;
    //PlayerMarkerOnTurf ( playerid ) ;
   
    if ( PlayerInfo [ playerid ] [ pWantedLevel ] > 0 ) {
        SetPlayerWantedLevel ( playerid , PlayerInfo [ playerid ] [ pWantedLevel ] ) ;
    }

    if( PlayerInfo[ playerid ][ pJailTime ] > 0 ) {
        SetPlayerWantedLevel( playerid, 0 );
        PlayerInfo[ playerid ][ pWantedLevel ] = 0;
        SCM(playerid, -1, ""GRI"Back to jail");
        PlayerInfo [ playerid ] [ pWantedDownTime ] = 0 ;

        SetPlayerVirtualWorld( playerid, 1 );
        SetPlayerInterior( playerid, 0 );
        TogglePlayerControllable( playerid, true );
        ResetPlayerWeaponsEx( playerid );
        TextDrawShowForPlayer( playerid, TextdrawJailTime[ playerid ] );
       
        PlayerInterior [ playerid ] [ 0 ] = MAX_HOUSES ;
        PlayerInterior [ playerid ] [ 1 ] = MAX_BUSSINESS ;
        PlayerInterior [ playerid ] [ 2 ] = MAX_FACTIONS ;
        PlayerInterior [ playerid ] [ 3 ] = 0 ;
        PlayerInterior [ playerid ] [ 4 ] = 0 ;
        PlayerInterior [ playerid ] [ 5 ] = 0 ;
        PlayerInterior [ playerid ] [ 6 ] = 0 ;

        SetSpawnInfo( playerid, 4, PlayerInfo[ playerid ][ pSkin ], -9.2413,1528.8455,-27.2323, 0, 0, 0, 0, 0, 0, 0 );
       
        SpawnPlayer( playerid );
        return 1;
    }
    if ( FactionInfo [ PlayerInfo [ playerid ] [ pMemberFaction ] ] [ fInWar ] == 1 ) {
        SetSpawnInfo ( playerid , 4 , PlayerInfo [ playerid ] [ pSkin ] , FactionInfo [ PlayerInfo [ playerid ] [ pMemberFaction ] ] [ fHQIesire ] [ 0 ] , FactionInfo [ PlayerInfo [ playerid ] [ pMemberFaction ] ] [ fHQIesire ] [ 1 ] , FactionInfo [ PlayerInfo [ playerid ] [ pMemberFaction ] ] [ fHQIesire ] [ 2 ] , 0 , 0 , 0 , 0 , 0 , 0 , 0 );
        SetPlayerInterior ( playerid , FactionInfo [ PlayerInfo [ playerid ] [ pMemberFaction ] ] [ fHQInterior ] );
        SetPlayerVirtualWorld ( playerid, FactionInfo [ PlayerInfo [ playerid ] [ pMemberFaction ] ] [ fHQVirtualWorld ] );

        PlayerInterior [ playerid ] [ 0 ] = MAX_HOUSES ;
        PlayerInterior [ playerid ] [ 1 ] = MAX_BUSSINESS ;
        if ( PlayerInfo [ playerid ] [ pMemberFaction ] > 0 ) {
            PlayerInterior [ playerid ] [ 2 ] = PlayerInfo [ playerid ] [ pMemberFaction ] ;
        }
        if ( PlayerInfo [ playerid ] [ pMemberFaction ] < 1 ) {
            PlayerInterior [ playerid ] [ 2 ] = MAX_FACTIONS ;
        }
        PlayerInterior [ playerid ] [ 3 ] = 0 ;
        PlayerInterior [ playerid ] [ 4 ] = 0 ;
        PlayerInterior [ playerid ] [ 5 ] = 0 ;
        PlayerInterior [ playerid ] [ 6 ] = 0 ;
       
        SpawnPlayer( playerid );
        return 1;
    }
pawn Код:
mysql_function_query( gHandle, SQLString, false, "SendQuery", "" );

        format( SQLString, sizeof( SQLString ), "UPDATE `users` SET `DriverLicense` = '%d', `PilotsLicense` = '%d', `BoatLicense` = '%d', `FishLicense` = '%d', `GunsLicense` = '%d', `Skin` = '%d', `Register` = '%d', `AcceptedMember` = '%d', `FWarn` = '%d' WHERE `UserName` = '%s'",
            PlayerInfo[ playerid ][ pDriverLicense ],
            PlayerInfo[ playerid ][ pPilotsLicense ],
            PlayerInfo[ playerid ][ pBoatLicense ],
            PlayerInfo[ playerid ][ pFishLicense ],
            PlayerInfo[ playerid ][ pGunsLicense ],
            PlayerInfo[ playerid ][ pSkin ],
            PlayerInfo[ playerid ][ pRegister ],
            PlayerInfo[ playerid ][ pAcceptedMember ],
            PlayerInfo[ playerid ][ pFWarn ],
            PlayerName( playerid )
        );
pawn Код:
public OnPlayerEnterRaceCheckpoint(playerid)
{
    new string[ 128 ];
    if( RCP[ playerid ] == 1 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 815.5944,-1407.9951,12.9747, 1038.8373,-1408.1396,12.9113, 3 );
        RCP[ playerid ] = 2;
    }
    else if( RCP[ playerid ] == 2 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1038.8373,-1408.1396,12.9113, 1193.4873,-1436.7834,13.0141, 3 );
        RCP[ playerid ] = 3;
    }
    else if( RCP[ playerid ] == 3 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1193.4873,-1436.7834,13.0141, 1215.0642,-1574.7374,13.0959, 3 );
        RCP[ playerid ] = 4;
    }
    else if( RCP[ playerid ] == 4 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1215.0642,-1574.7374,13.0959, 1294.4337,-1629.0203,13.0882, 3 );
        RCP[ playerid ] = 5;
    }
    else if( RCP[ playerid ] == 5 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1294.4337,-1629.0203,13.0882, 1330.7059,-1855.8740,13.0905, 3 );
        RCP[ playerid ] = 6;
    }
    else if( RCP[ playerid ] == 6 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1330.7059,-1855.8740,13.0905, 1526.5876,-1875.0485,13.0910, 3 );
        RCP[ playerid ] = 7;
    }
    else if( RCP[ playerid ] == 7 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1526.5876,-1875.0485,13.0910, 1571.9395,-1824.5236,13.0881, 3 );
        RCP[ playerid ] = 8;
    }
    else if( RCP[ playerid ] == 8 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1571.9395,-1824.5236,13.0881, 1656.5402,-1734.1147,13.0882, 3 );
        RCP[ playerid ] = 9;
    }
    else if( RCP[ playerid ] == 9 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1656.5402,-1734.1147,13.0882, 1691.5813,-1622.0455,13.0882, 3 );
        RCP[ playerid ] = 10;
    }
    else if( RCP[ playerid ] == 10 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1691.5813,-1622.0455,13.0882, 1905.4241,-1615.5610,13.0882, 3 );
        RCP[ playerid ] = 11;
    }
    else if( RCP[ playerid ] == 11 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1905.4241,-1615.5610,13.0882, 2031.6729,-1754.8744,13.0882, 3 );
        RCP[ playerid ] = 12;
    }
    else if( RCP[ playerid ] == 12 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 2031.6729,-1754.8744,13.0882, 2050.4148,-1809.4072,13.0881, 3 );
        RCP[ playerid ] = 13;
    }
    else if( RCP[ playerid ] == 13 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 2050.4148,-1809.4072,13.0881, 1964.1792,-1770.8026,13.0881, 3 );
        RCP[ playerid ] = 14;
    }
    else if( RCP[ playerid ] == 14 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1964.1792,-1770.8026,13.0881, 1944.4471,-1720.5701,13.0939, 3 );
        RCP[ playerid ] = 15;
    }
    else if( RCP[ playerid ] == 15 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1944.4471,-1720.5701,13.0939, 1824.7908,-1587.7555,13.0640, 3 );
        RCP[ playerid ] = 16;
    }
    else if( RCP[ playerid ] == 16 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1824.7908,-1587.7555,13.0640, 1803.6588,-1455.4504,13.0610, 3 );
        RCP[ playerid ] = 17;
    }
    else if( RCP[ playerid ] == 17 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1803.6588,-1455.4504,13.0610, 1451.7598,-1462.6648,13.0738, 3 );
        RCP[ playerid ] = 18;
    }
    else if( RCP[ playerid ] == 18 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1451.7598,-1462.6648,13.0738, 1332.6088,-1571.7007,13.0620, 3 );
        RCP[ playerid ] = 19;
    }
    else if( RCP[ playerid ] == 19 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1332.6088,-1571.7007,13.0620, 1308.7736,-1393.0870,12.9880, 3 );
        RCP[ playerid ] = 20;
    }
    else if( RCP[ playerid ] == 20 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 1308.7736,-1393.0870,12.9880, 915.2963,-1426.6416,12.9756, 3 );
        RCP[ playerid ] = 21;
    }
    else if( RCP[ playerid ] == 21 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 0, 915.2963,-1426.6416,12.9756, 855.1624,-1527.6810,13.0527, 3 );
        RCP[ playerid ] = 22;
    }
    else if( RCP[ playerid ] == 22 ) {
        DisablePlayerRaceCheckpoint( playerid );
        SetPlayerRaceCheckpoint( playerid, 1, 855.1624,-1527.6810,13.0527, 855.1624,-1527.6810,13.0527, 3 );
        RCP[ playerid ] = 23;
    }
    else if( RCP[ playerid ] == 23 ) {
        DisablePlayerRaceCheckpoint( playerid );
        RCP[ playerid ] = 0;
        PlayerInfo[ playerid ][ pCash ] -= 3000;
        PlayerInfo[ playerid ][ pDriverLicense ] = 1;
        DriversSchool[ playerid ] = false;
        SetVehicleToRespawn( GetPlayerVehicleID( playerid ) );
        SCM( playerid, -1, ""ALBASTRU"Felicitari, ai reusit sa obtii permisul de conducere !" );
        SCM( playerid, -1, ""GRI"Mult succes mai departe !" );
        format( SQLString, sizeof( SQLString ), "UPDATE `users` SET `Cash` = '%d', `DriverLicense` = '1' WHERE `UserName` = '%s'", PlayerInfo[ playerid ][ pCash ], PlayerName( playerid ) );
        mysql_function_query( gHandle, SQLString, false, "SendQuery", "" );
Reply
#2

Bump
Reply
#3

can you show me your onplayerconnect or something that call the OnAccountLoad

edit:
for the Driver lisence error, replace your code from
pawn Код:
//
    PlayerInfo[ playerid ][ pDriverLicense ] = 1;
    format( SQLString, sizeof( SQLString ), "UPDATE SET `DriverLicense` = '1'");
    mysql_function_query( gHandle, SQLString, false, "SendQuery", "" );
become

pawn Код:
//
    PlayerInfo[ playerid ][ pDriverLicense ] = 1;
    format( SQLString, sizeof( SQLString ), "UPDATE `users` SET `DriverLicense` = '1'");
    mysql_function_query( gHandle, SQLString, false, "SendQuery", "" );
Reply
#4

Thanks For reply , i will Test it if work

this is OnPlayersconnect

pawn Код:
/*==============================================================================
                            OnPlayerConnect(playerid)
==============================================================================*/

public OnPlayerConnect(playerid)
{
   
    SetPlayerColor( playerid, 0xFFFFFFFF );
    SetPVarInt(playerid, "bID", -1);
    BigEars[playerid] = 0;
   
    /*RemoveBuildingForPlayer( playerid, 1302, 0.0, 0.0, 0.0, 6000.0 );
    RemoveBuildingForPlayer( playerid, 1209, 0.0, 0.0, 0.0, 6000.0 );
    RemoveBuildingForPlayer( playerid, 955, 0.0, 0.0, 0.0, 6000.0 );
    RemoveBuildingForPlayer( playerid, 956, 0.0, 0.0, 0.0, 6000.0 );
    RemoveBuildingForPlayer( playerid, 1775, 0.0, 0.0, 0.0, 6000.0 );
    RemoveBuildingForPlayer( playerid, 1776, 0.0, 0.0, 0.0, 6000.0 );
    RemoveBuildingForPlayer( playerid, 1977, 0.0, 0.0, 0.0, 6000.0 );*/


    gPlayerLogTries[playerid]           = 0;
    gPlayerLogged[playerid]             = 0;
    CP[playerid]                        = 0;
    RCP[playerid]                       = 0;
    WantedSala[playerid]                = 0;
    Justadvertise[playerid]             = 0;
    WithdrawSuma[playerid]              = 0;
    PlayerCuffed[playerid]              = 0;
    FishingTool[ playerid ]             = 0;
    FishingWorms[ playerid ]            = 0;
    IsFishing[ playerid ]               = 0;
    TotalFish[ playerid ]               = 0;
    FishesWeight[ playerid ]            = 0;
    AlimentareMasina[ playerid ]        = 0;
    BackUpCOP[ playerid ]               = 0;
    GPSOn[ playerid ]                   = 0;
    UsedTelephone[ playerid ]           = 499;
    FireTigari[ playerid ]              = 0;
    NChatTime[ playerid ]               = 0;
    ReportTime[ playerid ]              = 0;
    HelpTime[ playerid ]                = 0;
    TintaID[ playerid ]                 = 499;
    AsasinID[ playerid ]                = 499;
    FactionsID[ playerid ]              = MAX_FACTIONS;
    LocationType[ playerid ]            = 0;
    TotalPaintKills[ playerid ]         = 0;
    IDVehicleRented[ playerid ]         = 0;
    IDPlaneRented[ playerid ]           = 0;
    SpecPlayer[ playerid ]              = 499;
    COPTicket[ playerid ]               = 0;
    PretVanzareMasina[ playerid ]       = 0;
    VehicleSell[ playerid ]             = 0;
    PayTime[ playerid ]                 = 0;
    CantitateDrugs [ playerid ]         = 0;
    PriceDrugs [ playerid ]             = 0;
    SellDrugsTime [ playerid ]          = 0;
    UsedDrugsTime [ playerid ]          = 0;
    VPersSpawned [ playerid ]           = MAX_PERSONALCARS;
    GunGameTeam [ playerid ]            = 0 ;
    GunGameKills [ playerid ]           = 0 ;
    GunGameSkill [ playerid ]           = 0 ;
    FindCarTime [ playerid ]            = 0 ;
    PlayerInterior [ playerid ] [ 0 ]   = MAX_HOUSES ; // Player aflat in casa
    PlayerInterior [ playerid ] [ 1 ]   = MAX_BUSSINESS ; // Player aflat in biz
    PlayerInterior [ playerid ] [ 2 ]   = MAX_FACTIONS ; // Player aflat in HQ / TR
    PlayerInterior [ playerid ] [ 3 ]   = 0 ; // Player aflat la paint
    PlayerInterior [ playerid ] [ 4 ]   = 0 ; // Player aflat la gungame
    PlayerInterior [ playerid ] [ 5 ]   = 0 ; // Player aflat in Crack House
    PlayerInterior [ playerid ] [ 6 ]   = 0 ; // Player aflat in primarie
    FindPlayer [ playerid ]             = -1 ;
    TaxiCallAccepted [ playerid ]       = -1 ;
    PlayerOnTurf [ playerid ]           = 0 ;
    CarMechanicFuel [ playerid ]        = 0 ;
    CarMechanicRepair [ playerid ]      = 0 ;
    PlayerIsDeath [ playerid ]          = 0 ;
    AnimationTime [ playerid ]          = 0 ;
    JoypadTest [ playerid ]             = 0 ;
    JoypadDetection [ playerid ]        = 0 ;
    SlotUSED [ playerid ]               = -1 ;
    VSellCarTo [ playerid ] [ 0 ]       = 0 ;
    VSellCarTo [ playerid ] [ 1 ]       = 0 ;
    MaterialsSell [ playerid ] [ 0 ]    = 0 ;
    MaterialsSell [ playerid ] [ 1 ]    = 0 ;
    PlayerDrunk [ playerid ]            = 0 ;
    UnjailPrice [ playerid ]            = 0 ;
    LiveON [ playerid ]                 = -1 ;
    COPRadar [ playerid ]               = -1 ;
    EnterCarHack [ playerid ]           = 0 ;
    EnterCarTime [ playerid ]           = 0 ;
    DeathTime [ playerid ]              = 0 ;
    TeleportHack [ playerid ]           = 0 ;
    AFKLoggin [ playerid ]              = 25 ;
    MechanicTime [ playerid ]           = 0 ;
    BadRCONLogin [ playerid ]           = 0 ;
    SpamCount [ playerid ]              = 0 ;
    Dicem     [ playerid ]              = 999 ;
    Diceid    [ playerid ]              = 999 ;
    SwatON[ playerid ]                  = false;
    FactionRope[ playerid ]             = false;
    PlayerTied[ playerid ]              = false;
    Zaruri[ playerid ]                  = false;
    Bricheta[ playerid ]                = false;
    AFKPlayer[ playerid ]               = false;
    LaptopHitman[ playerid ]            = false;
    BusDriverON[ playerid ]             = false;
    ChangeSkin[ playerid ]              = false;
    HitmanUndercover[ playerid ]        = false;
    Robbing[ playerid ]                 = false;
    DriversSchool[ playerid ]           = false;
    GunoierON[ playerid ]               = false;
    ComandaTaxi[ playerid ]             = false;
    FactionInvited[ playerid ]          = false;
    EnterLSPD[ playerid ]               = false;
    PlayerAtPaint[ playerid ]           = false;
    PlayerPaused[ playerid ]            = false;
    AdminDuty[ playerid ]               = false;
    AdminInSpectate[ playerid ]         = false;
    TaxiDuty[ playerid ]                = false;
    PlayerAmendat[ playerid ]           = false;
    CumparareMasina[ playerid ]         = false;
    PizzaBoyON[ playerid ]              = false;
    CementTruckerON[ playerid ]         = false;
    TurfsView[ playerid ]               = false;
    PlayerTicket [ playerid ]           = false ;
    SpectatePVehicle [ playerid ]       = false ;
    CarIcon [ playerid ]                = false ;
    LiveInvited [ playerid ]            = false ;
    SpawnChange [ playerid ]            = false ;
    PlayerLaptop [ playerid ]           = false ;
    SantaUse [ playerid ]               = false ;
    ColorAdmin [ playerid ]             = false ;
    EventOrganizer [ playerid ]         = false ;
    EventRequest [ playerid ]           = false ;
    LottoWinner [ playerid ]            = false ;
    RaceBuilder [ playerid ]            = false ;
    CommandsBlock [ playerid ]          = false ;
   
    TogInfo[ playerid ][ tTelephone ]   = false;
    TogInfo[ playerid ][ tDepartment ]  = false;
    TogInfo[ playerid ][ tRadio ]       = false;
    TogInfo[ playerid ][ tFamily ]      = false;
    TogInfo[ playerid ][ tLeaders ]     = false;
    TogInfo[ playerid ][ tAdmins ]      = false;
    TogInfo[ playerid ][ tHelpers ]     = false;
    TogInfo[ playerid ][ tWhisper ]     = false;
    TogInfo[ playerid ][ tNewbies ]     = false;

    PlayerInfo [ playerid ] [ pAdminLevel ]         = 0;
    PlayerInfo [ playerid ] [ pHelperLevel ]        = 0;
    PlayerInfo [ playerid ] [ pMemberFaction ]      = 0;
    PlayerInfo [ playerid ] [ pLeaderFaction ]      = 0;
    PlayerInfo [ playerid ] [ pRank ]               = 0;
    PlayerInfo [ playerid ] [ pWantedLevel ]        = 0;
    PlayerInfo [ playerid ] [ pJailTime ]           = 0;
    PlayerInfo [ playerid ] [ pValoareContract ]    = 0;
    PlayerInfo [ playerid ] [ pHouseKey ]           = MAX_HOUSES;
    PlayerInfo [ playerid ] [ pRentHouse ]          = MAX_HOUSES;
    PlayerInfo [ playerid ] [ pBizKey ]             = MAX_BUSSINESS;
    PlayerInfo [ playerid ] [ pCarKey1 ]            = MAX_PERSONALCARS;
    PlayerInfo [ playerid ] [ pCarKey2 ]            = MAX_PERSONALCARS;
    PlayerInfo [ playerid ] [ pCarKey3 ]            = MAX_PERSONALCARS;
    PlayerInfo [ playerid ] [ pWantedDownTime ]     = 0 ;
    PlayerInfo [ playerid ] [ pRWKills ]            = 0 ;
    PlayerInfo [ playerid ] [ pRWDeaths ]           = 0 ;
   
    RaceBuilderInfo [ playerid ] [ rbEditor ]       = 0 ;
    RaceBuilderInfo [ playerid ] [ rbCreateCP ]     = 0 ;
   
    PRaceInfo [ playerid ] [ prCheckpoint ]         = 0 ;
    PRaceInfo [ playerid ] [ prRaceLaps ]           = 0 ;
    PRaceInfo [ playerid ] [ prRaceTime ]           = 0 ;
    PRaceInfo [ playerid ] [ prIsReady ]            = 0 ;
    PRaceInfo [ playerid ] [ prAtRace ]             = 0 ;
   
    WeaponData [ playerid ] [ 0 ] = false ; WeaponData [ playerid ] [ 1 ] = false ; WeaponData [ playerid ] [ 2 ] = false ; WeaponData [ playerid ] [ 3 ] = false ;
    WeaponData [ playerid ] [ 4 ] = false ; WeaponData [ playerid ] [ 5 ] = false ; WeaponData [ playerid ] [ 6 ] = false ; WeaponData [ playerid ] [ 7 ] = false ;
    WeaponData [ playerid ] [ 8 ] = false ; WeaponData [ playerid ] [ 9 ] = false ; WeaponData [ playerid ] [ 10 ] = false ; WeaponData [ playerid ] [ 11 ] = false ; WeaponData [ playerid ] [ 12 ] = false ;

    //CheckAccount(playerid);
Reply
#5

I tested no lag now with cars Thanks , mm is have Lag when i go DealerShip or i go Biz / HQ LSPD.. [lag i see all players AFK]

and in Mysql_Log

Код:
[12:16:47] [ERROR] CMySQLQuery::Execute[LoadedObjects] - (error #1146) Table 'samp_samp.objects' doesn't exist
[12:23:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("DisableTime")
[12:23:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CarJackerTime")
[12:23:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BusDriverTime")
[12:23:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GunoierTime")
[12:23:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("PizzaBoyTime")
[12:23:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CementTruckerTime")
[12:35:08] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'CarJackerTime' in 'field list'
[12:35:08] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'GunoierTime' in 'field list'
[12:40:50] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'CarJackerTime' in 'field list'
[12:40:50] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'GunoierTime' in 'field list'
i go Example this Screen :

Reply
#6

Quote:
Originally Posted by KingPersona
Посмотреть сообщение
I tested no lag now with cars Thanks , mm is have Lag when i go DealerShip or i go Biz / HQ LSPD.. [lag i see all players AFK]

and in Mysql_Log

Код:
[12:16:47] [ERROR] CMySQLQuery::Execute[LoadedObjects] - (error #1146) Table 'samp_samp.objects' doesn't exist
[12:23:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("DisableTime")
[12:23:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CarJackerTime")
[12:23:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BusDriverTime")
[12:23:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GunoierTime")
[12:23:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("PizzaBoyTime")
[12:23:19] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CementTruckerTime")
[12:35:08] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'CarJackerTime' in 'field list'
[12:35:08] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'GunoierTime' in 'field list'
[12:40:50] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'CarJackerTime' in 'field list'
[12:40:50] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'GunoierTime' in 'field list'
i go Example this Screen :

Create a table named "objects" on your MySQL database
Reply
#7

Quote:
Originally Posted by AiRaLoKa
Посмотреть сообщение
Create a table named "objects" on your MySQL database
ok dude
Reply
#8

i created Table object , this
Код:
--
-- 
Table structure for table `objects`
--

CREATE TABLE IF NOT EXISTS `objects` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ModelID` int(11) NOT NULL,
  `PosX` float NOT NULL,
  `PosY` float NOT NULL,
  `PosZ` float NOT NULL,
  `RotX` float NOT NULL,
  `RotY` float NOT NULL,
  `RotZ` float NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
and i have again this Problem

Mysql_Log
Код:
[16:18:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("DisableTime")
[16:18:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CarJackerTime")
[16:18:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BusDriverTime")
[16:18:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GunoierTime")
[16:18:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("PizzaBoyTime")
[16:18:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CementTruckerTime")
[16:33:38] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'CarJackerTime' in 'field list'
[16:33:38] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'GunoierTime' in 'field list'
[16:38:22] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'CarJackerTime' in 'field list'
[16:38:22] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'GunoierTime' in 'field list'
Reply
#9

Quote:
Originally Posted by KingPersona
Посмотреть сообщение
i created Table object , this
Код:
--
-- 
Table structure for table `objects`
--

CREATE TABLE IF NOT EXISTS `objects` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ModelID` int(11) NOT NULL,
  `PosX` float NOT NULL,
  `PosY` float NOT NULL,
  `PosZ` float NOT NULL,
  `RotX` float NOT NULL,
  `RotY` float NOT NULL,
  `RotZ` float NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
and i have again this Problem

Mysql_Log
Код:
[16:18:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("DisableTime")
[16:18:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CarJackerTime")
[16:18:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BusDriverTime")
[16:18:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("GunoierTime")
[16:18:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("PizzaBoyTime")
[16:18:16] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CementTruckerTime")
[16:33:38] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'CarJackerTime' in 'field list'
[16:33:38] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'GunoierTime' in 'field list'
[16:38:22] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'CarJackerTime' in 'field list'
[16:38:22] [ERROR] CMySQLQuery::Execute[SendQuery] - (error #1054) Unknown column 'GunoierTime' in 'field list'
Search in gamemode for these names (one by one):
DisableTime, CarJackerTime, BusDriverTime, GunoierTime, PizzaBoyTime, CementTruckerTime

Then post me the query, so i can tell your what to do.
Reply
#10

Quote:
Originally Posted by icra
Посмотреть сообщение
Search in gamemode for these names (one by one):
DisableTime, CarJackerTime, BusDriverTime, GunoierTime, PizzaBoyTime, CementTruckerTime

Then post me the query, so i can tell your what to do.
this

pawn Код:
//*===================== stock LoadAccount(playerid) =========================*/

stock LoadAccount(playerid)
{
    format( SQLString, sizeof( SQLString ), "SELECT * FROM `users` WHERE `UserName` = '%s' LIMIT 1", PlayerName( playerid ) );
    mysql_function_query( gHandle, SQLString, true, "OnAccountLoad", "is", playerid, PlayerName( playerid ) );
}

/*==============================================================================
                            OnAccountLoad(playerid)
==============================================================================*/

forward OnAccountLoad ( playerid ) ;
public OnAccountLoad ( playerid ) {
    SetCameraBehindPlayer(playerid);
   
    new
        temp[64],
        string[ 128 ],
        rows,
        fields;
    cache_get_data( rows, fields );
    if(rows) {
        cache_get_field_content( 0, "Level", temp), PlayerInfo[ playerid ][ pLevel ]                            = strval( temp );
        cache_get_field_content( 0, "AdminLevel", temp ), PlayerInfo[ playerid ][ pAdminLevel ]                 = strval( temp );
        cache_get_field_content( 0, "HelperLevel", temp ), PlayerInfo[ playerid ][ pHelperLevel ]               = strval( temp );
        cache_get_field_content( 0, "LeaderFaction", temp ), PlayerInfo[ playerid ][ pLeaderFaction ]           = strval( temp );
        cache_get_field_content( 0, "MemberFaction", temp ), PlayerInfo[ playerid ][ pMemberFaction ]           = strval( temp );
        cache_get_field_content( 0, "Oras", temp ), PlayerInfo[ playerid ][ pOras ]                             = strval( temp );
        cache_get_field_content( 0, "Varsta", temp ), PlayerInfo[ playerid ][ pVarsta ]                         = strval( temp );
        cache_get_field_content( 0, "Sex", temp ), PlayerInfo[ playerid ][ pSex ]                               = strval( temp );
        cache_get_field_content( 0, "Cash", temp ), PlayerInfo[ playerid ][ pCash ]                             = strval( temp );
        cache_get_field_content( 0, "Bank", temp ), PlayerInfo[ playerid ][ pBank ]                             = strval( temp );
        cache_get_field_content( 0, "Warns", temp ), PlayerInfo[ playerid ][ pWarns ]                           = strval( temp );
        cache_get_field_content( 0, "Job", temp ), PlayerInfo[ playerid ][ pJob ]                               = strval( temp );
        cache_get_field_content( 0, "Rank", temp ), PlayerInfo[ playerid ][ pRank ]                             = strval( temp );
        cache_get_field_content( 0, "MutedTime", temp ), PlayerInfo[ playerid ][ pMutedTime ]                   = strval( temp );
        cache_get_field_content( 0, "DriverLicense", temp ), PlayerInfo[ playerid ][ pDriverLicense ]           = strval( temp );
        cache_get_field_content( 0, "PilotsLicense", temp ), PlayerInfo[ playerid ][ pPilotsLicense ]           = strval( temp );
        cache_get_field_content( 0, "BoatLicense", temp ), PlayerInfo[ playerid ][ pBoatLicense ]               = strval( temp );
        cache_get_field_content( 0, "FishLicense", temp ), PlayerInfo[ playerid ][ pFishLicense ]               = strval( temp );
        cache_get_field_content( 0, "GunsLicense", temp ), PlayerInfo[ playerid ][ pGunsLicense ]               = strval( temp );
        cache_get_field_content( 0, "Skin", temp ), PlayerInfo[ playerid ][ pSkin ]                             = strval( temp );
        cache_get_field_content( 0, "Register", temp ), PlayerInfo[ playerid ][ pRegister ]                     = strval( temp );
        cache_get_field_content( 0, "AcceptedMember", temp ), PlayerInfo[ playerid ][ pAcceptedMember ]         = strval( temp );
        cache_get_field_content( 0, "FWarn", temp ), PlayerInfo[ playerid ][ pFWarn ]                           = strval( temp );
        cache_get_field_content( 0, "FPunish", temp ), PlayerInfo[ playerid ][ pFPunish ]                       = strval( temp );
        cache_get_field_content( 0, "WantedLevel", temp ), PlayerInfo[ playerid ][ pWantedLevel ]               = strval( temp );
        cache_get_field_content( 0, "WantedDeaths", temp ), PlayerInfo[ playerid ][ pWantedDeaths ]             = strval( temp );
        cache_get_field_content( 0, "JailTime", temp ), PlayerInfo[ playerid ][ pJailTime ]                     = strval( temp );
        cache_get_field_content( 0, "Kills", temp ), PlayerInfo[ playerid ][ pKills ]                           = strval( temp );
        cache_get_field_content( 0, "Deaths", temp ), PlayerInfo[ playerid ][ pDeaths ]                         = strval( temp );
        cache_get_field_content( 0, "TimpConectat", temp ), PlayerInfo[ playerid ][ pTimpConectat ]             = strval( temp );
        cache_get_field_content( 0, "ValoareContract", temp ), PlayerInfo[ playerid ][ pValoareContract ]       = strval( temp );
        cache_get_field_content( 0, "Respect", temp ), PlayerInfo[ playerid ][ pRespect ]                       = strval( temp );
        cache_get_field_content( 0, "DisableTime", temp ), PlayerInfo[ playerid ][ pDisabledTime ]              = strval( temp );
        cache_get_field_content( 0, "NDisabled", temp ), PlayerInfo[ playerid ][ pNDisabled ]                   = strval( temp );
        cache_get_field_content( 0, "Materiale", temp ), PlayerInfo[ playerid ][ pMateriale ]                   = strval( temp );
        cache_get_field_content( 0, "HouseKey", temp ), PlayerInfo[ playerid ][ pHouseKey ]                     = strval( temp );
        cache_get_field_content( 0, "RentHouse", temp ), PlayerInfo[ playerid ][ pRentHouse ]                   = strval( temp );
        cache_get_field_content( 0, "Arestari", temp ), PlayerInfo[ playerid ][ pArestari ]                     = strval( temp );
        cache_get_field_content( 0, "Droguri", temp ), PlayerInfo[ playerid ][ pDroguri ]                       = strval( temp );
        cache_get_field_content( 0, "BizKey", temp ), PlayerInfo[ playerid ][ pBizKey ]                         = strval( temp );
        cache_get_field_content( 0, "Card", temp ), PlayerInfo[ playerid ][ pCard ]                             = strval( temp );
        cache_get_field_content( 0, "CardPin", temp ), PlayerInfo[ playerid ][ pCardPin ]                       = strval( temp );
        cache_get_field_content( 0, "LoiallityPoints", temp ), PlayerInfo[ playerid ][ pLoiallityPoints ]       = strval( temp );
        cache_get_field_content( 0, "FishTimer", temp ), PlayerInfo[ playerid ][ pFishTimer ]                   = strval( temp );
        cache_get_field_content( 0, "RegisterDate", PlayerInfo[ playerid ][ pDateRegister ] );
        cache_get_field_content( 0, "LastLoginDate", PlayerInfo[ playerid ][ pDateLastLogin ] );
        cache_get_field_content( 0, "eMail", PlayerInfo[ playerid ][ pEmail ] );
        cache_get_field_content( 0, "IPRegister", PlayerInfo[ playerid ][ pIPRegister ] );
        cache_get_field_content( 0, "GPS", temp ), PlayerInfo[ playerid ][ pGPS ]                               = strval( temp );
        cache_get_field_content( 0, "Telephone", temp ), PlayerInfo[ playerid ][ pTelephone ]                   = strval( temp );
        cache_get_field_content( 0, "PhoneNumber", temp ), PlayerInfo[ playerid ][ pPhoneNumber ]               = strval( temp );
        cache_get_field_content( 0, "PhoneBook", temp ), PlayerInfo[ playerid ][ pPhoneBook ]                   = strval( temp );
        cache_get_field_content( 0, "CarJackerSkill", temp ), PlayerInfo[ playerid ][ pCarJackerSkill ]         = strval( temp );
        cache_get_field_content( 0, "CarJackerTime", temp ), PlayerInfo[ playerid ][ pCarJackerTime ]           = strval( temp );
        cache_get_field_content( 0, "BusDriverSkill", temp ), PlayerInfo[ playerid ][ pBusDriverSkill ]         = strval( temp );
        cache_get_field_content( 0, "BusDriverTime", temp ), PlayerInfo[ playerid ][ pBusDriverTime ]           = strval( temp );
        cache_get_field_content( 0, "FreePoints", temp ), PlayerInfo[ playerid ][ pFreePoints ]                 = strval( temp );
        cache_get_field_content( 0, "CarKey1", temp ), PlayerInfo[ playerid ][ pCarKey1 ]                       = strval( temp );
        cache_get_field_content( 0, "CarKey2", temp ), PlayerInfo[ playerid ][ pCarKey2 ]                       = strval( temp );
        cache_get_field_content( 0, "CarKey3", temp ), PlayerInfo[ playerid ][ pCarKey3 ]                       = strval( temp );
        cache_get_field_content( 0, "RobPoints", temp ), PlayerInfo[ playerid ][ pRobPoints ]                   = strval( temp );
        cache_get_field_content( 0, "GunoierTime", temp ), PlayerInfo[ playerid ][ pGunoierTime ]               = strval( temp );
        cache_get_field_content( 0, "FightStyle", temp ), PlayerInfo[ playerid ][ pFightStyle ]                 = strval( temp );
        cache_get_field_content( 0, "PlayerConnected", temp ), PlayerInfo[ playerid ][ pPlayerConnected ]       = strval( temp );
        cache_get_field_content( 0, "NewsTime", temp ), PlayerInfo[ playerid ][ pNewsTime ]                     = strval( temp );
        cache_get_field_content( 0, "WalkieTalkie", temp ), PlayerInfo[ playerid ][ pWalkieTalkie ]             = strval( temp );
        cache_get_field_content( 0, "Freqvence", temp ), PlayerInfo[ playerid ][ pFreqvence ]                   = strval( temp );
        cache_get_field_content( 0, "NMuted", temp ), PlayerInfo[ playerid ][ pNMuted ]                         = strval( temp );
        cache_get_field_content( 0, "PizzaBoyTime", temp ), PlayerInfo[ playerid ][ pPizzaBoyTime ]             = strval( temp );
        cache_get_field_content( 0, "CementTruckerTime", temp ), PlayerInfo[ playerid ][ pCementTruckerTime ]   = strval( temp );
        cache_get_field_content( 0, "RWKills", temp ), PlayerInfo[ playerid ][ pRWKills ]                       = strval( temp );
        cache_get_field_content ( 0 , "RWDeaths" , temp ) , PlayerInfo[ playerid ][ pRWDeaths ]                 = strval ( temp ) ;
        cache_get_field_content ( 0 , "FInvite" , PlayerInfo [ playerid ] [ pFInvite ] ) ;
        cache_get_field_content ( 0 , "FPTime" , temp ) , PlayerInfo [ playerid ] [ pFPTime ]                   = strval ( temp ) ;
        cache_get_field_content ( 0 , "PayDay" , temp ) , PlayerInfo [ playerid ] [ pPayDay ]                   = strval ( temp ) ;
        cache_get_field_content ( 0 , "ReferralName" , PlayerInfo [ playerid ] [ pReferralName ] ) ;
        cache_get_field_content ( 0 , "ReferralMoneys" , temp ) , PlayerInfo [ playerid ] [ pReferralMoneys ]   = strval ( temp ) ;
        cache_get_field_content ( 0 , "ReferralRespect" , temp ) , PlayerInfo [ playerid ] [ pReferralRespect ] = strval ( temp ) ;
        cache_get_field_content ( 0 , "WantedDownTime" , temp ) , PlayerInfo [ playerid ] [ pWantedDownTime ]   = strval ( temp ) ;
        cache_get_field_content ( 0 , "NONAFKTime" , temp ) , PlayerInfo [ playerid ] [ pNONAFKTime ]           = strval ( temp ) ;
        cache_get_field_content ( 0 , "JobHours" , temp ) , PlayerInfo [ playerid ] [ pJobHours ]               = strval ( temp ) ;
        cache_get_field_content ( 0 , "Laptop" , temp ) , PlayerInfo [ playerid ] [ pLaptop ]                   = strval ( temp ) ;
        cache_get_field_content ( 0 , "BestAtWAR" , temp ) , PlayerInfo [ playerid ] [ pBestAtWAR ]             = strval ( temp ) ;
        cache_get_field_content ( 0 , "WrostAtWAR" , temp ) , PlayerInfo [ playerid ] [ pWrostAtWAR ]           = strval ( temp ) ;
        cache_get_field_content ( 0 , "SantaHat" , temp ) , PlayerInfo [ playerid ] [ pSantaHat ]               = strval ( temp ) ;
        cache_get_field_content ( 0 , "BestAtPaintBall" , temp ) , PlayerInfo [ playerid ] [ pBestAtPaintBall ] = strval ( temp ) ;
        cache_get_field_content ( 0 , "NewUser" , temp ) , PlayerInfo [ playerid ] [ pNewUser ]                 = strval ( temp ) ;
        cache_get_field_content ( 0 , "MinuteOnline" , temp ) , PlayerInfo [ playerid ] [ pMinuteOnline ]       = strval ( temp ) ;
        cache_get_field_content ( 0 , "LottoNumber" , temp ) , PlayerInfo [ playerid ] [ pLottoNumber ]         = strval ( temp ) ;
        cache_get_field_content ( 0 , "LottoNumber2" , temp ) , PlayerInfo [ playerid ] [ pLottoNumber2 ]       = strval ( temp ) ;
        cache_get_field_content ( 0 , "RaceTime" , temp ) , PlayerInfo [ playerid ] [ pRaceTime ]               = strval ( temp ) ;
        cache_get_field_content ( 0 , "ClanMember" , temp ) , PlayerInfo [ playerid ] [ pClanMember ]           = strval ( temp ) ;
        cache_get_field_content ( 0 , "ClanLeader" , temp ) , PlayerInfo [ playerid ] [ pClanLeader ]           = strval ( temp ) ;
        cache_get_field_content ( 0 , "LastName" , PlayerInfo [ playerid ] [ pLastName ] ) ;
        cache_get_field_content ( 0 , "ArmsDealerSkill" , temp ) , PlayerInfo [ playerid ] [ pArmsDealerSkill ] = strval ( temp ) ;
    }
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)