Dead Men Walking

Old Server Admin Section => SOG Archive => SOG War Room => Silver Oak Guardians => Archived Topics => The Clean Up => Topic started by: Vanguish on June 26, 2006, 12:24:46 AM

Title: Dkp site
Post by: Vanguish on June 26, 2006, 12:24:46 AM
Hey there,

I missed my name on the DkP site if you filter it on cloth... I do see a lot warlocks  but not my name  :nope:

I don't know if this is the right spot to put this, but hope to see my name soon on the DkP site if I filter on cloth  :D

Cya all tonight when we kill Raggy
Title: Dkp site
Post by: Bastet on June 26, 2006, 08:03:16 AM
All the filters are mildly borked up, dont worry if you whisper the ML should still be able to find your dkp, it might just take a bit longer.
Title: Dkp site
Post by: saori on June 26, 2006, 09:08:06 AM
One sugestion, wouldn't be nice to make a filter with RG1 or RG2 membership??, that will be easier to lookup standings inside the raidiging group.

Sao
Title: Dkp site
Post by: Greatdanes on June 26, 2006, 09:20:03 AM
Very good idea, Saori.
Title: Dkp site
Post by: Bastet on June 26, 2006, 09:22:51 AM
If it aint broke, dont fix it. The filters are hard wired in the site core, and id personaly rather not TANGO arround with it, cause breaking it would be pritty disasterous.

Shouldnt matter to much though, i always use sort on alphabet and then compare the whispering members.
Title: Dkp site
Post by: saori on June 26, 2006, 09:36:58 AM
QuoteOriginally posted by Bastet@Jun 26 2006, 08:22 AM
If it aint broke, dont fix it. The filters are hard wired in the site core, and id personaly rather not TANGO arround with it, cause breaking it would be pritty disasterous.

Shouldnt matter to much though, i always use sort on alphabet and then compare the whispering members.
[post=133503]Quoted post[/post]
[/b]

Well, i dont share the same opinion. If things dont broke then dont fix them...well, we arent talking about "fixing anything", we are talking about improving!!

You know, when a system works fine its great, but it can be allways improved. Having a RG1 and RG2 filter, for example, along with class filter will save a lot of time for ML and a lot of time for member to lookup standings. For example, at this moment there are 19 Warlocks dkp site, which of them are RG1 and wich of them are RG2?? i think is pretty interesnting to have the chance to order it this way.

Im sure there must be some skilled web programmer within the guild that can add the new query to the dkp site, i mean, we are only saying that the statement query will be something like filter "RG1" where "class" = classtype (it isnt as hard as you think, belive me)

Other chance is to set a new value in member description, i mean, actually we have for each memeber the following values:

Name, Rank, Level, Class, Earned, Spent, Adjustment, Current and Last Raid,

We can add a RG Status tab along with rank tab, for example, that will make easier to sort out standings too.

Obviously all this is just a suggestion for taking in consideration by the officers. I just think it will improve the system and make the searches faster and loot times shorter (and less messy)

Sao
Title: Dkp site
Post by: Bastet on June 26, 2006, 09:48:01 AM
Might not be hard, but if the data gets fubard up your screwed beyond belief, losing all the dkp info for members would not be a preferable situation. And how does it matter, the list of defender/guardians is a few posts higher then this one, and ML only looks at the ppl that whisper anyway. If you raid a lot youd know the ppl in your RG offhand anyway :P if you give me a list of names i know pritty much for all classes the RG1 members.
Title: Dkp site
Post by: saori on June 26, 2006, 09:59:02 AM
QuoteOriginally posted by Bastet@Jun 26 2006, 08:48 AM
Might not be hard, but if the data gets fubard up your screwed beyond belief, losing all the dkp info for members would not be a preferable situation. And how does it matter, the list of defender/guardians is a few posts higher then this one, and ML only looks at the ppl that whisper anyway. If you raid a lot youd know the ppl in your RG offhand anyway :P if you give me a list of names i know pritty much for all classes the RG1 members.
[post=133518]Quoted post[/post]
[/b]

Men, we live in 21th Century, didnt you heard about "backup copies"???? specially full and incremental server backups??

Anyway, we are just talking about a databse holding the data of the members 8which can easily be backedup) and a few "new querys" (no need to eliminate old querys). You can also make a copy of the system under a "development server" out of the "production one" (i can offer my own server as development server for SoG if necesary as same im a profesional programer and skilled enough to commit this changes in the site!! as any other improvements i think might be interesting)

Can you provide me a copy of the dkp site so i can work on it in my own enviroment? that will be great, that way i can show you how to imprve the site in test server with access to all memebers so thet can vote if changes are worth of it or not.

And one thing, Bastet, if you raid a lot you will probably know almost of the members, but what about the newcommers? or the people that couldnt afford to raid so much?

im just suggesting some improvements, nothing else! i thing officers are doing a great job for free just for the love of WoW.

Sao
Title: Dkp site
Post by: Bastet on June 26, 2006, 10:15:47 AM
well if you want a back up of the thing you have to talk to tanales, i really dont know much about the system, as you might have noticed by now. And since its dang important to us i dont want to mess with it too much :P as for the backups thier made, but not directly by us.

As for the members, i think i know pritty much most the ppl in the raid groups, and if not, heck then ill look em up on the list :P

and this might help too: http://ars.userfriendly.org/cartoons/?id=20060625 (http://ars.userfriendly.org/cartoons/?id=20060625)
Title: Dkp site
Post by: saori on June 26, 2006, 10:21:25 AM
QuoteOriginally posted by Bastet@Jun 26 2006, 09:15 AM
and this might help too: http://ars.userfriendly.org/cartoons/?id=20060625 (http://ars.userfriendly.org/cartoons/?id=20060625)
[post=133538]Quoted post[/post]
[/b]

I dont see the point here, i dont even knwo what is this....a newsfeed? a forum? just threads? For me it appears pretty messy there...

Well, anyway, what i had mention i think will benefit things over and will make data more redundant, easy to habdle and fast in sortering. But is just my point of view...

Sao
Title: Dkp site
Post by: Bastet on June 26, 2006, 10:22:50 AM
Was more the picture that was supposed to be a funny note in a way to serious thread, but either you didnt see it or couldnt load it :P
Title: Dkp site
Post by: TeaLeaf on June 26, 2006, 11:33:37 AM
One problem with filtering on RG1 or RG2 is that at the moment there might be both in one raid. So it might be a nice addition, but not one that is necessary.  In any case, I don't know enough to edit the code, so I cannot change anything!

As for backups, there is a backup taken nightly to a different box and then that backup is also FTP'd offsite, so I reckon we're pretty secure there atm.  It's one of the benefits of now hosting our own DKP.

TL.
Title: Dkp site
Post by: saori on June 26, 2006, 11:42:29 AM
QuoteOriginally posted by TeaLeaf@Jun 26 2006, 10:33 AM
One problem with filtering on RG1 or RG2 is that at the moment there might be both in one raid.
[post=133570]Quoted post[/post]
[/b]

Well, i know that sometimes people for RG2 go to RG1 for filling necessary spaces, but THEY STILL ARE RG2 people!

I mean, Teaelle = RG1, if teaelle go one day with RG2 to MC that dosent mean he is RG2, he is still RG1 despite the dkp's earned with that RG2 run, nope?

Is just one more tab to handle data in a more efficient way.

BTW, Bastet, sorry if you pretended to put some joke over there with the link, but i didnt really understood it  :D

Sao
Title: Dkp site
Post by: TeaLeaf on June 26, 2006, 03:41:27 PM
I'm really not sure what you're getting at here Saori. :unsure:

Do you want a 'button' to filter things for you for ease?  Is that it?

TL.
Title: Dkp site
Post by: Bob on June 26, 2006, 03:52:18 PM
QuoteOriginally posted by TeaLeaf@Jun 26 2006, 04:41 PM
Do you want a 'button' to filter things for you for ease? Is that it?
[post=133614]Quoted post[/post]
[/b]
Isn't that what most of this thread has been about?  Adding a simple filter, so that you in the same way you can choose to see only druids, you can also only choose to only see RG1 or 2 members...?

And btw - to Bastet who is afraid of crashing anything with the DKP system: such a filter shouldn't be hard to implement.  It's only about adding a very simple parameter in the sql query - and an sql query only retrieves data, it doesn't add anything, so it can't ruin anything either :)
It's just to change "SELECT * FROM MEMBERS WHERE CLASS = 'Druid'" to "SELECT * FROM MEMBERS WHERE MEMBERSHIP = 'Guardian'" (this is ofc very simplified example, but it doesn't need to be much harder ;)) before you list out the data.
Title: Dkp site
Post by: Neff on June 26, 2006, 04:07:34 PM
EZ: Ppl with 1500dkp+ is in rg1 problem solved for now.
Title: Dkp site
Post by: TeaLeaf on June 26, 2006, 05:17:44 PM
Well I think we all know its possible, but why is it such a big deal?  That's the bit I'm struggling with.  It's not something I know how to do so it woudl have to be others who did it, but it's not something I have ever needed or missed when I do the DKP. It's not something I have ever needed or missed when browsing the DKP site.  So I am asking why we should divert time to add it maybe?  That sounds harsh, it's not meant to be, just asking the question so I understand why.  If it turns out to be as easy as Bob describes then I am sure it will get done, but I am amazed at the depth of feeling over a missing filter that nobody seems to have a need for!

TL.
Title: Dkp site
Post by: Bob on June 26, 2006, 10:58:40 PM
QuoteOriginally posted by TeaLeaf@Jun 26 2006, 06:17 PM
If it turns out to be as easy as Bob describes then I am sure it will get done, but I am amazed at the depth of feeling over a missing filter that nobody seems to have a need for!
[post=133638]Quoted post[/post]
[/b]
I think I'm gonna go a bit off topic here, but what the heck - that's what I like to do ;)

Computer programming and development is both my hobby and my work - it's something I'm very pationate about.  It might just be my head that's a bit twisted when it comes to these things (as you can see in my topic about the dMw logo (http://forum.deadmen.co.uk/index.php?showtopic=14822) :P ), but that makes me notice and think about lots of stuff that not everybody normally do.
It can be programs I use, web sites I browse or technical devices I use (whatever related to something in that direction): I use them, and I can spot big or small things of various significance and think thoughts like "omg, why haven't they just added this cool feature? it's so easy and would have made everybodys life just a little bit better", or "whoa, hold the phone... who built that thing??? that sollution is just plain stupid", or similar stuff.  All these opinions are of course coming from a very (twisted :crazy: ) technologically influenced brain, and would perhaps not be of very much use to the general public.  But if I see something that could be helpfull in 1 out of 100 situations, I'd love to try and get it implemented :)

I guess it can be the same with you TL, being a certified financial advisor: perhaps you see somebodys budget and just roll your eyes and think "that could have been soo much easier by just making a few easy steps" (or whatever you financial advisors do :P).


The only reason that I actually bothered to post in this topic in the first place, was to back up Saori a bit.  It seemed that he presented a suggestion (and a pretty relevant one too if I might add), and only got hit in the face with "nope, forget it. not possible even in a million years" (this is ofc pushing things to extremes, but it's just to try and make a point).
Now I don't know anything about what lies behind this specfic system, but in general it's mostly a not too complicated sql database of some kind with simple queries to retrieve data.  And in this case it seemed like Saori had at least a bit knowledge about what he was talking about, and because of that I thought he deserved to be heard and have a bit of support ;)


But again, as usual, my posts tend to be 3 times as long as they have to be (and way out of the original topic of the thread) :rolleyes:
I'll go to bed now, and tomorrow I'm looking forward to take down one big dragon :rockon:
Title: Dkp site
Post by: saori on June 27, 2006, 09:09:30 AM
QuoteOriginally posted by TeaLeaf@Jun 26 2006, 02:41 PM
I'm really not sure what you're getting at here Saori. :unsure:

Do you want a 'button' to filter things for you for ease? Is that it?

TL.
[post=133614]Quoted post[/post]
[/b]

Well, what i had suggested to do is as follows:

1. Adding a new filter in the Top Page (http://dkp.silveroakguardians.org/dkp/listmembers.php) for selecting RG1 or RG2 members, the same place where you select to filter by class (warrior, lock, pala, etc). That will be useful to have a general balance of the progress in DKP amount in your raid group and will be easy to sort out the general members listed as RG2. Actually we have filter set for armor type (cloth, leather, mail and plate) and for class type (warrior, paladin, warlock, mage, druid, priest, hunter, rogue, shaman, unknown) (and we have shaman although SoG is alliance group, no? but under shaman we have 57 people under member status "inactive"...i dont quite understand this, is it SoG also in Horde side?) As easy as we set a filter for armor type, or class type, we can set a new filter for raid group status, belive me, is an easy sql query to implement. For doing that we only need to add to the table in the databse holding the player data, a new item called "raid status", for example, and set it to rg1 or rg2, so we can index de information according to this status. The place for inserting this new data piece will be the same place where we hold the data for each character description.

2. If we do step 1, then, when we choose to sort the info, for example, selecting "warlock" filter, we will get a list of 19 warlocks, with the folowwing tabs of information: name, rank, level, class, earned, spent, adjustment, current, last raid. If we had added the "raid status" then we will have another colum here listing "member of RG1" or "member of RG2" and we will have the chance to sort the items according to this, so we can have a better view of DKP standings within our own class type and own raid group.

Modifying the sql database and creating the new queries is a piece of cake!!

Sao.
Title: Dkp site
Post by: saori on June 27, 2006, 09:13:19 AM
QuoteOriginally posted by Threbrilith@Jun 26 2006, 09:58 PM
It might just be my head that's a bit twisted when it comes to these things, but that makes me notice and think about lots of stuff that not everybody normally do.
It can be programs I use, web sites I browse or technical devices I use (whatever related to something in that direction): I use them, and I can spot big or small things of various significance and think thoughts like "omg, why haven't they just added this cool feature? it's so easy and would have made everybodys life just a little bit better", or "whoa, hold the phone... who built that thing??? that sollution is just plain stupid", or similar stuff. All these opinions are of course coming from a very (twisted :crazy: ) technologically influenced brain, and would perhaps not be of very much use to the general public. But if I see something that could be helpfull in 1 out of 100 situations, I'd love to try and get it implemented :)
[post=133682]Quoted post[/post]
[/b]

/sign

And thx for the support, Therebrilith
Title: Dkp site
Post by: Bastet on June 27, 2006, 01:12:28 PM
As said by tanales on the other dkp site thread there is currently a bug that resets all members information to just thier name, so even with the filter in place it wouldnt work cause information gets reset (it tends to reset between 1 and 10 persons in the raid due to some odd reason)
Title: Dkp site
Post by: Neff on June 27, 2006, 04:09:25 PM
Woah bob, so you see a pretty lady and dont think how you could've hooked up with her, but "gee, i wonder how she's coded "

:D
Title: Dkp site
Post by: saori on June 27, 2006, 04:48:58 PM
QuoteOriginally posted by Bastet@Jun 27 2006, 12:12 PM
As said by tanales on the other dkp site thread there is currently a bug that resets all members information to just thier name, so even with the filter in place it wouldnt work cause information gets reset (it tends to reset between 1 and 10 persons in the raid due to some odd reason)
[post=133762]Quoted post[/post]
[/b]

And that is a definitive solution?? Well, personally i think, if there is a bug then the big must be fixed, what if the next thing that the malicious bug resets is the amount of DKP's from the last raid of 1 to 10 members? how do you control it? how do the system alerts of such things?

If your car resets the fuel tank every 100 km/h, wouldnt you try to fix it?

DKP site is great, but i think that in addtion of fixing this kind of stuff it can be improved....

Sao...
Title: Dkp site
Post by: Bob on June 27, 2006, 05:43:59 PM
QuoteOriginally posted by Threbrilith+Jun 26 2006, 11:58 PM-->
QUOTE(Threbrilith @ Jun 26 2006, 11:58 PM)
(...)
It can be programs I use, web sites I browse or technical devices I use (whatever related to something in that direction)
(...)
[post=133682]Quoted post[/post]
[/b]

Title: Dkp site
Post by: Neff on June 27, 2006, 08:31:22 PM
Duuh, im a teenage boy  :eyebrow:
 :lol:

But my point was only that your so into coding that i'd try to make a funny about it :/
Title: Dkp site
Post by: Bob on June 27, 2006, 09:24:18 PM
QuoteOriginally posted by Neff@Jun 27 2006, 09:31 PM
But my point was only that your so into coding that i'd try to make a funny about it :/
[post=133852]Quoted post[/post]
[/b]
My point, is that you're so into girls, that you don't even notice that I try to make fun of you being into girls :roflmao:
Title: Dkp site
Post by: Umbra on June 28, 2006, 11:21:59 AM
so code boy is taking the piss out of oversexed boy...?

of COURSE girls are coded well, have you seen the bump maps? And those textures are just...moist

What I think people are getting at is, all the filters on the site are to facilitate ease of searching through different groups of people/classes/etc, surely which raid group is a top level filter like (guild->raid group->class->peni5 size->name) or somesuch.

it would be useful to some people and yes it would be a very simple sql query, as to the 'if it aint broke don't fix it' bad bad bad bad, working in Software myself for many years I know this to be one of the worst things anyone can possibly think, it leads to a lack of progression and eventually having to code for legacy stuff that never kept up (remember y2k stuff?).

any coder who says that one phrase will usually get reviled for the rest of his/her days :)

of course it would be nice for me to be able to filter out the pretend people (RG2) ;)

P.S. happy birthday to me, do i get dkp as a present?
P.P.S.  surely Nefarian should be worth more dkp than the other bosses :o
Title: Dkp site
Post by: TeaLeaf on June 28, 2006, 11:27:41 AM
QuoteOriginally posted by Umbra@Jun 28 2006, 11:21 AM
P.P.S. surely Nefarian should be worth more dkp than the other bosses :o
[post=133955]Quoted post[/post]
[/b]
:unsure: Hmmm, I thought it was.  Maybe I shoudl go look at the DKP site to check......  :dummy:

TL.
Title: Dkp site
Post by: TeaLeaf on June 28, 2006, 11:30:46 AM
Mmm, ok, all BWL first kill bosses are worth 50 DKP each, whereas the MC bosses increased their DKP value throughout the instance.  I'd not noticed tha tbefore. I'll talk to the other officers about it.

TL.
Title: Dkp site
Post by: Umbra on June 28, 2006, 01:06:24 PM
yeah, i noticed thta, mc bosses increased dkp, and first kill = normal x 2 dkp
bwl bosses all 25dkp first kill is 50.

doesn't bother me much but no way is ebonroc same effort as nef :D but then that would imply RG was worth more as he was hard too.
Title: Dkp site
Post by: sitha on June 28, 2006, 01:21:44 PM
QuoteOriginally posted by Umbra@Jun 28 2006, 02:06 PM
yeah, i noticed thta, mc bosses increased dkp, and first kill = normal x 2 dkp
bwl bosses all 25dkp first kill is 50.

doesn't bother me much but no way is ebonroc same effort as nef :D but then that would imply RG was worth more as he was hard too.
[post=134015]Quoted post[/post]
[/b]

Then again we spent more time on Razorgore then on Nef :)
Title: Dkp site
Post by: TeaLeaf on June 28, 2006, 01:21:46 PM
After discussion apparently it was meant to be same for all bosses in BWL as they are all uniquely challenging, except of course the three drakes who are uniquely individual in the same way that identical triplets are :norty:

TL.
Title: Dkp site
Post by: Knabbel on June 28, 2006, 01:41:46 PM
From real live experience.......

I read the beginning of this thread there was stated that there a backups made but no backup is good unless the restore is tested....

Backuping is 1...restore is 2.

But tbh I think that this will be okay ......  :D  :D

D.
Title: Dkp site
Post by: TeaLeaf on June 28, 2006, 02:05:27 PM
I am sure Tanales did a backup and a restore.  Apparently only one user was adversely affected by the restore procedure, someone called Knabbel lost 1,000 DKP. We're figuring that's within tolerance though and are happy to stick with it :norty:

TL.
Title: Dkp site
Post by: Bastet on June 28, 2006, 02:06:18 PM
the last of the drakes should be worth about 2 dkp for beeing a total push over, so the dkp you dont get on nef you get there :P
Title: Dkp site
Post by: Knabbel on June 29, 2006, 12:13:49 PM
Well the -1000 dkp is not something that cannot be overcome....but it gives me a go to screw up 200 times OL......hehehehehe.... and then got kicked out of the guild  (pretty sure it will be a lot faster!).....  :dummy:  :dummy:  :dummy:


D.