AHH MSSQL AND SQL Hmm...

Results 1 to 11 of 11
  1. #1
    Novice MrGuinea is offline
    MemberRank
    Sep 2010 Join Date
    2Posts

    wink AHH MSSQL AND SQL Hmm...

    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??


  2. #2
    Proficient Member dvd70 is offline
    MemberRank
    Aug 2007 Join Date
    PortugalLocation
    156Posts

    Re: AHH MSSQL AND SQL Hmm...

    Quote Originally Posted by MrGuinea View Post
    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?

  3. #3
    Account Upgraded | Title Enabled! Denichu is offline
    MemberRank
    Mar 2009 Join Date
    744Posts

    Re: AHH MSSQL AND SQL Hmm...

    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;

  4. #4
    i sell platypus Improved is offline
    MemberRank
    Jun 2009 Join Date
    DenmarkLocation
    2,819Posts

    Re: AHH MSSQL AND SQL Hmm...

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

  5. #5
    Member Gillbill11 is offline
    MemberRank
    Mar 2010 Join Date
    76Posts

    Re: AHH MSSQL AND SQL Hmm...

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

  6. #6
    Member Mica is offline
    MemberRank
    Aug 2010 Join Date
    BelgiumLocation
    53Posts

    Re: AHH MSSQL AND SQL Hmm...

    Quote Originally Posted by Gillbill11 View Post
    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.)

  7. #7
    Account Upgraded | Title Enabled! ryuchao009 is offline
    MemberRank
    Feb 2009 Join Date
    United StatesLocation
    601Posts

    Re: AHH MSSQL AND SQL Hmm...

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

  8. #8
    Banned VLxPain is offline
    BannedRank
    May 2010 Join Date
    121Posts

    Re: AHH MSSQL AND SQL Hmm...

    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.

  9. #9
    [R8]ℓσℓ32 caja is offline
    MemberRank
    Oct 2008 Join Date
    Here!Location
    1,502Posts

    Re: AHH MSSQL AND SQL Hmm...

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

  10. #10
    Account Upgraded | Title Enabled! ryuchao009 is offline
    MemberRank
    Feb 2009 Join Date
    United StatesLocation
    601Posts

    Re: AHH MSSQL AND SQL Hmm...

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

  11. #11
    Member Gillbill11 is offline
    MemberRank
    Mar 2010 Join Date
    76Posts

    Re: AHH MSSQL AND SQL Hmm...

    ah i see



Advertisement