vB Affiliates for 3.5

Author: An-net
Ported by: Danny.vbt

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

[high] This hack is in it's early BETA stages, and it should be used for DEBUGGING purposes only. [/high]

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

And more!

Install Overview:

[high] Please upload files before importing product! [/high]
(Thanks Kirby!)

File Uploads(4)
Template Edits(1)
Products(1)
Cron (1)


Please Note:

This hack is in BETA, if you find any bugs whatsoever report them, and I will fix them asap. (I'm almost positive that there will be a few silly bugs.)

Thank You,
And please click Install if you use this hack.


Updates:

BETA 1.0.7

Uploaded new affiliate.php by HawkBizKit, fixes ON clause error

BETA 1.0.6

Uploaded new affiliate.php by Dark_Wizard

BETA 1.0.5

Fixes Installation/Uninstallation issues and table prefix error

BETA 1.0.4

Added missing phrases, fixed permissions issue.

BETA 1.0.3

Fixed errors on xml product, also added auto rebuild bitfields.

BETA 1.0.2

Fixed parse error on affiliate.php

Screen Shots Below: They are Poorer quality due to gifs.

I'm the middle of a big upgrade from vb 3.0.9 to vb 3.5 for one of the sites I admin. This is my top priority now, so the next version won't be released untill I am finished with that.

[davidw]

Originally Posted by Danny.VBT

Did you make sure to upload all the files (especially the xml files) before importing the product?

Also, all the settings should be working...but getting the hack to work is the biggest problem. So it should be fixed first

As I stated in post #148, yes. All files were uploaded before importing the product.
I may just wait until the final 3.5 comes out. Not sure where to go from here but wait.

[o0Hubba0o]

This hack is causing problems when I try to edit a usergroup, well not causing problems it's preventing me, with this message:

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Super Moderators',
`description` = '',
`usertitle` = 'Super Moderator',
`opentag` = '<font color=blue>',
`closetag` = '</font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048319',
`attachlimit` = '0',
`pmquota` = '250',
`pmpermissions` = '3',
`pmsendmax` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '15',
`adminpermissions` = '1',
`genericpermissions` = '204439535',
`genericoptions` = '31',
`profilepicmaxwidth` = '350',
`profilepicmaxheight` = '350',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '50000',
`vbaffiliatespermissions` = '0'
WHERE usergroupid=5;

MySQL Error : Unknown column 'vbaffiliatespermissions' in 'field list'
Error Number : 1054
Date : Thursday, October 13th 2005 @ 09:17:29 PM
Script : http://*************/forums/admincp/usergroup.php
Referrer : http://www.**********/forums/admincp/usergroup.php?do=edit&usergroupid=5
IP Address : ************
Username : ~Hubba~
Classname : vb_database

Trying to manage affiliates I get:

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM affiliates_settings;

MySQL Error : Table 'gfx_forums.affiliates_settings' doesn't exist
Error Number : 1146
Date : Thursday, October 13th 2005 @ 09:18:29 PM
Script : http://www.***********.net/forums/admincp/affiliateadmin.php?do=settings
Referrer : http://www.*********.net/forums/admincp/index.php?do=nav
IP Address : ************
Username : ~Hubba~
Classname : vb_database

Trying to uninstall I get:

Database error in vBulletin 3.5.0:

Invalid SQL:
DROP TABLE affiliates;

MySQL Error : Unknown table 'affiliates'
Error Number : 1051
Date : Thursday, October 13th 2005 @ 09:10:15 PM
Script : http://www.**********.net/forums/admincp/plugin.php
Referrer : http://www.********.net/forums/admincp/plugin.php?do=productdelete&productid=dvbt_vbaffil iates&s=
IP Address : *********
Username : ~Hubba~
Classname : vb_database

All files were uploaded, then the product, I don't want to know how to fix this, I want to know how to get rid of it.

[Blackbeard]

how close is this to Gold release?

[Flow Fusion]

Originally Posted by Blackbeard

how close is this to Gold release?

This is for gold read the top of the page. I am also using Gold.

http://giftedsouls.com

name: test

Pass: 999999

[Blackbeard]

Originally Posted by Flow Fusion

This is for gold read the top of the page. I am also using Gold.

http://giftedsouls.com

name: test

Pass: 999999

sorry what i means is, the affiliation hack is in beta mode when is this expected to be final.

Originally Posted by Blackbeard

sorry what i means is, the affiliation hack is in beta mode when is this expected to be final.

When all known bugs are fixed and the hack is stable for some time.

BETA 2 to will be release in about 4-6 days..

It will fix the mail problem, some other bugs, and add a few minor features.

[davidw]

Somehow, I managed to get it working, but I still have the three same issues as my previous post.

https://vborg.vbsupport.ru/showpost....&postcount=148

[Capricia]

Can somebody please help me with the following, I've asked questions before and never gotten an answer to them.. without me sounding rude can somebody please help me out.

Ok so I installed the hack and it messed up my board big time, I put my back up back (the one I made before I installed the hack) and undid the changes I made, however the hack still shows up in my Admincp and it won't let me remove the plugin (which is very annoying now it's just disabled).

but now it's causing me more problems in the way that I can't make changes to my usergroups.. this is a VERY serious problem for me and I would apriciate it if someone took the time to help me fix this.

I get the following after trying the edit a usergroup (and it's premissions)

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE celestialusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<b><i>',
`closetag` = '</b></i>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`ucash_paycheck` = '0',
`profileviewpermissions` = '15',
`vbaffiliatespermissions` = '',
`maxsiglines` = '0',
`maxsigfontsize` = '0',
`maxsigimgsize` = '0',
`maxsigimgwidth` = '500',
`maxsigimgheight` = '250',
`maxsigimages` = '1',
`custompermissions` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '31',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '130',
`avatarmaxheight` = '180',
`avatarmaxsize` = '35000'
WHERE usergroupid=6;

MySQL Error : Unknown column 'vbaffiliatespermissions' in 'field list'
Error Number : 1054
Date : Saturday, October 15th 2005 @ 09:03:42 AM
Script : http://www.
Referrer : http://www.do=edit&usergroupid=6
IP Address :
Username : Vivianne
Classname : vb_database

When I do try to uninstall the plugin it gives me this error

Database error in vBulletin 3.5.0:

Invalid SQL:
DROP TABLE celestialaffiliates;

MySQL Error : Unknown table 'celestialaffiliates'
Error Number : 1051
Date : Saturday, October 15th 2005 @ 09:10:03 AM
Script : http://www.celestialfaeries.com/admincp/plugin.php
Referrer : http://www.celestialfaeries.com/admi...baffiliates&s=
IP Address :
Username : Vivianne
Classname : vb_database

[Impreza04]

In the product system Edit > vB Affiliates Hack v2.5
Delete everything in the Uninstall Code.

Uninstall the product.
Try reinstalling again then