Author |
Topic |
Anacrusis
Junior Member
USA
219 Posts |
|
Pouyan
New Member
91 Posts |
Posted - 17 September 2003 : 01:18:33
|
Nice work!!!
How long before you take it out of the beta phase?< |
|
|
Anacrusis
Junior Member
USA
219 Posts |
|
TccK
Starting Member
5 Posts |
Posted - 17 September 2003 : 12:08:15
|
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:
########################
### Admin_pstore.asp ###
########################
Line 83:
"<tr><td align=center bgcolor=""white""><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """><a href=""admin_pstore.asp?item=" & rs("P_ITEM") & """>" & rs("P_TITLE") & "</a></font></b></td></tr>" & VbNewLine
Changed it to:
"<tr><td align=center bgcolor=""" & strAltForumCellColor & """><b><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strHeadFontColor & """><a href=""admin_pstore.asp?item=" & rs("P_ITEM") & """>" & rs("P_TITLE") & "</a></font></b></td></tr>" & VbNewLine
Line 102:
Response.Write "<tr><td align=center bgcolor=""white""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strDefaultFontColor & """>" & rs("P_DESCRIPTION") & "<br><br></font>" & VbNewLine
Changed it to:
Response.Write "<tr><td align=center bgcolor=""" & strForumCellColor & """><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strDefaultFontColor & """>" & rs("P_DESCRIPTION") & "<br><br></font>" & VbNewLine
After I purchased some items I clicked the link and got a 404, here is why:
########################
### 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.< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
Anacrusis
Junior Member
USA
219 Posts |
|
dacumen
Starting Member
25 Posts |
Posted - 25 September 2003 : 19:30:56
|
quote: 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?< |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 30 September 2003 : 17:36:52
|
http://www.2enetworx.com/dev/projects/tableeditor.asp
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< |
coaster crazy |
|
|
Anacrusis
Junior Member
USA
219 Posts |
Posted - 01 October 2003 : 08:21:29
|
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.< |
The Internet ClubHouse www.internet-clubhouse.com
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 01 October 2003 : 12:40:17
|
cool, thank you I'll install it either tonight or Friday, will let you know how it goes < |
coaster crazy |
|
|
Gargoyle
Junior Member
USA
280 Posts |
Posted - 02 October 2003 : 22:27:28
|
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.. < |
Here is a link to my Snitz powered Drag Racing site. |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 03 October 2003 : 17:31:39
|
quote: 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< |
coaster crazy |
|
|
Ryan
Average Member
USA
858 Posts |
Posted - 10 November 2003 : 14:20:06
|
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.< |
The Poultry Link - "Serving the best of the fancy with the best of the web" Forum Setup Help |
|
|
Anacrusis
Junior Member
USA
219 Posts |
Posted - 10 November 2003 : 16:43:58
|
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.< |
The Internet ClubHouse www.internet-clubhouse.com
|
|
|
Ryan
Average Member
USA
858 Posts |
Posted - 10 November 2003 : 16:58:39
|
"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.< |
The Poultry Link - "Serving the best of the fancy with the best of the web" Forum Setup Help |
|
|
ehoffman73
Starting Member
45 Posts |
Posted - 12 November 2003 : 20:51:19
|
hear hear, would love to see those!!
quote: 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.
< |
|
|
Topic |
|