SQL query to reset profile views??

[Kyle F]

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!

[Kyle F]

Bump??

[Nathan Explosion]

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?

[Adriano Faria]

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.

[Faqole]

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"?