Aff, when people die don't recive his reward and the website doesn't works too. appears that in console:
Code:[05/09/2011 19:23:04] mysql_real_query(): SELECT * FROM `bounty_hunters` WHERE `sp_id` = 46 AND `killed` = 0; - MYSQL ERROR: Unknown column 'sp_id' in 'where clause' (1054) [05/09/2011 19:23:04] mysql_real_query(): INSERT INTO `bounty_hunters` VALUES (NULL,44,46,0,1315243384,10000,0,0); - MYSQL ERROR: Column count doesn't match value count at row 1 (1136)
i tried it but im getting target does not exit.
!bounty [10000], [Killme]
/bounty [10000], [Killme]
!hunt
how i put for same ip no get reward?
I configured the system to be run only by god!
for this i need put one protection for if hunted player killer your sef whit mc he no get reward!!!
now u understand ??
sry my inglish
im from brazil!
<?php
if(!defined('INITIALIZED'))
exit;
$main_content .= '<center><h2>Bounty Hunter</h2><br>Type !hunt [priceOnHead],[name] ingame to put a price on someones head.</center><br>';
$list = $SQL->query('SELECT * FROM `bounty_hunters` ORDER by `id` DESC');
echo '<table border="0" cellspacing="1" width="100%">
<tr bgcolor="'.$a.'"><td width="3%">#</td><td width="20%"><b>Hunted by</b></td><td width="15%" colspan="2"><b>Reward</b></td><td width="20%"><b>Hunted player</b></td><td width="20%"><b>Killed by</b></td></tr>';
$datalist = 0;
foreach($list as $data) {
if(is_int($datalist / 2))
$bgcolor = $b;
else
$bgcolor = $c;
$datalist++;
$huntedby = $SQL->query('SELECT * FROM `players` WHERE `id` = '.$data['fp_id'].'')->fetch();
$huntedplayer = $SQL->query('SELECT * FROM `players` WHERE `id` = '.$data['sp_id'].'')->fetch();
$killedby = $SQL->query('SELECT * FROM `players` WHERE `id` = '.$data['k_id'].'')->fetch();
if($killedby == 0) { $killedby['name'] = 'STILL ALIVE'; }
echo '<tr bgcolor="'.$bgcolor.'"><td><span style="font-size:11px;color:#a8a8a8;">'.$datalist.'</span></td><td><a href="?subtopic=characters&name='.strtolower($huntedby['name']).'"><span style="font-size:11px;">'.strtoupper($huntedby['name']).'</span></a></td><td><span style="font-size:11px;color:#909090;">'.$data['prize'].'</span></td><td><span style="font-size:11px;">GOLD</span></td><td><a href="?subtopic=characters&name='.strtolower($huntedplayer['name']).'"><span style="font-size:11px;">'.strtoupper($huntedplayer['name']).'</a></td><td><a href="?subtopic=characters&name='.strtolower($killedby['name']).'"><span style="font-size:11px;">'.strtoupper($killedby['name']).'</a></td></tr>';
}
echo '</table>';
?>
Here is the bountyhunter.php for GESIOR:
PHP:<?php if(!defined('INITIALIZED')) exit; $main_content .= '<center><h2>Bounty Hunter</h2><br>Type !hunt [priceOnHead],[name] ingame to put a price on someones head.</center><br>'; $list = $SQL->query('SELECT * FROM `bounty_hunters` ORDER by `id` DESC'); echo '<table border="0" cellspacing="1" width="100%"> <tr bgcolor="'.$a.'"><td width="3%">#</td><td width="20%"><b>Hunted by</b></td><td width="15%" colspan="2"><b>Reward</b></td><td width="20%"><b>Hunted player</b></td><td width="20%"><b>Killed by</b></td></tr>'; $datalist = 0; foreach($list as $data) { if(is_int($datalist / 2)) $bgcolor = $b; else $bgcolor = $c; $datalist++; $huntedby = $SQL->query('SELECT * FROM `players` WHERE `id` = '.$data['fp_id'].'')->fetch(); $huntedplayer = $SQL->query('SELECT * FROM `players` WHERE `id` = '.$data['sp_id'].'')->fetch(); $killedby = $SQL->query('SELECT * FROM `players` WHERE `id` = '.$data['k_id'].'')->fetch(); if($killedby == 0) { $killedby['name'] = 'STILL ALIVE'; } echo '<tr bgcolor="'.$bgcolor.'"><td><span style="font-size:11px;color:#a8a8a8;">'.$datalist.'</span></td><td><a rel="nofollow" href="?subtopic=characters&name='.strtolower($huntedby['name']).'"><span style="font-size:11px;">'.strtoupper($huntedby['name']).'</span></a></td><td><span style="font-size:11px;color:#909090;">'.$data['prize'].'</span></td><td><span style="font-size:11px;">GOLD</span></td><td><a rel="nofollow" href="?subtopic=characters&name='.strtolower($huntedplayer['name']).'"><span style="font-size:11px;">'.strtoupper($huntedplayer['name']).'</a></td><td><a rel="nofollow" href="?subtopic=characters&name='.strtolower($killedby['name']).'"><span style="font-size:11px;">'.strtoupper($killedby['name']).'</a></td></tr>'; } echo '</table>'; ?>
Here you go!
not work for me, you help me?
Blank page
Anyone got the sqlite queery for this?
CREATE TABLE IF NOT EXISTS `bounty_hunters` (
`id` int(11) NOT NULL,
`fp_id` int(11) NOT NULL,
`sp_id` int(11) NOT NULL,
`k_id` int(11) NOT NULL,
`added` int(15) NOT NULL,
`prize` bigint(20) NOT NULL,
`killed` int(11) NOT NULL,
`kill_time` int(15) NOT NULL,
PRIMARY KEY (`id`)
)