Visit sponsor for points version 1.1- Lesane store addon

[GeorgeofCS]

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]

Sounds cool:)

Satan

[LOD-squa]

Sounds cool might install it

[ZiRu$]

that is a great idea.....but on my new forum I'm gonna stop using Lesanes store hack :(

[Areku]

how come?

[mewgood]

how come when I click the adminsponsor.php it turns out a blank page?

[GeorgeofCS]

Sorry about that forgot one step :(

in the admin/index.php find

makenavoption("Add","announcement.php?action=add","|");
makenavoption("Modify","announcement.php?action=modify");
makenavselect("Announcements");

add this after it

makenavoption("Add","adminsponsor.php?action=newsponsor","|");
makenavoption("Modify","adminsponsor.php?action=modifysponsor", "|");
makenavselect("Sponsors");

I've find the readme file as well

[mewgood]

is it possible to limit the user the number of clicks a day?

[Erwin]

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. :)

[GeorgeofCS]

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.

[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.php?s=&action=sponsee&sponid=1
Referer: http://forums.bluegoop.net/showthread.php?s=&threadid=926&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

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

[auz1111]

uh...is there supposed to be a link the the adminsposor page from the Admin CP? I am not getting one...

help please

[kaotic]

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?

[bgtking]

Yesterday at 09:43 AM kaotic said this in Post #22 (https://vborg.vbsupport.ru/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?
https://vborg.vbsupport.ru/showthread.php?postid=307173#post307173

[chavalo2]

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\',
PRIMARY KEY (id),
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 :(

[Koutaru]

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!

[glo]

Has anyone successfully tried this on 2.3.0???

[Koutaru]

I did ^^-- 2.3

The instructions were a bit awkward but I have it working

[Dras]

I tried it on 2.3.0 it works.

[tpearl5]

Please view this thread for a new idea thought of due to this hack: https://vborg.vbsupport.ru/showthread.php?s=&threadid=56100

:)

[arifagic]

I so this hack of your`s great work by the way ;)

https://vborg.vbsupport.ru/showthread.php?s=&threadid=44092

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 ?

[esquared]

I got it working, but isn't adding the points I don't think. :(

[esquared]

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.

[esquared]

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.

[esquared]

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.. :(

[pcoskat]

Ooooh, looking forward to installing this hack!

-pk

[bhutz]

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:

[deSPIse]

does anyone know how you can reorder the sponsors once they are placed?

[deSPIse]

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