Jump to content

glumpy

Members
  • Content count

    121
  • Joined

  • Last visited

  1. Hi just a quick question if im using Ultimate SEO URL what is my base url for the products listing, Im trying to use a RSS Feed and it requires your base url for products now that its changed it wouldnt be http://www.mysite.com/product_info.php?products_id= thanks
  2. glumpy

    Easy Discount

    Hi Just wanting to find out. I have added all is required in the install txt I have also added on the bottom of my application_top this include (DIR_WS_MODULES.'easy_coupons_code.php'); if ($cart->count_contents() > 0) { // cart contents $easy_discount->add('OST','10% discount of Sub Total',$cart->show_total()*0.1); // 10% of cart total } else{ $easy_discount->remove_type('OST'); // remove discount if present and cart gets empty } which should give a 10 % discount for people that put there coupon code in.. I am getting a little mixed up because i thought u can set this in your administrator area. If you manually give people a discount code ? I tried this from Boxtel's ealier post for someone and it didnt work I typed in the code i manually put in the adminiistrator area in.. and in the shopping cart after clicking cash in coupon.. nothing.. it just went back to the shopping cart with no discount or anything.. I have no idea what im doing wrong please help me out thanks greg
  3. i think its taking away the www. at the start .. cause i looked into error 10 it says this : URL not allowed Google has detected some URLs that appear to be at a higher level or different domain than the Sitemap file location. If you receive this error, try moving your Sitemap file to a higher location in your site and submitting again. For instance, if your Sitemap is listed under http://www.example.com/mysite/sitemap.xml, the following URLs are not valid for that sitemap * http://www.example.com/ - it's at a higher level than the Sitemap * http://www.example.com/yoursite/ - it's in a directory parallel to the Sitemap You should also check that the urls all begin with the same domain as your Sitemap location. For instance, if your sitemap is listed under http://www.example.com/sitemap.xml, the following URLs are not valid for that sitemap: * http://www.google.com - it's in the google.com domain rather than the example.com domain * http://example.com/ - it's missing the initial www * www.example.com/ - it's missing the protocol (http) * https://www.example.com/ - it's using a different protocol (https rather than http) Any URLs in the Sitemap that are not denied are processed normally. any ideas how to fix thanks greg
  4. Hi, I have installed this contribution.. It loaded well no probems. I then went to google and added the sitemap locations sitemapindex.xml was ok and loaded fine but google came back saying " ERROR 10 " in sitemapcategories.xml it said : URL not allowed (Line 3) with URL http://www.onestopadultshop.com/link/dvds-c-85.html This url is not allowed for a Sitemap at this location URL not allowed (Line 15) with URL http://onestopadultshop.com/link/books-c-84.html This url is not allowed for a Sitemap at this location. and so on and in sitemapproducts.xml it said " ERROR 10" URL not allowed (Line 51) with URL http://onestopadultshop.com/link/over-lovers-p-1649.html This url is not allowed for a Sitemap at this location. More URL not allowed (Line 21) with URL http://onestopadultshop.com/link/first-smi...ink-p-1288.html This url is not allowed for a Sitemap at this location. More what is the problem why am i getting these error 10's and how do i fix it? thanks greg
  5. Hi , i installed Ultimate SEO url contribution it works but i think something is wrong. When you try to add products to your cart . it goes to the page where your cart is but it says there is nothing in your cart. whereever you get a product it still doesnt show up in your cart no one can buy stuff at the moment are you able to tell me what the problem is thanks greg www.onestopadultshop.com
  6. Hi , i installed Ultimate SEO url contribution it works but i think something is wrong. When you try to add products to your cart . it goes to the page where your cart is but it says there is nothing in your cart. whereever you get a product it still doesnt show up in your cart no one can buy stuff at the moment are you able to tell me what the problem is thanks greg www.onestopadultshop.com
  7. ok so i just change the bottom one back to case 'now()': $query .= 'now(), '; case 'null': $query .= $columns .= ' = null, '; break; is that right?
  8. this also happens when a customer wants to buy a product, they click on confirm order and it comes up with this : 1064 - 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 '), '2102', 'AUD', '1.00000000')' at line 1 insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values ('36', 'greg burridge', '', '7 test rd', '', 'brisbane', '4000', '', 'Australia', '61407282810', 'support@onestopadultshop.com', '1', 'greg test', '', '7 test rd', '', 'brisbane', '4000', '', 'Australia', '1', 'greg test', '', '7 test rd', '', 'brisbane', '4000', '', 'Australia', '1', 'Bank Transfer Payment', '', '', '', '', date_add(now(), INTERVAL HOUR), '2102', 'AUD', '1.00000000') [TEP STOP] no idea whats going on
  9. and catalog/admin/includes/functions/database.php <?php /* $Id: database.php,v 1.23 2003/06/20 00:18:30 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') { global $$link; if (USE_PCONNECT == 'true') { $$link = mysql_pconnect($server, $username, $password); } else { $$link = mysql_connect($server, $username, $password); } if ($$link) mysql_select_db($database); return $$link; } function tep_db_close($link = 'db_link') { global $$link; return mysql_close($$link); } function tep_db_error($query, $errno, $error) { die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>'); } function tep_db_query($query, $link = 'db_link') { global $$link, $logger; if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) { if (!is_object($logger)) $logger = new logger; $logger->write($query, 'QUERY'); } $result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error()); if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) { if (mysql_error()) $logger->write(mysql_error(), 'ERROR'); } return $result; } function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') { reset($data); if ($action == 'insert') { $query = 'insert into ' . $table . ' ('; while (list($columns, ) = each($data)) { $query .= $columns . ', '; } $query = substr($query, 0, -2) . ') values ('; reset($data); while (list(, $value) = each($data)) { switch ((string)$value) { case 'now()': // Added a time offset function here $query .= 'date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR), '; break; case 'null': $query .= 'null, '; break; default: $query .= '\'' . tep_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ')'; } elseif ($action == 'update') { $query = 'update ' . $table . ' set '; while (list($columns, $value) = each($data)) { switch ((string)$value) { case 'now()': // Added a time offset function here $query .= 'date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR), '; break; case 'null': $query .= $columns .= ' = null, '; break; default: $query .= $columns . ' = \'' . tep_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ' where ' . $parameters; } return tep_db_query($query, $link); } function tep_db_fetch_array($db_query) { return mysql_fetch_array($db_query, MYSQL_ASSOC); } function tep_db_result($result, $row, $field = '') { return mysql_result($result, $row, $field); } function tep_db_num_rows($db_query) { return mysql_num_rows($db_query); } function tep_db_data_seek($db_query, $row_number) { return mysql_data_seek($db_query, $row_number); } function tep_db_insert_id() { return mysql_insert_id(); } function tep_db_free_result($db_query) { return mysql_free_result($db_query); } function tep_db_fetch_fields($db_query) { return mysql_fetch_field($db_query); } function tep_db_output($string) { return htmlspecialchars($string); } function tep_db_input($string) { return addslashes($string); } function tep_db_prepare_input($string) { if (is_string($string)) { return trim(stripslashes($string)); } elseif (is_array($string)) { reset($string); while (list($key, $value) = each($string)) { $string[$key] = tep_db_prepare_input($value); } return $string; } else { return $string; } } ?>
  10. catalog/includes/functions/database.php <?php /* $Id: database.php,v 1.21 2003/06/09 21:21:59 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') { global $$link; if (USE_PCONNECT == 'true') { $$link = mysql_pconnect($server, $username, $password); } else { $$link = mysql_connect($server, $username, $password); } if ($$link) mysql_select_db($database); return $$link; } function tep_db_close($link = 'db_link') { global $$link; return mysql_close($$link); } function tep_db_error($query, $errno, $error) { die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>'); } function tep_db_query($query, $link = 'db_link') { global $$link; if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) { error_log('QUERY ' . $query . "\n", 3, STORE_PAGE_PARSE_TIME_LOG); } $result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error()); if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) { $result_error = mysql_error(); error_log('RESULT ' . $result . ' ' . $result_error . "\n", 3, STORE_PAGE_PARSE_TIME_LOG); } return $result; } function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') { reset($data); if ($action == 'insert') { $query = 'insert into ' . $table . ' ('; while (list($columns, ) = each($data)) { $query .= $columns . ', '; } $query = substr($query, 0, -2) . ') values ('; reset($data); while (list(, $value) = each($data)) { switch ((string)$value) { case 'now()': // Added a time offset function here $query .= 'date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR), '; break; case 'null': $query .= 'null, '; break; default: $query .= '\'' . tep_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ')'; } elseif ($action == 'update') { $query = 'update ' . $table . ' set '; while (list($columns, $value) = each($data)) { switch ((string)$value) { case 'now()': // Added a time offset function here $query .= 'date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR), '; break; case 'null': $query .= $columns .= ' = null, '; break; default: $query .= $columns . ' = \'' . tep_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ' where ' . $parameters; } return tep_db_query($query, $link); } function tep_db_fetch_array($db_query) { return mysql_fetch_array($db_query, MYSQL_ASSOC); } function tep_db_num_rows($db_query) { return mysql_num_rows($db_query); } function tep_db_data_seek($db_query, $row_number) { return mysql_data_seek($db_query, $row_number); } function tep_db_insert_id() { return mysql_insert_id(); } function tep_db_free_result($db_query) { return mysql_free_result($db_query); } function tep_db_fetch_fields($db_query) { return mysql_fetch_field($db_query); } function tep_db_output($string) { return htmlspecialchars($string); } function tep_db_input($string) { return addslashes($string); } function tep_db_prepare_input($string) { if (is_string($string)) { return trim(tep_sanitize_string(stripslashes($string))); } elseif (is_array($string)) { reset($string); while (list($key, $value) = each($string)) { $string[$key] = tep_db_prepare_input($value); } return $string; } else { return $string; } } ?>
  11. Guys I am completely confused with this timezone patch. I have added it now when I add products (in categories) it says this : 1064 - 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 'date_add(now(), INTERVAL -h,4 HOUR) where products_id = '1579'' update products set products_quantity = '50', products_model = '0340220016', products_price = '49.9500', products_date_available = null, products_weight = '0.00', products_status = '1', products_tax_class_id = '1', manufacturers_id = '', products_image = 'test.jpg', date_add(now(), INTERVAL -h,4 HOUR) where products_id = '1579' [TEP STOP] what is the problem with my sql? and how do i fix it look forward to your reply
  12. Guys I am completely confused with this timezone patch. I have added it now when I add products (in categories) it says this : 1064 - 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 'date_add(now(), INTERVAL -h,4 HOUR) where products_id = '1579'' update products set products_quantity = '50', products_model = '0340220016', products_price = '49.9500', products_date_available = null, products_weight = '0.00', products_status = '1', products_tax_class_id = '1', manufacturers_id = '', products_image = 'test.jpg', date_add(now(), INTERVAL -h,4 HOUR) where products_id = '1579' [TEP STOP] what is the problem with my sql? and how do i fix it look forward to your reply
  13. glumpy

    Credit cards not being accepted

    worked like a champion thanks amanda. greg
  14. glumpy

    Credit cards not being accepted

    Hey guys, I know this question has been asked many times through the forum.. But im still a little bit confused with the credit card module. I see in cc_validation.php it has listed the accepted 4 first digits and then allocates it to the correct type of card may it be ( mastercard, visa .. or whatever ) but I do not want this checking. I just want it to accept all card numbers because i manually process the order. I have made these changes in cc_validation.php but still not working.. can someone help me.. i think i screwed sumfin up.. function validate($number, $expiry_m, $expiry_y, $cvv2) { $this->cc_number = ereg_replace('[^0-9]', '', $number); if (ereg('^4[0-9]{12}([0-9]{3})?$', $this->cc_number)) { $this->cc_type = 'Visa'; } elseif (ereg('^5[1-5][0-9]{14}$', $this->cc_number)) { $this->cc_type = 'Master Card'; } elseif (ereg('^3[47][0-9]{13}$', $this->cc_number)) { $this->cc_type = 'American Express'; } elseif (ereg('^3(0[0-5]|[68][0-9])[0-9]{11}$', $this->cc_number)) { $this->cc_type = 'Diners Club'; } elseif (ereg('^6011[0-9]{12}$', $this->cc_number)) { $this->cc_type = 'Discover'; } elseif (ereg('^(3[0-9]{4}|2131|1800)[0-9]{11}$', $this->cc_number)) { $this->cc_type = 'JCB'; } elseif (ereg('^5610[0-9]{12}$', $this->cc_number)) { $this->cc_type = 'Australian BankCard'; } else { return -1; } if (is_numeric($expiry_m) && ($expiry_m > 0) && ($expiry_m < 13)) { $this->cc_expiry_month = $expiry_m; } else { return -2; } i thought : } else { return -1; } makes it accept any card.. hrmmm well it sure didnt work still.. its still fussy when it comes to accepting the right kinda card... looking for a quick easy fix.. come on php guys.. help me out ta grego
  15. glumpy

    Problem with Credit Card with CVV2

    Hey guys... Having problems trying to figure out what i did wrong when i added CVV2 onto my credit card module. I am now getting this when you select credit card : Credit Card Credit Card Owner: Credit Card Number: MODULE_PAYMENT_CC_TEXT_CREDIT_CARD_CVV2 Credit Card Expiry Date: why doesnt it just say CVV2 or something like that.. havent been game to test it out yet.. can someone tell me how to change this.. and if i change it will it stuff everything up.. keep me posted.. you php crazy ass coders still are up there with mcdonalds. ta greg
×