Faction hits and sorting.

[nilbog]

This is something I've been wanting corrected for a while now.

Currently, when you kill an npc, the faction hits are sorted alpha ascending.

i.e.

You have slain Sergeant Miideanaer!
Your faction standing with ClawsofVeeshan got better.
Your faction standing with KingTormax got worse.
Your faction standing with Kromrif got worse.
Your faction standing with Kromzek got worse.This is wrong. The way it should work is that an npc's primary faction is displayed first.

You have slain Sergeant Miideanaer!
Your faction standing with Kromzek got worse.
Your faction standing with ClawsofVeeshan got better.
Your faction standing with KingTormax got worse.
Your faction standing with Kromrif got worse.So, this part is easily understood and will be corrected.

-----------------------------------------------------------------------------------------------

How should the rest of the hits be sorted? From logs/screenshots, the following is how they should appear.

You have slain Sergeant Miideanaer!
Your faction standing with Kromzek got worse.
Your faction standing with Kromrif got worse.
Your faction standing with KingTormax got worse.
Your faction standing with ClawsofVeeshan got better.You might think oh, well its sorted by the npcs faction hits from lowest negative to highest positive. But that's not the case. Here is a log from killing a random guard of Qeynos.

You have slain Guard Westyn!
Your faction standing with GuardsofQeynos got worse.
Your faction standing with AntoniusBayle got worse.
Your faction standing with CorruptQeynosGuards got better.
Your faction standing with CircleOfUnseenHands got better.
Your faction standing with MerchantsofQeynos got worse.Not only is not alphabetical ascending past the npc's primary faction, but also the 'got better' hits are above one of the 'got worse'.

Anyone have further insight into the ordering scheme used past the first line?

[maximum]

From my live experience, it is sorted by: a) Native Faction, then b) Highest Faction Amount to Lowest Faction Amount. 30 > 20 > 10 > 1.

Will dig up some screenshots.

Also, I have been wanting to bring up something similar. It's cosmetic, but "You have gained experience" message should be below faction hit message. Currently, it is not (and never has been).

[nilbog]

Also, I have been wanting to bring up something similar. It's cosmetic, but "You have gained experience" message should be below faction hit message. Currently, it is not (and never has been).

You are correct. Thanks

[maximum]

Screenshots with faction/exp messages:

http://www.steveprutz.com/files/image/xEQ000017.bmp (http://www.steveprutz.com/files/image/xEQ000017.bmp)

http://www.steveprutz.com/files/image/xEQ000030.bmp (http://www.steveprutz.com/files/image/xEQ000030.bmp)

Note: some appear to be from late 2001 and even possibly 2002-2003.
http://www.steveprutz.com/files/image/EQ000038.bmp
http://www.steveprutz.com/files/image/EQ000038.bmp

Notice that they all have the "spacing" that was patched, (e.g., Coalition Trade Folk Ill vs. CoalitionTradeFolkIll). I don't know when that patch came in.

[nilbog]

From my live experience, it is sorted by: a) Native Faction, then b) Highest Faction Hit to Lowest Faction Hit.


If this is the case, how can positives be higher than negative hits, or vice versa?

This one for example is worse, better, worse, better, better.

http://i46.tinypic.com/2lsuf9.jpg

[maximum]

Reworded above. I meant to say "amount of faction", largest to smallest.

Further clarifying: negative values are treated as positives when sorting

50
-40
30
20
-10
1

[nilbog]

Also, I have been wanting to bring up something similar. It's cosmetic, but "You have gained experience" message should be below faction hit message. Currently, it is not (and never has been).

This part fixed by kanras, pending update.

[maximum]

Fixed?

[enr4ged]

I don't think so, the faction hits are still in alphabetical order.

[Nirgon]

You have certainly got an eye sir

[nilbog]

Nope, the only thing fixed here was where the experience message was displayed on npc death.

Still looking for specifics for how they should be sorted.

[Lazortag]

Just using process of elimination here, I think amax is right that the factions should be listed in descending order of the absolute value of the faction hit (it can't be from highest to lowest or lowest to highest because a negative hit appears between two positive hits in that screenshot, and it can't be in alphabetical order as that screenshot also shows). This would make sense since that automatically puts the NPC's main faction first, and it seems consistent with all the evidence shown.

[nilbog]

Just using process of elimination here, I think amax is right that the factions should be listed in descending order of the absolute value of the faction hit (it can't be from highest to lowest or lowest to highest because a negative hit appears between two positive hits in that screenshot, and it can't be in alphabetical order as that screenshot also shows). This would make sense since that automatically puts the NPC's main faction first, and it seems consistent with all the evidence shown.

Well, I have a ton of screenshots, but too many other projects going on to research this fully. Feel free to collaborate!

[maximum]

Updated my first reply with the screenshots I could scrounge. If there are more, I'll add them to this reply.

[falkun]

Well, I have a ton of screenshots, but too many other projects going on to research this fully. Feel free to collaborate!

Screenshots with faction/exp messages:

http://www.steveprutz.com/files/image/xEQ000017.bmp (http://www.steveprutz.com/files/image/xEQ000017.bmp)

http://www.steveprutz.com/files/image/xEQ000030.bmp (http://www.steveprutz.com/files/image/xEQ000030.bmp)

Note: some appear to be from late 2001 and even possibly 2002-2003.
http://www.steveprutz.com/files/image/EQ000038.bmp
http://www.steveprutz.com/files/image/EQ000038.bmp

Notice that they all have the "spacing" that was patched, (e.g., Coalition Trade Folk Ill vs. CoalitionTradeFolkIll). I don't know when that patch came in.

I think Giegue is correct.

[maximum]

http://www.steveprutz.com/files/image/06%20at%20guild%20final.jpg

Absolute values, highest to lowest.

[Nirgon]

Sort with a lil math.abs and call it a day?

[Bamzal Sherbet]

listen. here is how it is sorted...

your first assumption was correct - highest adjustment to lowest adjusment

but when two factions have the same adjusment value, then they are sub-sorted alphabetically.

case closed.

[maximum]

http://www.silverblades-suitcase.com/eq/mm_aoe.jpg

Check out this faction hit message for Drusella and HS.... it's spelled "DrusselSathir"...

http://www.silverblades-suitcase.com/eq/sperm_pet.jpg

http://www.silverblades-suitcase.com/eq/torch_skeleton.jpg

DrusselSathir is a separate bug, I guess. More evidence: http://theclanhouse.yuku.com/reply/3679#.UYfjNW39thM

[nilbog]

DrusselSathir is a separate bug, I guess.

Fixed, pending update.

[Nirgon]

Maximum approaching max ally faction to me

[Henrik40]

Anything new here? I remember it as most people have stated as well. Main faction being fist, then the rest being listed by the amount of the faction hit, whether it's gained or lowered.

[maximum]

Bump. Order still does not look correct.

http://web.archive.org/web/20010602113017/http://plaza.ufl.edu/ojako/ :
http://web.archive.org/web/20010602194056im_/http://plaza.ufl.edu/ojako/mobs/talendor.jpg

Project 1999 Blue:
[Fri Jan 31 21:31:02 2014] Talendor has been slain by Estuk!
[Fri Jan 31 21:31:02 2014] Your faction standing with LeagueofAntonicanBards got better.
[Fri Jan 31 21:31:02 2014] Your faction standing with MayongMistmoore got better.
[Fri Jan 31 21:31:02 2014] Your faction standing with RingofScale could not possibly get any worse.
[Fri Jan 31 21:31:02 2014] Your faction standing with VenrilSathir got better.

[maximum]

Bi-yearly bump.

[maximum]

Bi-yearly bump.

[maximum]

Bump, still doesn't look right:

[Wed Mar 15 17:35:21 2017] You have slain a gnoll scout!
[Wed Mar 15 17:35:21 2017] Your faction standing with GuardsofQeynos got better.
[Wed Mar 15 17:35:21 2017] Your faction standing with JaggedpineTreefolk got better.
[Wed Mar 15 17:35:21 2017] Your faction standing with MerchantsofQeynos got better.
[Wed Mar 15 17:35:21 2017] Your faction standing with SabertoothsofBlackburrow could not possibly get any worse.
[Wed Mar 15 17:35:21 2017] Your faction standing with SilentFistClan got better.

Should be in this order:

Sabertooths of BB (native faction)
Guards
JP Treefolk
Merchants of Q
Silent Fist


...assuming all are 1 point of faction gain/loss. This was a mob in Qeynos Hills, if that helps.

[maximum]

Bumpus annualem

[Varren]

Sure would be handy to know native faction for monsters I kill!

[Rygar]

Are you certain the faction hits are just sorted by absolute value? There appear to be exceptions to this in Daldaen's thread:
https://www.project1999.com/forums/showthread.php?t=205626&highlight=faction

While most everything seem to follow the absolute value rule, here are some exceptions:
[Sat Aug 08 12:59:05 2015] You have slain Councilor Juliah Lockheart! - All Councilors share the same hit value
[Sat Aug 08 12:59:05 2015] Your faction standing with Coldain has been adjusted by -30.
[Sat Aug 08 12:59:05 2015] Your faction standing with Dain Frostreaver IV has been adjusted by -7.
[Sat Aug 08 12:59:05 2015] Your faction standing with Kromzek has been adjusted by 3.
[Sat Aug 08 12:59:05 2015] Your faction standing with Kromrif has been adjusted by 15.
[Sat Aug 08 12:59:28 2015] You have slain an Icewell Sentinel!
[Sat Aug 08 12:59:28 2015] Your faction standing with Coldain has been adjusted by -20.
[Sat Aug 08 12:59:28 2015] Your faction standing with Dain Frostreaver IV has been adjusted by -5.
[Sat Aug 08 12:59:28 2015] Your faction standing with Kromzek has been adjusted by 2.
[Sat Aug 08 12:59:28 2015] Your faction standing with Kromrif has been adjusted by 10.

Should note that earlier posts in his log seem to list the NPC's primary faction last, but these seem to list primary faction first.

I didn't see the Counciller hit on ZAM, but the Icewell Sentinel values are confirmed accurate and there is another post in the comments confirming the same order as Daldaen.

If I had to guess (purely guess without any research), my thought would be they would not want to give indicators back in the day to how large the faction hits were. I would think they would be sorted by the primary key in the database (like how items have Item IDs, perhaps factions have faction IDs).

I noticed that on Kunark dragons where the primary faction is listed, but then LeagueofAntonican Bards and MayongMistmoore are listed above VenrilSathir. Those values happen to be sorted in the correct value order, but I wonder if there are other cases where 'new content' hits are always listed before 'old content' hits. Are there also cases where Kromzek are always listed before Kromrif on secondary faction hits (assuming Kromzek was created first in the database, Kromrif after).

I'll look into this further later.

[maximum]

If a fix is implemented for absolute values, we're most of the way to Classic. My OP screenshots from Live (pre-2003) all show absolute value.

Later on, you can open a new bug post to address Dragons and special cases. Perhaps all of Velious is a special case.

[Rygar]

I only noticed a handful of screenshots that you posted, were there more elsewhere? I don't think that is a relevant sample size to base the fix off of.

I'll continue to look into this, but there are just too many cases of values not being in the 'absolute value' order.
http://everquest.allakhazam.com/db/npc.html?id=6472
http://everquest.allakhazam.com/db/npc.html?id=6092
http://everquest.allakhazam.com/db/npc.html?id=5866
http://everquest.allakhazam.com/db/npc.html?id=8539
http://everquest.allakhazam.com/db/npc.html?id=5398
http://everquest.allakhazam.com/db/npc.html?id=28381
http://everquest.allakhazam.com/db/npc.html?id=6681
http://everquest.allakhazam.com/db/npc.html?id=32799
http://everquest.allakhazam.com/db/npc.html?id=5384
http://everquest.allakhazam.com/db/npc.html?id=5390

These prove the 'sub-sort alphabetically if a tie occurs' is not correct either:
http://everquest.allakhazam.com/db/npc.html?id=5385
http://everquest.allakhazam.com/db/npc.html?id=5383


I am doubtful on Velious being a special case, but I will try and confirm that later by looking through Kunark / Classic content. Granted I'll be using the 'live values' shown on ZAM as a guide, but if any exceptions to the rules are verified by classic screenshots, that should show that absolute value sorting is not reliable.

I'm feeling a bit more confident in sorting by 'Faction ID', but I wasn't verifying that above with each link.

Part of me wonders if there was more beyond listing 'primary faction first', they certainly seem to list factions they are allied with 2nd most often (such as Coldain being primary, then Dain showing 2nd hit. Same if Kromrif is primary, Kromzek would often be next). Maybe it lists all factions the mobs will assist then other factions? Not sure if mobs assisting multiple factions is classic or not.

Will continue to look into this, I welcome any feedback or noted exceptions that break any proposed theory.

[Rygar]

Found some old world hits that come in funky ways...

Investigator Badge has some funky hits in no discernible sort order:
http://everquest.allakhazam.com/db/quest.html?quest=1271
[Tue Nov 10 09:32:12 2015] an investigator says 'You have done our city a great service and helped to bring several criminals to justice this day! Wear this Investigator's Badge with pride! Speak again with Vegalys Keldrane, he may have information about [advancing further] in rank.'
[Tue Nov 10 09:32:12 2015] Your faction standing with Antonius Bayle has been adjusted by 5.
[Tue Nov 10 09:32:12 2015] Your faction standing with Guards of Qeynos has been adjusted by 5.
[Tue Nov 10 09:32:12 2015] Your faction standing with Ring of Scale has been adjusted by -2.
[Tue Nov 10 09:32:12 2015] Your faction standing with Kane Bayle has been adjusted by -5.
[Tue Nov 10 09:32:12 2015] Your faction standing with Merchants of Qeynos has been adjusted by 5.
[Tue Nov 10 09:32:13 2015] You gain party experience!!

http://everquest.allakhazam.com/db/quest.html?quest=1279
[Fri Dec 29 13:35:44 2017] Velarte Selire says, 'You did it! You have proven you have the intelligence required and you may wear this Researcher's Badge with pride! Thank you for returning the jars.'
[Fri Dec 29 13:35:44 2017] Your faction standing with Priests of Life has been adjusted by 5.
[Fri Dec 29 13:35:44 2017] Your faction standing with Knights of Thunder has been adjusted by 1.
[Fri Dec 29 13:35:44 2017] Your faction standing with Guards of Qeynos has been adjusted by 2.
[Fri Dec 29 13:35:44 2017] Your faction standing with Bloodsabers has been adjusted by -1.
[Fri Dec 29 13:35:44 2017] Your faction standing with Antonius Bayle has been adjusted by 1.
[Fri Dec 29 13:35:44 2017] You gain experience (with a bonus)!

http://everquest.allakhazam.com/db/quest.html?quest=1288
[Fri Dec 29 14:00:48 2017] Your faction standing with Antonius Bayle has been adjusted by 5.
[Fri Dec 29 14:00:48 2017] Your faction standing with Guards of Qeynos has been adjusted by 5.
[Fri Dec 29 14:00:48 2017] Your faction standing with Ring of Scale has been adjusted by -2.
[Fri Dec 29 14:00:48 2017] Your faction standing with Kane Bayle has been adjusted by -5.
[Fri Dec 29 14:00:48 2017] Your faction standing with Merchants of Qeynos has been adjusted by 5.

Rabid Grizzlies quest as well:
http://everquest.allakhazam.com/db/quest.html?quest=557
[Wed Feb 25 20:19:46 2015] Your faction standing with Priests of Life has been adjusted by 20.
[Wed Feb 25 20:19:46 2015] Your faction standing with Knights of Thunder has been adjusted by 6.
[Wed Feb 25 20:19:46 2015] Your faction standing with Guards of Qeynos has been adjusted by 10.
[Wed Feb 25 20:19:46 2015] Your faction standing with Bloodsabers has been adjusted by -5.
[Wed Feb 25 20:19:46 2015] Your faction standing with Antonius Bayle has been adjusted by 3.
[Wed Feb 25 20:19:46 2015] You gain experience!!

Soulfire quest is all over as well:
http://everquest.allakhazam.com/db/quest.html?quest=362
Wed Oct 05 13:14:37 2016] Your faction standing with Mayong Mistmoore has been adjusted by -300.
[Wed Oct 05 13:14:37 2016] Your faction standing with King Tearis Thex has been adjusted by 75.
[Wed Oct 05 13:14:37 2016] Your faction standing with Agents of Mistmoore has been adjusted by -300.
[Wed Oct 05 13:14:37 2016] Your faction standing with League of Antonican Bards has been adjusted by 75.
[Wed Oct 05 13:14:37 2016] Your faction standing with Ring of Scale has been adjusted by 15.
Give sealed note to Brother Hayle
[Fri Apr 01 10:56:29 2016] Your faction standing with Priests of Life has been adjusted by 10.
[Fri Apr 01 10:56:29 2016] Your faction standing with Knights of Thunder has been adjusted by 3.
[Fri Apr 01 10:56:29 2016] Your faction standing with Guards of Qeynos has been adjusted by 5.
[Fri Apr 01 10:56:29 2016] Your faction standing with Bloodsabers has been adjusted by -2.
[Fri Apr 01 10:56:29 2016] Your faction standing with Antonius Bayle has been adjusted by 1.
Give Testimony of Truth to Valeron Dushire
[Fri Apr 01 19:03:32 2016] Your faction standing with Knights of Truth has been adjusted by 100.
[Fri Apr 01 19:03:32 2016] Your faction standing with Dismal Rage has been adjusted by -15.
[Fri Apr 01 19:03:32 2016] Your faction standing with The Freeport Militia has been adjusted by -15.
[Fri Apr 01 19:03:32 2016] Your faction standing with Priests of Marr has been adjusted by 20.
[Fri Apr 01 19:03:32 2016] Your faction standing with Steel Warriors has been adjusted by 10.

Some random kills from old world, in case quests were different:
http://everquest.allakhazam.com/db/npc.html?id=2983
[Sat Mar 07 15:03:11 2015] Your faction standing with Guards of Qeynos has been adjusted by -150.
[Sat Mar 07 15:03:11 2015] Your faction standing with Antonius Bayle has been adjusted by -22.
[Sat Mar 07 15:03:11 2015] Your faction standing with Corrupt Qeynos Guards has been adjusted by 22.
[Sat Mar 07 15:03:11 2015] Your faction standing with Circle Of Unseen Hands has been adjusted by 37.
[Sat Mar 07 15:03:11 2015] Your faction standing with Merchants of Qeynos has been adjusted by -15.
[Sat Mar 07 15:03:11 2015] Guard Philbin's corpse says 'My comrades will avenge my death.'

http://everquest.allakhazam.com/db/npc.html?id=2757
[Sun May 15 09:55:55 2016] Halleb hit Guard Wenbie for 89 points of non-melee damage.
[Sun May 15 09:55:55 2016] Your faction standing with Guards of Qeynos has been adjusted by -60.
[Sun May 15 09:55:55 2016] Your faction standing with Antonius Bayle has been adjusted by -9.
[Sun May 15 09:55:55 2016] Your faction standing with Corrupt Qeynos Guards has been adjusted by 9.
[Sun May 15 09:55:55 2016] Your faction standing with Circle Of Unseen Hands has been adjusted by 15.
[Sun May 15 09:55:55 2016] Your faction standing with Merchants of Qeynos has been adjusted by -6.

This one is Mooto, interesting that no Bixie faction given, didn't Aalderon famously farm this guy for months to become max ally with Bixies? should that be possible?
http://everquest.allakhazam.com/db/npc.html?id=2107
[Sun Mar 12 13:52:18 2017] Your faction standing with Clan Runnyeye has been adjusted by -50.
[Sun Mar 12 13:52:18 2017] Your faction standing with Storm Reapers has been adjusted by 2.
[Sun Mar 12 13:52:18 2017] Your faction standing with Guardians of the Vale has been adjusted by 5.
[Sun Mar 12 13:52:18 2017] Your faction standing with Storm Guard has been adjusted by 2.
[Sun Mar 12 13:52:18 2017] Your faction standing with King Xorbb has been adjusted by 5.



Don't get me wrong, there are indeed cases where sorting by faction size are happening, but it is by no means universal, so I'm just posting things that show otherwise. So I don't think the absolute value sort order should be implemented, it would only serve to give hints about faction values.

I'll try and map out the order everything appears and see if there is any kind of connection. Will probably take a long time.

[Rygar]

Have been having some relevant success on establishing some kind of chronological order in the database. However, there are a handful of exceptions that cropped up which tell me that isn't the sole method, perhaps factions were stored in different tables that could be joined or queried in different orders and affect the sort.

Thus far it seems like the Primary Faction (first faction hit shown) determines the sort order. For instance, I may see CircleofUnseenHands hit above AntoniousBayle for one primary faction, but on a different primary faction the display order is reversed. Have seen a wide range of values on those faction hits and feel it is reasonable to conclude the value of the hit has nothing to do with the sort order.

I'm trying to see if the text value of the faction can convert to a number and find some correlation, but I'm starting to go a bit too Beautiful Mind on this.

If I had some insight into how the faction tables and faction hits are setup then maybe I can make more sense of it.

For now, I'm just going to try and log the display order for each primary faction in Classic-Velious. If a dev wants to throw some 'fill in the blanks' code for how you want each primary faction to display I can post that when complete, and hopefully can alleviate some burden on implementing (a lot of faction to dig through, probably a 2-3 month project when all is said and done).

[Caiu]

Feel like this is a client limitation? Don't get the sense that devs would leave it untouched without a serious roadblock.

[maximum]

So I don't think the absolute value sort order should be implemented, it would only serve to give hints about faction values.

I would argue that giving hints about faction values is Totally Classic. I understand there are concerns about feeding Faction Lords/farmers, but this change should be made if it serves The Mission.

I can dig up more screenshots from 2001-2 if it is required, but I don't see a reason for an orgy of evidence.

[Rygar]

I would argue that giving hints about faction values is Totally Classic. I understand there are concerns about feeding Faction Lords/farmers, but this change should be made if it serves The Mission.

I can dig up more screenshots from 2001-2 if it is required, but I don't see a reason for an orgy of evidence.

Please help me understand why you want your proposed sort method implemented. I guess I don't understand why it should be if tons of evidence is found that shows it to be unreliable? To be clear, I agree that some quests / kills show the values in your proposed sort order, but you can't really ignore the cases that don't fit that, else it is just cherry picking the data.

If you found the same primary faction hit sorted in different orders I would begin to consider it again, but every single quest I've located has the order the same regardless of values. So same faction hits, but some may be sorted as 5, -1, 2, 1, 2 and a different quest is sorted the same but shows hits as 10, 3, 1, 1, 1.

I am indeed trying to keep it classic, if your method proved true then I would say go on and feed the Faction Lords/farmers.

[isidian]

I've spent a bit of time looking into this also.

If the numerical sort hypothesis true, then Primordial Malice would always appear first, not last, as it always does.

Also, you give the example of a MayongMistmoore hit, but prior to Kunark, the AgentsofMistmoore hit was replaced with QueenCristanosThex -- in the exact same position, with everything else unchanged. Proof:
http://tinypic.com/view.php?pic=2lsuf9&s=6#.WrBMPujwY2z
http://www.silverblades-suitcase.com/eq/mm_aoe.jpg

The hits clearly don't come in alphabetical order either, so it makes sense that one might argue for a "hidden ID#" hypothesis. But then this would be defeated by the reverse orders of StormGuard and EmeraldWarriors in the CrushboneOrc table versus the InhabitantsOfFirionaVie table. Another counterexample would be the reverse order of the Corrupt/Regular Qeynos guards in the SteelWarriors table versus the CircleOfUnseenHands table.

It seems much more likely that these tables are just individualized according to a list that belongs to the parent faction, and that the lists were populated by the developers manually. Almost all factions list as their second entry the faction most strongly aligned or most diametrically opposed: e.g. KaranaBandits lists KaranaResidents second, KazonStormhammer lists StormGuard second, CorruptQeynosGuards lists GuardsOfQeynos second, etc.

I would, however, be interested in any evidence that can support a different theory that has not been debunked by the above evidence.

[Rygar]

It seems much more likely that these tables are just individualized according to a list that belongs to the parent faction, and that the lists were populated by the developers manually. Almost all factions list as their second entry the faction most strongly aligned or most diametrically opposed: e.g. KaranaBandits lists KaranaResidents second, KazonStormhammer lists StormGuard second, CorruptQeynosGuards lists GuardsOfQeynos second, etc.

I'm definitely leaning towards this direction, notice a lot of allies / enemies in the same position, but there are plenty of examples where this is not a hard rule. I wonder if this was just a guideline to follow but mistakes were made when creating the faction tables.