[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) - Splav - 05.07.2012
Hello, all
I have special function written to R6 MySQL plugin
How can I rewrite it on R7 version?
Quote:
|
stock fromUnixTime(time) { new unbantime[25]; format(str, sizeof(str), "SELECT FROM_UNIXTIME( %d )", time); if(mysql_query(str) && mysql_store_result()) { mysql_fetch_row_format(unbantime); } mysql_free_result(); return unbantime; } |
Re: [REL] MySQL Plugin (R7 released) - Reboma - 06.07.2012
The memory leaking isnt fixed in the R7-2 version.
http://pastebin.com/raw.php?i=LGkJexAq
Re: [REL] MySQL Plugin (R7 released) - Kar - 06.07.2012
Quote:
|
Originally Posted by xxmitsu
 @kar, comment the entire callback
|
Re: [REL] MySQL Plugin (R7 released) - DarrenReeder - 06.07.2012
I am trying to use this feature:
pawn Код:
new string[100];
format(string, sizeof(string), "SELECT * FROM accounts WHERE Username='Darren'");
if(mysql_function_query(1, string, true, "Tester", "ss", "1", "1")) print("yes");
else print("no");
return 1;
}
forward Tester(playerid[], number[]);
public Tester(playerid[], number[]){
print("Number:");
return 1;
}
Re: [REL] MySQL Plugin (R7 released) - Reboma - 07.07.2012
Quote:
|
Originally Posted by DarrenReeder
I am trying to use this feature:
pawn Код:
|
If its dont work, enable mysql debug (in OnGameModeInit add: mysql_debug(true); ) and check the errors.
Re: [REL] MySQL Plugin (R7 released) - Tr1viUm - 09.07.2012
If you want to use threads for queries in a loop (especially with multiple indexes), then it differs a lot from the thread example on the Wiki. I faced this problem today (my queries also had to execute in a pattern) and luckily I solved it. I could not find any additional information about this in this forum so that is why I am sharing it here.
The solution I came up with is recursion. The idea was to keep calling the same function after a query had finished until it matches certain criteria. I will show some snippets below to illustrate what I have done.
This can be improved using mysql_function_query (R7 only).
Код:
#define MAX_STREETS 5
#define MAX_HOUSES 5
new streetHouses[MAX_STREETS][MAX_HOUSES];
#define S_THREAD_STREETS 1
new houseid = 0;
stock CreateStreet(streetid) {
if(houseid == 0) {
Thread_CreateStreet(streetid);
}
else {
print("[CreateStreet]: Thread is busy.");
}
}
stock Thread_CreateStreet(streetid) {
if(houseid == MAX_HOUSES) {
houseid = 0;
return 1;
}
else {
new query[99];
format(query, sizeof query,
"INSERT INTO streets (street_id, house_id, value)\
VALUES ('%i', '%i', %i)",
streetid, houseid, streetHouses[streetid][houseid]);
houseid++;
mysql_query(query, S_THREAD_STREETS, streetid);
}
return 0;
}
public OnQueryFinish(query[], resultid, extraid, connectionHandle) {
switch(resultid) {
case S_THREAD_STREETS: {
if(Thread_CreateStreet(extraid)) {
print("[Thread_CreateStreet]: "#MAX_HOUSES" houses have been saved");
}
}
default: {
printf("Unknown query: (Resultid %d, Connection ID %d, Query: %s)",resultid, connectionHandle, query);
}
}
return 1;
}
Код:
for(new houseid = 0; houseid < MAX_HOUSES; houseid++) {
// insert houses
}
Re: [REL] MySQL Plugin (R7 released) - Mr.Sphirit - 09.07.2012
Mirror MySQL Plugin R5 for linux ?
Re: [REL] MySQL Plugin (R7 released) - Tr1viUm - 09.07.2012
I uploaded R6-2 for windows:
http://www.solidfiles.com/d/b27395ff17/
AW: [REL] MySQL Plugin (R7 released) - Cank - 09.07.2012
@Tr1viUm
What's the advantage of using your recursive method instead of a loop?
Re: AW: [REL] MySQL Plugin (R7 released) - Tr1viUm - 09.07.2012
Quote:
|
Originally Posted by Cank
@Tr1viUm
What's the advantage of using your recursive method instead of a loop? |
Respuesta: [REL] MySQL Plugin (R7 released) - Sabio - 10.07.2012
Quote:
|
Error: Function not registered: 'mysql_store_result' Error: Function not registered: 'mysql_retrieve_row' Error: Function not registered: 'mysql_fetch_field_row' Error: Function not registered: 'mysql_free_result' Error: Function not registered: 'mysql_num_rows' Error: Function not registered: 'mysql_query' Error: Function not registered: 'mysql_debug' Error: Function not registered: 'mysql_connect' Error: Function not registered: 'mysql_ping' Error: Function not registered: 'mysql_close' Error: Function not registered: 'mysql_real_escape_string' Error: Function not registered: 'mysql_fetch_int' |
Someone help me? : (
Re: [REL] MySQL Plugin (R7 released) - AndreT - 10.07.2012
There are a few things to make sure of:
1. Does the log say something about the plugin failing to load or loading properly?
2. Is there a .so extension for the plugin in the server.cfg file? This is a common pitfall.
Also, for some awkward reason, the nativechecker plugin constantly keeps reporting that my natives are missing (on Linux) while they actually are present and loaded.
Respuesta: [REL] MySQL Plugin (R7 released) - Sabio - 10.07.2012
Yes, I have everything.
Now change the plugin and the errors are:
Quote:
|
Error: Function not registered: 'mysql_retrieve_row' Error: Function not registered: 'mysql_fetch_field_row' Error: Function not registered: 'mysql_debug' |
Re: [REL] MySQL Plugin (R7 released) - MickeyB - 10.07.2012
Which version of this should I be using at the moment to avoid most of these problems, or at least which is the best one currently?
Thanks in advance, MickeyB.
Re: [REL] MySQL Plugin (R7 released) - Mr.Sphirit - 10.07.2012
Mirror MySQL Plugin R5 for linux ?
Re: [REL] MySQL Plugin (R7 released) - Reboma - 11.07.2012
BlueG, when you will fix the Memory leak in R7?
Its really annoying.
Ps.: Isnt fixed in R7-2 fully ...
Re: Respuesta: [REL] MySQL Plugin (R7 released) - AndreT - 11.07.2012
Quote:
|
Originally Posted by Sabio
Yes, I have everything.
Now change the plugin and the errors are: |
Quote:
|
Originally Posted by Reboma
BlueG, when you will fix the Memory leak in R7?
Its really annoying. Ps.: Isnt fixed in R7-2 fully ... |
Also look at the posts made shortly after BlueG put R7-2 online. Someone describes another situation which could possibly be a memory leak. This could be helpful!
Re: [REL] MySQL Plugin (R7 released) - EvolutionS - 11.07.2012
Please reupload all
Re: Respuesta: [REL] MySQL Plugin (R7 released) - Kar - 11.07.2012
Quote:
|
Originally Posted by AndreT
Uhuh, but regardless of getting these errors (which, as I said, sometimes can be falsely generated), does the plugin work? Can you post what the console gives when it is trying to load the plugin?
I am positive that BlueG also has his own private life and other projects going on. As a side note, how large is this memory leak and have you used some sort of a tracer to perhaps help and find its source (note that I am not exactly familiar with the process)? This could possibly help fixing the memory leak. Also look at the posts made shortly after BlueG put R7-2 online. Someone describes another situation which could possibly be a memory leak. This could be helpful! |
R7-2 fixes, + Zeex's fix, has anyone compiled that yet?
Re: [REL] MySQL Plugin (R7 released) - EvolutionS - 11.07.2012
Please reupload plugin.