Tibia Tools http://www.tibiatools.pun.pl Tibia Tools pl http://backend.userland.com/rss Top Items Sms Shop http://www.tibiatools.pun.pl/viewtopic.php?pid=9#p9 9@http://www.tibiatools.pun.pl
W pliku shopsystem.php znajdujemy linkijkę:

Kod:

$main_content .= '<h2><center>Welcome to '.$config['server']['serverName'].' shop.</center></h2><center>';
Pod ni± dodajemy skrypt:

Kod:

$main_content .= '
<table cellspacing="1" cellpadding="4" align="center" style="border:0px; width:90%; text-align:center">
<tr BGCOLOR="'.$config['site']['vdarkborder'].'" class=white>
<td style="text-align:center" colspan=100><font color=gold><b>Top '.$config['site']['top'].' najchetniej kupowanych przedmiotow SMS</b></font></td>
</tr><tr bgcolor='.$bgcolor.'>';
$result = $SQL->query("SELECT * FROM `z_shop_offer` ORDER BY `pid`  DESC LIMIT ".$config['site']['top']."");
foreach($result as $rows) {     
if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; }
$number_of_rows++;
$main_content .= '<td BGCOLOR="'.$config['site']['darkborder'].'" width="20%"><img src=images/items/'.$rows['itemid1'].'.gif><br><font size=2><b>'.$rows['offer_name'].'</b><br>
</font></td>';}
Następnie szukamy:

Kod:

elseif($buy_offer['type'] == 'item')
{
Pod tym dodajemy

Kod:

$SQL->query('UPDATE `z_shop_offer` SET `pid` = pid + 1 WHERE `id` ='.$buy_offer['id'].';');
Pamiętajmy że w bazie danych w tabeli z_shop_offer powinien być wiersz pid

Na koniec w htdocs/config/config.php dodajemy linijkę

Kod:

$config['site']['top'] = 4;
Linijka ta odpowiada za ilo¶ć wy¶wietlanych itemów. Najlepsza ilo¶ć to od 4-6

Jeżeli co¶ nie działa pisać posty.]]> Pištek 19 PaÂździernik Pištek 19 PaÂździernik Most Powerful Guilds http://www.tibiatools.pun.pl/viewtopic.php?pid=8#p8 8@http://www.tibiatools.pun.pl

Kod:

$main_content .= '<div class="NewsHeadline">
    <div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)">
        <table border="0">
            <tr>
                <td style="text-align: center; font-weight: bold;">
                    <font color="white">Most powerfull guilds</font>
                </td>
            </tr>
        </table>
    </div>
</div>
<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>';
Tak to wygl±da:
http://img175.imageshack.us/img175/4744/whotomakethis.jpg]]> Niedziela 14 PaÂździernik Niedziela 14 PaÂździernik http://www.tibiatools.pun.pl/viewtopic.php?pid=7#p7 7@http://www.tibiatools.pun.pl

Kod:

<talkaction words="!firewalker" event="script" value="firewalker.lua"/>

Kod:

local config = {
    cost = 60000, -- Ile kosztuje naprawienie softow
    idsoft = 9933, -- ID softow
    idwornsoft = 10022 -- ID zepsutych softow    
    }
function onSay(cid, words, param)
local pos = getCreaturePosition(cid)
if getPlayerItemCount(cid, config.idwornsoft) >= 1 then
if getPlayerMoney(cid) >= config.cost then
doPlayerBuyItem(cid, config.idsoft, 1, config.cost, 1)
doPlayerRemoveItem(cid, config.idwornsoft, 1)
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Twoje Firewalker Boots Zostaly Naladowane.")
else
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Niemasz Kasy Na Naladowanie Soft Boots!")
end
else
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Niemasz Worn firewalker boots!")
end
return TRUE
end
]]> Niedziela 14 PaÂździernik Niedziela 14 PaÂździernik http://www.tibiatools.pun.pl/viewtopic.php?pid=6#p6 6@http://www.tibiatools.pun.pl

Kod:

<talkaction words="!soft" event="script" value="soft.lua"/>

Kod:

local config = {
    cost = 30000, -- Ile kosztuje naprawienie softow
    idsoft = 2640, -- ID softow
    idwornsoft = 10021 -- ID zepsutych softow    
    }
function onSay(cid, words, param)
local pos = getCreaturePosition(cid)
if getPlayerItemCount(cid, config.idwornsoft) >= 1 then
if getPlayerMoney(cid) >= config.cost then
doPlayerBuyItem(cid, config.idsoft, 1, config.cost, 1)
doPlayerRemoveItem(cid, config.idwornsoft, 1)
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Twoje Soft Boots Zostaly Naladowane.")
else
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Niemasz Kasy Na Naladowanie Soft Boots!")
end
else
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "Niemasz Worn Soft Boots!")
end
return TRUE
end
]]> Niedziela 14 PaÂździernik Niedziela 14 PaÂździernik http://www.tibiatools.pun.pl/viewtopic.php?pid=5#p5 5@http://www.tibiatools.pun.pl

Kod:

<talkaction words="!aol" event="script" value="aol.lua"/>
Skrypt:

Kod:

  function onSay(cid, words, param)
if getPlayerMoney(cid) >= 20000 then
    doPlayerRemoveMoney(cid,20000)
    doPlayerAddItem(cid,2173,1)
    doSendMagicEffect(getPlayerPosition(cid),12)
    doCreatureSay(cid, "Kupiles aol.", TALKTYPE_ORANGE_1)
else
doPlayerSendTextMessage(cid,MESSAGE_STATUS_CONSOLE_BLUE,"Nie masz kasy. Aol komenda: 2cc, u npc Eremo: 1cc.")
    doSendMagicEffect(getPlayerPosition(cid),2)
end
return TRUE
end
]]> Niedziela 14 PaÂździernik Niedziela 14 PaÂździernik Top Guilds http://www.tibiatools.pun.pl/viewtopic.php?pid=4#p4 4@http://www.tibiatools.pun.pl

Kod:

<?PHP
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD><font color=gold><B>Most Powerfulls Guilds</B></font></TD></TR></TABLE>
<table border="0" cellspacing="3" cellpadding="4" width="100%">
';

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, 100;') as $guild)

if ($guild['frags']>0)
{
$main_content .= '
<tr BGCOLOR="'.$config['site']['lightborder'].'"><td style="width: 25%; text-align: center;">
<a href="/?subtopic=guilds&action=show&guild=' . $guild['name'] . '">' . $guild['name'] . '<br><img src="/guilds/' . ((!empty($guild['logo']) && file_exists('guilds/' . $guild['logo'])) ? $guild['logo'] : 'default_logo.gif') . '" width="64" height="64" border="0"/></a>
</td><td><br />' . $guild['frags'] . ' Players kills</td> </tr>';}

$main_content .= '    
</table>';?>
]]> Niedziela 14 PaÂździernik Niedziela 14 PaÂździernik Top Fraggers http://www.tibiatools.pun.pl/viewtopic.php?pid=3#p3 3@http://www.tibiatools.pun.pl

Kod:

<?php

$main_content .= '<style>
.KL{background-color:none;}
.KL:hover{background-color:white;font-weight:bold;color:black;}
</style>

<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white colspan=100><B>Top 30 frags on ' . $config['server']['serverName'] . '</B></TD></TR>';

$i = 0;
foreach($SQL->query('SELECT description, `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++;

    $main_content .= '<tr BGCOLOR="'.$config['site']['lightborder'].'">
        <td width=1%>'.$i.'</td><td> <a href="?subtopic=characters&name=' . urlencode($player['name']) . '">' . $player['name'] . '</a></td>
        <td style="text-align: center;">' . $player['frags'] . ' players killed</td>
    </tr>';
}
$main_content .= '</table>';?>
]]> Niedziela 14 PaÂździernik Niedziela 14 PaÂździernik [Gesior Acc] Last joined, Free Houses and other! http://www.tibiatools.pun.pl/viewtopic.php?pid=2#p2 2@http://www.tibiatools.pun.pl

Kod:

$time = time();
Dodaj kod:

Kod:

/////////////////////////////////////////////////////////////////////////////////////////
//The new edition of my script: Best Player, Last joined and something new Server Motd.//
/////////////////////////Everything in the new appearance.///////////////////////////////
//////////////////////////////////////by  Aleh///////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////
///Queries ///
$query = $SQL->query('SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` DESC LIMIT 1;')->fetch();
$query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch();
$housesfree = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=0;')->fetch();
$housesrented = $SQL->query('SELECT COUNT(*) FROM `houses` WHERE `owner`=1;')->fetch();
$players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch();
$accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch();
$banned = $SQL->query('SELECT COUNT(*) FROM `bans` WHERE `id`>0;')->fetch();
$guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch();
///End Queries ///

    $main_content .= '<table bgcolor='.$config['site']['darkborder'].' border=0 cellpadding=4 cellspacing=1 width=100%>
    <tr bgcolor='. $config['site']['vdarkborder'] .'><td align="center" class=white colspan=1><b>Welcome to '.$config['server']['serverName'].'</b></td></tr>
    <tr><td><table border=0 cellpadding=1 cellspacing=1 width=100%>

    <tr bgcolor='. $config['site']['lightborder'] .'><td><center>Last joined us: <a href="?subtopic=characters&name='.urlencode($query2['name']).'">'.$query2['name'].'</a>, player number '.$query2['id'].'. Welcome and wish you a nice game!</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center>Currently, the best player on the server is: <a href="index.php?subtopic=characters&name='.urlencode($query['name']).'"> '.$query['name'].'</a> ('.urlencode($query['level']).'). Congratulations!</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Server motd:</b> '.$query['text'].'</center></td></tr> 
    <table border=0 cellpadding=0 cellspacing=1 width=100%>
      <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Free Houses:</b> '.$housesfree[0].'</center></td>
    <td><center><b>Rented Houses:</b> '.$housesrented[0].'</center></td></tr>      
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Accounts</b> in database: '.$accounts[0].'</center></td>
    <td><center><b>Players</b> in database: '.$players[0].'</center></td></tr>
    <tr bgcolor='. $config['site']['lightborder'] .'><td><center><b>Banned</b> accounts: '.$banned[0].'</center></td>
    <td><center><b>Guilds</b> in databese: '.$guilds[0].'</center></td></tr>

</table></td></tr></table>';

///Don't delete this! Please respect my work! I am counting on reputation.
$main_content .= '<div align="right"><small><b>Author of script: <a href="http://otland.net/members/aleh/">Aleh</a></b></small></div><br />';
///Don't delete this! Please respect my work! I am counting on reputation.
Tak wygl±daj± te statystyki pierwszej strony:
http://img176.imageshack.us/img176/414/30903493.png]]> Niedziela 14 PaÂździernik Niedziela 14 PaÂździernik