[Plugin] [REL] MySQL Plugin (Now on github!)

[Plugin] [REL] MySQL Plugin (Now on github!) - 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] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128

Re: [REL] MySQL Plugin (****** Project) - saamp - 27.09.2013

Thank you, I understand now.

Sometimes when I close my gamemode ( exit in console ) crashdetect prints me this:

Код:

server_log.txt

[27/09/2013 15:38:42] plugin.mysql: Unloading plugin...
[27/09/2013 15:38:42] [debug] Server crashed due to an unknown error
[27/09/2013 15:38:42] [debug] Native backtrace:
[27/09/2013 15:38:42] [debug] #0 6d99ccb6 in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\plugins\mysql.DLL
[27/09/2013 15:38:42] [debug] #1 6d99d9ff in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\plugins\mysql.DLL
[27/09/2013 15:38:42] [debug] #2 6d9aef39 in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\plugins\mysql.DLL
[27/09/2013 15:38:42] [debug] #3 004690eb in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\samp-server.exe
[27/09/2013 15:38:42] [debug] #4 004888d6 in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\samp-server.exe

AW: Re: [REL] MySQL Plugin (****** Project) - maddinat0r - 27.09.2013

Quote:

Originally Posted by saamp

Thank you, I understand now.

Sometimes when I close my gamemode ( exit in console ) crashdetect prints me this:

Код:

server_log.txt

[27/09/2013 15:38:42] plugin.mysql: Unloading plugin...
[27/09/2013 15:38:42] [debug] Server crashed due to an unknown error
[27/09/2013 15:38:42] [debug] Native backtrace:
[27/09/2013 15:38:42] [debug] #0 6d99ccb6 in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\plugins\mysql.DLL
[27/09/2013 15:38:42] [debug] #1 6d99d9ff in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\plugins\mysql.DLL
[27/09/2013 15:38:42] [debug] #2 6d9aef39 in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\plugins\mysql.DLL
[27/09/2013 15:38:42] [debug] #3 004690eb in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\samp-server.exe
[27/09/2013 15:38:42] [debug] #4 004888d6 in ?? () from C:\Users\UserName\Desktop\Mode\!!Server\samp-server.exe

http://www.solidfiles.com/d/d66861dbeb/
You can try this version, it has two bug fixes in it, one bug fix could be related to that crash.

Re: [REL] MySQL Plugin (****** Project) - caoraivoso3 - 28.09.2013

cache_get_row( row, idx, dest[] [, connectionHandle = 1] ) what is the row? i am making now some of the save system for my gamemode.
I want to save my things to multiple tables and i dont know how. someone can explain to me?

Re: [REL] MySQL Plugin (****** Project) - NSA - 05.10.2013

Anyone help me?

Re: [REL] MySQL Plugin (****** Project) - Luis- - 05.10.2013

You never asked for help.

AW: Re: [REL] MySQL Plugin (****** Project) - maddinat0r - 05.10.2013

Quote:

Originally Posted by NSA

Hi guys.
How to fix it?

symbol lookup error: plugins/mysql.so: undefined symbol: compress

Quote:

Originally Posted by NSA

Anyone help me?

Quote:

Originally Posted by Luis-

You never asked for help.

He did

However, I don't give support to versions older than R7. Maybe someone else is willing to help you.

Re: [REL] MySQL Plugin (****** Project) - Luis- - 05.10.2013

Ah. My mistake.

AW: Re: [REL] MySQL Plugin (****** Project) - maddinat0r - 06.10.2013

R34 is released.
Changes:

Код:

- fixed bug where orm_update generated wrong queries
- fixed bug where queries sometimes lost connection to a remote database
- added natives "orm_load" and "orm_save" for even easier data management
- added additional (optional) parameter "use_cache" for native "mysql_query" to determine if the cache will be used or not
- added native "mysql_unprocessed_queries" to retrieve the amount of unprocessed queries
- improved backward compatibility a bit

There is also a new wiki page for this plugin available here.

As always, have fun with it and please report bugs and possible suggestions.

Re: AW: Re: [REL] MySQL Plugin (****** Project) - Konstantinos - 06.10.2013

Quote:

Originally Posted by maddinat0r

R34 is released.
Changes:

Код:

- fixed bug where orm_update generated wrong queries
- fixed bug where queries sometimes lost connection to a remote database
- added natives "orm_load" and "orm_save" for even easier data management
- added additional (optional) parameter "use_cache" for native "mysql_query" to determine if the cache will be used or not
- added native "mysql_unprocessed_queries" to retrieve the amount of unprocessed queries
- improved backward compatibility a bit

There is also a new wiki page for this plugin available here.

As always, have fun with it and please report bugs and possible suggestions.

Great! Finally, wiki was updated for the latest versions of MySQL.

Re: [REL] MySQL Plugin (****** Project) - IstuntmanI - 06.10.2013

Nice release.

Re: AW: Re: [REL] MySQL Plugin (****** Project) - Sublime - 06.10.2013

Quote:

Originally Posted by maddinat0r

R34 is released.
Changes:

Код:

- fixed bug where orm_update generated wrong queries
- fixed bug where queries sometimes lost connection to a remote database
- added natives "orm_load" and "orm_save" for even easier data management
- added additional (optional) parameter "use_cache" for native "mysql_query" to determine if the cache will be used or not
- added native "mysql_unprocessed_queries" to retrieve the amount of unprocessed queries
- improved backward compatibility a bit

There is also a new wiki page for this plugin available here.

As always, have fun with it and please report bugs and possible suggestions.

I want to marry you so badly!

Re: AW: Re: [REL] MySQL Plugin (****** Project) - iZN - 06.10.2013

Quote:

Originally Posted by Sublime

I want to marry you so badly!

what the hell are you talking about lol?

On-topic: Great work as usual !

Re: [REL] MySQL Plugin (****** Project) - kurta999 - 06.10.2013

New idea: Add support to pass arrays in mysql_tquery(). ("a")

Re: [REL] MySQL Plugin (****** Project) - Misiur - 08.10.2013

A little bit unrelated question - what's the diffrence between (cell) and static_cast<cell> typecasting? Is it simply changing syntax to C++, or it has some additional consequences?

Re: [REL] MySQL Plugin (****** Project) - cyber_punk - 08.10.2013

Quote:

Originally Posted by Misiur

A little bit unrelated question - what's the diffrence between (cell) and static_cast<cell> typecasting? Is it simply changing syntax to C++, or it has some additional consequences?

http://www.cplusplus.com/doc/tutorial/typecasting/

Re: [REL] MySQL Plugin (****** Project) - Kyra - 09.10.2013

On R34 we can use "SELECT" type query without cache? If we can i need to use "mysql_store" and "mysql_free_result" for "SELECT" query?

Re: [REL] MySQL Plugin (****** Project) - Sp3cter - 11.10.2013

Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)

Why I get that error?

Re: [REL] MySQL Plugin (****** Project) - maddinat0r - 11.10.2013

Quote:

Originally Posted by Kyra

On R34 we can use "SELECT" type query without cache? If we can i need to use "mysql_store" and "mysql_free_result" for "SELECT" query?

Why don't you want to use the cache?

Quote:

Originally Posted by Sp3cter

Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)

Why I get that error?

What OS do you use? What is your MySQL server version?

Re: [REL] MySQL Plugin (****** Project) - Sp3cter - 11.10.2013

Quote:

Originally Posted by maddinat0r

Why don't you want to use the cache?

What OS do you use? What is your MySQL server version?

Ubuntu Linux 12.04.2 / MySQL version 5.5.32

Re: [REL] MySQL Plugin (****** Project) - maddinat0r - 11.10.2013

Quote:

Originally Posted by Sp3cter

Ubuntu Linux 12.04.2 / MySQL version 5.5.32

Huh, didn't wanted to ask about the server version, I need the MySQL client version. However, I assume that your MySQL server is running on the same machine as your SA-MP server.
The default mysql.so is for MySQL client version 5.1.x.The Linux download includes two .so's: mysql.so (for 5.1) and mysql_5.5.so (obviously for 5.5).
tl;dr: use the mysql_5.5.so