Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by Francys

  1. Francys

    photo gallery for oscommerce

    Ok i guess this thread isn't getting replies, but im sure its because of the easieness to install. Would advise this contribution to any shop owner who intends to have a show room of images for the clients. ANyway here it goes, Hi all, Can anyone spot what is wrong here, i am using MySQL 5.0.91-community-log in PHP Version 5.2.12 Here is the error message when i click edit on a picture: 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 'AND pID=' at line 1 Here is the code of gallery_user.php (i know this is a contribution but the thread is not getting any replies and this is syntax so i appreciate your answer if you know): <?php /* $Id: shipping.php,v 1.22 2003/06/05 23:26:23 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License Site design by www.micrographx.be */ require('includes/application_top.php'); header('Content-type: text/html; charset=' . CHARSET . ''); // if the customer is not logged on, redirect them to the login page if (!tep_session_is_registered('customer_id')) { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL')); } require(DIR_WS_LANGUAGES . $language . '/gallery_user.php'); //edit form voor titel en beschrijving processen if (isset($_POST['edittitle']) && $_POST['edittitle']=='save') { $cID = $_POST['cID']; $pID = $_POST['pID']; mysql_query("UPDATE gallery SET title='".addslashes($_POST['title'])."', description='".addslashes($_POST['description'])."' WHERE gallery.cID=".$cID." AND gallery.pID=".$pID) or die(mysql_error()); } if (isset($_GET['delete'])) { unlink('gallery/'.$_GET['pid']); $cID = explode("_",$_GET['pid']); $pID = explode(".",$cID[1]); mysql_query("DELETE FROM gallery WHERE cID=".$cID[0]." AND pID=".$pID[0]); $messageStack->add('The file has been removed successfully.','success'); } $superuser=false; $superuser_check_query = tep_db_query("select count(*) as total from " . TABLE_GALLERY_SUPERUSERS . " where cID = '" . (int)$customer_id . "'"); $superuser_check_value = tep_db_fetch_array($superuser_check_query); if ($superuser_check_value['total'] > 0) $superuser=true; if (isset($_POST['fotouploaden']) && $_POST['fotouploaden']='Upload') { foreach ($_FILES["uploadedfile"]["error"] as $key => $error) { if ($error == UPLOAD_ERR_OK) { //nagaan hoeveel fotos deze klant reeds staan heeft $sql = mysql_query("SELECT * FROM gallery WHERE cID=".$customer_id); $i = mysql_num_rows($sql)+1; if ($i > 6 && $superuser==false) { $messageStack->add('gallery_user',ERROR_TOO_MANY,'error'); } if ($i < 6 || $superuser==true) { // begin superuser //voorwaarden nagaan: afmetingen (800x600), soort file (jpg,jpeg), bestandsgrootte (100k) //------------------------uitwerken en de errors wat mooier weergeven in de messagestack-------------------------------------------- $allowed_extensions = array('jpg','JPG'); $file = $_FILES['uploadedfile']; if (! preg_match('#\.(.+)$#', $file['name'][$key], $matches)) {die('File has no extension');} if (! in_array($matches[1], $allowed_extensions)) {die("Extension {$matches[1]} is not allowed");} if ($file['size'][$key]>100000) {die("file size too large");} if (!$file['type'][$key] == 'image/jpg') {die("wrong file type");} if (!is_uploaded_file($file['tmp_name'][$key])) {die("not a http upload");} if (!getimagesize($file['tmp_name'][$key])) {die("not an image file type");}//geeft false terug voor niet-images $size=getimagesize($file['tmp_name'][$key]); $width=$size[0]; $height=$size[1]; if ($width>800){die("width is too large");} if ($height>600){die("height is too large");} $target_path = "gallery/"; //bepalen welke de eerste vrije fotonummer is voor deze klant //identify the first free photo number for this customer $gebruikte_nummers = array(); while($fotos = mysql_fetch_array($sql)){ $gebruikte_nummers[] = $fotos['pID']; } $n = 1; if ($superuser==false){ while ($n <= 5 ) { if (!in_array($n,$gebruikte_nummers)) { break; } $n ++; } }else{ while ($n <= $i-1 ) { if (!in_array($n,$gebruikte_nummers)) { break; } $n ++; } } //$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); $target_path = $target_path . $customer_id."_".$n.".jpg"; if(copy($file['tmp_name'][$key], $target_path)) { //$messageStack->add('gallery_user','success'); $messageStack->add('header',TEXT_FILE. ' '. basename($file['name'][$key]). ' '.TEXT_UPLOADED,'success'); mysql_query("INSERT INTO gallery (cID,pID) VALUES (".$customer_id.",".$n.")"); tep_redirect(tep_href_link(FILENAME_GALLERY)); } else{ //$messageStack->add('There was an error uploading the file '. basename($file['name'][$key]). ', please try again!','error'); $messageStack->add('header','There was an error uploading the file '. basename($file['name'][$key]). ', please try again!','error'); } }//end superuser } } } $breadcrumb->add(NAVBAR_TITLE, tep_href_link('gallery_user.php')); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <script type="text/javascript" src="js/highslide/highslide.js"></script> <script type="text/javascript"> hs.registerOverlay({ overlayId: 'closebutton', position: 'top right', fade: 2 // fading the semi-transparent overlay looks bad in IE }); hs.graphicsDir = 'js/highslide/graphics/'; </script> <style type="text/css"> .highslide-wrapper div {font-family: Verdana, Helvetica;font-size: 10pt;} .highslide {cursor: url(js/highslide/graphics/zoomin.cur), pointer;outline: none;text-decoration: none;} .highslide-active-anchor img {visibility: hidden;} .highslide img {/*border: 2px solid gray;*/} .highslide:hover img {border-color: silver;} .highslide-wrapper, .drop-shadow {background: white;} .highslide-image {border: 10px solid white;} .highslide-image-blur {} .highslide-html {background-color: white;} .highslide-html-blur {} .highslide-html-content {position: absolute;display: none;width: 300px;} .highslide-body{padding: 0 10px 10px 10px;} .highslide-caption { display: none; border: 0px solid #745224; font-family: Verdana, Helvetica; text-align:right; font-style:italic; font-weight:bold; font-size: 10pt; padding:10px; background: white; } .highslide-loading { display: block; color: black; font-size: 8pt; font-family: sans-serif; font-weight: bold; text-decoration: none; padding: 2px; border: 1px solid black; background-color: white; padding-left: 22px; background-image: url(js/highslide/graphics/loader.white.gif); background-repeat: no-repeat; background-position: 3px 1px; } a.highslide-credits, a.highslide-credits i { padding: 2px; color: silver; text-decoration: none; font-size: 10px; } a.highslide-credits:hover, a.highslide-credits:hover i { color: white; background-color: gray; } a.highslide-full-expand { background: url(js/highslide/graphics/fullexpand.gif) no-repeat; display: block; margin: 0 10px 10px 0; width: 34px; height: 34px; } .highslide-overlay { display: none; } .highslide-wrapper .highslide-header { padding-bottom: 5px; } .highslide-wrapper .highslide-header ul { margin: 0; padding: 0; text-align: right; } .highslide-wrapper .highslide-header ul li { display: inline; padding-left: 1em; } .highslide-wrapper .highslide-header ul li.highslide-previous, .highslide-wrapper .highslide-header ul li.highslide-next { display: none; } .highslide-wrapper .highslide-header a { font-weight: bold; text-transform: uppercase; text-decoration: none; } .highslide-wrapper .highslide-header a:hover { color: black; } .highslide-wrapper .highslide-header .highslide-move a { cursor: move; } .control { float: right; display: block; /*position: relative;*/ margin: 0 5px; font-size: 9pt; font-weight: bold; text-decoration: none; text-transform: uppercase; } .control:hover { color: black !important; } .highslide-move { cursor: move; } </style> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_specials.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php if ($messageStack->size('gallery_user') > 0) { ?> <tr> <td><?php echo $messageStack->output('gallery_user'); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main"> <?php echo REEDS_GEUPLOAD."<br>"; $aantal_kol = 3; //number of pictures per row $rij = 1; $kolom = 1; $counter = 0; $dir = "gallery/"; echo '<table width="100%">'; $sql = mysql_query("SELECT * FROM gallery WHERE cID=".$customer_id); while($fotos = mysql_fetch_array($sql)){ $counter ++; if ($kolom == 1) {echo '<tr>';} $file = $customer_id."_".$fotos['pID'].".jpg"; echo "\n\n".'<td class="main" align="center">'; echo '<a href="' . tep_href_link($dir.$file) . '" class="highslide" onclick="return hs.expand(this)">'.tep_image($dir . $file, '', 150, 150, 'hspace="5" vspace="5"').'</a><br>'; $photos_pid=$fotos['pID']; $photos_cid=$fotos['cID']; $link = 'gallery_process.php?edit=yes&pID='.$fotos['pID'].'&cID='.$fotos['cID']; echo '[<a href="'.tep_href_link($link,'','SSL','',false).'" onclick="return hs.htmlExpand(this, { objectType: \'iframe\',outlineType: \'rounded-white\', outlineWhileAnimating: true } )">' .TEXT_EDIT.'</a>]<br>'; echo '[<a href="' . tep_href_link('#') . '" onclick="return hs.htmlExpand(this, { contentId: \'comment'.$fotos['cID'].$fotos['pID'].'\', outlineType: \'rounded-white\', outlineWhileAnimating: true } )" class="highslide">' .TEXT_COMMENTS.'</a>]<br>'; echo '[<a href="gallery_user.php?delete&pid='.$file.'">'.TEXT_DELETE.'</a>]</td>'; ?> <div class="highslide-html-content" id="comment<?php echo $fotos['cID'].$fotos['pID'];?>"> <div style="height:20px; padding: 2px"> <a href="#" onclick="return hs.close(this)" class="control">Close</a> <a href="#" onclick="return false" class="highslide-move control">Move</a> </div> <div class="highslide-body"> <?php echo '<div style="text-align:left;color:#666666;font-weight:normal;font-style:normal;font-size:7pt;">'; //bestaande commentaar uitlezen if ($fotos['comment'] != '') { $comment = explode('<-->',$fotos['comment']); foreach ($comment as $val) { $commentaar = explode ('///',$val); echo '<b>'.stripslashes($commentaar[0]) . "</b>: ".stripslashes($commentaar[1]).'<hr style="border:0;height:1px;color:#666666;background:#666666;">'; } } else { echo TEXT_NO_COMMENTS; } echo '</div>'; ?> </div> </div> <?php if ($kolom == $aantal_kol) { echo '</tr>'; $kolom = 0; } $rij ++; $kolom ++; } if ($kolom <= $aantal_kol && $counter !== 0 ) {echo '</tr>';} echo '</table>'; if ($counter == 0) {echo NO_PICTURES;} echo "<p>"; echo VOORWAARDEN_ONE; if ($superuser==false) { echo VOORWAARDEN_TWO; }else{ //echo VOORWAARDEN_TWO_SU; } echo VOORWAARDEN_THREE; ?> <form enctype="multipart/form-data" action="gallery_user.php" method="POST"> <!--<input type="hidden" name="MAX_FILE_SIZE" value="100000" />--> <?php //nagaan hoeveel fotos deze klant reeds staan heeft $i = mysql_num_rows($sql); //if ($superuser==true) echo 'YOU ARE A SUPERUSER<br>'; if ($i < 6 || $superuser==true) { echo CHOOSE_FILE.': <br>'; if ($superuser==false){ while ($i <6) { $i ++; echo '<input type="file" name="uploadedfile[]" /><br>'; } }else{ $j=0; while ($j <6) { $j ++; echo '<input type="file" name="uploadedfile[]" /><br>'; } } ?> <input type="submit" name="fotouploaden" value="Upload" /> <?php } else { echo MAX_GALLERY_REACHED; } ?> </form> </td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  2. Can anyone explain what't wrong, the last rokslideshow contribution isn't showing any slides, there is missing some dialogs in admin, there isnt a clear interface explaining how you make/publish the slidesshows. And database sql leaves de slideshow table empty (supposedly in admin > tools > slideshow we could build those but the screen interface is empty). here is link http://addons.oscommerce.com/info/7221 Thanks in advance Francis
  3. Hellos This is a much expected patch, can anyone feedback about if its working or not, since from the previous posts it looks like it has some bugs. Feedback apreciated, Francis
  4. looooloooll kind of pretty ladies :)

  5. Francys

    out of stock

    lo craig I have this contribution installed and it works: Here is the link http://addons.oscommerce.com/info/5070 Have noticed the advanced_search_result products show all like not available, anyone has the fix for this (similar to what happen with index new products)
  6. Hi all, I installed a very much advised contribution that indicates if a given product is available or not, if its quantity is above or equal to 0, anyway. Here is the link http://addons.oscommerce.com/info/5070 Have noticed the advanced_search_result products show all like not available, anyone has the fix for this (similar to what happen with index new products) Thanks'n advance
  7. Going to try have a reply in another topic.
  8. Francys

    ULTIMATE Seo Urls 5 - by FWR Media

    Hi Rob Some people were pming me for USU5 PRO beta testing, since i also asked it lol in forums, which you arent sending to them if you are going to release it consider there are people willing to testing (its ashame people didnt support your dev thread for USU5 PRO much) Here is the link for people who can properly beta testing-> USU5 PRO SEO URLS FOR PROFESSSIONAL SHOPOWNERS anyway lobbying Cheers Franc
  9. Hi Robert, congratulations for yet another very nice contribution, since you made it available in extras, i installed google breadcrumbs, but after moving some categories in admin panel to root, and renaming the shop root in breadcrumb trail, i lost the subcategories in the breadcrumbs trail after Top> renamed Catalog> in product listing pages (in the rest of pages, and in product_info aswell the breadcrumbs are working) since you know very well the breadcrumbs mechanism i was hoping you can tell me what needs to be done to fix the breadcrumbs not showing properly in product listing (in the rest i have everything ok). i dont know if this is the problem but; Error: Undefined index: manufacturers_id File: includes/modules/product_listing.php Line: 117 $man_id = (tep_not_null($_GET['manufacturers_id']) ? $_GET['manufacturers_id'] : ''); Error: Undefined variable: cat_path File: includes/modules/product_listing.php Line: 118 $link = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $listing['products_id'] . ($man_id ? '&manufacturers_id='.$man_id : ($cPath && $cat_path ? '&cPath=' . $cPath : '')) ) . '"' . ($man_id || ($cat_path && $cat_path) ? ' rel="nofollow"' : '') . '>';
  10. Francys

    jQuery/Ajax Shopping Cart

    Congratulations for this nice contribution, when i run KissErrorHandler for debugging, i get the following error in shopping cart, in the 2 places of code where this line appears: Here is the report and line following Error: Undefined index: ajax File: shopping_cart.php Line: 34 Error: Undefined index: HTTP_X_REQUESTED_WITH File: shopping_cart.php Line: 34 Error: Undefined index: ajax File: shopping_cart.php Line: 340 Error: Undefined index: HTTP_X_REQUESTED_WITH File: shopping_cart.php Line: 340 if ( (int)$_GET['ajax'] != 1 && $_SERVER['HTTP_X_REQUESTED_WITH'] != 'XMLHttpRequest' ) I'm sure this must be super easy to sort out but still :)
  11. Francys

    Ultimate Seo Urls 5 Pro

    Hello, haven't receive the files for beta testing... you can send me a pm in forums if interested in having another beta tester. Cheers
  12. check my posts and help is appreciated thanks

  13. Francys

    News Blog V1.0

    Hi analogixx, Well this contribution has many bugs, the instructions aren't all accurate, and i think there isn't much support, the constants for instance return many errors in kissErrorHandler and i even renamed them because i am using rss.php for another contribution, so in conclusion you can check it with one of the contribution posters or have another contribution that basically does the same or resolve usingKissErrorHandler. cheers
  14. Francys

    Google XML Sitemap SEO

    Hi Jack, I have google xml seo v1.4 and it works returning seo urls (but im using another urls seo contrib). When i tried to update to v1.5 it works well, except the urls aren't seo they are cpath. What do you think is better for SEO pourposes: stay with the slightly hacked version of v1.4 (displaying seo urls) or install v1.5 without deprecated commands and fully working for multilanguage hence i can submit for all languages (with the disadvantage of cpath urls, since i can't make seo urls work in this version)
  15. Francys

    News Blog V1.0

    Check your file permissions, and check also catalog/includes/filenames.php, catalog/admin/includes/filenames.php In the meanwhile i'm going to post here some List of BUGS not sorted in this contribution: -> usage of HTTP_POST_VARS and HTTP_GET_VARS -> E_NOTICE Error Count: 5 Error: Undefined index: action File: news.php Line: 26 Error: Undefined index: article File: news.php Line: 70 Error: Undefined variable: news File: news.php Line: 82 Error: Undefined variable: news File: news.php Line: 83 Error: Undefined variable: news File: news.php Line: 84 -> The breadcrumbs of News Blog, are showing in other unrelated pages of the website (bad parameter passing), for instance in contact_us.php Note: If you want to install a product RSS Feed like RSS Feeds v2.2 you can just rename the following from this contribution: catalog/includes/filenames.php FILENAMES_RSS change to FILENAMES_RSS_NEWS catalog/includes/languages/yourlanguage.php BOX_INFORMATION_RSS change to BOX_INFORMATION_RSS_NEWS in catalog/ rss.php change to rss_news.php
  16. Francys

    jQuery/Ajax Shopping Cart

    Hi delete13, Congrats for the best ajax shopping cart i have seen so far, i have sorted the language bug, regarding the replace... shall i just update to your 3rd version or i implement the code you say here? I know this hasn't do to directly to this contrib but if you know i would like some hint... i have SEO Friendly URLs turned off, and still i am getting Unable to determine page links... thanks in advance
  17. Francys

    jQuery/Ajax Shopping Cart

    Ok, i will implement & feedback... thank you so much!! Congratulations, The contribution works very well and i am going to stick to it, i think the minor disadvantage of not having more jquery features (more then one jquery in same page can sometimes not be optimal) is easily bypassed by this jquery shopping cart advantages. I only have the following bugs (and reconfirmed all the installation steps): A - In step 4) of instructions (pdf file) 4) filename : catalog/index.php and other one where placed the shopping cart infobox What do you mean in other one... which files do we have to declare apart catalog/index.php ? (is it contact_us.php, and rest in catalog root?) B - My shopping cart recently is showing this in breadcrumbs and i don't know if it's because this contrib or news blog contrib... Begin>Catalog>NewsBlog instead of Begin>Catalog>Shopping Cart It must be some parameter that is passing incorrectly, because the shopping cart code "seems ok". What can be happening for the nav bar not displaying, and also i get in shopping_cart.php page the following error (not all times) Error! Unable to determine the page link! Thanks a lot for your fantastic contribution... and sorry for being a bit annoying with my questions :/ Cheers
  18. Francys

    jQuery/Ajax Shopping Cart

    Wow, congratulations for your contribution, i installed it and it works. Sugestion: paste this thread link in contribution spot so people can feedback here. Observations regarding contribution: A -> When you take out all the items clicking in remove, the total value doesn't update to 0,00. B -> special Portuguese, spanish and other chars after a few clicks get replaced by a question mark in shopping cart: á -> á ç -> ç ã -> ã C -> Doesn't the use of JQuery slow the website, and also, you can't use many JQuery in the same page because the different queries tend to conflict, your opinion regarding this. Very smooth and clean contribution, for a first version, congratulations.
  19. Francys

    Information Pages Unlimited v1.0

    Hi all, It's amazing that people should give more attention, when adding updates to contributions, the minimum that is asked is to read what is written in the contribution thread. If this is not done when a new update to info_pages comes up a problem is sorted, but some already spoted bugs may not be sorted. How to make this nice contribution to work properly: 1 - go to addon infos download info-unlimited-v2.07 --- escri version 2 - follow all instructions steps 2.1 - YES YOU SHOULD OPT WITH CKEDITOR it's the most advanced html editor, and it is ultra easy to install, just d/l it from ckeditor website and upload it to your server. 2.2 - if you are going for welcome pages (which i think you should) the sql is ok, bear in mind for n-languages websites you will need to create n x sql_additional (and dont forget your language id) 3 - After you do everything right, and finishing escri version instructions, you will now fix the following bugs: 3.1 BreadCrumbs not showing parent Ids properly This is not accurate but i have worked it out and this version works to show properly the breadcrumbs: /// Added for information pages if(!isset($_GET['info_id']) || !tep_not_null($_GET['info_id']) || !is_numeric($_GET['info_id']) ) { $title = 'Sorry. Page Not Found.'; $breadcrumb->add($INFO_TITLE, tep_href_link(FILENAME_INFORMATION, 'info_id=' . $_GET['info_id'], 'NONSSL')); } else { $info_id = intval($_GET['info_id']); $information_query = tep_db_query("SELECT parent_id, information_title, information_description FROM " . TABLE_INFORMATION . " WHERE visible='1' AND information_id='" . $info_id . "' and language_id='" . (int)$languages_id ."'"); $information = tep_db_fetch_array($information_query); $title = stripslashes($information['information_title']); $page_description = stripslashes($information['information_description']); // Added as noticed by infopages module if (!preg_match("/([\<])([^\>]{1,})*([\>])/i", $page_description)) { $page_description = str_replace("\r\n", "<br>\r\n", $page_description); } // if assigned to Parent - get parent too :) $parent = $information['parent_id']; if ($parent > '0') { $information_parent_query = tep_db_query("SELECT information_title FROM " . TABLE_INFORMATION . " WHERE information_id='" . $parent . "' and language_id='" . (int)$languages_id ."'"); $information_parent = tep_db_fetch_array($information_parent_query); $parent_title = stripslashes($information_parent['information_title']); $breadcrumb->add($parent_title, tep_href_link(FILENAME_INFORMATION, 'info_id=' . $parent, 'NONSSL')); $breadcrumb->add($title, tep_href_link(FILENAME_INFORMATION, 'info_id=' . $_GET['info_id'], 'NONSSL')); } else { $breadcrumb->add($title, tep_href_link(FILENAME_INFORMATION, 'info_id=' . $_GET['info_id'], 'NONSSL')); } } ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> 3.2 Another issue to fix has to do with children infopages don't update in information box 3.3 Edit catalog/includes/languages/yourlanguage.php (only if you have welcome pages as info pages) and: find: define('TEXT_GREETING_PERSONAL' define('TEXT_GREETING_PERSONAL_RELOGON', define('TEXT_GREETING_GUEST', and replace for: //define('TEXT_GREETING_PERSONAL' //define('TEXT_GREETING_PERSONAL_RELOGON', //define('TEXT_GREETING_GUEST', 4 This sorts it out. Everything works. CONCLUSION: When adding updates is appreciated to check the forums so nothing is by passed in terms of solutions.
  20. Francys

    Information Pages Unlimited v1.0

    I read carefully all this thread pages, and haven't found the answer to the problem im trying to sort... so can't say i haven't tried... everything runs smoothly and i can create nice info pages, but the problem is that it isn't showing the created content in the information box. If anyone knows to sort this reply is appreciated really Have here nice tools and sorting now thanks
  21. Francys

    Information Pages Unlimited v1.0

    Hi there, I have installed information pages last version 207 and it's working, when i click the link of the article entitled puppets www.mysite.com/information.php?info_id=7 i can see the info page regarding puppets info. What doesnt appear is the Puppets article page in the infobox on column left, near contact us or terms. my boxes/information.php code is this: <?php /* $Id: information.php 1739 2007-12-20 00:52:16Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <!-- information //--> <tr> <td> <?php // BOF code added Add-on - Information Pages Unlimited require_once(DIR_WS_FUNCTIONS . 'information.php'); // EOF code added Add-on - Information Pages Unlimited $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_INFORMATION); new infoBoxHeading($info_box_contents, false, false); $info_box_contents = array(); $info_box_contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_SHIPPING) . '">' . BOX_INFORMATION_SHIPPING . '</a><br>' . '<a href="' . tep_href_link(FILENAME_PRIVACY) . '">' . BOX_INFORMATION_PRIVACY . '</a><br>' . '<a href="' . tep_href_link(FILENAME_CONDITIONS) . '">' . BOX_INFORMATION_CONDITIONS . '</a><br>' . //BOF code news blog '<a href="' . tep_href_link(FILENAME_CONTACT_US) . '">' . BOX_INFORMATION_CONTACT . '</a> <br><a href="' . tep_href_link(FILENAME_NEWS) . '">News</a><br>'. //EOF code news blog /***** BOF code added End Sitemap_SEO *****/ '<a href="' . tep_href_link(FILENAME_SITEMAP_SEO) . '">' . BOX_INFORMATION_SITEMAP_SEO . '</a>'); /***** EOF code added End Sitemap_SEO *****/ new infoBox($info_box_contents); ?> </td> </tr> <!-- information_eof //-->
  22. Francys

    Ultimate Seo Urls 5 Pro

    I will test it today.
  23. Thanks stevel Regarding this topic: i have found that the bots from www.feedvalidator.org the tool for you to check if the feeds are compliant when reaching the shopsite are not recognized as bots, but as clients, check the user agent: FeedValidator/1.3 i didn't remember the rest like IP and name... congratulations for spiders.txt it's so usefull. I have had recently a user not showing anything in my website (no IP, no name, no user agent, and it said reserved) what kind of firewall is this. Where can we retrieve the logfiles of the visits without using cpanel. thanks Francys
  24. Francys

    The Feedmachine Solution

    Hi Sorry to double post but the edit option wasnt available. I have a couple of easy questions i would like the answer : A - Correct me if i'm wrong, but Easy Populate contribution generates this kind of information in csv values... would it work to use the easy populate dump for Seo product feeder? B - also in my shop i have only logged in customers can see prices, will i be able to feed products in SEO's (i just installed feedmachines and i'm newbie at this) i noticed the feeds are working properly and the price gets extracted to feed dump? C - After the feed to google (or other service) being produced we can submit it for what i have seen: by uploading it through each feed service website right, by sending it instantly with a cron job. Or by manual executing making use of FTP!? to send it. Basically we should put here->FTP Server FTP Path FTP Username FTP Password Period the data of our ftp server right?! BTW If i have three languages in a shop i have to make three instances of the feed config right? and it will output the three language files in three different names. Thanks in advance Francys