[SpikY_]

Hellu.
My server isn't Connecting to MYSQL why?

Here are the Codes ,

pawn Код:

forward ConnectMySQL()
public ConnectMySQL()
{
eXs=mysql_connect("127.0.0.1","port_2473", "port_2473", "etc")
//example eXs=mysql_connect("127.0.0.1","gtaserver4279", "gtaserver4279", "maybefuckoff")
printf("%d",mysql_errno(eXs))
if(mysql_errno() == 0)
{
mysql_close(eXs)
printf("[MYSQL]: [ERROR]:first Connection to `DATABASE` failed!")
eXs=mysql_connect("127.0.0.1","your username here", "YOUR DATABASE NAME HERE", "YOUR PASSWORD of user here")
//example eXs=mysql_connect("127.0.0.1","gtaserver4279", "gtaserver4279", "maybefuckoff")
printf("%d",mysql_errno(eXs))
if(mysql_errno() == 0)
{
mysql_close(eXs)
printf("[MYSQL]: [ERROR]:Second Connection to `DATABASE` failed!")
}
else
{
//mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG)
printf("[MYSQL]:second Connection to `DATABASE` successful! || %d",eXs)
con=2
}
}
else
{
//mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG)
printf("[MYSQL]:first Connection to `DATABASE` successful! || %d",eXs)
con=1
}
return 1
}

[biker122]

Totally wrong.
if(mysql_errno(connectionHandle) == 0) // success
just do it in vice-versa

[SpikY_]

Now wht?

pawn Код:

: error 017: undefined symbol "connectionHandle"

[JeaSon]

pawn Код:

new connectionHandle;

[Dutheil]

If mysql_errno return 0, there aren't errors.

pawn Код:

if(mysql_errno() == 0) 
    print("No problem with the connection!");

Quote:

Originally Posted by biker122 Totally wrong. if(mysql_errno(connectionHandle) == 0) // success just do it in vice-versa

mysql_errno hasn't parameters

[SpikY_]

Quote:

Originally Posted by Dutheil If mysql_errno return 0, there aren't errors. pawn Код: print("No problem with the connection!");

i was already using this but couldn't connect to mysql!

[Dutheil]

What version mysql do you use ?

[SpikY_]

mysql plugin R39-2

[Dutheil]

The mysql version works like that :

pawn Код:

// top of your script
new mysql;

// In OnGameModeInit
mysql = mysql_connect(the parameters);

// Exemple
public OnPlayerConnect(playerid)
{
    new pName[MAX_PLAYER_NAME], query[128];
    GetPlayerName(playerid, pName, sizeof(pName));
    
    mysql_format(mysql, query, sizeof(query), "SELECT * FROM `Members` WHERE `Name`='%s'", pName);
    mysql_tquery(mysql, query, "OnConnection", "d", playerid);
    
    return 1;
}

forward OnConnection(playerid);
public OnConnection(playerid)
{
    if(cache_get_row_count()) // an account find
    {
        // actions
    }

    else // account didn't find
    {
        // actions
    }
}

[biker122]

https://sampwiki.blast.hk/wiki/MySQL#mysql_errno
Jump to mysql_errno