| Author |
 Topic  |
|
davea
New Member
61 Posts |
 Posted - 03 January 2001 : 10:44:02
|
this is my 3rd or 4th time ive asked for this one.
i REALLY need to be able to lock a post at the top of the forum, each of my boards could use a seprate FAQ for each one, as well as a read before post sort of thing.
These MUST stay at the top....there must be a way to do this!!!!, ive had 0 response on it before
*begs*
*pants*
*HELP*
Moved and Name changed by Huwr
Edited by - Huwr on 04 January 2001 07:42:30
Edited by - Huwr on 04 January 2001 07:42:45 |
|
|
HuwR
Forum Admin
United Kingdom
20587 Posts |
Posted - 03 January 2001 : 12:24:36
|
davea,
How would you want this to look, purely as always the topic topic, or maybe in a separate table just above the topics, that you could maybe include in forum.asp aswel as Topic.asp
<font color=blue>'Resistance is futile'</font id=blue> |
 |
|
|
davea
New Member
61 Posts |
Posted - 03 January 2001 : 12:51:19
|
As the topic topic, admin option only.
my thoughts where on the lock topic option when you get the pop up confirm it would ask " would you like to lock in place?" if you lock it in place it will remain as a topic but as the first topic always and locked, if not it just locks normally.
how the hell this will happen is beyond me:)
|
|
|
|
HuwR
Forum Admin
United Kingdom
20587 Posts |
Posted - 04 January 2001 : 07:49:19
|
Here goes.
1) Add a new field to FORUM_TOPICS called T_INPLACE with a default value of 0
2) Replace pop_lock.asp and pop_open.asp with these
pop_lock.asp
pop_open.asp
3) Search in Forum.asp for
<pre id=code><font face=courier size=2 id=code>
<font color=blue>strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_LAST_POST DESC "</font id=blue>
</font id=code></pre id=code>
change it to
<pre id=code><font face=courier size=2 id=code><font color=red>
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_INPLACE DESC,"
strSql = strSql & " " & strTablePrefix & "TOPICS.T_LAST_POST DESC "</font id=red>
</font id=code></pre id=code>
<font color=blue>'Resistance is futile'</font id=blue>
Ooops missed out the http
Edited by - Huwr on 04 January 2001 09:50:57 |
|
|
|
tilttek
Junior Member
Canada
333 Posts |
Posted - 04 January 2001 : 09:43:55
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
pop_lock.asp
pop_open.asp
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Look like doesn't work... Still have a bug with the forum...
[ url="195.149.32.155/tools/uploads/pop_lock.txt" ]pop_lock.asp[ /url ]
is replace with
<pre id=code><font face=courier size=2 id=code>http: //forum.snitz.com/forum/195.149.32.155/tools/uploads/pop_lock.txt</font id=code></pre id=code>
Philippe Gamache
http://www.tilttek.com
http://www.lapageamelkor.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20587 Posts |
Posted - 04 January 2001 : 09:52:10
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
pop_lock.asp
pop_open.asp
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Look like doesn't work... Still have a bug with the forum...
[ url="195.149.32.155/tools/uploads/pop_lock.txt" ]pop_lock.asp[ /url ]
is replace with
<pre id=code><font face=courier size=2 id=code>http: //forum.snitz.com/forum/195.149.32.155/tools/uploads/pop_lock.txt</font id=code></pre id=code>
Philippe Gamache
http://www.tilttek.com
http://www.lapageamelkor.com
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I'm afraid that has never worked, it just doesn't know what to do with an IP address, I just forgot to put the http in it
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
davea
New Member
61 Posts |
Posted - 04 January 2001 : 10:10:32
|
so this is a working thing now?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20587 Posts |
Posted - 04 January 2001 : 10:17:48
|
The Mod yes, using IP address for web links No
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
davea
New Member
61 Posts |
Posted - 04 January 2001 : 10:22:05
|
i will add that tonight:)
thx ever so much
|
|
|
|
tilttek
Junior Member
Canada
333 Posts |
Posted - 04 January 2001 : 12:45:29
|
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I'm afraid that has never worked, it just doesn't know what to do with an IP address, I just forgot to put the http in it
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Ok, it's a browser problem.
I see you correct the url.
Maybe there are someting to do, to correct this problem.
Philippe Gamache
http://www.tilttek.com
http://www.lapageamelkor.com |
|
|
|
davea
New Member
61 Posts |
Posted - 06 January 2001 : 14:37:17
|
In forum.asp you said look for the line
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_LAST_POST DESC "
there is no such line
can you confirm this?
what i have found is two isntances of
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_LAST_POST"
one after the other, is there where you mean?
as i say i searched for 20 mins flat and did not find the line you quote.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20587 Posts |
Posted - 06 January 2001 : 14:56:36
|
what version of the code are you using, ?
what are the lines either side of the ones you found, in my forum.asp it appears only once at about line 136
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
davea
New Member
61 Posts |
Posted - 06 January 2001 : 16:05:39
|
Im using your code:)
its on your server hehe :>
the full code around it is,
select case sortorder
case "1a", "1d"
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_SUBJECT"
case "2a", "2d"
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_AUTHOR"
case "3a", "3d"
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_REPLIES"
case "4a", "4d"
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_VIEW_COUNT"
case "5a", "5d"
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_LAST_POST"
case else
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_LAST_POST"<font color=blue></font id=blue>[black]
the code version is
3.1 Service Release 2
we are at v4 now arnt we, im a little unwilling to change things due to the leave that the forum has been alterd :) i have so amny mods installed hehe:)
|
|
|
|
HuwR
Forum Admin
United Kingdom
20587 Posts |
Posted - 06 January 2001 : 16:44:54
|
Oh, Ok this is what it neds to look like
<pre id=code><font face=courier size=2 id=code>
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_INPLACE DESC,"
'############################################
select case sortorder
case "1a", "1d"
strSql = strSql & " " & strTablePrefix & "TOPICS.T_SUBJECT"
case "2a", "2d"
strSql = strSql & " " & strTablePrefix & "TOPICS.T_AUTHOR"
case "3a", "3d"
strSql = strSql & " " & strTablePrefix & "TOPICS.T_REPLIES"
case "4a", "4d"
strSql = strSql & " " & strTablePrefix & "TOPICS.T_VIEW_COUNT"
case "5a", "5d"
strSql = strSql & " " & strTablePrefix & "TOPICS.T_LAST_POST"
case else
strSql = strSql & " " & strTablePrefix & "TOPICS.T_LAST_POST"
End Select
</font id=code></pre id=code>
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
davea
New Member
61 Posts |
Posted - 06 January 2001 : 16:55:27
|
now whenever i try to eneter a forum i get.
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/davea/FORUM.asp, line 237
and stupid me did not save the old forum.asp
helllppp :)
|
|
|
|
HuwR
Forum Admin
United Kingdom
20587 Posts |
Posted - 06 January 2001 : 17:44:27
|
send me your forum.asp, I'll have a quick look
<font color=blue>'Resistance is futile'</font id=blue> |
|
|
|
Topic |
|
Topic Locked
