Database Save

Page 1 of 2 12 LastLast
Results 1 to 15 of 26
  1. #1
    One word! Im Fawkin Pro! Xakzi is offline
    MemberRank
    Jul 2010 Join Date
    SwedenLocation
    1,356Posts

    Database Save

    Yo!

    Some people have had rollback problems due to the database saving the game each 15 minutes..

    so here is a small snippet for how to change the time! :)

    1. You need to have a working source (Will not help with that)
    2. I don't see why you should get an error out of this release
    3. Add this spoiler to the snippet (mod)

    Spoiler:

    Open User.h
    Find
    Code:
    #define SEC_SAVEPLAYER 900
    Seconds = 900 =
    Minutes = 15

    So, if you want it to save each minute,
    you change it to;

    Code:
    #define SEC_SAVEPLAYER 60
    Simple eh? :)


    Sincerely~ Xakzi


  2. #2
    Account Upgraded | Title Enabled! Charles101 is offline
    MemberRank
    Feb 2012 Join Date
    Saint MorningLocation
    241Posts

    Re: Database Save

    i think it increases lag?

  3. #3
    Flyff Developer ShadowDragon is offline
    MemberRank
    Apr 2009 Join Date
    1,916Posts

    Re: Database Save

    Quote Originally Posted by Charles101 View Post
    i think it increases lag?
    It would. but if you have a relatively low number of players, the lag won't be enough to notice.

  4. #4
    One word! Im Fawkin Pro! Xakzi is offline
    MemberRank
    Jul 2010 Join Date
    SwedenLocation
    1,356Posts

    Re: Database Save

    Quote Originally Posted by ShadowDragon42 View Post
    It would. but if you have a relatively low number of players, the lag won't be enough to notice.
    or a relatively strong computer

  5. #5
    Flyff Developer ShadowDragon is offline
    MemberRank
    Apr 2009 Join Date
    1,916Posts

    Re: Database Save

    Quote Originally Posted by Xakzi View Post
    or a relatively strong computer
    That works too =P lol

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

    Re: Database Save

    Surprise question of the day: May I add this to our compilation thread?

  7. #7
    Flyff Developer ShadowDragon is offline
    MemberRank
    Apr 2009 Join Date
    1,916Posts

    Re: Database Save

    It does fall under the category of source edits, although it's a very small edit lol

  8. #8
    One word! Im Fawkin Pro! Xakzi is offline
    MemberRank
    Jul 2010 Join Date
    SwedenLocation
    1,356Posts

    Re: Database Save

    Quote Originally Posted by Improved View Post
    Surprise question of the day: May I add this to our compilation thread?

    Suprise answer of the day: The Hell you will!
    hahahah :p

    Go ahead hun

  9. #9
    Proficient Member Jcdacez is offline
    MemberRank
    Mar 2010 Join Date
    EnglandLocation
    185Posts

    Re: Database Save

    ive tried this myself and i ended up with a ton of deadlocks, idk if it was related tho, but they went up a TON after doing this.

  10. #10
    Flyff Developer ShadowDragon is offline
    MemberRank
    Apr 2009 Join Date
    1,916Posts

    Re: Database Save

    Quote Originally Posted by Jcdacez View Post
    ive tried this myself and i ended up with a ton of deadlocks, idk if it was related tho, but they went up a TON after doing this.
    Um, we can't confirm that without full specifications for your server.

  11. #11
    Flyff Developer Intelligence is offline
    MemberRank
    Oct 2011 Join Date
    United KingdomLocation
    1,401Posts

    Re: Database Save

    Is this the one that if Worldserver went DOWN, no ROLLBACK will happen?

  12. #12
    Trust your senses Gravious is offline
    MemberRank
    Sep 2009 Join Date
    NetherlandsLocation
    713Posts

    Re: Database Save

    Yes, it is.
    Posted via Mobile Device

  13. #13
    Flyff Developer Intelligence is offline
    MemberRank
    Oct 2011 Join Date
    United KingdomLocation
    1,401Posts

    Re: Database Save

    Quote Originally Posted by Gravious View Post
    Yes, it is.
    Posted via Mobile Device

    Alright, cheers.

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

    Re: Database Save

    You wont get lag if you manage the number of query per second. Also if you have an high player count with express version this may cause lag.
    Posted via Mobile Device

  15. #15
    !@#$%^&*() Langstra is offline
    MemberRank
    Feb 2011 Join Date
    Among heroesLocation
    479Posts

    Re: Database Save

    Does the express version have a limit to the amount of queries per second? Or is there something else that makes the chance of lag higher with the express version.
    At what number of players should you be worried, not that a friends server will have to cope with it, but let's take a pretty large/popular server. At how many players will it cause the server to lag?



Page 1 of 2 12 LastLast

Advertisement