[FaLLenGirL]

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":

Код:

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;
}

[FaLLenGirL]

Код:

[16:15:29] UPDATE `Accounts` SET `LoggedIn` = 0, `LastOn` = '01/12/2017', `Level` = '5', `VIP` = '2', `Cash` = '99998', `PremiumPoints` = '0', `Headshots` = '0', `Kills` = '0', `Deaths` = '0', `Hours` = '0', `Minutes` = '0', `Seconds` = '34', `BestKillings` = '0', `KillingSpree` = '0'
[16:15:29] , `FavSkin` = '0', `UseSkin` = '0', `Property` = '0', `Positive` = '0', `Negative` = '0'
[16:15:29] , `Kicks` = '0', `Bans` = '0', `Jails` = '0', `Warns` = '0', `ClearChats` = '0', `ReactionTest` = '0', `MathTest` = '0', `Mutes` = '0', `Jailed` = '0', `JailTime` = '0:0', `Frozen` = '0', `FreezeTime` = '0:0', `Muted` = '0', `MuteTime` = '0:0'
[16:15:29] , `RaceScore` = '0', `DriftScore` = '0', `Ignores` = '0/0/0', `KickW` = '0', `StatsNote` = '1'
[16:15:29] , `ColorMatchWon` = '0', `MoneyBagFounds` = '0', `AutoLogin` = '0'
[16:15:29] , `MazeWon` = '0', `SaveTime` = '-1', `ParkourWon` = '0'
[16:15:29] , `AntiFall` = '0', `FlyMode` = '0', `RainbowMode` = '0', `God` = '0', `GodCar` = '0', `Boost` = '0', `VipGodCar` = '0', `VipGod` = '0'
[16:15:29] , `UnJails` = '0', `UnMutes` = '0', `Gotos` = '0', `Asays` = '0', `Gets` = '0', `Heals` = '0', `Armours` = '0'
[16:15:29] , `PosGotos` = '0', `Racs` = '0', `Disarms` = '0', `Explodes` = '0', `Burns` = '0', `Spawns` = '0', `Freezes` = '0', `UnFreezes` = '0', `Akills` = '0', `WriteColor` = '0'
[16:15:29] , `PremiumLevel` = '10', `Baits` = '0', `Rod` = '0', `DerbyWon` = '0', `FalloutWon` = '0', `Country` = 'Romania'
[16:15:29] , `PastBoost` = '0', `PastIgnore_Goto` = '0', `PastIgnore_Get` = '0', `PastGod` = '0', `PastVup` = '0', `GodCar` = '0', `PastVGodCar` = '0', `PastVGod` = '0', `ColorSwitchWon` = '0'
[16:15:29] , `DingOnShot` = '0', `NewName` = '0', `NewNameTime` = '0:0', `SaveWeather` = '-1', `GangWeapon1` = '0', `GangWeapon2` = '0', `GangWeapon3` = '0', `GangWeapon4` = '0', `GangWeapon5` = '0', `UseGangWeapons` = '0'
[16:15:29] , `Ach1` = '0', `Ach2` = '0', `Ach3` = '0', `Ach4` = '0', `Ach5` = '0', `Ach6` = '0', `Ach7` = '0', `Ach8` = '0', `Ach9` = '0', `Ach10` = '0', `Ach11` = '0', `Ach12` = '0', `Ach13` = '0', `Ach14` = '0', `Ach15` = '0', `Ach16` = '0', `Ach17` = '0', `Ach18` = '0', `Ach19` = '0', `AchsCompleted` = '0' WHERE `ID` = '8'
[16:15:29] [part] FaLLenGirL has left the server (0:1)

Everything it is ok but it doesn't update in Database.

[Dayrion]

Set DEBUG mysql's logs on and post it there after you run the query.

[FaLLenGirL]

Solved. Thx anyway.