01.12.2017, 13:05
Hello there.
I have a problem with the server console.
3 or 4 months ago i closed my server because i have an exam and it is hard to work on it if it's always open. So now i wanted to play a little and i opened the server on my computer (Windows) and i saw that when i discconect from the server my console crashes and the dates don't save. So after that i made a "/saveme" command to see if the problem is on my "SavePlayer" function. The problem it seems to be there, because when i am in game and i use '/saveme' comamnd the console crashes. I don't understand why because when my server was online all the time this problem did not appear never. So everything was left in my server folder in a perfect condition and now appeared this problem. Also i have to tell you that before to close the server i reinstalled my windows and it is windows 7 first version i think because i had this Windows on a CD that is licensed. Maybe i must install some drivers or something for this console or idk. If u had this problem or if u know how to fix it i'll be very gratefull to you.
"SavePlayer":
I have a problem with the server console.
3 or 4 months ago i closed my server because i have an exam and it is hard to work on it if it's always open. So now i wanted to play a little and i opened the server on my computer (Windows) and i saw that when i discconect from the server my console crashes and the dates don't save. So after that i made a "/saveme" command to see if the problem is on my "SavePlayer" function. The problem it seems to be there, because when i am in game and i use '/saveme' comamnd the console crashes. I don't understand why because when my server was online all the time this problem did not appear never. So everything was left in my server folder in a perfect condition and now appeared this problem. Also i have to tell you that before to close the server i reinstalled my windows and it is windows 7 first version i think because i had this Windows on a CD that is licensed. Maybe i must install some drivers or something for this console or idk. If u had this problem or if u know how to fix it i'll be very gratefull to you.
"SavePlayer":
Код:
SavePlayer( playerid ) { new h, m, s, szYear, szMonth, szDay, query[ 9000 ]; TotalGameTime( playerid, h, m, s ); getdate( szYear, szMonth, szDay ); mysql_format( database, query, sizeof( query ), "UPDATE `Accounts` SET `LoggedIn` = 0, `LastOn` = '%02d/%02d/%02d', `Level` = '%d', `VIP` = '%d', `Cash` = '%d', `PremiumPoints` = '%d', `Headshots` = '%d', `Kills` = '%d', `Deaths` = '%d', `Hours` = '%d', `Minutes` = '%d', `Seconds` = '%d', `BestKillings` = '%d', `KillingSpree` = '%d'", szDay, szMonth, szYear, PlayerInfo[ playerid ][ p_admin_level ], PlayerInfo[ playerid ][ p_vip_level ], GetPlayerMoney(playerid), PlayerInfo[ playerid ][ p_premium_points ], PlayerInfo[ playerid ][ p_headshots ], PlayerInfo[ playerid ][ p_kills ], PlayerInfo[ playerid ][ p_deaths ], h, m, s, PlayerInfo[ playerid ][ p_best_killing_spree ], PlayerInfo[ playerid ][ p_killing_spree ] ); mysql_format( database, query, sizeof( query ), "%s, `FavSkin` = '%d', `UseSkin` = '%d', `Property` = '%d', `Positive` = '%d', `Negative` = '%d'", query, PlayerInfo[ playerid ][ p_fav_skin ], PlayerInfo[ playerid ][ p_use_skin ], PlayerInfo[ playerid ][ p_property_id ], PlayerInfo[ playerid ][ p_positive_respect ], PlayerInfo[ playerid ][ p_negative_respect ] ); mysql_format( database, query, sizeof( query ), "%s, `Kicks` = '%d', `Bans` = '%d', `Jails` = '%d', `Warns` = '%d', `ClearChats` = '%d', `ReactionTest` = '%d', `MathTest` = '%d', `Mutes` = '%d', `Jailed` = '%d', `JailTime` = '%d:%d', `Frozen` = '%d', `FreezeTime` = '%d:%d', `Muted` = '%d', `MuteTime` = '%d:%d'", query, PlayerInfo[ playerid ][ p_total_kicks ], PlayerInfo[ playerid ][ p_total_bans ], PlayerInfo[ playerid ][ p_total_jails ], PlayerInfo[ playerid ][ p_total_warns ], PlayerInfo[ playerid ][ p_total_clearchat ], PlayerInfo[ playerid ][ p_total_reactions ], PlayerInfo[ playerid ][ p_total_maths ], PlayerInfo[ playerid ][ p_total_mutes ], PlayerInfo[ playerid ][ p_jailed ], gTime[ playerid][ 0 ], gTime[ playerid][ 1 ], PlayerInfo[ playerid ][ p_frozen ], fTime[ playerid][ 0 ], fTime[ playerid ][ 1 ], PlayerInfo[ playerid ][ p_muted ], mTime[ playerid ][ 0 ], mTime[ playerid ][ 1 ] ); mysql_format( database, query, sizeof( query ), "%s, `RaceScore` = '%d', `DriftScore` = '%d', `Ignores` = '%d/%d/%d', `KickW` = '%d', `StatsNote` = '%d'", query, PlayerInfo[ playerid ][ p_race_points ], PlayerInfo[ playerid ][ p_drift_points ], PlayerInfo[ playerid ][ p_ignore_pm ], PlayerInfo[ playerid ][ p_ignore_goto ], PlayerInfo[ playerid ][ p_ignore_get ], PlayerInfo[ playerid ][ p_kick_warnings ], GiveNote( playerid ) ); mysql_format( database, query, sizeof( query ), "%s, `ColorMatchWon` = '%d', `MoneyBagFounds` = '%d', `AutoLogin` = '%d'", query, PlayerInfo[ playerid ][ p_color_match_won ], PlayerInfo[ playerid ][ p_m_bag_found ], PlayerInfo[ playerid ][ p_auto_login ] ); mysql_format( database, query, sizeof( query ), "%s, `MazeWon` = '%d', `SaveTime` = '%d', `ParkourWon` = '%d'", query, PlayerInfo[ playerid ][ p_maze_won ], PlayerInfo[ playerid ][ p_save_time ], PlayerInfo[ playerid ][ p_parkour_won ] ); mysql_format( database, query, sizeof( query ), "%s, `AntiFall` = '%d', `FlyMode` = '%d', `RainbowMode` = '%d', `God` = '%d', `GodCar` = '%d', `Boost` = '%d', `VipGodCar` = '%d', `VipGod` = '%d'", query, PlayerInfo[ playerid ][ p_anti_fall ], PlayerInfo[ playerid ][ p_vup ], PlayerInfo[ playerid ][ p_rainbow_vehicle ], PlayerInfo[ playerid ][ p_admin_god ], PlayerInfo[ playerid ][ p_admin_vehicle_god ], PlayerInfo[ playerid ][ p_boost ], PlayerInfo[ playerid ][ p_vip_vehicle_god ], PlayerInfo[ playerid ][ p_vip_god ] ); mysql_format( database, query, sizeof( query ), "%s, `UnJails` = '%d', `UnMutes` = '%d', `Gotos` = '%d', `Asays` = '%d', `Gets` = '%d', `Heals` = '%d', `Armours` = '%d'", query, PlayerInfo[ playerid ][ p_total_un_jails ], PlayerInfo[ playerid ][ p_total_un_mutes ], PlayerInfo[ playerid ][ p_total_gotos ], PlayerInfo[ playerid ][ p_total_admin_says ], PlayerInfo[ playerid ][ p_total_gets ], PlayerInfo[ playerid ][ p_total_heals ], PlayerInfo[ playerid ][ p_total_armour ] ); mysql_format( database, query, sizeof( query ), "%s, `PosGotos` = '%d', `Racs` = '%d', `Disarms` = '%d', `Explodes` = '%d', `Burns` = '%d', `Spawns` = '%d', `Freezes` = '%d', `UnFreezes` = '%d', `Akills` = '%d', `WriteColor` = '%d'", query, PlayerInfo[ playerid ][ p_total_pos_goto ], PlayerInfo[ playerid ][ p_total_racs ], PlayerInfo[ playerid ][ p_total_disarms ], PlayerInfo[ playerid ][ p_total_explodes ], PlayerInfo[ playerid ][ p_total_burns ], PlayerInfo[ playerid ][ p_total_spawns ], PlayerInfo[ playerid ][ p_total_freezes ], PlayerInfo[ playerid ][ p_total_un_freezes ], PlayerInfo[ playerid ][ p_total_admin_kills ], PlayerInfo[ playerid ][ p_write_color ] ); mysql_format( database, query, sizeof( query ), "%s, `PremiumLevel` = '%d', `Baits` = '%d', `Rod` = '%d', `DerbyWon` = '%d', `FalloutWon` = '%d', `Country` = '%s'", query, PlayerInfo[ playerid ][ p_premium_level ], PlayerInfo[ playerid ][ p_baits ], PlayerInfo[ playerid ][ p_rod ], PlayerInfo[ playerid ][ p_derby_won ], PlayerInfo[ playerid ][ p_fallout_won ], PlayerInfo[ playerid ][ p_country ] ); mysql_format( database, query, sizeof( query ), "%s, `PastBoost` = '%d', `PastIgnore_Goto` = '%d', `PastIgnore_Get` = '%d', `PastGod` = '%d', `PastVup` = '%d', `GodCar` = '%d', `PastVGodCar` = '%d', `PastVGod` = '%d', `ColorSwitchWon` = '%d'", query, PlayerInfo[ playerid ][ p_past_boost ], PlayerInfo[ playerid ][ p_past_ignore_goto ], PlayerInfo[ playerid ][ p_past_ignore_get ], PlayerInfo[ playerid ][ p_past_admin_god ], PlayerInfo[ playerid ][ p_past_vup ], PlayerInfo[ playerid ][ p_past_admin_vehicle_god ], PlayerInfo[ playerid ][ p_past_vip_vehicle_god ], PlayerInfo[ playerid ][ p_past_vip_god ], PlayerInfo[ playerid ][ p_color_switch_won ] ); mysql_format( database, query, sizeof( query ), "%s, `DingOnShot` = '%d', `NewName` = '%d', `NewNameTime` = '%d:%d', `SaveWeather` = '%d', `GangWeapon1` = '%d', `GangWeapon2` = '%d', `GangWeapon3` = '%d', `GangWeapon4` = '%d', `GangWeapon5` = '%d', `UseGangWeapons` = '%d'", query, PlayerInfo[ playerid ][ p_ding_on_shot ], PlayerInfo[ playerid ][ p_new_name_again ], nTime[ playerid ][ 0 ], nTime[ playerid ][ 1 ], PlayerInfo[ playerid ][ p_save_weather ], PlayerInfo[ playerid ][ p_gang_weapon_1 ], PlayerInfo[ playerid ][ p_gang_weapon_2 ], PlayerInfo[ playerid ][ p_gang_weapon_3 ], PlayerInfo[ playerid ][ p_gang_weapon_4 ], PlayerInfo[ playerid ][ p_gang_weapon_5 ], PlayerInfo[ playerid ][ p_use_gang_weapons ], PlayerInfo[ playerid ][ p_account_id ] ); mysql_format( database, query, sizeof( query ), "%s, `Ach1` = '%d', `Ach2` = '%d', `Ach3` = '%d', `Ach4` = '%d', `Ach5` = '%d', `Ach6` = '%d', `Ach7` = '%d', `Ach8` = '%d', `Ach9` = '%d', `Ach10` = '%d', `Ach11` = '%d', `Ach12` = '%d', `Ach13` = '%d', `Ach14` = '%d', `Ach15` = '%d', `Ach16` = '%d', `Ach17` = '%d', `Ach18` = '%d', `Ach19` = '%d', `AchsCompleted` = '%d' WHERE `ID` = '%d'", query, PlayerInfo[ playerid ][ p_ach_1 ], PlayerInfo[ playerid ][ p_ach_2 ], PlayerInfo[ playerid ][ p_ach_3 ], PlayerInfo[ playerid ][ p_ach_4 ], PlayerInfo[ playerid ][ p_ach_5 ], PlayerInfo[ playerid ][ p_ach_6 ], PlayerInfo[ playerid ][ p_ach_7 ], PlayerInfo[ playerid ][ p_ach_8 ], PlayerInfo[ playerid ][ p_ach_9 ], PlayerInfo[ playerid ][ p_ach_10 ], PlayerInfo[ playerid ][ p_ach_11 ], PlayerInfo[ playerid ][ p_ach_12 ], PlayerInfo[ playerid ][ p_ach_13 ], PlayerInfo[ playerid ][ p_ach_14 ], PlayerInfo[ playerid ][ p_ach_15 ], PlayerInfo[ playerid ][ p_ach_16 ], PlayerInfo[ playerid ][ p_ach_17 ], PlayerInfo[ playerid ][ p_ach_18 ], PlayerInfo[ playerid ][ p_ach_19 ], PlayerInfo[ playerid ][ p_ach_completed ], PlayerInfo[ playerid ][ p_account_id ] ); mysql_tquery( database, query, "", "" ); if( PlayerInfo[ playerid ][ p_property_id ] != 0 ) { new p_owner = PlayerInfo[ playerid ][ p_property_id ], p_query[ 9000 ]; mysql_format( database, p_query, sizeof( p_query ), "UPDATE `Properties` SET `PropOwner` = '%s', `PropName` = '%s' WHERE `ID` = '%d'", PlayerName( playerid ), PropertyInfo[ PlayerInfo[ playerid ][ p_property_id ] ][ p_property_name ], p_owner ); mysql_tquery( database, p_query, "", "" ); } return 1; }