The Arcive of Official vBulletin Modifications Site.

CampinCarl · #1 04-30-2008, 12:45 AM

I need to get information from a different table to work in my postbit
The info I need is from a table called players, and the fields coming from that table are field 12 and 11
also, this line is meant to check and see if there is a field with the same info as field 5, is it correct? "<if condition="$post['field12'] == $post['field5']">"
If someone could please help me out, that would be great

Code:

<if condition="$post['field12'] == $post['field5']">
<if condition="$post['field11']">
		<tr>
			<td bgcolor="#181818" width="20%" nowrap>
				<if condition="$post['field11'] == 0">
					<else />
					<if condition="$post['field11'] < 100"><div class="smallfont">Surf Rank:</div>
					<else />
					<if condition="$post['field11'] < 250"><div class="smallfont">Surf Rank:</div>
					<else />
					<if condition="$post['field11'] < 500"><div class="smallfont">Surf Rank:</div>
					<else />
					<if condition="$post['field11'] < 1000"><div class="smallfont">Surf Rank:</div>
					<else />
					<if condition="$post['field11'] > 1000"><div class="smallfont">Surf Rank:</div>
					<else />
				</if>
			</if>
		</if>
	</if>
</if>
				</if></td>
			<td bgcolor="#181818">					<if condition="$post['field11'] == 0">
	<else />
	<if condition="$post['field11'] < 100"><div class="smallfont"><b>Newb</b></div>
	<else />
	<if condition="$post['field11'] < 250"><div class="smallfont"><b>Intermediate</b></div>
	<else />
	<if condition="$post['field11'] < 500"><div class="smallfont"><b>Pro</b></div>
	<else />
	<if condition="$post['field11'] < 1000"><div class="smallfont"><b>Guru</b></div>
	<else />
	<if condition="$post['field11'] > 1000"><div class="smallfont"><b>God</b></div>
	<else />
	</if>
	</if>
	</if>
	</if>
	</if>
</if></td>
		</tr>
</if>
</if>
	</table>
</if>

Dismounted · #2 04-30-2008, 07:04 AM

$post['field12'] == $post['field5'] means if both field12 and field5 are the same, it is true.

CampinCarl · #3 04-30-2008, 01:18 PM

Ok, so when it confirms that they are the same, does that make it so it will then get the information for field 11 from the same line that field 12 has the same info as field 5?

Dismounted · #4 05-01-2008, 05:53 AM

It is only a comparison, it does not do any processing. It only compares if they are both the same, if they are, it prints the code within the block.

CampinCarl · #5 05-01-2008, 01:03 PM

oh ok.
And my last question was: how do I make it so I can get field 11 and 12 from a different table?

Dismounted · #6 05-01-2008, 01:36 PM

If you're getting fields from a different table, you don't name them field11 or field12. They should be reserved for actual profile fields. YOu will need to crate a plugin querying the database to fetch data from a table.

CampinCarl · #7 05-02-2008, 12:14 AM

oh field11 and 12 were just test fields to see if my if else statement worked... Could you please post exactly what I need to put in to make that work? thanks a bundle

Dismounted · #8 05-02-2008, 11:28 AM

I can't telepathically tell what you're trying to fetch you know...

CampinCarl · #9 05-02-2008, 01:04 PM

rats!
heres my entre postbit
I need the field steamid and totalpoints to be taken from sql table "players". What this is supposed to do is check to see if their steamid (field5) corresponds with the field steams id in players (which is what the field5 == steamid thing is supposed to do), then it gets the total points info from the same field that field5 corresponds to steamid, and displays a rank based on the amount of points there are.

Code:

$template_hook[postbit_start]
<table class="tborder" id="post$post[postid]" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
	<td class="thead" $post[scrolltothis]>
		<div class="normal" style="float:$stylevar[right]">
			&nbsp;
			<if condition="$show['postcount']">#<a href="showpost.php?$session[sessionurl]p=$post[postid]&amp;postcount=$post[postcount]" target="new" rel="nofollow" id="postcount$post[postid]" name="$post[postcount]"><strong>$post[postcount]</strong></a> &nbsp;</if>
			<if condition="$show['reputationlink']">
				<span id="reputationmenu_$post[postid]"><a href="reputation.php?$session[sessionurl]p=$post[postid]" rel="nofollow" id="reputation_$post[postid]"><img class="inlineimg" src="$stylevar[imgdir_button]/reputation.gif" alt="<phrase 1="$post[username]">$vbphrase[add_to_xs_reputation]</phrase>" border="0" /></a></span>
				<if condition="$show['popups']"><script type="text/javascript"> vbrep_register("$post[postid]")</script></if>&nbsp;
			</if>
			<if condition="$show['infractionlink']"><a href="infraction.php?$session[sessionurl]do=report&amp;p=$post[postid]" rel="nofollow"><img class="inlineimg" src="$stylevar[imgdir_button]/infraction.gif" alt="<phrase 1="$post[username]">$vbphrase[add_infraction_for_x]</phrase>" border="0" /></a> &nbsp;</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> &nbsp;</if>
			$post[iplogged]
			<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]" />
			</if>
		</div>

		<div class="normal">
			<!-- 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>
			<if condition="!$show['announcement']">
				$post[postdate]<if condition="!$show['detailedtime']">, $post[posttime]</if>
			<else />
				<phrase 1="$post[startdate]" 2="$post[enddate]">$vbphrase[x_until_y]</phrase>
			</if>
			$post[firstnewinsert]
			<!-- / status icon and date -->
		</div>
	</td>
</tr>
<tr>
	<td class="alt2" style="padding:0px">
		<!-- user info -->
		<table cellpadding="0" cellspacing="$stylevar[cellpadding]" border="0" width="100%">
		<tr>
			<if condition="$show['avatar']"><td class="alt2"><a href="member.php?$session[sessionurl]u=$post[userid]"><img src="$post[avatarurl]" $post[avwidth] $post[avheight] alt="<phrase 1="$post[username]">$vbphrase[xs_avatar]</phrase>" border="0" /></a></td></if>
			<td nowrap="nowrap">

				<div id="postmenu_$post[postid]">
					<if condition="$show['profile']">
					<a class="bigusername" href="member.php?$session[sessionurl]u=$post[userid]">$post[musername]</a>
					$post[onlinestatus]
					<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['reputation']"><div class="smallfont"><span id="repdisplay_$post[postid]_$post[userid]">$post[reputationdisplay]</span></div></if>
				$template_hook[postbit_userinfo_left]

			</td>
			<td valign="top" width="100%">
			<if condition="$post['field5']">
<table border="0" width="100%" cellpadding="2">
<tr>
<td bgcolor="#181818" nowrap width="13%"><div class="smallfont">STEAM ID:</div></td>
<td bgcolor="#181818"><div class="smallfont"><b>$post[field5]</b></div></td>
</tr>
<if condition="$post['steamid'] == $post['field5']">
<if condition="$post['totalpoints']">
<tr>
<td bgcolor="#181818" width="13%" nowrap>
<if condition="$post['totalpoints'] == 0"><else />
<if condition="$post['totalpoints'] < 1"><div class="smallfont">Surf Rank:</div>
</if>
</td>
<td bgcolor="#181818">
<if condition="$post['field11'] == 0"><else />
<if condition="$post['totalpoints'] < 100"><div class="smallfont"><b>Newb</b></div><else />
<if condition="$post['totalpoints'] < 250"><div class="smallfont"><b>Intermediate</b></div><else />
<if condition="$post['totalpoints'] < 500"><div class="smallfont"><b>Pro</b></div><else />
<if condition="$post['totalpoints'] < 1000"><div class="smallfont"><b>Guru</b></div><else />
<if condition="$post['totalpoints'] > 1000"><div class="smallfont"><b>God</b></div><else />
</if></if></if></if></if></if></if></td></tr></if></if></table></if>
			<td valign="top" nowrap="nowrap">

				<div class="smallfont">
					<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>
					$template_hook[postbit_userinfo_right_after_posts]
					<if condition="$show['infraction']"><div>$vbphrase[infractions]: $post[warnings]/$post[infractions] ($post[ipoints])</div></if>
					$template_hook[postbit_userinfo_right]
					<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon] $post[skypeicon]</div>
				</div>

			</td>
		</tr>
		</table>
		<!-- / user info -->
	</td>
</tr>
<tr>
	<td class="alt1" id="td_post_$post[postid]">
	<!-- message, attachments, sig -->

		$template_hook[postbit_messagearea_start]

		<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]; background-color:$stylevar[tborder_bgcolor]" />
			<!-- / icon and title -->
		</if>

		<!-- message -->
		<div id="post_message_$post[postid]" class="post_message">$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>

		$template_hook[postbit_signature_start]

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

		$template_hook[postbit_signature_end]

		<if condition="$show['postedited']">
		<!-- edit note -->
			<div class="smallfont">
				<hr size="1" style="color:$stylevar[tborder_bgcolor]; background-color:$stylevar[tborder_bgcolor]" />
				<em>
					<if condition="$show['postedithistory']">
						<phrase 1="$post[edit_username]" 2="$post[edit_date]" 3="$post[edit_time]" 4="posthistory.php?$session[sessionurl]p=$post[postid]">$vbphrase[last_edited_link_by_x_on_y_at_z_postid]</phrase>.
					<else />
						<phrase 1="$post[edit_username]" 2="$post[edit_date]" 3="$post[edit_time]">$vbphrase[last_edited_by_x_on_y_at_z]</phrase>.
					</if>
					<if condition="$post['edit_reason']">
						$vbphrase[reason]: $post[edit_reason]
					</if>
				</em>
			</div>
		<!-- / edit note -->
		</if>

		<div style="margin-top: 10px" align="$stylevar[right]">
			<!-- controls -->
			<if condition="$post['editlink']">
				<img style="display: none" id="progress_$postid" src="$stylevar[imgdir_misc]/progress.gif" alt="$vbphrase[loading_editor_please_wait]" />
				<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['multiquote_post']">
				<a href="$post[replylink]" rel="nofollow" onclick="return false"><img src="$stylevar[imgdir_button]/multiquote_<if condition="$show['multiquote_selected']">on<else />off</if>.gif" alt="$vbphrase[multi_quote_this_message]" border="0" id="mq_$post[postid]" /></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>
			<if condition="$show['spam']">
				<img src="$stylevar[imgdir_misc]/spam_detected.png" alt="$vbphrase[spam_post]" border="0" />
			</if>
			<if condition="$show['deletedpost']">
				<img src="$stylevar[imgdir_misc]/trashcan.gif" alt="$vbphrase[deleted_post]" border="0" />
			</if>
			<if condition="$show['redcard']">
				<a href="infraction.php?$session[sessionurl]do=view&amp;p=$post[postid]"><img src="$stylevar[imgdir_button]/redcard.gif" alt="$vbphrase[received_infraction]" border="0" /></a>
			<else />
				<if condition="$show['yellowcard']">
					<a href="infraction.php?$session[sessionurl]do=view&amp;p=$post[postid]"><img src="$stylevar[imgdir_button]/yellowcard.gif" alt="$vbphrase[received_warning]" border="0" /></a>
				</if>
			</if>
			$template_hook[postbit_controls]
			<!-- / controls -->
		</div>

	<!-- message, attachments, sig -->

	</td>
</tr>
</table>
$template_hook[postbit_end]

<!-- 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]">$vbphrase[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&amp;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=$post[userid]" rel="nofollow"><phrase 1="$post[username]">$vbphrase[find_all_posts_by_x]</phrase></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=buddy&amp;u=$post[userid]"><phrase 1="$post[username]">$vbphrase[add_x_to_contacts]</phrase></a></td></tr>
	</if>
	$template_hook[postbit_user_popup]
	</table>
</div>
<!-- / post $post[postid] popup menu -->

Dismounted · #10 05-03-2008, 04:08 AM

You will need to hook into one of the thread fetching processes to fetch your data along with the rest of the post data. The structure of the query should allow for extra fields to be fetched. However, do not hook at a postbit_display process, as that will cause a query to be run every time a post is displayed.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04605 seconds Memory Usage 2,311KB 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 (2)bbcode_code (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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!