collapse collapse
Menu
  • Home
  • Archives
    • * User Info
     
     
    Welcome, Guest. Please login or register.
    * Search

    * Board Stats
    • stats Total Members: 989
    • stats Total Posts: 18363
    • stats Total Topics: 2500
    • stats Total Categories: 7
    • stats Total Boards: 35
    • stats Most Online: 1144
    « previous next »
    Pages: 1 [2] 3 4 5   Go Down

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

    0 Members and 1 Guest are viewing this topic.

    Offline Alreadythere

    • BeBot Maintainer
    • BeBot Hero
    • ******
    • Posts: 1288
    • Karma: +0/-0
    Re: sql symbiants/pbs
    « Reply #15 on: July 08, 2006, 10:49:27 am »
    Nice work :)
    Logged

    Offline jjones666

    • Contributor
    • *******
    • Posts: 353
    • Karma: +0/-0
    Re: sql symbiants/pbs
    « Reply #16 on: July 12, 2006, 10:57:16 pm »
    Updated again -

    - Added one more TNH drop.

    <link removed>
    up to 876 symbs in DB.
    « Last Edit: July 22, 2006, 12:44:12 pm by jjones666 »
    Logged

    Offline jjones666

    • Contributor
    • *******
    • Posts: 353
    • Karma: +0/-0
    Re: sql symbiants/pbs
    « Reply #17 on: July 22, 2006, 12:43:49 pm »
    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 24, 2006, 02:12:12 am by jjones666 »
    Logged

    Offline Khalem

    • BeBot Founder
    • Administrator
    • ********
    • Posts: 1169
    • Karma: +0/-0
      • http://www.ancarim.com
    Re: sql symbiants/pbs
    « Reply #18 on: July 23, 2006, 07:38:35 am »
    Awesome work JJ :)
    Logged
    BeBot Founder and Fixer Kingpin

    Offline Wolfbiter

    • Contributor
    • *******
    • Posts: 149
    • Karma: +0/-0
      • KAZE
    Re: sql symbiants/pbs
    « Reply #19 on: July 23, 2006, 10:24:07 am »
    Updated first post with new .php and the latest .sql
    Logged
    Too many toons.

    Offline jjones666

    • Contributor
    • *******
    • Posts: 353
    • Karma: +0/-0
    Re: sql symbiants/pbs
    « Reply #20 on: July 24, 2006, 02:10:23 am »
    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, 04:57:03 pm by jjones666 »
    Logged

    Offline Wolfbiter

    • Contributor
    • *******
    • Posts: 149
    • Karma: +0/-0
      • KAZE
    Re: sql symbiants/pbs
    « Reply #21 on: July 24, 2006, 09:41:44 am »
    Another update
    Logged
    Too many toons.

    Offline Plac3bo

    • BeBot User
    • **
    • Posts: 50
    • Karma: +0/-0
    Re: sql symbiants/pbs
    « Reply #22 on: July 26, 2006, 09:50:53 am »
    managed to crash it on my 3rd command ;)

    !symb 260 support %

    not good :) infinate loop :)
    Logged

    Offline Wolfbiter

    • Contributor
    • *******
    • Posts: 149
    • Karma: +0/-0
      • KAZE
    Re: sql symbiants/pbs
    « Reply #23 on: July 26, 2006, 01:08:42 pm »
    Seems you're using an older version of bebot, without the multipage fix.
    See http://bebot.link/index.php/topic,234.0
    Logged
    Too many toons.

    Offline Alreadythere

    • BeBot Maintainer
    • BeBot Hero
    • ******
    • Posts: 1288
    • Karma: +0/-0
    Re: sql symbiants/pbs
    « Reply #24 on: July 26, 2006, 02:05:18 pm »
    Got one more drop for you:

    Alert Thigh Artillery of Devourer of Scheol QL 205
    Logged

    Offline Khalem

    • BeBot Founder
    • Administrator
    • ********
    • Posts: 1169
    • Karma: +0/-0
      • http://www.ancarim.com
    Re: sql symbiants/pbs
    « Reply #25 on: July 27, 2006, 05:30:24 am »
    Actually, that bug can still be triggered by very very long lines of text.
    Logged
    BeBot Founder and Fixer Kingpin

    Offline Wolfbiter

    • Contributor
    • *******
    • Posts: 149
    • Karma: +0/-0
      • KAZE
    Re: sql symbiants/pbs
    « Reply #26 on: July 27, 2006, 07:26:06 am »
    That too, but I tested the command on my own bot and it worked fine.
    Logged
    Too many toons.

    Offline jjones666

    • Contributor
    • *******
    • Posts: 353
    • Karma: +0/-0
    Re: sql symbiants/pbs
    « Reply #27 on: August 06, 2006, 04:56:06 pm »
    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

    Offline jjones666

    • Contributor
    • *******
    • Posts: 353
    • Karma: +0/-0
    Re: sql symbiants/pbs
    « Reply #28 on: August 26, 2006, 01:06:01 pm »
    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

    Offline Xenixa

    • Contributor
    • *******
    • Posts: 307
    • Karma: +0/-0
    Re: sql symbiants/pbs
    « Reply #29 on: September 15, 2006, 04:02:54 pm »
    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
    « previous next »
     
    * Recent Posts
    [AoC] special char for items module by bitnykk
    [February 09, 2024, 09:41:18 pm]
    0.8.x updates for AoC by bitnykk
    [January 30, 2024, 11:16:08 pm]
    0.8.x updates for AO by bitnykk
    [January 30, 2024, 11:15:37 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: 686
    • 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