CreatureEvent deleted thread

Teckman · Sep 11, 2011

deleted thread

RoHaN-OTs · Sep 11, 2011

seems like another awesome release.. will try it

Darkinho · Sep 11, 2011

Can i use this to work only in specific arenas?

Evan · Sep 11, 2011

Isn't there a code for "onLook"? to see the ranks next to their level/vocation display?

KylerXX · Sep 11, 2011

Nice release teckman!
Simple and usefull, but can be more developed

!

Knight God · Sep 11, 2011

hey teckman plx visit:

http://otland.net/f132/need-mix-onlook-script-please-help-140131/

luigilc · Sep 11, 2011

that's another awesome release, will use it for sure!

Knight God · Sep 12, 2011

hey is possible add to my web site?

Name*****Frags*****Rank

here is my top fragers

PHP:

<?php
$main_content .= '<div style="text-align: center; font-weight: bold;">Top 30 Frags on ' . $config['server']['serverName'] . '</div>
<table border="0" cellspacing="1" cellpadding="4" width="100%">
	<tr bgcolor="' . $config['site']['vdarkborder'] . '">
		<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
	GROUP BY `name`
	ORDER BY `frags` DESC, `name` ASC
	LIMIT 0,30;') as $player)
{
	$i++;
	$main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']) . '">
		<td><a href="?subtopic=characters&name=' . urlencode($player['name']) . '">' . $player['name'] . '</a></td>
		<td style="text-align: center;">' . $player['frags'] . '</td>
	</tr>';
}

$main_content .= '</table>';
?>

KylerXX · Sep 13, 2011

@up:
Try this:

PHP:

<?php 
$getranks = array(
			5 => "Private First Class",
			10 => "Specialist",
			15 => "Corporal",
			20 => "Sergeant",
			25 => "Staff Sergeant",
			30 => "Sergeant First Class",
			35 => "Master Sergeant",
			40 => "First Sergeant",
			45 => "Sergeant Major",
			50 => "Command Sergeant Major",
			55 => "Sergeant Major of the Army",
			60 => "Second Lieutenant",
			65 => "First Lieutenant",
			70 => "Captain",
			75 => "Major",
			80 => "Lieutenant Colonel",
			90 => "Colonel",
			100 => "Brigadier General",
			115 => "Major General",
			120 => "Lieutenant General",
			140 => "General",
			170 => "General of the Army");
$storkey = 600;

$main_content .= '<div style="text-align: center; font-weight: bold;">Top 30 Frags on ' . $config['server']['serverName'] . '</div> 
<table border="0" cellspacing="1" cellpadding="4" width="100%"> 
    <tr bgcolor="' . $config['site']['vdarkborder'] . '"> 
        <td class="white" style="text-align: center; font-weight: bold;">Name</td> 
        <td class="white" style="text-align: center; font-weight: bold;">Frags</td> 
		 <td class="white" style="text-align: center; font-weight: bold;">Rank</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 
    GROUP BY `name` 
    ORDER BY `frags` DESC, `name` ASC 
    LIMIT 0,30;') as $player) 
{ 
    $i++; 
    $player_id = $player['id'];
    $playerStorageValue = $SQL->query('SELECT value FROM player_storage WHERE player_id='$player_id' AND key='$storkey'');   
    $getTitleRank = getranks[$playerStorageValue];  
    $main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']) . '"> 
        <td><a href="?subtopic=characters&name=' . urlencode($player['name']) . '">' . $player['name'] . '</a></td> 
        <td style="text-align: center;">' . $player['frags'] . '</td> 
		 <td style="text-align: center;">' . $getRankTitle . '</td> 
    </tr>'; 
} 

$main_content .= '</table>'; 
?>

Knight God · Sep 13, 2011

i will test

Knight God · Sep 13, 2011

Parse error: syntax error, unexpected T_VARIABLE in C:\xampp\htdocs\fragers.php on line 47

KylerXX · Sep 14, 2011

Change the: $playerStorageValue
to:

PHP:

$playerStorageValue = $SQL->query('SELECT `value` FROM `player_storage` WHERE `player_id` = ' . $player_id . ' AND `key` = ' . $storkey . '');

And try.

Darkinho · Sep 14, 2011

There's a way to mix with this http://otland.net/f82/mod-full-auto-war-teambattle-event-random-rewards-92825/ ?

Knight God · Sep 14, 2011

Parse error: syntax error, unexpected '[' in C:\xampp\htdocs\fragers.php on line 48

KylerXX · Sep 14, 2011

Afffff xd

PHP:

<?php 
$getranks = array(
            5 => "Private First Class",
            10 => "Specialist",
            15 => "Corporal",
            20 => "Sergeant",
            25 => "Staff Sergeant",
            30 => "Sergeant First Class",
            35 => "Master Sergeant",
            40 => "First Sergeant",
            45 => "Sergeant Major",
            50 => "Command Sergeant Major",
            55 => "Sergeant Major of the Army",
            60 => "Second Lieutenant",
            65 => "First Lieutenant",
            70 => "Captain",
            75 => "Major",
            80 => "Lieutenant Colonel",
            90 => "Colonel",
            100 => "Brigadier General",
            115 => "Major General",
            120 => "Lieutenant General",
            140 => "General",
            170 => "General of the Army");
$storkey = 600;

$main_content .= '<div style="text-align: center; font-weight: bold;">Top 30 Frags on ' . $config['server']['serverName'] . '</div> 
<table border="0" cellspacing="1" cellpadding="4" width="100%"> 
    <tr bgcolor="' . $config['site']['vdarkborder'] . '"> 
        <td class="white" style="text-align: center; font-weight: bold;">Name</td> 
        <td class="white" style="text-align: center; font-weight: bold;">Frags</td> 
         <td class="white" style="text-align: center; font-weight: bold;">Rank</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 
    GROUP BY `name` 
    ORDER BY `frags` DESC, `name` ASC 
    LIMIT 0,30;') as $player) 
{ 
    $i++; 
    $player_id = $player['id'];
    $playerStorageValue = $SQL->query('SELECT `value` FROM `player_storage` WHERE `player_id` = ' . $player_id . ' AND `key` = ' . $storkey . '');   
    $getTitleRank = $getranks[$playerStorageValue];  
    $main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']) . '"> 
        <td><a href="?subtopic=characters&name=' . urlencode($player['name']) . '">' . $player['name'] . '</a></td> 
        <td style="text-align: center;">' . $player['frags'] . '</td> 
         <td style="text-align: center;">' . $getTitleRank. '</td> 
    </tr>'; 
} 

$main_content .= '</table>'; 
?>

Knight God · Sep 14, 2011

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `key` = 600' at line 1' in C:\xampp\htdocs\fragers.php:47 Stack trace: #0 C:\xampp\htdocs\fragers.php(47): PDO->query('SELECT `value` ...') #1 C:\xampp\htdocs\index.php(452): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\fragers.php on line 47

perfection · Sep 14, 2011

ey there is a bug in this script gods and gms also have military ranks

i tried to fix it but im not so familiar with mods

Knight God · Sep 14, 2011

Bring
Up
My
Post

PLAX

Knight God · Sep 15, 2011

Knight God · Sep 16, 2011

KylerXX said:

Afffff xd

PHP:

<?php 
$getranks = array(
            5 => "Private First Class",
            10 => "Specialist",
            15 => "Corporal",
            20 => "Sergeant",
            25 => "Staff Sergeant",
            30 => "Sergeant First Class",
            35 => "Master Sergeant",
            40 => "First Sergeant",
            45 => "Sergeant Major",
            50 => "Command Sergeant Major",
            55 => "Sergeant Major of the Army",
            60 => "Second Lieutenant",
            65 => "First Lieutenant",
            70 => "Captain",
            75 => "Major",
            80 => "Lieutenant Colonel",
            90 => "Colonel",
            100 => "Brigadier General",
            115 => "Major General",
            120 => "Lieutenant General",
            140 => "General",
            170 => "General of the Army");
$storkey = 600;

$main_content .= '<div style="text-align: center; font-weight: bold;">Top 30 Frags on ' . $config['server']['serverName'] . '</div> 
<table border="0" cellspacing="1" cellpadding="4" width="100%"> 
    <tr bgcolor="' . $config['site']['vdarkborder'] . '"> 
        <td class="white" style="text-align: center; font-weight: bold;">Name</td> 
        <td class="white" style="text-align: center; font-weight: bold;">Frags</td> 
         <td class="white" style="text-align: center; font-weight: bold;">Rank</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 
    GROUP BY `name` 
    ORDER BY `frags` DESC, `name` ASC 
    LIMIT 0,30;') as $player) 
{ 
    $i++; 
    $player_id = $player['id'];
    $playerStorageValue = $SQL->query('SELECT `value` FROM `player_storage` WHERE `player_id` = ' . $player_id . ' AND `key` = ' . $storkey . '');   
    $getTitleRank = $getranks[$playerStorageValue];  
    $main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']) . '"> 
        <td><a rel="nofollow" href="?subtopic=characters&name=' . urlencode($player['name']) . '">' . $player['name'] . '</a></td> 
        <td style="text-align: center;">' . $player['frags'] . '</td> 
         <td style="text-align: center;">' . $getTitleRank. '</td> 
    </tr>'; 
} 

$main_content .= '</table>'; 
?>

Knight God said:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `key` = 600' at line 1' in C:\xampp\htdocs\fragers.php:47 Stack trace: #0 C:\xampp\htdocs\fragers.php(47): PDO->query('SELECT `value` ...') #1 C:\xampp\htdocs\index.php(452): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\fragers.php on line 47

sorry for no wait the time for bump please help me..

CreatureEvent deleted thread

Intermediate OT User

RoHaN-OTs.com

New Member

A splendid one to behold

Active Member

Member

Lua Learner

Member

Active Member

Member

Member

Active Member

New Member

Member

Active Member

Member

FATAL DAMAGE

Member

Member

Member

Similar threads