$matchesa = array('<a href="http://wow.allakhazam.com/db/item.html?witem=', '"><img alt="" src="' . ROSTER_URL . $roster->config['interface_url'] . 'img/Interface/Icons"', '" alt="" height="32" width="32" border="0" /></a>', '"><img alt="" src="'); $imagex = str_replace($matchesa, ':', $string); if (stristr($imagex, ":")) { list($a, $b, $c, $d) = explode(":", $imagex); return $b; } else { return null; } } // End tooltips part } //aprint($addon); // Assign initial tpl vars $roster->tpl->assign_vars(array('L_ITEM' => $roster->locale->act['item'], 'L_NAME' => $roster->locale->act['name'], 'L_SLVL' => $roster->locale->act['skill_level'], 'L_DISPLAY' => $addon['config']['display_mr_list'] ? 'inline-table' : 'none', 'L_SHOWBAR' => $addon['config']['mr_show_progressbar'], 'A_THEME_IMG_PATH' => $addon['url_path'] . 'templates/images/', 'R_THEME_PATH' => ROSTER_PATH . 'templates/' . $roster->tpl->tpl)); $charid = $roster->data['member_id']; $skills = skill_get_many($charid); $skill_list = array(); $i = 0; $skill_name = ''; $skill_name_divider = ''; $known_count = array(); foreach ($skills as $skillgroup) { foreach ($skillgroup as $skill) { $st = $skill->data['skill_type']; if ($skill->data['skill_type'] == $roster->locale->wordings[$roster->data['clientLocale']]['professions'] || $skill->data['skill_type'] == $roster->locale->wordings[$roster->data['clientLocale']]['secondary']) { if ($skill->data['skill_name'] != $roster->locale->wordings[$roster->data['clientLocale']]['riding'] && $skill->data['skill_name'] != $roster->locale->wordings[$roster->data['clientLocale']]['Fishing'] && $skill->data['skill_name'] != $roster->locale->wordings[$roster->data['clientLocale']]['Skinning'] && $skill->data['skill_name'] != $roster->locale->wordings[$roster->data['clientLocale']]['Mining'] && $skill->data['skill_name'] != $roster->locale->wordings[$roster->data['clientLocale']]['Herbalism']) { $skill_list[$i] = $skill->data['skill_name']; $skill_level[$i] = $skill->data['skill_level']; $skill_name_header = $skill->data['skill_name']; $query = "SELECT count(`recipe_id`) as cnt FROM `" . $roster->db->table('recipes') . "` WHERE `member_id` = '{$charid}' AND `skill_name` = '{$skill_name_header}'"; $result = $roster->db->query($query);
function skill_get_many_by_order($member_id, $order) { global $roster; $order = $roster->db->escape($order); return skill_get_many($member_id, "`skill_order` = '{$order}'"); }