SA-MP Forums

Go Back   SA-MP Forums > Other > Everything and Nothing

Reply
 
Thread Tools Display Modes
Old 15/05/2017, 10:42 PM   #11
oMa37
Banned
 
Join Date: Feb 2016
Posts: 938
Reputation: 129
Default Re: Mysql

Why would you even care? lol
oMa37 is offline   Reply With Quote
Old 15/05/2017, 11:21 PM   #12
Despacito
Big Clucker
 
Join Date: Apr 2017
Posts: 61
Reputation: 1
Default Re: Mysql

Quote:
Originally Posted by Luis- View Post
How exactly do you know this? You have no proof?
Code:
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;
}

Code:
#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 )

Code:
	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( );

Code:
/**
 * MySQL plugin R7
 * Copyright (c) 2008-2011, BlueG
 */

#if defined mysql_included
	#endinput
#endif
#define mysql_included

/**
 * Common error codes
 *
 * Client: [url]http://dev.mysql.com/doc/refman/5.0/en/error-messages-client.html[/url]
 * Server: [url]http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html[/url]
 *
 */

#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)
Despacito is offline   Reply With Quote
Old 16/05/2017, 01:31 AM   #13
TommyB
Big Clucker
 
TommyB's Avatar
 
Join Date: Sep 2010
Location: Texas, USA.
Posts: 87
Reputation: 38
Default Re: Mysql

That's more than likely a fairly old version of XSF. I worked on the server for a little while last year since my friend and I had been hosting it since its inception and it was constantly under attack. Given that fact, I can promise you that newer versions are using MySQL R39-2 or higher. I couldn't tell you about the current version that's up right now since we no longer host XSF. It was too much of an annoyance to sustain for any longer than we already did. There was always people complaining about their donations not being processed because of the people who ran the server. They were far too inactive to give a shit but had no problem keeping all of the server's donation money, which is funny since we had been paying for its upkeep the entire time while they pocketed every cent. That wasn't really a problem though, we knew what we were getting into. The only annoying part is people would desperately try to get in contact with us when there was no way for us to even prove they had donated. Along with that fact, there was basically nobody managing the server anymore and bugs were rampant for a while. We eventually decided to hand the server off to some other dude and send it on its way. That was kind of off topic but hey :^)

The bottom line is there's really no sensible reason to use R7 or any other old MySQL plugin version these days. People who do are stuck with slower performance and absolutely zero support for any bugs or exploits that may exist within those versions. Not only that, in my opinion the newer version of the plugin is way easier to work with when compared with the old versions. The only reason anyone is even using R7 or below these days is because they're either too lazy or incompetent to convert their gamemodes to the most recent versions, and that's fine I suppose.
__________________

TommyB
Red County Roleplay Owner and Developer

Last edited by TommyB; 17/05/2017 at 09:58 PM.
TommyB is offline   Reply With Quote
Old 16/05/2017, 03:07 AM   #14
Dice_
Huge Clucker
 
Dice_'s Avatar
 
Join Date: Sep 2015
Location: Indonesia
Posts: 321
Reputation: 39
Default Re: Mysql

That is not the actual xSF script,I'm really sure that they're using R39.
__________________
203.114.74.56:7777


Dice_ is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Plugin r39-2 Error: Can't connect to local MySQL server through socket Emre__ Scripting Help 10 30/07/2014 08:26 AM
[Tutorial] [VIDEO] MySQL ORM r38: How to pair GM with MySQL & creation of registration/connection system cArnasLT Tutorials 3 19/05/2014 02:08 PM
[GameMode] MySQL Account Script BlueG MySQL plugin R31 (cache method) Aliassassin123456 Gamemode Scripts 10 23/02/2014 12:09 PM
BlueG MySQL plugin - Failed (plugins/mysql.so: undefined symbol: _Z13stringvprintfPKcPc) linuxthefish Plugin Development 10 13/07/2013 10:56 AM
[Tool/Web/Other] MySQL DB Manager - Easily manage your MySQL databases with this remote application fiki574 Tools and Files 13 22/07/2012 09:41 AM


All times are GMT. The time now is 01:22 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.