Green guilds by the numbers

[Videri]

Originally Posted by edmazur [You must be logged in to view images. Log in or Register.]

I don't know how useful this will be, but it was the right combination of useless + fun for me to put together. This is a little messy and I possibly did the parsing wrong, but if this does what I mean it to, for every guild name I've seen since launch, it should show the time at which I first observed it. This might help fill in some blanks for dead guilds?

$ IFS=$'\n'; for entry in $(cat /opt/everquest/EverQuest\ Project\ 1999/Logs/eqlog_Stanvern_P1999Green.txt | sed -n 's/\[.\{3\} \(.\{6\}\) \(.\{8\}\) \(.\{4\}\)\] \[.\+\] .\+ \(<.\+>\).*/\1 \2 \3 \4/p'); do date=$(echo $entry | cut -d ' ' -f 1-4 | xargs -I{} date --date={} "+%Y-%m-%d %H:%M:%S"); guild=$(echo $entry | cut -d ' ' -f 5-); echo $date $guild; done | sort -u -k3 | sort

 

2019-10-25 23:45:26 <Dial a Port>
2019-10-26 03:39:46 <Auld Lang Syne>
2019-10-26 11:29:36 <Europa>
2019-10-26 11:29:36 <Hearts of Faydwer>
2019-10-26 11:29:36 <Kingdom>
2019-10-26 11:40:26 <Fatal Train Engineers>
2019-10-26 12:07:33 <Castle>
2019-10-26 13:36:36 <Unknown Guild>
2019-10-26 14:15:43 <Black Lotus>
2019-10-26 14:20:58 <Level Up>
2019-10-26 18:53:01 <Bloomin Onions>
2019-10-26 20:15:48 <Anonymous>
2019-10-26 20:15:48 <Port Authority>
2019-10-26 20:15:48 <Sacrifice>
2019-10-26 20:15:48 <Smooth Operators>
2019-10-26 20:17:54 <Ravel>
2019-10-26 20:17:54 <Sanctuary>
2019-10-26 20:18:08 <Dwarven Adventure Company>
2019-10-26 20:41:14 <Hispartans>
2019-10-26 22:19:15 <Fatal>
2019-10-26 22:19:15 <Venerate>
2019-10-26 22:36:30 <The Long Patrol>
2019-10-27 01:29:36 <Dial a Dad>
2019-10-27 02:30:31 <The Lost Age>
2019-10-27 03:32:39 <Dark Men of Odus>
2019-10-27 15:25:07 <A Gnoll Predator>
2019-10-27 15:25:07 <Viridian>
2019-10-27 20:56:50 <Evergreen>
2019-10-27 20:56:50 <Saga of Lucimia>
2019-10-27 20:56:50 <Seal Team>
2019-10-27 21:32:40 <Dial a Daniel>
2019-10-27 23:05:53 <Taken ll>
2019-10-27 23:47:09 <Fires of Heaven>
2019-10-27 23:54:47 <Equilibrium>
2019-10-28 02:12:41 <Ova Nemas>
2019-10-28 03:01:32 <Freedom Guard>
2019-10-28 03:02:30 <Detached>
2019-10-28 03:15:28 <Draco>
2019-10-28 05:13:23 <No Time To Rez>
2019-10-28 11:57:12 <Green Beans>
2019-10-28 11:59:55 <Cats>
2019-10-28 20:04:41 <Avid>
2019-10-28 20:14:24 <Department of Fun>
2019-10-28 22:47:37 <Court of Owls>
2019-10-28 22:47:37 <Rebirth>
2019-10-29 00:17:43 <Merchant>
2019-10-29 00:17:43 <Unity of Souls>
2019-10-29 22:25:37 <The Defiant>
2019-10-30 02:43:18 <Gypsy Lute>
2019-10-30 02:43:18 <Loyalty>
2019-10-30 02:46:55 <Asgard>
2019-10-31 07:23:07 <Rocinante>
2019-11-01 01:51:39 <Aussie Crew>
2019-11-01 01:51:39 <The Friend Force>
2019-11-07 15:57:18 <Solitude>
2019-11-07 22:03:17 <Lineage>
2019-11-07 22:10:36 <Asylum>
2019-11-07 22:11:44 <Archers Vow>
2019-11-07 22:11:44 <Foggy Goblins>
2019-11-07 22:11:44 <United As One>
2019-11-11 02:36:05 <Gang Green>
2019-11-11 02:49:27 <Loot Horse>
2019-11-24 18:34:28 <Union of Power>
2019-11-25 12:10:38 <Merc>
2019-11-25 12:10:38 <Smitty Bacall Gang>
2019-11-25 23:58:00 <Leaf Quartet>
2019-12-01 03:28:42 <Ironborn>
2019-12-01 05:56:44 <Deez Games>
2019-12-01 16:49:06 <Dominion>
2019-12-03 07:36:42 <Saryrn's Song>
2019-12-04 15:39:27 <Pantos de la Grantos>
2019-12-05 10:26:15 <Pixie Dust Cartel>
2019-12-05 14:24:09 <Grumpy Old Gnomes>
2019-12-05 20:59:48 <Origine>
2019-12-06 00:47:00 <Dragonriders>
2019-12-15 21:38:05 <Illuminatis>
2019-12-18 22:54:53 <HR>
2019-12-21 00:33:58 <Adventure Call>
2020-01-18 22:34:15 <Fellowship of the Ding>
2020-01-19 05:38:04 <Akatsuki>
2020-01-19 10:04:33 <Dub Syndicate>
2020-01-19 10:32:21 <Explicit>
2020-01-19 23:09:54 <Keepin it Teal>
2020-01-19 23:16:46 <Calamitous Intent>
2020-01-19 23:20:36 <Halcyon>
2020-01-19 23:20:36 <Venom>
2020-01-20 00:16:00 <Entropy>
2020-02-01 02:35:33 <Chilling Gaze>
2020-02-01 02:35:33 <Mastermind>
2020-02-01 13:52:37 <Friends Unanimous>
2020-02-01 13:52:37 <Kittens Who Say Meow>
2020-02-08 21:10:53 <Catalina Wine Mixer>
2020-02-22 13:09:38 <Clan Moongleam>
2020-02-28 20:40:27 <Moonlight Crusaders>
2020-02-28 20:51:02 <Dynasty>
2020-02-28 22:37:21 <Fallen Leaves>
2020-03-01 12:44:00 <Champions of Norrath>
2020-03-05 17:15:25 <The JumJum Hooligans>
2020-03-07 21:42:18 <Sacred Phoenix>
2020-03-14 14:45:13 <Puppets of Death>
2020-03-14 14:54:37 <Guildless>
2020-03-14 14:54:37 <The Outlaws>
2020-03-14 18:27:48 <Deus>
2020-03-14 20:02:47 <Tanelorn>
2020-03-15 20:18:39 <De Ordine ebria>
2020-03-17 16:10:25 <Rod Squad>
2020-03-19 18:12:04 <Trade Federation>
2020-03-20 12:24:08 <Odin>
2020-03-22 00:04:04 <Bashin Ordur>
2020-03-26 00:29:08 <Eternal Soverign>
2020-03-30 17:30:13 <Boop>
2020-04-05 22:50:28 <Incognito>
2020-04-25 03:25:24 <Minotaur Axe Gang>
2020-04-25 05:37:56 <WuPow Clan>
2020-04-25 06:58:26 <Twisted Legends>
2020-04-25 12:34:15 <Clockwork Watch>
2020-04-25 12:59:31 <Sense Heading>
2020-04-26 00:44:12 <Notekeepers>
2020-04-26 05:14:02 <The Galt Heretics>
2020-04-26 16:16:09 <Imaginary Friends>
2020-04-26 19:13:32 <Euro Crew>
2020-04-26 22:11:02 <Fury of Faith>
2020-04-26 22:32:27 <Lowry Parcade Brigade>
2020-04-26 22:33:14 <Corpse Draggers>
2020-04-27 04:29:44 <Sarnaks & Beers>
2020-04-28 16:51:49 <The Alpha Betas>
2020-05-05 00:35:44 <LOST>
2020-05-05 17:18:13 <Metal Guard>
2020-05-05 17:52:15 <Solo Self Found>
2020-05-07 00:09:03 <The A-Team>
2020-05-09 00:46:21 <The Wolves of the North>
2020-05-09 17:13:28 <Legends Never Die>
2020-05-10 18:37:18 <Doz>
2020-05-12 22:00:48 <Bind Affinity>
2020-05-17 16:04:49 <Scarab>
2020-05-21 17:20:32 <Gnomeland Security>
2020-05-23 03:41:25 <Prodigal Sons>
2020-05-23 19:07:44 <Free Market>
2020-05-25 04:04:56 <Nostalgia>
2020-05-31 19:08:21 <Highly Unlikely Heroes>
2020-06-03 16:12:08 <Malarkey>
2020-07-02 00:53:21 <Reconstructed>
2020-07-19 23:16:53 <Peacebringers>
2020-08-08 13:24:07 <Karens of Karana>
2020-08-19 10:06:10 <Dial Transport Service>
2020-08-22 20:13:08 <Mental Militia>
2020-09-05 12:23:33 <Gathered Might>
2020-09-05 12:56:45 <Euroquest>
2020-09-05 23:07:02 <Legends of Kesmai>
2020-09-05 23:07:02 <Mad Company>
2020-09-06 06:03:25 <Norrathian Inquisition>
2020-09-06 07:11:11 <All Circuits Are Busy>
2020-09-13 23:29:54 <Human Retribution>
2020-09-19 23:54:17 <Baskin Vobobns>
2020-09-20 14:07:01 <Cult of the Red Bull>

That is amazing. Very clever. Let's all poke around in-game and see if we can find any of the missing ones.

Also, I just remembered there is a guild called <Sarnaks and Beers> that we haven't added to the list.

[Nuggie]

highest i found was guild156 <Cult of the Red Bull>
155<Human Retribution>
154<Baskin Vobobns>
153 <Legends of Kesmai>
150 <Mental Militia>
149 <Peacebringers>
148 <Red to Me>
145 <Norrathian Inquisition>
140 <Sodden Seakings>
136 <Nostalgia>
134 <Gathered Might>
132 <Gnomeland Security>
123 < Bind Affinity>
120 <Legends Never Die>
115 <Sacred Pheonix>
110 <Dynasty>
105 <Chilling Gaze>
101 <Fellowship of the Ding>
073 <Lineage>
056 <Asgard>
I thought I'd heard <Bears of Oboo> (GM guild) is 001

[Tethler]

Winner of best guild name goes to...

Originally Posted by Nuggie [You must be logged in to view images. Log in or Register.]

154<Baskin Vobobns>

Also, is there a command to check your own guild number? Or just need to go down to list of numbers till you find it?

[Plaguu~]

guild9 = Friends Unanimous
guild11 = Fury of Faith
guild28 = Hispartans
guild36 = Entropy
guild54 = Ironborn
guild56 = Asgard
guild71 = Odin
guild88 = Doz
guild91 = Illuminatis
guild105 = Chilling Gaze
guild107 = Guildless
guild109 = Trade Federation
guild110 = Dynasty
guild113 = Solo Self Found
guild115 = Sacred Phoenix
guild116 = Metal Guard
guild118 = Notekeepers
guild119 = Twisted Legends
guild121 = The Alpha Betas
guild123 = Bind Affinity
guild124 = Euro Crew
guild125 = Imaginary Friends
guild126 = Corpse Draggers
guild128 = The Galt Heretics
guild129 = Clockwork Watch

[Nuggie]

Updated list.

I thought I'd heard <Bears of Oboo> (GM guild) is 001
Guild1
Guild2 <Dial a Port>
Guild3 <Auld Lang Syne>
Guild4 <Dark Men of Odus>
Guild5 <Venerate>
Guild6 <Sanctuary>
Guild7 ?
Guild8 <Kingdom>
Guild9 Friends Unanimous
Guild10 <Castle>
Guild11 Fury of Faith
Guild12
Guild13
Guild14
Guild15
Guild16
Guild17 <Dial a Daniel>
Guild18 <House of Aegis>
Guild19
Guild20
Guild21
Guild22 <Equilibrium>
Guild23 <Black Lotus>
Guild24
Guild25 <Level Up>
Guild26 <Bloomin Onions>
Guild27
Guild28 Hispartans
Guild29 <Ravel>

Guild30
Guild31
Guild32
Guild33
Guild34
Guild35
Guild36 Entropy
Guild37
Guild38
Guild39

Guild40
Guild41
Guild42
Guild43
Guild44
Guild45 <Seal Team>
Guild46
Guild47
Guild48
Guild49 <Fires of Heaven>

Guild50
Guild51
Guild52 <The A-Team>
Guild53
Guild54 Ironborn
Guild55
Guild56 Asgard
Guild57
Guild58
Guild59

Guild60
Guild61
Guild62
Guild63
Guild64
Guild65
Guild66
Guild67 <Aussie Crew>
Guild68 <Akatsuki>
Guild69

Guild70
Guild71 Odin
Guild72
Guild73 <Lineage>
Guild74
Guild75
Guild76
Guild77 <Aussie Crew>
Guild78 <Akatsuki>
Guild79


Guild80
Guild81
Guild82
Guild83
Guild84
Guild85
Guild86
Guild87
Guild88 Doz
Guild89

Guild90
Guild91 Illuminatis
Guild92 <Illuminatis>
Guild93
Guild94
Guild95
Guild96
Guild97
Guild98
Guild99
Guild100
Guild101 <Fellowship of the Ding>
Guild102
Guild103
Guild104
Guild105 Chilling Gaze
guild107 = Guildless
guild109 = Trade Federation
guild110 = Dynasty
guild113 = Solo Self Found
guild115 = Sacred Phoenix
guild116 = Metal Guard
guild118 = Notekeepers
guild119 = Twisted Legends
120 <Legends Never Die>
guild121 = The Alpha Betas
guild123 = Bind Affinity
guild124 = Euro Crew
guild125 = Imaginary Friends
guild126 = Corpse Draggers
guild128 = The Galt Heretics
guild129 = Clockwork Watch
guild132 <Gnomeland Security>
guild134 <Gathered Might>
guild136 <Nostalgia>
guild140 <Sodden Seakings>
guild145 <Norrathian Inquisition>
guild148 <Red to Me>
guild149 <Peacebringers>
guild150 <Mental Militia>
guild153 <Legends of Kesmai>
guild154<Baskin Vobobns>
guild155<Human Retribution>

[Videri]

Wow, thanks for the contributions and corrections, everyone! Yeah, Nuggie, I figure we can just copy+paste it with updates until it's added to a Wiki page. And if it turns out there's a much easier way to do this, we'll all get a hearty kek.

Guild1 possibly <Bears of Oboo> (GM guild)?
Guild2 <Dial a Port>
Guild3 <Auld Lang Syne>
Guild4 <Dark Men of Odus>
Guild5 <Venerate>
Guild6 <Sanctuary>
Guild7
Guild8 <Kingdom>
Guild9 <Friends Unanimous>

Guild10 <Castle>
Guild11 <Fury of Faith>
Guild12
Guild13
Guild14
Guild15
Guild16
Guild17 <Dial a Daniel>
Guild18 <House of Aegis>
Guild19

Guild20
Guild21
Guild22 <Equilibrium>
Guild23 <Black Lotus>
Guild24
Guild25 <Level Up>
Guild26 <Bloomin Onions>
Guild27
Guild28 <Hispartans>
Guild29 <Ravel>

Guild30
Guild31
Guild32
Guild33
Guild34
Guild35
Guild36 Entropy
Guild37
Guild38
Guild39

Guild40
Guild41
Guild42
Guild43
Guild44
Guild45 <Seal Team>
Guild46
Guild47
Guild48
Guild49 <Fires of Heaven>

Guild50
Guild51
Guild52 <The A-Team>
Guild53
Guild54 <Ironborn>
Guild55
Guild56 <Asgard>
Guild57
Guild58
Guild59

Guild60
Guild61
Guild62
Guild63
Guild64
Guild65
Guild66
Guild67 <Aussie Crew>
Guild68 <Akatsuki>
Guild69

Guild70
Guild71 <Odin>
Guild72
Guild73 <Lineage>
Guild74
Guild75
Guild76
Guild77
Guild78
Guild79

Guild80
Guild81
Guild82
Guild83
Guild84
Guild85
Guild86
Guild87
Guild88 <Doz>
Guild89

Guild90
Guild91 <Illuminatis>
Guild92 <Illuminatis> uh-oh, we gotta check this one
Guild93
Guild94
Guild95
Guild96
Guild97
Guild98
Guild99

Guild100
Guild101 <Fellowship of the Ding>
Guild102
Guild103
Guild104
Guild105 <Chilling Gaze>
Guild106
Guild107 <Guildless>
Guild108
Guild109 <Trade Federation>

Guild110 <Dynasty>
Guild111
Guild112
Guild113 <Solo Self Found>
Guild114
Guild115 <Sacred Phoenix>
Guild116 <Metal Guard>
Guild118 <Notekeepers>
Guild119 <Twisted Legends>

Guild120 <Legends Never Die>
Guild121 <The Alpha Betas>
Guild123 <Bind Affinity>
Guild124 <Euro Crew>
Guild125 <Imaginary Friends>
Guild126 <Corpse Draggers>
Guild127
Guild128 <The Galt Heretics>
Guild129 <Clockwork Watch>

Guild130
Guild131
Guild132 <Gnomeland Security>
Guild133
Guild134 <Gathered Might>
Guild135
Guild136 <Nostalgia>
Guild137
Guild138
Guild139

Guild140 <Sodden Seakings>
Guild141
Guild142
Guild143
Guild144
Guild145 <Norrathian Inquisition>
Guild146
Guild147
Guild148 <Red to Me>
Guild149 <Peacebringers>

Guild150 <Mental Militia>
Guild151
Guild152
Guild153 <Legends of Kesmai>
Guild154 <Baskin Vobobns>
Guild155 <Human Retribution>
Guild156
Guild157
Guild158
Guild159

[Nuggie]

Originally Posted by Videri [You must be logged in to view images. Log in or Register.]

And if it turns out there's a much easier way to do this, we'll all get a hearty kek.

Minden or galach could do a 2 minute database query and copy/paste us a list. but then i/you/we-all wouldn't waste time doing it and spend the time causing havoc an mayhem in game.

[Noselacri]

Can Kunark come out already? People are going fucking mental around here.

[Videri]

Originally Posted by Noselacri [You must be logged in to view images. Log in or Register.]

Can Kunark come out already? People are going fucking mental around here.

Hah! Naw, I was already like this.

[Coridan]

I'm wondering if some of the blanks are disbanded guilds? Like <Euro Crew>, <The Lost Age>, <Reconstructed> etc?