Author |
Topic |
Anacrusis
Junior Member
USA
219 Posts |
Posted - 09 July 2003 : 16:22:20
|
Points MOD Beta ver.1.0b Last Updated 7/9/03
Finally! The Points MOD Is ready for testing. Please install this on a development server only. Report bugs/fixes back here. Thanks.
DO NOT INSTALL ON PRODUCTION SERVER, THIS IS A VERY EARLY BETA RELEASE AND PROBABLY CONTAINS BUGS!
Description: This mod allows members to earn points by actively participating in the forums, they receive points for posting new topics and replying to existing ones. Points are also earned when changing ranks. The Points can then be used to 'buy' things like custom avatars, glowing username in posts, custom title etc...
Features: Admin can change points amount for each user Easily turn off points system Enable/Disable Point Actions Change Number of points earned for each action Change cost of store items Users can donate points to other users Members Start off with specified number of points upon registration. Optional Integration with PM Mod and Avatar Mod
Possible Features for future releases: A bank that members can put points in, they can then earn intrest on the points in the bank. Lottery system, admin sets up a lottery, members give points to participate and can win the jackpot if they win
--------- Installation difficulty: 8 (1=Easy - 10=Hard)
DO NOT INSTALL ON PRODUCTION SERVER, THIS IS A VERY EARLY BETA RELEASE AND PROBABLY CONTAINS BUGS!
Download: http://www.internet-clubhouse.com/download/pointsmod.zip < |
The Internet ClubHouse www.internet-clubhouse.com
|
Edited by - Anacrusis on 15 July 2003 07:59:25 |
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 09 July 2003 : 22:35:09
|
Ah! Anacrusis!
Thank you so much!!
Etymon < |
|
|
jeffery
Junior Member
USA
176 Posts |
Posted - 10 July 2003 : 01:05:30
|
Anacrusis, Installed fine. One little thing with the DB. I run MS SQL and INSERT will not work after the Identity row has been set. So I had to manually remove the Identity of the P_ACTION column in the POINT_ACTIONS and rerun the INSERT portion of that table. I'm not sure how you would rework this in the dbs file.< |
www.thomasforum.com |
|
|
Anacrusis
Junior Member
USA
219 Posts |
|
jeffery
Junior Member
USA
176 Posts |
Posted - 10 July 2003 : 11:42:00
|
So far. Except the avatar option in the store apparently doesn't work with some of the avatar mods I have. My forum doesn't populate the AVATAR_URL field just one called AVATAR. I am working on different code for this or not using that asa store option at all. Your code makes it easy to customize, very organized. Thank you for this!
< |
www.thomasforum.com |
|
|
Ez4arab
Junior Member
479 Posts |
Posted - 11 July 2003 : 09:43:19
|
i found error in this line 224
strSql = "update " MEMBERS set M_AVATAR_URL = '" & chkString(Request.Form("AvatarURL"), "SQLString") & "', " &_
it need to be look like this strSql = "update " & strTablePrefix & "MEMBERS set M_AVATAR_URL = '" & chkString(Request.Form("AvatarURL"), "SQLString") & "', " &_< |
Ez4arab web site Ez4arab | |
|
|
Anacrusis
Junior Member
USA
219 Posts |
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 14 July 2003 : 16:10:46
|
I found a few "/pstore.asp" referrals in the code, but updated them. The code has been placed on to one of my Snitz Forums I run and it works fine after some minor code changes. I have also made it so unregistered users can only view the points.asp page, as I figured they do not have an account yet to use the functions of pstore.asp.
Good work overall Anacrusis..
Cheers,
David< |
|
|
Anacrusis
Junior Member
USA
219 Posts |
Posted - 14 July 2003 : 21:08:19
|
What kind of changes did you make, so I can add them to the zip file. A left viewing of pstore.asp to unregistered used so they can see the types of things they can purchase, personal preference.
How was the install, I take it I didn't miss anything, this is my first real mod so I'm a little nervous about it. Anybody think it's ready to be taken out of beta phase?
< |
The Internet ClubHouse www.internet-clubhouse.com
|
|
|
Ez4arab
Junior Member
479 Posts |
Posted - 15 July 2003 : 12:38:37
|
i think he means this slash "/"< |
Ez4arab web site Ez4arab | |
Edited by - Ez4arab on 15 July 2003 12:41:40 |
|
|
Anacrusis
Junior Member
USA
219 Posts |
|
dacumen
Starting Member
25 Posts |
Posted - 30 July 2003 : 22:41:05
|
When I click to configure the store, I don't see anything to configure. Here's what it looks like to start...I'm not quite sure what to make of it.
Any suggestions on where to begin debugging this baby?< |
|
|
OpenIntro
Junior Member
USA
126 Posts |
Posted - 01 August 2003 : 18:19:56
|
Something that I thought of for this MOD that would be VERY helpful....Not sure if it is possible though.
I run an Official Forum for a band called BOWLING FOR SOUP. On the forum, we have a section called the Daily Clicks where there are threads with links in them to different places to VOTE or REQUEST for Bowling for Soup.
Now my question is, would there be a way to TRACK members going into the threads and clicking on the voting/requesting links? If so, points would go up and they could use these points in the store.
Any ideas or possibilities behind this? I think this MOD could be REALLY useful to me, but I don't know how much it is actively being worked on.< |
Let's All Do Kamikaze Shots! http://www.kamikazeshots.com http://www.kamikazeshots.com/forum *DO YOUR CLICKS!* http://dailyclicks.kamikazeshots.com |
|
|
Para
Starting Member
2 Posts |
Posted - 14 August 2003 : 22:30:30
|
Is there anyway / how can i add more features to the shop .... ?
Also i was wondering how do i config the points configuration in the admin options. I want to add more ways people can get points. Im kinda confused where it says "code" what do i put and whats it mean ?< |
Edited by - Para on 14 August 2003 23:12:12 |
|
|
Anacrusis
Junior Member
USA
219 Posts |
Posted - 15 August 2003 : 08:43:11
|
Setting up new store items and adding more way's of earning points is not easy. But here's basicly how to do it: To setup new ways of earning, Under "code", put any 3 letter code you want. Description, Point Value and Enabled are self explanatory. Now, you have to edit asp code, this is how you award points to a user:
PointValue = GetPoints("XXX")
'Replace "XXX" with the code that you just created
'## Forum_SQL - Update Total Post for user
strSql = "UPDATE MEMBERS "
strSql = strSql & " SET M_POINTS = M_POINTS + " & PointValue
strSql = strSql & " WHERE MEMBER_ID = " & AMembersID
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
Adding new store items gets a bit more complicated. You must go into the database and manually add a new record to STORE_ITEMS table, making note of the ID that gets assigned to it. Then, open up PurcahseItem.asp and add a new case to the case statement starting on line 62 with your new id number. Take a look at how the others are done as an example. Let me know if you have any trouble and I'll try and walk you through in more detail.
I'm on ICQ, MSN and AIM if you need me.< |
The Internet ClubHouse www.internet-clubhouse.com
|
|
|
Anacrusis
Junior Member
USA
219 Posts |
|
Topic |
|