Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

orders_id is allways 0?


commander3

Recommended Posts

Hi to all

 

I have download store and everything worked just fine, but after I installed few add ons (super download store so on) something happend.

I cant see orders and customers cant download their products and they cant see their orders also.

 

I dont find any mistakes from script, but when I look orders from database orders_id is allways 0.

In these:

orders_products

orders_status

orders_status_history

orders_total

 

And in these orders_products_id is also 0

 

orders_products_attributes

orders_products_download

 

Could somebody help me with this problem, because I am in really big problems with this error??

I did remove all modifications I have made, but error still remains!!

..and sorry my english, but I hope you understand it?

 

HELP!!

Link to comment
Share on other sites

If you have removed all your changes you should be back to a clean install.

 

Remove the site and reinstall and start again.

 

Test after you install each contribution.

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

A modified site might have wrong values for n reasons.

 

You need to paste the code that You feel is responsible for this.

 

Generally its either a wrong variable name taken so a value 0 comes in.

Or register globals issue.

 

Satish

Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Link to comment
Share on other sites

Install all the contributions again and test after each one.

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Ok, I think at I found what causes that error:

Its thumbnail add-on:

<?php
/*
 $Id: CATALOG html_output.php,v 1.0 2007/09/09
+-----------------------------------------------------------------------+
| 								        								|
| Released under the GNU General Public License                         |
| 						                        						|
+-----------------------------------------------------------------------+
*/

   if (SEO_ENABLED == 'true') {
   ////
// Ultimate SEO URLs v2.1
// The HTML href link wrapper function
 function tep_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true) {
       global $seo_urls;                
               if ( !is_object($seo_urls) ){
                       if ( !class_exists('SEO_URL') ){
                               include_once(DIR_WS_CLASSES . 'seo.class.php');
                       }
                       global $languages_id;
                       $seo_urls = new SEO_URL($languages_id);
               }
       return $seo_urls->href_link($page, $parameters, $connection, $add_session_id);
 }
 } else {
////
// The HTML href link wrapper function
 function tep_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true) {
   global $request_type, $session_started, $SID;

   if (!tep_not_null($page)) {
     die('<br /><br /><font color="#ff0000"><strong>Error!</strong></font><br /><br /><strong>Unable to determine the page link!<br /><br />');
   }

   if ($connection == 'NONSSL') {
     $link = HTTP_SERVER . DIR_WS_HTTP_CATALOG;
   } elseif ($connection == 'SSL') {
     if (ENABLE_SSL == true) {
       $link = HTTPS_SERVER . DIR_WS_HTTPS_CATALOG;
     } else {
       $link = HTTP_SERVER . DIR_WS_HTTP_CATALOG;
     }
   } else {
     die('<br /><br /><font color="#ff0000"><strong>Error!</strong></font><br /><br /><strong>Unable to determine connection method on a link!<br /><br />Known methods: NONSSL SSL</strong><br /><br />');
   }

   if (tep_not_null($parameters)) {
     $link .= $page . '?' . tep_output_string($parameters);
     $separator = ' ';
   } else {
     $link .= $page;
     $separator = '?';
   }

   while ( (substr($link, -1) == '&') || (substr($link, -1) == '?') ) $link = substr($link, 0, -1);

// Add the session ID when moving from different HTTP and HTTPS servers, or when SID is defined
   if ( ($add_session_id == true) && ($session_started == true) && (SESSION_FORCE_COOKIE_USE == 'False') ) {
     if (tep_not_null($SID)) {
       $_sid = $SID;
     } elseif ( ( ($request_type == 'NONSSL') && ($connection == 'SSL') && (ENABLE_SSL == true) ) || ( ($request_type == 'SSL') && ($connection == 'NONSSL') ) ) {
       if (HTTP_COOKIE_DOMAIN != HTTPS_COOKIE_DOMAIN) {
         $_sid = tep_session_name() . '=' . tep_session_id();
       }
     }
   }

   if ( (SEARCH_ENGINE_FRIENDLY_URLS == 'true') && ($search_engine_safe == true) ) {
     while (strstr($link, '&&')) $link = str_replace('&&', '&', $link);

     $link = str_replace('?', '/', $link);
     $link = str_replace('&', '/', $link);
     $link = str_replace('=', '/', $link);

     $separator = '?';
   }

   if (isset($_sid)) {
     $link .= $separator . $_sid;
   }

   return $link;
 }
 }

////
// The HTML image wrapper function
 function tep_image($src, $alt = '', $width = '', $height = '', $parameters = '') {
   if ( (empty($src) || ($src == DIR_WS_IMAGES)) && (IMAGE_REQUIRED == 'false') ) {
     return false;
   }

if ($image_size = @getimagesize($src)) {
     if ((CONFIG_CALCULATE_IMAGE_SIZE == 'true' && $src != DIR_WS_IMAGES . 'pixel_black.gif' && $src != DIR_WS_IMAGES . 'pixel_trans.gif' && $src != DIR_WS_IMAGES . 'pixel_silver.gif' )) {
	if ( ($width) || ($height) ) {
		if ( $width=="100%" ) {
		  $width = $image_size[0];
		} elseif ( $height=="100%" ) {
		  $height = $image_size[1];
		} elseif ( $width==0 ) {
		  unset($width);
		} elseif ( $height==0 ) {
		  unset($height);
		}
		$src=thumbimage(DIR_FS_CATALOG . '/' .$src, $width, $height, 1, 1, DIR_FS_CATALOG . '/' . DIR_WS_IMAGES . 'thumbs_cache');
		if ((($image_size[1]/$height) > ($image_size[0]/$width) ) && $height>0){
			 $width=ceil(($image_size[0]/$image_size[1])* $height);
		} elseif ($width>0) {
			 $height=ceil($width/($image_size[0]/$image_size[1]));
		}
	}
	  }
     } elseif (IMAGE_REQUIRED == 'false') {
       return '';
     }


// alt is added to the img tag even if it is null to prevent browsers from outputting
// the image filename as default
   $image = '<img src="' . tep_output_string($src) . '" border="0" alt="' . tep_output_string($alt) . '"';

   if (tep_not_null($alt)) {
     $image .= ' title=" ' . tep_output_string($alt) . ' "';
   }

   if (tep_not_null($width) && tep_not_null($height)) {
     $image .= ' width="' . tep_output_string($width) . '" height="' . tep_output_string($height) . '"';
   }

   if (tep_not_null($parameters)) $image .= ' ' . $parameters;

   $image .= ' />';

   return $image;
 }

////
// The HTML form submit button wrapper function
// Outputs a button in the selected language
 function tep_image_submit($image, $alt = '', $parameters = '') {
   global $language;

   $image_submit = '<input type="image" src="' . tep_output_string(DIR_WS_LANGUAGES . $language . '/images/buttons/' . $image) . '" border="0" alt="' . tep_output_string($alt) . '"';

   if (tep_not_null($alt)) $image_submit .= ' title=" ' . tep_output_string($alt) . ' "';

   if (tep_not_null($parameters)) $image_submit .= ' ' . $parameters;

   $image_submit .= ' />';

   return $image_submit;
 }

// Output image form button for categories differentes / seul le lien de l'image change
 function tep_image_submit_used($image, $alt = '', $parameters = '') {
   global $language;

   $image_submit = '<input type="image" src="' . tep_output_string(DIR_FS_CATALOG_USED . $image) . '" alt="' . tep_output_string($alt) . '"';

   if (tep_not_null($alt)) $image_submit .= ' title=" ' . tep_output_string($alt) . ' "';

   if (tep_not_null($parameters)) $image_submit .= ' ' . $parameters;

   $image_submit .= ' />';

   return $image_submit;
 }  

////
// Output a function button in the selected language
 function tep_image_button($image, $alt = '', $parameters = '') {
   global $language;

   return tep_image(DIR_WS_LANGUAGES . $language . '/images/buttons/' . $image, $alt, '', '', $parameters);
 }

////
// Output a separator either through Otherspace, or with an image
 function tep_draw_separator($image = 'pixel_black.gif', $width = '100%', $height = '1') {
   return tep_image(DIR_WS_IMAGES . $image, '', $width, $height);
 }

////
// Output a form
 function tep_draw_form($name, $action, $method = 'post', $parameters = '') {
   $form = '<form name="' . tep_output_string($name) . '" action="' . tep_output_string($action) . '" method="' . tep_output_string($method) . '"';

   if (tep_not_null($parameters)) $form .= ' ' . $parameters;

   $form .= '>';

   return $form;
 }

////
// Output a form input field
 function tep_draw_input_field($name, $value = '', $parameters = '', $type = 'text', $reinsert_value = true) {
   $field = '<input type="' . tep_output_string($type) . '" name="' . tep_output_string($name) . '"';

   if ( (isset($GLOBALS[$name])) && ($reinsert_value == true) ) {
     $field .= ' value="' . tep_output_string(stripslashes($GLOBALS[$name])) . '"';
   } elseif (tep_not_null($value)) {
     $field .= ' value="' . tep_output_string($value) . '"';
   }

   if (tep_not_null($parameters)) $field .= ' ' . $parameters;

   $field .= ' />';

   return $field;
 }

////
// Output a form password field
 function tep_draw_password_field($name, $value = '', $parameters = 'maxlength="40"') {
   return tep_draw_input_field($name, $value, $parameters, 'password', false);
 }

////
// Output a selection field - alias function for tep_draw_checkbox_field() and tep_draw_radio_field()
 function tep_draw_selection_field($name, $type, $value = '', $checked = false, $parameters = '') {
   $selection = '<input type="' . tep_output_string($type) . '" name="' . tep_output_string($name) . '"';

   if (tep_not_null($value)) $selection .= ' value="' . tep_output_string($value) . '"';

   if ( ($checked == true) || ( isset($GLOBALS[$name]) && is_string($GLOBALS[$name]) && ( ($GLOBALS[$name] == 'on') || (isset($value) && (stripslashes($GLOBALS[$name]) == $value)) ) ) ) {
     $selection .= ' checked="checked"';
   }

   if (tep_not_null($parameters)) $selection .= ' ' . $parameters;

   $selection .= ' />';

   return $selection;
 }

////
// Output a form checkbox field
 function tep_draw_checkbox_field($name, $value = '', $checked = false, $parameters = '') {
   return tep_draw_selection_field($name, 'checkbox', $value, $checked, $parameters);
 }

////
// Output a form radio field
 function tep_draw_radio_field($name, $value = '', $checked = false, $parameters = '') {
   return tep_draw_selection_field($name, 'radio', $value, $checked, $parameters);
 }

////
// Output a selection field - alias function for tep_draw_checkbox_field() and tep_draw_radio_field() pour shopping_cart
 function tep_draw_selection_field_shopping_cart($name, $type, $value = '', $checked = false, $parameters = '') {
   $selection = '<input type="' . tep_output_string($type) . '" name="' . tep_output_string($name) . '"';

   if (tep_not_null($value)) $selection .= ' value="' . tep_output_string($value) . '"';

   if ( ($checked == true) || ( isset($GLOBALS[$name]) && is_string($GLOBALS[$name]) && ( ($GLOBALS[$name] == 'on') || (isset($value) && (stripslashes($GLOBALS[$name]) == $value)) ) ) ) {
$selection .= '';
   }

   if (tep_not_null($parameters)) $selection .= ' ' . $parameters;

   $selection .= ' />';

   return $selection;
 }

////
// Output a form checkbox field
 function tep_draw_checkbox_field_shopping_cart($name, $value = '', $checked = false, $parameters = '') {
   return tep_draw_selection_field_shopping_cart($name, 'checkbox', $value, $checked, $parameters);
 }

////
// Output a form radio field
 function tep_draw_radio_field_shopping_cart($name, $value = '', $checked = false, $parameters = '') {
   return tep_draw_selection_field_shopping_cart($name, 'radio', $value, $checked, $parameters);
 }

////
// Output a form textarea field
 function tep_draw_textarea_field($name, $width, $height, $text = '', $parameters = '', $reinsert_value = true) {
   $field = '<textarea name="' . tep_output_string($name) . '" cols="' . tep_output_string($width) . '" rows="' . tep_output_string($height) . '"';

   if (tep_not_null($parameters)) $field .= ' ' . $parameters;

   $field .= '>';

   if ( (isset($GLOBALS[$name])) && ($reinsert_value == true) ) {
     $field .= tep_output_string_protected(stripslashes($GLOBALS[$name]));
   } elseif (tep_not_null($text)) {
     $field .= tep_output_string_protected($text);
   }

   $field .= '</textarea>';

   return $field;
 }


////
// Output a form hidden field
 function tep_draw_hidden_field($name, $value = '', $parameters = '') {
   $field = '<input type="hidden" name="' . tep_output_string($name) . '"';

   if (tep_not_null($value)) {
     $field .= ' value="' . tep_output_string($value) . '"';
   } elseif (isset($GLOBALS[$name])) {
     $field .= ' value="' . tep_output_string(stripslashes($GLOBALS[$name])) . '"';
   }

   if (tep_not_null($parameters)) $field .= ' ' . $parameters;

   $field .= ' />';

   return $field;
 }

////
// Hide form elements
 function tep_hide_session_id() {
   global $session_started, $SID;

   if (($session_started == true) && tep_not_null($SID)) {
     return tep_draw_hidden_field(tep_session_name(), tep_session_id());
   }
 }

////
// Output a form pull down menu
 function tep_draw_pull_down_menu($name, $values, $default = '', $parameters = '', $required = false) {
 if(sizeof($values)>1){
   $field = '<select name="' . tep_output_string($name) . '"';

   if (tep_not_null($parameters)) $field .= ' ' . $parameters;

   $field .= '>';

   if (empty($default) && isset($GLOBALS[$name])) $default = stripslashes($GLOBALS[$name]);

   for ($i=0, $n=sizeof($values); $i<$n; $i++) {
     $field .= '<option value="' . tep_output_string($values[$i]['id']) . '"';
     if ($default == $values[$i]['id']) {
       $field .= ' selected="selected"';
     }

     $field .= '>' . tep_output_string($values[$i]['text'], array('"' => '"', '\'' => ''', '<' => '<', '>' => '>')) . '</option>';
   }
   $field .= '</select>';

   if ($required == true) $field .= TEXT_FIELD_REQUIRED;

}else{
$field .= tep_output_string($values[0]['text'], array('"' => '"', '\'' => '', '<' => '<', '>' => '>')).
   tep_draw_hidden_field(tep_output_string($name),  tep_output_string($values[0]['id']));}

   return $field;
 }

////
// Creates a pull-down list of countries
 function tep_get_country_list($name, $selected = '', $parameters = '') {
   $countries_array = array(array('id' => '', 'text' => PULL_DOWN_DEFAULT));
   $countries = tep_get_countries();

   for ($i=0, $n=sizeof($countries); $i<$n; $i++) {
     $countries_array[] = array('id' => $countries[$i]['countries_id'], 'text' => $countries[$i]['countries_name']);
   }

   return tep_draw_pull_down_menu($name, $countries_array, $selected, $parameters);
 }


 function thumbimage ($image, $x, $y, $aspectratio, $resize, $cachedir){
 define(JPEGQUALITY, 100);
         /*##############################################
      #          - Thumbnail-Script v1.3 -           #
      # Generating thumbnails 'on-the-fly' with PHP  #
      #                                              #
      #  © by Christian Lamine, FlashDreams OHG    #
      #          [url="http://www.flashdreams.de/"]http://www.flashdreams.de/[/url]          #
      #                                              #
      #       Modified by [url="http://www.tse.at"]http://www.tse.at[/url]          #
      #       Modified by [email protected]               #
      #                                              #
      # This script may be freely used, distributed  #
      # and modified without any charge as long as   #
      # this copyright information is included.      #
      #                                              #
      # Any commercial selling of this script is     #
      # forbidden.                                   #
      #                                              #
      # The author is not responsible for possible   #
      # damage which may result from the application #
      # of this script, neither direct nor indirect. #
      # Use at your own risk!                        #
   	  ##############################################*/

    error_reporting(0);

    $types = array (1 => "gif", "jpeg", "png");
// Formats Not Supported - To use this feature uncomment the line below 
// (beginning with ($not_supported_formats) and add the files types you do not
// want thumbed.
// $not_supported_formats = array ("GIF"); // Write in capital Letters!!
    umask(0);
    !is_dir ($cachedir)
        ? mkdir ($cachedir, 0777)
        : system ("chmod 0777 ".$cachedir);

      (!isset ($x) || ereg ('^[0-9]{1,}$', $x, $regs)) &&
      (!isset ($y) || ereg ('^[0-9]{1,}$', $y, $regs)) &&
      (isset ($x) || isset ($y))
           ? true
         : DIE ('Fehlende® oder ungültige® Größenparameter!');

    !isset ($resize) || !ereg ('^[0|1]$', $resize, $regs)
         ? $resize = 0
         : $resize;

    !isset ($aspectratio) || !ereg ('^[0|1]$', $aspectratio, $regs)
         ? isset ($x) && isset ($y)
                ? $aspectratio = 1
                : $aspectratio = 0
         : $aspectratio;

    !isset ($image)
         ? DIE ('Es wurde kein Bild angegeben!')
         : !file_exists($image)
              ? DIE ('Die angegebene Datei konnte nicht auf dem Server gefunden werden!')
              : false;

    $imagedata = getimagesize($image);

    !$imagedata[2] || $imagedata[2] == 4 || $imagedata[2] == 5
         ? DIE ('Bei der angegebenen Datei handelt es sich nicht um ein Bild!')
         : false;

 $imgtype="!(ImageTypes() & IMG_" . strtoupper($types[$imagedata[2]]) . ")";
    if ((eval($imgtype)) || (in_array(strtoupper(array_pop(explode('.', basename($image)))),$not_supported_formats))) {
    	$image = substr ($image, (strrpos (DIR_FS_CATALOG . '/', '/'))+1);
 	return $image;

    }

    if (!isset ($x)) $x = floor ($y * $imagedata[0] / $imagedata[1]);


    if (!isset ($y)) $y = floor ($x * $imagedata[1] / $imagedata[0]);

    if ($aspectratio && isset ($x) && isset ($y)) {
	if ((($imagedata[1]/$y) > ($imagedata[0]/$x) )){
		 $x=ceil(($imagedata[0]/$imagedata[1])* $y);
	} else {
		 $y=ceil($x/($imagedata[0]/$imagedata[1]));
	}
    }
    $thumbfile =  '/' . basename($image);
    if (file_exists ($cachedir.$thumbfile)) {
         $thumbdata = getimagesize ($cachedir.$thumbfile);
         $thumbdata[0] == $x && $thumbdata[1] == $y
              ? $iscached = true
              : $iscached = false;
		if (@filemtime($cachedir.$thumbfile) < @filemtime($image))   
		   $iscached = false;
    } else {
         $iscached = false;
    }

    if (!$iscached) {
         ($imagedata[0] > $x || $imagedata[1] > $y) || (($imagedata[0] < $x || $imagedata[1] < $y) && $resize)
              ? $makethumb = true

              : $makethumb = false;
    } else {
         $makethumb = false;
    }



    if ($makethumb) {
         $image = call_user_func("imagecreatefrom".$types[$imagedata[2]], $image);
  if (function_exists("imagecreatetruecolor") && ($thumb = imagecreatetruecolor ($x, $y))) {
	imagecopyresampled ($thumb, $image, 0, 0, 0, 0, $x, $y, $imagedata[0], $imagedata[1]);
  } else {
	$thumb = imagecreate ($x, $y);
	imagecopyresized ($thumb, $image, 0, 0, 0, 0, $x, $y, $imagedata[0], $imagedata[1]);
  }
         call_user_func("image".$types[$imagedata[2]], $thumb, $cachedir.$thumbfile, JPEGQUALITY);
         imagedestroy ($image);
         imagedestroy ($thumb);
         $image = DIR_WS_IMAGES . 'thumbs_cache' . $thumbfile;
    } else {
         $iscached
              ? $image = DIR_WS_IMAGES . 'thumbs_cache' . $thumbfile
              : $image = substr ($image, (strrpos (DIR_FS_CATALOG . '/', '/'))+1);
    }
return $image;
}
?>

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...