| Author |
 Topic  |
|
|
zerakh
Junior Member
120 Posts |
 Posted - 22 September 2005 : 18:00:14
|
I just installed the Points Mod. is there any way that I could use the current post counts and registrations to count towards these points?
THe way it is now is that the current users that have posted do not have any points and must start over in order to accumulate the points while the newer users are able to bypass the older users. |
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 22 September 2005 : 23:45:24
|
I don't know exactly how the Points MOD works (though I've considered it for a couple different projects I'm working on), but here's what I might suggest.
Write a script (or if you have few enough members, you do this manually) that will check the following:
# of topics started by a certain member
# of posts - # of topics (# of replies to posts)
Then simply do the math to figure out what their point total should be and update the appropriate fields in the database. |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
 |
|
|
zerakh
Junior Member
120 Posts |
Posted - 23 September 2005 : 07:23:40
|
| wouldnt mind doing that, but I havent a clue where to start or what codes to use.... |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 23 September 2005 : 23:45:41
|
| I can try taking a look early next week. I have a wedding to attend this weekend, so I won't be doing much of anything else. Perhaps someone more familiar with the Points MOD could take a look and figure out what would be needed. |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
zerakh
Junior Member
120 Posts |
Posted - 23 September 2005 : 23:59:17
|
I also get something really odd for any poster after I installed this. after every new post (not the first topic posted, but each reply) I get a number below the users name (in the signature area)
something similar to this::
20050917224613
the numbers vary per post, per user, and per forum (but always starts out with most of those numbers)
I appreciate your help. Enjoy your weekend, Im not in that big of a rush ;)
thanks |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 24 September 2005 : 00:29:39
|
| Looks like it's writing the post date for some reason. That string looks like 9/17/2005, 22:46:13 converted into a string. Check that against the actual post time and see if that's what it is. If so, find in the code (near the signature area) where it's sending a Response.Write for the post time or post date. Don't know exactly what the variable name is, but you should be able to find it without a lot of trouble. |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
zerakh
Junior Member
120 Posts |
Posted - 24 September 2005 : 11:33:24
|
ok, I was playing around with the code for this mod and ended up with a few other problems.
I think I managed to fix the date stamp showing, but I cant start posts correctly and I cant see the replies without having an error.
quote:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'GetPoints'
/forum/inc_func_count.asp, line 59
(sometimes its on line 61)
the code for this section::
quote:
Sub doUCount(sUser_Name, pType, GotNewRank)
If pType = "T" Then 'user posted new topic
PointValue = GetPoints("NFT")
ElseIf pType = "R" Then 'user posted a reply
PointValue = GetPoints("NFP")
Else
PointValue = 0
End If
If GotNewRank Then PointValue = PointValue + GetPoints("LVU")
'## Forum_SQL - Update Total Post for user
strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " SET M_POSTS = M_POSTS + 1, "
strSql = strSql & " M_POINTS = M_POINTS + " & PointValue
strSql = strSql & " WHERE M_NAME = '" & ChkString(sUser_Name, "SQLString") & "'"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
end sub
With these new errors, the points stop adding up.
depending on where I put the code listed for inc_func_common depends on the errors I will get.
Sometimes I get an error within my chkdate function::
It tells me that the cLng is a mismatch.
quote:
Type mismatch: 'cLng'
/forum/inc_func_common.asp, line 812
line 812::
if cLng(Mid(fTime, 9,2)) > 12 then
on a side note:: is it possible to allow admins/moderators regulate the point system, ie. dock points from a user depending on the post that was made or to increase the points per individual user? |
|
|
|
zerakh
Junior Member
120 Posts |
Posted - 29 September 2005 : 19:59:16
|
| any word on this one? |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 30 September 2005 : 01:39:41
|
| I've been a little busier than planned. Hopefully I'll have time tomorrow night after work to take a quick look for you. |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
zerakh
Junior Member
120 Posts |
Posted - 30 September 2005 : 08:01:40
|
thats fine, more than expected actually...thank you
just didnt want it to die away unanswered |
|
|
| |
Topic |
|
Topic Locked
