Profile Views List 1.0.2a

Here my mods and history gets moved when validated and released to the phpbb.com MODDB

Profile Views List 1.0.2a

Postby lefty » Tue Oct 09, 2007 8:36 pm

MOD Title: Profile Views List
MOD Description:Shows visitors of profiles and the total amount of visits, visits of guest users are not counted.
There is a separate statistics page, listing all visitors of the profile, including the amount of visits and the last time visited.

Enabling the counting of profile visitors can be switched on/off via the ACP.
The amount of seconds until a profile view is counted again can be changed in the ACP
The amount of recent profile viewers that are listed on the profile page can be modified via the ACP.
MOD Version: 1.0.2a

MOD Download: Profile Views List 1.0.2a
phpbb3 version: 3.0.6

Demo Board: Demoboard
Demo Username: test
Demo Password: testtest

Screenshots:
Image

Credits: requested by talkberlin.de :)
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

merci thanks

Postby PHIL » Wed Oct 10, 2007 5:18 pm

encore un super petit mods interressant

still super small a mods interressant
PHIL
Newbie/Neuling
 
Posts: 3
Joined: Mon Sep 24, 2007 7:28 pm

Re: [Beta] Profile Views List 0.1.0

Postby lefty » Wed Feb 06, 2008 10:08 pm

updated to v 0.1.0

to update, pse uninstall v 0.0.1 and install v 0.1.0
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [Beta] Profile Views List 0.1.0

Postby italian_user » Tue Jul 15, 2008 12:50 pm

Very good this mod! :happysmerk:

But when i go to view profile this error appars:

Errore Generale
SQL ERROR [ mysql4 ]

Table 'animedb.phpbb_profile_views' doesn't exist [1146]

SQL

SELECT * FROM phpbb_profile_views WHERE profile_user_id = 2861 AND viewer_user_id = 16825

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_profileviews.php
LINE: 34
CALL: dbal_mysql->sql_query()

FILE: memberlist.php
LINE: 453
CALL: count_visit()

In my database MySql I run this query

CREATE TABLE `phpbb_profile_views` (
`profile_user_id` MEDIUMINT( 8 ) NOT NULL ,
`viewer_user_id` MEDIUMINT( 8 ) NOT NULL ,
`viewer_user_counter` MEDIUMINT( 8 ) NOT NULL ,
`viewer_visit_time` INT( 11 ) NOT NULL
) ;

INSERT INTO phpbb_config (config_name, config_value) VALUES ('display_profile_views', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('amount_profile_views', '5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_profile_views', '15');



it possible resolve this problem?

I'm an italian users, sorry for my english (isn't very well) :newcry2:
italian_user
Newbie/Neuling
 
Posts: 4
Joined: Tue Jul 15, 2008 12:44 pm

Re: [Beta] Profile Views List 0.1.0

Postby lefty » Tue Jul 15, 2008 6:47 pm

hi italian_user and welcome to my board ;)

thats strange, can you see the table in the your database?
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [Beta] Profile Views List 0.1.0

Postby italian_user » Wed Jul 16, 2008 10:44 am

Image

where is the error?
italian_user
Newbie/Neuling
 
Posts: 4
Joined: Tue Jul 15, 2008 12:44 pm

Re: [Beta] Profile Views List 0.1.0

Postby lefty » Wed Jul 16, 2008 11:21 pm

good question, would you be able to provide me with a temp ftp account and a temp admin account on your (test)forum?
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [Beta] Profile Views List 0.1.0

Postby italian_user » Thu Jul 17, 2008 2:06 am

ok, you can speak with me in MSN.

I have been send my contact in your inbox (forum)
italian_user
Newbie/Neuling
 
Posts: 4
Joined: Tue Jul 15, 2008 12:44 pm

Re: [Beta] Profile Views List 0.1.0

Postby lefty » Thu Jul 17, 2008 7:16 am

ok, but you could have just added me, you know ;) my msn details are on my profile...
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [Beta] Profile Views List 0.1.0

Postby italian_user » Thu Jul 17, 2008 12:49 pm

I added you yesterday, when you are online?
italian_user
Newbie/Neuling
 
Posts: 4
Joined: Tue Jul 15, 2008 12:44 pm

Re: [Beta] Profile Views List 0.1.0

Postby zagor » Tue Aug 12, 2008 9:35 pm

Hi lefty.

I got some problems with your mod.

It automaticly shows +profile view statistic', not the profile when I click on user. I have php bb 3.02.

What did I do wrong?

Thank
zagor
Newbie/Neuling
 
Posts: 4
Joined: Tue Aug 12, 2008 9:29 pm

Re: [Beta] Profile Views List 0.1.0

Postby lefty » Tue Aug 12, 2008 9:42 pm

did you doublecheck your edits already?

sometimes, a before, add is done as after, add etc...
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [Beta] Profile Views List 0.1.0

Postby zagor » Wed Aug 13, 2008 9:59 am

Uhh.

I mod once again from the begining and still no luck :(

there is always case 'profile_views'

I don't know what I'm doing wrong

I really want this mod on my site. Is it possible to force case to force profile to viewprofile without 'profile_views' if I cannot manage to solve the problem?

Thank

P.
zagor
Newbie/Neuling
 
Posts: 4
Joined: Tue Aug 12, 2008 9:29 pm

Re: [Beta] Profile Views List 0.1.0

Postby lefty » Wed Aug 13, 2008 11:45 am

zagor wrote:Uhh.

I mod once again from the begining and still no luck :(

there is always case 'profile_views'

I don't know what I'm doing wrong

I really want this mod on my site. Is it possible to force case to force profile to viewprofile without 'profile_views' if I cannot manage to solve the problem?

Thank

P.

could you send me your modded files? i can have a look if you like.

i must admit i have not installed it on a fresh 3.0.2 board myself but i got no conflicts when upgrading my testboard to it.
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [Beta] Profile Views List 0.1.0

Postby absolutex » Mon Sep 01, 2008 5:03 am

thank you again :kuhsmilie: :cheer:
absolutex
Newbie/Neuling
 
Posts: 5
Joined: Sun Aug 31, 2008 3:13 am

Re: [Beta] Profile Views List 0.1.0

Postby lefty » Mon Sep 01, 2008 8:31 pm

:new_grin: glad you like it
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [Beta] Profile Views List 0.2.0

Postby lefty » Tue Sep 16, 2008 10:20 pm

Code: Select all
2008-09-14 - Version 0.2.0
        *   added separate module, installer. made xhtml strict. added possibility to determine max avatar size via ACP and amount of profile viewers per page
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [Beta] Profile Views List 0.2.0

Postby zagor » Wed Oct 08, 2008 7:06 am

Hi Lefty :D

I'm using your mod for some time and it works great.

What I want now is:

I want a list of five most viewed profiles on my portal blok. I looked at database and I found that there is not a field for overal views.

What sql code do I have to use? ( i know how to get number of views for one user)

Thanks
zagor
Newbie/Neuling
 
Posts: 4
Joined: Tue Aug 12, 2008 9:29 pm

Re: [Beta] Profile Views List 0.2.0

Postby lefty » Wed Oct 08, 2008 7:50 pm

you could try this:

Code: Select all
   $sql = 'SELECT p.profile_user_id, SUM(p.viewer_user_counter) as  viewcount, u.user_id, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, u.username, u.user_colour
      FROM ' . PROFILE_VIEWS_TABLE . ' p, ' . USERS_TABLE. " u
      WHERE p.profile_user_id = u.user_id
         GROUP BY p.profile_user_id
      ORDER BY viewcount DESC";
   $result = $db->sql_query_limit($sql, 5);
   while ($row = $db->sql_fetchrow($result))
   {
      echo $row['user_name'] . ' Amount of counts: ' . $row['viewcount'] . '<br/>';

   }
   $db->sql_freeresult($result);


of course you would need to still assign the variables as echo is just to quickly output the result
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [Beta] Profile Views List 0.2.0

Postby zagor » Thu Oct 09, 2008 8:29 pm

Thank you. It works :cheer:
Thanks again.
zagor
Newbie/Neuling
 
Posts: 4
Joined: Tue Aug 12, 2008 9:29 pm

Re: [Beta] Profile Views List 0.2.0

Postby LisaserstesForum » Mon Dec 08, 2008 12:18 pm

Halli Hallo :kuhsmilie:

ich habe mir deinen MOD installiert, leider hab ich dabei Probleme.
Habe alles nach Anleitung gemacht, wenn ich dann aber die install/index.php aufrufe, bekomme ich diese Meldung:

Parse error: syntax error, unexpected '=', expecting ')' in /kunden/87757/htdocs/chvt.de/www/flashen/phpBB3/install/index.php on line 302


Natürlich kommt dann auch eine Fehlermeldung, wenn ich auf ein Profil klicke, weil wahrscheinlich durch die Fehlermeldung nichts in die Datenbank eingetragen wurde.

Code: Select all
SQL ERROR [ mysql4 ]

Table '87757.phpbb_profile_views' doesn't exist [1146]

SQL

SELECT * FROM phpbb_profile_views WHERE profile_user_id = 2846 AND viewer_user_id = 2

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions_profileviews.php
LINE: 33
CALL: dbal_mysql->sql_query()

FILE: memberlist.php
LINE: 437
CALL: count_visit()


Hoffe auf Hilfe, danke :tigs:
LisaserstesForum
Newbie/Neuling
 
Posts: 2
Joined: Mon Dec 08, 2008 12:14 pm

Re: [Beta] Profile Views List 0.2.0

Postby lefty » Mon Dec 08, 2008 12:52 pm

hallo,
in der install/index.php

kannst du bitte mal das folgende aendern?

find
Code: Select all
    /**
    * Check if the modules exists, then (delete and re-)add the modules
    *
    */
    function install_modules($type=false, &$msg=false)
    {
       global $db, $user;


replace with
Code: Select all
    /**
    * Check if the modules exists, then (delete and re-)add the modules
    *
    */
    function install_modules($type=false, $msg=false)
    {
       global $db, $user;


hast du php4 oder php5 installiert?
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [Beta] Profile Views List 0.2.0

Postby LisaserstesForum » Mon Dec 08, 2008 12:57 pm

Damit hat es funktioniert, vielen Dank für die schnelle Hilfe! :cheer:

Eine Frage noch, ist es normal, dass das überall, nur beim Admin auf dem Profil nicht angezeigt wird? :thinking:

edit:
Hab glaub PHP4 ;)
LisaserstesForum
Newbie/Neuling
 
Posts: 2
Joined: Mon Dec 08, 2008 12:14 pm

Re: [Beta] Profile Views List 0.2.0

Postby lefty » Mon Dec 08, 2008 6:38 pm

wenn jemand beim admin aufs profil geht sollt das auch beim admin funktionieren, eigene profil besuche werden nicht gezaehlt. :wink:
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: [Beta] Profile Views List 0.2.0

Postby ScrapbookSupplies » Sat Dec 13, 2008 6:59 pm

This looks good to me! I might try this one!

:goodideasign:
ScrapbookSupplies
Forum Member
 
Posts: 14
Joined: Wed Jul 09, 2008 8:42 pm

Next

Return to [3.0.x] MOD Database Releases

Who is online

Users browsing this forum: No registered users and 4 guests

cron