[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)
+- 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 (Now on github!) - anou1 - 02.02.2014
Thank you, but I know.
But I can see only the source download.
Screenshot:
http://image.noelshack.com/fichiers/...7-download.png
Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 02.02.2014
The download was removed due to critical bugs.
Please wait for R36.
Re: [REL] MySQL Plugin (Now on github!) - anou1 - 02.02.2014
Okay, thank you !
Should I go back to R34 ? Cause I've the R35 files but I need mysql_static.so
Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 02.02.2014
Yes, you should use R34 until R36 is available. I think R36 will be ready within a week.
Re: [REL] MySQL Plugin (Now on github!) - DobbysGamertag - 03.02.2014
Is the connectionhandle needed in R34? or do you need one. Just switched from R6 to this.
Re: [REL] MySQL Plugin (Now on github!) - iZN - 07.02.2014
Thank you so much maddinat0r. Updating to R36 right away.
AW: [REL] MySQL Plugin (Now on github!) - ThomasTailor93 - 07.02.2014
I had many problems and errors with libmysqlclient but this here is very new to me:
Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)
BTW: I just wanted to compile it on my own but there is no boost library so the compiling failed.
Edit: Nevermind on boost library, I read the instructions on github.
Re: [REL] MySQL Plugin (Now on github!) - Konstantinos - 07.02.2014
EDIT: I had wrong configuration (for VPS instead of localhost) and GameModeExit function made the server "freeze".
Thanks for the update, I'll test it on the VPS (Linux) tomorrow!
Re: AW: [REL] MySQL Plugin (Now on github!) - IstuntmanI - 07.02.2014
Quote:
|
I'm sure this release is much stabler than R36 (mainly because it was successfully tested by half a dozen people before releasing it). |
Quote:
|
Originally Posted by ThomasTailor93
 I had many problems and errors with libmysqlclient but this here is very new to me:
Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference) BTW: I just wanted to compile it on my own but there is no boost library so the compiling failed. Edit: Nevermind on boost library, I read the instructions on github. |
Another great release, thanks !
Re: [REL] MySQL Plugin (Now on github!) - Misiur - 08.02.2014
I'm updating some old gamemode, and I have situation like this:
pawn Код:
new
LevelOfMudkipLikeness[MAX_PLAYERS char] = { 0, ... };
public OnPlayerConnect(playerid)
{
inline DatHandler()
{
if(cache_num_rows()) {
LevelOfMudkipLikeness{playerid} = cache_get_row_int(0, 0, handle);
}
}
mysql_tquery_inline(handle, "SELECT mudkipzlove FROM foobar WHERE 1 = 1", using inline DatHandler, "");
return 1;
}
public OnPlayerRequestClass(playerid, classid)
{
if(LevelOfMudkipLikeness{playerid} > 69) {
//do something
}
return 1;
}
1. Unthreaded query. Though, I'm afraid of server choking on that
2. While loop in OPRC, waiting for some another variable like "queryfinished" - again, server choking hazard
3. mysql_unprocessed_queries, but the information is too vague, and some other query might be running
Suggestions are very welcome
@down: ah, that's what I meant to write in 1, thanks
AW: [REL] MySQL Plugin (Now on github!) - Mellnik - 08.02.2014
@Misiur
What about sending a unthreaded query using mysql_query?
Re: [REL] MySQL Plugin (Now on github!) - CKA3KuH - 08.02.2014
orm_select in R36 don't work fine when MySQL returned an empty result!
Quote:
|
[08/02/2014 12:28:46] [debug] Server crashed due to an unknown error [08/02/2014 12:28:50] [debug] Native backtrace: [08/02/2014 12:28:50] [debug] #0 100019bc in ?? () from plugins\mysql.dll [08/02/2014 12:28:50] [debug] #1 004690a6 in ?? () from samp-server.exe -------------------------- SA-MP Server: 0.3x-R2 Exception At Address: 0xFF006AEC Module: (Unknown) Registers: EAX: 0x00000000 EBX: 0x0015CE60 ECX: 0x00158F80 EDX: 0x00000000 ESI: 0xFFFFFFFF EDI: 0x02A09858 EBP: 0x8B55FF8B ESP: 0x7C80244E EFLAGS: 0x00010246 Stack: +0000: 0x4BE80875 0x5DFFFFFF 0x900004C2 0x90909090 +0010: 0xFFFF9090 0x0000FFFF 0x24360000 0x90907C80 +0020: 0x90909090 0x90909090 0x90909090 0x90909090 +0030: 0xFF8B9090 0x8BEC8B55 0xF8830C45 0xFB840FFF +0040: 0xB900006E 0x00002710 0x4D8BE1F7 0xF7018908 +0050: 0x045189D8 0xF700D283 0x890189DA 0xC18B0451 +0060: 0x0008C25D 0x90909090 0x55FF8B90 0x006AEC8B +0070: 0xFF0875FF 0x8014BC15 0x0FC0857C 0x01089A8C +0080: 0x40C03300 0x0004C25D 0x839A9068 0x00A1647C +0090: 0x50000000 0x1024448B 0x10246C89 0x10246C8D +00A0: 0x5653E02B 0xF8458B57 0x50E86589 0xC7FC458B +00B0: 0xFFFFFC45 0x4589FFFF 0xF0458DF8 0x0000A364 +00C0: 0x8BC30000 0x8964F04D 0x0000000D 0x5E5F5900 +00D0: 0xC351C95B 0x90909090 0x90909090 0x90909090 +00E0: 0xFF8B9090 0x6AEC8B55 0x0C75FF00 0xE80875FF +00F0: 0x0000000E 0x0008C25D 0x90909090 0x90909090 +0100: 0x346A9090 0x80260868 0xFF7AE87C 0x45C7FFFF +0110: 0x000014BC 0xC045C700 0x00000001 0x7D8DC033 +0120: 0xABABABC4 0x8D57FF33 0xFF50BC45 0x80124815 +0130: 0xFC7D897C 0x0018A164 0x45890000 0x30408BDC |
Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 08.02.2014
Quote:
|
Originally Posted by CKA3KuH
orm_select in R36 don't work fine when MySQL returned an empty result!
|
Re: [REL] MySQL Plugin (Now on github!) - Mandrakke - 08.02.2014
Is R36 stable? I heard somewhere that the latest stable version is R33.
Re: [REL] MySQL Plugin (Now on github!) - Kar - 08.02.2014
r36 and r34 are stable, don't use r35. r35 should be scrapped as a release tbh.
Re: [REL] MySQL Plugin (Now on github!) - IstuntmanI - 08.02.2014
Quote:
|
Originally Posted by Mandrakke
Is R36 stable? I heard somewhere that the latest stable version is R33.
|
Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 08.02.2014
Quote:
|
Originally Posted by Kar
[...]r35 should be scrapped as a release tbh.
|
Re: [REL] MySQL Plugin (Now on github!) - Kar - 08.02.2014
Quote:
|
Originally Posted by maddinat0r
The only reason I haven't done this is because of the confusion. People would start wondering why there is a missing revision (R31 -> R32 -> R33 -> R34 -> R36; where's R35?!). I also reacted too slow, so I only removed the download links to the compiled binaries.
|
Re: [REL] MySQL Plugin (Now on github!) - IstuntmanI - 08.02.2014
Quote:
|
Originally Posted by Kar
Doesn't matter, R35's changelog should be linked with r36 or something or redirected with an explaination
|
Re: [REL] MySQL Plugin (Now on github!) - Misiur - 13.02.2014
Tried prebuilt R37, and now hand compiled master branch, so R37 + 1 commit.