Author Topic: Updated Points.php (Read 31649 times)

Temar · « **Reply #15 on:** January 10, 2009, 04:01:44 am »

simple thing u should do is replace the ORDER BY points with ORDER BY nickname
u can also change DESC to ASC
which eva u prefer

keirou · « **Reply #16 on:** January 10, 2009, 04:54:40 am »

wow, its really that easy?? man i feel like a moron

still better i ask then start tinkering with stuff that will break

Allisande · « **Reply #17 on:** January 17, 2009, 07:11:09 pm »

What if I wanted to add Nickname to the table. How can I do that?

I went and found what I would need to enter into the code to get the column added, but I messed something up by doing so because I could no longer view !points all or !points top. !points still showed me my total, but I could no longer view anyone else.

Thanks

keirou · « **Reply #18 on:** January 18, 2009, 02:18:04 pm »

to add a nickname to a table (i assume you mean award them points)
just go !points add name pts
where name = the name you want to add
and pts = the ammount of points you want them to have.
however they have to added as a member off the bot.

i found that out after converting out notepad dps list online, just went through adding the points and peoples names only started showing up after they talked in guild and were registered to the bot.

Allisande · « **Reply #19 on:** January 19, 2009, 03:53:52 am »

I know how to add points to a person. What my question is pertaining to is when I go and look at the actual table it displays

ID---Points---Raiding

What I would like to see in the table is

ID---Nickname---Points---Raiding

This way I can have an updated list saved as a back up in .xls in case something happens to the table. I will be able to check who is who. As it is now...I have to cross reference everything trying to figure out what ID number goes with who.

Thanks

keirou · « **Reply #20 on:** January 19, 2009, 05:56:07 am »

strange...
mine shows

points all (sorted by name)
name - points

points top (sorted by points)
# - name - points

I have never seen the id, or wether or not they are in the active raid. :S