Jump to content

olsonsp4c

Members
  • Content count

    545
  • Joined

  • Last visited

Everything posted by olsonsp4c

  1. olsonsp4c

    phpbb 2.015

    Hello, when I go to the admin part of phpbb, I get this error: Fatal error: Cannot redeclare tep_db_connect() (previously declared in /home/p4x/www/p4xworship/admin/includes/functions/database.php:13) in /home/p4x/www/p4xworship/admin/includes/functions/database.php on line 13 any thoughts? thanks! Scott
  2. olsonsp4c

    phpbb 2.015

    Not yet, I've contacted a number of people about it and have not figured it out. I do know that bbdefault is calling applicationtop twice, but if I comment out the include(...$file) line, I get a different error about ksort() which no one seems to be able to fix. Also, I've tried going to applicationtop and changing all require to require_once and it "works" without error but then pulls the wrong page in the left frame - the index.php admin page for oscommerce ends up in the frame rather than the phpbb nav menu. if you figure it out, lots of people would be very happy! thanks! a confuser for me is that it actually used to work and then quit working for no reason! Scott
  3. olsonsp4c

    phpbb 2.015

    Thanks Matti, I looked in catalog/admin/includes/languages + same/english + in the phpbb2 installation zip there were no files for php to be copied into those directories in the admin side of phpbb. the file it's trying to load for the phpbb is bb_default.php; however, this file is in admin/ The bb_default file is in frames on the page. Left frame is a menu, right frame is the selected menu options. the right frame shows. the left frame shows the error. any thoughts? thanks! Scott
  4. olsonsp4c

    phpbb 2.015

    Thanks Mark, I tried this and there were no blank lines - still get the same error. I can't figure it out. It's saying that it's recalling the same line 2x... Scott
  5. olsonsp4c

    Thumbnail PDF Catalogue

    Hello, I love this contrib... I'm having two minor issues with this contribution: 1. the same issue as previously mentioned in regard to transparent gifs showing thumbnailed with black backgrounds. I did change all pixel_black.gif mentions in html_output.php to pixel_trans.gif with no impact. All images are larger than the small image height/width set in the admin as well. 2. There are two recurring misc. characters that appear in the pdf: """ and "&" and "?" Any thoughts? thanks! Scott
  6. I was able to get it working after several tries, I found the instructions to be somewhat confusing and in my opinion need to be re-written. ***It would help me if, rather than making criticisms and giving opinions, if you would make suggestions as to how the instructions could be made more clear. Also, when trying to copy/paste the lines for "fedex_track_num, ups_track_num, and usps_track_num" it was giving me errors, but if I just inserted it into the existing line of code it worked fine. ***This would be the case if another mod was made to these lines through the installation of another contribution. This is why I noted that these three aspects are the only changes. As a contribution it's great, as for installition, I think it needs some fine tuning. ***I'm certainly am glad it is of use as I am not a coder but figured out what mods I made by logic. It could use some fine tuning by somebody that actually knows what they are doing in php. Maybe you could help. I'm currently trying to add dhl support per the suggestion of another user. again, thanks for using my contrib. Scott
  7. Let me try that again: tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments) . "')"); $order_updated = true; } if (tep_not_null($ups_track_num)) { tep_db_query("update " . TABLE_ORDERS . " set ups_track_num = '" . tep_db_input($ups_track_num) . "' where orders_id = '" . tep_db_input($oID) . "'"); $order_updated = true; } if (tep_not_null($usps_track_num)) { tep_db_query("update " . TABLE_ORDERS . " set usps_track_num = '" . tep_db_input($usps_track_num) . "' where orders_id = '" . tep_db_input($oID) . "'"); $order_updated = true; } if (tep_not_null($fedex_track_num)) { tep_db_query("update " . TABLE_ORDERS . " set fedex_track_num = '" . tep_db_input($fedex_track_num) . "' where orders_id = '" . tep_db_input($oID) . "'"); $order_updated = true; } if ($order_updated == true) { $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success'); } else { $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning'); } tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=edit')); break; case 'deleteconfirm': $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); tep_remove_order($oID, $HTTP_POST_VARS['restock']); tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')))); break; } } Scott
  8. Hello, Unless you purposefully modified this file, it should look like this after the mod is pasted: tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments) . "')"); $order_updated = true; } if (tep_not_null($ups_track_num)) { tep_db_query("update " . TABLE_ORDERS . " set ups_track_num = '" . tep_db_input($ups_track_num) . "' where orders_id = '" . tep_db_input($oID) . "'"); $order_updated = true; } if (tep_not_null($usps_track_num)) { tep_db_query("update " . TABLE_ORDERS . " set usps_track_num = '" . tep_db_input($usps_track_num) . "' where orders_id = '" . tep_db_input($oID) . "'"); $order_updated = true; } if (tep_not_null($fedex_track_num)) { tep_db_query("update " . TABLE_ORDERS . " set fedex_track_num = '" . tep_db_input($fedex_track_num) . "' where orders_id = '" . tep_db_input($oID) . "'"); $order_updated = true; } if ($order_updated == true) { $messageStack->add_session(SUCCESS_ORDER_UPDATED, 'success'); } else { $messageStack->add_session(WARNING_ORDER_NOT_UPDATED, 'warning'); } tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('action')) . 'action=edit')); break; case 'deleteconfirm': $oID = tep_db_prepare_input($HTTP_GET_VARS['oID']); tep_remove_order($oID, $HTTP_POST_VARS['restock']); tep_redirect(tep_href_link(FILENAME_ORDERS, tep_get_all_get_params(array('oID', 'action')))); break; } } hope this helps scott
  9. olsonsp4c

    Sales Report 2

    Hello - Maybe some one else has this problem. I have installed Sales Report 2. It looks to be installed correctly; however, when I click my different options for the report and click "Send", I am booted out to my admin login screen and no file is downloaded, no popup, etc... I then re-login and nothing happens either - no download, no popup. Any thoughts? Thanks! thanks! Scott
  10. olsonsp4c

    Sales Report 2

    I also seem to have the same identical problem after installing osplayer. So, I would conclude that it has something to do with accessing the file structure because sales report 2 creates a file for export and osplayer is trying to creat a directory. In both cases I'm booted out to my admin login screen. Please - any help? Since I am a CD store - i need the mp3 preview to work... thanks! Scott
  11. olsonsp4c

    Help with Coding

    To clarify my intent... What I would like it to do is to: 1. Email the customer when the status changes 2. Email the customer when 1 or multiple tracking numbers are added If there is a status change without a tracking number(s), I need and email sent that does have the current status and does not have the tracking message and link in the message. If there is a status change with a tracking number(s), I need an email sent that does have the current status and does have the tracking message and link in the message If there is no status change but I've added 1 or more tracking numbers, I need an email sent that does have the current status and does have the tracking message and link in the message. Thanks! Scott :D
  12. olsonsp4c

    Help with Coding

    Is there a coder out there who could analyze this code to tell me if it is functioning to do the following? I'm trying to integrate the package [ups,usps,fedex] tracking contrib (html) with the email subject order number status contrib. It currently will send and email when I update the order status, which is good; however, when I add a tracking number to the order and click update it gives me a message saying that the order was updated correctly but an email was not sent to the customer. Below is the hack I have so far within catalog/admin/orders.php: -------------------------- $customer_notified = '0'; if ($HTTP_POST_VARS['notify'] == 'on' & $ups_track_num == '' & $fedex_track_num == '' & $usps_track_num == '' ) { $notify_comments = ''; if ($HTTP_POST_VARS['notify_comments'] == 'on') { $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n"; } $email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "\n\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT_1. $oID . EMAIL_TEXT_SUBJECT_2 . $orders_status_array[$status], $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); $customer_notified = '1'; }elseif ($HTTP_POST_VARS['notify'] == 'on' & ($ups_track_num == '' or $fedex_track_num == '' or $usps_track_num == '') ) { $notify_comments = ''; if ($HTTP_POST_VARS['notify_comments'] == 'on') { $notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n"; } $email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "\n\n\n" . EMAIL_TEXT_TRACKING_NUMBER . ' ' . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); tep_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT_1. $oID . EMAIL_TEXT_SUBJECT_2 . $orders_status_array[$status], $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); $customer_notified = '1'; } ----------------------------- Thanks for any help you can provide so I can get the emails sent properly with tracking info to my customers.... Scott :thumbsup:
×