[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!) - basicllsw - 10.09.2014
Quote:
|
Originally Posted by dusk
 Are you sure you're using the R39-2 includes aswell? Or maybe you're compiling your gamemode with different ones?
|
Код:
/** * MySQL plugin R39-2 */
Код:
#define mysql_function_query(%0,%1,%2,%3,"%4"%5) mysql_tquery(%0,%1,%3,#%4%5)
Re: [REL] MySQL Plugin (Now on github!) - dusk - 10.09.2014
The function which the plugin will call must be a string name of it.
pawn Код:
mysql_function_query(handle,"SET NAMES TIS620",false,"sendquery");
EDIT: another question.
pawn Код:
mysql_pquery_inline(DbHandle,query,using inline FishingGearLoad, "i",playerid);
Also, I get these errors
pawn Код:
\pawno\include\a_mysql.inc(228) : error 017: undefined symbol "AMX_GetRelativeAddress"
\LT-RP\pawno\include\a_mysql.inc(231) : error 017: undefined symbol "Callback_Array"
Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 10.09.2014
You can, of course, pass other parameters (or none at all) to the inline callback, just like with a normal callback.
Some YSI-functions are undefined here, are you sure you have the whole YSI package installed?
Re: [REL] MySQL Plugin (Now on github!) - dusk - 11.09.2014
I was sure... But after I re-downloaded it the errors went away.
Re: [REL] MySQL Plugin (Now on github!) - TakeiT - 11.09.2014
getting a 403 on download
Re: [REL] MySQL Plugin (Now on github!) - iZN - 11.09.2014
Quote:
|
Originally Posted by TakeiT
getting a 403 on download
|
It's fine for me.
Re: [REL] MySQL Plugin (Now on github!) - nemesis- - 12.09.2014
Is there anything close to mysql_fetch_row() or mysql_fetch_row_format() where I can get a result set that I can then parse to my own liking w/ sscanf rather than having to use ORMs or field-by-field retrievals via cache_get_row()? I understand the idea of making this plugin frameworkish though I preferred to work directly with raw SQL like the older plugin allowed.
Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 12.09.2014
That string with the '|' delimiter is not "raw SQL", it was internally (in the plugin) generated in a for-loop with a 'cache_get_row()' like function. Thus it doesn't really make sense generating a string from all fields and then breaking it apart again through a parser (sscanf). 'cache_get_row()' is the only way (of course there are other ways, but they are also calling 'cache_get_row' internally) to retrieve data directly from the cached result set (because the "raw SQL" result is a 2D-string-array; the indices which are needed to access a field are the first two parameters in 'cache_get_row' and that field is directly stored into the third parameter passed to 'cache_get_row').
Re: [REL] MySQL Plugin (Now on github!) - DanGk3nNn - 13.09.2014
Link broken
Re: [REL] MySQL Plugin (Now on github!) - liinor - 14.09.2014
Give me working link for R7 ubuntu plugin!
Re: [REL] MySQL Plugin (Now on github!) - [CG]Milito - 14.09.2014
Hey, I got a question.
How can I check whether the server is connected to the mysql server or not?
As far as I know, the function mysql_ping is not longer supported, is it?
Re: [REL] MySQL Plugin (Now on github!) - DobbysGamertag - 15.09.2014
pawn Код:
new Database;
//OnGameModeInit()
public OnGameModeInit()
{
Database = mysql_connect(..);
if(mysql_errno(Database) != 0)return print("An error occured connecting to database.");
return 1;
}
Re: [REL] MySQL Plugin (Now on github!) - WhoIsYourDaddy - 15.09.2014
I'm looking for R7 version for Windows 64 bit. Please give me a link.
Re: [REL] MySQL Plugin (Now on github!) - psp12321 - 15.09.2014
Same but the R5 for linux
It will be perfect if you can fix the links :P Thanks!
Re: [REL] MySQL Plugin (Now on github!) - WopsS - 15.09.2014
Quote:
|
Originally Posted by [CG]Milito
Hey, I got a question.
How can I check whether the server is connected to the mysql server or not? As far as I know, the function mysql_ping is not longer supported, is it? |
pawn Код:
handle = mysql_connect("host", "user", "database", "password");
if(handle && mysql_errno(handle) == 0)
print("[MYSQL]: Connection to database was established!");
else
print("[MYSQL]: Connection to database failed!");
Re: [REL] MySQL Plugin (Now on github!) - liinor - 15.09.2014
Quote:
|
Originally Posted by WhoIsYourDaddy
I'm looking for R7 version for Windows 64 bit. Please give me a link.
|
Re: [REL] MySQL Plugin (Now on github!) - liinor - 15.09.2014
Quote:
|
Originally Posted by WhoIsYourDaddy
I'm looking for R7 version for Windows 64 bit. Please give me a link.
|
http://www.datafilehost.com/d/a57d6504
There you go!
Re: [REL] MySQL Plugin (Now on github!) - iFarbod - 15.09.2014
Quote:
|
Originally Posted by liinor
|
Why you guys want to start with that old versions?
...
How can i compile the plugin? What things i will need?
Re: [REL] MySQL Plugin (Now on github!) - iZN - 15.09.2014
Quote:
|
Originally Posted by iFarbod
How can i compile the plugin? What things i will need?
|
Re: [REL] MySQL Plugin (Now on github!) - Danny - 16.09.2014
Quote:
|
Originally Posted by iFarbod
I Don't know why you people guiding each other with this old versions (R5, R6, R7).
Why you guys want to start with that old versions? |