Vb3 Affiliate Hack

[AN-net]

Description:
This hack lists/displays affiliates added by you and other usergroups.

Features:
-Administration System
-Approval System
-Top Listing System
-Types/Categories for Affiliates
-Affiliate image buttons
-Affiliate descriptions
-Hit counter for Affiliates
-Rating System
-Editing for both types/categories and affiliates via admincp
-Vb Code Parsing

Author: Antonbomb22/AN-Net

Features for Next Version:
-Image link verification
-in and out hit counters
-more administration options and control
-usergroup permissions
-automatic emailing upon approval
-pagination
-cached templates
-and much more...

Live Demo:
http://www.animationation.net/community/affiliate.php

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

Sorry if this is in wrong forum.

PS: this is my first hack, im so excited

*Click Install*

Fixes: (Category Fix - 6:28 PM EST 4/14/04)https://vborg.vbsupport.ru/showpost.php?p=485373

[Ferny72]

Nice hack man was looking for something like this to add to my site. :)

[AN-net]

for those who have already downloaded or installed i have updated the affiliateadmin.php file plz reupload/overwrite the old with this new one attached

[trackpads]

for those who have already downloaded or installed i have updated the affiliateadmin.php file plz reupload/overwrite the old with this new one attached
Very very nice! Will be installing!

[Giveit2u43]

for those who have already downloaded or installed i have updated the affiliateadmin.php file plz reupload/overwrite the old with this new one attached
Thanks for the update.. could you please try and update the zip too so that future users don`t miss the update?! Thanks a lot :)

[ShutDown23]

I was looking for something like this. Thanks!

Will install!

[AN-net]

Thanks for the update.. could you please try and update the zip too so that future users don`t miss the update?! Thanks a lot :)
i alrdy did even before that post;)

[gmarik]

Cool, could you make an addon for any of the portals, I preffer vBindex myself, a box that integrates info from this great hack so I can have my affiliates also on the first page? please!?

[Blackbeard]

Now this is great, this will be in league with vbadvance and arcade, and i agree it would be great to have a addon that will display either banners or active links (addon for vbadvance please)

[Blackbeard]

Just an idea for any upgrades you do, could you make it so the mods get the options in the modcp to sort out any request, takes some work of the admins

[AN-net]

thank you for the suggestions
i will be planning modcp intergration in the next release.
i will try to code something for vbindex this week(since i run it on my site) and vbadvanced ill have to look at.
any other suggestions/feedback you can also leave at the offical support forum:http://www.animationation.net/community/forumdisplay.php?f=55 (open to guests for posting)

[Okiewan]

posted some comments there...

[Blaine0002]

nice hack! *installs* also make an addon block for vbportal when it comes out.

[AN-net]

question on portal blocks, do you want like a top listing of affiliates or just listing of all the affiliates?

[Blackbeard]

Iam not bothered either way m8, as this is a great hack and would be happy with either option

Just one other comment:- where the button is shown, could do with centralising and spacing out the text under the buttom. but thats just small things as iam happy with it.

[AN-net]

Iam not bothered either way m8, as this is a great hack and would be happy with either option


Just one other comment:- where the button is shown, could do with centralising and spacing out the text under the buttom. but thats just small things as iam happy with it.
just edit the affiliate_listbits template;)

[AN-net]

Fix: Fixed editing for types/categories

Those who have downloaded/installed already please reupload/overwrite affiliateadmin.php with the attached file.

[Okiewan]

Gotta tell ya, without pagination, this is not really a viable solution IMHO.

[AN-net]

Gotta tell ya, without pagination, this is not really a viable solution IMHO.
ill have the second version out soon:) Ok?

[Okiewan]

:)

[AN-net]

pagination alrdy done for second version;)

[AN-net]

oh yeah sorry forgot to post this, here is the top listing affiliate block for vbindex:
https://vborg.vbsupport.ru/showthread.php?t=62533

[DrkFusion]

What is the load of this hack? I understand that topsite lists have a lot of load, and I was just wondering, since the vb2 version that was made by Bane or someone (not 100% sure who) had a pretty big load, but was modified to cache. Does this cache as well?

[Natch]

question on portal blocks, do you want like a top listing of affiliates or just listing of all the affiliates?
I'd recommend random selection of X affil's ... X being a number you can specify in your AdminCP options ...

[AN-net]

thank you ill be sure to take that suggestion into consideration for the portal block and the version 2.

oh yes here are my server loads:

[Server Loads: 4.08 ? 4.36 : 4.21]


not sure was is considered high, but i didnt include caching in this version of templates but i will be sure to add that in the next version.

[Charlie Argueta]

Really a nice Hack. ;)

Is it possible to use the WYSIWYG format for the next version? :)

See Ya

[AN-net]

Really a nice Hack. ;)

Is it possible to use the WYSIWYG format for the next version? :)

See Ya
i havent ever worked with the WYSIWYG format yet but i will look at it:)

[AN-net]

to see version 2 of Vb3 Affiliate Hack come to life click here (http://www.animationation.net/community/affiliate.php).

Also if you have any questions/suggestions/ or feedback please feel free to post it here or at: http://www.animationation.net/community/forumdisplay.php?f=55

[ChuanSE]

Works fine

* ChuanSE clicks install ;)

https://vborg.vbsupport.ru/external/2004/04/1.php (http://forums.puredj.com)

[ChuanSE]

when is the next version comming up?

[AN-net]

heres a look at 3 new modules i added:
http://www.animationation.net/community/affiliate.php?do=listaffiliates

[AN-net]

ok, im getting close to being done with version 2. are there any other suggestions or feature you would like see in this version. after this version i will most likely not make the next version for awhile:)

[AutomatikStudio]

My suggestion for next time is to not put those phrases as an SQL query. I'm running around in circles having insert them manually b/c I've already got phraseid's equal to the ones your queries are trying to insert.

[AN-net]

My suggestion for next time is to not put those phrases as an SQL query. I'm running around in circles having insert them manually b/c I've already got phraseid's equal to the ones your queries are trying to insert.
out sry i put their ids in the queries. sry

[ChuanSE]

ok, im getting close to being done with version 2. are there any other suggestions or feature you would like see in this version. after this version i will most likely not make the next version for awhile:)

It would be great that the site titles in the top 5 list would be clickable :)

[AN-net]

It would be great that the site titles in the top 5 list would be clickable :)
woops sry forgot to code that in>_<

[Tim Wheatley]

Here's mine in action, modified a bit:
http://forum.racesimcentral.com/affiliate.php?do=listaffiliates

[ChuanSE]

Your description fields are empty?

[AN-net]

i like the way you worked with the top listing:)
also my affiliate list is currently down due to complications with some new feature i added. Ill try to get it back up and working as soon as possible;)

edit:
any other features or changes you would like to see in this new version?

[Tim Wheatley]

Your description fields are empty?
Yeah, haven't done them yet. I only upgraded to gold last night and I'm still working on it. :)

[AN-net]

need your opinions/suggestions: https://vborg.vbsupport.ru/showthread.php?t=62753

[tnguy3n]

great hack, m8. got it installed & works great on mah board. :)
hit install.

[Davey-UK]

Any ideas when version2 will be released?
The ideas you are throwing about here seem promising.

Seems like it could be a great hack!

[AN-net]

version 2 is live at: http://www.animationation.net/community/affiliate.php
there are few more features to be added and some fixing of the code:)

[Pikok]

version 2 is live at: http://www.animationation.net/community/affiliate.php
there are few more features to be added and some fixing of the code:)

You need to modify it so that the the visitors IP get logged in the datavase along with the date so that they can't keep rating, clicking through, etc. the same site over-and-over-and-over.. Basically to prevent anti-fraud or anti-cheating (whatever you want to call it).

If you weren't to enable the Admin to set the minimum amount of time between rating a site, or between clicks (for ins and outs), then yo ushould at least probably make it so that a user can only rate an individual site once (possibly with an option to be set by the Admin to allow changes) like vB does with thread ratings and have it only count one in and one out click per site per IP per day.

Other than that though, excellent job! It's looking very promising. ;)

[AN-net]

thanks, ill take this into consideration.

[Pikok]

thanks, ill take this into consideration.

You could either put the code into the script itself to remove the old IPs from the database or setup a cron to run daily too. That way they wouldn't be taken up wasted space. ;)

Looking good so far.. The final version of this should be great! :D

[ChuanSE]

version 2 is live at: http://www.animationation.net/community/affiliate.php
there are few more features to be added and some fixing of the code:)

Looks very neat :D
Keep up the good work...

[AN-net]

it is very close to completeion only like 2 or 3 more things to be fixed and it should be ready:)

[ChuanSE]

* ChuanSE can't wait :D

[BarHopper]

I have a problem, in the acp, when i go in Affiliate General Settings, i click yes fo everything, press ok. Then it reverts back to no. Help!. :)

[AN-net]

try this fresh file:

[AN-net]

ok the hack is almost complete just got to write up the instructions and fix the server loads:)

[Geographic2]

*stares at the clock waiting*

[ChuanSE]

*stares at the clock waiting*

Waiting for what???

[Tim Wheatley]

I have a problem, in the acp, when i go in Affiliate General Settings, i click yes fo everything, press ok. Then it reverts back to no. Help!. :)
You missed one of the queries.

[BarHopper]

ok, ive fixed that problem. But now, i cant add affiliates, as when i have filled an affiliate in, and press Add affiliate, it says Affiliate cannot be added, as a Affiliate name or Affiliate URL has not been provided. How do i fix this one?

[AN-net]

you must have both a url and a name filled in for the affiliate

[AN-net]

Version 2 released!!!

You can find it here: https://vborg.vbsupport.ru/showthread.php?t=63044

[BarHopper]

I did. Ahh well, i'll just upgrade and see how it goes.

[Blaine0002]

just so you know u forgot the .zip file extension...

[AN-net]

what do you mean?

[Blaine0002]

inside the main zip theres another file that should have the .zip extension..

[AN-net]

well i would suggest you use version 2 of this hack anyways;)

[Blaine0002]

ill stay with this version untill i NEED 2.0

[AN-net]

ok, if you wish. anyways what file needs another zip?

[stan68]

im getting a error when trying to add the query

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;

first error is this
Error

SQL-query :

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

MySQL said:


Unknown column 'clicks' in 'affiliates'
and the other is this


Error

SQL-query :

ALTER TABLE affiliates2 ADD clicksin INT( 20 ) DEFAULT '0' NOT NULL ,
ADD approved tinyint( 4 ) NOT NULL

MySQL said:


Table 'nukesm.affiliates2' doesn't exist

[AN-net]

sry the queries should be:
ALTER TABLE affiliates CHANGE clicks clicksout INT( 20 ) NOT NULL ;
ALTER TABLE affiliates ADD clicksin INT(20) DEFAULT '0' NOT NULL, ADD approved tinyint(4) NOT NULL;

and this belongs in the version 2 thread;)

[Lurk]

I've installed it...
but i don't see the things to the right... how do i enable or add them?

[ZoNe|GsT]

This mod would be a great a addition to our community.

Read the whole thread and I'm aware it's for 3.0, but would like to know if anyone has gotten it to work for 3.0.1?

[The Realist]

Few questions:

1) I have a red X when no button is added to the account on sign up? What is the path so I can add one if a button is not choosen.

2) There is no way to add a buton to an account from the admin panel and no way to phisically delete an inactive affiliate.

Thanks.

[venomx]

Whats the difference between this and vB Affiliates v.2?

[Blam Forumz]

i need tro know the same

[Viks]

just wondering if this mod is this vB 3.0.3 conpatible?

[AN-net]

just wondering if this mod is this vB 3.0.3 conpatible?
from my experience yet because its still working on my boards;)

[AN-net]

Few questions:

1) I have a red X when no button is added to the account on sign up? What is the path so I can add one if a button is not choosen.

2) There is no way to add a buton to an account from the admin panel and no way to phisically delete an inactive affiliate.

Thanks.
you can change the image via editing the affiliate in acp and to my knowledge you can still delete affiliates ever if inactive:)

[Jason McConnell]

I'm having a problem with the last query, 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

I know, I should be using v2, but I read the first 2 pages of posts and I didn't see to many issues with this. What should I change?

[The Realist]

SOLVED.

[Dead End Society]

*clicks install*

[mikaelweb]

I have made Modification to AFFILIATE template looks better now i hope this will work to you all

[flaregun]

you can change the image via editing the affiliate in acp and to my knowledge you can still delete affiliates ever if inactive:)

I'm still getting the "X" and don't see the option in ACP to set a default image. Any ideas?

thanks

[AN-net]

I'm still getting the "X" and don't see the option in ACP to set a default image. Any ideas?

thanks
did they provide a full url including http:// for buttons?

[Splinteroid]

I'm new to all this, I was just wondering whether it is possible to get the top 5 affilates page (/affiliate.php?do=listaffiliates) to be displayed on the forum home? Perhaps underneath the 'who's online' and 'todays birthdays' bit without having to click on a link or anything. Kinda like this: http://img.photobucket.com/albums/v139/Splinter2004/example2.jpg (in my case I would want it under the shoutbox perhaps)

Thanks in advance for any help you might offer :)

[flaregun]

did they provide a full url including http:// for buttons?

No, sorry, I mean i get the 'x' when there is no photo added. There should either be a default photo or no image call. Some users don't have a photo to upload.

[boo.3]

i get this error when running any querys :(

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

[AN-net]

No, sorry, I mean i get the 'x' when there is no photo added. There should either be a default photo or no image call. Some users don't have a photo to upload.
version 2 of this hack provides a default image if none is given;)

[Lyricsmama]

Hi.
Sorry to be a bother here but I'm having trouble with the redirecton when I click the affiliate's name/button. It just recycles forever and doesn't redirect, any suggestions?

TIA.

[The Realist]

In my affiliates > general settings box there are 2 buttons, one is Reset but my other one is blank, no text?

I presume it supposed to be Save but what do I need to do so I can correct it?

Laters

[o0Hubba0o]

Is this 3.0.7 compatible? I started running the queries and got an error on the first one. I'm fairly new to querries so I have no idea what to do with it:

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

I have no idea where I would find a "manual" to check this stuff like it says either.

[Marco van Herwaarden]

Please post the full error message. Difficult to tell what is wrong from that snippet.

PS A 'manual' you can find at http://www.mysql.com

[o0Hubba0o]

Please post the full error message. Difficult to tell what is wrong from that snippet.

PS A 'manual' you can find at http://www.mysql.com
That is the message copied in full. :ermm:

[o0Hubba0o]

Please post the full error message. Difficult to tell what is wrong from that snippet.

PS A 'manual' you can find at http://www.mysql.com
Bah nevermind, I was running the queries through vB's admincp, I went to phpmyadmin instead and it's all up and working. Thanks for replying though, that's more than I get with other hack questions lol.

[Marco van Herwaarden]

If you are using ACP to run queries, your userid must have permissions to run queries in the config.php, and you can only run 1 statement at a time.

[Guest190829]

There's a version two of this hack that works better..

https://vborg.vbsupport.ru/showthread.php?s=&threadid=63044 (here)

[lewisbeech]

the qureies dont work for me, i get an error for each one telling me there is an error, here is an example (taken from 1st query i need to run)

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-net]

the qureies dont work for me, i get an error for each one telling me there is an error, here is an example (taken from 1st query i need to run)
try running each separaretly instead of together:)

[o0Hubba0o]

the qureies dont work for me, i get an error for each one telling me there is an error, here is an example (taken from 1st query i need to run)
go back to post 89, my first post and read, I had the same problem. If your using the admin cp your have to have permisions to run queries, which I did, it's my site why wouldn't I give myself persmision. :P The way I got them to work was to go through phpmyadmin through my servers site/user admin.

[mawtenbiker]

go back to post 89, my first post and read, I had the same problem. If your using the admin cp your have to have permisions to run queries, which I did, it's my site why wouldn't I give myself persmision. :P The way I got them to work was to go through phpmyadmin through my servers site/user admin.

how do you do it through your phpmyadmin I looked around but i didn't see anything.

[AN-net]

how do you do it through your phpmyadmin I looked around but i didn't see anything.
its in your cpanel under mysql databases or there is a direct link

[o0Hubba0o]

its in your cpanel under mysql databases or there is a direct link
Well not just cpanel, this is a different one than the vb3 admincp, thought I would point that out so your don't get confused mawtenbiker. Your server should have sent you a link to a cpanel for your server, that's where you'll find mysql databases and phpmyadmin.

[lewisbeech]

go back to post 89, my first post and read, I had the same problem. If your using the admin cp your have to have permisions to run queries, which I did, it's my site why wouldn't I give myself persmision. :P The way I got them to work was to go through phpmyadmin through my servers site/user admin.

sorry, i'm confused.
i have tried phpmy admin, but i have to choose some categories, and i dont know which ones to pick/choose.

thanks for the help

[o0Hubba0o]

sorry, i'm confused.
i have tried phpmy admin, but i have to choose some categories, and i dont know which ones to pick/choose.

thanks for the help
Well on mine I just select my database, then click the SQL tab and there's a text input box there with this above it: " Run SQL query/queries on database mydatbase_net_forums". Then there's a box with browse button to upload a querie from my computer, and at the bottem a button that says go to execute.

If if doesn't look like this then I can't help you sorry:
http://www.graphicsanonymous.net/images/sql.jpg

[xtreme-mobile]

when itried to run the very last query it said error :( it said the data base VB3_vbforum.something does not exist any ideas? as i can see any settings in the admin cp :(

[xtreme-mobile]

when itried to run the very last query it said error :( it said the data base VB3_vbforum.something does not exist any ideas? as i can see any settings in the admin cp :(


MySQL said:

#1146 - Table 'admin_vbforum.phrase' doesn't exist

any ideas>?

[AN-net]

MySQL said:

#1146 - Table 'admin_vbforum.phrase' doesn't exist

any ideas>?
are you using table prefixes?

[xtreme-mobile]

are you using table prefixes?

dont know mate how can i find out :disappointed:

[AN-net]

dont know mate how can i find out :disappointed:
check your config.php file

[csidlernet]

thanks man

[Hornstar]

Im getting the same error as you guys are getting, on the very last query.

Anyone know the exact reason this is happening to so many people,

i am using vb 3.0.8 Is this my problem?

And someone said something about are you using table prefixes, and thats in the config.php

What if i am? what if im not?

Is this the problem

[AN-net]

Im getting the same error as you guys are getting, on the very last query.

Anyone know the exact reason this is happening to so many people,

i am using vb 3.0.8 Is this my problem?

And someone said something about are you using table prefixes, and thats in the config.php

What if i am? what if im not?

Is this the problem
shouldnt be if your not, i would really suggest using version 2 of this hack though>_>