<?php
$s_html = "";
$s_task = lib_set_var("task", "");
$i_overlayID = intval(lib_set_var("overlayID", "0"));
$i_julianDate = intval(lib_set_var("julian", "0"));
$s_input = lib_set_var("input", "");
$server = "65.175.107.2:3306";
$username = "******";
$password = "******";
$dbname = "cms";
$sqlconnect = mysql_connect($server, $username, $password);
$sqldb = mysql_select_db($dbname, $sqlconnect);
switch ($s_task) {
case "save":
$s_sql = "update cms.dyn_julian_dates set event = '{$s_input}' where overlayID = {$i_overlayID} and julianDate = {$i_julianDate}";
$s_html = $s_sql;
mysql_query($s_sql, $sqlconnect);
$i_result = mysql_affected_rows($sqlconnect);
if ($i_result == 0) {
$s_sql = "insert into cms.dyn_julian_dates (overlayID, julianDate, event) select {$i_overlayID}, {$i_julianDate}, '{$s_input}'";
$s_html .= "\n" . $s_sql;
mysql_query($s_sql, $sqlconnect);
}
mysql_close($sqlconnect);
break;
case "scroll":
//$s_output = "";
//$s_date = lib_set_var("date","01/01/1900");
//$s_sql = "select T.due_date, T.name, T.notes, T.task_id, A.first_name, A.last_name, O.org_name, L.street, L.city, L.state, L.zip
//from nightly_update.dbo.crm_task_table_copy T
<?php
$s_html = "";
$i_itemID = intval(lib_set_var("itemID", "0"));
$s_task = lib_set_var("task", "");
$s_purpose = lib_set_var("purpose", "");
$s_shipName = lib_set_var("shipName", "");
$s_slot = lib_set_var("slot", "");
$s_module = lib_set_var("module", "");
$b_command = lib_set_var("command", 0);
$s_filename = basename(__FILE__);
$s_pageName = "Ship Fitting";
$server = "65.175.107.2:3306";
$username = "******";
$password = "******";
$dbname = "braddoro";
$o_conn = mysql_connect($server, $username, $password);
if (!$o_conn) {
die_well(__LINE__, mysql_error());
}
$o_sel = mysql_select_db($dbname);
if (!$o_sel) {
die_well(__LINE__, mysql_error());
}
switch ($s_task) {
case "edit":
$s_sql = "select fitID, purpose, shipName, slot, module from braddoro.dyn_ship_fitting2 where fitID = {$i_itemID}";
$q_data = mysql_query($s_sql);
if (!$q_data) {
die_well(__LINE__, mysql_error());
}
$s_html = $objAdmin->blueprintOutput($s_sql);
break;
case "blueprintOutput":
$s_sql = "select B.blueprintID, O.owner, B.blueprintName, B.mat_lev, B.prod_lev, B.bpc, B.copies, B.runs, B.eveID, B.location, M.description \r\n\tfrom braddoro.dyn_blueprints B \r\n\tleft join braddoro.dyn_blueprint_owners O on B.ownerID = O.ownerID\r\n\tleft join braddoro.invtypes T on B.eveID = T.typeID\r\n\tleft join braddoro.invmarketgroups M on T.marketGroupID = M.marketGroupID\r\n\torder by B.blueprintName;";
$s_html = $objAdmin->blueprintOutput($s_sql);
break;
case "blueprintSave":
$eveID = intval(lib_set_var("eveID", "0"));
$mat_lev = intval(lib_set_var("mat_lev", "0"));
$prod_lev = intval(lib_set_var("prod_lev", "0"));
$blueprintName = lib_set_var("blueprintName", "");
$bpc = intval(lib_set_var("bpc", "0"));
$runs = intval(lib_set_var("runs", "0"));
$copies = intval(lib_set_var("copies", "0"));
$ownerID = intval(lib_set_var("ownerID", "0"));
$location = lib_set_var("location", "");
if ($i_itemID > 0) {
$s_sql = "update braddoro.dyn_blueprints set mat_lev = {$mat_lev}, prod_lev = {$prod_lev}, blueprintName = rtrim('{$blueprintName}'), bpc = {$bpc}, runs = {$runs}, copies = {$copies}, ownerID = {$ownerID}, updateDate = now(), location = '{$location}', eveID = {$eveID} where blueprintID = {$i_itemID};";
} else {
$s_sql = "INSERT INTO braddoro.dyn_blueprints (eveID,mat_lev,prod_lev,blueprintName,bpc,runs,copies,ownerID,updateDate,location) select {$eveID},{$mat_lev},{$prod_lev},rtrim('{$blueprintName}'),{$bpc},{$runs},{$copies},{$ownerID},now(), '{$location}';";
}
$s_html = $objAdmin->genSQL($s_sql);
$s_sql = "update braddoro.dyn_blueprints, braddoro.invtypes set eveID = typeID where (eveID is null or eveID = 0) AND typeName = concat(rtrim(blueprintName),' Blueprint');";
$s_html = $objAdmin->genSQL($s_sql);
$s_sql = "select B.blueprintID, O.owner, B.blueprintName, B.mat_lev, B.prod_lev, B.bpc, B.copies, B.runs, B.eveID, B.location, M.description \r\n\tfrom braddoro.dyn_blueprints B \r\n\tleft join braddoro.dyn_blueprint_owners O on B.ownerID = O.ownerID\r\n\tleft join braddoro.invtypes T on B.eveID = T.typeID\r\n\tleft join braddoro.invmarketgroups M on T.marketGroupID = M.marketGroupID order by B.blueprintName;";
$s_html = $objAdmin->blueprintOutput($s_sql);
break;
case "error":
$s_html = $s_task;
break;
}