Results 1 to 10 of 11

Thread: Store player informations with MySQL.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #2
    Assadministrator IzNoGoD's Avatar
    Join Date
    Aug 2012
    Posts
    1,731
    Thanks
    17
    Thanked 1,082 Times in 683 Posts
    1. its easy to exploit your database system, just naming myself something with ' will escape your string-input. User input == evil, so treat it as such.
    2. You should look into insert...on duplicate key update....
    3. You are using the most basic mysql functions, which can cause your server to lagg. Try looking into the async mysql module i inserted into libcod.
    4. Can you confirm by using phpmyadmin or heidisql that the changes are actually in the database? if not, your connection to the database might not even exist.

    Edit 5. your insert into doesnt specify the guid of the player, which is the primary key of the table and should always be set.
    "Does not work" is an error report for a bug between keyboard and chair.

    All hail Artie Effem

  2. The Following User Says Thank You to IzNoGoD For This Useful Post:

    kung foo man (4th July 2015)

Posting Permissions

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