<?php
include 'includes/functions.php';
include 'includes/header.php';
?>
<article>
<?php
foreach (getCharacters($mysqli) as $character) {
?>
<div class="character">
<h2><?php
echo $character->name;
?>
</h2>
<p>Race <?php
echo $character->race;
?>
</p>
</div>
<?php
}
?>
</article>
<?php
include 'includes/footer.php';
{
$myDB = new DBFactory();
$sql = $myDB->getMysqlConnexionWithPDO();
$query = $sql->prepare("SELECT chars.*, class.name AS className, spec1.role_name AS role1, spec2.role_name AS role2 FROM chars, specs AS spec1, specs AS spec2, class WHERE chars.spec1 = spec1.id AND chars.spec2 = spec2.id AND spec1.class_id = class.id");
$query->execute();
return $query->fetchAll();
}
?>
<div id="roles_content">
<div id="roles">
<h1>Composition de raid</h1>
<div class="role" id="raid_chars">
<h2>Raideurs</h2>
<ul id="user">
<?php
$results = getCharacters();
foreach ($results as $result) {
$id = $result['id'];
echo '<li class="className class' . ucfirst($result['className']) . '" id="' . $result['id'] . '">' . '<input type="hidden" id="' . $id . '_name" value="' . ucfirst($result['name']) . '" />' . '<input type="hidden" id="' . $id . '_spec1" value="' . $result['spec1'] . '" />' . '<input type="hidden" id="' . $id . '_spec2" value="' . $result['spec2'] . '" />' . '<input type="hidden" id="' . $id . '_role" value="' . $result['role1'] . '" />' . '<input type="hidden" id="' . $id . '_role1" value="' . $result['role1'] . '" />' . '<input type="hidden" id="' . $id . '_role2" value="' . $result['role2'] . '" />' . ucfirst($result['name']) . '<span id="' . $id . '_role_selector" class="roleSelector">' . '<img id="' . $id . '_role1_img" src="./img/role_' . $result['role2'] . '_off.png" title="' . $result['role2'] . '" class="a roleImg" onclick="assignRole(1, \'' . $result['role2'] . '\', ' . $id . ')" />' . '<img id="' . $id . '_role2_img" src="./img/role_' . $result['role1'] . '_on.png" title="' . $result['role1'] . '" class="a roleImg" onclick="assignRole(2, \'' . $result['role1'] . '\', ' . $id . ')" />' . '</span></li>';
}
?>
</ul>
</div>
<div class="role" id="raid_comp">
<h2>Raid</h2>
<ul id="raid">
<div class="group">
<h2>Groupe 1</h2>
<ul class="gr">
</ul>
</div>
