• Resolved Steven Ray

    (@steveneray)


    Hello,

    Occasionally we clone a website to create a sister website that looks the same, so the previous count carrys forward that needs adjusting. Or we simply need to adjust the unique visitor counts for a client, bringing an old website’s counts forward to new website.

    We use the short code:

    [slimstat f='count-all' w='ip']resolution is_not_empty &&&browser_type does_not_equal 2[/slimstat]

    …to show the count publicly on the user side in the footer.

    I have searched MySQL and cannot find a way to change the Unique IP count. Where is that value stored and why couldn’t there exist a setup interface option that allows the adjustment +/- of the count manually?

    Thanks!

    The page I need help with: [log in to see the link]

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support Amir

    (@amirfallah)

    Hi @steveneray

    Unfortunately, we did not fully understand your question. Please provide more details and your use case so that we can assist you better.

    Additionally, you can find sample codes and conditions that can be used in Shortcodes in the following guides.
    Mastering WP Slimstat Shortcodes
    Examples of Frequently Used Shortcodes in WP Slimstat

    We hope this guide helps you.
    Regards,

    Thread Starter Steven Ray

    (@steveneray)

    I know about all shortcodes, where they are located and I even provided one. The key phrases mentioned more than once, “adjust the unique visitor counts”, “change the Unique IP count” and “…option that allows the adjustment +/- of the count manually.” I am not sure how I could have repeated myself more clearly. Could someone else review my inquiry, process it, and respond?

    Plugin Support Amir

    (@amirfallah)

    Your request has been reviewed by the team, but unfortunately, we still did not fully understand your point.

    The above shortcodes are for displaying statistics, which read data from the wp_slim_stats table.

    For example, the following shortcode provides the number of unique visitors based on IP since the installation:

    [slimstat f='count-all' w='ip'][/slimstat]

    Additionally, the following shortcode gives you the total number of visits since installation:

    [slimstat f='count-all' w='id'][/slimstat]

    Since these values are read from the database, there is no possibility of increasing or decreasing them.

    If you want to retrieve specific data, you can use the filters to get the data according to your needs, edit it, and display it.

    We hope you achieve the desired result through the filters.
    Sincerely,

    Thread Starter Steven Ray

    (@steveneray)

    Okay, so this comment comes close to responding to my inquiry “Since these values are read from the database, there is no possibility of increasing or decreasing them.” However, my questions still remains, where in the MySQL database is the unique IP count found? What table? So that I can go into the table and edit the count. The unique IP visitor count appears by use of a SlimStat short code. The count has to originate from somewhere, e.g. the database to appear visually.

    Plugin Support Amir

    (@amirfallah)

    All the data and reports you see are retrieved from the wp_slim_stats table. The IPs are stored in the IP field in this table. There is no separate table for storing unique IPs. Instead, we prepare this report by retrieving and processing the data from this table.

    For example, to get the count of unique IPs from our data, we use a query like the following:

    SELECT COUNT(DISTINCT(ip)) FROM wp_slim_stats

    As a result, there is no specific table for storing and retrieving each of these items, rather, they are fetched, processed, and reported from the main table, which is wp_slim_stats.

    Please let me know if you have any further questions or need assistance.
    Regards,

    Thread Starter Steven Ray

    (@steveneray)

    Thanks, you have perfectly explained how the data process works and why the count value itself is not retrievable as an editable number. Thanks!

    Plugin Support Amir

    (@amirfallah)

    We are glad that we could answer your question.

    If you have any questions or issues at any time, feel free to ask us. We are here to help you.

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.