생일자 이름 옆에 회원아이콘 붙이려면 채택완료
토리군
11년 전
조회 5,603
스킨자료실의 생일자 소스를 잘 사용하고 있습니다.
현재 "[날짜]이름" 으로만 노출이 되고있는데, 회원아이콘을 이름 오른쪽에 같이 노출시키려면 어떻게 해야하나요?
* 회원마다 회원아이콘이 모두 각각 적용되어 있습니다.
코드는 아래와 같습니다..
</div>
<div>
<div><?</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$sql = "<span class="Apple-tab-span" style="white-space: pre"> </span>SELECT</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_name, mb_nick, mb_birth</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>FROM</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>g4_member</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>WHERE</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>(1)</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>AND</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_birth <> ''</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>ORDER BY</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>MID(mb_birth, 5, 4)</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>ASC</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$result = sql_query($sql);</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bCnt = 0;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>while ($row = sql_fetch_array($result)) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$byear = substr($row[mb_birth],0,4);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bmonth = substr($row[mb_birth],4,2);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bday = substr($row[mb_birth],6,2);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$byearthis = date('Y',time());</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bdatetime = $byearthis . '-' . $bmonth . '-' . $bday;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bdatetimeDisplay = $bmonth . '/' . $bday;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bname = $row[mb_name];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bnickname = $row[mb_nick];</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bdatetime = strtotime($bdatetime);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = date('w', $bdatetime);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if ($bweekday == 0) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '日';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = 'FF0000';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} elseif ($bweekday == 1) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '月';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = '000000';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} elseif ($bweekday == 2) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '火';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = '000000';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} elseif ($bweekday == 3) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '水';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = '000000';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} elseif ($bweekday == 4) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '木';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = '000000';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} elseif ($bweekday == 5) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '金';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = '000000';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} elseif ($bweekday == 6) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '土';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = '0000FF';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$thisdatetime = time();</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$olddatetime = $thisdatetime - 604800;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$newdatetime = $thisdatetime + 1209600;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if (($bdatetime > $olddatetime) && ($bdatetime < $newdatetime)) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if ($bdatetime < $thisdatetime) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bcolor = '777799';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} else {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bcolor = '0A7299';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>echo '<FONT COLOR=#' . $bcolor . '>['. $bdatetimeDisplay . '(<FONT COLOR=#'.$bweekdayColor.'>'.$bweekday.'</FONT>)] ' . $bname . '</FONT>
';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bCnt ++;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if ($bCnt == 0) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>echo '최근 생일을 맞은 회원이 없습니다.
';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div>?></div></div>
<div>
댓글을 작성하려면 로그인이 필요합니다.
답변 1개
채택된 답변
+20 포인트
11년 전
</div>
<div><?</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$sql = "<span class="Apple-tab-span" style="white-space: pre"> </span>SELECT</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_id, mb_name, mb_nick, mb_birth</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>FROM</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>g4_member</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>WHERE</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>(1)</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>AND</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>mb_birth <> ''</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>ORDER BY</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>MID(mb_birth, 5, 4)</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>ASC</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>";</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$result = sql_query($sql);</div>
<div>
</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bCnt = 0;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>while ($row = sql_fetch_array($result)) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$byear = substr($row[mb_birth],0,4);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bmonth = substr($row[mb_birth],4,2);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bday = substr($row[mb_birth],6,2);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$byearthis = date('Y',time());</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bdatetime = $byearthis . '-' . $bmonth . '-' . $bday;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bdatetimeDisplay = $bmonth . '/' . $bday;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bid = $row[mb_id];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bname = $row[mb_name];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bnickname = $row[mb_nick];</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bicon = "<a href="http://xxx.com/data/member/" target="_blank" rel="noopener noreferrer">http://xxx.com/data/member/</a>".substr($bid,0,2)."/".$bid.".gif";</div>
<div>
</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bdatetime = strtotime($bdatetime);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = date('w', $bdatetime);</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if ($bweekday == 0) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '日';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = 'FF0000';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} elseif ($bweekday == 1) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '月';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = '000000';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} elseif ($bweekday == 2) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '火';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = '000000';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} elseif ($bweekday == 3) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '水';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = '000000';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} elseif ($bweekday == 4) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '木';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = '000000';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} elseif ($bweekday == 5) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '金';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = '000000';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} elseif ($bweekday == 6) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekday = '土';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bweekdayColor = '0000FF';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$thisdatetime = time();</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$olddatetime = $thisdatetime - 604800;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$newdatetime = $thisdatetime + 1209600;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if (($bdatetime > $olddatetime) && ($bdatetime < $newdatetime)) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if ($bdatetime < $thisdatetime) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bcolor = '777799';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>} else {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bcolor = '0A7299';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>echo '<FONT COLOR=#' . $bcolor . '>['. $bdatetimeDisplay . '(<FONT COLOR=#'.$bweekdayColor.'>'.$bweekday.'</FONT>)] ' . $bname . '<img src="'.$bicon.'"></FONT>
';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>$bCnt ++;</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>if ($bCnt == 0) {</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>echo '최근 생일을 맞은 회원이 없습니다.
';</div>
<div><span class="Apple-tab-span" style="white-space: pre"> </span>}</div>
<div>?></div>
<div>이렇게 하면 되려나요?
30번째 줄 xxx.com에 도메인 넣으세요.
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인