discuz数据库调用

SELECT a.*,b.* FROM pre_forum_thread as a inner join pre_forum_forum as b on a.fid=b.fid

where a.fid>40 order by tid desc

<!--{if $discuz_uid}-->

<!--{else}-->

<!--通行证登陆前-->

<div class="defBox" id="loginBox">

<div class="defBoxTit">

<h3>登录</h3>

</div><FORM name=loginform action="logging.php?action=login&loginsubmit=tru" method="post">

<table width="96%" border="0" cellspacing="0" cellpadding="0">

<tr>

<th>用户名：</th>

<td><input name="username" type="text" class="userpw" size="14" /></td>

</tr>

<tr>

<th>密 码：</th>

<td><input name="password" type="password" class="userpw" size="14" /></td>

</tr>

<tr>

<th></th>

<td><input name="checkbox" type="checkbox" value="checkbox" checked="checked" />

记住密码</td>

</tr>

</table>

<div id="loginBtn"><input type="image" name="imageField" src="images/45.gif" onclick="javascript:checkloginform()" /></div> </form>

<ul>

<li><a href="$regname" class="showOrange">[新用户注册]</a></li>

<li><a href="logging.php?action=login" >[忘记密码]</a></li>

<li><a href="faq.php" >[帮助中心]</a></li>

</ul>

</div>

<!--{/if}-->

<!--{if $discuz_uid}-->

<!--通行证登陆后-->

<div class="defBox" id="loginBoxSuc">

<div id="loginBoxSucWrap">

<div class="userPhoto"><a href="memcp.php?action=profile&typeid=2" target="_blank">

{echo discuz_uc_avatar($discuz_uid, 'avatar')}</a>

</div>

<ul>

<li>用户ID: <a href="memcp.php?action=profile&typeid=2" target="_blank">$discuz_userss</a></li>

<li><a id="myprompt" href="notice.php" <!--{if $prompt}-->class="new" onmouseover="showMenu({'ctrlid':this.id})"<!--{/if}-->>{lang notice}</a>

<span id="myprompt_check"></span>

<a href="pm.php" id="pm_ntc" target="_blank">{lang pm_center}</a></li>

<li><a href="my.php?item=threads" target="_blank">我的话题</a>

<a href="my.php?item=favorites&type=thread" target=_blank>我的收藏</a>

</li> <li>

<!--{if $discuz_uid &&$adminid >1}--><a href="modcp.php?fid=$fid" target="_blank">{lang modcp}</a><!--{/if}-->

<!--{if $discuz_uid &&$adminid == 1}--><a href="admincp.php" target="_blank">{lang admincp}</a><!--{/if}--></li>

</ul>

</div>

<div class="linksBtn">

<a href="logging.php?action=logout&formhash={FORMHASH}" >

<img src="images/56.gif" alt="退出论坛" width="76" height="23" border="0" /></a>

<!--{if $ucappopen['UCHOME']}-->

<a href="{$uchomeurl}/space.php?uid=$discuz_uid" target="_blank"><img src="images/58.gif" alt="我的空间" width="80" height="23" border="0"/></a>

<!--{elseif $ucappopen['XSPACE']}-->

<a href="{$xspaceurl}/?uid-$discuz_uid" target="_blank"><img src="images/58.gif" alt="我的空间" width="80" height="23" border="0"/></a>

<!--{else}-->

<a href="{$uchomeurl}/space.php?uid=$discuz_uid" target=_blank><img src="images/58.gif" alt="我的空间" width="80" height="23" border="0"/></a>

<!--{/if}-->

</div>

</div>

<!--{else}-->

<!--{/if}-->

<!--通行证结束-->

---