core::$sql -> changeDB('acc');
if(core::$sql -> numRows("select * from Evangelion_uniques where CharName='$hData[CharName16]'") == 0)
{
echo "<td>This character has no uniques killed ! </td></table>";
}
else
{
echo "<td><u>Latest Unique Kills by :$hData[CharName16] </u><br /><br />
<table id='table-3' border='0' cellpadding='0' cellspacing='0'>
<td>Unique name</td><td>Time</td><tr/>";
$hQuery = core::$sql -> exec("select top 30 * from Evangelion_uniques where CharName='$hData[CharName16]' order by time desc");
while($row = mssql_fetch_array($hQuery))
{
$datetime1 = $row['time'];
$mssqldate1 = date("d-m-y", $datetime1);
echo "<tr>";
$UniqueType = $row['MobName'];
switch($UniqueType) {
// Tiger Girl
case "MOB_CH_TIGERWOMAN":
echo '<td>Tiger Girl</td><td>'.$mssqldate1.'</td>';
break;
case "MOB_CH_TIGERWOMAN_L3":
echo '<td>Tiger Girl (Titan)</td><td>'.$mssqldate1.'</td>';
break;
// Cerberus
case "MOB_EU_KERBEROS":
echo '<td>Cerberus</td><td>'.$mssqldate1.'</td>';
break;
case "MOB_EU_KERBEROS_L3":
echo '<td>Cerberus (Titan)</td><td>'.$mssqldate1.'</td>';
break;
// Captain Ivy
case "MOB_AM_IVY":
echo '<td>Captain Ivy</td><td>'.$mssqldate1.'</td>';
break;
case "MOB_AM_IVY_L3":
echo '<td>Captain Ivy (Titan)</td><td>'.$mssqldate1.'</td>';
break;
// Uruchi
case "MOB_OA_URUCHI":
echo '<td>Uruchi</td><td>'.$mssqldate1.'</td>';
break;
case "MOB_OA_URUCHI_L3":
echo '<td>Uruchi (Titan)</td><td>'.$mssqldate1.'</td>';
break;
// Isyutaru
case "MOB_KK_ISYUTARU":
echo '<td>Isyutaru</td><td>'.$mssqldate1.'</td>';
break;
case "MOB_KK_ISYUTARU_L3":
echo '<td>Isyutaru (Titan)</td><td>'.$mssqldate1.'</td>';
break;
// Lord Yarkan
case "MOB_TK_BONELORD":
echo '<td>Lord Yarkan</td><td>'.$mssqldate1.'</td>';
break;
case "MOB_TK_BONELORD_L3":
echo '<td>Lord Yarkan (Titan)</td><td>'.$mssqldate1.'</td>';
break;
// Demon Shaitan
case "MOB_RM_TAHOMET":
echo '<td>Demon Shaitan</td><td>'.$mssqldate1.'</td>';
break;
case "MOB_RM_TAHOMET_L3":
echo '<td>Demon Shaitan (Titan)</td><td>'.$mssqldate1.'</td>';
break;
// SoSo The Black Viper
case "MOB_TQ_BLACKSNAKE":
echo '<td>SoSo The Hades Viper</td><td>'.$mssqldate1.'</td>';
break;
case "MOB_TQ_BLACKSNAKE_L3":
echo '<td>SoSo The Hades Viper (Titan)</td><td>'.$mssqldate1.'</td>';
break;
// BeakYung The White Viper (Medusa)
case "MOB_TQ_WHITESNAKE":
echo '<td>BeakYung The White Viper (Medusa)</td><td>'.$mssqldate1.'</td>';
break;
// if none of the list above , do not show at all.
default:
break;
}
echo "<tr/>";
}
echo "</table></td></table>";
core::$sql -> changeDB('shard');
}
misc::back();
} else echo "Owner of account on which this character is created didn't want you to view he's (her) data.<br/>";
}
}
else
{
core::$sql -> changeDB("shard");
$hQuery = core::$sql -> exec("select top 50 * from _Char where CharName16 not like '%[GM]%' order by CurLevel desc");
case('set_char'):
if(isset($_GET['name']) && addslashes(security::isSecureString($_GET['name'], 3)))
{
$nCharName = $_GET['name'];
core::$sql -> changeDB("shard");
echo "
<table id='table-3' border='1' cellpadding='0' cellspacing='0'>
<tr>
<td>Char Name</td>
<td>Item Type</td>
<td>Image</td>
<td>Item Name</td>
<td>Type</td>
<td>Level</td>
<td>Plus Value</td>
</tr>
";
$query = core::$sql -> exec("
select it.OptLevel,
ch.CharName16,
obj.AssocFileIcon128,
obj.Country,
obj.CodeName128 ,
obj.ReqLevel1 ,
SealType = CASE
WHEN PATINDEX('%_11%_' + '%A_RARE',obj.CodeName128) > 0 THEN ' Seal of Nova'
WHEN PATINDEX('%_11%_' + '%SET_B_RARE',obj.CodeName128) > 0 THEN ' Egy A'
WHEN PATINDEX('%_11%_' + '%SET_A_RARE',obj.CodeName128) > 0 THEN ' Egy B'
WHEN PATINDEX('%A_RARE',obj.CodeName128) > 0 THEN ' Seal of Star'
WHEN PATINDEX('%B_RARE',obj.CodeName128) > 0 THEN ' Seal of Moon'
WHEN PATINDEX('%C_RARE',obj.CodeName128) > 0 THEN ' Seal of Sun'
ELSE 'Normal'
END,
CASE
WHEN inv.Slot = 0 THEN 'Head'
WHEN inv.Slot = 1 THEN 'Suit'
WHEN inv.Slot = 2 THEN 'Shoulders'
WHEN inv.Slot = 3 THEN 'Hands'
WHEN inv.Slot = 4 THEN 'Legs'
WHEN inv.Slot = 5 THEN 'Shoes'
WHEN inv.Slot = 6 THEN 'Weapon'
WHEN inv.Slot = 7 THEN 'Shield/Arrow'
WHEN inv.Slot = 9 THEN 'Earring'
WHEN inv.Slot = 10 THEN 'Necklace'
WHEN inv.Slot = 11 THEN 'Ring (L)'
WHEN inv.Slot = 12 THEN 'Ring (R)'
ELSE 'NO clue'
END as 'ItemType',
adv.nOptValue ,
es.EndTextString
from _Items as it
LEFT JOIN [dbo].[_Inventory] as inv ON it.ID64 = inv.ItemID
LEFT JOIN [dbo].[_Char] as ch ON inv.CharID = ch.CharID
LEFT JOIN [dbo].[_RefObjCommon] as obj ON it.RefItemID = obj.ID
LEFT JOIN [dbo].[_RefObjItem] as item ON obj.Link = item.ID
LEFT JOIN [dbo].[_BindingOptionWithItem] as adv on it.ID64 = adv.nItemDBID AND adv.bOptType = 2
LEFT JOIN [dbo].[C_EquipStrings] as es on obj.NameStrID128 = es.TextString
where ch.CharName16 = '$nCharName' and inv.Slot between 0 and 12 and inv.Slot != 8
");
while ($row = mssql_fetch_array($query)){
echo '<tr>';
echo '<td align="center"><a href="?pg=rank&type=char&name='.$row['CharName16'].'">'.$row['CharName16'].'</a></td>';
echo '<td>'.$row['ItemType'].'</td>';
if($row['AssocFileIcon128'] == 'xxx'){
echo '<td><img src="./item/clean.png" width="32" height="32" alt=""/></td>';
} else {
echo '<td><img src="./'.$row['AssocFileIcon128'].'.png" width="32" height="32" alt=""/></td>';
}
if($row['CodeName128'] == 'DUMMY_OBJECT'){
echo '<td>-</td>';
} else {
echo '<td>'.$row['EndTextString'].'</td>';
}
$totalvalue = $row['OptLevel']+$row['nOptValue'];
$advonly = $row['nOptValue'];
if($row['CodeName128'] == 'ITEM_ETC_AMMO_ARROW_01' || $row['CodeName128'] == 'ITEM_ETC_AMMO_BOLT_01' || $row['CodeName128'] == 'DUMMY_OBJECT'){
echo '<td>-</td>';
} else {
echo '<td>'.$row['SealType'].'</td>';
}
if($row['CodeName128'] == 'ITEM_ETC_AMMO_ARROW_01' || $row['CodeName128'] == 'ITEM_ETC_AMMO_BOLT_01' || $row['CodeName128'] == 'DUMMY_OBJECT'){
echo '<td>-</td>';
} else {
echo '<td>'.$row['ReqLevel1'].'</td>';
}
if($row['CodeName128'] == 'ITEM_ETC_AMMO_ARROW_01' || $row['CodeName128'] == 'ITEM_ETC_AMMO_BOLT_01' || $row['CodeName128'] == 'DUMMY_OBJECT'){
echo '<td>-</td>';
} else {
echo '<td>'.$totalvalue.'';
switch($advonly) {
case "NULL":
break;
case 1:
echo '+(1) ADV</td>';
break;
case 2:
echo '+(2) ADV</td>';
break;
case 3:
echo '+(3) ADV</td>';
break;
case 4:
echo '+(4) ADV</td>';
break;
case 5:
echo '+(5) ADV</td>';
break;
default:
break;
}}
echo '</tr>';
}
echo '</table>';
misc::back();
} else {
echo 'Character Name Is invalid.';
}
break;
//We'll be added in future updates.
case('set_plus'):
core::$sql -> changeDB("shard");
echo "
<table id='table-3' border='1' cellpadding='0' cellspacing='0'>
<tr>
<td>Char Name</td>
<td>Status</td>
<td>Image</td>
<td>Item Name</td>
<td>Type</td>
<td>Level</td>
<td>Plus Value</td>
</tr>
";
$query = core::$sql -> exec("
select top 50 it.OptLevel, ch.CharName16, obj.AssocFileIcon128, obj.Country, obj.CodeName128, obj.ReqLevel1 ,
SealType = CASE
WHEN PATINDEX('%_11%_' + '%A_RARE',obj.CodeName128) > 0 THEN ' Seal of Nova'
WHEN PATINDEX('%_11%_' + '%SET_B_RARE',obj.CodeName128) > 0 THEN ' Egy A'
WHEN PATINDEX('%_11%_' + '%SET_A_RARE',obj.CodeName128) > 0 THEN ' Egy B'
WHEN PATINDEX('%A_RARE',obj.CodeName128) > 0 THEN ' Seal of Star'
WHEN PATINDEX('%B_RARE',obj.CodeName128) > 0 THEN ' Seal of Moon'
WHEN PATINDEX('%C_RARE',obj.CodeName128) > 0 THEN ' Seal of Sun'
ELSE 'Normal'
END,
CASE
WHEN inv.Slot between 0 and 12 THEN 'Equipped'
ELSE 'No Equipped'
END as 'Equipped',
adv.nOptValue ,es.EndTextString
from _Items as it
LEFT JOIN [dbo].[_Inventory] as inv ON it.ID64 = inv.ItemID
LEFT JOIN [dbo].[_Char] as ch ON inv.CharID = ch.CharID
LEFT JOIN [dbo].[_RefObjCommon] as obj ON it.RefItemID = obj.ID
LEFT JOIN [dbo].[_RefObjItem] as item ON obj.Link = item.ID
LEFT JOIN [dbo].[_BindingOptionWithItem] as adv on it.ID64 = adv.nItemDBID AND adv.bOptType = 2
LEFT JOIN [dbo].[C_EquipStrings] as es on obj.NameStrID128 = es.TextString
where ch.CharName16 is not NULL and CodeName128 not like '%ARCHEMY%' and CharName16 not like '%]%'
ORDER BY it.OptLevel DESC, obj.ReqLevel1 DESC, item.ItemClass DESC, adv.nOptValue DESC
");
بص حضرتك انا عندى الاكونت بينزل لفل 110 اللى بيسجل اكونت جديد هوا اللى بيبقى الاول فى Top Chractares انا بقى عايز اظبطها على اى حاجة تانية مش على الفل ولا SP بحيث ان الناس اللى جامدة فى السيرفر هى اللى تبقى الاول
core::$sql -> changeDB('acc'); if(core::$sql -> numRows("select * from Evangelion_uniques where CharName='$hData[CharName16]'") == 0) { echo "<td>This character has no uniques killed ! </td></table>"; } else { echo "<td><u>Latest Unique Kills by :$hData[CharName16] </u><br /><br /> <table id='table-3' border='0' cellpadding='0' cellspacing='0'> <td>Unique name</td><td>Time</td><tr/>"; $hQuery = core::$sql -> exec("select top 30 * from Evangelion_uniques where CharName='$hData[CharName16]' order by time desc"); while($row = mssql_fetch_array($hQuery)) { $datetime1 = $row['time']; $mssqldate1 = date("d-m-y", $datetime1); echo "<tr>"; $UniqueType = $row['MobName']; switch($UniqueType) { // Tiger Girl case "MOB_CH_TIGERWOMAN": echo '<td>Tiger Girl</td><td>'.$mssqldate1.'</td>'; break; case "MOB_CH_TIGERWOMAN_L3": echo '<td>Tiger Girl (Titan)</td><td>'.$mssqldate1.'</td>'; break; // Cerberus case "MOB_EU_KERBEROS": echo '<td>Cerberus</td><td>'.$mssqldate1.'</td>'; break; case "MOB_EU_KERBEROS_L3": echo '<td>Cerberus (Titan)</td><td>'.$mssqldate1.'</td>'; break; // Captain Ivy case "MOB_AM_IVY": echo '<td>Captain Ivy</td><td>'.$mssqldate1.'</td>'; break; case "MOB_AM_IVY_L3": echo '<td>Captain Ivy (Titan)</td><td>'.$mssqldate1.'</td>'; break; // Uruchi case "MOB_OA_URUCHI": echo '<td>Uruchi</td><td>'.$mssqldate1.'</td>'; break; case "MOB_OA_URUCHI_L3": echo '<td>Uruchi (Titan)</td><td>'.$mssqldate1.'</td>'; break; // Isyutaru case "MOB_KK_ISYUTARU": echo '<td>Isyutaru</td><td>'.$mssqldate1.'</td>'; break; case "MOB_KK_ISYUTARU_L3": echo '<td>Isyutaru (Titan)</td><td>'.$mssqldate1.'</td>'; break; // Lord Yarkan case "MOB_TK_BONELORD": echo '<td>Lord Yarkan</td><td>'.$mssqldate1.'</td>'; break; case "MOB_TK_BONELORD_L3": echo '<td>Lord Yarkan (Titan)</td><td>'.$mssqldate1.'</td>'; break; // Demon Shaitan case "MOB_RM_TAHOMET": echo '<td>Demon Shaitan</td><td>'.$mssqldate1.'</td>'; break; case "MOB_RM_TAHOMET_L3": echo '<td>Demon Shaitan (Titan)</td><td>'.$mssqldate1.'</td>'; break; // SoSo The Black Viper case "MOB_TQ_BLACKSNAKE": echo '<td>SoSo The Hades Viper</td><td>'.$mssqldate1.'</td>'; break; case "MOB_TQ_BLACKSNAKE_L3": echo '<td>SoSo The Hades Viper (Titan)</td><td>'.$mssqldate1.'</td>'; break; // BeakYung The White Viper (Medusa) case "MOB_TQ_WHITESNAKE": echo '<td>BeakYung The White Viper (Medusa)</td><td>'.$mssqldate1.'</td>'; break; // if none of the list above , do not show at all. default:
break; } echo "<tr/>"; }
echo "</table></td></table>";
core::$sql -> changeDB('shard'); }
misc::back(); } else echo "Owner of account on which this character is created didn't want you to view he's (her) data.<br/>"; }
} else { core::$sql -> changeDB("shard"); $hQuery = core::$sql -> exec("USE [SRO_VT_SHARD] Select Top 50 _Char.CharName16,_Char.CurLevel,_Char.RemainSkillPoint,_Char.Strength,_Char.Intellect,SUM(_Items.OptLevel) As ItemPoints From _Char Inner Join _Inventory ON _Char.CharID = _Inventory.CharID Inner Join _Items ON _Inventory.ItemID = _Items.ID64 Where _Char.CharName16 Not Like '%[%' And _Char.CharName16 Not Like '%]%' And _Inventory.Slot between 0 and 12 Group by _Char.CharName16,_Char.CurLevel,_Char.RemainSkillPoint,_Char.Strength,_Char.Intellect Order by _Char.CurLevel Desc , ItemPoints Desc");
case('set_char'): if(isset($_GET['name']) && addslashes(security::isSecureString($_GET['name'], 3))) { $nCharName = $_GET['name']; core::$sql -> changeDB("shard"); echo " <table id='table-3' border='1' cellpadding='0' cellspacing='0'> <tr> <td>Char Name</td> <td>Item Type</td> <td>Image</td> <td>Item Name</td> <td>Type</td> <td>Level</td> <td>Plus Value</td> </tr> "; $query = core::$sql -> exec(" select it.OptLevel, ch.CharName16, obj.AssocFileIcon128, obj.Country, obj.CodeName128 , obj.ReqLevel1 , SealType = CASE WHEN PATINDEX('%_11%_' + '%A_RARE',obj.CodeName128) > 0 THEN ' Seal of Nova' WHEN PATINDEX('%_11%_' + '%SET_B_RARE',obj.CodeName128) > 0 THEN ' Egy A' WHEN PATINDEX('%_11%_' + '%SET_A_RARE',obj.CodeName128) > 0 THEN ' Egy B' WHEN PATINDEX('%A_RARE',obj.CodeName128) > 0 THEN ' Seal of Star' WHEN PATINDEX('%B_RARE',obj.CodeName128) > 0 THEN ' Seal of Moon' WHEN PATINDEX('%C_RARE',obj.CodeName128) > 0 THEN ' Seal of Sun' ELSE 'Normal' END, CASE WHEN inv.Slot = 0 THEN 'Head' WHEN inv.Slot = 1 THEN 'Suit' WHEN inv.Slot = 2 THEN 'Shoulders' WHEN inv.Slot = 3 THEN 'Hands' WHEN inv.Slot = 4 THEN 'Legs' WHEN inv.Slot = 5 THEN 'Shoes' WHEN inv.Slot = 6 THEN 'Weapon' WHEN inv.Slot = 7 THEN 'Shield/Arrow' WHEN inv.Slot = 9 THEN 'Earring' WHEN inv.Slot = 10 THEN 'Necklace' WHEN inv.Slot = 11 THEN 'Ring (L)' WHEN inv.Slot = 12 THEN 'Ring (R)' ELSE 'NO clue' END as 'ItemType', adv.nOptValue , es.EndTextString from _Items as it LEFT JOIN [dbo].[_Inventory] as inv ON it.ID64 = inv.ItemID LEFT JOIN [dbo].[_Char] as ch ON inv.CharID = ch.CharID LEFT JOIN [dbo].[_RefObjCommon] as obj ON it.RefItemID = obj.ID LEFT JOIN [dbo].[_RefObjItem] as item ON obj.Link = item.ID LEFT JOIN [dbo].[_BindingOptionWithItem] as adv on it.ID64 = adv.nItemDBID AND adv.bOptType = 2 LEFT JOIN [dbo].[C_EquipStrings] as es on obj.NameStrID128 = es.TextString where ch.CharName16 = '$nCharName' and inv.Slot between 0 and 12 and inv.Slot != 8 "); while ($row = mssql_fetch_array($query)){ echo '<tr>'; echo '<td align="center"><a href="?pg=rank&type=char&name='.$row['CharName16'].'">'.$row['CharName16'].'</a></td>'; echo '<td>'.$row['ItemType'].'</td>'; if($row['AssocFileIcon128'] == 'xxx'){ echo '<td><img src="./item/clean.png" width="32" height="32" alt=""/></td>'; } else { echo '<td><img src="./'.$row['AssocFileIcon128'].'.png" width="32" height="32" alt=""/></td>'; } if($row['CodeName128'] == 'DUMMY_OBJECT'){ echo '<td>-</td>'; } else { echo '<td>'.$row['EndTextString'].'</td>'; } $totalvalue = $row['OptLevel']+$row['nOptValue']; $advonly = $row['nOptValue']; if($row['CodeName128'] == 'ITEM_ETC_AMMO_ARROW_01' || $row['CodeName128'] == 'ITEM_ETC_AMMO_BOLT_01' || $row['CodeName128'] == 'DUMMY_OBJECT'){ echo '<td>-</td>'; } else { echo '<td>'.$row['SealType'].'</td>'; } if($row['CodeName128'] == 'ITEM_ETC_AMMO_ARROW_01' || $row['CodeName128'] == 'ITEM_ETC_AMMO_BOLT_01' || $row['CodeName128'] == 'DUMMY_OBJECT'){ echo '<td>-</td>'; } else { echo '<td>'.$row['ReqLevel1'].'</td>'; } if($row['CodeName128'] == 'ITEM_ETC_AMMO_ARROW_01' || $row['CodeName128'] == 'ITEM_ETC_AMMO_BOLT_01' || $row['CodeName128'] == 'DUMMY_OBJECT'){ echo '<td>-</td>'; } else { echo '<td>'.$totalvalue.''; switch($advonly) { case "NULL": break; case 1: echo '+(1) ADV</td>'; break; case 2: echo '+(2) ADV</td>'; break; case 3: echo '+(3) ADV</td>'; break; case 4: echo '+(4) ADV</td>'; break; case 5: echo '+(5) ADV</td>'; break; default: break; }} echo '</tr>'; }
echo '</table>'; misc::back(); } else { echo 'Character Name Is invalid.'; } break;
//We'll be added in future updates.
case('set_plus'): core::$sql -> changeDB("shard"); echo " <table id='table-3' border='1' cellpadding='0' cellspacing='0'> <tr> <td>Char Name</td> <td>Status</td> <td>Image</td> <td>Item Name</td> <td>Type</td> <td>Level</td> <td>Plus Value</td> </tr> "; $query = core::$sql -> exec(" select top 50 it.OptLevel, ch.CharName16, obj.AssocFileIcon128, obj.Country, obj.CodeName128, obj.ReqLevel1 , SealType = CASE WHEN PATINDEX('%_11%_' + '%A_RARE',obj.CodeName128) > 0 THEN ' Seal of Nova' WHEN PATINDEX('%_11%_' + '%SET_B_RARE',obj.CodeName128) > 0 THEN ' Egy A' WHEN PATINDEX('%_11%_' + '%SET_A_RARE',obj.CodeName128) > 0 THEN ' Egy B' WHEN PATINDEX('%A_RARE',obj.CodeName128) > 0 THEN ' Seal of Star' WHEN PATINDEX('%B_RARE',obj.CodeName128) > 0 THEN ' Seal of Moon' WHEN PATINDEX('%C_RARE',obj.CodeName128) > 0 THEN ' Seal of Sun' ELSE 'Normal' END, CASE WHEN inv.Slot between 0 and 12 THEN 'Equipped' ELSE 'No Equipped' END as 'Equipped', adv.nOptValue ,es.EndTextString from _Items as it LEFT JOIN [dbo].[_Inventory] as inv ON it.ID64 = inv.ItemID LEFT JOIN [dbo].[_Char] as ch ON inv.CharID = ch.CharID LEFT JOIN [dbo].[_RefObjCommon] as obj ON it.RefItemID = obj.ID LEFT JOIN [dbo].[_RefObjItem] as item ON obj.Link = item.ID LEFT JOIN [dbo].[_BindingOptionWithItem] as adv on it.ID64 = adv.nItemDBID AND adv.bOptType = 2 LEFT JOIN [dbo].[C_EquipStrings] as es on obj.NameStrID128 = es.TextString where ch.CharName16 is not NULL and CodeName128 not like '%ARCHEMY%' and CharName16 not like '%]%' ORDER BY it.OptLevel DESC, obj.ReqLevel1 DESC, item.ItemClass DESC, adv.nOptValue DESC ");
انا رتبتهملك على حسب الأيتم بوينت والليفل بالكيوري دي
كود PHP:
USE [SRO_VT_SHARD] Select Top 50 _Char.CharName16,_Char.CurLevel,_Char.RemainSkillPoint,_Char.Strength,_Char.Intellect,SUM(_Items.OptLevel) As ItemPoints From _Char Inner Join _Inventory ON _Char.CharID = _Inventory.CharID Inner Join _Items ON _Inventory.ItemID = _Items.ID64 Where _Char.CharName16 Not Like '%[%' And _Char.CharName16 Not Like '%]%' And _Inventory.Slot between 0 and 12 Group by _Char.CharName16,_Char.CurLevel,_Char.RemainSkillPoint,_Char.Strength,_Char.Intellect Order by _Char.CurLevel Desc , ItemPoints Desc
13-04-2015, 05:46 AM
المواضيع المتشابهه
.gif){kind=icon}
العرض المتطور
