Page 6 of 6 FirstFirst ... 456
Results 51 to 59 of 59
  1. #51
    Join Date
    Nov 2006
    Posts
    56
    Plugin Contributions
    0

    Default Re: Customer Search Log

    Trying to use the EXPORT AS CSV function, but the export has nothing in it but the headers? Any ideas on fixes?

  2. #52
    Join Date
    Jan 2004
    Posts
    66,344
    Blog Entries
    7
    Plugin Contributions
    271

    Default Re: Customer Search Log

    I just tried the Export as CSV in v2.3 and v2.4 and the output was correct: contained both headers and actual search results data.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #53
    Join Date
    Apr 2007
    Location
    Ontario, Canada
    Posts
    1,679
    Plugin Contributions
    20

    Default Re: Customer Search Log

    Please update version 2.4 download version to reflect zip version:

    admin/stats_search_log.php
    line 2
    // Search Log v2.4


    admin/includes/extra_datafiles/search_log.php
    line 21
    define('STATS_SEARCH_LOG_VERSION', '2.4');
    Twitch.
    http://www.twitchtoo.com - Do you work for free? Please donate.
    Twitch Wholesale PRO, ZC 1.38 - 1.57c - Expert Site Migration & Upgrades!

  4. #54
    Join Date
    Jun 2019
    Location
    Austin TX
    Posts
    31
    Plugin Contributions
    0

    Default Re: Customer Search Log

    Our site was attacked 3 days ago via SQL injection. We've made a full recovery of course, but is there a way to also log the IP of the user doing the search and have it saved in the database along with the rest of the saved data. It would help out in case someone attempts to do this again. We're on the latest version of zen cart but for some reason they were still able to fill up our server's hard drive and bring the site down for a couple hours before we noticed and did a restore.

  5. #55
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    8,004
    Plugin Contributions
    9

    Default Re: Customer Search Log

    Make sure you have followed the directions at http://www.zen-cart.com/wiki/index.p...ing_From_Hacks. Work with your host about blocking before they get to your site and try IP Blocker for blocking at the site.

  6. #56
    Join Date
    Nov 2005
    Posts
    494
    Plugin Contributions
    6

    Default Re: Customer Search Log

    Using zen cart 1.5.7 and search log version 2.4 I have found that attempting to use any of the sort by Asc / Desc options kicks me back to the admin index page.
    Can anyone else confirm this behaviour with the same zc and module version?
    Any ideas on a fix for this?

  7. #57
    Join Date
    Nov 2005
    Posts
    494
    Plugin Contributions
    6

    Default Re: Customer Search Log

    I resolved the issue.

    I modified lines 153 to 161 from this:
    Code:
    <td class="dataTableHeadingContent" align="left" valign="top" width="20%"><?php echo (($_GET['list_order']=='searchdate' or $_GET['list_order']=='searchdate-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_DATE . '</span>' : TABLE_HEADING_DATE); ?><br />
    <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=searchdate', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchdate' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</span>'); ?></a>&nbsp; <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=searchdate-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchdate-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
    </td>
    <td class="dataTableHeadingContent" align="left" valign="top"><?php echo (($_GET['list_order']=='searchterm' or $_GET['list_order']=='searchterm-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_SEARCH_TERM . '</span>' : TABLE_HEADING_SEARCH_TERM); ?><br />
    <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=searchterm', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchterm' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</span>'); ?></a>&nbsp; <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=searchterm-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchterm-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
    </td>
    <td class="dataTableHeadingContent" width="20%"><?php echo (($_GET['list_order']=='searchresults' or $_GET['list_order']=='searchresults-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_RESULTS . '</span>' : TABLE_HEADING_RESULTS); ?><br />
    <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=searchresults', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchresults' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</span>'); ?></a>&nbsp; <a href="<?php echo zen_href_link(basename($PHP_SELF) . '?list_order=searchresults-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchresults-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
    </td>
    To this:
    Code:
    <td class="dataTableHeadingContent" align="left" valign="top" width="20%">
    <?php echo (($_GET['list_order']=='searchdate' or $_GET['list_order']=='searchdate-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_DATE . '</span>' : TABLE_HEADING_DATE); ?><br />
    <a href="<?php echo zen_href_link(basename($PHP_SELF), zen_get_all_get_params(array('list_order', 'page')) . 'list_order=searchdate', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchdate' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</span>'); ?></a>
    <a href="<?php echo zen_href_link(basename($PHP_SELF), zen_get_all_get_params(array('list_order', 'page')) . 'list_order=searchdate-desc', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchdate-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
    </td>
    <td class="dataTableHeadingContent" align="left" valign="top">
    <?php echo (($_GET['list_order']=='searchterm' or $_GET['list_order']=='searchterm-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_SEARCH_TERM . '</span>' : TABLE_HEADING_SEARCH_TERM); ?><br />
    <a href="<?php echo zen_href_link(basename($PHP_SELF), zen_get_all_get_params(array('list_order', 'page')) . 'list_order=searchterm', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchterm' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</span>'); ?></a>
    <a href="<?php echo zen_href_link(basename($PHP_SELF), zen_get_all_get_params(array('list_order', 'page')) . 'list_order=searchterm-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchterm-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
    </td>
    <td class="dataTableHeadingContent" width="20%">
    <?php echo (($_GET['list_order']=='searchresults' or $_GET['list_order']=='searchresults-desc') ? '<span class="SortOrderHeader">' . TABLE_HEADING_RESULTS . '</span>' : TABLE_HEADING_RESULTS); ?><br />
    <a href="<?php echo zen_href_link(basename($PHP_SELF), zen_get_all_get_params(array('list_order', 'page')) . 'list_order=searchresults', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchresults' ? '<span class="SortOrderHeader">Asc</span>' : '<span class="SortOrderHeaderLink">Asc</span>'); ?></a>
    <a href="<?php echo zen_href_link(basename($PHP_SELF), zen_get_all_get_params(array('list_order', 'page')) . 'list_order=searchresults-desc', '', 'NONSSL'); ?>"><?php echo ($_GET['list_order']=='searchresults-desc' ? '<span class="SortOrderHeader">Desc</span>' : '<span class="SortOrderHeaderLink">Desc</span>'); ?></a>
    </td>
    Last edited by strelitzia; 20 Dec 2020 at 11:29 PM.

  8. #58
    Join Date
    Nov 2005
    Posts
    494
    Plugin Contributions
    6

    Default Re: Customer Search Log

    I've submitted an updated version of the mod for approval.

  9. #59
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,843
    Plugin Contributions
    292

    Default Re: Customer Search Log

    Added a small tweak: skip logging of searches performed from an IP in the Down for Maintenance exclusion list.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

 

 
Page 6 of 6 FirstFirst ... 456

Similar Threads

  1. v155 Customer can't log in but site creates customer
    By CandleMan in forum Basic Configuration
    Replies: 1
    Last Post: 8 Apr 2016, 03:37 PM
  2. v150 remove the customer log-in link and customer registration page
    By xr3461 in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 22 Dec 2012, 04:20 AM
  3. Customize admin customer search query: search alt emails, too?
    By Matt008 in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 15 Apr 2010, 01:10 AM
  4. Problem with Customer Log in/ Log out
    By tequila in forum General Questions
    Replies: 11
    Last Post: 3 Jul 2009, 02:39 AM
  5. External Log In - Log a Customer in from another system
    By designerman in forum General Questions
    Replies: 11
    Last Post: 14 Jul 2008, 02:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR