[Release] Modules for DarksWeb 0.3

 <?php
ob_start();
session_start();
$username = $_SESSION['member_username'];
$password = $_SESSION['member_password'];
$character = $_SESSION['character'];
include("./config.php");
include("../inc/sqlcfg.php");
secure($_POST['username']);
secure($_POST['password']);
secure($_POST['character']);
$md5 = mssql_query("SELECT * FROM misc WHERE id=4");
$md5 = mssql_fetch_array($md5);
$md5 = $md5['misc'];
if($md5 == 1)
    {
    $check = mssql_query("SELECT * FROM MEMB_INFO WHERE memb___id='$username' AND memb__pwd=[dbo].[fn_md5]('$password','$username')");
    }
else
    {
    $check = mssql_query("SELECT * FROM MEMB_INFO WHERE memb___id='$username' AND memb__pwd='$password'");
    }
function level_reset() {
{

$char = secure($_POST['chars']);
$char = str_replace("'" , "", $char);
$char = str_replace(";" , "", $char);
$xa = mssql_query("SELECT * FROM Character WHERE Name='$char'"); 
$res = mssql_fetch_array($xa);
$resmoney = '10000000'*($res['Resets']+1);     // ako neiskate zena da e zena po broq resets iztriite prosto "*($res['Resets']+1)" i ste gotovi :)
$reslevel = '350';
$maxres   = '50';
if($res['Class']==0){$respoints = '500';}     //Dark Wizard
elseif($res['Class']==1){$respoints = '500';}     //Soul Master
elseif($res['Class']==16){$respoints = '400';}    //Dark Knigh
elseif($res['Class']==17){$respoints = '400';}    //Blade Knight
elseif($res['Class']==32){$respoints = '450';}    //Elf
elseif($res['Class']==33){$respoints = '450';}    //Muse Elf
elseif($res['Class']==48){$respoints = '520';}    //Magic Gladiator  
global $web;
$username_check = mssql_query("SELECT Name FROM Character WHERE Name='$char' and AccountID = '$username'"); 
$username_checked = mssql_num_rows($username_check);  
$online_check = mssql_query("SELECT * FROM MEMB_STAT WHERE memb___id='$username'");
$online_checked = mssql_fetch_array($online_check);
$hero = mssql_query("SELECT * FROM Character WHERE Name='$char'"); 
$row = mssql_fetch_array($hero);
if (empty($char)) { echo "<td><br><font size=2>Please select Character!</font><br><br></td>"; $error=1; }
elseif ($online_checked['ConnectStat'] != 0){ echo "<td><br><font size=2>Account is online, must be logged off!</font><br><br></td>"; $error=1; }
elseif ($row['Money'] < $resmoney) { echo "<td><br><font size=2><b>$char</b> need [<b>$resmoney</b>] zen to Reset!</font><br><br></td>"; $error=1; }
elseif ($row['cLevel'] < $reslevel){ echo "<td><br><font size=2><b>$char</b> need level [<b>$reslevel</b>] to Reset!</font><br><br></td>"; $error=1; }
elseif ($row['Resets'] >= $maxres) { echo "<td><br><font size=2>You have reach maximum resets! Cannot reset this hero!</font><br><br></td>"; $error=1; }
if($error !=1) {
$newstats = ($row['Resets']*$respoints) + $respoints;
$resetup = $row['Resets'] + (1);
$money = $row['Money'] - $resmoney;
$reset_points = "UPDATE character SET [LevelUpPoint]='$newstats',[Money]='$money',cLevel='1',[Strength]='25',[Dexterity]='25',[Vitality]='25',[Energy]='25',Experience='0',[MapNumber]='0',[MapPosX]='125',[MapPosY]='128',[Resets]='$resetup',[inventory]=CONVERT(varbinary(1080), null),[magiclist]= CONVERT(varbinary(180), null) WHERE Name='$char'";
 $reset_results = mssql_query($reset_points);
echo "<td><br><font size=2><b>$char</b> have [<b>$newstats</b>] level up points!</font><br><br></td>";
} 
 }
  }
?>

<?php

$query = mssql_query("SELECT TOP 25 G_Name,G_Score from Guild order by G_Score desc");

echo '
<table width="160" border=0 align="center" bgcolor="#36261b">
<tr> 
<td valign=top align=left class="rank"><b>[+]</b></td>
<td valign=top align=left class="rank"><center><b>Guild</center></b></td>
<td valign=top align=right width=60 class="rank"><b><center>Score</center></b></td>
</tr>
';

for($i=0;$i < mssql_num_rows($query);++$i)
{
$row = mssql_fetch_row($query);
$rank = $i+1;
if($i%2) { $colors = "#483422";} else { $colors="#7b6c40"; }

echo "
<tr bgcolor='$colors' class='rank'>
<td>$rank.</td>
<td class='rank'>$row[0]</td>
<td class='rank' width=60><center>$row[1]</center></td>
</tr>
";

}
echo '</table>';
?>

<?php
ob_start();
session_start();

//How much stones get for change nickname
// defaut (1500)
define(STONE_CHANGE_NICK, 1500)

$member_username = $_SESSION['member_username'];
$password = $_SESSION['member_password'];
$character = $_SESSION['character'];
include(".../config.php");
include(".../inc/sqlcfg.php");
secure($_POST['username']);
secure($_POST['password']);
secure($_POST['character']);
$md5 = mssql_query("SELECT * FROM misc WHERE id=4");
$md5 = mssql_fetch_array($md5);
$md5 = $md5['misc'];
if($md5 == 1)
    {
    $check = mssql_query("SELECT * FROM MEMB_INFO WHERE memb___id='$member_username' AND memb__pwd=[dbo].[fn_md5]('$password','$member_username')");
    }
else
    {
    $check = mssql_query("SELECT * FROM MEMB_INFO WHERE memb___id='$member_username' AND memb__pwd='$password'");
    }

	$xa = mssql_query("SELECT Stone FROM StoneRena WHERE acc='$member_username'"); 
	$hi = mssql_fetch_array($xa);
	
	$online_check = mssql_query("SELECT * FROM MEMB_STAT WHERE memb___id='$member_username'");
	$online_checked = mssql_fetch_array($online_check);
	
	$yourstones = $hi['Stone'];
	if(!defined('STONE_CHANGE_NICK')) {
		$stones = 1500;
	} else {
		$stones = STONE_CHANGE_NICK;
	}
	
	
	echo "Your Stones :    $yourstones      <br>";
	
	if($yourstones < $stones) {
		$needStones = $stones - $yourstones;
		echo "You can't change char nickname. You need $needStones .<br/>";
	}
	if($yourstones >= $stones) {
		$p = $yourstones - $stones;
		echo "Change nickname: $stones";
		echo "You can Change your character name and your stones will be $p<br/>";
	
		echo '<table>
			<form method="post" action="">
			<tr><td><b>Old nickname</b></td><td><input type="text" name="oldname" size="25"/></td></tr>
			<tr><td><b>New nickname</b></td><td><input type="text" name="newname" size="25"/></td></tr>
			<tr><td></td><td><input type="submit" name="submit" value="Submit" /></td></tr></form>
			</table>';
	}

	
	
	$oldnick = $_POST['oldname']);
	$newnick = $_POST['newname']);


	if(!empty($oldnick) && !empty($newnick)) {
		if(empty($oldnick)) {
			$errors .= "Fill Old nickname!";
		} elseif(empty($newnick)) {
			$errors .= "Fill New nickname!";
		} else {
			if($yourstones < $stones) {
				$errors .= "You don't have enough stones. You need of $needStones to change your character name"
			} elseif($online_checked['ConnectStat'] != 0) {
				$errors .= "Account is online, must be logged off!";
			} elseif($oldnick > 10 || $newnick > 10) {
				$errors .= "Old/new nickname cannot be more then 10 symbols.";
			}
		}
	} else {
		$errors .= "Fill all fields";
	}
	
	if(count($errors) != 0) {
		echo $errors."<br/>";
	} else {
		
		$getCharname = mssql_query("SELECT AccountID FROM Character WHERE Name='$newnick'"); 
		$arr = mssql_fetch_array($getCharname);
		$accid = $arr['AccountID'];
		
		$stonesResult = $yourstones - $stones;
		
		$updateStones = mssql_query("UPDATE StoneRena SET [Stone]='$stonesResult' WHERE acc='$accid'");
		
		$ChangeNickname = mssql_query("UPDATE Character SET Name='$newnick' WHERE Name='$oldnick'");
		echo "Nickname successfully changed.";
	}
?>

</table>