EQEmulator Forums - Use classic zones in SoF

The PEQ db still has a few hiccups in regards to this, for instance, any client zoning out from gukbottom will go to old innothule(zone id 46), where as if you zone from guktop, it will send ver 6.2 and Titanium to old innothule, and the rest of the clients to new innothule (innothuleb, zone id 413).

Code:

select id,zone,target_zone_id,client_version_mask 

from zone_points 

where target_zone_id = 46

order by client_version_mask;

When you run the above query, you will notice 3 zones with a client_version_mask of 3 (rev2506), also notice the zone name gukbottom with a client mask of 4294967295, that means all clients zoning from gukbottom will zone to zone 46 (old innothule). Now re-run the query with new innothules zone id(413):

Code:

select id,zone,target_zone_id,client_version_mask 

from zone_points 

where target_zone_id = 413

order by client_version_mask;

Again 3 zones will have unique values for their client_version_mask (ie, not 4294967295) these are the same zone names from the previous query, except this is telling the server to send all clients BESIDES 6.2 and Titanium to new innothule from these zones.

Since you seem to want all clients going to the old innothule instead of the "crap" new one, then you would delete the three rows referenced in the above query zoning to new innothule with client_version mask of 4294967292, then edit the three rows from the first query with client_version_mask of 3 to use all clients instead, by changing the client_version_mask from 3 to 4294967295...

Use at your own risk and backup your db before dorking with it:

Code:

DELETE FROM `zone_points` 

WHERE `target_zone_id` = '413' 

AND `client_version_mask` = '4294967292';

This deletes the 3 unwanted rows, then run:

Code:

UPDATE `zone_points` SET `client_version_mask` = '4294967295' 

WHERE `target_zone_id` = '46' 

AND `client_version_mask` = '3';

Now all the old zone point data for innothule will apply to all clients. **NOTE** you will need to make sure you have all the zone files pertaining to these old zones on all the clients you would want to play on your server, so if its your own server, no biggie, but you will not be able to go public as any one without those zone files will not be able to zone at all, and may get caught in a zoning death spiral.