Skyblock Purge 0-stock shops from the '/shops find' listings

Discussion in 'Server Gameplay Suggestions' started by MathEquation, Dec 7, 2024.

  1. MathEquation
    Offline

    MathEquation Member

    Joined:
    Oct 19, 2024
    Messages:
    17
    There are still numerous shop listings for items with 0-stock shops. Embedded below are 2 examples of '/shops find owned bone_block', i hear the highscore for other items is even higher :) I remember seeing one with 687 or something days the other day, just can't remember which item it was.

    shops-find-wanted-bone_block.png

    I'm unsure about how shops work on Eco which is why i tagged this with Skyblock only.
     
    • Support Support x 2
    Last edited: Dec 7, 2024
  2. Kittykat713
    Offline

    Kittykat713 Active Member

    Joined:
    Feb 25, 2023
    Messages:
    227
    IGN:
    Kittykat713
    Eco is the same, I will officially request this fix for eco as well please.
     
  3. Timmut
    Offline

    Timmut Experienced Member

    Joined:
    Dec 30, 2012
    Messages:
    281
    IGN:
    BigChiefTim
    i think shops that havent been checked since before a shop update still show up even if they have 0 transactions left. hopefully noobcrew will change this but i think we are all used to the way it goes at this point.
     
  4. Pillow
    Offline

    Pillow blanky Premium

    Joined:
    May 27, 2019
    Messages:
    1,981
    IGN:
    Pilberry
    Would be a very easy fix - probably just one sql query mid-restart.
    Code:
    DELETE FROM shops WHERE transactions=0;
     
    • Agree Agree x 1
  5. Butter_
    Offline

    Butter_ Member

    Joined:
    Nov 30, 2024
    Messages:
    395
    IGN:
    itsbutter_
    I agree, also maybe removing shops with no trades/restocks for 365+ days?
     

Share This Page