Posts: 117
Threads: 26
Joined: Jan 2016
Hello i wanted to know the difference of 2 MySQL Versions. they are MySQL R7 and R41-2. When i search ****** for Latest MySQL for SAMP, it shows me R7 one. but when i click on Download link of BlueG's Thread, it shows me latest R41-2, released in December 2016.
if R41-2 is newer than R7, why is there no thread or tutorial on how to set up or what are the changes?
Sorry if this is wrong section. i didnt know where to put this..
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation:
0
Github has the newest versions. I think there's been three developers up to now and the original topic hasn't been updated since the original creator left (it).
Posts: 117
Threads: 26
Joined: Jan 2016
so which is the latest and best that we should use?
Posts: 6,242
Threads: 8
Joined: Jun 2008
R7 is an older method, when people were really into making tutorials and using MySQL, and passing on their knowledge.
That's why there's a lot more information about it, as there's more "hits" on it. R41+ is what you want to be looking at.
The changes from R7 to the next versions, were in the ways that the plugin worked, and the functions methods/usages.
If you have trouble starting the plugin on the later versions, it'll more than likely be you are missing a runtime/library. Avoid using the static one unless you REALLY can't "fix" it.
Posts: 117
Threads: 26
Joined: Jan 2016
Static means R41+? because i converted my script from R5 to R7 but everytime it said, MySQL Connection Failed. in R5 it was good but in R7, it said Connection to database failed. i changed all mysql_query with mysql_function_query. and moved all OnQueryFinish() cases, into seprate public callbacks for mysql_function_query. now, in R41+, mysql_query is back and some others were changed. idk why database is failing to connect. i dont see anything wrong with database. please suggest me something. it only loads 1 Vehicle ofc because MySQL Connection was unable to be made.
Please, help me.
Thanks.
Posts: 6,242
Threads: 8
Joined: Jun 2008
Static is a variant of most of the versions that doesn't require the runtimes that the other version does.
Simply moving code around, won't make the updated version "work", you need to understand the changes, to implement them.
R7 isn't bad, but it is out of date by a long time.
If the code you have is even loading 1 vehicle from the DB, then obviously it's made a connection, it's just that something in your code is stopping it from loading the rest.
You may want to start over, reading some of the R40+ Tutorials, rather than trying to convert the lower end to the latest.
Posts: 2,203
Threads: 154
Joined: Oct 2009
Reputation:
0
Avoid using R5 as it has no threading as far as i remember. (It could cause server introduced lag)
R6 was the first one to introduce threading if i remember correctly, and R7 was just like R6 only "fully" threaded.
Current latest version is fully threaded and has caching.
What should you use? Its your choice, the one you like most. Any of the three mentioned versions will do (R6,R7, latest). They are all stable. The only thing that's different is the way you use functions and latest version can be considered completely new plugin since it has many new features and functions.
Posts: 117
Threads: 26
Joined: Jan 2016
Thank you guys for the help. now i understand it. can you provide me a link to a good MYSQL R41+ or R40+ tutorial? the ones i found were only R7.
Posts: 1,506
Threads: 13
Joined: Jun 2015
Basically, you can find tutorials for r39 and then you can find the official guide to update from r39 to r40+.
