User Tag List

Page 2 of 4 FirstFirst 1 2 3 4 LastLast
Results 11 to 20 of 38

Thread: ODBC MySQL Connection Problems

  1. #11
    Clicker Multimedia Fusion 2 DeveloperAndroid Export Module

    Join Date
    Jun 2006
    Location
    Canada
    Posts
    611
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: ODBC MySQL Connection Problems

    isnt that a bit dangerous ? i mean the way it look like is that moosock get to the PHP file then the php file use GET method to get the information from moosock. But if someone do find out the URL where the application go (where moosock call).. he is going to be able to do what he want ?

  2. #12
    Clicker Multimedia Fusion 2 DeveloperAndroid Export Module

    Join Date
    Jun 2006
    Location
    Canada
    Posts
    611
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: ODBC MySQL Connection Problems

    isnt that a bit dangerous ? i mean the way it look like is that moosock get to the PHP file then the php file use GET method to get the information from moosock. But if someone do find out the URL where the application go (where moosock call).. he is going to be able to do what he want ?

  3. #13
    Clicker Multimedia Fusion 2 DeveloperiOS Export Module
    Nifflas's Avatar
    Join Date
    Jul 2006
    Posts
    2,613
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: ODBC MySQL Connection Problems

    To me, connecting directly to an SQL server is the only thing that sounds really dangerous. The very purpose of the php script, is the protection between the client (the game), and the sql database.

    With php, it should be no problem at all. Even if someone finds out the url, the script should of course only allow a very few types of operations, never give complete access to the database, for anyone who enters. For example, if an user has registred an account, with an username and encrypted password, even if he heads directly to the url, he will only be able change things about his own account anyway, since he don't know the other user's passwords. And if you worry about someone registering tons of accounts, remember that the very same thing can happen over a web forum anyway. And the php script can have protection against that.

    How safe it is, will be completely determined by the users php programming skills. A direct connection to an SQL database, doesn't sound safe under any circumstances. In that case, the user will just be able to look at what data was used to connect to the database, use that information to connect from another client, and change lots of things...

  4. #14
    Clicker Multimedia Fusion 2 DeveloperiOS Export Module
    Nifflas's Avatar
    Join Date
    Jul 2006
    Posts
    2,613
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: ODBC MySQL Connection Problems

    To me, connecting directly to an SQL server is the only thing that sounds really dangerous. The very purpose of the php script, is the protection between the client (the game), and the sql database.

    With php, it should be no problem at all. Even if someone finds out the url, the script should of course only allow a very few types of operations, never give complete access to the database, for anyone who enters. For example, if an user has registred an account, with an username and encrypted password, even if he heads directly to the url, he will only be able change things about his own account anyway, since he don't know the other user's passwords. And if you worry about someone registering tons of accounts, remember that the very same thing can happen over a web forum anyway. And the php script can have protection against that.

    How safe it is, will be completely determined by the users php programming skills. A direct connection to an SQL database, doesn't sound safe under any circumstances. In that case, the user will just be able to look at what data was used to connect to the database, use that information to connect from another client, and change lots of things...

  5. #15
    Clicker Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Universal Windows Platform Export Module (Steam)

    Join Date
    Jul 2006
    Posts
    2,023
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: ODBC MySQL Connection Problems

    or you could be sneaky and host your OWN server, or get a dedicated / shared server and host the game SERVER exe on it, then the client contacts the MOOd which will get data from MySQL directly, this is in both MMORPGs i am working on

  6. #16
    Clicker Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Universal Windows Platform Export Module (Steam)

    Join Date
    Jul 2006
    Posts
    2,023
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: ODBC MySQL Connection Problems

    or you could be sneaky and host your OWN server, or get a dedicated / shared server and host the game SERVER exe on it, then the client contacts the MOOd which will get data from MySQL directly, this is in both MMORPGs i am working on

  7. #17
    Clicker Multimedia Fusion 2 DeveloperAndroid Export Module

    Join Date
    Jun 2006
    Location
    Canada
    Posts
    611
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: ODBC MySQL Connection Problems

    This system is interesting.. but is there a way.. to only enable MooSock access to the php file ? and exclude external access?

  8. #18
    Clicker Multimedia Fusion 2 DeveloperAndroid Export Module

    Join Date
    Jun 2006
    Location
    Canada
    Posts
    611
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: ODBC MySQL Connection Problems

    This system is interesting.. but is there a way.. to only enable MooSock access to the php file ? and exclude external access?

  9. #19
    Clickteam Clickteam
    Jeff's Avatar
    Join Date
    Jun 2006
    Location
    Battle Ground Washington
    Posts
    11,825
    Mentioned
    8 Post(s)
    Tagged
    2 Thread(s)

    Re: ODBC MySQL Connection Problems

    Have a check on the submitted data, perhaps using an MD5 hash or other hash.

    If the hash fails to match discard all the data and exit the script as you know its tampered with.

  10. #20
    Clickteam Clickteam
    Jeff's Avatar
    Join Date
    Jun 2006
    Location
    Battle Ground Washington
    Posts
    11,825
    Mentioned
    8 Post(s)
    Tagged
    2 Thread(s)

    Re: ODBC MySQL Connection Problems

    Have a check on the submitted data, perhaps using an MD5 hash or other hash.

    If the hash fails to match discard all the data and exit the script as you know its tampered with.

Page 2 of 4 FirstFirst 1 2 3 4 LastLast

Similar Threads

  1. Connection problems with my application
    By Lord_Wezel in forum Lacewing
    Replies: 0
    Last Post: 25th February 2011, 07:22 PM
  2. MySQL base connection using SQL Serwer or ODBC
    By EasySite in forum Multimedia Fusion 2 - Technical Support
    Replies: 1
    Last Post: 11th October 2010, 01:32 PM
  3. Can I create an ODBC connection to a remote mySQL?
    By RGBreality in forum Multimedia Fusion 2 - Technical Support
    Replies: 1
    Last Post: 22nd September 2010, 06:59 PM
  4. Public MOO Server - Connection Problems
    By CodeCannon in forum Multimedia Fusion 2 - Technical Support
    Replies: 3
    Last Post: 6th March 2008, 07:19 PM
  5. odbc
    By bensmid66 in forum Multimedia Fusion 2 - Technical Support
    Replies: 6
    Last Post: 26th October 2007, 08:37 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
  •