| Author |
 Topic  |
|
|
woodywyatt
New Member
61 Posts |
 Posted - 19 December 2008 : 07:09:10
|
| I'm would like to set up a classifieds section where users can post advertisements for a small fee. Is there a MOD that would handle this?< |
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 19 December 2008 : 07:30:19
|
| You'll have to a search here for the key words you just mentioned. You may not find an exact topic for what you want, but you may find several topics that contribute to your answer.< |
 |
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 07 January 2009 : 16:20:20
|
there is a classified MOD but it's for free using the user login from SNITZ, what you can do is add a new field to the USER table say: "advertisement" from type bit (1/0) and in the classPlaceAd.asp add a script that performs a query requesting this field... if "1" then show the Post Button, if "0" disabled all fields (you can use jquery to do this in just 3 lines of code) and hide the Post button adding a message (a div) saying that, to post they need to buy a membership...
build a new page with access to paypal (for example) and when retrieving the information that the payment was successfully, UPDATE the user filed value to "1" and voilá!
Updated: instead of messing with the USER table, create two new tables with this fields:
[ADS_PAYMENTS]
USER_ID
PAYMENT_DATE
PAYMENT_VALUE
DURATION (in days or months)
[ADS_ALLOWEDMEMBERS]
USER_ID
ACCESS_UNTIL (PAYMENT_DATE + DURATION)
so you can save a log of payments and present a message (or send email) to users one month before the credit expires... for example.< |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
Edited by - balexandre on 07 January 2009 16:35:19 |
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 07 January 2009 : 18:46:25
|
| Or you could use the existing subscription mod and if they've subscribed (and it's current), let them post advertisements.< |
|
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 08 January 2009 : 20:42:59
|
quote:
Originally posted by Carefree
Or you could use the existing subscription mod and if they've subscribed (and it's current), let them post advertisements.
For this kind of things, you should always use a new table to hold logs like payment date, amount, full message from paypal, paypal transfer id, etc... so you can get this later on or provide an invoice to the user.
lets imagine that a user cant pay... should always be saved the attempt and error messages (in an error or NotSuccessful table to not mess up with the Successful payments, dont you agree?< |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
|
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 08 January 2009 : 23:09:13
|
| I think I'd rather keep it simple. Create a subscription option, let those who have current subscriptions post advertisements, prohibit those who haven't. Done deal.< |
|
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 09 January 2009 : 02:28:19
|
| but he wanted to that be subject of an online payment ... you should save the payment information!< |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
|
|
|
Webbo
Average Member
United Kingdom
982 Posts |
Posted - 13 January 2009 : 18:40:45
|
Save the email from the payment processor - easy enough
Also, once you start to take payments you will need to keep accounts and within the database is not the ideal way.
Simply create an Excell spreadsheet and you can record everything you need and be able to share it with bookeeper/acountant/ etc< |
Edited by - Webbo on 13 January 2009 18:41:21 |
|
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 14 January 2009 : 07:53:07
|
guys, we are in the 21th century and you use Excel ???
we have databases to keep everything in one place, we have invoice software, and so many new things, you are kind'a late on this matter I can see.
you do as you want, I do like I do, and to tell you something, I've been invoicing my programming work for more than 10 years now without any money spend in book keeping personal! At least I know what I am talking about ... humpff... excel!!!< |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
Edited by - balexandre on 14 January 2009 07:53:58 |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 14 January 2009 : 09:24:10
|
and what may i ask do you think is wrong with using excel ?
Excel is a spreadsheet, it has a totally different use to a database, so why are you comparing them. i suggest you get into the 21st century and find out what the difference between a spreadsheet and a database is before making such sweeping statements< |
|
|
|
balexandre
Junior Member
Denmark
418 Posts |
Posted - 14 January 2009 : 10:29:30
|
this is the same as, "why do we need to use Source Control?? I always did my backups and can always see latest versions of my code"
the answer is the same, after you do things in the right way, we will never go back, and you will end up saying "Why didn't I use this before! so headaches so worries... for nothing"
I have my share part of 'Excel', but there are MUCH better, there are tools (DB) to keep our stuff in order... why am I bordering.
as said, before, you all do how you love more, I know, from my end what I am talking about, I've been there and look back I hated! I just wanted to give the best choice to the fellow.< |
Bruno Alexandre
(Strøby, DANMARK)
"a Portuguese in Danmark"
|
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 14 January 2009 : 10:32:07
|
Then suggest the free edition of QuickBooks Online.  < |
|
|
|
woodywyatt
New Member
61 Posts |
Posted - 20 January 2009 : 05:54:47
|
Thanks for the suggestions so far. I have now managed to get the classified MOD up and running here http://www.fuerteventura-forum.com/classifieds.asp
This works fine - user enters details, ad gets sent to admin for approval , admin sets ads live.
Now we'd like to try and get the payment part working - i.e. as soon as the details are sent to admin, users are then sent to the PayPal payment page.
If anyone has any ideas or is willing to sell us the code, please let us know.
Many thanks< |
Edited by - woodywyatt on 20 January 2009 05:55:27 |
|
|
| |
Topic |
|
Pay to post?
