User Tag List

Results 1 to 9 of 9

Thread: MySQL object ?

  1. #1
    No Products Registered

    Join Date
    Jul 2010
    Posts
    36
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL object ?

    Hi,

    Is there an extension for performing online MySQL queries?

  2. #2
    Clicker Multimedia Fusion 2 Developer

    Join Date
    Jun 2006
    Location
    Darlington, UK
    Posts
    3,298
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: MySQL object ?

    The recommended way is to have some application on the mysql server (e.g. a php script) that performs the actual queries, that you then communicate with from your MMF application (e.g. using the GET object). You get finer-grained permissions this way, like a player only being able to add highscores to themselves.

  3. #3
    Clicker Multimedia Fusion 2 DeveloperSWF Export Module

    Join Date
    Aug 2006
    Posts
    2,335
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: MySQL object ?

    There is a few objects for MySQL in the released extensions area, there is -

    SQL Server

    PostgreSQL for MMF2 Developer

    SQLite3PRO for MMF2 Developer

    SQLite3 version 2.0

  4. #4
    Clicker Multimedia Fusion 2 Developer

    Join Date
    Jun 2006
    Location
    Darlington, UK
    Posts
    3,298
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: MySQL object ?

    Those last three are for MySQL.
    PostgreSQL is not MySQL.
    Neither is SQLite.

    SQL Server might work, but I have no idea.

  5. #5
    No Products Registered

    Join Date
    Jul 2010
    Posts
    36
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: MySQL object ?

    Thanks.

    I have MMF Standard edition and so I only can try "SQL Server" and "SQL3". I don't know how to be connected to my database by "SQL3". It seems to work on localhost only. "SQL Server" has an event to access online database but that doesn't work. Maybe there is a specific syntax.

    In fact I already use a php script with the moo object for perfoming queries but I was wondering if it was a good way to do it or if it was better to use a specific extension.

  6. #6
    Clicker iOS Export Module

    Join Date
    Feb 2010
    Location
    Behind the tree!
    Posts
    200
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: MySQL object ?

    As has already been said, you need to use the "get" object to pass messages between sql3 and php to your online database.

    Jeff made an example of a high score system. It should provide a basis of what you want to do.

    download link


  7. #7
    Clicker Fusion 2.5 MacFusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleiOS Export ModuleSWF Export ModuleXNA Export ModuleUnicode Add-on
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Fusion 2.5+ DLC (Steam)Android Export Module (Steam)HTML5 Export Module (Steam)iOS Export Module (Steam)Universal Windows Platform Export Module (Steam)
    Phi's Avatar
    Join Date
    Jan 2010
    Location
    England
    Posts
    1,834
    Mentioned
    14 Post(s)
    Tagged
    0 Thread(s)

    Re: MySQL object ?

    The Get object can be found in the second link in my signature

  8. #8
    No Products Registered

    Join Date
    Aug 2007
    Posts
    69
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: MySQL object ?

    The "SQL Server" extension is for Microsoft SQL Server and will not interface with MySQL. The SQLite3 extension uses the SQLite library to access serverless file-based databases and has nothing to do with MySQL either. The Get object is probably the only option as has been suggested by others.

  9. #9
    No Products Registered

    Join Date
    Jul 2010
    Posts
    36
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: MySQL object ?

    Thanks for your help, that's work perfectly

Similar Threads

  1. Implementing a Promo Code with PHP, MySQL, and Get Object?
    By Bipolar_Games in forum Android Export Module Version 2.0
    Replies: 3
    Last Post: 11th June 2015, 05:58 PM
  2. Get Object : MySQL
    By Ham in forum File Archive
    Replies: 0
    Last Post: 10th May 2010, 09:45 PM
  3. [Request] MySQL Object
    By dingdong in forum Extension Development
    Replies: 9
    Last Post: 15th December 2008, 04:16 PM
  4. MySQL?
    By Blizna in forum Multimedia Fusion 2 - Technical Support
    Replies: 2
    Last Post: 27th January 2007, 06:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •