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
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 8

Anacrusis
Junior Member

USA
219 Posts

Posted - 02 September 2003 :  08:01:58  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
take a look in your database, is there anything in the FORUM_STORE_ITEMS table?<

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

Gargoyle
Junior Member

USA
280 Posts

Posted - 02 September 2003 :  13:23:00  Show Profile  Visit Gargoyle's Homepage  Reply with Quote
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.
Go to Top of Page

ehoffman73
Starting Member

45 Posts

Posted - 06 September 2003 :  02:27:21  Show Profile  Reply with Quote
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.<
Go to Top of Page

ehoffman73
Starting Member

45 Posts

Posted - 06 September 2003 :  02:34:19  Show Profile  Reply with Quote
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!<
Go to Top of Page

ehoffman73
Starting Member

45 Posts

Posted - 06 September 2003 :  02:37:20  Show Profile  Reply with Quote
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!!<
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 06 September 2003 :  12:04:45  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
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
Go to Top of Page

Ez4arab
Junior Member

479 Posts

Posted - 09 September 2003 :  13:28:09  Show Profile  Visit Ez4arab's Homepage  Reply with Quote
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 |
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 09 September 2003 :  14:36:11  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
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
Go to Top of Page

Ez4arab
Junior Member

479 Posts

Posted - 10 September 2003 :  11:59:35  Show Profile  Visit Ez4arab's Homepage  Reply with Quote
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 |
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 10 September 2003 :  12:11:31  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
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
Go to Top of Page

Ez4arab
Junior Member

479 Posts

Posted - 10 September 2003 :  12:43:53  Show Profile  Visit Ez4arab's Homepage  Reply with Quote
I did the code give me your comment download beta code<

Ez4arab web site Ez4arab |
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 10 September 2003 :  13:51:58  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
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
Go to Top of Page

Anacrusis
Junior Member

USA
219 Posts

Posted - 10 September 2003 :  15:42:47  Show Profile  Visit Anacrusis's Homepage  Send Anacrusis an AOL message  Reply with Quote
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
Go to Top of Page

Ez4arab
Junior Member

479 Posts

Posted - 10 September 2003 :  16:31:25  Show Profile  Visit Ez4arab's Homepage  Reply with Quote
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 |
Go to Top of Page

Ez4arab
Junior Member

479 Posts

Posted - 13 September 2003 :  00:34:23  Show Profile  Visit Ez4arab's Homepage  Reply with Quote
Is it possible to the member to takeoff the Glow form his/her name if they apply it?
<

Ez4arab web site Ez4arab |
Go to Top of Page
Page: of 8 Previous Topic Topic Next Topic  
Previous Page | 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.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07