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)

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 08:06 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.01344 seconds
  • Memory Usage 1,750KB
  • 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
  • (3)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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