3.2 & 3.3 Extensions Database 3.2 / 3.3 ⇒ Member Profile Views

[dmzx]

I have a custom version if i remember right.

Yes thats true

[martin]

Numbers are ok but you have to watch the Queries it makes it's in testing

[uruguayito]

Thx

[Zockgeier]

ThX for the great Extension.

[Siava]

Hi! Thanks for this extension!
I added a counter per user like on this forum:

in listener.php
find

Code: Select all

$query = "SELECT m.user_id, u.username, u.user_colour, u.user_id

replace with

Code: Select all

$query = "SELECT m.user_id, u.username, u.user_colour, u.user_id, COUNT(m.user_id) as view_count

find

Code: Select all

$user_id_member = $totalviewsmember['user_id'];

after add

Code: Select all

$view_count = $totalviewsmember['view_count'];

find

Code: Select all

'URL'				=> $url,

after add

Code: Select all

'VIEW_COUNT'		=> $view_count,

fix current view count
find

Code: Select all

'MEMBER_PROFILE_VIEWS'			=> $member['user_member_profile_views'],

replace with

Code: Select all

'MEMBER_PROFILE_VIEWS'			=> ($this->user->data['user_id'] == $user_id) ? $member['user_member_profile_views'] : $member['user_member_profile_views'] + 1,

memberlist_view_contact_after.html
find

Code: Select all

<span><a href="{member_viewed.URL}" "{member_viewed.USERNAME_COLOUR}">{member_viewed.USERNAME}</a></span><!-- IF not member_viewed.S_LAST_ROW -->, <!-- ENDIF -->

replace with

Code: Select all

<span><a href="{member_viewed.URL}" "{member_viewed.USERNAME_COLOUR}">{member_viewed.USERNAME}</a></span> ({member_viewed.VIEW_COUNT})<!-- IF not member_viewed.S_LAST_ROW -->, <!-- ENDIF -->

[martin]

Do you mean a counter like this ?

rrrr.png

if so its already an ext if not post a screen shot of what your edits do.

[Siava]

Do you mean a counter like this ?

Exactly.

I have downloaded ext from the first post, but there was no counter per user.

[ Post made via Android ]

[BLIZZARDCZ]

Excellent nice work, big thanks

[dmzx]

First post updated

[all4phone]

Polish translation v 1.0.2

pl.zip

[uruguayito]

Hi.
After update to the last version, when I visit a profile appears this error

SQL ERROR [ mysqli ]

Unknown column 'counter_user' in 'field list' [1054]

SQL

UPDATE phpbb_memberprofileviews SET counter_user = 1, date = 1465327768 WHERE user_id = 2 AND view_id = 1783

BACKTRACE


why?

[dmzx]

Hi.
After update to the last version, when I visit a profile appears this error

SQL ERROR [ mysqli ]

Unknown column 'counter_user' in 'field list' [1054]

SQL

UPDATE phpbb_memberprofileviews SET counter_user = 1, date = 1465327768 WHERE user_id = 2 AND view_id = 1783

BACKTRACE


why?

Did you disable and delete data in ACP when uninstalling the "old" version?

[uruguayito]

Disable yes...
Delete not




[ Post made via Samsung Galaxy S4 ]

[dmzx]

Disable yes...
Delete not




[ Post made via Samsung Galaxy S4 ]

Need to delete also to get the old DB table out.

[uruguayito]

Thanks so much dmzx