$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:
		}
	}
};