<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';