View Full Version : Visit sponsor for points version 1.1- Lesane store addon

29 Sep 2002, 17:15
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.

Chris M
29 Sep 2002, 17:26
Sounds cool:)


29 Sep 2002, 18:39
Sounds cool might install it

30 Sep 2002, 02:21
that is a great idea.....but on my new forum I'm gonna stop using Lesanes store hack :(

01 Oct 2002, 10:27
how come?

07 Oct 2002, 01:48
how come when I click the adminsponsor.php it turns out a blank page?

07 Oct 2002, 11:12
Sorry about that forgot one step :(

in the admin/index.php find


add this after it

makenavoption("Modify","adminsponsor.php?action=modifysponsor", "|");

I've find the readme file as well

08 Oct 2002, 02:28
is it possible to limit the user the number of clicks a day?

08 Oct 2002, 02:36
Be aware that some advertisers disallow incentivized clicks in their TOS because their ads are no longer targeted, so make sure you read the license agreement you have with your advertiser. :)

08 Oct 2002, 10:13
I'm working on that tid bit and hope to have it shortly with a few other tweaks. I'm attempting to figure out an easy way to do this, but I'm having some problems figuring out exactly how to do it.

Erwin did bring up a good point some advertisers don't allow incentive clicks. I personally use things that are related to the site or advertisers that specifically know they are being used in this manner. Also for my board members I'm looking into ways for them to use points to buy sponsorships to send people to their site.

08 Oct 2002, 23:05
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.

08 Oct 2002, 23:31
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.

09 Oct 2002, 00:28
what's next?

09 Oct 2002, 01:13
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 :)

09 Oct 2002, 04:29
possible for a member to pay points to post a banner on the sponsor.php for a certain amount of time or impressions?

16 Oct 2002, 00:21
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 :)

20 Oct 2002, 00:55
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.php?s=&action=sponsee&sponid=1
Referer: http://forums.bluegoop.net/showthread.php?s=&threadid=926&pagenumber=2

20 Oct 2002, 03:34
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.

20 Oct 2002, 14:49
Ok I'm still making sure that the new code is working fine and trying to add a few things.

do this query

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


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.

02 Feb 2003, 06:25
did this ever get fixed?

just wondering

13 Mar 2003, 15:54
uh...is there supposed to be a link the the adminsposor page from the Admin CP? I am not getting one...

help please

19 Apr 2003, 09:43
Yes, I'm a bit confused about this too. I followed your instructions, but where am I suppose to edit my sponsor's link in?

20 Apr 2003, 17:28
Yesterday at 09:43 AM kaotic said this in Post #22 (http://www.vbulletin.org/forum/showthread.php?postid=384099#post384099)
Yes, I'm a bit confused about this too. I followed your instructions, but where am I suppose to edit my sponsor's link in?

21 Apr 2003, 17:30
Not sure how you guys are doing this but is there a reason when I run the code in mysql I get these errors:

CREATE TABLE sponsors (
id int(11) NOT NULL auto_increment,
name tinytext NOT NULL,
sponban text NOT NULL,
sponlink text NOT NULL,
sponpoint int(11) NOT NULL default \'0\',
sponday int(11) NOT NULL default \'0\',
sponexp int(11) NOT NULL default \'0\',
sponhits int(11) NOT NULL default \'0\',
KEY id (id)

MySQL said:

You have an error in your SQL syntax near '\'0\',
sponday int(11) NOT NULL default \'0\',
sponexp int(11) NOT NULL de' at line 6

I can't get past first step :(

26 Apr 2003, 12:07
O_o it worked fine for me -- I just did it a few seconds ago in phpmyadmin

I got this hack up and working. It took awhile though because some of the instructions were a bit confusing :)

Nicely made -- everything works!

27 Apr 2003, 15:05
Has anyone successfully tried this on 2.3.0???

27 Apr 2003, 17:40
I did ^^-- 2.3

The instructions were a bit awkward but I have it working

11 Aug 2003, 04:59
I tried it on 2.3.0 it works.

11 Aug 2003, 05:44
Please view this thread for a new idea thought of due to this hack: http://www.vbulletin.org/forum/showthread.php?s=&threadid=56100


06 Sep 2003, 22:12
I so this hack of your`s great work by the way ;)


But i have a great suggestion..

If you add a survay or a quastion that members need`s to answer right so then they get the points.. Like

To Get Like 100 Poinst then have to answer a quastion that you can give instructions how to get.. and if the answer is right then the member get`s his points.. ?

what do you think ? is it hard ?

30 Sep 2003, 20:43
I got it working, but isn't adding the points I don't think. :(

30 Sep 2003, 20:53
Ok, NM. I got the points working. But is there anyway that if you have it setup that you only want them to be able to earn points one time it still redirects them to the sponsor instead of the error page? Cause even right now with having it setup to unlimited visits I get the error page after one.

30 Sep 2003, 21:35
NM, I managed to do it myself. Plus also managed to set it up so if a guest clicks on a banner it doesn't take to the error page.

05 Nov 2003, 14:32
Is the time set in which you setup so people can earn points for clicking in seconds, minutes, hours or what? I put mine in second form and it isn't working.. :(

03 Feb 2004, 17:21
Ooooh, looking forward to installing this hack!


05 Jul 2004, 22:09
Has anybody modded this so that it works for VB 3.0.1?
I think I see where the query is insert new values into the database but I need to find the equivalent for the uCash database fields...any idea :ermm:

02 Aug 2004, 00:51
does anyone know how you can reorder the sponsors once they are placed?

02 Aug 2004, 01:00
umm for some reason when i click a sponsor banner it just pop ups the same window and doesnt bring up the sponsor's page