Well, I do belive that going for normal site path will be fineinsted of these "relative path" of yours
Thanks anyways for your great help
how do I add another?
?
?
Why do i get this error
/var/www/[COLOR="Red"][B]/[/B][/COLOR]cache/status
A Database Error Occurred
Error Number: 1054
Unknown column 'nameOriginal' in 'field list'
UPDATE `players` SET `name` = 'Gn xxx', `world_id` = '0', `group_id` = '1', `account_id` = '2', `level` = '8', `vocation` = '1', `health` = '185', `healthmax` = '185', `experience` = '4200', `lookbody` = '0', `lookfeet` = '0', `lookhead` = '0', `looklegs` = '0', `looktype` = '110', `lookaddons` = '0', `maglevel` = '0', `mana` = '35', `manamax` = '35', `manaspent` = '0', `soul` = '0', `town_id` = '1', `posx` = '1000', `posy` = '1000', `posz` = '7', `conditions` = '', `cap` = '440', `sex` = '1', `lastlogin` = '0', `lastip` = '0', `save` = '1', `skull` = '0', `skulltime` = '0', `rank_id` = '0', `guildnick` = '', `lastlogout` = '0', `blessings` = '0', `balance` = '0', `stamina` = '151200000', `direction` = '0', `loss_experience` = '100', `loss_mana` = '100', `loss_skills` = '100', `loss_containers` = '100', `loss_items` = '100', `premend` = '0', `online` = '0', `marriage` = '0', `promotion` = '0', `deleted` = '0', `description` = '', `old_name` = '', `hide_char` = '', `worldtransfer` = '', `created` = '1277224605', `nick_verify` = '', `comment` = '', `nameOriginal` = 'Gn xxx', `world_idOriginal` = '0', `group_idOriginal` = '1', `account_idOriginal` = '2', `levelOriginal` = '8', `vocationOriginal` = '1', `healthOriginal` = '185', `healthmaxOriginal` = '185', `experienceOriginal` = '4200', `lookbodyOriginal` = '0', `lookfeetOriginal` = '0', `lookheadOriginal` = '0', `looklegsOriginal` = '0', `looktypeOriginal` = '110', `lookaddonsOriginal` = '0', `maglevelOriginal` = '0', `manaOriginal` = '35', `manamaxOriginal` = '35', `manaspentOriginal` = '0', `soulOriginal` = '0', `town_idOriginal` = '1', `posxOriginal` = '1000', `posyOriginal` = '1000', `poszOriginal` = '7', `conditionsOriginal` = '', `capOriginal` = '440', `sexOriginal` = '1', `lastloginOriginal` = '0', `lastipOriginal` = '0', `saveOriginal` = '1', `skullOriginal` = '0', `skulltimeOriginal` = '0', `rank_idOriginal` = '0', `guildnickOriginal` = '', `lastlogoutOriginal` = '0', `blessingsOriginal` = '0', `balanceOriginal` = '0', `staminaOriginal` = '151200000', `directionOriginal` = '0', `loss_experienceOriginal` = '100', `loss_manaOriginal` = '100', `loss_skillsOriginal` = '100', `loss_containersOriginal` = '100', `loss_itemsOriginal` = '100', `premendOriginal` = '0', `onlineOriginal` = '0', `marriageOriginal` = '0', `promotionOriginal` = '0', `deletedOriginal` = '0', `descriptionOriginal` = '', `old_nameOriginal` = '', `hide_charOriginal` = '', `worldtransferOriginal` = '', `createdOriginal` = '1277224605', `nick_verifyOriginal` = '', `commentOriginal` = '' WHERE `id` = '20'<?php
//Script by Elf
//Made for Modern AAC by Paxton
require("config.php");
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = $ots->getDBHandle();
echo '<div style="text-align: center; font-weight: bold;">Top 30 frags on ' . $config['server_name'] . '</div>
<table border="0" cellspacing="1" cellpadding="4" width="100%">
<tr>
<td class="white" style="text-align: center; font-weight: bold;">Name</td>
<td class="white" style="text-align: center; font-weight: bold;">Frags</td>
</tr>';
$i = 0;
foreach($SQL->query('SELECT `p`.`name` AS `name`, COUNT(`p`.`name`) as `frags`
FROM `killers` k
LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
GROUP BY `name`
ORDER BY `frags` DESC, `name` ASC
LIMIT 0,30;') as $player)
{
$i++;
echo '<tr class="highlight">
<td><a href="'.WEBSITE.'/index.php/character/view/'.$player['name'].'"><center>' . $player['name'] . '</center></a></td>
<td><center>' . $player['frags'] . '</center></td>
</tr>';
}
echo '</table>';
?><?php
//Script by Elf
//Made for Modern AAC by Paxton
require("config.php");
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = [B][COLOR="Red"]>[/COLOR]$ots-[/B]getDBHandle();
echo '<div style="text-align: center; font-weight: bold;">Top 30 frags on ' . $config['server_name'] . '</div>
<table border="0" cellspacing="1" cellpadding="4" width="100%">
<tr>
<td class="white" style="text-align: center; font-weight: bold;">Name</td>
<td class="white" style="text-align: center; font-weight: bold;">Frags</td>
</tr>';
$i = 0;
[B][COLOR="Red"]>[/COLOR]foreach($SQL-query[/B]('SELECT `p`.`name` AS `name`, COUNT(`p`.`name`) as `frags`
FROM `killers` k
LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
GROUP BY `name`
ORDER BY `frags` DESC, `name` ASC
LIMIT 0,30;') as $player)
{
$i++;
echo '<tr class="highlight">
<td><a href="'.WEBSITE.'/index.php/character/view/'.$player['name'].'"><center>' . $player['name'] . '</center></a></td>
<td><center>' . $player['frags'] . '</center></td>
</tr>';
}
echo '</table>';
[B][COLOR="Red"]>[/COLOR]?[/B]