Jump to content
RF-Dev | RF Online Development

Creatorly

Member
  • Content Count

    79
  • Joined

  • Last visited

  • Days Won

    3

Creatorly last won the day on July 6

Creatorly had the most liked content!

1 Follower

About Creatorly

  • Rank
    Senior Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Creatorly

    Yorozuya - Open Source Zone Guard [2.2.3.2]

    Been off for a while dev'ing other things not RF related. I'll look for the .dll on my pc and upload it. my fixes include 1. Potion Error fix for set items 2. Fix for not being able to go through portals when in battle mode 3. Fix for guard towers being recognized as traps and throwing "unable to put anymore traps" error
  2. Creatorly

    RF Fedor @ DevCorp

    I fully agree with this statement and can confirm that Rayzer does ask for your db credentials, but thats not the worst of it. In reality not only does he ask for the DB credentials, but also the server host credentials as well
  3. Creatorly

    SQL Stale Cursor Error

    The error looks to be caused by LoadKillerListImpl under PlayerEx_PvpOrderViewDB.cpp From what I gather what it does is it checks tbl_KillerList for the current character and inserts the records for new kills. And then it probably crashes while it loops because not all of the resources are cleared before the next loop iteration I commented this out and will let you know what happens - from what i tested i still get pvp points / certain points for kills even though its commented out.
  4. Creatorly

    RF Fedor @ DevCorp

    In yorozuya there's a DTrade log but it only contains logs regarding dalant / gold and not items.
  5. Creatorly

    RF Fedor @ DevCorp

    Game cp from Razr has this feature where he can pull trade logs per character / item ID you might want to check with him too
  6. Creatorly

    SQL Stale Cursor Error

    It fails during this method: CPvpOrderViewDB::LoadKillerListImpl under PlayerEx_PvpOrderViewDB.cpp Haven't had crashes for 3 days but suddenly it crashed again with the same error. Running the query that errors out shows a null value, but i've had crashes where it does return a value: And then my theory is it crashes here although i'm not 100% Read this post regarding the issue https://stackoverflow.com/questions/1752548/invalid-cursor-state-sql-state-24000-in-sqlexecdirect It looks like the root cause is something to do with not free-ing up resources before the next query but for this i think it might be the part where it tries to close the cursor. If anyone is familiar with cursors and whatnot please chime in, lets try and build yorozuya.
  7. Creatorly

    SQL Stale Cursor Error

    Yeah it looks exactly like the error i'm getting, also makes sense it would be a stale cursor since if the temp table has already been dropped or the index is no longer existing it wouldn't be able to call the next method. After you disabled it did you experience any issues regarding certain points?
  8. Creatorly

    SQL Stale Cursor Error

    ODBC settings, although if there was an issue there would’nt it error out all the time instead of just sometimes.
  9. Creatorly

    SQL Stale Cursor Error

    Yup i’ve disabled the modules that i don’t really use in order to reduce the load on loop() currently to no avail. I’m thinking it might be my odbc settings. I’ll post them in a bit
  10. Creatorly

    SQL Stale Cursor Error

    I recently moved back to Yorozuya 1.4.2 which coincidentally provides better logging. I’ve now identified the logs and query that causes zone to crash Has anyone experienced this before? I tried running it on its own and the query returns fine so the zone might be running a loop and fails during that step. Edit: it only happens before cw, other times when people kill each other its fine
  11. Creatorly

    Yorozuya - Open Source Zone Guard [2.2.3.2]

    What exactly are you asking help for?
  12. Creatorly

    DQS Thread Error?

    I've gone 3 days and counting without any crashes - honestly its weird that it suddenly stopped and I have no idea why. I have a patch this weekend and I'll turn on debug mode. Come to think of it, the other servers I dev'ed on all had debug mode on in their zone. Yeah I've been looking at ollydbg as well as the free version of IDA as well. Hopefully i learn something useful
  13. Creatorly

    DQS Thread Error?

    I don't think I'm qualified to be an actual contributor since I have to study a lot before making modules / fixes, I've only done minor fixes so far. @Asteria has already created an add-on for it and would be a great mentor for us all. On a side note, has anyone heard of dragon-dev? they look to be licensing / selling zone protection with modules too but I'm afraid it just might be a yorozuya fork or a fork of this http://forum.ragezone.com/f479/release-zoneserver-protect-2-2-a-1050028/
  14. Creatorly

    DQS Thread Error?

    With all due respect, if i knew what was going on i wouldn’t have posted about it right? I never said yorozuya was causing the crashes i was merely stating i was using yorozuya and saw these logs while investigating why the zone is crashing No where in any of my statements have i said that yorozuya was the cause of the error in the logs. what i DID say is yorozuya is crashing randomly. With that being said if you have any input regarding how to prevent the zone from crashing that would be good.
  15. Creatorly

    DQS Thread Error?

    Prob gonna go back to yorozuya 1.4.2 imo it was a more stable version albeit in pre release. It’ll never go into prod anyway since the developer stopped. I’ll just edit and release my fixes in 1.4 to 1.4.2
×