Account Maker Gesior acc maker 0.3.6 problem spells

Status
Zamknięty.
S

Shadow Dan

User
Zarejestrowany
Dołączył
Marzec 25, 2010
Posty
16
Liczba reakcji
1
Mam problem z acc makerem. Gdy klikam na subtopic spells w menu, zamiast spelli pokazuje mi si? taki b??d. W necie nie znalaz?em na to odpowiedzi.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'theforgottenserver.z_spells' doesn't exist' in D:\Daniel\aSerwer TFS\xampp\xampp\htdocs\spells.php:10 Stack trace: #0 D:\Daniel\aSerwer TFS\xampp\xampp\htdocs\spells.php(10): PDO->query('SELECT * FROM z...') #1 D:\Daniel\aSerwer TFS\xampp\xampp\htdocs\index.php(82): include('D:\Daniel\aSerw...') #2 {main} thrown in D:\Daniel\aSerwer TFS\xampp\xampp\htdocs\spells.php on line 10
 
Odp: Gesior acc maker 0.3.6 problem spells

Przegl?dnij ten temat.
 
Odp: Gesior acc maker 0.3.6 problem spells

Przeczyta?em ca?y i nie rozumiem po co mi da?e? ten link.
Je?li kto? wie o co chodzi z tym problemem to prosz? o pomoc, b?d? wdzi?czny.
Mo?e wystarczy doda? t? 'table' w spells.php i po problemie, tylko nie wiem jak...

To m?j plik spells.php
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>';
?>
 
Ostatnia edycja:
Odp: Gesior acc maker 0.3.6 problem spells

Mo?e przy instalowaniu gensiora zle zaimportowa?e? spelle w sensie ,?e nie klikn??e? na linijk? ,
omin??e? j?.
Prze instaluj gesiora.
 
Ostatnia edycja:
Odp: Gesior acc maker 0.3.6 problem spells

#edit
Poniewa? nikt nie zna? odpowiedzi, nie pozosta?o mi nic innego jak zainstalowa? acc makera ponownie, problem rozwi?zany.

Temat mo?na zamkn?? lub usun??.
 
Ostatnia edycja:
Odp: Gesior acc maker 0.3.6 problem spells

?e tak powiem, wystarczy?o si? zalogowa? na podane dane przy instalowaniu acc, wej?? w admin panel no i oczywi?cie reloadn?? spells.
 
Status
Zamknięty.
Back
Do góry