Visit sponsor for points version 1.1- Lesane store addon

New Version 1.2

Added feature to restrict members from visiting sponsors once per day. Download is below with instructions on how to upgrade

This hack was request not too long ago by someone. I don't know who, but I decided to alter my original working on this so that other vb site's could use it.

Essentially this allows member to visit sponsors of your choice to earn points toward whatever your site may use points for. You can control how many hits a sponsor can have to their site, etc. It was designed to work with the Lesane store hack and credit must be given to eiSecure for alot of the back bone behind this hack. I originally designed this to work with his contest add-on hack. So that websites could sponsor contests. But after seeing a request for this type of hack I decided to finish a stand alone version. So some of the coding is from the contest hack.

This hack should install pretty simply. It has been tested and functions properly. However if you have any problems I'll be more than happy to help.

Also feel free to PM me with any ideas or suggestions. Like everything with me I still deem it as work in progress.

[mewgood]

ya
I hope you can figur out a way asap
ya maybe they can use their points to buy a space at the sponsors page for a certain amount of time or for a certain amount of impressions.

[GeorgeofCS]

Done I've updated the coding to allow members to visit a sponsor only once per day.

I'm still working on a few more options. I'll be honest I'm still attempting to figure out how to do some of these things. I'll probably release a better updated script shortly as my members begin using it regularly.

[mewgood]

great
what's next?

[GeorgeofCS]

I'm working on a time requirement to viewing the sponsor before getting the points. So say the member has to stay at the sponsor for 30 seconds before getting the points, etc. I'm still taking ideas for future releases

[mewgood]

cool
possible for a member to pay points to post a banner on the sponsor.php for a certain amount of time or impressions?
?

[GeorgeofCS]

I fixed a bug in the sponsor.php file. It appeared to work fine originally, but it seemed to get the last visit of a sponsor stuck. So it's been updated and works fine now

[bensonfactor]

Getting errors when attempting to visit sponsor.

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT lastvisit FROM sponsor_visit WHERE userid='17' AND sponid='1'
mysql error: Table 'benson_forums.sponsor_visit' doesn't exist

mysql error number: 1146

Date: Saturday 19th of October 2002 05:06:10 PM
Script: http://forums.bluegoop.net/sponsor.p...onsee&sponid=1
Referer: http://forums.bluegoop.net/showthrea...6&pagenumber=2

[GeorgeofCS]

hmm seems that the readme file along the way was replaced by an old one. There's a couple of steps missing. Give me until the morning and I'll have it fixed. Along with a few additions.

[GeorgeofCS]

Ok I'm still making sure that the new code is working fine and trying to add a few things.
bensonfactor

do this query

PHP Code:

CREATE TABLE sponsor_visit (
  userid int(10) NOT NULL default '0',
  sponid int(10) NOT NULL default '0',
  lastvisit int(10) NOT NULL default '0'
) 


then make a template called

error_alreadyvisited

and add

You have already visited this site today. You are allowed to visit this site once every day.

I've rewritten the code some and added some features to allow you to choose how long between visiting sponsors, etc. I'm still testing these options and I'm going to attempt to add a few more things. So it will take a little bit longer before I have the updated bits.

[AsedaH]

did this ever get fixed?

just wondering