PDA

View Full Version : 124!! queries


hilfe-forum
06-17-2006, 12:49 PM
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$p ost[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
06-17-2006, 01:33 PM
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
06-17-2006, 02:36 PM
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
06-17-2006, 10:56 PM
Maybe highlight the changes between the two you made ;)

Paul M
06-17-2006, 11:42 PM
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
06-17-2006, 11:58 PM
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
06-18-2006, 12:37 AM
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
06-18-2006, 04:59 PM
My guess is that the can_moderate accounts for a big number of the extra queries.

hilfe-forum
06-18-2006, 07:23 PM
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
06-18-2006, 08:17 PM
That looks right... you can leave the adsense in. That doesnt do anything for your queries.

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

Paul M
07-11-2006, 03:27 PM
Install microstats or turn on debug mode.

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