Is this possible?

[Jeido]

Is it possible to create a section of the site where it will record when major mobs are killed, and say the date/time? This would be great for scripted events, the biggest one I can think of right now is Vulak though. It would just be nice if it were possible to see when they were killed so that other guilds/players could plan accordingly. What do you think Topsy? : P

[Topsy]

Is it possible to create a section of the site where it will record when major mobs are killed, and say the date/time? This would be great for scripted events, the biggest one I can think of right now is Vulak though. It would just be nice if it were possible to see when they were killed so that other guilds/players could plan accordingly. What do you think Topsy? : P

First something like that would need approvial from tyler & lillu. I imagine somewhere in the db that information is stored. I know that i can tell from clone their spawn time. But i haven't really looked into the code to see if it stores the time they die. That being said. If there was somewhere in the db that listed if they were "spawned" or when they will be spawned, it wouldn't take much more than a few lines of html & and pulling that data from the db. Mind you: We would need a complete list of mobs to be added including their id's.

[Jeido]

I wouldn't mind helping with the boring part, listing the mobs : P. Others could recommend mobs as they see fit as well, I would likely just list important raid mobs such as key mobs, epic mobs or others that can be tedious to not know when they will be back up.

[Topsy]

Sure, lets see what lillu & tyler say. I'll look to see if i can see anything in the db before you go through all the trouble of finding mobs.

[Topsy]

It looks like there is a table named respawn_times;
id / start / duration / instance_id.

This is probally the table were looking for, i'll need to verify if its actually a functioning table though. It might just be in there as a "one day we'll impliment this" table.

lillu / tyler:

What are your thoughts on introducing a Raid mobs page? Could have a breakdown like.

epic 1.5 mobs:
unicorn of blah spawned
unicorn of nonblah spawns in 31minutes

st key holders
klandicar spawned (and fully equiped with lipstick)
....

tier 1
emperor ssra spawned
Cursed spawns in 15minutes 12 seconds

tier 2
tov dragons


tier 3
st named

tier 4
pofire named
... so on and so forth.

[Topsy]

Might try a query to see what you get:

mysql> use peq;
Database changed
mysql> select respawn_times.duration, npc_types.name, npc_types.lastname from respawn_Times left join npc_types on respawn_times.id=npc_types.id;
+----------+------------------+----------+
|-duration--|-name | lastname |
+----------+------------------+----------+
| 1000 | a_sarnak_armorer | |
+----------+------------------+----------+
1 row in set (0.00 sec)

mysql>

Hopefully the respawn_times.id = the npc_types.id; if so it would be a snap

[Jeido]

Ok well just let me know all of the information you'd need for each mob after you figure out how to make it work!

[Lillu]

I like the idea, and would be a nice addition to our (already unique) web based tools. Though Topsy has 2-3 running sub projects already, so he definately could use some help.

[Tyler]

Key word - Overtime!

[Koeril]

I say you double what you pay Topsy for all his hard work. Thanksgiving bonus even!!