Echo Of Chardok

Discussion in 'Time Locked Progression Servers' started by Clonkers, Jun 20, 2018.

Thread Status:
Not open for further replies.
  1. Maze Elder


    Hmm, No.
    Anyone with SQL knowledge worth a damn, will always run an interpreter or a whatif.
    We're not talking about bulk changes.

    We're talking about a removal of flagged out of era mobs, which takes 30s to clear up.
    I need to remove the entry "the_fabled_prince_selrach_Di`Zok"


    EverQuest's database is miniscule in comparison to databases I run "UPDATE" queries on daily.

    Code:
    MariaDB [nlair]> select name, id from npc_types WHERE id > 103000 and id < 104000;
    +-----------------------------------+--------+
    | name                              | id    |
    +-----------------------------------+--------+
    | a_Tortured_Iksar_Miner            | 103001 |
    | a_Chokidai_Rootdigger            | 103002 |
    | a_Chokidai_Herbsniffer            | 103003 |
    | an_Apprentice_Herbalist          | 103004 |
    | a_Veteran_Underboss              | 103005 |
    | a_Chokidai_Terror                | 103006 |
    | a_Sarnak_pitboss                  | 103007 |
    | a_Wizened_Herb_Collector          | 103008 |
    | a_Dizok_Herbalist                | 103009 |
    | a_Sarnak_Foreman                  | 103010 |
    | a_Scarred_Overseer                | 103011 |
    | a_Sarnak_Herb_Collector          | 103012 |
    | a_Sarnak_Slavedriver              | 103013 |
    | a_Chokidai_Mangler                | 103014 |
    | a_Chokidai_Bloodhound            | 103015 |
    | a_Sarnak_Overseer                | 103016 |
    | a_Di`zok_Captain                  | 103017 |
    | a_Reanimated_Conscript            | 103018 |
    | a_Di`zok_Partisan                | 103019 |
    | a_Sarnak_Slavemaster              | 103020 |
    | a_Di`zok_Conscript                | 103021 |
    | a_Chokidai_Growler                | 103022 |
    | a_Di`zok_Invoker                  | 103023 |
    | a_Chokidai_Tearer                | 103024 |
    | a_Shai`din_Nightfear              | 103025 |
    | a_Di`zok_Channeler                | 103026 |
    | Herald_Telcha                    | 103027 |
    | a_Veteran_Drillmaster            | 103028 |
    | a_Di`zok_Dragoon                  | 103029 |
    | a_Shai`din_Soultrapper            | 103030 |
    | a_Shai`din_Partisan              | 103031 |
    | a_Chokidai_Whelp                  | 103032 |
    | a_Di`zok_Recruit                  | 103033 |
    | a_Reanimated_Partisan            | 103034 |
    | a_Chokidai_Sniffer                | 103035 |
    | a_Di`zok_Underling                | 103036 |
    | an_off_duty_Pitboss              | 103037 |
    | an_off_duty_Researcher            | 103038 |
    | a_Di`zok_Soldier                  | 103039 |
    | #Tani_Cogswin                    | 103040 |
    | an_escaped_slave                  | 103041 |
    | a_muddy_slave                    | 103042 |
    | a_Chokidai_Bonesnapper            | 103043 |
    | a_Treasury_Guard                  | 103044 |
    | a_Shai`din_Bonecollector          | 103045 |
    | a_Di`zok_Evoker                  | 103046 |
    | a_Chokidai_Wardog                | 103047 |
    | a_Di`zok_Legionnaire              | 103048 |
    | a_Shai`din_Follower              | 103049 |
    | a_Shai`din_Hemlock                | 103050 |
    | Observer_Aq`touz                  | 103051 |
    | a_Reanimated_Dragoon              | 103052 |
    | Ancient_Guardian                  | 103053 |
    | a_Chokidai_Fleshripper            | 103054 |
    | Queen_Velazul_Di`zok              | 103055 |
    | Overking_Bathezid                | 103056 |
    | an_Imperial_Courier              | 103057 |
    | a_Di`zok_Jannisary                | 103058 |
    | a_Di`zok_Warlord                  | 103059 |
    | a_Shai`din_Bloodomen              | 103060 |
    | a_Di`zok_Guardian                | 103061 |
    | a_Lesser_Guardian                | 103062 |
    | Di`zok_royal_guard                | 103063 |
    | sorcerer_of_Di`zok                | 103064 |
    | judicator_of_Di`zok              | 103065 |
    | sorcerer_of_Di`zok                | 103066 |
    | sorcerer_of_Di`zok                | 103067 |
    | judicator_of_Di`zok              | 103068 |
    | Di`zok_royal_guard                | 103069 |
    | sorcerer_of_Di`zok                | 103070 |
    | Di`zok_royal_guard                | 103071 |
    | judicator_of_Di`zok              | 103072 |
    | an_apprentice_lorekeeper          | 103073 |
    | a_Royal_Library_Guard            | 103074 |
    | a_Dizok_Researcher                | 103075 |
    | a_Shai`din_Savant                | 103076 |
    | a_Di`zok_Librarian                | 103077 |
    | a_Di`zok_Sage                    | 103078 |
    | an_Imperial_Defender              | 103079 |
    | Prince_Selrach_Di`zok            | 103080 |
    | an_Imperial_Advisor              | 103081 |
    | judicator_of_Di`zok              | 103082 |
    | a_chardoki_golem                  | 103083 |
    | a_Sarnak_myrmidon                | 103084 |
    | Councilman_Buzdarloan_III        | 103085 |
    | a_chardoki_golem                  | 103086 |
    | Councilman_Ysabrial_III          | 103087 |
    | Councilman_Laanari_III            | 103088 |
    | an_imperial_construct            | 103089 |
    | Di`zok_elite_guard                | 103090 |
    | an_imperial_construct            | 103091 |
    | an_Imperial_Gravemaster          | 103092 |
    | a_Reanimated_Berserker            | 103093 |
    | a_Di`zok_Cryptmaster              | 103094 |
    | a_Di`zok_Gravebinder              | 103095 |
    | an_escaped_slave                  | 103096 |
    | an_escaped_slave                  | 103097 |
    | a_Chokidai_Lasher                | 103098 |
    | Vault_Master_Shu`zo              | 103099 |
    | Haggle_Baron_Dry`dn              | 103100 |
    | a_soggy_slave                    | 103101 |
    | an_unhappy_slave                  | 103102 |
    | a_skinny_slave                    | 103103 |
    | a_tired_slave                    | 103104 |
    | a_grumpy_slave                    | 103105 |
    | a_droopy_slave                    | 103106 |
    | an_apprentice_kennelmaster        | 103107 |
    | a_Chokidai_Mauler                | 103108 |
    | a_Chokidai_Pitfighter            | 103109 |
    | an_Imperial_Wardog                | 103110 |
    | a_Sarnak_Physician                | 103111 |
    | a_Sarnak_Dog_Handler              | 103112 |
    | a_Sarnak_Manager                  | 103113 |
    | an_enraged_slave                  | 103114 |
    | a_Slaveblock_Guard                | 103115 |
    | a_Block_Foreman                  | 103116 |
    | an_off_duty_Accountant            | 103117 |
    | an_off_duty_Scribe                | 103118 |
    | an_off_duty_Slavemaster          | 103119 |
    | an_off_duty_Pitboss              | 103120 |
    | an_off_duty_Overseer              | 103121 |
    | a_gruff_slave                    | 103122 |
    | a_dirty_slave                    | 103123 |
    | a_sad_slave                      | 103124 |
    | Niblek                            | 103125 |
    | Councilman_Gwalnax_III            | 103126 |
    | Councilman_Caroeth_III            | 103127 |
    | Councilman_Neyir_III              | 103128 |
    | an_Ancient_Guardian              | 103129 |
    | a_Greater_Guardian                | 103130 |
    | an_Imperial_Inspector            | 103131 |
    | a_Di`zok_Myrmidon                | 103132 |
    | an_Imperial_Interrogator          | 103133 |
    | an_Imperial_Officer              | 103134 |
    | an_Enslaved_Iksar_Miner          | 103135 |
    | an_iksar_collaborator            | 103136 |
    | a_Sarnak_Underboss                | 103137 |
    | an_accused_traitor                | 103138 |
    | Grand_Herbalist_Mak`ha            | 103139 |
    | a_Security_Advisor                | 103140 |
    | a_crystal_shard_golem            | 103141 |
    | a_Dizok_Observer                  | 103142 |
    | Korucust`s_Courier                | 103143 |
    | a_Reanimated_Champion            | 103144 |
    | a_Di`zok_Follower                | 103145 |
    | a_Di`zok_Revealer                | 103146 |
    | a_Sarnak_Whipcracker              | 103147 |
    | a_Di`zok_Sergeant                | 103148 |
    | a_Veteran_Overseer                | 103149 |
    | a_Shai`din_Conscript              | 103150 |
    | sorcerer_of_Di`zok                | 103151 |
    | Councilman_Garkerok_III          | 103152 |
    | sorcerer_of_Di`zok                | 103153 |
    | Di`zok_royal_guard                | 103154 |
    | a_sarnak_janissary                | 103155 |
    | a_Sarnak_templar                  | 103156 |
    | a_Sarnak_templar                  | 103157 |
    | a_sarnak_janissary                | 103158 |
    | a_shivering_slave                | 103159 |
    | a_terrified_slave                | 103160 |
    | #Echo_of_Chardok                  | 103161 |
    | a_confused_slave                  | 103162 |
    | Sarnak_Collective_Auditor        | 103163 |
    | an_angry_slave                    | 103164 |
    | a_Di`zok_Seer                    | 103165 |
    | a_Di`zok_Herbalist                | 103166 |
    | The_bridge                        | 103167 |
    | The_musty                        | 103168 |
    | Grave_Master_Zo`lun              | 103169 |
    | Foreman_Ku`lul                    | 103170 |
    | Overseer_Dal`guur                | 103171 |
    | Watch_Sergeant_Riz`oul            | 103172 |
    | an_insane_slave                  | 103173 |
    | The_thick                        | 103174 |
    | Grand_Advisor_Zum`uul            | 103175 |
    | The_sounds                        | 103176 |
    | Underboss_Myli`ki                | 103177 |
    | The_earth                        | 103178 |
    | Your_shin                        | 103179 |
    | Kennel_Master_Al`ele              | 103180 |
    | a_Shai`din_Soldier                | 103181 |
    | a_Shai`din_Myrmidon              | 103182 |
    | An_Iksar_Trustee                  | 103183 |
    | Battle_Master_Ska`tu              | 103184 |
    | a_miserable_slave                | 103185 |
    | a_Sarnak_aruspice                | 103186 |
    | The_stench                        | 103187 |
    | a_Di`zok_Aruspex                  | 103188 |
    | a_Chokidai_Sunderfiend            | 103189 |
    | Your_mind                        | 103190 |
    | Deathfang                        | 103191 |
    | a_smelly_slave                    | 103192 |
    | an_iksar_betrayer                | 103193 |
    | You_seem                          | 103194 |
    | The_Bridge_Keeper                | 103195 |
    | Clanging_sounds                  | 103196 |
    | Watch_Captain_Hir`roul            | 103197 |
    | Drill_Master_Dih`roul            | 103198 |
    | Wraith_of_a_Di`zok_Hero          | 103199 |
    | Grand_Lorekeeper_Kino_Shai`din    | 103200 |
    | a_Alchemist`s_Acolyte            | 103201 |
    | The_cries                        | 103202 |
    | You_hear                          | 103203 |
    | You_notice                        | 103204 |
    | a_Shai`din_Jannisary              | 103205 |
    | Arch_Inspector_Nibi`zi            | 103206 |
    | The_clang                        | 103207 |
    | a_Sarnak_aruspex                  | 103208 |
    | a_Shai`din_Warlord                | 103209 |
    | A_mix                            | 103210 |
    | Foreman_Mirt`akk                  | 103211 |
    | Captain_Di`ouz                    | 103212 |
    | Your_feet_splash                  | 103213 |
    | a_Sad_Ratman_Slave                | 103214 |
    | Loremaster_Piza`tak              | 103215 |
    | a_sullen_slave                    | 103216 |
    | #Historian_Silren_Di`zok          | 103217 |
    | #The_Fabled_Prince_Selrach_Di`zok | 103218 |
    | #Korocust                        | 103219 |
    | #Interrogator_Gi`mok              | 103220 |
    +-----------------------------------+--------+
    220 rows in set (0.00 sec)
  2. That One Guy Augur

    I'm more curious how they managed to fix Echo of Sebilis but they didn't realize there was an Echo of Chardok until it was too late? All you have to do is look up his loot table, look to see there is a quest item that involves... Echo of Chardok and boom. 1 minute of research, once you are at Echo of Sebilis on allakhazam and doing your research to determine if Echo of Sebilis is out of era or not... seems extremely easy to just dig 2 pages deeper to see if there are more out of era mobs linked to the same quest.
  3. ExoticCheese Journeyman

    It has nothing to do with the skill of the developer. It has to do with risk management. It is infinitely times safer to do a script update in a zone than to do a mass table update with a query. Good management knows that, even if it takes an umpteenth times longer to do.
  4. Maze Elder

    Risk management is a null issue if you on-board competence instead of incompetence.
  5. Bobbybick Only Banned Twice

    Maybe it was during those 4 days of ZAM outage!
  6. ExoticCheese Journeyman

    RIsk management is always an issue. No matter how "competent" an individual or individuals are, there is always risk. If you fail to see that, you would fall under the "incompetent" bucket.
    DruidCT likes this.
  7. Maze Elder

    Maybe I should tell the DBAs that work for Oracle to take a hike.

    They run queries....at....
    Oracle.
  8. Gidono https://everquest.allakhazam.com

    I run allakhazam on a docker environment. It's basically a clone of the site that reads off a clone of the repo on my drive, along with the database tables I need for whatever I'm working on. So I can run queries and see what they'll do before I ever send those queries off to the production server.
    Sultan likes this.
  9. Maze Elder

    Point proven.

    I run any database in a test environment prior to porting the query over to production.

    They have local pocket servers, I know this for a fact.
    Sultan likes this.
  10. Lupercus New Member

    We still had Echo of Sebilis in our instance when we were doin Trak today..
  11. Sultan Elder

    Don't think that was the point they were making and I am finding more and more of your posts lately to be offensive and sarcastic, not very professional.
  12. Accipiter Old Timer


    Salty people read salt in every post.

    I didn't read Ngreth's post as sarcastic in the least. He was simply saying, "It's not as easy as you think."
    Felicite likes this.
  13. Zanarnar Augur

    Actually what he admitted was that he had to go lay eyes on every spawn in the zones to fix this instead of being able to fix the spawns on the database side, as he should be able to. Honestly if they can't EASILY spot out-of-era spawns in the database they have things setup worse then the eqemu is.

    Salty or not, the excuse doesn't hold much water with a half-way competent DBA. Whatever it doesn't matter on Phinny anymore so I have no dog in this fight other than boredom.
    Sultan likes this.
  14. taliefer Augur

    Oracle is the biggest piece of poo trying to pass itself off as functional software I've ever seen. Everything from the user interface to the back end support is garbage.
  15. Waring_McMarrin Augur


    Well I guess it is a good thing that Ngreth isn't a DBA.
  16. Ngreth Thergn Developer

    This will be fixed in a hotfix soon(tm)
    And since this thread is out of hand... closing.
    Clonkers likes this.
Thread Status:
Not open for further replies.