am altfel astea, cred ca aste corespunt [pawn]case RegDialog: { if ( !response ) return ShowPlayerDialog( playerid, RegDialog, DIALOG_STYLE_PASSWORD, "{FFFFFF}Register {FF0000}Failed !", "{FF0000}ERROR!: {FFFFFF}You must obligatory register your account!", "Register", "" ); new rPassword[ 25 ] ; if ( sscanf( inputtext, "s[25]", rPassword ) ) return ShowPlayerDialog( playerid, RegDialog, DIALOG_STYLE_PASSWORD, "Register", "You must type a password if you want to register!", "Register", "" ); if ( strlen( rPassword ) < 6 || strlen( rPassword ) > 25 ) return ShowPlayerDialog( playerid, RegDialog, DIALOG_STYLE_PASSWORD, "Register", "The password must be between 6 and 24 characters!", "Register", "" ); mysql_real_escape_string( rPassword, rPassword ); new Buf[ 129 ]; WP_Hash( Buf, 129, rPassword ); new liYear, liMonth, liDay; getdate( liYear, liMonth, liDay ); //--------------------------- Account INSERT ---------------------// gsString[ 0 ] = EOS; format( gsString, 2048, "INSERT INTO `Accounts`(`Key`, `Name`, `IP`, `Password`, `RegisterDate`, `LoggedIn`, `Level`, `Vip`, `rVip`, `LastOn`, \ `Cash`, `Score`, `Kills`, `Deaths`, `Online`, `Rank`, `BestKillings`, `KillingSpree`, `Drugs`, `TimesOnServer`," ); format( gsString, 2048, "%s`Coins`, `SAdmin`, `FavSkin`, `UseSkin`, `Description1`, `Description2`, `Description3`, `Description4`, `Positive`, `Negative`, \ `Clan`, `ClanRank`, `E-Mail`, `ClanPoints`, `ClanDeaths`, `ClanOnline`, `ClanJoined`, `Kicks`, `Bans`, `Jails`,", gsString ); format( gsString, 2048, "%s`Warns`, `ClearChats`, `ReactionTest`, `MathTest`, `Mutes`, `ARatio`, `Property`, `Jailed`, `JailTime`, `Frozen`, \ `FreezeTime`, `RAdmin`, `ChatColor`, `RaceScore`, `DriftScore`, `DuelScore`, `vSpawn_X`, `vSpawn_Y`, `vSpawn_Z`, `vSpawn_A`, \ `TopOnline`, `AdminWarns`, `OwnedCarID`, `AllowToken`, `Token`, `VIPTime`, `SavingSts`, `HouseID`, `BankMoney`,", gsString ); format( gsString, 2048, "%s`Lang`, `GangID`,`GangKills`,`GangDeaths`,`GangRank`,`GangWarns`,`GangCaptures`,`GangPoints`,`FreeVIP`)", gsString ); format( gsString, 2048, "%s VALUES (0, '%s', '%s', '%s', '%d-%d-%d', 1, 0, 0, 0, '%d-%d-%d', \ 300000, 50, 0, 0, '00:00:00', 0, 0, 0, 0, 1, \ 0, 0, 0, 0, ' ', ' ', ' ', ' ', 0, 0,", gsString, PlayerName( playerid ), GetPlayerIPEx( playerid ), Buf, liYear, liMonth, liDay, liYear, liMonth, liDay ); format( gsString, 2048, "%s'None', 0, ' ', 0, 0, '00:00:00', 'None', 0, 0, 0, \ 0, 0, 0, 0, 0, 0, 0, 0, '00:00', 0, \ '00:00', 0, '0xFFFFFFFF', 0, 0, 0, 0.00, 0.00, 0.00, 0.00, \ 0, 0, 0, 0, 0, 0, '0,0', 0, 0, %d, 0, 0, 0, 0, 0, 0, 0, 1)", gsString, Lang[ playerid ] ); mysql_function_query( g_Handle, gsString, false, "OnAccountCreated", "i", playerid ); //----------------------------------------------------------------// gsString[ 0 ] = EOS; switch( Lang[ playerid ] ) { case 0: { blablabla (de ce sa bage email) } case 1: { blablabla (de ce sa bage email) } } ShowPlayerDialog( playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "{FFFFFF}Type your E-Mail", gsString, "Enter", "" ); PlayerInfo[ playerid ][ LoggedIn ] = 1; GivePlayerMoney( playerid, 300000 ); SetPlayerScore( playerid, 50 ); return ( 1 ); } case DIALOG_EMAIL: { if ( !response ) return ShowPlayerDialog( playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Type your E-Mail", "You need to set your e-mail!", "Enter", "" ); new lsMail[ 128 ] ; if ( sscanf( inputtext, "s[128]", lsMail ) ) return ShowPlayerDialog( playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Type your E-Mail", "You need to set your e-mail!", "Enter", "" ); if ( strlen( lsMail ) < 8 || strlen( lsMail ) > 60 ) return ShowPlayerDialog( playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Type your E-Mail", "Please type a valid E-Mail adress.", "Enter", "" ); if ( strfind( lsMail, "@", false ) == -1 || strfind( lsMail, ".", false ) == -1 ) return ShowPlayerDialog( playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Type your E-Mail", "Please type a valid E-Mail adress.", "Enter", "" ); mysql_real_escape_string( lsMail, lsMail ); format( gsQuery, 256, "UPDATE `Accounts` SET `E-Mail` = '%s' WHERE `Key` = %d", lsMail, PlayerInfo[ playerid ][ AccID ] ); mysql_function_query( g_Handle, gsQuery, false, "", "" ); return ( 1 ); }[/pawn] [pawn]function OnPlayerConnectEx( playerid ) { ShowZonesFor( playerid ); candrift[playerid] = 0; gvdrift[playerid] = 0; drift2[playerid] = 0; drift3[playerid] = 0; drift1[playerid] = 0; sdrift[playerid] = 0; SDriftT[playerid] = 0; PlayerInfo[ playerid ][ FreeVIP ] = 1; PlayerInfo[ playerid ][ IgnoreGangGoto ] = 0; PlayerInfo[ playerid ][ hacker ] = 0; PlayerInfo[ playerid ][ pRainbow ] = 0; PlayerInfo[ playerid ][ o_index ] = -1; PlayerInfo[ playerid ][ szOwnedHouseID ] = 0; PlayerInfo[ playerid ][ p_health ] = 100.0; PlayerInfo[ playerid ][ FirstSpawn ] = 1; PlayerInfo[ playerid ][ blip ] = 0; PlayerInfo[ playerid ][ Use_Attach ] = 0; PlayerInfo[ playerid ][ D_Score ] = 0; PlayerInfo[ playerid ][ Race_Score ] = 0; PlayerInfo[ playerid ][ Drift_Score ] = 0; PlayerInfo[ playerid ][ p_TextColor ] = 16777215; PlayerInfo[ playerid ][ Tag ] = 0; PlayerInfo[ playerid ][ rAdmin ] = 0; PlayerInfo[ playerid ][ Property ] = 0; PlayerInfo[ playerid ][ WarnTimer ] = 0; PlayerInfo[ playerid ][ InJob ] = 0; PlayerInfo[ playerid ][ Spectating ] = 0; PlayerInfo[ playerid ][ PGoted ] = -1; PlayerInfo[ playerid ][ BanTimer ] = 0; PlayerInfo[ playerid ][ KickTimer ] = 0; PlayerInfo[ playerid ][ ID ] = 0; PlayerInfo[ playerid ][ rank ] = 0; PlayerInfo[ playerid ][ skin ] = 0; PlayerInfo[ playerid ][ spawnX ] = 0.0; PlayerInfo[ playerid ][ spawnY ] = 0.0; PlayerInfo[ playerid ][ spawnZ ] = 0.0; PlayerInfo[ playerid ][ spawnA ] = 0.0; PlayerInfo[ playerid ][ Weap1 ] = 0; PlayerInfo[ playerid ][ Weap2 ] = 0; PlayerInfo[ playerid ][ Weap3 ] = 0; PlayerInfo[ playerid ][ Weap4 ] = 0; PlayerInfo[ playerid ][ Weap5 ] = 0; PlayerInfo[ playerid ][ Weap6 ] = 0; PlayerInfo[ playerid ][ PosRespect ] = 0; PlayerInfo[ playerid ][ NegRespect ] = 0; PlayerInfo[ playerid ][ Ignore_Spec ] = 0; PlayerInfo[ playerid ][ Ignore_Get ] = 0; PlayerInfo[ playerid ][ Ignore_Clan_Invite ] = 0; PlayerInfo[ playerid ][ AccID ] = 0; PlayerInfo[ playerid ][ AWarings ] = 0; PlayerInfo[ playerid ][ Vup ] = 0; PlayerInfo[ playerid ][ JumpSize ] = 0; PlayerInfo[ playerid ][ VupKey ] = 0; PlayerInfo[ playerid ][ InEvent ] = 0; PlayerInfo[ playerid ][ HaveGPS ] = false; PlayerInfo[ playerid ][ HaveBomb ] = 0; PlayerInfo[ playerid ][ Deaths ] = 0; PlayerInfo[ playerid ][ Kills ] = 0; PlayerInfo[ playerid ][ Jailed ] = 0; PlayerInfo[ playerid ][ Frozen ] = 0; PlayerInfo[ playerid ][ Level ] = 0; PlayerInfo[ playerid ][ SAdmin ] = 0; PlayerInfo[ playerid ][ pVip ] = 0; PlayerInfo[ playerid ][ rVip ] = 0; PlayerInfo[ playerid ][ LoggedIn ] = 0; PlayerInfo[ playerid ][ Muted ] = 0; PlayerInfo[ playerid ][ MuteWarnings ] = 0; PlayerInfo[ playerid ][ Warnings ] = 0; PlayerInfo[ playerid ][ pCar ] = -1; PlayerInfo[ playerid ][ PingCount ] = 0; PlayerInfo[ playerid ][ PingTime ] = 0; PlayerInfo[ playerid ][ FailLogin ] = 0; PlayerInfo[ playerid ][ Coins ] = 0; PlayerInfo[ playerid ][ Rank ] = 0; PlayerInfo[ playerid ][ P_AntiFall ] = 0; PlayerInfo[ playerid ][ RecentlyRobbed ] = 0; PlayerInfo[ playerid ][ hours ] = 0; PlayerInfo[ playerid ][ mins ] = 0; PlayerInfo[ playerid ][ secs ] = 0; PlayerInfo[ playerid ][ ActionID ] = 0; PlayerInfo[ playerid ][ Drugs ] = 0; PlayerInfo[ playerid ][ ConnectTime ] = gettime( ); PlayerInfo[ playerid ][ KillingSpree ] = 0; PlayerInfo[ playerid ][ bKillingSpree ] = 0; PlayerInfo[ playerid ][ PKicks ] = 0; PlayerInfo[ playerid ][ PMaths ] = 0; PlayerInfo[ playerid ][ PWarns ] = 0; PlayerInfo[ playerid ][ PBans ] = 0; PlayerInfo[ playerid ][ PReactions ] = 0; PlayerInfo[ playerid ][ PClearCH ] = 0; PlayerInfo[ playerid ][ PJails ] = 0; PlayerInfo[ playerid ][ PMutes ] = 0; PlayerInfo[ playerid ][ HideTDSSSS ] = 0; PlayerInfo[ playerid ][ InMinigun ] = 0; PlayerInfo[ playerid ][ Planted ] = 0; PlayerInfo[ playerid ][ Bomb ] = 0; PlayerInfo[ playerid ][ GotoIgnored ] = 0; PlayerInfo[ playerid ][ PlayerInBloodring ] = -1; PlayerInfo[ playerid ][ PlayerInVortexCar ] = -1; PlayerInfo[ playerid ][ GotoIgnored ] = 0; PlayerInfo[ playerid ][ isafk ] = 0; PlayerInfo[ playerid ][ CarID ] = 0; PlayerInfo[ playerid ][ car_X ] = 0.0; PlayerInfo[ playerid ][ car_Y ] = 0.0; PlayerInfo[ playerid ][ car_Z ] = 0.0; PlayerInfo[ playerid ][ car_A ] = 0.0; PlayerInfo[ playerid ][ car_Locked ] = 0; PlayerInfo[ playerid ][ car_color1 ] = random( 226 ); PlayerInfo[ playerid ][ car_color2 ] = random( 1 ); PlayerInfo[ playerid ][ spoilerid ] = 0; PlayerInfo[ playerid ][ neonid ] = 0; PlayerInfo[ playerid ][ p_VehID ] = -1; PlayerInfo[ playerid ][ AdminWarns ] = 0; PlayerInfo[ playerid ][ BuyerID ] = -1; PlayerInfo[ playerid ][ Trader ] = -1; PlayerInfo[ playerid ][ P_BANK_MONEY ] = 0; Users[ playerid ][ gang ] = 0; Users[ playerid ][ turfe ] = 0; Users[ playerid ][ isLeader ] = 0; Users[ playerid ][ turftime ] = 30; Users[ playerid ][ kills ] = 0; Users[ playerid ][ deaths ] = 0; Users[ playerid ][ g_Warns ] = 0; Users[ playerid ][ g_Captures ] = 0; Users[ playerid ][ g_Points ] = 0; format( PlayerInfo[ playerid ][ LastOn ], 11, " " ); format( PlayerInfo[ playerid ][ Description1 ], 85, " " ); format( PlayerInfo[ playerid ][ Description2 ], 85, " " ); format( PlayerInfo[ playerid ][ Description3 ], 85, " " ); format( PlayerInfo[ playerid ][ Description4 ], 85, " " ); format( PlayerInfo[ playerid ][ Clan ], 25, "niciunul" ); format( PlayerInfo[ playerid ][ RankName ], 25, "Incepator" ); format( PlayerInfo[ playerid ][ d_RankName ], 25, "Duelist incepator" ); format( PlayerInfo[ playerid ][ r_RankName ], 25, "Sofer incepator" ); format( PlayerInfo[ playerid ][ ds_RankName ], 25, "Drifter incepator" ); format( PlayerInfo[ playerid ][ car_plate ], 50, "Masina" ); iPlayerNickTime[ playerid ] = 0; GPSTimer[ playerid ] = 0; SpawnInDM[ playerid ] = " "; Speeding[ playerid ] = false; grider[ playerid ][ 0 ] = 0; grider[ playerid ][ 1 ] = 0; grider[ playerid ][ 2 ] = 0; InvitedClanID[ playerid ] = -1; CheckpoinID[ playerid ] = -1; FishNameVIP[ playerid ] = 0; FRod[ playerid ] = 0; Bait[ playerid ] = 0; FLine[ playerid ] = 0; Snow_F[ playerid ] = 0; Killer[ playerid ] = 501; Charged[ playerid ] = 0; Shoot[ playerid ] = 0; ViewedVehicleID[ playerid ] = -1; IsAsayTimer[ playerid ] = 0; InHNS[ playerid ] = 0; PlayerItem{ playerid } = 1; SelectingCar{ playerid } = false; Lang[ playerid ] = -1; Current_Hidden_Packages[ playerid ] = 0; CancelSelectTextDraw( playerid ); TogglePlayerControllable( playerid, true ); HideCarTextDraws( playerid ); SetPlayerVirtualWorld( playerid, 0 ); for ( new i; i < PING_MAX_EXCEEDS; i++ ) PlayerInfo[ playerid ][ pPing ][ i ] = 0; ResetPlayerWeapons( playerid ); SetPlayerMapIcon( playerid, 0, -1662.4999, 1209.7217, 7.2500, 55, 0 ); rInfoTDS[ playerid ] = CreatePlayerTextDraw( playerid, 165.000000, 371.000000, " " ); PlayerTextDrawAlignment( playerid, rInfoTDS[ playerid ], 1 ); PlayerTextDrawBackgroundColor( playerid, rInfoTDS[ playerid ], 0x000000ff ); PlayerTextDrawFont( playerid, rInfoTDS[ playerid ], 1 ); PlayerTextDrawLetterSize( playerid, rInfoTDS[ playerid ], 0.299999, 1.200000 ); PlayerTextDrawColor( playerid, rInfoTDS[ playerid ], 0xffffffff ); PlayerTextDrawSetOutline( playerid, rInfoTDS[ playerid ], 1 ); PlayerTextDrawSetProportional( playerid, rInfoTDS[ playerid ], 1 ); PlayerTextDrawSetShadow( playerid, rInfoTDS[ playerid ], 1 ); PlayerTextDrawSetSelectable( playerid, rInfoTDS[ 2 ], 0 ); Jail_Time = CreatePlayerTextDraw( playerid, 565.000000, 13.000000, "_"); PlayerTextDrawBackgroundColor( playerid, Jail_Time, 255); PlayerTextDrawFont( playerid, Jail_Time, 2); PlayerTextDrawLetterSize( playerid, Jail_Time, 0.320000, 1.500000); PlayerTextDrawColor( playerid, Jail_Time, 929038335); PlayerTextDrawSetOutline( playerid, Jail_Time, 1); PlayerTextDrawSetProportional( playerid, Jail_Time, 1); Random_TD_Texts = CreatePlayerTextDraw( playerid, 0.000000, 436.000000, "_"); PlayerTextDrawBackgroundColor( playerid, Random_TD_Texts, 85); PlayerTextDrawFont( playerid, Random_TD_Texts, 1); PlayerTextDrawLetterSize( playerid, Random_TD_Texts, 0.159999, 1.200000); PlayerTextDrawColor( playerid, Random_TD_Texts, -1); PlayerTextDrawSetOutline( playerid, Random_TD_Texts, 1); PlayerTextDrawSetProportional( playerid, Random_TD_Texts, 1); Random_TD_Texts_RO = CreatePlayerTextDraw( playerid, 0.000000, 436.000000, "_"); PlayerTextDrawBackgroundColor( playerid, Random_TD_Texts_RO, 85); PlayerTextDrawFont( playerid, Random_TD_Texts_RO, 1); PlayerTextDrawLetterSize( playerid, Random_TD_Texts_RO, 0.159999, 1.200000); PlayerTextDrawColor( playerid, Random_TD_Texts_RO, -1); PlayerTextDrawSetOutline( playerid, Random_TD_Texts_RO, 1); PlayerTextDrawSetProportional( playerid, Random_TD_Texts_RO, 1); if ( ServerInfo[ NameKick ] == 1 ) { for ( new s = 0; s < BadNameCount; s++ ) { if ( !strcmp( BadNames[ s ], PlayerName( playerid ), true ) ) { SendClientMessage( playerid, COLOR_GREY, "Numele tau se afla pe lista de Nume Interzise, Ai fost deconectat automat." ); format( gsString, sizeof( gsString ), "%s (ID:%d) a primit kick automat. (Motiv: Nume Interzis)", PlayerName( playerid ), playerid ); SendClientMessageToAll( COLOR_GREY, gsString ); FormatLog( "KickLog", "%s a fost deconectat automat de pe server. Motiv: Nume interzis.", PlayerName( playerid ) ); Kick( playerid ); return ( 1 ); } } } if ( ServerInfo[ PartNameKick ] == 1 ) { for ( new s = 0; s < BadPartNameCount; s++ ) { new pos; while ( ( pos = strfind( PlayerName( playerid ), BadPartNames[ s ], true ) ) != -1 ) for ( new i = pos, j = pos + strlen( BadPartNames[ s ] ); i < j; i++ ) { SendClientMessage( playerid, COLOR_GREY, "Numele dau nu este permis pe server, ai fost dat afata automat." ); format( gsString, sizeof( gsString ), " %s (ID:%d) ai fost dat afata automat. (Motiv: Nume Interzis)",PlayerName( playerid ), playerid ); SendClientMessageToAll( COLOR_GREY, gsString ); FormatLog( "KickLog", "%s a fost deconectat automat de pe server. Motiv: Nume interzis.", PlayerName( playerid ) ); Kick( playerid ); return ( 1 ); } } } switch( random( 4 ) ) { case 0: format( gsString, 256, "~g~~h~%s(%d) ~y~~h~a intrat pe Server.", PlayerName( playerid ), playerid ); case 1: format( gsString, 256, "~r~~h~%s(%d) ~y~~h~a intrat pe Server.", PlayerName( playerid ), playerid ); case 2: format( gsString, 256, "~b~~h~%s(%d) ~y~~h~a intrat pe Server.", PlayerName( playerid ), playerid ); case 3: format( gsString, 256, "~p~~h~%s(%d) ~y~~h~a intrat pe Server.", PlayerName( playerid ), playerid ); } ShowOnTextDraw( gsString ); for ( new i = 0; i < 8; i++ ) { p_Object[ playerid ][ i ] = -1; TextDrawShowForPlayer( playerid, ConnectTD[ i ] ); SendClientMessage( playerid, ~1, " " ); } format( gsString, 144, "Welcome '%s' pe ....", PlayerName( playerid ) ); SendClientMessage(playerid, -1, "Bine ai venit pe ..... Pentru mai mult ajutor scrie /HELP!"); SendClientMessage(playerid, -1, "Scrie /rules Ca sa vezi Regulamentul serverului"); SendClientMessage(playerid, -1, "Scrie /cmds ca sa vezi toate Comenzile."); SendClientMessage(playerid, -1, "Scrie /teles ca sa vezi toate Teleporturile."); SendClientMessage(playerid, -1, "Type /eng or /ro to select language."); SendClientMessage(playerid, -1, "Daca vrei o masin scrie /V Si daca vrei sa o tunezi scrie /tune"); SendClientMessage(playerid, -1, "Viziteaza si inregistreaza-te pe ..... Ca sa vizitezi situl!"); format( gsQuery, 128, "SELECT * FROM `Accounts` WHERE `Name` = '%s'", PlayerName( playerid ) ); mysql_function_query( g_Handle, gsQuery, true, "LoginPlayerAccount", "i", playerid ); format( gsQuery, 128, "SELECT `Names` FROM `AKA` WHERE `IP` = '%s'", GetPlayerIPEx( playerid ) ); mysql_function_query( g_Handle, gsQuery, true, "LoadPlayerAKA", "i", playerid ); return ( 1 ); }[/pawn] [pawn] SQL_Function LoginPlayerAccount( playerid ) { if ( !IsPlayerConnected( playerid ) ) return ( 1 ); new Rows, Fields, Login_Field[ 128 ], LastOnline[ 56 ], RegisterDate[ 56 ]; cache_get_data( Rows, Fields, g_Handle ); if ( Rows ) { cache_get_field_content( 0, "IP", Login_Field, g_Handle ); if ( !strcmp( GetPlayerIPEx( playerid ), Login_Field, true ) && ServerInfo[ AutoLogin ] == 1 ) { PlayerInfo[ playerid ][ LoggedIn ] = 1; PlayerInfo[ playerid ][ AccID ] = cache_get_field_content_int( 0, "Key", g_Handle ); PlayerInfo[ playerid ][ pVip ] = cache_get_field_content_int( 0, "Vip", g_Handle ); PlayerInfo[ playerid ][ Level ] = cache_get_field_content_int( 0, "Level", g_Handle ); PlayerInfo[ playerid ][ rVip ] = cache_get_field_content_int( 0, "rVip", g_Handle ); PlayerInfo[ playerid ][ bKillingSpree ] = cache_get_field_content_int( 0, "BestKillings", g_Handle ); PlayerInfo[ playerid ][ KillingSpree ] = cache_get_field_content_int( 0, "KillingSpree", g_Handle ); PlayerInfo[ playerid ][ Drugs ] = cache_get_field_content_int( 0, "Drugs", g_Handle ); PlayerInfo[ playerid ][ Coins ] = cache_get_field_content_int( 0, "Coins", g_Handle ); PlayerInfo[ playerid ][ PosRespect ] = cache_get_field_content_int( 0, "Positive", g_Handle ); PlayerInfo[ playerid ][ NegRespect ] = cache_get_field_content_int( 0, "Negative", g_Handle ); PlayerInfo[ playerid ][ SAdmin ] = cache_get_field_content_int( 0, "SAdmin", g_Handle ); PlayerInfo[ playerid ][ FavSkin ] = cache_get_field_content_int( 0, "FavSkin", g_Handle ); PlayerInfo[ playerid ][ rank ] = cache_get_field_content_int( 0, "ClanRank", g_Handle ); PlayerInfo[ playerid ][ c_points ] = cache_get_field_content_int( 0, "ClanPoints", g_Handle ); PlayerInfo[ playerid ][ c_deaths ] = cache_get_field_content_int( 0, "ClanDeaths", g_Handle ); PlayerInfo[ playerid ][ PKicks ] = cache_get_field_content_int( 0, "Kicks", g_Handle ); PlayerInfo[ playerid ][ PBans ] = cache_get_field_content_int( 0, "Bans", g_Handle ); PlayerInfo[ playerid ][ PJails ] = cache_get_field_content_int( 0, "Jails", g_Handle ); PlayerInfo[ playerid ][ PWarns ] = cache_get_field_content_int( 0, "Warns", g_Handle ); PlayerInfo[ playerid ][ PClearCH ] = cache_get_field_content_int( 0, "ClearChats", g_Handle ); PlayerInfo[ playerid ][ PReactions ] = cache_get_field_content_int( 0, "ReactionTest", g_Handle ); PlayerInfo[ playerid ][ PMaths ] = cache_get_field_content_int( 0, "MathTest", g_Handle ); PlayerInfo[ playerid ][ PMutes ] = cache_get_field_content_int( 0, "Mutes", g_Handle ); PlayerInfo[ playerid ][ Property ] = cache_get_field_content_int( 0, "Property", g_Handle ); PlayerInfo[ playerid ][ Jailed ] = cache_get_field_content_int( 0, "Jailed", g_Handle ); PlayerInfo[ playerid ][ Frozen ] = cache_get_field_content_int( 0, "Frozen", g_Handle ); PlayerInfo[ playerid ][ Kills ] = cache_get_field_content_int( 0, "Kills", g_Handle ); PlayerInfo[ playerid ][ Deaths ] = cache_get_field_content_int( 0, "Deaths", g_Handle ); PlayerInfo[ playerid ][ rAdmin ] = cache_get_field_content_int( 0, "RAdmin", g_Handle ); PlayerInfo[ playerid ][ p_TextColor ] = cache_get_field_content_int( 0, "ChatColor", g_Handle ); PlayerInfo[ playerid ][ D_Score ] = cache_get_field_content_int( 0, "DuelScore", g_Handle ); PlayerInfo[ playerid ][ Race_Score ] = cache_get_field_content_int( 0, "RaceScore", g_Handle ); PlayerInfo[ playerid ][ Drift_Score ] = cache_get_field_content_int( 0, "DriftScore", g_Handle ); PlayerInfo[ playerid ][ CarID ] = cache_get_field_content_int( 0, "OwnedCarID", g_Handle ); PlayerInfo[ playerid ][ szOwnedHouseID ] = cache_get_field_content_int( 0, "HouseID", g_Handle ); PlayerInfo[ playerid ][ P_BANK_MONEY ] = cache_get_field_content_int( 0, "BankMoney", g_Handle ); Lang[ playerid ] = cache_get_field_content_int( 0, "Lang", g_Handle ); Users[ playerid ][ gang ] = cache_get_field_content_int( 0, "GangID", g_Handle ); Users[ playerid ][ kills ] = cache_get_field_content_int( 0, "GangKills", g_Handle ); Users[ playerid ][ deaths ] = cache_get_field_content_int( 0, "GangDeaths", g_Handle ); Users[ playerid ][ isLeader ] = cache_get_field_content_int( 0, "GangRank", g_Handle ); Users[ playerid ][ g_Warns ] = cache_get_field_content_int( 0, "GangWarns", g_Handle ); Users[ playerid ][ g_Captures ] = cache_get_field_content_int( 0, "GangCaptures", g_Handle ); Users[ playerid ][ g_Points ] = cache_get_field_content_int( 0, "GangPoints", g_Handle ); cache_get_field_content( 0, "E-Mail", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ EMail ], 128, "%s", Login_Field ); SetPVarFloat( playerid, "vSpawn_X", cache_get_field_content_float( 0, "vSpawn_X", g_Handle ) ); SetPVarFloat( playerid, "vSpawn_Y", cache_get_field_content_float( 0, "vSpawn_Y", g_Handle ) ); SetPVarFloat( playerid, "vSpawn_Z", cache_get_field_content_float( 0, "vSpawn_Z", g_Handle ) ); SetPVarFloat( playerid, "vSpawn_A", cache_get_field_content_float( 0, "vSpawn_A", g_Handle ) ); ResetPlayerMoney( playerid ); GivePlayerMoney( playerid, cache_get_field_content_int( 0, "Cash", g_Handle ) ); SetPVarInt( playerid, "sMoney", cache_get_field_content_int( 0, "Cash", g_Handle ) ); SetPlayerScore( playerid, cache_get_field_content_int( 0, "Score", g_Handle ) ); cache_get_field_content( 0, "Online", Login_Field, g_Handle ); sscanf( Login_Field, "p<:>iii", PlayerInfo[ playerid ][ hours ], PlayerInfo[ playerid ][ mins ], PlayerInfo[ playerid ][ secs ] ); cache_get_field_content( 0, "LastOn", LastOnline, g_Handle ); cache_get_field_content( 0, "RegisterDate", RegisterDate, g_Handle ); cache_get_field_content( 0, "Rank", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ RankName ], 25, Login_Field ); cache_get_field_content( 0, "Description1", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ Description1 ], 85, Login_Field ); cache_get_field_content( 0, "Description2", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ Description2 ], 85, Login_Field ); cache_get_field_content( 0, "Description3", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ Description3 ], 85, Login_Field ); cache_get_field_content( 0, "Description4", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ Description4 ], 85, Login_Field ); cache_get_field_content( 0, "ClanJoined", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ JoinedInClan ], 50, Login_Field ); cache_get_field_content( 0, "Clan", Login_Field, g_Handle ); format( PlayerInfo[ playerid ][ Clan ], 25, "%s", Login_Field ); cache_get_field_content( 0, "ClanOnline", Login_Field ); sscanf( Login_Field, "p<:>iii", PlayerInfo[ playerid ][ clan_H ], PlayerInfo[ playerid ][ clan_M ], PlayerInfo[ playerid ][ clan_S ] ); cache_get_field_content( 0, "SavingSts", Login_Field, g_Handle ); sscanf( Login_Field, "p<,>ii", PlayerInfo[ playerid ][ p_HoldSaving ], PlayerInfo[ playerid ][ p_VehicleHoldSaving ] ); if ( PlayerInfo[ playerid ][ Jailed ] >= 1 ) { cache_get_field_content( 0, "JailTime", Login_Field, g_Handle ); sscanf( Login_Field, "p<:>ii", gTime[ playerid ][ 0 ], gTime[ playerid ][ 1 ] ); } if ( PlayerInfo[ playerid ][ Frozen ] == 1 ) { cache_get_field_content( 0, "FreezeTime", Login_Field, g_Handle ); sscanf( Login_Field, "p<:>ii", gTime[ playerid ][ 0 ], gTime[ playerid ][ 1 ] ); } if ( PlayerInfo[ playerid ][ pVip ] == 2 ) { PlayerInfo[ playerid ][ TempVIP ] = cache_get_field_content_int( 0, "VIPTime", g_Handle ); if ( gettime( ) > PlayerInfo[ playerid ][ TempVIP ] ) { format( gsString, 256, "~y~~h~INFO:~w~~h~VIP-ul tau temporat a ~r~~h~expirat~w~~h~.~n~Poti sa cumperi alt VIP, folosind ~r~~h~/buyvip", PlayerInfo[ playerid ][ pVip ] ); Info( playerid, gsString, 6000 ); PlayerInfo[ playerid ][ pVip ] = 0; PlayerInfo[ playerid ][ TempVIP ] = 0; } } if ( PlayerInfo[ playerid ][ CarID ] != 0 ) { format( gsQuery, 128, "SELECT * FROM `PersonalVehicles` WHERE `Owner` = '%s'", PlayerName( playerid ) ); mysql_function_query( g_Handle, gsQuery, true, "LoadPersonalVehicleInfo", "i", playerid ); } format( gsQuery, 128, "UPDATE `Accounts` SET `LoggedIn` = 1 WHERE `Key` = %d", PlayerInfo[ playerid ][ AccID ] ); mysql_function_query( g_Handle, gsQuery, false, "", "" ); format( gsQuery, 256, "SELECT * FROM `Holds` WHERE `UserID` = %d", PlayerInfo[ playerid ][ AccID ] ); mysql_function_query( g_Handle, gsQuery, true, "LoadHoldDetails", "i", playerid ); if ( !strmatch( PlayerInfo[ playerid ][ Clan ], "None" ) ) { format( gsQuery, 256, "SELECT * FROM `Clans` WHERE `name` = '%s'", PlayerInfo[ playerid ][ Clan ] ); mysql_function_query( g_Handle, gsQuery, true, "LoadClanDetails", "i", playerid ); } if ( PlayerInfo[ playerid ][ CarID ] != 0 ) { format( gsQuery, 256, "SELECT * FROM `PersonalVehicles` WHERE `Owner` = '%s'", PlayerName( playerid ) ); mysql_function_query( g_Handle, gsQuery, true, "LoadVehicleDetails", "i", playerid ); } SendClientMessage( playerid, ~1, " " ); switch( PlayerInfo[ playerid ][ Level ] ) { case 0: { PlayerTextDrawShow( playerid, Random_TD_Texts ); PlayerTextDrawHide( playerid, Random_TD_Texts_RO ); switch( Lang[ playerid ] ) { case 0: { FormatMSG( playerid, COLOR_ULTRARED, "Welcome back to your account, %s", PlayerName( playerid ) ); FormatMSG( playerid, COLOR_ULTRARED, "You were last online at %s and registered on %s", LastOnline, RegisterDate ); FormatMSG( playerid, COLOR_ULTRARED, "You have been online for %d hours, %d minutes, %d seconds", PlayerInfo[ playerid ][ hours ], PlayerInfo[ playerid ][ mins ], PlayerInfo[ playerid ][ secs ] ); } case 1: { FormatMSG( playerid, COLOR_ULTRARED, "Bine ai revenit in contul tau, %s", PlayerName( playerid ) ); FormatMSG( playerid, COLOR_ULTRARED, "Ultima data cand ai fost online %s si te-ai inregistrat in %s", LastOnline, RegisterDate ); FormatMSG( playerid, COLOR_ULTRARED, "Ai fost online timp de %d ore, %d minute, %d secunde", PlayerInfo[ playerid ][ hours ], PlayerInfo[ playerid ][ mins ], PlayerInfo[ playerid ][ secs ] ); } } } default: { PlayerTextDrawHide( playerid, Random_TD_Texts ); PlayerTextDrawShow( playerid, Random_TD_Texts_RO ); switch( Lang[ playerid ] ) { case 0: { FormatMSG( playerid, COLOR_ULTRARED, "Welcome back to your account, %s. Admin Level %d", PlayerName( playerid ), PlayerInfo[ playerid ][ Level ] ); FormatMSG( playerid, COLOR_ULTRARED, "You were last online at %s and registered on %s", LastOnline, RegisterDate ); FormatMSG( playerid, COLOR_ULTRARED, "You have been online for %d hours, %d minutes, %d seconds", PlayerInfo[ playerid ][ hours ], PlayerInfo[ playerid ][ mins ], PlayerInfo[ playerid ][ secs ] ); } case 1: { FormatMSG( playerid, COLOR_ULTRARED, "Bine ai revenit in contul tau, %s. Admin Level %d", PlayerName( playerid ), PlayerInfo[ playerid ][ Level ] ); FormatMSG( playerid, COLOR_ULTRARED, "Ultima data cand ai fost online %s si te-ai inregistrat in %s", LastOnline, RegisterDate ); FormatMSG( playerid, COLOR_ULTRARED, "Ai fost online timp de %d ore, %d minute, %d secunde", PlayerInfo[ playerid ][ hours ], PlayerInfo[ playerid ][ mins ], PlayerInfo[ playerid ][ secs ] ); } } } } } else ShowPlayerDialog( playerid, DIALOG_LANG, 0, "{FFFFFF}Language/Limba", "Necessarily have to choose your language.\nChoose between Romana or English", "Romana", "English" ); } else ShowPlayerDialog( playerid, DIALOG_LANG_EX, 0, "{FFFFFF}Language/Limba", "Necessarily have to choose your language.\nChoose between Romana or English", "Romana", "English" ); return ( 1 ); }[/pawn]