[Tropicali]

I'm having a bit of an issue with registering dialogs.

First off, I'm using a gamemode that's perhaps 2-3 years old and uses MySQL. If I try to register on the server, it doesn't allow me to do that, it just flips back and forth dialogs. However, if I create myself an account through MySQL and log in with those details, it allows me to do this.

What I'm wondering is, is the data somehow now inserting into the table and therefore saving? Because when a player disconnects/the gamemode restarts the data saves, but its just not creating that initial player on the database and I don't know why. I've racked my brain for two days trying to figure it out as I'm teaching myself MySQL and enjoy learning like this, this is just for perserverance and I'd like someone to help me out here.

I don't know where to begin with showing you my code, if someone thinks they can help I'll show you the code here.

Thanks guys.

[Tropicali]

When I try to insert the query manually on SQL database it gives me an #1064 error.

Код:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[value-1],[value-2],[value-3],[value-4],[value-5],[value-6],[value-7],[value-8],' at line 1

What's the deal with this? It's an errot with INSERT INTO `players` ecetra.

[McBan]

Are you certain the MySQL version is the latest?

[DetoNater]

update the mysql plugins to latest and there are bunch of tutorials available, this might help you www.forum.sa-mp.com/showthread.php?t=337810

[Tropicali]

The MYSQL plugin is BlueGs R5 I've just noticed, so its fairly outdated. The trouble now is converting all the old functions to new ones. If I do this will it work?

[rappy93]

If the MySQL syntax is correct yes, it will work.

[Tropicali]

I've switched the plugin to R6-2 because I don't want to/don't know how to use the whole threaded enquiries thing yet as I'm just practising.

I compile the code and there's no errors, I run the server and theres no errors. It just doesn't save player data (it saves everywhere its supposed to in the script) but when I click the SQL tab in the MySQL table to insert it still gives me that syntax error. Any idea why? This is really bugging me and I need to fix it.