Stuff

<?PHP

/********************************************/
# Widgets Beta 0.1 
# An Iteractive Logging system for Mu Online

# Created by john_d
# Site: http://www.mmowebs.com/
# if you delete this you're a douche.

/********************************************/
$_config['APPL_NAME'] = 'Widgets';

include('config.php');
include('includes/functions.php');
include('includes/dbconnect.php');
include_once $_config['server_type'].'/define.php';
$PREFIX = 'GAMESERVER.';
//$db->debug=1;
$db->Execute('SET ANSI_NULLS ON');
$db->Execute('SET ANSI_WARNINGS ON');

define('_Stats01',"select distinct Login, count(*) as COUNT from cabal_auth_table group by Login");
define('_Stats03',"Select count(*) as COUNT from cabal_character_table");
define('_Stats04',"Select count(*) as COUNT from Guild");
define('_WTOP_HERO',"select NAME,Lev,RESETS,style,CharacterIDX from  cabal_character_table where nation != 3 order by RESETS desc, lev desc");
define('_WTOP_GUILD',"select GUILDNAME, GUILDNO, ( select count(*) from  GuildMember as gm where gm.GuildNo = g.GuildNo )  as MEMB from Guild as g order by MEMB desc");
 
switch(@$_GET['callback']){
case 'servstats':
	
	//$gs =  @fsockopen($_config[0]['ip'], $_config[0]['gs_port'], $errno, $errstr,0.5);


 
 $rs = $db->Execute(_Stats01);
// $login = array('Logout','Logined');
	foreach ($rs as $row) {
	if ($row['LOGIN'] ==1) $stats['Logined'] = $row['COUNT'];
	else $stats['Logined'] = 0;
	$total += $row['COUNT'];
	}
	$stats['Accounts'] =$total;


	$rs = $db2->Execute(_Stats03);
	$row = $rs->FetchRow();
	$stats['Characters'] = $row['COUNT'];


	$rs = $db2->Execute(_Stats04);
	$row = $rs->FetchRow();
	$stats['Guilds'] = $row['COUNT'];
	

	switch (@$_GET['style']) {
		default:
		case 'inline':
		echo 'document.write(\'<div class="mulabel">';
		foreach ($stats as $s1 => $s) echo ' <label>'.$s1.':</label> <b>'.$s.'</b>';
		echo '</div>\');';

		break;
		case 'li':
		case '2':
		echo 'document.write(\'<ul class="mulabel">';
		foreach ($stats as $s1 => $s) echo ' <li>'.$s1.': <b>'.$s.'</b></li>';
		echo '</ul>\');';


		break;
		case 'json':
		echo 'servStats({"data":[';
		foreach ($stats as $s1 => $s) echo '{"label":"'.$s1.'","value":"'.$s.'"},';

		echo '{}]})';

		break;
	
	}
  break;
  case 'tophero':
	$top = (ctype_digit($_GET['top'])) && ($_GET['top']<=50) ? $_GET['top'] : 5;
	$rs = $db2->SelectLimit(_WTOP_HERO, $top,0,array() );
	$row = $rs->GetArray();
	$result =  array();
	foreach ($row as $r1 => $r) {
			$style = decode_style($r['style']);
			$result[$r1]['CL'] = $style['Class'];
			$result[$r1]['CLNO'] =  $style['Class_Name'];
			foreach ($r as $r2 => $r3) 
				if (ctype_upper($r2)) $result[$r1][$r2] = $r3;			   
	}
	echo 'topHero({"CharList":'.array2json($result).'})';  
  break;
  case 'topguild':
  $db->debug=1;
	$top = (ctype_digit($_GET['top'])) && ($_GET['top']<=50) ? $_GET['top'] : 5;
	$rs = $db2->SelectLimit(_WTOP_GUILD,$top,0,array());
	$row = $rs->GetArray();
	$result =  array();
	foreach ($row as $r1 => $r) {
		
			//$result[$r1]['GMARK'] = urlencode(bin2hex($r['G_MARK']));;
			foreach ($r as $r2 => $r3) 
				if (ctype_upper(preg_replace('/_/i','',$r2))) $result[$r1][$r2] = $r3;			   
	}
	echo 'topGuilds({"GuildList":'.array2json($result).'})';  
  break;

  default:
    $rs = $db->Execute(_Stats01);
// $login = array('Logout','Logined');
	foreach ($rs as $row) {
	if ($row['LOGIN'] ==1) $stats['Logined'] = $row['COUNT'];
	else $stats['Logined'] = 0;
	$total += $row['COUNT'];
	}
	$stats['Accounts'] =$total;
	$rs = $db2->Execute(_Stats03);
	$row = $rs->FetchRow();
	$stats['Characters'] = $row['COUNT'];
	$rs = $db2->Execute(_Stats04);
	$row = $rs->FetchRow();
	$stats['Guilds'] = $row['COUNT'];
	$top = (ctype_digit($_GET['top'])) && ($_GET['top']<=50) ? $_GET['top'] : 5;
	$rs = $db2->SelectLimit(_WTOP_HERO, $top,0,array() );
	$row = $rs->GetArray();
	$cresult =  array();
	foreach ($row as $r1 => $r) {
		
			$style = decode_style($r['style']);
			$cresult[$r1]['CL'] = $style['Class'];
			$cresult[$r1]['CLNO'] =  $style['Class_Name'];
			foreach ($r as $r2 => $r3) 
				if (ctype_upper($r2)) $cresult[$r1][$r2] = $r3;			   
	}
	$top = (ctype_digit($_GET['top'])) && ($_GET['top']<=50) ? $_GET['top'] : 5;
	$rs = $db2->SelectLimit(_WTOP_GUILD,$top,0,array());
	$row = $rs->GetArray();
	$result =  array();
	foreach ($row as $r1 => $r) {
			foreach ($r as $r2 => $r3) 
				if (ctype_upper(preg_replace('/_/i','',$r2))) $result[$r1][$r2] = $r3;			   
	}
	
	$result = array('GuildList'=>$result,'CharList'=>$cresult,'Stats'=>$stats);
	echo 'srvFeed('.array2json($result).')';  
  
  break;
}
$db->close;
$db2->close;





?>