Secret Experience

crazyshock · 19-02-2010, 03:56 PM

Galera to usando o script do aio do DUDU pro site..
so que meu serve é EPILOGUE..
e ta dando esse erro aqui..

Column count doesn't match value count at row 1

O Arquivo principal ta aqui abaixo ve se podem arrumar pra mim ..

Código: [Somente Usuários Registrados Podem Visualizar os Links Desta PáginaClique aqui para se Registrar]

<?
include("config.php");

function gerar($t) {

	$caracteres = '0123456789';
	$codigo_a   = '';
	for($i=0; $i<$t; $i++) {
		$codigo_a .= $caracteres[rand(0,strlen($caracteres)-1)];
	}
	
	return $codigo_a;
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Seu servidor de Lineage II</title>
<script>
function mudar(string) {
	var t = document.getElementById(string).value='';
}


function div(div) {
	var ob = document.getElementById(div);
	if(ob.style.display == 'none') {
		ob.style.display = 'block';
		}else{
		ob.style.display = 'none';
	}
}
</script>
<style type="text/css">
<!--
.style1 {
	font-size: 13px;
	font-family: Arial, Helvetica, sans-serif;
	font-weight: bold;
	color: #333333;
}
.style2 {
	font-size: 11px;
	font-family: Arial, Helvetica, sans-serif;
}
a {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 11px;
	color: #999999;
}
a:link {
	text-decoration: none;
	color: #666666;
}
a:visited {
	text-decoration: none;
	color: #666666;
}
a:hover {
	text-decoration: underline;
	color: #666666;
}
a:active {
	text-decoration: none;
	color: #666666;
}
-->
</style>
</head>

<body>
<table width="100%" border="0">
  <tr bgcolor="#CCCCCC" class="style1">
    <td align="center">Sistema de AIO BY _Dudu_1533:</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>

<?
$act = $_GET['act']; 

if($act == 'abx'){
$sql = mysql_query("SELECT * FROM characters ORDER BY  char_name") or die(mysql_error());
?>
<form id="form1" name="form1" method="post" action="">
  <table width="100%" border="0" class="style2">
    <tr>
      <td width="21%">Selecione o char:</td>
      <td colspan="3"><select name="char" class="style2">
          <?
	while($c = mysql_fetch_array($sql)) {
	?>
          <option value="<?php echo $c['charId']; ?>"><?php echo $c['char_name']; 

?></option>
          <?
	}
	?>
        </select>      </td>
    </tr>
    <tr>
      <td>Alterar level do char para: </td>
      <td colspan="3"><input name="level" type="text" class="style2" id="level" value="78" 

/></td>
    </tr>
    <tr>
      <td height="23">Inserir Dual para o char? </td>
      <td width="11%" height="23">
      <input name="dual" id="dual" type="radio" class="style2" value="sim" checked="checked" 

onclick="javascript:div('enchant');">
      Sim</td>
      <td width="10%" height="23"><input name="dual" id="dual" type="radio" class="style2" 

value="nao" onclick="javascript:div('enchant');">
      N&atilde;o</td>
      <td width="58%" height="23">
      <div id="enchant" style="display:block">
      <input name="enchant" type="text" class="style2" id="enchant" 

onmouseup="javascript:mudar('enchant');" value="Escreva aqui o enchant da arma." size="40"/> 
        EX: <strong>10</strong>
        </div>
      </td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td colspan="3">&nbsp;</td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td colspan="3"><input name="inserir" type="submit" class="style2" id="inserir" 

value="Inserir AIO" /></td>
    </tr>
  </table>
</form>
<?
}

if(@$_POST['inserir']) {

$char    = $_POST['char'];
$level   = intval($_POST['level']);
$dual    = $_POST['dual'];
$enchant = intval($_POST['enchant']);

$chars = mysql_query("SELECT * FROM characters WHERE charId = '".$char."'") or 

die(mysql_error());
$ch = mysql_fetch_array($chars);

if($dual == 'sim') {

$fi = file('aio.txt');
foreach($fi as $f) {

$f = str_replace('".$char."', ''.$char.'', $f);
$f = str_replace('".$level."', ''.$level.'', $f);
mysql_query($f) or die(mysql_error());
}

$query = mysql_query("INSERT INTO `items` (`owner_id`, `object_id`, `item_id`, `count`, 

`enchant_level`, `loc`, `loc_data`, `time_of_use`, `custom_type1`, `custom_type2`, 

`mana_left`, `time`) VALUES (".$char.", '".gerar(9)."', '2571', '1', '".$enchant."', 

'INVENTORY', '', '', '0', '0', '-1', '0')") or die(mysql_error());

}else{

$fi = file('aio.txt');
foreach($fi as $f) {

$f = str_replace('".$char."', ''.$_POST['char'].'', $f);
$f = str_replace('".$level."', ''.$level.'', $f);
$query = mysql_query($f) or die(mysql_error());
}

}

if($query) { 

echo "<script> alert('AIO adicionado com sucesso para o char ".$ch['char_name']."'); 

</script>";
echo "<script> window.location='index.php'; </script>";

}else{
echo "<script> alert('Não foi possível adicionar AIO para o char ".$ch['char_name']."'); 

</script>";
echo "<script> window.location='index.php'; </script>";

}

}

if(empty($act)) {
?>
<table width="100%" border="0">
  <tr>
    <td><a href="?act=abx">Inserir AIO para um char.</a></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<?
}
?>
</body>
</html>