How to reset weblink hits?

hervemlam
Topic Author
Offline
Elite Member

7 years 4 hours ago - 6 years 11 months ago #67162 by hervemlam

How to reset weblink hits? was created by hervemlam

Hello,

I've got some weblink and extendedweblink fields in my site. I'd like to reset their number of hits to zero for some reason.
Is there a way to do it easily? (and, if possible, massively?)
I didn't find it in the interface.
And I find it difficult to update the value column in the database with an SQL order (because the 'value' column contains several figures and data).

Could you help?

Thanks,
HervE

PHP 8.1.16
Joomla! 4.3.3
FLEXIcontent 4.1.5

Attachments:

Last edit: 6 years 11 months ago by hervemlam. Reason: Add screenshot

Please Log in or Create an account to join the conversation.

hervemlam
Topic Author
Offline
Elite Member

6 years 11 months ago - 6 years 11 months ago #67209 by hervemlam

Replied by hervemlam on topic How to reset weblink hits?

Hello,

I succeeded myself with an SQL order. Here it is, if anybody's intereted:

Code:

update myPrefix_flexicontent_fields_item_relations set value = concat(mid(value,1,instr(value, ';i:')), 'i:0;}') where (item_id>=myFirstItem and item_id<=myLastItem) and (field_id=myWebLinkField or field_id=myOtherWebLinkField)

(In the code above, replace myFirstItem, myLastItem, myWebLinkField and myOtherWebLinkField with the appropriate numbers, and myPrefix with the appropriate string.)

Good night.
HervE

PHP 8.1.16
Joomla! 4.3.3
FLEXIcontent 4.1.5

Last edit: 6 years 11 months ago by hervemlam.

Please Log in or Create an account to join the conversation.