SA-MP Forums Archive
[Plugin] [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 (/showthread.php?tid=122983)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - Sergei - 28.02.2010

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

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - -Davee- - 28.02.2010

Okay, I removed this code from the timer.

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - Julian2574 - 28.02.2010

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..

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - dengli - 01.03.2010

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


Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - xxmitsu - 01.03.2010

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


Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - MenaceX^ - 01.03.2010

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?

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - dengli - 01.03.2010

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)..


Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - -Davee- - 01.03.2010

With this plugin I no need to use
pawn Код:
mysql_free_result();
?

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

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - MenaceX^ - 01.03.2010

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.

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - -Davee- - 01.03.2010

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

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - MenaceX^ - 01.03.2010

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?

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - xxmitsu - 01.03.2010

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

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - -Davee- - 01.03.2010

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

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - StrickenKid - 01.03.2010

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.

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - -Davee- - 01.03.2010

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


Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - Dreftas - 07.03.2010

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.

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - Calgon - 07.03.2010

Don't worry, figured it out.

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - Wutschkooo - 07.03.2010

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

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - Calgon - 08.03.2010

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.

Re: [REL] SA:MP MySQL Plugin 1.2 - The Easiest Multithreading Implementation! - Wutschkooo - 08.03.2010

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 ^^)