[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: AW: [REL] MySQL Plugin (Now on github!) - maddinat0r - 21.12.2013
Quote:
|
Originally Posted by Leenert
 Hey everyone,
since updating to r34 i got the following error on server start: Код:
[16:36:35] [ERROR] CMySQLConnection::Connect - (error #2002) Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) |
Re: [REL] MySQL Plugin (Now on github!) - [DK]Dark_Knight - 21.12.2013
Hosting a server on a remote server, and MySQL is failing to start.
It works perfectly on my home computer and I've uploaded all necessarry files.
Is there something that needs to be installed on the server to get it running?
The server is Windows.
Код:
echo Executing Server Config... lanmode 0 rcon_password sefgsdfgdfghsder5tesr5y5ersy5er6yt maxplayers 25 port 7777 hostname SA-MP 0.3 Server gamemode0 Max filterscripts plugins mysql streamer sscanf whirlpool nativechecker announce 1 query 1
Код:
[23:49:48] Server Plugins [23:49:48] -------------- [23:49:48] Loading plugin: mysql [23:49:48] Failed. [23:49:48] Loading plugin: streamer [23:49:48] *** Streamer Plugin v2.6.1 by Incognito loaded *** [23:49:48] Loaded.
Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 22.12.2013
Quote:
|
Originally Posted by [DK]Dark_Knight
Hosting a server on a remote server, and MySQL is failing to start.
It works perfectly on my home computer and I've uploaded all necessarry files. Is there something that needs to be installed on the server to get it running? The server is Windows. Код:
[...] Код:
[23:49:48] Server Plugins [23:49:48] -------------- [23:49:48] Loading plugin: mysql [23:49:48] Failed. [23:49:48] Loading plugin: streamer [23:49:48] *** Streamer Plugin v2.6.1 by Incognito loaded *** [23:49:48] Loaded. |
Re: [REL] MySQL Plugin (Now on github!) - [DK]Dark_Knight - 22.12.2013
Quote:
|
Originally Posted by maddinat0r
Yes, there is: http://www.solidfiles.com/d/dcb62ce7e5/
|
It works perfectly on my own computer, but when I uploaded the stuff (As per pics) It errors.
========================================
Also to all those people that are getting this error
Код:
[ERROR] CMySQLHandle::ConnectT - (error #2003) Can't connect to MySQL server on 'SERVERIP' (10061)
pawn Код:
MySQL = mysql_connect(HOSTNAME, USERNAME, DATABASE, PASSWORD, PORT, BOOL:AUTORECONNECT);
pawn Код:
MySQL = mysql_connect("localhost", "DvL", "Samp", "toohardforyou", 3306, true);
Re : [REL] MySQL Plugin (Now on github!) - DeeJas - 23.12.2013
delete.
Re: [REL] MySQL Plugin (Now on github!) - DeeJas - 24.12.2013
delete.
AW: [REL] MySQL Plugin (Now on github!) - Mellnik - 24.12.2013
Uh you have to use the latest include file...
Re: [REL] MySQL Plugin (Now on github!) - [DK]Dark_Knight - 24.12.2013
Hey all, I figured it out!!!
If you are having the same problem as me do the following:
1- Download THIS (its the dependent librarys for SA-MP and MySQL plugin)
2- Extract them to your servers ROOT directory (The one containing samp-server.exe)
3- Run server, all should be working
This is the steps you take if you get the following error:
Код:
[23:49:48] Loading plugin: mysql [23:49:48] Failed. ... [23:49:49] Script[gamemodes/gamemode.amx]: Run time error 19: "File or function is not found"
Re: [REL] MySQL Plugin (Now on github!) - Aliassassin123456 - 25.12.2013
Solved
Hi, i have this problem:
Код:
[15:24:54] [ERROR] CMySQLQuery::Execute[SendQuery()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
pawn Код:
new ali[350];
format(ali, 350, "CREATE TABLE IF NOT EXISTS `%s` \
(`tPX` float(20) NOT NULL,\
`tPY` float(20) NOT NULL,\
`tText` varchar(500) NOT NULL,\
`tLSX` float(20) NOT NULL,\
`tLSY` float(20) NOT NULL,\
`tTSX` float(20) NOT NULL,\
`tTSY` float(20) NOT NULL,\
`tAlign` int(20) NOT NULL,\
`tColor` int(25) NOT NULL,\
`tUB` int(10) NOT NULL,\
`tBC` int(25) NOT NULL,\
`tShadow` int(20) NOT NULL,\
`tOL` int(25) NOT NULL,\
`tBGC` int(25) NOT NULL,\
`tFont` int(10) NOT NULL,",inputtext);
strcat(ali, "`tProportional` int(20) NOT NULL,\
`tSelectable` int(10) NOT NULL,\
`tPM` int(20) NOT NULL,\
`tPRX` float(20) NOT NULL,\
`tPRY` float(20) NOT NULL,\
`tPRZ` float(20) NOT NULL,\
`tPRZoom` float(20) NOT NULL,\
`tPVC1` int(10) NOT NULL,\
`tPVC2` int(10) NOT NULL,\
`Tyype` int(5) NOT NULL)\
ENGINE=MyISAM;",350);
mysql_tquery(handle, ali, "SendQuery", "");
Код:
OS: Windows 7 64bit MySQL Server version: 5.6.12 Plugin version: R34
Re: AW: [REL] MySQL Plugin (Now on github!) - DeeJas - 25.12.2013
delete.
Re: [REL] MySQL Plugin (Now on github!) - Patrick - 25.12.2013
Aliassassin123456 - This should work, but I suggest you stop coding in PAWN to create table, it's just waste of time, I suggest you create the table in phpMyAdmin
pawn Код:
define TABLE_NAME "Your_Table_Here"
public OnGameModeInit()
{
new ali[ 255 char ], handle;
format(ali, sizeof(ali), "CREATE TABLE IF NOT EXISTS `%s` \
(`tPX` float(20) NOT NULL,\
`tPY` float(20) NOT NULL,\
`tText` varchar(500) NOT NULL,\
`tLSX` float(20) NOT NULL,\
`tLSY` float(20) NOT NULL,\
`tTSX` float(20) NOT NULL,\
`tTSY` float(20) NOT NULL,\
`tAlign` int(20) NOT NULL,\
`tColor` int(25) NOT NULL,\
`tUB` int(10) NOT NULL,\
`tBC` int(25) NOT NULL,\
`tShadow` int(20) NOT NULL,\
`tOL` int(25) NOT NULL,\
`tBGC` int(25) NOT NULL,\
`tFont` int(10) NOT NULL,");
format(ali, sizeof(ali), "`tProportional` int(20) NOT NULL,\
`tSelectable` int(10) NOT NULL,\
`tPM` int(20) NOT NULL,\
`tPRX` float(20) NOT NULL,\
`tPRY` float(20) NOT NULL,\
`tPRZ` float(20) NOT NULL,\
`tPRZoom` float(20) NOT NULL,\
`tPVC1` int(10) NOT NULL,\
`tPVC2` int(10) NOT NULL,\
`Tyype` int(5) NOT NULL)\
ENGINE=MyISAM;", TABLE_NAME);
mysql_tquery(handle, ali, "SendQuery", "");
}
Re: [REL] MySQL Plugin (Now on github!) - Aliassassin123456 - 25.12.2013
@pds2k12
0.Thanks for reply
1.I knew phpMyAdmin and i am always working with that.
2.There is a reason to i didn't use phpMyAdmin for that and it's: that table isn't a global table like users, it's project to save textdraws
and player can create table in game 3.There isn't any different in the format for packed strings:
pawn Код:
new ali[ 255 char ], handle;
/*=======>*/format(ali, sizeof(ali), "CREATE TABLE IF NOT EXISTS `%s` \
(`tPX` float(20) NOT NULL,\
`tPY` float(20) NOT NULL,\
`tText` varchar(500) NOT NULL,\
`tLSX` float(20) NOT NULL,\
`tLSY` float(20) NOT NULL,\
`tTSX` float(20) NOT NULL,\
`tTSY` float(20) NOT NULL,\
`tAlign` int(20) NOT NULL,\
`tColor` int(25) NOT NULL,\
`tUB` int(10) NOT NULL,\
`tBC` int(25) NOT NULL,\
`tShadow` int(20) NOT NULL,\
`tOL` int(25) NOT NULL,\
`tBGC` int(25) NOT NULL,\
`tFont` int(10) NOT NULL,");
/*=======>*/format(ali, sizeof(ali), "`tProportional` int(20) NOT NULL,\
`tSelectable` int(10) NOT NULL,\
`tPM` int(20) NOT NULL,\
`tPRX` float(20) NOT NULL,\
`tPRY` float(20) NOT NULL,\
`tPRZ` float(20) NOT NULL,\
`tPRZoom` float(20) NOT NULL,\
`tPVC1` int(10) NOT NULL,\
`tPVC2` int(10) NOT NULL,\
`Tyype` int(5) NOT NULL)\
ENGINE=MyISAM;", TABLE_NAME);
Problem solved, i use ALTER TABLE `table_name` ADD `column_name` column_type(column_size) NOT NULL;
Anyway, Thanks
Re: [REL] MySQL Plugin (Now on github!) - PakPak - 25.12.2013
Hey. im using the mysql plugin R33 (https://sampforum.blast.hk/showthread.php?tid=56564 ),
It works on my other pc, but on this one it doesn't work.
Код:
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3x, ©2005-2013 SA-MP Team [19:59:24] [19:59:24] Server Plugins [19:59:24] -------------- [19:59:24] Loading plugin: mysql [19:59:24] Failed. [19:59:24] Loading plugin: streamer [19:59:24] *** Streamer Plugin v2.6.1 by Incognito loaded *** [19:59:24] Loaded. [19:59:24] Loading plugin: sscanf [19:59:24] [19:59:24] =============================== [19:59:24] sscanf plugin loaded. [19:59:24] Version: 2.8.1 [19:59:24] © 2012 Alex "Y_Less" Cole [19:59:24] =============================== [19:59:24] Loaded. [19:59:24] Loading plugin: nativechecker [19:59:24] Loaded. [19:59:24] Loading plugin: Whirlpool [19:59:24] [19:59:24] ================== [19:59:24] [19:59:24] Whirlpool loaded [19:59:24] [19:59:24] ================== [19:59:24] [19:59:24] Loaded. [19:59:24] Loaded 4 plugins. [19:59:24] [19:59:24] Filterscripts [19:59:24] --------------- [19:59:24] Loaded 0 filterscripts. [19:59:24] Error: Function not registered: 'cache_get_row_count' [19:59:24] Error: Function not registered: 'mysql_close' [19:59:24] Error: Function not registered: 'mysql_connect' [19:59:24] Error: Function not registered: 'mysql_tquery' [19:59:24] Error: Function not registered: 'cache_get_data' [19:59:24] Error: Function not registered: 'cache_get_row_int' [19:59:24] Error: Function not registered: 'cache_get_row' [19:59:24] Error: Function not registered: 'cache_get_row_float' [19:59:24] Error: Function not registered: 'cache_insert_id' [19:59:24] Error: Function not registered: 'WP_Hash' [19:59:24] Error: Function not registered: 'mysql_escape_string' [19:59:24] Script[gamemodes/MyRP.amx]: Run time error 19: "File or function is not found" [19:59:24] Number of vehicle models: 0
I don't know what i am doing wrong.
Ive also re-installed .net framework, but that didn't help too
any one knows what the problem is?
Re: [REL] MySQL Plugin (Now on github!) - maddinat0r - 25.12.2013
Quote:
|
Originally Posted by PakPak
Hey. im using the mysql plugin R33 (https://sampforum.blast.hk/showthread.php?tid=56564 ),
It works on my other pc, but on this one it doesn't work. Код:
[...] [19:59:24] Loading plugin: mysql [19:59:24] Failed. [...] I don't know what i am doing wrong. Ive also re-installed .net framework, but that didn't help too any one knows what the problem is? |
Try installing this onto the PC where the plugin fails to load.
Re: [REL] MySQL Plugin (Now on github!) - Konstantinos - 26.12.2013
Is it? It seems like it's going to set to its first cell. I haven't tried that in-game to see whether it works or not, only while compiling. I'm going to test it and edit my post.
It seems so. Too sad, it'd be really nice.
Re: [REL] MySQL Plugin (Now on github!) - [DK]Dark_Knight - 26.12.2013
pawn Код:
//Make an enum for all player data
enum PlayerData
{
ORM:ORM_ID,
ID,
Username[24],
Password[129],
Admin
};
new playerData[MAX_PLAYERS][PlayerData];
public OnPlayerConnect(playerid)
{
GetPlayerName(playerid, Player_Name[playerid][Username], MAX_PLAYER_NAME);
new ORM:ormid = playerData[playerid][ORM_ID] = orm_create("players");
orm_addvar_int(ormid, playerData[playerid][ID], "id");
orm_addvar_string(ormid, playerData[playerid][Username], MAX_PLAYER_NAME, "name");
orm_addvar_string(ormid, playerData[playerid][Password], 128, "pass");
// ... password etc.
orm_addvar_int(ormid, playerData[playerid][Admin], "admin");
//Set Key to Username so we can search the database for that user and load all info as above
orm_setkey(ormid, "Username");
//Selects all data from database where Username = players name and then calls OnPlayerDataLoad
orm_select(ormid, "OnPlayerDataLoad", "d", playerid);
// more..
return 1;
}
forward OnPlayerDataLoad(playerid);
public OnPlayerDataLoad(playerid)
{
switch(orm_errno(pData[playerid][ORM_ID]))
{
case ERROR_OK:
{
//LOGIN PLAYER STUFF
}
case ERROR_NO_DATA:
{
//User was not found in database, make them register
}
}
//Change the key to ID for future updating of mysql
orm_setkey(pData[playerid][ORM_ID], "ID");
return 1;
}
Re: [REL] MySQL Plugin (Now on github!) - Konstantinos - 27.12.2013
Quote:
|
Originally Posted by maddinat0r
Player_Name[playerid][0] is correct, did you tried it like that? You can use orm_addvar_* with every variable you like.
Also passing char-typed variables per reference is unsupported in PAWN (or maybe it is? someone should ask ****** about that one). |
I asked ****** and he said that it's not possible to pass it by reference. That ruined it for me, so I guess I'll be using cache again. Atleast, I learned about ORM!
@[DK]Dark_Knight: The thing is that I don't want to use an enumeration.
Re: Re : [REL] MySQL Plugin (Now on github!) - DeeJas - 27.12.2013
delete.
Re: [REL] MySQL Plugin (Now on github!) - xeeZ - 27.12.2013
DeeJas: You have to install Visual C++ 2012 runtime: http://www.microsoft.com/en-us/downl....aspx?id=30679 (select vcredist_x86.exe, even if your system is x64).
Re: [REL] MySQL Plugin (Now on github!) - DeeJas - 27.12.2013
delete.