Page 3 of 3 FirstFirst 123
Results 21 to 25 of 25

Thread: Asynchronous mysql queries

  1. #21
    Assadministrator IzNoGoD's Avatar
    Join Date
    Aug 2012
    Posts
    1,718
    Thanks
    17
    Thanked 1,068 Times in 674 Posts
    Comment the bind-address out in /etc/mysql/my.cnf using a # at the start of the line, then you can connect from all ips.

    Make sure to just whitelist the ips you want in your firewall though.
    "Does not work" is an error report for a bug between keyboard and chair.

    All hail Artie Effem

  2. #22
    Sergeant serthy's Avatar
    Join Date
    Nov 2012
    Posts
    450
    Thanks
    96
    Thanked 296 Times in 188 Posts
    What are the NoSafe queries for? I've looked into the source, and if you have NoSafe, you just do not call mysql_store_result() on it, but I'm not that firm with it.
    Is it for queries, that do only reading (not writing) the database?

    Also, it might be useful for others:
    • the mas string length that can be sent from CoD2 to the mysql server seems to be 512 chars
    • the libcod-functions in cod2 seem to have been renamed, the correct names can be found here: https://znation.nl/cod4script/
    Last edited by serthy; 5th September 2016 at 12:49.

  3. #23
    Assadministrator IzNoGoD's Avatar
    Join Date
    Aug 2012
    Posts
    1,718
    Thanks
    17
    Thanked 1,068 Times in 674 Posts
    nosave is to not save the result. (nosafe is not something in the code though, it's nosave)

    Stringlength is limited by the engine and should be 1024

    Yes, I renamed a few functions for my next mod, forgot to change them back in the code
    "Does not work" is an error report for a bug between keyboard and chair.

    All hail Artie Effem

  4. #24
    Sergeant serthy's Avatar
    Join Date
    Nov 2012
    Posts
    450
    Thanks
    96
    Thanked 296 Times in 188 Posts
    Quote Originally Posted by IzNoGoD View Post
    nosave is to not save the result. (nosafe is not something in the code though, it's nosave)
    wow, I feel stupid now..

    Okay, when I call mysql_async_create_query_nosave() once, all other queries (even normal async ones) fail to execute, I have to shut the server down (close the terminal/screen), a normal /killserver doesn't help

    But its just a note, I don't get it why one would use nosave when you do not get any result back? Maybe its just some mysql internals with this store

  5. #25
    Assadministrator IzNoGoD's Avatar
    Join Date
    Aug 2012
    Posts
    1,718
    Thanks
    17
    Thanked 1,068 Times in 674 Posts
    Quote Originally Posted by serthy View Post
    wow, I feel stupid now..

    Okay, when I call mysql_async_create_query_nosave() once, all other queries (even normal async ones) fail to execute, I have to shut the server down (close the terminal/screen), a normal /killserver doesn't help

    But its just a note, I don't get it why one would use nosave when you do not get any result back? Maybe its just some mysql internals with this store
    Try the same query with normal async create query, probably your query is fcked
    "Does not work" is an error report for a bug between keyboard and chair.

    All hail Artie Effem

Posting Permissions

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