竹貓星球

yuei 寫:1.問題外掛：FACE mod 2.20
2.參考連結：無\r
3.使用版本：phpBB 2.0.19
4.網站位置：單機中Orz
5.狀況描述：

虛擬形象的相簿功能拍照只有自己能看
感覺非常的雞肋...食之無味去之可惜~_~

如果能改成列出所有拍照過的圖片我想會非常完美
這是facealbum中的原始碼\r

代碼: 選擇全部

	//?#123;實保存照片?#125;始
	$albumcookie = $db->sql_query("SELECT * FROM week9_facealbum where userid = $userdata[user_id] order by albumtime DESC");
	$break = 1;
	while ($useralbum = $db->sql_fetchrow($albumcookie))
    {
		$userface = $useralbum[useralbum];
		//$week9face = "<img src=pic/$useralbum[useralbum]>";
		$week9face = "<img src="$useralbum[useralbum]" border="0" alt="Fly In Beijing">";
        eval('$xiangpian .= "' . gettemplate('face_album_xiangpian') . '";');
		if ($break%4 == 0)
		{
			$huanhang = "</td></tr><tr><td>";
		}
		else
		{
			$huanhang = "";
		}
		$break++;
		$xiangpian = $xiangpian.$huanhang;
	}
	$db->sql_freeresult($albumcookie);
	//結束	

我修改的語法是這樣\r

代碼: 選擇全部

	$sql = "SELECT useralbum
	FROM WEEK9_FACEALBUM
	ORDER BY useralbum DESC LIMIT 0,4";
	
	while ($useralbum = $db->sql_fetchrow($result))
    {
		$userface = $useralbum[useralbum];
		//$week9face = "<img src=pic/$useralbum[useralbum]>";
		$week9face = "<img src="$useralbum[useralbum]" border="0" alt="Fly In Beijing">";
        eval('$xiangpian .= "' . gettemplate('face_album_xiangpian') . '";');
		if ($break%4 == 0)
		{
			$huanhang = "</td></tr><tr><td>";
		}
		else
		{
			$huanhang = "";
		}
		$break++;
		$xiangpian = $xiangpian.$huanhang;
	}
	$db->sql_fetchrow($result);

請問有那裡忽略或寫錯嗎 ?
怎麼試都顯示不出useralbum中的東西

請前輩指導一下!!謝謝!!T_T

	$sql = "SELECT useralbum
	FROM WEEK9_FACEALBUM
	ORDER BY useralbum DESC LIMIT 0,4";

	$sql = "SELECT *
	FROM week9_facealbum
	ORDER BY albumtime DESC";

	if( !$result = $db->sql_query($sql) ) 
	{ 
		message_die(GENERAL_ERROR, '無法取得相冊資訊', __LINE__, __FILE__, $sql); 
	}

心靈捕手 寫:

yuei 寫:1.問題外掛：FACE mod 2.20
2.參考連結：無\r
3.使用版本：phpBB 2.0.19
4.網站位置：單機中Orz
5.狀況描述：

虛擬形象的相簿功能拍照只有自己能看
感覺非常的雞肋...食之無味去之可惜~_~

如果能改成列出所有拍照過的圖片我想會非常完美
這是facealbum中的原始碼\r

代碼: 選擇全部

	//?#123;實保存照片?#125;始
	$albumcookie = $db->sql_query("SELECT * FROM week9_facealbum where userid = $userdata[user_id] order by albumtime DESC");
	$break = 1;
	while ($useralbum = $db->sql_fetchrow($albumcookie))
    {
		$userface = $useralbum[useralbum];
		//$week9face = "<img src=pic/$useralbum[useralbum]>";
		$week9face = "<img src="$useralbum[useralbum]" border="0" alt="Fly In Beijing">";
        eval('$xiangpian .= "' . gettemplate('face_album_xiangpian') . '";');
		if ($break%4 == 0)
		{
			$huanhang = "</td></tr><tr><td>";
		}
		else
		{
			$huanhang = "";
		}
		$break++;
		$xiangpian = $xiangpian.$huanhang;
	}
	$db->sql_freeresult($albumcookie);
	//結束	

我修改的語法是這樣\r

代碼: 選擇全部

	$sql = "SELECT useralbum
	FROM WEEK9_FACEALBUM
	ORDER BY useralbum DESC LIMIT 0,4";
	
	while ($useralbum = $db->sql_fetchrow($result))
    {
		$userface = $useralbum[useralbum];
		//$week9face = "<img src=pic/$useralbum[useralbum]>";
		$week9face = "<img src="$useralbum[useralbum]" border="0" alt="Fly In Beijing">";
        eval('$xiangpian .= "' . gettemplate('face_album_xiangpian') . '";');
		if ($break%4 == 0)
		{
			$huanhang = "</td></tr><tr><td>";
		}
		else
		{
			$huanhang = "";
		}
		$break++;
		$xiangpian = $xiangpian.$huanhang;
	}
	$db->sql_fetchrow($result);

請問有那裡忽略或寫錯嗎 ?
怎麼試都顯示不出useralbum中的東西

請前輩指導一下!!謝謝!!T_T

以下的修改, 提供您參考:
#
#-----[ FIND ]-----
# ps. 此代碼為 '引言部份' 您所修改者

代碼: 選擇全部

	$sql = "SELECT useralbum
	FROM WEEK9_FACEALBUM
	ORDER BY useralbum DESC LIMIT 0,4";

#
#-----[ REPLACE WITH ]-----
#

代碼: 選擇全部

	$sql = "SELECT *
	FROM week9_facealbum
	ORDER BY albumtime DESC";

	if( !$result = $db->sql_query($sql) ) 
	{ 
		message_die(GENERAL_ERROR, '無法取得相冊資訊', __LINE__, __FILE__, $sql); 
	}

yexusbeliever 寫:Can someone help translate this page for me? I think it must be a way to make face mod compatible with phpBB 2.0.19. Please help translate into English for me.

Meteo 寫:他不會國語的...>''<
我們很喜歡這個功能, 所以我把整個face mod翻成了英文...
具體看我們的論壇

mmo-empire.com

現在有一個問題就是虛擬形象不能正確的顯示在論壇里(用IE的話)
可是用firefox只能正確顯示出一個虛擬形象