EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)

- - Peq DB (https://www.eqemulator.org/forums/showthread.php?t=25995)

tweak24

08-22-2008 11:01 AM

Peq DB

I have a question pertaining to the database
Is it possible to let someone not gm flagged in zones past PoP?
When we did try to experiment with it we ended up causing it not to let any connections to the server >.<

tweak24

08-22-2008 11:12 AM

gr. i clicked the wrong link. i swear i was on windows support my appologies

cavedude

08-22-2008 02:34 PM

You'd have to remove the flag requirements for PoP zones. Status will also need to be set to 0 for the elementals/Time which aren't quite done yet. This query will do it:

Code:

update zone set flag_needed = '', min_status = 0 where zoneidnumber > 199 and zoneidnumber < 224;

For zones past PoP, you just need to set the status:

Code:

update zone set min_status = 0 where zoneidnumber > 223;

This will effect every zone that has a zoneidnumber higher than 223 (potimeb), so be careful.

So_1337

08-22-2008 03:00 PM

How does the flag_needed fielded relate to what's actually being looked for? If there's any value at all there, it checks the zone_flags table for if a character is flagged or not? Or does it actually matter what's in the field?

cavedude

08-22-2008 03:08 PM

From my limited testing, if there is anything in the field it looks to see if the toon has a flag and if so let's them in. So, no it doesn't matter what's in the field. Though, I did have some trouble with flags that were text, which is why all the PoP flag_needed fields are set simply to 1. If the field is NULL, then obviously no flag is required.

So_1337

08-22-2008 03:32 PM

I'd been wondering for awhile, and you answered it perfectly. Thank you!

All times are GMT -4. The time now is 11:10 PM.