WORKING Thread -- please stop in.

[MililaniBuckeye]

That gets my vote.

Freaking homo'ass computer!!!

Well, what kind of computer would you expect a freaking homo'ass to have?

 

[Steve19]

This is really taking shape! Neat new look and upgrade, Clarity! Much appreciated by us all!

 

[Clarity]

In regards to too many posts showing up new, it will sort itself out. We handle that completely differently now, and you're going to find that it's far more accurate and useful than it used to be.

Basically, it used to be based on your cookies. Once a user had been inactive for a certain amount of time (the value of the cookie timeout option, which is 900s as I recall) all threads and forums were considered read. Individual threads were marked as read within a session via cookies stored on your computer.

Now we use the database to store thread and forum read times. This allows accurate read markers to be kept indefinitely. Forums are automatically marked as read when the last new thread is read.

Basically this allows a new level of accuracy and functionality from before. Play with 'New Posts' up on the navbar a bit, you'll find (as Deety mentioned earlier) that it's giving you more and better information.

Because we've never stored that information in the database, it's basically having to build new information for you. What you could do to force it along, is 'Mark All Forums Read' from the Forum Home, and that would effectively 'reset' everything for you.

In fact, everyone who reads this should go out to the forum overview page right now, and click the 'Mark Forums Read' button right now. Can start enjoying the nicer functionality sooner that way. I might see if I can set that flag for everyone through the database. Fighting with bpCash and TopXStats at the moment.

 

[Nate]

So any early opinions/favorites on the new 'skins'?

For any who missed my earlier post, you can now scroll down to the bottom of any page, on the left hand side there's a pulldown where you can select one of; DayGame (default), AfternoonGame, and NightGame.

Definitely curious to hear what different people will use.

Very nice addition letting users choose different skins. I like the new nightgame the best and am using it now.

I know I don't post much but I do frequent and lurk almost everyday. Very nice job on the upgrade. :cheers:

 

[Clarity]

Thanks nate, and everyone else. Glad the changes are being received so well.

I'm pasting in some of the stats code relevant to the excludes list. Seems like simply changing NOT to IS, or just removing NOT someplace would work, but it hasn't been that easy yet. Putting it here so I can look at it without the rest of the code, and in case someone with a better clue than mine has an idea.

if ($vbulletin->options['topXstats_excludedforums'] !== '') {
    $excludedforums = ',' . $vbulletin->options['topXstats_excludedforums'];
}

// get rid of initial comma
$excludedforums = substr($excludedforums, 1);

if ($excludedforums != "") {
    $excludedforums = "AND thread.forumid NOT IN ($excludedforums)";
}

$getstats_threads = $db->query_read("
    SELECT
        thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
        " . iif($deljoin, ", NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason") . "
    FROM " . TABLE_PREFIX . "thread AS thread
        LEFT JOIN  " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter)
        $deljoin
        WHERE NOT ISNULL(thread.threadid)
        $excludedforums
        " . iif(!$deljoin, "AND thread.visible <> 2") . "
    ORDER BY lastpost DESC LIMIT 0, $displayrecords");

 

[3yardsandacloud]

I assume you know that all the sub-forums are displaying in the forum lobby page. Not sure if that is intended or just another glitch to fix. Actually, I might grow to like it that way as it might make navigation a bit easier, although it makes the lobby page a bit cluttered.

 

[Clarity]

I assume you know that all the sub-forums are displaying in the forum lobby page. Not sure if that is intended or just another glitch to fix. Actually, I might grow to like it that way as it might make navigation a bit easier, although it makes the lobby page a bit cluttered.

It's intentional. But I may reduce how deep it goes, and/or how many it shows.

 

[Nate]

I think the view of the subforums on the index is a good idea. Makes navigation easier.

 

[bucknut11]

So at the top of the "new threads" list right now is a thread about naked women. I don't have RR access, and I even though I can't get to it anyways, I don't think that's something we want #1 on the list...

 

[Clarity]

It will be changed.

I'm dealing with a problematic issue with the code, it's pasted above if someone wants to help figure it out.

Until then, it will be fixed when it's fixed. If someone is threatened by the words "hot half naked", then I recommend they just leave the site for a day or two while I try to get everything done.

 

[lvbuckeye]

It will be changed.

I'm dealing with a problematic issue with the code, it's pasted above if someone wants to help figure it out.

Until then, it will be fixed when it's fixed. If someone is threatened by the words "hot half naked", then I recommend they just leave the site for a day or two while I try to get everything done.

darn it! you edited it before i could quote! i was gonna buy you a vBeer...

 

[bucknut11]

I didn't say threatened, I was referring more to the recruits, families, and young kids that often visit the site.

But I understand having trouble with code, so I won't push it.

 

[Clarity]

darn it! you edited it before i could quote! i was gonna buy you a vBeer...

Yeah, I really don't like some of this stuff. I know where the vCash data is in the backup database, I know where and how I want that to be in the new database, but I can't visualize a way to make that happen -- and it pisses me off. Lol, so I'm starting to get edgy. My original response "so fix it" was pointlessly hostile, not 11's fault mySQL is evil.

The topxstats code *should* be easy to modify to my needs, but I can't wrap my head around how to do something that should be simple.

Been looking at this stuff too long, I'm ready to be done, so I can get back to something productive like restoring or adding new features.

 

[Clarity]

15 forums blocked from topxstats as part of the exclude list, as a temporary stopgap measure until I can figure out how to do it right. Romper amongst them.

My avatar speaks truths.

 

[Taosman]

Great job Clarity! Very nice upgrade.