07.06.2014, 20:07
(
Последний раз редактировалось KingPersona; 08.06.2014 в 16:31.
Причина: Fixed [ SET 'DriverLicense' ]
)
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
Pawn Code for ['SET `DriverLicense] , i dont know where 
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 Код:
/*==============================================================================
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", "" );