[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 (R7 released) - xxmitsu - 09.06.2012
The compiled version of R7-2 source can be found at the address: http://www.egaming.ro/MySQL/ or http://mirror1.egaming.ro/MySQL/
Re: [REL] MySQL Plugin (R7 released) - Deagle[WS] - 09.06.2012
Quote:
|
Originally Posted by xxmitsu
 The compiled version of R7-2 source can be found at the address: http://www.egaming.ro/MySQL/
|
Re: [REL] MySQL Plugin (R7 released) - HB - 09.06.2012
http://www.neozftw.nl/files/mysql/r7-2/mysql.so
Is there any heads up on the GLIBCXX problem? I have been checking RPMs. I found the following package that should get GLIBCXX 3.4.9 installed: http://rpm.pbone.net/index.php3/stat...86_64.rpm.html
Perhaps that helps out. My machine appears to be running on CentOS 5, so this RPM is of no use to me.
Edit:
Actually, after some more searching, it appears that you need CentOS 6 for this plugin. CentOS 5 is incompatible: GLIBCXX 3.4.9 is not provided for CentOS 5 (3.4.8 is the most recent version).
Re: [REL] MySQL Plugin (R7 released) - kurta999 - 10.06.2012
For me with these verisons memory usage is 523 MB, with R7 (default) it was 140 - 200MB.
Re: [REL] MySQL Plugin (R7 released) - Kyle - 12.06.2012
There is an issue with 'mysql_format' - Sometimes it doesn't display the variables but displays how they are in the format, e.g - `PoliceRank`=%d and NOT - `PoliceRank`=1.
Please refer to this thread: https://sampforum.blast.hk/showthread.php?pid=1918575#pid1918575
When I tried 'Format' it worked, so it must be an issue / bug.
Also, it sometimes displays how it should be with the correct variable numbers, and other times it shows '%d' etc.
Re: [REL] MySQL Plugin (R7 released) - BaubaS - 13.06.2012
I have a problem with saving/loading server statistics. It always null
? No errors at all, where can be the problem?Saving:
pawn Код:
stock SaveStatistic()
{
new szQuery[289];
format(szQuery, 289, "UPDATE `statistika` SET `RekordoData` = '%s', `Saskaitos` = '%d', `Prisijungimai` = '%d', `Suimimai` = '%d', `Rekordas` = '%d', `DuotosBaudos` = '%d', `Ismetimai` = '%d', `Uzblokavimai` = '%d'",
sInfo[szRecordDate], sInfo[iAccounts], sInfo[iConnects], sInfo[iArrests], sInfo[iRecord], sInfo[iFines], sInfo[iKicks], sInfo[iBans]);
mysql_function_query(iHandle, szQuery, false, "", "");
}
pawn Код:
#define LoadStatistic() mysql_function_query(iHandle, "SELECT * FROM `statistika`", true, "OnServerStatisticLoad", "")
pawn Код:
PUB::OnServerStatisticLoad()
{
new
iFields,
iRows;
cache_get_data(iRows, iFields);
if (iRows)
{
new szResult[12];
cache_get_row(0, 0, sInfo[szRecordDate]);
cache_get_row(0, 1, szResult); sInfo[iAccounts] = strval(szResult);
cache_get_row(0, 2, szResult); sInfo[iConnects] = strval(szResult);
cache_get_row(0, 3, szResult); sInfo[iArrests] = strval(szResult);
cache_get_row(0, 4, szResult); sInfo[iRecord] = strval(szResult);
cache_get_row(0, 5, szResult); sInfo[iFines] = strval(szResult);
cache_get_row(0, 6, szResult); sInfo[iKicks] = strval(szResult);
cache_get_row(0, 7, szResult); sInfo[iBans] = strval(szResult);
}
return true;
}
Re: [REL] MySQL Plugin (R7 released) - dud - 13.06.2012
Why mysql_num_rows always return -1 ?
i have this in mysql log
Код:
[22:37:35] >> mysql_num_rows( Connection handle: 1 ) [22:37:35] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
Re: [REL] MySQL Plugin (R7 released) - Scottas - 14.06.2012
Using KickPlayer in callback, which get called by mysql_function_query, shows 'Lost connection to server' for client, which should be kicked. Can anyone confirm this?
Re: [REL] MySQL Plugin (R7 released) - Virtual1ty - 14.06.2012
Quote:
|
Originally Posted by Scottas
Using KickPlayer in callback, which get called by mysql_function_query, shows 'Lost connection to server' for client, which should be kicked. Can anyone confirm this?
|
Re: [REL] MySQL Plugin (R7 released) - TheRoss - 14.06.2012
fixed
Re: [REL] MySQL Plugin (R7 released) - Kar - 16.06.2012
I think theres another bug with the memory leak. (R7)
Every few hours or so my server goes up around 7/8mb and after it gets to 50mb+ (sometimes it may goto 60mb+) it crashes and crashdetect says it crashes to an unknown error.. which should be a plugin. Only happening since R7 and it only crashes at 50mb+
Re: [REL] MySQL Plugin (R7 released) - Cassandra - 16.06.2012
Quote:
|
Originally Posted by Scottas
Using KickPlayer in callback, which get called by mysql_function_query, shows 'Lost connection to server' for client, which should be kicked. Can anyone confirm this?
|
Re: [REL] MySQL Plugin (R7 released) - Nightmare[TR] - 17.06.2012
Guys,i was using another mysql script but i transformed it to this plugin. But there's a lot of differences between them.Others are easy,but one function is hopeless.
My plugin was StrickenKid's plug-in. There is a func. on his include,"mysql_fetch_string",i need this but there is no function for fetching string.Or i don't know
mysql_fetch_string(StrickenKid) = ?(BlueG)
Re: [REL] MySQL Plugin (R7 released) - Sergei - 17.06.2012
Quote:
|
mysql_fetch_field(0,field[]); |
Re: [REL] MySQL Plugin (R7 released) - doreto - 26.06.2012
I have 1 question is possible to connect to scripts into 1 db and both to work fine ?
Re: [REL] MySQL Plugin (R7 released) - Kyle - 26.06.2012
Anyone know why my server crashes when hosted on volt-host, but is fine on home host.
It's only when I spawn...
Re: [REL] MySQL Plugin (R7 released) - Luis- - 26.06.2012
Quote:
|
Originally Posted by KyleSmith
Anyone know why my server crashes when hosted on volt-host, but is fine on home host.
It's only when I spawn... |
Re: [REL] MySQL Plugin (R7 released) - Kyle - 26.06.2012
Quote:
|
Originally Posted by -Luis
Which version are you using? If you're using R7 check where you load the players information cause it happened to me, I was loading something which wasn't actually in my players database, after I added it, it stopped crashing. ( sorry if i'm wrong with this, it's only an example ).
|
Re: [REL] MySQL Plugin (R7 released) - marquezsanchez - 26.06.2012
hey gay i have detect an error in the callback system , when I try to kick player in the callback I receive that :
the code :
Quote:
|
PHP код:
|
et tant que san andreas est ouvert les 4 phrases se repetes. And Sorry for my bad english
Re: [REL] MySQL Plugin (R7 released) - Luis- - 27.06.2012
Dude, we can't do anything with the code you have provided. How are you calling OnCheckBanList?