Author |
Topic |
Old Ager
New Member
Italy
59 Posts |
Posted - 13 January 2002 : 16:37:37
|
OK, this will probably be my last update as I just don't have the time for it. Feel free to do whatever you want with this MOD from here on out...
The new changes are noted in the original post.
Ciao!!
Old Ager |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 20 January 2002 : 14:51:40
|
In the zip I just downloaded, there is no .dbs file.
Am I misunderstanding something?
***** "Bother," said Pooh, as Piglet was assimilated by the Borg. |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 20 January 2002 : 14:53:40
|
the file you are looking for should be dbs_xxxxxx.asp. .dbs was used in earlier versions. 3.3 uses dbs_xxxxxx.asp
www.forumSquare.com - GauravBhabu - It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying. |
|
|
ParaDoX
New Member
United Kingdom
84 Posts |
Posted - 27 January 2002 : 18:28:20
|
Without wanting to drag this out, I tried to run the MOD on my forum and I got the error:
quote:
Sticky Topic Mod
Adding Column T_STICKY... ALTER TABLE FORUM_TOPICS ADD COLUMN T_STICKY int NULL DEFAULT 0 -2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement. Adding Column T_TOPSTICKY... ALTER TABLE FORUM_TOPICS ADD COLUMN T_TOPSTICKY int NULL DEFAULT 0 -2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
--------------------------------------------------------------------------------
Adding Column T_STICKY... ALTER TABLE FORUM_A_TOPICS ADD COLUMN T_STICKY int NULL DEFAULT 0 -2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement. Adding Column T_TOPSTICKY... ALTER TABLE FORUM_A_TOPICS ADD COLUMN T_TOPSTICKY int NULL DEFAULT 0 -2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Having noted that it has made a difference in the past, I should probably tell you that I host with Brinkster for free.
In anticipation,
Jamez
|
|
|
SnowPunk98
Starting Member
33 Posts |
Posted - 05 February 2002 : 00:12:19
|
I tried to do the first part, but when I got into the MOD part there is nothing in the drop down feild and I put those dbs files in there too. Can I do the mod without updating the database?
DATABASE FILES: (extract this file to your forum directory) ===============
dbs_Sticky_Topic.asp
USE dbs_HuwR_Sticky_Topic.asp IF YOU HAVE INSTALLED HUWR'S MOD!!!!
Run MOD Setup from the Admin Options and select "Sticky Topic MOD" from the menu. The following fields will be added to your database:
TOPICS.T_STICKY TOPICS.T_TOPSTICKY A_TOPICS.T_STICKY A_TOPICS.T_TOPSTICKY
You should delete the DBS file once this is accomplished.
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 05 February 2002 : 00:26:38
|
The fields need added to the database for the mod to function.
Is this what you are asking?
Nathan Bales - Romans 15:13 --------------------------------- Snitz Exchange | Mod Resource |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 05 February 2002 : 01:03:14
|
I downloaded the zip but don't see anything to lock the topic while in post.asp, I could have sworn there was documentation on how to add that... am I overlooking something?
____________ dayve@burningsouls.com
http://www.nineinchnailz.com - your source for everything nine inch nails ! |
|
|
SnowPunk98
Starting Member
33 Posts |
Posted - 05 February 2002 : 02:03:13
|
I dont think im understanding what its saying, do I just need to put all the ASP files in the forum root? why are the 3 files that need to be edited not just inclueded allready done?
|
|
|
ParaDoX
New Member
United Kingdom
84 Posts |
Posted - 05 February 2002 : 08:25:43
|
I believe the modded files aren't included as you may be running other mods that wouldn't work if you changed the script.
If I add the tables to my DB manually, will that do the same thing, assuming that I change the ASP as well?
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 19 February 2002 : 07:54:42
|
Well, that was very easy :)
Dayve, if you put all the files in your root, including the .gif images, then when you are logged in as an admin or moderator, you'll see red UP and DOWN arrows in your admin tools section on the far right.
Click those to stick or unstick your posts.
Raichel - I don't think you're supposed to use this version for a 3.1 install. I use Huw's Lock in Place mod, which does the same thing a little differently, for my 3.1 boards. Uninstall this and re-install that :)
ParaDox - yes, if you have all the same values for those fields.
SnowPunk - yes, put all the files in your root and then manually edit the pages as required in the readme.
***** "You know, there's nothing sexier than a girl geek on a big coding run." -Doonesbury |
|
|
DarlingBri
Junior Member
United Kingdom
378 Posts |
Posted - 19 February 2002 : 12:22:23
|
there's a tiny typo in this mod as distributed in the zip file that causes an error in post.asp. It's easily fixed.
In the code you are instructed to put in post.asp, do exactly as it says, but add the closing %> at the end:
<% '################### Sticky Topic MOD ###################### %> <font face="<% =strDefaultFontFace %>" size="<% =strDefaultFontSize %>"> Make this this topic: <input name="sticky" type="radio" value="1"><b>Sticky?</b> <input name="sticky" type="radio" value="2"><b>Top Sticky?</b> </font> <% '################### Sticky Topic MOD ######################%>
--Bri
***** "You know, there's nothing sexier than a girl geek on a big coding run." -Doonesbury |
|
|
Kong
Junior Member
100 Posts |
Posted - 20 February 2002 : 05:30:09
|
I made a post a little while ago about a problem I've been having since I installed the Sticky Topic mod. The title of it was Topic Ordering by Date Inproperly.
I'm not sure why I've been having this problem but I am.
There's a picture at the old topic.
Does anyone know why I've been having this problem? Does anyone know how to fix it?
_________________________ Come on by and visit Deth Incarnate. Growing slowly, but growing none the less. |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 24 February 2002 : 20:12:36
|
finally decided to install this and it works just fine. question though... the documentation was confusing a bit but finally understood what you were trying to note about HuwR's mod. I also noticed there was a dbs file named dbs_Stick_Topic_fix.asp. What is this for??
____________ dayve@burningsouls.com
http://www.nineinchnailz.com - your source for everything nine inch nails ! |
|
|
Kong
Junior Member
100 Posts |
Posted - 27 February 2002 : 03:07:35
|
quote: I noticed there was a dbs file named dbs_Stick_Topic_fix.asp. What is this for??
I noticed that too but I'm not sure what it does either.
Maybe it's a fix for the problem I've been having.
_________________________ Come on by and visit Deth Incarnate. Growing slowly, but growing none the less. |
|
|
Topic |
|