Hi all.
I bring this some php scripts:)
config.php
online_users.phpPHP Code:<?
$dbhost = "127.0.0.1";
$dbuser = "sa";
$dbpasswd = "pass";
$host = "127.0.0.1";
//=============== Connect to DB ====================
$db = 'MuOnline';
$msconnect=mssql_connect("$host","$dbuser","$dbpasswd");
$msdb=mssql_select_db("$db",$msconnect);
?>
add_stats.phpPHP Code:<?
include("config.php");
error_reporting (E_ALL ^ E_NOTICE);
$query = 'Select GameIDC, Resets, Class, MapNumber, MapPosX, MapPosY, ServerName, OnlineHours From MEMB_STAT, AccountCharacter, Character where MEMB_STAT.Connectstat=1 and AccountCharacter.Id=MEMB_STAT.memb___id AND AccountCharacter.GameIDC=Character.Name collate Chinese_PRC_CI_AS order by GameIDC, ServerName desc';
$result = mssql_query($query);
echo '<TABLE border=0 cellPadding=0 cellSpacing=0>
<TD>
<TABLE cellPadding=2 cellSpacing=0>
<TR><TD>
<table height=40 cellspacing=2 cellpadding=0 width=485 border=0 >
<tr>
<td align=center><b>#</b></td>
<td align=center><b>Name</b></td>
<td align=center><b>Reset</b></td>
<td align=center><b>Charakter</b></td>
<td align=center><b>Map</b></td>';
for($i=0;$i < mssql_num_rows($result);++$i)
{
$row = mssql_fetch_row($result);
$rank = $i+1;
if ($row[3] == 0) { $map = 'Lorencia';}
if ($row[3] == 1) { $map = 'Dungeon';}
if ($row[3] == 2) { $map = 'Davias';}
if ($row[3] == 3) { $map = 'Noria';}
if ($row[3] == 4) { $map = 'Lost Tower';}
if ($row[3] == 5) { $map = 'Banned';}
if ($row[3] == 6) { $map = 'Arena';}
if ($row[3] == 7) { $map = 'Atlans';}
if ($row[3] == 8) { $map = 'Tarkan';}
if ($row[3] == 9) { $map = 'Devil Square';}
if ($row[3] == 10) { $map = 'Icarus';}
if ($row[3] == 11) { $map = 'Blood Castle';}
if ($row[3] == 12) { $map = 'Blood Castle';}
if ($row[3] == 13) { $map = 'Blood Castle';}
if ($row[3] == 14) { $map = 'Blood Castle';}
if ($row[3] == 15) { $map = 'Blood Castle';}
if ($row[3] == 16) { $map = 'Blood Castle';}
if ($row[3] == 17) { $map = 'Crystal map';}
if ($row[3] == 19) { $map = 'Dare Devil';}
if ($row[3] == 30) { $map = 'Valley of Loren';}
if ($row[3] == 31) { $map = 'Place of Exile';}
if ($row[3] == 32) { $map = 'Aida';}
if ($row[3] == 34) { $map = 'CryWolf';}
if ($row[2] == 0) {$class = 'DW';}
if ($row[2] == 1) {$class = 'SM';}
if ($row[2] == 2) {$class = 'GM';}
if ($row[2] == 16){$class = 'DK';}
if ($row[2] == 17){$class = 'BK';}
if ($row[2] == 18){$class = 'BM';}
if ($row[2] == 32){$class = 'Elf';}
if ($row[2] == 33){$class = 'ME';}
if ($row[2] == 34){$class = 'HE';}
if ($row[2] == 48){$class = 'MG';}
if ($row[2] == 50){$class = 'DM';}
if ($row[2] == 64){$class = 'DL';}
if ($row[2] == 6){$class = 'LE';}
echo "
<tr><td valign=top align=center><b>$rank.</b></td>
<td align=center><B>$row[0]</B></td>
<td align=center>$row[1]</td>
<td align=center>$class</td>
<td align=center>$map</td>
</tr>";
}
?>
clear_pk.phpPHP Code:<?php
include("config.php");
if($_POST[SEND]){
$acc = $_POST[acc];
$char = $_POST[name];
$pwd = $_POST[pwd];
$sila = $_POST[sila];
$obratnost = $_POST[obr];
$vitalita = $_POST[zivot];
$energia = $_POST[energia];
$str = strtok($sila,'-');
$obr = strtok($obratnost,'-');
$vit = strtok($vitalita,'-');
$ene = strtok($energia,'-');
$vs = ($str)+($obr)+($vit)+($ene);
$dot1 = mssql_query("SELECT AccountID,Name,LevelUpPoint,Strength,Dexterity,Vitality,Energy,memb__pwd FROM Character,MEMB_INFO WHERE Name = '$char' AND memb__pwd = '$pwd'");
$show = mssql_fetch_row($dot1);
$sk = ($show[3])+($str);
$ok = ($show[4])+($obr);
$vk = ($show[5])+($vit);
$ek = ($show[6])+($ene);
if($show){
if($show[0] == "$acc"){
if($show[2] > $vs){
if($sk <= '32767' && $ok <= '32767' && $vk <= '32767' && $ek <= '32767'){
$body = $show[2]-($str)-($obr)-($vit)-($ene);
mssql_query("
UPDATE Character SET LevelUpPoint = '$body'
WHERE Name = '$char'
UPDATE Character SET Strength = '$sk'
WHERE Name = '$char'
UPDATE Character SET Dexterity = '$ok'
WHERE Name = '$char'
UPDATE Character SET Vitality = '$vk'
WHERE Name = '$char'
UPDATE Character SET Energy = '$ek'
WHERE Name = '$char'");
echo "Stats added! U have $body points for add.";
} else {echo 'Max stat is 32767';}
} else {echo 'U have small points! !';}
} else {echo 'Account is BAD!';}
} else {echo 'Character is not exist!!';}
}
else
{
echo "
<form method='post' action =''>
<font color='#5e842a'><label style='float: left; width: 80px;'>Account:</label></font> <input style='margin-bottom: 2px;'type ='text' name='acc'><br>
<font color='#5e842a'><label style='float: left; width: 80px;'>Character:</label></font> <input style='margin-bottom: 2px;'type ='text' name='name'><br>
<font color='#5e842a'><label style='float: left; width: 80px;'>Password:</label></font> <input style='margin-bottom: 2px;'type ='password' name='pwd'><br>
<font color='#5e842a'><label style='float: left; width: 80px;'>Strenght:</label></font> <input style='margin-bottom: 2px;'type ='text' name='sila'><br>
<font color='#5e842a'><label style='float: left; width: 80px;'>Agility:</label></font> <input style='margin-bottom: 2px;'type ='text' name='obr'><br>
<font color='#5e842a'><label style='float: left; width: 80px;'>Vitality:</label></font> <input style='margin-bottom: 2px;'type ='text' name='zivot'><br>
<font color='#5e842a'><label style='float: left; width: 80px;'>Energy:</label></font> <input style='margin-bottom: 2px;'type ='text' name='energia'><br>
<input type='submit' name='SEND' value='Add!'> <input type='reset' value='Reset'>
</form>
";
}
?>
level_reset.phpPHP Code:<?
include("config.php");
$overenie = "SELECT AccountID,Name FROM Character,MEMB_INFO WHERE Name = '$name' AND AccountID = '$acc' AND memb__pwd = '$pwd'";
$qwery = mssql_query($overenie);
mssql_query("
UPDATE dbo.Character SET PkLevel = '3'
WHERE Name = '$name'
");
echo "
<form method='post' action =''>
<label style='float: left;color:red; width: 80px;'>Character:</label></font><input type ='text' name='name'><br>
<label style='float: left;color:red; width: 80px;'>Account:</label></font><input type ='text' name='acc'><br>
<label style='float: left;color:red; width: 80px;'>Password:</label></font><input type ='password' name='pwd'><br>
<input type='submit' name='SEND' value='Clear PK!'> <input type='reset' value='Reset'>
</form>";
?>
register.phpPHP Code:<?
include("config.php");
if($_POST['SEND']){
$name = $_POST[name];
$pwd = $_POST[pwd];
$acc = $_POST[acc];
$money = 15000000;
$ower = mssql_query("SELECT ConnectStat FROM MEMB_STAT WHERE memb___id ='$acc'");
$vyp = mssql_fetch_row($ower);
if($vyp[0] != '1'){
$q = "SELECT AccountID,Name,cLevel,resets,memb__pwd,CtlCode,Money FROM Character,MEMB_INFO WHERE Name = '$name' AND AccountID = '$acc' AND memb__pwd = '$pwd'";
$dt = mssql_query($q);
$vypis = mssql_fetch_row($dt);
if($vypis[3] <= '81'){
$potr = $vypis[3]+('320');
} else {$potr = "400";}
if($vypis[1] !=''){
if($vypis[2] >= $potr){
if($vypis[5] != '32' && $vypis[5] != '8'){
if($vypis[3] < '402'){
if($vypis[6] >= '$money'){
$res = $vypis[3] +('1');
$prachy = $vypis[6]-('15000000');
$point = $vypis[3]*('500')+('500');
mssql_query("
UPDATE dbo.Character SET clevel=1
WHERE Name = '$name'
UPDATE dbo.Character SET resets = '$res'
WHERE Name = '$name'
UPDATE dbo.Character SET Experience = '0'
WHERE Name = '$name'
UPDATE dbo.Character SET Money = '$prachy'
WHERE Name = '$name'
UPDATE dbo.Character SET LevelUpPoint = '$point'
WHERE Name = '$name'
UPDATE dbo.Character SET MapNumber = '0'
WHERE Name = '$name'
UPDATE dbo.Character SET Strength = '18'
WHERE Name = '$name'
UPDATE dbo.Character SET Dexterity = '18'
WHERE Name = '$name'
UPDATE dbo.Character SET Vitality = '15'
WHERE Name = '$name'
UPDATE dbo.Character SET Energy = '30'
WHERE Name = '$name'
UPDATE dbo.Character SET MapPosX= '125'
WHERE Name = '$name'
UPDATE dbo.Character SET MapPosY= '125'
WHERE Name = '$name'
");
echo "U have <font color='#5e842a'>$res</font> resets and <font color='#5e842a'>$point</font> points for add.";
}
} else {echo "U have Full reset!!";}
} else {echo "U are GM! !";}
} else {echo "U have small level! $potr !";}
} else {echo "U entered bad data! ";}
} else {echo "U need log off your character!";}
}
else
{
echo "
<form method='post' action =''>
<label style='float: left;color:red; width: 80px;'>Account:</label></font> <input type ='text' name='acc'><br>
<label style='float: left;color:red; width: 80px;'>Character:</label></font> <input type ='text' name='name'><br>
<label style='float: left;color:red; width: 80px;'>Password:</label></font> <input type ='password' name='pwd'><br>
<input type='submit' name='SEND' value='Go!'> <input type='reset' value='Reset'>
</form>";
}
?>
top10guild.phpPHP Code:<?php
include("config.php");
$error[0] = "<font color='red' size='2'>Enter Account!</font>";
$error[1] = "<font color='red' size='2'>Enter E-Mail!</font>";
$error[2] = "<font color='red' size='2'>Enter password!</font>";
$error[3] = "<font color='red' size='2'>Enter repeat password!</font>";
$error[4] = "<font color='green' size='2'>Register SUCESSFULLY!</font>";
if ($_POST[send]){
$Acc = $_POST[Acc];
$mail = $_POST[mail];
$pass = $_POST[pass];
$pass2 = $_POST[pass2];
if (strlen($Acc) > 4 ){
$Acc = stripslashes($Acc);
}
else {
$Acc = NULL;
$msg[0] = $error[0];
}
if (strlen($mail) > 4 ){
$mail = stripslashes($mail);
}
else {
$mail = NULL;
$msg[1] = $error[1];
}
if (strlen($pass) > 4 ){
$pass = stripslashes($pass);
}
else {
$pass = NULL;
$msg[2] = $error[2];
}
if ($pass != $pass2){
$msg[3] = $error[3];
}
if ($Acc && $mail && $pass == $pass2){
$id = 1111111111111;
$dotaz = "INSERT INTO [MEMB_INFO] (memb___id,memb__pwd,memb_name,sno__numb,mail_addr,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code,fpas_ques,fpas_answ) VALUES ('$Acc','$pass','Hocico','$id','$mail','01/01/2006','01/01/2006','01/01/2006','01/01/2006','1','0','0','','')";
mssql_query ($dotaz);
$msg[4] = $error[4];
}
mssql_close();
}
echo '
<form method="post" action="">
<font size="2"><label for="acc" style="float: left;color:orange; width: 80px;">Account</label></font> <input style="margin-bottom: 2px;" class="textbox" type="text" name="Acc" id="Acc"><br>
<span style="color:red">'.$msg[0].'</span><br>
<font size="2"><label for="email" style="float: left;color:orange; width: 80px;">Email</label></font> <input style="margin-bottom: 2px;" class="textbox" type="text" name="mail" id="mail"><br>
<span style="color:red">'.$msg[1].'</span><br>
<font size="2"><label for="password" style="float: left;color:orange; width: 80px;">Password</label></font> <input style="margin-bottom: 2px;" class="textbox" type="password" name="pass" id="pass"><br>
<span style="color:red">'.$msg[2].'</span><br>
<font size="2"><label for="password2" style="float: left;color:orange; width: 80px;">Repeat Password</label></font> <input style="margin-bottom: 2px;" class="textbox" type="password" name="pass2" id="pass2"><br>
<span style="color:red">'.$msg[3].'</span><br>
<input type="submit" name="send" class="button" value="Register!"> <input type="reset" name="Reset" class="button" value="Reset" >
</form>'.$msg[4];
?>
top10chars.phpPHP Code:<?
include("config.php");
$query = 'SELECT TOP 10 * from guild order by G_score desc';
$result = mssql_query($query);
echo '
<table height=1 cellspacing=0 cellpadding=5 width=180 border=0 bgcolor="" bordercolor="#FFCC00">
<td valign=top align=center width=13 height=6><font color="yellow"><strong>#</font></td>
<td valign=top align=center><strong><font color="yellow">Name</font></td>
<td valign=top align=center><strong><font color="yellow">Score</font></td>
</tr>';
for($i=0;$i < mssql_num_rows($result);++$i)
{
$row = mssql_fetch_row($result);
$rank = $i+1;
$query2= "Select count(*) from GuildMember where G_name='$row[0]'";
$result2 = mssql_query($query2);
$row2 = mssql_fetch_row($result2);
echo "<tr>
<td valign=top align=center><font color='blue' size='2'><span class='style1'><b>$rank.</b></font></td>
<td valign=top align=center><font color='#00FF33' size='2'><span class='style1'><b>$row[0]</b></font></td>
<td valign=top align=center><font color='#00FF33' size='2'><span class='style1'><b>$row[2]</b></font></td>
</tr>";
}
?>
gm_online.phpPHP Code:<?php
include("config.php");
$query = "SELECT TOP 10 Name,resets,cLevel FROM Character WHERE CtlCode='1' OR CtlCode='0' ORDER BY resets desc,cLevel desc";
$result = mssql_query($query);
echo '<table align=center height=30 cellspacing=0 cellpadding=0 width=180 border=0 >
<tbody>
<tr>
<td><b>#</b></td>
<td><b>Charakter</b></td>
<td><b>Reset</b></td>
<td><b>Level</b></td>
</tr>';
for($i=0;$i < mssql_num_rows($result);++$i)
{
$row = mssql_fetch_row($result);
$rank = $i+1;
if($row[1] == null){ $row[1] = '0';
}
echo "<tr><td align=left>$rank.</td>
<td align=left>$row[0]</td>
<td align=center>$row[1]</td>
<td align=center>$row[2]</td></tr></tbody></table>";
}
?>
All are my scripts :) nice UsagePHP Code:<?
include("config.php");
$query=mssql_query("SELECT * FROM Character WHERE CtlCode=32");
while($gm=mssql_fetch_array($query)){
$stat="";
$gmname=$gm['Name'];
$gmacc=$gm['AccountID'];
$query2=mssql_query("SELECT ConnectStat FROM MEMB_STAT WHERE memb___id='$gmacc'");
$query3=mssql_query("SELECT GameIDC FROM AccountCharacter WHERE Id='$gmacc'");
$query3=mssql_result($query3, 0, 0);
$rquery2=mssql_num_rows($query2);
if($rquery2<1) { $query2 = '0'; }
else{ $query2=mssql_result($query2, 0, 0); }
if($query2=='1'){
if($query3==$gmname){
$stat = '<font color=green><strong>[ON]</strong></font>';
}
}
if($query2=='0'){
$stat = '<font color=red><strong>[OFF]</strong></font>';
}
if($query2=='1' AND $query3 <> $gmname){
$stat = '<font color=red><strong>[OFF]</strong></font>';
}
echo "$gmname $stat";
echo "<br>";
}
?>



Reply With Quote



