| Author | 
                
                  Topic   | 
                
              
              
                | 
                 gor 
                Retired Admin 
                      
                 
                
                Netherlands 
                5511 Posts  | 
                
                  
                    
                      
                       Posted - 25 July 2001 :  16:03:39
                        
                        
                      
  | 
                     
                    
                        ############################################### ########### IT IS FINALLY HERE !!! ############ ###############################################
  VERSION 3.3 of SNITZ FORUMS 2000 has been made available for download.
 
 
  Download it here: http://forum.snitz.com/download.asp
 
  ## WHAT IS NEW IN THIS VERSION ?
  New features in this version:
  * Complete Topic/Post Moderation
  A forum can be set to 1) no moderation (default) 2) topic moderation; topics need to be approved by a moderator before they are visible, replies are not moderated 3) reply moderation; topics are not moderated, but replies need to be approved by a moderator before they are visible 4) total moderation; both topics and replies to those topics need to be approved by a moderator before they are visible.
  * Topic Archiving
  Archive topics that haven't been active since a selected time per forum or all forums at once. Archived topics can still be viewed by members, existing links to archived topics still work. Archives can be searched and batchdeleted (all posts in archived forum are deleted).
  * Subscribe to Board / Category / Forum / Topic 
  Notification by e-mail no longer is limited to replies to existing topics but a members can now also subscribe to be notified of new posts in a forum or in all forums of a selected category. Depending on the setting by the administrator a member can also subscribe to the complete board, so that he/she gets notified by mail when ever there is a new post in any of the forums.
  * Improved unsubscribe
  The member now has a link to "My Subscriptions" where he can see all current subscriptions to either the Board/Categories/Forums and/or Topics. Here he can unsubscribe with one click of the button so the member no longer has to search for the topic that he subscribed to.
  * Short(er) urls
  Forum-titles and Topic-Titles are no longer passed in the urls of Forum.asp and Topic.asp That means that a member can link to a topic by using:
  TOPIC.ASP?TOPIC_ID=12345
  If a topic is archived the link doesn't break, if the topic isn't found in the live forum, and it exists in the archives, the visitor is automatically redirected to the correct topic in the archives.
  * Category and Forum ordering
  The Administrator can now order Categories and Forums within categories at will. So the no longer is any need for tricks like adding 1. / 2. / 3. etc. to the Category or Forumtitles to sort them.
  * Improved Members-page
  Members can now be searched by (part of) their Membername, Firstname or Lastname.
  * Fixed a lot of bugs
  Smaller bugs and bigger bugs. Added explicit recordsetclosing. Since Snitz Forums becomes more popular, hackers enjoy finding exploits in the code. We had to fix two security related bugs. Those two are enough reason to upgrade !
  * New CONFIG-table
  Instead of a table with a field per config-item, we now switched to a table with three fields that hold all configuration items. This makes it easier for MOD-builders to add extra configuration information to the database without the need of database upgradescripts. New configuration information stored in the table will automatically be loaded by config.asp so there too is no need for changes and modifications.
  ## IS IT HARD TO UPGRADE ?
  No, like promised will the setup.asp page take care of upgrading all versions since 3.1 All you need to do is upload the files, backup you database (to be safe) and run setup.asp All your members, forums, posts will still be there !
  So, what are you waiting for ? Download it here: http://forum.snitz.com/download.asp http://prdownloads.sourceforge.net/sf2k/sf2k_v33_02.zip (temp-link)
 
 
  Pierre Join a Snitz Mailinglist | 
                     
                   
                 | 
              
              
                | 
                 HuwR 
                Forum Admin 
                      
                 
                
                United Kingdom 
                20611 Posts  | 
                
                  
                    
                      
                       Posted - 25 July 2001 :  16:07:50
                        
                        
                      
  | 
                     
                    
                       well done gor.  
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 gor 
                Retired Admin 
                      
                 
                
                Netherlands 
                5511 Posts  | 
                
                  
                    
                      
                       Posted - 25 July 2001 :  16:12:33
                        
                        
                      
  | 
                     
                    
                       quote:
  well done gor.  
 
  
  Like always I can't take all the credit.  
  Now I'm going to take a few hours off, perhaps even a few days...  
  Pierre Join a Snitz Mailinglist | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 GauravBhabu 
                Advanced Member 
                      
                 
                
                4288 Posts  | 
                
                  
                    
                      
                       Posted - 25 July 2001 :  16:24:38
                        
                      
  | 
                     
                    
                       That is great! Aha!
  Share A Square atforumSquare
 
  gauravbhabu
  There is only one miracle...That is LIFE! | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Guru 
                Starting Member 
                 
                 
                
                32 Posts  | 
                
                  
                    
                      
                       Posted - 25 July 2001 :  16:30:29
                        
                      
  | 
                     
                    
                       quote:
 
 quote:
  well done gor.  
 
  
  Like always I can't take all the credit.  
  Now I'm going to take a few hours off, perhaps even a few days...  
  Pierre Join a Snitz Mailinglist
 
  
  Thank you all guys for this new version (I already have downloaded it) And Gor: Go to the beach and order some Heineken... (if it's in the neighbourhood of Amsterdam i will buy it for you).
  Now it's up to us getting headaches of putting the mods into the new version  
  Again: GREAT JOB you all folks!!!!!
  Guru
  ps. is there a simple way to make a testdir on my site beside's the "life" version to test and make the modifications on the "life" database. Again: thnx and cheers
 
 
  Edited by - Guru on 25 July 2001  16:32:24 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 big9erfan 
                Average Member 
                    
                 
                
                540 Posts  | 
                
                  
                    
                      
                       Posted - 25 July 2001 :  16:47:21
                        
                      
  | 
                     
                    
                       way to go guys!! 
  *clap clap clap* congrats on all the hard work finally coming to an end....
  Until SR 1  
  Hee hee....The old saying, A Software Engineers job is never.....EVER.....Done
  If you guys were paid for this at least you could enjoy the thoughts of job security  
 
  http://www.ugfl.net/forums | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Laocoon 
                Starting Member 
                 
                 
                
                USA 
                37 Posts  | 
                
                  
                    
                      
                       Posted - 25 July 2001 :  18:31:55
                        
                        
                      
  | 
                     
                    
                       I have downloaded the code and uploaded everything to my server.  But when I run the following page:
  http://forums.sweetsports.com/setup.asp
  I get a page that states the following:
  To upgrade the database you need to be logged on as a forum administrator.
  I am doing this as a clean install.
  So I can't login if there is no database setup already.
  Please help.
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 apollyon 
                Starting Member 
                 
                 
                
                1 Posts  | 
                
                  
                    
                      
                       Posted - 25 July 2001 :  19:10:05
                        
                      
  | 
                     
                    
                       does it allow for avatars?
 
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 HellRazor 
                New Member 
                  
                 
                
                59 Posts  | 
                
                  
                    
                      
                       Posted - 25 July 2001 :  19:56:05
                        
                      
  | 
                     
                    
                       HuwR, was wonderinf if you'll be putting Snitz with the mods you have added up on your web page this evening?
  HellRazor
 
 quote:
  well done gor.  
 
  
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 tangoc9999 
                Junior Member 
                   
                 
                
                USA 
                158 Posts  | 
                
                  
                    
                      
                       Posted - 25 July 2001 :  20:40:29
                        
                        
                      
  | 
                     
                    
                       salutations!
  TANGO 
  Computers run on smoke, when the smoke comes out, they quit running! 
 
   | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Jeepaholic 
                Average Member 
                    
                 
                
                USA 
                697 Posts  | 
                
                  
                    
                      
                       Posted - 25 July 2001 :  22:41:36
                        
                        
                      
  | 
                     
                    
                       Kickus bootimus. Great job, guys! Can't wait to find some time to do something with the new version.   
  Al Bsharah Jeepaholics Anonymous | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 suhern 
                Junior Member 
                   
                 
                
                186 Posts  | 
                
                  
                    
                      
                       Posted - 26 July 2001 :  04:41:12
                        
                      
  | 
                     
                    
                       I downloaded the new version but could not find the ACESS 2000 database. In the tools zip there is only an ACCESS 97 database, the 2000 cannot be found anywhere else. Please advise and thanks....
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 gor 
                Retired Admin 
                      
                 
                
                Netherlands 
                5511 Posts  | 
                
                  
                    
                      
                       Posted - 26 July 2001 :  06:05:06
                        
                        
                      
  | 
                     
                    
                       quote:
  I downloaded the new version but could not find the ACESS 2000 database. In the tools zip there is only an ACCESS 97 database, the 2000 cannot be found anywhere else. Please advise and thanks....
 
  
  Just use the Access 97 database the way it is, or open it in Access 2000 so it gets converted and use it then.
  Pierre Join a Snitz Mailinglist | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Spoon 
                Average Member 
                    
                 
                
                Ireland 
                507 Posts  | 
                
                  
                    
                      
                       Posted - 26 July 2001 :  07:45:58
                        
                        
                      
  | 
                     
                    
                       Does anybody get this error when they try to post a message?
  --------- Microsoft JET Database Engine error '80040e14' 
  The INSERT INTO statement contains the following unknown field name: 'C_STRMOVENOTIFY'. Make sure you have typed the name correctly, and try the operation again. 
  /snitz_1/post_info.asp, line 653  ----------------------------------
  Permissions are set
 
 
  Regards,
  Spoon, (ya all love me right?) | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Spoon 
                Average Member 
                    
                 
                
                Ireland 
                507 Posts  | 
                
                  
                    
                      
                       Posted - 26 July 2001 :  07:49:29
                        
                        
                      
  | 
                     
                    
                       There was a space there (line 653)
  my_Conn.Execute (strSql)
  I deleted the space but still no luck, ill keep on checking
  ------ Update -----
  This field "'C_STRMOVENOTIFY'" Is not in Forum_topics where the sql is trying to insert.
 
  Edited by - spoon on 26 July 2001  08:07:03
  Edited by - spoon on 26 July 2001  08:08:13 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 gor 
                Retired Admin 
                      
                 
                
                Netherlands 
                5511 Posts  | 
                
                  
                 | 
              
              
                
                
                  Topic   | 
                  |