PMx-Subforums v1.41 (updated 03 Jul 2013t)

RCC_SaMiaM · February 29, 2012, 04:13:13 PM

I have the sub forum domain pointing to an IP address, which is the same as the main forum, and on my panel have the sub forum aliased to the main forum domain name. Is this not the way I should do it?

RCC_SaMiaM · February 29, 2012, 04:20:05 PM

To make things simpler, here are the actual domains I am using.

http://www.moparnetwork.com is the main forum/domain. http://www.traildustercentral.com is the subforum/domain I want to use. I do not have a site setup for traildustercentral, just have it aliased to moparnetwork. If you access both you see the exact same site, I have traildustercentral set to a different theme and only one board but those settings are not being used, instead I see the same as the moparnetwork.

Can you please let me know what I need to do to make this work, I have been wanting to do something like this for a while and if I can get this to work it will be perfect

Thanks again for the help!

feline · February 29, 2012, 06:23:27 PM

What you have setup in the Subforums Manager?
The hostname for the subforums must be www.traildustercentral.com
And different themes works also .. see our demo site ...

RCC_SaMiaM · February 29, 2012, 10:18:01 PM

I have tried both www.traildustercentra.com and just traildustercentral.com, neither work.

feline · March 01, 2012, 07:04:22 AM

I don't know you hosting, so I can't say if this work on your hosting.
We have a dedicated server on 1und1 and all works perfect as you can see on our demo site ...

!RFAN · March 01, 2012, 07:56:37 AM

i'm using tiny portal and pretty url.. can i use this mod?

RCC_SaMiaM · March 01, 2012, 08:58:43 AM

Quote from: feline on March 01, 2012, 07:04:22 AM
I don't know you hosting, so I can't say if this work on your hosting.
We have a dedicated server on 1und1 and all works perfect as you can see on our demo site ...

I have a dedicated server with softlayer so I can set it up anyway I want. I am using a Plesk control panel. I do know for a fact I the aliasing works otherwise traildustercentral wouldn't show moparnetwork.

feline · March 01, 2012, 02:41:14 PM

Quote from: !RFAN on March 01, 2012, 07:56:37 AM
i'm using tiny portal and pretty url.. can i use this mod?

I can nothing say about prettyurls, that you have to test that or call the author.
TinyPortal should work (I think

)

RCC_SaMiaM · March 01, 2012, 02:43:02 PM

I have pretty urls, maybe that is why it doesn't work? Does the mod detect which forum to display from strings in the URL? Or does it by the domain or sub domain?

feline · March 01, 2012, 02:43:32 PM

Quote from: RCC_SaMiaM on March 01, 2012, 08:58:43 AM
I have a dedicated server with softlayer so I can set it up anyway I want. I am using a Plesk control panel. I do know for a fact I the aliasing works otherwise traildustercentral wouldn't show moparnetwork.

Is the domain traildustercentral show on Domain in Plesk ?
Or is this only show in Alias domains ?

RCC_SaMiaM · March 01, 2012, 02:46:11 PM

only as an aliased domain, there is no entry for it as a website.

feline · March 01, 2012, 02:49:08 PM

Quote from: RCC_SaMiaM on March 01, 2012, 02:43:02 PM
Does the mod detect which forum to display from strings in the URL? Or does it by the domain or sub domain?

To detect the domain, we use $_SERVER['SERVER_NAME']

RCC_SaMiaM · March 01, 2012, 02:50:51 PM

I will echo that and see what it is showing. Thanks.

RCC_SaMiaM · March 01, 2012, 02:57:30 PM

it is reading it correctly, if I log into www.traildustercentral.com and view the admin panel for the sub forums, it has a green check next to www.traildustercentral.com.

luuuciano · March 05, 2012, 11:13:40 AM

Hi Feline!

Im trying pmxsubforums on a new installed smf, just installed pmxsubforums... but used all the database information from another working SMF forum

PMXsubforums seems to work... but allmost all the time when switching between forums (domains), mysqld keeps eating 100% cpu for 1 or 2 minutes, then something happens and it shows the information...

I have tried to find a way to see what is happening on mysqld on those moments, and have found this:

Quote2012-02-4 11:31:58.275649|10566|dbusername|localhost|dbname|Query|0|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:31:58.776285|10566|dbusername|localhost|dbname|Query|0|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:31:59.276955|10566|dbusername|localhost|dbname|Query|1|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:31:59.777577|10566|dbusername|localhost|dbname|Query|1|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:00.278240|10566|dbusername|localhost|dbname|Query|2|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:00.778970|10566|dbusername|localhost|dbname|Query|2|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:01.279612|10566|dbusername|localhost|dbname|Query|3|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:01.780256|10566|dbusername|localhost|dbname|Query|3|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:02.280958|10566|dbusername|localhost|dbname|Query|4|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:02.781612|10566|dbusername|localhost|dbname|Query|4|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:03.282312|10566|dbusername|localhost|dbname|Query|5|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:03.783135|10566|dbusername|localhost|dbname|Query|5|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:04.283845|10566|dbusername|localhost|dbname|Query|6|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:04.784514|10566|dbusername|localhost|dbname|Query|6|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:05.285155|10566|dbusername|localhost|dbname|Query|7|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:05.786013|10566|dbusername|localhost|dbname|Query|7|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:06.286718|10566|dbusername|localhost|dbname|Query|8|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:06.787452|10566|dbusername|localhost|dbname|Query|8|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:07.288100|10566|dbusername|localhost|dbname|Query|9|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:07.788802|10566|dbusername|localhost|dbname|Query|9|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:08.289438|10566|dbusername|localhost|dbname|Query|10|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:08.790178|10566|dbusername|localhost|dbname|Query|10|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:09.290867|10566|dbusername|localhost|dbname|Query|11|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:09.791539|10566|dbusername|localhost|dbname|Query|11|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:10.292204|10566|dbusername|localhost|dbname|Query|12|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:10.792932|10566|dbusername|localhost|dbname|Query|12|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:11.293586|10566|dbusername|localhost|dbname|Query|13|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:11.794410|10566|dbusername|localhost|dbname|Query|13|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:12.295091|10566|dbusername|localhost|dbname|Query|14|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:12.795824|10566|dbusername|localhost|dbname|Query|14|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:13.296482|10566|dbusername|localhost|dbname|Query|15|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:13.797117|10566|dbusername|localhost|dbname|Query|15|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:14.297819|10566|dbusername|localhost|dbname|Query|16|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:14.798478|10566|dbusername|localhost|dbname|Query|16|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:15.299124|10566|dbusername|localhost|dbname|Query|17|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:15.799865|10566|dbusername|localhost|dbname|Query|17|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:16.300533|10566|dbusername|localhost|dbname|Query|18|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:16.801355|10566|dbusername|localhost|dbname|Query|18|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:17.302219|10566|dbusername|localhost|dbname|Query|19|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:17.802889|10566|dbusername|localhost|dbname|Query|19|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:18.303536|10566|dbusername|localhost|dbname|Query|20|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:18.804190|10566|dbusername|localhost|dbname|Query|20|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:19.304890|10566|dbusername|localhost|dbname|Query|21|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:19.805526|10566|dbusername|localhost|dbname|Query|21|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:20.306181|10566|dbusername|localhost|dbname|Query|22|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:20.806913|10566|dbusername|localhost|dbname|Query|22|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:21.307555|10566|dbusername|localhost|dbname|Query|23|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:21.808223|10566|dbusername|localhost|dbname|Query|23|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:22.308917|10566|dbusername|localhost|dbname|Query|24|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:22.809411|10566|dbusername|localhost|dbname|Query|24|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:23.310114|10566|dbusername|localhost|dbname|Query|25|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:23.810742|10566|dbusername|localhost|dbname|Query|25|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:24.311614|10566|dbusername|localhost|dbname|Query|26|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:24.812464|10566|dbusername|localhost|dbname|Query|26|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:25.313033|10566|dbusername|localhost|dbname|Query|27|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:25.813803|10566|dbusername|localhost|dbname|Query|27|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:26.314388|10566|dbusername|localhost|dbname|Query|28|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:26.815048|10566|dbusername|localhost|dbname|Query|28|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:27.315679|10566|dbusername|localhost|dbname|Query|29|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:27.816302|10566|dbusername|localhost|dbname|Query|29|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:28.316936|10566|dbusername|localhost|dbname|Query|30|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:28.817532|10566|dbusername|localhost|dbname|Query|30|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:29.318137|10566|dbusername|localhost|dbname|Query|31|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:29.818959|10566|dbusername|localhost|dbname|Query|31|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:30.319561|10566|dbusername|localhost|dbname|Query|32|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:30.820172|10566|dbusername|localhost|dbname|Query|32|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:31.320806|10566|dbusername|localhost|dbname|Query|33|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:31.821404|10566|dbusername|localhost|dbname|Query|33|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:32.322152|10566|dbusername|localhost|dbname|Query|34|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:32.822794|10566|dbusername|localhost|dbname|Query|34|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:33.323437|10566|dbusername|localhost|dbname|Query|35|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:33.824105|10566|dbusername|localhost|dbname|Query|35|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:34.324666|10566|dbusername|localhost|dbname|Query|36|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:34.825337|10566|dbusername|localhost|dbname|Query|36|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:35.326108|10566|dbusername|localhost|dbname|Query|37|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:35.826796|10566|dbusername|localhost|dbname|Query|37|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:36.327445|10566|dbusername|localhost|dbname|Query|38|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:36.828168|10566|dbusername|localhost|dbname|Query|38|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:37.328840|10566|dbusername|localhost|dbname|Query|39|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:37.829457|10566|dbusername|localhost|dbname|Query|39|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:38.330079|10566|dbusername|localhost|dbname|Query|40|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:38.830735|10566|dbusername|localhost|dbname|Query|40|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:39.331356|10566|dbusername|localhost|dbname|Query|41|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:39.832007|10566|dbusername|localhost|dbname|Query|41|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:40.332621|10566|dbusername|localhost|dbname|Query|42|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:40.833228|10566|dbusername|localhost|dbname|Query|42|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:41.333922|10566|dbusername|localhost|dbname|Query|43|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:41.834505|10566|dbusername|localhost|dbname|Query|43|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:42.335132|10566|dbusername|localhost|dbname|Query|44|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:42.835903|10566|dbusername|localhost|dbname|Query|44|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:43.336804|10566|dbusername|localhost|dbname|Query|45|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:43.837420|10566|dbusername|localhost|dbname|Query|45|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:44.338074|10566|dbusername|localhost|dbname|Query|46|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:44.838758|10566|dbusername|localhost|dbname|Query|46|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:45.339429|10566|dbusername|localhost|dbname|Query|47|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:45.840092|10566|dbusername|localhost|dbname|Query|47|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:46.340771|10566|dbusername|localhost|dbname|Query|48|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:46.841430|10566|dbusername|localhost|dbname|Query|48|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)
WHERE 1=1 AND FIND_IN_SET(t.id_board, '4,5,7,9,19,20,26,27,34,36,39,40,41,42,43,44,45,46,47,48,49,55,57,58,59,60,61,62') != 0
2012-02-4 11:32:47.342097|10566|dbusername|localhost|dbname|Query|49|Sending data|SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
FROM wargatest_topics AS t
LEFT JOIN wargatest_messages AS m ON (t.id_board = m.id_board)

feline · March 05, 2012, 01:03:07 PM

These queries are used to get the correct count of Topics and Post for a Subforum.
I know that is not optimized .. for the next release we will moved that to a other point.

For now, you can remove these queries .. it's only a visibility fault

You find that here:
/Sources/Stats.php (1 hits)
Line 108: SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
/Sources/Subs.php (1 hits)
Line 3316: SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts

Hope this help ...

RCC_SaMiaM · March 05, 2012, 01:12:24 PM

Any idea on what I should try to get mine working? The mod knows (recognizes) the sub forum domain, it just isn't setting the right display (themes, visible boards).

luuuciano · March 05, 2012, 01:38:03 PM

Quote from: feline on March 05, 2012, 01:03:07 PM
These queries are used to get the correct count of Topics and Post for a Subforum.
I know that is not optimized .. for the next release we will moved that to a other point.

For now, you can remove these queries .. it's only a visibility fault

You find that here:
/Sources/Stats.php (1 hits)
Line 108: SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
/Sources/Subs.php (1 hits)
Line 3316: SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts

Hope this help ...

Thanks a lot Feline! will try it...

btw, the correct way to comment that will be something like:

Code Select

	if(isset($modSettings['subforums'][$_SERVER['SERVER_NAME']]))
	{
/*		global $smcFunc;
		$result = $smcFunc['db_query']('', '
			SELECT COUNT(DISTINCT t.id_topic) AS topics, COUNT(DISTINCT m.id_msg) as posts
			FROM {db_prefix}topics AS t
			LEFT JOIN {db_prefix}messages AS m ON (t.id_board = m.id_board)
			WHERE 1=1{subforums_see_board:t-id_board}',
			array()
		);
		$row = $smcFunc['db_fetch_assoc']($result);
		$smcFunc['db_free_result']($result);
		$context['common_stats']['total_posts'] = comma_format($row['posts']);
		$context['common_stats']['total_topics'] = comma_format($row['topics']);*/
	}

EDIT: it works flawlessly! (or looks like that, lol)

Finally I saw the light! this mod is awesome feline! I wish many other people start to use it too...

Feline, what is not made without those commented lines? just to know

feline · March 06, 2012, 03:02:23 AM

the both queries are a bottleneck for bigger forums. so we will look what we can do to solve that problem quickly ...

RCC_SaMiaM · March 06, 2012, 12:23:18 PM

Any ideas on what I should try to make this work? I would love to use this

News:

PMx-Subforums v1.41 (updated 03 Jul 2013t)