<div class='' align='center'>
<h1>Stats for Eden</h1>
</div>
<form class='' name='test' method='post' action='".FUSION_SELF."' enctype='multipart/form-data''
target='_self'><br>
<div class='' align='center'> <label for='availability' class=''>Select
Available Times<span class='tooltip' tooltip='Check the times your available for battle'>
</span></label>'
<ul id='availability'>
<li><input name='reset' value='yes' type='checkbox'>Reset</li>
<li><input name='6' value='yes' type='checkbox'>+6</li>
<li><input name='8' value='yes' type='checkbox'>+8</li>
<li><input name='12' value='yes' type='checkbox'>+12</li>
<li><input name='16' value='yes' type='checkbox'>+16</li>
<li><input name='18' value='yes' type='checkbox'>+18</li>
<li><input name='23' value='yes' type='checkbox'>+23</li>
</ul>
</div>
<div class='' align='center'><label for='footmen' class=''>Footmen<span class='tooltip-element'
tooltip='highest level footmen'> </span></label>
<select class='form' name='footmen' id='footmen' required='required' aria-required='true'>
<option disabled='null' selected='null'>-</option>
<option value='7' id='footmen'>T7</option>
<option value='8' id='footmen'>T8</option>
<option value='9' id='footmen'>T9</option>
<option value='10' id='footmen'>T10</option>
</select>
<label for='archers' class=''>Archers<span class='tooltip' tooltip='highest level archers'></span>
</label>
<select class='form' name='footmen' id='footmen' required='required' aria-required='true'>
<option disabled='null' selected='null'>-</option>
<option value='7' id='archers'>T7</option>
<option value='8' id='archers'>T8</option>
<option value='9' id='archers'>T9</option>
<option value='10' id='archers'>T10</option>
</select>
<label for='archers' class=''>Calvary <span class='tooltip-element' tooltip='highest level calvary'></span>
</label>
<select class='form' name='calvary' id='calvary' required='required' aria-required='true'>
<option disabled='null' selected='null'>-</option>
<option value='7' id='calvary'>T7</option>
<option value='8' id='calvary'>T8</option>
<option value='9' id='calvary'>T9</option>
<option value='10' id='calvary'>T10</option>
</select>
</div>
<div class='' align='center'><br>
</div>
<div class='' align='center'> <label for='loyalty' class=''>Loyalty Level
<span class='tooltip' tooltip='EDEN Loyalty'>
</span></label>
<input placeholder='0' class='form' name='loyalty' value='0' id='number-loyalty' title='eden loyalty level' required='required' form='stat_update' min='0' max='30000' type='number'> </div>
<div class='' align='center'> <input name='submit' form='test' formaction='submit-form-db' formmethod='post' formtarget='_self' type='submit'>
<input name='reset' type='reset'>
</div> </form>
user_loyalty
int(5) UNSIGNED NOT NULL,
user_cavs
int(2) UNSIGNED NOT NULL,
user_foot
int(2) UNSIGNED NOT NULL,
user_archer
int(2) UNSIGNED NOT NULL,
user_reset
varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
user_6
varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
user_8
varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
user_12
varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
user_16
varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
user_18
varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
user_23
varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
<?php
require_once "maincore.php";
require_once "subheader.php";
if (iMEMBER) {
$data = dbarray($result);
$result = dbquery("UPDATE ".$db_prefix."users (user_loyalty, user_cavs, user_foot, user_archer, user_reset, user_6, user_8, user_12, user_16, user_18, user_23")
$loyalty = isset($_POST['user_loyalty']) ? stripinput(trim($_POST['user_loyalty'])) : "";
$cavs = isset($_POST['user_cavs']) ? stripinput(trim($_POST['user_cavs'])) : "";
$foot = isset($_POST['user_foot']) ? stripinput(trim($_POST['user_foot'])) : "";
$archer = isset($_POST['user_archer']) ? stripinput(trim($_POST['user_archer'])) : "";
//availability match check boxes with table
$reset = isset($_POST['user_reset']) ? stripinput(trim($_POST['user_reset'])) : "";
$reset6 = isset($_POST['user_6']) ? stripinput(trim($_POST['user_6'])) : "";
$reset8 = isset($_POST['user_8']) ? stripinput(trim($_POST['user_8'])) : "";
$reset12 = isset($_POST['user_12']) ? stripinput(trim($_POST['user_12'])) : "";
$reset16 = isset($_POST['user_16']) ? stripinput(trim($_POST['user_16'])) : "";
$reset18 = isset($_POST['user_18']) ? stripinput(trim($_POST['user_18'])) : "";
$reset23 = isset($_POST['user_23']) ? stripinput(trim($_POST['user_23'])) : "";
echo "<div class='' align='center'>
<h1>Stats for Eden</h1>
</div>
<form class='' name='test' method='post' action='".FUSION_SELF."' enctype='multipart/form-data''
target='_self'><br>
<div class='' align='center'> <label for='availability' class=''>Select
Available Times<span class='tooltip' tooltip='Check the times your available for battle'>
</span></label>'
<ul id='availability'>
<li><input name='reset' value='yes' type='checkbox'>Reset</li>
<li><input name='6' value='yes' type='checkbox'>+6</li>
<li><input name='8' value='yes' type='checkbox'>+8</li>
<li><input name='12' value='yes' type='checkbox'>+12</li>
<li><input name='16' value='yes' type='checkbox'>+16</li>
<li><input name='18' value='yes' type='checkbox'>+18</li>
<li><input name='23' value='yes' type='checkbox'>+23</li>
</ul>
</div>
<div class='' align='center'><label for='footmen' class=''>Footmen<span class='tooltip-element'
tooltip='highest level footmen'> </span></label>
<select class='form' name='footmen' id='footmen' required='required' aria-required='true'>
<option disabled='null' selected='null'>-</option>
<option value='7' id='footmen'>T7</option>
<option value='8' id='footmen'>T8</option>
<option value='9' id='footmen'>T9</option>
<option value='10' id='footmen'>T10</option>
</select>
<label for='archers' class=''>Archers<span class='tooltip' tooltip='highest level archers'></span>
</label>
<select class='form' name='footmen' id='footmen' required='required' aria-required='true'>
<option disabled='null' selected='null'>-</option>
<option value='7' id='archers'>T7</option>
<option value='8' id='archers'>T8</option>
<option value='9' id='archers'>T9</option>
<option value='10' id='archers'>T10</option>
</select>
<label for='archers' class=''>Calvary <span class='tooltip-element' tooltip='highest level calvary'></span>
</label>
<select class='form' name='calvary' id='calvary' required='required' aria-required='true'>
<option disabled='null' selected='null'>-</option>
<option value='7' id='calvary'>T7</option>
<option value='8' id='calvary'>T8</option>
<option value='9' id='calvary'>T9</option>
<option value='10' id='calvary'>T10</option>
</select>
</div>
<div class='' align='center'><br>
</div>
<div class='' align='center'> <label for='loyalty' class=''>Loyalty Level
<span class='tooltip' tooltip='EDEN Loyalty'>
</span></label>
<input placeholder='0' class='form' name='loyalty' value='0' id='number-loyalty' title='eden loyalty level' required='required' form='stat_update' min='0' max='30000' type='number'> </div>
<div class='' align='center'> <input name='submit' form='test' formaction='submit-form-db' formmethod='post' formtarget='_self' type='submit'>
<input name='reset' type='reset'>
</div> </form>";
} else {
redirect("index.php");
}
require_once "footer.php"
?>
<?php
require_once __DIR__."/maincore.php";
require_once THEMES."templates/header.php";
add_to_title('Eden Form');
if (isset($_POST['submit'] {
$result = dbquery("UPDATE ".$db_prefix."users (user_loyalty, user_cavs, user_foot, user_archer, user_reset, user_6, user_8, user_12, user_16, user_18, user_23")
$data = dbarray($result)
$loyalty = isset($_POST['user_loyalty']) ? stripinput(trim($_POST['user_loyalty'])) : "";
$cavs = isset($_POST['user_cavs']) ? stripinput(trim($_POST['user_cavs'])) : "";
$foot = isset($_POST['user_foot']) ? stripinput(trim($_POST['user_foot'])) : "";
$archer = isset($_POST['user_archer']) ? stripinput(trim($_POST['user_archer'])) : "";
//availability match check boxes with table
$reset = isset($_POST['user_reset']) ? stripinput(trim($_POST['user_reset'])) : "";
$reset6 = isset($_POST['user_6']) ? stripinput(trim($_POST['user_6'])) : "";
$reset8 = isset($_POST['user_8']) ? stripinput(trim($_POST['user_8'])) : "";
$reset12 = isset($_POST['user_12']) ? stripinput(trim($_POST['user_12'])) : "";
$reset16 = isset($_POST['user_16']) ? stripinput(trim($_POST['user_16'])) : "";
$reset18 = isset($_POST['user_18']) ? stripinput(trim($_POST['user_18'])) : "";
$reset23 = isset($_POST['user_23']) ? stripinput(trim($_POST['user_23'])) : "";
echo "<div class='' align='center'>
<h1>Stats for Eden</h1>
</div>
<form class='' name='eden' method='post' action='".FUSION_SELF."' enctype='multipart/form-data''
target='_self'><br>
<div class='' align='center'> <label for='availability' class=''>Select
Available Times<span class='tooltip' tooltip='Check the times your available for battle'>
</span></label>'
<ul id='availability'>
<li><input name='user_reset' value='Yes' type='checkbox'>Reset</li>
<li><input name='user_6' value='Yes' type='checkbox'>+6</li>
<li><input name='user_8' value='Yes' type='checkbox'>+8</li>
<li><input name='user_12' value='Yes' type='checkbox'>+12</li>
<li><input name='user_16' value='Yes' type='checkbox'>+16</li>
<li><input name='user_18' value='Yes' type='checkbox'>+18</li>
<li><input name='user_23' value='Yes' type='checkbox'>+23</li>
</ul>
</div>
<div class='' align='center'><label for='footmen' class=''>Footmen<span class='tooltip-element'
tooltip='highest level footmen'> </span></label>
<select class='form' name='user_foot' id='user_foot' required='required' aria-required='true'>
<option disabled='null' selected='".$user_data['user_foot']."'>-</option>
<option value='7' id='footmen'>T7</option>
<option value='8' id='footmen'>T8</option>
<option value='9' id='footmen'>T9</option>
<option value='10' id='footmen'>T10</option>
</select>
<label for='archers' class=''>Archers<span class='tooltip' tooltip='highest level archers'></span>
</label>
<select class='form' name='user_archer' id='user_archer' required='required' aria-required='true'>
<option disabled='null' selected='".$user_data['user_archer']."'>-</option>
<option value='7' id='archers'>T7</option>
<option value='8' id='archers'>T8</option>
<option value='9' id='archers'>T9</option>
<option value='10' id='archers'>T10</option>
</select>
<label for='archers' class=''>Calvary <span class='tooltip-element' tooltip='highest level calvary'></span>
</label>
<select class='form' name='user_cavs' id='user_cavs' required='required' aria-required='true'>
<option disabled='null' selected='".$user_data['user_cavs']."'>-</option>
<option value='7' id='calvary'>T7</option>
<option value='8' id='calvary'>T8</option>
<option value='9' id='calvary'>T9</option>
<option value='10' id='calvary'>T10</option>
</select>
</div>
<div class='' align='center'><br>
</div>
<div class='' align='center'> <label for='loyalty' class=''>Loyalty Level
<span class='tooltip' tooltip='EDEN Loyalty'>
</span></label>
<input placeholder='0' class='form' name='user_loyalty' value='".$user_data['user_loyalty']."' id='user_loyalty' title='eden loyalty level' required='required' form='eden' min='0' max='30000' type='number'> </div>
<div class='' align='center'> <input name='submit' form='eden' formmethod='post' formtarget='stats.php' type='submit'>
<input name='reset' type='reset'>
</div> </form>";
}
require_once THEMES."templates/footer.php";
?>
<?php
require_once __DIR__."/maincore.php";
require_once THEMES."templates/header.php";
add_to_title('Eden Form');
if (isset($_POST['submit'] {
$result = dbquery("UPDATE ".DB_USERS." (user_loyalty, user_cavs, user_foot, user_archer, user_reset, user_6, user_8, user_12, user_16, user_18, user_23")
$data = dbarray($result)
$loyalty = isset($_POST['user_loyalty']) ? stripinput(trim($_POST['user_loyalty'])) : "";
$cavs = isset($_POST['user_cavs']) ? stripinput(trim($_POST['user_cavs'])) : "";
$foot = isset($_POST['user_foot']) ? stripinput(trim($_POST['user_foot'])) : "";
$archer = isset($_POST['user_archer']) ? stripinput(trim($_POST['user_archer'])) : "";
//availability match check boxes with table
$reset = isset($_POST['user_reset']) ? stripinput(trim($_POST['user_reset'])) : "";
$reset6 = isset($_POST['user_6']) ? stripinput(trim($_POST['user_6'])) : "";
$reset8 = isset($_POST['user_8']) ? stripinput(trim($_POST['user_8'])) : "";
$reset12 = isset($_POST['user_12']) ? stripinput(trim($_POST['user_12'])) : "";
$reset16 = isset($_POST['user_16']) ? stripinput(trim($_POST['user_16'])) : "";
$reset18 = isset($_POST['user_18']) ? stripinput(trim($_POST['user_18'])) : "";
$reset23 = isset($_POST['user_23']) ? stripinput(trim($_POST['user_23'])) : "";
echo"<div class='' align='center'>
<h1>Stats for Eden</h1>
</div>
<form class='' name='eden' method='post' action='".FUSION_SELF."' enctype='multipart/form-data''
target='_self'><br>
<div class='' align='center'> <label for='availability' class=''>Select
Available Times<span class='tooltip' tooltip='Check the times your available for battle'>
</span></label>'
<ul id='availability'>
<li><input name='user_reset' value='Yes' type='checkbox'>Reset
<input name='user_6' value='Yes' type='checkbox'>+6
<input name='user_8' value='Yes' type='checkbox'>+8
<input name='user_12' value='Yes' type='checkbox'>+12</li>
<li><input name='user_16' value='Yes' type='checkbox'>+16
<input name='user_18' value='Yes' type='checkbox'>+18
<input name='user_23' value='Yes' type='checkbox'>+23</li>
</ul>
</div>
<div class='' align='center'><label for='footmen' class=''>Footmen<span class='tooltip-element'
tooltip='highest level footmen'> </span></label>
<select class='form' name='user_foot' id='user_foot' required='required' aria-required='true'>
<option disabled='null' selected='".$user_data['user_foot']."'>-</option>
<option value='7' id='footmen'>T7</option>
<option value='8' id='footmen'>T8</option>
<option value='9' id='footmen'>T9</option>
<option value='10' id='footmen'>T10</option>
</select>
<label for='archers' class=''>Archers<span class='tooltip' tooltip='highest level archers'></span>
</label>
<select class='form' name='user_archer' id='user_archer' required='required' aria-required='true'>
<option disabled='null' selected='".$user_data['user_archer']."'>-</option>
<option value='7' id='archers'>T7</option>
<option value='8' id='archers'>T8</option>
<option value='9' id='archers'>T9</option>
<option value='10' id='archers'>T10</option>
</select>
<label for='archers' class=''>Calvary <span class='tooltip-element' tooltip='highest level calvary'></span>
</label>
<select class='form' name='user_cavs' id='user_cavs' required='required' aria-required='true'>
<option disabled='null' selected='".$user_data['user_cavs']."'>-</option>
<option value='7' id='calvary'>T7</option>
<option value='8' id='calvary'>T8</option>
<option value='9' id='calvary'>T9</option>
<option value='10' id='calvary'>T10</option>
</select>
</div>
<div class='' align='center'><br>
</div>
<div class='' align='center'> <label for='loyalty' class=''>Loyalty Level
<span class='tooltip' tooltip='EDEN Loyalty'>
</span></label>
<input placeholder='0' class='form' name='user_loyalty' value='".$user_data['user_loyalty']."' id='user_loyalty' title='eden loyalty level' required='required' form='eden' min='0' max='30000' type='number'> </div>
<div class='' align='center'>
<input class='button' name='submit' form='eden' formmethod='post' formtarget='_self' type='submit'>
<input name='reset' type='reset'>
</div> </form>";
}
require_once THEMES."templates/footer.php";
?>
<?php
require_once "../../maincore.php";
require_once THEMES."templates/header.php";
add_to_title('Eden Form');
if (isset($_POST['submit'])) {
$loyalty = isset($_POST['user_loyalty']) ? stripinput(trim($_POST['user_loyalty'])) : "";
$cavs = isset($_POST['user_cavs']) ? stripinput(trim($_POST['user_cavs'])) : "";
$foot = isset($_POST['user_foot']) ? stripinput(trim($_POST['user_foot'])) : "";
$archer = isset($_POST['user_archer']) ? stripinput(trim($_POST['user_archer'])) : "";
//availability match check boxes with table
$reset = isset($_POST['user_reset']) ? stripinput(trim($_POST['user_reset'])) : "";
$user_6 = isset($_POST['user_6']) ? stripinput(trim($_POST['user_6'])) : "";
$user_8 = isset($_POST['user_8']) ? stripinput(trim($_POST['user_8'])) : "";
$user_12 = isset($_POST['user_12']) ? stripinput(trim($_POST['user_12'])) : "";
$user_16 = isset($_POST['user_16']) ? stripinput(trim($_POST['user_16'])) : "";
$user_18 = isset($_POST['user_18']) ? stripinput(trim($_POST['user_18'])) : "";
$user_23 = isset($_POST['user_23']) ? stripinput(trim($_POST['user_23'])) : "";
$result = dbquery("UPDATE ".DB_USERS." SET user_loyalty='".$loyalty."', user_cavs='".$cavs."', user_foot='".$foot."', user_archer='".$archer."', user_reset='".$reset."' user_6='".$user_6."', user_8='".$user_8."', user_12='".$user_12."', user_16='".$user_16."', user_18='".$user_18."', user_23='".$user_23."' WHERE user_id='".$userdata['user_id']."'");
redirect(FUSION_SELF);
}
echo "<div class='' align='center'>
<h1>Stats for Eden</h1>
</div>
<form class='' name='eden' method='post' action='".FUSION_SELF."' enctype='multipart/form-data''
target='_self'><br>
<div class='' align='center'> <label for='availability' class=''>Select
Available Times<span class='tooltip' tooltip='Check the times your available for battle'>
</span></label>'
<ul id='availability'>
<li><input name='user_reset' value='Yes' type='checkbox'>Reset</li>
<li><input name='user_6' value='Yes' type='checkbox'>+6</li>
<li><input name='user_8' value='Yes' type='checkbox'>+8</li>
<li><input name='user_12' value='Yes' type='checkbox'>+12</li>
<li><input name='user_16' value='Yes' type='checkbox'>+16</li>
<li><input name='user_18' value='Yes' type='checkbox'>+18</li>
<li><input name='user_23' value='Yes' type='checkbox'>+23</li>
</ul>
</div>
<div class='' align='center'><label for='footmen' class=''>Footmen<span class='tooltip-element'
tooltip='highest level footmen'> </span></label>
<select class='form' name='user_foot' id='user_foot' required='required' aria-required='true'>
<option disabled='null' selected='".$userdata['user_foot']."'>-</option>
<option value='7' id='footmen'>T7</option>
<option value='8' id='footmen'>T8</option>
<option value='9' id='footmen'>T9</option>
<option value='10' id='footmen'>T10</option>
</select>
<label for='archers' class=''>Archers<span class='tooltip' tooltip='highest level archers'></span>
</label>
<select class='form' name='user_archer' id='user_archer' required='required' aria-required='true'>
<option disabled='null' selected='".$userdata['user_archer']."'>-</option>
<option value='7' id='archers'>T7</option>
<option value='8' id='archers'>T8</option>
<option value='9' id='archers'>T9</option>
<option value='10' id='archers'>T10</option>
</select>
<label for='archers' class=''>Calvary <span class='tooltip-element' tooltip='highest level calvary'></span>
</label>
<select class='form' name='user_cavs' id='user_cavs' required='required' aria-required='true'>
<option disabled='null' selected='".$userdata['user_cavs']."'>-</option>
<option value='7' id='calvary'>T7</option>
<option value='8' id='calvary'>T8</option>
<option value='9' id='calvary'>T9</option>
<option value='10' id='calvary'>T10</option>
</select>
</div>
<div class='' align='center'><br>
</div>
<div class='' align='center'> <label for='loyalty' class=''>Loyalty Level
<span class='tooltip' tooltip='EDEN Loyalty'>
</span></label>
<input placeholder='0' class='form' name='user_loyalty' value='".$userdata['user_loyalty']."' id='user_loyalty' title='eden loyalty level' required='required' form='eden' min='0' max='30000' type='number'> </div>
<div class='' align='center'> <input name='submit' form='eden' formmethod='post' formtarget='stats.php' type='submit'>
<input name='reset' type='reset'>
</div> </form>";
require_once THEMES."templates/footer.php";
?>
<?php
require_once "maincore.php";
require_once THEMES."templates/header.php";
add_to_title('Eden Form');
if (isset($_POST['submit'])) {
$loyalty = isset($_POST['user_loyalty']) ? stripinput(trim($_POST['user_loyalty'])) : "";
$cavs = isset($_POST['user_cavs']) ? stripinput(trim($_POST['user_cavs'])) : "";
$foot = isset($_POST['user_foot']) ? stripinput(trim($_POST['user_foot'])) : "";
$archer = isset($_POST['user_archer']) ? stripinput(trim($_POST['user_archer'])) : "";
//availability match check boxes with table
$reset = isset($_POST['user_reset']) ? stripinput(trim($_POST['user_reset'])) : "";
$user_6 = isset($_POST['user_6']) ? stripinput(trim($_POST['user_6'])) : "";
$user_8 = isset($_POST['user_8']) ? stripinput(trim($_POST['user_8'])) : "";
$user_12 = isset($_POST['user_12']) ? stripinput(trim($_POST['user_12'])) : "";
$user_16 = isset($_POST['user_16']) ? stripinput(trim($_POST['user_16'])) : "";
$user_18 = isset($_POST['user_18']) ? stripinput(trim($_POST['user_18'])) : "";
$user_23 = isset($_POST['user_23']) ? stripinput(trim($_POST['user_23'])) : "";
$result = dbquery("UPDATE ".DB_USERS." SET user_loyalty='".$loyalty."', user_cavs='".$cavs."', user_foot='".$foot."', user_archer='".$archer."', user_reset='".$reset."' user_6='".$user_6."', user_8='".$user_8."', user_12='".$user_12."', user_16='".$user_16."', user_18='".$user_18."', user_23='".$user_23."' WHERE user_id='".$userdata['user_id']."'");
redirect(FUSION_SELF);
}
echo "<div class='' align='center'>
<h1>Stats for Eden</h1>
</div>
<form class='' name='eden' method='post' action='".FUSION_SELF."' enctype='multipart/form-data' target='_self'><br>
<div class='' align='center'> <label for='availability' class=''>Select
Available Times<span class='tooltip' tooltip='Check the times your available for battle'>
</span></label>'
<ul id='availability'>
<li><input name='user_reset' value='Yes' type='checkbox'>Reset
<input name='user_6' value='Yes' type='checkbox'>+6
<input name='user_8' value='Yes' type='checkbox'>+8
<input name='user_12' value='Yes' type='checkbox'>+12</li>
<li><input name='user_16' value='Yes' type='checkbox'>+16
<input name='user_18' value='Yes' type='checkbox'>+18
<input name='user_23' value='Yes' type='checkbox'>+23</li>
</ul>
</div>
<div class='' align='center'><label for='footmen' class=''>Footmen<span class='tooltip-element'
tooltip='highest level footmen'> </span></label>
<select class='form' name='user_foot' id='user_foot' required='required' aria-required='true'>
<option value='".$userdata['user_foot']."' id='archers'>".$userdata['user_foot']."</option>
<option value='T7' id='footmen'>T7</option>
<option value='T8' id='footmen'>T8</option>
<option value='T9' id='footmen'>T9</option>
<option value='T10' id='footmen'>T10</option>
</select>
<label for='archers' class=''>Archers<span class='tooltip' tooltip='highest level archers'></span>
</label>
<select class='form' name='user_archer' id='user_archer' required='required' aria-required='true'>
<option value='".$userdata['user_archer']."' id='archers'>".$userdata['user_archer']."</option>
<option value='T7' id='archers'>T7</option>
<option value='T8' id='archers'>T8</option>
<option value='T9' id='archers'>T9</option>
<option value='T10' id='archers'>T10</option>
</select>
<label for='archers' class=''>Calvary <span class='tooltip-element' tooltip='highest level calvary'></span>
</label>
<select class='form' name='user_cavs' id='user_cavs' required='required' aria-required='true'>
<option value='".$userdata['user_cavs']."' id='archers'>".$userdata['user_cavs']."</option>
<option value='T7' id='calvary'>T7</option>
<option value='T8' id='calvary'>T8</option>
<option value='T9' id='calvary'>T9</option>
<option value='T10' id='calvary'>T10</option>
</select>
</div>
<div class='' align='center'><br>
</div>
<div class='' align='center'> <label for='loyalty' class=''>Loyalty Level
<span class='tooltip' tooltip='EDEN Loyalty'>
</span></label>
<input placeholder='0' class='form' name='user_loyalty' value='".$userdata['user_loyalty']."' id='user_loyalty' title='eden loyalty level' required='required' form='eden' min='0' max='30000' type='number'> </div>
<div class='' align='center'>
<input name='submit' form='eden' formmethod='post' formtarget='".FUSION_SELF."' type='submit'>
<input name='reset' type='reset'>
</div> </form>";
require_once THEMES."templates/footer.php";
?>
user_loyalty
int(5) NOT NULL,
user_cavs
text COLLATE utf8mb4_unicode_ci NOT NULL,
user_foot
text COLLATE utf8mb4_unicode_ci NOT NULL,
user_archer
text COLLATE utf8mb4_unicode_ci NOT NULL,
user_reset
int(1) NOT NULL DEFAULT 0,
user_6
int(1) NOT NULL DEFAULT 0,
user_8
int(1) NOT NULL DEFAULT 0,
user_12
int(1) NOT NULL DEFAULT 0,
user_16
int(1) NOT NULL DEFAULT 0,
user_18
int(1) NOT NULL DEFAULT 0,
user_23
int(1) NOT NULL DEFAULT 0
if (isset($_POST['loyalty_save'])) {
$loyalty = isset($_POST['user_loyalty']) && isnum($_POST['user_loyalty']) ? $_POST['user_loyalty'] : 0;
$cavs = isset($_POST['user_cavs']) && stripinput($_POST['user_cavs']) ? $_POST['user_cavs'] : 0;
$foot = isset($_POST['user_foot']) && stripinput($_POST['user_foot']) ? $_POST['user_foot'] : 0;
$archer = isset($_POST['user_archer']) && stripinput($_POST['user_archer']) ? $_POST['user_archer'] : 0;
//availability match check boxes with table
$reset = isset($_POST['user_reset']) && isnum($_POST['user_reset']) ? $_POST['user_reset'] : 0;
$user_6 = isset($_POST['user_6']) && isnum($_POST['user_6']) ? $_POST['user_6'] : 0;
$user_8 = isset($_POST['user_8']) && isnum($_POST['user_8']) ? $_POST['user_8'] : 0;
$user_12 = isset($_POST['user_12']) && isnum($_POST['user_12']) ? $_POST['user_12'] : 0;
$user_16 = isset($_POST['user_16']) && isnum($_POST['user_16']) ? $_POST['user_16'] : 0;
$user_18 = isset($_POST['user_18']) && isnum($_POST['user_18']) ? $_POST['user_18'] : 0;
$user_23 = isset($_POST['user_23']) && isnum($_POST['user_23']) ? $_POST['user_23'] : 0;
$result = dbquery("UPDATE ".DB_USERS." SET user_loyalty='".$loyalty."', user_cavs='".$cavs."', user_foot='".$foot."', user_archer='".$archer."', user_reset='".$reset."', user_6='".$user_6."', user_8='".$user_8."', user_12='".$user_12."', user_16='".$user_16."', user_18='".$user_18."', user_23='".$user_23."' WHERE user_id='".$userdata['user_id']."'");
redirect(FUSION_SELF);
} else if (isset($_POST['loyalty_reset'])) {
$result = dbquery("UPDATE ".DB_USERS." SET user_loyalty='0', user_cavs='0', user_foot='0', user_archer='0', user_reset='0', user_6='0', user_8='0', user_12='0', user_16='0', user_18='0', user_23='0' WHERE user_id='".$userdata['user_id']."'");
redirect(FUSION_SELF);
}
echo "<div class='' align='center'>
<h1>Stats for Eden</h1>
</div><form method='post' action='".FUSION_SELF."'><br>
<div class='' align='center'> <label for='availability' class=''>Select
Available Times<span class='tooltip' tooltip='Check the times your available for battle'>
</span></label>
<ul id='availability'>
<li>
<label><input type='checkbox' name='user_reset' value='1'".($userdata['user_reset'] == 1 ? " checked='checked'" : "")." />Reset</label>n
<label><input type='checkbox' name='user_6' value='1'".($userdata['user_6'] == 1 ? " checked='checked'" : "")." />+6</label>n
<label><input type='checkbox' name='user_8' value='1'".($userdata['user_8'] == 1 ? " checked='checked'" : "")." />+8</label>n
<label><input type='checkbox' name='user_12' value='1'".($userdata['user_12'] == 1 ? " checked='checked'" : "")." />+12</label>n
</li>
<li>
<label><input type='checkbox' name='user_16' value='1'".($userdata['user_16'] == 1 ? " checked='checked'" : "")." />+16</label>n
<label><input type='checkbox' name='user_18' value='1'".($userdata['user_18'] == 1 ? " checked='checked'" : "")." />+8</label>n
<label><input type='checkbox' name='user_23' value='1'".($userdata['user_23'] == 1 ? " checked='checked'" : "")." />+23</label>n
</li>
</ul>
</div>
<div class='' align='center'><label for='footmen' class=''>Footmen<span class='tooltip-element'
tooltip='highest level footmen'> </span></label>
<select class='form' name='user_foot' id='user_foot' required='required' aria-required='true'>
<option value='0'".($userdata['user_foot'] == "0" ? " selected='selected'" : "").">0</option>
<option value='T7'".($userdata['user_foot'] == "T7" ? " selected='selected'" : "").">T7</option>
<option value='T8'".($userdata['user_foot'] == "T8" ? " selected='selected'" : "").">T8</option>
<option value='T9'".($userdata['user_foot'] == "T9" ? " selected='selected'" : "").">T9</option>
<option value='T10'".($userdata['user_foot'] == "T10" ? " selected='selected'" : "").">T10</option>
</select>
<label for='archers' class=''>Archers<span class='tooltip' tooltip='highest level archers'></span>
</label>
<select class='form' name='user_archer' id='user_archer' required='required' aria-required='true'>
<option value='0'".($userdata['user_archer'] == "0" ? " selected='selected'" : "").">0</option>
<option value='T7'".($userdata['user_archer'] == "T7" ? " selected='selected'" : "").">T7</option>
<option value='T8'".($userdata['user_archer'] == "T8" ? " selected='selected'" : "").">T8</option>
<option value='T9'".($userdata['user_archer'] == "T9" ? " selected='selected'" : "").">T9</option>
<option value='T10'".($userdata['user_archer'] == "T10" ? " selected='selected'" : "").">T10</option>
</select>
<label for='archers' class=''>Calvary <span class='tooltip-element' tooltip='highest level calvary'></span>
</label>
<select class='form' name='user_cavs' id='user_cavs' required='required' aria-required='true'>
<option value='0'".($userdata['user_cavs'] == "0" ? " selected='selected'" : "").">0</option>
<option value='T7'".($userdata['user_cavs'] == "T7" ? " selected='selected'" : "").">T7</option>
<option value='T8'".($userdata['user_cavs'] == "T8" ? " selected='selected'" : "").">T8</option>
<option value='T9'".($userdata['user_cavs'] == "T9" ? " selected='selected'" : "").">T9</option>
<option value='T10'".($userdata['user_cavs'] == "T10" ? " selected='selected'" : "").">T10</option>
</select>
</div>
<div class='' align='center'><br>
</div>
<div class='' align='center'> <label for='loyalty' class=''>Loyalty Level
<span class='tooltip' tooltip='EDEN Loyalty'>
</span></label>
<input type='number' id='user_loyalty' name='user_loyalty' maxlength='1' min='0' max='30000' class='textbox' value='".$userdata['user_loyalty']."' required='required' style='width:200px;' /> </div>
<div class='' align='center'>
<input type='submit' name='loyalty_save' value='Save' class='button' />
<input type='submit' name='loyalty_reset' value='Reset' class='button' />
</div></form>";
<?php
require_once __DIR__."/maincore.php";
require_once THEMES."templates/header.php";
include LOCALE.LOCALESET."members.php";
add_to_title("Eden Stats");
opentable("Eden Stats");
if (iMEMBER) {
if (!isset($_GET['sortby']) || !ctype_alnum($_GET['sortby'])) {
$_GET['sortby'] = "all";
}
$orderby = ($_GET['sortby'] == "all" ? "" : " AND user_name LIKE '".stripinput($_GET['sortby'])."%'");
$search_text = ((isset($_GET['search_text']) && preg_check("/^[-0-9A-Z_@S]+$/i", $_GET['search_text'])) ? $orderby = ' AND user_name LIKE "'.stripinput($_GET['search_text']).'%"' : $_GET['sortby']);
$result = dbquery("SELECT user_id FROM ".DB_USERS." WHERE user_status='0'".$orderby);
$rows = dbrows($result);
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) {
$_GET['rowstart'] = 0;
}
if ($rows) {
$i = 0;
echo "<table cellpadding='0' cellspacing='0' width='100%'>n<tr>n";
echo "<td align='center' class='tbl2'><strong>".$locale['401']."</strong></td>n";
echo "<td class='tbl2'><strong>".$locale['405']."</strong></td>n";
//echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><strong>".$locale['402']."</strong></td>n";
echo "<td align='center' class='tbl2'><strong>Current Loyalty</strong></td>n";
echo "<td align='center' class='tbl2'><strong>Calvery Level</strong></td>n";
echo "<td align='center' class='tbl2'><strong>Footment Level</strong></td>n";
echo "<td align='center' class='tbl2'><strong>Archer Level</strong></td>n";
echo "<td align='center' class='tbl2'><strong>Reset</strong></td>n";
echo "<td align='center' class='tbl2'><strong>+6</strong></td>n";
echo "<td align='center' class='tbl2'><strong>+8</strong></td>n";
echo "<td align='center' class='tbl2'><strong>+12</strong></td>n";
echo "<td align='center' class='tbl2'><strong>+16</strong></td>n";
echo "<td align='center' class='tbl2'><strong>+18</strong></td>n";
echo "<td align='center' class='tbl2'><strong>+23</strong></td>n";
echo "</tr>n";
$result = dbquery("SELECT user_id, user_name, user_status, user_level, user_groups, user_loyalty, user_cavs, user_foot, user_archer, user_reset, user_6, user_8, user_12, user_16, user_18, user_23 FROM ".DB_USERS." WHERE user_status='0'".$orderby." ORDER BY user_level DESC, user_name LIMIT ".$_GET['rowstart'].",20");
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2");
$i++;
echo "<tr>n<td class='$cell_color'>n".profile_link($data['user_id'], $data['user_name'], $data['user_status'])."</td>n";
$groups = "";
$user_groups = explode(".", $data['user_groups']);
$j = 0;
foreach ($user_groups as $key => $value) {
if ($value) {
$groups .= "<a href='profile.php?group_id=".$value."'>".getgroupname($value)."</a>".($j < count($user_groups) - 1 ? ", " : "");
}
$j++;
}
echo "<td class='$cell_color'>n".($groups ? $groups : ($data['user_level'] == 103 ? $locale['407'] : $locale['406']))."</td>n";
echo "<td align='center' class='$cell_color'>n".$data['user_loyalty']."</td>n";
echo "<td align='center' class='$cell_color'>n ".$data['user_cavs']."</td>n";
echo "<td align='center' class='$cell_color'>n ".$data['user_foot']."</td>n";
echo "<td align='center' class='$cell_color'>n ".$data['user_archer']."</td>n";
echo "<td align='center' class='$cell_color'>n".$data['user_reset']."</td>n";
echo "<td align='center' class='$cell_color'>n".$data['user_6']."</td>n";
echo "<td align='center' class='$cell_color'>n".$data['user_8']."</td>n";
echo "<td align='center' class='$cell_color'>n".$data['user_12']."</td>n";
echo "<td align='center' class='$cell_color'>n".$data['user_16']."</td>n";
echo "<td align='center' class='$cell_color'>n".$data['user_18']."</td>n";
echo "<td align='center' class='$cell_color'>n".$data['user_23']."</td>n";
//echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>n</tr>";
}
echo "</table>n";
} else {
}
echo "</tr>n</table>n";
} else {
redirect("index.php");
}
closetable();
if ($rows > 100) {
echo "<div align='center' style='margin-top:5px;'>".makepagenav($_GET['rowstart'], 100, $rows, 3, FUSION_SELF."?sortby=".$_GET['sortby']."&")."</div>n";
}
require_once THEMES."templates/footer.php";
Quote
Major - i havw the data displayed as i would like for the most part except for the times available. How can i convert the value of 0 / 1 to be No or Yes (through php rendering not through changing the data in the db)
Quote
The minor issue that I am having is as you can see in the screen shot that on mobile devices the table dosnt properly fit the screen.. Is there any way to better format this information so it looks presentable and dosnt break the page?
Quote
Secondly i would like to have a total at the bottom that counts how many people are available at that time.
<?php
require_once __DIR__.'/maincore.php';
require_once THEMES.'templates/header.php';
include LOCALE.LOCALESET.'members.php';
add_to_title("Eden Stats");
opentable("Eden Stats");
if (iMEMBER) {
if (!isset($_GET['sortby']) || !ctype_alnum($_GET['sortby'])) {
$_GET['sortby'] = "all";
}
$orderby = ($_GET['sortby'] == "all" ? "" : " AND user_name LIKE '".stripinput($_GET['sortby'])."%'");
$search_text = ((isset($_GET['search_text']) && preg_check("/^[-0-9A-Z_@S]+$/i", $_GET['search_text'])) ? $orderby = ' AND user_name LIKE "'.stripinput($_GET['search_text']).'%"' : $_GET['sortby']);
$result = dbquery("SELECT user_id FROM ".DB_USERS." WHERE user_status='0'".$orderby);
$rows = dbrows($result);
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) {
$_GET['rowstart'] = 0;
}
if ($rows) {
$i = 0;
echo "<div style='overflow-x: auto;min-height: 0.01%;'><table cellpadding='0' cellspacing='0' width='100%'><tr>";
echo "<td align='center' class='tbl2'><strong>".$locale['401']."</strong></td>";
echo "<td class='tbl2'><strong>".$locale['405']."</strong></td>";
//echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><strong>".$locale['402']."</strong></td>n";
echo "<td align='center' class='tbl2'><strong>Current Loyalty</strong></td>";
echo "<td align='center' class='tbl2'><strong>Calvery Level</strong></td>";
echo "<td align='center' class='tbl2'><strong>Footment Level</strong></td>";
echo "<td align='center' class='tbl2'><strong>Archer Level</strong></td>";
echo "<td align='center' class='tbl2'><strong>Reset</strong></td>";
echo "<td align='center' class='tbl2'><strong>+6</strong></td>";
echo "<td align='center' class='tbl2'><strong>+8</strong></td>";
echo "<td align='center' class='tbl2'><strong>+12</strong></td>";
echo "<td align='center' class='tbl2'><strong>+16</strong></td>";
echo "<td align='center' class='tbl2'><strong>+18</strong></td>";
echo "<td align='center' class='tbl2'><strong>+23</strong></td>";
echo "</tr>";
$result = dbquery("SELECT user_id, user_name, user_status, user_level, user_groups, user_loyalty, user_cavs, user_foot, user_archer, user_reset, user_6, user_8, user_12, user_16, user_18, user_23 FROM ".DB_USERS." WHERE user_status='0'".$orderby." ORDER BY user_level DESC, user_name LIMIT ".$_GET['rowstart'].",20");
while ($data = dbarray($result)) {
$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2");
$i++;
echo "<tr><td class='$cell_color'>".profile_link($data['user_id'], $data['user_name'], $data['user_status'])."</td>";
$groups = "";
$user_groups = explode(".", $data['user_groups']);
$j = 0;
foreach ($user_groups as $key => $value) {
if ($value) {
$groups .= "<a href='profile.php?group_id=".$value."'>".getgroupname($value)."</a>".($j < count($user_groups) - 1 ? ", " : "");
}
$j++;
}
echo "<td class='$cell_color'>".($groups ? $groups : ($data['user_level'] == 103 ? $locale['407'] : $locale['406']))."</td>";
echo "<td align='center' class='$cell_color'>".$data['user_loyalty']."</td>";
echo "<td align='center' class='$cell_color'> ".$data['user_cavs']."</td>";
echo "<td align='center' class='$cell_color'> ".$data['user_foot']."</td>";
echo "<td align='center' class='$cell_color'> ".$data['user_archer']."</td>";
echo "<td align='center' class='$cell_color'>".$data['user_reset']."</td>";
echo "<td align='center' class='$cell_color'>".($data['user_6'] == 0 ? "No" : "Yes")."</td>";
echo "<td align='center' class='$cell_color'>".($data['user_8'] == 0 ? "No" : "Yes")."</td>";
echo "<td align='center' class='$cell_color'>".($data['user_12'] == 0 ? "No" : "Yes")."</td>";
echo "<td align='center' class='$cell_color'>".($data['user_16'] == 0 ? "No" : "Yes")."</td>";
echo "<td align='center' class='$cell_color'>".($data['user_18'] == 0 ? "No" : "Yes")."</td>";
echo "<td align='center' class='$cell_color'>".($data['user_23'] == 0 ? "No" : "Yes")."</td>";
//echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'>".getuserlevel($data['user_level'])."</td>n</tr>";
}
//echo "</table>n</div>n";
} else {
}
echo "</tr></table></div>";
} else {
redirect("index.php");
}
closetable();
if ($rows > 100) {
echo "<div align='center' style='margin-top:5px;'>".makepagenav($_GET['rowstart'], 100, $rows, 3, FUSION_SELF."?sortby=".$_GET['sortby']."&")."</div>";
}
require_once THEMES.'templates/footer.php';
Category Forum
Modifications and Requests - 8Labels
None yet
Statistics
4 participants
Notifications
You are not receiving notifications from this thread.
Related Questions