$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>';
}
//echo moduledrop('index');
$i = 0;
if (isset($getHeaderTrusted)) {
if ($getHeaderTrusted == 'Yes') {
if ($getHeaderCorpID == $G_corpID) {
echo alert_check();
$sec_site = good_query_assoc("SELECT sec_site_admin FROM corp_members WHERE char_id=" . $getHeaderCharID . "");
if ($sec_site['sec_site_admin']) {
$issiteadmin = 1;
$allow = array(1 => 'Basic', 2 => 'Standard', 3 => 'Admin', 4 => 'Site Admin');
$sql_in = "'1','2','3','4'";
//echo'superadmin';
} else {
$issiteadmin = 0;
$allow = array(1 => 'Basic', 2 => 'Standard', 3 => 'Admin');
$sql_in = "'1','2','3'";
//echo'regularadmin';
}
include $module_dir . 'navigation/config.php';
$wrt = $wrt_top . '<table cellpadding="0" cellspacing="0" border="0" align="center" width="' . $tblWidth . '">';
//############################################# menu order sof
$wrt .= '<tr><td width="25%">';
<?php
require_once $module_dir . 'bulletin/config.php';
echo '<p> </p>';
if (!isset($_GET['mode'])) {
$getNOPages = good_query_assoc("SELECT bulletins FROM settings LIMIT 1");
$bulletin_limit = $getNOPages['bulletins'];
$result = good_query("SELECT *, DATE_FORMAT(postdate,'%Y-%m-%d') AS date FROM bulletin ORDER BY postdate DESC LIMIT {$bulletin_limit}");
echo '<table class="center" width="' . $tblWidth . '"><tr><td class="left"><div id="accordion" style="width:100%;">';
while ($row = mysql_fetch_array($result)) {
//if ($isDirector) {$editpanel = '<hr><span class="edit"><a href="'.$root_url.'&mode=edit&id='.$row['id'].'">edit</a></span> <span class="del"><a id="opener" href="./?p=data&mode=bulletin&a=delete&id='.$row['id'].'">delete</a></span>';} else {$editpanel ='';}
echo '<h3><a href="#"><div><span>' . $row['title'] . '</span><span class="right">' . $row['author'] . ' | ' . date('Y-m-d', strtotime($row['postdate'])) . ' </span></div></a></h3>
<div><span class="btext">' . $row['content'] . '</span></div>';
//if ($admin == true) {echo '<tr><td class="tleft" colspan="2"><a href="./?p=bulletin&s=edit&id='.$row['id'].'"><img src="database_edit.png" class="nob"></a><a href="./?p=bulletin&s=delete&id='.$row['id'].'"><img src="database_delete.png" class="nob"></a></td></tr>';} // ############################ ADMIN CHECK
//if ($admin == true) {echo '<tr><td class="tleft" colspan="2"><span class="edit"><a href="./?p=bulletin&s=edit&id='.$row['id'].'">edit</a></span> <span class="del"><a id="opener" href="./?p=bulletin_data&a=delete&id='.$row['id'].'">delete</a></span></td></tr>';} // ############################ ADMIN CHECK
//echo '</table>';
//echo '<p> </p>';
}
echo '</div></td></tr></table>';
// ############################################################## NEW WAY EOF
}
function get_name($string)
{
$dbcall = good_query_assoc("SELECT typeName FROM eve_db_invtypes WHERE typeID={$string} LIMIT 1");
return $dbcall['typeName'];
}
$wrt .= ldimg($item, 'type', '', '', '32', '24');
$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';
function getInvite($token)
{
return good_query_assoc("SELECT name, email, freeInvites, phone, registered, dev, waitinglist FROM `garage_invites` WHERE token = '{$token}'");
}
$p_title = mysql_real_escape_string($_POST['p_title']);
$p_content = mysql_real_escape_string($_POST['p_content']);
$charid = mysql_real_escape_string($_SERVER['HTTP_EVE_CHARID']);
$date = strtotime(date('Y-m-d H:i:s'));
$id = mysql_real_escape_string($_POST['id']);
mysql_query("UPDATE pages SET p_name='{$p_name}', p_title='{$p_title}', p_content='{$p_content}', char_id='{$charid}', datetime='{$date}' WHERE id = '{$id}'");
$_SESSION['text'] = 'Page "' . $p_name . '" Updated Successfully!';
$_SESSION['type'] = 'success';
if ($logFile) {
logToFile('Site Pages', 'Edit', $p_name);
}
// Logger
//header('Location: ./?p=page_manager&do=edit&id='.$id.'');
redirect('./?module=admin&part=page&do=edit&id=' . $id . '');
exit;
}
if (isset($_GET['a']) && $_GET['a'] == 'del') {
$id = mysql_real_escape_string($_GET['id']);
$get_name = good_query_assoc("SELECT p_title FROM pages WHERE id='" . $id . "'");
$show_name = $get_name['p_title'];
$_SESSION['text'] = 'Page "' . $show_name . '" Deleted Successfully!';
$_SESSION['type'] = 'success';
if ($logFile) {
logToFile('Site Pages', 'Deletion', $show_name);
}
// Logger
mysql_query("DELETE FROM pages WHERE id='" . $id . "'");
//header('Location: ./?p=page_manager');
redirect('./?module=admin&part=page');
exit;
}
if (isset($_GET['s'])) {
if ($_GET['s'] == 'apiset') {
$keyid = mysql_real_escape_string($_POST['keyID']);
$vcode = mysql_real_escape_string($_POST['vCode']);
$charid = mysql_real_escape_string($_POST['charID']);
mysql_query("UPDATE corp_members SET api_keyid='{$keyid}', api_vcode='{$vcode}' WHERE char_id='{$charid}'");
echo 'Update Success';
$_SESSION['text'] = 'API Updated!';
$_SESSION['type'] = 'success';
//if ($logFile) {logToFile('Fitting','Fitt Deleted','no return value');} // Logger
redirect('./?module=member_settings');
exit;
} elseif ($_GET['s'] == 'standings') {
$char_id = $_SERVER['HTTP_EVE_CHARID'];
$apidb = good_query_assoc("SELECT * FROM corp_members WHERE char_id='{$char_id}'");
$apiurl = "https://api.eveonline.com/char/Standings.xml.aspx?keyID=" . $apidb['api_keyid'] . "&vCode=" . $apidb['api_vcode'];
$xmlFile = file_get_contents($apiurl);
file_put_contents("./cache/xml/hud/" . $char_id . '.xml', $xmlFile);
//echo 'Done Fetching Api';
if (!file_exists('./cache/xml/hud/' . $_SERVER['HTTP_EVE_CHARID'] . '.xml')) {
//echo'nope';
} else {
$charxml = './cache/xml/hud/' . $_SERVER['HTTP_EVE_CHARID'] . '.xml';
$xmlFile = file_get_contents($charxml);
$xmlRead = new SimpleXMLElement($xmlFile);
$accChars = $xmlRead->xpath("result/characterNPCStandings/rowset[@name='NPCCorporations']/row");
$ic = 0;
foreach ($accChars as $curChars) {
$result = good_query("SELECT * FROM cache_ag_standings WHERE char_id='{$char_id}' AND fromID={$curChars['fromID']}");
if (mysql_num_rows($result) > 0) {
function getagents($solsystem)
{
$retval = '';
global $charid, $G_corpID, $cur_lvl;
//$get_ag = mysql_query("SELECT * FROM eve_db_agentloc WHERE ag_sol_id='".$solsystem."'");
$get_ag = mysql_query("SELECT * FROM eve_db_agentloc WHERE ag_sol_id='" . $solsystem . "' AND ag_lvl>='" . $cur_lvl . "'");
if ($get_ag) {
//echo '<ul class="loc">';
$retval .= wrt_table(0, 0, 0, '100%', '');
while ($row_a = mysql_fetch_array($get_ag)) {
//$avail = good_query_assoc("SELECT * FROM cache_ag_standings WHERE (char_id='$charid' OR char_id='0000$G_corpID' OR char_id='0001$G_corpID') AND fromID='$row_a[ag_crp]' AND standings>='3'");
$stand_pilot = good_query_assoc("SELECT * FROM cache_ag_standings WHERE (char_id='{$charid}' OR char_id='0000{$G_corpID}' OR char_id='0001{$G_corpID}') AND fromID='{$row_a['ag_crp']}' AND standings>='3'");
$stand_corp = good_query_assoc("SELECT cags.fromID,cags.standings FROM cache_ag_standings cags INNER JOIN eve_db_chrfactions fac ON (cags.fromID=fac.corporationID)");
//$stand_corp = good_query_assoc("SELECT cags.fromID FROM cache_ag_standings cags INNER JOIN eve_db_chrfactions fac ON (cags.fromID=fac.corporationID)WHERE (char_id='$charid' OR char_id='0000$G_corpID' OR char_id='0001$G_corpID') AND fromID='$row_a[ag_crp]' AND standings>='3'");
if ($stand_pilot['fromID'] || $stand_corp['fromID']) {
//echo'<pre>';print_r($stand_pilot);echo'</pre>';
$tst = '';
if ($row_a['ag_lvl'] == '1') {
$aglvl = 'contact';
$ag_lvl = '1';
$ag_stand = '-1';
if ($stand_pilot['standings'] > '-1' || $stand_corp['standings'] > '-1') {
$tst = 'l1avail';
$show = true;
} else {
$show = false;
}
} elseif ($row_a['ag_lvl'] == '2') {
$aglvl = 'contact';
$ag_lvl = '2';
$ag_stand = '1';
if ($stand_pilot['standings'] > '1' || $stand_corp['standings'] > '1') {
$tst = 'l2avail';
$show = true;
} else {
$show = false;
}
} elseif ($row_a['ag_lvl'] == '3') {
$aglvl = 'contact3';
$ag_lvl = '3';
$ag_stand = '3';
if ($stand_pilot['standings'] > '3' || $stand_corp['standings'] > '3') {
$tst = 'l3avail';
$show = true;
} else {
$show = false;
}
} elseif ($row_a['ag_lvl'] == '4') {
$aglvl = 'contact4';
$ag_lvl = '4';
$ag_stand = '5';
if ($stand_pilot['standings'] > '5' || $stand_corp['standings'] > '5') {
$tst = 'l4avail';
$show = true;
} else {
$show = false;
}
} else {
$aglvl = 'contact';
$ag_lvl = '';
$show = false;
}
//echo '<li class="'.$aglvl.'"><img height="32" align="left" src="http://image.eveonline.com/Corporation/'.$row_a['ag_crp'].'_32.png"> <a href="#" onclick="CCPEVE.showInfo(1377, '.$row_a['ag_id'].')">'.$row_a['ag_name'].'</a> <a href="#" onclick="CCPEVE.startConversation('.$row_a['ag_id'].')"><img src="./img/hud/bubble.png"></a></li>'.PHP_EOL;
//$retval .= '<li style="height: 32px; width:400px; margin:4 0 0 4; border-bottom:1px solid #c0c0c0;" class="'.$aglvl.'"><span id="inp"><span title="chartip"><img title="'.$row_a['ag_st_name'].'" height="32" align="left" src="http://image.eveonline.com/Corporation/'.$row_a['ag_crp'].'_32.png"></span></span> <a href="javascript:void(0)" onclick="CCPEVE.showInfo(1377, '.$row_a['ag_id'].')">'.$row_a['ag_name'].'</a> <a href="javascript:void(0)" onclick="CCPEVE.startConversation('.$row_a['ag_id'].')"><img src="./img/hud/bubble.png"></a></li>'.PHP_EOL;
if ($show) {
$retval .= '
<tr>
<td colspan="2"><img src="./img/hud/l' . $ag_lvl . '.png"></td><td rowspan="2" width="32" class="ag_b_bot"><img title="' . $row_a['ag_st_name'] . '" src="http://image.eveonline.com/Corporation/' . $row_a['ag_crp'] . '_32.png"></td><td class="ag_b_bot" rowspan="2"><a href="javascript:void(0)" onclick="CCPEVE.showInfo(1377, ' . $row_a['ag_id'] . ')">' . $row_a['ag_name'] . '</a></td>
</tr>
<tr>
<td class="ag_b_bot" width="16"><a href="javascript:void(0)" onclick="CCPEVE.setDestination(' . $row_a['ag_st_id'] . ')"><img title="Set Destination" src="./img/hud/set.png"></a></td><td class="ag_b_bot" width="16"><a href="javascript:void(0)" onclick="CCPEVE.startConversation(' . $row_a['ag_id'] . ')"><img title="Start Conversation" src="./img/hud/bubble.png"></a></td>
</tr>
';
//<a href="#" onclick="CCPEVE.setDestination('.$row_a['ag_sol_id'].')">set_route</a> -
//<a href="#" onclick="CCPEVE.startConversation('.$row_a['ag_id'].')">convo</a>
}
$tst = '';
}
//echo '<li class="'.$aglvl.'"><img align="left" src="http://image.eveonline.com/Corporation/'.$row_a['ag_crp'].'_32.png"> <a href="#" onclick="CCPEVE.showInfo(1377, '.$row_a['ag_id'].')">'.$row_a['ag_name'].'</a> <br /> <a href="#" onclick="CCPEVE.setDestination('.$row_a['ag_sol_id'].')">set_route</a> - <a href="#" onclick="CCPEVE.startConversation('.$row_a['ag_id'].')">convo</a></li>'; // shows all
}
//echo '</ul>';
$retval .= '</table>';
}
$pelle = 'asdasd';
return $retval;
}
}
if (file_exists($root . '/' . $module . '/handler/index.php')) {
$wrt .= '<td class="tcell' . $odder . '">' . show_status('yn', 'yes') . '</td>';
$i++;
} else {
$wrt .= '<td class="tcell' . $odder . '">' . show_status('yn', 'no') . '</td>';
}
if (file_exists($root . '/' . $module . '/public/index.php')) {
$wrt .= '<td class="tcell' . $odder . '">' . show_status('yn', 'yes') . '</td>';
$i++;
} else {
$wrt .= '<td class="tcell' . $odder . '">' . show_status('yn', 'no') . '</td>';
}
global $mnm, $mdescr, $mreq, $mid;
if ($i == $mreq) {
$mod_row = good_query_assoc("SELECT * FROM modules WHERE module_id = {$mid}");
if ($mod_row) {
$wrt .= '<td class="tcell' . $odder . ' font_s">installed</td>';
} else {
$wrt .= '<td class="tcell' . $odder . ' font_s">Install</td>';
}
} else {
$wrt .= '<td class="tcell' . $odder . ' font_s">Broken</td>';
}
$wrt .= '<tr><td class="tcell' . $odder . ' border_bottom font_s"> </td><td class="tcell' . $odder . ' border_bottom font_s">' . $mnm . '</td><td colspan="4" class="tcell' . $odder . ' border_bottom font_s">' . $mdescr . '</td></tr>';
}
}
closedir($handle);
}
$wrt .= '';
$wrt .= '';
$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 .= '<div id="dialog-confirm" title="Delete a Page?">';
$wrt .= ' <p><span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 20px 0;"></span>This Page will be permanently deleted and cannot be recovered. Are you sure?</p>';
$wrt .= ' </div>';
$editor = good_query_assoc("SELECT * FROM pages WHERE id='" . $_GET['id'] . "'");
$wrt .= '<form action="./?module=data&part=page&a=edit" method="post"><table border="0">';
$wrt .= '<tr><th colspan="2">Edit Page</th></tr>';
$wrt .= '<tr>';
$wrt .= '<td class="left">Page Identifier</td><td class="left"><span id="inp"><input title="' . $pidenti . '<br />Like this: index&entry=' . $editor['p_name'] . '" type="text" name="p_name" value="' . $editor['p_name'] . '"></span></td>';
$wrt .= '</tr><tr>';
$wrt .= '<td class="left">Page Title</td><td class="left"><input type="text" name="p_title" value="' . $editor['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">' . $editor['p_content'] . '</textarea></td>';
$wrt .= '</tr>';
$wrt .= '<tr><td colspan="2"><input type="hidden" name="id" value="' . $editor['id'] . '"><input type="submit" value="update"><span class="del"><a id="opener" href="./?module=data&part=page&a=del&id=' . $editor['id'] . '">delete</a></span></td></tr>';
$wrt .= '</table></form>';
}
$wrt .= '';
$wrt .= '';
<?php
include $module_dir . 'api/config.php';
$api = good_query_assoc("SELECT * FROM api");
$wrt = '
<script>
$(function() {
$( "input:submit, input:button").button();
$( "button#insert").button({
icons: {
primary: "ui-icon-disk"
},
text: true
});
});
</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>';
<script type="text/javascript" src="./js/jquery.cluetip.all.min.js"></script>
<?php
include './includes/securitycheck.php';
?>
</head>
<body>
<div id="loadingpage" align="center"><div id="loadingpage_content"><br /><img src="./img/ghooloader2.gif" /></div></div>
<?php
echo alert_check();
$row_title = good_query_assoc("SELECT * FROM settings");
if (isset($_GET['module'])) {
if (isset($_GET['part'])) {
$row = good_query_assoc("SELECT url,title FROM navigation WHERE url='" . $_GET['module'] . "&part=" . $_GET['part'] . "'");
} elseif (isset($_GET['entry'])) {
$row = good_query_assoc("SELECT url,title FROM navigation WHERE url='" . $_GET['module'] . "&entry=" . $_GET['entry'] . "'");
} else {
$row = good_query_assoc("SELECT url,title FROM navigation WHERE url='" . $_GET['module'] . "'");
}
$ttle = $row['title'];
} elseif (empty($_GET['module'])) {
$ttle = 'Docked';
} else {
$ttle = 'Other';
}
$wrt = '<br /><table cellpadding="0" cellspacing="0" border="0" class="center tabwidth"><tr>
<td class="hset htitle"><span class="corptitle">Corporation</span>';
$wrt .= pageheader($row_title['site_title'], $ttle);
$wrt .= '</td>
</tr></table>';
echo $wrt;
//echo 'name='.$group_name.' groupid='.$group_id;
//echo './?module=admin&part=competence&do=grp&a=edit&id='.$group_id;
$_SESSION['text'] = 'Competence Group Edited!';
$_SESSION['type'] = 'success';
if ($logFile) {
logToFile('Competence', 'Group Edited', $group_name);
}
// Logger
redirect('./?module=admin&part=competence&do=grp&a=edit&id=' . $group_id);
exit;
} elseif ($_GET['s'] == 'skill') {
$c_grp = mysql_escape_string($_POST['id']);
$c_gid = mysql_escape_string($_POST['gid']);
$c_skill = mysql_escape_string($_POST['c_skill']);
$c_lvl = mysql_escape_string($_POST['c_lvl']);
$check = good_query_assoc("SELECT * FROM comp_table WHERE comp_id={$c_grp} AND skill_id={$c_skill}");
echo $check['skill_id'] . '-' . $check['skill_lvl'];
if ($check) {
//if already exists check if duplicate or update.
if ($check['skill_lvl'] == $c_lvl) {
//duplicate so go back.
//echo'we do nothing!';
$_SESSION['text'] = 'Skill Prereq Already Set!';
$_SESSION['type'] = 'warning';
if ($logFile) {
logToFile('Competence', 'Group Duplicate', $group_name);
}
// Logger
} else {
//new level so update.
//echo'now we update lvl';
<?php
require_once './config.php';
require_once './includes/database.php';
require_once './includes/functions.php';
require_once './includes/igb_headers.php';
session_start();
$pwdform = mysql_escape_string(trim($_POST['login']));
echo $pwdform;
$pwd = good_query_assoc("SELECT global_pwd FROM settings");
echo $pwd['global_pwd'];
if (empty($pwdform)) {
$_SESSION['text'] = 'Login Password EMPTY!';
$_SESSION['type'] = 'warning';
header("Location: ./");
} elseif ($pwdform == $pwd['global_pwd']) {
$date = strtotime(date('Y-m-d H:i:s'));
$charid = $getHeaderCharID;
$upd = good_query_assoc("UPDATE corp_members SET sec_ip='{$ip}', sec_global_pwd='1', sec_time='{$date}' WHERE char_id='{$charid}'");
//echo $date;
$_SESSION['text'] = 'Login Password ACCEPTED!';
$_SESSION['type'] = 'success';
header("Location: ./?module=misc&entry=login_success");
} else {
$_SESSION['text'] = 'Login Password WRONG!';
$_SESSION['type'] = 'info';
header("Location: ./");
}
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;
}
$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 .= '';
$wrt .= '</table></form>';
} elseif (isset($_GET['do']) && $_GET['do'] == 'edit') {
$edit_cat = good_query_assoc("SELECT * FROM forum_cat WHERE id='" . $_GET['id'] . "'");
$wrt .= '<form method="post" action="' . $module_data . '&mode=forumedit&a=editcat" name="editcat"><table border="0" cellspacing="0" cellpadding="0">';
$wrt .= '<tr><td class="left">Title</td><td class="left"><input type="text" name="title" value="' . $edit_cat['cat_name'] . '"></td>';
$wrt .= '<tr><td class="left">Description</td><td class="left"><textarea name="descr">' . $edit_cat['cat_descr'] . '</textarea></td>';
if ($edit_cat['cat_isdir']) {
$chck_isdir = ' checked';
} else {
$chck_isdir = '';
}
$wrt .= '<tr><td class="left" colspan="2"><input type="checkbox" id="check" name="fordirs" value="1"/' . $chck_isdir . '><label for="check">Director Only?</label> <input type="hidden" name="id" value="' . $edit_cat['id'] . '"><input type="submit" value="Update"></td></tr>';
$wrt .= '';
$wrt .= '</table></form>';
}
$wrt .= '';
$wrt .= '';
$wrt .= '';
<?php
if (isset($_SERVER['HTTP_EVE_TRUSTED'])) {
$getHeaderTrusted = $_SERVER['HTTP_EVE_TRUSTED'];
if ($_SERVER['HTTP_EVE_TRUSTED'] == 'Yes') {
//Collecting all headers once so i can abuse them !
$getHeaderCorpID = $_SERVER['HTTP_EVE_CORPID'];
$getHeaderCharID = $_SERVER['HTTP_EVE_CHARID'];
$getHeaderCharName = $_SERVER['HTTP_EVE_CHARNAME'];
$getHeaderSolSysName = $_SERVER['HTTP_EVE_SOLARSYSTEMNAME'];
$getHeaderCorpRole = $_SERVER['HTTP_EVE_CORPROLE'];
}
}
$corp_row = good_query_assoc("SELECT corp_id FROM settings");
$G_corpID = $corp_row['corp_id'];
$ip = $_SERVER['REMOTE_ADDR'];
$evenOdd = true;
} elseif ($_GET['a'] == 'post') {
$answer = mysql_real_escape_string($_POST['a_answer']);
$aid = $_POST['aid'];
$qid = $_POST['qid'];
//echo $answer . $qid . $aid;
mysql_query("UPDATE forum_posts SET a_answer='{$answer}' WHERE question_id = '{$qid}' AND a_id='{$aid}'");
//if ($logFile) {logToFile('Board','Edit','Edited Post');} // Logger
$_SESSION['text'] = 'Post added!';
$_SESSION['type'] = 'success';
//header("Location: ./?p=forum&mode=view&id=$qid");
redirect('./?p=forum&mode=view&id=' . $qid . '');
exit;
} elseif ($_GET['a'] == 'delcat') {
$id = mysql_real_escape_string($_GET['id']);
mysql_query("DELETE FROM forum_cat WHERE id='" . $id . "'");
$post_deleter = good_query_assoc("SELECT * FROM forum_thread WHERE pid=" . $id . "");
mysql_query("DELETE FROM forum_posts WHERE question_id='" . $post_deleter['id'] . "'");
mysql_query("DELETE FROM forum_thread WHERE pid='" . $id . "'");
if ($logFile) {
logToFile('Forum', 'Deletion', 'Category Deleted');
}
// Logger
$_SESSION['text'] = 'Forum Category deleted!';
$_SESSION['type'] = 'success';
redirect($module_admin);
exit;
} elseif ($_GET['a'] == 'editcat') {
if (isset($_POST['fordirs']) && $_POST['fordirs'] == '1') {
$fordirs = '1';
} else {
$fordirs = '0';
echo $chaid.'<br />';
echo $chaname.'<br />';
echo $charole.'<br />';
echo $chaloc.'<br />';
echo $chaloc.'<br />';
echo $chaship.'<br />';
echo $chaon.'<br />';
echo $chaoff.'<br />';
*/
$exists = good_query_assoc("SELECT count(*) as numrecords FROM corp_members WHERE char_id='" . $chaid . "'") or die('queryproblems - exists.');
//$exists= good_query_assoc("SELECT count(*) as numrecords FROM corp_members WHERE char_id='" . $chaid . "' and char_log_on='" . $chaon . "'") or die ('Queryproblem checking existing record.');
if (!$exists['numrecords'] >= 1) {
//echo 'doesnt exists';
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)) {
<?php
if (isset($_GET['entry']) && $_GET['entry'] == 'login_success') {
$time = good_query_assoc("SELECT global_pwd_interval FROM settings");
$wrt = '<table cellpadding="0" cellspacing="0" border="0" class="center" width="50%">';
$wrt .= '';
$wrt .= '<tr><th class="ft_head">Successful Login!</th></tr>';
$wrt .= '<tr>';
$wrt .= '<td class="left">';
$wrt .= 'You have gained access to this site.<br />The site will ask for renewal of password authentication in two other cases.';
$wrt .= '<ol>';
$wrt .= '<li>Your authentcation period expires, that is within ' . $time['global_pwd_interval'] . ' weeks.</li>';
$wrt .= '<li>You visit this site with another computer/internet address.</li>';
$wrt .= '</ol>';
$wrt .= 'Password can change, if and when it does. it will be accessible thorugh the corp ingame bulletin!';
$wrt .= '</td>';
$wrt .= '</tr>';
$wrt .= '</table>';
$wrt .= '';
}
echo $wrt;
$tbl_name = "forum_posts";
//your table name
// How many adjacent pages should be shown on each side?
$adjacents = 2;
/*
First get total number of rows in data table.
If you have a WHERE clause in your query, make sure you mirror it here.
*/
$query = "SELECT COUNT(*) as num FROM {$tbl_name} WHERE question_id='{$id}'";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages['num'];
/* Setup vars for query. */
$targetpage = $module_public . '&mode=view&pid=' . $pid;
//your file name (the name of this file)
//$limit = 10; //how many items to show per page
$getNOPages = good_query_assoc("SELECT forum_posts FROM settings LIMIT 1");
//$limit = $pageBreak;
$limit = $getNOPages['forum_posts'];
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = '1';
}
//$page = $_GET['page'];
if ($page) {
$start = ($page - 1) * $limit;
} else {
$start = 0;
}
//if no page var is given, set start to 0
/* Get data. */
$pagination .= "<a href=\"{$targetpage}&page={$next}\">next <img src=\"./img/rgt.png\"></a>";
} else {
$pagination .= "<span class=\"disabled\">next <img src=\"./img/rgt.png\"></span>";
$pagination .= "</div>\n";
}
}
while ($row = mysql_fetch_array($result)) {
if ($evenOdd) {
$odder = " bcelleven";
$splitter = false;
} else {
$odder = " bcellodd";
$splitter = true;
}
$evenOdd = !$evenOdd;
$get_latest_post = good_query_assoc("SELECT a_datetime FROM forum_posts WHERE question_id=" . $row['id'] . " ORDER BY a_datetime DESC LIMIT 1");
$wrt .= '<tr><td class="left' . $odder . $fd_color . '" width="30%"><a class="ld" href="' . $module_public . '&mode=view' . $urlsel . '&pid=' . $row['pid'] . '&id=' . $row['id'] . '">' . $row['topic'] . '</a> by ' . $row['name'] . '</td><td class="left' . $odder . $fd_color . '" width="20%">' . trim_text($row['detail'], 20) . '</td><td class="left' . $odder . $fd_color . '">' . $row['name'] . '</td><td class="right' . $odder . $fd_color . '">' . substr($get_latest_post['a_datetime'], 0, 16) . '</td></tr>';
}
// PAGINATION END
$wrt .= '</table></td></tr>';
}
$wrt .= '';
$wrt .= '';
$wrt .= '';
$wrt .= '</table>';
}
echo $wrt;
if (isset($pagination)) {
echo $pagination;
}
//echo $pagination;
<?php
//ob_start();
//pagetitle($G_siteTitle,"Docked");
//echo '<br /><br /><br /><br /><b>Welcome to '.$G_corpName.'!</b>';
if (!isset($_GET['entry'])) {
$getPage = good_query_assoc("SELECT * FROM pages WHERE p_name='index'");
} else {
$getPage = good_query_assoc("SELECT * FROM pages WHERE p_name='" . $_GET['entry'] . "'");
}
//$getPage = good_query_assoc("SELECT * FROM pages ");
$wrt = '<table cellpadding="0" cellspacing="0" border="0" class="center" width="' . $tblWidth . '">';
$wrt .= '<tr><th class="ft_head left">' . $getPage['p_title'] . '</th></tr>';
$wrt .= '';
//$wrt .= '<tr><td class="left">'.nl2br($getPage['p_content']).'</td></tr>';
$wrt .= '<tr><td class="left">' . $getPage['p_content'] . '</td></tr>';
$wrt .= '';
$wrt .= '';
$wrt .= '';
$wrt .= '';
$wrt .= '';
$wrt .= '';
$wrt .= '';
$wrt .= '';
$wrt .= '';
$wrt .= '</table>';
if (empty($getPage['p_name'])) {
echo '<br /><br /><br /><br /><table class="center"><tr><th class="ft_head">Invalid/Non Existant Page Call!</th></tr><tr><td>Work it out!</td></tr></table>';
} else {
echo $wrt;
}
$wrt .= '</table>';
$wrt .= '</td>';
$wrt .= '<td>';
//------------------------------- Content Start
if (!isset($_GET['do'])) {
$wrt .= wrt_table(0, 0, 0, '100%');
$wrt .= '<tr><td class="ft_head">Admin Diagram</td></tr>';
$wrt .= '<tr><td>content</td></tr>';
$wrt .= '</table>';
} elseif ($_GET['do'] == 'grp') {
if (!isset($_GET['a'])) {
$wrt_g = '<form action="./?module=data&part=competence&s=group" method="post">Group Name: <input type="text" name="grp_name"> <input type="submit" value="Add"></form>';
$stitle = 'Add Group';
} elseif (isset($_GET['a']) && $_GET['a'] == 'edit') {
$get_id = mysql_escape_string($_GET['id']);
$sql_ed_grp = good_query_assoc("SELECT * FROM comp_grp WHERE comp_grp_id={$get_id}");
$wrt_g = '<form action="./?module=data&part=competence&s=groupupd" method="post">Group Name: <input type="text" name="grp_name" value="' . $sql_ed_grp['comp_grp_name'] . '"><input type="hidden" name="grp_id" value="' . $sql_ed_grp['comp_grp_id'] . '"> <input type="submit" value="Update"></form>';
$stitle = 'Edit Group';
} else {
$wrt_g = '';
$stitle = ' ';
}
$wrt .= wrt_table(0, 0, 0, '100%');
$wrt .= '<tr><td class="ft_head">Groups</td><td class="ft_head">' . $stitle . '</td></tr>';
$comp_groups = good_query_table("SELECT * FROM comp_grp");
$wrt .= '<tr><td width="150">' . wrt_table(0, 0, 0, '100%');
foreach ($comp_groups as $cgrp) {
if (isset($_GET['id']) && $_GET['id'] == $cgrp['comp_grp_id']) {
$cglink = ' class="ot_sel"';
$cglink2 = ' ot_sel';
} else {
$skillgrps = array('266', '273', '272', '271', '255', '268', '258', '269', '256', '275', '1044', '270', '278', '257', '989', '274');
$arrskills = $xmlRead->xpath("result/rowset[@name='skills']/row");
foreach ($arrskills as $value) {
//$skillname = good_query_assoc("SELECT typeName FROM eve_db_invtypes WHERE typeID=".$value['typeID']."");
//echo $value['typeID'] .'<br>';
//echo $skillname['typeName'] . '<img src="./img/recruiter/level'.$value['level'].'.gif">' . $value['typeID'];
//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) {
First get total number of rows in data table.
If you have a WHERE clause in your query, make sure you mirror it here.
*/
$exclude1 = "WHERE ((corporationID NOT IN ('414596443')) or ('shipTypeID' NOT IN ('670')))";
//$exclude2 = "WHERE (corporationID != '414596443' or 'shipTypeID' != '670')";
//$exclude2 = "WHERE corporationID != '414596443'";
//$exclude2 = "WHERE shipTypeID != '670'";
$exclude2 = "WHERE corporationID != '414596443' AND shipTypeID != '670'";
$query = "SELECT COUNT(*) as num FROM {$tbl_name} {$exclude2}";
//$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = mysql_fetch_assoc(mysql_query($query));
$total_pages = $total_pages['num'];
/* Setup vars for query. */
$targetpage = $module_public;
//your file name (the name of this file)
$getNOPages = good_query_assoc("SELECT pages_kills FROM settings LIMIT 1");
$limit = $getNOPages['pages_kills'];
//how many items to show per page
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = '1';
}
//$page = $_GET['page'];
if ($page) {
$start = ($page - 1) * $limit;
} else {
$start = 0;
}
//if no page var is given, set start to 0
/* Get data. */
