<?php
/******************************************************************************
* MyProfile.php *
* User Profile Page *
* See readme.txt for additional information *
*******************************************************************************
* eqEpic - The Epic Raid Manager *
* Open-Source Project By Ryan Christenson *
* =========================================================================== *
* Software Version: eqEpic 0.7.8 *
* Software by: The RSWR Network (http://www.rswr.net) *
* Copyright 2006-2007 by: Ryan Christenson (http://www.rswr.net) *
* Support, News, Updates at: http://forum.rswr.net/ *
*******************************************************************************
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* the Free Software Foundation; either version 2 of the License, or *
* (at your option) any later version. *
* *
* This program is distributed in the hope that it will be useful, *
* but WITHOUT ANY WARRANTY; without even the implied warranty of *
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
* GNU General Public License for more details. *
* *
* You should have received a copy of the GNU General Public License *
* along with DownloadCounter; if not, write to the Free Software *
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
******************************************************************************/
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 ("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("MyProfile") : GetAnonymousPriv("MyProfile");
if (($ewCurSec & ewAllowList) <> ewAllowList) {
ob_end_clean();
header("Location: login.php");
exit();
}
if (IsLoggedIn() && CurrentUserID() == "") {
ob_end_clean();
header("Location: login.php");
exit();
}
?>
<?php
// Open connection to the database
$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
?>
<?php include ("sources/header.php") ?>
<script type="text/javascript" src="ewp.js"></script>
<?php
// Get Data (yes this is big and ugly)
// Replace session userID in each DB query
$sel01 .= "SELECT * FROM `players` WHERE (`name` = '#UserID')";
$sel01 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel01);
$r_name = phpmkr_query("$sel01", $conn);
$sel02 .= "SELECT * FROM `chklist_ber` WHERE (`ber_name` = '#UserID')";
$sel02 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel02);
$r_ber = phpmkr_query("$sel02", $conn);
$sel03 .= "SELECT * FROM `chklist_brd` WHERE (`brd_name` = '#UserID')";
$sel03 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel03);
$r_brd = phpmkr_query("$sel03", $conn);
$sel04 .= "SELECT * FROM `chklist_bst` WHERE (`bst_name` = '#UserID')";
$sel04 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel04);
$r_bst = phpmkr_query("$sel04", $conn);
$sel05 .= "SELECT * FROM `chklist_clr` WHERE (`clr_name` = '#UserID')";
$sel05 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel05);
$r_clr = phpmkr_query("$sel05", $conn);
$sel06 .= "SELECT * FROM `chklist_dru` WHERE (`dru_name` = '#UserID')";
$sel06 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel06);
$r_dru = phpmkr_query("$sel06", $conn);
$sel07 .= "SELECT * FROM `chklist_enc` WHERE (`enc_name` = '#UserID')";
$sel07 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel07);
$r_enc = phpmkr_query("$sel07", $conn);
$sel08 .= "SELECT * FROM `chklist_mag` WHERE (`mag_name` = '#UserID')";
$sel08 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel08);
$r_mag = phpmkr_query("$sel08", $conn);
$sel09 .= "SELECT * FROM `chklist_mnk` WHERE (`mnk_name` = '#UserID')";
$sel09 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel09);
$r_mnk = phpmkr_query("$sel09", $conn);
$sel10 .= "SELECT * FROM `chklist_nec` WHERE (`nec_name` = '#UserID')";
$sel10 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel10);
$r_nec = phpmkr_query("$sel10", $conn);
$sel11 .= "SELECT * FROM `chklist_pal` WHERE (`pal_name` = '#UserID')";
$sel11 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel11);
$r_pal = phpmkr_query("$sel11", $conn);
$sel12 .= "SELECT * FROM `chklist_rng` WHERE (`rng_name` = '#UserID')";
$sel12 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel12);
$r_rng = phpmkr_query("$sel12", $conn);
$sel13 .= "SELECT * FROM `chklist_rog` WHERE (`rog_name` = '#UserID')";
$sel13 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel13);
$r_rog = phpmkr_query("$sel13", $conn);
$sel14 .= "SELECT * FROM `chklist_shd` WHERE (`shd_name` = '#UserID')";
$sel14 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel14);
$r_shd = phpmkr_query("$sel14", $conn);
$sel15 .= "SELECT * FROM `chklist_shm` WHERE (`shm_name` = '#UserID')";
$sel15 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel15);
$r_shm = phpmkr_query("$sel15", $conn);
$sel16 .= "SELECT * FROM `chklist_war` WHERE (`war_name` = '#UserID')";
$sel16 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel16);
$r_war = phpmkr_query("$sel16", $conn);
$sel17 .= "SELECT * FROM `chklist_wiz` WHERE (`wiz_name` = '#UserID')";
$sel17 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel17);
$r_wiz = phpmkr_query("$sel17", $conn);
$sel18 .= "SELECT * FROM `flaglist_dod` WHERE (`dod_name` = '#UserID')";
$sel18 = str_replace("#UserID", AdjustSql(CurrentUserID()), $sel18);
$r_dod = phpmkr_query("$sel18", $conn);
//Fetch Row Data
$row01 = mysqli_fetch_array($r_name);
$row02 = mysqli_fetch_array($r_ber);
$row03 = mysqli_fetch_array($r_brd);
$row04 = mysqli_fetch_array($r_bst);
$row05 = mysqli_fetch_array($r_clr);
$row06 = mysqli_fetch_array($r_dru);
$row07 = mysqli_fetch_array($r_enc);
$row08 = mysqli_fetch_array($r_mag);
$row09 = mysqli_fetch_array($r_mnk);
$row10 = mysqli_fetch_array($r_nec);
$row11 = mysqli_fetch_array($r_pal);
$row12 = mysqli_fetch_array($r_rng);
$row13 = mysqli_fetch_array($r_rog);
$row14 = mysqli_fetch_array($r_shd);
$row15 = mysqli_fetch_array($r_shm);
$row16 = mysqli_fetch_array($r_war);
$row17 = mysqli_fetch_array($r_wiz);
$row18 = mysqli_fetch_array($r_dod);
//Row Data to Display
$x_name = $row01["name"];
$x_ber_name = $row02["ber_name"];
$x_brd_name = $row03["brd_name"];
$x_bst_name = $row04["bst_name"];
$x_clr_name = $row05["clr_name"];
$x_dru_name = $row06["dru_name"];
$x_enc_name = $row07["enc_name"];
$x_mag_name = $row08["mag_name"];
$x_mnk_name = $row09["mnk_name"];
$x_nec_name = $row10["nec_name"];
$x_pal_name = $row11["pal_name"];
$x_rng_name = $row12["rng_name"];
$x_rog_name = $row13["rog_name"];
$x_shd_name = $row14["shd_name"];
$x_shm_name = $row15["shm_name"];
$x_war_name = $row16["war_name"];
$x_wiz_name = $row17["wiz_name"];
$x_dod_name = $row18["dod_name"];
// Uncomment bottom line to show SQL for debugging
// echo $row1 . "<br>"; //
?>
<?php
if (@$_SESSION[ewSessionMessage] <> "") {
?>
<p><div class="ewmsg"><?php echo $_SESSION[ewSessionMessage]; ?></div></p>
<?php
$_SESSION[ewSessionMessage] = ""; // Clear message
}
?>
<table align="center">
<tr>
<td align="center"><!-- Players List -->
<div class="rollover_menu marlefta">
<?php if (is_null($x_name)) { ?>
<a href="playersadd.php"><img src="images/my_charachter.gif" alt="Players List" border="0"/></a>
<?php } else if (!is_null($x_name)) { ?>
<a href="playersedit.php?name=<?php echo $x_name; ?>"><img src="images/my_charachter.gif" alt="Players List" border="0"/></a>
<?php } ?>
</div> </td>
<td align="center">
<div class="rollover_menu marrighta">
<a href="stepslist.php?cmd=resetall#"><img src="images/my_raid_info.gif" alt="Raid Fight Info" border="0"/></a>
</div>
</td>
</tr>
<tr>
<td align="center" valign="top">
<?php if (is_null($x_name)) { ?>
<div class="marlefta">
<span class="ewmsg">You Have No Charachter Entered<br />
<a href="playersadd.php">Add one here</a></span>
</div>
<?php } else if (!is_null($x_name)) { ?>
<div class="marlefta">
<a href="playersedit.php?name=<?php echo $x_name; ?>">Edit Your Charachter, <?php echo $x_name; ?></a>
</div>
<?php } ?> </td>
<td align="center" valign="top">
<div class="marrighta">
Info on each fight, including strat and mob stats.
</div>
</td>
</tr>
<tr>
<td align="center">
<div class="rollover_menu marlefta"><a href="#"><img src="images/my_epics.gif" alt="Epic Check List" border="0"/></a>
</div>
</td>
<td align="center">
<div class="rollover_menu marrighta">
<?php if (is_null($x_flag_name)) { ?>
<a href="#"><img src="images/my_flags.gif" alt="Flag Check List" border="0"/></a>
<?php } else if (!is_null($x_flag_name)) { ?>
<a href="#"><img src="images/my_flags.gif" alt="Flag Check List" border="0"/></a>
<?php } ?>
</div>
</td>
</tr>
<tr>
<td valign="top">
<div class="marleftb">
<div>
<ul><li>
<!-- BRD Checklist -->
<?php if (is_null($x_brd_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_brd_name)) { ?>
<a href="lists/chklist_brdedit.php?brd_name=<?php echo $x_brd_name; ?>">View Your Bard Checklist</a><br /><br />
<?php } ?>
<!-- BST Checklist -->
<?php if (is_null($x_bst_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_bst_name)) { ?>
<a href="lists/chklist_bstedit.php?bst_name=<?php echo $x_bst_name; ?>">View Your Beastlord Checklist</a><br /><br />
<?php } ?>
<!-- BER Checklist -->
<?php if (is_null($x_ber_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_ber_name)) { ?>
<a href="lists/chklist_beredit.php?ber_name=<?php echo $x_ber_name; ?>">View Your Berserker Checklist</a><br />
<br />
<?php } ?>
<!-- CLR Checklist -->
<?php if (is_null($x_clr_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_clr_name)) { ?>
<a href="lists/chklist_clredit.php?clr_name=<?php echo $x_clr_name; ?>">View Your Cleric Checklist</a><br />
<br />
<?php } ?>
<!-- DRU Checklist -->
<?php if (is_null($x_dru_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_dru_name)) { ?>
<a href="lists/chklist_druedit.php?dru_name=<?php echo $x_dru_name; ?>">View Your Druid Checklist</a><br /><br />
<?php } ?>
<!-- ENC Checklist -->
<?php if (is_null($x_enc_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_enc_name)) { ?>
<a href="lists/chklist_encedit.php?enc_name=<?php echo $x_enc_name; ?>">View Your Enchanter Checklist</a><br /><br />
<?php } ?>
<!-- MAG Checklist -->
<?php if (is_null($x_mag_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_mag_name)) { ?>
<a href="lists/chklist_magedit.php?mag_name=<?php echo $x_mag_name; ?>">View Your Magician Checklist</a><br /><br />
<?php } ?>
<!-- MNK Checklist -->
<?php if (is_null($x_mnk_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_mnk_name)) { ?>
<a href="lists/chklist_mnkedit.php?mnk_name=<?php echo $x_mnk_name; ?>">View Your Monk Checklist</a><br /><br />
<?php } ?>
<!-- NEC Checklist -->
<?php if (is_null($x_nec_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_nec_name)) { ?>
<a href="lists/chklist_necedit.php?nec_name=<?php echo $x_nec_name; ?>">View Your Necromancer Checklist</a><br /><br />
<?php } ?>
<!-- PAL Checklist -->
<?php if (is_null($x_pal_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_pal_name)) { ?>
<a href="lists/chklist_paledit.php?pal_name=<?php echo $x_pal_name; ?>">View Your Paladin Checklist</a><br /><br />
<?php } ?>
<!-- RNG Checklist -->
<?php if (is_null($x_rng_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_rng_name)) { ?>
<a href="lists/chklist_rngedit.php?rng_name=<?php echo $x_rng_name; ?>">View Your Ranger Checklist</a><br /><br />
<?php } ?>
<!-- ROG Checklist -->
<?php if (is_null($x_rog_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_rog_name)) { ?>
<a href="lists/chklist_rogedit.php?rog_name=<?php echo $x_rog_name; ?>">View Your Rogue Checklist</a><br /><br />
<?php } ?>
<!-- SHD Checklist -->
<?php if (is_null($x_shd_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_shd_name)) { ?>
<a href="lists/chklist_shdedit.php?shd_name=<?php echo $x_shd_name; ?>">View Your ShadowKnight Checklist</a><br /><br />
<?php } ?>
<!-- SHM Checklist -->
<?php if (is_null($x_shm_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_shm_name)) { ?>
<a href="lists/chklist_shmedit.php?shm_name=<?php echo $x_shm_name; ?>">View Your Shaman Checklist</a><br /><br />
<?php } ?>
<!-- WAR Checklist -->
<?php if (is_null($x_war_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_war_name)) { ?>
<a href="lists/chklist_waredit.php?war_name=<?php echo $x_war_name; ?>">View Your Warrior Checklist</a><br /><br />
<?php } ?>
<!-- WIZ Checklist -->
<?php if (is_null($x_wiz_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_wiz_name)) { ?>
<a href="lists/chklist_wizedit.php?wiz_name=<?php echo $x_wiz_name; ?>">View Your Wizard Checklist</a><br /><br />
<?php } ?>
</li></ul>
</div>
<script type='text/javascript'>
// initialize tooltips in a seperate thread
$(document).ready(function() {
window.setTimeout(hovertipInit, 1);
});
</script>
<div><a href="#"><span id="epic_click">Click Here to Add Epic Checklists!</span></a></div>
<div class="clicktip" target="epic_click">
<br /><span class="ewmsg"><b>Available Epic Checklists</b></span>
<ul>
<li>
<!-- BRD Checklist -->
<?php if (is_null($x_brd_name)) { ?>
<a href="lists/chklist_brdadd.php">Bard Checklist</a><br />
<?php } else if (!is_null($x_brd_name)) { ?>
<?php } ?>
<!-- BST Checklist -->
<?php if (is_null($x_bst_name)) { ?>
<a href="lists/chklist_bstadd.php">Beastlord Checklist</a><br />
<?php } else if (!is_null($x_bst_name)) { ?>
<?php } ?>
<!-- BER Checklist -->
<?php if (is_null($x_ber_name)) { ?>
<a href="lists/chklist_beradd.php">Berserker Checklist</a><br />
<?php } else if (!is_null($x_ber_name)) { ?>
<?php } ?>
<!-- CLR Checklist -->
<?php if (is_null($x_clr_name)) { ?>
<a href="lists/chklist_clradd.php">Cleric Checklist</a><br />
<?php } else if (!is_null($x_clr_name)) { ?>
<?php } ?>
<!-- DRU Checklist -->
<?php if (is_null($x_dru_name)) { ?>
<a href="lists/chklist_druadd.php">Druid Checklist</a><br />
<?php } else if (!is_null($x_dru_name)) { ?>
<?php } ?>
<!-- ENC Checklist -->
<?php if (is_null($x_enc_name)) { ?>
<a href="lists/chklist_encadd.php">Enchanter Checklist</a><br />
<?php } else if (!is_null($x_enc_name)) { ?>
<?php } ?>
<!-- MAG Checklist -->
<?php if (is_null($x_mag_name)) { ?>
<a href="lists/chklist_magadd.php">Magician Checklist</a><br />
<?php } else if (!is_null($x_mag_name)) { ?>
<?php } ?>
<!-- MNK Checklist -->
<?php if (is_null($x_mnk_name)) { ?>
<a href="lists/chklist_mnkadd.php">Monk Checklist</a><br />
<?php } else if (!is_null($x_mnk_name)) { ?>
<?php } ?>
<!-- NEC Checklist -->
<?php if (is_null($x_nec_name)) { ?>
<a href="lists/chklist_necadd.php">Necromancer Checklist</a><br />
<?php } else if (!is_null($x_nec_name)) { ?>
<?php } ?>
<!-- PAL Checklist -->
<?php if (is_null($x_pal_name)) { ?>
<a href="lists/chklist_paladd.php">Paladin Checklist</a><br />
<?php } else if (!is_null($x_pal_name)) { ?>
<?php } ?>
<!-- RNG Checklist -->
<?php if (is_null($x_rng_name)) { ?>
<a href="lists/chklist_rngadd.php">Ranger Checklist</a><br />
<?php } else if (!is_null($x_rng_name)) { ?>
<?php } ?>
<!-- ROG Checklist -->
<?php if (is_null($x_rog_name)) { ?>
<a href="lists/chklist_rogadd.php">Rogue Checklist</a><br />
<?php } else if (!is_null($x_rog_name)) { ?>
<?php } ?>
<!-- SHD Checklist -->
<?php if (is_null($x_shd_name)) { ?>
<a href="lists/chklist_shdadd.php">Shadowknight Checklist</a><br />
<?php } else if (!is_null($x_shd_name)) { ?>
<?php } ?>
<!-- SHM Checklist -->
<?php if (is_null($x_shm_name)) { ?>
<a href="lists/chklist_shmadd.php">Shaman Checklist</a><br />
<?php } else if (!is_null($x_shm_name)) { ?>
<?php } ?>
<!-- WAR Checklist -->
<?php if (is_null($x_war_name)) { ?>
<a href="lists/chklist_waradd.php">Warrior Checklist</a><br />
<?php } else if (!is_null($x_war_name)) { ?>
<?php } ?>
<!-- WIZ Checklist -->
<?php if (is_null($x_wiz_name)) { ?>
<a href="lists/chklist_wizadd.php">Wizard Checklist</a><br />
<?php } else if (!is_null($x_wiz_name)) { ?>
<?php } ?>
<br />
</li>
</ul>
</div>
</div>
</td>
<td valign="top">
<div class="marrightb">
<div>
<ul><li>
<!-- OLD World Flags -->
<?php if (is_null($x_old_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_old_name)) { ?>
<a href="lists/chklist_oldedit.php?brd_name=<?php echo $x_old_name; ?>">View Your Old World Flags & Keys</a><br /><br />
<?php } ?>
<!-- Velious Flags -->
<?php if (is_null($x_vel_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_vel_name)) { ?>
<a href="lists/chklist_oldedit.php?brd_name=<?php echo $x_vel_name; ?>">View Your Velious Flags & Keys</a><br /><br />
<?php } ?>
<!-- Kunark Flags -->
<?php if (is_null($x_kun_name)) { ?>
<!-- Blank Data -->
<?php } else if (!is_null($x_kun_name)) { ?>
<a href="lists/chklist_oldedit.php?brd_name=<?php echo $x_kun_name; ?>">View Your Kunark Flags & Keys</a><br /><br />
<?php } ?>
</li></ul>
</div>
<div>Click Here to Add Flag Checklists!<br />Coming Soon...</div>
<div class="clicktip" target="flag_click">
<br /><span class="ewmsg"><b>Available Flag Checklists</b></span>
<ul>
<li>
<!-- OLD Checklist -->
<?php if (is_null($x_old_name)) { ?>
<a href="lists/chklist_oldadd.php">OLD World Flags</a><br />
<?php } else if (!is_null($x_old_name)) { ?>
<?php } ?>
<!-- Velious Checklist -->
<?php if (is_null($x_vel_name)) { ?>
<a href="lists/chklist_veladd.php">Velious Flags</a><br />
<?php } else if (!is_null($x_vel_name)) { ?>
<?php } ?>
<!-- Kunark Checklist -->
<?php if (is_null($x_kun_name)) { ?>
<a href="lists/chklist_kunadd.php">Kunark Flags</a><br />
<?php } else if (!is_null($x_kun_name)) { ?>
<?php } ?>
<br />
</li>
</ul>
</div>
</div>
</td>
</tr>
</table>
<?php
// Close recordset and connection
phpmkr_free_result($rs);
phpmkr_db_close($conn);
?>
<?php include ("footer.php") ?>