L* R*
HOME FORUM DOWNLOADS
Content
  Links
     Browse SVN
     SVN Commit log
     Documentation (Wiki)
  Developers
     Taskmanager
User
Welcome, Guest. Please login or register.
Did you miss your activation email?
December 04, 2008, 01:52:49 PM

Login with username, password and session length
Search



Advanced search
Support GoPHP5.org
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Modules > Modules for older versions > 0.2.x Custom/Unofficial Modules > Topic: Level - but sqlbased
Pages: [1] 2   Go Down
« previous next »
Print
Author Topic: Level - but sqlbased  (Read 2193 times)
0 Members and 1 Guest are viewing this topic.
Wolfbiter
BeBot Contributor
Apprentice
*******
Offline Offline

Posts: 141



WWW
Level - but sqlbased
« on: December 06, 2006, 09:25:37 PM »

Updated 2006-12-14

Wrote this script because it's better to have each level # accessible from a main location that have it all hardcoded in a prepared string.
It'll also make it easier to change the ranges later on if FC changes anything.

You'll need the colors module for this.

Commands
!mish/!mission # - List of all levels that can pull a ql # mission
!sk/xp #from [#to] - How much xp/sk is needed at level #to, or from #from to #to
!level/lvl #1 #2 ... #N - Info on each supplied level #
!axp #from [#to] - How much axp is needed at level #from, or #from to #to
!rp/research #from [#to] - How much research is needed at level #from, or #from to #to

AXP added by jjones
Added research points
« Last Edit: December 14, 2006, 10:11:31 AM by Wolfbiter » Logged

220 Doctor | 220 Adventurer | 220 Shade
Alreadythere
BeBot Maintainer
Administrator
Grandmaster
********
Offline Offline

Posts: 1088


Re: Level - but sqlbased
« Reply #1 on: December 07, 2006, 05:19:03 AM »

Uber, thanks. Saves me a lot of work!

Always wanted to do this, but never got around to it.
Logged
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: Level - but sqlbased
« Reply #2 on: December 07, 2006, 05:45:09 AM »

Yup, thanks Wolfbiter, most appreciated :-)

-jj-
Logged
nebhyper
Rookie
**
Offline Offline

Gender: Male
Posts: 62


Re: Level - but sqlbased
« Reply #3 on: December 07, 2006, 09:53:34 AM »

This is awesome and includes all but one thing I've been looking for except one thing!

AXP.


This great though! Thanks!
Logged

Siocuffin (Squad Commander of United Notum Federation)
alts: Nebhyper, Nebalmighty.
Naturalistic
BeBot Contributor
Experienced
*******
Offline Offline

Posts: 221


Re: Level - but sqlbased
« Reply #4 on: December 07, 2006, 11:18:13 AM »

There is an axp module floating around somewhere, or I can just post mine.

Just use the search Tongue
Logged

220/25 Eternalist Doctor
-----------------------------
Campalot Coding Co-ordinator and Super Admin
http://www.campalot.info/index.php
nebhyper
Rookie
**
Offline Offline

Gender: Male
Posts: 62


Re: Level - but sqlbased
« Reply #5 on: December 07, 2006, 01:18:17 PM »

Yep I'm using it too.


Guess I worded that wrong.  What I meant was everything I have been looking for in one file except AXP. 

But it looks like it would be easy enough to add a second table with AXP values and add additional code to handle calling up that table.

I'll work on it when I get a chance.
Logged

Siocuffin (Squad Commander of United Notum Federation)
alts: Nebhyper, Nebalmighty.
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: Level - but sqlbased
« Reply #6 on: December 08, 2006, 09:15:23 PM »

- added AI levels
- added processing of single level (!xp 219)

(i think Wolfbiter will curse me for awful coding style) :-/

helpfiles:
http://www.jjones.co.uk/files/mission.txt
http://www.jjones.co.uk/files/mish.txt
http://www.jjones.co.uk/files/sk.txt
http://www.jjones.co.uk/files/xp.txt
http://www.jjones.co.uk/files/axp.txt

revised sql:
http://www.jjones.co.uk/files/levels.sql

revised php:
http://www.jjones.co.uk/files/level.php

-jj-
Logged
Wolfbiter
BeBot Contributor
Apprentice
*******
Offline Offline

Posts: 141



WWW
Re: Level - but sqlbased
« Reply #7 on: December 08, 2006, 11:30:47 PM »

Well, not bad.. but I think I'll work on my own little version of !axp and single !xp/sk tomorrow, way too late now Wink
Logged

220 Doctor | 220 Adventurer | 220 Shade
Wolfbiter
BeBot Contributor
Apprentice
*******
Offline Offline

Posts: 141



WWW
Re: Level - but sqlbased
« Reply #8 on: December 09, 2006, 09:49:47 AM »

You had a slight logical error for AXP in your script, jj (that had to do with ai level starting at 0, not 1)
Logged

220 Doctor | 220 Adventurer | 220 Shade
Galdethi
Freshman
*
Offline Offline

Posts: 9


Re: Level - but sqlbased
« Reply #9 on: December 13, 2006, 03:07:21 PM »

Just got this installed and its great, only thing is it only works for me in tells, any way to make it work in guild channel?

{edit} Installing this and the colours to use it has disabled my bot from responding to anything not in a tell, any ideas why?
« Last Edit: December 13, 2006, 03:59:41 PM by Galdethi » Logged
Wolfbiter
BeBot Contributor
Apprentice
*******
Offline Offline

Posts: 141



WWW
Re: Level - but sqlbased
« Reply #10 on: December 13, 2006, 05:08:13 PM »

Well.. maybe if you include some info on what bot you run (version.. I don't want to see something along the lines of "duh.. I run bebot of course"), other custom scripts installed, etc...
Logged

220 Doctor | 220 Adventurer | 220 Shade
Galdethi
Freshman
*
Offline Offline

Posts: 9


Re: Level - but sqlbased
« Reply #11 on: December 13, 2006, 11:24:59 PM »

[edit] nm found the problem, slight typo in a file was messing everything up
« Last Edit: December 14, 2006, 12:06:31 AM by Galdethi » Logged
Malosar
Expert
*****
Offline Offline

Posts: 259


WWW
Re: Level - but sqlbased
« Reply #12 on: December 15, 2006, 12:04:27 PM »

Thanks for the research update.
Logged

Eternalist
General of The Syndicate
Malosar
Expert
*****
Offline Offline

Posts: 259


WWW
Re: Level - but sqlbased
« Reply #13 on: December 19, 2006, 01:05:22 PM »

btw, the last 2 values for rp are wrong. They should be 640,000,000 and 900,000,000. You have 64,000,000 and 90,000,000.
Logged

Eternalist
General of The Syndicate
Wolfbiter
BeBot Contributor
Apprentice
*******
Offline Offline

Posts: 141



WWW
Re: Level - but sqlbased
« Reply #14 on: December 19, 2006, 04:53:46 PM »

The tables aren't verified at all.. nor do they reflect sk needed... I might work on sk tables and updated xp later on when there's something solid to work with, but right now it's just too damn boring to get reliable (ie capping things myself) data.
Logged

220 Doctor | 220 Adventurer | 220 Shade
Pages: [1] 2   Go Up
Print
BeBot - An Anarchy Online/Age Of Conan chat automaton > Forum > Modules > Modules for older versions > 0.2.x Custom/Unofficial Modules > Topic: Level - but sqlbased
« previous next »
 
Jump to:  

Recent
Bot not working after tod...
by Alreadythere
[Today at 01:04:41 PM]

Tokens Calulator
by Temar
[December 03, 2008, 01:09:03 PM]

Bebot does not work with ...
by IKShadow
[December 03, 2008, 08:54:04 AM]

!items database
by Temar
[December 03, 2008, 07:27:59 AM]

massive_pvp_time_table 1
by Sudoka
[December 03, 2008, 06:49:07 AM]

Log playtime from buddys ...
by IKShadow
[December 02, 2008, 06:48:12 AM]

[request] Raid timers
by Elesar1
[December 01, 2008, 04:41:09 PM]

Shared DB online list
by Temar
[December 01, 2008, 01:55:47 AM]

relay colors
by Temar
[December 01, 2008, 01:54:56 AM]

BeBot v0.6.0 released
by Alreadythere
[November 30, 2008, 05:32:00 PM]
Stats
Members
Total Members: 1246
Latest: Vingus
Stats
Total Posts: 11190
Total Topics: 1507
Online Today: 21
Online Ever: 168
(July 01, 2007, 09:30:02 PM)
Users Online
Users: 3
Guests: 18
Total: 21
vikor
clashbot

Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
TinyPortal v0.9.8 © Bloc | NewDef design by Bloc
Page created in 0.386 seconds with 28 queries. (Pretty URLs adds 0.042s, 4q)
Loading...