Jump to content

Demitry

Members
  • Content count

    288
  • Joined

  • Last visited

  • Days Won

    8

Everything posted by Demitry

  1. Demitry

    [Addon} Theme Switcher

    ok, good point, ..thanks Jim So, where do I change the layout for,.. lets say the header? Is it in the /includes/modules/content/header/templates/... and related CSS classes? Where is all this compiled?, on the individual page? or is there a grid of some sort that is sectioned into zones? Still struggling with the new structure.
  2. Demitry

    [Addon} Theme Switcher

    I can work with css, but I was looking more to re-positioning the divs and recreating the layout structure for the header, footer, menu, and main body. The default layout is nice, but plain and the Theme Switcher only changes the layout colors.
  3. Demitry

    [Addon} Theme Switcher

    Thanks Frank, ..any documentation on customizing the header and footer? I'm still trying to get familiarized with the file structure and code.
  4. Demitry

    [Addon} Theme Switcher

    Actually a couple of other changes in that /includes/template_top.php file with the jquery version and the font-awesome style-sheet version.
  5. Demitry

    [Addon} Theme Switcher

    Hi, I just installed it and the instructions mention only the one line change in the /includes/template_top.php file, however, I noticed that there was another change made. The viewport meta tag had the following content attribute removed in the add-on file: shrink-to-fit=no If this is a needed change, the instruction documentation should be updated. Also, possibly in a future release, it would be good to have a preview of each theme in admin because as of right now, you have to change it, save it, and then go to the home page and refresh it. Even a selection of screenshot thumbs would be good on that admin page. I was really looking to change the layout some like that of the header, footer, menu and main body. I'm not sure if there is an addon for this or any documentation on how to customize these areas. Any help would be greatly appreciated. Thanks.
  6. ok, Finally! The Issue was resolved. I'll tell you,.. I still don't have an idea as to what was happening because I could not get the osC auto-installer to connect to the database in the first step of the installation. So, here is what I did to get this resolved. My hosting company has an auto installer called, Softaculous Apps Installer. I used this to install osC v2.3.4.1 (because they don't have BS-Edge) on a sub-domain called "test." I did this because I wanted to know if I was going to experience the same problems and also because I wanted to pull both configuration files from it for review. Meanwhile, I had my v2.3.4-BS-Edge installed on another sub-domain called "dev2" with that issue where the admin page was not redirecting properly and would not load. After installing osC v2.3.4.1, I went to the site (test.mydomain.com/) and was greeted with the same osC auto-installation window. I entered the information in the first step of the install (database server, user name, password, database name) and again, the connection was stuck. So, I went and pulled both configuration files to see what was going on. To my surprise, Softaculous Apps Installer created a database, user-name, and password for this new install, while BS-Edge did not. I'm not sure if this is supposed to happen or not, but for the BS-Edge installation I created the database in the C-Panel before initiating the install. So in those two configuration files, I changed the database information to the one I had already created for BS-Edge and changed the appropriate sub-domain name and then uploaded both configuration files to the dev2 (BS-Edge) installation. Now, everything seems to work properly. In summary, I think if anyone else runs into a similar odd-ball issue with the auto-installer via database connectivity or cannot access the admin login page due to a redirect loop, it is a good idea to try and install the same or latest version of the software on another sub-domain. Then change the directory path in both configuration files and use those files in the original install. I had a tough time finding how these configuration files should be set-up and most people would not need to see this information because the auto-installer automatically writes to these files. A big thank you to everyone here for their help. Demitry
  7. Jim, Thank you for the reply. I will definitely try that as well, though hosting tech support says there are no redirects on that sub-domain. ..and I did not create a redirect in the C-Panel when I created that sub-domain. I've actually never used that redirect feature when creating a sub-domain.
  8. no, my hosting tech support said there are no redirects on that sub-domain, but I do need to try that cookie path change. I also noticed that v2.3.4.1 does not have a directive for the Header unset ETag. I'm not sure what the ETag is for but the htaccess file for the BS-Edge does have this directive. I am installing v2.3.4.1 now so I will try it with and without that htaccess mod. Thank you so much for taking the time to install this on your own server to test this issue.
  9. yeah, I tried FF, Chrome, and IE. Nothing is working. I will try v2.3.4.1 now and then try the most basic user name and password and simplest database name. I activated error logs and nothing was reporting and my hosting company tech support has no idea other than blaming it on the software.
  10. Hi Frank, Thank you for the reply and the online header sniffer tools. I created another sub-domain called "dev2" and installed 2.3.4-BS-Edge on it without changing the admin folder name. I also reinstalled or re-created the database in the C-Panel and ran the SQL file in phpMyAdmin. I tried to go through the auto-install, but it got stuck on the first step in trying to connect to the database. So, I manually filled out the two configure.php files and uploaded them. The admin section has the same issue and when I try to install it via the auto-installer, it still gets stuck on that first step in connecting to the database. The catalog part is also unable to connect to the database though the home page displays with all the test products. I renamed the main htaccess file in the main/parent account to eliminate it as the cause that might affecting any & all other folders & sub-domains, and it is not the cause of this issue. I went to web-sniffer and the site was not pulling up so I tried the suggested alternative site, http://testuri.org/sniffer and I also ran this same page on https://httpstatus.io/ the screenshots are attached, but other than seeing that there is a 302 redirect on it, I cannot figure it out from this data. Is there anything that points to a cause from this info? Next, I will try to install a clean 2.3.4.1 version to see if I gets the same issue. This will tell me if it is a BS-Edge bug or some issue with my server configuration or database user name and password. I did think that there may be an issue with the user name and password, because I am using underscore in the user name and a couple of special characters in the password. If the new BS-Edge is coded to strip those, then it would certainly cause a connectivity issue. However, this does not explain the redirecting. I also looked at the tep_db_connect() function in BS-Edge and in the newest osC v2.3.4.1 and there is only one line difference, which I don't think is the issue.
  11. Hi Manfred, I did try it that way at first, but it was not working and I kept getting the same page error. What I posted was the latest version of it... after trying everything I could to get that admin login page to load. I changed those variables because I thought they may be causing the problem by using the mydomain instead of the test sub-domain. So, I figured I would define the direct path. I'd love to know of a tool that could pin-point this problem. If you're saying it is not the /admin/includes/configure.php file,.. then it has to be something else.
  12. ok, thank you Rainer. Please keep in mind that this is a sub-domain... a folder inside of another folder, as in /myAccountName/other_sites/test/ that can be accessed from a browser as test.mydomain.com <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2014 osCommerce Released under the GNU General Public License */ // define our webserver variables // FS = Filesystem (physical) // WS = Webserver (virtual) define('HTTP_SERVER', 'http://test.mydomain.com'); // eg, http://localhost or - https://localhost should not be NULL for productive servers define('HTTPS_SERVER', 'http://test.mydomain.com'); define('ENABLE_SSL', false); define('HTTP_COOKIE_DOMAIN', '/'); define('HTTPS_COOKIE_DOMAIN', ''); define('HTTP_COOKIE_PATH', '/'); define('HTTPS_COOKIE_PATH', ''); define('HTTP_CATALOG_SERVER', 'http://test.mydomain.com'); define('HTTPS_CATALOG_SERVER', ''); define('ENABLE_SSL_CATALOG', false); // secure webserver for catalog module //define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs) define('DIR_FS_DOCUMENT_ROOT', '/home/myAccountName/public_html/other_sites/test/'); define('DIR_WS_ADMIN', '/admin/'); define('DIR_WS_HTTPS_ADMIN', '/admin/'); //define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN); define('DIR_FS_ADMIN', '/home/myAccountName/public_html/other_sites/test/admin/'); define('DIR_WS_CATALOG', '/'); define('DIR_WS_HTTPS_CATALOG', '/'); //define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG); define('DIR_FS_CATALOG', '/home/myAccountName/public_html/other_sites/test/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); // define our database connection define('DB_SERVER', 'localhost'); define('DB_SERVER_USERNAME', '*********'); define('DB_SERVER_PASSWORD', '*********'); define('DB_DATABASE', '*********'); define('USE_PCONNECT', 'false'); define('STORE_SESSIONS', 'mysql'); ?>
  13. Hi, I installed the 2.3.4-BS-Edge on a sub-domain and renamed the admin folder. The site comes up fine, but the admin login page gives a "The page isn’t redirecting properly" error. I looked online and on osC forums for a solution and nothing was relevant. This issue exists in the three browsers I tested it in. I called my hosting tech support and they could not resolve it saying that it is redirecting to itself over and over again. I have not touched the code yet as it is a fresh install. I think it is likely my /admin/includes/configure.php file settings and I've tried different variations. One other thing that might be of relevance: my original hosting account is set to PHP5.3 and this sub-domain is set to PHP7.1.7 via AddHandler directive in htaccess and the php.ini file in that sub-domain. Though I don't think this could be the cause. Any help would be greatly appreciated. Thanks.
  14. Demitry

    Database Optimizer

    Phil, ...agreed, ..and that's pretty much what I always try to do. Though as for the tables and nested tables, this is legacy osC code and we will likely be poking fun the same way at divs and nested divs at some point in the near future. :) The issues I brought up are minor and do not affect the functionality of Jack's code and his fantastic contribution.
  15. Demitry

    Database Optimizer

    Phil, ..yeah, I know the nested tables are pretty bad, lol Jack, The code I posted above has no errors displayed. This is my "altered" file. The particular form in question on your uploaded file opens the form inside of a closed <td></td> tags set and closes that form outside of a </tr> tag. So, ...even if you can structure a form as <form><tr><td></td></tr></form> (by removing that closed </td> tag),... it is not proper structure to have an open <tr> tag follow an open <td> tag, which would be the case if you removed that closed </td> tag. As in,... <td><form><tr><td> ... </td></tr></form></td> I only wanted to bring this to your attention to keep the code structure clean. What you do with it is completely your choice. I've already made the change in my file and I am happy with them.
  16. Demitry

    Database Optimizer

    I've never done that and I'm not sure how to do it. I can just paste that code for the page here and you can copy it into a file and look at it in DreamWeaver. Just a precaution for anyone else who looks at this code, ..This code has my modifications and will not work on your site without modifications to other files, so don't use it! <?php /* $Id: database_optimizer_cron.php,v 1.0 2011/02/02 database_optimizer_cron.php Originally Created by: Jack_mcs - http://www.oscommerce-solution.com osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Portions Copyright 2011 oscommerce-solution.com Released under the GNU General Public License */ require('includes/application_top.php'); require('includes/database_optimizer_db_handler.php'); require('includes/languages/english/database_optimizer/database_optimizer_need_help.php'); DO_CheckDatabase(); $actionRunOptimizer = ((isset($_POST['action_run_optimizer']) && $_POST['action_run_optimizer'] == 'process') ? true : false); $currentVersion = ''; $message = ''; /********************** BEGIN VERSION CHECKER *********************/ if (file_exists('includes/functions/version_checker.php')) { require('includes/languages/' . $language . '/version_checker.php'); require('includes/functions/version_checker.php'); $contribPath = 'http://addons.oscommerce.com/info/4441'; $currentVersion = 'Database Optimizer V 1.6'; $contribName = 'Database Optimizer V'; $versionStatus = ''; } /********************** END VERSION CHECKER *********************/ if (isset($_POST['action'])) { /********************** CHECK THE VERSION ***********************/ if ($_POST['action'] == 'getversion') { if (isset($_POST['version_check']) && $_POST['version_check'] == 'on') { $versionStatus = AnnounceVersion($contribPath, $currentVersion, $contribName); } } } else if ($actionRunOptimizer) { $forceOptimize = true; //this is being ran manually so ignore the setting for optimizing require('includes/functions/database_optimizer.php'); require('includes/modules/database_optimizer.php'); if (! $optionSelected) { $messageStack->add(ERROR_NO_OPTION_SELECTED, 'error'); } } ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <link rel="stylesheet" type="text/css" href="includes/database_optimizer.css"> <script type="text/javascript" src="includes/general.js"></script> <link rel="stylesheet" href="//ajax.googleapis.com/ajax/libs/jqueryui/1.10.1/themes/base/jquery-ui.css" type="text/css"> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> <script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.10.1/jquery-ui.min.js"></script> <script type="text/javascript"><!-- function showHelp(page) { //console.log('show help '+page); $( "#do_help" ).dialog({ show: "fade", hide: "fade", position: ['middle',100], width: 600, height: 400, modal: true, open: function(event, ui) { $(this).load(page); } //, buttons: { "Ok": function() { $(this).dialog("close"); } } }); } function ToggleBoxes(cnt) { for (i = 0; i < cnt; i++) { var id = 'opt_'+ i; if (document.getElementById(id).checked == true) { document.getElementById(id).checked = false; } else { document.getElementById(id).checked = true; } } } //--></script> <style type="text/css"> table.BorderedBox {border:1px solid #ddd; background-color:#eee; } .do_small { float:right;font-family:Verdana, Arial, sans-serif; font-size:10px; font-weight:bold; color:#ff0000 } .do_small_inline { display:inline-block; font-family:Verdana, Arial, sans-serif; font-size:10px; font-weight:bold; color:#ff0000 } </style> <script type="text/javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=800,height=800,screenX=150,screenY=150,top=15,left=15') } //--></script> </head> <body> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- 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 width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="BorderedBox"> <tr> <td><table border="0" width="40%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading" valign="top"><?php echo str_replace(" ", "&nbsp;", $currentVersion); ?></td> </tr> <tr> <td class="smallText" valign="top"><?php echo HEADING_TITLE_SUPPORT_THREAD; ?></td> </tr> </table></td> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="smallText" align="right"><?php echo HEADING_TITLE_AUTHOR; ?></td> </tr> <?php if (function_exists('AnnounceVersion')) { $idParts = explode(' ', $currentVersion); foreach ($idParts as $part) { if ($part !== 'V') { $name .= $part; } else { break; } } $id = $idParts[count($idParts)-1]; if (DATABASE_OPTIMIZER_ENABLE_VERSION_CHECKER == 'true') { ?> <tr> <td style="float:right"> <table border="0" cellpadding="0"> <tr> <td class="do_small"><?php echo AnnounceVersion($contribPath, $currentVersion, $contribName); ?></td> <td class="do_small"><INPUT style="vertical-align:middle; margin-top:3px" type="radio" name="version_check_unreleased" onClick="window.open('http://www.oscommerce-solution.com/check_unreleased_updates.php?id=<?php echo $id; ?>&name=<?php echo $name; ?>')"><span style="vertical-align:top"><?php echo TEXT_VERSION_CHECK_UPDATES_UNRELEASED; ?></span></td> </tr> </table></td> </tr> <?php } elseif (tep_not_null($versionStatus)) { echo ' <tr><td class="do_small">' . $versionStatus . '</td></tr>'; } else { $open_form = tep_draw_form('version_check', FILENAME_DATABASE_OPTIMIZER, '', 'post') . tep_draw_hidden_field('action', 'getversion'); ?> <tr> <td style="float:right"><?php echo $open_form; ?><table border="0" cellpadding="0"> <tr> <td class="do_small_inline"><INPUT style="vertical-align:middle; margin-top:0px" type="radio" name="version_check" onClick="this.form.submit();"><?php echo TEXT_VERSION_CHECK_UPDATES; ?></td> <td class="do_small_inline"><INPUT style="vertical-align:middle; margin-top:0px" type="radio" name="version_check_unreleased" onClick="window.open('http://www.oscommerce-solution.com/check_unreleased_updates.php?id=<?php echo $id; ?>&name=<?php echo $name; ?>')"><?php echo TEXT_VERSION_CHECK_UPDATES_UNRELEASED; ?></td> </tr> </table></form></td> </tr> <?php } // if (DATABASE_OPTIMIZER_ENABLE_VERSION_CHECKER == 'true') } else { ?> <tr> <td class="do_small"><?php echo TEXT_MISSING_VERSION_CHECKER; ?></td> </tr> <?php } // if (function_exists('AnnounceVersion')) ?> </table></td> </tr> <tr> <td class="do_small tt"><div style="float:right; margin-bottom:10px; color:sienna; text-align:center"><?php echo TEXT_HELP; ?></div></td> </tr> </table></td> </tr> <!-- BEGIN LOWER SECTION --> <tr> <td><table width="100%" border="0" cellspacing="0" cellpadding="0"> <!-- BEGIN DELETE AND GENERATE FILE --> <tr> <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="right"><?php echo tep_draw_form('database_optimizer', FILENAME_DATABASE_OPTIMIZER, '', 'post') . tep_draw_hidden_field('action_run_optimizer', 'process'); ?><table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td><input type="checkbox" name="toggle_boxes" onClick="return ToggleBoxes('<?php echo count($optionsArray); ?>');"></td> <td colspan="2" class="smallText">Select ALL</td> </tr> <?php $idx = 0; foreach ($optionsArray as $option) { ?> <tr> <td><input type="checkbox" name="<?php echo $option['post']; ?>" id="<?php echo 'opt_' . $idx; ?>"></td> <td class="smallText"><?php echo $option['option']; ?></td> <td class="smallText"><?php echo $option['explain']; ?></td> </tr> <?php $idx++; } // foreach ?> <tr> <td colspan="3" align="center" style="padding:25px;"><?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE);?></td> </tr> </table></form></td> </tr> </table></td> </tr> </table></td> </tr> <!-- END DELETE AND GENERATE FILE --> <!-- BEGIN SHOW THE RESULTS --> <?php if (tep_not_null($message)) { ?> <tr> <td colspan="2" class="smallText" style="padding:10px 0px 5px 10px;"><?php echo str_replace("\r\n", "<br>", $message); ?></td> </tr> <?php } ?> <!-- END SHOW THE RESULTS --> <tr> <td class="main" style="padding:20px 0px 20px 10px;"><span style="font-weight:bold; color:red;">Please Note:</span> All settings for this Database Optimization feature can be managed on the <a href="configuration.php?gID=5011" style="font-size:12px;">Database Optimizer configuration</a> page. </td> </tr> <tr> <td colspan="2" class="main" style="padding:10px 0px 5px 10px;"><div style="width:75%;"><?php echo DO_TEXT_MAIN; ?></div></td> </tr> <!-- END LOWER SECTION --> </table></td> <!-- body_text_eof //--> </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'); ?>
  17. Demitry

    Database Optimizer

    right, but removing the closing </td> tag will not resolve it, because then it is followed by an open <tr> tag (as in... <td><form><tr>). Here is a screenshot of how I changed it (including some other edits). Thank you for the cron job clarification. I initially thought that if that ON/OFF setting is turned to ON, then it would initiate the cron job based on the number of days increment. However, I am glad that I do not have to turn it on and off to apply a manual run. Thank you for that.
  18. Demitry

    Database Optimizer

    Jack, That line is 187 and the form closing tag is on line 211. I got that line number from your file not my changed one. Here is a screenshot of it in DreamWeaver to show what I'm talking about. This shows the whole second form and some of the other stuff I mentioned.
  19. Demitry

    Database Optimizer

    I checked again, and I did download the latest version (V 1.6) that was from Jan 15th this year. Does keeping the ON/OFF setting to ON in configuration, automatically make it a cron job? In other words, if I only wanted to run it manually, would I have to keep that setting turned off and only turn it on when I wanted to run the optimization?
  20. Demitry

    Database Optimizer

    Actually, that center yellow button link issue is likely due to the TEXT_VERSION_CHECK_UPDATES_UNRELEASED variable being undefined. If you cannot replicate this issue, then it is probably that long variable name that is pushing the buttons to a smaller width and thereby, the link of the center button onto the next line.
  21. Demitry

    Database Optimizer

    Hi Jack, Phil, Thank you for pointing out the configuration settings. I did not even realize they were there! I was focused on the /admin/Tools/Database Optimizer. I figured that the undefined variable was for Version Checker, which I don't have installed,.. but thought I'd mention it anyway for those folks that don't have Version Checker either. As far as the form issue, I do believe it is a W3C validation issue and like I mentioned, that the forms likely function properly. I looked at the code in FF and it points out all the html errors in red, which helps me locate and fix them. I placed the form tags around the table on both forms and the error went away. On the second one the opening form tag is inside a closed <td></td> tag (line 187) and the closing one is outside of a closing </tr> tag, which does not follow the form rules you listed above. Please don't take it the wrong way,.. my understanding is that you're more of a back-end developer and your php & other code is fantastic! I just try to keep the code as clean as I can, which is probably a waste of time and a bit overkill. As for adding the file name definition to /admin/includes/filenames.php, ..that was something I did to stay consistent with the osC file structure. My current version is MS2.2 (though I'm about to make the latest BS Edge leap) and my site does have a defined file structure. I did have a look at osC 2.3.4 and it does have the /admin/includes/filenames.php file, so maybe I'm misunderstanding your reply on this because the filename definitions do exist in the newer version as well as in mine. Regardless, it was a minor tweak that does not affect anything in terms of the add-on's functionality... other than stroke my OCD, lol I included a screenshot of the buttons without the inline css for nowrap that I added and you can see the issue with the center button link. I don't think I downloaded an old version of the add-on. I always try to get the complete & latest contribution that fits my needs. However, I will go back and look to see if this was the most recent one. Any suggestions on the javascript error for the buttons from the screenshot above? It's not a big deal if I cannot get them working. I included that language definitions file and echoed the descriptions variable below the output message. So, I have all the descriptions on the same page. I ran the optimization last night and it was amazing!!! reduced my database by 86.74% Thank you!!! Works Awesome!
  22. Demitry

    Database Optimizer

    I'm also getting javascript errors (see screenshot below) from the yellow buttons and there is nothing that displays when I click on them. The first error in the screenshot is on page load and the second, when I click on any of the three javascript buttons. I'm not good with javascript, so any help would be greatly appreciated. Thanks.
  23. Demitry

    Database Optimizer

    Hi Jack, Thank you for this great add-on,.. I just installed it and have not run it yet, but I found several minor html issues with a couple of the files and listed them below. These issues seem to be the same for both Before_2.3 and After_2.3 folders in related files. I also have some concerns regarding how will clearing the database of older customer tracking information affect reporting? If you plan on doing another release of this add-on, it would be good to have some admin-controlled additional selection of how far back to go to remove such records (..and specifically for customer data), or even a checklist of options based on certain customer criteria that an admin could select to further filter the purge. My understanding is that this add-on (with the particular checkbox selection) will remove ALL customer records from the database that have not purchased or logged-in in the last 300 days. So, if a customer made a purchase prior to that 300 day mark and has not bought anything since, I would not want them deleted. However, this is the current configuration of this add-on, is that correct? Or, I may want to remove all customer record’s whose email is bouncing after a certain amount of time, regardless of the time passed since their last purchase or login. /Before_2.3/New_Files_Only/admin/database_optimizer.php On line 160, TEXT_VERSION_CHECK_UPDATES_UNRELEASED is not defined anywhere. Line 173 is missing the closing </div></td> tags Line 189 and line 205, there are duplicate border=”0” attributes within the same <table> opening tag Line 197, there is an extra semicolon “;” at the end of the input tag for each of the checkboxes Line 205, the nested table is not necessary, I removed it and added colspan=”3” and 25px padding to that <td> for the Update button Line 155, the tep_draw_form() should open and close around the <table> tag: open before the table tag on line 158 and closed on line 161. There is an html error with it being placed between the two </tr> tags,.. though I’m sure the form functions properly. Similar issue on the second tep_draw_form() instance. /Before_2.3/New_Files_Only/admin/includes/languages/english/database_optimizer.php Line 21, where it say “Need An Addon?” ..needs to be either “Need&nbsp;An&nbsp;Addon?” or have an in-line css for white-space:nowrap; in the link because right now, it forces “Addon?” to the next line below the yellow button. Aside from making those changes, I also defined the database_optimizer.php file in /admin/includes/filenames.php to stay consistent with the osC structure: // Database Optimizer define('FILENAME_DATABASE_OPTIMIZER', 'database_optimizer.php'); And then changed that variable name in /admin/includes/boxes/tools.php and for the two tep_draw_form() instances in /admin/database_optimizer.php And,.. I added a label to the “Select ALL” checkbox on /Before_2.3/New_Files_Only/admin/database_optimizer.php (line 192): <td colspan="2" class="smallText">Select ALL</td> </tr>
  24. Hi, I could not find any forum on here that deals specifically with MySQL security. And, since I do have this add-on installed, I figured I would ask here. My site is an older version MS2.2 I recently noticed the STORE_ZONE field in MySQL was altered. The hack came from outside the site’s admin panel. I have several security layers to secure access to that admin area. The added entry was not a selection from the drop-down menu used to edit that field, which is based on my country’s code. I’m now looking for a solution to patch that hole. So,.. I thought about revoking the rights to insert, update, delete that configuration table from the public. However, I am not sure if that will be enough or the right way to go, or if there is a better alternative. I’d love to know how the hack was executed and if I missed securing a form or some other entry point. However, at this time I think blocking all write access to that configuration table would likely work. Any help on this would be greatly appreciated.
  25. Demitry

    New UPS XML Shipping Module available

    Cool, thanks Jim, I tried to use the other debugging method too, by adding the value of "1" to use_exec on line 70 of upsxml.php, but when I ran the test checkout, I got no shipping rates or anything at all displaying below the shipping section heading. I don't know if perhaps I missed doing something, but figured I would stick with resolving the cURL error issues first. Demitry
×