smoothrocker
New Member
- Joined
- May 16, 2009
- Messages
- 22
- Reaction score
- 0
THX MAN! good help
rep++ for the quick reply
rep++ for the quick reply
http://chaotical.servegame.com//?subtopic=accountmanagement
http://chaotical.servegame.com//?subtopic=createaccount
http://chaotical.servegame.com:8090/?subtopic=accountmanagement
i have question about guilds create in game without logout creator of guild. It's works? or it's bugged and admin neet to clean up guilds and players?
oO in my case its working. Try again with this spells.php file:Spells.php is still buged xP
check it please :S
Cya
<?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 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.'"> <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 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[$voc_info[0]][$voc_info[1]]))
{
$vocs .= $vocation_name[$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>';
?>
STEP 4
Add samples to DB:
Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\install.php on line 512
You have to setup mysql connection in signature.php file.