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> <a href="http://getmangos.com/community/" target="_blank">MaNGOS Forums</a><br><a href="http://www.scriptdev2.com/" target="_blank">ScriptDev2 forums</a> <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"> <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"> </td><td class="maintab_active_first"> </td> <td class="maintab_active_back" valign="top"> <a href="http://udbforums.org/index.php">Home</a> </td><td class="maintab_active_last"> </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"> </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> > <b><a href="http://udbforums.org/index.php#15" class="nav">Database Development</a></b> > <b><a href="http://udbforums.org/index.php?board=17.0" class="nav">Accepted Fixes</a></b> > <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"> </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> | <a href="http://udbforums.org/index.php?action=markasread;sa=topic;t=0;topic=13351.0;sesc=24761cede8de65719736bc1c3ed8b0df">Mark unread</a> | <a href="http://udbforums.org/index.php?action=sendtopic;topic=13351.0">Send this topic</a> | <a href="http://udbforums.org/index.php?action=printpage;topic=13351.0" target="_blank">Print</a></td> <td class="mirrortab_last"> </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 (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; </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> </span></span></li><li class="alt"><span>(43346, 40753, 100, 0, 5, 5, 0, 0, 0); </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> <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>; </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. 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> <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. <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> <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; </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> </span></span></li><li class="alt"><span>(43346, 40753, 100, 0, 5, 5, 0, 0, 0); </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>; </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> <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"> </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> | <a href="http://udbforums.org/index.php?action=markasread;sa=topic;t=0;topic=13351.0;sesc=24761cede8de65719736bc1c3ed8b0df">Mark unread</a> | <a href="http://udbforums.org/index.php?action=sendtopic;topic=13351.0">Send this topic</a> | <a href="http://udbforums.org/index.php?action=printpage;topic=13351.0" target="_blank">Print</a></td> <td class="maintab_last"> </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" /> <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% (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> </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 && 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"> => Releases & Announcements</option> <option value="?board=28.0"> => 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"> => Content Development</option> <option value="?board=16.0"> => New Fixes</option> <option value="?board=17.0" selected="selected"> => Accepted Fixes</option> <option value="?board=18.0"> ===> Rejected Fixes</option> <option value="?board=53.0"> ===> 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"> => Misc Bugs</option> <option value="?board=112.0"> ===> Graveyards</option> <option value="?board=113.0"> ===> Instance</option> <option value="?board=114.0"> ===> Game tele</option> <option value="?board=115.0"> ===> Game events</option> <option value="?board=116.0"> ===> Achievements</option> <option value="?board=9.0"> => Console Errors</option> <option value="?board=14.0"> => Gameobject Bugs</option> <option value="?board=13.0"> => Item Bugs</option> <option value="?board=66.0"> => Loot Bugs</option> <option value="?board=7.0"> => NPC Bugs</option> <option value="?board=8.0"> => Quest Bugs</option> <option value="?board=107.0"> ===> Quest Relations</option> <option value="?board=108.0"> ===> Quest Reputation</option> <option value="?board=109.0"> ===> Quest Chains</option> <option value="?board=110.0"> ===> Quest template WDB</option> <option value="?board=111.0"> ===> Quest Escort/Events</option> <option value="?board=117.0"> ===> Quest Texts</option> <option value="?board=106.0"> => *scripts* bugs</option> <option value="?board=67.0"> => Spawn Bugs</option> <option value="?board=68.0"> ===> Gameobject Spawns</option> <option value="?board=69.0"> ===> NPC spawns</option> <option value="?board=46.0"> => Closed Bugs</option> <option value="?board=56.0"> ===> Bogus Bug Reports</option> <option value="?board=64.0"> ===> Closed - Needs core support</option> <option value="?board=65.0"> ===> 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"> => Tools</option> <option value="?board=24.0"> ===> Database Tools</option> <option value="?board=23.0"> ===> Mangos Tools</option> <option value="?board=22.0"> ===> C </option> <option value="?board=21.0"> ===> PHP</option> <option value="?board=25.0"> ===> SQL</option> <option value="" disabled="disabled">-----------------------------</option> <option value="#40">UDB Translations</option> <option value="" disabled="disabled">-----------------------------</option> <option value="?board=60.0"> => Languages</option> <option value="?board=41.0"> ===> French</option> <option value="?board=89.0"> =====> News, Releases & Announcements</option> <option value="?board=90.0"> =====> Help & Support</option> <option value="?board=91.0"> =====> General discussions</option> <option value="?board=92.0"> =====> Quests</option> <option value="?board=93.0"> =====> Creatures</option> <option value="?board=94.0"> =====> Gameobjects</option> <option value="?board=95.0"> =====> npc_texts</option> <option value="?board=96.0"> =====> Page Texts</option> <option value="?board=97.0"> =====> MaNGOS Strings</option> <option value="?board=98.0"> =====> Items</option> <option value="?board=101.0"> =====> SD2 and ACID Texts</option> <option value="?board=99.0"> =====> Accepted Fixes</option> <option value="?board=100.0"> =====> Closed Topics</option> <option value="?board=42.0"> ===> German</option> <option value="?board=45.0"> ===> Spanish</option> <option value="?board=49.0"> ===> Russian</option> <option value="?board=59.0"> ===> Simplified Chinese</option> <option value="?board=70.0"> ===> Czech</option> <option value="?board=71.0"> ===> Italian</option> <option value="?board=72.0"> =====> News, Releases & Announcements</option> <option value="?board=73.0"> =====> Help & Support</option> <option value="?board=74.0"> =====> General Discussions</option> <option value="?board=75.0"> =====> Quests</option> <option value="?board=76.0"> =====> Creatures</option> <option value="?board=77.0"> =====> Gameobjects</option> <option value="?board=78.0"> =====> npc_texts</option> <option value="?board=79.0"> =====> Page Text</option> <option value="?board=80.0"> =====> Mangos Strings</option> <option value="?board=102.0"> =====> SD2 and ACID Texts</option> <option value="?board=82.0"> =====> Accepted Fixes</option> <option value="?board=83.0"> =====> Closed Topics</option> <option value="" disabled="disabled">-----------------------------</option> <option value="#48">Non UDB</option> <option value="" disabled="disabled">-----------------------------</option> <option value="?board=19.0"> => The Offline Channel</option> <option value="?board=36.0"> => Workarounds and User content</option> <option value="?board=118.0"> ===> 1.12 development</option> <option value="?board=47.0"> => Core Support</option> </select> <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>