[Help]Restart server and rollback!

[Looky]

Hi,(official files)

I have a big problem when i close the WorldServer to restart the server, some players lose items, experience or level.
Why?
And is there a way to save the database correctly at each restart please?

Sorry for my bad english, thank you.

[MentaL]

[eejhey]

close the cache server first.
then when you see CCU:0 on your worldserver, everyone's last activity should have been saved.

[Looky]

Ok thank you eejhey

[AccountDeleted]

close the cache server first.
then when you see CCU:0 on your worldserver, everyone's last activity should have been saved.

The cache server is where the players data is being 'cached', yeah ironic right with the name cache server and all?...

Thus closing it would just simply clear all cached data that has not been saved to the database yet causing the rollback.

[BGxAshtonJ1]

What i did is setup a php page named dc.php and inside i put

$online = @fsockopen("127.0.0.1", 12001, $errno, $errstr, 1);
    if($online >= 1) { 
        echo '<b><font color=#00FF00>Online</font></b>';
    }
    else {
    echo '<b><font color=#FF0000>Offline</font></b>';
    } 
    $online = @fsockopen("127.0.0.1", 23000, $errno, $errstr, 1);
    if($online >= 1) { 
        echo '<b><font color=#00FF00>Online</font></b>';
    }
    else {
    echo '<b><font color=#FF0000>Offline</font></b>';
    } 
    $online = @fsockopen("127.0.0.1", 7000, $errno, $errstr, 1);
    if($online >= 1) { 
        echo '<b><font color=#00FF00>Online</font></b>';
    }
    else {
    echo '<b><font color=#FF0000>Offline</font></b>';
    } 
    $online = @fsockopen("127.0.0.1", 4001, $errno, $errstr, 1);
    if($online >= 1) { 
        echo '<b><font color=#00FF00>Online</font></b>';
    }
    else {
    echo '<b><font color=#FF0000>Offline</font></b>';
    } 
    $online = @fsockopen("127.0.0.1", 15400, $errno, $errstr, 1);
    if($online >= 1) { 
        echo '<b><font color=#00FF00>Online</font></b>';
    }
    else {
    echo '<b><font color=#FF0000>Offline</font></b>';
    } 
    $online = @fsockopen("127.0.0.1", 28000, $errno, $errstr, 1);
    if($online >= 1) { 
        echo '<b><font color=#00FF00>Online</font></b>';
    }
    else {
    echo '<b><font color=#FF0000>Offline</font></b>';
    } 
    $online = @fsockopen("127.0.0.1", 2101 , $errno, $errstr, 1);
    if($online >= 1) { 
        echo '<b><font color=#00FF00>Online</font></b>';
    }
    else {
    echo '<b><font color=#FF0000>Offline</font></b>';
    } 

And that will disconnect all users online and the 30+ times i tested it there was no rollback (I DON'T GUARANTEE THAT THIS WILL WORK BUT IT WORKED FOR ME)