[HELP]How To Create A Gamemode With MySQL

[ArromG]

Hi All....

I want to create a gamemode with mysql....for accuracy one gamemode roleplay

but i don't know how

if you can help me

[Machine]

learn lua and sql

or just buy one of the original scripts from roleplay servers

or hire a pro scripted

cuz no one will hep you with that for free or just simple as that

[ArromG]

Thank For Information

And What MySQL Use?

[Gallardo9944]

MySQL uses RAM, CPU, admin's time, ...

Please, ask proper questions.

[ArromG]

Which MySQL Should I Use For The MTASA Server?

[xXMADEXx]

MySQL is a database language, used to save information. Google mysql on how to learn it.

MySQL uses RAM, CPU, admin's time, ...

Please, ask proper questions.

Do you know what you're even talking about?

[ViRuZGamiing]

Which MySQL Should I Use For The MTASA Server?

Do you mean MySQL or SQLite?

[ixjf]

MySQL is a database language, used to save information. Google mysql on how to learn it.

No. MySQL is a database management system. SQL is a language.

[ArromG]

I Asked Simple [ Which MySQL Should I Use For The MTASA Server? ]

Because A Friend Of Mine Says I Use (MySQL Workbench)

While Another Tells Me To Use (MySQL Server)

And Me I Don't Know Which MySQL To Use..

ViRuZGamiing What Do You Mean [ MySQL Or SQL] ????? (Why SQLite First Time See This)

Sorry For My English

[xXMADEXx]

Mysql is a server, and SQLite is basically a the same thing but a file... if you're looking for a program to host it. I would just use sqlite.

[ArromG]

I Would Prefer MySQL..Why The i know Better....while the SQLite(SQL) do not know...but i think can use and of two

And Which MySQL Should I Use For The MTASA Server?

The MySQL Server??

The MySQL Workbench??

Or Other

Sorry For Same Question

[LonelyRoad]

You need to learn LUA to make scripts for MTA, then learn the SQL functions to communicate with any kind of database. SQLite is easier to use but it has less functionality and makes it more difficult to use the data externally, for places such as on a website.

You probably want to use MySQL, with the MySQL CE server (free version of the MySQL Server, available HERE).

You will need a proper dedicated server to run any of this efficiently so good luck on the cost of that.

P.s: MySQL Workbench is an admin tool for a MySQL Server.

[xXMADEXx]

I use USBWebHost. You can google it.

(PS SQLite and MySQL use the same execution atrings.)

[.:HyPeX:.]

Just to made clear, why u actually think MySQL is better? its not worth the cost if you do not really need it, as it means alot more in hosting.

[Atton]

From what I know about code lua is needed for mysql to work in mta so learn lua.

[ArromG]

Must Namely To Use MySQL Server?? For MTASA (Server)

Just Ask To Be Sure...For Not To Download Mistake MySQL

Sorry For The Same Question....And My English

[LonelyRoad]

Depending on how indepth you want to be with your gamemode (do you want a website User Control Panel for example?) then you almost certainly want to use MySQL CE Server.

SQLite and MySQL do not always use the same execution strings, but most of the time it can be the same.

MySQL CE Server is free anyway, and depending on where you host it you may not need to pay for anything at all, for servers like MTA you probably want your own dedi of some form to administrate it all anyways.

[ArromG]

For Roleplay Gamemode The MySQL Use?

[myonlake]

Will you not spam that same line of text all the time and read what we're trying to help you with.

Learn Lua before you head to SQL, I really don't think learning SQL is such an important phase until you actually go and make the gamemode.

viewtopic.php?f=148&t=40809

Read all the important tutorials, and additionally you could read them all if you have the time.

As for what goes to your need in form of database architecture I say get XAMPP on your home computer and learn to use it. It includes a MySQL server, but also phpMyAdmin and an Apache web server, so it's a good pack for free.

On dedicated hosts the SQL database comes for free, and you don't have to worry about it. Just make sure you buy it from a place where they really provide you with one, and a phpMyAdmin site.

[ArromG]

Ok

Thank For Answer