MyBB Community Forums

This query might show the results more clearly - will show a count of rows by template name:

select title, count(*) as count from mybb_templates group by title order by count desc;

Can we see the first 20 or so rows from this?

(2021-11-29, 08:03 PM)Matt Wrote: [ -> ]This query might show the results more clearly - will show a count of rows by template name:

select title, count(*) as count from mybb_templates group by title order by count desc;

Can we see the first 20 or so rows from this?

Thank you for putting me in the right direction. After running this query I got this.




I saw that there are two titles which having huge number counts. Should I delete them or?

Waiting for your response.

Hm, can you run both of these:

select title, template from mybb_templates where title = 'ubh' limit 1;

select title, template from mybb_templates where title = 'err' limit 1;

Those aren't default templates so not sure where they've come from.

Is your forum darkforums.net?
I believe your database has been breached by some hacking forum, you should remove all plugins which are not from mybb.com as some plugin is compromising your site.

(2021-11-30, 02:38 PM)Matt Wrote: [ -> ]Hm, can you run both of these:

select title, template from mybb_templates where title = 'ubh' limit 1;

select title, template from mybb_templates where title = 'err' limit 1;

Those aren't default templates so not sure where they've come from.

Here is the output of both:
http://prntscr.com/215htqo
http://prntscr.com/215hxix

I can't edit them, it says reached memory limit. Shall I delete both entries?

---

(2021-11-30, 09:03 PM)codedude Wrote: [ -> ]Is your forum darkforums.net?
I believe your database has been breached by some hacking forum, you should remove all plugins which are not from mybb.com as some plugin is compromising your site.

Thanks for your suggestion, I will try to disable all third-party plugins and check it and update you asap.

---

please help me guys