HOW to Fix STAT BUq in 1299 PWs. ---

[melo717171]

you know there's a stat buq in 1299pws. when reset stats, it gets (31).
To fix IT :::
-----------------------------------------------------------------------

1) GO Query analyzer,set DB your ko db, exec those codes:

 [/B]
[B]CREATE PROCEDURE statduzelt
@oyunid varchar(21)
-- Bu procedure 4 Haziran tarihinde;
-- 77killer // MerT tarafından Ko-Cuce.Com i

 

[zyllion]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

It does only fix warriors, rogues, paper mage and battle priest what i can se.
But nice work, going to check if we can fix those 2 also

 

[mamaorha]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

nice fix but if u dont wont lot of resoures waste u can put in ur pannel a place after the user login that he can claim his reall stats than it aint running all the time

 

[HellFire]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

easy, make a claim real stats tool in php.

odbc exec <proc>$POST-Charname

i can make it but if i want too 0-0

to define post a form in php is needed.

 

[SexyReplay]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

mine is better nd works for all class/chars

 

[mamaorha]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

sexy stop show off say thanks or share dont just tell us mine is better aint helping to no one :s

 

[SexyReplay]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

thats funny bcz i was going to share this xD but ye i cant share atm the procedure i currently have xD

<?php 
parth1tr();
parth1('25%', 1, 1);
echo 'Re-Stat Script, made by SexyReplay';
parth2();
parth2tr();
part1tr();
part1('25%', 1, 1, 'left');
?>
<table align=center border=0> 
<tr> 
<br><td>Enter Char Nick:</td> 
<td> 
<form action='' method=post> 
<input type=text name=namen maxlength="14" size="14">
</tr> 
<tr> 
<td align="right">Password: </td>
<td> 
<form action='' method=post> 
<input type=password name=namen2 maxlength="12" size="12">
</tr> 
<tr> 
<td colspan=2 align=center><input type=submit value=Go></form></td> 
</table> 
<?php 
$msconnect=odbc_connect("$dbname","$dbuser","$dbpass"); 
if(isset($_POST['namen']))
{ 
$IGN = trim($_POST['namen']); 
$IGN = str_replace("\'","",$IGN); 
$pass = trim($_POST['namen2']); 
$pass = str_replace("\'","",$pass); 
$ses=$_SESSION['sesuser']; 
$ExistCheck = odbc_exec($msconnect, "SELECT COUNT(*) FROM userdata WHERE struserid = '$IGN'"); 
$msExistCheck = odbc_result($ExistCheck, 1); 
if($msExistCheck<=0){ 
echo'<br><br>No Such Char Try Again<br><br>'; 
}else{
$getinfo="select strpasswd from tb_user where straccountid ='$ses'"; 
$msgetinfo = odbc_exec($msconnect , $getinfo) or die('error'); 
while (odbc_fetch_row($msgetinfo)) 
 
$pass_2 = odbc_result($msgetinfo, 1); 
 
if ($pass != $pass_2) {
echo 'Wrong Password.';
} else {
$getinfo2="select struserid from userdata where struserid = '$IGN'";
$msgetinfo2 = odbc_exec($msconnect , $getinfo2) or die('error'); 
while (odbc_fetch_row($msgetinfo2)) 
$CoolNick = odbc_result($msgetinfo2, 1);
$GO="exec statduzelt $IGN"; 
$msresult=odbc_exec($msconnect,$GO) or die(odbc_error());
echo "Your Character $CoolNick has been RE-stated";
}}}
?>

add this to your panel and when ppl want to restat their Character they just have to log to your panel nd put their ingame nick nd their account pw so that way u dont lose any resources xD ( you must have the procedure melo717171 posted by the way)otherwise it wont work xd

if you are a bitch nub stealer then take out the credits but if your r not then keep it.

 

[mamaorha]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

sorry than u just said i have better and thats it so i though u just show off sorry bro
btw that script is rewriten of one of my older php scripts right?

 

[melo717171]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

mine is better nd works for all class/chars

be respectful to the sharings.. nobody said yours bad. wrong?

 

[SexyReplay]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

and I didn't said yours is bad either, I just said mine is better nd right after I made a php script for your procedure

anyway, im out--

 

[blazekilla]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

thats funny bcz i was going to share this xD but ye i cant share atm the procedure i currently have xD

<?php 
parth1tr();
parth1('25%', 1, 1);
echo 'Re-Stat Script, made by SexyReplay';
parth2();
parth2tr();
part1tr();
part1('25%', 1, 1, 'left');
?>
<table align=center border=0> 
<tr> 
<br><td>Enter Char Nick:</td> 
<td> 
<form action='' method=post> 
<input type=text name=namen maxlength="14" size="14">
</tr> 
<tr> 
<td align="right">Password: </td>
<td> 
<form action='' method=post> 
<input type=password name=namen2 maxlength="12" size="12">
</tr> 
<tr> 
<td colspan=2 align=center><input type=submit value=Go></form></td> 
</table> 
<?php 
$msconnect=odbc_connect("$dbname","$dbuser","$dbpass"); 
if(isset($_POST['namen']))
{ 
$IGN = trim($_POST['namen']); 
$IGN = str_replace("\'","",$IGN); 
$pass = trim($_POST['namen2']); 
$pass = str_replace("\'","",$pass); 
$ses=$_SESSION['sesuser']; 
$ExistCheck = odbc_exec($msconnect, "SELECT COUNT(*) FROM userdata WHERE struserid = '$IGN'"); 
$msExistCheck = odbc_result($ExistCheck, 1); 
if($msExistCheck<=0){ 
echo'<br><br>No Such Char Try Again<br><br>'; 
}else{
$getinfo="select strpasswd from tb_user where straccountid ='$ses'"; 
$msgetinfo = odbc_exec($msconnect , $getinfo) or die('error'); 
while (odbc_fetch_row($msgetinfo)) 
 
$pass_2 = odbc_result($msgetinfo, 1); 
 
if ($pass != $pass_2) {
echo 'Wrong Password.';
} else {
$getinfo2="select struserid from userdata where struserid = '$IGN'";
$msgetinfo2 = odbc_exec($msconnect , $getinfo2) or die('error'); 
while (odbc_fetch_row($msgetinfo2)) 
$CoolNick = odbc_result($msgetinfo2, 1);
$GO="exec statduzelt $IGN"; 
$msresult=odbc_exec($msconnect,$GO) or die(odbc_error());
echo "Your Character $CoolNick has been RE-stated";
}}}
?>

add this to your panel and when ppl want to restat their Character they just have to log to your panel nd put their ingame nick nd their account pw so that way u dont lose any resources xD ( you must have the procedure melo717171 posted by the way)otherwise it wont work xd

if you are a bitch nub stealer then take out the credits but if your r not then keep it.

nice but 1 thing i'm not good at is php could u explain alittle of how to add this on panel i know the sql part just suck at php thx for the help

 

[melo717171]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

run notepad , paste those php? codes, save it as a php file ( *.php ) example ; statfix.php, put that file in your web index ( for appserv: put that php in the www folder ) , now run your homepage file, edit it and add a link/button to going this file and you can name it like "Fix Your Stats" vs.

 

[blazekilla]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

run notepad , paste those php? codes, save it as a php file ( *.php ) example ; statfix.php, put that file in your web index ( for appserv: put that php in the www folder ) , now run your homepage file, edit it and add a link/button to going this file and you can name it like "Fix Your Stats" vs.

ok i made the php file but now i'm lost at the link and stuff for it on homepage

 

[melo717171]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

put it in www, edit your homepage with a html editor. i believe you can make a link

 

[blazekilla]

Re: [Share] HOW to Fix STAT BUq in 1299 PWs. ---

edit your homepage with a html editor. i believe you can make a link

aight thx anyway but i have no idea how to add that to kopanel anyone else can explain pls ??