Originally Posted by
asianking
I tested with just 9 sp and error is "There was an error happened while processing." I have no problems with epin, creating users, accessing user profile, but error on adding sp.
if you're talking about the two db that comes with the download; yes. But other than the two db that comes along; what exactly table that I need to add?
Fixed. For those of you who's having issue adding sp; change these codes on admin template:
Code:
////////////////////////////////////////////////////////////////////////////
case "spver":
////////////////////////////////////////////////////////////////////////////
?>
<div style="padding-top: 2px;">
<div class="news_row_holder">
<div class="news_row">
<div class="news_row_head" id="newstitle150">
<p>
<?php echo $lang["admin_spver"]; ?>
</p>
</div>
<div class="news_row_content">
<?php
if($_POST)
{
connect_db("2");
$karakterad = anti_injection($_POST["karakterad"]);
$spmiktar = anti_injection($_POST["spmiktar"]);
if($karakterad == "" && $pmiktar == "" && !is_numeric($spmiktar))
{
echo "Character Name & SP Amount can't be empty.";
}
else if(@mssql_num_rows(@mssql_query("Use SRO_VT_SHARD SELECT * FROM dbo._Char WHERE CharName16 = '$karakterad'")) == "0")
{
echo "This character not exists.";
}
else
{
$spekle = @mssql_query("UPDATE dbo._Char SET RemainSkillPoint = RemainSkillPoint+$spmiktar WHERE CharName16 = '$karakterad'");
if($spekle)
{
close_db_connection();
connect_db("1");
$tarih = date("d.m.Y H:i:s");
$olay = $spmiktar . " SP gived to " . $karakterad;
$islemekle = @mssql_query("INSERT INTO dbo.TB_IslemGecmisi (yapan, yapanid, tip, olay, tarih) VALUES ('$kullanici', '$kullaniciid', '3', '$olay', '$tarih')");
echo $spmiktar . " SP gived to " . $karakterad;
close_db_connection();
}
else
{
echo "There was an error happened while processing.";
}
}
}
else
{
?>
<form action="" method="POST">
<table width="100%" cellpadding="5px" cellspacing="5px" border="0">
<tr>
<td>Username:</td>
<td><input type="text" name="karakterad" value="" /></td>
</tr>
<tr>
<td>SP Amount to give:</td>
<td><input type="text" name="spmiktar" value="" /></td>
</tr>
<tr>
<td colspan="2"><div align="right"><input type="submit" value="Give SP" /></div></td>
</tr>
</table>
</form>
<?php
}
?>
</div>
</div>
</div>
</div>
<?php
Reply With Quote