[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 (07/16/09) - APTEM - 04.08.2009
And it is possible to write though how with this function to work? And that new functions at all for me.
Re: [REL] MySQL Plugin (07/16/09) - agusfn20 - 05.08.2009
Where can i download the a_mysql.inc with those funcions?
Re: [REL] MySQL Plugin (07/16/09) - Sergei - 06.08.2009
Quote:
|
Originally Posted by agusfn20
Where can i download the a_mysql.inc with those funcions?
|
Re: [REL] MySQL Plugin (07/16/09) - agusfn20 - 06.08.2009
I cant see the download link of a_mysql.inc, please put the url in the reply
Re: [REL] MySQL Plugin (07/16/09) - Sergei - 06.08.2009
Quote:
|
Originally Posted by agusfn20
I cant see the download link of a_mysql.inc, please put the url in the reply
|
Re: [REL] MySQL Plugin (07/16/09) - agusfn20 - 06.08.2009
This function is not defined
samp_mysql_select_db
Re: [REL] MySQL Plugin (07/16/09) - Sergei - 06.08.2009
Quote:
|
Originally Posted by agusfn20
This function is not defined
samp_mysql_select_db |
Re: [REL] MySQL Plugin (07/16/09) - APTEM - 07.08.2009
I something and shall not understand as from sql to read the information. Write please ready code.
Код:
new Data[1024];
new Field[64];
new rcnt = 1;
MySQLFetchAcctRecord(PlayerInfo[playerid][pSQLID], Data);
samp_mysql_strtok(Field, "|", Data);
while (samp_mysql_strtok(Field, "|", "")==1)
{
Re: [REL] MySQL Plugin (07/16/09) - Sergei - 07.08.2009
Quote:
|
Originally Posted by APTEM
I something and shall not understand as from sql to read the information. Write please ready code.
Код:
new Data[1024];
new Field[64];
new rcnt = 1;
MySQLFetchAcctRecord(PlayerInfo[playerid][pSQLID], Data);
samp_mysql_strtok(Field, "|", Data);
while (samp_mysql_strtok(Field, "|", "")==1)
{
|
Re: [REL] MySQL Plugin (07/16/09) - DaLgakiran - 07.08.2009
My website is in different server. How can i connect the database?
Re: [REL] MySQL Plugin (07/16/09) - whooper - 07.08.2009
Type in the ip of your website or i think you can do domains not sure..
Re: [REL] MySQL Plugin (07/16/09) - Sergei - 07.08.2009
If mysql server is on the other server than gameserver you can feel nice lag.
And for connection just put a domain which points on that server ot its IP.
Re: [REL] MySQL Plugin (07/16/09) - Programie - 16.08.2009
I tried to load the plugin but it fails.
My Server is a VPS (Virtual Private Server) with Windows Server 2003 Standard x64 Edition and .NET Framework 2.0 + 3.0.
What can I do?
Re: [REL] MySQL Plugin (07/16/09) - silvan - 18.08.2009
hi peaple, i tried to work myself on it.. but the problem is that its loading the plugin... but its giving me an error on " File or function is not found. "
please help me
this is my config:
echo Executing Server Config...
plugins mysql
lanmode 0
rcon_password -----
maxplayers 32
port 7777
hostname Malta Role Play
gamemode0 mrp 1
filterscripts adminspec vactions
announce 1
query 1
weburl www.sa-mp.com
anticheat 0
password ----
This is my DB details:
( At the begining of the GM )
#define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_PASS "----"
#define MYSQL_DB "sampserver"
( Under OnGameModeInt )
samp_mysql_connect("MYSQL_HOST","MYSQL_USER","MYSQ L_PASS");
samp_mysql_select_db("MYSQL_DB");
please note that fields marked with " ---- " is done that by purpose... ( because can't risk a hack ) tghou thanks for help
This is my server log:
SA:MP Dedicated Server
----------------------
v0.2X, ©2005-2008 SA:MP Team
[00:23:52]
[00:23:52] Server Plugins
[00:23:52] --------------
[00:23:52] Loading plugin: mysql
[00:23:52]
-------------------------------------
MySQL plugin has been loaded
Version: 1.0.3
Initialized on SA:MP Windows 0.2X
-------------------------------------
[00:23:52] Loaded.
[00:23:52] Loaded 1 plugins.
[00:23:52]
[00:23:52] Filter Scripts
[00:23:52] ---------------
[00:23:52] Loading filter script 'adminspec.amx'...
[00:23:52] Loading filter script 'vactions.amx'...
[00:23:52] Loaded 2 filter scripts.
[00:23:52] Script[gamemodes/mrp.amx]: Run time error 19: "File or function is not found"
[00:24:02] --- Server Shutting Down.
[00:24:02]
-------------------------------------
MySQL plugin unloaded
-------------------------------------
Re: [REL] MySQL Plugin (07/16/09) - Programie - 18.08.2009
I think you have to write variables without quotes.
I mean that:
Код:
samp_mysql_connect("MYSQL_HOST","MYSQL_USER","MYSQL_PASS");
samp_mysql_select_db("MYSQL_DB");
Код:
samp_mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS); samp_mysql_select_db(MYSQL_DB);
plugins mysql.dll
But I'm not shure.
Re: [REL] MySQL Plugin (07/16/09) - silvan - 19.08.2009
the plugin is readable from the server... so the server.cfg is fine... tghou i removed the " " it still gave me error...
Re: [REL] MySQL Plugin (07/16/09) - Balon - 19.08.2009
Programie, you're wrong.
Код:
mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS); mysql_select_db(MYSQL_DB);
Re: [REL] MySQL Plugin (07/16/09) - silvan - 19.08.2009
then what needs to be?
Re: [REL] MySQL Plugin (07/16/09) - Sergei - 19.08.2009
It's this function:
Код:
mysql_connect(const host[],const user[],const database[],const password[])
Re: [REL] MySQL Plugin (07/16/09) - Programie - 19.08.2009
Oh yes, that was another plugin.
I'm currently using the plugin with "samp_..." (samp_mysql_connect(), ...) cause of it works and this one doesn't work. But I don't know why.
Don't understand it negatively!