Author |
Topic |
Anacrusis
Junior Member
USA
219 Posts |
|
Gargoyle
Junior Member
USA
280 Posts |
Posted - 02 September 2003 : 13:23:00
|
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.< |
Here is a link to my Snitz powered Drag Racing site. |
|
|
ehoffman73
Starting Member
45 Posts |
Posted - 06 September 2003 : 02:27:21
|
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
Starting Member
45 Posts |
Posted - 06 September 2003 : 02:34:19
|
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
Starting Member
45 Posts |
Posted - 06 September 2003 : 02:37:20
|
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
Junior Member
USA
219 Posts |
Posted - 06 September 2003 : 12:04:45
|
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.< |
The Internet ClubHouse www.internet-clubhouse.com
|
|
|
Ez4arab
Junior Member
479 Posts |
Posted - 09 September 2003 : 13:28:09
|
quote: Originally posted by Anacrusis Users can donate points to other users
Is it possible to get the names of donate? < |
Ez4arab web site Ez4arab | |
|
|
Anacrusis
Junior Member
USA
219 Posts |
Posted - 09 September 2003 : 14:36:11
|
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)
and add this code below it: strSql = "insert into " & strTablePrefix & "DONATERS (FROM_ID, TO_ID, D_AMOUNT) values (" & MemberID & ", " & GetMemberID(Request.Form("dTo")) & ", " & DonateAmount & ")" my_Conn.Execute (strsql)
havn't tested it, but it should work...< |
The Internet ClubHouse www.internet-clubhouse.com
|
|
|
Ez4arab
Junior Member
479 Posts |
Posted - 10 September 2003 : 11:59:35
|
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.< |
Ez4arab web site Ez4arab | |
|
|
Anacrusis
Junior Member
USA
219 Posts |
Posted - 10 September 2003 : 12:11:31
|
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.< |
The Internet ClubHouse www.internet-clubhouse.com
|
|
|
Ez4arab
Junior Member
479 Posts |
|
Anacrusis
Junior Member
USA
219 Posts |
Posted - 10 September 2003 : 13:51:58
|
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 :) < |
The Internet ClubHouse www.internet-clubhouse.com
|
|
|
Anacrusis
Junior Member
USA
219 Posts |
Posted - 10 September 2003 : 15:42:47
|
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. < |
The Internet ClubHouse www.internet-clubhouse.com
|
|
|
Ez4arab
Junior Member
479 Posts |
Posted - 10 September 2003 : 16:31:25
|
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 web site Ez4arab | |
|
|
Ez4arab
Junior Member
479 Posts |
Posted - 13 September 2003 : 00:34:23
|
Is it possible to the member to takeoff the Glow form his/her name if they apply it? < |
Ez4arab web site Ez4arab | |
|
|
Topic |
|