create maxonline.sql and write
Quote
/*
MySQL Data Transfer
Source Host: localhost
Source Database: l2jdb
Target Host: localhost
Target Database: l2jdb
Date: 21.08.2010 14:10:39
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for maxonline
-- ----------------------------
DROP TABLE IF EXISTS `maxonline`;
CREATE TABLE `maxonline` (
`MaxOnline` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `maxonline` VALUES ('1');
Next execute this sql file in Navicat.
now create in root directory of site maxonline.php and write
Quote
<?php
$mysql_host="localhost"; // MySQL Host [localhost]
$mysql_port="3306"; // MySQL Port [3306]
$mysql_db="l2jdb"; // MySQL Database [l2jdb]
$mysql_login="root"; // MySQL User [root]
$mysql_password="master"; // MySQL Password [root]
$link = mysql_connect($mysql_host, $mysql_login, $mysql_password) or die("<br>Could not connect: " .mysql_error());
@mysql_select_db($mysql_db, $link);
?>
<?
$sql = mysql_query("SELECT count(*) FROM characters WHERE online = 1") or die("Invalid query: " .mysql_error());
$playsonline = mysql_result($sql, 0, 0);
$sql = mysql_query("SELECT maxonline FROM maxonline") or die("Invalid query: " .mysql_error());
$playsmaxonline = mysql_result($sql, 0, 0);
if($playsmaxonline < $playsonline)
{ mysql_query("UPDATE maxonline SET maxonline='$playsonline'") or die("Invalid query: " .mysql_error()); }
?>
<?php echo $playsmaxonline; ?>
then include this file in your template.