vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   vB Affiliates for 3.5 (https://vborg.vbsupport.ru/showthread.php?t=96485)

09-17-2005 10:00 PM

vB Affiliates for 3.5
 
Author: An-net
Ported by: Danny.vbt

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

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

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

And more!

Install Overview:

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

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


Please Note:

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

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


Updates:
BETA 1.0.7
Uploaded new affiliate.php by HawkBizKit, fixes ON clause error
BETA 1.0.6
Uploaded new affiliate.php by Dark_Wizard
BETA 1.0.5
Fixes Installation/Uninstallation issues and table prefix error
BETA 1.0.4
Added missing phrases, fixed permissions issue.
BETA 1.0.3
Fixed errors on xml product, also added auto rebuild bitfields.
BETA 1.0.2
Fixed parse error on affiliate.php

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

Daniel 09-18-2005 05:39 AM

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

Guest190829 09-18-2005 05:41 AM

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 09-18-2005 07:07 AM

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

erratic assasin 09-18-2005 07:38 AM

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 09-18-2005 11:05 AM

Live demo please?

FleaBag 09-18-2005 02:22 PM

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

Guest190829 09-18-2005 02:52 PM

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

Impreza04 09-18-2005 08:24 PM

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

PHP Code:

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 09-18-2005 11:36 PM

Quote:

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

PHP Code:

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 09-19-2005 01:29 PM

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

Impreza04 09-19-2005 01:38 PM

I get this error when Importing the product.

PHP Code:

Parse errorparse errorunexpected '<' in /home/imp04/public_html/forum/admincp/plugin.php(1192) : eval()'d code on line 1 

Sorry to be a pain..

erratic assasin 09-19-2005 06:21 PM

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 09-19-2005 06:33 PM

Quote:

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

Quote:

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 09-19-2005 07:04 PM

Quote:

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

wow someone is ungrateful...

Glovebox 09-19-2005 07:24 PM

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 09-19-2005 07:39 PM

read below!

erratic assasin 09-19-2005 07:49 PM

Quote:

Originally Posted by BrentWilson
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!

Quote:

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 09-19-2005 07:59 PM

Quote:

Originally Posted by AN-net
wow someone is ungrateful...

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

AN-net 09-19-2005 08:06 PM

Quote:

Originally Posted by erratic assasin
Question "DID YOU INSTALL IT????" Hmm I wonder why??? :speechless:

actually i initially created this hack

erratic assasin 09-19-2005 08:49 PM

Quote:

Originally Posted by AN-net
actually i initially created this hack

Yep and heres another members quote""

Quote:

Originally Posted by loonytune15
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 09-19-2005 09:06 PM

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 09-19-2005 09:15 PM

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 09-19-2005 09:24 PM

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 09-19-2005 09:24 PM

Quote:

Originally Posted by erratic assasin
Yep and heres another members quote""



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

someone is in a grouchy mood>_>

Guest190829 09-19-2005 09:43 PM

Quote:

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

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

Glovebox 09-19-2005 10:18 PM

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 09-19-2005 10:21 PM

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

Guest190829 09-19-2005 10:32 PM

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

Glovebox 09-19-2005 10:38 PM

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

Guest190829 09-19-2005 10:42 PM

Quote:

Originally Posted by Glovebox
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 09-19-2005 11:13 PM

Okay, another update.

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

erratic assasin 09-20-2005 03:56 AM

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

Brinnie 09-20-2005 04:18 AM

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

Impreza04 09-20-2005 02:24 PM

Ok.. now im gonna be a real pain:

Affiliateadmin.php
PHP Code:

Parse errorparse errorunexpected ',' in /home/imp04/public_html/forum/admincp/affiliateadmin.php on line 193 

affiliate.php
PHP Code:

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
PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
DROP TABLE affiliates;

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


Glovebox 09-20-2005 03:28 PM

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 09-20-2005 09:35 PM

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 09-21-2005 02:56 AM

go into the AFFILIATE template and remove Code:

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

Code:

        print_stop_message('approved_affiliate_x_successfully', $sitename);
Thanks Danny...awesome work..

Omega Prime 09-21-2005 03:06 AM

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:

Code:

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 09-21-2005 03:57 AM

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...


All times are GMT. The time now is 03:18 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02601 seconds
  • Memory Usage 1,869KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (6)bbcode_php_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete