SA-MP Forums Archive
mysql help +rep - 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: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql help +rep (/showthread.php?tid=534067)


mysql help +rep - momo123 - 27.08.2014

hi guys i connect my server to mysql and uplode the files in myphpadmin but i have 1 problem in server logs say connection faield

and mysql username/password/database is true

this is Pawno Mysql codes
Код:
forward ConnectMySQL();
public ConnectMySQL()
{
	GTADM=mysql_connect("127.0.0.1","port_8008", "port_8008", "******");
	//example GTADM=mysql_connect("127.0.0.1","gtaserver4279", "gtaserver4279", "maybefuckoff");
	printf("%d",mysql_errno(GTADM));
	if(mysql_errno() != 0)
	{
         mysql_close(GTADM);
		 printf("[MYSQL]: [ERROR]:first Connection to `DATABASE` failed!");
  	     GTADM=mysql_connect("127.0.0.1","port_8008", "port_8008", "*****");
	     //example GTADM=mysql_connect("127.0.0.1","gtaserver4279", "gtaserver4279", "maybefuckoff");
		 printf("%d",mysql_errno(GTADM));
	     if(mysql_errno() != 0)
	     {
	         mysql_close(GTADM);
			 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",GTADM);
            con=2;
	 	 }
	}
    else
    {
        //mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG);
	    printf("[MYSQL]:first Connection to `DATABASE` successful! || %d",GTADM);
        con=1;
	}
	return 1;
}


Re: mysql help +rep - redist - 27.08.2014

Wrong.

Use

pawn Код:
if(mysql_errno() == 0) // If it is EQUAL to 0, then there is no error
{
Instead of

pawn Код:
if(mysql_errno() != 0)
{