Highpass Hold

[Zothen]

I was a little bit disappointed to revisit this zone after a decade and see it revamped with my SoD client.

The orcs there look almost like WoW orcs now, that just doesnt fit EQ style...

Is there a way to change at least the gnoll and orc models back to the old world ones?

[trevius]

Yeah, you just need to change the races in the database for that zone, and then you probably need to adjust your highpass_chr.txt file (or whatever the zone is named) to add in the old races. Most likely, you can just copy the file from an older install to have the old races available.

[Zothen]

Great, will try that out. Thanks alot!

[Zothen]

Hmm, there are 3 zones in the database:

highpass
highpasshold (the new one)
oldhighpass

I tried to /zone to the other 2, but for '/zone highpass' I get an error I need to enter a valid zone name.

Zoning to oldhighpass works, but it rather looks like highkeep to me, but an empty, unfinished version of it.

Dunno which database entry I need for reference now to change the mobs of new HPH back to the old ones.

[Secrets]

Hmm, there are 3 zones in the database:

highpass
highpasshold (the new one)
oldhighpass

I tried to /zone to the other 2, but for '/zone highpass' I get an error I need to enter a valid zone name.

Zoning to oldhighpass works, but it rather looks like highkeep to me, but an empty, unfinished version of it.

Dunno which database entry I need for reference now to change the mobs of new HPH back to the old ones.

/zone is a client command, and thus, uses the client to lookup zone names. If the zone name isn't valid (Highpass original is missing from EQ SoF/SoD) it will refuse to send you there.

[trevius]

Hmm, there are 3 zones in the database:

highpass
highpasshold (the new one)
oldhighpass

I tried to /zone to the other 2, but for '/zone highpass' I get an error I need to enter a valid zone name.

Zoning to oldhighpass works, but it rather looks like highkeep to me, but an empty, unfinished version of it.

Dunno which database entry I need for reference now to change the mobs of new HPH back to the old ones.

You will need to change the race of the mobs in highpasshold. Then, you will need to copy over your highpass_chr.txt file from an older client into your new one and rename it to highpasshold_chr.txt. You will probably have an existing file by that same name, but you can just rename it first so you have a backup.

[Zothen]

So highpass is the real old zone, not oldhighpass? Well, obviously not, else it wouldnt be emtpy...

I already got you on the .txt file changes, I just wasnt sure which database entry to take as a source for my edits.

EDIT: highpass_chr.txt doesnt exist in my titanium folder!

[provocating]

I was a little bit disappointed to revisit this zone after a decade and see it revamped with my SoD client.

The orcs there look almost like WoW orcs now, that just doesnt fit EQ style...

Is there a way to change at least the gnoll and orc models back to the old world ones?


I am not too hip on these either. They are not much like any other character model in even the newer zones. They are rounded, and cartoon-like. WTF were they thinking letting these into the game ?

[Zothen]

I am about to give up. I dug up an oldhighpass_chr.txt, but it has 20 entries in it. The new highpasshold_chr.txt got 6...so I guess I cant just copy and rename the old one without strange results.

Second problem I cant find any of the names of the txt files in the database. Neither gnl nor any other npc codes, just full names.

Need more input ;)

[sorvani]

A clean titanium install should have all of the correct files because these zones work just fine on P99 and there are no changes required to highpass files for the clients to play there.

As for the DB entries, I have no idea as I have never tried it out on my test server.

edit: A quick DB query shows highpass, highkeep as the correct zones on my server with the new highpasskeep locked with a min status of 80 in the default 1751 DB. They are both expansion 1 and zoneidnumber = 5 and 6
select * from zone where long_name like '%high%';

[Zothen]

I tried a clean Titanium as well as a fresh RoK install, but no highpass_chr.txt. Only highpass_chr.s3d...

I can't edit the database as long as I dont know how its connected with the clients txt files. :(

[KingMort]

This is a Couple of Query's to change all NEW orcs on your server and NEW goblins on your server to the OLD versions.

DO NOT RUN THIS UNLESS YOUR SURE THIS IS WHAT YOU WANT:
(This will change all the new Goblins and Orcs into the old one on your ENTIRE server)

UPDATE `npc_types` SET `race` = '54' WHERE `race` = '458';
UPDATE `npc_types` SET `race` = '40' WHERE `race` = '433';

[Zothen]

are you sure this works without changing anything on client side?

[KingMort]

No client changes are needed, this should work just fine .. But keep in mind this is going to do all the orcs and goblins in every single zone everywhere.

If you just want to be zone specific, well that's a bit more complicated.

But essentially it would look like this


UPDATE
`npc_types` INNER JOIN `spawnentry` ON `npc_types`.`id` = `spawnentry`.`npcID`
INNER JOIN `spawn2` ON `spawnentry`.`spawngroupID` = `spawn2`.`spawngroupID`
INNER JOIN `zone` ON `spawn2`.`zone` = `zone`.`short_name`
SET
`npc_types`.`race` = '54'
WHERE
`npc_types`.`race` = '458' and `zone`.`zoneidnumber` = 5


zone 5 being highold.. Anyway you can do this zone by zone if you like or use the query i posted before to do your entire database if that's what you want.

Morty

[Zothen]

Thats great, thanks mate!

[KingMort]

NP !! While I do suck at C++, I am fair - midland on PERL and SQL stuff hehe :)

[Zothen]

I tested it and unfortunetely, it does not work. :(

All gnoll and orc models are now human male.

[KingMort]

That's your Client seeing them as a human male.. Now your diving into the individual zone character text file. You may also go to the human males and do a #gender 0, or #texture 0, or #texture 1, , 2 , 3 , 4 etc and see what happens. Some times those can mess it up so it won't show up.

[robinreg]

I know you can change old model orc to new model orc in the classic world. but not so much to change new model to old model in revamp zones. I guess you got to tweak and mess with the client files for it to work.

[sorvani]

Logged onto my test server with Titanium, SoD, and UF. As expected everything looks pre-change on Titanium while SoD and UF show the new zone and orc models. So if you are using Titanium and not seeing hte right stuff you got something messed up. My DB is straight from the SVN

[Zothen]

I am using SoD.

Well, i managed to change the orcs back to old world model. But it needed adding the model to highpasshold_chr.txt.

Unfortunetely, gnolls still dont work so far. Referring to EQEmus model list, I added

gnn,blackburrow_chr

to the .txt file, but that doesnt do the trick.

Is there another model anywhere for race 39?

[Zothen]

Okay, I got it working at last!

First, we need the following modified SQL-Statement from KingMort:

-- Change Highpass Hold mobs back to classic

-- Change Orcs
UPDATE
npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID
INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID
INNER JOIN zone ON spawn2.zone = zone.short_name
SET
npc_types.race = 54, npc_types.size = 8, npc_types.texture = 1, npc_types.helmtexture = 0, npc_types.gender = 2
WHERE
npc_types.race = 458 AND zone.zoneidnumber = 407;

-- Change Gnolls
UPDATE
npc_types INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID
INNER JOIN spawn2 ON spawnentry.spawngroupID = spawn2.spawngroupID
INNER JOIN zone ON spawn2.zone = zone.short_name
SET
npc_types.race = 39, npc_types.size = 6, npc_types.texture = 2, npc_types.helmtexture = 0, npc_types.gender = 2
WHERE
npc_types.race = 524 AND zone.zoneidnumber = 407;

Then we really need to edit the client file "highpasshold_chr.txt" and add 2 lines:

7
hhm,highkeep_chr
qcm,qeynos_chr
qcf,qeynos_chr
gnl,gnl
mmy,mmy_chr
gnn,qeytoqrg_chr
orc,ecommons_chr


Done! Enjoy the new old models ;)