Vb3 Affiliate Hack

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/commun...splay.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

[o0Hubba0o]

Originally Posted by MarcoH64

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]

Originally Posted by MarcoH64

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.

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

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

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

Originally Posted by 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)

try running each separaretly instead of together

[o0Hubba0o]

Originally Posted by 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)

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]

Originally Posted by o0Hubba0o

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]

Originally Posted by mawtenbiker

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]

Originally Posted by AN-net

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.