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

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

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

0 Members and 4 Guests are viewing this topic.

Offline Wolfbiter

  • Contributor
  • *******
  • Posts: 149
  • Karma: +0/-0
    • KAZE
sql symbiants/pbs
« 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
« Last Edit: February 05, 2007, 06:02:08 am by Wolfbiter »
Too many toons.

Offline Zacix

  • Contributor
  • *******
  • Posts: 73
  • Karma: +0/-0
Re: sql symbiants/pbs
« 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 :D) 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
Zacix
Current projects:
RINGBot, BeBot branch
Neutnet, RK2 Neutral massmessage network

Offline Nogoal

  • BeBot Apprentice
  • ***
  • Posts: 77
  • Karma: +0/-0
Re: sql symbiants/pbs
« 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 ; ).

Offline Wolfbiter

  • Contributor
  • *******
  • Posts: 149
  • Karma: +0/-0
    • KAZE
Re: sql symbiants/pbs
« 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.
« Last Edit: January 25, 2006, 02:11:05 pm by Wolfbiter »
Too many toons.

Offline Alreadythere

  • BeBot Maintainer
  • BeBot Hero
  • ******
  • Posts: 1288
  • Karma: +0/-0
Re: sql symbiants/pbs
« 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 :)

Offline Wolfbiter

  • Contributor
  • *******
  • Posts: 149
  • Karma: +0/-0
    • KAZE
Re: sql symbiants/pbs
« 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).
Too many toons.

Offline Zacix

  • Contributor
  • *******
  • Posts: 73
  • Karma: +0/-0
Re: sql symbiants/pbs
« Reply #6 on: January 25, 2006, 05:50:10 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
Zacix
Current projects:
RINGBot, BeBot branch
Neutnet, RK2 Neutral massmessage network

Offline Shelly

  • BeBot Apprentice
  • ***
  • Posts: 192
  • Karma: +0/-0
Re: sql symbiants/pbs
« 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.

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: sql symbiants/pbs
« 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-
« Last Edit: July 24, 2006, 02:11:22 am by jjones666 »

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: sql symbiants/pbs
« 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-

Offline Malosar

  • BeBot Expert
  • ****
  • Posts: 259
  • Karma: +0/-0
    • http://www.lowerdimension.com
Re: sql symbiants/pbs
« Reply #10 on: June 20, 2006, 03:23:28 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 :)
Eternalist
General of The Syndicate

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: sql symbiants/pbs
« Reply #11 on: June 29, 2006, 08: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 :)
« Last Edit: July 05, 2006, 08:22:39 am by jjones666 »

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: sql symbiants/pbs
« Reply #12 on: July 05, 2006, 08: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, 12:45:20 pm by jjones666 »

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: sql symbiants/pbs
« 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.
« Last Edit: July 22, 2006, 12:45:07 pm by jjones666 »

Offline jjones666

  • Contributor
  • *******
  • Posts: 353
  • Karma: +0/-0
Re: sql symbiants/pbs
« 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.
« Last Edit: July 22, 2006, 12:44:31 pm by jjones666 »

 

* Recent Posts
0.8.x updates for AO by bitnykk
[June 23, 2024, 03:19:47 pm ]


0.8.x updates for AoC by bitnykk
[June 23, 2024, 03:19:44 pm ]


[AoC] special char for items module by bitnykk
[February 09, 2024, 09:41:18 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: 419
  • 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