[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
sparforum
Registered User
Posts: 62
Joined: Fri Oct 17, 2003 6:01 am

Post by sparforum »

Links were sent... Let me know if you have any problems.

Thank you

C

sparforum
Registered User
Posts: 62
Joined: Fri Oct 17, 2003 6:01 am

Post by sparforum »

Could this error have to do with a user groups problem?
Couldn't obtain viewer group list

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 'AND user_pending=0' at line 4

SELECT * FROM phpbb_user_group WHERE group_id= 137 AND user_id= AND user_pending=0

Line : 96
File : /home2/sparfcom/public_html/SPARForum/profilcp/profilcp_public_groups.php


This is the error I get when trying to view a members group info from the profile, not to concerned with fixing this, but is this possibly what's causing the problem?

thanks

C

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

Post by Ptirhiik »

No, this is something else (already reported). A fix will be publicated today later.

sparforum
Registered User
Posts: 62
Joined: Fri Oct 17, 2003 6:01 am

Post by sparforum »

Thanks for th update :D Were you able to get into my FTP without any problems?

Let me know if I did something wrong.

thanks

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

Post by Ptirhiik »

I didn't have yet to get back your zip, but I rather prefer a simple link to your files that your ftp pass (you should never give it !). If you pleased to send me by pm this link (so something as http://mydomain.com/packfile.zip), it would be much more better. Yet I am going to destroy your pm to avoid any malicious attempt to steal your passes (I haven't note them and have clean my temporary internet directory to avoid any risqus).

sparforum
Registered User
Posts: 62
Joined: Fri Oct 17, 2003 6:01 am

Post by sparforum »

Thanks, PM is sent.

This MOD, and the service connected to it have been priceless!

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

Post by Ptirhiik »

Two fixes :

Code: Select all

#
#-----[ OPEN ]------------------------------------------------
#
# 2003-10-23-01 : groups public view sometime fails
#
profilcp/profilcp_public_groups.php
#
#-----[ FIND ]------------------------------------------------
#
 *	version				: 1.0.4 - 17/10/2003
#
#-----[ REPLACE WITH ]---------------------------------------- 
#
 *	version				: 1.0.5 - 17/10/2003
#
#-----[ FIND ]------------------------------------------------
#
						AND user_id= $user_id
#
#-----[ REPLACE WITH ]---------------------------------------- 
#
						AND user_id =" .  $userdata['user_id'] . "
#
#-----[ OPEN ]------------------------------------------------
#
# 2003-10-23-02 : watched topics on home panel : typo in the pos
#
profilcp/profilcp_home_wtopics.php
#
#-----[ FIND ]------------------------------------------------
#
 *	version				: 1.0.0 - 26/09/2003
#
#-----[ REPLACE WITH ]---------------------------------------- 
#
 *	version				: 1.0.1 - 23/10/2003
 *
#
#-----[ FIND ]------------------------------------------------
#
	$home_modules['pos'][] = 'left';
#
#-----[ REPLACE WITH ]---------------------------------------- 
#
	$home_modules['pos'][] = 'right';
#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM

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

Post by Ptirhiik »

> sparforum : I browse some of your files, and really the mod is quite badly install. Yet I can't figure how you can have any messages displayed in the viewtopic page with the sql request settled in :). What you did also in the page_header.php won't certainly work correctly in all situations. At this point, the best you have to do is to reinstall properly the mod, helping you with the modified files pack, and avoiding any fancy attempt to modify it until the basic install will work perfectly on your board.

sparforum
Registered User
Posts: 62
Joined: Fri Oct 17, 2003 6:01 am

Post by sparforum »

Thanks for all your help! Like always, the creator knows best, your mod is working fine, I'll begin reinstalling the others I was using.

Thanks!

>>>

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

Post by Ptirhiik »

Two more fixes :

Code: Select all

#
#-----[ OPEN ]------------------------------------------------
#
# 2003-10-23-03 : usage of get_func and chk func inoperational
#
profilcp/def/def_userfuncs.php
#
#-----[ FIND ]------------------------------------------------
#
 *	version				: 1.0.3 - 20/10/2003
#
#-----[ REPLACE WITH ]---------------------------------------- 
#
 *	version				: 1.0.4 - 23/10/2003
#
#-----[ FIND ]------------------------------------------------
#
		$res['type'] = $res['get_mode'];
	}
#
#-----[ AFTER, ADD ]------------------------------------------
#
	else if ( !empty($res['get_func']) || !empty($res['chk_func']) )
	{
		$res['type'] = '';
	}
#
#-----[ OPEN ]------------------------------------------------
#
# 2003-10-23-04 : user_from missing from viewtopic panel
#   NB. : don't forget to set the CHMOD of the file to 666 after upload,
#	or use the ACP to modify this one :) : map : PHPBB->viewtopic->left
#
profilcp/def/def_usermaps.php
#
#-----[ FIND ]------------------------------------------------
#
			'user_loc' => array(
#
#-----[ REPLACE WITH ]---------------------------------------- 
#
			'user_from' => array(
#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM

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

Post by Ptirhiik »

And one more :

Code: Select all

#
#-----[ OPEN ]------------------------------------------------
#
# 2003-10-23-05 : select lost in pagination on members lists
#
profilcp/profilcp_buddy.php
#
#-----[ FIND ]------------------------------------------------
#
 *	version			: 1.2.1 - 20/10/2003
#
#-----[ REPLACE WITH ]---------------------------------------- 
#
 *	version			: 1.2.2 - 23/10/2003
#
#-----[ FIND ]------------------------------------------------
#
	$fvalue = ( isset($HTTP_GET_VARS['fvalue'] ) || isset($HTTP_POST_VARS['fvalue'] ) ) ? ( isset($HTTP_GET_VARS['fvalue'] ) ? trim(htmlspecialchars($HTTP_GET_VARS['fvalue'] )) : htmlspecialchars(urldecode($HTTP_POST_VARS['fvalue'])) ) : '';
#
#-----[ REPLACE WITH ]---------------------------------------- 
#
	$fvalue = ( isset($HTTP_GET_VARS['fvalue'] ) || isset($HTTP_POST_VARS['fvalue'] ) ) ? ( isset($HTTP_GET_VARS['fvalue'] ) ? trim(htmlspecialchars(stripslashes(urldecode($HTTP_GET_VARS['fvalue'])))) : htmlspecialchars(urldecode($HTTP_POST_VARS['fvalue'])) ) : '';
#
#-----[ FIND ]------------------------------------------------
#
	$s_filter .= '</select>';
#
#-----[ AFTER, ADD ]------------------------------------------
#

	// add the sort to the call
	if ( !empty($order) && !empty($sort) ) 
	{ 
		$call .= "&order=$order&sort=$sort"; 
	}
#
#-----[ FIND ]------------------------------------------------
#
	// call url
	$call = "./profile.$phpEx?mode=buddy&sub=$sub";
	if ( !empty($order) && !empty($sort) )
	{
		$call .= "&order=$order&sort=$sort";
	}
	if ( !empty($filter) && empty($comp) && !empty($fvalue) )
	{
		$call .= "&filter=$filter&comp=$comp&fvalue=" . urlencode($fvalue);
	}
	$call = append_sid($call);

	$template->assign_vars(array(
#
#-----[ REPLACE WITH ]---------------------------------------- 
#
	$template->assign_vars(array(
#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM

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

Post by Ptirhiik »

And there comes the pack 1.0.4-3 RC :

All the published fixes are included in, and I finally decided to add the ability to create mapped custom panels in this version :).

McLR
Registered User
Posts: 95
Joined: Thu Aug 21, 2003 12:51 pm

Post by McLR »

i can't post in chat post

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

Post by Ptirhiik »

Here is not a chat post, nor a guess game : can you explain what you mean ?

McLR
Registered User
Posts: 95
Joined: Thu Aug 21, 2003 12:51 pm

Post by McLR »

the theard of chat... I can't post there...
it's wrong place to ask this..
and I got this error :

Code: Select all

Invalid_session 

Locked

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