Paxton
Banned User
In index.php there are few constants defined, check them out.
The first idea, is basically all about different URL of redirecting aftre registration second one, good idea, but there are different forums isn't it?
here should be very soon at web apps aswellShowing staff members online would be great. What difference from Gesior's script has to be changed to work on Modern?
<?PHP
/* * * * * * * * * * * * * * * * * * * * * * * * * *
* Improved Support List *
* Adapted for Modern AAC by Cybermaster *
* Original from AchTung *
* Credits to Gesior(Standard Version) *
* Credits to Zonet(Improved the PHP script with css part)*
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * */
require("config.php");
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = $ots->getDBHandle();
$config['site']['server_path'] = "C:/otserv/";
if($groups = simplexml_load_file($config['site']['server_path'].'/data/XML/groups.xml') or die('<b>Could not load groups!</b>'))
foreach($groups->group as $g)
$groupList[(int)$g['id']] = $g['name'];
$list = $SQL->query("SELECT `name`, `online`, `group_id`, `world_id` FROM `players` WHERE `group_id` > 1 ORDER BY `group_id` DESC");
$showed_players = 0;
echo'<div class="bar"><center>Support in game</center></div><br/><br/><br/>';
$headline = '<table class="houses_list_box" border="0" cellspacing="1" cellpadding="0" width="100%">
<tr class="bar"><td width="30%"><font class=white><b>Group</b></font></td>
<td width="35%"><font class=white><b>Name</b></font></td>
<td width="15%"><font class=white><b>Status</b></font></td>
<td width="20%"><font class=white><b>World</b></font></td>';
$group_id = 0;
foreach($list as $gm)
{
if($group_id != (int)$gm['group_id'])
{
if($group_id != 0)
echo'</table><br />';
echo $headline;
$group_id = (int)$gm['group_id'];
}
echo'<tr class="over"><td>'.$groupList[(int)$gm['group_id']].'</td><td><a class="link" href="'.WEBSITE.'/index.php/character/view/'.$gm['name'].'">'.$gm['name'].'</a></td><td><font color="'.($gm['online'] == 0 ? 'red">Offline' : 'green">Online').'</font></td><td>'.$config['worlds'][$gm['world_id']].'</td></tr>';
}
echo'</table>';
?>
<style type="text/css">
tr.over:hover {
background-color: #FAFAD2;
}
.link {text-decoration: none;font-weight:bold;color:black;}
.more { display: none;}
</style>
here should be very soon at web apps aswell
PHP:<?PHP /* * * * * * * * * * * * * * * * * * * * * * * * * * * Improved Support List * * Adapted for Modern AAC by Cybermaster * * Original from AchTung * * Credits to Gesior(Standard Version) * * Credits to Zonet(Improved the PHP script with css part)* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * */ require("config.php"); $ots = POT::getInstance(); $ots->connect(POT::DB_MYSQL, connection()); $SQL = $ots->getDBHandle(); $config['site']['server_path'] = "C:/otserv/"; if($groups = simplexml_load_file($config['site']['server_path'].'/data/XML/groups.xml') or die('<b>Could not load groups!</b>')) foreach($groups->group as $g) $groupList[(int)$g['id']] = $g['name']; $list = $SQL->query("SELECT `name`, `online`, `group_id`, `world_id` FROM `players` WHERE `group_id` > 1 ORDER BY `group_id` DESC"); $showed_players = 0; echo'<div class="bar"><center>Support in game</center></div><br/><br/><br/>'; $headline = '<table class="houses_list_box" border="0" cellspacing="1" cellpadding="0" width="100%"> <tr class="bar"><td width="30%"><font class=white><b>Group</b></font></td> <td width="35%"><font class=white><b>Name</b></font></td> <td width="15%"><font class=white><b>Status</b></font></td> <td width="20%"><font class=white><b>World</b></font></td>'; $group_id = 0; foreach($list as $gm) { if($group_id != (int)$gm['group_id']) { if($group_id != 0) echo'</table><br />'; echo $headline; $group_id = (int)$gm['group_id']; } echo'<tr class="over"><td>'.$groupList[(int)$gm['group_id']].'</td><td><a class="link" href="'.WEBSITE.'/index.php/character/view/'.$gm['name'].'">'.$gm['name'].'</a></td><td><font color="'.($gm['online'] == 0 ? 'red">Offline' : 'green">Online').'</font></td><td>'.$config['worlds'][$gm['world_id']].'</td></tr>'; } echo'</table>'; ?> <style type="text/css"> tr.over:hover { background-color: #FAFAD2; } .link {text-decoration: none;font-weight:bold;color:black;} .more { display: none;} </style>
Spell list and Banishment list?
@JoccE, will require access to the server files for the spells. But banishments are possible.