Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Criz

Archived
  • Posts

    50
  • Joined

  • Last visited

About Criz

  • Birthday 06/18/1973

Profile Information

  • Real Name
    Christiaan
  • Location
    Tel Aviv, Israel
  • Website

Criz's Achievements

  1. Dear Daggy, in your sql admin, you must look for a field called query of process. I use blacksql and have this line: Run SQL query/queries on database. Here you get a window, you paste the lines (the lines are actually sql commands) in there and press Go. Then it automatically generates the new tables etc. But be carefull, things can go pretty wrong when you mess with you database. Make sure you have a recent backup. Hope this helps you out. Regards, Chris
  2. Dear All, I hope someone can help me out with the following problem, as I have seen other people write about it, but did not read any solution. I have installed the contribution and for now it seems to work fine, but when I log in as an affiliate, it loads page 'affiliate_summary.php' and i get the following error message: Fatal error: Call to a member function on a non-object in /sites/crown-of-thorns.com/htdocs/affiliate_summary.php on line 108 I have the following code at line 108: <?php if ($messageStack->size('account') > 0) { ?> I have no idea what the problem could be (also don't really understand this coding ;) ) Could anyone help me out please, as this contribution seems to be great and I cannot wait to start using it. Thanks and regards, Chris
  3. Sorry, found it, had to read the instruction manual better :wub: Learned my lesson, Regards, Chris
  4. Sorry guys, I am talking about the Affiliate Contribution. Pressed new topic instead of reply. Maybe some 'team member' could move this post to current topic on this contribution. Regards, Chris
  5. Dear All, I hope someone can help me out with the following problem, as I have seen other people write about it, but did not read any solution. I have installed the contribution and for now it seems to work fine, but when I log in as an affiliate, it loads page 'affiliate_summary.php' and i get the following error message: Fatal error: Call to a member function on a non-object in /sites/crown-of-thorns.com/htdocs/affiliate_summary.php on line 108 I have the following code at line 108: <?php if ($messageStack->size('account') > 0) { ?> I have no idea what the problem could be (also don't really understand this coding ;) ) Could anyone help me out please, as this contribution seems to be great and I cannot wait to start using it. Thanks and regards, Chris[/color]
  6. Hi, I have just installed the contribution osCAffiliate v2.02. I do not know how to change the basic settings like the commission rate. <_< I would appreciate it if anyone could point me in the right direction. Are there any other menus or directions that I should know about changing other settings of the affiliate program. Even better, is there some kind of manual available? Thanks and regards, Chris
  7. Ross, I have added the code you provided. It does not seem to work for me, although the codes looks ok. When I changed the code to your code, nothing happened. When I entered something in products_head_title_tag in TABLE_PRODUCTS_DESCRIPTION it still pulled in the date from there and not from the products_name. I looked into it, but did not find an answer yet. Maybe you can help me out. Thanks, Chris
  8. Dear Linda, I have taken a look at the adminstration tool and will for sure install. But my point/question was not about that. When I installed your contribution, it automatically generated header tags for all the current products in my dbase. Is that something happening only when I install the contribution? Or does that also need to happen when adding new products. After installing, all the product pages had the product name in the page title, exactly like I wished it would be. The new products do not have the product name in the page title. Could you please shed a light on this matter? Thanks, Chris
  9. Hi Ross, Thanks for your reaction. All the products in my dbase got automatically the Title tag, generated by Header Tag Controller. The strange thing is, that it doesn't work for new products. In my opinion it should work also for new products. I definitely look into the codes you supplied. Regards, Chris
  10. Hello, I have installed the Header Tag Controller mod, which is working great. I currently have one problem. When I add new products, it seems like the Header Tag Controller is not generating Page Titles for these new product pages. Can anyone help me out here? Thanks, Chris
  11. Hi Everyone! I would like to grab the ip address of customers placing an order (in order to further prevent fraud). I ran into the contribution IP Address Collector v1.0. If anyone has other suggestions for grabbing an ip address :wink: more than welcome. If not, please help me out with the problem below. I am installing it at this moment, but I am experiencing some problems when editing orders.php. I have to replace a piece of code with a new one. It is not clear for me what I exactly need to replace, because the code structure looks really different. Following I include the new code I have to put in the file (located around line 50) // NEW TEP_DB_QUERY ADDED BY BURT - REPLACE THE OLD ONE tep_db_query("insert into " . TABLE_ORDERS . " (customers_id, customers_name, 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_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, comments, currency, currency_value, ip_address) values ('" . $customer_id . "', '" . $order->customer['firstname'] . ' ' . $order->customer['lastname'] . "', '" . $order->customer['street_address'] . "', '" . $order->customer['suburb'] . "', '" . $order->customer['city'] . "', '" . $order->customer['postcode'] . "', '" . $order->customer['state'] . "', '" . $order->customer['country'] . "', '" . $order->customer['telephone'] . "', '" . $order->customer['email_address'] . "', '" . $order->customer['format_id'] . "', '" . $order->delivery['firstname'] . ' ' . $order->delivery['lastname'] . "', '" . $order->delivery['street_address'] . "', '" . $order->delivery['suburb'] . "', '" . $order->delivery['city'] . "', '" . $order->delivery['postcode'] . "', '" . $order->delivery['state'] . "', '" . $order->delivery['country'] . "', '" . $order->delivery['format_id'] . "', '" . $order->info['payment_method'] . "', '" . $order->info['cc_type'] . "', '" . $order->info['cc_owner'] . "', '" . $order->info['cc_number'] . "', '" . $order->info['cc_expires'] . "', now(), '" . DEFAULT_ORDERS_STATUS_ID . "', '" . addslashes($order->info['comments']) . "', '" . $order->info['currency'] . "', '" . $order->info['currency_value'] . "', '" . $ip . "')"); // END BURT This is the current code I have around that line: $sql_data_array = array('customers_id' => $customer_id, 'customers_name' => $order->customer['firstname'] . ' ' . $order->customer['lastname'], 'customers_street_address' => $order->customer['street_address'], 'customers_suburb' => $order->customer['suburb'], 'customers_city' => $order->customer['city'], 'customers_postcode' => $order->customer['postcode'], 'customers_state' => $order->customer['state'], 'customers_country' => $order->customer['country']['title'], 'customers_telephone' => $order->customer['telephone'], 'customers_email_address' => $order->customer['email_address'], 'customers_address_format_id' => $order->customer['format_id'], 'delivery_name' => $order->delivery['firstname'] . ' ' . $order->delivery['lastname'], 'delivery_street_address' => $order->delivery['street_address'], 'delivery_suburb' => $order->delivery['suburb'], 'delivery_city' => $order->delivery['city'], 'delivery_postcode' => $order->delivery['postcode'], 'delivery_state' => $order->delivery['state'], 'delivery_country' => $order->delivery['country']['title'], 'delivery_address_format_id' => $order->delivery['format_id'], 'payment_method' => $order->info['payment_method'], 'cc_type' => $order->info['cc_type'], 'cc_owner' => $order->info['cc_owner'], 'cc_number' => $order->info['cc_number'], 'cc_expires' => $order->info['cc_expires'], 'date_purchased' => 'now()', 'orders_status' => DEFAULT_ORDERS_STATUS_ID, 'comments' => $order->info['comments'], 'currency' => $order->info['currency'], 'currency_value' => $order->info['currency_value']); tep_db_perform(TABLE_ORDERS, $sql_data_array); $insert_id = tep_db_insert_id(); for ($i=0; $i<sizeof($order_totals); $i++) { $sql_data_array = array('orders_id' => $insert_id, 'title' => $order_totals[$i]['title'], 'text' => $order_totals[$i]['text'], 'value' => $order_totals[$i]['value'], 'class' => $order_totals[$i]['code'], 'sort_order' => $order_totals[$i]['sort_order']); tep_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array); } $customer_notification = (SEND_EMAILS == 'true') ? '1' : '0'; $sql_data_array = array('orders_id' => $insert_id, 'new_value' => DEFAULT_ORDERS_STATUS_ID, 'date_added' => 'now()', 'customer_notified' => $customer_notification); tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array); Please help me out here, and sorry for the mess with all the codes :wink: Thanks, Chris
  12. For now finished installing, disabled a few things, changed some lay-out issues, edited some text and it seems to work fine now.:D If anyone has a question, just let me know. Regards, Chris
  13. An update while installing: When using the update function in the newsletter admin, that will synchronize the data between the customers table and the subscribers table, I got an error message, stating that p.customers_blacklist was not found. After deleting p.customers_blacklist, on line 214 in the file newsletter_update.php everything worked ok, and it updated the subcribers info with the customers info. Chris
  14. Hi Folks, I am just installing a neat contribution that you can find here: http://www.oscommerce.com/downloads.php/co...ions,741/type,3 It looks like a good addon and I encountered some issues when installing, while I am installing I will post here a few things I ran into. 1) do not just copy the product_info.php into your directory. I kept my old one and it seems to work fine. Maybe someone can explain me what the 'new' file in the contribution ads. 2) Some files use a specific 'class' for example in newsletter_subscription.php, it looks like this: include "includes/classes/snoopy1.class.php"; if you don't have this class defined it will generate error, so or delete this line or put // before the line to disable it. For now it seems to work fine, just take a look at the images, some need to be added or updated. And of course don't forget to edit your own text. Regards, Chris
  15. You can find her contribution here: http://www.oscommerce.com/downloads.php/co...ions,311/type,5 Regards, Chris
×
×
  • Create New...