Olá meu povo, boa noite.

Vim lhes pedir para me ajudar a resolver um pequeno problema para quem entende rs'

Meu spells.php esta dando um erro:

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\spells.php on line 20 

Aqui está meu 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.'">   <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>'; ?>

Espero que me ajudem, obrigado desde já.

Up

Verificou se a tabela de z_spells existe no banco de dados??

Esse sistema de spells do gesior já é antigo, ninguém atualizou... precisa de um mecanismo para gravar as spells no bandados, sendo assim ele captura os dados obtidos e reverte para a página.

Em 2017-6-12 at 22:47, victorfasano disse:

Verificou se a tabela de z_spells existe no banco de dados??

 

Esse sistema de spells do gesior já é antigo, ninguém atualizou... precisa de um mecanismo para gravar as spells no bandados, sendo assim ele captura os dados obtidos e reverte para a página.

Sim existe, eu a adicionei.

DROP TABLE IF EXISTS `z_spells`;CREATE TABLE IF NOT EXISTS `z_spells` (  `name` varchar(255) NOT NULL,  `spell` varchar(255) NOT NULL,  `spell_type` varchar(255) NOT NULL,  `mana` int(11) NOT NULL DEFAULT '0',  `lvl` int(11) NOT NULL DEFAULT '0',  `mlvl` int(11) NOT NULL DEFAULT '0',  `soul` int(11) NOT NULL DEFAULT '0',  `pacc` varchar(255) NOT NULL,  `vocations` varchar(255) NOT NULL,  `conj_count` int(11) NOT NULL DEFAULT '0',  `hide_spell` int(11) NOT NULL DEFAULT '0') ENGINE=InnoDB DEFAULT CHARSET=latin1;