• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Fragi Guild zbugowane - Scrypt

Reins

Reins

Member
Joined
Apr 9, 2009
Messages
586
Reaction score
8
Otóż posiadam taki scrypt na top 5 guild w latestnews

Code: 
<table border="0" cellspacing="3" cellpadding="4" width="100%">
    <tr>';

foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
    `g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`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`
    LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
    LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
    GROUP BY `name`
    ORDER BY `frags` DESC, `name` ASC
    LIMIT 0, 4;') as $guild)
    $main_content .= '        <td style="width: 25%; text-align: center;">
            <a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '"><img src="guilds/' . ((!empty($guild['logo']) && file_exists('guilds/' . $guild['logo'])) ? $guild['logo'] : 'default_logo.gif') . '" width="64" height="64" border="0"/><br />' . $guild['name'] . '</a><br />' . $guild['frags'] . ' kills
        </td>';

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

Chodzi mi o to, aby fragi nie były usuwane jeżeli ktoś użyje Remove RS, znalazłem fixa na zwykłe fragi dla graczy, ale nie mogę nic znaleźć dla guild.

Posiada ktoś taki script ?
 
Reins said:
Otóż posiadam taki scrypt na top 5 guild w latestnews

Code: 
<table border="0" cellspacing="3" cellpadding="4" width="100%">
    <tr>';

foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
    `g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`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`
    LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
    LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
    GROUP BY `name`
    ORDER BY `frags` DESC, `name` ASC
    LIMIT 0, 4;') as $guild)
    $main_content .= '        <td style="width: 25%; text-align: center;">
            <a rel="nofollow" href="?subtopic=guilds&amp;action=show&amp;guild=' . $guild['id'] . '"><img src="guilds/' . ((!empty($guild['logo']) && file_exists('guilds/' . $guild['logo'])) ? $guild['logo'] : 'default_logo.gif') . '" width="64" height="64" border="0"/><br />' . $guild['name'] . '</a><br />' . $guild['frags'] . ' kills
        </td>';

$main_content .= '    </tr>
</table>';
Chodzi mi o to, aby fragi nie były usuwane jeżeli ktoś użyje Remove RS, znalazłem fixa na zwykłe fragi dla graczy, ale nie mogę nic znaleźć dla guild.

Posiada ktoś taki script ?
Click to expand...

Ustaw unjust 0

Sammi said:
Ustaw unjust 0
Click to expand...

WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
Click to expand...
Chyba tak:

WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 0
Click to expand...
Sry, za double post, przypadek.
 
Last edited by a moderator:
Texon tak tak 4 mam ;)

Zrobione, chodziło mi o ten efekt

Code: 
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1

na

Code: 
WHERE `k`.`unjustified` = 0 AND `k`.`final_hit` = 1
 
Back
Top