Day and Night

[Angelox]

Before I lost my server , I was working on a day and night Idea I had mainly for the zone line to SK in LakeRathe. I remember in the old days, when night time came, if you killed the gnolls there, the undead would spawn as would the gnolls during the day.
I managed to find most of what I had lost for that, but at the time I lost my server, I was at a stale-mate.
What I wanted, was for the npc spawn tables for certain mobs be replaced as to spawn or not depending on the night or day status. so I made the npc's, made the sqls, and made a script that would run the sqls every 12 hours (everquest time).
the script;

while (1) {
`mysql -h192.168.2.100 -ueq -peq -Dax_classic < /home/angelox/sqls/
rathenight.sql 2>&1`;
    sleep 2160;
    `mysql -h192.168.2.100 -ueq -peq -Dax_classic < /home/angelox/sqls/
ratheday.sql 2>&1`;
    sleep 2160;
};

The latter script runs at server startup on a static zone, since zones always boot up at 8:00 am, it would start with the daytime gnolls and by 8:00pm the undead would replace the gnolls


ratheday.sql:

--- Lake Rathe ---
UPDATE spawn2 set _condition=1 where zone="lakerathe" and spawngroupid=51134;
UPDATE spawn2 set _condition=0 where (spawngroupid>=51000 and spawngroupid<=51008);

--- Kithicor ---
UPDATE spawn2 set _condition=1  where (id >=6037 and id <=6044) or (id >=6182 and id <=6196) or (id >=6095 and id <=6099) or (id >=6012 and id <=6018) or (id >=5994 and id <=5998) or (id >=347154 and id <=347155) or (id >=6102 and id <=6103) or (id >=6107 and id <=6108) or id=6199 or id=6121 or id=6202 or id=6200 or id=6112 or id=6092 or id=347709 or spawngroupid=20089;
UPDATE spawn2 set _condition=0 where spawngroupid=20041 or spawngroupid=20169 or spawngroupid=20039;
UPDATE spawn2 set _condition=0 where spawngroupid=20161 or spawngroupid=20069 or spawngroupid=20018 or spawngroupid=20000 or spawngroupid=20006 or spawngroupid=20031 or spawngroupid=20056 or spawngroupid=20075;

rathenight.sql;

--- Lake Rathe ---
UPDATE spawn2 set _condition=0 where zone="lakerathe" and spawngroupid=51134;
UPDATE spawn2 set _condition=1 where (spawngroupid>=51000 and spawngroupid<=51008);

--- Kithicor ---
UPDATE spawn2 set _condition=0  where (id >=6037 and id <=6044) or (id >=6182 and id <=6196) or (id >=6095 and id <=6099) or (id >=6012 and id <=6018) or (id >=5994 and id <=5998) or (id >=347154 and id <=347155) or (id >=6102 and id <=6103) or (id >=6107 and id <=6108) or id=6199 or id=6121 or id=6202 or id=6200 or id=6112 or id=6092 or id=347709 or spawngroupid=20089;
UPDATE spawn2 set _condition=1 where spawngroupid=20041 or spawngroupid=20169 or spawngroupid=20039;
UPDATE spawn2 set _condition=1 where spawngroupid=20161 or spawngroupid=20069 or spawngroupid=20018 or spawngroupid=20000 or spawngroupid=20006 or spawngroupid=20031 or spawngroupid=20056 or spawngroupid=20075;

I was so exited, I preped Kithicor also and thought I just needed to figure out how to repop this zone every 12 hours (kithcor undead pop up at night).
Well, I came to realize that: 1- the spawngroups I replace will only appear on a "repop" (if I kill a gnoll with a pc, the gnoll spawns, not the replaced undead). 2- there is no way I know of, that a zone can be repoped unless you do it via GM.
Another way would be to use dynamic zone, but whan you zone to a dynamic, it always starts at 8:00 am and will be out of sync.

Anyways, there are the scripts ( I got frustrated)- I posted an update to my database with the NPC changes, so you can see it works: you can actually set the zone up as static, wait tell night and "repop" the zone, undead will appear. the script loops , so it will always happen.
If anyone has any ideas or knows how to get this working, please post!

[techguy84]

This seems like a awsome Idea, you could use this possibly for special events and such.

As far as to your problem, as I know nothing about Mysql yet, but what if you you made sqls that completely replace the whole spawn data in that zone, and then you could possibly have a batch file that sources in the new zone spawns, not repops, and then boots the zone, closing the zone before it. The only issue with this is if anyone is in that zone, they get disconnected...... hmm, well nevermind, i thouhgt i had something.

Ok, what about this, can you run scripted gm commands some how, maybe through a keyboard API or something that you create you a gm, run a bare bones client that you will not use, and at a scheduled time of day, have the api run a repop command that will be layered into the client therefore running the repop for you......

I dont know, im just tooting my horn here, as I haves a now Idea /sigh

[ArChron]

I may be talking way off base here, but why couldn't the spawn tables just incorporate a temporal component? No script that needs to be run to swap the pops, but extend the model to incorporate time of day and you have a much more flexible solution... some mobs could only be up during certain hours of the day.

Dang, now you're gonna make me go look at the spawn code...

[techguy84]

I think its more along the lines of it having to be coded into the emulator itself. Like a line that tells it to re pop using said database information. This could be used in conjonuction with your idea archon. The database would contain spawn times for select spawns, and the emulator would see this when its internal time hit 8:00am or 8:00pm, at which time it would prepare or just directly respawn using those special spawns from the databse.

[samandhi]

I don't know anything about the coding in the emu( I know some coding of a different sort though, as I work for a controls company, or building automation if you will)... so not sure if this is even feasable or not, but what if you ran the zone (kith) dynamically, and did NOT spawn anything yet. Then make a call to the system (read emu) time to sync it with the world, THEN spawn the zone accordingly..? I know it sounds "easier said than done" but ideas start from somewhere yes?

[ArChron]

There is always the option of trying to include a daemon in the emulator (might be there already for all I know) that would allow events to be queued up. When the appointed hour came nigh, the daemon could spawn an event thread and hand it the event ID so it could deal with the event details.

For this "normal during day, undead at night", at 0 hour you could wipe the zone of "normals", then do a repop of the undead (making critters warp all over the place at they repop at designated points).

Or the thread could find each appropriate mob and swap it out at their current location, in their current state (kinda like the moonlight in Pirates of the Caribbean) according to the event rules.