Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/45879?pagenum=1
05 November 2025, 00:07
Topic
Anacrusis
Points MOD Beta
09 July 2003, 16:22
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
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 <
Replies ...
Etymon
09 July 2003, 22:35
Ah! Anacrusis!
Thank you so much!! Etymon <
jeffery
10 July 2003, 01:05
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.<
Anacrusis
10 July 2003, 08:18
I'm not sure either, does anybody else know how to do this?
Was that the only trouble you had?<
jeffery
10 July 2003, 11:42
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!
<
Ez4arab
11 July 2003, 09:43
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") & "', " &_<
Anacrusis
11 July 2003, 16:15
Zip updated. Thanks.<
Classicmotorcycling
14 July 2003, 16:10
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
14 July 2003, 21:08
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?
<
Ez4arab
15 July 2003, 12:38
i think he means this slash "/"<
Anacrusis
16 July 2003, 08:17
works fine after some minor code changes
I assumed there were more changes.<
dacumen
30 July 2003, 22:41
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
01 August 2003, 18:19
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.<
Para
14 August 2003, 22: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 ?<
Anacrusis
15 August 2003, 08:43
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:
Code:
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
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.<
Anacrusis
15 August 2003, 08:46
dacumen, Sorry so late... did you get your problem straightend out?<
Para
15 August 2003, 10:41
not at the mo aint had time to mess with it since i posted it .. gonne try and mess with it today, ill let ya knwo how i get along ..
Thanks<
Heynow
21 August 2003, 22:33
Very nice Anacrusis...Good job!<
Gargoyle
23 August 2003, 14:47
So far I really like this MOD and I think you have done a very good job at it. What I would like to know in a little more detail is how to award points and how to set-up store items. I see the code you posted above but have no idea where to put it and how to implement it's functions. I guess I am asking for a walk through type of set-up. Possibly a zipped instruction manual so to speak.
Thanks Anacrusis for sharing this MOD. <
acoustika
23 August 2003, 20:24
Hello There, nice Mod
Im setting up a forum in denmark and I am currently testing all the different Mods to see which one's i would like for my form, I like this mod, bur I'm not much of a programmer, more a Super-User of designing programs. So my question is:
Would it be possible to: make the "# og point" i user profiles disappers if one turns the POINT system off.
Reason: To have the mod installet, and to have it ready for a future feature, and because of this I dont want the users to see that there is something that has to do with points.
Maybe it could be nice too, if the already bought points_features could be removed from all members and selective members. And it could be VERY NICE if the titel_feature you can purchase wouldn't allow the Administrator & the Moderator title
Also I think I found a BUG, in the GLOWING Username Strengt field, if you put a very high number I would get an error, a minor thing I know, but is'nt it possibel to restrict the amount of digit's in the field???( ex. 2 digit's would be enough)
But anyways
Good good job<
acoustika
23 August 2003, 20:55
ME AGAIN!!!!
I saw another possibility. Still the above is kind of a request But another thing that could be great was that if I would be able to turn the POINT system ON, but the FEATURE SHOPPING system OFF, so that my users would earn points, but the SHOP would be closed, and not show as a link to anyboby, in this way the points system could funktion as a semi-rank system, and if so, it could be nice if it was possible to show the users points in their posts also, ex. under their title, maybe even as a feature for the admin to turn on/off.
Maybe even extend it to where, there was POINTS, and there were SHOPPING POINTS, in that way, then my users wouldn't have a lot of points if I suddenly would turn the shop on, well i dont know, I'm kind of an Idea man so I could go on and on .....
EDITED: A great Idea, I would like an option to grant selected members acces to using HTML, build into this point MOD it could be really great. It could be a VERY VERY expensive feature to buy, but really something to thrive for, if your forum does NOT allow html in post *SS*.
But great program it is Snitz 2000 *S*<
Anacrusis
24 August 2003, 00:08
acoustika:Those are all execllent ideas and would like to implement some of them. The great thing about the points system is that you could use it for sooo many things. I use it instead of reall money for my football pool on my site. Maybe if I release a new version I'll include those. Thanks!
Gargoyle: Contact me via AIM or MSN and I'll help you out. You have to know ASP to setup store items and way's of earning points, but I'm more than happy to walk you through it.<
acoustika
24 August 2003, 01:55
Thank's Anacrusis *S*
I have made a BRAINSTORMING Topic, and there I also have a couple of suggestions for the POINT MOD, you can see it Here
ex. A feature to vote for profiles, buy votes. Could also be at MOD by it self ex. A feature to see when you will shift ranks, graphical counter maybe EDITED: And Anacrusis as you mention yourself, the system can be used to a lot (Alot of thanks for making it *S*.
Also therefore it really would be excellent if there were actually 2 Points variables which seperately could be administrated, and as a bad ass feature, one could refer to the COUNTS you have chosen in the MEMBERS RANKING CONFIGURATION (should also be selective), now in a FAQ page tell bout the ranks and vupti, members can see when its time for shifting rank, really badass with a graphical counter.
Maybe also the one variable name or both (title, ex.:Points) would be configuable.
Also maybe, the opportunity to have a memberlist of users that are capable of having a picture in their profil. Then this could also be at very exclusive feature to buy in a non-picture forum.
How about making users able to buy different sized Avatar's at different costs.<
Heynow
24 August 2003, 06:35
Originally posted by Anacrusis
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
Really looking forward to any add-ons to this mod. I am not a programer, so I can only make suggestions.
1. Points for referals: Maybe a something in register.asp where a newbie can add the username of who they were refered by.
2. Points for signature: Members will need to purchase the ability to use their signature.
3. Points Poll: Extra points for members who add a poll.
Thanks again Anacrusis for this great mod..<
Gargoyle
24 August 2003, 16:27
Anacrusis I would love to send you a message with MSN but you have left me no ID number.. <
dacumen
29 August 2003, 19:36
Originally posted by Anacrusis dacumen, Sorry so late... did you get your problem straightend out?
No, still not sure what to do to get the store to show up. Above you mentioned manually adding store items to the database. Is that what I need to do?<
Anacrusis
30 August 2003, 01:14
No, the store comes with items already in it. Post a text copy of your page and I'll take a look for you.<
dacumen
31 August 2003, 22:49
http://www.partyutah.com/forum/pstore.txt
here ya go. Thanks. <
Ez4arab
01 September 2003, 16:41
I am testing this code on my local computer. I found a bug on file pstore.asp error explain
if member try to login to the forum form this page (pstore.asp). An error appear to the users after login
Code:
• Error Type: Microsoft VBScript runtime (0x800A000D) Type mismatch: 'sha256' /1/inc_header.asp, line 189 • Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) • Page: POST 74 bytes to /1/pstore.asp • POST Data: Method_Type=login&Name=1&Password=1&SavePassWord=true&Login.x=55&Login.y=9
I decide to add this code to fix this bug <!-- #INCLUDE FILE="inc_sha256.asp"-->
<
Anacrusis
01 September 2003, 20:43
dacumen, You said you can't view the page for managing the store. In that case I need admin_points.asp. Also can you view the source code from IE for the page that's causing you trouble. There maybe an error message that's not printing to the screen.
Thanks ez4arab for finding the bug.<
dacumen
02 September 2003, 00:27
Sorry about that:
http://www.partyutah.com/forum/admin_pstore.txt
http://www.partyutah.com/forum/admin_points.txt
Actually, it's not that I can't view the page, it's that there doesn't seem to be anything there to manage. The page loads fine.
By the way, thanks for your help on this one. It's a great Mod. I know I must be missing something stupidly simple!<
Anacrusis
02 September 2003, 08:01
take a look in your database, is there anything in the FORUM_STORE_ITEMS table?<
Gargoyle
02 September 2003, 13:23
Anacrusis, Since my attempts to contact you have failed I tried to add a way for my users to get points on my own by using the code and instructions you posted previously on page one.
I inserted the code into to correct area of the asp page.
I added the code to the admin section and enabled it.
I then went to test the code and nothing happened. I did exactly as you said but for some reason it did not update the points for that member.
If there is a way that I can contact you please let me know as my previous attempts have failed.<
ehoffman73
06 September 2003, 02:27
My store looked like that...there was an error in the mod setup so it didn't add the default items...I owuld love to get those items put in there, is there a listing somewhere?
I manually added one myself; what I am not sure I understand is what to call an item so the system knows what to do with glowing text for example.<
ehoffman73
06 September 2003, 02:34
Okay, got the items in from the mod code...
Now, I click on the item to donate points, for example, but it goes to a blank page. Does it need to be an identity of 1500 as in that page, or can I just use my own sequence?
How does the custom avatar one work?
Thanks, great mod!<
ehoffman73
06 September 2003, 02:37
Okay, solution to the store items showing up...I just changed the "case" value in the purchaseitem.asp file to match my identity field numbers.
Very cool. Now if I can just learn ASP enough to figure out how to modify the colors. Cold Fusion guy learning this new fangled deal!!<
Anacrusis
06 September 2003, 12:04
Glad it's working for you. I coded all items starting with 1500, any numbers would work as long as you change the case statement as you have. For all the listings, take a look at the dbs file where it loads the defaults in.<
Ez4arab
09 September 2003, 13:28
Originally posted by Anacrusis
Users can donate points to other users
Is it possible to get the names of donate?
<
Anacrusis
09 September 2003, 14:36
yea it's possible, pretty simple to do just create a new table called "FORUM_DONATERS" with the following fields: FROM_ID integer TO_ID integer D_AMOUNT integer
create a unique index on from_id and to_id
find the following code in purchaseitem.asp around line 89: strSql = "update MEMBERS set M_POINTS = M_POINTS - (" & DonateAmount & " + " & ItemCost & ")" &_ " where MEMBER_ID=" & MemberID my_Conn.Execute (strsql)
I think you forget somthing to give Donters_ID as auto key It worked fine. I will try to build the code for display the members.<
Anacrusis
10 September 2003, 12:11
You don't need a auto increment field in this table. That's why I said make FROM_ID and TO_ID the unique key. Doesn't really matter much, I just don't like making fields that arn't needed.<
Does it work? It looks like it should. Two things though: 1)You don't need Donters_ID, it serves no purpose.
2)In your sql statement, you have the line that joins the members table to the donaters table commented out... it won't work correctly like that.
Other then that it looks good, maybe I'll put in in a new realease :) <
Anacrusis
10 September 2003, 15:42
I apologize, I must not be thinking clearly. You are right, you do need a auto increment 'donater_id' field because a member could donate to another member more then once. So it wouldn't make sense to have the to_id and from_id the unique index. I apologize for doubting you. <
Ez4arab
10 September 2003, 16:31
Sorry, I made this code for Arabic maybe it will be difficult for you to read it. It is just test our ideas.
Regarding to SQL commented. If we try to play with the code a member can shows his denotation using IF...End if statement <
Ez4arab
13 September 2003, 00:34
Is it possible to the member to takeoff the Glow form his/her name if they apply it?
<
Anacrusis
13 September 2003, 22:28
No, not currently. It would have to be done manually by you I guess. That's a good thing to have for a future release though :)<
Pouyan
17 September 2003, 01:18
Nice work!!!
How long before you take it out of the beta phase?<
Anacrusis
17 September 2003, 08:14
When I'm sure I found most all bugs. I'd also like to find a way to make it more user friendly.<
TccK
17 September 2003, 12:08
Anacrusis,
I downloaded the ZIP yesterday and installed the MOD in my test forum.
I found: the background color of my forum is black, and default font color white, so I had some trouble administering the shop, to fix do following:
After I purchased some items I clicked the link and got a 404, here is why:
Code:
######################## ### PurchaseItem.asp ### ######################## Line 367: Response.Write "<p align=center><a href=""/pstore.asp"">Back to Store</a></p>" & VbNewLine Changed it to: Response.Write "<p align=center><a href=""pstore.asp"">Back to Store</a></p>" & VbNewLine
I also made some adjustments to get the points to show up in the post right beneath the number of post and one to get a preview of the glow when purchasing.
If U are interested in that, mail me. My test forum is fully modded and I don't wanna post wrong line numbers etc. here. I can send U the modified files(s), so U can make descend MOD-material out of it.<
Anacrusis
17 September 2003, 13:20
Yea, I'd be interested in seing that, shoot me an email <
dacumen
25 September 2003, 19:30
Originally posted by Anacrusis take a look in your database, is there anything in the FORUM_STORE_ITEMS table?
:-( I'm ashamed to admint this, but I installed Snitz with MSSQL and I don't have a database interface to see what's going on inside the tables. If I'd been thinking, I could have used MySQL and just used phpMyAdmin to look around, but thats life. I think I'm hosed.
Any other ideas?<
download, upload to your site, edit the files as necessary in the read me and you'll be able to view the contents of your db online.
question about, I also run my forum/site on MS SQL, I noticed on the first page there was something about the insert command not working in MS SQL, I was wondering if this has since been fixed. I am going to a new version, redoing my site so to say, and want this points mod to be a new feature in the re-release of my site So just checking to see if it's ready to run on ms sql.
WWS<
Anacrusis
01 October 2003, 08:21
It works fine with MSSQL, but when running the dbs file, default values couldn't be inserted. If you run into this problem, remove the identity attribute in the POINT_ACTIONS table, rerun the dbs, then put the identity back on. You should be fine.<
weeweeslap
01 October 2003, 12:40
cool, thank you I'll install it either tonight or Friday, will let you know how it goes <
Gargoyle
02 October 2003, 22:27
Anacrusis... I am sorry I have been very bust lately and have not had a chance to get a hold of you. I am still very interested in learning how to add new ways for my members to earn points and I will be trying to get a hold of you soon!
Thanks for your understanding.. <
weeweeslap
03 October 2003, 17:31
Originally posted by Anacrusis ...If you run into this problem, remove the identity attribute in the POINT_ACTIONS table, rerun the dbs, then put the identity back on...
Pardon my little knowledge, but can you perhaps walk me through this through SQL Enterprise Manager?
Thank You
WWS<
Ryan
10 November 2003, 14:20
A really nice MOD. Thank you Anacrusis! I do have a couple of suggestions which would really soup this MOD up:
1. Make it so that you can select a single user (or list of users) to be "store-keeper". That way the admin wont have to worry about the store as much (you will see later why.) An easy way to do this is to have a password protected pages (say pstore_manage.asp) that you can let users (that you select as store keepers) know what the password is.
2. Change the code so that admins (and store keepers) can add/delete points for any given user.
3. Modify the code so that a the admin (and store keepers) can get rid of glowing text, avatars, etc..)
4. Change it so that from the admin section the administrator can add a new store item that may have nothing to do with the forum. IE you can add a new store item so that when a user buys the item the storekeepers are either e-mailed, pmed, or the messages are put in the pstore_manage.asp itself letting the storekeepers know what items were puchased. The item can then be given to the user and his/her points reduced.
I may cook up some more later.<
Anacrusis
10 November 2003, 16:43
Those are great ideas and I've actually implented some of them already. Take a look at the store on my site. I've now modified it so users can buy more then one item, create a wishlist of items that can then be purchased as gifts by other members. I've also made it quite a bit easier to add store items. Hopefully someday I'll make all these changes into a seconed realease of this mod.<
Ryan
10 November 2003, 16:58
"Hopefully someday"
I hope that is very soon. I have the MOD installed but I am hesitant to let my users know about it because I really would like to add these other things first.<
ehoffman73
12 November 2003, 20:51
hear hear, would love to see those!!
Originally posted by Anacrusis Those are great ideas and I've actually implented some of them already. Take a look at the store on my site. I've now modified it so users can buy more then one item, create a wishlist of items that can then be purchased as gifts by other members. I've also made it quite a bit easier to add store items. Hopefully someday I'll make all these changes into a seconed realease of this mod.
<
Medic397
12 November 2003, 23:20
Another Idea anacrusis when you get around to it is a way to add things to the store not relating to the forum such as things like cups/mugs and so forth and a way to track who purchased it so that it can be mailed to them!<
Medic397
13 November 2003, 15:12
For those of you that are interested I did some tinkering to get the points total to show up in topic.asp right under the posts count: Here is where you need to insert the code and what needs to be inserted.
At both Instances that this occurs:
" <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>Points: " & Reply_MemberPoints & "</small></font><br />" & vbNewLine & _ So that it looks like this:
Response.Write " <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>" & Reply_MemberPosts & " Posts</small></font><br />" & vbNewLine & _ " <font color=""" & strForumFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """><small>Points: " & Reply_MemberPoints & "</small></font><br />" & vbNewLine & _ That should be it. Hope you find a good use for this!<
Medic397
13 November 2003, 15:33
Also have a question for you anacrusis? I have just installed the Links Manager 3.0 and was looking a spot to add the GetPoints function to allow users to get points for putting in a link. If you could help out with this it would be greatly appreciated. Here is a link to my links.txt file
http://www.coruscantonline.net/forum/links.txt<
MarcelG
29 February 2004, 07:31
Anacrusis, just question ; is development of this mod still going on ? Or has it been cancelled ?
I am looking for some way of encouraging my members to post _contributing_ posts, instead of spam, and I thought that this mod might help.<
Anacrusis
02 March 2004, 21:28
I've completly rewritten the points system for my site. But sadly I will not release it as a mod just because of the work that would be involved for the conversion. Please don't ask me for my code either, I am not willing to give it out. Sorry.<
nyquist
21 March 2004, 08:43
Anacrusis, i've installed your MOD and it works fine. I've found that there are some features coded but not enabled. In PurchaseItem.asp there are the 'case' statements needed to change other users title, create own forum, buy lottery ticket and Change shout box text, but they're not in the STORE_ITEMS table. Now i'm wondering if adding them to the table is enough to enable them. If so i can just use a dbs file to achieve the result.
Thanks in advance
nyquist<
nyquist
17 April 2004, 07:06
bump<
fishsticks
17 April 2004, 20:15
Anacrusis...
Thank you for the mod. I installed it, but it doesn't work. When I try to enter admin_point.asp I get "Syntax Error" at line 3098.
Does Avatar Mod necissarily have to be installed for this to work?<
Linare
18 April 2004, 09:29
it says the following lines are in POP_profile.asp ... am I blind, or are they not in there?
line 499 find this: " <td bgColor=""" & strPopUpTableColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & ChkString(rs("M_NAME"),"display") & " </font></td>" & VbNewLine & _ <
Linare
18 April 2004, 09:34
I found this code on line 506 ... is this what he was talking about?
" <td bgColor=""" & strAltForumCellColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """>" & ChkString(rs("M_NAME"),"display") & " </font></td>" & vbNewLine & _ <
Linare
18 April 2004, 20:42
Aha, found it ... i think.<
Linare
18 April 2004, 20:44
Anacrusis, if you still read this, I'd like to ask you a question.
I'm learning ASP, and should know enough to begin devloping mods for the Snitz Forums. Since this is such a great mod and you decided to quit it, would you be fine with me taking up what you have here, and further developing it?<
pknaz
03 May 2004, 15:34
Linare,
If anacrusis gives you permission to further his code, I may be willing to help you with this. I would really like to implement some form of this MOD into our intranet, but sadly it will need a lot of work in order to benifit me.
Let me know <
Anacrusis
04 May 2004, 14:56
Your more then welcome to do anything you'd like with the code.<
twentythree
30 June 2004, 14:24
I'm not the greatest programmer but I know a little about ASP so I'm starting to modify this code a bit. I also wanted a feature that would allow them to turn off the glow for free. So I added that. Here's the code in case anyone is interested:
You have to add this into the PurchaseItem.asp page:
Code:
'========= Case 1510 'Remove glow from name '========= CreateTable(ItemTitle) If DoIt <> True Then Call ShowStats() Response.Write "Click the submit button below to remove the glow feature<br>from your username on the topic & profile page.<br><font size=""" & strFooterFontSize & """>Remember, this can not be undone and it will cost you more points if you want to re-add the glow feature again!</font>" CloseTable(1) Else strRemoveGlow = "" strSql = "update " & strTablePrefix & "MEMBERS set M_GLOW_TEXT = '" & strRemoveGlow & "', " &_ "M_POINTS = M_POINTS -" & ItemCost &_ " where MEMBER_ID=" & MemberID my_Conn.Execute (strsql) UpdateItemCount Response.Write "<br>Congratulations, you've removed the glow effect from your name." Call BackToStore CloseTable(0) End If
Also you have to manually add the store item to the database. So if your Autonumber on that item in not 1510 just be sure to change it in the Case # in this code so that it knows what store item to reference from the database.
I'm going to be *trying* to build a page that lets you add store items w/out having to manually do it in the database. BUT, you still have to write the code into that purchaseitem.asp page... (no biggie). I want to add simple things like buy a font for your username for like 25 points, change the style for 50 and buy bigger avatar usage. But it's pretty hard, I will try my best and I will post my code as I go here.<
awin24
09 July 2004, 01:04
i'm having a problem, please help!
this is what i get EVERYTIME i post something, it accepts the post, but it give error at the buttom as well,
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'doULastPost'
/forums/post_info.asp, line 1785
i had problems creating tables too on the db file! please help!!<
Jotts
21 November 2004, 23:31
Can't edit members points from Profile.. i did place code in but nothing...<
What's the current status?
The one I downloaded by Chuck, of snitzbitz is filled with BUGS (Glow don't work, login errors on the pstore.asp page etc. etc.) So I am forced to remove this mod, although I very much liked the concept.
Anybody picked it up and did something with it?
<
ILLHILL
13 January 2005, 18:19
Is it really that hard to get one decent answer?
This mod is great, when it works and will support posting by members, but nobody is willing to tell me if this is ever finished and if so, by who.
Thanks in advance<
ILLHILL
19 January 2005, 22:02
I got it to work :-)<
ILLHILL
20 January 2005, 05:57
Let me know if anybody want a working version of this.
I need to fix one little thingy (as posted in Mod W/O code forum).
Greets
Dominic<
twentythree
27 January 2005, 00:26
I got this mod to work as well... it's sorta a pain but I was able to add more features to it as well... If anyone is interested in the code feel free to contact me.
You can see it in action at http://www.bodyartforms.com/forumsV9/<
TStewartFan
27 January 2005, 20:17
You ain't kidding about it being a pain. The stel mod was a real brain buster but it was worth the pain.....makes for an interesting freebie in the store. Will work on the lottery ticket soon since I have a pot growing right now from the sale of all the other items...might as well do something with them....lol Nice job on the stylings....i have not even tried it but then again there is a lot i am still learning about it.<
ILLHILL
28 January 2005, 20:58
Soon as someone helps me on the last two issues I posted in the W/O Code borad, I will wrap it up and re-release it as the bug-free edition.
And yeah, this code was a pain in the *spot-where-the-sun-don't-shines*
Greets & anjoy your weekends to all.
Dominic <
Dubie
16 February 2005, 03:57
Any luck on releaseing a working copy of this mod yet?<
TStewartFan
16 February 2005, 06:14
It works now.....I have implemented this into my site as part of my race for the cup. He is just working on a cleaner version of the code i suppose.<
morbidpalooza
23 February 2005, 09:15
I cant get it to work worth a crap :(<
hawkdrean
17 March 2005, 19:50
Has anyone got a version that works on Multi-Language Skin3D Portal<
andretti
27 March 2005, 21:10
This is a nice looking mod but I would like to be able to reward members with actual items like for instance 2500 points = 1 free dvd or something along those lines..
Has anyone been able to make this mod or something similiar be able to do that?<
andretti
02 April 2005, 21:56
Ok I went ahead and installed thsi and I will adapt it to fit my needs. It installed without a problem with 15 minutes and so far it seems to be working good..
Now my question is this to anyone that knows this code.....
How would I go about adding this mod so that when members post 1) A new Classified Ad they will recieve points 2) Post a new Link they will also recieve points 3) Upload a picture into the photo album they recieve points
If anyone can point me in the right direction of what I need to do I would be extremely grateful!<
CJones
06 April 2005, 03:56
Does anyone have a link for the working MOD?<
ebelthite
23 August 2005, 09:49
Here is two mods that I got working :
1 - get points for adding a web link to the web links manager
add 'WEB' to pstore
Links.asp after the lines:
Code:
Else Response.Write "Link Submitted." End If
add:
Code:
PointValue = GetPoints("WEB")
'## Forum_SQL - Update Points for user strSql = "UPDATE " & strTablePrefix & "MEMBERS " strSql = strSql & " SET M_POINTS = M_POINTS + " & PointValue strSql = strSql & " WHERE MEMBER_ID = " & MemberID
I have implemented the mod successfully, but I need an addition... Can I get a list of all my members with their points? Currently there is no such option... I need to rank them based on points earned...
<
Shaggy
15 September 2006, 07:55
Do you want to show the points on members.asp or do you want a completely seperate page?
<
sachin
15 September 2006, 10:05
Originally posted by Shaggy Do you want to show the points on members.asp or do you want a completely seperate page?
anything will do... but they must be sorted based on their points... also, is it possible to have some feature using which the admin can change the points of members randomly... for eg, supposedly a member makes an objectionable post, then i must be able to deduct his points rather than awarding him 5 points as in the current system...
<
JBaldwin
15 September 2006, 20:26
Originally posted by sachin
... also, is it possible to have some feature using which the admin can change the points of members randomly... for eg, supposedly a member makes an objectionable post, then i must be able to deduct his points rather than awarding him 5 points as in the current system...
This part you can accomplish by going into that members profile. The points are near the Signature Box. You can adjust the points to anything you want to assign them.<
sachin
15 September 2006, 21:35
Originally posted by JBaldwin
This part you can accomplish by going into that members profile. The points are near the Signature Box. You can adjust the points to anything you want to assign them.
nopes... when i try editing a memebr, their points are not shown, so the points cannot be edited... when i try editing my own profile, the points are shown and can be edited - i hope the memebrs are not getting this option, else they can adjust their points to whatever they want<
<
Could also be at MOD by it self
<
<
<