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: !points  (Read 2830 times)

0 Members and 1 Guest are viewing this topic.

Offline Allisande

  • BeBot User
  • **
  • Posts: 68
  • Karma: +0/-0
!points
« on: December 24, 2008, 02:59:32 am »
How does the !points mod connect to the !raid mod?  Or is this something that doesnt happen?  Also the !points table doesnt seem to keep any points.  I have done !points give Allisande 5...it says i have recieved 5 points, but when i do !points all or !points top or just !points it tells me i have 0 points.

Offline Temar

  • Contributor
  • *******
  • Posts: 1140
  • Karma: +0/-0
    • AoFiles
Re: !points
« Reply #1 on: December 24, 2008, 06:42:05 am »
it could be a mysql error, check your Log,
Raid module adds the points directly too, so same as before a mysql can cause problem there too

Offline Allisande

  • BeBot User
  • **
  • Posts: 68
  • Karma: +0/-0
Re: !points
« Reply #2 on: December 24, 2008, 07:55:53 am »
The only errors I'm see are:

1)  MySQL error(# 0) on query: insert into bots)log (bot, dim, start, end) values ('dogsoldier', 'thog', 1230067190, 1230101228)

2)  Incorrect interger value: 'thog' for column 'dim' at row 1

and I think they are part of the same error.  I'm not real sure what 'log' you are referring to, but I checked my bebot\log files and I don't see what is taking place.

Could I delete those tables and see if the bot will recreate them correctly?

Offline Allisande

  • BeBot User
  • **
  • Posts: 68
  • Karma: +0/-0
Re: !points
« Reply #3 on: December 27, 2008, 12:37:31 am »
Ok I got it working by just deleting the table.  I think what happened is that I had this mod and Alreadythere's mod trying to work together.  But now that I figured this out I was wondering if the !bid module works with the !points module without too much playing around.  If it does I was wondering if someone could help me modify the !bid module to do the following.

1.  The raid leader opens the bidding by saying something like !bid open 30 (where 30 is the cost of the item).
2.  Instead of Bidding the player sends the bot a tell putting in his/her name saying that they would like the item.
3.  The bot then checks the players points and the person with the highest DKP would then win the item.
4.  The bot would then deduct the amount of points the item costs (we have 6 different costs).
5.  The bot would then announce to the guild who won the item.

I can do all this on my own, but if this mod was capable of doing this that would rock.  And since I still haven't figured out how to do all that I would like on my own...I would really appreciate the help.

Offline bookie

  • BeBot Rookie
  • *
  • Posts: 3
  • Karma: +0/-0
Re: !points
« Reply #4 on: January 09, 2009, 06:26:44 pm »
MySQL error(# 0) on query: insert into bots)log (bot, dim, start, end) values ('dogsoldier', 'thog', 1230067190, 1230101228)

Im getting this same error. How do you get rid of it?

Offline Allisande

  • BeBot User
  • **
  • Posts: 68
  • Karma: +0/-0
Re: !points
« Reply #5 on: January 10, 2009, 01:55:12 am »
I went into my Dbase with Aqua Data Studio 7.0 - 64bit and deleted the points table and restarted the bot.  The bot then recreated the tables as needed and all is well.

 

* 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: 695
  • 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