[MOD DB][2.0.6-2.0.4] Profile Control Panel v 2.0.0

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Locked
Abax
Registered User
Posts: 142
Joined: Sun May 11, 2003 10:34 am
Location: Atlanta
Contact:

memberlist

Post by Abax »

Hi,

Everything worked fine afetr the upgrade to 1.02. and the profiles do appear normally now. Thanks a lot.

Howerver, the memberlist gives an error when viewed by the members.


Could not read user informations

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '<> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR (' at line 8

SELECT DISTINCT
u.*,
i.buddy_visible AS user_my_visible_virt,
(CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_my_ignore_virt,
(CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_friend_virt,
b.buddy_visible AS user_visible_virt,
(CASE WHEN b.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_ignore_virt,
(CASE WHEN (u.user_id = 7 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN (CASE WHEN u.user_session_time >= (1067492702-300) THEN 1 ELSE 0 END) ELSE '' END) AS user_online_virt,
u.username AS username_virt,
(CASE WHEN (u.user_id = 7 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_regdate ELSE '' END) AS user_regdate_virt,
(CASE WHEN (u.user_id = 7 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_lastvisit ELSE '' END) AS user_lastvisit_virt,
(CASE WHEN (u.user_id = 7 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_posts ELSE '' END) AS user_posts_virt,
(CASE WHEN (u.user_id = 7 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND ( <> 0 OR 0 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR ( =

...
...
...

Line : 906
File : D:\hshome\...\profilcp\profilcp_buddy.php


It goes on and on. When the administrator looks at it, it displays normally. It just gives that error for members.

my board uses Phpbb 2.0.6. Upgrade to PCP 1.0.2 from 1.0.1. style : Athena

Thanks a lot!

User avatar
Ptirhiik
Registered User
Posts: 7411
Joined: Mon Jan 06, 2003 10:36 pm
Contact:

Post by Ptirhiik »

Please upgrade to the last version.

Abax
Registered User
Posts: 142
Joined: Sun May 11, 2003 10:34 am
Location: Atlanta
Contact:

Thanks!

Post by Abax »

Ok. I definitely. The Control Panel is tooo Nice! I hardly can beleive that it is better in the latter versions!!! I'll let you know if I have any more problems. Thank a whole lot for your time!

User avatar
Ptirhiik
Registered User
Posts: 7411
Joined: Mon Jan 06, 2003 10:36 pm
Contact:

Post by Ptirhiik »

With the last version, you get the ability to re-organize your profile view, and to add custom fields using the admin tools in the ACP :).

The Sorcerer
Registered User
Posts: 17
Joined: Fri Aug 29, 2003 5:38 pm

Post by The Sorcerer »

Of all things, how come there isn't an upload a personal photo? :D

User avatar
Ptirhiik
Registered User
Posts: 7411
Joined: Mon Jan 06, 2003 10:36 pm
Contact:

Post by Ptirhiik »

You just have to duplicate the avatar panel using new field to store the photo uploaded url : there is no difficulties in this :).

User avatar
Ptirhiik
Registered User
Posts: 7411
Joined: Mon Jan 06, 2003 10:36 pm
Contact:

Post by Ptirhiik »

And then comes the release time : Profile Control Panel v 2.0.0.


It comes naturaly after the beta stages that were PCP versions from 1.0.2.

Changelog:
  • 2003-10-30 - Version 2.0.0
  • fix some missing td in lang settings admin progs
  • fix the return path of my friend/my ignore buttons
  • re-add those buttons to viewprofile
  • fix empty group list when user is the owner of
  • fix remaining .php qualifications
  • enhance the compliancy for email with phpBB > 2.0.4
  • enhance compliancy with sub-templates
Last edited by Ptirhiik on Thu Oct 30, 2003 9:14 am, edited 1 time in total.

mm3guy
Registered User
Posts: 197
Joined: Tue Oct 14, 2003 8:13 pm

Post by mm3guy »

Cool, a new version!

User avatar
Ptirhiik
Registered User
Posts: 7411
Joined: Mon Jan 06, 2003 10:36 pm
Contact:

Post by Ptirhiik »

Not really new if you were in 1.0.4-3 RC :).

mm3guy
Registered User
Posts: 197
Joined: Tue Oct 14, 2003 8:13 pm

Post by mm3guy »

I am in that version right now :cool:

Deriel
Registered User
Posts: 164
Joined: Tue Aug 27, 2002 5:16 pm
Location: Curitiba/PR - Brasil
Contact:

Post by Deriel »

A very bizarre message. As Admin or Board Founder, no erro, but as a normal user, this message (yeas, exactly this way)

(teste board: http://forum.valinor.com.br/teste/ )

Code: Select all

Could not read user informations

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '<> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_vi

SELECT DISTINCT 
				u.*,
i.buddy_visible AS user_my_visible_virt,
(CASE WHEN i.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_my_ignore_virt,
(CASE WHEN b.buddy_ignore = 0 THEN 1 ELSE 0 END) AS user_friend_virt,
b.buddy_visible AS user_visible_virt,
(CASE WHEN b.buddy_ignore = 1 THEN 1 ELSE 0 END) AS user_ignore_virt,
(CASE WHEN (u.user_id = 4 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN (CASE WHEN u.user_session_time >= (1067524157-300) THEN 1 ELSE 0 END) ELSE '' END) AS user_online_virt,
u.username AS username_virt,
(CASE WHEN (u.user_id = 4 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_regdate ELSE '' END) AS user_regdate_virt,
(CASE WHEN (u.user_id = 4 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_lastvisit ELSE '' END) AS user_lastvisit_virt,
(CASE WHEN (u.user_id = 4 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN u.user_posts ELSE '' END) AS user_posts_virt,
(CASE WHEN (u.user_id = 4 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewwebsite = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN r.rank_title ELSE '' END) AS user_rank_title_virt,
				1 AS user_generic_display,
(CASE WHEN (u.user_id = 4 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND ( b.buddy_visible = 1 OR ( u.user_allow_viewonline = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_allow_viewonline = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_viewonline_display,
(CASE WHEN (u.user_id = 4 OR ( ( i.buddy_ignore <> 1 OR i.buddy_ignore IS NULL ) AND (  <> 0 OR 0 <> 1 ) AND u.user_allow_website = 1 AND ( b.buddy_visible = 1 OR ( u.user_viewwebsite = 1 OR ( = 1 AND 0 = 1) ) OR ( b.buddy_ignore = 0 AND ( u.user_viewwebsite = 2 OR ( = 2 AND 0 = 1) ) ) ) )) THEN 1 ELSE '' END) AS user_webdisplay_display
			FROM ((((
phpbb_users AS u)
LEFT JOIN phpbb_buddy AS i ON i.user_id=4 AND i.buddy_id=u.user_id)
LEFT JOIN phpbb_buddy AS b ON b.user_id=u.user_id AND b.buddy_id=4)
LEFT JOIN phpbb_ranks AS r

ON (u.user_rank > 0 AND r.rank_special <> 0 AND r.rank_id = u.user_rank) 

OR (u.user_rank = 0 AND r.rank_special = 0 AND u.user_posts >= r.rank_min AND u.user_posts < r.rank_max))
			WHERE u.user_id <> -1 AND i.buddy_ignore = 0
			ORDER BY username_virt ASC
 


Line : 906
File : /www/valinor/forum/www/teste/profilcp/profilcp_buddy.php

Deriel
Registered User
Posts: 164
Joined: Tue Aug 27, 2002 5:16 pm
Location: Curitiba/PR - Brasil
Contact:

Post by Deriel »

Two more things

a) copy *.* in the install make this MOD not EM compatilble yet (I know that EasyMOD will have copy *.* anytime soon, but not yet)

b) Apparently the Attach MOD 2.3.9-2 stop working

User avatar
Ptirhiik
Registered User
Posts: 7411
Joined: Mon Jan 06, 2003 10:36 pm
Contact:

Post by Ptirhiik »

> your error : you didn't follow all the instructions regarding the upgrades : it is asked to you to go the ACP and edit and validate any map one time to regenerate the file. Now the best to do is to get the last version of the def_userfields.php and replace yours, same thing with def_usermaps.php,

> No mods are EMC yet, because EMC is not fully written. This one can be installed using Easy mod, and talking care of the numerous message regarding copy *.* and sql performs sended by easymod during the process,

> Recheck your viewtopic, and apply the modifications required by attachmod to profilcp_privmsg.php as well.

Deriel
Registered User
Posts: 164
Joined: Tue Aug 27, 2002 5:16 pm
Location: Curitiba/PR - Brasil
Contact:

Post by Deriel »

Ptirhiik - RPGnet-fr wrote: > your error : you didn't follow all the instructions regarding the upgrades : it is asked to you to go the ACP and edit and validate any map one time to regenerate the file. Now the best to do is to get the last version of the def_userfields.php and replace yours, same thing with def_usermaps.php,


That was a first time installation, with the latest version posted here.

[EDITED] I redo from scratch all instalation (including a DROP database) in http://forum.valinor.com.br/teste2/ and same thing. To a common user that long error message. And yes, I follow the upgrade recomendations (and wasn't an upgrade)
Last edited by Deriel on Thu Oct 30, 2003 7:47 pm, edited 2 times in total.

Diskmaster
Registered User
Posts: 105
Joined: Mon Jun 09, 2003 3:57 pm
Contact:

Post by Diskmaster »

I've reinstalled 2.0.0 (On /starnikmb) and have had only one cosmetic issue.

The "Your inbox is 4% full" bars do not show. How do I fix this issue.

The MOD kicks butt otherwise. (I attribute my previous Inv. Session error to probably a broken install attempt.)

Edit: And how do I adapt Custom Title for use with this?
Murphy's Law is recursive.

Locked

Return to “[2.0.x] MODs in Development”