All pastes #1490574 Raw Edit

01

public text v1 · immutable
#1490574 ·published 2009-07-10 10:16 UTC
rendered paste body
<head>	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">	<meta name="description" content="[Fix] Large Satchel of Spoils">	<meta name="keywords" content="PHP, MySQL, bulletin, board, free, open, source, smf, simple, machines, forum">	<script language="JavaScript" type="text/javascript" src="http://udbforums.org/Themes/default/script.js?fin11"></script>	<script language="JavaScript" type="text/javascript"><!-- // --><![CDATA[		var smf_theme_url = "http://udbforums.org/Themes/default";		var smf_images_url = "http://udbforums.org/Themes/default/images";		var smf_scripturl = "http://udbforums.org/index.php";		var smf_iso_case_folding = false;		var smf_charset = "UTF-8";	// ]]></script>	<title>[Fix] Large Satchel of Spoils</title>	<link rel="stylesheet" type="text/css" href="http://udbforums.org/Themes/default/style.css?fin11">	<link rel="stylesheet" type="text/css" href="http://udbforums.org/Themes/default/print.css?fin11" media="print">	<link rel="help" href="http://udbforums.org/index.php?action=help" target="_blank">	<link rel="search" href="http://udbforums.org/index.php?action=search">	<link rel="contents" href="http://udbforums.org/index.php">	<link rel="alternate" type="application/rss xml" title="UDBForums - RSS" href="http://udbforums.org/index.php?type=rss;action=.xml">	<link rel="prev" href="http://udbforums.org/index.php?topic=13351.0;prev_next=prev">	<link rel="next" href="http://udbforums.org/index.php?topic=13351.0;prev_next=next">	<link rel="index" href="http://udbforums.org/index.php?board=17.0">	<script language="JavaScript" type="text/javascript"><!-- // --><![CDATA[		var current_header = false;		function shrinkHeader(mode)		{			smf_setThemeOption("collapse_header", mode ? 1 : 0, null, "24761cede8de65719736bc1c3ed8b0df");			document.getElementById("upshrink").src = smf_images_url   (mode ? "/upshrink2.gif" : "/upshrink.gif");			document.getElementById("upshrinkHeader").style.display = mode ? "none" : "";			document.getElementById("upshrinkHeader2").style.display = mode ? "none" : "";			current_header = mode;		}	// ]]></script>		<script language="JavaScript" type="text/javascript"><!-- // --><![CDATA[			var current_header_ic = false;			function shrinkHeaderIC(mode)			{				smf_setThemeOption("collapse_header_ic", mode ? 1 : 0, null, "24761cede8de65719736bc1c3ed8b0df");				document.getElementById("upshrink_ic").src = smf_images_url   (mode ? "/expand.gif" : "/collapse.gif");				document.getElementById("upshrinkHeaderIC").style.display = mode ? "none" : "";				current_header_ic = mode;			}		// ]]></script>	<link rel="stylesheet" type="text/css" href="http://udbforums.org/Themes/default/smfsyntax/smfsyntax.css"><style type="text/css">.dp-sql .func { color: #ff1493; }.dp-sql .op { color: #808080; }</style><style type="text/css">.dp-sql .func { color: #ff1493; }.dp-sql .op { color: #808080; }</style><style type="text/css">.dp-sql .func { color: #ff1493; }.dp-sql .op { color: #808080; }</style></head><body>	<div class="tborder">		<table width="100%" border="0" cellpadding="0" cellspacing="0">			<tbody><tr>				<td class="catbg" height="32">					<span style="font-family: Verdana,sans-serif; font-size: 140%;">UDBForums</span>				</td>				<td class="catbg" align="right">					<img src="http://udbforums.org/Themes/default/images/smflogo.gif" style="margin: 2px;" alt="">				</td>			</tr>		</tbody></table>		<table width="100%" border="0" cellpadding="0" cellspacing="0">			<tbody><tr>				<td class="titlebg2" height="32">					<span style="font-size: 130%;"> Hello <b>tinkttt</b></span>				</td>				<td class="titlebg2" align="right" height="32">					<span class="smalltext">July 10, 2009, 11:16:06 am</span>					<a href="#" onclick="shrinkHeader(!current_header); return false;"><img id="upshrink" src="http://udbforums.org/Themes/default/images/upshrink.gif" alt="*" title="Shrink or expand the header." style="margin: 0pt 1ex;" align="bottom"></a>				</td>			</tr>			<tr id="upshrinkHeader">				<td colspan="2" valign="top">					<table class="bordercolor" style="margin-top: 1px;" width="100%" border="0" cellpadding="8" cellspacing="1">						<tbody><tr>							<td colspan="2" class="windowbg2" valign="top" width="100%"><span class="middletext">								<a href="http://udbforums.org/index.php?action=unread">Show unread posts since last visit.</a> <br>								<a href="http://udbforums.org/index.php?action=unreadreplies">Show new replies to your posts.</a><br>								Total time logged in: 5 hours and 26 minutes.<br>				</span>							</td>						</tr>					</tbody></table>				</td>			</tr>		</tbody></table>		<table id="upshrinkHeader2" width="100%" border="0" cellpadding="4" cellspacing="0">			<tbody><tr>				<td class="titlebg2" width="90%">					<span class="smalltext"><b>News</b>: Clickable quick-links:<br><a href="http://udbforums.org/index.php?topic=12687.msg68964#msg68964" target="_blank">UDB Release 0.11.5: "What A Long, Strange Trip It's Been" Rev. 381 for 3.1.3</a><br><a href="http://udbforums.org/index.php?topic=11571.msg59723#msg59723" target="_blank">UDB Release 0.10.5: "Bag of Candies" Rev. 365 for 2.4.3 (no longer supported)</a><br><a href="http://wiki.udbforums.org/index.php/Main_Page" target="_blank">UDB Wiki documentation</a>&nbsp; &nbsp; <a href="http://getmangos.com/community/" target="_blank">MaNGOS Forums</a><br><a href="http://www.scriptdev2.com/" target="_blank">ScriptDev2 forums</a>&nbsp; &nbsp; &nbsp; &nbsp; <a href="http://www.trinitycore.org/forum/" target="_blank">Trinity Core Forums</a></span>				</td>				<td class="titlebg2" valign="top" align="right" nowrap="nowrap">					<form action="http://udbforums.org/index.php?action=search2" method="post" accept-charset="UTF-8" style="margin: 0pt;">						<a href="http://udbforums.org/index.php?action=search;advanced"><img src="http://udbforums.org/Themes/default/images/filter.gif" style="margin: 0pt 1ex;" alt="" align="middle"></a>						<input name="search" value="" style="width: 190px;" type="text">&nbsp;						<input name="submit" value="Search" style="width: 11ex;" type="submit">						<input name="advanced" value="0" type="hidden">						<input name="topic" value="13351" type="hidden">					</form>				</td>			</tr>		</tbody></table>	</div>			<table style="margin-left: 10px;" border="0" cellpadding="0" cellspacing="0">				<tbody><tr>					<td class="maintab_first">&nbsp;</td><td class="maintab_active_first">&nbsp;</td>				<td class="maintab_active_back" valign="top">					<a href="http://udbforums.org/index.php">Home</a>				</td><td class="maintab_active_last">&nbsp;</td>				<td class="maintab_back" valign="top">					<a href="http://udbforums.org/index.php?action=help">Help</a>				</td>				<td class="maintab_back" valign="top">					<a href="http://udbforums.org/index.php?action=search">Search</a>				</td>				<td class="maintab_back" valign="top">					<a href="http://udbforums.org/index.php?action=profile">Profile</a>				</td>				<td class="maintab_back" valign="top">					<a href="http://udbforums.org/index.php?action=pm">My Messages </a>				</td>				<td class="maintab_back" valign="top">					<a href="http://udbforums.org/index.php?action=calendar">Calendar</a>				</td>				<td class="maintab_back" valign="top">					<a href="http://udbforums.org/index.php?action=mlist">Members</a>				</td>				<td class="maintab_back" valign="top">					<a href="http://udbforums.org/index.php?action=logout;sesc=24761cede8de65719736bc1c3ed8b0df">Logout</a>				</td>				<td class="maintab_last">&nbsp;</td>			</tr>		</tbody></table>	<div id="bodyarea" style="padding: 1ex 0px 2ex;"><a name="top"></a><a name="msg69668"></a><div><div class="nav" style="font-size: smaller; margin-bottom: 2ex; margin-top: 2ex;"><b><a href="http://udbforums.org/index.php" class="nav">UDBForums</a></b>&nbsp;&gt;&nbsp;<b><a href="http://udbforums.org/index.php#15" class="nav">Database Development</a></b>&nbsp;&gt;&nbsp;<b><a href="http://udbforums.org/index.php?board=17.0" class="nav">Accepted Fixes</a></b>&nbsp;&gt;&nbsp;<b><a href="http://udbforums.org/index.php?topic=13351.0" class="nav">[Fix] Large Satchel of Spoils</a></b></div></div><table width="100%" border="0" cellpadding="0" cellspacing="0">	<tbody><tr>		<td class="middletext" style="padding-bottom: 4px;" valign="bottom">Pages: [<b>1</b>] </td>		<td style="padding-right: 1ex;" align="right">			<div class="nav" style="margin-bottom: 2px;"> <a href="http://udbforums.org/index.php?topic=13351.0;prev_next=prev#new">« previous</a> <a href="http://udbforums.org/index.php?topic=13351.0;prev_next=next#new">next »</a></div>			<table cellpadding="0" cellspacing="0">				<tbody><tr>							<td class="mirrortab_first">&nbsp;</td>		<td class="mirrortab_back"><a href="http://udbforums.org/index.php?action=notify;sa=on;topic=13351.0;sesc=24761cede8de65719736bc1c3ed8b0df" onclick="return confirm('Are you sure you wish to enable notification of new replies for this topic?');">Notify</a> &nbsp;|&nbsp; <a href="http://udbforums.org/index.php?action=markasread;sa=topic;t=0;topic=13351.0;sesc=24761cede8de65719736bc1c3ed8b0df">Mark unread</a> &nbsp;|&nbsp; <a href="http://udbforums.org/index.php?action=sendtopic;topic=13351.0">Send this topic</a> &nbsp;|&nbsp; <a href="http://udbforums.org/index.php?action=printpage;topic=13351.0" target="_blank">Print</a></td>		<td class="mirrortab_last">&nbsp;</td>				</tr>			</tbody></table>		</td>	</tr></tbody></table><table class="tborder" style="border-bottom: 0pt none;" width="100%" border="0" cellpadding="3" cellspacing="0">		<tbody><tr class="catbg3">				<td style="padding-left: 6px;" valign="middle" width="2%">						<img src="http://udbforums.org/Themes/default/images/topic/normal_post.gif" alt="" align="bottom">				</td>				<td width="13%"> Author</td>				<td style="padding-left: 6px;" id="top_subject" valign="middle" width="85%">						Topic: [Fix] Large Satchel of Spoils &nbsp;(Read 440 times)				</td>		</tr>		<tr>				<td colspan="3" class="smalltext">1 Member and 0 Guests are viewing this topic.				</td>		</tr></tbody></table><form action="http://udbforums.org/index.php?action=quickmod2;topic=13351.0" method="post" accept-charset="UTF-8" name="quickModForm" id="quickModForm" style="margin: 0pt;" onsubmit="return in_edit_mode == 1 ? modify_save('24761cede8de65719736bc1c3ed8b0df') : confirm('Are you sure you want to do this?');"><table class="bordercolor" width="100%" border="0" cellpadding="0" cellspacing="0">	<tbody><tr><td style="padding: 1px 1px 0pt;">		<table width="100%" border="0" cellpadding="3" cellspacing="0">			<tbody><tr><td class="windowbg">				<table style="table-layout: fixed;" width="100%" cellpadding="5" cellspacing="0">					<tbody><tr>						<td rowspan="2" style="overflow: hidden;" valign="top" width="16%">							<b><a href="http://udbforums.org/index.php?action=profile;u=12867" title="View the profile of JoN0">JoN0</a></b>							<div class="smalltext">								Jr. Member<br>								<img src="http://udbforums.org/Themes/default/images/star.gif" alt="*" border="0"><img src="http://udbforums.org/Themes/default/images/star.gif" alt="*" border="0"><br>								<a href="http://udbforums.org/index.php?action=pm;sa=send;u=12867" title="Personal Message (Offline)"><img src="http://udbforums.org/Themes/default/images/useroff.gif" alt="Offline" style="margin-top: 2px;" border="0"></a><span class="smalltext"> Offline</span><br><br>								Posts: 67<br>								<br>																																<br>								<a href="http://udbforums.org/index.php?action=profile;u=12867"><img src="http://udbforums.org/Themes/default/images/icons/profile_sm.gif" alt="View Profile" title="View Profile" border="0"></a>								<a href="http://udbforums.org/index.php?action=pm;sa=send;u=12867" title="Personal Message (Offline)"><img src="http://udbforums.org/Themes/default/images/im_off.gif" alt="Personal Message (Offline)" border="0"></a>							</div>						</td>						<td valign="top" width="85%" height="100%">							<table width="100%" border="0"><tbody><tr>								<td valign="middle"><a href="http://udbforums.org/index.php?topic=13351.msg69668#msg69668"><img src="http://udbforums.org/Themes/default/images/post/xx.gif" alt="" border="0"></a></td>								<td valign="middle">									<div style="font-weight: bold;" id="subject_69668">										<a href="http://udbforums.org/index.php?topic=13351.msg69668#msg69668">[Fix] Large Satchel of Spoils</a>									</div>									<div class="smalltext">« <b> on:</b> June 23, 2009, 11:27:45 am »</div></td>								<td style="font-size: smaller;" valign="bottom" align="right" height="20">								</td>							</tr></tbody></table>							<hr class="hrcolor" size="1" width="100%">							<div class="post">Large Satchel of Spoils(43346) that drops from Sartharion in Heroic mode does not contain any Emblem of Valor.<br><br><div class="codeheader">Code: sql</div><div class="dp-highlighter"><div class="bar"><div class="tools"><a href="#" onclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a><a href="#" onclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy to clipboard</a><a href="#" onclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="#" onclick="dp.sh.Toolbar.Command('About',this);return false;">?</a></div></div><ol class="dp-sql" start="1"><li class="alt"><span><span class="keyword">DELETE</span><span> </span><span class="keyword">FROM</span><span> item_loot_template </span><span class="keyword">WHERE</span><span> entry=43346;&nbsp;&nbsp;</span></span></li><li class=""><span><span class="keyword">INSERT</span><span> </span><span class="keyword">INTO</span><span> item_loot_template </span><span class="keyword">VALUES</span><span>&nbsp;&nbsp;</span></span></li><li class="alt"><span>(43346, 40753, 100, 0, 5, 5, 0, 0, 0);&nbsp;&nbsp;</span></li></ol></div><pre style="display: none;" name="code" class="sql">DELETE FROM item_loot_template WHERE entry=43346;<br>INSERT INTO item_loot_template VALUES<br>(43346, 40753, 100, 0, 5, 5, 0, 0, 0);<br></pre></div>						</td>					</tr>					<tr>						<td class="smalltext" valign="bottom" width="85%">							<table style="table-layout: fixed;" width="100%" border="0"><tbody><tr>								<td colspan="2" class="smalltext" width="100%">								</td>							</tr><tr>								<td class="smalltext" id="modified_69668" valign="bottom">									« <i>Last Edit: June 23, 2009, 11:38:02 am by JoN0</i> »								</td>								<td class="smalltext" valign="bottom" align="right">									<a href="http://udbforums.org/index.php?action=reporttm;topic=13351.0;msg=69668">Report to moderator</a> &nbsp;									<img src="http://udbforums.org/Themes/default/images/ip.gif" alt="" border="0">									<a href="http://udbforums.org/index.php?action=helpadmin;help=see_member_ip" onclick="return reqWin(this.href);" class="help">Logged</a>								</td>							</tr></tbody></table>						</td>					</tr>				</tbody></table>			</td></tr>		</tbody></table>	</td></tr>	<tr><td style="padding: 1px 1px 0pt;">		<a name="msg69669"></a>		<table width="100%" border="0" cellpadding="3" cellspacing="0">			<tbody><tr><td class="windowbg2">				<table style="table-layout: fixed;" width="100%" cellpadding="5" cellspacing="0">					<tbody><tr>						<td rowspan="2" style="overflow: hidden;" valign="top" width="16%">							<b><a href="http://udbforums.org/index.php?action=profile;u=746" title="View the profile of subhuman_bob">subhuman_bob</a></b>							<div class="smalltext">								Developers<br>								Hero Member<br>								<img src="http://udbforums.org/Themes/default/images/stargmod.gif" alt="*" border="0"><img src="http://udbforums.org/Themes/default/images/stargmod.gif" alt="*" border="0"><img src="http://udbforums.org/Themes/default/images/stargmod.gif" alt="*" border="0"><img src="http://udbforums.org/Themes/default/images/stargmod.gif" alt="*" border="0"><img src="http://udbforums.org/Themes/default/images/stargmod.gif" alt="*" border="0"><br>								<a href="http://udbforums.org/index.php?action=pm;sa=send;u=746" title="Personal Message (Offline)"><img src="http://udbforums.org/Themes/default/images/useroff.gif" alt="Offline" style="margin-top: 2px;" border="0"></a><span class="smalltext"> Offline</span><br><br>								Posts: 2247<br>								<br>								<div style="overflow: auto; width: 100%;"><img src="http://udbforums.org/index.php?action=dlattach;attach=197;type=avatar" alt="" class="avatar" border="0"></div><br>																<a href="http://members.msn.com/subhuman_bob@hotmail.com" target="_blank"><img src="http://udbforums.org/Themes/default/images/msntalk.gif" alt="subhuman_bob@hotmail.com" border="0"></a>																<br>								<a href="http://udbforums.org/index.php?action=profile;u=746"><img src="http://udbforums.org/Themes/default/images/icons/profile_sm.gif" alt="View Profile" title="View Profile" border="0"></a>								<a href="http://udbforums.kicks-ass.net" title="UDB Community Forums" target="_blank"><img src="http://udbforums.org/Themes/default/images/www_sm.gif" alt="WWW" border="0"></a>								<a href="http://udbforums.org/index.php?action=pm;sa=send;u=746" title="Personal Message (Offline)"><img src="http://udbforums.org/Themes/default/images/im_off.gif" alt="Personal Message (Offline)" border="0"></a>							</div>						</td>						<td valign="top" width="85%" height="100%">							<table width="100%" border="0"><tbody><tr>								<td valign="middle"><a href="http://udbforums.org/index.php?topic=13351.msg69669#msg69669"><img src="http://udbforums.org/Themes/default/images/post/xx.gif" alt="" border="0"></a></td>								<td valign="middle">									<div style="font-weight: bold;" id="subject_69669">										<a href="http://udbforums.org/index.php?topic=13351.msg69669#msg69669">Re: [Fix] Large Satchel of Spoils</a>									</div>									<div class="smalltext">« <b>Reply #1 on:</b> June 23, 2009, 11:35:00 am »</div></td>								<td style="font-size: smaller;" valign="bottom" align="right" height="20">								</td>							</tr></tbody></table>							<hr class="hrcolor" size="1" width="100%">							<div class="post">There no need to put it in groupid=1 when it's by itself.<br>AFAIK that doesn't hurt anything, but it's not helping anything either.<br>Also, this should have been posted in "Loot Bugs" since it's a loot-table update.<br><br>The part I'm posting, however belongs in "Item Bugs" where you made this post.<br><br><div class="codeheader">Code: sql</div><div class="dp-highlighter"><div class="bar"><div class="tools"><a href="#" onclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a><a href="#" onclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy to clipboard</a><a href="#" onclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="#" onclick="dp.sh.Toolbar.Command('About',this);return false;">?</a></div></div><ol class="dp-sql" start="1"><li class="alt"><span><span class="keyword">UPDATE</span><span> `item_template` </span><span class="keyword">SET</span><span> `minMoneyLoot` = </span><span class="string">'500000'</span><span>, `maxMoneyLoot` = </span><span class="string">'750000'</span><span> </span><span class="keyword">WHERE</span><span> `entry` = </span><span class="string">'43346'</span><span>;&nbsp;&nbsp;</span></span></li></ol></div><pre style="display: none;" name="code" class="sql">UPDATE `item_template` SET `minMoneyLoot` = '500000', `maxMoneyLoot` = '750000' WHERE `entry` = '43346';<br></pre><br>per comments: <a href="http://www.wowhead.com/?item=43346#comments" target="_blank">http://www.wowhead.com/?item=43346#comments</a><br><br>First part (loot fix) accepted by me.&nbsp; Would like another Dev to verify second part (money) before moving to accepted fixes.</div>						</td>					</tr>					<tr>						<td class="smalltext" valign="bottom" width="85%">							<table style="table-layout: fixed;" width="100%" border="0"><tbody><tr>								<td colspan="2" class="smalltext" width="100%">								</td>							</tr><tr>								<td class="smalltext" id="modified_69669" valign="bottom">									« <i>Last Edit: June 23, 2009, 11:40:06 am by subhuman_bob</i> »								</td>								<td class="smalltext" valign="bottom" align="right">									<a href="http://udbforums.org/index.php?action=reporttm;topic=13351.1;msg=69669">Report to moderator</a> &nbsp;									<img src="http://udbforums.org/Themes/default/images/ip.gif" alt="" border="0">									<a href="http://udbforums.org/index.php?action=helpadmin;help=see_member_ip" onclick="return reqWin(this.href);" class="help">Logged</a>								</td>							</tr></tbody></table>							<hr class="hrcolor" size="1" width="100%">							<div class="signature"><i>Lack of understanding by you does not constitute a bug by us.</i><br><br><img src="http://img167.imageshack.us/img167/2065/wda.th.png" alt="" border="0"></div>						</td>					</tr>				</tbody></table>			</td></tr>		</tbody></table>	</td></tr>	<tr><td style="padding: 1px 1px 0pt;">		<a name="msg69670"></a>		<table width="100%" border="0" cellpadding="3" cellspacing="0">			<tbody><tr><td class="windowbg">				<table style="table-layout: fixed;" width="100%" cellpadding="5" cellspacing="0">					<tbody><tr>						<td rowspan="2" style="overflow: hidden;" valign="top" width="16%">							<b><a href="http://udbforums.org/index.php?action=profile;u=12867" title="View the profile of JoN0">JoN0</a></b>							<div class="smalltext">								Jr. Member<br>								<img src="http://udbforums.org/Themes/default/images/star.gif" alt="*" border="0"><img src="http://udbforums.org/Themes/default/images/star.gif" alt="*" border="0"><br>								<a href="http://udbforums.org/index.php?action=pm;sa=send;u=12867" title="Personal Message (Offline)"><img src="http://udbforums.org/Themes/default/images/useroff.gif" alt="Offline" style="margin-top: 2px;" border="0"></a><span class="smalltext"> Offline</span><br><br>								Posts: 67<br>								<br>																																<br>								<a href="http://udbforums.org/index.php?action=profile;u=12867"><img src="http://udbforums.org/Themes/default/images/icons/profile_sm.gif" alt="View Profile" title="View Profile" border="0"></a>								<a href="http://udbforums.org/index.php?action=pm;sa=send;u=12867" title="Personal Message (Offline)"><img src="http://udbforums.org/Themes/default/images/im_off.gif" alt="Personal Message (Offline)" border="0"></a>							</div>						</td>						<td valign="top" width="85%" height="100%">							<table width="100%" border="0"><tbody><tr>								<td valign="middle"><a href="http://udbforums.org/index.php?topic=13351.msg69670#msg69670"><img src="http://udbforums.org/Themes/default/images/post/xx.gif" alt="" border="0"></a></td>								<td valign="middle">									<div style="font-weight: bold;" id="subject_69670">										<a href="http://udbforums.org/index.php?topic=13351.msg69670#msg69670">Re: [Fix] Large Satchel of Spoils</a>									</div>									<div class="smalltext">« <b>Reply #2 on:</b> June 23, 2009, 11:38:37 am »</div></td>								<td style="font-size: smaller;" valign="bottom" align="right" height="20">								</td>							</tr></tbody></table>							<hr class="hrcolor" size="1" width="100%">							<div class="post">hahah i thought so too. anyway query changed to reflect it.&nbsp; <img src="http://udbforums.org/Smileys/default/cheesy.gif" alt="Cheesy" border="0"></div>						</td>					</tr>					<tr>						<td class="smalltext" valign="bottom" width="85%">							<table style="table-layout: fixed;" width="100%" border="0"><tbody><tr>								<td colspan="2" class="smalltext" width="100%">								</td>							</tr><tr>								<td class="smalltext" id="modified_69670" valign="bottom">								</td>								<td class="smalltext" valign="bottom" align="right">									<a href="http://udbforums.org/index.php?action=reporttm;topic=13351.2;msg=69670">Report to moderator</a> &nbsp;									<img src="http://udbforums.org/Themes/default/images/ip.gif" alt="" border="0">									<a href="http://udbforums.org/index.php?action=helpadmin;help=see_member_ip" onclick="return reqWin(this.href);" class="help">Logged</a>								</td>							</tr></tbody></table>						</td>					</tr>				</tbody></table>			</td></tr>		</tbody></table>	</td></tr>	<tr><td style="padding: 1px 1px 0pt;">		<a name="msg69732"></a>		<table width="100%" border="0" cellpadding="3" cellspacing="0">			<tbody><tr><td class="windowbg2">				<table style="table-layout: fixed;" width="100%" cellpadding="5" cellspacing="0">					<tbody><tr>						<td rowspan="2" style="overflow: hidden;" valign="top" width="16%">							<b><a href="http://udbforums.org/index.php?action=profile;u=67" title="View the profile of Buuggen">Buuggen</a></b>							<div class="smalltext">								Developers<br>								Hero Member<br>								<img src="http://udbforums.org/Themes/default/images/stargmod.gif" alt="*" border="0"><img src="http://udbforums.org/Themes/default/images/stargmod.gif" alt="*" border="0"><img src="http://udbforums.org/Themes/default/images/stargmod.gif" alt="*" border="0"><img src="http://udbforums.org/Themes/default/images/stargmod.gif" alt="*" border="0"><img src="http://udbforums.org/Themes/default/images/stargmod.gif" alt="*" border="0"><br>								<a href="http://udbforums.org/index.php?action=pm;sa=send;u=67" title="Personal Message (Offline)"><img src="http://udbforums.org/Themes/default/images/useroff.gif" alt="Offline" style="margin-top: 2px;" border="0"></a><span class="smalltext"> Offline</span><br><br>								Posts: 2352<br>								<br>								<div style="overflow: auto; width: 100%;"><img src="http://udbforums.org/index.php?action=dlattach;attach=119;type=avatar" alt="" class="avatar" border="0"></div><br>																																<br>								<a href="http://udbforums.org/index.php?action=profile;u=67"><img src="http://udbforums.org/Themes/default/images/icons/profile_sm.gif" alt="View Profile" title="View Profile" border="0"></a>								<a href="http://udbforums.org/index.php?action=pm;sa=send;u=67" title="Personal Message (Offline)"><img src="http://udbforums.org/Themes/default/images/im_off.gif" alt="Personal Message (Offline)" border="0"></a>							</div>						</td>						<td valign="top" width="85%" height="100%">							<table width="100%" border="0"><tbody><tr>								<td valign="middle"><a href="http://udbforums.org/index.php?topic=13351.msg69732#msg69732"><img src="http://udbforums.org/Themes/default/images/post/xx.gif" alt="" border="0"></a></td>								<td valign="middle">									<div style="font-weight: bold;" id="subject_69732">										<a href="http://udbforums.org/index.php?topic=13351.msg69732#msg69732">Re: [Fix] Large Satchel of Spoils</a>									</div>									<div class="smalltext">« <b>Reply #3 on:</b> June 24, 2009, 08:14:52 am »</div></td>								<td style="font-size: smaller;" valign="bottom" align="right" height="20">								</td>							</tr></tbody></table>							<hr class="hrcolor" size="1" width="100%">							<div class="post"><div class="codeheader">Code: sql</div><div class="dp-highlighter"><div class="bar"><div class="tools"><a href="#" onclick="dp.sh.Toolbar.Command('ViewSource',this);return false;">view plain</a><a href="#" onclick="dp.sh.Toolbar.Command('CopyToClipboard',this);return false;">copy to clipboard</a><a href="#" onclick="dp.sh.Toolbar.Command('PrintSource',this);return false;">print</a><a href="#" onclick="dp.sh.Toolbar.Command('About',this);return false;">?</a></div></div><ol class="dp-sql" start="1"><li class="alt"><span><span class="keyword">DELETE</span><span> </span><span class="keyword">FROM</span><span> item_loot_template </span><span class="keyword">WHERE</span><span> entry=43346;&nbsp;&nbsp;</span></span></li><li class=""><span><span class="keyword">INSERT</span><span> </span><span class="keyword">INTO</span><span> item_loot_template </span><span class="keyword">VALUES</span><span>&nbsp;&nbsp;</span></span></li><li class="alt"><span>(43346, 40753, 100, 0, 5, 5, 0, 0, 0);&nbsp;&nbsp;</span></li><li class=""><span><span class="keyword">UPDATE</span><span> `item_template` </span><span class="keyword">SET</span><span> `minMoneyLoot` = </span><span class="string">'500000'</span><span>, `maxMoneyLoot` = </span><span class="string">'750000'</span><span> </span><span class="keyword">WHERE</span><span> `entry` = </span><span class="string">'43346'</span><span>;&nbsp;&nbsp;</span></span></li></ol></div><pre style="display: none;" name="code" class="sql">DELETE FROM item_loot_template WHERE entry=43346;<br>INSERT INTO item_loot_template VALUES<br>(43346, 40753, 100, 0, 5, 5, 0, 0, 0);<br>UPDATE `item_template` SET `minMoneyLoot` = '500000', `maxMoneyLoot` = '750000' WHERE `entry` = '43346';<br></pre></div>						</td>					</tr>					<tr>						<td class="smalltext" valign="bottom" width="85%">							<table style="table-layout: fixed;" width="100%" border="0"><tbody><tr>								<td colspan="2" class="smalltext" width="100%">								</td>							</tr><tr>								<td class="smalltext" id="modified_69732" valign="bottom">								</td>								<td class="smalltext" valign="bottom" align="right">									<a href="http://udbforums.org/index.php?action=reporttm;topic=13351.3;msg=69732">Report to moderator</a> &nbsp;									<img src="http://udbforums.org/Themes/default/images/ip.gif" alt="" border="0">									<a href="http://udbforums.org/index.php?action=helpadmin;help=see_member_ip" onclick="return reqWin(this.href);" class="help">Logged</a>								</td>							</tr></tbody></table>						</td>					</tr>				</tbody></table>			</td></tr>		</tbody></table>	</td></tr>	<tr><td style="padding: 0pt 0pt 1px;"></td></tr></tbody></table><a name="lastPost"></a><table width="100%" border="0" cellpadding="0" cellspacing="0">	<tbody><tr>		<td class="middletext">Pages: [<b>1</b>] </td>		<td style="padding-right: 1ex;" align="right">			<table cellpadding="0" cellspacing="0">				<tbody><tr>							<td class="maintab_first">&nbsp;</td>		<td class="maintab_back"><a href="http://udbforums.org/index.php?action=notify;sa=on;topic=13351.0;sesc=24761cede8de65719736bc1c3ed8b0df" onclick="return confirm('Are you sure you wish to enable notification of new replies for this topic?');">Notify</a> &nbsp;|&nbsp; <a href="http://udbforums.org/index.php?action=markasread;sa=topic;t=0;topic=13351.0;sesc=24761cede8de65719736bc1c3ed8b0df">Mark unread</a> &nbsp;|&nbsp; <a href="http://udbforums.org/index.php?action=sendtopic;topic=13351.0">Send this topic</a> &nbsp;|&nbsp; <a href="http://udbforums.org/index.php?action=printpage;topic=13351.0" target="_blank">Print</a></td>		<td class="maintab_last">&nbsp;</td>				</tr>			</tbody></table>		</td>	</tr></tbody></table><script language="JavaScript" type="text/javascript" src="http://udbforums.org/Themes/default/xml_topic.js"></script><script language="JavaScript" type="text/javascript"><!-- // --><![CDATA[	quickReplyCollapsed = true;	smf_topic = 13351;	smf_start = 0;	smf_show_modify = 1;	// On quick modify, this is what the body will look like.	var smf_template_body_edit = '<div id="error_box" style="padding: 4px; color: red;"></div><textarea class="editor" name="message" rows="12" style="width: 94%; margin-bottom: 10px;">%body%</textarea><br /><input type="hidden" name="sc" value="24761cede8de65719736bc1c3ed8b0df" /><input type="hidden" name="topic" value="13351" /><input type="hidden" name="msg" value="%msg_id%" /><div style="text-align: center;"><input type="submit" name="post" value="Save" onclick="return modify_save(\'24761cede8de65719736bc1c3ed8b0df\');" accesskey="s" />&nbsp;&nbsp;<input type="submit" name="cancel" value="Cancel" onclick="return modify_cancel();" /></div>';	// And this is the replacement for the subject.	var smf_template_subject_edit = '<input type="text" name="subject" value="%subject%" size="60" style="width: 99%;"  maxlength="80" />';	// Restore the message to this after editing.	var smf_template_body_normal = '%body%';	var smf_template_subject_normal = '<a href="http://udbforums.org/index.php?topic=13351.msg%msg_id%#msg%msg_id%">%subject%</a>';	var smf_template_top_subject = "Topic: %subject% &nbsp;(Read 440 times)"	if (window.XMLHttpRequest)		showModifyButtons();// ]]></script><table style="margin-bottom: 1ex;" width="100%" border="0" cellpadding="0" cellspacing="0">		<tbody><tr>				<td class="nav" valign="top" align="right"> <a href="http://udbforums.org/index.php?topic=13351.0;prev_next=prev#new">« previous</a> <a href="http://udbforums.org/index.php?topic=13351.0;prev_next=next#new">next »</a></td>		</tr></tbody></table>	<table style="margin-left: 1ex;" border="0" cellpadding="0" cellspacing="0">		<tbody><tr>			<td>&nbsp;</td>		</tr>	</tbody></table></form><div class="tborder"><div class="titlebg2" style="padding: 4px;" align="right">	<form action="http://udbforums.org/index.php" method="get" accept-charset="UTF-8" style="margin: 0pt; padding: 0pt;">		<span class="smalltext">Jump to:</span>		<select name="jumpto" id="jumpto" onchange="if (this.selectedIndex > 0 &amp;&amp; this.options[this.selectedIndex].value) window.location.href = smf_scripturl   this.options[this.selectedIndex].value.substr(smf_scripturl.indexOf('?') == -1 || this.options[this.selectedIndex].value.substr(0, 1) != '?' ? 0 : 1);">			<option value="">Please select a destination:</option>			<option value="" disabled="disabled">-----------------------------</option>			<option value="#4">General</option>			<option value="" disabled="disabled">-----------------------------</option>			<option value="?board=5.0"> =&gt; Releases &amp; Announcements</option>			<option value="?board=28.0"> =&gt; Help and Support</option>			<option value="" disabled="disabled">-----------------------------</option>			<option value="#15">Database Development</option>			<option value="" disabled="disabled">-----------------------------</option>			<option value="?board=29.0"> =&gt; Content Development</option>			<option value="?board=16.0"> =&gt; New Fixes</option>			<option value="?board=17.0" selected="selected"> =&gt; Accepted Fixes</option>			<option value="?board=18.0"> ===&gt; Rejected Fixes</option>			<option value="?board=53.0"> ===&gt; Previous Update Packs</option>			<option value="" disabled="disabled">-----------------------------</option>			<option value="#6">Bug Reports</option>			<option value="" disabled="disabled">-----------------------------</option>			<option value="?board=10.0"> =&gt; Misc Bugs</option>			<option value="?board=112.0"> ===&gt; Graveyards</option>			<option value="?board=113.0"> ===&gt; Instance</option>			<option value="?board=114.0"> ===&gt; Game tele</option>			<option value="?board=115.0"> ===&gt; Game events</option>			<option value="?board=116.0"> ===&gt; Achievements</option>			<option value="?board=9.0"> =&gt; Console Errors</option>			<option value="?board=14.0"> =&gt; Gameobject Bugs</option>			<option value="?board=13.0"> =&gt; Item Bugs</option>			<option value="?board=66.0"> =&gt; Loot Bugs</option>			<option value="?board=7.0"> =&gt; NPC Bugs</option>			<option value="?board=8.0"> =&gt; Quest Bugs</option>			<option value="?board=107.0"> ===&gt; Quest Relations</option>			<option value="?board=108.0"> ===&gt; Quest Reputation</option>			<option value="?board=109.0"> ===&gt; Quest Chains</option>			<option value="?board=110.0"> ===&gt; Quest template WDB</option>			<option value="?board=111.0"> ===&gt; Quest Escort/Events</option>			<option value="?board=117.0"> ===&gt; Quest Texts</option>			<option value="?board=106.0"> =&gt; *scripts* bugs</option>			<option value="?board=67.0"> =&gt; Spawn Bugs</option>			<option value="?board=68.0"> ===&gt; Gameobject Spawns</option>			<option value="?board=69.0"> ===&gt; NPC spawns</option>			<option value="?board=46.0"> =&gt; Closed Bugs</option>			<option value="?board=56.0"> ===&gt; Bogus Bug Reports</option>			<option value="?board=64.0"> ===&gt; Closed - Needs core support</option>			<option value="?board=65.0"> ===&gt; Closed - Needs script support</option>			<option value="" disabled="disabled">-----------------------------</option>			<option value="#20">Data Development Tools</option>			<option value="" disabled="disabled">-----------------------------</option>			<option value="?board=63.0"> =&gt; Tools</option>			<option value="?board=24.0"> ===&gt; Database Tools</option>			<option value="?board=23.0"> ===&gt; Mangos Tools</option>			<option value="?board=22.0"> ===&gt; C  </option>			<option value="?board=21.0"> ===&gt; PHP</option>			<option value="?board=25.0"> ===&gt; SQL</option>			<option value="" disabled="disabled">-----------------------------</option>			<option value="#40">UDB Translations</option>			<option value="" disabled="disabled">-----------------------------</option>			<option value="?board=60.0"> =&gt; Languages</option>			<option value="?board=41.0"> ===&gt; French</option>			<option value="?board=89.0"> =====&gt; News, Releases &amp; Announcements</option>			<option value="?board=90.0"> =====&gt; Help &amp; Support</option>			<option value="?board=91.0"> =====&gt; General discussions</option>			<option value="?board=92.0"> =====&gt; Quests</option>			<option value="?board=93.0"> =====&gt; Creatures</option>			<option value="?board=94.0"> =====&gt; Gameobjects</option>			<option value="?board=95.0"> =====&gt; npc_texts</option>			<option value="?board=96.0"> =====&gt; Page Texts</option>			<option value="?board=97.0"> =====&gt; MaNGOS Strings</option>			<option value="?board=98.0"> =====&gt; Items</option>			<option value="?board=101.0"> =====&gt; SD2 and ACID Texts</option>			<option value="?board=99.0"> =====&gt; Accepted Fixes</option>			<option value="?board=100.0"> =====&gt; Closed Topics</option>			<option value="?board=42.0"> ===&gt; German</option>			<option value="?board=45.0"> ===&gt; Spanish</option>			<option value="?board=49.0"> ===&gt; Russian</option>			<option value="?board=59.0"> ===&gt; Simplified Chinese</option>			<option value="?board=70.0"> ===&gt; Czech</option>			<option value="?board=71.0"> ===&gt; Italian</option>			<option value="?board=72.0"> =====&gt; News, Releases &amp; Announcements</option>			<option value="?board=73.0"> =====&gt; Help &amp; Support</option>			<option value="?board=74.0"> =====&gt; General Discussions</option>			<option value="?board=75.0"> =====&gt; Quests</option>			<option value="?board=76.0"> =====&gt; Creatures</option>			<option value="?board=77.0"> =====&gt; Gameobjects</option>			<option value="?board=78.0"> =====&gt; npc_texts</option>			<option value="?board=79.0"> =====&gt; Page Text</option>			<option value="?board=80.0"> =====&gt; Mangos Strings</option>			<option value="?board=102.0"> =====&gt; SD2 and ACID Texts</option>			<option value="?board=82.0"> =====&gt; Accepted Fixes</option>			<option value="?board=83.0"> =====&gt; Closed Topics</option>			<option value="" disabled="disabled">-----------------------------</option>			<option value="#48">Non UDB</option>			<option value="" disabled="disabled">-----------------------------</option>			<option value="?board=19.0"> =&gt; The Offline Channel</option>			<option value="?board=36.0"> =&gt; Workarounds and User content</option>			<option value="?board=118.0"> ===&gt; 1.12 development</option>			<option value="?board=47.0"> =&gt; Core Support</option>		</select>&nbsp;		<input value="go" onclick="if (this.form.jumpto.options[this.form.jumpto.selectedIndex].value) window.location.href = 'http://udbforums.org/index.php'   this.form.jumpto.options[this.form.jumpto.selectedIndex].value;" type="button">	</form></div></div><br>	</div>	<div id="footerarea" style="text-align: center; padding-bottom: 1ex;">		<script language="JavaScript" type="text/javascript"><!-- // --><![CDATA[			function smfFooterHighlight(element, value)			{				element.src = smf_images_url   "/"   (value ? "h_" : "")   element.id   ".gif";			}		// ]]></script>		<table width="100%" align="center" border="0" cellpadding="3" cellspacing="0">			<tbody><tr>				<td valign="middle" width="28%" align="right">					<a href="http://www.mysql.com/" target="_blank"><img id="powered-mysql" src="http://udbforums.org/Themes/default/images/powered-mysql.gif" alt="Powered by MySQL" style="margin: 5px 16px;" onmouseover="smfFooterHighlight(this, true);" onmouseout="smfFooterHighlight(this, false);" width="54" height="20"></a>					<a href="http://www.php.net/" target="_blank"><img id="powered-php" src="http://udbforums.org/Themes/default/images/powered-php.gif" alt="Powered by PHP" style="margin: 5px 16px;" onmouseover="smfFooterHighlight(this, true);" onmouseout="smfFooterHighlight(this, false);" width="54" height="20"></a>				</td>				<td style="white-space: nowrap;" valign="middle" align="center">							<span class="smalltext" style="display: inline; visibility: visible; font-family: Verdana,Arial,sans-serif;"><a href="http://www.simplemachines.org/" title="Simple Machines Forum" target="_blank">Powered by SMF 1.1.9</a> | <a href="http://www.simplemachines.org/about/copyright.php" title="Free Forum Software" target="_blank">SMF © 2006-2009, Simple Machines LLC</a>		</span>				</td>				<td valign="middle" width="28%" align="left">					<a href="http://validator.w3.org/check/referer" target="_blank"><img id="valid-xhtml10" src="http://udbforums.org/Themes/default/images/valid-xhtml10.gif" alt="Valid XHTML 1.0!" style="margin: 5px 16px;" onmouseover="smfFooterHighlight(this, true);" onmouseout="smfFooterHighlight(this, false);" width="54" height="20"></a>					<a href="http://jigsaw.w3.org/css-validator/check/referer" target="_blank"><img id="valid-css" src="http://udbforums.org/Themes/default/images/valid-css.gif" alt="Valid CSS!" style="margin: 5px 16px;" onmouseover="smfFooterHighlight(this, true);" onmouseout="smfFooterHighlight(this, false);" width="54" height="20"></a>				</td>			</tr>		</tbody></table>		<script language="JavaScript" type="text/javascript"><!-- // --><![CDATA[			window.addEventListener("load", smf_codeFix, false);			function smf_codeFix()			{				var codeFix = document.getElementsByTagName ? document.getElementsByTagName("div") : document.all.tags("div");				for (var i = 0; i < codeFix.length; i  )				{					if (codeFix[i].className == "code" && (codeFix[i].scrollWidth > codeFix[i].clientWidth || codeFix[i].clientWidth == 0))						codeFix[i].style.overflow = "scroll";				}			}		// ]]></script>	</div>	<div id="ajax_in_progress" style="display: none;">Loading...</div>		<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shCore.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushColdFusion.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushCpp.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushCSharp.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushCss.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushDelphi.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushJava.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushJScript.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushPerl.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushPhp.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushPlSql.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushPython.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushRuby.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushSql.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushVb.js"></script>	<script type="text/javascript" src="http://udbforums.org/Themes/default/smfsyntax/shBrushXml.js"></script>		<script type="text/javascript">		dp.SyntaxHighlighter.ClipboardSwf = 'http://udbforums.org/Themes/default/smfsyntax/clipboard.swf';		dp.SyntaxHighlighter.BloggerMode();		dp.SyntaxHighlighter.HighlightAll('code');	</script>	</body>