vb.org Archive - vB Affiliates v.2

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)

ok just got around to upgrading install went flawless so i thought. added a affilate it shows up in admin pannel but does nto show up on site. Yes I did activate it any ideas

I failed to install this :(
the sql queries failed..
I run:
vBulletin 3.0.1
uCash & uShop
vBadvanced

can you give me the error mysql gave u?

nvm, i tried the queries again in phpmyadmin and everything worked fine.. :)
thank you for this wonderful hack
[high]* Lurk clicks install[/high]

When I run this MySQL query:

PHP Code:


		
			
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_x_successfully', '<i>{1}\'s</i> has been updates!', '9000');

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_successfully', '<i>{1}</i> has been deleted!', '9000');

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_unsuccessfully', '<i>{1}</i> was not deleted due to your choice selection.', '9000');

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_successfully', '<i>{1}</i> has been successfully added to the data base.', '9000');

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_unsuccessfully', 'This affiliates could not be added to the database because you either did not enter an affiliate name or an affiliate url or an affiliate email.', '9000');

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_settings_successfully', 'Settings for Affiliates Addon Updated.', '9000');

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_successfully', '<i>{1}</i> was updated successfully.', '9000');

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_unsuccessfully', 'The type was <u>not</u> updated because the types name was left blank.', '9000');

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_unsuccessfully', 'This type/category was not added to the database due to the name of this type/category not being filled in.', '9000');

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_successfully', '<i>{1}</i> was added to the database successfully.', '9000');

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('0', 'approved_affiliate_x_successfully', '<i>{1}</i> has been approved successfully and an email has been dispatched to its admin\'s email.', '9000');

I get this:

Code:

 SQL-query : 



INSERT INTO phrase( languageid, varname, text, phrasetypeid )

VALUES (

'-1', 'saved_affiliate_x_successfully', '<i>{1}\'s</i> has been updates!', '9000'

)



MySQL said:



Table 'sm0k3_com.phrase' doesn't exist

in my database i see "vb3_phrase" ...do i need to change the "INSERT INTO phrase" to "INSERT INTO vb3_phrase"?

nevermind.....i went ahead and took a chance and it worked...thanks anyways :)

I got this erro when I am trying to add affiliate_list template

Code:

The following error occurred when attempting to evaluate this template:



Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /home/gamerzpl/public_html/forums/includes/adminfunctions_template.php(3037) : eval()'d code on line 97



This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.

could u please post the code your inserting into that template?

The Code that I put for that template is

Code:

$stylevar[htmldoctype]

<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">

<head>

        <title>$vboptions[bbtitle] - vB Affilates: List</title>

$headinclude

</head>

<body>

$header

$navbar

<br />

<table width="100%" align="center">

<tr>

<if condition="$show['sides']">

<if condition="$show[leftside]">

<td valign="top" align="center" width="150">

$momentbits

$mhobits

$mhibits

$mvbits

</td>

</if>

</if>

<td>

<if condition="$setting[top]">

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">

<tbody>

<tr class="tcat">

<td colspan="4" align="center">        <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('toplist')"><img id="collapseimg_toplist" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_toplist].gif" alt="" border="0"></a><font size="3"><b>Top(<i>$setting[top_limit]</i>) Affiliates</b></font></td>

</tr>

</tbody>

<tbody id="collapseobj_toplist" style="$vbcollapse[collapsetobj_toplist]">

<tr>

<td class="thead" align="center">#</td>

<td class="thead" width="100%" align="$stylevar[left]">Name</td>

<td class="thead" align="center">Hits Out</td>

<td class="thead" align="center">Hits In</td>

</tr>

$topbits

</tbody>

</table>

<br />

</if>

<form action="affiliate.php?do=listaffiliates" method="post">

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">

<tbody>

<tr>

<td colspan="2" class="thead" align="center"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('displayopt')"><img id="collapseimg_displayopt" src="$stylevar[imgdir_button]/collapse_alt$vbcollapse[collapseimg_displayopt].gif" alt="" border="0"></a>Display Options</td>

</tr>

</tbody>

<tbody id="collapseobj_displayopt" style="$vbcollapse[collapsetobj_displayopt]">

<tr>

<td class="alt1">Order By:<select name="by">

<optgroup label="Order By:">

<option value="sitename">Name</option>

<option value="name">Category/Type</option>

<option value="clicksout">Hits Out</option>

<option value="clicksin">Hits In</option>

<option value="totalvotes">Total Votes</option>

</optgroup>

</select>

</td>

<td class="alt2">Sort Order:

<select name="in">

<optgroup label="Sort Order:">

<option value="DESC">Descending</option>

<option value="ASC">Ascending</option>

</optgroup>

</select>

</td>

</tr>

<tr>

<td colspan="2" class="tcat" align="center"><input type="submit" value="Show Affiliates" class="button" /></td>

</tr>

</tbody>

</table>

</form>

<br />

<if condition="$show[pagination]">

<table align="center" width="100%" class="tborder"><tr><td class="tcat"><if condition="$show[prevactive]"><a href="affiliate.php?do=listaffiliates&page=$pageprev">促rev</a><else />促rev</if></td><td class="tcat" align="right"><if condition="$show[nextactive]"><a href="affiliate.php?do=listaffiliates&page=$pagenext">Next?/a><else />Next?/if></td>

</tr>

</table>

<br />

</if>

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">

<tbody>

<tr class="tcat">

<td colspan="6" align="center"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('afflist')"><img id="collapseimg_afflist" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_afflist].gif" alt="" border="0"></a><b><font size="5">$vboptions[bbtitle]'s Affiliates</font></b></td>

</tr>

</tbody>

<tbody id="collapseobj_afflist" style="$vbcollapse[collapsetobj_afflist]">

<tr>

<td class="thead" align="$stylevar[left]">Name/Description</td>

<td class="thead" align="center">Type/Category</td>

<td class="thead" align="center">Hits In</td>

<td class="thead" align="center">Hits Out</td>

<td class="thead" align="center">Rating</td>

<if condition="$show['rate']">

<td class="thead" align="center">Rate</td>

</if>

</tr>

$affiliatebits

</tbody>

<tr class="tcat">

<td align="center" colspan="6"><b>:<a href="affiliate.php">Index</a>:<if condition="$show['apply']">-:<a href="affiliate.php?do=apply">Apply for Affiliation</a>:</if></b></td>

</tr>

</table>

<br />

<if condition="$show['disclaimer']">

<div class="smallfont">*$vboptions[bbtitle]'s affiliates do not represent or express $vboptions[bbtitle]'s opinions,views, or ideals.</div></if>

</td>

<if condition="$show['sides']">

<if condition="$show[rightside]">

<td valign="top" align="center" width="150">

$momentbits

$mhobits

$mhibits

$mvbits

</td>

</if>

</if>

</tr>

</table>

<br />

$crn

<br />

$footer

</body>

</html>

and for line 3037 on adminfunctions_template.php

Code:

eval('$devnull = "' . $template . '";');

X vBulletin 3.8.12 by vBS Debug 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 (1)bbcode_php_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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01103 seconds Memory Usage 1,778KB 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 (1)bbcode_php_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
Messages: