Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 06-17-2006, 12:49 PM
hilfe-forum hilfe-forum is offline
 
Join Date: Sep 2005
Location: http://www.alpha-board.eu
Posts: 198
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 124!! queries

wen i open a Thred with this postbit:

Code:
<!-- 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:


Code:
<!-- 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???
Reply With Quote
  #2  
Old 06-17-2006, 01:33 PM
Alan @ CIT Alan @ CIT is offline
 
Join Date: Nov 2004
Location: South UK
Posts: 625
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Because something in your second postbit is running a bunch of silly queries in the PHP script

What hacks have you installed?

Thanks,
Alan.
Reply With Quote
  #3  
Old 06-17-2006, 02:36 PM
hilfe-forum hilfe-forum is offline
 
Join Date: Sep 2005
Location: http://www.alpha-board.eu
Posts: 198
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #4  
Old 06-17-2006, 10:56 PM
BamaStangGuy's Avatar
BamaStangGuy BamaStangGuy is offline
 
Join Date: Mar 2004
Location: Alabama
Posts: 521
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Maybe highlight the changes between the two you made
Reply With Quote
  #5  
Old 06-17-2006, 11:42 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by BamaStangGuy
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.
Reply With Quote
  #6  
Old 06-17-2006, 11:58 PM
Christine's Avatar
Christine Christine is offline
 
Join Date: Oct 2001
Location: PA
Posts: 472
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by hilfe-forum
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.

Quote:
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.
Reply With Quote
  #7  
Old 06-18-2006, 12:37 AM
Reeve of shinra's Avatar
Reeve of shinra Reeve of shinra is offline
 
Join Date: Oct 2001
Location: NYC
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

HTML Code:
<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>
Reply With Quote
  #8  
Old 06-18-2006, 04:59 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

My guess is that the can_moderate accounts for a big number of the extra queries.
Reply With Quote
  #9  
Old 06-18-2006, 07:23 PM
hilfe-forum hilfe-forum is offline
 
Join Date: Sep 2005
Location: http://www.alpha-board.eu
Posts: 198
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Paul M
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?

Quote:
Originally Posted by Christine
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.

Quote:
Originally Posted by Reeve of shinra
Try getting rid of this in your postbit template. I had issues with it too.

HTML Code:
<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

Quote:
Originally Posted by MarcoH64
My guess is that the can_moderate accounts for a big number of the extra queries.
tank you!

so i only remove this?

Code:
		<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
Reply With Quote
  #10  
Old 06-18-2006, 08:17 PM
Reeve of shinra's Avatar
Reeve of shinra Reeve of shinra is offline
 
Join Date: Oct 2001
Location: NYC
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That looks right... you can leave the adsense in. That doesnt do anything for your queries.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:47 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04908 seconds
  • Memory Usage 2,349KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (2)bbcode_html
  • (7)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete