| Author |
 Topic  |
|
MaGraham
Senior Member
USA
1297 Posts |
 Posted - 05 December 2013 : 13:54:37
|
Is there a way for members to earn more points for replying to a particular topic? I'm just trying to get more to participate in a particular area.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
 |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 06 December 2013 : 00:07:24
|
Yes, you'd want to change the code in "inc_func_common.asp".
|
Edited by - Carefree on 06 December 2013 03:12:28 |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 06 December 2013 : 02:32:39
|
If I make this change, does this mean a member would now only receive points when posting to a particular topic, or will they still receive points for ANY posting?
I'm asking because I may not have made myself clear. I want them to continue to receive points for replying to ALL posts, just more points for a particular post.
Also, if I add more possible ways of them receiving points, how do I know what "code" to use?
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 06 December 2013 : 03:13:31
|
| All posts would continue to be awarded points, the point value for the forum number specified would be higher by the amount specified following it. |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 06 December 2013 : 10:55:15
|
The forum number is 10, and I chose 10 points.
If forum_id=10 Then GetPoints=GetPoints+10
It works fine, but it's giving 15 points. (lol) I won't complain about that though but just thought I'd let you know, Carefree.
What a NEAT way to get members more involved on a particular forum! I LOVE IT!!
Thank you so much, Carefree!
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 06 December 2013 : 11:30:59
|
Question: What if a member adds "glow" to his/her username and then decides he/she doesn't want it? What can I do to remove it?
Also, how could I make this "removal of glow" an option in the Points Store? Or, is that even possible? Your thoughts on this, Carefree?
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 06 December 2013 11:43:09 |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 06 December 2013 : 18:46:32
|
quote:
Originally posted by MaGraham
The forum number is 10, and I chose 10 points.
If forum_id=10 Then GetPoints=GetPoints+10
It works fine, but it's giving 15 points.
It's giving 15 because you selected 5 as the default. Ergo, 5 (GetPoints) + 10 = 15..... Change the + value to 5 if you want to award 10. |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 06 December 2013 : 18:49:56
|
quote:
Originally posted by MaGraham
Question: What if a member adds "glow" to his/her username and then decides he/she doesn't want it? What can I do to remove it?
Also, how could I make this "removal of glow" an option in the Points Store? Or, is that even possible? Your thoughts on this, Carefree?
I'll look at this one later, running out of time now. Tests in 13 minutes. |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 07 December 2013 : 09:25:49
|
OK - to remove, you could edit the database "Members" table and delete the content of the "M_Glow_Text" field for that member. Alternatively, you could replace two files (like normal, back them up, these are untested):
"pstore.asp"
"purchaseitem.asp"
|
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 07 December 2013 : 09:52:52
|
I'll come back to this, Carefree. I just realized this is causing an error when someone attemps to register, not allowing the registration to go through.
Here's the error message.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 5.1 Driver][mysqld-5.5.28]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' ')' at line 1
/fp/register.asp, line 774
Here are lines 759 - 779
end if
if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
else
strSql = strSql & ", ''"
end if
strSql = strSql & ", '" & ChkString(Request.Form("Referred"),"message") & "'"
strSql = strSql & ", 1"
' ## Points Below
strSql = strSql & ", " & GetPoints("REG")
' ## Points Above
strSql = strSql & ")"
strSql = strSql & ", '" & ChkString(Request.Form("Avatar_URL"),"SqlString") & "'"
strSql = strSql & ")"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
if strEmail = "1" and strEmailVal = "1" then
'Do Nothing
else
Call DoCount |
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
Edited by - MaGraham on 07 December 2013 09:56:03 |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 07 December 2013 : 11:06:58
|
| I need more of the file than that, all of that routine defining the strSql from the very first one ... not a strSql=strSql+... You really should make this a new topic. |
Edited by - Carefree on 07 December 2013 11:07:23 |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 08 December 2013 : 00:36:37
|
I have decided to just remove the "glow" option, Carefree. Gonna turn that option OFF.
Thank you much for your time on that!
And, sorry for all the trouble and time it took! 
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 08 December 2013 : 04:01:37
|
Carefree, I am trying to create an option for members to purchase "Name Tags" with their points. Could you possibly help me with this?
I'll probably have about fifty name tags for them to choose from so it might be best to have about ten name tag graphics on each page so it won't take each page so long to load.
I'd just need to be able to come behind you and add a picture of each name tag and then change the generic name you would probably have in that area.
I would either want a means of the members selecting a name tag or simply an area for them to type the NAME of the name tag, i.e. "Scottish Bagpipes," "Christmas Elf," etc.
My members post a LOT so let's say the price for each could be 1,000 points.
Their points would be deducted when they place their order but since I would then need to create the name tag (putting their name on the graphic they chose), how could I be notified of what they ordered? Oh, could there be a place for them to enter an email address for me to use to send their name tag to them? And, could the message they receive after purchasing a name tag be something like, "Your name tag should be ready within the next 72 hours and will be sent to the email address you have provided. If you have any questions please contact 'forum email address could go here'" (as a means of them contacting me).
Would this be something just too major?
I've edited the following files so here's a copy of mine, if you can help. I didn't edit the other files in the "Points" mod.
Here's my pstore.asp
Here's my PurchaseItem.asp.
Here's my points.asp.
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 08 December 2013 : 07:49:54
|
| This will take a while. I'll probably work on it piecemeal, instead of trying to do it all at once. |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 08 December 2013 : 12:51:57
|
GREAT! Thank you so much, Carefree! 
I am planning a Grand Opening of the new site for next week (Dec. 11) and I think this will really be enticing for the new members. 
The site has been open since the middle of October but only for a select group of members.
Members will get 25 points for each person they get to join the website. With the "Referral" mod you did, I am notified by email when someone registers and the email also tells me who referred the member to the site. YEA! That mod is the BEST!! And, that will obviously make it easy for me to award the member who invited the new member their 25 points.
I'm EXCITED! 
Thank you, again, Carefree! You are Sooo appreciated!!
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
|
Topic |
|
|
|
