[hoanduy]

Sorry, my english is not good. All I write is from ****** Translate.

How to create MySQL for a gamemode starting from New.

[Fratello]

https://github.com/pBlueG/SA-MP-MySQL/releases
https://github.com/pBlueG/SA-MP-MySQ...stem-cache.pwn

There you go! A little advise: You should know PAWN properly before attempting to use database system

[MEW273]

There are quite a few existing threads that explain how to do so:
https://sampforum.blast.hk/showthread.php?tid=159785
https://sampforum.blast.hk/showthread.php?tid=461766
https://sampforum.blast.hk/showthread.php?tid=420363

And I'm sure if you searched the gamemode script release section here: http://forum.sa-mp.com/forumdisplay.php?f=71 you would likely find basic MySQL gamemodes that other people have created that you could build upon.

[Fratello]

Well those threads are seriously outdated. I reckon he will face problems running outdated plugins & game modes. I recommend using new and fresh.

By the way, there is a easier way to learn mySQL (https://sampforum.blast.hk/showthread.php?pid=3719540#pid3719540). And this DOESN'T WORK on R4 version. (Try looking up for the plugin & include) But it's perfect for newbies.

[whadez]

Quote:

Originally Posted by Fratello Well those threads are seriously outdated. I reckon he will face problems running outdated plugins & game modes. I recommend using new and fresh. By the way, there is a easier way to learn mySQL (https://sampforum.blast.hk/showthread.php?pid=3719540#pid3719540). And this DOESN'T WORK on R4 version. (Try looking up for the plugin & include) But it's perfect for newbies.

Since I'm using SQL during workdays, this 'easier mysql version' looks way more harder to me. Once you learn how to write proper queries, it becomes so easy, that you dont find it hard at all. I feel like its better to put 3-4 hours into testing and messing around with SQL queries rather than learning this 'easier' method, and whenever you'll need to use SQL lets say during a webdevelopment you'll have to learn the SQL itself again, since there is no other 'methods'. This is my honest opinion.

[Misiur]

"No other methods" - what about ORM? Of course I don't disagree that it's worth knowing SQL, but there are methods to avoid writing it by hand (half of the time, other time you are dealing with ORM madness and end up writing the query yourself)

[Fratello]

Quote:

Originally Posted by whadez Since I'm using SQL during workdays, this 'easier mysql version' looks way more harder to me. Once you learn how to write proper queries, it becomes so easy, that you dont find it hard at all. I feel like its better to put 3-4 hours into testing and messing around with SQL queries rather than learning this 'easier' method, and whenever you'll need to use SQL lets say during a webdevelopment you'll have to learn the SQL itself again, since there is no other 'methods'. This is my honest opinion.

Same thing here. I'd rather learn SQL instead of that 'easy' method. It takes a while to understand how it works.

[hoanduy]

Quote:

Originally Posted by MEW273 There are quite a few existing threads that explain how to do so: https://sampforum.blast.hk/showthread.php?tid=159785 https://sampforum.blast.hk/showthread.php?tid=461766 https://sampforum.blast.hk/showthread.php?tid=420363 And I'm sure if you searched the gamemode script release section here: http://forum.sa-mp.com/forumdisplay.php?f=71 you would likely find basic MySQL gamemodes that other people have created that you could build upon.

Can you help me find a specific gamemode, in my english is not good so the search will become difficult.
And if it's a basic Gamemode Roleplay, then MySQL is better. I am very grateful to you.

[BreakStore]

If you want to learn SQL simply, for SA: MP, you can follow this tutorial:

https://sampforum.blast.hk/showthread.php?tid=627520

You need just obserting the queries (SELECT, INSERT etc ..), the functions, their use you happen to understand the different uses.

And if you want to better understand, make your server.

[hoanduy]

Quote:

Originally Posted by BreakStore If you want to learn SQL simply, for SA: MP, you can follow this tutorial: https://sampforum.blast.hk/showthread.php?tid=627520 You need just obserting the queries (SELECT, INSERT etc ..), the functions, their use you happen to understand the different uses. And if you want to better understand, make your server.

Thank You