Ausgirl

May 28, 2007

This contribution does not work for everyone. Before adding little extras to this contribution, I think it would serve everyone better if it could be updated first. If someone could be kind enough to do so, it would be much appreciated :)

May 13, 2007

Hello,

Need a BIG FAVOUR PLEASE!!! :) Can someone update this so it will work with Mysql 5. I really need this mod for my customers to upload there photos.

I cant do it as I have no idea when it comes to writing php.

Please someone, pretty please.

Thanks

May 8, 2007

Lol, your right, it does sound a bit confusing. Thanks for explaining that Rhea, I thought it had something to do with that but had no idea exactly how it worked. I shall copy this to my file so that I refer back to it later.

Thank you

Much Appreciated :)

May 8, 2007

They have instructions on how to install, just no instructions on how it works. Im still waiting for a reply to my last post. What is the teir level and how does it work. Im assuming its if someone signs up then they get someone else to sign up ect... Some simple instructions wouldnt go astray if someone whom already knows how this works could include them in the file or post it here. This mod is a bit tricky to understand.

I think this is a bit of a ghost thread :ph34r:

I downloaded and am using the oscaffiliate v2.6

May 1, 2007

<?php

/*

$Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Released under the GNU General Public License

*/

require('includes/application_top.php');

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);

$product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product_check = tep_db_fetch_array($product_check_query);

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product_info = tep_db_fetch_array($product_info_query);

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<head>

<?php

// BOF: Header Tag Controller v2.6.0

if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {

require(DIR_WS_INCLUDES . 'header_tags.php');

} else {

?>

<?php

}

// EOF: Header Tag Controller v2.6.0

?>

<?php include ('includes/ssl_provider.js.php'); ?>

function popupWindow(url) {

window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res

izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le

ft=150')

}

//--></script>

</head>

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

</table></td>

<?php $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product_info = tep_db_fetch_array($product_info_query);

$products_name = $product_info['products_name'];

?>

<?php echo mws_header (''); ?>

<?php

if ($product_check['total'] < 1) {

?>

<tr>

<td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>

</tr>

<tr>

</tr>

<tr>

<tr>

<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<?php

} else {

tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

if ($new_price = tep_get_products_special_price($product_info['products_id'])) {

$products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';

} else {

$products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));

}

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';

} else {

$products_name = $product_info['products_name'];

}

?>

<tr>

<tr>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<?php

if (tep_not_null($product_info['products_image'])) {

?>

<tr>

document.write('<?php echo '<a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');

//--></script>

<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>

</noscript>

<?php

//affiliate build a link begin

if (tep_session_is_registered('affiliate_id')) {

?>

<?php echo '<a href="' . tep_href_link(FILENAME_AFFILIATE_BANNERS_BUILD, 'individual_banner_id=' .

$product_info['products_id']) .'" target="_self">' .

tep_image('includes/languages/english/images/buttons/button_affiliate_build_a_link.gif', 'Make a link') . ' </a>'; ?>

<?php

}

//affiliate build a link begin

?>

</td>

</tr>

</table>

<?php

}

?>

<?php

$products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");

$products_attributes = tep_db_fetch_array($products_attributes_query);

if ($products_attributes['total'] > 0) {

?>

<tr>

</tr>

<?php

$products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");

while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {

$products_options_array = array();

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");

while ($products_options = tep_db_fetch_array($products_options_query)) {

$products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);

if ($products_options['options_values_price'] != '0') {

$products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';

}

if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {

$selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];

} else {

$selected_attribute = false;

}

?>

<tr>

</tr>

<?php

}

?>

</table>

<?php

}

?>

</td>

</tr>

<tr>

</tr>

<?php

$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");

$reviews = tep_db_fetch_array($reviews_query);

if ($reviews['count'] > 0) {

?>

<tr>

</tr>

<tr>

</tr>

<?php

}

if (tep_not_null($product_info['products_url'])) {

?>

<tr>

</tr>

<tr>

</tr>

<?php

}

if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {

?>

<tr>

</tr>

<?php

} else {

?>

<tr>

</tr>

<?php

}

?>

<tr>

</tr>

<tr>

<?php echo '<a title="' . $tags_array['title'] . '" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_info['products_id'], 'NONSSL') . '"/# ' . $tags_array['title'] . '">' . $tags_array['title']; ?></a></td>

</tr>

<tr>

</tr>

<tr>

<tr>

<td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

<tr>

</tr>

<tr>

<td>

<?php

if ((USE_CACHE == 'true') && empty($SID)) {

echo tep_cache_also_purchased(3600);

} else {

include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);

}

?>

</td>

</tr>

</table></form></td>

<?php echo mws_footer (''); ?>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

</table></td>

</tr>

</table>

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

May 1, 2007

Nope, it didnt work! I think its because the HTC takes over the headings but thats ok.

May 1, 2007

Ok here I go

May 1, 2007

Just wing it you reckon! LOL, The reason I asked was because the HTC makes your heading H1 priority. I just wondered if it would call on the header your little hack shows as it would be better that way, I think. Dont want it calling on a header that is no longer there.

One can only have a go!

May 1, 2007

G'day John,

How nifty, do you think this would effect a site using HTC?

Thanks

April 30, 2007

Very Welcome, Nice store by the way.

Thank You :)

Prices for Logged-In Users Only · April 30, 2007

Prices for Logged-In Users Only

Can this be turned on & off?

Can it be set for individual products only and not the entire store?

If not, does anyone know of a contribution that is like Prices for Logged-In Users Only but can do the above?

Thanks

April 30, 2007

Thanks for that John, I am sooooooo blind sometimes, I already had all that code done. I left out one little noborderbox. :blush:

As for replacing the lets see what we have here, you can change that in the english file but im not sure how you would make it call on the catagory titles. Have you tried Header Tag Controller, thats really good it will fill in all the headings for you. If you dont think that is what you are needing, maybe you should post that topic in the general thread as its nothing to do with GB so you will have more luck in finding an answer there.

Hope that helps you a little.

Thanks

April 30, 2007

I know its in this thread, I have already done all that, thought you had found something else.

April 29, 2007

I did find a fix, it's actually in the install.txt although I found the fix earlier in this thread. It basically adds a noborder box to the offending boxes so removing the problem.

If you found the fix could you please repost it so as I can fix mine.

Thanks

April 26, 2007

Hello John,

Mine does that, hehehe, If you can post the fix here that you found, (I was looking but couldnt find it) I might be able to help you with it.

April 21, 2007

Could someone please explain to me what the Affiliate Tier Multilevel Affiliate provisions, is, please. Is this a referal from an affiliate? How exactly does it work? What is this % rate? Is that the % they are paid?

April 20, 2007

No worries, I dont have the featured product mod installed, but Im sure it will help all those that do. :)

Thanks for all your help, much appreciated.

April 20, 2007

And the last hint I "created" today is about "featured products"

What! No more lessons? :) Thanks for the tips, mate :thumbsup:

April 19, 2007

Im not quite understanding how the "Payment" side of it works, if someone could please explain? I signed up as an affiliate, bought some products ect... I then went into the "Payment" Section on the Admin side, but none of this information is there so how do I start billing in order to pay? Affiliate Payment (excl.) Payment (incl.) Date Billed Status Action.

I assume the start billing is so I can pay the affiliates. Where do I find the payment options? Paid by Paypal, Bank deposit ect...

April 19, 2007

Ahhhh! Thats why I wasnt all lined up properly. Now Im all neat & lined up nicely,

Thanks again, your a gem :)

April 19, 2007

G'day Dennis,

Thank you kind sir, tis all fixed up now :)

April 19, 2007

In Admin, my heading looks like this:

TABLE_HEADING_AFFILIATE_NEWS

How do I get it to look like this:

TABLE HEADING AFFILIATE NEWS

Is there something in the english file that needs editing? If so what and where, please,

Thanks

April 19, 2007

ALTER TABLE `affiliate_banners` ADD `affiliate_category_id` INT DEFAULT '0' NOT NULL AFTER `affiliate_products_id` ;

:)

That worked. Just added the above code to the DB. :)

April 19, 2007

Hi Dennis,

I checked the database and the 900 table ID comes up with affiliate so I dont how that happens to say duplicate given it was the first time I ever installed it.

I know what the 1054 error means, I dont know why its stating that its not there when I installed the SQL. (I did have touble with the Alter Tables as I stated in the above thread) I will try installing just this bit hopefully its the right bit:

ALTER TABLE `affiliate_banners` ADD `affiliate_category_id` INT DEFAULT '0' NOT NULL AFTER `affiliate_products_id` ;

Unless someone can post the bit of code I am missing would be appreciated. :)

April 19, 2007

*
* 6.3. FIND:

*

new contentBoxHeading($info_box_contents);

*

* REPLACE With:

*

// new contentBoxHeading($info_box_contents);

Thanks Matej,

That was the little bit of code I forgot. New I missed something. Thank You :)

Ausgirl

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by Ausgirl

[CONTRIBUTION] File uploads as an Option Feature

[CONTRIBUTION] File uploads as an Option Feature

OSC-Affiliate

OSC-Affiliate

Graphical Borders on RSS News

Graphical Borders on RSS News

Graphical Borders on RSS News

Graphical Borders on RSS News

Graphical Borders on RSS News

Graphical Borders on RSS News

Prices for Logged-In Users Only

Graphical Borders on RSS News

Graphical Borders on RSS News

Graphical Borders on RSS News

Graphical Borders on RSS News

OSC-Affiliate

Graphical Borders on RSS News

Graphical Borders on RSS News

OSC-Affiliate

Graphical Borders on RSS News

OSC-Affiliate

OSC-Affiliate

OSC-Affiliate

OSC-Affiliate

Graphical Borders on RSS News

Browse

Activity