SA-MP Forums Archive
MySQL - 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 (/showthread.php?tid=623744)



MySQL - Loinal - 04.12.2016

Hello Guys, Iam back and have a problem i just added this mysql system to my gamemode and then its not working and doesn't save So i need help the script that i added: https://sampforum.blast.hk/showthread.php?tid=569686


Re: MySQL - DetoNater - 04.12.2016

Check your mysql connections parameters and check if it connected ... simple one is this
Код:
if(mysql_errno() != 0)
	{
		printf("[MYSQL] Connection with the database: FAIL!");
	}
	else
	{
 		printf("[MYSQL] Connection with the database: SUCCESS!");
	}
add it in OnGameModeInit

give us some more details of the script so that we could help you...


Re: MySQL - Loinal - 04.12.2016

It always say : printf("[MYSQL] Connection with the database: SUCCESS!");

But not saving Score or money


Re: MySQL - Younes44 - 04.12.2016

did you upload .sql file using phpmyadmin ?


Re: MySQL - Loinal - 04.12.2016

Quote:
Originally Posted by Younes44
Посмотреть сообщение
did you upload .sql file using phpmyadmin ?
Yes.


Re: MySQL - Younes44 - 04.12.2016

can you show us Screen shot of your MySQL(phpmyadmin)


Re: MySQL - Loinal - 04.12.2016

https://postimg.org/image/4zlvayq8r/8fec653c/
https://postimg.org/image/6rpew4z7b/44aeafdc/


Re: MySQL - Younes44 - 04.12.2016

Quote:
Originally Posted by JeaSon
Посмотреть сообщение
pawn Код:
#define db      "sami" //This is your database name. Remember we have created a database called server before.
and when i check SQL
i found this:
PHP код:
-- Database: `sami
so try to change sami to your db name in SQL i think it's the problem


Re: MySQL - Loinal - 04.12.2016

Not working also.


Re: MySQL - DetoNater - 04.12.2016

show us your query used in the script..