<?php
session_start();
ob_start();
?>
<?php
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // Always modified
header("Cache-Control: private, no-store, no-cache, must-revalidate"); // HTTP/1.1
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache"); // HTTP/1.0
?>
<?php include ("../ewconfig.php") ?>
<?php include ("../db.php") ?>
<?php include ("chklist_maginfo.php") ?>
<?php include ("../advsecu.php") ?>
<?php include ("../phpmkrfn.php") ?>
<?php
if (!IsLoggedIn() && (@$_COOKIE[ewCookieAutoLogin] == "autologin" && @$_COOKIE[ewCookiePassword] <> "")) {
ob_end_clean();
header("Location: ../login.php");
exit();
}
LoadUserLevel();
$ewCurSec = (IsLoggedIn())? CurrentUserLevelPriv("chklist_mag") : GetAnonymousPriv("chklist_mag");
if (($ewCurSec & ewAllowAdd) <> ewAllowAdd) {
ob_end_clean();
header("Location: ../MyProfile.php");
exit();
}
?>
<?php
// Load key from QueryString
$bCopy = true;
$x_mag_name = @$_GET["mag_name"];
if (($x_mag_name == "") || (is_null($x_mag_name))) $bCopy = false;
// Get action
$sAction = @$_POST["a_add"];
if (($sAction == "") || ((is_null($sAction)))) {
if ($bCopy) {
$sAction = "C"; // Copy record
} else {
$sAction = "I"; // Display blank record
}
} else {
// Get fields from form
$x_mag_name = @$_POST["x_mag_name"];
$x_step001 = @$_POST["x_step001"];
$x_step002 = @$_POST["x_step002"];
$x_step003 = @$_POST["x_step003"];
$x_step004 = @$_POST["x_step004"];
$x_step005 = @$_POST["x_step005"];
$x_step006 = @$_POST["x_step006"];
$x_step007 = @$_POST["x_step007"];
$x_step008 = @$_POST["x_step008"];
$x_step009 = @$_POST["x_step009"];
$x_step010 = @$_POST["x_step010"];
$x_step011 = @$_POST["x_step011"];
$x_step012 = @$_POST["x_step012"];
$x_step013 = @$_POST["x_step013"];
$x_step014 = @$_POST["x_step014"];
$x_step015 = @$_POST["x_step015"];
$x_step016 = @$_POST["x_step016"];
$x_step017 = @$_POST["x_step017"];
$x_step018 = @$_POST["x_step018"];
$x_step019 = @$_POST["x_step019"];
$x_step020 = @$_POST["x_step020"];
$x_step021 = @$_POST["x_step021"];
$x_step022 = @$_POST["x_step022"];
$x_step023 = @$_POST["x_step023"];
$x_step024 = @$_POST["x_step024"];
$x_step025 = @$_POST["x_step025"];
$x_step026 = @$_POST["x_step026"];
$x_step027 = @$_POST["x_step027"];
$x_step028 = @$_POST["x_step028"];
$x_step029 = @$_POST["x_step029"];
$x_step030 = @$_POST["x_step030"];
$x_step031 = @$_POST["x_step031"];
$x_step032 = @$_POST["x_step032"];
$x_step033 = @$_POST["x_step033"];
$x_step034 = @$_POST["x_step034"];
$x_step035 = @$_POST["x_step035"];
$x_step036 = @$_POST["x_step036"];
$x_step037 = @$_POST["x_step037"];
$x_step038 = @$_POST["x_step038"];
$x_step039 = @$_POST["x_step039"];
$x_step040 = @$_POST["x_step040"];
$x_step041 = @$_POST["x_step041"];
$x_step042 = @$_POST["x_step042"];
$x_step043 = @$_POST["x_step043"];
$x_step044 = @$_POST["x_step044"];
$x_step045 = @$_POST["x_step045"];
$x_step046 = @$_POST["x_step046"];
$x_step047 = @$_POST["x_step047"];
$x_step048 = @$_POST["x_step048"];
$x_step049 = @$_POST["x_step049"];
$x_step050 = @$_POST["x_step050"];
$x_step051 = @$_POST["x_step051"];
$x_step052 = @$_POST["x_step052"];
$x_step053 = @$_POST["x_step053"];
$x_step054 = @$_POST["x_step054"];
$x_step055 = @$_POST["x_step055"];
$x_step056 = @$_POST["x_step056"];
$x_step057 = @$_POST["x_step057"];
$x_step058 = @$_POST["x_step058"];
$x_step059 = @$_POST["x_step059"];
$x_step060 = @$_POST["x_step060"];
$x_step061 = @$_POST["x_step061"];
$x_step062 = @$_POST["x_step062"];
$x_step063 = @$_POST["x_step063"];
$x_step064 = @$_POST["x_step064"];
$x_step065 = @$_POST["x_step065"];
$x_step066 = @$_POST["x_step066"];
$x_step067 = @$_POST["x_step067"];
$x_step068 = @$_POST["x_step068"];
$x_step069 = @$_POST["x_step069"];
$x_step070 = @$_POST["x_step070"];
$x_step071 = @$_POST["x_step071"];
$x_step072 = @$_POST["x_step072"];
$x_step073 = @$_POST["x_step073"];
$x_step074 = @$_POST["x_step074"];
$x_step075 = @$_POST["x_step075"];
$x_step076 = @$_POST["x_step076"];
$x_step077 = @$_POST["x_step077"];
$x_step078 = @$_POST["x_step078"];
$x_step079 = @$_POST["x_step079"];
$x_step080 = @$_POST["x_step080"];
$x_step081 = @$_POST["x_step081"];
$x_step082 = @$_POST["x_step082"];
$x_step083 = @$_POST["x_step083"];
$x_step084 = @$_POST["x_step084"];
$x_step085 = @$_POST["x_step085"];
$x_step086 = @$_POST["x_step086"];
$x_step087 = @$_POST["x_step087"];
$x_step088 = @$_POST["x_step088"];
$x_step089 = @$_POST["x_step089"];
$x_step090 = @$_POST["x_step090"];
$x_step091 = @$_POST["x_step091"];
$x_step092 = @$_POST["x_step092"];
$x_step093 = @$_POST["x_step093"];
$x_step094 = @$_POST["x_step094"];
$x_step095 = @$_POST["x_step095"];
$x_step096 = @$_POST["x_step096"];
$x_step097 = @$_POST["x_step097"];
$x_step098 = @$_POST["x_step098"];
$x_step099 = @$_POST["x_step099"];
$x_step100 = @$_POST["x_step100"];
$x_step101 = @$_POST["x_step101"];
}
$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
switch ($sAction) {
case "C": // Copy record
if (!LoadData($conn)) { // Load record
$_SESSION[ewSessionMessage] = "No Records Found";
phpmkr_db_close($conn);
ob_end_clean();
header("Location: ../MyProfile.php");
exit();
}
break;
case "A": // Add
if (AddData($conn)) { // Add new record
$_SESSION[ewSessionMessage] = "Magician Epic Checklist Added to My Profile";
phpmkr_db_close($conn);
ob_end_clean();
header("Location: ../MyProfile.php");
exit();
}
break;
}
?>
<?php include ("../sources/header_lists.php") ?>
<script type="text/javascript">
<!--
EW_LookupFn = "../ewlookup.php"; // ewlookup file name
EW_AddOptFn = "../ewaddopt.php"; // ewaddopt.php file name
//-->
</script>
<script type="text/javascript" src="../ewp.js"></script>
<script type="text/javascript">
$(document).ready(function(){
function visibleCheck() {
var $this = $(this);
var ul = $this.siblings("ul");
if ($this.is(":checked"))
ul.hide("normal");
else
ul.show("normal");
}
$(":checkbox")
.click(visibleCheck)
.each(visibleCheck);
});
</script>
<p> </p>
<form name="fchklist_magadd" id="fchklist_magadd" action="chklist_magadd.php" method="post">
<input type="hidden" name="a_add" value="A" />
<?php
if (@$_SESSION[ewSessionMessage] <> "") {
?>
<p><div class="ewmsg"><?php echo $_SESSION[ewSessionMessage]; ?></div></p>
<?php
$_SESSION[ewSessionMessage] = ""; // Clear message
}
?>
<span class="chktitle">Magician Epic Checklist</span>
<?php $x_mag_name = stripslashes($_SESSION[ewSessionUserName]); ?>
<input type="hidden" id="x_mag_name" name="x_mag_name" value="<?php echo @$x_mag_name; ?>" />
<ul>
<li><input type="checkbox" name="x_step001" value="Y"<?php if ($x_step001 == "Y") { ?> checked<?php } ?> /> Pre-Quest 1.5
<ul>
<li><input type="checkbox" name="x_step002" value="Y"<?php if ($x_step002 == "Y") { ?> checked<?php } ?> />
Part 1
<ul>
<li><input type="checkbox" name="x_step003" value="Y"<?php if ($x_step003 == "Y") { ?> checked<?php } ?> />
Talk to Bantil Io`Tuv (Loc?? Plane of Knowledge)
<ul>
<li><input type="checkbox" name="x_step004" value="Y"<?php if ($x_step004 == "Y") { ?> checked<?php } ?> />
Receive Vial of Elemental Binding
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step005" value="Y"<?php if ($x_step005 == "Y") { ?> checked<?php } ?> />
Kill Swirling Monsoon Elemental (Plane of Storms)
<ul>
<li><input type="checkbox" name="x_step006" value="Y"<?php if ($x_step006 == "Y") { ?> checked<?php } ?> />
Loot Captured Monsoon Elemental
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step007" value="Y"<?php if ($x_step007 == "Y") { ?> checked<?php } ?> />
Kill Trembling Earthquake Elemental (The Grey)
<ul>
<li><input type="checkbox" name="x_step008" value="Y"<?php if ($x_step008 == "Y") { ?> checked<?php } ?> />
Loot Captured Earthquake Elemental
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step009" value="Y"<?php if ($x_step009 == "Y") { ?> checked<?php } ?> />
Kill Raging Wildfire Elemental (Shadeweaver's Thicket)
<ul>
<li><input type="checkbox" name="x_step010" value="Y"<?php if ($x_step010 == "Y") { ?> checked<?php } ?> />
Loot Captured Wildfire Elemental
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step011" value="Y"<?php if ($x_step011 == "Y") { ?> checked<?php } ?> />
Kill Ravaging Tsunami Elemental
<ul>
<li><input type="checkbox" name="x_step012" value="Y"<?php if ($x_step012 == "Y") { ?> checked<?php } ?> />
Loot Captured Tsunami Elemental
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step013" value="Y"<?php if ($x_step013 == "Y") { ?> checked<?php } ?> />
Give the 4 captured elementals to Bantil Io`Tuv (Plane of Knowledge)
</li>
</ul>
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step014" value="Y"<?php if ($x_step014 == "Y") { ?> checked<?php } ?> /> 1.5
<ul>
<li><input type="checkbox" name="x_step015" value="Y"<?php if ($x_step015 == "Y") { ?> checked<?php } ?> />
Part 1 - Sentience of Elements
<ul>
<li><input type="checkbox" name="x_step016" value="Y"<?php if ($x_step016 == "Y") { ?> checked<?php } ?> />
Talk to Bantil Io`Tuv (Loc?? Plane of Knowledge)
<ul>
<li><input type="checkbox" name="x_step017" value="Y"<?php if ($x_step017 == "Y") { ?> checked<?php } ?> />
Receive Tattered Note
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step018" value="Y"<?php if ($x_step018 == "Y") { ?> checked<?php } ?> />
Find Danvi's Corpse and /open it (Loc?? Akheva Ruins)
<ul>
<li><input type="checkbox" name="x_step019" value="Y"<?php if ($x_step019 == "Y") { ?> checked<?php } ?> />
Receive Journal of Magus Tvish
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step020" value="Y"<?php if ($x_step020 == "Y") { ?> checked<?php } ?> />
Give Journal of Magus Tvish to Bantil Io`Tuv
</li>
<li><input type="checkbox" name="x_step021" value="Y"<?php if ($x_step021 == "Y") { ?> checked<?php } ?> />
Say "Violet Roses" to a Lost Tomekeeper (Western Wastes)
<ul>
<li><input type="checkbox" name="x_step022" value="Y"<?php if ($x_step022 == "Y") { ?> checked<?php } ?> />
Recieve Tome of Primal Fires
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step023" value="Y"<?php if ($x_step023 == "Y") { ?> checked<?php } ?> />
Give Tome of Primal Fires to Bantil Io`Tuv
</li>
<li><input type="checkbox" name="x_step024" value="Y"<?php if ($x_step024 == "Y") { ?> checked<?php } ?> />
Pick up the Book of Bindings and Incantations (Charasis)
</li>
<li><input type="checkbox" name="x_step025" value="Y"<?php if ($x_step025 == "Y") { ?> checked<?php } ?> />
Kill Grigor Rojha (The Deep)
<ul>
<li><input type="checkbox" name="x_step026" value="Y"<?php if ($x_step026 == "Y") { ?> checked<?php } ?> />
Loot Codex of Ice and Ether
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step027" value="Y"<?php if ($x_step027 == "Y") { ?> checked<?php } ?> />
Give the Book of Bindings and Incantations and the Codex of Ice and Ether to Bantil
</li>
<li><input type="checkbox" name="x_step028" value="Y"<?php if ($x_step028 == "Y") { ?> checked<?php } ?> />
Talk to Jahsohn Aksot (Loc?? The Commonlands)
</li>
<li><input type="checkbox" name="x_step029" value="Y"<?php if ($x_step029 == "Y") { ?> checked<?php } ?> />
Talk to Walnan (Loc?? Butcherblock Mountains)
</li>
<li><input type="checkbox" name="x_step030" value="Y"<?php if ($x_step030 == "Y") { ?> checked<?php } ?> />
Talk to Akksstaff (Loc?? Najena) - Spawns Akksstaff's Minion
<ul>
<li><input type="checkbox" name="x_step031" value="Y"<?php if ($x_step031 == "Y") { ?> checked<?php } ?> />
Kill Akksstaff's Minion
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step032" value="Y"<?php if ($x_step032 == "Y") { ?> checked<?php } ?> />
Talk to Akksstaff (Loc?? Najena)
<ul>
<li><input type="checkbox" name="x_step033" value="Y"<?php if ($x_step033 == "Y") { ?> checked<?php } ?> />
Recieve Sentience of Elements
</li>
</ul>
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step034" value="Y"<?php if ($x_step034 == "Y") { ?> checked<?php } ?> />
Part 2 - The 4 Elemental Essences
<ul>
<li><input type="checkbox" name="x_step035" value="Y"<?php if ($x_step035 == "Y") { ?> checked<?php } ?> />
Give the Sentience of Elements to Bantil
</li>
<li><input type="checkbox" name="x_step036" value="Y"<?php if ($x_step036 == "Y") { ?> checked<?php } ?> />
Talk to Sarhya the Dawnbreeze (Loc?? Plane of Tranquility)
</li>
<li><input type="checkbox" name="x_step037" value="Y"<?php if ($x_step037 == "Y") { ?> checked<?php } ?> />
Kill Elemental Essence of Air
<ul>
<li><input type="checkbox" name="x_step038" value="Y"<?php if ($x_step038 == "Y") { ?> checked<?php } ?> />
Loot Elemental Essence of Air
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step039" value="Y"<?php if ($x_step039 == "Y") { ?> checked<?php } ?> />
Talk to Jurmak the Undertow (Loc?? Plane of Tranquility)
</li>
<li><input type="checkbox" name="x_step040" value="Y"<?php if ($x_step040 == "Y") { ?> checked<?php } ?> />
Talk to High Priest Margle (Loc?? Cobolt Scar)
</li>
<li><input type="checkbox" name="x_step041" value="Y"<?php if ($x_step041 == "Y") { ?> checked<?php } ?> />
Kill Ice Burrowers
<ul>
<li><input type="checkbox" name="x_step042" value="Y"<?php if ($x_step042 == "Y") { ?> checked<?php } ?> />
Loot 4 Ice Burrower Meat
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step043" value="Y"<?php if ($x_step043 == "Y") { ?> checked<?php } ?> />
Give the 4 Ice Burrower Meat(unstacked) to High Priest Margle (Spawns Tiknonmanin)
<ul>
<li><input type="checkbox" name="x_step044" value="Y"<?php if ($x_step044 == "Y") { ?> checked<?php } ?> />
Kill Tiknonmanin
<ul>
<li><input type="checkbox" name="x_step045" value="Y"<?php if ($x_step045 == "Y") { ?> checked<?php } ?> />
Loot Elemental Essence of Water
</li>
</ul>
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step046" value="Y"<?php if ($x_step046 == "Y") { ?> checked<?php } ?> />
Talk to Miak the Searedsoul (Loc?? Plane of Tranquility)
</li>
<li><input type="checkbox" name="x_step047" value="Y"<?php if ($x_step047 == "Y") { ?> checked<?php } ?> />
Talk to Gnaap Guinders (Loc?? Plane of Tactics)
<ul>
<li><input type="checkbox" name="x_step048" value="Y"<?php if ($x_step048 == "Y") { ?> checked<?php } ?> />
Receive a Note from Gnapp
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step049" value="Y"<?php if ($x_step049 == "Y") { ?> checked<?php } ?> />
Kill a Diaku Warrior (Plane of Tactics)
<ul>
<li><input type="checkbox" name="x_step050" value="Y"<?php if ($x_step050 == "Y") { ?> checked<?php } ?> />
Loot a Diaku Forged Maul
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step051" value="Y"<?php if ($x_step051 == "Y") { ?> checked<?php } ?> />
Give Note from Gnaapp and the Diaku War Maul to Bor Warhammer (Loc?? Plane of Tranquility)
<ul>
<li><input type="checkbox" name="x_step052" value="Y"<?php if ($x_step052 == "Y") { ?> checked<?php } ?> />
Recieve a Reinforced Flask
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step053" value="Y"<?php if ($x_step053 == "Y") { ?> checked<?php } ?> />
Kill any Crystalline Monster (Plane of Valor)
<ul>
<li><input type="checkbox" name="x_step054" value="Y"<?php if ($x_step054 == "Y") { ?> checked<?php } ?> />
Loot a Metallic Liquid (Rare Drop)
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step055" value="Y"<?php if ($x_step055 == "Y") { ?> checked<?php } ?> />
Kill any Frog (Plane of Storms)
<ul>
<li><input type="checkbox" name="x_step056" value="Y"<?php if ($x_step056 == "Y") { ?> checked<?php } ?> />
Loot a Hydrolyzed Ether
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step057" value="Y"<?php if ($x_step057 == "Y") { ?> checked<?php } ?> />
Kill Corrupted Turepta (Ferubi)
<ul>
<li><input type="checkbox" name="x_step058" value="Y"<?php if ($x_step058 == "Y") { ?> checked<?php } ?> />
Loot a Heavey Water
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step059" value="Y"<?php if ($x_step059 == "Y") { ?> checked<?php } ?> />
Combine in a Brew Barrel: Reinforced Flask + Heavy Water + Metallic Liquid + Hydrolyzed Ether
<ul>
<li><input type="checkbox" name="x_step060" value="Y"<?php if ($x_step060 == "Y") { ?> checked<?php } ?> />
Receive Corrosive Solution
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step061" value="Y"<?php if ($x_step061 == "Y") { ?> checked<?php } ?> />
Give Corrosive Solution to Gnaapp (Plane of Tactics - Spawns Elemental Essence of Fire)
<ul>
<li><input type="checkbox" name="x_step062" value="Y"<?php if ($x_step062 == "Y") { ?> checked<?php } ?> />
Kill Elemental Essence of Fire
<ul>
<li><input type="checkbox" name="x_step063" value="Y"<?php if ($x_step063 == "Y") { ?> checked<?php } ?> />
Loot Elemental Essence of Fire
</li>
</ul>
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step064" value="Y"<?php if ($x_step064 == "Y") { ?> checked<?php } ?> />
Talk to Taq`aal Emeraldshard (Plane of Tranquility)
</li>
<li><input type="checkbox" name="x_step065" value="Y"<?php if ($x_step065 == "Y") { ?> checked<?php } ?> />
Kill Elemental Essence of Earth
<ul>
<li><input type="checkbox" name="x_step066" value="Y"<?php if ($x_step066 == "Y") { ?> checked<?php } ?> />
Loot Elemental Essence of Earth
</li>
</ul>
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step067" value="Y"<?php if ($x_step067 == "Y") { ?> checked<?php } ?> />
Part 3 - Staff of Elemental Essence
<ul>
<li><input type="checkbox" name="x_step068" value="Y"<?php if ($x_step068 == "Y") { ?> checked<?php } ?> />
Give Elemental Essence of: Earth, Air, Fire, Water to Bantil Io`Tuv (Plane of Knowledge)
<ul>
<li><input type="checkbox" name="x_step069" value="Y"<?php if ($x_step069 == "Y") { ?> checked<?php } ?> />
Receive Staff of Elemental Essence (1.5)
</li>
</ul>
</li>
</ul>
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step070" value="Y"<?php if ($x_step070 == "Y") { ?> checked<?php } ?> />2.0
<ul>
<li><input type="checkbox" name="x_step071" value="Y"<?php if ($x_step071 == "Y") { ?> checked<?php } ?> />
Part 1 - A Pouch Full of Essence
<ul>
<li><input type="checkbox" name="x_step072" value="Y"<?php if ($x_step072 == "Y") { ?> checked<?php } ?> />
Talk to Iilivina (Loc?? Dranik's Scar)
</li>
<li><input type="checkbox" name="x_step073" value="Y"<?php if ($x_step073 == "Y") { ?> checked<?php } ?> />
Collect 4 Essences (Riftseekers' Sanctum)
<ul>
<li><input type="checkbox" name="x_step074" value="Y"<?php if ($x_step074 == "Y") { ?> checked<?php } ?> />
Pyrilen Essences x2
</li>
<li><input type="checkbox" name="x_step075" value="Y"<?php if ($x_step075 == "Y") { ?> checked<?php } ?> />
Gelidran Essences x2
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step076" value="Y"<?php if ($x_step076 == "Y") { ?> checked<?php } ?> />
Give the 4 essences to Iilivina (Dranik's Scar)
<ul>
<li><input type="checkbox" name="x_step077" value="Y"<?php if ($x_step077 == "Y") { ?> checked<?php } ?> />
Receive Pouch of Powdered Riftseeker Essence and Note from Iilivina
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step078" value="Y"<?php if ($x_step078 == "Y") { ?> checked<?php } ?> />
Hand Pouch and Note to Bantil Io`Tuv (Loc?? Plane of Knowledge)
<ul>
<li><input type="checkbox" name="x_step079" value="Y"<?php if ($x_step079 == "Y") { ?> checked<?php } ?> />
Recieve Small Pouch of Riftseeker Essence
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step080" value="Y"<?php if ($x_step080 == "Y") { ?> checked<?php } ?> />
Hand pouch to Vornol Transon (Loc?? Twilight Sea)
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step081" value="Y"<?php if ($x_step081 == "Y") { ?> checked<?php } ?> />
Part 2 - The 4 Elements
<ul>
<li><input type="checkbox" name="x_step082" value="Y"<?php if ($x_step082 == "Y") { ?> checked<?php } ?> />
Talk to Iilivina (Dranik's Scar)
</li>
<li><input type="checkbox" name="x_step083" value="Y"<?php if ($x_step083 == "Y") { ?> checked<?php } ?> />
Kill Body Elemental (Ferubi)
<ul>
<li><input type="checkbox" name="x_step084" value="Y"<?php if ($x_step084 == "Y") { ?> checked<?php } ?> />
Loot Element of Body
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step085" value="Y"<?php if ($x_step085 == "Y") { ?> checked<?php } ?> />
Kill Chaos Elemental (Dreadlands)
<ul>
<li><input type="checkbox" name="x_step086" value="Y"<?php if ($x_step086 == "Y") { ?> checked<?php } ?> />
Loot Element of Chaos
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step087" value="Y"<?php if ($x_step087 == "Y") { ?> checked<?php } ?> />
Kill Spirit Elemental (Crypt of Decay)
<ul>
<li><input type="checkbox" name="x_step088" value="Y"<?php if ($x_step088 == "Y") { ?> checked<?php } ?> />
Loot Element of Spirit
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step089" value="Y"<?php if ($x_step089 == "Y") { ?> checked<?php } ?> />
Kill Order Elemental (Halls of Honor)
<ul>
<li><input type="checkbox" name="x_step090" value="Y"<?php if ($x_step090 == "Y") { ?> checked<?php } ?> />
Loot Element of Order
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step091" value="Y"<?php if ($x_step091 == "Y") { ?> checked<?php } ?> />
Give the 4 elements to Iilivina (Dranik's Scar)
</li>
<li><input type="checkbox" name="x_step092" value="Y"<?php if ($x_step092 == "Y") { ?> checked<?php } ?> />
Globe of Discordant Energy - Drops from 4 mobs in complete clearing of Citidel of Anguish
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step093" value="Y"<?php if ($x_step093 == "Y") { ?> checked<?php } ?> />
Part 3 - Focus of Primal Elements
<ul>
<li><input type="checkbox" name="x_step094" value="Y"<?php if ($x_step094 == "Y") { ?> checked<?php } ?> />
Give Globe + Staff of Elemental Essence to Bantil Io`Tuv (Plane of Knowledge)
<ul>
<li><input type="checkbox" name="x_step095" value="Y"<?php if ($x_step095 == "Y") { ?> checked<?php } ?> />
Receive Focus of Primal Elements (2.0)
</li>
</ul>
</li>
</ul>
</li>
</ul>
</li>
<li><input type="checkbox" name="x_step096" value="Y"<?php if ($x_step096 == "Y") { ?> checked<?php } ?> />2.5
<ul>
<li><input type="checkbox" name="x_step097" value="Y"<?php if ($x_step097 == "Y") { ?> checked<?php } ?> />
An Epic Augment (Quest - Dreadspire Keep)
<ul>
<li><input type="checkbox" name="x_step098" value="Y"<?php if ($x_step098 == "Y") { ?> checked<?php } ?> />
Kill ??
<ul>
<li><input type="checkbox" name="x_step099" value="Y"<?php if ($x_step099 == "Y") { ?> checked<?php } ?> />
Loot??</li>
</ul>
</li>
<li><input type="checkbox" name="x_step100" value="Y"<?php if ($x_step100 == "Y") { ?> checked<?php } ?> />
Turn in ?? to Eric Von Schnelling (Loc?? Zone??)
<ul>
<li><input type="checkbox" name="x_step101" value="Y"<?php if ($x_step101 == "Y") { ?> checked<?php } ?> />
Receive ??</li>
</ul>
</li>
</ul>
</li>
</ul>
</li>
</ul>
<p></p>
<input type="submit" name="btnAction" id="btnAction" value="Add Magician Checklist" class="button" />
</form>
<?php include ("../footer.php") ?>
<?php
phpmkr_db_close($conn);
?>
<?php
//-------------------------------------------------------------------------------
// Function LoadData
// - Variables setup: field variables
function LoadData($conn)
{
global $x_mag_name;
$sFilter = ewSqlKeyWhere;
$x_mag_name = (get_magic_quotes_gpc()) ? stripslashes($x_mag_name) : $x_mag_name;
$sFilter = str_replace("@mag_name", AdjustSql($x_mag_name), $sFilter); // Replace key value
if ((CurrentUserID() <> "-1") && (CurrentUserID() <> "")) {
//$sFilter .= " AND " . str_replace("#UserID", AdjustSql(CurrentuserID()), ewSqlUserIDFilter);
$sFilter .= " AND " . ewSqlUserIDFilter;
$sFilter = str_replace("#Key", "`mag_name`", $sFilter);
$sFilter = str_replace("#UserID", AdjustSql(CurrentUserID()), $sFilter);
}
$sSql = ewBuildSql(ewSqlSelect, ewSqlWhere, ewSqlGroupBy, ewSqlHaving, ewSqlOrderBy, $sFilter, "");
$rs = phpmkr_query($sSql,$conn) or die("Failed to execute query at line " . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL: ' . $sSql);
if (phpmkr_num_rows($rs) == 0) {
$bLoadData = false;
} else {
$bLoadData = true;
$row = phpmkr_fetch_array($rs);
// Get the field contents
$GLOBALS["x_mag_name"] = $row["mag_name"];
$GLOBALS["x_step001"] = $row["step001"];
$GLOBALS["x_step002"] = $row["step002"];
$GLOBALS["x_step003"] = $row["step003"];
$GLOBALS["x_step004"] = $row["step004"];
$GLOBALS["x_step005"] = $row["step005"];
$GLOBALS["x_step006"] = $row["step006"];
$GLOBALS["x_step007"] = $row["step007"];
$GLOBALS["x_step008"] = $row["step008"];
$GLOBALS["x_step009"] = $row["step009"];
$GLOBALS["x_step010"] = $row["step010"];
$GLOBALS["x_step011"] = $row["step011"];
$GLOBALS["x_step012"] = $row["step012"];
$GLOBALS["x_step013"] = $row["step013"];
$GLOBALS["x_step014"] = $row["step014"];
$GLOBALS["x_step015"] = $row["step015"];
$GLOBALS["x_step016"] = $row["step016"];
$GLOBALS["x_step017"] = $row["step017"];
$GLOBALS["x_step018"] = $row["step018"];
$GLOBALS["x_step019"] = $row["step019"];
$GLOBALS["x_step020"] = $row["step020"];
$GLOBALS["x_step021"] = $row["step021"];
$GLOBALS["x_step022"] = $row["step022"];
$GLOBALS["x_step023"] = $row["step023"];
$GLOBALS["x_step024"] = $row["step024"];
$GLOBALS["x_step025"] = $row["step025"];
$GLOBALS["x_step026"] = $row["step026"];
$GLOBALS["x_step027"] = $row["step027"];
$GLOBALS["x_step028"] = $row["step028"];
$GLOBALS["x_step029"] = $row["step029"];
$GLOBALS["x_step030"] = $row["step030"];
$GLOBALS["x_step031"] = $row["step031"];
$GLOBALS["x_step032"] = $row["step032"];
$GLOBALS["x_step033"] = $row["step033"];
$GLOBALS["x_step034"] = $row["step034"];
$GLOBALS["x_step035"] = $row["step035"];
$GLOBALS["x_step036"] = $row["step036"];
$GLOBALS["x_step037"] = $row["step037"];
$GLOBALS["x_step038"] = $row["step038"];
$GLOBALS["x_step039"] = $row["step039"];
$GLOBALS["x_step040"] = $row["step040"];
$GLOBALS["x_step041"] = $row["step041"];
$GLOBALS["x_step042"] = $row["step042"];
$GLOBALS["x_step043"] = $row["step043"];
$GLOBALS["x_step044"] = $row["step044"];
$GLOBALS["x_step045"] = $row["step045"];
$GLOBALS["x_step046"] = $row["step046"];
$GLOBALS["x_step047"] = $row["step047"];
$GLOBALS["x_step048"] = $row["step048"];
$GLOBALS["x_step049"] = $row["step049"];
$GLOBALS["x_step050"] = $row["step050"];
$GLOBALS["x_step051"] = $row["step051"];
$GLOBALS["x_step052"] = $row["step052"];
$GLOBALS["x_step053"] = $row["step053"];
$GLOBALS["x_step054"] = $row["step054"];
$GLOBALS["x_step055"] = $row["step055"];
$GLOBALS["x_step056"] = $row["step056"];
$GLOBALS["x_step057"] = $row["step057"];
$GLOBALS["x_step058"] = $row["step058"];
$GLOBALS["x_step059"] = $row["step059"];
$GLOBALS["x_step060"] = $row["step060"];
$GLOBALS["x_step061"] = $row["step061"];
$GLOBALS["x_step062"] = $row["step062"];
$GLOBALS["x_step063"] = $row["step063"];
$GLOBALS["x_step064"] = $row["step064"];
$GLOBALS["x_step065"] = $row["step065"];
$GLOBALS["x_step066"] = $row["step066"];
$GLOBALS["x_step067"] = $row["step067"];
$GLOBALS["x_step068"] = $row["step068"];
$GLOBALS["x_step069"] = $row["step069"];
$GLOBALS["x_step070"] = $row["step070"];
$GLOBALS["x_step071"] = $row["step071"];
$GLOBALS["x_step072"] = $row["step072"];
$GLOBALS["x_step073"] = $row["step073"];
$GLOBALS["x_step074"] = $row["step074"];
$GLOBALS["x_step075"] = $row["step075"];
$GLOBALS["x_step076"] = $row["step076"];
$GLOBALS["x_step077"] = $row["step077"];
$GLOBALS["x_step078"] = $row["step078"];
$GLOBALS["x_step079"] = $row["step079"];
$GLOBALS["x_step080"] = $row["step080"];
$GLOBALS["x_step081"] = $row["step081"];
$GLOBALS["x_step082"] = $row["step082"];
$GLOBALS["x_step083"] = $row["step083"];
$GLOBALS["x_step084"] = $row["step084"];
$GLOBALS["x_step085"] = $row["step085"];
$GLOBALS["x_step086"] = $row["step086"];
$GLOBALS["x_step087"] = $row["step087"];
$GLOBALS["x_step088"] = $row["step088"];
$GLOBALS["x_step089"] = $row["step089"];
$GLOBALS["x_step090"] = $row["step090"];
$GLOBALS["x_step091"] = $row["step091"];
$GLOBALS["x_step092"] = $row["step092"];
$GLOBALS["x_step093"] = $row["step093"];
$GLOBALS["x_step094"] = $row["step094"];
$GLOBALS["x_step095"] = $row["step095"];
$GLOBALS["x_step096"] = $row["step096"];
$GLOBALS["x_step097"] = $row["step097"];
$GLOBALS["x_step098"] = $row["step098"];
$GLOBALS["x_step099"] = $row["step099"];
$GLOBALS["x_step100"] = $row["step100"];
$GLOBALS["x_step101"] = $row["step101"];
}
phpmkr_free_result($rs);
return $bLoadData;
}
?>
<?php
//-------------------------------------------------------------------------------
// Function AddData
// - Add Data
// - Variables used: field variables
function AddData($conn)
{
global $x_mag_name;
$sFilter = ewSqlKeyWhere;
// Check for duplicate key
$bCheckKey = true;
if ((@$x_mag_name == "") || (is_null(@$x_mag_name))) {
$bCheckKey = false;
} else {
$sFilter = str_replace("@mag_name", AdjustSql($x_mag_name), $sFilter); // Replace key value
}
if ($bCheckKey) {
$sSqlChk = ewBuildSql(ewSqlSelect, ewSqlWhere, ewSqlGroupBy, ewSqlHaving, ewSqlOrderBy, $sFilter, "");
$rsChk = phpmkr_query($sSqlChk, $conn) or die("Failed to execute query at line " . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL: ' . $sSqlChk);
if (phpmkr_num_rows($rsChk) > 0) {
$_SESSION[ewSessionMessage] = "You Already Have a Magician Epic Checklist";
phpmkr_free_result($rsChk);
return false;
}
phpmkr_free_result($rsChk);
}
// Field mag_name
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_mag_name"]) : $GLOBALS["x_mag_name"];
$theValue = ($theValue != "") ? " '" . $theValue . "'" : "NULL";
$fieldList["`mag_name`"] = $theValue;
// Field step001
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step001"]) : $GLOBALS["x_step001"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step001`"] = $theValue;
// Field step002
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step002"]) : $GLOBALS["x_step002"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step002`"] = $theValue;
// Field step003
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step003"]) : $GLOBALS["x_step003"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step003`"] = $theValue;
// Field step004
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step004"]) : $GLOBALS["x_step004"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step004`"] = $theValue;
// Field step005
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step005"]) : $GLOBALS["x_step005"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step005`"] = $theValue;
// Field step006
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step006"]) : $GLOBALS["x_step006"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step006`"] = $theValue;
// Field step007
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step007"]) : $GLOBALS["x_step007"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step007`"] = $theValue;
// Field step008
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step008"]) : $GLOBALS["x_step008"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step008`"] = $theValue;
// Field step009
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step009"]) : $GLOBALS["x_step009"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step009`"] = $theValue;
// Field step010
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step010"]) : $GLOBALS["x_step010"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step010`"] = $theValue;
// Field step011
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step011"]) : $GLOBALS["x_step011"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step011`"] = $theValue;
// Field step012
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step012"]) : $GLOBALS["x_step012"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step012`"] = $theValue;
// Field step013
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step013"]) : $GLOBALS["x_step013"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step013`"] = $theValue;
// Field step014
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step014"]) : $GLOBALS["x_step014"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step014`"] = $theValue;
// Field step015
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step015"]) : $GLOBALS["x_step015"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step015`"] = $theValue;
// Field step016
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step016"]) : $GLOBALS["x_step016"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step016`"] = $theValue;
// Field step017
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step017"]) : $GLOBALS["x_step017"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step017`"] = $theValue;
// Field step018
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step018"]) : $GLOBALS["x_step018"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step018`"] = $theValue;
// Field step019
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step019"]) : $GLOBALS["x_step019"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step019`"] = $theValue;
// Field step020
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step020"]) : $GLOBALS["x_step020"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step020`"] = $theValue;
// Field step021
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step021"]) : $GLOBALS["x_step021"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step021`"] = $theValue;
// Field step022
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step022"]) : $GLOBALS["x_step022"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step022`"] = $theValue;
// Field step023
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step023"]) : $GLOBALS["x_step023"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step023`"] = $theValue;
// Field step024
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step024"]) : $GLOBALS["x_step024"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step024`"] = $theValue;
// Field step025
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step025"]) : $GLOBALS["x_step025"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step025`"] = $theValue;
// Field step026
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step026"]) : $GLOBALS["x_step026"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step026`"] = $theValue;
// Field step027
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step027"]) : $GLOBALS["x_step027"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step027`"] = $theValue;
// Field step028
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step028"]) : $GLOBALS["x_step028"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step028`"] = $theValue;
// Field step029
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step029"]) : $GLOBALS["x_step029"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step029`"] = $theValue;
// Field step030
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step030"]) : $GLOBALS["x_step030"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step030`"] = $theValue;
// Field step031
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step031"]) : $GLOBALS["x_step031"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step031`"] = $theValue;
// Field step032
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step032"]) : $GLOBALS["x_step032"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step032`"] = $theValue;
// Field step033
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step033"]) : $GLOBALS["x_step033"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step033`"] = $theValue;
// Field step034
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step034"]) : $GLOBALS["x_step034"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step034`"] = $theValue;
// Field step035
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step035"]) : $GLOBALS["x_step035"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step035`"] = $theValue;
// Field step036
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step036"]) : $GLOBALS["x_step036"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step036`"] = $theValue;
// Field step037
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step037"]) : $GLOBALS["x_step037"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step037`"] = $theValue;
// Field step038
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step038"]) : $GLOBALS["x_step038"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step038`"] = $theValue;
// Field step039
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step039"]) : $GLOBALS["x_step039"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step039`"] = $theValue;
// Field step040
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step040"]) : $GLOBALS["x_step040"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step040`"] = $theValue;
// Field step041
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step041"]) : $GLOBALS["x_step041"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step041`"] = $theValue;
// Field step042
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step042"]) : $GLOBALS["x_step042"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step042`"] = $theValue;
// Field step043
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step043"]) : $GLOBALS["x_step043"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step043`"] = $theValue;
// Field step044
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step044"]) : $GLOBALS["x_step044"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step044`"] = $theValue;
// Field step045
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step045"]) : $GLOBALS["x_step045"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step045`"] = $theValue;
// Field step046
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step046"]) : $GLOBALS["x_step046"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step046`"] = $theValue;
// Field step047
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step047"]) : $GLOBALS["x_step047"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step047`"] = $theValue;
// Field step048
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step048"]) : $GLOBALS["x_step048"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step048`"] = $theValue;
// Field step049
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step049"]) : $GLOBALS["x_step049"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step049`"] = $theValue;
// Field step050
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step050"]) : $GLOBALS["x_step050"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step050`"] = $theValue;
// Field step051
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step051"]) : $GLOBALS["x_step051"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step051`"] = $theValue;
// Field step052
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step052"]) : $GLOBALS["x_step052"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step052`"] = $theValue;
// Field step053
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step053"]) : $GLOBALS["x_step053"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step053`"] = $theValue;
// Field step054
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step054"]) : $GLOBALS["x_step054"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step054`"] = $theValue;
// Field step055
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step055"]) : $GLOBALS["x_step055"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step055`"] = $theValue;
// Field step056
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step056"]) : $GLOBALS["x_step056"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step056`"] = $theValue;
// Field step057
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step057"]) : $GLOBALS["x_step057"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step057`"] = $theValue;
// Field step058
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step058"]) : $GLOBALS["x_step058"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step058`"] = $theValue;
// Field step059
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step059"]) : $GLOBALS["x_step059"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step059`"] = $theValue;
// Field step060
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step060"]) : $GLOBALS["x_step060"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step060`"] = $theValue;
// Field step061
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step061"]) : $GLOBALS["x_step061"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step061`"] = $theValue;
// Field step062
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step062"]) : $GLOBALS["x_step062"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step062`"] = $theValue;
// Field step063
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step063"]) : $GLOBALS["x_step063"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step063`"] = $theValue;
// Field step064
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step064"]) : $GLOBALS["x_step064"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step064`"] = $theValue;
// Field step065
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step065"]) : $GLOBALS["x_step065"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step065`"] = $theValue;
// Field step066
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step066"]) : $GLOBALS["x_step066"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step066`"] = $theValue;
// Field step067
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step067"]) : $GLOBALS["x_step067"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step067`"] = $theValue;
// Field step068
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step068"]) : $GLOBALS["x_step068"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step068`"] = $theValue;
// Field step069
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step069"]) : $GLOBALS["x_step069"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step069`"] = $theValue;
// Field step070
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step070"]) : $GLOBALS["x_step070"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step070`"] = $theValue;
// Field step071
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step071"]) : $GLOBALS["x_step071"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step071`"] = $theValue;
// Field step072
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step072"]) : $GLOBALS["x_step072"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step072`"] = $theValue;
// Field step073
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step073"]) : $GLOBALS["x_step073"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step073`"] = $theValue;
// Field step074
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step074"]) : $GLOBALS["x_step074"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step074`"] = $theValue;
// Field step075
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step075"]) : $GLOBALS["x_step075"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step075`"] = $theValue;
// Field step076
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step076"]) : $GLOBALS["x_step076"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step076`"] = $theValue;
// Field step077
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step077"]) : $GLOBALS["x_step077"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step077`"] = $theValue;
// Field step078
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step078"]) : $GLOBALS["x_step078"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step078`"] = $theValue;
// Field step079
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step079"]) : $GLOBALS["x_step079"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step079`"] = $theValue;
// Field step080
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step080"]) : $GLOBALS["x_step080"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step080`"] = $theValue;
// Field step081
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step081"]) : $GLOBALS["x_step081"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step081`"] = $theValue;
// Field step082
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step082"]) : $GLOBALS["x_step082"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step082`"] = $theValue;
// Field step083
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step083"]) : $GLOBALS["x_step083"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step083`"] = $theValue;
// Field step084
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step084"]) : $GLOBALS["x_step084"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step084`"] = $theValue;
// Field step085
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step085"]) : $GLOBALS["x_step085"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step085`"] = $theValue;
// Field step086
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step086"]) : $GLOBALS["x_step086"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step086`"] = $theValue;
// Field step087
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step087"]) : $GLOBALS["x_step087"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step087`"] = $theValue;
// Field step088
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step088"]) : $GLOBALS["x_step088"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step088`"] = $theValue;
// Field step089
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step089"]) : $GLOBALS["x_step089"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step089`"] = $theValue;
// Field step090
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step090"]) : $GLOBALS["x_step090"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step090`"] = $theValue;
// Field step091
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step091"]) : $GLOBALS["x_step091"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step091`"] = $theValue;
// Field step092
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step092"]) : $GLOBALS["x_step092"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step092`"] = $theValue;
// Field step093
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step093"]) : $GLOBALS["x_step093"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step093`"] = $theValue;
// Field step094
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step094"]) : $GLOBALS["x_step094"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step094`"] = $theValue;
// Field step095
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step095"]) : $GLOBALS["x_step095"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step095`"] = $theValue;
// Field step096
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step096"]) : $GLOBALS["x_step096"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step096`"] = $theValue;
// Field step097
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step097"]) : $GLOBALS["x_step097"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step097`"] = $theValue;
// Field step098
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step098"]) : $GLOBALS["x_step098"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step098`"] = $theValue;
// Field step099
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step099"]) : $GLOBALS["x_step099"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step099`"] = $theValue;
// Field step100
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step100"]) : $GLOBALS["x_step100"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step100`"] = $theValue;
// Field step101
$theValue = (!get_magic_quotes_gpc()) ? addslashes($GLOBALS["x_step101"]) : $GLOBALS["x_step101"];
$theValue = (strtoupper($theValue) != "Y") ? " 'N'" : " 'Y'";
$fieldList["`step101`"] = $theValue;
// Inserting event
if (Recordset_Inserting($fieldList)) {
// Insert
$sSql = "INSERT INTO `chklist_mag` (";
$sSql .= implode(",", array_keys($fieldList));
$sSql .= ") VALUES (";
$sSql .= implode(",", array_values($fieldList));
$sSql .= ")";
phpmkr_query($sSql, $conn) or die("Failed to execute query at line " . __LINE__ . ": " . phpmkr_error($conn) . '<br>SQL: ' . $sSql);
$result = (phpmkr_affected_rows($conn) > 0);
// Inserted event
if ($result) Recordset_Inserted($fieldList);
} else {
$result = false;
}
return $result;
}
// Inserting event
function Recordset_Inserting(&$newrs)
{
// Enter your customized codes here
return true;
}
// Inserted event
function Recordset_Inserted($newrs)
{
$table = "chklist_mag";
}
?>