MTA Integrate with SQL

[Lloyd Logan]

Right guys,

Wondering how to to link MTA SA with Mysql, now this may be stupid if someone has already posted a topic about it could you link me to it?. What i mean is, in big scripts such as Valhalla, Vedic etc. , they have a folder named Mysql, but how do they get it, i can set up a big script, but it is no use setting it up if you don't understand any of it,,

How do you link MTA:SA with Mysql and Sqlite etc,?

Please forgive if this makes me look stupid in some way, or if the question is stupid, but hey, we all need to learn!!

Thanks again, Lloyd

[Castillo]

Topic moved to "Scripting" section.

https://wiki.multitheftauto.com/wiki/Ser ... _functions

These are the MySQL and SQLite functions, in order to use MySQL, you need a MySQL server, that could be "xampp" ( is what I use ).

SQLite doesn't require a MySQL server, you could either use the function which stores the data on "registry.db": executeSQLQuery, or the db functions which can open custom .db files.

[robhol]

Just as a nitpick, XAMPP isn't an SQL server. It's a bundle with Apache, MySQL, PHP and... some other thing. It's fully possible to just install MySQL by itself, you don't need the web server stuff.

[FWCentral]

Instead of me starting a new topic, im wondering what is better/faster MySQL or SQLite also what about an external MySQL server? (I would think external is much slower than any local)

[AeroXbird]

I prefer MySQL over SQLITE just because of its flexability, you can simply move your MySQL Database all around whenever you want, and there's not too much hassle..

SQLite is handy if you want to save data real quick, but i really recommend MySQL as it's simply superior in flexibility and usability... ( imo ofcourse )

[robhol]

If you run it on the same computer, the difference should be hard to notice. However, SQLite is faster. If you run an external MySQL server, that will obviously be slower (and enough that you might actually notice it) due to networking.

[FWCentral]

Yeah that's exactly what i thought about the external server robhol, and yeah the SQLite server is on the same computer (the one built into MTA).

Thanks for your info guys.

[Lloyd Logan]

Yeah that's exactly what i thought about the external server robhol, and yeah the SQLite server is on the same computer (the one built into MTA).

Thanks for your info guys.

Back to topic guys please????

[FWCentral]

Read Solidsnake14's post he is correct, sorry for jacking your topic

[Lloyd Logan]

Read Solidsnake14's post he is correct, sorry for jacking your topic

I still don't understand how to make a database!

[FWCentral]

Well do you want to use MySQL or the SQLite?

[Lloyd Logan]

Well do you want to use MySQL or the SQLite?

SQLite

Thanks Lloyd

[FWCentral]

  
executeSQLQuery 
  

There is examples on how to create a table and more there.