Thread: [Epic] Some Scripts

Hello , today its my first post on mmotop , and i have too bad english i have create some scripts :

PHP Code:

<?php
mysql_connect("localhost", "your-user", "your-pass");
mysql_select_db("auth");
// compte created
$retour = mysql_query("SELECT COUNT(*) AS nbre_entrees FROM account");
$comptecree = mysql_fetch_array($retour);
?>

number of accounts created :

PHP Code:

<?php echo $comptecree['nbre_entrees']; ?>

PHP Code:

 <?php
mysql_connect("localhost", "your-user", "your-pass");
mysql_select_db("auth");
// record
$max = mysql_query("select max(`maxplayers`) from uptime");
$max = mysql_result ($max,0);

?>

Record players online :

PHP Code:

<?php echo $max;?>

PHP Code:

<?php
mysql_connect("localhost", "your-user", "your-pass");
mysql_select_db("characters");
// comptes créer
$retour = mysql_query("SELECT COUNT(*) AS nbre_entrees FROM characters");
$persocree = mysql_fetch_array($retour);?>

total characted created :

PHP Code:

<?php echo $persocree['nbre_entrees']; ?>

PHP Code:

<?php
$conn = mysql_connect("localhost", "your-user", "your-pass");

mysql_select_db("characters", $conn) or die('La s&eacute;lection de la base de donn&eacute;e &agrave; &eacute;chou&eacute;: ' . mysql_error());

$sql = "SELECT Count(Online) FROM `characters` WHERE `online` = 1";
$result = mysql_query($sql, $conn);
$row = mysql_fetch_array($result);
$online = $row["Count(Online)"];


mysql_selectdb ("auth");
?>

player online :

PHP Code:

<?php echo $online;?>

PHP Code:

<?php
mysql_connect("localhost", "your-user", "your-pass") or die ("Connexion impossible &agrave; $host");
mysql_selectdb ("auth");

$sql = mysql_query ("SELECT * FROM `auth``uptime` ORDER BY `starttime` DESC LIMIT 1");  
$uptime_results = mysql_fetch_array($sql);    

if ($uptime_results['uptime'] > 86400) { 
    $uptime =  round(($uptime_results['uptime'] / 24 / 60 / 60),2)." jour(s)";
}
elseif($uptime_results['uptime'] > 3600) { 
    $uptime =  round(($uptime_results['uptime'] / 60 / 60),2)." heure(s)";
}
else { 
    $uptime =  round(($uptime_results['uptime'] / 60),2)." min";
}

?>

Uptime :

PHP Code:

<?php echo $uptime;?>

Thats all , take 2sec vote [Only registered and activated users can see links. ]