Instances Rollover

[Guest]

Welcome, Guest. Please login or register.
Did you miss your activation email?

1 Hour 1 Day 1 Week 1 Month Forever

Login with username, password and session length

Getting Started

Rules

Character Mover

Optimization Guide

EZ Wiki

EZ Guide

Magelo

Zone List

Spell Recipes

T10.5 Spell Recipes

Crafting Recipes

Donate

EZ Player Discord

[EZ Server Files]

EZ Server Files

EZ Client Downloads

Custom UF MiniMap

Custom UF Inventory

EQEmu Server Status

EQEmulator Home

Allakhazam Home

UFMissingFilesList

TwitchTV

[Natedog]

DBI seems to be more reliable than qglobals, for example our Trivia Bot runs off DBI.

I've been using quest gobals to create the instances ... then when I want to find the instance to send a player there I use DBI ... so far seems pretty reliable .. just gotta lag test it with a bunch of boxes loaded lol

[Hunter]

ahh you set the global the normal way, but reading the global via DBI? So we're sort of using both?

[Camric]

Looking at what Akkadius shared, I see a delete function, but is there a clean up procedure or service to remove expired instances from the table?   Keeping the tables clean will ensure the queries are efficient and lessen the need to create indexes.

[hateborne]

Looking at what Akkadius shared, I see a delete function, but is there a clean up procedure or service to remove expired instances from the table?   Keeping the tables clean will ensure the queries are efficient and lessen the need to create indexes.

I'm working on trying to do just that. I am having issues with the logging on my server stopping for no apparent reason, which is making it harder to test. When I get home, I will continue my faceroll.


-Hate

[Hunter]

try #logs quest

Can see which line number has errors or warnings while doing a #reloadquest or hailing npc.

[hateborne]

try #logs quest

Can see which line number has errors or warnings while doing a #reloadquest or hailing npc.

Sexy. I will try that when I get home (~6-7pm EST) and see what I can do.


-Hate

[Camric]

If you don't mind sharing the code Hate, I'd like to have a look at what you have.

[hateborne]

Probably Camric.

First day in a bit that I have been able to work on it again. Thanks to Hunter's post, making headway on it again.

Not going to promise or "present" anything yet, as it's a bit soon. That being said, looking at group/guild/raid instances. Group instances are essentially the "throwaway" instance. Guild instances last the longest. Raid instance is likely going to be the most commonly used. I'm trying to set the raid instance up to allow the raid in and then (hopefully) allow invites.

Anywho, back to work.


-Hate

[Fliker]

What's repop on t6?

Raid instance should be close to that imho.

[Mattnaik]

Group instances are 5k, they can just buy one of those. If they can't afford 5k, they can go kill 4 mobs in velks.

Except you can't create a group instance unless you are in a group. It yells at you when you attempt to create one. A minor inconvenience to log on an alt and invite them to group just to spawn the instance but removing the check if you were in a group would be better IMO.

[hateborne]

What's repop on t6?

Raid instance should be close to that imho.

Repop time: 3 days.

I was looking at setting 5 days for guild, 24h for raid, and 6-12 for group. Obvious subject to change, but I cannot see anyone outside of a guild actually waiting the 3 days to redo instance. Leaving it up and active I could see for those slowly clearing through, but the two biggest things that I am trying to tackle are instance reliability (a.k.a existing 5 minutes from now...) and efficient instance transitions (invites without reforming).

If there is a maximum number of instances that can be created in the server code, we need to minimize the number created. Having a ton of orphaned raid instances won't help this at all. I am trying to find creative ways to tie these to players over play sessions, but it's slow going. I am trying to avoid having a giant array loop run each time to update/remove members from raid/guild instances as it's going to get sluggish across 30+ waypoint npcs.

Will update more as I have time.


-Hate

[Hunter]

did this poll work?


yes
no



edit: i swear i clicked cancel on this thread, thus the no poll.

[Hunter]

fail?

[Fugitive]

did this poll work?


yes
no



edit: i swear i clicked cancel on this thread, thus the no poll.

no clue what this was..

[hateborne]

Due to pretty hellish time constraints for the next month or so, I will be unable to continue any form of serious testing. I can still write up things, but I will be unable to test in any form until like March(ish).

As such, I am dumping the little bit that I had from the new instance system that I was trying to work on. Maybe Akkadius, lerxst2112, Paldail, and/or Felony can finish and test this out.


THE FOLLOWING IS INCOMPLETE!
http://hateborne.com/ezserver/debug/Incomplete%20Instances.zip

There are three files in the archive: waypoint.pl, waypoint_assistant.pl, and instance_table.sql

The waypoint.pl contains the actual waypoint quest script. This handles all the heavy lifting.

The waypoint_assistant.pl contains a "sweeper" script to be attached to some static npc in a static zone (cannot be instanced). It runs through every so often and cleans the instance table. It needs to also delete the instances from the builtin instance store using the quest::DestroyInstance (if applicable).

The instances_table.sql is the SQL file to build the table in the database. This is where the new system would be storing the instance records. I am trying to use DB over QGlobals as there is no refresh period or funky rain dance associated with DB calls. The data either exists or doesn't.


I'm sorry to go and be a spoilsport, but I simply don't have the time. I don't even really play games at the moment.


-Hate

Advanced search

• Official Guild Creation R... by Draca [June 19, 2024, 07:25:31 am]
• New Server update causing... by Mixlor [June 02, 2024, 01:01:54 am]
• Memorial Day Event by wachna [May 30, 2024, 01:52:28 pm]
• EZServer Rules by Sarthin [May 30, 2024, 01:10:12 pm]
• Fear Itself, testing week... by torotornot [May 24, 2024, 09:29:42 am]
• Fear Itself, the new Even... by kendiian [April 26, 2024, 11:48:38 pm]
• Recent & Upcoming Changes by Dokplayer2 [April 23, 2024, 10:48:30 pm]
• Issue with my epic by fangzy [April 22, 2024, 07:32:32 pm]
• Few Changes - T11, VP, Gu... by clbreastmilk [April 10, 2024, 11:32:33 am]
• Combine HoH tokens macro.... by Dbeast [April 04, 2024, 05:10:46 pm]
• Warlock self buffs by Fecs [April 04, 2024, 03:56:08 pm]
• T11 Feedback Thread by Pubis [April 03, 2024, 12:54:53 pm]
• T10 Sunderock quest track... by Marcone [March 12, 2024, 07:12:11 am]
• It makes me very happy to... by Sarthin [March 10, 2024, 08:18:12 am]
• Broken Stuff Repair Shop ... by gnonim [March 08, 2024, 10:39:39 am]
• World loot currently brok... by Sarthin [March 08, 2024, 12:36:31 am]
• Testing Help Needed - Tes... by Sarthin [February 28, 2024, 09:49:51 am]
• Tier 11 - Kael Drakkel by Sarthin [February 25, 2024, 09:11:15 am]
• Set filters macro by Marcone [February 23, 2024, 05:13:59 pm]
• TOFS and possible spell b... by AreFitz [February 20, 2024, 02:31:05 pm]
• At Long Last....Tier 11. by Draca [February 16, 2024, 09:30:46 pm]
• Kickoff to T11 by Draca [February 15, 2024, 08:45:03 pm]
• T11 NPC Testers by Serra Angel [February 05, 2024, 05:20:29 pm]
• RALLOS ZEK EVENT by gnonim [February 01, 2024, 09:13:31 am]
• EZ Update - T11, Recent C... by Draca [January 31, 2024, 05:25:11 pm]
• T5 Named kills by ZerarWarrior [January 24, 2024, 08:08:07 am]
• Possible bug by Raygan [January 17, 2024, 03:35:08 pm]
• Tier 11, Kael Drakkel Upd... by Draca [January 09, 2024, 12:42:02 pm]
• Multi-botting instances by Serra Angel [December 31, 2023, 02:19:16 am]
• New Characters crashing w... by ZerarWarrior [December 30, 2023, 01:16:50 pm]

Members

• Total Members: 6133
• Latest: entrey73

Stats

• Total Posts: 65023
• Total Topics: 5057
• Online Today: 110
• Online Ever: 8678
• (December 19, 2022, 02:32:09 pm)

Users Online

Users: 0
Guests: 65
Total: 65