| Author |  Topic  | 
              
                | withanhdammitJunior Member
 
   
 
                USA236 Posts
 | 
                    
                      |  Posted - 18 March 2005 :  10:01:56       
 |  
                      | This is an update of HuwR's Bookmark Mod.  I updated this with a ton of help from HuwR (thanks again, HuwR!) 
 <edit>Let me know if there are any problems with this.  I may not have included all the updates.  I'm pretty sure they are all there, but I put the zip together after the fact.</edit>
 
 h
 
 http://www.dnjhome.com/snitz/bookmark.zip<
 |  
                      | I reject your reality and substitute my own.
 |  
                      | Edited by - withanhdammit on 18 March 2005  11:06:06
 |  | 
              
                | andrettiNew Member
 
  
 
                70 Posts | 
                    
                      |  Posted - 19 March 2005 :  12:50:16       
 |  
                      | just downloaded your zip file above and 
 1   bookmark.zip: Unknown method in bookmark.asp
 2   bookmark.zip: Unknown method in bookmark.dbs
 3   bookmark.zip: Unknown method in icon_bookmark.gif
 4   bookmark.zip: Unknown method in readme.txt
 5   bookmark.zip: No files to extract
 
 Or
 Extracting to "C:\Documents and Settings\server\Desktop\New Folder\"
 Use Path: yes   Overlay Files: no
 skipping: bookmark.asp: this file is not in the standard Zip 2.0 format
 Please see www.winzip.com/zip20.htm for more information
 skipping: bookmark.dbs: this file is not in the standard Zip 2.0 format
 Please see www.winzip.com/zip20.htm for more information
 skipping: icon_bookmark.gif: this file is not in the standard Zip 2.0 format
 Please see www.winzip.com/zip20.htm for more information
 skipping: readme.txt: this file is not in the standard Zip 2.0 format
 Please see www.winzip.com/zip20.htm for more information
 error:  no files were found - nothing to do
 
 
 is the error when I open it ...
 
 Just thought you would want to know<
 |  
                      |  |  | 
              
                | masteraoSenior Member
 
     
 
                Sweden1678 Posts
 | 
                    
                      |  Posted - 19 March 2005 :  13:45:08       
 |  
                      | I have no problems opening it up with winrar, although I get the same error using win xp's built-in unzip feature. Andretti, try unzipping it with with winzip or winrar, and you will not get any errors at all.< |  
                      | Jan
 ===========
 FR Portal Forums | Active Users 4.0.20 Mod
 |  
                      |  |  | 
              
                | andrettiNew Member
 
  
 
                70 Posts | 
                    
                      |  Posted - 19 March 2005 :  13:48:26       
 |  
                      | The first set of error message did come from winrar and the second set came from winzip< |  
                      |  |  | 
              
                | masteraoSenior Member
 
     
 
                Sweden1678 Posts
 | 
                    
                      |  Posted - 19 March 2005 :  13:57:42       
 |  
                      | Oops  . 
 I didn't try to extract the files the first time, I just viewed them. Now I tried to unzip them and true, I got the same error with winrar that you did. However, I could unzip them with Total Commander and with winzip, though.<
 |  
                      | Jan
 ===========
 FR Portal Forums | Active Users 4.0.20 Mod
 |  
                      | Edited by - masterao on 19 March 2005  13:58:08
 |  
                      |  |  | 
              
                | withanhdammitJunior Member
 
   
 
                USA236 Posts
 | 
                    
                      |  Posted - 19 March 2005 :  14:19:40       
 |  
                      | OK, I rezipped it.  I use WinZip 9.0 and had no problems unzipping it.  I know that depending on the amount of compression you pick, it may not be compatible with previous versions.  So I rezipped it using "normal" compression.  Let me know if you still have any problems. 
 h<
 |  
                      | I reject your reality and substitute my own.
 |  
                      |  |  | 
              
                | andrettiNew Member
 
  
 
                70 Posts | 
                    
                      |  Posted - 19 March 2005 :  14:24:40       
 |  
                      | got it and it opened up just fine... 
 Thanks<
 |  
                      |  |  | 
              
                | withanhdammitJunior Member
 
   
 
                USA236 Posts
 | 
                    
                      |  Posted - 20 March 2005 :  00:24:07       
 |  
                      | Great!  Let me know how you like it. 
 h<
 |  
                      | I reject your reality and substitute my own.
 |  
                      |  |  | 
              
                | andrettiNew Member
 
  
 
                70 Posts | 
                    
                      |  Posted - 20 March 2005 :  12:38:08       
 |  
                      | so far it looks good. Just having a problem finding where to insert <a href="bookmark.asp?mode=add&id=<%=Request.querystring("Topic_ID")%>">Bookmark This Topic</a>
 
 In the topic.asp file<
 |  
                      |  |  | 
              
                | withanhdammitJunior Member
 
   
 
                USA236 Posts
 | 
                    
                      |  Posted - 20 March 2005 :  20:28:02       
 |  
                      | Find this code: 
 
		if lcase(strEmail) = "1" and Topic_Status < 2 then 
			if Cat_Status <> 0 and Forum_Status <> 0 and Topic_Status <> 0 and mLev > 0 then
				if strSubscription > 0 and Cat_Subscription > 0 and Forum_Subscription > 0 then
					if InArray(strTopicSubs, Topic_ID) then
						Response.Write "          <br />" & ShowSubLink ("U", Cat_ID, Forum_ID, Topic_ID, "Y") & vbNewLine
					elseif strBoardSubs <> "Y" and not(InArray(strForumSubs,Forum_ID) or InArray(strCatSubs,Cat_ID)) then
						Response.Write "          <br />" & ShowSubLink ("S", Cat_ID, Forum_ID, Topic_ID, "Y") & vbNewLine
					end if
				end if
			end if
			if ((mlev <> 0) or (mlev = 0 and strLogonForMail <> "1")) and lcase(strShowSendToFriend) = "1" then
				Response.Write	"          <br /><a href=""JavaScript:openWindow('pop_send_to_friend.asp?url=" & strForumURL & "topic.asp?TOPIC_ID=" & Topic_ID & "')"">" & getCurrentIcon(strIconSendTopic,"Send this post to a friend","align=""absmiddle""") & "</a> <a href=""JavaScript:openWindow('pop_send_to_friend.asp?url=" & strForumURL & "topic.asp?TOPIC_ID=" & Topic_ID & "')"">Send this Post to a Friend</a>" & vbNewLine
			end if 
		end if 
And insert this after it:
 
 		Response.Write	"	   <br /><a href=bookmark.asp?mode=add&topic_id=" & Topic_ID & ">" & getCurrentIcon(strIconBookmark,"Bookmark this post","align=""absmiddle""") & "</a> <a href=bookmark.asp?mode=add&topic_id=" & Topic_ID & ">Bookmark This Topic</a>" & vbNewLine
 
 I updated the line to show the bookmark icon.<
 |  
                      | I reject your reality and substitute my own.
 |  
                      |  |  | 
              
                | andrettiNew Member
 
  
 
                70 Posts | 
                    
                      |  Posted - 20 March 2005 :  21:43:40       
 |  
                      | Did what you said above and I was able to get it to show on the menu.. 
 Only problem now is I get this error
 
 Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
 
 [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'B_MemberID=1 and B_TopicID='.
 
 /bookmark.asp, line 106
 
 
 I added a response.write (strsql) in there so I could see what data was trying to be added and here is the output of that as well.
 
 SELECT COUNT(FORUM_TOPICS.T_LAST_POST) AS NUM_ACTIVE FROM FORUM_TOPICS WHERE (((FORUM_TOPICS.T_LAST_POST)>'20050320123700')) AND FORUM_TOPICS.T_STATUS <= 1<
 |  
                      |  |  | 
              
                | withanhdammitJunior Member
 
   
 
                USA236 Posts
 | 
                    
                      |  Posted - 20 March 2005 :  22:20:03       
 |  
                      | Oh, that's probably the problem.  I use MSSQL, not Access, so my strSql is written for MSSQL.  I don't know enough to rewrite it so it will work with Access.  We'll need someone else's help for that. 
 Sorry ;-(
 
 h<
 |  
                      | I reject your reality and substitute my own.
 |  
                      |  |  | 
              
                | andrettiNew Member
 
  
 
                70 Posts | 
                    
                      |  Posted - 20 March 2005 :  22:35:40       
 |  
                      | well maybe someone here can help then :)< |  
                      |  |  | 
              
                | AstralisSenior Member
 
     
 
                USA1218 Posts
 |  | 
              
                | AnonJrModerator
 
      
 
                United States5768 Posts
 | 
                    
                      |  Posted - 03 September 2005 :  11:07:28       
 |  
                      | Seems to be up now. If it still doesn't work, I can send you a copy.< |  
                      |  |  | 
              
                | AstralisSenior Member
 
     
 
                USA1218 Posts
 | 
                    
                      |  Posted - 03 September 2005 :  19:56:41     
 |  
                      | Question: 
 This is in the instructions:
 
 quote:
 Copy the mod_dbsetup.asp and the bookmark.dbs file to either the mods directory if you have one
 or the tools directory.
 
 
 I do not have either directory.  Is it necessary to create one?  I don't think so but just want to make sure.
 <
 |  
                      |  |  | 
              
                
                |  Topic  |  |