Hi guys.

I was wondering if the SQL query command to reset profile views was the same as previous versions of IP.Board, and if so, what is the command query for IPS 4.3.6? And can we still run such a command in the SQL Toolbox?

Thanks!

Bump??

You're asking people to confirm if a SQL query to do something is the same now as it was previously, but you haven't actually provided the SQL query......so, what is the SQL query you are asking about?

What exactly are you trying to achieve?

Edited December 17, 20186 yr by Nathan Explosion

All members:

update core_members set members_profile_views = 0;

Specific member:

update core_members set members_profile_views = 0 where member_id = X;

where X is the member ID.

Edited December 17, 20186 yr by Adriano Faria

In addition to what @Adriano Faria said above, it would be best to backup the members table first. Personally I think that it is a good practice to always backup the database before you modify something in it.

I was also wandering what you meant by "was the same as previous versions of IP.Board"?