vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB Affiliates v.2 (https://vborg.vbsupport.ru/showthread.php?t=63044)

LEAD_WEIGHT 04-26-2005 04:53 AM

Do u know if the text files "installation_instruct" are vb forum edits & "upgrade_instruct" are for CMPS modules. Thx if u could help

venomx 04-26-2005 05:01 AM

I am guesing the upgrade file is for if you ran a old version of this hack...

LEAD_WEIGHT 04-26-2005 05:18 AM

Quote:

Originally Posted by venomx
I am guesing the upgrade file is for if you ran a old version of this hack...

Did u install this hack and what board version are u running.

Yah, u are right. It does say overwrite for php. files Thx venomx

The old one was vB Affiliates is that what u are referring to?

U know I was checking how did anyone install this hack for vb3.0.7 if the narbar edits to find that code do not exist, so how do u add a code that not there? It is not in default code, so how.

just wondering how u got the right Navbar code for vb3.0.7 cause the one it shows is for vb3.0.0

I just linked to http://www.mydomain.com/forums/affiliate.php

~~~~~~~~~~~~~~~~~~~~~~~~~~
Begin Template Edits
~~~~~~~~~~~~~~~~~~~~~~~~~~
-----------------------------------
Open template titled: navbar is vb3.0.0
-----------------------------------
Find:
<td class="vbmenu_control"><a href="$vboptions[bburl]/memberlist.php?$session[sessionurl]">$vbphrase[members_list]</a></td>
-----------------------------------
After Add:
<td class="vbmenu_control"><a href="$vboptions[bburl]/affiliate.php">Affiliates</a></td>



~~~~~~~~~~~~~~~~~~~~~~~~~~
Begin Template Edits
~~~~~~~~~~~~~~~~~~~~~~~~~~
-----------------------------------
Open template titled: navbar is vb3.0.7


navbar vb3.0.7 is the only code that looks to match
------------------------------------
<td class="vbmenu_control"><a href="memberlist.php?$session[sessionurl]">$vbphrase[members_list]</a></td>

so all u do is change it like this.

<td class="vbmenu_control"><a href="http://www.mydomain.com/forums/affiliate.php">Affiliates</a></td>

Credits to venomx for the help

LEAD_WEIGHT 04-26-2005 07:59 AM

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

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL au

Is this one query or many cause I copy & paste & get that 1064 error so how do I do this.


Code:

Run this query:
DROP TABLE IF EXISTS affiliates;
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)
);

Got it this is one query
Code:

DROP TABLE IF EXISTS affiliates;
and this is the next query [ after each ( ; ) is a query ]
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)
);

credits for help MarcoH64 at vb.com & I guess same guy here :ermm:




One more thing is I am surprise u do not have a paypal donate thing cause of the time u spent on this. :nervous:

LEAD_WEIGHT 04-26-2005 05:00 PM

How do I enable it or what is the amdin link? I get this when i click on it
Code:

Sorry but the Affiliates section of this site has been disabled.
I do not see it in c/panel or is it I have to do something that I have not figure out yet. I been up to long. :tired:

venomx 04-26-2005 05:10 PM

Look in your VB admincp

LEAD_WEIGHT 04-26-2005 09:56 PM

Quote:

Originally Posted by venomx
Look in your VB admincp

Oh, that where it is hiding or is it that I really do not see it, I need glasses or is it hiding within one the list. Man why is these things getting harder to do.

Quote:

Originally Posted by AN-net
you go to your administration control panel and click general settings, under that there is a setting that says # of affiliates per page next to it is a drop down menu of #'s you must choose one and also set up your other settings then click update for it take affect.

I do not see that. I wondering those upgrades are for the first version of vB Affiliates v.2 right. I still can not see that like it shows in those thumbs.

venomx 04-26-2005 10:10 PM

If you made the edits to the /admincp file(s) then you should have Affiliates Listed on the right...

LEAD_WEIGHT 04-26-2005 10:22 PM

Quote:

Originally Posted by venomx
If you made the edits to the /admincp file(s) then you should have Affiliates Listed on the right...

The left u mean right under Vb options or did I just screw this up. Oh u mean the page appears right of the Admin list controls :tired:

How sad I am I did not even refresh my Admin. C/panel page to see the changes. I really need some sleep but before I do I think I go to look at that Graffito thing it looks real promising :tired:

Woot! Woot! got it working Thanks again venomx

FightRice.com 04-28-2005 02:35 AM

Will this work with 3.07


All times are GMT. The time now is 10:48 PM.

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.01394 seconds
  • Memory Usage 1,751KB
  • 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
  • (4)bbcode_code_printable
  • (4)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