Print Page - HUGE UPDATE

Title: HUGE UPDATE
Post by: Hunter on November 27, 2012, 11:12:22 pm

Some major updates in last 2 months esp the one posted today.

Go to test locally on my test server and if it works fine then I'll update EZ Server with the new source code.

This will include some major changes such as the loot system. May be better or worse, we'll fine out when its put in. But its todays changes that makes me want to update now.

http://projecteqemu.googlecode.com/svn/trunk/EQEmuServer/changelog.txt

If we use the updates possible in the next 24 hour then I'll post about it. EZ Server would probably be down for a little bit too, maybe 1 hour.

Code:

==11/27/2012==
Sorvani: fix for newly created items with unlmiited charges to actually be usable.
Sorvani: (Uleat) Lore check is now made for items inside bags being trade before the trade completes.
Akkadius: Started first works of implementing QueryServ for what it was meant to be used
Akkadius: Moved QueryServ to it's own configuration block in the eqemu_config.xml (example):
	<qsdatabase>
		<host>localhost</host>
		<port>3306</port>
		<username>root</username>
		<password>password</password>
		<db>queryserv</db>
	</qsdatabase>
Akkadius: QueryServ can now be used on a separate server and can use an entirely separate database as it was meant to
Akkadius: Added 'loottable_id` to NPC::ModifyNPCStat which also changes quest::ModifyNPCStat(identifier, newValue); as well
Akkadius: Fixed heap corruption in quest_globals that would occur if a value over 64 bytes was created
Akkadius: Changed value size in qglobals from 64 bytes to 128 bytes
Akkadius: Added #reloadworld - This command will reload every single zones Perl quests and reboot them

Perl Changes:
Akkadius: Added EVENT_DISCONNECT to global_player.pl/player.pl - Event that triggers whenever a character disconnects from the world
Akkadius: Added EVENT_CONNECT to global_player.pl/player.pl - Event that triggers whenever a character connects to the world
Akkadius: Added EVENT_TASK_UPDATE to global_player.pl/player.pl - Event that triggers whenever a donecount is incremented in a task, exports variables: $donecount, $activity_id and $task_id
Akkadius: Added EVENT_TASK_COMPLETE to global_player.pl/player.pl - Event that triggers whenever a task is complete, this can sort of be checked in EVENT_TASK_STAGE_COMPLETED already but this is more finite, exports variables: $donecount, $activity_id and $task_id
Akkadius: Added EVENT_TASK_FAIL to global_player.pl/player.pl - Event that triggers whenever a task has failed, exports variables: $task_id
Akkadius: Added $client->SignalClient($data), it uses the client as the initiator and the client that gets sent the data, good for entity_list iterations through client
Akkadius: Exported $client->AddAlternateCurrencyValue(currency_id, amount); originally created by KLS
Akkadius: Added quest::gettaskactivitydonecount(task, activity); which obviously will get the amount done in a task based on task and activity
Akkadius: Added cross zone client signalling capability by character ID: quest::crosszonesignalclientbycharid(char_id, data);
Akkadius: Added cross zone client signalling capability by character Name: quest::crosszonesignalclientbyname(Name, data);
Akkadius: Added cross zone client messaging capability by character Name: quest::crosszonemessageplayerbyname(Type, Name, Message);
Akkadius: Added the ability to flow #commands through Perl, by flow meaning if the command doesn't process through the traditional command system, it will dump the output to EVENT_SAY in player.pl/global_player.pl based on rule Chat:FlowCommandstoPerl_EVENT_SAY

QueryServ Changes:
* I plan on adding much more logging to this server, but for now I've started with the following:
* QueryServ requires rules to be enabled before packets get sent to QueryServ, otherwise World/Zone doesn't need to even craft the packets for logging
Akkadius: Logging all player kills through QueryServ, you need to have QueryServ:PlayerLogNPCKills Rule Enabled, type: 0 = Solo, 1 = Group, 2 = Raid
Akkadius: Player trades logging started but definitely not finished
Akkadius: Removed the rules system from QueryServ, rules should only be read from World/Zone

REQUIRED SQL: utils/sql/queryserv/2268_QueryServ.sql

Database Changes:
Akkadius: Added a field in `character_` called `firstlogon` that will essentially be booled true when a player logs on, it handles a characters online status between world and zone and ultimately gets used in EVENT_CONNECT
Akkadius: Completely dropped the `id` column in `quest_globals`, the (`charid`, `npcid`, `zoneid`, `name`) fields will act as the primary keys, tested and working fine. This solves capping out on ID's as they are unecessary.
Akkadius: Changed value size of `quest_globals` field `value` from 64 bytes to 128 bytes
Akkadius: Removed an AA that was causing heap corruption

REQUIRED SQL: utils/sql/svn/2268_required_updates.sql

Title: Re: HUGE UPDATE
Post by: Strix on November 27, 2012, 11:44:56 pm

Quote

Divine Intervention baseline is now correctly set to 8000HP (from 50k) (RULE: DivineInterventionHeal)

Wow - that's a LOT of changes!! How does an update like this affect EZ's custom values? DI being set to 8000HP (for example) will effectively make the spell useless on EZ with players who have HPs into the millions. Does the server retain all its custom content or would this update overwrite a heap of things?

Title: Re: HUGE UPDATE
Post by: Hunter on November 28, 2012, 12:01:18 am

That update was on 8/16 and we have that source already.

Update is going to be from loot drop changes and up.

Title: Re: HUGE UPDATE
Post by: Natedog on November 28, 2012, 12:13:04 am

Quote

Sorvani: Tabasco sent in this bugfix: Ranged attack crash
It doesn't happen every time, but if an NPC is flagged for ranged attacks and they kill their target, the AIProcess function continues on under the assumption that the target is still available.

No wonder when my wizard gets 1 shot from Ranged it would crash the zone!! lol

Title: Re: HUGE UPDATE
Post by: Hunter on November 28, 2012, 01:59:59 am

Everything went well with testing the new updates.

Charm Upgrades that are suppose to be 1/666 are showing chance of 0.0015 which is correct.

Everything else working as well. Going to bring down EZ Server to install new source.

Thanks Akkadius for all the really good updates!

Title: Re: HUGE UPDATE
Post by: Camric on November 28, 2012, 05:20:23 am

Has Akkadius or others done performance testing for the new tools, such as, QueryServ? With limited resources both in hardware and bandwidth it would be of value for Hunter to know the potential impact and the scalability for these tools prior to implementing.

Thanks for the update

Title: Re: HUGE UPDATE
Post by: Hunter on November 28, 2012, 05:48:08 am

Updates are mostly working except NPC's can't see your qglobals which is the table that stores your flags.

I might have to revert back to our old server code if I can't figure this out.

Title: Re: HUGE UPDATE
Post by: Secrets on November 28, 2012, 06:41:18 am

Quote from: Hunter on November 28, 2012, 05:48:08 am

Updates are mostly working except NPC's can't see your qglobals which is the table that stores your flags.

I might have to revert back to our old server code if I can't figure this out.

I got this, don't worry!

Check out r2771.

Title: Re: HUGE UPDATE
Post by: Hunter on November 28, 2012, 06:43:45 am

Checking now. BIG THANKS!

Will update

Title: Re: HUGE UPDATE
Post by: Hunter on November 28, 2012, 06:54:55 am

I see 2268_required_updates.sql was updated when doing scv update but I can't see what changed, no need to run that one again?

Title: Re: HUGE UPDATE
Post by: Secrets on November 28, 2012, 06:58:37 am

Quote from: Hunter on November 28, 2012, 06:54:55 am

I see 2268_required_updates.sql was updated when doing scv update but I can't see what changed, no need to run that one again?

Shouldn't need to update that one, at least I don't think so. Akkadius may have added some last minute changes, at this point I would run this query:

REPLACE INTO `rule_values` VALUES ('1', 'Chat:FlowCommandstoPerl_EVENT_SAY', 'true', '');
REPLACE INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'QueryServ:PlayerLogNPCKills', 'false', '');
REPLACE INTO `rule_values` (`ruleset_id`, `rule_name`, `rule_value`, `notes`) VALUES (1, 'QueryServ:PlayerLogTrades', 'false', '');

There were only code changes after those updates. They were just so the rule appears in your database. Should boot without it but meh, up to you!

Title: Re: HUGE UPDATE
Post by: Hunter on November 28, 2012, 06:59:13 am

Works now! Thanks secrets!

#globalview doesn't show 0 anymore, instead it gives me a list :)

My qglobal testing NPC's showing that they see the values too.

Title: Re: HUGE UPDATE
Post by: Secrets on November 28, 2012, 06:59:35 am

Quote from: Hunter on November 28, 2012, 06:59:13 am

Works now! Thanks secrets!

#globalview doesn't show 0 anymore, instead it gives me a list :)

My qglobal testing NPC's showing that they see the values too.

Awesome, glad to hear! If there's anything else broken you know where to contact me :)

Title: Re: HUGE UPDATE
Post by: Hunter on November 28, 2012, 07:05:00 am

Oh, I'm sure I'll break stuff in the future. This current fix saved me 24 hours of hair pulling. Thanks for fast response and quick debug.

Server will probably be unlocked soon, just doing final test before unlocking.

Title: Re: HUGE UPDATE
Post by: wolfegunr on November 28, 2012, 10:18:28 am

T6 trash mobs are dropping augs almost 80% of the time. Something is out of whack. Also I hear HOH mobs are dropping tokens 80% of the time.

Title: Re: HUGE UPDATE
Post by: Fjord on November 28, 2012, 10:22:37 am

Gems are dropping at pretty much the old rate (before the change a few days ago) in LDoN.

Title: Re: HUGE UPDATE
Post by: Blurring on November 28, 2012, 11:20:11 am

Can confirm T6 non-armor aug drop rate near 100% off trash. Tokens in HoH are definitely dropping very commonly.

In about a 30 minute span of wisp hunting in Jaggedpine I have seen 0 GLS, I don't think it's bad luck any more hehe. *EDIT* Have seen at least a couple drop now. Certainly seems lower but could just be my impatience :)

Title: Re: HUGE UPDATE
Post by: cerwin on November 28, 2012, 11:45:04 am

Seems weapon aug drops are about 90% across all zones. About 9 out of every 10 mobs drops one in ldon

Title: Re: HUGE UPDATE
Post by: Fjord on November 28, 2012, 11:49:00 am

My warrior alone seems to have the power to completely crash the nexus and qrg when he hails the Universal Teleporter. His name is Ohno if the irony wasn't clear enough. I guess I will stop using him for a little while, but it doesn't seem to occur on my other older characters.

Title: Re: HUGE UPDATE
Post by: Mattnaik on November 28, 2012, 12:14:37 pm

Quote from: Blurring on November 28, 2012, 11:20:11 am

In about a 30 minute span of wisp hunting in Jaggedpine I have seen 0 GLS, I don't think it's bad luck any more hehe. *EDIT* Have seen at least a couple drop now. Certainly seems lower but could just be my impatience :)

I've been farming them on and off all day and I don't see a difference in drop rate

Title: Re: HUGE UPDATE
Post by: cerwin on November 28, 2012, 12:18:58 pm

Quote from: Thorleif on November 28, 2012, 11:49:00 am

I dont think its just you. Have seen alot of crashes for surefall and nexus since the patch.

Title: Re: HUGE UPDATE
Post by: Xiggie | Stone on November 28, 2012, 12:45:20 pm

Quote from: Thorleif on November 28, 2012, 10:22:37 am

Gems are dropping at pretty much the old rate (before the change a few days ago) in LDoN.

I wish this would stay this way. I liked making a little plat while farming ldon charms.

Title: Re: HUGE UPDATE
Post by: napoleonn on November 28, 2012, 01:47:13 pm

Quote from: Blurring on November 28, 2012, 11:20:11 am

Tokens in HoH are definitely dropping very commonly.

Ive seen around 100 tokens drop in a hour

Title: Re: HUGE UPDATE
Post by: Hunter on November 28, 2012, 03:54:07 pm

Seems that it could be a problem with converting the old loot system to the new one.

Its possible where I had before a 2% chance to drop 1 of 30 items in a list now has a 60% chance of dropping an item.

Hope that makes sense.

I need a clear list of what is broken. Hopefully EZ Server doesn't have too many big list. Gem drops would be the common type of big list.

Title: Re: HUGE UPDATE
Post by: Hunter on November 28, 2012, 04:45:57 pm

Loots are obviously not working as intended.

Might need to roll back to the last back up.

Server is just staying up right now for lack of better ideas while I look at how to fix it.

Could take a week to fix them in the new system to work as intended.

I really prefer not to go back to the old code.

Title: Re: HUGE UPDATE
Post by: cerwin on November 28, 2012, 05:11:44 pm

Quote from: Hunter on November 28, 2012, 04:45:57 pm

Omg please dont rollback, i did the crafters guild quest all today and theres no way i will ever do it again =P

Btw the only loot that seems messed up is that weapon augs are dropping alot more (does anyone even use them?). Gems and all other drops seem normal to me.

Edit: oh and HoH tokens, big whoop =P

Title: Re: HUGE UPDATE
Post by: Natedog on November 28, 2012, 05:20:53 pm

X mob has 10% Lootdrop_id -- inside the lootdrop_id are 10 items .. these items should be set to 1% chance to equal the 10%... which seems different from the way old loot tables worked

This is how I think it works.. not sure how accurate that statement is.. but seems correct from looking at my database with the new loot system.

Title: Re: HUGE UPDATE
Post by: wolfegunr on November 28, 2012, 07:27:01 pm

+1 on cerwin post, its non essentials dropping i did a lot of work today that would be undone.

Title: Re: HUGE UPDATE
Post by: Gannicus on November 28, 2012, 07:38:42 pm

I myself would have to veto the idea of a rollback, I know I cant contribute much to find a solution other than this, but with the amount of aas i've grinded in this time and how close I am done with this hell level, would be discouraging to see these hours of aa grinding be for nothing.

Title: Re: HUGE UPDATE
Post by: Adydar on November 28, 2012, 07:54:59 pm

Did a bunch of charm farming, I'll throw my hat into the ring of please no roll back.

Title: Re: HUGE UPDATE
Post by: hateborne on November 28, 2012, 07:56:26 pm

With a nightmare of problems happening, it probably isn't even wise to do anything extremely deep or complicated. With any massive change over, there is always a small chance for failure.

-Hate

Title: Re: HUGE UPDATE
Post by: Drast on November 28, 2012, 08:54:41 pm

yeah did a bunch of Named farming in T5 today. going to suck loosing those if a rollback happens.

Guess that not all improvements come off flawlessly. Hunter still does a great job without having a huge paid staff, so I'm willing to cut him a break on stuff like this.

Title: Re: HUGE UPDATE
Post by: napoleonn on November 28, 2012, 08:57:11 pm

Quote from: Hunter on November 28, 2012, 04:45:57 pm

Loots are obviously not working as intended.

Might need to roll back to the last back up.

Oh come on i spent 5 hours finishing up both my uc's i was working on! charms weren't dropping any more then they usually do, if anything they were dropping less! :(

Title: Re: HUGE UPDATE
Post by: zymral on November 28, 2012, 09:41:29 pm

When will we know if you are going to roll back i really dont want to turn in / finish farming fg stuff till you know / roll back the server.

Title: Re: HUGE UPDATE
Post by: Lexington on November 28, 2012, 09:56:21 pm

prolly being rolled back now. while it may suck that we lose out on stuff it's not like we didn't get a little bit of a warning- least via forums too :)

Title: Re: HUGE UPDATE
Post by: 1flytrapp on November 28, 2012, 10:19:02 pm

Looks like server crashed or was brought down

Title: Re: HUGE UPDATE
Post by: Akkadius on November 28, 2012, 11:36:19 pm

I've been working with Hunter, stopped quite a while ago as he's been making his own preparations.

He's got intermittent crashes that haven't been cleanly reproducible yet he doesn't have the proper setup currently to debug any zone crashes.

He'll let you know of any further information.

Loot isn't necessarily an issue, it's more the crashes that players were reporting. I don't know how many were happening and how they were happening but that would all be good information to know.

Title: Re: HUGE UPDATE
Post by: Obskure on November 28, 2012, 11:40:47 pm

I second the pls don't roll us back finally got 2 rares today for my t5 flag, but hey you gota do what you gota do.

Title: Re: HUGE UPDATE
Post by: Hunter on November 28, 2012, 11:43:22 pm

Posted a new topic on the rollback.

I realize some players got lucky on loot. The loot system was broken. I don't need a flooded market from broken loots.

Title: Re: HUGE UPDATE
Post by: Hunter on November 28, 2012, 11:45:11 pm

I know a lot of players crashed zones. Can we be specific how we were doing it? Which buff did you use. Which NPC did you hail and what did you say to the NPC etc?

Thanks Akkadius for the time helping so far.

Title: Re: HUGE UPDATE
Post by: Natedog on November 28, 2012, 11:53:17 pm

Quote from: Hunter on November 28, 2012, 11:45:11 pm

I know a lot of players crashed zones. Can we be specific how we were doing it? Which buff did you use. Which NPC did you hail and what did you say to the NPC etc?

Is it possible to reflect the shout kill you cast on yourself? Sounds confusing... but not even sure how reflecting spells worked. (Sm // Goblin pet buff)

Just spam hailing the crap out of the buff bot I was able to make an instance of Nexus crash and it would shoot my client instantly to the log in screen. Like a World Kick.

Only on a SPAM // Death is where it would crash my instance. (Guessing getting the buff spam + client death)

If I used invuln I could spam her infinitely and it would not crash at all. I was getting tons of buffs over and over.. and getting chain DTed but never crashed. Then I stopped hailing when my Invuln wore off and zone stayed stable.

Any possibility the crashes were from qglobals checking character flags when hailing NPCs?

EZ Server

General Category => Updates => Topic started by: Hunter on November 27, 2012, 11:12:22 pm