Mysql - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Other (https://sampforum.blast.hk/forumdisplay.php?fid=7)
+--- Forum: Everything and Nothing (https://sampforum.blast.hk/forumdisplay.php?fid=23)
+--- Thread: Mysql (/showthread.php?tid=634220)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Other (https://sampforum.blast.hk/forumdisplay.php?fid=7)
+--- Forum: Everything and Nothing (https://sampforum.blast.hk/forumdisplay.php?fid=23)
+--- Thread: Mysql (/showthread.php?tid=634220)
Mysql - Loinal - 15.05.2017
I think that not all the famous server are using R41-2
Like
1- GamerX is using mysql version??
2- XSF is using mysql version??
3- YG is using mysql version??
Note: YG server is closed so who don't know about it don't speak about it
Re: Mysql - iLearner - 15.05.2017
Use latest version of the plugin and you shouldnt care about others at all.
- I use R33.
Re: Mysql - coool - 15.05.2017
How can you say that about famous servers do you have any proof ?
Re: Mysql - Loinal - 15.05.2017
Quote:
|
Originally Posted by iLearner
 Use latest version of the plugin and you shouldnt care about others at all.
- I use R33. |
Quote:
|
Originally Posted by coool
How can you say that about famous servers do you have any proof ?
|
Re: Mysql - Logic_ - 15.05.2017
What do you even mean? MySQL and management/ server has no link with it. Using newer version of MySQL either R39 or R40+ has their own benefits. If one uses R39 then they're exposing themselves to exploits or probably no support - Else who use R40+ receive support, bug patches and new features that has more speed and reliability than the R39 or older versions.
Re: Mysql - Loinal - 15.05.2017
Quote:
|
Originally Posted by Logic_
What do you even mean? MySQL and management/ server has no link with it. Using newer version of MySQL either R39 or R40+ has their own benefits. If one uses R39 then they're exposing themselves to exploits or probably no support - Else who use R40+ receive support, bug patches and new features that has more speed and reliability than the R39 or older versions.
|
Re: Mysql - Logic_ - 15.05.2017
Quote:
|
Originally Posted by Loinal
Right , so why half the famous servers use r7?
|
Re: Mysql - Loinal - 15.05.2017
XSF and YG
Re: Mysql - Luis- - 15.05.2017
Quote:
|
Originally Posted by Loinal
XSF and YG
|
Re: Mysql - Despacito - 15.05.2017
Quote:
|
Originally Posted by Luis-
How exactly do you know this? You have no proof?
|
pawn Код:
forward ConnectMySQL();
public ConnectMySQL()
{
xSF=mysql_connect( LOCAL_HOST, LOCAL_USER, LOCAL_DB, LOCAL_PASS );
if(mysql_ping(xSF) == 1)
{
mysql_debug(xSF);
printf("[MYSQL]:first Connection to `DATABASE` succesful! || %d",xSF);
}
else
{
mysql_close(xSF);
printf("[MYSQL]: [ERROR]:first Connection to `DATABASE` failed!");
xSF=mysql_connect( LOCAL_HOST, LOCAL_USER, LOCAL_DB, LOCAL_PASS );
if(mysql_ping(xSF) == 1)
{
mysql_debug(xSF);
printf("[MYSQL]:second Connection to `DATABASE` succesful! || %d",xSF);
}
else printf("[MYSQL]: [ERROR]:second Connection to `DATABASE` failed!");
}
return 1;
}
pawn Код:
#define HOST_R ":: xSF » Xtreme Stunt Freeroam (0.3.7R2) ::"
#define NAME_S "xSF"
#define VERSION_B "V1.3"
#define RESPAWN_TIME ( 25 )
#define HOSTNAME_1 ":: xSF » Xtreme Stunt Freeroam (0.3z) :: "
#define HOSTNAME_2 ":: xSF » Stunt/DM/Race/Derby/Minigames :: "
#define HOSTNAME_3 ":: xSF » Xtreme Stunt Freeroam (0.3z) :: "
#define HOSTNAME_4 ":: xSF » Stunt/DM/Race/Derby/Minigames :: "
#define SITETD_1 "~y~~h~xSF"
#define SITETD_2 "~r~~h~xSF"
#define SITETD_3 "~b~~h~xSF"
#define SITETD_4 "~p~~h~xSF"
#define MYSQL_VERSION "R7 by Blueg"
// ( MySQL Configuration Panel )
#define USE_LOCALHOST ( true )
#define USE_ANTI_STEALER ( false )
#define ENABLE_DEBUGING ( 0 )
#define SERVER_FORUM "Example.com"
#define MAX_CONNECTIONS_FROM_IP ( 15 )
pawn Код:
gsString[ 0 ] = EOS;
new
Buf[ 129 ]
;
WP_Hash( Buf, 129, rPassword );
new
liYear,
liMonth,
liDay
;
getdate( liYear, liMonth, liDay );
new year, month, day;
getdate( year, month, day );
format( gsString, sizeof( gsString ), "INSERT INTO `accounts` \
VALUES(0, '%s', '%s', '%s', '%d-%d-%d','%d/%d/%d', '0', '0', '0', '0', '0', '0', \
'0', '0', '0', '00:00:00', '0', '0', '0' '0', \
'0', '0', '0', 'None.', '0', '0', 'None', '0', '0', '0', 0", PlayerName( playerid ), GetPlayerIPEx( playerid ), Buf, liYear, liMonth, liDay,year,month,day);
format( gsString, sizeof( gsString ), "%s, '0', '0', '0', '0', '0', \
'0', '0', '0', '00:00', '0', '00:00', '0', '0xFFFFFFFF', \
' 0', '0', '00:00:00', '0',0, 0, '0', '0','0', 0, '0', '0', '0','5','22', 33, '1', '0', '0','0','0','0', '0', '0', '0', '0', '0', '0', '0', '0', '0')", gsString );
mysql_query( gsString );
PlayerInfo[ playerid ][ AccID ] = mysql_insert_id( );
pawn Код:
/**
* MySQL plugin R7
* Copyright © 2008-2011, BlueG
*/
#if defined mysql_included
#endinput
#endif
#define mysql_included
/**
* Common error codes
*
* Client: http://dev.mysql.com/doc/refman/5.0/en/error-messages-client.html
* Server: http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html
*
*/
#define ER_DBACCESS_DENIED_ERROR 1044
#define ER_ACCESS_DENIED_ERROR 1045
#define ER_UNKNOWN_TABLE 1109
#define ER_SYNTAX_ERROR 1149
#define CR_SERVER_GONE_ERROR 2006
#define CR_SERVER_LOST 2013
#define CR_COMMAND_OUT_OF_SYNC 2014
#define CR_SERVER_LOST_EXTENDED 2055
// Native functions
#define mysql_fetch_row(%1) mysql_fetch_row_format(%1,"|")
#define mysql_next_row() mysql_retrieve_row()
#define mysql_get_field(%1,%2) mysql_fetch_field_row(%2,%1)
#define mysql_query_callback(%1,%2,%3,%4,%5) \
mysql_function_query(%5,%2,false,%3,"siii",%2,%1,%4,%5)