SA-MP Forums

Go Back   SA-MP Forums > SA-MP > General

Reply
 
Thread Tools Display Modes
Old 09/07/2018, 06:04 PM   #1
HoNEYKISS
Big Clucker
 
HoNEYKISS's Avatar
 
Join Date: Aug 2017
Location: Must +rep to see the users location (joking don't ban me)
Posts: 51
Reputation: 24
Default Newbies tryna use MySQL

If you are new to scripting and you want to use a gamemode based on MySQL why don't you first check out some tutorials...I noticed that almost half of the threads on Server Support or Scripting help have to do with MySQL problems! Someone has to put an end to this!

And the worst part is that their problem is always the fact that they don't know how to connect their database.... Am I really the only one annoyed from this threads?
__________________

Last edited by dugi; 13/07/2018 at 05:59 PM.
HoNEYKISS is offline   Reply With Quote
Old 09/07/2018, 09:35 PM   #2
DerickClark
High-roller
 
Join Date: Jul 2012
Posts: 1,707
Reputation: 14
Default Re: Newbies tryna use MySQL

MySQL is the fastest, so let them practice their MySQL skills. But it's best to read about it and learn about you had learned into your building your skills, and starting to create server with MySQL database. But Ini, Yini, Dini is to use but some of them is out-dated. I start off with ini. Was very easy to use tho. but i went to dini and now im at MySQL the codes i can put in easy to the game. It's all about learning your step. and track your errors. Some people can't do it so they move on to ini. which is a server file now. but if you choose database(MySQL) or other. That's good practice.
__________________
Working on a Trucking Server from scratch.
There are cool features, like /workmenu /convoy /pay(When Police Officer asked you for a fine) and more etc.
DerickClark is offline   Reply With Quote
Old 12/07/2018, 12:19 AM   #3
BlackBank
High-roller
 
BlackBank's Avatar
 
Join Date: Dec 2010
Location: The Netherlands
Posts: 1,174
Reputation: 435
Default Re: Newbies tryna use MySQL

Quote:
Originally Posted by DerickClark View Post
MySQL is the fastest, so let them practice their MySQL skills. But it's best to read about it and learn about you had learned into your building your skills, and starting to create server with MySQL database. But Ini, Yini, Dini is to use but some of them is out-dated. I start off with ini. Was very easy to use tho. but i went to dini and now im at MySQL the codes i can put in easy to the game. It's all about learning your step. and track your errors. Some people can't do it so they move on to ini. which is a server file now. but if you choose database(MySQL) or other. That's good practice.
Uhm, MySQL isn't the fastest... INI can be much faster, it all depends on the way you save your data. Ofcourse MySQL is better for a lot of different data and their relationships, but if you just save and load user data, INI is good enough.
BlackBank is offline   Reply With Quote
Old 12/07/2018, 05:46 AM   #4
iLearner
Gangsta
 
iLearner's Avatar
 
Join Date: Apr 2017
Posts: 553
Reputation: 116
Default Re: Newbies tryna use MySQL

Quote:
Originally Posted by BlackBank View Post
Uhm, MySQL isn't the fastest... INI can be much faster, it all depends on the way you save your data. Ofcourse MySQL is better for a lot of different data and their relationships, but if you just save and load user data, INI is good enough.
Imo ini (files) should only be used for loading configuration settings.
iLearner is online now   Reply With Quote
Old 12/07/2018, 06:51 AM   #5
DerickClark
High-roller
 
Join Date: Jul 2012
Posts: 1,707
Reputation: 14
Default Re: Newbies tryna use MySQL

Quote:
Originally Posted by BlackBank View Post
Uhm, MySQL isn't the fastest... INI can be much faster, it all depends on the way you save your data. Ofcourse MySQL is better for a lot of different data and their relationships, but if you just save and load user data, INI is good enough.
Like what iLearner saids. You also can use it to pass it around in a file. MySQL is the fastest. then ini
MySQL = Database
INI = File System
__________________
Working on a Trucking Server from scratch.
There are cool features, like /workmenu /convoy /pay(When Police Officer asked you for a fine) and more etc.
DerickClark is offline   Reply With Quote
Old 12/07/2018, 07:55 AM   #6
Sew_Sumi
Godfather
 
Join Date: Jun 2008
Location: Azerbaijan
Posts: 6,296
Reputation: 519
Default

This isn't just MySQL issues alone, and with the MySQL issues it's usually the exact same problem... Runtimes not being installed, with the constant spam of 'install static'.

People don't search, and people don't learn. People who throw up the instant 'update plugins' and 'install static' are simply feeding the spam by not asking what it is, or explaining it properly (If at all), as well as encouraging the idea that people are going to respond instantly, and give a quick-fix, so when someone starts asking the real questions, they're already mad, and take it out on those who do actually come and ask details.

This same issue, relates to the plugin fails that you see all the time, people so eager to throw out 'install nativechecker/crashdetect' instead of asking for the log, or checking what is indeed not loading, and thinking about why it may not actually load.


Then that comes to the noobs, who throw up 'Help me' topics, with no information, and when asked, trim the log so much they simply show the error lines, without showing the whole log, or what was needed to find the aforementioned plugin issue.

While there are many cases where this happens, there are also a few occasions that those who are posting these sort of things (Both as OP, and as contributor) realize what they did, and reform themselves.
Sew_Sumi is offline   Reply With Quote
Old 16/07/2018, 01:51 AM   #7
BlackBank
High-roller
 
BlackBank's Avatar
 
Join Date: Dec 2010
Location: The Netherlands
Posts: 1,174
Reputation: 435
Default Re: Newbies tryna use MySQL

Quote:
Originally Posted by iLearner View Post
Imo ini (files) should only be used for loading configuration settings.
That's true, but i was more aiming to people who are new in the programming scene.

Quote:
Originally Posted by DerickClark View Post
Like what iLearner saids. You also can use it to pass it around in a file. MySQL is the fastest. then ini
MySQL = Database
INI = File System
No, MySQL doesn't have to be faster. INI is file based, so faster to read (if you are running decent hardware, as most servers do). With MySQL you have to connect to the MySQL server, run the query and 'receive' it back.
BlackBank is offline   Reply With Quote
Old 16/07/2018, 01:59 AM   #8
DerickClark
High-roller
 
Join Date: Jul 2012
Posts: 1,707
Reputation: 14
Default Re: Newbies tryna use MySQL

Quote:
Originally Posted by BlackBank View Post
That's true, but i was more aiming to people who are new in the programming scene.



No, MySQL doesn't have to be faster. INI is file based, so faster to read (if you are running decent hardware, as most servers do). With MySQL you have to connect to the MySQL server, run the query and 'receive' it back.
Yes. That's what im saying. INI as a file system and MYSQL for a database. I worked with INI before. Then INI Become outdated.
__________________
Working on a Trucking Server from scratch.
There are cool features, like /workmenu /convoy /pay(When Police Officer asked you for a fine) and more etc.
DerickClark is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[Tutorial] Setting up MySQL database [For newbies!] Jarnu Tutorials 19 19/08/2015 03:00 PM
[Tutorial] coordinates for newbies coool Tutorials 9 14/11/2013 07:46 PM
Any tips for a new server tryna make it? jremi General 16 02/11/2013 05:41 AM
Anyone can help me in vb2010 tryna make something for samp nenum12 Everything and Nothing 2 09/08/2012 08:19 PM
4 Newbies InterRP Team Scripting Help 3 12/11/2011 08:52 AM


All times are GMT. The time now is 05:41 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.