Ali Bilgrami wrote:
hey there mate...just found out a bug...after givin someone a thanks if i give them thanks again it says i've already thanked him AND it adds up the points where it SHUDNT be doing that |
i corrected the bug and change the link in my first message. if you edit your own pop_karizma.asp file :
cut that code (at line 29 to line 36:
'Initliase the SQL query to get the thread details from the database
strSQL = "SELECT tblThread.Author_ID, tblAuthor.username, tblAuthor.Karizma FROM tblThread, tblAuthor WHERE tblThread.Thread_ID = " & lngThreadID & " AND tblAuthor.Author_ID = tblThread.Author_ID ;"
rsCommon.Open strSQL, adoCon, 2, 3
pf= rscommon("Author_ID")
user = rscommon("username")
rscommon("karizma")=rscommon("karizma")+2
rscommon.update
rscommon.close
and paste between
end with
(here)
Call closeDatabase()
Thanked = " Thanked to " &user
like this:
End With
'Initliase the SQL query to get the thread details from the database
strSQL = "SELECT tblThread.Author_ID, tblAuthor.username, tblAuthor.Karizma FROM tblThread, tblAuthor WHERE tblThread.Thread_ID = " & lngThreadID & " AND tblAuthor.Author_ID = tblThread.Author_ID ;"
rsCommon.Open strSQL, adoCon, 2, 3
pf= rscommon("Author_ID")
user = rscommon("username")
rscommon("karizma")=rscommon("karizma")+2
rscommon.update
rscommon.close
Call closeDatabase()
Thanked = " Thanked to " &user
taht's it...
Edited by gölge - 01 June 2006 at 11:56am