stop threads bumping in certain forum

[DPerley]

nakkid

If the ? was to me about version I assume you mean version of vb - which for me is 2.2.4. As for the reference to user group/mods I would only use this hack in an advertising forum for regular registered users. Otherwise I'm not sure what you were referring to.

DPerley

[Logician]

Originally posted by Bald Bouncer
all sounds nice but whats the sql_field_name_for_date?

"dateline" it is..

[Bald Bouncer]

not working mate, tried the below too and it still aint having it

PHP Code:

//stop bumping in release forum
if ($forumid=101) {
  $sortfield = "$thread[dateline]";
}
//stop bumping in release forum 


[Logician]

Here you go:

1-Edit forumdisplay.php, find:
-- cut --
switch ($sortfield) {
case 'title':
case 'lastpost':
case 'replycount':
case 'views':
case 'postusername':
case 'voteavg':
break;

default:
$sortfield='lastpost';
}
-- cut --

2- After that add:
-- cut --
$sortfield = "dateline";
-- cut --

This will sort all threads in all forums according to the first message date and user's sort field choice is cancelled.

if you want this feature for a specific forum (eg #4), use this instead:
-- cut --
if ($forumid == 4) {$sortfield = "dateline";}
-- cut --

For 4 and 5 and 6 use this:
-- cut ---
if (($forumid == 4) OR ($forumid == 5) OR ($forumid == 6)) {$sortfield = "dateline";}
-- cut --

This is tested and working..

Enjoy..

[Bald Bouncer]

that did it fantastic job Logician thanks!

[Pinocchi]

Well this option sure works, but you would have to edit the file over and over again every time you add another forum you want to be listed that way.

I added some extra rows in a table, added some extra lines into several files and now I can set the order to every forum in the admin script. The only thing I'm still looking at is the query to select all columns in a table. Like that you wouldn't have to manually type the column (and need to know it) but could just select the one you want it to be ordered by.

If somebody would be interested, let me know I've got to figure out again what I did exactly but I'm willing to give it another try.

Thanks,

Erik

------
You can test it out in a few days at the new forum: NewHostingTalk

[Logician]

Originally posted by Pinocchi
only thing I'm still looking at is the query to select all columns in a table. Like that you wouldn't have to manually type the column (and need to know it) but could just select the one you want it to be ordered by.

Here you go:

-- cut ---
$mylink = mysql_connect('localhost', 'myname', 'secret');
$tablefields = mysql_list_fields("databasename", "tablename", $mylink);
$columncount = mysql_num_fields($tablefields);
for ($i = 0; $i < $columncount; $i++)
{
echo mysql_field_name($tablefields, $i) . " - ";
}
-- cut ---

Regards,
Logician