Search found 7 matches

by bsoder
Tue Mar 11, 2008 5:57 am
Forum: [3.0.x] Abandoned MODs
Topic: [ABD] Multiple File Upload 0.0.3
Replies: 102
Views: 30392

Re: [ALPHA] Multiple File Upload 0.0.3

Few minutes of screwing around trying to figure out the reversed posting order gave me this - in posting.php, find the following: -------- if ($post_data['post_attachment'] && !$submit && !$refresh && !$preview && $mode == 'edit') { // Do not change to SELECT * $sql =...
by bsoder
Tue Mar 04, 2008 12:57 am
Forum: [3.0.x] MOD Requests
Topic: request - youtube channel
Replies: 1
Views: 110

request - youtube channel

how about a youtube channel plugin? Basically, the username and channel for the channel would be handled behind the scenes, and users could upload their videos through the BB to the channel, then embed.
by bsoder
Tue Feb 19, 2008 9:47 pm
Forum: [3.0.x] MOD Database Releases
Topic: New post count on index
Replies: 123
Views: 38276

Re: New post count on index

I think the problem comes from the fact that the newposts query in search.php for threads uses user_lastvisit to key on, rather than a similar query to the one I posted. So what happens is that the query I posted will show you a count of all threads in the system that you've never viewed, but the qu...
by bsoder
Sun Feb 17, 2008 2:11 pm
Forum: [3.0.x] MOD Database Releases
Topic: New post count on index
Replies: 123
Views: 38276

Re: New post count on index

The SQL I posted doesn't reflect the actual number of new posts, it reflects the number of new topics. I've changed the text in language/en/common.php, the SEARCH_NEW value, to read "View new topics" on my board. I like topic count better than post count anyway, but just so you all are awa...
by bsoder
Sat Feb 16, 2008 7:01 pm
Forum: [3.0.x] MOD Database Releases
Topic: New post count on index
Replies: 123
Views: 38276

Re: New post count on index

Welcome. It's not my query, it was in another thread here somewhere - not directly related to post counts, but close enough.
by bsoder
Sat Feb 16, 2008 4:12 pm
Forum: [3.0.x] MOD Database Releases
Topic: New post count on index
Replies: 123
Views: 38276

Re: New post count on index

My setup is working now - I'm using this query, which indicates the correct unread post count now. I just replaced the sql query in index.php (actually in includes/functions.php per the first page or two of this thread) with this. $sql = 'SELECT count(*) as count FROM ( SELECT t.topic_id, t.topic_la...
by bsoder
Fri Feb 08, 2008 8:43 pm
Forum: [3.0.x] MOD Requests
Topic: [REQUEST] Posts per Page by User
Replies: 2
Views: 306

Re: [REQUEST] Posts per Page by User

bump for this - I've gotten a few requests for it as well.

Go to advanced search