PDA

View Full Version : 124!! queries


hilfe-forum
17 Jun 2006, 13:49
wen i open a Thred with this postbit:


<!-- post #$post[postid] -->
<if condition="$show['spacer']">
$spacer_open
<div id="edit$post[postid]" style="padding:0px 0px

$stylevar[cellpadding]px 0px">
<if condition="!$post['islastshown']"><!-- this is not the

last post shown on the page --></if>
</if>

<table id="post$post[postid]" class="tborder"

cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0"

width="100%" align="center">
<tr>
<if condition="$show['announcement']">
<td class="thead" style="font-weight:normal"

colspan="2">
<img class="inlineimg"

src="$stylevar[imgdir_statusicon]/post_$post[statusicon].gif"

alt="$post[statustitle]" border="0" />
<phrase 1="$post[startdate]"

2="$post[enddate]">$vbphrase[x_until_y]</phrase>
</td>
<else />
<td class="thead" style="font-weight:normal"

$post[scrolltothis]>
<!-- status icon and date -->
<a

name="post$post[postid]"><img class="inlineimg"

src="$stylevar[imgdir_statusicon]/post_$post[statusicon].gif"

alt="$post[statustitle]" border="0" /></a>
$post[postdate]<if

condition="!$show['detailedtime']">, $post[posttime]</if>
$post[firstnewinsert]
<!-- / status icon and date -->


</td>
<td class="thead" style="font-weight:normal"

align="$stylevar[right]">
&nbsp;
<if

condition="$show['postcount']">#<a

href="showpost.php?$session[sessionurl]p=$post[postid]&amp;p

ostcount=$post[postcount]" target="new" rel="nofollow"

id="postcount$post[postid]"

name="$post[postcount]"><strong>$post[postcount]</strong></a

></if>
<if

condition="$show['inlinemod']">
<input type="checkbox"

name="plist[$postid]" id="plist_$postid"

style="vertical-align:middle; padding:0px; margin:0px 0px 0px

5px" value="$post[checkbox_value]"

onclick="inlineMod.toggle(this)" />
</if>
</td>
</if>
</tr>
<tr valign="top">
<td class="alt2" width="175">

<div

id="postmenu_$post[postid]">
<if

condition="$show['profile']">
<a

class="bigusername"

href="member.php?$session[sessionurl]u=$post[userid]">$post[

musername]</a>
<script

type="text/javascript">

vbmenu_register("postmenu_$post[postid]", true); </script>
<else />
$post[musername]
</if>
</div>

<if

condition="$post['usertitle']"><div

class="smallfont">$post[usertitle]</div></if>
<if condition="$post['rank']"><div

class="smallfont">$post[rank]</div></if>

<if condition="$show['avatar']">
<div class="smallfont">
&nbsp;<br

/><a

href="member.php?$session[sessionurl]u=$post[userid]"><img

src="$post[avatarurl]" alt="<phrase

1="$post[username]">$vbphrase[xs_avatar]</phrase>"

border="0" /></a>
</div>
</if>

<div class="smallfont">
&nbsp;<br />
<if

condition="$post['joindate']"><div>$vbphrase[join_date]:

$post[joindate]</div></if>
<if

condition="$post['field2']"><div>$vbphrase[location_perm]:

$post[field2]</div></if>
<if

condition="$post['age']"><div>$vbphrase[age]:

$post[age]</div></if>
<div>


$vbphrase[posts]: $post[posts]
</div>
<if

condition="$show['reputation']"><div><if

condition="$show['reppower']">$vbphrase[reppower]:

$post[reppower]</if>$post[reputationdisplay]</div></if>
<div>$post[icqicon]

$post[aimicon] $post[msnicon] $post[yahooicon]

$post[skypeicon]</div>
</div>



</td>
<if condition="$show['moderated']">
<td class="alt2" id="td_post_$post[postid]">
<else />
<td class="alt1" id="td_post_$post[postid]">
</if>

<if condition="$show['messageicon'] OR

$post['title']">
<!-- icon and title -->
<div class="smallfont">
<if

condition="$show['messageicon']"><img class="inlineimg"

src="$post[iconpath]" alt="$post[icontitle]" border="0" /></if>
<if

condition="$post['title']"><strong>$post[title]</strong></if>
</div>
<hr size="1"

style="color:$stylevar[tborder_bgcolor]" />
<!-- / icon and title -->
</if>

<!-- message -->
<div

id="post_message_$post[postid]">$post[message]</div>
<!-- / message -->

<if condition="$show['attachments']">
<!-- attachments -->
<div

style="padding:$stylevar[cellpadding]px">

<if

condition="$show['thumbnailattachment']">
<fieldset

class="fieldset">


<legend>$vbphrase[attached_thumbnails]</legend>
<div

style="padding:$stylevar[formspacer]px">


$post[thumbnailattachments]
</div>
</fieldset>
</if>

<if

condition="$show['imageattachment']">
<fieldset

class="fieldset">


<legend>$vbphrase[attached_images]</legend>
<div

style="padding:$stylevar[formspacer]px">


$post[imageattachments]
</div>
</fieldset>
</if>

<if

condition="$show['imageattachmentlink']">
<fieldset

class="fieldset">


<legend>$vbphrase[attached_images]</legend>
<table

cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">


$post[imageattachmentlinks]
</table>
</fieldset>
</if>

<if

condition="$show['otherattachment']">
<fieldset

class="fieldset">


<legend>$vbphrase[attached_files]</legend>
<table

cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">


$post[otherattachments]
</table>
</fieldset>
</if>

<if

condition="$show['moderatedattachment']">
<fieldset

class="fieldset">


<legend>$vbphrase[attachments_pending_approval]</legend>
<table

cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">


$post[moderatedattachments]
</table>
</fieldset>
</if>

</div>
<!-- / attachments -->
</if>

<if condition="$post['signature']">
<!-- sig -->
<div>


__________________<br />
$post[signature]
</div>
<!-- / sig -->
</if>

<if condition="$show['postedited']">
<!-- edit note -->
<div class="smallfont">

<hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<em>
<phrase

1="$post[edit_username]" 2="$post[edit_date]"

3="$post[edit_time]">$vbphrase[last_edited_by_x_on_y_at_z]</p

hrase>.
<if

condition="$post['edit_reason']">$vbphrase[reason]:

$post[edit_reason]</if>
</em>
</div>
<!-- / edit note -->
</if>

</td>
</tr>
<tr>
<td class="alt2">
$post[onlinestatus]
<if condition="$show['reputationlink']"><a

href="reputation.php?$session[sessionurl]p=$post[postid]"

rel="nofollow"><img class="inlineimg"

src="$stylevar[imgdir_button]/reputation.gif" border="0"

alt="<phrase

1="$post[username]">$vbphrase[add_to_xs_reputation]</phrase

>" /></a></if>
<if condition="$show['reportlink']"><a

href="report.php?$session[sessionurl]p=$post[postid]"

rel="nofollow"><img class="inlineimg"

src="$stylevar[imgdir_button]/report.gif"

alt="$vbphrase[report_bad_post]" border="0" /></a></if>
$post[iplogged]
&nbsp;
</td>
<if condition="$show['moderated']">
<td class="alt2" align="$stylevar[right]">
<else />
<td class="alt1" align="$stylevar[right]">
</if>
<!-- controls -->
<if condition="$post['editlink']">
<a href="$post[editlink]"

name="vB::QuickEdit::$post[postid]"><img

src="$stylevar[imgdir_button]/edit.gif"

alt="$vbphrase[edit_delete_message]" border="0" /></a>
</if>
<if condition="$post['forwardlink']">
<a href="$post[forwardlink]"><img

src="$stylevar[imgdir_button]/forward.gif"

alt="$vbphrase[forward_message]" border="0" /></a>
</if>
<if condition="$post['replylink']">
<a href="$post[replylink]"

rel="nofollow"><img src="$stylevar[imgdir_button]/<if

condition="$post['forwardlink']">reply_small<else

/>quote</if>.gif" alt="$vbphrase[reply_with_quote]" border="0"

/></a>
</if>
<if condition="$show['quickreply'] AND

!$show['threadedmode']">
<a href="$post[replylink]"

rel="nofollow" id="qr_$post[postid]" onclick="return false"><img

src="$stylevar[imgdir_button]/quickreply.gif"

alt="$vbphrase[quick_reply_to_this_message]" border="0" /></a>
</if>
<if condition="$show['moderated']">
<img

src="$stylevar[imgdir_misc]/moderated.gif"

alt="$vbphrase[moderated_post]" border="0" />
</if>
<!-- / controls -->
</td>
</tr>
</table>

<!-- post $post[postid] popup menu -->
<div class="vbmenu_popup" id="postmenu_$post[postid]_menu"

style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">$post[username]</td>
</tr>
<if condition="$show['profile']">
<tr><td class="vbmenu_option"><a

href="member.php?$session[sessionurl]u=$post[userid]">$vbphr

ase[view_public_profile]</a></td></tr>
</if>
<if condition="$show['pmlink']">
<tr><td class="vbmenu_option"><a

href="private.php?$session[sessionurl]do=newpm&amp;u=$post[

userid]" rel="nofollow"><phrase

1="$post[username]">$vbphrase[send_private_message_to_x]</

phrase></a></td></tr>
</if>
<if condition="$show['emaillink']">
<tr><td class="vbmenu_option"><a

href="sendmessage.php?$session[sessionurl]do=mailmember&a

mp;u=$post[userid]" rel="nofollow"><phrase

1="$post[username]">$vbphrase[send_email_to_x]</phrase></a

></td></tr>
</if>
<if condition="$show['homepage']">
<tr><td class="vbmenu_option"><a

href="$post[homepage]"><phrase

1="$post[username]">$vbphrase[visit_xs_homepage]</phrase><

/a></td></tr>
</if>
<if condition="$show['search']">
<tr><td class="vbmenu_option"><a

href="search.php?$session[sessionurl]do=finduser&amp;u=$pos

t[userid]" rel="nofollow"><phrase

1="$post[username]">$vbphrase[find_more_posts_by_x]</phras

e></a></td></tr>
</if>
<if condition="$post['userid'] AND $show['member']">
<tr><td class="vbmenu_option"><a

href="profile.php?$session[sessionurl]do=addlist&amp;userlist=b

uddy&amp;u=$post[userid]"><phrase

1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase>

</a></td></tr>
</if>
</table>
</div>
<!-- / post $post[postid] popup menu -->

<if condition="$show['spacer']">
</div>
$spacer_close
</if>
<!-- / post #$post[postid] -->



i have 11 queries.



with this postbit:


<!-- post #$post[postid] -->
<if condition="$show['spacer']">
$spacer_open
<div id="edit$post[postid]" style="padding:0px 0px

$stylevar[cellpadding]px 0px">
<if condition="!$post['islastshown']">
<!-- this is not the last post shown on the page -->
</if>
</if>
<table id="post$post[postid]" class="tborder"

cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0"

width="100%" align="center">
<tr>
<if condition="$show['announcement']">
<td class="thead" style="font-weight:normal"

colspan="2"><img class="inlineimg"

src="$stylevar[imgdir_statusicon]/post_$post[statusicon].gif"

alt="$post[statustitle]" border="0" />
<phrase 1="$post[startdate]"

2="$post[enddate]">$vbphrase[x_until_y]</phrase>
</td>
<else />
<td class="thead" style="font-weight:normal"

$post[scrolltothis]><!-- status icon and date -->
<a name="post$post[postid]"><img class="inlineimg"

src="$stylevar[imgdir_statusicon]/post_$post[statusicon].gif"

alt="$post[statustitle]" border="0" /></a> $post[postdate]
<if condition="!$show['detailedtime']">,

$post[posttime]</if>
$post[firstnewinsert]
<!-- / status icon and date -->
</td>
<td class="thead" style="font-weight:normal"

align="$stylevar[right]">&nbsp;
<if condition="$show['postcount']">#<a

href="showpost.php?$session[sessionurl]p=$post[postid]&amp;p

ostcount=$post[postcount]" target="new" rel="nofollow"

id="postcount$post[postid]"

name="$post[postcount]"><strong>$post[postcount]</strong></a

></if>
<if condition="$show['inlinemod']">
<input type="checkbox" name="plist[$postid]"

id="plist_$postid" style="vertical-align:middle; padding:0px;

margin:0px 0px 0px 5px" value="$post[checkbox_value]"

onClick="inlineMod.toggle(this)" />
</if>
</td>
</if>
</tr>
<tr valign="top">
<td rowspan="2" class="alt2"

width="175">

<!--boxstart-->
<table class="tborder" cellspacing="1" border="0"

width="100%">
<tbody>
<tr>
<td class="thead" colspan="2"><div align="center"

id="postmenu_$post[postid]" <if

condition="$post['namestyle']">style="$post[namestyle]"</if>>
<!-- vbPlaza end -->


<if condition="$show['profile']"><a class="bigusername"

href="member.php?$session[sessionurl]u=$post[userid]"

$post[mh_unm_username_history]>$post[musername]</a>
<script type="text/javascript">

vbmenu_register("postmenu_$post[postid]", true); </script>
<else />
$post[musername] </if>
</div></td>
</tr>
</tbody>
<tbody

id="collapseobj_postbit_legacy_userinfo$post[postcount]"

style="$vbcollapse[collapseobj_postbit_legacy_userinfo]">
<tr>


<td class="alt2"><fieldset class="fieldset">
<legend>
<if condition="$post['usertitle']"><div class="smallfont" <if

condition="$post['titlestyle']">style="$post[titlestyle]"</if>>$post[u

sertitle]</div>
</legend>
</if>
<!--rankstart --><br>
<if condition="$post['rank']">
<div align="center" class="smallfont">$post[rank]</div>
</if>
<!--rankend-->
<!--avatar start -->
<if condition="$show['avatar']">
<div align="center" class="smallfont1"><br />
<a

href="member.php?$session[sessionurl]u=$post[userid]"><img

src="$post[avatarurl]" alt="<phrase

1="$post[username]">$vbphrase[xs_avatar]
</phrase>
" border="0" /></a> </div>
</if>

<!--avatar end--><!--kannmoderierenstart -->


<if condition="$post['usertitle']">


<if

condition="can_moderate($thread[forumid],'',$post[userid])">


<br />


</if>


</if>


<div align="center" class="smallfont">



<if condition="$post['usertitle']">


<if

condition="can_moderate($thread[forumid],'',$post[userid])">


kann hier

moderieren<br><br>
</if>


</if>
<if condition="$bbuserinfo['userid']">
<else />
<script type="text/javascript"><!--
google_ad_client = "pub-1063502050622105";
google_alternate_color = "FFFFFF";
google_ad_width = 125;
google_ad_height = 125;
google_ad_format = "125x125_as";
google_ad_type = "text_image";
google_ad_channel ="";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "000000";
google_color_text = "000000";
google_color_url = "000000";
//--></script>
<script type="text/javascript"


src="http://pagead2.googlesyndication.com/pagead/show_ads.js"

>
</script>
<br>

<div style="font-size:12px"><a

href="http://www.hilfe-forum.eu/register/">registrierte</a>

User<br> sehen keine Werbung</div>
</if>

</div>


<!--kannmoderierenend -->
</fieldset></td>


</tr>
</tbody>
</table>
<!--boxend-->
<!-- ******************************************** -->
<if condition="$bbuserinfo['userid']"><div class="smallfont">

&nbsp;<br />
<!-- START COLLAPSABLE POSTBIT BEGINNING-->
<if condition="THIS_SCRIPT=='showthread' OR

THIS_SCRIPT=='showpost'">

<table class="tborder" cellspacing="1" border="0"

width="100%">
<tbody>
<tr>
<td class="thead" colspan="2">&nbsp;
<!-- <a style="float:$stylevar[right]" href="#"

onClick="return

toggle_collapseuserinfo('postbit_legacy_userinfo$post[postcount]

')"><img

id="collapseimg_postbit_legacy_userinfo$post[postcount]"

src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collaps

eimg_postbit_legacy_userinfo].gif" alt="" border="0"

/></a>$vbphrase[collapse_postbit]-->
</td>
</tr>
</tbody>
<tbody

id="collapseobj_postbit_legacy_userinfo$post[postcount]"

style="$vbcollapse[collapseobj_postbit_legacy_userinfo]">
<tr>


<td class="alt2">
</if>

<!-- / END COLLAPSABLE POSTBIT BEGINNING-->
<!-- START PROFILE LEGEND -->
<fieldset class="fieldset">
<legend>$post[musername]'s Profil</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]"

border="1">



<if condition="$post['joindate']">
<br> <div>$vbphrase[join_date]: $post[joindate]</div>
</if>
<if

condition="$show['last_seen_online']"><div>$vbphrase[last_seen

_online]: $post[lastseen_date] $post[lastseen_time]</div></if>


<if condition="$post['field2']">
<div>$vbphrase[location_perm]: $post[field2]</div>
</if>
<if condition="$vboptions['usereferrer']">
<br>
<div class="smallfont1">$vbphrase[referrals]:

$post[referrals]</div>
</if>
<div><a

href="vbimghost.php?do=viewimages&id=$post[userid]">$vbphra

se[vbimghost_menushimg] </a> </div>
$post[findme]
<br>
<if condition="$post['age']">
<div class="smallfont1">$vbphrase[age]:

$post[age]</div>
</if>


<if

condition="$thread[postuserid] == $post[userid] and

$post[postcount] > '1'">
<div class="smallfont1"><img

src="/images/misc/threadstarter.gif" alt="" /> Themenstarter<br

/>
</div>
</if>


</table>
</fieldset>
<!-- / END PROFILE LEGEND -->
<!-- START STATS LEGEND -->
<fieldset class="fieldset">
<legend>$post[musername]'s Stats</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]"

border="1">
<if condition="$post['age']">
<div>$vbphrase[age]: $post[age]</div>
</if>
<br> <div> $vbphrase[posts]: $post[posts]
<!-- vbPlaza start -->
<if condition="$vboptions['vbbux_enabled']"><br />
$vbphrase[vbbux_points]: $post[points]<br />
$vbphrase[vbbux_bank]: $post[bank]<br />
<phrase

1="$vbphrase[vbbux_points]">$vbphrase[vbbux_total_points]</ph

rase>: $post[totalpoints]<br />
<a

href="vbplaza.php?do=donate&amp;userid=$post[userid]">$vbph

rase[vbplaza_donate]</a><br />
</if>
<!-- vbPlaza end --> </div>

<div class="smallfont1">$vbphrase[vbshout_shouts]:

$totalshouts</div> <div>
Zeit im

Forum:<br> $post[timeonboard]
</div><br>



<if condition="$show['reputation']">
<div>
<if condition="$show['reppower']">$vbphrase[reppower]:

$post[reppower]</if>
Erfahrung: $post[reputationdisplay]</div><br>
</if>

<if condition="$post[userid]">


$vbphrase[post_thanks_thanks]:

$post[post_thanks_user_amount] Danke<br />




<if condition="$post[post_thanks_thanked_times_on] ==

1">$vbphrase[post_thanks_time_post]
<else />


<if condition="$post[post_thanks_thanked_posts_on] == 1">


<phrase

1="$post[post_thanks_thanked_times]">$vbphrase[post_thanks_

times_post]


</phrase>


<else />


<phrase 1="$post[post_thanks_thanked_times]"

2="$post[post_thanks_thanked_posts]">




$vbphrase[post_thanks_times_posts]


</phrase>


</if>


</if>
</if>
<!-- Ende

Beitrags Danke Hack -->

<br><br> $post[crowns]$post[champtext]<br />

<if condition="$post['photos']">


<div>Photos:

<strong>$post[photos]</strong> <a

href="$vbpoptions[bbdir]/gallery/showgallery.php?cat=500&ppus

er=$post[userid]"><img class="inlineimg"

src="$stylevar[imgdir_button]/lastpost.gif" alt="Users Photo

Gallery" border="0" /></a>
</if>

</div>


</table>
</fieldset>
<!-- / END STATS LEGEND -->
<!-- START INSTANT MESSAGING LEGEND -->
<if condition="$show['hasimicons']">
<fieldset class="fieldset">
<legend>$post[musername]'s Messaging</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]"

border="1">




<div>$post[icqicon] $post[aimicon] $post[msnicon]

$post[yahooicon] $post[skypeicon]</div>

<!-- vbPlaza start -->
<if

condition="$post['giftsdisplay']"><div

class="smallfont">$post[giftsdisplay]</div></if>
<if

condition="$post['ribbonsdisplay']"><div

class="smallfont">$post[ribbonsdisplay]</div></if>
<!-- vbPlaza end -->



</table>
</fieldset>
</if>
<!-- / END INSTANT MESSAGING LEGEND -->
<!-- / START EXTRAS LEGEND -->
<fieldset class="fieldset">
<legend>$post[musername]'s Extras</legend>
$post[onlinestatus]
<if condition="$show['reputationlink']"><a

href="reputation.php?$session[sessionurl]p=$post[postid]"

rel="nofollow"><img class="inlineimg"

src="$stylevar[imgdir_button]/reputation.gif" border="0"

alt="<phrase

1="$post[username]">$vbphrase[add_to_xs_reputation]
</phrase>
"/></a><br>
<br>
</if>



<table width="100%" border="0" cellspacing="0"

cellpadding="0">
<tr height="100%">
<if condition="$show['reportlink']">
<td width="70"><a

href="report.php?$session[sessionurl]p=$post[postid]"

rel="nofollow"><img class="inlineimg"

src="$stylevar[imgdir_button]/report.gif"

alt="$vbphrase[report_bad_post]" border="0" /></a><br>
</td align="left">
</if>
<if condition="$show['warning']">
<td>$post[iplogged]</td>
</if>
</tr>
</table>
<br>
<div class="smallfont">$post[warning]</div>
</fieldset>




























































</div>

<!-- / END EXTRAS LEGEND -->
<!-- START COLLAPSABLE POSTBIT ENDING -->
<if condition="THIS_SCRIPT=='showthread' OR

THIS_SCRIPT=='showpost'">

</td>
</tr>

</tbody>

</table>
</if>

</if>
</td>
<!-- / END COLLAPSABLE POSTBIT ENDING -->
<!-- ******************************************** -->





<!--post -->
<if condition="$show['moderated']">
<td height="100%" class="alt2"

id="td_post_$post[postid]"><else />
<td height="100%" class="alt1"

id="td_post_$post[postid]"><!-- <br><br>-->
</if><!-- <fieldset class="fieldset"><legend>-->
<if condition="$show['messageicon'] OR $post['title']">
<!-- icon and title -->
<div class="smallfont">
<if condition="$show['messageicon']"><img

class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]"

border="0" /></if>
<if

condition="$post['title']"><strong>$post[title]</strong></if>
</div>
<!-- / icon and title -->
</if><!-- </legend>-->
<!-- message --><hr>
<div id="post_message_$post[postid]">$post[message]</div>
<!-- / message -->
<if condition="$show['attachments']">
<!-- attachments -->
<div style="padding:$stylevar[cellpadding]px">
<if condition="$show['thumbnailattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_thumbnails]</legend>
<div style="padding:$stylevar[formspacer]px">

$post[thumbnailattachments] </div>
</fieldset>
</if>
<if condition="$show['imageattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<div style="padding:$stylevar[formspacer]px">

$post[imageattachments] </div>
</fieldset>
</if>
<if condition="$show['imageattachmentlink']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_images]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]"

border="0">
$post[imageattachmentlinks]
</table>
</fieldset>
</if>
<if condition="$show['otherattachment']">
<fieldset class="fieldset">
<legend>$vbphrase[attached_files]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]"

border="0">
$post[otherattachments]
</table>
</fieldset>
</if>
<if condition="$show['moderatedattachment']">
<fieldset class="fieldset">


<legend>$vbphrase[attachments_pending_approval]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]"

border="0">
$post[moderatedattachments]
</table>
</fieldset>
</if>
</div>
<!-- / attachments -->
</if>
<if condition="$show['postedited']">
<!-- edit note -->
<div class="smallfont">
<hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<em>
<phrase 1="$post[edit_username]" 2="$post[edit_date]"

3="$post[edit_time]">$vbphrase[last_edited_by_x_on_y_at_z]</p

hrase>
.
<if condition="$post['edit_reason']">$vbphrase[reason]:

$post[edit_reason]</if>
</em> </div>
<!-- / edit note -->
</if>
<!--</fieldset> -->
</td><!--postend-->
</tr>
<tr>
<td height="1" valign="bottom" class="alt2">
<if condition="$post['signature']"> <!-- sig -->
<fieldset class="fieldset"><legend>$post[musername]'s

Signatur</legend><div align="center"><br />
$post[signature] </div></fieldset
><!-- / sig --></if>



<div align="center">
<if condition="$bbuserinfo['userid']">
<else />
<!-- Search Google -->
<center>
<form method="get" action="http://www.google.de/custom"

target="google_window">
<table bgcolor="#ffffff">
<tr><td nowrap="nowrap" valign="top" align="left" height="32">
<a href="http://www.google.com/">
<img src="http://www.google.com/logos/Logo_25wht.gif"

border="0" alt="Google" align="middle"></img></a>
<input type="text" name="q" size="50" maxlength="255"

value=""></input>
<input type="submit" name="sa" value="Suchen"></input>
<input type="hidden" name="client"

value="pub-1063502050622105"></input>
<input type="hidden" name="forid" value="1"></input>
<input type="hidden" name="ie" value="ISO-8859-1"></input>
<input type="hidden" name="oe" value="ISO-8859-1"></input>
<input type="hidden" name="cof"

value="GALT:#FFFFFF;GL:1;DIV:#FFFFFF;VLC:FFFFFF;AH:c

enter;BGC:FFFFFF;LBGC:FFFFFF;ALC:FFFFFF;LC:FFFFFF;T

:000000;GFNT:0000FF;GIMP:0000FF;FORID:1;"></input>
<input type="hidden" name="hl" value="de"></input>
</td></tr></table>
</form>
</center>
<!-- Search Google -->

</if>
</div>















</td>
</tr>
<tr>
<td class="alt2"></td>
<td class="alt1" align="$stylevar[left]">
</td>
</tr>
<tr>
<td class="alt2"></td>
<if condition="$show['moderated']">
<td class="alt2" align="$stylevar[right]"><else />
<td class="alt1" align="$stylevar[right]">
</if>
<!-- controls -->
<!-- Start Post Thank You Hack -->
$post_thanks_button
<!-- End Post Thank You Hack -->
<if condition="$post['editlink']"> <a href="$post[editlink]"

name="vB::QuickEdit::$post[postid]"><img

src="$stylevar[imgdir_button]/edit.gif"

alt="$vbphrase[edit_delete_message]" border="0" /></a> </if>
<if condition="$post['forwardlink']"> <a

href="$post[forwardlink]"><img

src="$stylevar[imgdir_button]/forward.gif"

alt="$vbphrase[forward_message]" border="0" /></a> </if>
<if condition="$post['replylink']">
<a href="$post[replylink]" rel="nofollow"><img

src="$stylevar[imgdir_button]/<if

condition="$post['forwardlink']">reply_small<else

/>quote</if>.gif" alt="$vbphrase[reply_with_quote]" border="0"

/></a>
</if>
<if condition="$show['quickreply'] AND

!$show['threadedmode']"> <a href="$post[replylink]"

rel="nofollow" id="qr_$post[postid]" onClick="return false"><img

src="$stylevar[imgdir_button]/quickreply.gif"

alt="$vbphrase[quick_reply_to_this_message]" border="0" /></a>

</if>
<if condition="$show['moderated']"> <img

src="$stylevar[imgdir_misc]/moderated.gif"

alt="$vbphrase[moderated_post]" border="0" /> </if>
<!-- / controls -->
</td>
</tr>
</table>
<!-- post $post[postid] popup menu -->
<div class="vbmenu_popup"

id="postmenu_$post[postid]_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">$post[username]</td>
</tr>
<if condition="$show['profile']">
<tr>
<td class="vbmenu_option"><a

href="member.php?$session[sessionurl]u=$post[userid]">$vbphr

ase[view_public_profile]</a></td>
</tr>
</if>
<if condition="$show['pmlink']">
<tr>
<td class="vbmenu_option"><a

href="private.php?$session[sessionurl]do=newpm&amp;u=$post[

userid]">
<phrase

1="$post[username]">$vbphrase[send_private_message_to_x]</

phrase>
</a></td>
</tr>
</if>
<if condition="$show['emaillink']">
<tr>
<td class="vbmenu_option"><a

href="sendmessage.php?$session[sessionurl]do=mailmember&a

mp;u=$post[userid]" rel="nofollow">
<phrase

1="$post[username]">$vbphrase[send_email_to_x]</phrase>
</a></td>
</tr>
</if>
<if condition="$show['homepage']">
<tr>
<td class="vbmenu_option"><a href="$post[homepage]">
<phrase

1="$post[username]">$vbphrase[visit_xs_homepage]</phrase>
</a></td>
</tr>
</if>
<if condition="$show['search']">
<tr>
<td class="vbmenu_option"><a

href="search.php?$session[sessionurl]do=finduser&amp;u=$pos

t[userid]" rel="nofollow">
<phrase

1="$post[username]">$vbphrase[find_more_posts_by_x]</phras

e>
</a></td>
</tr>
</if>
<if condition="$post['userid'] AND $show['member']">
<tr>
<td class="vbmenu_option"><a

href="profile.php?$session[sessionurl]do=addlist&amp;userlist=b

uddy&amp;u=$post[userid]">
<phrase

1="$post[username]">$vbphrase[add_x_to_buddy_list]</phrase>
</a></td>
</tr>
</if>




<if condition="$post[journal_id]">
<tr>
<td class="vbmenu_option"><a

href="journal.php?$session[sessionurl]do=showjournal&j=$post[j

ournal_id]" title="$post[journaldesc]"><phrase

1="$post[username]">$vbphrase[visit_xs_journal]</phrase></a>

</td>
</tr>
</if>




</table>
</div>
<!-- / post $post[postid] popup menu -->
<if condition="$show['spacer']">
</div>
$spacer_close
</if>
<!-- / post #$post[postid] -->
<!-- Start Post Thank You Hack -->
$post_thanks
<!-- End Post Thank You Hack -->

i have 124 queries!!

Why???

Alan @ CIT
17 Jun 2006, 14:33
Because something in your second postbit is running a bunch of silly queries in the PHP script :)

What hacks have you installed?

Thanks,
Alan.

hilfe-forum
17 Jun 2006, 15:36
hmm i have 124 queries with deactivateall Hacks...
Activate all hacks i have 213 queries...

More Posts in a Thread more queries.

makes the if condition the lot of queries?


sorry for bad english for

BamaStangGuy
17 Jun 2006, 23:56
Maybe highlight the changes between the two you made ;)

Paul M
18 Jun 2006, 00:42
Maybe highlight the changes between the two you made ;)The two are hugely different, there is so much stuff in the second one I wouldn't know where to start, there's even google adsense code in there.

Christine
18 Jun 2006, 00:58
hmm i have 124 queries with deactivateall Hacks...
Activate all hacks i have 213 queries...
Not possible. At a quick glance, I am seeing vbPlaza, can moderate, google, last online, thread starter image, vbbux, shouts, thanks, thanks stats, gallery stats, warnings, attachment, image links, google search in the sig section (form method="get" action="http://www.google.de/custom" ), and journaling.

sorry for bad english for Your english is fine. :)

Make a backup of your modified postbit, revert the postbit to default and one by one, add your hacks in and check the queries on each addition.

Reeve of shinra
18 Jun 2006, 01:37
Try getting rid of this in your postbit template. I had issues with it too.


<if condition="$post[journal_id]">
<tr>
<td class="vbmenu_option"><a

href="journal.php?$session[sessionurl]do=showjournal&j=$post[j

ournal_id]" title="$post[journaldesc]"><phrase

1="$post[username]">$vbphrase[visit_xs_journal]</phrase></a>

</td>
</if>

Marco van Herwaarden
18 Jun 2006, 17:59
My guess is that the can_moderate accounts for a big number of the extra queries.

hilfe-forum
18 Jun 2006, 20:23
The two are hugely different, there is so much stuff in the second one I wouldn't know where to start, there's even google adsense code in there.

much stuff is right.
but mor then 200 queries?

Not possible. At a quick glance, I am seeing vbPlaza, can moderate, google, last online, thread starter image, vbbux, shouts, thanks, thanks stats, gallery stats, warnings, attachment, image links, google search in the sig section (form method="get" action="http://www.google.de/custom" ), and journaling.

Your english is fine. :)

Make a backup of your modified postbit, revert the postbit to default and one by one, add your hacks in and check the queries on each addition.

ok thank you i try this.

Try getting rid of this in your postbit template. I had issues with it too.


<if condition="$post[journal_id]">
<tr>
<td class="vbmenu_option"><a

href="journal.php?$session[sessionurl]do=showjournal&j=$post[j

ournal_id]" title="$post[journaldesc]"><phrase

1="$post[username]">$vbphrase[visit_xs_journal]</phrase></a>

</td>
</if>



this i wil try to THX

My guess is that the can_moderate accounts for a big number of the extra queries.

tank you!

so i only remove this?


<if condition="$post['usertitle']">


<if

condition="can_moderate($thread[forumid],'',$post[userid])">


<br />


</if>


</if>


<div align="center" class="smallfont">



<if condition="$post['usertitle']">


<if

condition="can_moderate($thread[forumid],'',$post[userid])">


kann hier

moderieren<br><br>
</if>


</if>


or the adsense part to?


THX@ all for help!

i try this all and then i will report

Reeve of shinra
18 Jun 2006, 21:17
That looks right... you can leave the adsense in. That doesnt do anything for your queries.

ThomasR
11 Jul 2006, 15:32
it's perhaps a stupid question (and offtopic), but how can we see the querries count?

Paul M
11 Jul 2006, 16:27
Install microstats or turn on debug mode.

Reeve of shinra
12 Jul 2006, 02:48
miscrostats is almost a must when your constantly playing with hacks on yoru forum like I do.