Peq DB

[tweak24]

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]

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

[cavedude]

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:


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:


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]

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]

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]

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