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


Data MySQL - hoanduy - 27.09.2017

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

How to create MySQL for a gamemode starting from New.

Re: Data MySQL - Fratello - 27.09.2017

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

Re: Data MySQL - MEW273 - 27.09.2017

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.

Re: Data MySQL - Fratello - 27.09.2017

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.

Re: Data MySQL - whadez - 27.09.2017

Quote:
Originally Posted by Fratello
View Post
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.

Re: Data MySQL - Misiur - 27.09.2017

"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)

Re: Data MySQL - Fratello - 27.09.2017

Quote:
Originally Posted by whadez
View Post
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.

Re: Data MySQL - hoanduy - 29.09.2017

Quote:
Originally Posted by MEW273
View Post
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.

Re: Data MySQL - BreakStore - 29.09.2017

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.

Re: Data MySQL - hoanduy - 29.09.2017

Quote:
Originally Posted by BreakStore
View Post
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