$wrt .= ' <table width="100%" border="0" cellspacing="0" cellpadding="0">';
$wrt .= ' <tr>';
$wrt .= ' <td class="tright">Title : </td>';
$wrt .= ' <td class="tleft"><input type="text" name="title"></td>';
$wrt .= ' </tr>';
$wrt .= ' <tr>';
$wrt .= ' <td class="tright">Bulletin content : </td>';
$wrt .= ' <td class="tleft"><textarea name="content" cols="50" rows="10" id="editor"></textarea></td>';
$wrt .= ' </tr>';
$wrt .= ' <tr><td colspan="2"><input type="hidden" name="author" value="' . $getHeaderCharName . '"><button id="insert">Add Bulletin</button></td></tr>';
$wrt .= ' </table>';
$wrt .= ' </form>';
}
} elseif (isset($_GET['mode']) && $_GET['mode'] == 'edit') {
//if ($admin == true) {
$result = good_query_table("SELECT * FROM bulletin WHERE id = " . $_GET['id'] . "");
//while ($row = mysql_fetch_array($result))
$wrt .= '<tr><th class="ft_head" colspan="3">Edit Bulletin</th></tr>';
$wrt .= '<tr><td colspan="3">';
foreach ($result as $row) {
$wrt .= '<form name="form1" method="post" action="./?module=data&part=bulletin&a=update">';
$wrt .= ' <table width="100%" border="0" cellspacing="0" cellpadding="0">';
$wrt .= ' <tr>';
$wrt .= ' <td class="tright">Title : </td>';
$wrt .= ' <td class="tleft"><input type="text" name="title" value="' . $row['title'] . '"></td>';
$wrt .= ' </tr>';
$wrt .= ' <tr>';
$wrt .= ' <td class="tright">Bulletin content : </td>';
$wrt .= ' <td class="tleft"><textarea name="content" cols="50" rows="10" id="editor">' . $row['content'] . '</textarea></td>';
$wrt .= ' </tr>';
$wrt .= ' <tr><td colspan="2"><input type="hidden" name="author" value="' . $getHeaderCharName . '"><input type="hidden" name="id" value="' . $row['id'] . '"><input type="submit" name="Submit" value="Update"></td></tr>';
function getDNA($kill_id)
{
//$killid='20469491'; //miner
//$kill_id='20469506'; //hauler
/*
if (isset($_GET['id'])){
$kill_id=$_GET['id'];
}else{$kill_id='20469506';}
*/
/*
$killer1 = good_query_table("SELECT kb_kill.shipTypeID as ship,kb_items_destr.item_id as itemds,kb_items_destr.qty as qtyds,kb_items_destr.slot FROM
kb_kill
LEFT JOIN kb_items_destr ON kb_kill.killid=kb_items_destr.kill_id
LEFT JOIN kb_items_drop ON kb_kill.killid=kb_items_drop.kill_id
WHERE killid=17492613 AND kb_items_destr.flag=0 and kb_items_destr.flag=0");
$killer = good_query_table("
SELECT kill_id,item_id,qty,slot FROM kb_items_destr
WHERE kill_id=17492613 AND flag=0 AND slot IN ('1','2','3','5','6','7')
UNION
SELECT kill_id,item_id,qty,slot FROM kb_items_drop
WHERE kill_id=17492613 AND flag=0 AND slot IN ('1','2','3','5','6','7')
");
*/
$dna_high = good_query_table("SELECT item_id,qty FROM kb_items_destr WHERE kill_id=" . $kill_id . " AND flag=0 AND slot=1 UNION SELECT item_id,qty FROM kb_items_drop WHERE kill_id=" . $kill_id . " AND flag=0 AND slot=1");
$dna_medium = good_query_table("SELECT item_id,qty FROM kb_items_destr WHERE kill_id=" . $kill_id . " AND flag=0 AND slot=2 UNION SELECT item_id,qty FROM kb_items_drop WHERE kill_id=" . $kill_id . " AND flag=0 AND slot=2");
$dna_low = good_query_table("SELECT item_id,qty FROM kb_items_destr WHERE kill_id=" . $kill_id . " AND flag=0 AND slot=3 UNION SELECT item_id,qty FROM kb_items_drop WHERE kill_id=" . $kill_id . " AND flag=0 AND slot=3");
$dna_rig = good_query_table("SELECT item_id,qty FROM kb_items_destr WHERE kill_id=" . $kill_id . " AND flag=0 AND slot=5 UNION SELECT item_id,qty FROM kb_items_drop WHERE kill_id=" . $kill_id . " AND flag=0 AND slot=5");
$dna_sub = good_query_table("SELECT item_id,qty FROM kb_items_destr WHERE kill_id=" . $kill_id . " AND flag=0 AND slot=7 UNION SELECT item_id,qty FROM kb_items_drop WHERE kill_id=" . $kill_id . " AND flag=0 AND slot=7");
$ship = good_query_assoc("SELECT shipTypeID FROM kb_kill WHERE killid=" . $kill_id . "");
/*
echo'<pre>';
//print_r($killer);
echo '<hr>';
//print_r($dna_high);
echo '<hr>';
//print_r(array_count_values($dna_high));
echo '<hr>high';
print_r(sum_array($dna_high));
echo '<hr>med';
print_r(sum_array($dna_medium));
echo '<hr>low';
print_r(sum_array($dna_low));
echo '<hr>rig';
print_r(sum_array($dna_rig));
echo '<hr>sub';
print_r(sum_array($dna_sub));
echo'</pre>';
//$dna_string='';
*/
$dna_string = $ship['shipTypeID'];
//echo $ship['shipTypeID'];
foreach ($dna_sub as $item) {
$dna_string .= ':' . $item['item_id'] . ';' . $item['qty'];
}
foreach ($dna_rig as $item) {
$dna_string .= ':' . $item['item_id'] . ';' . $item['qty'];
}
foreach ($dna_low as $item) {
$dna_string .= ':' . $item['item_id'] . ';' . $item['qty'];
}
foreach ($dna_medium as $item) {
$dna_string .= ':' . $item['item_id'] . ';' . $item['qty'];
}
foreach ($dna_high as $item) {
$dna_string .= ':' . $item['item_id'] . ';' . $item['qty'];
}
$dna_string .= '::';
/*
echo'<hr>';
echo $dna_string;
echo'<hr>';
echo "<a href=\"javascript:CCPEVE.showFitting('".$dna_string."');\"'>Show Fitting</a>";
*/
/*
//echo '<a href="?id=20469506">hauler</a> <a href="?id=20469491">miner</a> <a href="?id=20185622">apoc</a> <a href="?id=18128798">vexor</a><hr>';
$hs_drp=0;$ms_drp=0;$ls_drp=0;$rs_drp=0;$ss_drp=0;$hs_dst=0;$ms_dst=0;$ls_dst=0;$rs_dst=0;$ss_dst=0;
$slotCH=0;$slotCM=0;$slotCL=0;$slotCR=0;$slotCS=0;
$i=0;
$tstdrop = good_query_table("SELECT kb_kill.shipTypeID as ship,kb_items_drop.item_id as itemdr,kb_items_drop.qty as qtydr,kb_items_drop.slot FROM kb_kill LEFT JOIN kb_items_drop ON kb_kill.killid=kb_items_drop.kill_id WHERE killid=".$kill_id." AND flag=0");
$tstdestr = good_query_table("SELECT kb_kill.shipTypeID as ship,kb_items_destr.item_id as itemds,kb_items_destr.qty as qtyds,kb_items_destr.slot FROM kb_kill LEFT JOIN kb_items_destr ON kb_kill.killid=kb_items_destr.kill_id WHERE killid=".$kill_id." AND flag=0");
//$sql_drp = "SELECT * FROM kb_items_drop where kill_id=".$id." AND flag=0 ORDER BY slot ASC";
//$sql_dst = "SELECT * FROM kb_items_destr where kill_id=".$id." AND flag=0 ORDER BY SLOT ASC";
$ship = good_query_assoc("SELECT shipTypeID FROM kb_kill WHERE killid=".$kill_id."");
//echo '<br><b>'.$slotCH.'</b><br>';
foreach ($tstdrop as $item){
//echo 'item '.$item['itemdr'] . ' qty' . $item['qtydr'].' slot'.$item['slot'].'<br />';
if ($item['slot']==1){
//$hs_drp=$hs_drp+$item['qtydr'];
$slotHarr[$slotCH][0]=$item['itemdr'];
$slotHarr[$slotCH][1]=$item['qtydr'];
$slotCH++;
}
if ($item['slot']==2){
//$ms_drp=$ms_drp+$item['qtydr'];
$slotMarr[$slotCM][0]=$item['itemdr'];
$slotMarr[$slotCM][1]=$item['qtydr'];
$slotCM++;
}
if ($item['slot']==3){
//$ls_drp=$ls_drp+$item['qtydr'];
$slotLarr[$slotCL][0]=$item['itemdr'];
$slotLarr[$slotCL][1]=$item['qtydr'];
$slotCL++;
}
if ($item['slot']==5){
//$rs_drp=$rs_drp+$item['qtydr'];
$slotRarr[$slotCR][0]=$item['itemdr'];
$slotRarr[$slotCR][1]=$item['qtydr'];
$slotCR++;
}
if ($item['slot']==7){
//$ss_drp=$ss_drp+$item['qtydr'];
$slotSarr[$slotCS][0]=$item['itemdr'];
$slotSarr[$slotCS][1]=$item['qtydr'];
$slotCS++;
}
//if ($item['qtydr'] > 1) {echo'bana';}
$i++;
}
*/
/*
echo'<pre>high';
print_r($slotHarr);
echo'med';
print_r($slotMarr);
echo'low';
print_r($slotLarr);
echo'</pre>';
echo '<br><b>'.$slotCH.'</b><br>';
*/
/*
$slotCH=0;$slotCM=0;$slotCL=0;$slotCR=0;$slotCS=0;
//echo '<hr>';
foreach ($tstdestr as $item){
//echo '<br />item '.$item['itemds'] . ' qty' . $item['qtyds'].' slot'.$item['slot'].'';
if ($item['slot']==1){
//$hs_drp=$hs_drp+$item['qtyds'];
//$slotHarr[$slotCH][0]=$item['itemds'];
//$slotHarr[$slotCH][1]=$item['qtyds'];
//echo $slotHarr[0][0].'-'.$slotCH;
if (isset($slotHarr[$slotCH])){
//if (!empty($slotHarr[$slotCH])){$slotCH++;}
if ($slotHarr[$slotCH][0]==$item['itemds']){
//echo' if duplicate ';
$slotHarr[$slotCH][1] += $item['qtyds'];
}elseif ($slotHarr[$slotCH][1]>0){
//}else{
//echo' if cnt ';
if (!empty($slotHarr[$slotCH])){
//echo' hehe ';
$slotCH++;
}
$slotHarr[$slotCH][0]=$item['itemds'];
$slotHarr[$slotCH][1]=$item['qtyds'];
}
}else{
//echo' else ';
$slotMarr[$slotCH][0]=$item['itemds'];
$slotMarr[$slotCH][1]=$item['qtyds'];
}
$slotCH++;
}
if ($item['slot']==2){
//$ms_drp=$ms_drp+$item['qtyds'];
if (isset($slotMarr[$slotCM])){
if ($slotMarr[$slotCM][0]==$item['itemds']){
$slotMarr[$slotCM][1] += $item['qtyds'];
}elseif ($slotMarr[$slotCM][1]>1){
$slotMarr[$slotCM][0]=$item['itemds'];
$slotMarr[$slotCM][1]=$item['qtyds'];
}
}else{
$slotMarr[$slotCM][0]=$item['itemds'];
$slotMarr[$slotCM][1]=$item['qtyds'];
}
$slotCM++;
}
if ($item['slot']==3){
//$ls_drp=$ls_drp+$item['qtyds'];
if (isset($slotLarr[$slotCL])){
if ($slotLarr[$slotCL][0]==$item['itemds']){
$slotLarr[$slotCL][1] += $item['qtyds'];
}elseif ($slotLarr[$slotCL][1]>1){
$slotLarr[$slotCL][0]=$item['itemds'];
$slotLarr[$slotCL][1]=$item['qtyds'];
}
}else{
$slotLarr[$slotCL][0]=$item['itemds'];
$slotLarr[$slotCL][1]=$item['qtyds'];
}
$slotCL++;
}
if ($item['slot']==5){
//$rs_drp=$rs_drp+$item['qtyds'];
if (isset($slotRarr[$slotCR])){
if ($slotRarr[$slotCR][0]==$item['itemds']){
$slotRarr[$slotCR][1] += $item['qtyds'];
}elseif ($slotRarr[$slotCR][1]>1){
$slotRarr[$slotCR][0]=$item['itemds'];
$slotRarr[$slotCR][1]=$item['qtyds'];
}
}else{
$slotLarr[$slotCR][0]=$item['itemds'];
$slotLarr[$slotCR][1]=$item['qtyds'];
}
$slotCR++;
}
if ($item['slot']==7){
//$ss_drp=$ss_drp+$item['qtyds'];
if (isset($slotSarr[$slotCS])){
if ($slotLarr[$slotCS][0]==$item['itemds']){
$slotLarr[$slotCS][1] += $item['qtyds'];
}elseif ($slotSarr[$slotCS][1]>1){
$slotSarr[$slotCS][0]=$item['itemds'];
$slotSarr[$slotCS][1]=$item['qtyds'];
}
}else{
$slotLarr[$slotCS][0]=$item['itemds'];
$slotLarr[$slotCS][1]=$item['qtyds'];
}
$slotCS++;
}
//if ($item['qtydr'] > 1) {echo'bana';}
$i++;
}
*/
/*
echo '<br><b>'.$slotCH.'</b><br>';
echo'<pre>high';
print_r($slotHarr);
echo'med';
print_r($slotMarr);
echo'low';
print_r($slotLarr);
echo'rig';
print_r($slotRarr);
echo'sub';
print_r($slotSarr);
echo'</pre>';
*/
/*
$dna = $ship['shipTypeID'].':';
//echo $ship['shipTypeID'].':';
for ($i=0; $i<=7; $i++){
if (isset($slotSarr[$i])){
echo $slotSarr[$i][0].';';//echo'<br />';
echo $slotSarr[$i][1].':';
$dna .= $slotSarr[$i][0].';';
$dna .= $slotSarr[$i][1].':';
}else{
//echo':';$dna .= ':';}
//echo'';$dna .= '';
$dna .= '';
}
if (isset($slotRarr[$i])){
//echo $slotRarr[$i][0].';';
//echo $slotRarr[$i][1].':';
$dna .= $slotRarr[$i][0].';';
$dna .= $slotRarr[$i][1].':';
}else{
//echo':';$dna .= ':';}
//echo'';$dna .= '';
$dna .= '';
}
if (isset($slotLarr[$i])){
//echo $slotLarr[$i][0].';';
//echo $slotLarr[$i][1].':';
$dna .= $slotLarr[$i][0].';';
$dna .= $slotLarr[$i][1].':';
}else{
//echo':';$dna .= ':';}
//echo'';$dna .= '';
$dna .= '';
}
if (isset($slotMarr[$i])){
//echo $slotMarr[$i][0].';';
//echo $slotMarr[$i][1].':';
$dna .= $slotMarr[$i][0].';';
$dna .= $slotMarr[$i][1].':';
}else{
//echo':';$dna .= ':';}
//echo'';$dna .= '';
$dna .= '';
}
if (isset($slotHarr[$i])){
//echo $slotHarr[$i][0].';';
//echo $slotHarr[$i][1].':';
$dna .= $slotHarr[$i][0].';';
$dna .= $slotHarr[$i][1].':';
}else{
//echo':';$dna .= ':';}
//echo'';$dna .= '';
$dna .= '';
}
$dna .= ':';
}
*/
/*
echo '<hr>'.$dna,'<hr>642:519;4:6328;2:1353;1:6158;3:6175;1:9497;8:: //APOC<hr>';
echo '626:11269;2:2048;1:3530;1:2032;2:12058;1:12346;3:25861;1:24348;1:: //Vexor<hr>';
echo 'a dynamic dna link test! -><a href="javascript:CCPEVE.showFitting(\''.$dna.':\');">show</a><hr>';
echo 'a fixed dna link test! -><a href="javascript:CCPEVE.showFitting(\'597:25861;1:6673;3:439;1:4025;1:1183;1:1998;1:1236;1:11269;1::\');">show</a>';
*/
/*
SELECT
kb_kill.shipTypeID as ship,
kb_items_drop.item_id as itemdr,
kb_items_drop.qty as qtydr
FROM kb_kill
LEFT JOIN kb_items_drop ON
kb_kill.killid=kb_items_drop.kill_id
WHERE killid=20469491
*/
//echo $dna;
//return $dna;
return $dna_string;
}
} else {
$glink = '';
}
$wrt .= '<tr><td' . $glink . '><a href="' . $module_admin . '&do=pre&a=edit&id=' . $_GET['id'] . '&gid=' . $m_grp['groupID'] . '">' . $m_grp['groupName'] . '</a></td></tr>';
}
$wrt .= '</table>';
}
$wrt .= 'asdasd';
$wrt .= '</td>';
//SUBSKILLS SET
$wrt .= '<td>';
if (isset($_GET['a']) && $_GET['a'] == 'edit') {
if (isset($_GET['gid'])) {
$i = 0;
$sub_groups = $_GET['gid'];
$grouptypes = good_query_table("SELECT * FROM eve_db_invtypes WHERE groupID=" . $sub_groups . " AND published=1 ORDER BY typeName ASC");
$wrt .= wrt_table(0, 0, 0, '100%');
$wrt .= '<tr><td><form action="./?module=data&part=competence&s=skill" method="post">';
$wrt .= '<select rows="30" name="c_skill">';
foreach ($grouptypes as $itum) {
$wrt .= '<option value="' . $itum['typeID'] . '">';
$wrt .= $itum['typeName'];
$wrt .= '</option>';
}
$wrt .= '</select>';
$wrt .= '<select name="c_lvl">';
while ($i <= 5) {
$wrt .= '<option value="' . $i . '">' . $i . '</option>';
$i++;
}
$wrt .= '</select>';
function moduledrop($sel = null)
{
//if (isset($sel))
$root = 'modules';
$nav_admin = '<option>-- Admin Modules --</option>';
$nav_pub = '<option>-- Public Modules --</option>';
$nav_pg = '<option>-- Page Module</option>';
if ($handle = opendir($root)) {
while (false !== ($module = readdir($handle))) {
//if ( $evenOdd ) {$odder = "even"; $splitter = false;}else{$odder = "odd"; $splitter = true;}
//$evenOdd = !$evenOdd;
$i = 0;
$counter = 0;
if ($module != "." && $module != "..") {
if (file_exists($root . '/' . $module . '/config.php')) {
include $root . '/' . $module . '/config.php';
}
if (file_exists($root . '/' . $module . '/admin/index.php')) {
$last = count($array) - 1;
foreach ($array['Admin'] as $ic => $row) {
$isFirst = $ic == 0;
$isLast = $ic == $last;
if ($row['link'] == $sel) {
$selected = ' selected';
} else {
$selected = '';
}
$nav_admin .= '<option value="' . $row['link'] . '"' . $selected . '> ' . $row['name'] . '</option>';
}
$i++;
} else {
}
if (file_exists($root . '/' . $module . '/public/index.php')) {
$last = count($array) - 1;
foreach ($array['Public'] as $ic => $row) {
$isFirst = $ic == 0;
$isLast = $ic == $last;
if ($row['link'] == $sel) {
$selected = ' selected';
} else {
$selected = '';
}
$nav_pub .= '<option value="' . $row['link'] . '"' . $selected . '> ' . $row['name'] . '</option>';
}
$i++;
} else {
}
}
}
closedir($handle);
$pgmngr = good_query_table("SELECT p_name, p_title FROM pages ORDER BY id DESC");
foreach ($pgmngr as $option) {
if ('page&entry=' . $option['p_name'] == $sel) {
$selected = ' selected';
} else {
$selected = '';
}
$nav_pg .= '<option value="page&entry=' . $option['p_name'] . '"' . $selected . '> ' . $option['p_title'] . '</option>';
}
}
return '<select name="lurl">' . $nav_pub . $nav_admin . $nav_pg . '</select>';
}
<?php
require_once './includes/include_editor.php';
$pidenti = 'Page Identifier, this is used in menu later!';
$pages = good_query_table("SELECT * FROM pages ORDER BY id ASC");
$wrt = '<table cellpadding="0" cellspacing="0" border="0" class="center" width="' . $tblWidth . '">';
$wrt .= '<tr><th class="ft_head left">Pages</th><th class="ft_head left">Content Editor <span class="add"><a href="./?module=admin&part=page&do=add">create page</a></span></th></tr>';
$wrt .= '<tr><td class="left" width="250">';
$wrt .= '<ul>';
foreach ($pages as $page) {
$wrt .= '<li><a href="./?module=admin&part=page&do=edit&id=' . $page['id'] . '">' . $page['p_name'] . '</a></li>';
}
$wrt .= '</ul>';
$wrt .= '';
$wrt .= '';
$wrt .= '</td><td class="left border_left">';
$wrt .= '';
if (isset($_GET['do']) && $_GET['do'] == 'add') {
$wrt .= '<form action="./?module=data&part=page&a=add" method="post"><table border="0">';
$wrt .= '<tr><th colspan="2">Add Page</th></tr>';
$wrt .= '<tr>';
$wrt .= '<td class="left">Page Identifier</td><td class="left"><span id="inp"><input title="' . $pidenti . '" type="text" name="p_name"></span></td>';
$wrt .= '</tr><tr>';
$wrt .= '<td class="left">Page Title</td><td class="left"><input type="text" name="p_title"></td>';
$wrt .= '</tr><tr>';
$wrt .= '<td class="left">Page Content</td></tr>';
$wrt .= '<tr><td class="left" colspan="2"><textarea id="editor" name="p_content" rows="10" cols="100"></textarea></td>';
$wrt .= '</tr>';
$wrt .= '<tr><td colspan="2"><input type="submit" value="insert"></td></tr>';
$wrt .= '</table></form>';
} elseif (isset($_GET['do']) && $_GET['do'] == 'edit') {
$wrt .= '';
$wrt .= '';
$wrt .= '<tr>';
$wrt .= '<th class="ft_head left" colspan="2">';
$wrt .= '<a class="ld" href="' . $module_public . '&mode=threads' . $urlsel . '&id=' . $forum_cat['id'] . '">';
$wrt .= '<a class="ld" href="' . $module_public . '' . $urlsel . '">Forum</a> / ' . $forum_cat['cat_name'];
$wrt .= '</a>';
$wrt .= '</th>';
$wrt .= '</tr>';
$wrt .= '<tr><td class="left font_s">' . $forum_cat['cat_descr'] . '</td><td class="right font_s"><a href="' . $strCreate . '">Create New Topic</a</td></tr>';
$forum_sub_chck = good_query_assoc("SELECT * FROM forum_thread WHERE pid=" . $forum_cat['id'] . " AND fordirs=" . $sqlsel . " ORDER BY datetime DESC");
if (empty($forum_sub_chck['id'])) {
$wrt .= '<tr><td class="font_s">No Threads Found</td></tr>';
} else {
$getNOPages = good_query_assoc("SELECT forum_threads FROM settings LIMIT 1");
$forum_th = good_query_table("SELECT * FROM forum_thread WHERE pid='" . $forum_cat['id'] . "' ORDER BY datetime DESC LIMIT " . $getNOPages['forum_threads'] . "");
$wrt .= '<tr><td class="right" colspan="2">' . wrt_table(0, 0, 0, $tblWidth, 'right');
// PAGINATION START
$adjacents = 3;
$query = "SELECT COUNT(*) as num FROM forum_thread WHERE pid=" . $forum_cat['id'] . " AND fordirs=" . $sqlsel . "";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages['num'];
/* Setup vars for query. */
$targetpage = $module_public . '&mode=threads&id=' . $id . '';
$limit = $getNOPages['forum_threads'];
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = '1';
}
//$page = $_GET['page'];
<?php
$wrt = '';
$sqlmembers = good_query_table("SELECT * FROM corp_members ORDER BY char_name ASC");
$wrt = wrt_table(0, 0, 0, $tblWidth, 'center');
$wrt .= '<tr><th class="left ft_head">List of Members</th></tr></table>';
$wrt .= '';
$wrt .= wrt_table(0, 0, 0, $tblWidth, 'center', 'table_id');
$wrt .= '';
$wrt .= '';
$wrt .= '';
$wrt .= '<tr>';
$wrt .= '<td class="ft_head">Name</td>';
$wrt .= '<td class="ft_head" width="120">Verified Status</td>';
$wrt .= '<td class="ft_head" width="120">Global PWD Set</td>';
$wrt .= '<td class="ft_head" width="120">Site Admin</td>';
$wrt .= '</tr>';
$wrt .= '';
foreach ($sqlmembers as $mem) {
if (!empty($mem['sec_ip'])) {
$verified = 'yes';
} else {
$verified = 'no';
}
if (!empty($mem['sec_global_pwd'])) {
$gpwd = 'yes';
} else {
$gpwd = 'no';
}
if (!empty($mem['sec_site_admin'])) {
$adm = 'yes';
$wrt .= '</td><td class="left tcell' . $odder . '">';
$wrt .= $item_name['typeName'];
$wrt .= '</td><td class="left tcell' . $odder . '">';
$wrt .= $key;
$wrt .= '</td></tr>';
}
}
}
$wrt .= '</table>';
$wrt .= '</td></tr>';
$wrt .= '<tr><td colspan="2" class="left"><span class="exp"><a href="#" onclick="CCPEVE.showFitting(\'' . getDNA($row['killid']) . '\');">Export Fitting</a></span></td></tr>';
$wrt .= '</table>';
echo $wrt;
} elseif (isset($_GET['mode']) && $_GET['mode'] == 'attackers') {
$perc = good_query_assoc("SELECT wpn_id,SUM(dmgdone) FROM kb_kill_attackers WHERE kill_id='" . $id . "'");
$att = good_query_table("SELECT * FROM kb_kill_attackers WHERE kill_id='" . $id . "' ORDER BY dmgdone DESC");
$wrt = '<table border="0" cellspacing="0" cellpadding="0" width="100%">';
$wrt .= '<tr><th class="left ft_head font_m">Ship</th><th class="left ft_head font_m">Attacker</th><th class="left ft_head font_m">Damage</th></tr>';
foreach ($att as $attacker) {
//$dmgDone = number_format((double)$value['damageDone']);
if ($evenOdd) {
$odder = "even";
$splitter = false;
} else {
$odder = "odd";
$splitter = true;
}
$evenOdd = !$evenOdd;
if ($attacker['fb'] == true) {
$fb = '_fb';
} else {
$wrt .= '<tr><td class="tleft">Parent</td><td class="tleft">';
$resultp = mysql_query("SELECT * FROM menu WHERE pid='0' ORDER BY morder ASC");
$wrt .= '<select name="parent">';
while ($rowp = mysql_fetch_array($resultp)) {
$wrt .= '<option value="' . $rowp['id'] . '">' . $rowp['mname'] . '</option>' . "\n";
}
$wrt .= '</select>';
$wrt .= '</td></tr>';
$wrt .= '<tr><td class="tleft">isTitle</td><td class="tleft"><input type="checkbox" id="check" name="istitle" value="y" /><label for="check"></label></input></td></tr>';
$wrt .= '<tr><td colspan="2"><input type="submit" value="add"></td></tr>';
//$wrt .= '</table></form>';
$wrt .= '<tr><td colspan="2"> </td></tr>';
$wrt .= '<tr><td colspan="2" class="ft_head">Add From PageMngr</td></tr>';
$wrt .= '<tr><td class="tleft">Page</td><td class="tleft">';
$wrt .= '<select name="urltitle" onchange="document.formadd.lurl.value=this.value">';
$pgmngr = good_query_table("SELECT p_name, p_title FROM pages ORDER BY id DESC");
$wrt .= '<option>- page selection -</option>';
foreach ($pgmngr as $option) {
$wrt .= '<option title="' . $option['p_title'] . '" value="index&entry=' . $option['p_name'] . '">' . $option['p_title'] . '</option>';
}
$wrt .= '</select>';
$wrt .= '</td></tr>';
$wrt .= '';
$wrt .= '</table></form>';
$wrt .= '';
}
//############################################# menu add eof
$wrt .= '</td></tr>';
$wrt .= '</table>';
echo $wrt;
}
$whereclause = "('1')";
}
$wrt .= '<ul id="navlist">';
$check_navi = good_query_value("SELECT count(*) FROM navigation");
if ($check_navi) {
$navigation = good_query_table("SELECT * FROM navigation WHERE (access in " . $whereclause . ") ORDER BY s_order ASC");
foreach ($navigation as $row) {
if ($row['istitle']) {
$wrt .= '<li>' . $row['name'] . '</li>';
} else {
$wrt .= '<li><a class="ld" href="./?module=' . $row['url'] . '">' . $row['name'] . '</a></li>';
}
}
}
//check if basic navigation is setup!
$checkNav = good_query_table("SELECT * FROM navigation ORDER BY s_order ASC");
$preconf = 0;
foreach ($checkNav as $checkN) {
if ($checkN['url'] == 'admin&part=settings') {
$preconf++;
}
if ($checkN['url'] == 'admin&part=navigation') {
$preconf++;
}
}
if ($preconf != 2) {
$wrt .= '<li>Base Configuration</li>';
$wrt .= '<li><a href="./?module=admin&part=navigation">Configure Navigation.</a></li>';
$wrt .= '<li><a href="./?module=admin&part=settings">Configure Settings.</a></li>';
}
$preconf = 0;
});
</script>
';
$wrt .= wrt_table(0, 0, 0, '100%', 'center');
$wrt .= '<tr><td><form action="' . $module_data . '&a=apiupdate" method="post" name="apiupdate">';
$wrt .= wrt_table(0, 0, 0, '100%', 'center');
$wrt .= '<tr><th>keyID</th><th>vCode</th></tr>';
$wrt .= '<tr><td><input type="text" size="10" name="keyID" value="' . $api['keyID'] . '"></td><td><input type="text" size="90" name="vCode" value="' . $api['vCode'] . '"></td></tr>';
$wrt .= '<tr><td colspan="2"><input type="submit" name="submit" value="Update"></td></tr>';
$wrt .= '';
$wrt .= '';
$wrt .= '';
$wrt .= '</table></form>';
$wrt .= '</td><td>';
$wrt .= wrt_table(0, 0, 0, '100%', 'center');
$cache = good_query_table("SELECT * FROM cacheduntil JOIN apiaddresses WHERE apiaddresses.addressID=cacheduntil.addressID");
$wrt .= '<tr><th colspan="3">Cache State\'s</th></tr>';
$wrt .= '<tr><th>key</th><th>xml</th><th>Expire</th></tr>';
foreach ($cache as $crow) {
$wrt .= '<tr><td>';
$wrt .= $crow['keyID'];
$wrt .= '</td><td>';
$wrt .= $crow['apiSheetName'];
$wrt .= '</td><td>';
$wrt .= $crow['cacheexpire'];
$wrt .= '';
$wrt .= '</td></tr>';
}
$wrt .= '';
$wrt .= '</table>';
$wrt .= '';
cache:true,
load: function (e, ui) {
$(ui.panel).find(".tab-loading").remove();
},
select: function (e, ui) {
var $panel = $(ui.panel);
if ($panel.is(":empty")) {
$panel.append("<div class='tab-loading'>Loading...</div>")
}
}
})
*/
$wrt .= wrt_table(0, 0, 0, $tblWidth, 'center');
$wrt .= '<tr><td>';
$shipGroup = good_query_table("SELECT * FROM feeds");
// Ship Categories
$wrt .= '<div id="tabs">';
$wrt .= '<ul>';
foreach ($shipGroup as $row) {
//$wrt .= '<li><a href="./includes/feeds/load_feeds.php?load='.$row['tag'].'">'.$row['name'].'</a></li>';
$wrt .= '<li><a href="' . $module_dir . $self . '/includes/load_feeds.php?load=' . $row['tag'] . '">' . $row['name'] . '</a></li>';
}
$wrt .= '</ul>';
$wrt .= '';
$wrt .= '<div id="tabs-1">';
$wrt .= '<p><div id="loading"><p align="center">';
$wrt .= '<img src="./img/ghooloader2.gif" />';
$wrt .= '</p></div>';
$wrt .= '</div>';
$wrt .= '';
$( this ).dialog( "close" );
},
Cancel: function() {
$( this ).dialog( "close" );
}
}
});
});
</script>
';
$wrt .= '<div id="dialog-confirm" title="Delete a Fitt?">
<p><span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 20px 0;"></span>This fitt will be permantently deleted from library!<br>Proceed?</p>
</div>';
$wrt .= wrt_table(0, 0, 0, $tblWidth, 'center');
$wrt .= '<tr><th class="ft_head" width="140">Class</th><th class="ft_head">Content</th></tr>';
$shipHulls = good_query_table("SELECT * FROM fitt_dna_cat ORDER BY cat_order ASC");
$wrt .= '<tr><td class="left"><ul id="btnlist">';
foreach ($shipHulls as $row) {
$wrt .= '<li><a class="btn" href="javascript:jaquest(' . $row['hull_id'] . ')">' . $row['shipclass'] . '</a></li>';
}
$wrt .= '<li> </li>';
$wrt .= '<li> </li>';
$wrt .= '<li><a class="btn ld" href="' . $module_admin . '&a=add">Add Fitt</a></li>';
$wrt .= '</ul></td><td valign="top">';
$wrt .= '';
$wrt .= '<div id="placeholder"></div>';
$wrt .= '';
$wrt .= '</td></tr>';
$wrt .= '';
$wrt .= '</table>';
$wrt .= '';
mysql_query("INSERT INTO corp_members (char_id,char_name,char_role,char_loc,char_loc_name,char_ship,char_log_on,char_log_off) VALUES ('{$chaid}','{$chaname}','{$charole}','{$chaloc}','{$chalocname}','{$chaship}','{$chaon}','{$chaoff}')") or die("Error inserting onTimes! " . mysql_error());
} else {
$update = good_query_assoc("SELECT count(*) as numrecords FROM corp_members WHERE char_id='" . $chaid . "' and char_log_on='" . $chaon . "'") or die('Queryproblem - update.');
if (!$update['numrecords'] >= 1) {
//echo'logdate old';
$updatetimes = "UPDATE corp_members SET char_role='" . $charole . "',char_loc='" . $chaloc . "',char_ship='" . $chaship . "',char_log_on='" . $chaon . "',char_log_off='" . $chaoff . "' WHERE char_id = '" . $chaid . "'";
$updateit = mysql_query($updatetimes) or die(mysql_error());
} else {
//echo'logdate current';
}
}
$arrRemove[] = $chaid;
//echo '<hr>';
}
//------------ Clean Corp Start
$clean_corp = good_query_table("SELECT * FROM corp_members WHERE char_id NOT IN ('" . implode(',', $arrRemove) . "')");
foreach ($clean_corp as $clean_mem) {
if (!in_array($clean_mem['char_id'], $arrRemove)) {
//remove corp member
mysql_query("DELETE FROM corp_members WHERE char_id='" . $clean_mem['char_id'] . "'");
}
}
//------------- Clean Corp End
while ($member->{$cnt}) {
$charID = $xmlrowset->row[$cnt]['characterID'];
$charTime = $xmlrowset->row[$cnt]['logonDateTime'];
$charTimeOff = $xmlrowset->row[$cnt]['logoffDateTime'];
$result = mysql_query("SELECT count(*) as numrecords FROM ontimes WHERE charid='" . $charID . "' and onTime='" . $charTime . "'") or die('Queryproblem - updatemania');
$row = mysql_fetch_assoc($result);
if ($row['numrecords'] >= 1) {
} else {
$wrt .= wrt_table(0, 0, 0, $tblWidth);
$wrt .= '<tr><td class="ft_head left">Public Categories</td></tr>';
$wrt .= '</table>';
$wrt .= '<ul id="forum_cat">';
$forum_order = good_query_table("SELECT * FROM forum_cat WHERE cat_isdir=0 ORDER BY cat_order ASC");
foreach ($forum_order as $forder) {
//$wrt .= '<li id="item_'.$forder['id'].'" class="ui-state-default ui-corner-all">'.wrt_table(0,0,0,'100%').'<tr><td class="left" width="60%">'.$forder['cat_name'].'</td><td class="right font_s"><span class="edit"><a href="./?p=forum_mng&do=edit&id='.$forder['id'].'">edit</a></span> <span class="del"><a>delete</a></span></td></tr></table></li>';
$wrt .= '<li id="item_' . $forder['id'] . '" class="ui-state-default ui-corner-all">' . wrt_table(0, 0, 0, '100%') . '<tr><td class="left" width="60%">' . $forder['cat_name'] . '</td><td class="right font_s"><span class="edit"><a href="' . $module_admin . '&do=edit&id=' . $forder['id'] . '">edit</a></span> <span class="del"><a id="opener" href="' . $module_data . '&mode=forumedit&a=delcat&id=' . $forder['id'] . '">delete</a></span></td></tr></table></li>';
}
$wrt .= '';
$wrt .= '</ul>';
$wrt .= wrt_table(0, 0, 0, $tblWidth);
$wrt .= '<tr><td class="ft_head left">Admin Categories</td></tr>';
$wrt .= '</table>';
$wrt .= '<ul id="forum_cat_admin">';
$forum_order = good_query_table("SELECT * FROM forum_cat WHERE cat_isdir=1 ORDER BY cat_order ASC");
foreach ($forum_order as $forder) {
//$wrt .= '<li id="item_'.$forder['id'].'" class="ui-state-default ui-corner-all">'.$forder['cat_name'].'</li>';
$wrt .= '<li id="item_' . $forder['id'] . '" class="ui-state-default ui-corner-all">' . wrt_table(0, 0, 0, '100%') . '<tr><td class="left" width="60%">' . $forder['cat_name'] . '</td><td class="right font_s"><span class="edit"><a href="' . $module_admin . '&do=edit&id=' . $forder['id'] . '">edit</a></span> <span class="del"><a id="opener" href="' . $module_data . '&mode=forumedit&a=delcat&id=' . $forder['id'] . '">delete</a></span></td></tr></table></li>';
}
$wrt .= '';
$wrt .= '</ul>';
$wrt .= '</td><td>';
$wrt .= '';
$wrt .= '';
if (isset($_GET['do']) && $_GET['do'] == 'add') {
$wrt .= '<form method="post" action="' . $module_data . '&mode=forumadd&a=cat" name="addcat"><table border="0" cellspacing="0" cellpadding="0">';
$wrt .= '<tr><td class="left">Title</td><td class="left"><input type="text" name="title"></td>';
$wrt .= '<tr><td class="left">Description</td><td class="left"><textarea name="descr"></textarea></td>';
$wrt .= '<tr><td class="left" colspan="2"><input type="checkbox" id="check" name="fordirs" value="1"/><label for="check">Director Only?</label> <input type="submit" value="Add"></td></tr>';
$wrt .= '';
cache:true,
load: function (e, ui) {
$(ui.panel).find(".tab-loading").remove();
},
select: function (e, ui) {
var $panel = $(ui.panel);
if ($panel.is(":empty")) {
$panel.append("<div class='tab-loading'>Loading...</div>")
}
}
})
*/
$wrt .= wrt_table(0, 0, 0, $tblWidth, 'center');
$wrt .= '<tr><td>';
$shipGroup = good_query_table("SELECT * FROM fitt_dna_cat ORDER BY cat_order");
// Ship Categories
$wrt .= '<div id="tabs">';
$wrt .= '<ul>';
foreach ($shipGroup as $row) {
//$wrt .= '<li><a href="./includes/fittings/showcase.php?group='.$row['id'].'">'.$row['shipclass'].'</a></li>';
$wrt .= '<li><a href="' . $module_dir . $self . '/includes/showcase.php?group=' . $row['hull_id'] . '">' . $row['shipclass'] . '</a></li>';
}
$wrt .= '</ul>';
$wrt .= '';
$wrt .= '<div id="tabs-1">';
//$wrt .= '<p><div id="loading"><p align="center"><img src="./img/ajax_preloader.gif" /> Please Wait</p></div>';
$wrt .= '<p><div id="loading"><p align="center">';
//$wrt .= '<img src="./img/ajax_preloader.gif" />';
//$wrt .= '<img src="./img/38.gif" />';
$wrt .= '<img src="./img/ghooloader2.gif" />';
$groupID = mysql_real_escape_string($_GET['group']);
$evenOdd = true;
$wrt = '<table cellspacing="0" cellpadding="0" class="center" border="0" width="100%"><tr>';
$wrt .= '<th class="ft_bod" width="100">Name</th>';
$wrt .= '<th class="ft_bod" width="100">Ship</th>';
$wrt .= '<th class="ft_bod" width="100">Role</th>';
$wrt .= '<th class="ft_bod">Description</th>';
$wrt .= '<th class="ft_bod" width="100">Posted</th>';
$wrt .= '<th class="ft_bod" width="100">Author</th>';
$wrt .= '</tr>';
$shipHullQ = good_query_table("SELECT * FROM fitt_dna_hull WHERE hull_id = " . $groupID . "");
foreach ($shipHullQ as $rowH) {
$shipTypeQ = good_query_table("SELECT * FROM fitt_dna_ships WHERE gid = " . $rowH['grp_id'] . "");
foreach ($shipTypeQ as $row2) {
//$shipDNAQ = mysql_query("SELECT * FROM fitt_dna WHERE tid = ".$row2['tid']."");
$shipDNAQ = good_query_table("SELECT * FROM fitt_dna WHERE tid = " . $row2['tid'] . "");
//while ($row3 = mysql_fetch_array($shipDNAQ)) {
foreach ($shipDNAQ as $row3) {
if ($evenOdd) {
$odder = "even";
$splitter = false;
} else {
$odder = "odd";
$splitter = true;
}
$evenOdd = !$evenOdd;
$wrt .= '<tr>';
$wrt .= ' <td class="tleft tcell' . $odder . '"><a href="#" onclick="CCPEVE.showFitting(\'' . $row3['fitting'] . '\')">' . $row3['fittName'] . '</a></td>';
$wrt .= ' <td class="tleft tcell' . $odder . '"><img align="left" src="http://image.eveonline.com/Render/' . $row3['tid'] . '_32.png" size="64">' . fGetShip($row3['tid']) . '</td>';
$wrt .= ' <td class="tleft tcell' . $odder . '">' . fGetRole($row3['role']) . '</td>';
$wrt .= ' <td class="tleft tcell' . $odder . '">' . $row3['description'] . '</td>';
//echo '<br />';
}
//echo $arrskills->
$wrt = '';
$wrt .= '<script type="text/javascript" src="./js/expand.js"></script>';
echo '<script type="text/javascript" src="./js/expand.js"></script>';
$wrt1 = '<div id="content"><div class="demo ui-accordion ui-widget ui-helper-reset">';
$total_sp = 0;
foreach ($skillgrps as $sgroups) {
$groupname = good_query_assoc("SELECT typeName,typeID,groupID FROM eve_db_invtypes WHERE groupID=" . $sgroups . " AND published=1");
$wrt .= '<tr><td class="ft_head" colspan="3">' . $groupname['typeName'] . '</td></tr>';
$wrt1 .= '<h3 class="expand ui-accordion-header ui-helper-reset ui-state-active ui-corner-top">' . $groupname['typeName'] . '</h3>';
$wrt .= '<tr>';
//$wrt .= '<td><img src="./img/recruiter/'.$sgroups.'.png"></td><td><img src="./img/recruiter/'.$sgroups.'.jpg">'.$sgroups.'</td>';
$wrt .= '</tr>';
$grouptypes = good_query_table("SELECT * FROM eve_db_invtypes WHERE groupID=" . $sgroups . " AND published=1");
$wrt1 .= '<div class="collapse ui-accordion-content ui-helper-reset ui-widget-content ui-corner-bottom ui-accordion-content-active">' . wrt_table(0, 0, 0, '100%', 'center');
foreach ($grouptypes as $itum) {
//$wrt .= '<tr><td>'.$itum['typeName'].'</td></tr>';
$skills = $xmlRead->xpath("result/rowset[@name='skills']/row[@typeID='" . $itum['typeID'] . "']");
//$wrt .= '<tr><td>'.$skills.'</td></tr>';
$xml2json = json_encode($skills);
$finished = json_decode($xml2json, TRUE);
//echo'<pre>';print_r($finished);echo'</pre><hr>';
if ($finished) {
$skill_id = $finished[0]['@attributes']['typeID'];
} else {
$skill_id = 0;
}
if ($itum['typeID'] == $skill_id) {
$skill_level = $finished[0]['@attributes']['level'];
<?php
$strLocation = './../';
include './../config.php';
include './../includes/functions.php';
include './../includes/database.php';
$sql = good_query_table("SELECT * FROM feeds WHERE enabled='1'");
echo '<pre>';
print_r($sql);
echo '</pre>';
foreach ($sql as $row) {
echo $row['tag'] . '<br>';
echo $row['url'] . '<br>';
$xmlFile = file_get_contents($row['url']);
file_put_contents($strLocation . "cache/xml/feeds_" . $row['tag'] . "_prepare.xml", $xmlFile);
$feedsLocal = $strLocation . "cache/xml/feeds_" . $row['tag'] . "_prepare.xml";
$string = file_get_contents($feedsLocal);
$xmlRead = new SimpleXMLElement($string);
//do some error checking
//if error check is good then rename
rename($strLocation . "cache/xml/feeds_" . $row['tag'] . "_prepare.xml", $strLocation . "cache/xml/feeds_" . $row['tag'] . ".xml");
}
