Title: Change Count
Last modified: September 5, 2024

---

# Change Count

 *  Resolved [Steven Ray](https://wordpress.org/support/users/steveneray/)
 * (@steveneray)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/change-count/)
 * 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:
 *     ```wp-block-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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fchange-count%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 7 replies - 1 through 7 (of 7 total)

 *  [Amir](https://wordpress.org/support/users/amirfallah/)
 * (@amirfallah)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/change-count/#post-18000497)
 * Hi [@steveneray](https://wordpress.org/support/users/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](https://wp-slimstat.com/resources/examples-of-frequently-used-shortcodes/)
 * We hope this guide helps you.
   Regards,
 *  Thread Starter [Steven Ray](https://wordpress.org/support/users/steveneray/)
 * (@steveneray)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/change-count/#post-18000554)
 * 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?
 *  [Amir](https://wordpress.org/support/users/amirfallah/)
 * (@amirfallah)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/change-count/#post-18000867)
 * 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:
 *     ```wp-block-code
       [slimstat f='count-all' w='ip'][/slimstat]
       ```
   
 * Additionally, the following shortcode gives you the total number of visits since
   installation:
 *     ```wp-block-code
       [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](https://wp-slimstat.com/resources-category/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](https://wordpress.org/support/users/steveneray/)
 * (@steveneray)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/change-count/#post-18001212)
 * 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.
 *  [Amir](https://wordpress.org/support/users/amirfallah/)
 * (@amirfallah)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/change-count/#post-18001530)
 * 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:
 *     ```wp-block-code
       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](https://wordpress.org/support/users/steveneray/)
 * (@steveneray)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/change-count/#post-18001636)
 * Thanks, you have perfectly explained how the data process works and why the count
   value itself is not retrievable as an editable number. Thanks!
 *  [Amir](https://wordpress.org/support/users/amirfallah/)
 * (@amirfallah)
 * [1 year, 9 months ago](https://wordpress.org/support/topic/change-count/#post-18001667)
 * 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)

The topic ‘Change Count’ is closed to new replies.

 * ![](https://ps.w.org/wp-slimstat/assets/icon.svg?rev=2832242)
 * [SlimStat Analytics](https://wordpress.org/plugins/wp-slimstat/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-slimstat/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-slimstat/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-slimstat/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-slimstat/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-slimstat/reviews/)

 * 7 replies
 * 2 participants
 * Last reply from: [Amir](https://wordpress.org/support/users/amirfallah/)
 * Last activity: [1 year, 9 months ago](https://wordpress.org/support/topic/change-count/#post-18001667)
 * Status: resolved