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, 12:53:00 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 4 5   Go Down
« previous next »
Print
Author Topic: sql symbiants/pbs  (Read 8082 times)
0 Members and 1 Guest are viewing this topic.
Alreadythere
BeBot Maintainer
Administrator
Grandmaster
********
Offline Offline

Posts: 1077


Re: sql symbiants/pbs
« Reply #15 on: July 08, 2006, 03:49:27 AM »

Nice work Smiley
Logged
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: sql symbiants/pbs
« Reply #16 on: July 12, 2006, 03:57:16 PM »

Updated again -

- Added one more TNH drop.

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

Posts: 353


Re: sql symbiants/pbs
« Reply #17 on: July 22, 2006, 05:43:49 AM »

Updated again -

- Synced with Muhandes' thread on engie forums: http://forums.anarchy-online.com/showthread.php?t=421758 (thanks!)
- Merged the two SQL files together.
- Removed a couple of TNH/<255 boss duplicates.

<link removed>
up to 870 symbs in DB.

N.B. incorrect on AOPocket:
240 LHAND CONTROL is "Shake" not "Ushqa"
270 EAR CONTROL is "Ushqa" not "Shake"
270 RARM CONTROL is "Ushqa" not "Shake"
« Last Edit: July 23, 2006, 07:12:12 PM by jjones666 » Logged
Khalem
BeBot Founder
Administrator
Grandmaster
********
Offline Offline

Gender: Male
Posts: 670



WWW
Re: sql symbiants/pbs
« Reply #18 on: July 23, 2006, 12:38:35 AM »

Awesome work JJ Smiley
Logged

BeBot Founder and Fixer Kingpin
Madman coder and destroyer of good code
Wolfbiter
BeBot Contributor
Apprentice
*******
Offline Offline

Posts: 141



WWW
Re: sql symbiants/pbs
« Reply #19 on: July 23, 2006, 03:24:07 AM »

Updated first post with new .php and the latest .sql
Logged

220 Doctor | 220 Adventurer | 220 Shade
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: sql symbiants/pbs
« Reply #20 on: July 23, 2006, 07:10:23 PM »

Updated again -

- Added two more TNH drops (one from me, the other from Borealis).
- Merged pocketbosses.sql files together (can you update main post pls Wolfbiter as this is also needed).

http://www.jjones.co.uk/files/pocketbosses.sql
http://www.jjones.co.uk/files/symbiants.sql
up to 872 symbs in DB.

N.B. now only missing 100% confirmation on:
QL 270 Cognizant Waist Symbiant, Control Unit Aban*
QL 290 Conscious Ocular Symbiant, Extermination Unit Aban

* I added under Tailee Frees for the time being as this is the boss we think drops it.  Was confirmed by Ulna to drop from "Clan Inf Key" PB.
« Last Edit: August 06, 2006, 09:57:03 AM by jjones666 » Logged
Wolfbiter
BeBot Contributor
Apprentice
*******
Offline Offline

Posts: 141



WWW
Re: sql symbiants/pbs
« Reply #21 on: July 24, 2006, 02:41:44 AM »

Another update
Logged

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

Gender: Male
Posts: 50



Re: sql symbiants/pbs
« Reply #22 on: July 26, 2006, 02:50:53 AM »

managed to crash it on my 3rd command Wink

!symb 260 support %

not good Smiley infinate loop Smiley
Logged
Wolfbiter
BeBot Contributor
Apprentice
*******
Offline Offline

Posts: 141



WWW
Re: sql symbiants/pbs
« Reply #23 on: July 26, 2006, 06:08:42 AM »

Seems you're using an older version of bebot, without the multipage fix.
See http://bebot.shadow-realm.org/index.php/topic,234.0
Logged

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

Posts: 1077


Re: sql symbiants/pbs
« Reply #24 on: July 26, 2006, 07:05:18 AM »

Got one more drop for you:

Alert Thigh Artillery of Devourer of Scheol QL 205
Logged
Khalem
BeBot Founder
Administrator
Grandmaster
********
Offline Offline

Gender: Male
Posts: 670



WWW
Re: sql symbiants/pbs
« Reply #25 on: July 26, 2006, 10:30:24 PM »

Actually, that bug can still be triggered by very very long lines of text.
Logged

BeBot Founder and Fixer Kingpin
Madman coder and destroyer of good code
Wolfbiter
BeBot Contributor
Apprentice
*******
Offline Offline

Posts: 141



WWW
Re: sql symbiants/pbs
« Reply #26 on: July 27, 2006, 12:26:06 AM »

That too, but I tested the command on my own bot and it worked fine.
Logged

220 Doctor | 220 Adventurer | 220 Shade
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: sql symbiants/pbs
« Reply #27 on: August 06, 2006, 09:56:06 AM »

Updated again -

- Added one more TNH drop.
- Added information from Alreadythere and removed symb from TNH drop (thanks!)

http://www.jjones.co.uk/files/symbiants.sql
up to 873 symbs in DB.
Logged
jjones666
BeBot Contributor
Champion
*******
Offline Offline

Posts: 353


Re: sql symbiants/pbs
« Reply #28 on: August 26, 2006, 06:06:01 AM »

Updated again -

- Added final TNH drop.

http://www.jjones.co.uk/files/symbiants.sql
up to 874 symbs in DB.

Apart from undiscovered symbs dropping from PB's - sql is 100% - unless i missed a few out :-)

N.B. now only missing 100% confirmation on:
QL 270 Cognizant Waist Symbiant, Control Unit Aban*

* I added under Tailee Frees for the time being as this is the boss we think drops it.  Was confirmed by Ulna to drop from "Clan Inf Key" PB.
Logged
Xenixa
BeBot Contributor
Expert
*******
Offline Offline

Posts: 307



Re: sql symbiants/pbs
« Reply #29 on: September 15, 2006, 09:02:54 AM »

A suggestion for the .SQL files when you post new ones with updated info.

Change the INSERT INTO statements to REPLACE INTO. So when updates are put out you don't get loads of errors if you forget to drop the table first. REPLACE INTO compares current records and only updates rows that changed or are new. REPLACE INTO acts just like INSERT INTO if it's a new row of data(record).
Logged

<<< Hack's in Zend Studio

All my Custom Bebot files may be Found Here <-clicky
Pages: 1 [2] 3 4 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: 1
Guests: 14
Total: 15
xlDanek

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