vB Affiliates v.2

[AN-net]

vB Affiliates v.2

Author: Antonbomb22

Description:
Now add,manage,display all your communties/boards affiliates in a simple and organized fashion.

Features:
-Administration Panel
-multiple affilliates
-image button verification
-modules
-top listing
-types/categories
-reporting system
-rating system
-in and out clicking system
-redirects
-delay system
-disclaimers
-extremely customizeable
-display options
-pagination
-approval system
-usergroup permissions
-active system
-image buttons

Changes from Version 1:
-administration intergrated better
-added a delay system
-added a report system
-4 new modules
-display options
-pagination
-click in features with buttons so affiliates may link back
-cached templates
-quicked load speeds
-image button verification
-more options
-approval system
-usergroup permissions

Known Bugs:
-if an affiliates site goes down completely the verification/validation system will report errors

Some notes(usually rare):
-server load may increase a little bit if you have all modules active
-load time may a little bit increase if you have image validation on

Live Demo:
http://www.animationation.net/community/affiliate.php
http://www.game-realms.net/vb/affiliate.php?do=listaffiliates

Offical Support/Suggestion forum: http://www.animationation.net/community/forumdisplay.php?f=58

plz click install;)

Enjoy;)

edit:
attachment updated, wrong queries for upgrade instruct.
updated zip file with new template edit
updated zip file with new affiliate.php
update zip file with new queries
Those who has alrdy downloaded follow the following links for file updates:
https://vborg.vbsupport.ru/showpost.php?p=491667
https://vborg.vbsupport.ru/showpost.php?p=491675
https://vborg.vbsupport.ru/showpost.php?p=496126
updated zip file with few fixes(4/14/04)

[???`S?LV?R???`]

Interesting hack... not sure if ill use it yet though since theres still a few bugs.

[JonnyQuest]

I was looking at the edits to functions_online.php and they appeared to only be for making it so that people show up in the Who's Online list. Is this correct? What happens if I don't edit this file? Also, you note of potential high load, can you give any more details as to how big the load increase is? What is the main cause of it? How much do you have to turn off to drop the load?

Thanks! Been following your hack closely and will likely install assuming its not going to drown my server - I run a pretty large board.

[Gio Takahashi]

Perfect solution to my problem! I'll install this!

[AN-net]

the load isnt to great like say 2.42 >> 2.36 and like that. to lessen the server load i would either turn off image button validation or one or two of modules. the server load isnt that great but i think i owe it to the users to advise them of this:)
but this isnt always necessary, cause extra server load rarely occurs

[AN-net]

I was looking at the edits to functions_online.php and they appeared to only be for making it so that people show up in the Who's Online list. Is this correct? What happens if I don't edit this file? Also, you note of potential high load, can you give any more details as to how big the load increase is? What is the main cause of it? How much do you have to turn off to drop the load?

Thanks! Been following your hack closely and will likely install assuming its not going to drown my server - I run a pretty large board.
the server load question was answered above

editing functions_online.php enables you and users who are viewing the who's online list will display Viewing Affiliate List, View Affiliate Index, Applying for Affiliation etc.. if you dont edit it will place the name of the file their viewing and saying its an unknown location. i did this so it looks better for boards/communities using this addon/hack

[Pikok]

You're missing " . TABLE_PREFIX ." in all the files. You're doing a great job on this one so far.. Keep up the great work! ;)

[JonnyQuest]

the load isnt to great like say 2.42 >> 2.36 and like that. to lessen the server load i would either turn off image button validation or one or two of modules. the server load isnt that great but i think i owe it to the users to advise them of this:)
but this isnt always necessary, cause extra server load rarely occurs

2.42 seems fairly high. I usually am below that with 300 people on my board. Load really depends on server specs however. Can you tell me how many queries are called on the various functions?

[BlackxRam]

Has this Hack had the Bugs worked out of it? Has anyone installed it with NO problems?

[BarHopper]

I'm having quite a few problems with the SQL.

When i try:

ALTER TABLE affiliates_settings ADD perpage int(3) NOT NULL, ADD bbsmilies tinyint(4) NOT NULL, ADD bbimage tinyint(4) NOT NULL, ADD moment tiny(4) NOT NULL, ADD most_hitsout tinyint(4) NOT NULL, ADD most_hitsin tinyint(4) NOT NULL, ADD most_votes tinyint(4) NOT NULL, ADD imagelink varchar(250) NOT NULL, ADD senderemail varchar(255) NOT NULL, ADD module_position tinyint(4) NOT NULL, ADD cantview varchar(50) NOT NULL, ADD cantapply varchar(50) NOT NULL, ADD cantrate varchar(50) NOT NULL, ADD disclaimer tinyint(4) NOT NULL, ADD validate tinyint(4) NOT NULL, ADD reporting tinyint(4) NOT NULL, ADD reportemail varchar(255) NOT NULL, ADD cantreport varchar(50) NOT NULL, ADD delay int(3) NOT NULL;,

I get: SQL-query :

ALTER TABLE affiliates_settings ADD perpage int( 3 ) NOT NULL ,
ADD bbsmilies tinyint( 4 ) NOT NULL ,
ADD bbimage tinyint( 4 ) NOT NULL ,
ADD moment tiny( 4 ) NOT NULL ,
ADD most_hitsout tinyint( 4 ) NOT NULL ,
ADD most_hitsin tinyint( 4 ) NOT NULL ,
ADD most_votes tinyint( 4 ) NOT NULL ,
ADD imagelink varchar( 250 ) NOT NULL ,
ADD senderemail varchar( 255 ) NOT NULL ,
ADD module_position tinyint( 4 ) NOT NULL ,
ADD cantview varchar( 50 ) NOT NULL ,
ADD cantapply varchar( 50 ) NOT NULL ,
ADD cantrate varchar( 50 ) NOT NULL ,
ADD disclaimer tinyint( 4 ) NOT NULL ,
ADD validate tinyint( 4 ) NOT NULL ,
ADD reporting tinyint( 4 ) NOT NULL ,
ADD reportemail varchar( 255 ) NOT NULL ,
ADD cantreport varchar( 50 ) NOT NULL ,
ADD delay int( 3 ) NOT NULL

MySQL said:


You have an error in your SQL syntax near 'tiny( 4 ) NOT NULL ,
ADD most_hitsout tinyint( 4 ) NOT NULL ,
ADD most_h' at line 4


When i try:

ALTER TABLE affiliates CHANGE `clicks` `clicksout` INT( 20 ) DEFAULT '0' NOT NULL ;
ALTER TABLE affiliates2 ADD clicksin INT(20) DEFAULT '0' NOT NULL, ADD approved tinyint(4) NOT NULL;

I get:

SQL-query :

ALTER TABLE affiliates CHANGE `clicks` `clicksout` INT( 20 ) DEFAULT '0' NOT NULL

MySQL said:


Unknown column 'clicks' in 'affiliates'


And where do i edit this? ::

-----------------------------------
Find:
<table class="galcat" style="border: 1px solid;" align="center" width="100%">
-----------------------------------
Replace with:
<table class="tcat" style="border: 1px solid;" align="center" width="100%">
-----------------------------------

Also, what title can my Shedule Task be? As i tried Affiliate, and a numbe rof others, and it keep saying:
Invalid title Specified

Please help, as i really wnat this hack.

[AN-net]

try these 2 new queries:

ALTER TABLE affiliates_settings ADD perpage int(3) NOT NULL, ADD bbsmilies tinyint(4) NOT NULL, ADD bbimage tinyint(4) NOT NULL, ADD moment tinyint(4) NOT NULL, ADD most_hitsout tinyint(4) NOT NULL, ADD most_hitsin tinyint(4) NOT NULL, ADD most_votes tinyint(4) NOT NULL, ADD imagelink varchar(250) NOT NULL, ADD senderemail varchar(255) NOT NULL, ADD module_position tinyint(4) NOT NULL, ADD cantview varchar(50) NOT NULL, ADD cantapply varchar(50) NOT NULL, ADD cantrate varchar(50) NOT NULL, ADD disclaimer tinyint(4) NOT NULL, ADD validate tinyint(4) NOT NULL, ADD reporting tinyint(4) NOT NULL, ADD reportemail varchar(255) NOT NULL, ADD cantreport varchar(50) NOT NULL, ADD delay int(3) NOT NULL;

and

ALTER TABLE affiliates CHANGE clicks clicksout INT( 20 ) NOT NULL ;
ALTER TABLE affiliates2 ADD clicksin INT(20) DEFAULT '0' NOT NULL, ADD approved tinyint(4) NOT NULL;


for the template edit, those changes need to be made in the AFFILIATE template.

im not sure what your putting for your cron so can you post the title your giving the scheduled task?

Sorry for this problem and oh yes, zip has been updated:)

for those who have already downloaded, here is an updated upgrade_instruct.txt

[BarHopper]

First query worked, but the second one didnt and i got this back:

SQL-query :

ALTER TABLE affiliates CHANGE clicks clicksout INT( 20 ) NOT NULL

MySQL said:

Unknown column 'clicks' in 'affiliates'

Also, what title can i use for the scheduled task?

[AN-net]

i named my scheduled task: Empty Affiliates Records

for query there must be sumthing wrong with your table, because in the original version of this there was a clicks column in the affiliates table. i even ran that query on a test table.

[AN-net]

You're missing " . TABLE_PREFIX ." in all the files. You're doing a great job on this one so far.. Keep up the great work! ;)

well this hack doesnt require table prefixes since the queries and the creation of tables dont use any;)

[AN-net]

2.42 seems fairly high. I usually am below that with 300 people on my board. Load really depends on server specs however. Can you tell me how many queries are called on the various functions?

the minimum queries with all modules off,validation off, and bb code parse off, is 11 queries(base is usally 8). With everything on the maximum is 22. with the 4 new modules off you have about 14 queries. Validation doesnt add query just a rarely shown extra load time and server load. so basically with all the enhanced features off you cut the queries in half. this is why i made this hack so customizable so you can out fit it to your boards needs:)

each module adds about 1 query

[BarHopper]

Err, im a big novice, on hacks. So, how can i fix this?

[BarHopper]

kk, i've sorted that out.

But look: http://www.game-realms.net/vb/affiliate.php?do=listaffiliates&styleid=5 and http://www.game-realms.net/vb/affiliate.php?do=listaffiliates&styleid=6 and http://www.game-realms.net/vb/affiliate.php?do=listaffiliates&styleid=3

There very distorted, how do i fix that??

Also, whats that error at the top?

[BarHopper]

Also, im still having that problem, that i cant add any affiliates. :(.

I get this:

[AN-net]

to fix the table run this query:

ALTER TABLE affiliates ADD clicksout INT( 20 ) NOT NULL;


i dont understand wut u mean by distorted?

for the error, you must setup your settings and perpage values via admincp. you are getting that error because you dont have a perpage value set:)

[AN-net]

Also, im still having that problem, that i cant add any affiliates. :(.

I get this:
you must provide an email,name, url for the site

[BarHopper]

My admincp. Do you have Any IMs, so i can show you?

i just ran the query you said, to try and fix the erro and i got this::

Error

SQL-query :

ALTER TABLE affiliates ADD clicksout INT( 20 ) NOT NULL

MySQL said:

Duplicate column name 'clicksout'

[BarHopper]

to fix the table run this query:

for the error, you must setup your settings and perpage values via admincp. you are getting that error because you dont have a perpage value set:)

And how do i do this?

[AN-net]

My admincp. Do you have Any IMs, so i can show you?

i just ran the query you said, to try and fix the erro and i got this::

Error

SQL-query :

ALTER TABLE affiliates ADD clicksout INT( 20 ) NOT NULL

MySQL said:


Duplicate column name 'clicksout'
r u running a fresh install or an upgrade?

[AN-net]

And how do i do this?
you go to your administration control panel and click general settings, under that there is a setting that says # of affiliates per page next to it is a drop down menu of #'s you must choose one and also set up your other settings then click update for it take affect.

[AN-net]

sorry i left a template edit.

for those who have alrdy downloaded, download this new upgrade_instruct.txt

zip updated with new upgrade_instruct.txt

[AN-net]

i have updated the affiliate.php file so it works with the new approval system. sry for the inconvience.

updated file has been attached for those who have alrdy downloaded

[AN-net]

all problems/bugs so far have been solved. if anyone else has any questions,concerns, or problems please post them here or at the offical support forums. thanks and sry for any inconvience:)

[BarHopper]

Thanks its now working, You've been a great help

[BarHopper]

Erm. All is good. Except, is there a way, if a an affiliate doesnt have a button and you dont put one in, is there anyway, you can get rid of the broken image?

[AN-net]

use validation. it replaces it with another image if that field is left blank

[BarHopper]

And how do i that? lol

[AN-net]

admincp->affiliates->general settings->validate image buttons

any other questions or problems dont be afraid to ask:)

[JonnyQuest]

Just a thought -- have you thought about combining this with one of the javascript external data syndication tools (like RSS) so that afflilates would actually display the RSS instead of just a banner? This could be a great way to help encourage syndication of boards content.

[AN-net]

hmm i look into that even though i dont know much about rss syndication;)

[Majik?]

You did a very good job with this one.. I like it. I've modified some of it to suit my own needs though (i.e. you don't always get an error message for clicking out more than once in the set time, the count just doesn't increase).

Also, I've made it so that when my image is displayed on an affiliate's site, it shows up in Who's Online as a guest (or the member's name if they're registered and their cookies haven't expired). It doesn't currently show the name of the site that the image is displaying on, but when I get a chance (not sure when though), I'll be making the $userinfo['where'] variable show a link to the affiliate's site.

This is one of the best affiliate systems I've seen here and has quite a bit of potential. :up:

[AN-net]

oh yeah ive noticed that who's online problem but i wasnt sure what to do with it, especially what to name it, if you want to give me some suggestions what to name it, i can surely code it for u;)

[Majik?]

oh yeah ive noticed that who's online problem but i wasnt sure what to do with it, especially what to name it, if you want to give me some suggestions what to name it, i can surely code it for u;)
I'd orgiginally made it so that it wouldn't show up in the Who's Online, but then got to thinking. I'd like for it to show up there and display that the user's browsing an affiliates site as the $userinfo['action'] and to have the site's name, if a valid (i.e. approved and active) affiliate, display the site's name with a link to it as the $userinfo['where']. So, I changed it back to display in the Who's Online and set it to show "Browsing Affiliate Site", but still need to make the site's name and link show yet..

[AN-net]

thats a good idea, ill try to find time to code it;)

[AN-net]

i have updated the upgrade instructions again. Please download the attached the filed.

[Pitman]

I don't think mine is sending the emails for approval. Does it send the email at a certain time or something? If not mine isn't working right :(

[GamerJunk.net]

Woohoo installed! Awesome!

[Pitman]

I don't think mine is sending the emails for approval. Does it send the email at a certain time or something? If not mine isn't working right :(
I also modified it a little, and I noticed that the rating system doesn't work now... the link to the site is http://www.game-dog.com/forums/link.php?do=listlinks if anyone can help.

[AN-net]

what did you change?

[Pitman]

what did you change?
Well, mostly I added the same features and functions that are in the listlinks to the toplinks.

[Pitman]

It would also be great if you could add a search feature for it, like the member list is mostly, with A-Z and it searches for links that begin with that. Also a search feature for each catagory, maybe as another module. Along with text searches, again possibly as a module.

Edit: I forgot to mention that I converted it to be a links system instead of an affiliate hack

[Pitman]

Contents of link_listbits:
<tr>
<td class="alt1" align="$stylevar[left]"><if condition="$show[button]"><if condition="$valid"><a href="link.php?do=redirect&u=$link[siteurl]&a=$link[link_id]"><img src="$link[buttonurl]" border="0" /></a><br /><else /><a href="link.php?do=redirect&u=$link[siteurl]&a=$link[link_id]"><img src="$stylevar[imgdir_editor]/unlink.gif" alt="Button N/A" border="0" /><a/><br /></if></if>
<a href="link.php?do=redirect&u=$link[siteurl]&a=$link[link_id]"><i><b>$link[sitename]</b></i></a><if condition="$show['disclaimer']">*</if><if condition="$show[report]"><a href="link.php?do=report&a=$link[link_id]" title="Report a broken url/link." target="_self"><img src="$stylevar[imgdir_button]/report.gif" border="0" /></a></if><br />
<dfn>$link[desc]</dfn></td>
<td class="alt2" align="center">$link[name]</td>
<td class="alt1" align="center">$link[clicksin]</td>
<td class="alt2" align="center">$link[clicksout]</td>
<td class="alt1" align="center"><img src="$stylevar[imagesfolder]/rating/rating_$rating.gif" /><br /><div class="smallfont"><dfn>Total Votes: $link[totalvotes]</dfn></div></td>
<if condition="$show['rate']">
<td class="alt2" align="center"><form action="link.php?do=vote" method="post">
<input type="hidden" name="a" value="$link[link_id]"><select name="rating"><optgroup label="ratings">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</optgroup>
</select>
<input type="submit" value="Rate" class="button">
</form>
</td>
</if>
</tr>

[AN-net]

problem solved. if anyone is experiencing any kind of problems with the voting/rating feature. find this line in your affiliate.php:

if(empty($a) OR empty($rating)){


replace it with this:

if(empty($_POST['a']) OR empty($_POST['rating'])){

[Pitman]

problem solved. if anyone is experiencing any kind of problems with the voting/rating feature. find this line in your affiliate.php:

if(empty($a) OR empty($rating)){


replace it with this:

if(empty($_POST['a']) OR empty($_POST['rating'])){

Thanks man... that works perfectly :)

[Bryan Ex]

Installed without problems... thanks very much for your time and effort on this AN-net.

One suggestion and one question - I have mine set to require approval of new links and I finding I'm digging through multiple pages in admincp just to check for new pending submissions. What would be very helpful is a separate "awaiting approval" list so I know right away if there's anything new. I was also wondering about the "active status" as it seems to default to no on all new submissions. Does this change automatically the first time the link is used? If not, where can I change them to default to active: yes so I don't have to edit each one after approving them.

If I'm missing a better way of doing things please let me know.

Thanks very much.

[AN-net]

do you mean the active status or the approval status?

thank you for the suggestion, i might consider that for as an addon to this hack(since i dont plan on releasing a new version for awhile).

[Bryan Ex]

do you mean the active status or the approval status?Active status is what I want to default to YES. Right now I need to approve a new link and then go back and further edit it to "active" to appear on my list.

[Bryan Ex]

As far as the links awaiting approval go... if the query calling up the list of affiliates in the admincp (manage affiliates) was reversed so newest was shown first instead of last it would place anything needing attention on the first page instead of buried several pages back. I just haven't found the right query to make the change yet...

[Majik?]

I changed the sort order to display the sites awaiting approval first, then the sites that are approved but inactive, then the sites that are approved and active.

[Bryan Ex]

Exactly what I'm after... care to share where that query is?

[Majik?]

Exactly what I'm after... care to share where that query is?
$faffiliate= $DB_site->query("SELECT affiliate_id,sitename,siteurl,active,approved,emai l FROM " . TABLE_PREFIX . "affiliates ORDER BY approved, active, sitename LIMIT $limitvalue,$perpage");
I don't remember offhand hat the original line looked like, but just search for $faffiliate= $DB_site->query as I only found that once in the file. ;)

[Bryan Ex]

Exactly what I needed. Much appreciated Majik.

[AN-net]

$faffiliate= $DB_site->query("SELECT affiliate_id,sitename,siteurl,active,approved,emai l FROM " . TABLE_PREFIX . "affiliates ORDER BY approved, active, sitename LIMIT $limitvalue,$perpage");
I don't remember offhand hat the original line looked like, but just search for $faffiliate= $DB_site->query as I only found that once in the file. ;)

thanks:), you saved me alot of work;)

[Bryan Ex]

Last small item for me to sort out... it seems that if the site description text gets too close to the edge of a cell on the affiliate list page I lose the left side border for that cell. Cells affected will change as window size or screen resolution is changed depending on where the text wraps. Any ideas of how to address this?

[Bryan Ex]

Can anyone offer any suggestions on what else I might try because I'm baffled by this one. I've played with cell padding and font sizes to no avail and the left boders continue to disappear where ever text comes within a certain margin width. I just dunno... :disappointed:

[AN-net]

well each cell doesnt have a border, the border you see is the background of the table:) try increasing cellpadding and cellspacing:)

[Bryan Ex]

Got it. I deleted the <dfn> tags around the description text and all is well in the world. :squareeyed:

[Bryan Ex]

Anyway of resetting the stats on a weekly basis or am I looking at digging into the database for that?

[AN-net]

you mean resetting the clicks in and out?

[Bryan Ex]

Exactly. Even with a reasonable delay on clicks - people will cheat so it's nice to either give others a fair chance at being listed or keep the cheaters very busy.

[AN-net]

hmm ill see if i have time to write up a cron script

[Bryan Ex]

That would be great if you have time. Didn't mean to make work for you ... just looking for the easiest way to maintain my affiliate list now that it's installed and running well.

[djohn]

Before I install this, does this hack have a master on-off switch, that would make the affiliates section completely unavailable\available for users?

[Bryan Ex]

Yes it does and you can also grant access to only certain usergroups - like mods for example

SQL question... how can I get the following query to list ORDER BY totalratings / totalvotes ?

$mvotes= $DB_site->query_first("SELECT sitename,buttonurl,affiliate_id,siteurl,totalvotes FROM affiliates WHERE active='1' AND approved='1' ORDER BY totalvotes DESC");

I'm looking to list affiliates based on average ratings instead of totals but "calcrating" isn't entered into the db.

[AN-net]

$mvotes= $DB_site->query_first("SELECT sitename,buttonurl,affiliate_id,siteurl,totalvotes FROM affiliates WHERE active='1' AND approved='1' ORDER BY totalvotes DESC");

change that to this:


$mvotes= $DB_site->query_first("SELECT sitename,buttonurl,affiliate_id,siteurl,totalvotes FROM affiliates WHERE active='1' AND approved='1' ORDER BY totalvotes DESC,totalrating DESC");


reply back on how that works;)

[Bryan Ex]

It still orders them by totalrating which isn't necesarily correct. I have a "two star" affiliate listed before a "four star" one because of extra votes for a higher total. I think there needs to be some sort of division equasion - SORT BY (totalrating / totalvotes) DESC - for example to list by average.

[CarolinaKid]

ok just got around to upgrading install went flawless so i thought. added a affilate it shows up in admin pannel but does nto show up on site. Yes I did activate it any ideas

[AN-net]

did you approve it?

[Lurk]

I failed to install this :(
the sql queries failed..
I run:
vBulletin 3.0.1
uCash & uShop
vBadvanced

[AN-net]

can you give me the error mysql gave u?

[Lurk]

nvm, i tried the queries again in phpmyadmin and everything worked fine.. :)
thank you for this wonderful hack
* Lurk clicks install

[SM0k3]

When I run this MySQL query:

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_x_successfully', '<i>{1}\'s</i> has been updates!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_successfully', '<i>{1}</i> has been deleted!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_unsuccessfully', '<i>{1}</i> was not deleted due to your choice selection.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_successfully', '<i>{1}</i> has been successfully added to the data base.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_unsuccessfully', 'This affiliates could not be added to the database because you either did not enter an affiliate name or an affiliate url or an affiliate email.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_settings_successfully', 'Settings for Affiliates Addon Updated.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_successfully', '<i>{1}</i> was updated successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_unsuccessfully', 'The type was <u>not</u> updated because the types name was left blank.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_unsuccessfully', 'This type/category was not added to the database due to the name of this type/category not being filled in.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_successfully', '<i>{1}</i> was added to the database successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('0', 'approved_affiliate_x_successfully', '<i>{1}</i> has been approved successfully and an email has been dispatched to its admin\'s email.', '9000');


I get this:

SQL-query :

INSERT INTO phrase( languageid, varname, text, phrasetypeid )
VALUES (
'-1', 'saved_affiliate_x_successfully', '<i>{1}\'s</i> has been updates!', '9000'
)

MySQL said:

Table 'sm0k3_com.phrase' doesn't exist



in my database i see "vb3_phrase" ...do i need to change the "INSERT INTO phrase" to "INSERT INTO vb3_phrase"?

[SM0k3]

nevermind.....i went ahead and took a chance and it worked...thanks anyways :)

[Skyline_GT]

I got this erro when I am trying to add affiliate_list template


The following error occurred when attempting to evaluate this template:

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/gamerzpl/public_html/forums/includes/adminfunctions_template.php(3037) : eval()'d code on line 97

This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.

[AN-net]

could u please post the code your inserting into that template?

[Skyline_GT]

The Code that I put for that template is

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle] - vB Affilates: List</title>
$headinclude
</head>
<body>
$header
$navbar
<br />
<table width="100%" align="center">
<tr>
<if condition="$show['sides']">
<if condition="$show[leftside]">
<td valign="top" align="center" width="150">
$momentbits
$mhobits
$mhibits
$mvbits
</td>
</if>
</if>
<td>
<if condition="$setting[top]">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tbody>
<tr class="tcat">
<td colspan="4" align="center"> <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('toplist')"><img id="collapseimg_toplist" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_toplist].gif" alt="" border="0"></a><font size="3"><b>Top(<i>$setting[top_limit]</i>) Affiliates</b></font></td>
</tr>
</tbody>
<tbody id="collapseobj_toplist" style="$vbcollapse[collapsetobj_toplist]">
<tr>
<td class="thead" align="center">#</td>
<td class="thead" width="100%" align="$stylevar[left]">Name</td>
<td class="thead" align="center">Hits Out</td>
<td class="thead" align="center">Hits In</td>
</tr>
$topbits
</tbody>
</table>
<br />
</if>
<form action="affiliate.php?do=listaffiliates" method="post">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tbody>
<tr>
<td colspan="2" class="thead" align="center"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('displayopt')"><img id="collapseimg_displayopt" src="$stylevar[imgdir_button]/collapse_alt$vbcollapse[collapseimg_displayopt].gif" alt="" border="0"></a>Display Options</td>
</tr>
</tbody>
<tbody id="collapseobj_displayopt" style="$vbcollapse[collapsetobj_displayopt]">
<tr>
<td class="alt1">Order By:<select name="by">
<optgroup label="Order By:">
<option value="sitename">Name</option>
<option value="name">Category/Type</option>
<option value="clicksout">Hits Out</option>
<option value="clicksin">Hits In</option>
<option value="totalvotes">Total Votes</option>
</optgroup>
</select>
</td>
<td class="alt2">Sort Order:
<select name="in">
<optgroup label="Sort Order:">
<option value="DESC">Descending</option>
<option value="ASC">Ascending</option>
</optgroup>
</select>
</td>
</tr>
<tr>
<td colspan="2" class="tcat" align="center"><input type="submit" value="Show Affiliates" class="button" /></td>
</tr>
</tbody>
</table>
</form>
<br />
<if condition="$show[pagination]">
<table align="center" width="100%" class="tborder"><tr><td class="tcat"><if condition="$show[prevactive]"><a href="affiliate.php?do=listaffiliates&page=$pageprev">促rev</a><else />促rev</if></td><td class="tcat" align="right"><if condition="$show[nextactive]"><a href="affiliate.php?do=listaffiliates&page=$pagenext">Next?/a><else />Next?/if></td>
</tr>
</table>
<br />
</if>
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tbody>
<tr class="tcat">
<td colspan="6" align="center"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('afflist')"><img id="collapseimg_afflist" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_afflist].gif" alt="" border="0"></a><b><font size="5">$vboptions[bbtitle]'s Affiliates</font></b></td>
</tr>
</tbody>
<tbody id="collapseobj_afflist" style="$vbcollapse[collapsetobj_afflist]">
<tr>
<td class="thead" align="$stylevar[left]">Name/Description</td>
<td class="thead" align="center">Type/Category</td>
<td class="thead" align="center">Hits In</td>
<td class="thead" align="center">Hits Out</td>
<td class="thead" align="center">Rating</td>
<if condition="$show['rate']">
<td class="thead" align="center">Rate</td>
</if>
</tr>
$affiliatebits
</tbody>
<tr class="tcat">
<td align="center" colspan="6"><b>:<a href="affiliate.php">Index</a>:<if condition="$show['apply']">-:<a href="affiliate.php?do=apply">Apply for Affiliation</a>:</if></b></td>
</tr>
</table>
<br />
<if condition="$show['disclaimer']">
<div class="smallfont">*$vboptions[bbtitle]'s affiliates do not represent or express $vboptions[bbtitle]'s opinions,views, or ideals.</div></if>
</td>
<if condition="$show['sides']">
<if condition="$show[rightside]">
<td valign="top" align="center" width="150">
$momentbits
$mhobits
$mhibits
$mvbits
</td>
</if>
</if>
</tr>
</table>
<br />
$crn
<br />
$footer
</body>
</html>

and for line 3037 on adminfunctions_template.php


eval('$devnull = "' . $template . '";');

[AN-net]

replace

<if condition="$show['rate']">
<td class="thead" align="center">Rate</td>
</if>


with

<if condition="$show[rate]">
<td class="thead" align="center">Rate</td>
</if>

[Skyline_GT]

not working..
http://www.gamerzplanet.net/forums/affiliate.php?do=listaffiliates

[Skyline_GT]

I got this when I am trying to edit taht template..


The following error occurred when attempting to evaluate this template:

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/gamerzpl/public_html/forums/includes/adminfunctions_template.php(3037) : eval()'d code on line 104

This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.

[Skyline_GT]

hm.. it works now..
Somehow I need to rmeove the " ' " in the if condition..
thanks.

[Holidazed]

An-net, I installed this and it works fine. However, if either myself or a user adds an affilliate and somewhere in the decription, title or whereever there is a ' it gives a database error. I know that the ' character has caused problems in other hacks, is there some modification I cqn add to your hack to make this not an issue.

I can explain to my users not to use the ' key, but I find that most ppl are just plain stupid.

Also, is there a way to make it open a new browser window when a link from the affiliate is clicked?

[SnowBot]

got it installed but whenever i try to activate it it does not save the settings in admincp :( Any ideas ?

[SnowBot]

nevermind :) i missed a query out, stupid me.

[Holidazed]

An-net, I installed this and it works fine. However, if either myself or a user adds an affilliate and somewhere in the decription, title or whereever there is a ' it gives a database error. I know that the ' character has caused problems in other hacks, is there some modification I cqn add to your hack to make this not an issue.

I can explain to my users not to use the ' key, but I find that most ppl are just plain stupid.

Also, is there a way to make it open a new browser window when a link from the affiliate is clicked?
Any ideas?

[Vman]

Two Things!

#1, when trying to register to your site for support, the "Reigister" link is not working so Im not able to register and get the support needed for the script...

#2. It seems since I have installed your program Im getting the following type errors. When A person fills in the "Add to Affiliate" and it goes to the re-direct. the re-direct stays in a loop! If a person uses the by pass link, then it stated you do not have all the fields filled out correctly and still stays in a re-direct loop.
Then if I have processed the site for approval and if a person (Including myslef) tries to click the link to THAT site in the affiliate program, It Stays in a loop and if you press the link to bypass that it sends you back the main forum with the their site address attached in the string, which then make the re-direct not work...

Hope I have explained this in detial for you to understand. Please help in anyway you can.

Don :disappointed:

[AN-net]

in response to bitg:

find in affiliate.php:

$DB_site->query("INSERT INTO affiliates (siteurl,sitename,sitedesc,type,email,buttonurl) VALUES('$siteurl','$sitename','$desc','$type','$em ail','$button')");


change to:

$DB_site->query("INSERT INTO affiliates (siteurl,sitename,sitedesc,type,email,buttonurl) VALUES('$siteurl','".addslashes($sitename)."','".addslashes($desc)."','$type','$email','$button')");

[Vman]

????????????????????Help!

[Holidazed]

AN-net, thank you. Works like a charm

[monstergamer]

is there any way of show the affiliates list with out having to go through this page http://www.monstergamer.net/vb/affiliate.php

i much rather have the affiliates show first with the affiliate.php address (not the affiliate.php?do=listaffiliates)

[AN-net]

find

//---------------------End Who Can Not View Permissions-----------------//
else{

underneath add:


if(empty($_REQUEST['do']))
{
$_REQUEST['do']="listaffiliates";
}

[monstergamer]

find

//---------------------End Who Can Not View Permissions-----------------//
else{

underneath add:


if(empty($_REQUEST['do']))
{
$_REQUEST['do']="listaffiliates";
}
thanx, worked great :D

[Rick Sample]

Is this hack, the same used on this site: http://forum.rscnet.org/affiliate.php?do=listaffiliates

I mean, I don't want those hacks of the moth or stuff on the right like in the demo or anything.

Also, how do you get hits in? is their a code provided with this hack to allow the users to put a link in their site to ours?

One last question--Do we, the admin, get to add the link, or do the users get to? I hope we do, I don't want the users to simply because I know a number of sites will not put our link up, they will just add their site and thats it. I wan't to be able to visit their site to make sure they have our link up before we add theirs.

Thanks,

[gmarik]

AN-net http://www.animationation.net/community/index.php?
How did you integrated the shoutbox in this page, can you share the little code to save our time?

[AN-net]

Is this hack, the same used on this site: http://forum.rscnet.org/affiliate.php?do=listaffiliates

I mean, I don't want those hacks of the moth or stuff on the right like in the demo or anything.

Also, how do you get hits in? is their a code provided with this hack to allow the users to put a link in their site to ours?

One last question--Do we, the admin, get to add the link, or do the users get to? I hope we do, I don't want the users to simply because I know a number of sites will not put our link up, they will just add their site and thats it. I wan't to be able to visit their site to make sure they have our link up before we add theirs.

Thanks,
that site uses version version one of this hack.
Code is provided in this to get hits in. upon approval of an affiliate an email is sent the email that was provided for the site.

admins can add their own links as they want and also categories. you can also define what usergroups can and can not add links to your site;)

also you do have an active system meaning before they showup on the affiliates page you must approve and activate them;)

[AN-net]

AN-net http://www.animationation.net/community/index.php?
How did you integrated the shoutbox in this page, can you share the little code to save our time?

um you know it requires that you have vbindex's shoutbox?

if there is enough people who want it i could release it;)

[Rick Sample]

that site uses version version one of this hack.
Code is provided in this to get hits in. upon approval of an affiliate an email is sent the email that was provided for the site.

admins can add their own links as they want and also categories. you can also define what usergroups can and can not add links to your site;)

also you do have an active system meaning before they showup on the affiliates page you must approve and activate them;)


COOL! I'll try to intall this later tonight! thanks!

[Vman]

Thanks for the support! I see that my ??? were not answered and for what reasone I don't know why! Like I said before. The program is stuck in a re-direct loop and If I tried to register to your site I get a 404 Error!

Im sorry for being upset about this, but if you looked at my post date you would hve seen that I have asked for help some time ago and yet other who post after me get answers!!!!

Im almost at a point to just stick with wht vB3 offers as a affiliate program and point counts system...It would make things easier, but I have used your system before and like it very much.

Again thanks for any info you will provide to help.

[AN-net]

Thanks for the support! I see that my ??? were not answered and for what reasone I don't know why! Like I said before. The program is stuck in a re-direct loop and If I tried to register to your site I get a 404 Error!

Im sorry for being upset about this, but if you looked at my post date you would hve seen that I have asked for help some time ago and yet other who post after me get answers!!!!

Im almost at a point to just stick with wht vB3 offers as a affiliate program and point counts system...It would make things easier, but I have used your system before and like it very much.

Again thanks for any info you will provide to help.
i am sorry i dont not respond cause i was still wondering exactly why that was happening.

could it be your browser?

[Vman]

I have tried 3 different browsers and 2 different computer, one being a MAC...
What I will do is remove the files and reinstall it again and see what happens...
Also, if I get this to work, is there a way to have "The Site Of The Moment" show up on vbPortal's page?

Thanks for the quick responce. I look forward to using this program and am very excited!!!!!

[Vman]

OK, I have reinstalled the whole program. Now if you go and check it out, click on the link or banner that i have added to the affiliate program. its now not redirecting anywhere!
THis is what its doing:
http://www.bodybuildingcentral.net/forums/www.bodybuildingcentral.net <-- as you can see its adding my site url again at the end! Then it goes to a 404 error page.

Here is the site and its set so guests can enter
www.bodybuildingcentral.net

thanks for any help on this, Im trying to get things rollin as fast as I can....

[AN-net]

the url must be in full format meaning http:// must be included or it will be considered a file or folder;)

[SnowBot]

When adding a new affil how can i auto add the

http://

In the box so that people dont have to add it?

Thanks for any help on this.

[Vman]

the url must be in full format meaning http:// must be included or it will be considered a file or folder;)


OK!, Ill give that a try...thanks... :nervous:

[Vman]

IT WORKED!!!! Thanks!

[Vman]

Two Questions now...

#1 is there a way to make it so when people add banners, no matter what size they are, they are automaticly changed to a size you set like 88x31

#2 is there a way to show the "Site Of The Moment" on vBPortal page and how?!?

THanks

[AN-net]

Two Questions now...

#1 is there a way to make it so when people add banners, no matter what size they are, they are automaticly changed to a size you set like 88x31

#2 is there a way to show the "Site Of The Moment" on vBPortal page and how?!?

THanks

#1 one would require some type of GD imaging

#2 it seems your using the new vbportal version so im not exactly sure how it works>_<

[Vman]

Ok, thanks!...Ill see what I can do....

[monstergamer]

When adding a new affil how can i auto add the

http://

In the box so that people dont have to add it?

Thanks for any help on this.
your talking about some thing like this > http://www.monstergamer.net/vb/affiliate.php?do=apply

when they go to apply for affiliation, it show the HTTP:// for them

[SnowBot]

YES :) that is exactly what i was after :0

[monstergamer]

YES :) that is exactly what i was after :0
since i did not like how the apply page looked i changed it, your welcome to use it



in the affiliate_apply, REPLACE ALL WITH
$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle] - vB Affilates: Apply</title>
$headinclude
</head>
<body>
$header
$navbar
<form action="affiliate.php?do=insert" method="post">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat"><b>Application</b>:</td>
</tr>
<tr>
<td class="alt1">Site Name:<input type="text" name="sitename" value="" maxlength="50" size="30"></td>
</tr>
<tr>
<td class="alt2">Site Url:
<input type="text" name="siteurl" value="http://" maxlength="255" size="50"></td>
</tr>
<tr>
<td class="alt1">Site Description:<br />
<textarea name="desc" cols="50" rows="10"></textarea></td>
</tr>
<tr>
<td class="alt2">Button Url:<input type="text" name="button" value="http://" maxlength="150" size="50"></td>
</tr>
<tr>
<td class="alt1">Category:<select name="type"><optgroup label="Categories/Types">
$typebits
</optgroup>
</select></td>
</tr>
<tr>
<td class="alt2">Webmaster Email:<input type="text" name="email" value="" maxlength="250" size="50"></td>
</tr>
<tr>
<td class="tcat">&nbsp;<input type="submit" value="Submit"></td>
</tr>
</table>
</form>
<br />
$footer
</body>
</html>

[SnowBot]

Now that does look much better, i appreciate that.

THANKS :)

[trackpads]

I used this to organize the Affiliate templates in the template manager. It makes it look a lot better.

This is a GREAT Hack btw!!!!!


In includes/adminfunctions_template.php:

Find:

'subscription' => $vbphrase['group_paid_subscriptions'],


Add BELOW:

'affiliate' => 'VB Affiliates',

[Chris Gwynne]

Not sure if you're still providing support for the hack, lets hope you are.

When I try to run this query
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_x_successfully', '<i>{1}\'s</i> has been updates!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_successfully', '<i>{1}</i> has been deleted!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_unsuccessfully', '<i>{1}</i> was not deleted due to your choice selection.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_successfully', '<i>{1}</i> has been successfully added to the data base.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_unsuccessfully', 'This affiliates could not be added to the database because you either did not enter an affiliate name or an affiliate url or an affiliate email.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_settings_successfully', 'Settings for Affiliates Addon Updated.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_successfully', '<i>{1}</i> was updated successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_unsuccessfully', 'The type was <u>not</u> updated because the types name was left blank.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_unsuccessfully', 'This type/category was not added to the database due to the name of this type/category not being filled in.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_successfully', '<i>{1}</i> was added to the database successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('0', 'approved_affiliate_x_successfully', '<i>{1}</i> has been approved successfully and an email has been dispatched to its admin\'s email.', '9000');

I get this error

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VA

Any help with this please?

Regards,
Chris

[joeychgo]

problem I noticed.....

ANYONE can vote and vote as often as the like, so it makes the rating system ineffective

[AN-net]

chris im not sure what the problem is because i dont know which line it is. um can you run each insert one singally.

joey that means the delay feature is not working for u.

[Ronso Rage]

Installed with no probs and seems to be working fine thanks

*RR clicks install*

[joeychgo]

joey that means the delay feature is not working for u.



actually- its on one of your demo sites.........I havent installed this hack, that kept me from doing do.

[Bryan Ex]

I don't think the delay feature is set up quite right IMO. If you set a long delay it will certainly slow down the cheating but it affects all links... not just the one they just clicked on. This means that people have difficulty browsing several listings because they must wait between using each link. Click on a link that turns out to be not what you were looking for and you must wait to try the next one. Delay should only apply to visited links - not all links.

[AN-net]

actually- its on one of your demo sites.........I havent installed this hack, that kept me from doing do.
ok well then it could be that the demo site had turned off the delay feature by setting it to 0

hmm i will try look into that bryan, thanks:) but im sorta busy right now

[Pseudomizer]

Hi,

i have a weird problem. My performance hack shows me that i have 1 template uncached called "AFFILIATE" and if i list the affiliates i have 7 uncached templates. I crosschecked the affialiates.php file and all templates are listed in the $globaltemplates.

Anyone knows why they are not cached ?

Thanks in advance.

Cheers,

[Pseudomizer]

chris im not sure what the problem is because i dont know which line it is. um can you run each insert one singally.

joey that means the delay feature is not working for u.

With all respect but the delay feature is NOT the solution here. As soon as someone changes his IP adress or the delay has passed he will be able to vote again.

I changed this on my site. Because only members can see the affiliate site, i implemented a voting mechanism for members. It will be stored in the database accordingly to their userid. Some minor changes ( took me 6 hours to find the best way ) and members can only vote once per affiliate.

Hint: I would NOT recommend using this on a biiiiiiig VB site with more then 100.000 users. Otherwise your queries will destroy your performance.

But i am still waiting for an answer for my caching problem. Any ideas ?

Thanks for this hack so far. It works fine.

Cheers,

[SnowBot]

What are the queries to undo any table changes if we want to unistall ?

[AN-net]

uninstall version 2?

[JustAskJulie]

Is it possible to completely turn off the rating system? And do you have to show hits in/out?

I'm just wanting a basic links page tool, not a top sites list.

[Pseudomizer]

Is it possible to completely turn off the rating system? And do you have to show hits in/out?

I'm just wanting a basic links page tool, not a top sites list.

Hi JustAskJulie,

not via ACP. But open the affialiates_list template and remove this line:


<if condition="$show['rate']">
<td class="thead" align="center">Rate</td>
</if>


and this in affiliate_listbits:


<if condition="$show['rate']">
<td class="alt2" align="center"><form action="affiliate.php?do=vote" method="post">
<input type="hidden" name="a" value="$affiliate[affiliate_id]"><select name="rating"><optgroup label="ratings">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</optgroup>
</select>
<input type="submit" value="Rate" class="button">
</form>
</td>
</if>


Cheers,

[JustAskJulie]

Thanks :) What would you edit to remove the hits in/out?

[Pseudomizer]

Thanks :) What would you edit to remove the hits in/out?

Hi JustAskJulie,

Template affialiate_list


<td class="thead" align="center">Hits In</td>
<td class="thead" align="center">Hits Out</td>


and template affiliate_listbits


<td class="alt1" align="center">$affiliate[clicksin]</td>
<td class="alt2" align="center">$affiliate[clicksout]</td>


Cheers,

[jesslynn]

got it installed but whenever i try to activate it it does not save the settings in admincp :( Any ideas ?

This is exactly what is happening to me. I even went so far as to completely start over from scratch, and it is still happening. I also can't log out. Are those two problems related perhaps? This seems like such a silly problem so it is driving me batty! LOL

http://www.boutiquebids.com/forums

TIA for any help! :)

[Jack28]

1. the users that added thier site are not getting an email to get the link activated ALSO i as admin dont get an email either..?
2. because i dont get an email i wanna know how the sites get "in Hits"
what link do they need to use..?

i hope someone can help me @ both things...

[Pseudomizer]

1. the users that added thier site are not getting an email to get the link activated ALSO i as admin dont get an email either..?
2. because i dont get an email i wanna know how the sites get "in Hits"
what link do they need to use..?

i hope someone can help me @ both things...

1. The email part works. But you will not get an email. Only the admin of your affiliate will get an email to the email address he specified.

2. You should not ask for an interim solution because your email does not work. If you fix the email part, you second problem will be gone, because they will also get this link in the email they receive.

Cheers,

[Bro_Joey_Gowdy]

re-installs

:)

[AN-net]

This is exactly what is happening to me. I even went so far as to completely start over from scratch, and it is still happening. I also can't log out. Are those two problems related perhaps? This seems like such a silly problem so it is driving me batty! LOL

http://www.boutiquebids.com/forums

TIA for any help! :)
if you are having problems logging out it is most likely not my hack but a problem with your board or your cookies. since the only files edited were /includes/functions_online.php and /admincp/index.php which do not deal with logging in and out. I think your logging out problem may have something to do with it not updating the settings, i suggest you contact vbulletin for support to fix your logging in and out problems.

[AN-net]

With all respect but the delay feature is NOT the solution here. As soon as someone changes his IP adress or the delay has passed he will be able to vote again.

I changed this on my site. Because only members can see the affiliate site, i implemented a voting mechanism for members. It will be stored in the database accordingly to their userid. Some minor changes ( took me 6 hours to find the best way ) and members can only vote once per affiliate.

Hint: I would NOT recommend using this on a biiiiiiig VB site with more then 100.000 users. Otherwise your queries will destroy your performance.

But i am still waiting for an answer for my caching problem. Any ideas ?

Thanks for this hack so far. It works fine.

Cheers,
i will try look into the caching problem when i get free time most likely after i finish my journal hack, i am sorry for the delay but i have been very busy.

[aHMET]

redirects doesnt work with mozilla
to fix it

Find
$url="$u";

Add Below
$js_url=$u;

I dont know if is it fixed but just a tip

[Jag]

Wonderful hack, installed without a hitch :)

* clicks install

[rex_b]

GREAT HACK..

ADDED WITH NO PROBLEMS

*Clicks install

[kall]

redirects doesnt work with mozilla
to fix it

Find
$url="$u";

Add Below
$js_url=$u;

I dont know if is it fixed but just a tip
Yeah, redirects are totally bung under firefox.

*tries various methods of fixing it*

*edit* Hmm, no...only when I vote. It seems to think there was nothing specifed, and I get sent into a loop. But only on Firefox.

[venomx]

Have all bugs been fixed with this yet? I want to install it.. :P

[venomx]

Anyone?

[flstreetscene]

How come sometimes it works sometimes it's an SQL error;

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO affiliates (siteurl,sitename,sitedesc,type,email,buttonurl) VALUES('www.floridastreetscene.com','FSS','Connect ing Florida's Automotive blah blah blah...','1','soflaimprot@bellsouth.net','http://www.floridastreetscene.com/button.gif')
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's Automotive blah blah blah...','1','soflaimprot@bellsouth.net'

mysql error number: 1064

Date: Thursday 09th of September 2004 06:10:01 PM
Script: http://www.floridastreetscene.com/forums/affiliate.php?do=insert
Referer: http://www.floridastreetscene.com/forums/affiliate.php?do=apply

[Lacrosse Boy]

I'm going to feel dumb about this, but what exactly does the cron setup do?

[P.Jackson]

i setups a script to run ever hour or however you choose it i.e every 10 mins every hoyr etc etc

[Blam Forumz]

Database error in vBulletin 3.0.2:

Invalid SQL: SELECT * FROM affiliates_types ORDER BY name ASC
mysql error: Table 'blamina_forum.affiliates_types' doesn't exist

mysql error number: 1146

Date: Sunday 12th of September 2004 03:06:26 AM
Script: http://www.blaminator.co.uk/forum/admincp/affiliateadmin.php?do=add
Referer: http://www.blaminator.co.uk/forum/admincp/index.php?do=nav
Username: Blaminator
IP Address: xx.xxx.xxx.xx



Theres my problem

[poolking]

Brilliant hack, installed no probs. :bandit: :up:

[poolking]

Database error in vBulletin 3.0.2:

Invalid SQL: SELECT * FROM affiliates_types ORDER BY name ASC
mysql error: Table 'blamina_forum.affiliates_types' doesn't exist

mysql error number: 1146

Date: Sunday 12th of September 2004 03:06:26 AM
Script: http://www.blaminator.co.uk/forum/admincp/affiliateadmin.php?do=add
Referer: http://www.blaminator.co.uk/forum/admincp/index.php?do=nav
Username: Blaminator
IP Address: xx.xxx.xxx.xx



Theres my problem
Did you run the queries to create the affiliate_types table?

[Blam Forumz]

I ran all the querys

[Blam Forumz]

problem :


http://www.blaminator.co.uk/forum/affiliate.php?do=listaffiliates

[venomx]

Is there a way to add the refuserid= if the person getting the code is a member?
This way if members join the afiliate thing they get credit for any signups...

[Blam Forumz]

bump

[Blam Forumz]

#bump#bump#bump#bump#bump#bump#bump#bump#bump#bump #bump#bump#bump#bump#bump#bump #bump#bump#bump#bump#bump#bump#bump#bump#bump#bump #bump#bump#bump#bump#bump#bump #bump#bump#bump#bump#bump#bump#bump#bump#bump#bump #bump

[AN-net]

problem :


http://www.blaminator.co.uk/forum/affiliate.php?do=listaffiliates
it seems to be having a problem connecting to one of your affiliating sites:) or maybe that specific php function is blocked by your host...

[Blam Forumz]

Bah, may I ask, is there any difference between this version and the other affiliate hack?

[AN-net]

well there are more features on this one but besides that not really.....

[Quelyn]

Thanks this is awesome, a great way to manage links, I like it :D

Is there a way I can get that first page not to show up, and instead just have it go right to the affiliates listing?

[venomx]

Yes just link to
http://www.domain.com/forums/affiliate.php?do=listaffiliates instead

[Quelyn]

Yes just link to
http://www.domain.com/forums/affiliate.php?do=listaffiliates instead

I should have thought of that, I'm a noob, thanks :D

[School-Help]

hello , i have installed this hack and it works wonderfully , the only problem is that when i go to the affiliate page and click on the button to make each section hide under its title the image is broken. www.school-help.co.uk/affiliate.php? check out the problem . it looks fine on the first look but after you click on the image it breaks? Is there anyway to either remove these images or fix them?


:ermm: Please help anyone...

[AN-net]

hello , i have installed this hack and it works wonderfully , the only problem is that when i go to the affiliate page and click on the button to make each section hide under its title the image is broken. www.school-help.co.uk/affiliate.php? check out the problem . it looks fine on the first look but after you click on the image it breaks? Is there anyway to either remove these images or fix them?


:ermm: Please help anyone...
this doesn't happen to me

[School-Help]

what could i do to fix it then?

[dieselpowered]

So then do we know if this will work fine with 3.0.3?? :)

[AN-net]

im using it with vb 3.0.3 it works fine for me:)

[dieselpowered]

im using it with vb 3.0.3 it works fine for me:)

LOL ya but you are a lot smarter than me when it comes to this stuff :squareeyed:

Ok so it should install alright...I will give it a whirl, wish me luck ;)

[businessjunkies]

The emails aren't sending out to affiliates.. and it keeps saying, after they complete the form, that they are missing information..

And yes, it is installed correctly.

[HiDeo]

Thanks for the nice job, I'll use on my forum !

[Spyke]

Thanks for the nice job, I'll use on my forum !
hey nice mod.

It was working fine until recently and when someone signs up at the affiliate form none of the "types" are showing in the dropdown menu (community, other, etc). I checked them in the AdminCP and they are showing there, i have deleted and re-added them but still nothing?

[bondjetta]

I'm having a little issue w/ this. The Install went well, thanks to some links on MySQL queries :D, but my affiliates.php file is just coming up blank :(

http://www.emptythecup.com/forums/affiliate.php

Any ideas? was I supposed to save those queries or just run them? I'll admit i'm pretty MySQL/PHPMyAdmin retarded :(

[AN-net]

I'm having a little issue w/ this. The Install went well, thanks to some links on MySQL queries :D, but my affiliates.php file is just coming up blank :(

http://www.emptythecup.com/forums/affiliate.php

Any ideas? was I supposed to save those queries or just run them? I'll admit i'm pretty MySQL/PHPMyAdmin retarded :(
did you install the templates?

[bondjetta]

did you install the templates?
sure did. i followed the instructions to a T (i do believe), at least I did everything it asked piece by piece....

I'm at work right now, but i'll try to open the instructions here and make sure i didn't miss anything. but i have 10 Affiliate templates right now, i even directly copied their names from the .txt file to keep from making typos :)

[bondjetta]

sure did. i followed the instructions to a T (i do believe), at least I did everything it asked piece by piece....

I'm at work right now, but i'll try to open the instructions here and make sure i didn't miss anything. but i have 10 Affiliate templates right now, i even directly copied their names from the .txt file to keep from making typos :)
and I lied, the first template was lowercase instead of caps :(


ok, i'm gonna go play around again, if i can't figure it out i'll be back :) Thanks


EDIT: I'm back: and not w/ positive results. For one, the index is working now, that's good news, however the bad news is none of the links are working. :( When I vote/rate one of the affiliates the redirect page goes into an infinite loop (links such as: http://www.emptythecup.com/forums/affiliate.php?do=vote ) or when I click on the name of the Affiliate, which should send me to their Domain, i'm getting an infinite loop.

Ideas? :)

[AN-net]

and I lied, the first template was lowercase instead of caps :(


ok, i'm gonna go play around again, if i can't figure it out i'll be back :) Thanks


EDIT: I'm back: and not w/ positive results. For one, the index is working now, that's good news, however the bad news is none of the links are working. :( When I vote/rate one of the affiliates the redirect page goes into an infinite loop (links such as: http://www.emptythecup.com/forums/affiliate.php?do=vote ) or when I click on the name of the Affiliate, which should send me to their Domain, i'm getting an infinite loop.

Ideas? :)
this may be due to your browser

[bondjetta]

this may be due to your browser
Firefox 1.0 PR??


EDIT: sure as heck, it worked in IE.

Any ideas how i can cleanup that link to work in FF/Opera? :)

[Spyke]

hey nice mod.

It was working fine until recently and when someone signs up at the affiliate form none of the "types" are showing in the dropdown menu (community, other, etc). I checked them in the AdminCP and they are showing there, i have deleted and re-added them but still nothing?

Any idea's on my problem?

Thanks.

[99SIVTEC]

Yep, I can verify the firefox problems. Any idea's on that? A large number of my users are using FF, and i'm pushing that browser hard since IE sucks so badly.

[bondjetta]

Yep, I can verify the firefox problems. Any idea's on that? A large number of my users are using FF, and i'm pushing that browser hard since IE sucks so badly.
i'm the same way ;)

i'm investigating the "redirect" function inside of affiliate.php for anything i might be able to change to hopefully create a more firefox-friendly page :) as of right now the whole module isn't worth much to me since i (and at least half my users) are dedicated FF users :(

[Spyke]

Any idea's on my problem?

Thanks.

Never mind, stupid me forgot to add a template :ermm:

[bondjetta]

Yep, I can verify the firefox problems. Any idea's on that? A large number of my users are using FF, and i'm pushing that browser hard since IE sucks so badly.
After speaking with Ianomed about this he pointed out some problems with the template STANDARD_REDIRECT and Firefox...as a result I've found (at least a temporary fix) a fix for this...go to your STANDARD_REDIRECT template and change:

else
{
clearTimeout(timerID);
window.status = "";
window.location = "$js_url";
}

to:
else
{
clearTimeout(timerID);
window.status = "";
window.location = "$url";
}

I'm testing it across a few different browsers right now, i'll post if i find any irregularities, but at least the URL's are forwarding now (making this module useful again ;))

[AN-net]

After speaking with Ianomed about this he pointed out some problems with the template STANDARD_REDIRECT and Firefox...as a result I've found (at least a temporary fix) a fix for this...go to your STANDARD_REDIRECT template and change:

else
{
clearTimeout(timerID);
window.status = "";
window.location = "$js_url";
}

to:
else
{
clearTimeout(timerID);
window.status = "";
window.location = "$url";
}

I'm testing it across a few different browsers right now, i'll post if i find any irregularities, but at least the URL's are forwarding now (making this module useful again ;))
interesting.....

[dieselpowered]

This is a great hack, one question though...

When a user applies to have their link listed, shouldn't there be some sort of indication of what size their image should be? Or better yet, some way of having it autosize if it is too large :rolleyes: :squareeyed:

Also, not sure if this is an ongoing issue with anyone else, however, no e mails are being sent to those who apply to have their site listed. I know I applied on your site and received nothing?

[AN-net]

This is a great hack, one question though...

When a user applies to have their link listed, shouldn't there be some sort of indication of what size their image should be? Or better yet, some way of having it autosize if it is too large :rolleyes: :squareeyed:

Also, not sure if this is an ongoing issue with anyone else, however, no e mails are being sent to those who apply to have their site listed. I know I applied on your site and received nothing?
most likely either spam blocked or the mail function did not work....

[dieselpowered]

Hmmm I am not sure....

What about the button sizes? Is there a way to indicate somewhere what size should be included for the button so that the person applying knows?

[bendigo-tech]

Hmmm I am not sure....

What about the button sizes? Is there a way to indicate somewhere what size should be included for the button so that the person applying knows?
Change the template and put next to the button url box (88x31 MAX) or something. :)

[bendigo-tech]

I have this installed and working with with VB 3.0.3. Very nice!

That said, how can I change the email message that is sent upon approval?? I have looked every for it and can't seem to find it. :(

[AN-net]

I have this installed and working with with VB 3.0.3. Very nice!

That said, how can I change the email message that is sent upon approval?? I have looked every for it and can't seem to find it. :(
i think it was a phrase last time i remember(its early right now so im not sure....)

[bendigo-tech]

i think it was a phrase last time i remember(its early right now so im not sure....)
I have just searched the phrases again and I can't find it anywhere. :(

EDIT: It isn't a phrase. It is in the affiliateadmin.php file in the admincp directory. No wonder I couldn't find it. :ninja:

[AN-net]

I have just searched the phrases again and I can't find it anywhere. :(

EDIT: It isn't a phrase. It is in the affiliateadmin.php file in the admincp directory. No wonder I couldn't find it. :ninja:
hehe i was such a script kiddie when i made this hack... i shouldn't have hardcoded that>_<

[trackpads]

Dude, this script still rocks. Are you planning an update to it?

[AN-net]

Dude, this script still rocks. Are you planning an update to it?
maybe eventually, i guess if time allows it...

[trackpads]

maybe eventually, i guess if time allows it...
I will not beg..... yet.... ok.... no not yet..... maybe.... grrrrr.... ;-)

[Quelyn]

Sorry if this is already in the thread, I don't have much time to go through and read it. But when I rate an affiliate, I get this:

There was no affiliate or rating identified.If you followed a bad link please report it to a board administrator. Your are now being redirected back to the affiliate list.

Click here if your browser does not automatically redirect you.

Any reason?

[Pseudomizer]

Sorry if this is already in the thread, I don't have much time to go through and read it. But when I rate an affiliate, I get this:

There was no affiliate or rating identified.If you followed a bad link please report it to a board administrator. Your are now being redirected back to the affiliate list.

Click here if your browser does not automatically redirect you.

Any reason?

Your PHP Version is the problem. Go into the script and replace the variables with either $_POST[variablename] or $_SERVER[variablename]. Then it will work.

Cheers,

[Quelyn]

Your PHP Version is the problem. Go into the script and replace the variables with either $_POST[variablename] or $_SERVER[variablename]. Then it will work.

Cheers,

Sorry I'm not sure exactly what you mean to change .. and I don't want to break anything, think you could specify, or point me to where it might say that. Thanks much.

[alzibub]

Great hack, installed in 5 mins and working fine!
Thanks very much :)

[Gaffer]

i just installed this... it looks like it's working Great. but has anyone made an addon which will desplay some of the affiliates on the main forum index...

this is not the affiliates hack (it's installed on my other forums) but something like what is down the bottom of this page

www.midasaray.com/vb/

[venomx]

Yeah would be a nice addition to have it on the forums or even on vBadvanced CMPS.

[Gaffer]

Yeah would be a nice addition to have it on the forums or even on vBadvanced CMPS.
there is an addon for the CMPS... but it's not what i need...

[yuvalo]

I installed this on my site and found a security issue.

When i tried to add a site, and in its description used the character ' (the single quote), the query failed. The error itself indicated that this feature is vulnerable to SQL injection attacks.

could some of you try and verify this?

Yuval

[venomx]

Where can I find it?

[mholtum]

The install went easy but when running the sql querry I get error 1064 ARGH!

[Scerina]

Oh, what an awesome hack! Could someone please install this for me please????? If you can help me, please email me at: Pandora@Sweet-November.Net

Thanx in advance

[mholtum]

Ok, I was ablew to get all of the queries to work except the first one. When I run it I get this error:

SQL-query:

CREATE TABLE affiliatesaffiliate_id int( 10 ) NOT NULL AUTO_INCREMENT ,
sitename varchar( 50 ) NOT NULL ,
siteurl varchar( 250 ) NOT NULL ,
sitedesc mediumtext NOT NULL ,
buttonurl varchar( 150 ) NOT NULL ,
TYPE tinyint( 4 ) NOT NULL ,
email varchar( 250 ) NOT NULL ,
clicksout int( 20 ) NOT NULL ,
clicksin int( 20 ) NOT NULL ,
active tinyint( 4 ) NOT NULL ,
totalrating bigint( 20 ) NOT NULL ,
totalvotes bigint( 20 ) NOT NULL ,
approved tinyint( 4 ) NOT NULL ,
PRIMARY KEY ( affiliate_id ) ,
KEY sitename( sitename ) ,
KEY siteurl( siteurl ) ,
KEY email( email )



MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'affiliate_id int(10) NOT NULL auto_increment,
sitename varch

[mholtum]

Ok, I got it working! http://www.ravensrealm.net/forum/affiliates.php

[Scerina]

Is anyone else havin problem with this mySQL Query:

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_x_successfully', '<i>{1}\'s</i> has been updates!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_successfully', '<i>{1}</i> has been deleted!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_unsuccessfully', '<i>{1}</i> was not deleted due to your choice selection.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_successfully', '<i>{1}</i> has been successfully added to the data base.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_unsuccessfully', 'This affiliates could not be added to the database because you either did not enter an affiliate name or an affiliate url or an affiliate email.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_settings_successfully', 'Settings for Affiliates Addon Updated.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_successfully', '<i>{1}</i> was updated successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_unsuccessfully', 'The type was <u>not</u> updated because the types name was left blank.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_unsuccessfully', 'This type/category was not added to the database due to the name of this type/category not being filled in.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_successfully', '<i>{1}</i> was added to the database successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('0', 'approved_affiliate_x_successfully', '<i>{1}</i> has been approved successfully and an email has been dispatched to its admin\'s email.', '9000');

For some odd reason, it won't let me run this query...can someone help me???

[NightWalk8r]

i cant get this to work right. Please help me out.
I have it in a module for CMPS too.

here's the link to the module. http://www.anim3.com
here's the link to the main affiliate page http://www.anim3.com/forums/affiliate.php?do=listaffiliates

If you click on the link, it wouldnt work for some reason.

[bandare]

I'd like to get that vbadvanced mod if you can make it accessible pls.....

----------------------------------------------------

I have a problem. If I try to click on any of the affiliates links in that section, it just hangs rather than going to the webpage of the affilliate.... what is going wrong?

It keeps adding lots of hits to the affilliate link but doesnt actually go there until I hit the proceed button manually....

pls help!

[bandare]

After speaking with Ianomed about this he pointed out some problems with the template STANDARD_REDIRECT and Firefox...as a result I've found (at least a temporary fix) a fix for this...go to your STANDARD_REDIRECT template and change:

else
{
clearTimeout(timerID);
window.status = "";
window.location = "$js_url";
}

to:
else
{
clearTimeout(timerID);
window.status = "";
window.location = "$url";
}

I'm testing it across a few different browsers right now, i'll post if i find any irregularities, but at least the URL's are forwarding now (making this module useful again ;))


I am still trying to fix this problem for my affiliates section and firefox/mozilla users.... I cant find the template STANDARD REDIRECT......... pls help.......

is this the only fix for the redirection fault for affiliates V2?

[Deviant++]

What exactly is the difference between this and vb3 affiliates hack ..


this is the second version cause it's vb affliates v.2 ?


also, I can't run a single query this is what all it's saying

vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL a



An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates_records (
record_id int(10) NOT N

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates_records (
record_id int(10) NOT N

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates_settings (
active tinyint(4) NOT

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates_types (
id int(10) NOT NULL auto_

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VA



NOTE : I am on windows 2003 server on plesk 6.5

[AN-net]

What exactly is the difference between this and vb3 affiliates hack ..


this is the second version cause it's vb affliates v.2 ?


also, I can't run a single query this is what all it's saying

vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL a



An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates_records (
record_id int(10) NOT N

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates_records (
record_id int(10) NOT N

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates_settings (
active tinyint(4) NOT

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates_types (
id int(10) NOT NULL auto_

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VA



NOTE : I am on windows 2003 server on plesk 6.5

try running it one query at a time;)

[Deviant++]

okay I got queries done..

[Deviant++]

Invalid SQL: SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,tota lrating,totalvotes FROM vb3_affiliates LEFT JOIN affiliates_types ON affiliates.type = affiliates_types.id WHERE active='1' AND approved='1' ORDER BY sitename DESC LIMIT 0,5
mysql error: Table 'dvdb.affiliates_types' doesn't exist

the tables threre..

I tried putting vb3_ ( which is my prefix ) on all of them or alterntively one by one, not making any difference..

[Deviant++]

Bah, had to hardcode it to get it working..

:disappointed: wouldn't take prefix's otherwise..

[Soto]

OK, I have reinstalled the whole program. Now if you go and check it out, click on the link or banner that i have added to the affiliate program. its now not redirecting anywhere!
THis is what its doing:
http://www.bodybuildingcentral.net/forums/www.bodybuildingcentral.net <-- as you can see its adding my site url again at the end! Then it goes to a 404 error page.

Here is the site and its set so guests can enter
www.bodybuildingcentral.net

thanks for any help on this, Im trying to get things rollin as fast as I can....

I'm having the same problem. When an affiliate is clicked it adds the affiliate url to my forum url so gives a 404.

Any ideas what's causing this, and how do I correct it. This is a great mod and I really want to work with it.

[Soto]

Ahhhh my fault, what an idiot I am! I checked the affiliate details in the the admincp and it was because I'd preapproved an affilitate without http:// at the beginning of the url. Changed that and now it works like a dream.

I made the board redirect template change mentioned earlier for better compatibility with Firefox - it works well, although in some cases you have to manually click "proceed" but it's a small price to pay.

Thanks so much for this.

Also, some people were asking how to make affiliates open in a new window. I made the following edits to allow that:

Basically in each case it's a case of adding target="blank" where ever needed - to save people the time of wading through the template files I've added a text file for the edits.

Can we get an affiliate thread going? We can really use this hack to its full potential then :D

[Soto]

Is anyone else having a problem where "hits in" doesn't seem to be working?

Everything else works, except for hits in.

Any ideas?

[Royalridge]

Out of the zip there is a serious functionality problem, links to sites in the "Top (X) Affiliates" section link directly to the site and bypass the "Links Out" counting. There is a fix that requires one query modification to affilate.php and a change to affiliate_topbits template.

[Royalridge]

Niggles:

Administrator should be able to specify what page incoming hits are directed to rather than a force into the affiliate list. (I know this can be done through editing the affiliatein.php but ideally should be through control panel)
Use of the re-direction template on hits in and out looks messy and should have a control panel option to disable.

[venomx]

Out of the zip there is a serious functionality problem, links to sites in the "Top (X) Affiliates" section link directly to the site and bypass the "Links Out" counting. There is a fix that requires one query modification to affilate.php and a change to affiliate_topbits template.

And the fix is?

[agiacosa]

I installed this hack on a 3.0.6 site. Everything installed fine. The problem is that when I add an affiliate, it doesn't show up in the affiliate index page. Everything else seems to happen. Email is sent to affiliate, it shows approved in AdminCP, etc.

What could it be?

[AN-net]

the affiliatemust be approved and active;)

[agiacosa]

It is.

[AN-net]

are sure that it is both because that active and approved are separate and that would be the only reason it would not show up.

[slow56k]

Hi,

I've installed everything as per instructions but when I come to run the queries I get an error. Any help is appreciated.

DROP TABLE IF EXISTS affiliates;
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL auto_increment,
sitename varchar(50) NOT NULL,
siteurl varchar(250) NOT NULL,
sitedesc mediumtext NOT NULL,
buttonurl varchar(150) NOT NULL,
type tinyint(4) NOT NULL,
email varchar(250) NOT NULL,
clicksout int(20) NOT NULL,
clicksin int(20) NOT NULL,
active tinyint(4) NOT NULL,
totalrating bigint(20) NOT NULL,
totalvotes bigint(20) NOT NULL,
approved tinyint(4) NOT NULL,
PRIMARY KEY (affiliate_id),
KEY sitename (sitename),
KEY siteurl (siteurl),
KEY email (email)
);


An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL auto_increment,
' at line 1

[slow56k]

Typical - as soon as I asked for help I found the answer. Thanks for the hack!!

[mikaelweb]

This hack is posted on difrent forum at this time

[venomx]

huh?

[Guest190829]

Take the link out and report it to vbulletin.

[venomx]

Hmm on my WOL I am getting this...
Unknown Location
/forums/affiliatein.php?do=image&a=1

I made all the edits in the files.. what do I need to do?

Also are we to get an email when people submit a site? I dont get one to tell me I have to go and approve a site..

[Moncal]

Great hack! Thanks.

[m0nde]

Great hack!

I just installed this hack and found an error in affiliateadmin.php which wouldn't let me modify the cantview field in affiliates_settings.
cantview='$canrview',
I changed this to the code below and it worked.
cantview='$cantview',

I can't seem to get the pagination system working at all, though.
It simply won't show the previous and next dialogues if they're needed.

I currently have 7 affiliates in my database and the only way to view these guys is to set the per page setting to 10.

Please help.

The module can be found at http://www.bostonlove.org/forums/affiliate.php

[playstation]

I have installed this hack and can add affiliates fine,but when the other party get the e-mail.with my image link they get this-

Please put the following code on the page/link you provided our database with. Code: <a href="http://www.playstation-elite.co.uk/forum/affiliatein.php?do=redirect&a=8"><img src="http://www.playstation-elite.co.uk/forum/affiliatein.php?do=image&a=8" border="0"></a> OR use this: <a href="http://www.playstation-elite.co.uk/forum/affiliatein.php?do=redirect&a=8">PlayStation-Elite</a>

But there is no banner image showing up on their site. :ermm:

[LEAD_WEIGHT]

When will this be upgraded to vb3.x.x

[venomx]

It is.....

[m0nde]

When will this be upgraded to vb3.x.x

I'm using it with vBulletin 3.0.7 and it works fine.

[poolking]

LEAD_WEIGHT,

Look at what version of vbulletin this is intended for, it is already intended for 3.x.x also look at which forum it is in, that should give you a clue as well.

[LEAD_WEIGHT]

LEAD_WEIGHT,

Look at what version of vbulletin this is intended for, it is already intended for 3.x.x also look at which forum it is in, that should give you a clue as well.
vB Version: 3.0.0 Mod Version: 2.00 Supported
DB Changes
Installer included

Release: 28. Mar 2004 Installs: 115
Last Update: 15. Apr 2004 Rating:

I think those glasses are too dark for u maybe a shade lighter would help unless u see vb3.x.x cause I see vb3.0.0 :ermm:
Your quick poolking :glasses:

Could some ask AN-net if he like to relinquish this hack so some Coder could updated or change how it is setup.

[poolking]

excuse me 3.x.x that you are referring to includes 3.0.0 all the way upto the current version of vbulletin which is 3.0.7.

[agiacosa]

excuse me 3.x.x that you are referring to includes 3.0.0 all the way upto the current version of vbulletin which is 3.0.7.
Anyone find a solution to FireFox redirect problems? The solution in the past post doesn't work for me.

[LEAD_WEIGHT]

Do u know if the text files "installation_instruct" are vb forum edits & "upgrade_instruct" are for CMPS modules. Thx if u could help

[venomx]

I am guesing the upgrade file is for if you ran a old version of this hack...

[LEAD_WEIGHT]

I am guesing the upgrade file is for if you ran a old version of this hack...

Did u install this hack and what board version are u running.

Yah, u are right. It does say overwrite for php. files Thx venomx

The old one was vB Affiliates is that what u are referring to?

U know I was checking how did anyone install this hack for vb3.0.7 if the narbar edits to find that code do not exist, so how do u add a code that not there? It is not in default code, so how.

just wondering how u got the right Navbar code for vb3.0.7 cause the one it shows is for vb3.0.0

I just linked to http://www.mydomain.com/forums/affiliate.php (http://www.mydomain.com/forums/affiliate.php)

~~~~~~~~~~~~~~~~~~~~~~~~~~
Begin Template Edits
~~~~~~~~~~~~~~~~~~~~~~~~~~
-----------------------------------
Open template titled: navbar is vb3.0.0
-----------------------------------
Find:
<td class="vbmenu_control"><a href="$vboptions[bburl]/memberlist.php?$session[sessionurl]">$vbphrase[members_list]</a></td>
-----------------------------------
After Add:
<td class="vbmenu_control"><a href="$vboptions[bburl]/affiliate.php">Affiliates</a></td>



~~~~~~~~~~~~~~~~~~~~~~~~~~
Begin Template Edits
~~~~~~~~~~~~~~~~~~~~~~~~~~
-----------------------------------
Open template titled: navbar is vb3.0.7


navbar vb3.0.7 is the only code that looks to match
------------------------------------
<td class="vbmenu_control"><a href="memberlist.php?$session[sessionurl]">$vbphrase[members_list]</a></td>

so all u do is change it like this.

<td class="vbmenu_control"><a href="http://www.mydomain.com/forums/affiliate.php">Affiliates</a></td>

Credits to venomx for the help

[LEAD_WEIGHT]

https://vborg.vbsupport.ru/showpost.php?p=602355&postcount=210

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL au

Is this one query or many cause I copy & paste & get that 1064 error so how do I do this.


Run this query:
DROP TABLE IF EXISTS affiliates;
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL auto_increment,
sitename varchar(50) NOT NULL,
siteurl varchar(250) NOT NULL,
sitedesc mediumtext NOT NULL,
buttonurl varchar(150) NOT NULL,
type tinyint(4) NOT NULL,
email varchar(250) NOT NULL,
clicksout int(20) NOT NULL,
clicksin int(20) NOT NULL,
active tinyint(4) NOT NULL,
totalrating bigint(20) NOT NULL,
totalvotes bigint(20) NOT NULL,
approved tinyint(4) NOT NULL,
PRIMARY KEY (affiliate_id),
KEY sitename (sitename),
KEY siteurl (siteurl),
KEY email (email)
);

Got it this is one query
DROP TABLE IF EXISTS affiliates;

and this is the next query [ after each ( ; ) is a query ]
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL auto_increment,
sitename varchar(50) NOT NULL,
siteurl varchar(250) NOT NULL,
sitedesc mediumtext NOT NULL,
buttonurl varchar(150) NOT NULL,
type tinyint(4) NOT NULL,
email varchar(250) NOT NULL,
clicksout int(20) NOT NULL,
clicksin int(20) NOT NULL,
active tinyint(4) NOT NULL,
totalrating bigint(20) NOT NULL,
totalvotes bigint(20) NOT NULL,
approved tinyint(4) NOT NULL,
PRIMARY KEY (affiliate_id),
KEY sitename (sitename),
KEY siteurl (siteurl),
KEY email (email)
);

credits for help MarcoH64 at vb.com & I guess same guy here :ermm:




One more thing is I am surprise u do not have a paypal donate thing cause of the time u spent on this. :nervous:

[LEAD_WEIGHT]

How do I enable it or what is the amdin link? I get this when i click on it
Sorry but the Affiliates section of this site has been disabled.
I do not see it in c/panel or is it I have to do something that I have not figure out yet. I been up to long. :tired:

[venomx]

Look in your VB admincp

[LEAD_WEIGHT]

Look in your VB admincp

Oh, that where it is hiding or is it that I really do not see it, I need glasses or is it hiding within one the list. Man why is these things getting harder to do.

you go to your administration control panel and click general settings, under that there is a setting that says # of affiliates per page next to it is a drop down menu of #'s you must choose one and also set up your other settings then click update for it take affect.

I do not see that. I wondering those upgrades are for the first version of vB Affiliates v.2 right. I still can not see that like it shows in those thumbs.

[venomx]

If you made the edits to the /admincp file(s) then you should have Affiliates Listed on the right...

[LEAD_WEIGHT]

If you made the edits to the /admincp file(s) then you should have Affiliates Listed on the right...

The left u mean right under Vb options or did I just screw this up. Oh u mean the page appears right of the Admin list controls :tired:

How sad I am I did not even refresh my Admin. C/panel page to see the changes. I really need some sleep but before I do I think I go to look at that Graffito thing it looks real promising :tired:

Woot! Woot! got it working Thanks again venomx

[FightRice.com]

Will this work with 3.07