Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Rebuilding polls votings
#1
This user has been denied support. This user has been denied support.
If you're like me who gets bombed by low end countries who gets paid to vote, welp deleting em isn't that simple if you like it clean.

So made this a quickly, yay for sql...

update mybb_polls set votes = (select group_concat(e separator '||~|~||') e FROM (SELECT COALESCE(count(vid),0) as e FROM `mybb_pollvotes` where pid = [Enter PID] group by voteoption, pid) q) where pid = [Enter PID]

Posting it here because it might get useful for someone in the upcoming years if not mybb stop doing it this way.
Beep Boop          
                                          ~ RIP Server 2014-2014
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)