| Author | 
                
                  Topic   | 
                
              
              
                | 
                 bugfix 
                Starting Member 
                 
                 
                
                Singapore 
                47 Posts  | 
                
                  
                    
                      
                       Posted - 09 January 2001 :  10:59:43
                        
                      
  | 
                     
                    
                       I notice that if a user want to get a high rating of # posts. They can post a topic or a reply and then delete it, post again, delete again and again and again and again.
  The # of post still stays the same. Always increased when he/she post but never decreases when he/she delete her/his own post . This could lead to 'gaming' in order to gain most posts.
  Pls help.
 
 
  Moved by HuwR
  Edited by - Huwr on 09 January 2001  11:48:48 | 
                     
                   
                 | 
              
              
                | 
                 wii 
                Free ASP Hosts Moderator 
                      
                 
                
                Denmark 
                2632 Posts  | 
                
                  
                    
                      
                       Posted - 09 January 2001 :  11:22:15
                        
                      
  | 
                     
                    
                       yes, I have noticed this also!
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 HuwR 
                Forum Admin 
                      
                 
                
                United Kingdom 
                20611 Posts  | 
                
                  
                    
                      
                       Posted - 09 January 2001 :  11:48:12
                        
                        
                      
  | 
                     
                    
                       It is not a bug, the number of posts indicates just what it says, the number of post the user has made since joining.
  'Resistance is futile' | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kat 
                Advanced Member 
                      
                 
                
                United Kingdom 
                3065 Posts  | 
                
                  
                    
                      
                       Posted - 09 January 2001 :  12:25:45
                        
                        
                      
  | 
                     
                    
                       Can users delete the first topic in a thread now then? They couldn't in SR3 - they could only delete replies created by themselves.          
  KatsKorner
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 HuwR 
                Forum Admin 
                      
                 
                
                United Kingdom 
                20611 Posts  | 
                
                  
                    
                      
                       Posted - 09 January 2001 :  14:48:15
                        
                        
                      
  | 
                     
                    
                       quote:
  Can users delete the first topic in a thread now then? They couldn't in SR3 - they could only delete replies created by themselves.          
  KatsKorner
 
 
  
  No that has not changed
  'Resistance is futile' | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 bugfix 
                Starting Member 
                 
                 
                
                Singapore 
                47 Posts  | 
                
                  
                    
                      
                       Posted - 10 January 2001 :  03:12:46
                        
                      
  | 
                     
                    
                       If that's the case, is it possible to implement it in snitz ? Can anyone help me to decrease the # of post when they delete their own post or topic ?
  Thanks.
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 HuwR 
                Forum Admin 
                      
                 
                
                United Kingdom 
                20611 Posts  | 
                
                  
                    
                      
                       Posted - 10 January 2001 :  04:14:53
                        
                        
                      
  | 
                     
                    
                       the best thing would be to write a little admin tool that checked count vs actual posts, then if there is a huge discrepency, reset the users post count (maybe to teach them a lesson, set it back to zero)
  'Resistance is futile' | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kat 
                Advanced Member 
                      
                 
                
                United Kingdom 
                3065 Posts  | 
                
                  
                    
                      
                       Posted - 10 January 2001 :  04:18:50
                        
                        
                      
  | 
                     
                    
                       quote:
  the best thing would be to write a little admin tool that checked count vs actual posts, then if there is a huge discrepency, reset the users post count (maybe to teach them a lesson, set it back to zero)
 
 
  
  That is a bit harsh Huw isn't it? What about setting the post count to the actual number of posts on site for that user at that time, rather than zero.....
  KatsKorner
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 RichardKinser 
                Snitz Forums Admin 
                      
                 
                
                USA 
                16655 Posts  | 
                
                  
                    
                      
                       Posted - 10 January 2001 :  04:37:25
                        
                      
  | 
                     
                    
                       Ok, how about this:
  I added this to the Do Counts section of inc_functions.asp (around line #1353)
 
 sub DoUMinusCount(sUser_Name)   	'## Forum_SQL - Update Total Post for user 	strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS " 	strSql = strSql & " SET " & strMemberTablePrefix & "MEMBERS.M_POSTS = " & strMemberTablePrefix & "MEMBERS.M_POSTS - 1 " 	strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & sUser_Name & "'"   	my_Conn.Execute (strSql)   end sub 
 
  Then in pop_delete.asp
  on line #49 I inserted this:
 
 			if strDBNTUserName = Request.Form("User") and mLev < 3 then 				DoUMinusCount Request.Form("User") 			end if
  This will decrease the post count by 1 each time someone deletes their own reply
  Edited by - Richard Kinser on 10 January 2001  04:51:47 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kat 
                Advanced Member 
                      
                 
                
                United Kingdom 
                3065 Posts  | 
                
                  
                    
                      
                       Posted - 10 January 2001 :  04:39:47
                        
                        
                      
  | 
                     
                    
                       Great Richard..  
  Is this one best left out of future releases though because not everyone may want to do this??
  KatsKorner
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 RichardKinser 
                Snitz Forums Admin 
                      
                 
                
                USA 
                16655 Posts  | 
                
                  
                    
                      
                       Posted - 10 January 2001 :  04:45:45
                        
                      
  | 
                     
                    
                      |  I like the way it is now.  Because if you want to go through and delete old posts, the user's post count doesn't go down as well.  I also go through and delete some of my old posts that aren't relevant anymore.  A user would be less inclined to do so if their post count went down when they did this. | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kat 
                Advanced Member 
                      
                 
                
                United Kingdom 
                3065 Posts  | 
                
                  
                    
                      
                       Posted - 10 January 2001 :  04:49:36
                        
                        
                      
  | 
                     
                    
                       That is exactly what I was thinking. It is sometimes necessary to do a clean up and delete those posts that have not had a response for a while, or have been locked for ages. I know my users wouldn't appreciate potential loss of stars!  
  KatsKorner
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 RichardKinser 
                Snitz Forums Admin 
                      
                 
                
                USA 
                16655 Posts  | 
                
                  
                    
                      
                       Posted - 10 January 2001 :  04:53:26
                        
                      
  | 
                     
                    
                       I had to add the and mLev < 3 so that Moderators and Admins post count wouldn't be decreased if they delete someone else's reply.
  I'm sure there is a better way to do a check to make sure that only the person who posted the reply is getting their post count reduced. | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 HuwR 
                Forum Admin 
                      
                 
                
                United Kingdom 
                20611 Posts  | 
                
                  
                    
                      
                       Posted - 10 January 2001 :  05:15:23
                        
                        
                      
  | 
                     
                    
                       quote:
  I like the way it is now.  Because if you want to go through and delete old posts, the user's post count doesn't go down as well.  I also go through and delete some of my old posts that aren't relevant anymore.  A user would be less inclined to do so if their post count went down when they did this.
 
  
  So do I, here at Snitz we are currently cleaning out old posts, I'm sure users here wouldn't want their counts to go down while I am merrily deleting their posts.
  'Resistance is futile'
  I posted a mod awhile back which allowed you to place a delay between allowed posts, you could use this, it may deter them if they have wait 60 seconds before being able to make their next post
  Edited by - Huwr on 10 January 2001  05:16:40 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 bugfix 
                Starting Member 
                 
                 
                
                Singapore 
                47 Posts  | 
                
                  
                    
                      
                       Posted - 11 January 2001 :  08:00:59
                        
                      
  | 
                     
                    
                       Hi, i think you guys mis-intepret my idea.
  I agree with the idea that we should not re-count the user # of post, since we may delete certain topics or posts that are no longer relevant or being used anymore.
  but my intention is, if a user delete THEIR own posts, then we have to decrease their # of post, that's all.
  Pls help, or give suggestion on which table to decrease # of post. thank you very much for your kind attention.
 
 
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Kat 
                Advanced Member 
                      
                 
                
                United Kingdom 
                3065 Posts  | 
                
                  
                    
                      
                       Posted - 11 January 2001 :  08:06:31
                        
                        
                      
  | 
                     
                    
                       bugfix,
  That would be FORUM_MEMBERS.. and FORUM_TOPICS and FORUM_FORUM...
  KatsKorner
 
  Edited by - kat on 11 January 2001  08:07:00 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                
                
                  Topic   | 
                  |