Author Topic: Forum moving to new host. Downtime expected!  (Read 10218 times)

0 Members and 1 Guest are viewing this topic.

Offline Shadow

  • Former Moderator
  • *
  • Posts: 8314
  • Decorated Soldier, Validated Commander, GHTG
    • View Profile
  • Nick: Shadow
  • Side: Confederacy
Re: Forum moving to new host. Downtime expected!
« Reply #60 on: February 26, 2018, 11:23:41 pm »
I ran a recount of all posters posts on the forum.. i guess some things got counted badly up before and now got properly redone..

 :'(
FSE Head Moderator, Feb 2018 - Apr 2022
FSE Community Moderator, Oct 2015 - Feb 2018

FSE Discord Moderator, Dec 2018 - Present

Former Leutnant 19te Prussian Infantry || Feel free to contact me on Steam here

Join the FSE Discord here!

Offline Vincenzo

  • Flying Squirrel Dev
  • FSE Developer
  • ****
  • Posts: 2352
  • Dutchman living in Allenstein, Ostpreußen.
    • View Profile
    • Flying Squirrel Entertainment
  • Nick: FSE_Vincenzo
  • Side: Union
Re: Forum moving to new host. Downtime expected!
« Reply #61 on: February 26, 2018, 11:30:50 pm »
I checked the query that the mod is doing.. it should be correct..
Code
SELECT m.id_member, COUNT(m.id_member) AS posts
FROM smf_messages AS m
LEFT JOIN smf_boards AS b
ON m.id_board = b.id_board
WHERE m.id_member != 0
AND b.count_posts = 0
GROUP BY m.id_member