Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Problem adding Locking Topics Mod...		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

MCane
Starting Member

37 Posts
Posted - 24 July 2002 :  21:38:16  Show Profile
I just tried to add the locking topic mod to 3.3.03 and I got the following error...

Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN T_INPLACE int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated

Why... Someone please help.

Roland
Advanced Member

Netherlands
9335 Posts
Posted - 24 July 2002 :  21:39:50  Show Profile
Do you mean the Sticky Topics MOD that will lock a topic in place at the top of a forum?

Roland

http://www.frutzle.com

Snitz Exchange | Snitz Icons | Do's and Dont's
Go to Top of Page

Hamlin
Advanced Member

United Kingdom
2386 Posts
Posted - 24 July 2002 :  21:41:07  Show Profile
Have a look at this post

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=26081

It has tips if your having problems.


No matter how fast light travels it finds the darkness has always got there first, and is waiting for it.
http://www.ian-hamlin.co.uk ™
Go to Top of Page

MCane
Starting Member

37 Posts
Posted - 24 July 2002 :  21:50:51  Show Profile
Yes this is the sticky topic mod... I got it here:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=6217
Go to Top of Page

MCane
Starting Member

37 Posts
Posted - 24 July 2002 :  21:52:29  Show Profile
Got it... Thanks so much... I changed my conn string.
Go to Top of Page

MCane
Starting Member

37 Posts
Posted - 24 July 2002 :  21:59:00  Show Profile
Actually, now that I look at this I am not sure it is what I want! Will this MOD allow anyone to lock a topic or just an Administrator?

I would hope just and admin.

Thanks
Go to Top of Page

MCane
Starting Member

37 Posts
Posted - 24 July 2002 :  22:01:24  Show Profile
One more thing... In the directions it sais to modify the following, but I don't have the lines to modify.

--------------------------------------------------------------------
forum.asp
--------------------------------------------------------------------

Approx. Line 138, you will find this line
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_LAST_POST DESC "

Change the code to this
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_INPLACE DESC "
strSql = strSql & " , " & strTablePrefix & "TOPICS.T_LAST_POST DESC "
Go to Top of Page

Hamlin
Advanced Member

United Kingdom
2386 Posts
Posted - 24 July 2002 :  22:03:23  Show Profile
I dont know about that version, but the updated one here http://ls3k.com/snitz/mods.asp?action=details&ID=36 only allows admins and mods to sticky a topic


No matter how fast light travels it finds the darkness has always got there first, and is waiting for it.
http://www.ian-hamlin.co.uk ™
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.37 seconds. Powered By: Snitz Forums 2000 Version 3.4.07