[Loinal]

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

[iLearner]

Use latest version of the plugin and you shouldnt care about others at all.

- I use R33.

[coool]

How can you say that about famous servers do you have any proof ?

[Loinal]

Quote:

Originally Posted by iLearner Use latest version of the plugin and you shouldnt care about others at all. - I use R33.

I don't care about them but just to know because some servers uses old version like R7 and has a cool future

Quote:

Originally Posted by coool How can you say that about famous servers do you have any proof ?

Proof for?

[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.

[Loinal]

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.

Right , so why half the famous servers use r7?

[Logic_]

Quote:

Originally Posted by Loinal Right , so why half the famous servers use r7?

Absolutely wrong. Give me proof if they use R7, no server uses such outdated version of MySQL unless it's being hosted by bunch of kids who claim themselves to be professional.

[Loinal]

XSF and YG

[Luis-]

Quote:

Originally Posted by Loinal XSF and YG

How exactly do you know this? You have no proof?

[Despacito]

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/e...lient.html
 * Server: http://dev.mysql.com/doc/refman/5.0/en/e...erver.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)