Bckup mysql data
I am using zp bank sql for saving amopacks on zombie mod and I am thinking if mysql go down in the midle of the game what can I do so player dont lose his data, because when the map will be changed and mysql is up again then will load the last data that was saved before mysql go down . what can i do for not losing data when mysql is down ...
|
Re: Bckup mysql data
If ammo packs will be saved whenever they earn +1 this couldn't happen (I guess)
|
Re: Bckup mysql data
i dont understand what you say what i want is to get another way of saving ammo packs when mysql is down how i can detect when mysql go down ? i use this http://forums.alliedmods.net/showthread.php?t=121541
and i tried to save with nvault but how can i detect if mysql go down in the midle of the game ? |
Re: Bckup mysql data
There is a way but you need to edit code. When mysql goes down, then your queries will fail. You can then use SQL_GetQueryString to get original query string and store it in a file. Once the connection is reestablished you can execute all saved queries.
|
Re: Bckup mysql data
Quote:
|
Re: Bckup mysql data
use plugin_end();
it's hook when map chaned |
Re: Bckup mysql data
in conclusion how i check if mysql goes down, i mean if map is changed then it showing that mysql is down but if is int middle of the game is not showing so i have to check this .. how ?
|
Re: Bckup mysql data
Quote:
PHP Code:
|
Re: Bckup mysql data
this check will be made at start game like plugin_init ?
how do i check this with a task in the game |
Re: Bckup mysql data
Can be checked with SQL_ThreadQuery();
|
| All times are GMT -4. The time now is 20:38. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.