[Plugin] [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011

[Plugin] [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - 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: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 (/showthread.php?tid=122983)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - whitedragon - 08.09.2010

How is easyst way to compile 1.4 to 2.0?

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - leo9414 - 10.09.2010

[Fri Sep 10 22:32:03 2010] Error (0): Function: mysql_connect failed, mysql was not initialized on this handle.

What is the false thing?

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - [Ask]Terminator - 11.09.2010

I have a problem and its after like one or more hours that my gamemode is fine but after i think it disconnect from mySQL because when i go ingame and try to login at my account which is already registered in the database it says this name isnt took and show me register and when i register it still comes means it doesnt save even
thanks to help me

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - Cameltoe - 11.09.2010

Quote:

Originally Posted by [Ask]Terminator

I have a problem and its after like one or more hours that my gamemode is fine but after i think it disconnect from mySQL because when i go ingame and try to login at my account which is already registered in the database it says this name isnt took and show me register and when i register it still comes means it doesnt save even
thanks to help me

Also is having this problem @ Debian

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - Toni - 12.09.2010

Quote:

Originally Posted by [Ask]Terminator

still no answer

Thats either probably because your mysql database is turning on/off at periods. If its localhosted, it shouldn't be doing that, and it would be more of a function inside you script.

If it isn't local hosted, and you have a company hosting your db, try contacting them on it.

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - [Ask]Terminator - 12.09.2010

I tried db4 and also a local hosted and i still get that problem.
is there a funtion to reconnect to mysql after its disconneted or something?

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - Cameltoe - 12.09.2010

Quote:

Originally Posted by The Toni

i'm Also having this problem and the problem is caused if theres no activity on the server .. as my server is passworded i don't get much activity.

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - [Ask]Terminator - 12.09.2010

mine is somehow same
exactly after i dont get activity on it

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - Scenario - 15.09.2010

Quote:

Originally Posted by The Toni

'WHERE `userid1 = '0''.
Unnecessary quote marks.
Change that query to this;

Code:

WHERE `userid` = 0 (or any % module).

Only use ' and ' for strings.

Okay, thank you. I have changed it to this;

pawn Code:

format(string, sizeof(string), "UPDATE `Accounts` SET `Password` = '%s', `AdminLevel` = '%d', `Money` = '%d', `Score` = '%d', WHERE `UserID` = %d", PlayerStatistics[playerid][pPassword], PlayerStatistics[playerid][pAdminLevel], PlayerStatistics[playerid][pMoney], PlayerStatistics[playerid][pDatabaseID]);

However I still get the same error.

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - Toni - 15.09.2010

Quote:

Originally Posted by RealCop228

Okay, thank you. I have changed it to this;

pawn Code:

format(string, sizeof(string), "UPDATE `Accounts` SET `Password` = '%s', `AdminLevel` = '%d', `Money` = '%d', `Score` = '%d', WHERE `UserID` = %d", PlayerStatistics[playerid][pPassword], PlayerStatistics[playerid][pAdminLevel], PlayerStatistics[playerid][pMoney], PlayerStatistics[playerid][pDatabaseID]);

However I still get the same error.

pawn Code:

`AdminLevel` = %d, `Money` = %d, `Score` = %d

You added ' and ' around integers again.

Plus, you also added a extra comma before "WHERE `userid` = %d".

Re : [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - Peppe95 - 15.09.2010

Is this better than G-Stylezzz's Plugin?

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - Luka P. - 15.09.2010

Yes IMO.

The message you have entered is too short. Please lengthen your message to at least 8 characters.

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - Scenario - 15.09.2010

Quote:

Originally Posted by The Toni

pawn Code:

`AdminLevel` = %d, `Money` = %d, `Score` = %d

You added ' and ' around integers again.

Plus, you also added a extra comma before "WHERE `userid` = %d".

Oh! That definitely fixed the issue! Just to be on the safe side, what about here?

pawn Code:

"SELECT * FROM `Accounts` WHERE `UserID` = '%d'"

Should I do anything there, or just leave it?

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - toneysix - 15.09.2010

"SELECT * FROM Accounts WHERE UserID = %d"
' ' only for strings like '%s'

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - Luka P. - 15.09.2010

It shouldn't matter.

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - toneysix - 16.09.2010

Luka P don't think so. Try make query with keys - time, date, type, you get the error if your keys not in double `.

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - Cameltoe - 16.09.2010

Someone else noticed OnMysqlQuery isn't working?

The actual callback gets called, and you can make a switch statement .. but when you call mysql_store_result(); inside the statement nothing gets done, why?

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - whitedragon - 17.09.2010

DA_Boss unstable mysql version?

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - StrickenKid - 06.10.2010

Re-download the fix and try again

EDIT: it might be because I had to compile it with visual studio 2010, which is a piece of shit.
I don't understand why Microsoft doesn't have downloads for previous versions of vs.

Re: [REL] SA:MP MySQL Plugin 2.0 - Released (8/7/2010) - StrickenKid - 06.10.2010

Thats just SP1, but I found the whole download on brothersoft

Ill uninstall 2010 and install 2008