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 MOD-Group
 MOD Add-On Forum (W/Code)
 Points MOD Beta
 New Topic  Reply to Topic
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 8

Anacrusis
Junior Member

USA
219 Posts

Posted - 09 July 2003 :  16:22:20  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
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  Show Profile  Visit Etymon's Homepage  Reply with Quote
Ah! Anacrusis!

Thank you so much!!

Etymon
<
Go to Top of Page

jeffery
Junior Member

USA
176 Posts

Posted - 10 July 2003 :  01:05:30  Show Profile  Reply with Quote
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
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 10 July 2003 :  08:18:06  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
I'm not sure either, does anybody else know how to do this?

Was that the only trouble you had?<

The Internet ClubHouse
www.internet-clubhouse.com
Go to Top of Page

jeffery
Junior Member

USA
176 Posts

Posted - 10 July 2003 :  11:42:00  Show Profile  Reply with Quote
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
Go to Top of Page

Ez4arab
Junior Member

479 Posts

Posted - 11 July 2003 :  09:43:19  Show Profile  Visit Ez4arab's Homepage  Reply with Quote
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 |
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 11 July 2003 :  16:15:02  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
Zip updated. Thanks.<

The Internet ClubHouse
www.internet-clubhouse.com
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 14 July 2003 :  16:10:46  Show Profile  Reply with Quote
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<
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 14 July 2003 :  21:08:19  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
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
Go to Top of Page

Ez4arab
Junior Member

479 Posts

Posted - 15 July 2003 :  12:38:37  Show Profile  Visit Ez4arab's Homepage  Reply with Quote
i think he means this slash "/"<

Ez4arab web site Ez4arab |

Edited by - Ez4arab on 15 July 2003 12:41:40
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 16 July 2003 :  08:17:34  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
quote:

works fine after some minor code changes


I assumed there were more changes.<

The Internet ClubHouse
www.internet-clubhouse.com
Go to Top of Page

dacumen
Starting Member

25 Posts

Posted - 30 July 2003 :  22:41:05  Show Profile  Reply with Quote
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?<
Go to Top of Page

OpenIntro
Junior Member

USA
126 Posts

Posted - 01 August 2003 :  18:19:56  Show Profile  Send OpenIntro an AOL message  Reply with Quote
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
Go to Top of Page

Para
Starting Member

2 Posts

Posted - 14 August 2003 :  22:30:30  Show Profile  Reply with Quote
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
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 15 August 2003 :  08:43:11  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
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
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 15 August 2003 :  08:46:22  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
dacumen, Sorry so late... did you get your problem straightend out?<

The Internet ClubHouse
www.internet-clubhouse.com
Go to Top of Page
Page: of 8 Previous Topic Topic Next Topic  
Next Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.17 seconds. Powered By: Snitz Forums 2000 Version 3.4.07