Author Topic: sql symbiants/pbs (Read 20816 times)

Wolfbiter · « **on:** January 24, 2006, 04:24:23 am »

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

Zacix · « **Reply #1 on:** January 24, 2006, 12:13:03 pm »

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

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

) 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

Nogoal · « **Reply #2 on:** January 24, 2006, 03:53:40 pm »

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 ; ).

Wolfbiter · « **Reply #3 on:** January 25, 2006, 02:06:57 pm »

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.

Alreadythere · « **Reply #4 on:** January 25, 2006, 02:35:18 pm »

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

Wolfbiter · « **Reply #5 on:** January 25, 2006, 05:15:58 pm »

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

Zacix · « **Reply #6 on:** January 25, 2006, 05:50:10 pm »

Quote from: Wolfbiter on January 25, 2006, 02:06:57 pm

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

Shelly · « **Reply #7 on:** May 09, 2006, 07:17:01 pm »

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

I did some searching to find it so I could use it too.

jjones666 · « **Reply #8 on:** June 06, 2006, 01:23:08 pm »

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-

jjones666 · « **Reply #9 on:** June 20, 2006, 03:04:20 am »

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-

Malosar · « **Reply #10 on:** June 20, 2006, 03:23:28 pm »

Quote from: jj666 on June 20, 2006, 03:04:20 am

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

jjones666 · « **Reply #11 on:** June 29, 2006, 08:41:44 pm »

jjones666 · « **Reply #12 on:** July 05, 2006, 08:25:33 am »

jjones666 · « **Reply #13 on:** July 06, 2006, 07: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.

jjones666 · « **Reply #14 on:** July 07, 2006, 07: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.

Author Topic: sql symbiants/pbs (Read 20816 times)

Wolfbiter

sql symbiants/pbs

Zacix

Re: sql symbiants/pbs

Nogoal

Re: sql symbiants/pbs

Wolfbiter

Re: sql symbiants/pbs

Alreadythere

Re: sql symbiants/pbs

Wolfbiter

Re: sql symbiants/pbs

Zacix

Re: sql symbiants/pbs

Shelly

Re: sql symbiants/pbs

jjones666

Re: sql symbiants/pbs

jjones666

Re: sql symbiants/pbs

Malosar

Re: sql symbiants/pbs

jjones666

Re: sql symbiants/pbs

jjones666

Re: sql symbiants/pbs

jjones666

Re: sql symbiants/pbs

jjones666

Re: sql symbiants/pbs