vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Visit sponsor for points version 1.1- Lesane store addon (https://vborg.vbsupport.ru/showthread.php?t=44092)

GeorgeofCS 09-28-2002 10:00 PM

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.

Chris M 09-29-2002 04:26 PM

Sounds cool:)

Satan

LOD-squa 09-29-2002 05:39 PM

Sounds cool might install it

ZiRu$ 09-30-2002 01:21 AM

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

Areku 10-01-2002 09:27 AM

how come?

mewgood 10-07-2002 12:48 AM

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

GeorgeofCS 10-07-2002 10:12 AM

Sorry about that forgot one step :(

in the admin/index.php find

PHP Code:

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

add this after it

PHP Code:

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

I've find the readme file as well

mewgood 10-08-2002 01:28 AM

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

Erwin 10-08-2002 01:36 AM

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 10-08-2002 09:13 AM

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 10-08-2002 10:05 PM

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 10-08-2002 10:31 PM

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 10-08-2002 11:28 PM

great
what's next?

GeorgeofCS 10-09-2002 12:13 AM

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 10-09-2002 03:29 AM

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 10-15-2002 11:21 PM

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 10-19-2002 11:55 PM

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 10-20-2002 02:34 AM

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 10-20-2002 01:49 PM

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(10NOT NULL default '0',
  
sponid int(10NOT NULL default '0',
  
lastvisit int(10NOT 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 02-02-2003 05:25 AM

did this ever get fixed?

just wondering

auz1111 03-13-2003 02:54 PM

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

help please

kaotic 04-19-2003 08:43 AM

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 04-20-2003 04:28 PM

Quote:

Yesterday at 09:43 AM kaotic said this in Post #22
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/showthrea...173#post307173

chavalo2 04-21-2003 04:30 PM

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

Code:

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 04-26-2003 11:07 AM

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 04-27-2003 02:05 PM

Has anyone successfully tried this on 2.3.0???

Koutaru 04-27-2003 04:40 PM

I did ^^-- 2.3

The instructions were a bit awkward but I have it working

Dras 08-11-2003 03:59 AM

I tried it on 2.3.0 it works.

tpearl5 08-11-2003 04:44 AM

Please view this thread for a new idea thought of due to this hack: https://vborg.vbsupport.ru/showthrea...threadid=56100

:)

arifagic 09-06-2003 09:12 PM

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

https://vborg.vbsupport.ru/showthrea...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 09-30-2003 07:43 PM

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

esquared 09-30-2003 07:53 PM

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 09-30-2003 08:35 PM

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 11-05-2003 01:32 PM

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 02-03-2004 04:21 PM

Ooooh, looking forward to installing this hack!

-pk

bhutz 07-05-2004 09:09 PM

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 08-01-2004 11:51 PM

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

deSPIse 08-02-2004 12:00 AM

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


All times are GMT. The time now is 06:35 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01136 seconds
  • Memory Usage 1,811KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (3)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (38)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete