[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!) - S4t3K - 26.03.2015
I'm testing it on a local server, on Windows.
Re: [REL] MySQL Plugin (Now on github!) - Banditukas - 27.03.2015
Here is some buggs. One time i on my gamemode all was loading (mysql) houses, bussines server crashed due unknow error (by crash detector), but there writes mysql, i reload server then everything okey, it'is maybe 1 way from 1000 that happin small but still there haven't be that.
Re: [REL] MySQL Plugin (Now on github!) - skydux123 - 28.03.2015
Please fix the link
Re: [REL] MySQL Plugin (Now on github!) - dusk - 28.03.2015
Why does cache_get_field_contente_int fail on converted types?
Table:
Code:
CREATE TABLE IF NOT EXISTS graffiti_colours ( id INT AUTO_INCREMENT NOT NULL, name VARCHAR(32) NOT NULL, argb VARCHAR(8) NOT NULL, PRIMARY KEY(id) ) ENGINE=INNODB DEFAULT CHARSET cp1257 COLLATE=cp1257_bin;
Code:
SELECT id, CONVERT(CONV(argb, 16, 10), SIGNED) AS argb FROM graffiti_colours WHERE name = '%e'
pawn Code:
cache_get_field_content_int(0, "argb");
Code:
20:47:45 cache_get_field_content_int OK row: 0, field_name: "argb", connection: 1 20:47:45 CMySQLResult::GetRowDataByName OK row: '0', field: "argb", data: "4294901760" 20:47:45 cache_get_field_content_int ERROR invalid datatype
Re: [REL] MySQL Plugin (Now on github!) - Vince - 28.03.2015
I believe it returns a 64 bit integer, which Pawn cannot handle. Not sure why you're not simply storing the color as an int rather than a varchar in the first place.
Re: [REL] MySQL Plugin (Now on github!) - dusk - 28.03.2015
Just for the ability to see it as a HEX in the database. I know that that should not be a factor when designing a database but...
Re: [REL] MySQL Plugin (Now on github!) - DarkPower2 - 30.03.2015
link not work!
Re: [REL] MySQL Plugin (Now on github!) - DetoNater - 31.03.2015
there's a problem loading the plugin. I have the latest versions of includes and I have 2012 Redistributable
Re: [REL] MySQL Plugin (Now on github!) - dusk - 31.03.2015
Quote:
|
Originally Posted by DarkPower2
 link not work!
|
Quote:
|
Originally Posted by DetoNater
there's a problem loading the plugin. I have the latest versions of includes and I have 2012 Redistributable
|
Re : [REL] MySQL Plugin (Now on github!) - MrAlexisX2 - 31.03.2015
New link for MYSQL R7 ?
EDIT : If you don't find the link, I give this website for you : http://kaperstone.ru/samp/mysql/
Re : [REL] MySQL Plugin (Now on github!) - S4t3K - 31.03.2015
This version is clearly outdated.
If there were updates, that's not only for the fun to work on a plugin : it adds new features and improvements.
If those version are not advocated, it's mainly because you see better, easier to learn/use and faster.
Those who stick with R7 are just too lazy to update their modes.
Re: [REL] MySQL Plugin (Now on github!) - ihatetn931 - 01.04.2015
delete found my answer
Re: [REL] MySQL Plugin (Now on github!) - Anuris - 01.04.2015
Hello BlueG.
Some kind of issue here...
SA-MP server 0.3z R4 with MySQL R39-3, running on Debian x64.
PHP Code:
//In some public
new qwery[300];
format(qwery, sizeof(qwery), "SELECT `lvl` FROM `admins` WHERE BINARY `Nick` = '%s'", GN(playerid));
mysql_function_query(MySQL, qwery, true, "OnAdminQueryFinished", "i", playerid);
SendClientMessage(playerid, -1, qwery);
PHP Code:
public OnAdminQueryFinished(playerid)
{
new lvl = cache_get_row_int(0,0);
SendMes(playerid, -1, "%i", lvl);
if(lvl > 0)
{
//Don't exec
}
else
{
//exec
}
return 0;
}
They sends:
Code:
[15:09:17] SELECT `lvl` FROM `admins` WHERE BINARY `Nick` = 'Эраст_Фандорин' [15:09:17] 0
Here is a point: I'm adding some symbols from Russian alphabet in my Query (`Nick` = 'Эраст_Фандорин'), but it works just fine with phpmyadmin.
UPD: works fine without Russian symbols...can you fix it, please?
Re: [REL] MySQL Plugin (Now on github!) - iZN - 01.04.2015
@Anuris:
pawn Code:
public OnAdminQueryFinished(playerid)
{
// first we've to check whether there are any results, if yes, it will simply continue.. otherwise, nothing will happen, you could add an else statement to the following if statement if you wanted to do something about when there are no row existing rows.
if(cache_get_row_count())
{
new lvl = cache_get_row_int(0,0);
SendMes(playerid, -1, "%i", lvl);
if(lvl > 0)
{
//Don't exec
}
else
{
//exec
}
}
return true; // returning true will clear out this callback's cache.
}
Re: [REL] MySQL Plugin (Now on github!) - iZN - 03.04.2015
Quote:
|
Originally Posted by Ralfie
Hi, how can if find if a specific word in a string im providing matches a row i have?
i.e: string = "Hello World" Table: Code:
... Something more like the strfind function: if (~strfind("World", "Hello Wrold", true)) |
PHP Code:
SELECT * FROM tbl_name WHERE tbl_field LIKE "% foo %";
Re: [REL] MySQL Plugin (Now on github!) - Anuris - 09.04.2015
I'm sorry, but...bump!
Quote:
|
Originally Posted by Anuris
Hello BlueG.
Some kind of issue here... SA-MP server 0.3z R4 with MySQL R39-3, running on Debian x64. PHP Code:
PHP Code:
They sends: Code:
[15:09:17] SELECT `lvl` FROM `admins` WHERE BINARY `Nick` = 'Эраст_Фандорин' [15:09:17] 0 Here is a point: I'm adding some symbols from Russian alphabet in my Query (`Nick` = 'Эраст_Фандорин'), but it works just fine with phpmyadmin. UPD: works fine without Russian symbols...can you fix it, please? |
Re: [REL] MySQL Plugin (Now on github!) - MotherDucker - 10.04.2015
Quote:
|
Originally Posted by iZN
|
If anyone does know how to use threading, could you please make a topic on how to use it with the newest release or if there already is a topic please can you link me?
Re: [REL] MySQL Plugin (Now on github!) - iZN - 10.04.2015
Quote:
|
Originally Posted by MotherDucker
No, I just don't know how to use threading.
If anyone does know how to use threading, could you please make a topic on how to use it with the newest release or if there already is a topic please can you link me? |
it's outdated but it should be fine, and then use the wiki for more details about the latest functions.
Re: [REL] MySQL Plugin (Now on github!) - Ahmad45123 - 15.04.2015
Whenever I include mysql, It crashes the compiler... Any fix is appreciated.
Please note that I dont use any functions... I just included it and the compiler crashes and whenever I remove it, The compiler works.
OK, I figured it out by looking at the code.
I just forgot to include MYSQL_USE_YINLINE or E_CALLBACK_DATA
Re: [REL] MySQL Plugin (Now on github!) - caoraivoso3 - 20.04.2015
well i have a bug to report, i use r39-2 and sometimes some weird shit goes like i crash(it is my client or intended by me to do it) and some variables are saved badly and i say badly because i am on x,y,z and it's saved on 1.23E10 0 0.35, or the money variable goes on rampage with positive or negative values.
It is quite annoying.
It is a bug discovered or something new?
well i use orm system if i didn't mention.