2014-02-26, 05:16 AM
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...
Posting it here because it might get useful for someone in the upcoming years if not mybb stop doing it this way.
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.