::NoName Magazine 无名杂志 » Project Parasy » 头像展示的机制是什么?


2008-4-13 14:24 elicip
头像展示的机制是什么?

我更新了r46后似乎首页没能显示出头像来,但是背景什么的都显示出来了.
谢谢!

2008-4-13 14:29 Sai
个人页面点击超过100就可以展示

想去掉这个限制的话在ParasyCore.php里搜索
[code]AND mf.hits >100 [/code]
去掉即可

2008-6-28 01:51 aquino
我去掉了AND mf.hits >100 這段代碼,老是是出現
====================================================
Time: 2008-6-28 1:47am
Script: /bbs/index.php

SQL: SELECT m.uid,m.username,m.usr_geo,mf.nickname,mf.avatar from [Table]members m LEFT JOIN [Table]memberfields mf ON m.uid=mf.uid WHERE mf.avatar != >'100. ORDER BY rand() LIMIT 20
Error: 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 '>'100. ORDER BY rand() LIMIT 20' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.

2008-6-28 10:22 Sai
WHERE mf.avatar != >'100 怎麽改成這樣了?

需要修改的完整查詢
[code]$query_avatar = $db->query("SELECT m.uid,m.username,m.usr_geo,mf.nickname,mf.avatar from {$tablepre}members m LEFT JOIN {$tablepre}memberfields mf ON m.uid=mf.uid WHERE mf.avatar !='' ORDER BY rand() LIMIT 20");[/code]

2008-6-28 10:54 aquino
(ll11) 就少拿掉".AVATAR_SHOW_HITS."這句,正確應該要拿掉
AND mf.hits >'".AVATAR_SHOW_HITS."這一段。
感謝SAI的提示,頭像已經可以正確顯示。

页: [1]


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.