collapse collapse
* User Info
 
 
Welcome, Guest. Please login or register.
* Search

* Board Stats
  • stats Total Members: 989
  • stats Total Posts: 18363
  • stats Total Topics: 2500
  • stats Total Categories: 7
  • stats Total Boards: 35
  • stats Most Online: 1144

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

0 Members and 1 Guest are viewing this topic.

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: Updated Points.php
« 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

Offline keirou

  • BeBot Apprentice
  • ***
  • Posts: 90
  • Karma: +0/-0
Re: Updated Points.php
« 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

Offline Allisande

  • BeBot User
  • **
  • Posts: 68
  • Karma: +0/-0
Re: Updated Points.php
« 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

Offline keirou

  • BeBot Apprentice
  • ***
  • Posts: 90
  • Karma: +0/-0
Re: Updated Points.php
« 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.

Offline Allisande

  • BeBot User
  • **
  • Posts: 68
  • Karma: +0/-0
Re: Updated Points.php
« 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

Offline keirou

  • BeBot Apprentice
  • ***
  • Posts: 90
  • Karma: +0/-0
Re: Updated Points.php
« 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

 

* Recent Posts
[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 pm]


0.8.x updates for AoC by bitnykk
[January 30, 2024, 11:16:08 pm]


0.8.x updates for AO by bitnykk
[January 30, 2024, 11:15:37 pm]


BeBot still alive & kicking ! by bitnykk
[December 17, 2023, 12:58:44 am]


Bebot and Rasberry by bitnykk
[November 29, 2023, 11:04:14 pm]

* Who's Online
  • Dot Guests: 506
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.
* Forum Staff
bitnykk admin bitnykk
Administrator
Khalem admin Khalem
Administrator
WeZoN gmod WeZoN
Global Moderator
SimplePortal 2.3.7 © 2008-2024, SimplePortal