AHH MSSQL AND SQL Hmm...

[MrGuinea]

Well MSSQL is cool and runs official files right?

Well does SQL run official files too.

Most extras for servers run on SQL. well ?
like: cash shops, most guides are for SQL.

can you get official files for SQL ?

Thx

If you can where do you get files from??

 

[dvd70]

Well MSSQL is cool and runs official files right?

Well does SQL run official files too.

Most extras for servers run on SQL. well ?
like: cash shops, most guides are for SQL.

can you get official files for SQL ?

Thx

If you can where do you get files from??

what do you mean about SQL? lol sql is a simple language it has no programs...

I guess you want to say mysql or postgres?

 

[Denichu]

yea he means mysql
lets make this clear for you:
MSSQL = Official Files
MYSQL = Emulators and most of the times, webdatabases.

Just use MSSQL, if you know how the SQL language works, than you know how MSSQL worls o;

 

[Improved]

MSSQL is for the serus files released in the release section aka. Official files. They use ONLY official.

 

[Gillbill11]

can you use both like MSSQL to run server and SQL for webshop?

 

[Mica]

can you use both like MSSQL to run server and SQL for webshop?

First off:

MSSQL = Microsoft Database Stuff (Most programs written for Microsoft uses this kind of database).
MySQL = Open Source Database (Mostly used for Webbased) And in FlyFF Server Files (Non-Official Server Files).
Oracle = Something you wouldn't understand, and not used by Flyff Server Files.

Now your question:

Official Files use MSSQL (for the game to work)
nd yes you can use MySQL for the webshop (you'd have to build your own webshop then + You'd have to do abit work to send the item etc to the character.)

 

[ryuchao009]

First off:
and yes you can use MySQL for the webshop (you'd have to build your own webshop then + You'd have to do abit work to send the item etc to the character.)

You could do it that way, but if you know mysql you pretty much know mssql. The differences are small enough to where you can adjust easily. Don't overcomplicate things when you can avaoid it :

 

[VLxPain]

sir could you please explain what you mean by SQL, it is only a very basic programming language, used for querying a database like MSSQL or MYSQL.
All I can say right now is that ALL server files use SQL.

 

[caja]

You could do it that way, but if you know mysql you pretty much know mssql. The differences are small enough to where you can adjust easily. Don't overcomplicate things when you can avaoid it :

No... MySQL and MsSQL sintax it's completely different. Also, in php, the functions are very similar, so you only have to change one letter. But in php, the functions are very similar, you will only need to change one letter in the most cases.

 

[ryuchao009]

No... MySQL and MsSQL sintax it's completely different. Also, in php, the functions are very similar, so you only have to change one letter. But in php, the functions are very similar, you will only need to change one letter in the most cases.

It depends on what you're doing with them. Calling stored procedures is simply "EXEC" vs. "CALL". Most people don't do much with them beyond basic queries and stored procedures. Creating/editing tables isn't much different from navicat for mysql either.

 

[Gillbill11]

ah i see