rendered paste body$result=mysql_query("SELECT * FROM `creature_template` , `creature_questrelation` , `creature_involvedrelation` , `quest_template` WHERE `quest_template`.`entry` = '$creaid' AND `creature_questrelation`.`quest` = `quest_template`.`entry` AND `creature_involvedrelation`.`quest` = `quest_template`.`entry` AND `creature_questrelation`.`id` = `creature_template`.`entry` LIMIT 100;") or die(mysql_error()); while ($row=mysql_fetch_array($result)) { $questname=$row['Title'];$npcid=$row['0'];$npcname=$row['name'];$prevquestid=$row['PrevQuestId'];$lvl=$row['MinLevel'];$sortas=$row['ZoneOrSort'];$proflvl=$row['RequiredSkillValue'];$mission=$row['SpecialFlags'];$race=$row['RequiredRaces'];$class=$row['RequiredClass']; switch($sortas) { case -24: $kintamas="Herbalism"; break; case -101: $kintamas="Fishing"; break; case -181: $kintamas="Alchemy"; break; case -182: $kintamas="Leatherworking"; break; case -201: $kintamas="Engineering"; break; case -264: $kintamas="Tailoring"; break; case -304: $kintamas="Cooking"; break; case -324: $kintamas="First Aid"; break; case -121: $kintamas="Blacksmithing"; break; default: }}; if ( $mission != 0 ) { for( $i = 0; $i <= 14; $i++ ) { switch( $mission & pow( 2, $i ) ) { case 1: $kintamas2.="<li><u>Atnešti(1)</u></li>"; $atnesti1=$row['ReqItemId1']; $atnesti2=$row['ReqItemId2']; $atnesti3=$row['ReqItemId3']; $atnesti4=$row['ReqItemId4']; $atnestikiek1=$row['ReqItemCount1']; $atnestikiek2=$row['ReqItemCount2']; $atnestikiek3=$row['ReqItemCount3']; $atnestikiek4=$row['ReqItemCount4']; break; case 2: $kintamas2.="<li><u>Apžiūrėti(2)</u></li>"; break; case 4: $kintamas2.="<li><u>Pasišnekėti(4)</u></li>"; break; case 8: $kintamas2.="<li><u>Nužudyti arba užbūrti(8)</u></li>"; $npcorobj1=$row['ReqCreatureOrGOId1']; $npcorobj2=$row['ReqCreatureOrGOId2']; $npcorobj3=$row['ReqCreatureOrGOId3']; $npcorobj4=$row['ReqCreatureOrGOId4']; $npcorobjkiek1=$row['ReqCreatureOrGOCount1']; $npcorobjkiek2=$row['ReqCreatureOrGOCount2']; $npcorobjkiek3=$row['ReqCreatureOrGOCount3']; $npcorobjkiek4=$row['ReqCreatureOrGOCount4']; $reikcast1=$row['ReqSpellCast1']; $reikcast2=$row['ReqSpellCast2']; $reikcast3=$row['ReqSpellCast3']; $reikcast4=$row['ReqSpellCast4']; break; case 16: $kintamas2.="<li><u>+ Laiko apribojimas(16)</u></li>"; break; case 32: $kintamas2.="<li><u>Nežinomas(32)</u></li>"; break; case 64: $kintamas2.="<li><u>Nežinomas(64)</u></li>"; break; default: } }};