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.

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

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:

Please upload files before importing product!
(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.

[Daniel]

Loving it, loving it... nice. :)

[Guest190829]

For some reason it wont let me add any more screen shots...it looks exactly the same as the one for 3.0.x, so you can look at that thread untill I upload the screenies. :)

[erratic assasin]

Thanks dude you must have read my mind....lol....."instal clicked"

[erratic assasin]

Parse error: parse error, unexpected ';' in /home/****/*****/*****/affiliate.php on line 575

any ideas?

also

<td class="vbmenu_control"><a href="$vboptions[bburl]/memberlist.php?$session[sessionurl]">$vbphrase[members_list]</a></td>

is not in my navbar template.... :ermm:

[Snake]

Live demo please?

[FleaBag]

Great work Danny! Will install tomorrow... Can't wait for vBspace now... :)

[Guest190829]

I'm going to work now, I'll sort the bugs once I get home. :)

[Impreza04]

I get this error when trying to update my usergroups even when Ive uninstalled the product..

Invalid SQL:
UPDATE vB_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ucash_paycheck` = '0.00',
`forumpermissions` = '68157439',
`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` = '120',
`avatarmaxheight` = '120',
`avatarmaxsize` = '20000',
`ecdownloadpermissions` = '2047',
`vbaffiliatespermissions` = '0'
WHERE usergroupid=6;

MySQL Error : Unknown column 'vbaffiliatespermissions' in 'field list'
Error Number : 1054

[Guest190829]

I get this error when trying to update my usergroups even when Ive uninstalled the product..

Invalid SQL:
UPDATE vB_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ucash_paycheck` = '0.00',
`forumpermissions` = '68157439',
`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` = '120',
`avatarmaxheight` = '120',
`avatarmaxsize` = '20000',
`ecdownloadpermissions` = '2047',
`vbaffiliatespermissions` = '0'
WHERE usergroupid=6;

MySQL Error : Unknown column 'vbaffiliatespermissions' in 'field list'
Error Number : 1054




Did you remove the xml file? and rebuild bitfields?


Also, the hack has been updated to BETA 1.0.2 which should fix the affiliate.php parse error.

[loonytune15]

I hope it runs better than the vb3 one, i had nothing but probs with it.

[Impreza04]

I get this error when Importing the product.

Parse error: parse error, unexpected '<' in /home/imp04/public_html/forum/admincp/plugin.php(1192) : eval()'d code on line 1

Sorry to be a pain..

[erratic assasin]

Oh dear this hack needs some major work! more errors than a dyslexic school boy.. at the momment im trying to rebuild my board thanks for the extra work load dude....

user groups .. will not let me add a new group ???

removed XML files and still .. wont let me???

my advise "DO NOT INSTALL BETA VERSIONS"

[BamaStangGuy]

Oh dear this hack needs some major work! more errors than a dyslexic school boy.. at the momment im trying to rebuild my board thanks for the extra work load dude....

user groups .. will not let me add a new group ???

removed XML files and still .. wont let me???


my advise "DO NOT INSTALL BETA VERSIONS"

my advise "DO NOT INSTALL BETA VERSIONS"

Your... not smart...

If everyone had your mentality EVERYTHING would remain beta including the very forum software you are using.

[AN-net]

Oh dear this hack needs some major work! more errors than a dyslexic school boy.. at the momment im trying to rebuild my board thanks for the extra work load dude....

user groups .. will not let me add a new group ???

removed XML files and still .. wont let me???


my advise "DO NOT INSTALL BETA VERSIONS"
wow someone is ungrateful...

[Glovebox]

Whats ungrateful about it? It doesnt work and it messes up the database and usergroups. Rude and offensive yes, but not ungrateful.

Adam

[erratic assasin]

read below!

[erratic assasin]

Your... not smart...

If everyone had your mentality EVERYTHING would remain beta including the very forum software you are using.

sorry if you feel that my comments where out of place! but when you are limited in .php and your board has been running well until you install said hack you do tend to get a little pissed...

My apologise to the author of the hack .... I was angry and well theres no excuse....sorry for my outburst..

@Brent-Wilson mind your "expletive" business! when I want your opinion I will ask for it!

Your... not smart...

smart enough to warn peeps who do not know much about .php that this hack has more holes than dutch cheese..

anyway what are you married to the author?

and do you own a mustang?

[erratic assasin]

wow someone is ungrateful...

Question "DID YOU INSTALL IT????" Hmm I wonder why??? :speechless:

[AN-net]

Question "DID YOU INSTALL IT????" Hmm I wonder why??? :speechless:
actually i initially created this hack

[erratic assasin]

actually i initially created this hack

Yep and heres another members quote""

I hope it runs better than the vb3 one, i had nothing but probs with it.

seems nether of you could get it right....

[Guest190829]

This is BETA for a reason, and anyone who has installed this on a live board should not complain to me. I don't mean to sound rude, but that's how it is.

I'll look into the bugs now...

[Guest190829]

Okay, this should fix the product import bug. I put php tags in the install code which caused the problem. Uninstall orignal product, Reupload product and install, on a test board.

I also appreciate everyone who gave constructive comments, and reported bugs. Thank you. :)

[Glovebox]

Still getting this on install danny:

Parse error: parse error, unexpected '<' in /home/*****/public_html/admincp/plugin.php(1156) : eval()'d code on line 1

[AN-net]

Yep and heres another members quote""



seems nether of you could get it right....
someone is in a grouchy mood>_>

[Guest190829]

Still getting this on install danny:


Parse error: parse error, unexpected '<' in /home/*****/public_html/admincp/plugin.php(1156) : eval()'d code on line 1

Forgot to upload the new .zip package. Try now, thanks again for your patience. :)

[Glovebox]

Looking better bud, just a couple of things I picked up regarding phrases:


Maybe more than this but I havent checked it out fully yet.

Adam

Edit: Also

MySQL Error : Unknown column 'vbaffiliatespermissions' in 'field list'
When trying to do anything with usergroup permissions.

[Guest190829]

Okay, seems like I forgot to add the phrases to the Product. Will update, thanks for the report.

[Guest190829]

Doh! I forgot to tell you to run the query needed. That's what is causing the permissions error.

[Glovebox]

You've lost me there matey, sorry! ;-)

[Guest190829]

You've lost me there matey, sorry! ;-)

Lol, I'm just talking to myself I guess. I'll provide an update that will do it automatically.

[Guest190829]

Okay, another update.

BETA 1.0.4 should fix the usergroup permission error, and also add the missing queries.

[erratic assasin]

@ Danny yeah your right! Im an ass .. Nice work .. and thank you ... :squareeyed:

[Brinnie]

can u use images?
if yes, can u specify a max width x height?

[Impreza04]

Ok.. now im gonna be a real pain:

Affiliateadmin.php
Parse error: parse error, unexpected ',' in /home/imp04/public_html/forum/admincp/affiliateadmin.php on line 193

affiliate.php
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM vB_ affiliates_settings;

MySQL Error : Table 'imp04_vbulliten.vB_' doesn't exist
Error Number : 1146
Date : Tuesday, September 20th 2005 @ 08:19:25 AM
Script : http://www.playstation-racing.co.uk/forum/affiliate.php

Uninstalling
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
DROP TABLE affiliates;

MySQL Error : Unknown table 'affiliates'
Error Number : 1051
Date : Tuesday, September 20th 2005 @ 08:23:42 AM
Script : http://www.playstation-racing.co.uk/forum/admincp/plugin.php

[Glovebox]

Thanks for your help Danny, works great now.

Minor niggle:

Code:

Appears at top of affialiates page, see my site to see what I mean.

Adam

[Guest190829]

Glovebox,

Look in your affiliate template, and there should be "Code:" there, remove it and it will fix it.

Impreza04, I fix the affiliateadmin.php error, I will upload it tonight. Also, it seems like you didn't properly install the product because the tables don't exist...

Brinnie,
Yes you can use image, and I think there is a set width. Check the admin cp setting of the hack.

[jugo]

go into the AFFILIATE template and remove Code:

And go into line 193 of the affiliateadmin.php file and change it to this:


print_stop_message('approved_affiliate_x_successfu lly', $sitename);


Thanks Danny...awesome work..

[Omega Prime]

Is there any means to using this if the affiliate system was installed with 3.0.x? What I mean is that I tried running the plugin and got this:


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)
);

MySQL Error : Table 'affiliates' already exists


I suppose I could just drop the old tables, but I had hoped that this would be more of an upgrade than a fresh install :)

[Hawkbizkit]

you forgot to add the " . TABLE_PREFIX . " in the xml for those of us that use prefix's like myself ;)

Edit: also in the uninstall code to remove the usergroup database info your plugin added you put DELETE instead of DROP..:D

Edit2: well it looks like in the affiliateadmin.php you put a ton of spaces after the table prefix codes all over the place which cause many errors...

[Impreza04]

Nope.. Ive tried re-installing with overwrite on and its not creating the tables.. :ermm:

[Guest190829]

If you already have the affiliates database, I'll make a product for just the two plugins in the product.

Also, that was the fix for the affiliate admin page...are there any other errors?

[Hawkbizkit]

well all 3 php pages you have for this mod need the space removed after the " . TABLE_PREFIX . " cause it was in more than just the admin page. there was one more error i came up with but i can't remember since i uninstalled it anyways since i was tried of playing with it but maybe tonight i will give it another run... ;) and let you know of any problems

[Guest190829]

well all 3 php pages you have for this mod need the space removed after the " . TABLE_PREFIX . " cause it was in more than just the admin page. there was one more error i came up with but i can't remember since i uninstalled it anyways since i was tried of playing with it but maybe tonight i will give it another run... ;) and let you know of any problems

Okay, thanks. I'll fix that tonight, and upload the new zip file. :)

[Protoman]

I'm having issues that I am unable to install vbAdvanced CMPS after installing this hack. not sure if it's just me or what.. so I tried to uninstall the hack and got an error.
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
ALTER TABLE usergroup DELETE vbaffiliatespermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

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 'DELETE vbaffiliatespermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL' at line 1
Error Number : 1064
Date : Friday, September 23rd 2005 @ 01:45:58 PM
Script : http://testvb.mysite.net/forum/admincp/plugin.php
Referrer : http://testvb.mysite.net/forum/admincp/plugin.php?do=productdelete&productid=dvbt_vbaffiliates&s=
IP Address : XXXXXX
Username : admin
Classname : vB_Database

[Dark_Wizard]

I'm having issues that I am unable to install vbAdvanced CMPS after installing this hack. not sure if it's just me or what.. so I tried to uninstall the hack and got an error.
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
ALTER TABLE usergroup DELETE vbaffiliatespermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

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 'DELETE vbaffiliatespermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL' at line 1
Error Number : 1064
Date : Friday, September 23rd 2005 @ 01:45:58 PM
Script : http://testvb.mysite.net/forum/admincp/plugin.php
Referrer : http://testvb.mysite.net/forum/admincp/plugin.php?do=productdelete&productid=dvbt_vbaffiliates&s=
IP Address : XXXXXX
Username : admin
Classname : vB_Database


The product xml file isn't correct for this hack...Danny, get in touch with me via IM....I have an updated xml file for you since I had the same issues as everyone else.

[Guest190829]

The product xml file isn't correct for this hack...Danny, get in touch with me via IM....I have an updated xml file for you since I had the same issues as everyone else.

Okay, I pmed you.

Once I get this sorted out, I will fix the other bugs and do another update to BETA 1.0.5.

[Hawkbizkit]

Line 308 affiliates.php you are missing the " . TABLE_PREFIX . ". Other than that i think i fixed the installing/uninstalling and using functionallity so if you wanna take a look at the code or the pages i have fixed feel free to hit me up in the vb.org chat system or over MSN/Yahoo/AIM messanger.

Edit: Here are a few links to it up and running just fine
http://forum.overhauledpc.com/affiliate.php?do=listaffiliates
http://forum.overhauledpc.com/affiliate.php?do=apply
http://forum.overhauledpc.com/affiliate.php

[ReadOrDie]

I'm getting this error: Sorry but the affiliate section of the siteis currently disabled. How do I fix it? It's when I click on the affiliates tab.

[Guest190829]

I'm getting this error: Sorry but the affiliate section of the siteis currently disabled. How do I fix it? It's when I click on the affiliates tab.

In Admin Cp- > Affiliate Setting -> Set that the affiliate section is enabled.

[ReadOrDie]

In Admin Cp- > Affiliate Setting -> Set that the affiliate section is enabled.

Could you be more specific? Or provide screenshots? Because I'm looking everywhere in the Admin CP and I can't find something that says "Affiliate Setting"

[Guest190829]

AdminCP -> Affiliates -> General Settings -> Is the Affiliates Addon Active? If not, no one can view this addon - > Set to yes

If you can't see Affiliates category in the admincp, make sure you upload the cpnav_affiliates.xml file to your includes/xml directory.

[Guest190829]

Okay, thanks to Dark_Wizard for updating the xml product, the hack has been updated to BETA 1.0.5.

This fixes the various problems with installation/uninstallation, and it also should fix the "TABLE_PREFIX" problem.

( I did a find/replace to take the spaces away)

[ReadOrDie]

Now I'm getting this error: Parse error: parse error, unexpected ',' in /www/g/************/htdocs/forum/admincp/affiliateadmin.php on line 193

[Guest190829]

Hm...I don't see anything wrong with that line, nor did I make any changes to it. Can you post line 193 of the file on here, so I can take a look?

Is anyone else having this problem?

[Impreza04]

Everything is working on my test board apart from when trying to view affiliate.php

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM vb_ affiliates_settings;

MySQL Error : Table 'integram_crg.vb_' doesn't exist
Error Number : 1146
Date : Monday, September 26th 2005 @ 04:22:45 PM

EDIT: Actually I see the problem myself and its fixed..
//################## Begin Settings###################//
$setting= $db->query_first("SELECT * FROM " . TABLE_PREFIX ." affiliates_settings");

Has a space..
Replace with
//################## Begin Settings###################//
$setting= $db->query_first("SELECT * FROM " . TABLE_PREFIX ."affiliates_settings");

Lets try on my real board


The disabled message
"Sorry but the affiliate section of the siteis currently disabled."
Needs a space between site and is :rolleyes:

and
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,totalrating,totalvotes
FROM vB_affiliates LEFT JOIN vB_affiliates_types
ON affiliates.type = affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,20;

MySQL Error : Unknown table 'affiliates' in on clause
Error Number : 1109
Date : Monday, September 26th 2005 @ 09:05:35 AM
Script : http://www.playstation-racing.co.uk/forum/affiliate.php?do=listaffiliates

[ReadOrDie]

Hm...I don't see anything wrong with that line, nor did I make any changes to it. Can you post line 193 of the file on here, so I can take a look?

Is anyone else having this problem?

I don't get what you mean...

[Dark_Wizard]

Okay, thanks to Dark Visor for updating the xml product, the hack has been updated to BETA 1.0.5.

This fixes the various problems with installation/uninstallation, and it also should fix the "TABLE_PREFIX" problem.

( I did a find/replace to take the spaces away)

LOL...close enough. Although Dark Visor may like it... ;)

[loneranger]

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,tota lrating,totalvotes
FROM vB_affiliates LEFT JOIN vB_affiliates_types
ON affiliates.type = affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,20;

MySQL Error : Unknown table 'affiliates' in on clause




i am getting this error too is there a solution yet as i need this

[ReadOrDie]

This hack is becomming very troublesome...

[Dark_Wizard]

This hack is becomming very troublesome...


Try this file overwriting the one you have now..

[Guest190829]

LOL...close enough. Although Dark Visor may like it... ;)

Lol, Sorry I changed I the it, and put you as a supporter. Is their a Dark Visor on vb.org?

And to everyone getting annoyed, or irratated by the errors and updates of the hack. Please realize that this is only in the BETA stages without these errors the hack would not progress!

[Hawkbizkit]

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,tota lrating,totalvotes
FROM vB_affiliates LEFT JOIN vB_affiliates_types
ON affiliates.type = affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,20;

MySQL Error : Unknown table 'affiliates' in on clause




i am getting this error too is there a solution yet as i need this
very simple fix on line 309 in the affiliate.php change this ON affiliates.type = affiliates_types.id

with this ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id

[Dark_Wizard]

I have already changed the file in the post above and it's better to do it this way:


SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,tota lrating,totalvotes
FROM vB_affiliates AS affiliates LEFT JOIN vB_affiliates_types AS affiliates_type
ON affiliates.type = affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,20;

[Impreza04]

Nope sorry. None of those fixes work. Same error still occurs :ermm:

[Guest190829]

This should be a simple fix, by combining both of the suggested fixes..I'll do this later tonight and upgrade the hack with the new affiliate file.

[ReadOrDie]

delete this post plz.

[ReadOrDie]

Sorry about that, It's working now. I reinstalled the adminaffiliate.php thing! I'm clicking install!

[ReadOrDie]

Now it says I don't have permission...How do I not have permission? I'm the administrator. When I click on the affiliates in the forum it says you may not have enough priviledges blah blah blah...

[Guest190829]

You have to set permissions in the usergroup manager

[ReadOrDie]

You have to set permissions in the usergroup manager

Nothing in the usergroup manager says anything about affiliates...

[Guest190829]

Did you upload the bitfield_vbaffiliates.xml file into your includes/xml directory?

[Impreza04]

Has the affiliate file been updated yet..?

[ReadOrDie]

Did you upload the bitfield_vbaffiliates.xml file into your includes/xml directory?

Alright I installed it, but yet again I'm getting another error:
Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 628

[Guest190829]

What page are you getting that error? I think I filtered out a integer type variable, that's what is causing the error.

[bi11i]

Everything is working on my test board apart from when trying to view affiliate.php

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM vb_ affiliates_settings;

MySQL Error : Table 'integram_crg.vb_' doesn't exist
Error Number : 1146
Date : Monday, September 26th 2005 @ 04:22:45 PM

EDIT: Actually I see the problem myself and its fixed..
//################## Begin Settings###################//
$setting= $db->query_first("SELECT * FROM " . TABLE_PREFIX ." affiliates_settings");

Has a space..
Replace with
//################## Begin Settings###################//
$setting= $db->query_first("SELECT * FROM " . TABLE_PREFIX ."affiliates_settings");

Lets try on my real board


The disabled message
"Sorry but the affiliate section of the siteis currently disabled."
Needs a space between site and is :rolleyes:

and
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,totalrating,totalvotes
FROM vB_affiliates LEFT JOIN vB_affiliates_types
ON affiliates.type = affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,20;

MySQL Error : Unknown table 'affiliates' in on clause
Error Number : 1109
Date : Monday, September 26th 2005 @ 09:05:35 AM
Script : http://www.playstation-racing.co.uk/forum/affiliate.php?do=listaffiliates

thanks, that fixed my SQL error, also.

Are the General Settings optimally configured by default?

[bi11i]

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,totalrating,totalvotes
FROM opio_affiliates AS affiliates_types
LEFT JOIN opio_affiliates_types AS affiliates_type
ON opio_affiliates.type = opio_affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,5;

MySQL Error : Unknown table 'opio_affiliates' in on clause
Error Number : 1109
Date : Wednesday, September 28th 2005 @ 11:45:15 AM
Script : http://forum.opiophile.org/affiliate.php?do=listaffiliates
Referrer : http://forum.opiophile.org/affiliate.php
IP Address : 192.168.0.110
Username : bi11i
Classname : vB_Database_MySQLiI'm still getting this error no matter which hack to the mod I try. Any definitive solution?

[Hawkbizkit]

I'm still getting this error no matter which hack to the mod I try. Any definitive solution?
you are missing the who affiliates table it's self it looks like try runing the query to install the table
CREATE TABLE `opio_affiliates` (
`affiliate_id` int(10) NOT NULL auto_increment,
`sitename` varchar(50) NOT NULL default '',
`siteurl` varchar(250) NOT NULL default '',
`sitedesc` mediumtext NOT NULL,
`buttonurl` varchar(150) NOT NULL default '',
`type` tinyint(4) NOT NULL default '0',
`email` varchar(250) NOT NULL default '',
`clicksout` int(20) NOT NULL default '0',
`clicksin` int(20) NOT NULL default '0',
`active` tinyint(4) NOT NULL default '0',
`totalrating` bigint(20) NOT NULL default '0',
`totalvotes` bigint(20) NOT NULL default '0',
`approved` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`affiliate_id`),
KEY `sitename` (`sitename`),
KEY `siteurl` (`siteurl`),
KEY `email` (`email`)
) ;

[bi11i]

you are missing the who affiliates table it's self it looks like try runing the query to install the table

error number: 1050
error desc: Table 'opio_affiliates' already existswhen running the query...

[Hawkbizkit]

oh dummy me i read your error wrong sorry well i would say try this code

Find: (should be around line 307ish in affiliates.php)
$faffiliate=$db->query_read("SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,totalrating,totalvotes
FROM " . TABLE_PREFIX . "affiliates AS affiliates LEFT JOIN " . TABLE_PREFIX . "affiliates_types AS affiliates_type
ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY $by $in
LIMIT $limitvalue,$perpage"
);


Replace with: on the first line in this code there is a space between tota lrating just remove the 2 spaces and it should work just fine.
$faffiliate=$db->query_read("SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,totalrating,totalvotes
FROM " . TABLE_PREFIX . "affiliates LEFT JOIN " . TABLE_PREFIX . "affiliates_types
ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY $by $in
LIMIT $limitvalue,$perpage"
);

Thats how i have my code setup and it is working just fine and when i tried it your way it doesn't work...

EDIT: Fix down in post #88 (http://showpost.php?p=781411&postcount=88)

[ReadOrDie]

What page are you getting that error? I think I filtered out a integer type variable, that's what is causing the error.

I'm getting the error when I try to update the usergroups. It happens right after I press "update"

[bi11i]

Another problem I'm having is the displaying of $bbuserinfo in the error message I received concerning insufficient privilges. Is global.php missing from somewhere? It looks to be in the two affiliate files. Any ideas?$bbuserinfo[username], you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account. Use the contact form to find out why.

[bi11i]

oh dummy me i read your error wrong sorry well i would say try this code

Find: (should be around line 307ish in affiliates.php)
$faffiliate=$db->query_read("SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,totalrating,totalvotes
FROM " . TABLE_PREFIX . "affiliates AS affiliates LEFT JOIN " . TABLE_PREFIX . "affiliates_types AS affiliates_type
ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY $by $in
LIMIT $limitvalue,$perpage"
);


Replace with:
$faffiliate=$db->query_read("SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,totalrating,totalvotes
FROM " . TABLE_PREFIX . "affiliates LEFT JOIN " . TABLE_PREFIX . "affiliates_types
ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY $by $in
LIMIT $limitvalue,$perpage"
);

Thats how i have my code setup and it is working just fine and when i tried it your way it doesn't work...

I've got this with your new modification:Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,tota lrating,totalvotes
FROM opio_affiliates LEFT JOIN opio_affiliates_types
ON opio_affiliates.type = opio_affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,5;

MySQL Error : Unknown column 'tota' in 'field list'
Error Number : 1054
Date : Wednesday, September 28th 2005 @ 02:17:58 PM
Script : http://forum.opiophile.org/affiliate.php?do=listaffiliates
Referrer : http://forum.opiophile.org/affiliate.php
IP Address : 192.168.0.110
Username : bi11i
Classname : vB_Database_MySQLi

[bi11i]

I've got this with your new modification:

I managed to correct the totalrating line.

On to the next problem:

I added an affiliate via the Admin Panel. It doesn't show. So I need to approve it via the admin panel? I'm not sure why this would be, but after I do approve it, get this error:Warning: mail() [function.mail]: SMTP server response: 503 No recipient(s). in \admincp\affiliateadmin.php on line 191The email fields are filled out, plus it went way too quick to have gotten that info from my mailserver.

The the other problem is that if an image is not added to an affiliate, I get the old x'd out box. Any way to fix that?

Also, shouldn't the affiliates open up in a new window?

Last, wouldn't it be best to include an if statement in the navbar for when the affiliates is turned off?

[Guest190829]

I'm getting the error when I try to update the usergroups. It happens right after I press "update"

Try rebuilding the bitfields manually through the admincp. I'm going to open my test board with this on, along with a bug tracker so I can easily find all the bugs..Also, I will post an update right now...

[Guest190829]

Please submit all bugs to

http://www.dev.tobroadway.com/forum/vbugs.php

You do not have to register to post bugs...

[ReadOrDie]

I'm still getting this error: Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 628

Whatever it is, it has something to do with classcore.php...

[Hawkbizkit]

I've got this with your new modification:
dangit i don't know why but each time i post something using the PHP tags it wants to add a space somewhere where it should not.....meaning fix this space it added in the first line..

edit dangit it still keeps adding the space just try replacing it with this page
or just in the first line fix the space between tota lrating to totalrating

[Guest190829]

I'm still getting this error:

Whatever it is, it has something to do with classcore.php...

Did you try manually rebuilding the bitfields via the Admin Cp Option? It seems like it isn't doing it now..

[Impreza04]

Cheers that new file worked..

One small thing though:
Uncached templates: affiliate_list (1)
Uncached templates: affiliate_listbits (1)

[Hawkbizkit]

alright add this plugin to cache your templates also i attached a file to group the templates in your style

[Impreza04]

Ta.. yay.. It all finally works I hope..
>> Another thing - When voting the default stars are used even though im using a custom template with unique rankings.
Any chance this can be fixed.?

[ReadOrDie]

Did you try manually rebuilding the bitfields via the Admin Cp Option? It seems like it isn't doing it now..

What do you mean? I'm not good at editing files or whatever... :nervous:

[Guest190829]

What do you mean? I'm not good at editing files or whatever... :nervous:

You don't have to edit files, point your AdminCP page to this:

admincp/index.php?do=buildbitfields

so it's www.yourdomain.com/admincp/index.php?do=bitfields

[Hawkbizkit]

Ta.. yay.. It all finally works I hope..
>> Another thing - When voting the default stars are used even though im using a custom template with unique rankings.
Any chance this can be fixed.?
in template affiliate_listbits
Find:
<img src="$stylevar[imagesfolder]/rating/rating_$rating.gif" />

and replace it with your location to your ratings images.
<img src="$stylevar[imgdir_rating]/rating_$rating.gif" />

[ReadOrDie]

You don't have to edit files, point your AdminCP page to this:

admincp/index.php?do=buildbitfields

so it's www.yourdomain.com/admincp/index.php?do=bitfields

That doesn't work, it leads me straight to the frontpage of the admin CP.

[Guest190829]

Is your forum on debug mode?

[ReadOrDie]

Is your forum on debug mode?

How do I turn it on debug mode? Isn't there an easier way to fix the usergroups error?

[xtreme-mobile]

when i click view current affiliates it shows following error:


Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,totalrating,totalvotes
FROM vb3_8affiliates AS affiliates_types
LEFT JOIN vb3_8affiliates_types AS affiliates_type
ON affiliates.type = affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,5;

MySQL Error : Unknown table 'affiliates' in on clause
Error Number : 1109
Date : Friday, September 30th 2005 @ 03:58:53 PM
Script : http://www.talk-365.com/forum/affiliate.php?do=listaffiliates
Referrer : http://www.talk-365.com/forum/affiliate.php
IP Address : xx.xxxx.xxx.xxx
Username : Dean
Classname : vb_database

any ideas?

[Hawkbizkit]

this file is working and should fix your problem unless the table is not in the database
https://vborg.vbsupport.ru/attachment.php?attachmentid=34901
in post #88 (showpost.php?p=781411&postcount=88)

[Guest190829]

I've updated to BETA 1.0.7, this uses Hawkbizkit's affiliate.php file to fix the ON CLAUSE error. Just upload that new file, and it should work. Thanks Hawkbizkit. :)

[ReadOrDie]

The affiliates file didn't fix my error: Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 628

Anyone got a solution?

[Guest190829]

Follow these instruction to put on debug mode

https://vborg.vbsupport.ru/showthread.php?t=82835

Then point your domain to the link I gave you.

It should say

"Bitfields rebuilt successfully" or something like that.

[ReadOrDie]

Follow these instruction to put on debug mode

https://vborg.vbsupport.ru/showthread.php?t=82835

Then point your domain to the link I gave you.

It should say

"Bitfields rebuilt successfully" or something like that.

Thanks anyways but this hack is a little too stressful for me, each time I solve one problem two more come up. I think I'll wait till this gets fixed, or kirby re-makes this into a usuable version. :ermm:

[Guest190829]

Thanks anyways but this hack is a little too stressful for me, each time I solve one problem two more come up. I think I'll wait till this gets fixed, or kirby re-makes this into a usuable version. :ermm:

Okay, that's your choice. I'm sure you could code a more stable version :)

-Danny

[Andreas]

Just a note:
Enabling debug mode is not necessary to rebuild bitfields.
Just point the browser to admincp/index.php?do=buildbitfields

I think i'll write a FAQ with some bold, red, blinking text in size 7:
Upload Bitfields XMLs before importing Products! :D

[Guest190829]

Just a note:
Enabling debug mode is not necessary to rebuild bitfields.
Just point the browser to admincp/index.php?do=buildbitfields

I think i'll write a FAQ with some bold, red, blinking text in size 7:
Upload Bitfields XMLs before importing Products! :D

Kirby to the rescue again. :D

[erratic assasin]

You posted some pretty ignornat comments in the affiliates thread when it messed up your board. I guess you are smart enough to know that installing modifications is done at the users risk?

People like you ruin the boards and prevent some mods from being released. If it says beta, don't touch it. Those of us that know how to deal with and work out issues will install it. Sit on your hands like a good boy and wait for us to release the debugged version. Don't start running your mouth when you apparently can't do any of this yourself. This site doesn't need you....you need this site! Grow up and start showing a little gratitude. Modifications are free and no one gets paid for the time they take to write. When you are releasing mods, +++++ all you want. Until then, shut your mouth.

I agree with you I did check to see if it was a beta when I downloaded and installed guess I missed the tick in the box! and yes I have alot to learn... and you are right I do need this site more than it needs me...there is no excuse for my behaviour please forgive me ....:nervous:

I will go on bended knee and beg forgiveness!

@Danny VBT I am truly sorry for my outburst for that I have no excuses

@Any one else I offended I apologize!

yours (ashamedly)

Erratic assasin

Thank you iguanairs for your PM!

[Capricia]

I could use some help please, I just installed the first version tonight (1.4) I got errors then I read this thread and downloaded the newer version (1.7) still errors. Can anyone tell me what I'm doing wrong and how to fix this?

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM celestial affiliates_settings;

MySQL Error : Table 'd2751dig_new.celestial' doesn't exist
Error Number : 1146
Date : Sunday, October 2nd 2005 @ 11:27:30 PM
Script : http://www.celestialfaeries.com/affiliate.php
Referrer : http://www.celestialfaeries.com/index.php
IP Address : 212.238.236.169
Username : Vivianne
Classname : vb_database


And I get this in the ACP

Database error in vBulletin 3.5.0:

Invalid SQL:
SELECT * FROM celestialaffiliates_settings;

MySQL Error : Table 'd2751dig_new.celestialaffiliates_settings' doesn't exist
Error Number : 1146
Date : Sunday, October 2nd 2005 @ 11:30:04 PM
Script : http://www.celestialfaeries.com/admincp/affiliateadmin.php?do=settings
Referrer : http://www.celestialfaeries.com/admincp/index.php
IP Address : 212.238.236.169
Username : Vivianne
Classname : vb_database

[subnet_rx]

I'm getting this error when I try to run the cron job:

Fatal error: Call to a member function on a non-object in /includes/cron/affiliate_emptyrec.php on line 10

[mcyates]

I get this error when updating the usergroups.


Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

[mcyates]

also i get this when running the cron job


Fatal error: Call to a member function on a non-object in /home/myfootba/public_html/includes/cron/affiliate_emptyrec.php on line 10

[mcyates]

i've disabled this from my board for the time being.

[Guest190829]

I get this error when updating the usergroups.


Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635


Did you make sure to Upload the xml files before importing the product?

[Guest190829]

also i get this when running the cron job


Fatal error: Call to a member function on a non-object in /home/myfootba/public_html/includes/cron/affiliate_emptyrec.php on line 10


Open up affiliate_emptyrec.php and put this right after <?php

require_once('./global.php');

[mcyates]

Did you make sure to Upload the xml files before importing the product?

I uploaded it to the XML folder on the forum and imported it that way, it worked. The files cpnav_affiliates.xml and bitfield_vbaffiliates.xml where already on the server when i imported the file from my computer. I don't know why it didn't work when importing thr xml file from my pc. It worked when i uploaded it to the includes/xml directory. Thanks

[mcyates]

also the script does not send out any emails to new sites that join up. There is no option to delete sites in the lists.

[Blackbeard]

Is this going to be made into gold version, dont want to install a rc version then have to play again in a day or two

[Guest190829]

I'm upgrading the hack tonight that fixes various bugs...if no other bugs occur then it will be upgraded to Beta 2...then finally to GOLD.

[Blackbeard]

cheers m8

[ReadOrDie]

Alright I finally got it working, a friend gave me the database code. The product is useless. But now when I apply to affiliate nothing appears, meaning there are no affiliates. I had friends apply too...nothing...and I checked the affiliates option in the admin CP, nothing to validate either...whats wrong?

[pyro.699]

i would eb that friend ^^ and same here.... if you help one of us, we both will get program working!

[Guest190829]

Alright I finally got it working, a friend gave me the database code. The product is useless. But now when I apply to affiliate nothing appears, meaning there are no affiliates. I had friends apply too...nothing...and I checked the affiliates option in the admin CP, nothing to validate either...whats wrong?

Well I can't really tell you, because you've used installation code that I don't know. Did you try adding affiliates via the admin CP to test if it's working?

[pyro.699]

no, its your code....

i ran your script, and then exported teh ones, then made up the permissions 1.. tis the exact same thing you have ^^

[Guest190829]

no, its your code....

i ran your script, and then exported teh ones, then made up the permissions 1.. tis the exact same thing you have ^^

Well is there an error coming up when the member applies? Did you check the table to see if there is any content? It works for everyone else, so I need more information to fix the problem. :)

[pyro.699]

ill add you to icq, we can talk there ^^

[Guest190829]

ill add you to icq, we can talk there ^^

I no longer have ICQ installed, best way to talk to me is using vb.org's chat room. :)

[pyro.699]

awww, and i have no clue how 2 use the chat /; (you could go on icq2go http://www.icq.com/icq2go/ )

[Guest190829]

awww, and i have no clue how 2 use the chat /; (you could go on icq2go http://www.icq.com/icq2go/ )

lol I don't even know my password or my ICQ number...

just go to this url...

https://vborg.vbsupport.ru/chat.php?

[ReadOrDie]

Well is there an error coming up when the member applies? Did you check the table to see if there is any content? It works for everyone else, so I need more information to fix the problem. :)

There's no error. It's just when someone applies, an affiliate is supposed to appear. Nothing appears. Besides the normal page. I asked kirbyde if he could make this into a usuable hack but he still hasn't replied. :ermm:

[Guest190829]

There's no error. It's just when someone applies, an affiliate is supposed to appear. Nothing appears. Besides the normal page. I asked kirbyde if he could make this into a usuable hack but he still hasn't replied. :ermm:

It is useable, yours is the only one not working and keeping me from upgrading to BETA 2. :)

[Impreza04]

Im back.. Few problems im having:

Whenever I try to reset anything, it doesnt work.
Allow Parsing of Image Code? I cant set to yes.
And I dont recieve an Email when a new affiliate applies.

Apart from that everything seems fine.

[ReadOrDie]

Things this hack needs:

Better organized.

The email dispatch does not work fix it please.

The buttons are not so good like the report button.

A user should not be able to rate an affiliate more than once just to gain 100 votes for him or herself to get to the top. The affiliate hack should record the user account so the person can only vote for an affiliate once.

I should be able to edit the disclaimer in the Admin CP but I can't.

The code button to affiliate should be available when people apply to affiliate.



I think that's it for now, but there you go.

[Guest190829]

Things this hack needs:





I think that's it for now, but there you go.

What do you mean by better organized?

[ReadOrDie]

What do you mean by better organized?

It's just things are all over the place. It's a good hack...but too many things on the affiliate page..

[Guest190829]

Well you could disable the modules you don't want or need. All of your other suggestions will be looked into for BETA 2.

[ReadOrDie]

Well you could disable the modules you don't want or need. All of your other suggestions will be looked into for BETA 2.

When will Beta 2 be coming out?

[Guest190829]

In the next 2-3 days. :)

[hotrod1]

Wow super fast install, thanks alot for a great hack!!!!

[Glovebox]

Danny, I am getting the following error when a visitor adds a site:

Parse error: parse error, unexpected T_STRING in /home/w******/public_html/affiliate.php(117) : eval()'d code on line 1

[Flow Fusion]

I keep getting this error...

MySQL Error : Unknown column 'vbaffiliatespermissions' in 'field list'
Error Number : 1054
Date : Monday, October 10th 2005 @ 05:52:45 PM
Script : http://giftedsouls.com/gs/admincp/usergroup.php

[Guest190829]

Looks like the permission query didn't run..try uninstalling and then reinstalling. Import xml files before you upload the product though

[Flow Fusion]

Looks like the permission query didn't run..try uninstalling and then reinstalling. Import xml files before you upload the product though

Yup that did it thanks alot!

[mholtum]

Installed fine, however, when I go to view it It says I dont have permission?

[Hawkbizkit]

have you set the usergroup permissions?

[mholtum]

I didnt see usergroup permissions in the admincp under this heading.. hmm

[mholtum]

I found it. Thanks!

[davidw]

I've set up affiliates as per instructions, assigned usergroups, etc. - anything I could think of (after reading, and rereading this thread). I've also built the bitfields and rebuilt them. I can't think of why this isn't working for me.
Also, I may add note (in case this helps to find the issue to my problem) under General Affiliate Settings, these fields will NOT update:
Email for reports to be sent to:If yes for broken urls/links reporting, enter the email you wish to receive broken urls/links. - will not accept an email address.
Affiliate of the Moment Addon Block Active? If not, the affiliate of the moment addon block will not be activated.Will not retain a "Yes" choice.
Allow Parsing of Image Code? If not, images will not be parsed for affiliates' descriptions.Will not retain a "Yes" choice.

I've fixed numerous other issue by reading through this thread, but am at a loss now.
Thanks!

[Guest190829]

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

[Unexplained.tv]

Is Beta 2 nearing a release date?
I'd like to give it a try, but will wait for the next version.

[Guest190829]

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]

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 firstAs 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_vbaffiliates&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]

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]

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.

[Guest190829]

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.php?p=794942&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/admincp/plugin.php?do=productdelete&productid=dvbt_vbaffiliates&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

[Capricia]

Thank you so much, finally someone who gives me answers *hugs*


EDIT

Ok, I uninstalled the product after that was done I reinstalled the whole hack, everything works fine.. sofar except for one thing.

I can't view the hack from the board nor can I change the settings in the usergroups in the admincp.

When I try this it gives me this:

https://vborg.vbsupport.ru/

and on the board it says I don't have premission to view/access the page.

Any ideas how to fix this?

[davidw]

To add to my post above, when approving someone, I get this error:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, *****@*****.*** and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log. I then click on Manage Affiliates to find that person is approved. Why do I get that error, is it related to the above mentioned problem?

[Guest190829]

Thank you so much, finally someone who gives me answers *hugs*


EDIT

Ok, I uninstalled the product after that was done I reinstalled the whole hack, everything works fine.. sofar except for one thing.

I can't view the hack from the board nor can I change the settings in the usergroups in the admincp.

When I try this it gives me this:

http://i5.photobucket.com/albums/y192/Fleursmom/warning.jpg

and on the board it says I don't have premission to view/access the page.

Any ideas how to fix this?

You must upload the xml files before importing the product, that's what your error is from.

[Guest190829]

To add to my post above, when approving someone, I get this error:

I then click on Manage Affiliates to find that person is approved. Why do I get that error, is it related to the above mentioned problem?

I don't know what is causing your errors, everything should be working as is except for the mail feature.

[Capricia]

You must upload the xml files before importing the product, that's what your error is from.

Tnx hun, that fixed the problem :up:

[o0Hubba0o]

Thank you so much, finally someone who gives me answers *hugs*
I posted that same problem a few posts above you, thank you for posting again, and thank you Impreza04 for the answer to our problems. vBAffiliates now working for me.

[Suzie]

This has screwed up my admin panel and usergroup functions so bad I can't do anything because of errors and I can't uninstal it I get a msql error and I can't delete the templates and disabling it doesn't help. Please advise on how to get rid of this.

[Guest190829]

This has screwed up my admin panel and usergroup functions so bad I can't do anything because of errors and I can't uninstal it I get a msql error and I can't delete the templates and disabling it doesn't help. Please advise on how to get rid of this.

You're going to have to be a little more specific then that, so I can find out what the problem is...

[Suzie]

I can't delete the templates. (that means when I click revert they will not go away it wont even let me revert them) I can't use the uninstall feature because I get a Mysql error this is the error...

[QUOTE]Database error in vBulletin 3.5.0:

Invalid SQL:
DROP TABLE vb_affiliates;

MySQL Error : Unknown table 'vb_affiliates'
Error Number : 1051 [/QUOTE}

The table is there

[Guest190829]

What happens when you try to change usergroup permissions?

[Suzie]

What happens when you try to change usergroup permissions?
Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE vb_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = 'Member',
`opentag` = '<FONT SIZE=\"2\">',
`closetag` = '</FONT>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '717055',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '51',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions` = '136847298',
`genericoptions` = '6',
`profilepicmaxwidth` = '300',
`profilepicmaxheight` = '500',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '125',
`avatarmaxheight` = '300',
`avatarmaxsize` = '20000',
`vbaffiliatespermissions` = '0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'vbaffiliatespermissions' in 'field list'
Error Number : 1054

[Guest190829]

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

Uninstall the product.
Try reinstalling again then

Try the above.

[Suzie]

I don't want to reinstall. I no longer wish to use this product. I will check back in the morning. I need sleep, I have spent too much of this day trying to fix this. I still get the same error editing the user groups after performing your suggestion.

[Guest190829]

Well then you have to remove all the uploaded files, and then empty out the uninstall box and click uninstall...

[Suzie]

As I said last night, I did that already. I still get this error.

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE vb_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = 'Member',
`opentag` = '<FONT SIZE=\"2\">',
`closetag` = '</FONT>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '717055',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '51',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions` = '136847298',
`genericoptions` = '6',
`profilepicmaxwidth` = '300',
`profilepicmaxheight` = '500',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '125',
`avatarmaxheight` = '300',
`avatarmaxsize` = '20000',
`vbaffiliatespermissions` = '0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'vbaffiliatespermissions' in 'field list'

[Impreza04]

If you are uninstalling you need to delete the files the MOD added, and then rebuild the bitfields..

[Suzie]

I had to reload forum files rebuild the database and go in and manually delete the field in my phpmyadmin. I think I am back to normal now. Whew.http://webpages.charter.net/connectingzone/shock/10.gif Thanks for the help.

[Guest190829]

I have been very busy recently and I haven't been able to work on BETA 2. Once I have some time I will release it.

[bi11i]

Loving it, loving it... nice. :)

This could be totally unrelated, but I don't see it anywhere else on my board. Why does my error message (when insufficient privileges) state:
$bbuserinfo[username], you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account. Use the contact form (http://forum.opiophile.org/$vboptions[bburl]/sendmessage.php) to find out why.
You have neglected to activate your account. Need the email sent again? Click (http://forum.opiophile.org/$vboptions[bburl]/register.php?do=requestemail) Does anyone know why this variable doesn't display correctly? I'm running v3.5 and everything else appears to work just fine...

[bi11i]

As I said last night, I did that already. I still get this error.

I've also got this same error. This is after a complete uninstall. I've not been able to get any version of this mod to work correctly - any future updates on the horizon?

[bi11i]

I need to know how to manually remove this field from my forum's mySQL using phpmyadmin. I can search for this and am able to find it, but there's far too many variables inside for me to simply delete something.

UPDATE: Copying the tools.php file from the original installation do_not_upload folder into your admincp and executing will allow you to select the option to rebuild the bitfield cache. No other editing is necessary.

I'm a big fan of this mod, but this is the 3rd time I've tried to install it, each time having disasterous results. While a really cool idea, I've never been able to get it to work. I don't recommend (sorry.)

[Guest190829]

I need to know how to manually remove this field from my forum's mySQL using phpmyadmin. I can search for this and am able to find it, but there's far too many variables inside for me to simply delete something.

UPDATE: Copying the tools.php file from the original installation do_not_upload folder into your admincp and executing will allow you to select the option to rebuild the bitfield cache. No other editing is necessary.

I'm a big fan of this mod, but this is the 3rd time I've tried to install it, each time having disasterous results. While a really cool idea, I've never been able to get it to work. I don't recommend (sorry.)

It's BETA for a reason....

[bi11i]

It's BETA for a reason....

If it's Beta at 1.0.7, what was it at 1.0.2?

Beta or not, I've never had to use the vBulletin tools to recover my database on a mod.

I'm simply posting my feedback of it; I would've appreciated the same had I seen it before this install.

[Guest190829]

It's will remain beta, untill the "BETA" doesn't appear before every version number...

[ReadOrDie]

Now when people apply to my affiliates it's not appearing. I did it through the admin CP and nothing is awaiting my approval. Can you somehow make it so this hack adds the affiliate immediately instead of having to wait more than two days?

[Guest190829]

The hack doesn't wait one or two days, it get's inserted instantly. You're database is strange...

[ReadOrDie]

I don't recommend (sorry.)

I agree, I could REALLY REALLY use a hack like this but installing it was a huge hassle. And now it's installed but my affiliates aren't appearing. It's a shame because I was gaining alot of members with the affiliates hack. Now I'm going to have to cancel all my affiliates. Please kirbyde do something. :(

[Guest190829]

I agree, I could REALLY REALLY use a hack like this but installing it was a huge hassle. And now it's installed but my affiliates aren't appearing. It's a shame because I was gaining alot of members with the affiliates hack. Now I'm going to have to cancel all my affiliates. Please kirbyde do something. :(

I don't get why people don't understand about this hack being a BETA. Beta are to be installed for debugging purposes only, not live productions sites. Anyone who installs this hack on a live board without knowledge of php should not being posting how this hack is "not reccomended."

ReadOrDie, I've held my patience with you for a long time. And I'm at the breaking point. You've done nothing here but whine and moan about this hack. If your so dissapointed at the bugs of the hack, you can go and learn PHP and fix them.

I have other more important things to do then work on this hack. And going to this thread and seeing ungrateful and disrespectful posts doesn't give me the enthusiam to work on this, and maybe some of the other hacks I plan to release here for free.

For those who still can not grasp the termonogly of releases here you go:


In software engineering, development stage terminology expresses how the development of a piece of software has progressed and how much further development it may require. Each major version of a product usually goes through a stage when new features are added (alpha stage), then a stage when it is actively debugged (beta stage), and finally a stage when all important bugs have been removed (stable stage). Intermediate stages may also be recognized. ...


Right now this hack is in BETA, also known as the "stage when it is actively debugged."

Thanks,
Danny

[divided_by_fear]

i dont have this code in my style at all

<td class="vbmenu_control"><a href="$vboptions[bburl]/memberlist.php?$session[sessionurl]">$vbphrase[members_list]</a></td>

where do you think i should add this code? im running disturbed style by eXtremepixels ... any help would be great...thanks

[davidw]

Danny, being a coder myself (although recently new to vbulletin) I can understand a level of frustration. However, being in beta, which has been made apparently clear, hopefully to everyone reading, please take a level of criticism with it. You cannot simply put out a beta and expect people NOT to whine about it. I had complaints, yes, agreed, however, I have resolved most of mine aside from the ones I posted prior to this posting. I can live with these and when I have appropriate time, I may delve into the code to find what conflicts may be as at the moment I have no time to do so. I'm still taking in the differences between this software (vbulletin) and what I'm used to. I also have web designing to do, work at my job, and a newborn baby to help take care of. This adds to my client-side frustration as I feel others may have as well in different circumstances.

Having said that, as a coder yourself and with a project in BETA stage, calling someone's database "strange" because you haven't been able to duplicate their issues doesn't mean their issues do not exist. I, myself, experienced a similar situation which was corrected with uninstalling the hack and reinstalling it. If you have a problem with one of the members, please notify a moderator. Otherwise, accept the issues that clients run into as an issue that needs to be addressed rather than dismissed.

You are NOT going to have all the answers, nor the time to answer everything, which is understandable, but please, have patience with people. I'm sure this hack and others you will do will be great ones, but it takes time and patience dealing with clients on their issues. You are in a position of professionalism and your responses need to reflect your position.

[Guest190829]

Danny, being a coder myself (although recently new to vbulletin) I can understand a level of frustration. However, being in beta, which has been made apparently clear, hopefully to everyone reading, please take a level of criticism with it. You cannot simply put out a beta and expect people NOT to whine about it. I had complaints, yes, agreed, however, I have resolved most of mine aside from the ones I posted prior to this posting. I can live with these and when I have appropriate time, I may delve into the code to find what conflicts may be as at the moment I have no time to do so. I'm still taking in the differences between this software (vbulletin) and what I'm used to. I also have web designing to do, work at my job, and a newborn baby to help take care of. This adds to my client-side frustration as I feel others may have as well in different circumstances.

Having said that, as a coder yourself and with a project in BETA stage, calling someone's database "strange" because you haven't been able to duplicate their issues doesn't mean their issues do not exist. I, myself, experienced a similar situation which was corrected with uninstalling the hack and reinstalling it. If you have a problem with one of the members, please notify a moderator. Otherwise, accept the issues that clients run into as an issue that needs to be addressed rather than dismissed.

You are NOT going to have all the answers, nor the time to answer everything, which is understandable, but please, have patience with people. I'm sure this hack and others you will do will be great ones, but it takes time and patience dealing with clients on their issues. You are in a position of professionalism and your responses need to reflect your position.

Hey christianb,

Although I agree with you entirely on your arguements, you do use the term clients. Clients, through my eyes, are people paying me to code for them. When I am dealing with clients, I have absolute patients with them. In this situation, however, I am not dealing with clients.

If you have a problem with one of the members, please notify a moderator. Otherwise, accept the issues that clients run into as an issue that needs to be addressed rather than dismissed.

I may have gotten a little upset with a member, but contacting a moderator for it is really not neccesary. Also, I am not required to accept anything. This is a free script provided to the members of vbulletin.org. I know this seems a bit extreme, but it is true. In this case, I tried to aquire more information so I could see what may be wrong. I didn't recieve any significant information, only impatience.

Yes, the coders have to be patient, but so do the people installing the hacks. Specifically when the hack is in BETA. I look back on my previous post, and I don't feel like anything I said didn't need to be said. I am giving my free time to add additional features to vbulletin. I appreciate the insightful posts with bug fixes and constructive critisizm. I do not like member's judging how I code, when they can't even understand php.

Again, there has to be an equllibrium of patience between both parties. The coder and the members installing the hack should all be patient. Everyone would be happier. :)

where do you think i should add this code? im running disturbed style by eXtremepixels ... any help would be great...thanks

Hey,

Try finding this, it should be in the navbar template.

<td class="vbmenu_control"><a href="$vboptions[bburl]/calendar.php$session[sessionurl_q]">$vbphrase[calendar]</a></td>

[divided_by_fear]

this is my whole navbar template code its not in there... sorry if im bugging you im still new to all this.... but i have installed alot of other mods i just didnt see that code... do you think i could add it in somewhere?

<script type="text/javascript">
<!--
function log_out()
{
ht = document.getElementsByTagName("html");
ht[0].style.filter = "progid:DXImageTransform.Microsoft.BasicImage(grays cale=1)";
if (confirm('$vbphrase[sure_you_want_to_log_out]'))
{
return true;
}
else
{
ht[0].style.filter = "";
return false;
}
}
//-->
</script>

<br />

<!-- breadcrumb, login, pm info -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%">
<if condition="is_array($navbits)">
<table cellpadding="0" cellspacing="0" border="0">
<tr valign="bottom">
<td><a href="#" onclick="history.back(1); return false;"><img src="$stylevar[imgdir_misc]/navbits_start.gif" alt="$vbphrase[go_back]" border="0" /></a></td>
<td>&nbsp;</td>
<td width="100%"><span class="navbar"><a href="$vboptions[forumhome].php$session[sessionurl_q]" accesskey="1">$vboptions[bbtitle]</a></span> $navbits[breadcrumb]</td>
</tr>
<tr>
<td class="navbar" style="font-size:10pt; padding-top:1px" colspan="3"><a href="$scriptpath"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_finallink.gif" alt="$vbphrase[reload_this_page]" border="0" /></a> <strong>$navbits[lastelement]</strong></td>
</tr>
</table>
<else />
<div class="navbar" style="font-size:10pt"><a href="$vboptions[forumhome].php$session[sessionurl_q]" accesskey="1"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_start.gif" alt="" border="0" /></a> <strong>$vboptions[bbtitle]</strong></div>
</if>
</td>

<if condition="$bbuserinfo['userid']">

<td class="alt2" valign="top" nowrap="nowrap">
<div class="smallfont">
<strong><phrase 1="$bbuserinfo[username]">$vbphrase[welcome_x]</phrase></strong><br />
<if condition="$pcount != ''">$pcount<br /></if>
<phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]">$vbphrase[last_visited_x_at_y]</phrase>
<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl_q]">$vbphrase[private_messages_nav]</phrase></if>
<br /><if condition="$rcount != ''">$rcount<br /></if>
</div>
</td>

<else />

<td class="alt2" nowrap="nowrap" style="padding:0px">

<!-- login form -->
<form action="login.php" method="post" onsubmit="md5hash(vb_login_password, vb_login_md5password, vb_login_md5password_utf, $show[nopasswordempty])">
<script type="text/javascript" src="clientscript/vbulletin_md5.js"></script>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td class="smallfont">$vbphrase[username]</td>
<td><input type="text" class="bginput" style="font-size: 11px" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="101" value="$vbphrase[username]" onfocus="if (this.value == '$vbphrase[username]') this.value = '';" /></td>
<td class="smallfont" colspan="2" nowrap="nowrap"><label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" tabindex="103" id="cb_cookieuser_navbar" accesskey="c" />$vbphrase[remember_me]</label></td>
</tr>
<tr>
<td class="smallfont">$vbphrase[password]</td>
<td><input type="password" class="bginput" style="font-size: 11px" name="vb_login_password" size="10" accesskey="p" tabindex="102" /></td>
<td><input type="submit" class="button" value="$vbphrase[log_in]" tabindex="104" title="$vbphrase[enter_username_to_login_or_register]" accesskey="s" /></td>
</tr>
</table>
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="login" />
<input type="hidden" name="vb_login_md5password" />
<input type="hidden" name="vb_login_md5password_utf" />
</form>
<!-- / login form -->

</td>

</if>

</tr>
</table>
<!-- / breadcrumb, login, pm info -->

<div class="spacer"></div>

<if condition="$show['forumdesc']">
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="alt1" width="100%"><strong>$foruminfo[title]</strong> <span class="smallfont">$foruminfo[description]</span></td>
</tr>
</table>
<br />
</if>

<if condition="$show['popups']">
<!-- NAVBAR POPUP MENUS -->

<if condition="$show['searchbuttons']">
<!-- header quick search form -->
<div class="vbmenu_popup" id="navbar_search_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">$vbphrase[search_forums]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="search.php" method="post">
<input type="hidden" name="do" value="process" />
<input type="hidden" name="showposts" value="0" />
<input type="hidden" name="quicksearch" value="1" />
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="text" class="bginput" name="query" size="20" />$gobutton<br />
</form>
</td>
</tr>
<tr>
<td class="vbmenu_option"><a href="search.php$session[sessionurl_q]" accesskey="4" rel="nofollow">$vbphrase[advanced_search]:</a></td>
</tr>
<tr>
<td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=getnew" accesskey="2">$vbphrase[new_posts_nav]:</a></td>
</tr>
<tr>
<td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=getdaily" accesskey="2">$vbphrase[todays_posts]:</a></td>
</tr>
</table>
</div>
<!-- / header quick search form -->
</if>

<if condition="$show['member']">
<!-- user cp tools menu -->
<div class="vbmenu_popup" id="usercptools_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">

<tr><td class="thead">$vbphrase[quick_links]</td></tr>
<if condition="$vboptions['enablesearches']"><tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=getdaily">$vbphrase[todays_posts]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="forumdisplay.php?$session[sessionurl]do=markread">$vbphrase[mark_forums_read]</a></td></tr>
<tr><td class="vbmenu_option"><a href="#" onclick="window.open('misc.php?$session[sessionurl]do=buddylist&amp;focus=1','buddylist','statusbar=no,me nubar=no,toolbar=no,scrollbars=yes,resizable=yes,w idth=250,height=300'); return false;">$vbphrase[open_buddy_list]</a></td></tr>

<tr><td class="thead"><a href="usercp.php$session[sessionurl_q]">$vbphrase[user_control_panel]</a></td></tr>
<if condition="$show['siglink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editsignature">$vbphrase[edit_signature]</a></td></tr></if>
<!--<if condition="$show['avatarlink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editavatar">$vbphrase[edit_avatar]</a></td></tr></if>-->
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td></tr>
<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editoptions">$vbphrase[edit_options]</a></td></tr>

<tr><td class="thead">$vbphrase[miscellaneous]</td></tr>
<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php$session[sessionurl_q]">$vbphrase[private_messages]</a></td></tr></if>
<tr><td class="vbmenu_option"><a href="topposters.php?$session[sessionurl]">Display Top Posters</a></td></tr>
<tr><td class="vbmenu_option"><a href="subscription.php$session[sessionurl_q]">$vbphrase[subscribed_threads]</a></td></tr>
<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>
<if condition="$show['wollink']"><tr><td class="vbmenu_option"><a href="online.php$session[sessionurl_q]">$vbphrase[whos_online]</a></td></tr></if>

</table>
</div>
<!-- / user cp tools menu -->
</if>
<!-- / NAVBAR POPUP MENUS -->

<!-- PAGENAV POPUP -->

<div class="vbmenu_popup" id="pagenav_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead" nowrap="nowrap">$vbphrase[go_to_page]</td>
</tr>
<tr>
<td class="vbmenu_option" title="nohilite">
<form action="$vboptions[forumhome].php" method="get" onsubmit="return this.gotopage()" id="pagenav_form">
<input type="text" class="bginput" id="pagenav_itxt" style="font-size:11px" size="4" />
<input type="button" class="button" id="pagenav_ibtn" value="$vbphrase[go]" />
</form>
</td>
</tr>
</table>
</div>

<!-- / PAGENAV POPUP -->
</if>

[Guest190829]

<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>

Above or below that would work. :)

[divided_by_fear]

thank you very much and thanks for the fast reply trying it right now

[davidw]

I understand what you refer to as clients. I have two types of clients - nonpaying and paying.

When I've dealt with beta projects myself in the past, inclusive of even my own, we've used a select amount of people to beta test the scripts (either by a beta test email list or by chosen who apply to beta test).

I'm still getting used to vbulletin's forums. I've never had a community where the beta and all was freely available to anyone. Of course, when I think about it, this is the first software (vbulletin) that I've had to pay for :D

I moved to vbulletin because I got tired of dealing with other software that was bug-filled and riddled with holes and security flaws. I spent hundreds of hours working on fixing problems in my spare time. I can also achieve my goals with vbulletin much faster 1/20th the time because this "just works." whereas before it was hit-and-miss 100% of the time.

On the moderator situatino, I've been part of many forums (under various usernames) that in a situation like what I referred to, one would contact a moderator, and the moderator would contact the offending party - act as an arbitrator in matters. Of course, I've seen some pretty childish things as well. :P

[divided_by_fear]

i have it working now thanks again... just one question though i have this at the bottom of the page,

Page generated in 0.05022 seconds with 19 queries (4 queries for uncached templates)
Uncached templates: affiliate_list (1)
Uncached templates: affiliate_module_mosthitsin (1)
Uncached templates: affiliate_module_mosthitsout (1)
Uncached templates: affiliate_module_mostvotes (1)

is there anyway to make these cached?

[Guest190829]

i have it working now thanks again... just one question though i have this at the bottom of the page,

Page generated in 0.05022 seconds with 19 queries (4 queries for uncached templates)
Uncached templates: affiliate_list (1)
Uncached templates: affiliate_module_mosthitsin (1)
Uncached templates: affiliate_module_mosthitsout (1)
Uncached templates: affiliate_module_mostvotes (1)

is there anyway to make these cached?

Yes that fix will be in BETA 2.

[divided_by_fear]

not to be a bother how long do you think that will be out? i love this mod its tight... just hoping it will be cached soon :nervous:

also when someone goes to submit a site this error is at the top do you know how this could be fixed?

Parse error: parse error, unexpected T_STRING in /home/*********/public_html/affiliate.php(117) : eval()'d code on line 1

[Guest190829]

This should be release by this wednsday. :)

[divided_by_fear]

sweet i cant wait lol... also one thing i had a problem on is the email part too... when i added it manualy it didnt send the code or when we tried to submit it... both ways didnt send the email... i own the server so i was looking to see why it didnt... and it was going to my bulk mail on the default email set up on vb basiclly emailing the admins email... not to the person email itself... is there a way that it could be set up different or what else could i do to have it email them? or maybe even just show the code after they submit it... with like a lil note saying please add are link then once we see it up we will affilate back... or something along them lines...

[Guest190829]

sweet i cant wait lol... also one thing i had a problem on is the email part too... when i added it manualy it didnt send the code or when we tried to submit it... both ways didnt send the email... i own the server so i was looking to see why it didnt... and it was going to my bulk mail on the default email set up on vb basiclly emailing the admins email... not to the person email itself... is there a way that it could be set up different or what else could i do to have it email them? or maybe even just show the code after they submit it... with like a lil note saying please add are link then once we see it up we will affilate back... or something along them lines...

Yeah the email error is a known bug it will be fixed in BETA 2. Would you prefer it to still mail or pm?

[divided_by_fear]

bro to be honest i cant make that choice... you made the mod so i guess you can make the final call... not trying to sound harsh or nothing, but im just thankful to have such a mod... um if the mail could be fixed then that would be great maybe have it mail there email the way it would if you chose to have it email them to activate there accounts... or even a pm would be good.. but the final call is up to you i feel which ever is easier for you since your doing this for free for us... people just need to be thankful your will to fix these such things...

edit: or what do you think about doing away with the whole mail thing and having it show your link and button this way it dont have to mail it dont have to pm it would just show it right there on that page below it ;) ... kinda like phpnuke does... maybe have a block under it when they submit telling them to link us then we will link you back... just giving ideas on such a great mod

[mfizzel]

I CAN'T wait for the final of this, I need it badly :D

[Guest190829]

I CAN'T wait for the final of this, I need it badly :D

Please note that the next release will be BETA 2, not the GOLD release of the hack.

[mfizzel]

how is the beta going so far? would you recommend to only install it for testing purposes?

[Guest190829]

how is the beta going so far? would you recommend to only install it for testing purposes?

Yes, it's important that you only install for testing purposes. The more people testing the quicker a GOLD version is released. :)

[kall]

Yes, it's important that you only install for testing purposes. The more people testing the quicker a GOLD version is released. :)

I am getting multiple errors in my cPanel log:

[Mon Oct 31 23:08:51 2005] [error] PHP Fatal error: Call to a member function on a non-object in */includes/cron/affiliate_emptyrec.php on line 10
[Mon Oct 31 22:59:43 2005] [error] PHP Fatal error: Call to a member function on a non-object in */includes/cron/affiliate_emptyrec.php on line 10
[Mon Oct 31 22:55:10 2005] [error] PHP Fatal error: Call to a member function on a non-object in */includes/cron/affiliate_emptyrec.php on line 10
[Mon Oct 31 22:52:48 2005] [error] PHP Fatal error: Call to a member function on a non-object in */includes/cron/affiliate_emptyrec.php on line 10
[Mon Oct 31 22:51:02 2005] [error] PHP Fatal error: Call to a member function on a non-object in *includes/cron/affiliate_emptyrec.php on line 10
[Mon Oct 31 22:50:03 2005] [error] PHP Fatal error: Call to a member function on a non-object in *includes/cron/affiliate_emptyrec.php on line 10
[Mon Oct 31 22:49:35 2005] [error] PHP Fatal error: Call to a member function on a non-object in *includes/cron/affiliate_emptyrec.php on line 10
[Mon Oct 31 22:48:03 2005] [error] PHP Fatal error: Call to a member function on a non-object in *includes/cron/affiliate_emptyrec.php on line 10

[Guest190829]

Okay thanks for reporting. From the looks of the errors, I probably left a $DB_site somewhere in that file...

[Lyricsmama]

Hi.
First of all, thank you very much for your hard work and for giving us this hack :)

I installed and so far all but one thing is working great:
for some reason in the admin page I cannot see more than the first page when using the 'manage affiliates' option. Consequently I could not aprove more entries than those shown in the first page. When clicking on the 'next' link it showed me the same entries.

I am sure there is something I did wrong?

For the moment I just edited the affiliatesadmin.php file and increased the value of $perpage but that is certainly not the correct solution.

Any help will be greatly appreciated. :)

[mindfrost82]

Hi.
First of all, thank you very much for your hard work and for giving us this hack :)

I installed and so far all but one thing is working great:
for some reason in the admin page I cannot see more than the first page when using the 'manage affiliates' option. Consequently I could not aprove more entries than those shown in the first page. When clicking on the 'next' link it showed me the same entries.

I am sure there is something I did wrong?

For the moment I just edited the affiliatesadmin.php file and increased the value of $perpage but that is certainly not the correct solution.

Any help will be greatly appreciated. :)

I had the same problem, but your work-around is working good.

Any info on an official fix?

[Guest190829]

Hi.
First of all, thank you very much for your hard work and for giving us this hack :)

I installed and so far all but one thing is working great:
for some reason in the admin page I cannot see more than the first page when using the 'manage affiliates' option. Consequently I could not aprove more entries than those shown in the first page. When clicking on the 'next' link it showed me the same entries.

I am sure there is something I did wrong?

For the moment I just edited the affiliatesadmin.php file and increased the value of $perpage but that is certainly not the correct solution.

Any help will be greatly appreciated. :)

Thank you for reporting this. :)

[Guest190829]

Just an update: All bugs will be fixed and I will test out everything privately for about 2-3 days. Once I am satisfied with the product I will release BETA 1.0.8. Then if there are no bug reports it will be changed as BETA 2.

I have a few coding stuff I have to do for a client that I must finish before though...

[Lyricsmama]

Just an update: All bugs will be fixed and I will test out everything privately for about 2-3 days. Once I am satisfied with the product I will release BETA 1.0.8. Then if there are no bug reports it will be changed as BETA 2.

I have a few coding stuff I have to do for a client that I must finish before though...
Thank you VERY much for all that work :)

[mfizzel]

can't wait :)

With the next release I'll install it on my forum, it's quite active so I should be able to help with bug reporting.

[Paul-WA]

First of all I'd just like to say this is a great mod and works fine apart from one thing; it says I don't have permission to view the page. It's the common message that reads:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Is there a way for me to change the permissions for the affiliates section? Or is this message showing due to a different error? Anyone know? Before anyone says, yes I am the administrator.

[RaidenDAWG2]

Usergroup manager -> edit the permissions for every group ;)

[DS MrSinister]

after upgrading from 3.5.0 to 3.5.1 i dont see the usergroup permissions.

any ideas how to fix this?

[Guest190829]

after upgrading from 3.5.0 to 3.5.1 i dont see the usergroup permissions.

any ideas how to fix this?

This hack hasn't been tested on 3.5.1. The next release will work on 3.5.1.

[DS MrSinister]

k thx. i will wait for the fix. no rush

[Paul-WA]

This hack hasn't been tested on 3.5.1. The next release will work on 3.5.1.

Ah I see, thats why I cannot view the permissions because I have 3.5.1 too. Thanks anyway RaidenDAWG2. Ah well, guess I'll have to wait :ermm:

[ManagerJosh]

This hack hasn't been tested on 3.5.1. The next release will work on 3.5.1.

Any E.T.A?

[Guest190829]

Any E.T.A?

As soon as possible. I will be working on this today, and more this week. :)

[SuperFly]

How would i remove the affilate block from the admin cp?

[Guest190829]

Remove the xml file in includes/xml

[MThornback]

I'm missing 1-2 phrases...when I forget to add a title to an entry or its too short, I get a blank popup window....any idea what/where the missing phrase is, so I can add it manually? :)

[loonytune15]

Hope you update this soon. I've installed but without be able to access permissions its pretty useless currently.

[davidw]

Have you gone into your usergroup settings and given yourself permissions?

[Guest190829]

Have you gone into your usergroup settings and given yourself permissions?

No, they mean that it's not showing at all in the usergroup manager. There is something wrong with the xml file. I fixed that, but now for some reason the settings in the admincp aren't editing. I have to fix that.

[Guest190829]

Okay I got the settings bug fixed. Now I am trying to get the mail function to work. :)

[davidw]

Good work Danny :) - I'm waiting it out for a little bit due to other site issues :)

[loonytune15]

any chance of updating the zip with the fix for the settings please?

[Guest190829]

The fix was a settings was an error on my part when editing one of the files..it shouldn't be a bug with earlier versions..

[loonytune15]

Well i'm in my usergroups right now, and i cant see anywhere to allow users to see the affiliates page. Thats includes admin.

I'm vb3.5.1 if that makes any difference.

[Electronic Punk]

I also just installed it and can't see the setting. Like what I can see so far though and am looking forward to playing ;)

[trackpads]

Yeah the email error is a known bug it will be fixed in BETA 2. Would you prefer it to still mail or pm?

The more things are based on PMs the better :) Thanks!

[trackpads]

The more things are based on PMs the better :) Thanks!

Has anyone had a chance to work on a new CMPS module yet?

http://www.vbadvanced.com/forum/showthread.php?t=1442

[Lena Starling]

Lena Starling, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Log Out Home

I don't see any place where I can edit permissions... A little advice, please?

Gracias!
Lena

[ReadOrDie]

How would I change the msn logo on the left corner? Because I made a logo same size and renamed it MSN logo however it won't appear when I replace the MSNlogo you have any idea how I can fix this?

[Guest190829]

Lena Starling, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Log Out Home



I don't see any place where I can edit permissions... A little advice, please?

Gracias!
Lena

The current version of the hack is not compatible with 3.5.1. I'm guessing your using that version..

[Sinistra]

Nope She is using 3.5.0 I have fixed the issue for her XD permission issue >> ^_^

[TF|Scorpion]

So when will the fixed final version be released? It would be much appriciated if it is fixed soon.

[Guest190829]

I am very busy recently with personal things. I have been trying to code on the side, but It's gotten to the point where I don't have time for it. It will be released soon, I just got a few things I have to fix and one or two additional feature I will like to incorporate.

[trackpads]

I am very busy recently with personal things. I have been trying to code on the side, but It's gotten to the point where I don't have time for it. It will be released soon, I just got a few things I have to fix and one or two additional feature I will like to incorporate.

Much appreciated Danny!!!

[loonytune15]

I am uninstalling this. I have founf the top list hack anfd i think it will do the job nicely. Sorry.

[Blackbeard]

Await for version to work with 3.5.1, i'll keep watching this space, Thanks

[kafi]

Await for version to work with 3.5.1, i'll keep watching this space, Thanks

Does this have a use for link exchange?

thank you

[ManagerJosh]

*hums cheerfully...still waiting Danny :D*

[Guest190829]

It will come, I'm recovering from a few days of being sick..:)

[Stephen3]

this can add from admin panel right?
i'm finding this ... :D
hope 3.5. soon

[Sinistra]

Havning an issue with group permissions. They are not showing up How can I fix this issue