Page 1 of 2 12 LastLast
Results 1 to 20 of 23

Thread: I dare you to break it!

  1. #1

    I dare you to break it!

    www.beta.xyphos.com

    this is my "testlive" of my items database. sorry for the all green, but it's not ment to look pretty.

    anywho, I've updated the item search engine;

    and this time, I think I've solved my name indexing issues by using a very dirty work-around.

    basically, I've ditched the failed fulltext indexes and added 2 extra tables to reference each word in every item.

    I want you to test the modified search engine.
    the other features on beta have been disabled on purpose.

    search for items on the beta version and report anything about the search engine that you find wrong, or if it takes more then 2 seconds to yield results.

    if all works out, It'll hit the live version by next week, and CIDB will utilize it also when it goes live.


    EDIT:
    searching for "Might Rev" or "O.E.T. Co." works properly now.

    EDIT 2: CIDB isn't hooked into the beta, so searching on CIDB will still use the old borked live search engine until I know the beta engine works.
    (this is called prototyping.)
    Last edited by Xyphos; May 7th, 2010 at 20:49:17.
    "When life knocks you on your butt, you have to get back up and punch it in the face." --DJ Ashval of GSP

    Nullified "Bitbucket" Deadcode - 220/25 Neut NanoMage Engi
    Bits10 - 150/14 Clan Opifex Trader

  2. #2
    Very nice... No more green though, please
    Protektor- Engydoggy- Spydoggy- RealMadrid - Some others.
    Rolling around RK since Dec 2001.
    ¡Se habla español!

  3. #3
    Searching for "Envy of the Xan" tells me I have 8 weapon results, when only two (Envy of the Xan and its left-hand only mesh counterpart) exist in the list.

    All items searched give me a "SQL ERROR [ mysqli ]" error.
    [[ RYUAHN | 220/21 Opifex Trader
    == Proud Member of Core ==
    [[ ALASTROPHE | 220/15 Solitus Martial-Artist

    Quote Originally Posted by Raggy View Post
    There is literally nothing wrong with {Shutdown Skills} in it's current incarnation. What should be being looked at is the reason why it's needed so much. E.g, the incredible amount of Alpha being thrown around and the fickleness of Evade profs.
    Quote Originally Posted by Cratertina View Post
    I walk in to BS... could not perk people... with 3704 AR and 300 AAD drain... NT facerolled me, shade instagibbed me, after a few minutes I just decided not gonna bother.

  4. #4
    Congrats Saetos, You broke it!
    hm, odd bug but thankyou for reporting it
    "When life knocks you on your butt, you have to get back up and punch it in the face." --DJ Ashval of GSP

    Nullified "Bitbucket" Deadcode - 220/25 Neut NanoMage Engi
    Bits10 - 150/14 Clan Opifex Trader

  5. #5
    Quote Originally Posted by Xyphos View Post
    Congrats Saetos, You broke it!
    Yaaay!

    I might try to find more tomorrow, but quite frankly I got a lot to do tomorrow outside of AO so we'll see
    [[ RYUAHN | 220/21 Opifex Trader
    == Proud Member of Core ==
    [[ ALASTROPHE | 220/15 Solitus Martial-Artist

    Quote Originally Posted by Raggy View Post
    There is literally nothing wrong with {Shutdown Skills} in it's current incarnation. What should be being looked at is the reason why it's needed so much. E.g, the incredible amount of Alpha being thrown around and the fickleness of Evade profs.
    Quote Originally Posted by Cratertina View Post
    I walk in to BS... could not perk people... with 3704 AR and 300 AAD drain... NT facerolled me, shade instagibbed me, after a few minutes I just decided not gonna bother.

  6. #6
    Tried to create a faux character with the character thingymagig.
    General Error
    SQL ERROR [ mysqli ]

    Unknown column 'i.name' in 'field list' [1054]

    An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
    Kaelde ~ Gimpy engi of doom
    Ecrisi ~ Even gimpier than Kaelde

    Thingymawhat of Paragon

  7. #7
    I AM CAN BREAK?!11one
    VHAB SMASH!!
    Formerly Vhab.
    Once upon a time ruled a server. And then sold out. Sorry.

  8. #8
    Quote Originally Posted by CastarasOfPie View Post
    Tried to create a faux character with the character thingymagig.

    well thats cuz I updated the item search engine, not the character designer.
    says so in the OP.
    you're testing the wrong feature
    character designer is next to be updated, but only if I know that the item search works properly so I don't have to change the DB schema yet again
    (which is why i.name is missing)
    "When life knocks you on your butt, you have to get back up and punch it in the face." --DJ Ashval of GSP

    Nullified "Bitbucket" Deadcode - 220/25 Neut NanoMage Engi
    Bits10 - 150/14 Clan Opifex Trader

  9. #9
    Tried to search "piercing" and in the weapons pane it returned "Piercing Evil" in QL 259 and 220. QL260 is missing.
    Level 200 Nanomage Nano-Technician on Rimor speaking... - Unit Commander of Knights of Ka
    Toons:(*=froobs)
    Zzzzzzwap* (inofficial main),
    Krisplin* (main, but buff whore),
    Theophrastus* (piercing doc - aka froob shade)
    Kosminski (Shade - Yes, i went paid...)
    Codeleet (s10 & pvp)
    ~ Founder of TL5+ - Rimor TL5+ froob raid force ~ || ~ My Tweet... ~

  10. #10
    General Error
    SQL ERROR [ mysqli ]

    Unknown column 'name' in 'field list' [1054]

    An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
    while trying to get a profession nano list (shade, NT, ...)
    Level 200 Nanomage Nano-Technician on Rimor speaking... - Unit Commander of Knights of Ka
    Toons:(*=froobs)
    Zzzzzzwap* (inofficial main),
    Krisplin* (main, but buff whore),
    Theophrastus* (piercing doc - aka froob shade)
    Kosminski (Shade - Yes, i went paid...)
    Codeleet (s10 & pvp)
    ~ Founder of TL5+ - Rimor TL5+ froob raid force ~ || ~ My Tweet... ~

  11. #11
    Oh, perhaps you can take tlfiveplus.com into your link list? Its a froob raiding force on RK2
    Level 200 Nanomage Nano-Technician on Rimor speaking... - Unit Commander of Knights of Ka
    Toons:(*=froobs)
    Zzzzzzwap* (inofficial main),
    Krisplin* (main, but buff whore),
    Theophrastus* (piercing doc - aka froob shade)
    Kosminski (Shade - Yes, i went paid...)
    Codeleet (s10 & pvp)
    ~ Founder of TL5+ - Rimor TL5+ froob raid force ~ || ~ My Tweet... ~

  12. #12
    [Spartans] Voidraven: !items t dou sun
    [Spartans] Spartagc: CIDB Says: item name needs to be at least 4 LETTERS long.
    Darkempire 220/30/70 Agent
    {edited by Anarrina: see me if you have questions}
    When specifically asked for positive words, responding with a personal attack is incredibly rude and inappropriate. Please do not repeat such behavior.
    Quote Originally Posted by nums214 View Post
    If my wife never got preggo omni wouldn't have lost their fields. 2009 is pretty much when I quit.

  13. #13
    The search is working fine for me, but found this:

    http://www.beta.xyphos.com/ao/aodb.php?id=222695

    NanoCrystal(s):
    Lethargic Right Wrist Symbiant, Control Unit Aban
    Weird looking Cut Red Tape

    Some other nanos have weird crystal assosiations too (at least on nanos that "red tape" search returned)

  14. #14
    Quote Originally Posted by idefistooshort View Post
    The search is working fine for me, but found this:

    http://www.beta.xyphos.com/ao/aodb.php?id=222695

    NanoCrystal(s):
    Lethargic Right Wrist Symbiant, Control Unit Aban
    Weird looking Cut Red Tape

    Some other nanos have weird crystal assosiations too (at least on nanos that "red tape" search returned)
    hm, that seems to be a bug with my parsing tools, and quite an odd one at that... thanks.





    Quote Originally Posted by DocJones View Post
    Tried to search "piercing" and in the weapons pane it returned "Piercing Evil" in QL 259 and 220. QL260 is missing.
    220->259->260
    260 is missing from the search list, cuz it's the highest interpolation link, and highest interpolation links aren't shown on purpose to reduce the results shown.
    if anyone else has problems with this or think that highest interpolation links should be shown, then I'll disable that feature.
    but 260 isn't missing if you view the 259 version and move the QL slider far right.
    Last edited by Xyphos; May 7th, 2010 at 21:04:46.
    "When life knocks you on your butt, you have to get back up and punch it in the face." --DJ Ashval of GSP

    Nullified "Bitbucket" Deadcode - 220/25 Neut NanoMage Engi
    Bits10 - 150/14 Clan Opifex Trader

  15. #15
    Quote Originally Posted by Xyphos View Post
    hm, that seems to be a bug with my parsing tools, and quite an odd one at that... thanks.







    220->259->260
    260 is missing from the search list, cuz it's the highest interpolation link, and highest interpolation links aren't shown on purpose to reduce the results shown.
    if anyone else has problems with this or think that highest interpolation links should be shown, then I'll disable that feature.
    but 260 isn't missing if you view the 259 version and move the QL slider far right.
    Maybe display both the min and the max instead of just the min QL?
    Formerly Vhab.
    Once upon a time ruled a server. And then sold out. Sorry.

  16. #16
    http://www.beta.xyphos.com/ao/aodb.php?searchid=78

    Code:
    string(351) "
     SELECT i.type, 
    	COUNT(i.xid) AS count
     
     FROM (xaodb_items AS i)
    	 
    	 INNER JOIN (xaodb_info AS q) ON (q.xid = i.xid) 
    	 INNER JOIN (xaodb_subtext AS st) ON (i.xid = st.xid) 
    	 INNER JOIN (xaodb_nameindex AS ni) ON (ni.ft = st.ft)
    	 
    	 
     WHERE (i.sflags & 1) 
    	 AND (((ni.word LIKE 'GUNSHIP%')) AND (q.subname LIKE '%GUNSHIP%'))
     GROUP BY i.type 
    
    "
    "War may be Hell....but it's good for business!"
    -The Association for Merchants,Manufacturers, and Morticians

    [Kintaii]: Dude, I *am* weird
    [Kintaii]: I came to accept this many years ago and am much happier for it. XD
    [Kintaii]: Besides - I work on *AO*. That right there is proof of my oddness.

  17. #17
    aw crap.
    I forgot to remove a "trace dump / debug dump"
    fixed. sorry
    "When life knocks you on your butt, you have to get back up and punch it in the face." --DJ Ashval of GSP

    Nullified "Bitbucket" Deadcode - 220/25 Neut NanoMage Engi
    Bits10 - 150/14 Clan Opifex Trader

  18. #18

  19. #19
    Quote Originally Posted by ragerayden View Post
    All hail XY
    oh no, please don't.
    I'm an oddity.
    I enjoy helping others, and I enjoy sharing my works, but I hate being admired.
    "When life knocks you on your butt, you have to get back up and punch it in the face." --DJ Ashval of GSP

    Nullified "Bitbucket" Deadcode - 220/25 Neut NanoMage Engi
    Bits10 - 150/14 Clan Opifex Trader

  20. #20
    Code:
    Fatal error: Call to undefined method AODB_Lookups::perks() in 
    /home8/xyphosco/public_html/beta/ao/requires/aodb/aodb-item.php  on line 436
    When trying to look up bio shielding 7 via this link

    http://www.beta.xyphos.com/ao/aodb.php?id=211672

    which was generated by this search

    http://www.beta.xyphos.com/ao/aodb.php?searchid=300
    Nelle, RK2 Clan Keeper
    Triskweline, RK2 Clan NT
    Zubrus, Grumpy Old Crat

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •