[Sergei]

If server is crashing that you should fix your scripts. And for restarts, just save all players' stats before restarting.

[-Davee-]

Okay, I removed this code from the timer.

[Julian2574]

Quote:

Originally Posted by MenaceX^ Why not to create a timer on each player's login when he logs in, that will save the account?

He meant that you make the timer run on EACH player that logins..

[dengli]

Quote:

Originally Posted by Sma_X If you use: Код: lls -al /usr/lib/libstdc++.so.6 I guess it should be symlinked like this Код: lrwxrwxrwx 1 root root 18 Jan 25 11:37 /usr/lib/libstdc++.so.6 -> libstdc++.so.6.0.8 and.. it should work. It's still not working ?

hello,now i use this lls -al /usr/lib/libstdc++.so.6,but it show thish: lls: command not found

[xxmitsu]

Quote:

Originally Posted by dengli Quote: Originally Posted by Sma_X If you use: Код: lls -al /usr/lib/libstdc++.so.6 I guess it should be symlinked like this Код: lrwxrwxrwx 1 root root 18 Jan 25 11:37 /usr/lib/libstdc++.so.6 -> libstdc++.so.6.0.8 and.. it should work. It's still not working ? hello,now i use this lls -al /usr/lib/libstdc++.so.6,but it show thish: lls: command not found

sorry, it's ls, typo mistake.

so,

Код:

ls -al /usr/lib/libstdc++.so.6

[MenaceX^]

Quote:

Originally Posted by »Julian™« Quote: Originally Posted by MenaceX^ Why not to create a timer on each player's login when he logs in, that will save the account? He meant that you make the timer run on EACH player that logins..

Huh? It's actually what I said, nah?

[dengli]

Quote:

Originally Posted by Sma_X Quote: Originally Posted by dengli Quote: Originally Posted by Sma_X If you use: Код: lls -al /usr/lib/libstdc++.so.6 I guess it should be symlinked like this Код: lrwxrwxrwx 1 root root 18 Jan 25 11:37 /usr/lib/libstdc++.so.6 -> libstdc++.so.6.0.8 and.. it should work. It's still not working ? hello,now i use this lls -al /usr/lib/libstdc++.so.6,but it show thish: lls: command not found sorry, it's ls, typo mistake. so, Код: ls -al /usr/lib/libstdc++.so.6

hello,it still don't work,i run the ls -al /usr/lib/libstdc++.so.6,it show the information about:
lrwxrwxrwx 1 root root 18 01-22 18:11 /usr/lib/libstdc++.so.6 -> libstdc++.so.6
than i reuse the plugins,but it still show the same thing:Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by plugins/mysql.so)..

[-Davee-]

With this plugin I no need to use

pawn Код:

mysql_free_result();

?

In my test script the memory freed automatically ( without mysql_free_result(); )

[MenaceX^]

Quote:

Originally Posted by Davee. With this plugin I no need to use pawn Код: mysql_free_result(); ? In my test script the memory freed automatically ( without mysql_free_result(); )

Your test script doesn't use this plugin then..

You must release the result by yourself.

[-Davee-]

Quote:

Originally Posted by MenaceX^ Quote: Originally Posted by Davee. With this plugin I no need to use pawn Код: mysql_free_result(); ? In my test script the memory freed automatically ( without mysql_free_result(); ) Your test script doesn't use this plugin then.. You must release the result by yourself.

I use mysql_store_result(); ... And I use this plugin

[MenaceX^]

Quote:

Originally Posted by Davee. Quote: Originally Posted by MenaceX^ Quote: Originally Posted by Davee. With this plugin I no need to use pawn Код: mysql_free_result(); ? In my test script the memory freed automatically ( without mysql_free_result(); ) Your test script doesn't use this plugin then.. You must release the result by yourself. I use mysql_store_result(); ... And I use this plugin

Well yes. Then where's the problem?

[xxmitsu]

Quote:

Originally Posted by dengli Quote: Originally Posted by Sma_X Quote: Originally Posted by dengli Quote: Originally Posted by Sma_X If you use: Код: lls -al /usr/lib/libstdc++.so.6 I guess it should be symlinked like this Код: lrwxrwxrwx 1 root root 18 Jan 25 11:37 /usr/lib/libstdc++.so.6 -> libstdc++.so.6.0.8 and.. it should work. It's still not working ? hello,now i use this lls -al /usr/lib/libstdc++.so.6,but it show thish: lls: command not found sorry, it's ls, typo mistake. so, Код: ls -al /usr/lib/libstdc++.so.6 hello,it still don't work,i run the ls -al /usr/lib/libstdc++.so.6,it show the information about: lrwxrwxrwx 1 root root 18 01-22 18:11 /usr/lib/libstdc++.so.6 -> libstdc++.so.6 than i reuse the plugins,but it still show the same thing:Failed (/usr/lib/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by plugins/mysql.so)..

Well, yes, as you have shown here
http://www.dumpt.com/img/viewer.php?...wp3fop7nb0.jpg
you only have
/usr/lib/libstdc++.so.6.0.8
so, your symlink is bad linked (linked yo itself)
do those commands

Код:

mv /usr/lib/libstdc++.so.6 /usr/lib/libstdc++.so.6.bak 
ln -s /usr/lib/libstdc++.so.6.0.8 /usr/lib/libstdc++.so.6

And try to start your plugin then.
what is done here:
With the first command, you backup your curent symlink by renaming it to libstdc++.so.6.bak
and with the second one, you link it to /usr/lib/libstdc++.so.6.0.8

[-Davee-]

Quote:

Originally Posted by MenaceX^ Quote: Originally Posted by Davee. Quote: Originally Posted by MenaceX^ Quote: Originally Posted by Davee. With this plugin I no need to use pawn Код: mysql_free_result(); ? In my test script the memory freed automatically ( without mysql_free_result(); ) Your test script doesn't use this plugin then.. You must release the result by yourself. I use mysql_store_result(); ... And I use this plugin Well yes. Then where's the problem?

Thats was a quesion

[StrickenKid]

Quote:

Originally Posted by Davee. Quote: Originally Posted by MenaceX^ Quote: Originally Posted by Davee. Quote: Originally Posted by MenaceX^ Quote: Originally Posted by Davee. With this plugin I no need to use pawn Код: mysql_free_result(); ? In my test script the memory freed automatically ( without mysql_free_result(); ) Your test script doesn't use this plugin then.. You must release the result by yourself. I use mysql_store_result(); ... And I use this plugin Well yes. Then where's the problem? Thats was a quesion

Yes, the plugin does free the result automatically on the next query (if stored), although, I advise you to do it manually, its more efficient.

[-Davee-]

Quote:

Originally Posted by StrickenKid Quote: Originally Posted by Davee. Quote: Originally Posted by MenaceX^ Quote: Originally Posted by Davee. Quote: Originally Posted by MenaceX^ Quote: Originally Posted by Davee. With this plugin I no need to use pawn Код: mysql_free_result(); ? In my test script the memory freed automatically ( without mysql_free_result(); ) Your test script doesn't use this plugin then.. You must release the result by yourself. I use mysql_store_result(); ... And I use this plugin Well yes. Then where's the problem? Thats was a quesion Yes, the plugin does free the result automatically on the next query (if stored), although, I advise you to do it manually, its more efficient.

Ok, and I have a problem with your and G-sTyLeZzZ's plugin too, my server crashed after about one day ( with G-sTyLeZzZ about 1-2 hours after restart ) the server is pingable, but I can't join, it stops at "Connected. Jointing the game..."

I think that this is because the connection is time out, but this function does not work for me with your plugin:

pawn Код:

MySQLCheck()
{
    if(mysql_ping() == 1)
    {
        mysql_connect(SQL_HOST, SQL_USER, SQL_PASS, SQL_DB);
    }
    return 1;
}

[Dreftas]

On my linux VPS, mysqld service used a lot of RAM when it was installed with XAMPP packet(apache/php/mysql). When I installed Apache, PHP and MySQL seperate, my mysqld service RAM usage decreased ~150MB.

[Calgon]

Don't worry, figured it out.

[Wutschkooo]

Well, hi guys...
i want to use that plugin but thats the error message in the log

Quote:

[00:01:21] Server Plugins [00:01:21] -------------- [00:01:21] Loading plugin: mysql.so [00:01:21] Failed (libmysqlclient.so.15: cannot open shared object file: No such file or directory) [00:01:21] Loaded 0 plugins.

could anyone help me please?

eh ... the server-os is Debian Lenny

[Calgon]

Quote:

Originally Posted by LoH | Wutschkooo Well, hi guys... i want to use that plugin but thats the error message in the log Quote: [00:01:21] Server Plugins [00:01:21] -------------- [00:01:21] Loading plugin: mysql.so [00:01:21] Failed (libmysqlclient.so.15: cannot open shared object file: No such file or directory) [00:01:21] Loaded 0 plugins. could anyone help me please? eh ... the server-os is Debian Lenny

You must install MySQL correctly on your server, refer to the first post.

[Wutschkooo]

Quote:

Originally Posted by FreddoX [BINMAN ] Quote: Originally Posted by LoH | Wutschkooo Well, hi guys... i want to use that plugin but thats the error message in the log Quote: [00:01:21] Server Plugins [00:01:21] -------------- [00:01:21] Loading plugin: mysql.so [00:01:21] Failed (libmysqlclient.so.15: cannot open shared object file: No such file or directory) [00:01:21] Loaded 0 plugins. could anyone help me please? eh ... the server-os is Debian Lenny You must install MySQL correctly on your server, refer to the first post.

ye but MySQL is correctly installed... So in this root folder: /usr/lib/ is the missing file "libmysqlclient.so.15" and anotherone named "libmysqlclient.so.15.0.0". Well, i don't understand the error.

(Sorry for my bad english ^^)