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?
November 22, 2008, 01:12:41 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: sql symbiants/pbs
Pages: [1] 2 3 ... 5   Go Down
« previous next »
Print
Author Topic: sql symbiants/pbs  (Read 8083 times)
0 Members and 1 Guest are viewing this topic.
Wolfbiter
BeBot Contributor
Apprentice
*******
Offline Offline

Posts: 141



WWW
sql symbiants/pbs
« on: January 23, 2006, 10:24:23 PM »

There was a post here somewhere (that I can't find) with a sql-based symb/pb script... if anyone is using it I've written a better .php for it.
Just load it and use "!symb bla" for a little help on how to use it.

2007-02-05
Now the script tries to match the input for bosses if there's no match for a pocketboss.
ie: "!pb tuq'usk" will return Haqa
Wont work on all bosses, for example "Chimera Driver", because the db entry is "Chimera Mornitor/Trainer/Driver".

2006-12-19 Update
Did a lot of changes for the !symb script, some parts are not the best.. but I thought of them while I was coding so only made dirty fixes.
Now the search options are "smarter".
!symb 200-230 infantry
!symb 180-200 doctor
!symb doctor head chest
!symb infantry artil chest wrist larm
etc... apart from adding professional search option you can mix all possible search options.

Search options
# - specific ql
#-# - ql range
infantry/support/... etc (inf, arti etc also works as long as they don't match professional substring - art will match martial artist for example).
head/wrist/rwrist/lwrist/chest/etc..
growing/awakening/etc - matches symb name

Not tested everything too much, so feel free to report bugs.

2006-12-21 Update
Forgot to specify engineer types for "!symb engineer"

All .sql are kept up to date by JJ

symbpb.php UPDATED 2006-12-19
symbiants.sql UPDATED 2006-07-24
pocketbosses.sql UPDATE 2006-07-24
http://www.jjones.co.uk/files/symbiants.sql UPDATED 2007-01-16
« Last Edit: February 05, 2007, 12:02:08 AM by Wolfbiter » Logged

220 Doctor | 220 Adventurer | 220 Shade
Zacix
Rookie
**
Offline Offline

Posts: 72


Re: sql symbiants/pbs
« Reply #1 on: January 24, 2006, 06:13:03 AM »

Original thread...written by Derroylo, modfied by Alreadythere, extra info by jj666 and helpfiles by Wanuarmi.

Also, what's the improved part? Can't really see the difference except a little more extensive search in the database which I'm not sure is needed. You should also make it a bit easier to change colors, e.g. use a classvariable, botlevel colortags or _Colors.php instead of redeclaring colortags throughout the code. Anyway, keep up the good work Smiley

PS! Even though I don't develop anything for BeBot anymore and thereby don't really concerns me (I do however enjoy to keep track of the community), I think BeBot need some coding standards. Best example of the "problem" would be how colors are set. From what I can see 4 methods are used throughout the different modules...plain strings directly into code, classvariables, botlevel variables ($this->bot->tell_color) and global variables (_Colors.php). Think it's needless to say that changing color of the bot is a royal pain in the ass to say the least =P Personally I think _Colors.php is the best solution (hey...I wrote the first version of it Cheesy) and it shouldn't be too hard to customize and make work with the database. Guess it's up to Khalem and/or the community if they want to decide anything on this, but the way I see it, this community is growing a lot these days, and to prevent 2-3 "systems" on each feature, ease code readability etc etc, I think BeBot would benefit from this in the long run.

/runs back and hides
Logged

Zacix
Current projects:
RINGBot, BeBot branch
Neutnet, RK2 Neutral massmessage network
Nogoal
Rookie
**
Offline Offline

Posts: 61


Re: sql symbiants/pbs
« Reply #2 on: January 24, 2006, 09:53:40 AM »

I like to have the same colors in all bot msgs and so you don't need to modify each script. Oh and most BeBot scripts work under RINGbot with minor modifications and you're active on this forums so I guess you're a member of this community ; ).
Logged
Wolfbiter
BeBot Contributor
Apprentice
*******
Offline Offline

Posts: 141



WWW
Re: sql symbiants/pbs
« Reply #3 on: January 25, 2006, 08:06:57 AM »

The improved part is exactly the search possiblities. I know I prepfer being able to limit the output to just ql200-240 and such instead of having to view all.
And I do have a bad habit of coding for my use only, with hardcoded colors and such.

And the url you posted was not the original code. This uses a mysql database, whoever I got this from probably used that as a base thou. The place I got it from had one .sql for symbs and one for pbs, and not one files as Xenixa's mod.
« Last Edit: January 25, 2006, 08:11:05 AM by Wolfbiter » Logged

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

Posts: 1077


Re: sql symbiants/pbs
« Reply #4 on: January 25, 2006, 08:35:18 AM »

Check my post on the second page, I posted a setup like that there, as I'm using it myself.

Got to test your search abilities some day, I tend to be lazy, so I only got one type of search right now Smiley
Logged
Wolfbiter
BeBot Contributor
Apprentice
*******
Offline Offline

Posts: 141



WWW
Re: sql symbiants/pbs
« Reply #5 on: January 25, 2006, 11:15:58 AM »

There it is, it's your script I wrote mine from (too lazy to rewrite some code, using your sql files).
Logged

220 Doctor | 220 Adventurer | 220 Shade
Zacix
Rookie
**
Offline Offline

Posts: 72


Re: sql symbiants/pbs
« Reply #6 on: January 25, 2006, 11:50:10 AM »

Quote from: Wolfbiter on January 25, 2006, 08:06:57 AM
The improved part is exactly the search possiblities. I know I prepfer being able to limit the output to just ql200-240 and such instead of having to view all.
And I do have a bad habit of coding for my use only, with hardcoded colors and such.

Indeed a nice addition to the module.

On the other part, code standards and such, you're of course entitled to do whatever you want. Hell, I'm like that myself. My point was not really directly aimed at you, but rather on BeBot community itself. Guess it was a less successful attempt at hijacking the thread/start a discussion about standards. As you pointed out, this is a nice addition to the module, and should probably be included in the main branch of BeBot (at least I'd like to see that). Problem is that it will need some rewriting because in the end we want colors to be set globally. I'm not sure who has access to SVN, but it will be a lot of double work for the ones that have to do it. Since it's no real standard for it, code contributors will use whatever suits them best, and they are completely entitled to no matter what, but it does create a fair amount of extra work to get it into BeBot branch. I just think that it would benefit all parts with some rules that people can comply to...at least in regards to workload, codestability, more features and easier development.

Think I'm done now =P
Logged

Zacix
Current projects:
RINGBot, BeBot branch
Neutnet, RK2 Neutral massmessage network
Shelly
Freshman
*
Offline Offline

Posts: 11


Re: sql symbiants/pbs
« Reply #7 on: May 09, 2006, 12:17:01 PM »

Looks like your original SQL code is mentioned in this thread http://bebot.shadow-realm.org/index.php/topic,148.msg1332.html#msg1332

I did some searching to find it so I could use it too.
Logged
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: sql symbiants/pbs
« Reply #8 on: June 06, 2006, 06:23:08 AM »

Finally got round to trying this - very nice indeed!

Here are the updates which for the PB's and symbs which are missing from AOPocket (so far):

<links removed>

Cheers,

-jj-
« Last Edit: July 23, 2006, 07:11:22 PM by jjones666 » Logged
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: sql symbiants/pbs
« Reply #9 on: June 19, 2006, 08:04:20 PM »

Currently adding all the confirmed TNH drop symbs to our org database.  As I'm collecting the symbs, can confirm 100% which ones drop ;-)

Will post SQL as soon as complete.

Cheers,

-jj-
Logged
Malosar
Expert
*****
Offline Offline

Posts: 259


WWW
Re: sql symbiants/pbs
« Reply #10 on: June 20, 2006, 08:23:28 AM »

Quote from: jj666 on June 19, 2006, 08:04:20 PM
Currently adding all the confirmed TNH drop symbs to our org database.  As I'm collecting the symbs, can confirm 100% which ones drop ;-)

Will post SQL as soon as complete.

Cheers,

-jj-

Very nice, that would be awesome data to include Smiley
Logged

Eternalist
General of The Syndicate
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: sql symbiants/pbs
« Reply #11 on: June 29, 2006, 01:41:44 PM »

<link removed>

here is the WIP sql - i seem to be added one or two every couple of days, so will post updates as frequently as I can.  remember these are confirmed drops, may be missing a few still.

enjoy!

cheers,

-jj-

p.s. i didn't add any that didn't already drop somewhere else Smiley
« Last Edit: July 05, 2006, 01:22:39 AM by jjones666 » Logged
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: sql symbiants/pbs
« Reply #12 on: July 05, 2006, 01:25:33 AM »

<link removed>
up to 851 symbs in DB.

I added a few more TNH drops and also duplicated a few entries where the pocketboss dropping symb was QL255 and symbs were also in TNH loot table.

Merged all my additions into one file.

Cheers,

-jj-

« Last Edit: July 22, 2006, 05:45:20 AM by jjones666 » Logged
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: sql symbiants/pbs
« Reply #13 on: July 06, 2006, 12:55:56 AM »

Updated again -

- Synced with AOpocket 020606, 220506 updates (and removed references to TNH dropping symbs on those additions as all <ql255 bosses).
- Added three more TNH only drops.

<link removed>
up to 856 symbs in DB.
« Last Edit: July 22, 2006, 05:45:07 AM by jjones666 » Logged
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: sql symbiants/pbs
« Reply #14 on: July 07, 2006, 12:43:46 PM »

Updated again -

- Synced with Borealis' confirmed drops 250606: http://home.no/aofun/docs/TNH-symbiants_all.htm (thanks!)

<link removed>
up to 875 symbs in DB.
« Last Edit: July 22, 2006, 05:44:31 AM by jjones666 » Logged
Pages: [1] 2 3 ... 5   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: sql symbiants/pbs
« previous next »
 
Jump to:  

Recent
Change text in remember "...
by gerborg
[November 21, 2008, 05:14:57 PM]

Log playtime from buddys ...
by Temar
[November 20, 2008, 10:33:57 AM]

Vote Core module and Simp...
by Temar
[November 19, 2008, 09:26:52 AM]

Restrict access for one m...
by Organizer
[November 19, 2008, 03:21:19 AM]

Custom / Revised Modules ...
by Elesar1
[November 17, 2008, 03:51:46 PM]

TWC
by Temar
[November 16, 2008, 11:39:12 AM]

Are there any FUN modules...
by Elesar1
[November 15, 2008, 07:39:15 PM]

Call to a member function...
by exxie
[November 15, 2008, 09:29:31 AM]

Ported Modules
by Alreadythere
[November 14, 2008, 06:10:07 PM]

cURL and other non-defaul...
by Temar
[November 14, 2008, 04:11:44 PM]
Stats
Members
Total Members: 1235
Latest: DDDepressionnn
Stats
Total Posts: 11037
Total Topics: 1496
Online Today: 18
Online Ever: 168
(July 01, 2007, 09:30:02 PM)
Users Online
Users: 0
Guests: 15
Total: 15

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.251 seconds with 29 queries. (Pretty URLs adds 0.045s, 4q)
Loading...