Интеграция Community Builder 1.2 и phpBB 3 - страница 5 - phpBB

Fatal error: Cannot redeclare get_joomla_user_data() (previously declared in /home/master/site/forum/cache
/tpl_proglass_joomla_db.html.php:38) in /home/master/site/forum/cache/tpl_proglass_joomla_db.html.php on line 61

// Get Homepage, ICQ, AIM, MSN, YIM and Jabber from CB
if ($this->_tpldata['postrow']) {
	foreach ($this->_tpldata['postrow'] as &$row) {
		$user_data = get_joomla_user_data($row['POST_AUTHOR']);
		$sql = "SELECT cb_www,cb_icq,cb_aim,cb_msn,cb_yim,cb_jabber,cb_from,cb_geburtstag FROM jos_comprofiler WHERE user_id=".$user_data['id'];
		$result1 = $jdb->sql_query($sql);
		$row1 = $jdb->sql_fetchrow($result1);
		$jdb->sql_freeresult($result1);
		$row['POSTER_FROM'] = (!empty($row1['cb_from']))? $row1['cb_from'] : '';
		if ($row1['cb_www'] != "" || !empty($row1['cb_www'])) $row['U_WWW'] = 'http://' . $row1['cb_www'];
		$row['U_MSN'] = ($row1['cb_msn'] && $auth->acl_get('u_sendim'))? append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=contact&action=msnm&u=".(int)$user_data['id']) : '';
		$row['U_ICQ'] = 'http://www.icq.com/people/webmsg.php?to=' .(int)$row1['cb_icq'];
		$row['U_YIM'] = ($row1['cb_yim'])? 'http://edit.yahoo.com/config/send_webmesg?.target=' . urlencode($row1['cb_yim']). '&.src=pg' : '';
		$row['U_AIM'] = ($row1['cb_aim'] && $auth->acl_get('u_sendim'))? append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=contact&action=aim&u=".(int)$user_data['id']) : '';
		$row['U_JABBER'] = ($row1['cb_jabber'] && $auth->acl_get('u_sendim'))? append_sid("{$phpbb_root_path}memberlist.$phpEx", "mode=contact&action=jabber&u=".(int)$user_data['id']) : '';
	}
}

// Signature from CB
if ($this->_tpldata['postrow']) {
	foreach ($this->_tpldata['postrow'] as &$row) {
		$user_data = get_joomla_user_data($row['POST_AUTHOR']);
		$sql = "SELECT cb_signature FROM jos_comprofiler WHERE user_id=".(int)$user_data['id'];
		$result1 = $jdb->sql_query($sql);
		$row1 = $jdb->sql_fetchrow($result1);
		$jdb->sql_freeresult($result1);
		$row['SIGNATURE'] = $row1['cb_signature'];
	}
}

// Posts
if ($this->_tpldata['postrow']) {
	foreach ($this->_tpldata['postrow'] as &$row) {
		$user_data = get_joomla_user_data($row['POST_AUTHOR']);
$sql = "SELECT cb_birthday FROM jos_comprofiler WHERE user_id=".$user_data['id'];
		$result1 = $jdb->sql_query($sql);
		$row1 = $jdb->sql_fetchrow($result1);
		$jdb->sql_freeresult($result1);
		$row['POSTER_AGE'] = (!empty($row1['cb_birthday']))? $row1['cb_birthday'] : '';
		
// avatars in posts
		$row['POSTER_AVATAR'] = $user_data['avatar'];
$row['POSTER_FROM'] = $user_data['cb_state'];

$row['S_PROFILE_poster_city'] = $user_data['city'];

if ($this->_tpldata['postrow']) {
    $now = getdate(time() + $user->timezone + $user->dst - date('Z'));//$user - глобальная переменная
	foreach ($this->_tpldata['postrow'] as &$row) {
		$user_data = get_joomla_user_data($row['POST_AUTHOR']);
                      $sql = "SELECT cb_birthday FROM jos_comprofiler WHERE user_id=".(int)$user_data['id'];
		$result1 = $jdb->sql_query($sql);
		$row1 = $jdb->sql_fetchrow($result1);
		$jdb->sql_freeresult($result1);
                       if (!empty($row1['cb_birthday']))
			{
				list($bday_year, $bday_month, $bday_day) = array_map('intval', explode('-', $row1['cb_birthday']));

				if ($bday_year)
				{
					$diff = $now['mon'] - $bday_month;
					if ($diff == 0)
					{
						$diff = ($now['mday'] - $bday_day < 0)? 1 : 0;
					}
					else
					{
						$diff = ($diff < 0)? 1 : 0;
					}

					$row['POSTER_AGE'] = (int) ($now['year'] - $bday_year - $diff);
				}
			}
                 }
}
		

... {postrow.POSTER_FROM}</dd><!-- ENDIF -->
<!-- IF postrow.POSTER_AGE --><dd><strong>{L_AGE}:</strong> {postrow.POSTER_AGE}</dd><!-- ENDIF -->

INSERT INTO `***_phpbb`.`phpbb_users` (`user_birthday`) 
SELECT `cb_birthday`
FROM `****_joomla`.`jos_comprofiler` 

<!-- INCLUDE joomla_db.html -->
<!-- PHP -->

/**
 * Redirect to Joomla! (CB) profile
 */

$username = $this->_tpldata['.'][0]['USERNAME']; 
if (!$username) {
	$username = $this->_tpldata['.'][0]['S_USERNAME'];
}
$user_data = get_joomla_user_data($username);
if ($user_data['id']) {
	header('Location: http://'.$_SERVER['HTTP_HOST'].'/index.php?option=com_comprofiler&task=userProfile&user='.$user_data['id']);
	exit;
}

<!-- ENDPHP -->

<!-- INCLUDE overall_header.html -->
<!-- PHP -->

$username = $this->_tpldata['.'][0]['USERNAME']; 
if (!$username) {
	$username = $this->_tpldata['.'][0]['S_USERNAME'];
}
$user_data = get_joomla_user_data($username);

<!-- ENDPHP -->

			<!-- IF USER_COLOR --><span style="color: {USER_COLOR}; font-weight: bold;"><!-- ELSE --><span><!-- ENDIF -->{USERNAME}</span>

			<!-- IF USER_COLOR --><span style="color: {USER_COLOR}; font-weight: bold;"><!-- ELSE --><span><!-- ENDIF -->
<!-- PHP -->
if ($user_data['id']) {echo '<a href="http://'.$_SERVER['HTTP_HOST'].'/index.php?option=com_comprofiler&task=userProfile&user='.$user_data['id'].'">';}
<!-- ENDPHP -->
{USERNAME}
<!-- PHP -->
if ($user_data['id']) {echo '</a>';}
<!-- ENDPHP -->
</span>