• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

GESIOR ACC spells array

Exiled Pain

Fervid Learner
Joined
Jan 8, 2008
Messages
552
Reaction score
4
Sup everyone.
I'm using gesior acc. Everything working 100%... just one thing I notice, went to spells section and when I want to select a specific Vocation set of spells to display All I get in the slidedown bar is:
All
Array
Array
Array
Array

No matter what you select you always get all spells shown

And all my vocations are correctly set up in the config.php and spells also are correct in mi spells.xml.. what could be wrong here and how to fix it? Besides that everything working nicely.

Hope someone can help out
 
Thanks for your reply.
Went to DB and added manually the vocations for some spells in z_spells but it still doen't show anything. Any other thoughts?
 
Take this spells.php file:
PHP:
<?PHP
$allowed_order_by = array('name', 'spell', 'spell_type', 'mana', 'lvl', 'mlvl', 'soul');
$vocation_id = $_REQUEST['vocation_id'];
$order = $_REQUEST['order'];
if(in_array($order, $allowed_order_by))
	$orderby = $order;
else
	$orderby = 'name';

$spells = $SQL->query('SELECT * FROM z_spells WHERE hide_spell != 1 ORDER BY '.$orderby.', lvl');
$main_content .= '<FORM ACTION="?subtopic=spells" METHOD=post>
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR='.$config['site']['vdarkborder'].'><TD CLASS=white><B>Spell Search</B></TD></TR>
<TR BGCOLOR='.$config['site']['darkborder'].'><TD>Only for vocation: <SELECT NAME="vocation_id">';
$main_content .= '<OPTION VALUE="a:a" ';
if('a:a' == $vocation_id)
	$main_content .= 'SELECTED';
$main_content .= '>All';

foreach($vocation_name[0] as $prom => $arr)
	foreach($arr as $voc_id => $voc_name)
	{
		$main_content .= '<OPTION VALUE="'.$prom.';'.$voc_id.'"';
		if($prom.';'.$voc_id == $vocation_id && $vocation_id != "a:a" && $vocation_id != '')
			$main_content .= ' SELECTED';
		$main_content .= '/>'.$voc_name;
	}
$main_content .= '</SELECT><input type="hidden" name="order" value="'.$orderby.'">&nbsp;&nbsp;&nbsp;<INPUT TYPE=image NAME="Submit" ALT="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD><TR>
</TABLE></FORM>';

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD CLASS=white><B><a href="?subtopic=spells&vocation_id='.$vocation_id.'&order=name"><font CLASS=white>Name</a></B></TD><TD CLASS=white><B><a href="?subtopic=spells&vocation_id='.$vocation_id.'&order=spell"><font CLASS=white>Sentence</a></B></TD><TD CLASS=white><B><a href="?subtopic=spells&vocation_id='.$vocation_id.'&order=spell_type"><font CLASS=white>Type<br/>(count)</a></B></TD><TD CLASS=white><B><a href="?subtopic=spells&vocation_id='.$vocation_id.'&order=mana"><font CLASS=white>Mana</a></B></TD><TD CLASS=white><B><a href="?subtopic=spells&vocation_id='.$vocation_id.'&order=lvl"><font CLASS=white>Exp.<br/>Level</a></B></TD><TD CLASS=white><B><a href="?subtopic=spells&vocation_id='.$vocation_id.'&order=mlvl"><font CLASS=white>Magic<br/>Level</a></B></TD><TD CLASS=white><B><a href="?subtopic=spells&vocation_id='.$vocation_id.'&order=soul"><font CLASS=white>Soul</a></B></TD><TD CLASS=white><B>PACC</B></TD><TD CLASS=white><B>For<br/>Vocations:</B></TD></TR>';
if($vocation_id != 'a:a' && $vocation_id != '')
{
	foreach($vocation_name[0] as $prom => $arr)
		foreach($arr as $voc_id => $voc_name)
			if($prom.';'.$voc_id == $vocation_id)
				$voc_n = $voc_name;
	foreach($spells as $spell)
	{
		$spell_vocations = explode(",", $spell['vocations']);
		if(in_array($vocation_id, $spell_vocations) || empty($spell['vocations']))
		{
			if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
			$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>'.$spell['name'].'</TD><TD>'.$spell['spell'].'</TD>';
			if($spell['spell_type'] == 'conjure')
				$main_content .= '<TD>'.$spell['spell_type'].'('.$spell['conj_count'].')</TD>';
			else
				$main_content .= '<TD>'.$spell['spell_type'].'</TD>';
			$main_content .= '<TD>'.$spell['mana'].'</TD><TD>'.$spell['lvl'].'</TD><TD>'.$spell['mlvl'].'</TD><TD>'.$spell['soul'].'</TD><TD>'.$spell['pacc'].'</TD><TD>'.$voc_n.'</TD></TR>';
		}
	}
}
else
{
	foreach($spells as $spell)
	{
		$spell_vocations = explode(",", $spell['vocations']);
		$showed_vocations = 0;
		$vocs = '';
		foreach($spell_vocations as $voc)
		{
			$voc_info = explode(";", $voc);
			if(!empty($vocation_name[0][$voc_info[0]][$voc_info[1]]))
			{
				$vocs .= $vocation_name[0][$voc_info[0]][$voc_info[1]];
				if($showed_vocations != count($spell_vocations))
					$vocs .= '<br/>';
			}
		}
		if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
		$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>'.$spell['name'].'</TD><TD>'.$spell['spell'].'</TD>';
		if($spell['spell_type'] == 'conjure')
			$main_content .= '<TD>'.$spell['spell_type'].'('.$spell['conj_count'].')</TD>';
		else
			$main_content .= '<TD>'.$spell['spell_type'].'</TD>';
		$main_content .= '<TD>'.$spell['mana'].'</TD><TD>'.$spell['lvl'].'</TD><TD>'.$spell['mlvl'].'</TD><TD>'.$spell['soul'].'</TD><TD>'.$spell['pacc'].'</TD><TD><font size="1">'.$vocs.'</font></TD></TR>';
	}
}

$main_content .= '</TABLE>';
?>
 
Back
Top