1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Delete all smilies at once?

Discussion in 'XenForo Questions and Support' started by oman, Apr 3, 2013.

  1. oman

    oman Well-Known Member

    Not sure if I asked this one before, but what is the best way to bulk delete smilies from the Admin CP?
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Run this query on the db:

    Code:
    TRUNCATE TABLE xf_smilie;
    
    Then edit/save or add/delete a smilie in the Admin CP to prompt a rebuild of the cache.
     
    oman likes this.
  3. DRE

    DRE Well-Known Member

    How do you delete more than one smiley at a time?
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Use the above query?
     
  5. DRE

    DRE Well-Known Member

    Not all of em lol
     
  6. Jeremy

    Jeremy XenForo Moderator Staff Member

    You'll have to manually construct a query that'll delete it based on IDs. Its most likely easier to delete manually.
     
  7. LuvMeSumZen

    LuvMeSumZen Active Member

    We really need a way to mass delete smilies in the ACP. I deleted the file from the DB but I am having to indivdually delete nearly 150 smilies one by one - taking 4ever. :rolleyes:
     
    Klaudius likes this.
  8. Jeremy

    Jeremy XenForo Moderator Staff Member

    Are you deleting them all? Jake posted a solution:
     
  9. LuvMeSumZen

    LuvMeSumZen Active Member

    I must not've done it right Jeremy - will try again next time around. Thx.
     
  10. oman

    oman Well-Known Member

    Jake's solution works well.
     
  11. rafass

    rafass Well-Known Member

    Would be great improve this in the future.
    The options to handle the smilies are very poor.
     
    EBOC and Arno Nühm like this.
  12. Steve Brewer

    Steve Brewer Member

    I'm sure they'll update this in the future, but in the meantime:

    1. Use phpmyadmin
    2. Go to the xf_smilies table
    3. Press browse to show the data, rather than structure
    4. At the bottom of the page set it to display more than 30 rows if needed
    5. Shift and tick to select multiple rows at once
    6. Press the delete button at the bottom.
    There may be a maximum number of rows you can select at once, so if it looks like it hasn't ticked all rows in your range, it will have selected as many as it can, so just delete and repeat.
     
    Last edited: Aug 22, 2015

Share This Page