Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Open)
 Moderation and Last Post Updates
 New Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 19 January 2011 :  20:51:30  Show Profile  Send ruirib a Yahoo! Message
Problem is that moderation is never checked for a topic edit. Actually, for an existing topic it doesn't really matter as you just need to check the topic_status and act accordingly (if the topic is approved, moderation does not matter anyway). So your suggestion is a good one. Please post it in full, with line numbers and all.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

SiSL
Average Member

Turkey
671 Posts

Posted - 19 January 2011 :  21:01:45  Show Profile  Visit SiSL's Homepage
Should I edit original post or post a new topic?

CHIP Online Forum

My Mods
Select All Code | Fix a vulnerability for your private messages | Avatar Categories W/ Avatar Gallery Mod | Complaint Manager
Admin Level Revisited | Merge Forums | No More Nested Quotes Mod
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 19 January 2011 :  21:08:25  Show Profile  Send ruirib a Yahoo! Message
Just post a final reply here with the working solution.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

SiSL
Average Member

Turkey
671 Posts

Posted - 19 January 2011 :  21:09:27  Show Profile  Visit SiSL's Homepage
BUG: When a user updates their unapproved topic, it is sent to Forum Listings as "Last Topic", even though it is not reachable, it is visible on main forum listings or category pages as "Last Topic" as described here http://forum.snitz.com/forum/topic.asp?TOPIC_ID=69803

FIX:

Open post_info.asp
Find following around line 735

else
			if mLev <> 4 and Moderation = "No" then
				'## Forum_SQL - Update Last Post
				strSql = " UPDATE " & strTablePrefix & "FORUM"
				strSql = strSql & " SET F_LAST_POST = '" & DateToStr(strForumTimeAdjust) & "'"
				strSql = strSql & ",    F_LAST_POST_AUTHOR = " & MemberID
				strSql = strSql & ",    F_LAST_POST_TOPIC_ID = " & Topic_ID
				strSql = strSql & ",    F_LAST_POST_REPLY_ID = " & 0
				strSql = strSql & " WHERE FORUM_ID = " & Forum_ID

				my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords



Change this line:

if mLev <> 4 and Moderation = "No" then


with following:

if mLev <> 4 and Moderation = "No" AND Topic_Status < 2 then


CHIP Online Forum

My Mods
Select All Code | Fix a vulnerability for your private messages | Avatar Categories W/ Avatar Gallery Mod | Complaint Manager
Admin Level Revisited | Merge Forums | No More Nested Quotes Mod

Edited by - SiSL on 19 January 2011 21:43:55
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000 Version 3.4.07