| Author |  Topic  | 
              
                | al_iguanaJunior Member
 
   
 
                138 Posts | 
                    
                      |  Posted - 19 September 2002 :  22:39:31     
 |  
                      | quote:Originally posted by shyguy
 
 Hey serverhacker good job.
 
 Just wondering if I can use this forum with 3.3.5 database.
 I have alot of users and posts so dont want to restart the whole thing again!
 
 If its possible, then what are the steps that I need to take and be careful about before installing it?
 
 
 
 
 
 1) back up your database. definately.
 2) download the original snitz 3.4.3 forum. change config.asp to your database. run setup.asp (to update the database)
 3) download the db files from the first post in this topic, and unzip them to the forum you just set up
 4) go to admin / mods and install each mod. then log off
 5) delete the snitz 3.4.3 forum (not your database!!)
 6) unzip the serverhacker forum to your server
 7) change config.asp to point to your database
 8) should work now. worked for me, i didn't lose any posts or users.
 
 good luck! make sure you have a backup of your database. always.
  |  
                      | ----
 
 Don't Dream It ~ Be It
 http://www.peppermintiguana.co.uk/cymrugothic/
 |  
                      | Edited by - al_iguana on 19 September 2002  22:40:54
 |  
                      |  |  | 
              
                | shyguyStarting Member
 
 
 
                47 Posts |  | 
              
                | al_iguanaJunior Member
 
   
 
                138 Posts | 
                    
                      |  Posted - 19 September 2002 :  22:46:36     
 |  
                      | question (may be way off topic...) 
 i deleted the "this page has been viewed xxx times" from inc_header, because that was causing the scrollbars (at least for me).
 
 uploaded the new inc_header
 
 checked it. new inc_header (minus pageview) is on my server ok.
 
 went to my forum. pageviews are still there (and causing scrolling). tried refreshing... still there.. deleted my local cache... tried a different isp... still there.. checked the inc_asp page again - the code isn't there. so why is it still showing up?
 
 helllp! (and this is the last time i will ask for it.. honestly)
  |  
                      | ----
 
 Don't Dream It ~ Be It
 http://www.peppermintiguana.co.uk/cymrugothic/
 |  
                      |  |  | 
              
                | serverhackerJunior Member
 
   
 
                USA125 Posts
 | 
                    
                      |  Posted - 20 September 2002 :  00:12:28   
 |  
                      | hi, al_iquana 
 look for this line in "inc_header.asp":
 --------------------------------------------------------------------------
 [ Page Viewed <b><font color=""" & strForumLinkColor & """>" & MyPageCounter.Hits & "</font></b> Times ]
 --------------------------------------------------------------------------
 
 replace with this:
 --------------------------------------------------------------------------
 "& n b s p ;" (with out the spaces ok)
 --------------------------------------------------------------------------
 
 you can also remove this:
 --------------------------------------------------------------------------
 Set MyPageCounter = Server.CreateObject("MSWC.PageCounter")
 If Request.ServerVariables("REMOTE_ADDR") <> "192.168.0.6" Then 'Set the IP to your own IP (if you have a static one, else leave it be)
 MyPageCounter.PageHit 'Increments the Count
 End If
 --------------------------------------------------------------------------
 
 also I went to your site and I do not see the "scrollbars" at the bottom. hope this help, let me know ok?
 
 |  
                      | Edited by - serverhacker on 20 September 2002  00:25:00
 |  
                      |  |  | 
              
                | His Divine ShadowNew Member
 
  
 
                Finland84 Posts
 | 
                    
                      |  Posted - 20 September 2002 :  04:44:53   
 |  
                      | Ok, I found a style bug, in the page where I view my subscriptions, near the bottom. |  
                      | I'm here to donate blood...
 Someone elses...
 |  
                      |  |  | 
              
                | al_iguanaJunior Member
 
   
 
                138 Posts | 
                    
                      |  Posted - 20 September 2002 :  04:47:56     
 |  
                      | i removed the page-visits and now i get no scrolling at all. fixed. except if you view the page without loggin in, when the "register/logon" boxes mess it up, but i think i can fix that myself  
 i'm amazed at this forum and i'm amazed that i'm actually learning some ASP. thanks all. woot!
 |  
                      | ----
 
 Don't Dream It ~ Be It
 http://www.peppermintiguana.co.uk/cymrugothic/
 |  
                      | Edited by - al_iguana on 20 September 2002  04:51:02
 |  
                      |  |  | 
              
                | serverhackerJunior Member
 
   
 
                USA125 Posts
 | 
                    
                      |  Posted - 20 September 2002 :  04:56:10   
 |  
                      | first off, 
 His Divine Shadow, i am fixing the subscriptions problem ASAP. (FIXED SEE FIRST POST)
 
 al_iguana, i will proble be removing the page-visits if i find that it fixs that wide problem.
 
 |  
                      | Edited by - serverhacker on 20 September 2002  05:15:00
 |  
                      |  |  | 
              
                | MarkJHSenior Member
 
     
 
                United Kingdom1722 Posts
 | 
                    
                      |  Posted - 20 September 2002 :  05:27:46     
 |  
                      | Small bug: On Active Users, when you move the cursor over somebody's MSN symbol, rather than saying "Click to see xxxx's MSN Messenger Address" it says "Click to see 's MSN Messenger Address".  Works in members.asp. |  
                      | Bandlink.net - http://www.bandlink.net/
 Bandlink Music Forums - http://www.bandlink.net/forum/
 |  
                      |  |  | 
              
                | Benji2002Starting Member
 
 
 
                United Kingdom49 Posts
 | 
                    
                      |  Posted - 20 September 2002 :  06:41:11     
 |  
                      | serverhacker, I think ur probably not seeing the scroll bars because you have your screen res high. Set it to 800x600 and you'll see what he means. 
 Ben
 |  
                      |  |  | 
              
                | snerdleyNew Member
 
  
 
                USA65 Posts
 | 
                    
                      |  Posted - 20 September 2002 :  07:14:42   
 |  
                      | Confirm that removing the page views corrects the scrolling problem here. 
 snerd
 
 |  
                      | snerd
 
 |  
                      |  |  | 
              
                | al_iguanaJunior Member
 
   
 
                138 Posts | 
                    
                      |  Posted - 20 September 2002 :  07:20:26     
 |  
                      | quote:Originally posted by Benji2002
 
 serverhacker, I think ur probably not seeing the scroll bars because you have your screen res high. Set it to 800x600 and you'll see what he means.
 
 Ben
 
 
 
 i was going to say that, but it sounded too obvious
  
 re: the screen scrolling when you are logged off. i notice this happens on serverhackers demo site too (although he hasn't removed the page visits yet). could someone (who can work it out) change the logon boxes to look like this:
 
 username ***********
 password ***********
 LOGON * save password
 register | forgot password < small font
 
 it would be neater in one column (i've tried to work out how to do it but i can't under stand it.... tr and td everywhere
  ) 
 yeah, removing the page-visits has fixed the scroll problem on both user screens and admin screens. maybe the code could be fixed? its put in a table that is right aligned, 1% wide i think (sorry about my newbieness). is that causing the problem?
 |  
                      | ----
 
 Don't Dream It ~ Be It
 http://www.peppermintiguana.co.uk/cymrugothic/
 |  
                      | Edited by - al_iguana on 20 September 2002  07:43:13
 |  
                      |  |  | 
              
                | DelStarting Member
 
 
 
                8 Posts | 
                    
                      |  Posted - 20 September 2002 :  10:29:58   
 |  
                      | I have noticed that on the Site News, if I make an announcement and make it sticky (because I want it to remain the first annoucement). Adding additional news updates push it down regardless of what I do. Is this a bug? |  
                      |  |  | 
              
                | SmokeMeRotStarting Member
 
 
 
                Netherlands11 Posts
 | 
                    
                      |  Posted - 20 September 2002 :  10:38:31   
 |  
                      | Wow hackingMan great rebuild of the forum, tho my question : You have in front of the forum (1 dir higher) a defualt(asp,htm,html) & index(asp,htm.html) witch calls the sitenews of the forum , i recon this is a kewl way to actually "kinda have a redirection without messing op your foum/default" but the prob is (at least at myTest Site ) that when you login it says Yup but when the page returns you are not logged in. Is there a way to make this work ???? would be great,
 
 Also i got when i just put on the site a active_user.asp error, it  resolved when i renamed the DB_name ??? but dont fall over it it is working
  
 i also got a test of your forum on a local webserver and i am trying to implement a crash feature (the admin online/offline on posts) when i finally manage it to work problay i will mail you the zip file.
 |  
                      | ***Yeeeh***
 |  
                      |  |  | 
              
                | al_iguanaJunior Member
 
   
 
                138 Posts | 
                    
                      |  Posted - 20 September 2002 :  17:31:48     
 |  
                      | you need to modify topic.asp to correct a bug in the avatar mod, as discussed here : 
 http://forum.snitz.com/forum/topic.asp?TOPIC_ID=34509
 
 (it doesn't seem to affect your forum code, but its better to insert it just in case)
 
 around line 557 / topic.asp :
 
 
 
rR_MSGICON = 22
		if CanShowSignature = 1 then
			rM_SIG = 23
                        '#######Avatar Start########
                        if StrShowAvatar = "1" then
		              rM_AVATAR = 24
		              rM_AVATAR_WIDTH = 25
		              rM_AVATAR_HEIGHT = 26
	                end if
                else
	                if StrShowAvatar = "1" then
		        rM_AVATAR = 23
		        rM_AVATAR_WIDTH = 24
		        rM_AVATAR_HEIGHT = 25
	                end if
                        '######Avatar End########
                end if
 |  
                      | ----
 
 Don't Dream It ~ Be It
 http://www.peppermintiguana.co.uk/cymrugothic/
 |  
                      |  |  | 
              
                | sji2671Junior Member
 
   
 
                United Kingdom185 Posts
 | 
                    
                      |  Posted - 20 September 2002 :  19:13:13     
 |  
                      | I just did a clean install of the download from page 1, however I still get the following message when I click on a forum topic. 
 Microsoft JET Database Engine error '80040e10'
 
 No value given for one or more required parameters.
 
 /forum/forum.asp, line 331
 
 |  
                      |  |  | 
              
                
                |  Topic  |  |