$columnall_y = 0;
$querycolumns = MYSQL_QUERY("SELECT * FROM flobase_{$columnstable}_columns WHERE secret='0' ORDER BY vieworder");
while ($columns = MYSQL_FETCH_ARRAY($querycolumns)) {
if ($columns['code_korean'] === NULL && isset($write) && !$placeholder) {
$write = write();
$placeholder = 1;
continue;
}
//set korean-code to tolower
$columns['code_korean'] = strtolower($columns['code_korean']);
//ausslassen wenn defaultwert oder nicht gesetzt
if ($columns['defaultvalue'] == $details[$columns['code_korean']] or !isset($details[$columns['code_korean']])) {
continue;
}
if ($columns['floatvalue']) {
$details[$columns['code_korean']] = bin2float($details[$columns['code_korean']]);
}
if ($columnstable == "npc") {
switch ($columns['code_english']) {
case "attackmax":
if (intval($details[$columns['code_korean']]) == 0) {
$details[$columns['code_korean']] = $details[$florensia->get_columnname("attackmin", "npc")];
}
$write = write($columns['name_' . $flolang->language], " ~ " . $details[$columns['code_korean']], $columns['code_english'], "attackmin");
break;
case "attackrange":
if (!intval($details[$columns['code_korean']])) {
$details[$columns['code_korean']] = "Melee";
} else {
$details[$columns['code_korean']] = "Range";
}
}
/* */
/* * *
MK-Time
* * */
if (!isset($_POST['tag'])) {
$_POST['tag'] = date("d");
}
if (!isset($_POST['monat'])) {
$_POST['monat'] = date("m");
}
if (!isset($_POST['jahr'])) {
$_POST['jahr'] = date("Y");
}
if (!isset($_POST['std'])) {
$_POST['std'] = date("H");
}
if (!isset($_POST['min'])) {
$_POST['min'] = date("i");
}
if (!isset($_POST['sek'])) {
$_POST['sek'] = date("s");
}
if (intval($_GET['float'])) {
$_POST['float'] = intval($_GET['float']);
}
echo "\n<div style='height:20px;'></div>\n\n<div style='float:left; width:50%;'>\n\t<form action='" . htmlentities($_SERVER['PHP_SELF']) . "' method='POST'>\n\n\t<div style='text-align:center; width:100%; border:1px solid #000000;'><div style='background-color:#4A4A4A; color:#FFFFFF;'>Float-Bin Converter</div>\n\t\t<div style='height:30px;'></div>\n\t\t<table style='text-align:center; width:100%;'>\n\t\t\t<tr><td>Float: <input type='TEXT' name='float' value='" . htmlentities($_POST['float']) . "'><input type='SUBMIT'></td></tr>\n\t\t\t<tr><td style='text-align:left;'>";
if ($_POST['float']) {
$floaterg = bin2float($_POST['float']);
}
echo "\n\t\t\t</td></tr>\n\t\t</table>\n\t\t<div style='height:30px;'></div>\n\t</div>\n\t</form>\n</div>\n<div style='margin-left:51%;'>\n\t<div style='text-align:center; border:1px solid #000000;'>\n\t\t<div style='background-color:#4A4A4A; color:#FFFFFF;'>Time Converter</div>\n\t\t<div>\n\t\t\t<form action='" . htmlentities($_SERVER['PHP_SELF']) . "' method='post'>\n\t\t\t\t<table style='width:100%;'>\n\t\t\t\t\t<tr><td style='vertical-align:top;'>\n\t\t\t\t\t\tTag: <input type='Text' name='tag' size='4' value='" . htmlentities($_POST['tag']) . "'><br />\n\t\t\t\t\t\tMonat: <input type='Text' name='monat' size='4' value='" . htmlentities($_POST['monat']) . "'><br />\n\t\t\t\t\t\tJahr: <input type='Text' name='jahr' size='4' value='" . htmlentities($_POST['jahr']) . "'><br />\n\t\t\t\t\t\t<br />\n\t\t\t\t\t\tStd: <input type='Text' name='std' size='4' value='" . htmlentities($_POST['std']) . "'><br />\n\t\t\t\t\t\tMin: <input type='Text' name='min' size='4' value='" . htmlentities($_POST['min']) . "'><br />\n\t\t\t\t\t\tSek: <input type='Text' name='sek' size='4' value='" . htmlentities($_POST['sek']) . "'><br />\n\t\t\t\t\t\t<br />\n\t\t\t\t\t\t<input type='Submit'>\n\t\t\t\t\t</td><td style='vertical-align:top;'>\n\t\t\t\t\tmkTime: <input type='Text' name='mktime' size='10' value='" . mktime($_POST['std'], $_POST['min'], $_POST['sek'], $_POST['monat'], $_POST['tag'], $_POST['jahr']) . "'><br />\n\t\t\t\t\t<br />\n\t\t\t\t\t<input type='Submit'>\n\t\t\t\t\t</td></tr>\n\t\t\t\t\t<tr><td>==> " . mktime($_POST['std'], $_POST['min'], $_POST['sek'], $_POST['monat'], $_POST['tag'], $_POST['jahr']) . "</td><td>" . date("d.m.Y - H:i:s", $_POST['mktime']) . "</td></tr>\n\t\t\t\t</table>\n\t\t\t</form>\n\t\t</div>\n\t</div>\n\t\n</div>\n";
public function details()
{
global $florensia, $flolang;
$details = array();
$detailstable = new floclass_detailstable();
foreach ($this->data as $key => $value) {
$details[strtolower($key)] = $value;
}
$querycolumns = MYSQL_QUERY("SELECT * FROM flobase_npc_columns WHERE secret='0' ORDER BY vieworder");
while ($columns = MYSQL_FETCH_ARRAY($querycolumns)) {
if ($columns['code_korean'] === NULL && isset($write) && !$placeholder) {
$detailstable->add();
continue;
}
//set korean-code to tolower
$columns['code_korean'] = strtolower($columns['code_korean']);
//ausslassen wenn defaultwert oder nicht gesetzt
if ($columns['defaultvalue'] == $details[$columns['code_korean']] or !isset($details[$columns['code_korean']])) {
continue;
}
if ($columns['floatvalue']) {
$details[$columns['code_korean']] = bin2float($details[$columns['code_korean']]);
}
switch ($columns['code_english']) {
case "attackmax":
if (intval($details[$columns['code_korean']]) == 0) {
$details[$columns['code_korean']] = $details[$florensia->get_columnname("attackmin", "npc")];
}
$detailstable->add($columns['name_' . $flolang->language], $details[$florensia->get_columnname("attackmin", "npc")] . " ~ " . $details[$columns['code_korean']], $columns['code_english'], "attackmin");
break;
case "attackrange":
if (!intval($details[$columns['code_korean']])) {
$details[$columns['code_korean']] = "Melee";
} else {
$details[$columns['code_korean']] = "Range";
}
$detailstable->add($columns['name_' . $flolang->language], $details[$columns['code_korean']], $columns['code_english']);
break;
case "airmonster":
if (intval($details[$columns['code_korean']]) != 0) {
$value = $flolang->yes;
} else {
$value = $flolang->no;
}
$detailstable->add($columns['name_' . $flolang->language], $value, $columns['code_english']);
break;
case "navalguns":
if (!intval($details[$florensia->get_columnname("attackrange", "npc")])) {
continue;
}
//melee
$detailstable->add($columns['name_' . $flolang->language], $details[$columns['code_korean']] . $columns['endvalue'], $columns['code_english']);
break;
case "navalgunspeed":
if (!intval($details[$florensia->get_columnname("navalguns", "npc")])) {
continue;
}
//no guns
$detailstable->add($columns['name_' . $flolang->language], bcdiv($details[$columns['code_korean']], 1000, 1) . $columns['endvalue'], $columns['code_english']);
break;
case "navalgunscope":
if (!intval($details[$florensia->get_columnname("navalguns", "npc")])) {
continue;
}
//no guns
$detailstable->add($columns['name_' . $flolang->language], bcdiv($details[$columns['code_korean']], 100) . $columns['endvalue'], $columns['code_english']);
break;
case "exp":
//class land/sea
if (intval($details[$florensia->get_columnname("fielddividing", "npc")])) {
$expclass = "sea";
} else {
$expclass = "land";
}
$expprocent = $florensia->get_exp($details[$columns['code_korean']], $details[$florensia->get_columnname("level", "npc")], $expclass);
$detailstable->add($columns['name_' . $flolang->language], "" . $details[$columns['code_korean']] . " ({$expprocent}/" . $details[$florensia->get_columnname("level", "npc")] . ")", $columns['code_english']);
break;
/*
case "attackcooldown1": { }
case "attackcooldown2": { }
case "attackcooldown3": {
$details[$columns['code_korean']]=$details[$columns['code_korean']]/100;
$detailstable->add($columns['name_'.$flolang->language], $details[$columns['code_korean']]."s", $columns['code_english']);
break;
}
*/
/*
case "attackcooldown1": { }
case "attackcooldown2": { }
case "attackcooldown3": {
$details[$columns['code_korean']]=$details[$columns['code_korean']]/100;
$detailstable->add($columns['name_'.$flolang->language], $details[$columns['code_korean']]."s", $columns['code_english']);
break;
}
*/
case "attackpowerelement":
case "resistenceelement":
case "attackpowerillusion":
case "resistenceillusion":
case "attackpowerholy":
case "resistenceholy":
case "attackpowerdark":
case "resistencedark":
case "attackpowerphysical":
case "resistencephysical":
case "attackpowerpoison":
case "resistencepoison":
case "attackpowerfire":
case "resistencefire":
case "attackpowerice":
case "resistenceice":
case "attackpowerlighning":
case "resistencelighning":
case "attackpowerholyph":
case "resistenceholyph":
case "attackpowerdark":
case "resistancedark":
case "attackpowerabsolute":
case "resistanceabsolute":
$details[$columns['code_korean']] = $details[$columns['code_korean']] / 10;
$detailstable->add($columns['name_' . $flolang->language], $details[$columns['code_korean']] . $columns['endvalue'], $columns['code_english']);
break;
default:
$detailstable->add($columns['name_' . $flolang->language], $details[$columns['code_korean']] . $columns['endvalue'], $columns['code_english']);
break;
}
}
return $detailstable->display();
}