Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited


Profile Information

  • Real Name
  • Gender

Recent Profile Visitors

14,550 profile views
  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. Going to try have a reply in another topic.
  7. 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
  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)