News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Topic View Log

Started by live627, July 16, 2015, 09:15:43 AM

Previous topic - Next topic

aegersz

the info I posted is intended to be for the guy who wrote it. I get the same thing as you but only on 1 page.

as I said, the database table it uses is correct but the query of it only returns the same one line - he expects a number of rows as he sets up an array to receive them.

buggered if i know, I'm just exploring the wonders of php+SQL and I'm only a novice.
The configuration of my Linux VPS (SMF 2.0 with 160+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

runningtrades

i get multiple pages, but can only see one name on the first page, but the name always changes, as members view the post

aegersz

I was able to get two pages of blanks by altering a SQL query and I have run the SQL from the debugging mods on phpmyadmin and I get the exact same single line returned, despite there being multiple rows to be accessed.

I emailed the author because it's now beyond my current skillset ... i really like this mod BUT that database table is slowly growing with every thread view and that's another concern.

I can't see any code to process all the appropriate rows to provide a consice listing of viewers so I am even more confused !
The configuration of my Linux VPS (SMF 2.0 with 160+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

aegersz

#23
i got it working but it produces HEAPS of information ... try my fix (and see if you like the amount of data it produces) by replacing the top 3 lines of the SQL SELECT code in function list_get_tvl_members in .Sources/TopicViewLog.php as shown below:

change the following:
                SELECT
                        mem.id_member, mem.member_name, mem.real_name, mg.group_name,
                        tvl.time, COUNT(m.id_msg) AS topic_posts


to the following:
                SELECT
                DISTINCT
                        mem.id_member, mem.member_name, mem.real_name, mg.group_name, tvl.time, mem.posts AS topic_posts
The configuration of my Linux VPS (SMF 2.0 with 160+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

runningtrades

that fix works perfectly! Thank you very much!!

aegersz

You're welcome but I decided to Uninstall it due to the table it uses that is continually growing and the huge amount of pages it produces.

Good for every now and then though.
The configuration of my Linux VPS (SMF 2.0 with 160+ mods & some assorted manual tweaks) can be found here and notes on my mods can be found here (warning: those links will take you to a drug related forum). My (House) music DJ dedication page is here

runningtrades

I managed to track down an offending member that I was trying to weed out, so it served it's purpose for me! I'll probably keep the logs for now, see how big they get...if they get too big, I may remove it. But it helped me ban a member I was looking for!

Advertisement: