PHP ApiGetShopData API

<?php
require("includes/config.inc.php");
header("Content-type: text/xml");

echo "<?xml version=\"1.0\"?>\n";
echo "<shopInfo>\n";

$qry = mysql_query("SELECT * from DataSkill2Price");
echo "<skills>";
while($skill = mysql_fetch_array($qry))
{
    echo "<sk SkillID=\"".$skill['SkillID']."\" Lv1=\"".$skill['Lv1']."\" Lv2=\"".$skill['Lv2']."\" Lv3=\"".$skill['Lv3']."\" Lv4=\"".$skill['Lv4']."\" Lv5=\"".$skill['Lv5']."\"></sk>\n";
}
echo "</skills>";

echo "<items>";

$qry = mysql_query("SELECT * FROM Items_Gear");
while($gear = mysql_fetch_array($qry))
{
    echo "<si itemId=\"".$gear['ItemID']."\" price1d=\"".$gear['Price1']."\" price7d=\"".$gear['Price7']."\" price30d=\"".$gear['Price30']."\" pricePerm=\"".$gear['PriceP']."\" gd_price1d=\"".$gear['GPrice1']."\" gd_price7d=\"".$gear['GPrice7']."\" gd_price30d=\"".$gear['GPrice30']."\" gd_pricePerm=\"".$gear['GPriceP']."\"></si>\n";
}

$qry = mysql_query("SELECT * FROM Items_Weapons");
while($gear = mysql_fetch_array($qry))
{
    echo "<si itemId=\"".$gear['ItemID']."\" price1d=\"".$gear['Price1']."\" price7d=\"".$gear['Price7']."\" price30d=\"".$gear['Price30']."\" pricePerm=\"".$gear['PriceP']."\" gd_price1d=\"".$gear['GPrice1']."\" gd_price7d=\"".$gear['GPrice7']."\" gd_price30d=\"".$gear['GPrice30']."\" gd_pricePerm=\"".$gear['GPriceP']."\"></si>\n";
}

$qry = mysql_query("SELECT * FROM Items_Generic");
while($gear = mysql_fetch_array($qry))
{
    echo "<si itemId=\"".$gear['ItemID']."\" price1d=\"".$gear['Price1']."\" price7d=\"".$gear['Price7']."\" price30d=\"".$gear['Price30']."\" pricePerm=\"".$gear['PriceP']."\" gd_price1d=\"".$gear['GPrice1']."\" gd_price7d=\"".$gear['GPrice7']."\" gd_price30d=\"".$gear['GPrice30']."\" gd_pricePerm=\"".$gear['GPriceP']."\"></si>\n";
}

$qry = mysql_query("SELECT * FROM Items_Attachments");
while($gear = mysql_fetch_array($qry))
{
    echo "<si itemId=\"".$gear['ItemID']."\" price1d=\"".$gear['Price1']."\" price7d=\"".$gear['Price7']."\" price30d=\"".$gear['Price30']."\" pricePerm=\"".$gear['PriceP']."\" gd_price1d=\"".$gear['GPrice1']."\" gd_price7d=\"".$gear['GPrice7']."\" gd_price30d=\"".$gear['GPrice30']."\" gd_pricePerm=\"".$gear['GPriceP']."\"></si>\n";
}

$qry = mysql_query("SELECT * from Items_Packages");
while($pack = mysql_fetch_array($qry))
{
    if($pack['IsEnabled'] == 0)
        continue;
    echo "<package itemId=\"".$pack['ItemID']."\" price1d=\"".$pack['Price1']."\" price7d=\"".$pack['Price7']."\" price30d=\"".$pack['Price30']."\" pricePerm=\"".$pack['PriceP']."\" gd_price1d=\"".$pack['GPrice1']."\" gd_price7d=\"".$pack['GPrice7']."\" gd_price30d=\"".$pack['GPrice30']."\" gd_pricePerm=\"".$pack['GPriceP']."\"></package>\n";
}
echo "</items>";

echo "</shopInfo>";

/*echo "WO_0";*/
?>