<div class="container_3 account-wide" align="center" style="margin:40px 0 0 0;">
<div style="padding:10px 0 10px 0;" align="left">
<!-- Charcaters -->
<div style="display:block; padding:0 20px 0 10px; float:left;">
<?php
//load the characters module
$CORE->load_ServerModule('character');
//setup the characters class
$chars = new server_Character();
//set the realm
if ($chars->setRealm($RealmId)) {
if ($res = $chars->getAccountCharacters()) {
$selectOptions = '';
//loop the characters
while ($arr = $res->fetch()) {
$ClassSimple = str_replace(' ', '', strtolower($chars->getClassString($arr['class'])));
echo '
<!-- Charcater ', $arr['guid'], ' -->
<div id="character-option-', $arr['guid'], '" style="display:none;">
<div class="character-holder">
<div class="s-class-icon ', $ClassSimple, '" style="background-image:url(http://wow.zamimg.com/images/wow/icons/medium/class_', $ClassSimple, '.jpg);"></div>
<p>', $arr['name'], '</p><span>Level ', $arr['level'], ' ', $chars->getRaceString($arr['race']), ' ', $arr['gender'] == 0 ? 'Male' : 'Female', '</span>
</div>
</div>
';
$selectOptions .= '<option value="' . $arr['name'] . '" getHtmlFrom="#character-option-' . $arr['guid'] . '"></option>';
unset($ClassSimple);
}
unset($arr);
echo '
<div id="select-charcater-selected" style="display:none;">
//if the character is DK
if ($charRow['level'] >= 80) {
//the character meets the requirements
$requirementsMet = true;
}
} else {
//any other class than DK
if ($charRow['level'] >= 60) {
//the character meets the requirements
$requirementsMet = true;
}
}
//if the character meet's the requirements
if ($requirementsMet) {
//update the status and statusText
$statusText = '<b>' . $charRow['name'] . '</b> ' . $chars->getClassString($charRow['class']) . ' Level ' . $charRow['level'] . '</p>';
$status = RAF_LINK_ACTIVE;
//query
$update = $DB->prepare("UPDATE `raf_links` SET `statusText` = :text, `status` = :status, `cDate` = :time WHERE `id` = :id LIMIT 1;");
$update->bindParam(':id', $row['id'], PDO::PARAM_INT);
$update->bindParam(':text', $statusText, PDO::PARAM_STR);
$update->bindParam(':status', $status, PDO::PARAM_INT);
$update->bindParam(':time', $CORE->getTime(), PDO::PARAM_STR);
$update->execute();
unset($update);
//the link is active save that info to the CURUSER class
$CURUSER->setRecruiterLinkState(RAF_LINK_ACTIVE);
//break the realm loop for this referral
break 1;
}
unset($requirementsMet);
if (!isset($characterData[$GUID])) {
$columns = array('name', 'class', 'level', 'race', 'gender');
$characterData[$GUID] = $chars->getCharacterData($GUID, false, $columns);
unset($columns);
}
echo '
<ul class="item-row">
<li class="item-icon">
<a href="', $config['WoWDB_URL'], '/?item=', $arr['entry'], '" target="_newtab" rel="item=', $arr['entry'], '">
<img style="background-image:url(http://wow.zamimg.com/images/wow/icons/large/inv_misc_questionmark.jpg)"/>
</a>
</li>
<li class="item-info"><h2>Loading</h2><h5>', $arr['price'], ' ', $arr['currency'] == CA_COIN_TYPE_SILVER ? 'Silver' : 'Gold', ' Coins</h5></li>
<li class="refund-btn"><a href="#" class="refund-btn" onclick="return RefundItem(', $arr['id'], ');">Refund</a></li>';
if ($characterData[$GUID]) {
$ClassSimple = str_replace(' ', '', strtolower($chars->getClassString($characterData[$GUID]['class'])));
echo '
<li class="character">
<div class="character-holder">
<div class="s-class-icon ', $ClassSimple, '" style="background-image:url(http://wow.zamimg.com/images/wow/icons/medium/class_', $ClassSimple, '.jpg);"></div>
<p>', $characterData[$GUID]['name'], '</p><span>Level ', $characterData[$GUID]['level'], ' ', $chars->getRaceString($characterData[$GUID]['race']), ' ', $characterData[$GUID]['gender'] == 0 ? 'Male' : 'Female', '</span>
</div>
</li>';
unset($ClassSimple);
} else {
//Character not found
echo '
<li class="character">
<div class="character-holder">
<div class="s-class-icon" style="background-image:url(http://wow.zamimg.com/images/wow/icons/large/inv_misc_questionmark.jpg);"></div>
<p>Unknown</p><span>Character not found</span>
while ($arr = $res->fetch()) {
$categories[$arr['id']] = $arr['name'];
}
}
unset($res);
$res = $DB->query("SELECT * FROM `armorsets` ORDER BY id DESC");
if ($res->rowCount() > 0) {
while ($arr = $res->fetch()) {
//null the array
unset($subInfo);
//check for set specifications
if ($arr['tier'] != '') {
$subInfo[] = $arr['tier'];
}
if ($arr['class'] != '' and $arr['class'] > 0) {
$subInfo[] = 'Class: ' . $chars->getClassString($arr['class']);
}
if ($arr['type'] != '') {
$subInfo[] = 'Type: ' . $arr['type'];
}
//explode the items
$items = explode(',', $arr['items']);
//get the category name
if (isset($categories[$arr['category']])) {
$cat = $categories[$arr['category']];
} else {
$cat = 'Unknown';
}
//get the realm name
if ($arr['realm'] == '-1') {
$realmStr = 'All Realms';
