tyuahoi

Sabe aquele negocio chato de quando vc tem que mudar level ou editar algum char que voçê tem que ir no phpmyadmin etc?
poisé isso acabou! :b
 
 
Crie uma pasta em C:\xampp\htdocs
 
com o nome: adminpro.php
 
e cole isso:

<?PHP //README: if nick contain "'" use "\'". For example: nick = The'Knight so use in the form The\'Knight ,,,-WORKS! if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) { $main_content .= 'Welcome to advanced admin panel! Mainly you can edit players. Coded by <a href="http://otland.net/members/turs0n/">turson</a>'; //admin panel menu (player+account) $main_content .= '<br /><br /><div style="width:100%;border:1px solid #c6c6c6;padding:3px 0 3px 0"> <b>EDIT PLAYER -></b> <a href="?subtopic=admin&action=namelock">Name</a> | <a href="?subtopic=admin&action=exp">Experience</a> | <a href="?subtopic=admin&action=level">Level</a> | <a href="?subtopic=admin&action=others">Others</a> | <a href="?subtopic=admin&action=position">Position</a> | <a href="?subtopic=admin&action=delete">Delete</a> <br> <b>EDIT ACCOUNT -></b> <a href="?subtopic=admin&action=acc">Account Number</a> | <a href="?subtopic=admin&action=pass">Password</a> | <a href="?subtopic=admin&action=mail">E-mail</a> | <a href="?subtopic=admin&action=access">Access</a> <br><center><font color="red"><b>PLAYER MUST BE OFFLINE!</b></font></center> </div><br>'; /////////////////////////////////CHARACTER//////////////////////////////////// //namelock if (isset($_POST['ok1'])){ $SQL->query("UPDATE `players` SET `name` = ".$SQL->quote( $_POST['newname'] )." WHERE name = ".$SQL->quote( $_POST['name0'] ).";"); $main_content .= "Player name has been changed.";} //exp if (isset($_POST['ok2'])){ $SQL->query("UPDATE `players` SET experience = experience + ".$SQL->quote( $_POST['exp'] )." WHERE name = ".$SQL->quote( $_POST['name1'] ).";"); $main_content .= "Experience has been added.";} //level if (isset($_POST['ok3'])){ $SQL->query("UPDATE `players` SET level = ".$SQL->quote( $_POST['level'] )." WHERE name = ".$SQL->quote( $_POST['name2'] ).";"); $main_content .= "Level has been set.";} //others if (isset($_POST['ok4'])){ $SQL->query("UPDATE `players` SET health=".$SQL->quote( $_POST['health'] ).",healthmax=".$SQL->quote( $_POST['health'] ).",mana=".$SQL->quote( $_POST['mana'] ).",manamax=".$SQL->quote( $_POST['mana'] ).",cap=".$SQL->quote( $_POST['cap'] ).",maglevel=".$SQL->quote( $_POST['maglevel'] )." WHERE name = ".$SQL->quote( $_POST['name3'] ).";"); $main_content .= "Informations has been changed.";} //delete if (isset($_POST['ok5'])){ $SQL->query("DELETE from `players` WHERE name = ".$SQL->quote( $_POST['name4'] ).";"); $main_content .= "Character has beed deleted.";} //pos if (isset($_POST['ok10'])){ $SQL->query("UPDATE `players` SET group_id = ".$SQL->quote( $_POST['newpos'] )." WHERE name = ".$SQL->quote( $_POST['name9'] ).";"); $main_content .= "Player position has been changed.";} /////////////////////////////////////////ACCOUNT/////////////////////////////////////// //acc if (isset($_POST['ok6'])){ $SQL->query("UPDATE `accounts` INNER JOIN `players` ON `accounts`.`id` = `players`.`account_id` SET accounts.name=".$SQL->quote( $_POST['newacc'] )." WHERE players.name = ".$SQL->quote( $_POST['name5'] ).";"); $main_content .= "Account number has beed changed.";} //password if (isset($_POST['ok7'])){ $SQL->query("UPDATE `accounts` INNER JOIN `players` ON `accounts`.`id` = `players`.`account_id` SET accounts.password=".$SQL->quote( $_POST['newpass'] )." WHERE players.name = ".$SQL->quote( $_POST['name6'] ).";"); $main_content .= "Password has beed changed.";} //mail if (isset($_POST['ok8'])){ $SQL->query("UPDATE `accounts` INNER JOIN `players` ON `accounts`.`id` = `players`.`account_id` SET accounts.email=".$SQL->quote( $_POST['newmail'] )." WHERE players.name = ".$SQL->quote( $_POST['name7'] ).";"); $main_content .= "E-Mail adress has beed changed.";} //mail if (isset($_POST['ok9'])){ $SQL->query("UPDATE `accounts` INNER JOIN `players` ON `accounts`.`id` = `players`.`account_id` SET accounts.page_access=".$SQL->quote( $_POST['newaccess'] )." WHERE players.name = ".$SQL->quote( $_POST['name8'] ).";"); $main_content .= "Page access has beed changed.";} ////////////CHARACTER FORM/////////// //namelock form if($_GET["action"]=="namelock"){ $main_content .= '<form action="?subtopic=admin" method="post"> New Player Name <input type="text" name="newname"><br> Old Player Name <input type="text" name="name0"><br><input type="submit" value="OK" name="ok1"></form>';} //exp form if($_GET["action"]=="exp"){ $main_content .= '<form action="?subtopic=admin" method="post"> Add experience <input type="text" name="exp"> (only numbers)<br> Player Name <input type="text" name="name1"><br><input type="submit" value="OK" name="ok2"></form>';} //level form if($_GET["action"]=="level"){ $main_content .= '<form action="?subtopic=admin" method="post"> Set player level <input type="text" name="level"> (only numbers)<br> Player Name <input type="text" name="name2"><br><input type="submit" value="OK" name="ok3"></form>';} //others form if($_GET["action"]=="others"){ $main_content .= '<form action="?subtopic=admin" method="post"> Health <input type="text" name="health"> (only numbers)<br> Mana <input type="text" name="mana"> (only numbers)<br> Cap <input type="text" name="cap"> (only numbers)<br> MagLevel <input type="text" name="maglevel"> (only numbers)<br> Player Name <input type="text" name="name3"><br><input type="submit" value="OK" name="ok4"></form>';} //delete form if($_GET["action"]=="delete"){ $main_content .= '<form action="?subtopic=admin" method="post"> Player Name <input type="text" name="name4"><br><b>ARE YOU SURE?</b> <input type="submit" value="YES" name="ok5"></form>';} //pos form if($_GET["action"]=="position"){ $main_content .= '<form action="?subtopic=admin" method="post"> Position <input type="text" name="newpos"><i>example(1-player,2-tutor,3-senior tutor,4-gamemaster,5-community manager,6-god)</i> <br> Player Name <input type="text" name="name9"><br><input type="submit" value="OK" name="ok10"></form>';} /////////////ACCOUNT FORM//////////////// //account number form if($_GET["action"]=="acc"){ $main_content .= '<form action="?subtopic=admin" method="post"> New account number <input type="text" name="newacc"> <br> Player Name <input type="text" name="name5"><br><input type="submit" value="OK" name="ok6"></form>';} //password form if($_GET["action"]=="pass"){ $main_content .= '<form action="?subtopic=admin" method="post"> New password <input type="text" name="newpass"> <br> Player Name <input type="text" name="name6"><br><input type="submit" value="OK" name="ok7"></form>';} //mail form if($_GET["action"]=="mail"){ $main_content .= '<form action="?subtopic=admin" method="post"> New e-mail adress <input type="text" name="newmail"> <br> Player Name <input type="text" name="name7"><br><input type="submit" value="OK" name="ok8"></form>';} //access form if($_GET["action"]=="access"){ $main_content .= '<form action="?subtopic=admin" method="post"> Page access <input type="text" name="newaccess">(3->admin) <br> Player Name <input type="text" name="name8"><br><input type="submit" value="OK" name="ok9"></form>';} } else $main_content .= "You don't have required access!"; ?>
 
Salve e feixe.
 
 
Agora va em: index.php
 
Após
 

case "adminpanel": $topic = "Admin Panel"; $subtopic = "adminpanel"; include("adminpanel.php"); break;
 
Cole isso:
 

case "admin"; $subtopic = "admin"; $topic = "Advanced Admin Panel"; include("adminpro.php"); break;
 
Salve e feixe.
 
Agora va em C:\xampp\htdocs\layouts\tibiacom
 
abra o layout.php
 
após:
 

<a href='?subtopic=createaccount'> <div id='submenu_createaccount' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'> <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> <div id='ActiveSubmenuItemIcon_createaccount' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div> <div class='SubmenuitemLabel'>Create Account</div> <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> </div> </a>
 
Cole isso:
 

<a href='?subtopic=admin'> <div id='submenu_adminpanel' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'> <div class='LeftChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div> <div id='ActiveSubmenuItemIcon_adminpanel' class='ActiveSubmenuItemIcon' style='background-image:url(".$layout_name."/images/menu/icon-activesubmenu.gif);'></div> <div class='SubmenuitemLabel'><font color=\"blue\">~<u>Admin PRO</u>~</font></div> <div class='RightChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div> </div>
 
Ficaram assim:
 

 
 
e sejam felizes :b
 
 
Crédito: turson
 
 
obs: Não se preocupem apenas o admin do site conseiguira acessar esta pagina ;p

Olá
 
Após 3 Tentativas d autorizaçao para postar o script em outro forum, o Dono Me Autorizou POSAKPDKPSAKD
 
1. Estatisticas Do Servidor. (Ultimo Char Criado, Top Etc.)
 
Abra O: latestnews.php
E procure pela linha: $time = time(); ( Normalmente Bem No Começo)
 
adicione isso logo abaixo:
 

///////////////////////////////////////////////////////////////////////////////////////// //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.
 
 
Pronto.
CrEdItOs.
 
 

Aleh
 
 
2. Best Guild.
 
 
Faça Um Novo Arquivo com o nome frags.php em: C:\xampp\htdocs
 
Cole Isso Dentro:
 

<?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 AND `k`.`final_hit` = 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>'; ?>
 
agora va em: latestnews
 
e adicione isso:
 

$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>';
 
 
Ta ae.
 
 
Bom Uso.

Olá
 
 
Vim Trazer Um Script Para Ficar Mais Agradavel o Seu Site.
 
 
 
1º Efeito De Texto Ficar Ao Redor Da Seta Do seu Mouse.
 
Basta adicionar isso em seu <head> da layout.php
 
 

<style type="text/css"> /* Circle Text Styles */ #outerCircleText { /* Optional - DO NOT SET FONT-SIZE HERE, SET IT IN THE SCRIPT */ font-style: italic; font-weight: bold; font-family: 'comic sans ms', verdana, arial; color: #000; /* End Optional */ /* Start Required - Do Not Edit */ position: absolute;top: 0;left: 0;z-index: 3000;cursor: default;} #outerCircleText div {position: relative;} #outerCircleText div div {position: absolute;top: 0;left: 0;text-align: center;} /* End Required */ /* End Circle Text Styles */ </style> <script type="text/javascript"> /* Circling text trail- Tim Tilton Website: http://www.tempermedia.com/ Visit: http://www.dynamicdrive.com/ for Original Source and tons of scripts Modified Here for more flexibility and modern browser support Modifications as first seen in http://www.dynamicdrive.com/forums/ username:jscheuer1 - This notice must remain for legal use */ ;(function(){ // Your message here (QUOTED STRING) var msg = "Real Server!"; /* THE REST OF THE EDITABLE VALUES BELOW ARE ALL UNQUOTED NUMBERS */ // Set font's style size for calculating dimensions // Set to number of desired pixels font size (decimal and negative numbers not allowed) var size = 24; // Set both to 1 for plain circle, set one of them to 2 for oval // Other numbers & decimals can have interesting effects, keep these low (0 to 3) var circleY = 0.75; var circleX = 2; // The larger this divisor, the smaller the spaces between letters // (decimals allowed, not negative numbers) var letter_spacing = 5; // The larger this multiplier, the bigger the circle/oval // (decimals allowed, not negative numbers, some rounding is applied) var diameter = 10; // Rotation speed, set it negative if you want it to spin clockwise (decimals allowed) var rotation = 0.4; // This is not the rotation speed, its the reaction speed, keep low! // Set this to 1 or a decimal less than one (decimals allowed, not negative numbers) var speed = 0.3; ////////////////////// Stop Editing ////////////////////// if (!window.addEventListener && !window.attachEvent || !document.createElement) return; msg = msg.split(''); var n = msg.length - 1, a = Math.round(size * diameter * 0.208333), currStep = 20, ymouse = a * circleY + 20, xmouse = a * circleX + 20, y = [], x = [], Y = [], X = [], o = document.createElement('div'), oi = document.createElement('div'), b = document.compatMode && document.compatMode != "BackCompat"? document.documentElement : document.body, mouse = function(e){ e = e || window.event; ymouse = !isNaN(e.pageY)? e.pageY : e.clientY; // y-position xmouse = !isNaN(e.pageX)? e.pageX : e.clientX; // x-position }, makecircle = function(){ // rotation/positioning if(init.nopy){ o.style.top = (b || document.body).scrollTop + 'px'; o.style.left = (b || document.body).scrollLeft + 'px'; }; currStep -= rotation; for (var d, i = n; i > -1; --i){ // makes the circle d = document.getElementById('iemsg' + i).style; d.top = Math.round(y[i] + a * Math.sin((currStep + i) / letter_spacing) * circleY - 15) + 'px'; d.left = Math.round(x[i] + a * Math.cos((currStep + i) / letter_spacing) * circleX) + 'px'; }; }, drag = function(){ // makes the resistance y[0] = Y[0] += (ymouse - Y[0]) * speed; x[0] = X[0] += (xmouse - 20 - X[0]) * speed; for (var i = n; i > 0; --i){ y[i] = Y[i] += (y[i-1] - Y[i]) * speed; x[i] = X[i] += (x[i-1] - X[i]) * speed; }; makecircle(); }, init = function(){ // appends message divs, & sets initial values for positioning arrays if(!isNaN(window.pageYOffset)){ ymouse += window.pageYOffset; xmouse += window.pageXOffset; } else init.nopy = true; for (var d, i = n; i > -1; --i){ d = document.createElement('div'); d.id = 'iemsg' + i; d.style.height = d.style.width = a + 'px'; d.appendChild(document.createTextNode(msg[i])); oi.appendChild(d); y[i] = x[i] = Y[i] = X[i] = 0; }; o.appendChild(oi); document.body.appendChild(o); setInterval(drag, 25); }, ascroll = function(){ ymouse += window.pageYOffset; xmouse += window.pageXOffset; window.removeEventListener('scroll', ascroll, false); }; o.id = 'outerCircleText'; o.style.fontSize = size + 'px'; if (window.addEventListener){ window.addEventListener('load', init, false); document.addEventListener('mouseover', mouse, false); document.addEventListener('mousemove', mouse, false); if (/Apple/.test(navigator.vendor)) window.addEventListener('scroll', ascroll, false); } else if (window.attachEvent){ window.attachEvent('onload', init); document.attachEvent('onmousemove', mouse); }; })(); </script>
 
Aonde Esta Escrito Real Server Voçe Muda Para A Mensagem Que Voçe Quiser.
 
Imagem De Como Ira Ficar.
 

 
Simples Mais Util.
 
2º Efeito De Neve Em Seu Web Site
 
Acresente Isso Em layout.php
 

<script type="text/javascript"> /* Snow Fall 1 - no images - Java Script Visit http://rainbow.arch.scriptmania.com/scripts/ for this script and many more */ // Set the number of snowflakes (more than 30 - 40 not recommended) var snowmax=35 // Set the colors for the snow. Add as many colors as you like var snowcolor=new Array("#AAAACC","#DDDDFF","#CCCCDD","#F3F3F3","#F0FFFF") // Set the fonts, that create the snowflakes. Add as many fonts as you like var snowtype=new Array("Arial Black","Arial Narrow","Times","Comic Sans MS") // Set the letter that creates your snowflake (recommended: * ) var snowletter="*" // Set the speed of sinking (recommended values range from 0.3 to 2) var sinkspeed=0.6 // Set the maximum-size of your snowflakes var snowmaxsize=22 // Set the minimal-size of your snowflakes var snowminsize=8 // Set the snowing-zone // Set 1 for all-over-snowing, set 2 for left-side-snowing // Set 3 for center-snowing, set 4 for right-side-snowing var snowingzone=1 /* // * NO CONFIGURATION BELOW HERE * */ // Do not edit below this line var snow=new Array() var marginbottom var marginright var timer var i_snow=0 var x_mv=new Array(); var crds=new Array(); var lftrght=new Array(); var browserinfos=navigator.userAgent var ie5=document.all&&document.getElementById&&!browserinfos.match(/Opera/) var ns6=document.getElementById&&!document.all var opera=browserinfos.match(/Opera/) var browserok=ie5||ns6||opera function randommaker(range) { rand=Math.floor(range*Math.random()) return rand } function initsnow() { if (ie5 || opera) { marginbottom = document.body.clientHeight marginright = document.body.clientWidth } else if (ns6) { marginbottom = window.innerHeight marginright = window.innerWidth } var snowsizerange=snowmaxsize-snowminsize for (i=0;i<=snowmax;i++) { crds[i] = 0; lftrght[i] = Math.random()*15; x_mv[i] = 0.03 + Math.random()/10; snow[i]=document.getElementById("s"+i) snow[i].style.fontFamily=snowtype[randommaker(snowtype.length)] snow[i].size=randommaker(snowsizerange)+snowminsize snow[i].style.fontSize=snow[i].size snow[i].style.color=snowcolor[randommaker(snowcolor.length)] snow[i].sink=sinkspeed*snow[i].size/5 if (snowingzone==1) {snow[i].posx=randommaker(marginright-snow[i].size)} if (snowingzone==2) {snow[i].posx=randommaker(marginright/2-snow[i].size)} if (snowingzone==3) {snow[i].posx=randommaker(marginright/2-snow[i].size)+marginright/4} if (snowingzone==4) {snow[i].posx=randommaker(marginright/2-snow[i].size)+marginright/2} snow[i].posy=randommaker(2*marginbottom-marginbottom-2*snow[i].size) snow[i].style.left=snow[i].posx snow[i].style.top=snow[i].posy } movesnow() } function movesnow() { for (i=0;i<=snowmax;i++) { crds[i] += x_mv[i]; snow[i].posy+=snow[i].sink snow[i].style.left=snow[i].posx+lftrght[i]*Math.sin(crds[i]); snow[i].style.top=snow[i].posy if (snow[i].posy>=marginbottom-2*snow[i].size || parseInt(snow[i].style.left)>(marginright-3*lftrght[i])){ if (snowingzone==1) {snow[i].posx=randommaker(marginright-snow[i].size)} if (snowingzone==2) {snow[i].posx=randommaker(marginright/2-snow[i].size)} if (snowingzone==3) {snow[i].posx=randommaker(marginright/2-snow[i].size)+marginright/4} if (snowingzone==4) {snow[i].posx=randommaker(marginright/2-snow[i].size)+marginright/2} snow[i].posy=0 } } var timer=setTimeout("movesnow()",50) } for (i=0;i<=snowmax;i++) { document.write("<span id='s"+i+"' style='position:absolute;top:-"+snowmaxsize+"'>"+snowletter+"</span>") } if (browserok) { window.onload=initsnow } </SCRIPT>
 
Imagem De Como Ira Ficar.

 
 
Simples Mais Util.

Olá xtibianos, vim trazer um script que acredito eu seja um pouco útil e facilite a vida de algumas pessoas...
 
Bom o script é simples você tem total controle sobre seu servidor pelo site, exemplo: você pode fechar ele, abrir, reiniciar tudo através do site do servidor.
 
bom vamos ao que interessa
 
na pasta htdocs do seu site faça um arquivo .php chamado restarter e cole isso:
 

<?PHP $path = $config['site']['server_path']; $exename = "NOME DO EXECUTAVEL.exe"; if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) { if($action == "") { $main_content .= '<table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><font color="red"><b>Option</b></font></td><td><font color="red"><b>Description</b></font></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=restart">Reiniciar</a></b></td><td><b>Fechar o servidor e abri-lo novamente</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=restarter&action=kill">Fechar Servidor</a></b></td><td><b>Fechar todos os processos do servidor imediatamente</b></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=start">Iniciar Servidor</a></b></td><td><b>iniciar servidor</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=restarter&action=shutdown">Fechar o servidor</a></b></td><td><b>Fecha o servidor após 5 minutos</b></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=shutdownlong">avisar os players do fechamento do servidor</a></b></td><td><b>Performs safe shutdown after broadcast warning and 5 minutes delay.</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=adminpanel">Back to admin panel</a></b></td><td><b>Go back to admin panel.</b></td></tr> </table>'; } getcwd(); chdir($path); if($action == "restart") { exec('TASKKILL /F /IM "'.$exename.'"'); $command = 'START/HIGH '.$exename; $tmpnam = "temp.bat"; $fp = fopen ($tmpnam, "w"); fwrite($fp, $command); fclose ($fp); $foo = @popen($tmpnam, 'r'); $main_content .='<center>Server restarted.<br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "kill"){exec('TASKKILL /F /IM "'.$exename.'"'); $main_content .='<center>Server closed.<br><b><a href="?subtopic=restarter">Back</a></center>';} if($action == "start") { $command = 'START/HIGH '.$exename; $tmpnam = "temp.bat"; $fp = fopen ($tmpnam, "w"); fwrite($fp, $command); fclose ($fp); $foo = @popen($tmpnam, 'r'); $main_content .='<center>Server started. <br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "shutdown") { $SQL->query('UPDATE '.$SQL->tableName('z_shut').' SET `shutdown`="1", `long`="0" WHERE id = "1";'); $main_content .='<center>Server will shut down soon. <br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "shutdownlong") { $SQL->query('UPDATE '.$SQL->tableName('z_shut').' SET `shutdown`="1", `long`="1" WHERE `id` = "1";'); $main_content .='<center>Server will shut down soon. <br><b><a href="?subtopic=restarter">Back</a></center>'; } } else { $title = $GLOBALS['config']['server']["serverName"]." - OTS"; $main_content .= 'Invalid subtopic. Can\'t load page.'; } ?>
 
Não esqueçam de colocar o nome do executável do servidor na 3º linha!
 
agora vá em index.php e adicione:
 
 

case "restarter": $topic = "Restarter"; $subtopic = "restarter"; include("restarter.php"); break;
 
 
Antes de:
 
 

case "latestnews": $topic = "Latest News"; $subtopic = "latestnews"; include("latestnews.php"); break;
 
Agora em adminpanel.php adicione:
 
<tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter">Restarter</a></b></td><td><b>Here you start, stop and restart server!</b></td></tr>  
 
Antes de
</table>  
Agora na sua database execute isso:
 

CREATE TABLE IF NOT EXISTS `z_shut` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shutdown` int(11) NOT NULL DEFAULT '1', `long` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; INSERT INTO `z_shut` (`id`, `shutdown`, `long`) VALUES (1, 0, 1);
 
agora na pasta do seu servidor vá em data\globalevents\scripts faça um novo arquivo .lua com o nome de restarter e cole isso:
 

local message = { "Server will shut down in 5 minutes. Dont ask me why, I'm only script", "Server will shutdown in 2 minutes, please log off", "Server is going down..." } local class = 21 function shutDown() doBroadcastMessage(message[3], class) doSetGameState(GAMESTATE_SHUTDOWN) return TRUE end function broadcast() doBroadcastMessage(message[2], class) return TRUE end function onThink(interval, lastExecution) local result_plr = db.getResult("SELECT * FROM z_shut WHERE `id` = 1;") if(result_plr:getID() ~= -1) then while(true) do if(tonumber(result_plr:getDataInt("shutdown"))==1) then db.executeQuery("UPDATE z_shut SET shutdown = '0' WHERE id = '1';") if(tonumber(result_plr:getDataInt("long"))==0) then doBroadcastMessage(message[3], class) doSetGameState(GAMESTATE_SHUTDOWN) else doBroadcastMessage(message[1], class) addEvent(broadcast, 3*60*1000, {}) addEvent(shutDown, 5*60*1000, {}) end end if not(result_plr:next()) then break end end end result_plr:free() return TRUE end
 
e por fim em globalevents.xml adicione:
 
<globalevent name="safe_shutdown" interval="5" event="script" value="restarter.lua"/>  
 
Sinceramente espero que seja útil para vocês isso, duvidas podem postar que estarei ajudando...

Olá
 
 
Script para Quem Quiser Deixar Seu Site Com O Kill Statistics Igual O Da CipSoft.
 
Va Em:
C:\xampp\htdocs
 
Faça Um Novo Arquivo Com O Nome: Kill.lua
 
E Cole Isso:

<?PHP //CONFIG $mysql_user = "root"; $mysql_pass = "sexyloves2"; $mysql_database = "sexylove"; $mysql_host = "localhost"; //END OF CONFIG $numberlist = 0; $timenow = time(); $dayago = $timenow - 86400; $weekago = $timenow - (86400 * 7); mysql_connect($mysql_host,$mysql_user,$mysql_pass) or die ("Could not connect to a MySQL server"); mysql_select_db($mysql_database); $deaths_data = mysql_query('SELECT name FROM environment_killers;'); $data1 = mysql_fetch_assoc($deaths_data); $x = 100; $x1 = $x/6; $x2 = $x/3; $main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'> <TD CLASS=red width="'.$x2.'%"></TD><TD CLASS=red width="'.$x2.'%" colspan=2><B><font color="'.$config['site']['lightborder'].'">Last Day</B></TD><TD CLASS=red width="'.$x2.'%" colspan=2><B><font color="'.$config['site']['lightborder'].'">This Week</B></TD></TR>'; $main_content .= '<TR BGCOLOR='.$config['site']['vdarkborder'].'> <TD><B><font color="'.$config['site']['lightborder'].'">Race</B></TD><TD><B><font color="'.$config['site']['lightborder'].'">Killed Players</B></TD><TD><B><font color="'.$config['site']['lightborder'].'">Killed by Players</B></TD><TD><B><font color="'.$config['site']['lightborder'].'">Killed Players</B></TD><TD><B><font color="'.$config['site']['lightborder'].'">Killed by Players</B></TD></TR>'; $delete_old = $SQL->query('SELECT * FROM killed_monsters where date < '.$weekago.';'); if(!empty($delete_old)) { foreach($delete_old as $del) { $old = $del['date']; if ($old < $weekago) { mysql_query('DELETE FROM `killed_monsters` WHERE id = '.$del['id'].';'); } } } if(!empty($deaths_data)) $available_monsters = $SQL->query('SELECT name FROM z_monsters GROUP by name;'); { foreach($available_monsters as $monstrums) { /* Killed Players By Monsters Daily */ $killers_monsters = mysql_query('SELECT COUNT(name) as liczba FROM environment_killers,player_deaths,killers where player_deaths.id = killers.death_id and killers.id = environment_killers.kill_id and name LIKE "%'.$monstrums[name].'" and date > '.$dayago.';'); $count1 = mysql_fetch_assoc($killers_monsters); $count = $count1['liczba']; /* Killed Players By Monsters Weekly */ $killers_monsters1 = mysql_query('SELECT COUNT(name) as liczba FROM environment_killers,player_deaths,killers where player_deaths.id = killers.death_id and killers.id = environment_killers.kill_id and name LIKE "%'.$monstrums[name].'" and date > '.$weekago.';'); $count3 = mysql_fetch_assoc($killers_monsters1); $count2 = $count3['liczba']; /* Killed Monsters By Players Weekly */ $player_killers = mysql_query('SELECT COUNT(name) as liczba FROM killed_monsters where name LIKE "%'.$monstrums[name].'" and date > '.$weekago.';'); $count5 = mysql_fetch_assoc($player_killers); $count4 = $count5['liczba']; /* Killed Monsters By Players Daily */ $player_killers1 = mysql_query('SELECT COUNT(name) as liczba FROM killed_monsters where name LIKE "%'.$monstrums[name].'" and date > '.$dayago.';'); $count7 = mysql_fetch_assoc($player_killers1); $count6 = $count7['liczba']; $displayday_kp = 0; $displayweek_kp = 0; $displayday_pk = 0; $displayweek_pk = 0; if ($count == 0) { $displayday_kp = 0; } else { $displayday_kp = 1; } if ($count2 == 0) { $displayweek_kp = 0; } else { $displayweek_kp = 1; } if ($count4 == 0) { $displayweek_pk = 0; } else { $displayweek_pk = 1; } if ($count6 == 0) { $displayday_pk = 0; } else { $displayday_pk = 1; } if (($displayday_kp == 1) or ($displayweek_kp == 1) or ($displayweek_pk == 1) or ($displayday_pk == 1)) { if(!empty($killers_monsters)) { $numberlist++; if(is_int($numberlist / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } // By QuaS~ $main_content .= '<TR BGCOLOR='.$bgcolor.'> <TD><B><font CLASS = "red">'.$monstrums[name].'</B></TD><TD><B><font CLASS = "red">'.$count.'</B></TD><TD><B><font CLASS = "red">'.$count6.'</B></TD><TD><B><font CLASS = "red">'.$count2.'</B></TD><TD><B><font CLASS = "red">'.$count4.'</B></TD></TR>'; } } } } $main_content .= '</TABLE>'; ?>
 
Configure Corretamente Estas Linhas:
 

//CONFIG $mysql_user = "user"; $mysql_pass = "password"; $mysql_database = "database"; $mysql_host = "localhost"; //END OF CONFIG
 
Agora Va Em:
/data/creatureevents/scripts
 
Faça Um NOvo arquivo Com o Nome:
counter.lua
 
e Cole Isso:
 

function onKill(cid, target, lastHit) local monster = getCreatureName(target) if isMonster(target) == TRUE then db.executeQuery("INSERT INTO killed_monsters (`name`, `date`) VALUES\n('".. monster .."',".. os.time() ..");") end return TRUE end
 
Abra o: Login.lua
 
E adicione Isso:

registerCreatureEvent(cid, "Counter")
 
 
Agora Abra O: creatureevents.xml
 
E adicione Isso:

<event type="kill" name="Counter" script="counter.lua"/>
 
 
Abra Seu Detabase e adicione isso:
 

CREATE TABLE killed_monsters ( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, date BIGINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE = InnoDB
 
 
 
Agora Va Em Index E adicione Isso:
 

case "KillStatistic"; $topic = "Kill Statistic"; $subtopic = "Kills"; include("kill.php"); break;
 
agora va em: C:\xampp\htdocs\layouts\tibiacom
 
Abra O Layout.php
 
e adicione logo abaixo de:
 

<a href='?subtopic=killstatistics'> <div id='submenu_killstatistics' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'> <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> <div id='ActiveSubmenuItemIcon_killstatistics' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div> <div class='SubmenuitemLabel'>Last Kills</div> <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> </div> </a>
 
adicione Isso::
 

<a href='index.php?subtopic=killstatistic'> <div id='submenu_wars' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'> <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> <div id='ActiveSubmenuItemIcon_killstatistic' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div> <div class='SubmenuitemLabel'><font color="white">Kill Statistic</font></div> <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> </div> </a>
 
 
Pronto.
 
 
Bom Uso.

Olá xtibianos, vim trazer um script que acredito eu seja um pouco útil e facilite a vida de algumas pessoas...
 
Bom o script é simples você tem total controle sobre seu servidor pelo site, exemplo: você pode fechar ele, abrir, reiniciar tudo através do site do servidor.
 
bom vamos ao que interessa
 
na pasta htdocs do seu site faça um arquivo .php chamado restarter e cole isso:
 

<?PHP $path = $config['site']['server_path']; $exename = "NOME DO EXECUTAVEL.exe"; if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) { if($action == "") { $main_content .= '<table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><font color="red"><b>Option</b></font></td><td><font color="red"><b>Description</b></font></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=restart">Reiniciar</a></b></td><td><b>Fechar o servidor e abri-lo novamente</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=restarter&action=kill">Fechar Servidor</a></b></td><td><b>Fechar todos os processos do servidor imediatamente</b></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=start">Iniciar Servidor</a></b></td><td><b>iniciar servidor</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=restarter&action=shutdown">Fechar o servidor</a></b></td><td><b>Fecha o servidor após 5 minutos</b></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=shutdownlong">avisar os players do fechamento do servidor</a></b></td><td><b>Performs safe shutdown after broadcast warning and 5 minutes delay.</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=adminpanel">Back to admin panel</a></b></td><td><b>Go back to admin panel.</b></td></tr> </table>'; } getcwd(); chdir($path); if($action == "restart") { exec('TASKKILL /F /IM "'.$exename.'"'); $command = 'START/HIGH '.$exename; $tmpnam = "temp.bat"; $fp = fopen ($tmpnam, "w"); fwrite($fp, $command); fclose ($fp); $foo = @popen($tmpnam, 'r'); $main_content .='<center>Server restarted.<br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "kill"){exec('TASKKILL /F /IM "'.$exename.'"'); $main_content .='<center>Server closed.<br><b><a href="?subtopic=restarter">Back</a></center>';} if($action == "start") { $command = 'START/HIGH '.$exename; $tmpnam = "temp.bat"; $fp = fopen ($tmpnam, "w"); fwrite($fp, $command); fclose ($fp); $foo = @popen($tmpnam, 'r'); $main_content .='<center>Server started. <br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "shutdown") { $SQL->query('UPDATE '.$SQL->tableName('z_shut').' SET `shutdown`="1", `long`="0" WHERE id = "1";'); $main_content .='<center>Server will shut down soon. <br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "shutdownlong") { $SQL->query('UPDATE '.$SQL->tableName('z_shut').' SET `shutdown`="1", `long`="1" WHERE `id` = "1";'); $main_content .='<center>Server will shut down soon. <br><b><a href="?subtopic=restarter">Back</a></center>'; } } else { $title = $GLOBALS['config']['server']["serverName"]." - OTS"; $main_content .= 'Invalid subtopic. Can\'t load page.'; } ?>
 
Não esqueçam de colocar o nome do executável do servidor na 3º linha!
 
agora vá em index.php e adicione:
 
 

case "restarter": $topic = "Restarter"; $subtopic = "restarter"; include("restarter.php"); break;
 
 
Antes de:
 
 

case "latestnews": $topic = "Latest News"; $subtopic = "latestnews"; include("latestnews.php"); break;
 
Agora em adminpanel.php adicione:
 
<tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter">Restarter</a></b></td><td><b>Here you start, stop and restart server!</b></td></tr>  
 
Antes de
</table>  
Agora na sua database execute isso:
 

CREATE TABLE IF NOT EXISTS `z_shut` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shutdown` int(11) NOT NULL DEFAULT '1', `long` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; INSERT INTO `z_shut` (`id`, `shutdown`, `long`) VALUES (1, 0, 1);
 
agora na pasta do seu servidor vá em data\globalevents\scripts faça um novo arquivo .lua com o nome de restarter e cole isso:
 

local message = { "Server will shut down in 5 minutes. Dont ask me why, I'm only script", "Server will shutdown in 2 minutes, please log off", "Server is going down..." } local class = 21 function shutDown() doBroadcastMessage(message[3], class) doSetGameState(GAMESTATE_SHUTDOWN) return TRUE end function broadcast() doBroadcastMessage(message[2], class) return TRUE end function onThink(interval, lastExecution) local result_plr = db.getResult("SELECT * FROM z_shut WHERE `id` = 1;") if(result_plr:getID() ~= -1) then while(true) do if(tonumber(result_plr:getDataInt("shutdown"))==1) then db.executeQuery("UPDATE z_shut SET shutdown = '0' WHERE id = '1';") if(tonumber(result_plr:getDataInt("long"))==0) then doBroadcastMessage(message[3], class) doSetGameState(GAMESTATE_SHUTDOWN) else doBroadcastMessage(message[1], class) addEvent(broadcast, 3*60*1000, {}) addEvent(shutDown, 5*60*1000, {}) end end if not(result_plr:next()) then break end end end result_plr:free() return TRUE end
 
e por fim em globalevents.xml adicione:
 
<globalevent name="safe_shutdown" interval="5" event="script" value="restarter.lua"/>  
 
Sinceramente espero que seja útil para vocês isso, duvidas podem postar que estarei ajudando...

Olá
 
 
Vim Trazer A Voçês um Script De Top Fragger. ;D
 
 
Vamo Ao Que Interessa.
 
Va Em: xampp\htdocs
 
Crie Um Novo Arquivo frags.php
 
e Cole Isso:
 

<?php $main_content .= '<div style="text-align: center; font-weight: bold;">Top 25 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,25;') 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>'; ?>
Salve E Fexe.
 
Agora Va Em index.php
 
Após:

case "guilds"; $topic = "Guilds"; $subtopic = "guilds"; include("guilds.php"); break;
 
Cole isso:
 

case "frags"; $topic = "Top Frags"; $subtopic = "frags"; include("frags.php"); break;
 
Agora Va na Detabase DO Seu Servidor e Adicione Isso:
 

ALTER TABLE `players` ADD `frags` INT( 11 ) NOT NULL DEFAULT '0';
 
Agora Va Ate: data\creaturescripts\scripts
 
Abra o Login.lua
 
Após:
registerCreatureEvent(cid, "Mail")
 
Cole Isso:
registerCreatureEvent(cid, "TopFrags")
 
Em: data\creaturescripts\scripts
 
 
Crie Um Novo Arquivo Com O nome: topfrags.lua

function onKill(cid, target, lastHit) if isPlayer(target) then db.executeQuery("UPDATE `players` SET `frags` = `frags` + 1 WHERE `id` = " .. getPlayerGUID(cid) .. ";") end return true end
 
 
 
Salve E Fexe.
 
Agora Va em: data/creaturescripts/
 
e Abra o: creaturescripts.xml
 
E Adicione essa Linha:
 
<event type="kill" name="TopFrags" event="script" value="topfrags.lua"/>
 
 
 
Agora Va Em:
 
C:\xampp\htdocs\layouts\tibiacom
 
Após

<a href='?subtopic=guilds'> <div id='submenu_guilds' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'> <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> <div id='ActiveSubmenuItemIcon_guilds' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div> <div class='SubmenuitemLabel'>Guilds</div> <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> </div> </a>
 
Cole isso:
 

<a href='index.php?subtopic=frags'> <div id='submenu_wars' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'> <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> <div id='ActiveSubmenuItemIcon_wars' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div> <div class='SubmenuitemLabel'><font color="red"> Top Fragger </font></div> <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> </div> </a>
 
 
Resultado:

 
Pronto.
 
 
 
CréDiToS:
 
Layout: widnet

Sabe aquele negocio chato de quando vc tem que mudar level ou editar algum char que voçê tem que ir no phpmyadmin etc?
poisé isso acabou! :b
 
 
Crie uma pasta em C:\xampp\htdocs
 
com o nome: adminpro.php
 
e cole isso:

<?PHP //README: if nick contain "'" use "\'". For example: nick = The'Knight so use in the form The\'Knight ,,,-WORKS! if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) { $main_content .= 'Welcome to advanced admin panel! Mainly you can edit players. Coded by <a href="http://otland.net/members/turs0n/">turson</a>'; //admin panel menu (player+account) $main_content .= '<br /><br /><div style="width:100%;border:1px solid #c6c6c6;padding:3px 0 3px 0"> <b>EDIT PLAYER -></b> <a href="?subtopic=admin&action=namelock">Name</a> | <a href="?subtopic=admin&action=exp">Experience</a> | <a href="?subtopic=admin&action=level">Level</a> | <a href="?subtopic=admin&action=others">Others</a> | <a href="?subtopic=admin&action=position">Position</a> | <a href="?subtopic=admin&action=delete">Delete</a> <br> <b>EDIT ACCOUNT -></b> <a href="?subtopic=admin&action=acc">Account Number</a> | <a href="?subtopic=admin&action=pass">Password</a> | <a href="?subtopic=admin&action=mail">E-mail</a> | <a href="?subtopic=admin&action=access">Access</a> <br><center><font color="red"><b>PLAYER MUST BE OFFLINE!</b></font></center> </div><br>'; /////////////////////////////////CHARACTER//////////////////////////////////// //namelock if (isset($_POST['ok1'])){ $SQL->query("UPDATE `players` SET `name` = ".$SQL->quote( $_POST['newname'] )." WHERE name = ".$SQL->quote( $_POST['name0'] ).";"); $main_content .= "Player name has been changed.";} //exp if (isset($_POST['ok2'])){ $SQL->query("UPDATE `players` SET experience = experience + ".$SQL->quote( $_POST['exp'] )." WHERE name = ".$SQL->quote( $_POST['name1'] ).";"); $main_content .= "Experience has been added.";} //level if (isset($_POST['ok3'])){ $SQL->query("UPDATE `players` SET level = ".$SQL->quote( $_POST['level'] )." WHERE name = ".$SQL->quote( $_POST['name2'] ).";"); $main_content .= "Level has been set.";} //others if (isset($_POST['ok4'])){ $SQL->query("UPDATE `players` SET health=".$SQL->quote( $_POST['health'] ).",healthmax=".$SQL->quote( $_POST['health'] ).",mana=".$SQL->quote( $_POST['mana'] ).",manamax=".$SQL->quote( $_POST['mana'] ).",cap=".$SQL->quote( $_POST['cap'] ).",maglevel=".$SQL->quote( $_POST['maglevel'] )." WHERE name = ".$SQL->quote( $_POST['name3'] ).";"); $main_content .= "Informations has been changed.";} //delete if (isset($_POST['ok5'])){ $SQL->query("DELETE from `players` WHERE name = ".$SQL->quote( $_POST['name4'] ).";"); $main_content .= "Character has beed deleted.";} //pos if (isset($_POST['ok10'])){ $SQL->query("UPDATE `players` SET group_id = ".$SQL->quote( $_POST['newpos'] )." WHERE name = ".$SQL->quote( $_POST['name9'] ).";"); $main_content .= "Player position has been changed.";} /////////////////////////////////////////ACCOUNT/////////////////////////////////////// //acc if (isset($_POST['ok6'])){ $SQL->query("UPDATE `accounts` INNER JOIN `players` ON `accounts`.`id` = `players`.`account_id` SET accounts.name=".$SQL->quote( $_POST['newacc'] )." WHERE players.name = ".$SQL->quote( $_POST['name5'] ).";"); $main_content .= "Account number has beed changed.";} //password if (isset($_POST['ok7'])){ $SQL->query("UPDATE `accounts` INNER JOIN `players` ON `accounts`.`id` = `players`.`account_id` SET accounts.password=".$SQL->quote( $_POST['newpass'] )." WHERE players.name = ".$SQL->quote( $_POST['name6'] ).";"); $main_content .= "Password has beed changed.";} //mail if (isset($_POST['ok8'])){ $SQL->query("UPDATE `accounts` INNER JOIN `players` ON `accounts`.`id` = `players`.`account_id` SET accounts.email=".$SQL->quote( $_POST['newmail'] )." WHERE players.name = ".$SQL->quote( $_POST['name7'] ).";"); $main_content .= "E-Mail adress has beed changed.";} //mail if (isset($_POST['ok9'])){ $SQL->query("UPDATE `accounts` INNER JOIN `players` ON `accounts`.`id` = `players`.`account_id` SET accounts.page_access=".$SQL->quote( $_POST['newaccess'] )." WHERE players.name = ".$SQL->quote( $_POST['name8'] ).";"); $main_content .= "Page access has beed changed.";} ////////////CHARACTER FORM/////////// //namelock form if($_GET["action"]=="namelock"){ $main_content .= '<form action="?subtopic=admin" method="post"> New Player Name <input type="text" name="newname"><br> Old Player Name <input type="text" name="name0"><br><input type="submit" value="OK" name="ok1"></form>';} //exp form if($_GET["action"]=="exp"){ $main_content .= '<form action="?subtopic=admin" method="post"> Add experience <input type="text" name="exp"> (only numbers)<br> Player Name <input type="text" name="name1"><br><input type="submit" value="OK" name="ok2"></form>';} //level form if($_GET["action"]=="level"){ $main_content .= '<form action="?subtopic=admin" method="post"> Set player level <input type="text" name="level"> (only numbers)<br> Player Name <input type="text" name="name2"><br><input type="submit" value="OK" name="ok3"></form>';} //others form if($_GET["action"]=="others"){ $main_content .= '<form action="?subtopic=admin" method="post"> Health <input type="text" name="health"> (only numbers)<br> Mana <input type="text" name="mana"> (only numbers)<br> Cap <input type="text" name="cap"> (only numbers)<br> MagLevel <input type="text" name="maglevel"> (only numbers)<br> Player Name <input type="text" name="name3"><br><input type="submit" value="OK" name="ok4"></form>';} //delete form if($_GET["action"]=="delete"){ $main_content .= '<form action="?subtopic=admin" method="post"> Player Name <input type="text" name="name4"><br><b>ARE YOU SURE?</b> <input type="submit" value="YES" name="ok5"></form>';} //pos form if($_GET["action"]=="position"){ $main_content .= '<form action="?subtopic=admin" method="post"> Position <input type="text" name="newpos"><i>example(1-player,2-tutor,3-senior tutor,4-gamemaster,5-community manager,6-god)</i> <br> Player Name <input type="text" name="name9"><br><input type="submit" value="OK" name="ok10"></form>';} /////////////ACCOUNT FORM//////////////// //account number form if($_GET["action"]=="acc"){ $main_content .= '<form action="?subtopic=admin" method="post"> New account number <input type="text" name="newacc"> <br> Player Name <input type="text" name="name5"><br><input type="submit" value="OK" name="ok6"></form>';} //password form if($_GET["action"]=="pass"){ $main_content .= '<form action="?subtopic=admin" method="post"> New password <input type="text" name="newpass"> <br> Player Name <input type="text" name="name6"><br><input type="submit" value="OK" name="ok7"></form>';} //mail form if($_GET["action"]=="mail"){ $main_content .= '<form action="?subtopic=admin" method="post"> New e-mail adress <input type="text" name="newmail"> <br> Player Name <input type="text" name="name7"><br><input type="submit" value="OK" name="ok8"></form>';} //access form if($_GET["action"]=="access"){ $main_content .= '<form action="?subtopic=admin" method="post"> Page access <input type="text" name="newaccess">(3->admin) <br> Player Name <input type="text" name="name8"><br><input type="submit" value="OK" name="ok9"></form>';} } else $main_content .= "You don't have required access!"; ?>
 
Salve e feixe.
 
 
Agora va em: index.php
 
Após
 

case "adminpanel": $topic = "Admin Panel"; $subtopic = "adminpanel"; include("adminpanel.php"); break;
 
Cole isso:
 

case "admin"; $subtopic = "admin"; $topic = "Advanced Admin Panel"; include("adminpro.php"); break;
 
Salve e feixe.
 
Agora va em C:\xampp\htdocs\layouts\tibiacom
 
abra o layout.php
 
após:
 

<a href='?subtopic=createaccount'> <div id='submenu_createaccount' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'> <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> <div id='ActiveSubmenuItemIcon_createaccount' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div> <div class='SubmenuitemLabel'>Create Account</div> <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> </div> </a>
 
Cole isso:
 

<a href='?subtopic=admin'> <div id='submenu_adminpanel' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'> <div class='LeftChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div> <div id='ActiveSubmenuItemIcon_adminpanel' class='ActiveSubmenuItemIcon' style='background-image:url(".$layout_name."/images/menu/icon-activesubmenu.gif);'></div> <div class='SubmenuitemLabel'><font color=\"blue\">~<u>Admin PRO</u>~</font></div> <div class='RightChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div> </div>
 
Ficaram assim:
 

 
 
e sejam felizes :b
 
 
Crédito: turson
 
 
obs: Não se preocupem apenas o admin do site conseiguira acessar esta pagina ;p

eu to sem xampp nesse pc, e o outro está ocupado, mais você apenas tem que executar esse comando na sua database como eu expliquei acima, executando pela coluna SQL, após isso veja se funcionou normalmente o seu site...

encryptionType = "plain" e mude para
encryptionType = "sha1"  
crie uma nova account e faça o teste

encryptionType = "plain" e mude para
encryptionType = "sha1"  
crie uma nova account e faça o teste

executa isso na sua database
 

CREATE TABLE `newsticker` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `date` INT(11) NOT NULL , `text` TEXT NOT NULL ) ENGINE=MYISAM ;

vamos para a apelação então haha
 
execute isso:
 

UPDATE accounts SET password = password + 7110eda4d09e062aa5e4a390b0a572ac0d2c0220
 
e confira se todas as senhas ficarão 1234...

não precisa muda pra plain nao pode deixar tudo normal...
tópico reportado, duvida senada.
 
sobre o nickname tem um monte de tutorial que ensina você configurar seu website aqui no xtbia ;p abrasss

bom dia =)
vá na sua database, na tabela account, selecione a account que você quer editar, procure por page_access e coloque 5, pronto

cara eu tava quase desistindo já OPKSADOPKSAPDA
 
veja se agora da certo

UPDATE accounts SET password = ('7110eda4d09e062aa5e4a390b0a572ac0d2c0220')

usa encryptionType = "sha1" nas 2?
 
tente usar
encryptionType = "plain"
 
para trocar todas as senhas da databese
 
 
execute na sua database:
 
UPDATE accounts SET password = password + 1234 no lugar de 1234 a senha que você desejar...
acredito que seja isso

execute esses comandos na sua database POR ORDEM.
 
1º
 
DROP TABLE poll_votes;  
 
2º

CREATE TABLE IF NOT EXISTS `poll_votes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `answer_id` int(11) DEFAULT NULL, `poll_id` int(11) DEFAULT NULL, `account_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `poll_id` (`poll_id`), KEY `account_id` (`account_id`), KEY `answer_id` (`answer_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
 
3º

ALTER TABLE `poll_votes` ADD CONSTRAINT `poll_votes_ibfk_1` FOREIGN KEY (`answer_id`) REFERENCES `poll_answer` (`id`), ADD CONSTRAINT `poll_votes_ibfk_2` FOREIGN KEY (`poll_id`) REFERENCES `poll` (`id`), ADD CONSTRAINT `poll_votes_ibfk_3` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`);
 
não esqueça, 1 por vez.

Olá xtibianos, vim trazer um script que acredito eu seja um pouco útil e facilite a vida de algumas pessoas...
 
Bom o script é simples você tem total controle sobre seu servidor pelo site, exemplo: você pode fechar ele, abrir, reiniciar tudo através do site do servidor.
 
bom vamos ao que interessa
 
na pasta htdocs do seu site faça um arquivo .php chamado restarter e cole isso:
 

<?PHP $path = $config['site']['server_path']; $exename = "NOME DO EXECUTAVEL.exe"; if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) { if($action == "") { $main_content .= '<table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><font color="red"><b>Option</b></font></td><td><font color="red"><b>Description</b></font></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=restart">Reiniciar</a></b></td><td><b>Fechar o servidor e abri-lo novamente</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=restarter&action=kill">Fechar Servidor</a></b></td><td><b>Fechar todos os processos do servidor imediatamente</b></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=start">Iniciar Servidor</a></b></td><td><b>iniciar servidor</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=restarter&action=shutdown">Fechar o servidor</a></b></td><td><b>Fecha o servidor após 5 minutos</b></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=shutdownlong">avisar os players do fechamento do servidor</a></b></td><td><b>Performs safe shutdown after broadcast warning and 5 minutes delay.</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=adminpanel">Back to admin panel</a></b></td><td><b>Go back to admin panel.</b></td></tr> </table>'; } getcwd(); chdir($path); if($action == "restart") { exec('TASKKILL /F /IM "'.$exename.'"'); $command = 'START/HIGH '.$exename; $tmpnam = "temp.bat"; $fp = fopen ($tmpnam, "w"); fwrite($fp, $command); fclose ($fp); $foo = @popen($tmpnam, 'r'); $main_content .='<center>Server restarted.<br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "kill"){exec('TASKKILL /F /IM "'.$exename.'"'); $main_content .='<center>Server closed.<br><b><a href="?subtopic=restarter">Back</a></center>';} if($action == "start") { $command = 'START/HIGH '.$exename; $tmpnam = "temp.bat"; $fp = fopen ($tmpnam, "w"); fwrite($fp, $command); fclose ($fp); $foo = @popen($tmpnam, 'r'); $main_content .='<center>Server started. <br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "shutdown") { $SQL->query('UPDATE '.$SQL->tableName('z_shut').' SET `shutdown`="1", `long`="0" WHERE id = "1";'); $main_content .='<center>Server will shut down soon. <br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "shutdownlong") { $SQL->query('UPDATE '.$SQL->tableName('z_shut').' SET `shutdown`="1", `long`="1" WHERE `id` = "1";'); $main_content .='<center>Server will shut down soon. <br><b><a href="?subtopic=restarter">Back</a></center>'; } } else { $title = $GLOBALS['config']['server']["serverName"]." - OTS"; $main_content .= 'Invalid subtopic. Can\'t load page.'; } ?>
 
Não esqueçam de colocar o nome do executável do servidor na 3º linha!
 
agora vá em index.php e adicione:
 
 

case "restarter": $topic = "Restarter"; $subtopic = "restarter"; include("restarter.php"); break;
 
 
Antes de:
 
 

case "latestnews": $topic = "Latest News"; $subtopic = "latestnews"; include("latestnews.php"); break;
 
Agora em adminpanel.php adicione:
 
<tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter">Restarter</a></b></td><td><b>Here you start, stop and restart server!</b></td></tr>  
 
Antes de
</table>  
Agora na sua database execute isso:
 

CREATE TABLE IF NOT EXISTS `z_shut` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shutdown` int(11) NOT NULL DEFAULT '1', `long` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; INSERT INTO `z_shut` (`id`, `shutdown`, `long`) VALUES (1, 0, 1);
 
agora na pasta do seu servidor vá em data\globalevents\scripts faça um novo arquivo .lua com o nome de restarter e cole isso:
 

local message = { "Server will shut down in 5 minutes. Dont ask me why, I'm only script", "Server will shutdown in 2 minutes, please log off", "Server is going down..." } local class = 21 function shutDown() doBroadcastMessage(message[3], class) doSetGameState(GAMESTATE_SHUTDOWN) return TRUE end function broadcast() doBroadcastMessage(message[2], class) return TRUE end function onThink(interval, lastExecution) local result_plr = db.getResult("SELECT * FROM z_shut WHERE `id` = 1;") if(result_plr:getID() ~= -1) then while(true) do if(tonumber(result_plr:getDataInt("shutdown"))==1) then db.executeQuery("UPDATE z_shut SET shutdown = '0' WHERE id = '1';") if(tonumber(result_plr:getDataInt("long"))==0) then doBroadcastMessage(message[3], class) doSetGameState(GAMESTATE_SHUTDOWN) else doBroadcastMessage(message[1], class) addEvent(broadcast, 3*60*1000, {}) addEvent(shutDown, 5*60*1000, {}) end end if not(result_plr:next()) then break end end end result_plr:free() return TRUE end
 
e por fim em globalevents.xml adicione:
 
<globalevent name="safe_shutdown" interval="5" event="script" value="restarter.lua"/>  
 
Sinceramente espero que seja útil para vocês isso, duvidas podem postar que estarei ajudando...

Olá xtibianos, vim trazer um script que acredito eu seja um pouco útil e facilite a vida de algumas pessoas...
 
Bom o script é simples você tem total controle sobre seu servidor pelo site, exemplo: você pode fechar ele, abrir, reiniciar tudo através do site do servidor.
 
bom vamos ao que interessa
 
na pasta htdocs do seu site faça um arquivo .php chamado restarter e cole isso:
 

<?PHP $path = $config['site']['server_path']; $exename = "NOME DO EXECUTAVEL.exe"; if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) { if($action == "") { $main_content .= '<table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><font color="red"><b>Option</b></font></td><td><font color="red"><b>Description</b></font></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=restart">Reiniciar</a></b></td><td><b>Fechar o servidor e abri-lo novamente</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=restarter&action=kill">Fechar Servidor</a></b></td><td><b>Fechar todos os processos do servidor imediatamente</b></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=start">Iniciar Servidor</a></b></td><td><b>iniciar servidor</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=restarter&action=shutdown">Fechar o servidor</a></b></td><td><b>Fecha o servidor após 5 minutos</b></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=shutdownlong">avisar os players do fechamento do servidor</a></b></td><td><b>Performs safe shutdown after broadcast warning and 5 minutes delay.</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=adminpanel">Back to admin panel</a></b></td><td><b>Go back to admin panel.</b></td></tr> </table>'; } getcwd(); chdir($path); if($action == "restart") { exec('TASKKILL /F /IM "'.$exename.'"'); $command = 'START/HIGH '.$exename; $tmpnam = "temp.bat"; $fp = fopen ($tmpnam, "w"); fwrite($fp, $command); fclose ($fp); $foo = @popen($tmpnam, 'r'); $main_content .='<center>Server restarted.<br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "kill"){exec('TASKKILL /F /IM "'.$exename.'"'); $main_content .='<center>Server closed.<br><b><a href="?subtopic=restarter">Back</a></center>';} if($action == "start") { $command = 'START/HIGH '.$exename; $tmpnam = "temp.bat"; $fp = fopen ($tmpnam, "w"); fwrite($fp, $command); fclose ($fp); $foo = @popen($tmpnam, 'r'); $main_content .='<center>Server started. <br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "shutdown") { $SQL->query('UPDATE '.$SQL->tableName('z_shut').' SET `shutdown`="1", `long`="0" WHERE id = "1";'); $main_content .='<center>Server will shut down soon. <br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "shutdownlong") { $SQL->query('UPDATE '.$SQL->tableName('z_shut').' SET `shutdown`="1", `long`="1" WHERE `id` = "1";'); $main_content .='<center>Server will shut down soon. <br><b><a href="?subtopic=restarter">Back</a></center>'; } } else { $title = $GLOBALS['config']['server']["serverName"]." - OTS"; $main_content .= 'Invalid subtopic. Can\'t load page.'; } ?>
 
Não esqueçam de colocar o nome do executável do servidor na 3º linha!
 
agora vá em index.php e adicione:
 
 

case "restarter": $topic = "Restarter"; $subtopic = "restarter"; include("restarter.php"); break;
 
 
Antes de:
 
 

case "latestnews": $topic = "Latest News"; $subtopic = "latestnews"; include("latestnews.php"); break;
 
Agora em adminpanel.php adicione:
 
<tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter">Restarter</a></b></td><td><b>Here you start, stop and restart server!</b></td></tr>  
 
Antes de
</table>  
Agora na sua database execute isso:
 

CREATE TABLE IF NOT EXISTS `z_shut` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shutdown` int(11) NOT NULL DEFAULT '1', `long` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; INSERT INTO `z_shut` (`id`, `shutdown`, `long`) VALUES (1, 0, 1);
 
agora na pasta do seu servidor vá em data\globalevents\scripts faça um novo arquivo .lua com o nome de restarter e cole isso:
 

local message = { "Server will shut down in 5 minutes. Dont ask me why, I'm only script", "Server will shutdown in 2 minutes, please log off", "Server is going down..." } local class = 21 function shutDown() doBroadcastMessage(message[3], class) doSetGameState(GAMESTATE_SHUTDOWN) return TRUE end function broadcast() doBroadcastMessage(message[2], class) return TRUE end function onThink(interval, lastExecution) local result_plr = db.getResult("SELECT * FROM z_shut WHERE `id` = 1;") if(result_plr:getID() ~= -1) then while(true) do if(tonumber(result_plr:getDataInt("shutdown"))==1) then db.executeQuery("UPDATE z_shut SET shutdown = '0' WHERE id = '1';") if(tonumber(result_plr:getDataInt("long"))==0) then doBroadcastMessage(message[3], class) doSetGameState(GAMESTATE_SHUTDOWN) else doBroadcastMessage(message[1], class) addEvent(broadcast, 3*60*1000, {}) addEvent(shutDown, 5*60*1000, {}) end end if not(result_plr:next()) then break end end end result_plr:free() return TRUE end
 
e por fim em globalevents.xml adicione:
 
<globalevent name="safe_shutdown" interval="5" event="script" value="restarter.lua"/>  
 
Sinceramente espero que seja útil para vocês isso, duvidas podem postar que estarei ajudando...

Olá xtibianos, vim trazer um script que acredito eu seja um pouco útil e facilite a vida de algumas pessoas...
 
Bom o script é simples você tem total controle sobre seu servidor pelo site, exemplo: você pode fechar ele, abrir, reiniciar tudo através do site do servidor.
 
bom vamos ao que interessa
 
na pasta htdocs do seu site faça um arquivo .php chamado restarter e cole isso:
 

<?PHP $path = $config['site']['server_path']; $exename = "NOME DO EXECUTAVEL.exe"; if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) { if($action == "") { $main_content .= '<table style=\'clear:both\' border=0 cellpadding=0 cellspacing=0 width=\'100%\'> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><font color="red"><b>Option</b></font></td><td><font color="red"><b>Description</b></font></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=restart">Reiniciar</a></b></td><td><b>Fechar o servidor e abri-lo novamente</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=restarter&action=kill">Fechar Servidor</a></b></td><td><b>Fechar todos os processos do servidor imediatamente</b></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=start">Iniciar Servidor</a></b></td><td><b>iniciar servidor</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=restarter&action=shutdown">Fechar o servidor</a></b></td><td><b>Fecha o servidor após 5 minutos</b></td></tr> <tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter&action=shutdownlong">avisar os players do fechamento do servidor</a></b></td><td><b>Performs safe shutdown after broadcast warning and 5 minutes delay.</b></td></tr> <tr bgcolor='.$config['site']['darkborder'].'><td width="150"><b><a href="?subtopic=adminpanel">Back to admin panel</a></b></td><td><b>Go back to admin panel.</b></td></tr> </table>'; } getcwd(); chdir($path); if($action == "restart") { exec('TASKKILL /F /IM "'.$exename.'"'); $command = 'START/HIGH '.$exename; $tmpnam = "temp.bat"; $fp = fopen ($tmpnam, "w"); fwrite($fp, $command); fclose ($fp); $foo = @popen($tmpnam, 'r'); $main_content .='<center>Server restarted.<br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "kill"){exec('TASKKILL /F /IM "'.$exename.'"'); $main_content .='<center>Server closed.<br><b><a href="?subtopic=restarter">Back</a></center>';} if($action == "start") { $command = 'START/HIGH '.$exename; $tmpnam = "temp.bat"; $fp = fopen ($tmpnam, "w"); fwrite($fp, $command); fclose ($fp); $foo = @popen($tmpnam, 'r'); $main_content .='<center>Server started. <br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "shutdown") { $SQL->query('UPDATE '.$SQL->tableName('z_shut').' SET `shutdown`="1", `long`="0" WHERE id = "1";'); $main_content .='<center>Server will shut down soon. <br><b><a href="?subtopic=restarter">Back</a></center>'; } if($action == "shutdownlong") { $SQL->query('UPDATE '.$SQL->tableName('z_shut').' SET `shutdown`="1", `long`="1" WHERE `id` = "1";'); $main_content .='<center>Server will shut down soon. <br><b><a href="?subtopic=restarter">Back</a></center>'; } } else { $title = $GLOBALS['config']['server']["serverName"]." - OTS"; $main_content .= 'Invalid subtopic. Can\'t load page.'; } ?>
 
Não esqueçam de colocar o nome do executável do servidor na 3º linha!
 
agora vá em index.php e adicione:
 
 

case "restarter": $topic = "Restarter"; $subtopic = "restarter"; include("restarter.php"); break;
 
 
Antes de:
 
 

case "latestnews": $topic = "Latest News"; $subtopic = "latestnews"; include("latestnews.php"); break;
 
Agora em adminpanel.php adicione:
 
<tr bgcolor='.$config['site']['lightborder'].'><td width="150"><b><a href="?subtopic=restarter">Restarter</a></b></td><td><b>Here you start, stop and restart server!</b></td></tr>  
 
Antes de
</table>  
Agora na sua database execute isso:
 

CREATE TABLE IF NOT EXISTS `z_shut` ( `id` int(11) NOT NULL AUTO_INCREMENT, `shutdown` int(11) NOT NULL DEFAULT '1', `long` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; INSERT INTO `z_shut` (`id`, `shutdown`, `long`) VALUES (1, 0, 1);
 
agora na pasta do seu servidor vá em data\globalevents\scripts faça um novo arquivo .lua com o nome de restarter e cole isso:
 

local message = { "Server will shut down in 5 minutes. Dont ask me why, I'm only script", "Server will shutdown in 2 minutes, please log off", "Server is going down..." } local class = 21 function shutDown() doBroadcastMessage(message[3], class) doSetGameState(GAMESTATE_SHUTDOWN) return TRUE end function broadcast() doBroadcastMessage(message[2], class) return TRUE end function onThink(interval, lastExecution) local result_plr = db.getResult("SELECT * FROM z_shut WHERE `id` = 1;") if(result_plr:getID() ~= -1) then while(true) do if(tonumber(result_plr:getDataInt("shutdown"))==1) then db.executeQuery("UPDATE z_shut SET shutdown = '0' WHERE id = '1';") if(tonumber(result_plr:getDataInt("long"))==0) then doBroadcastMessage(message[3], class) doSetGameState(GAMESTATE_SHUTDOWN) else doBroadcastMessage(message[1], class) addEvent(broadcast, 3*60*1000, {}) addEvent(shutDown, 5*60*1000, {}) end end if not(result_plr:next()) then break end end end result_plr:free() return TRUE end
 
e por fim em globalevents.xml adicione:
 
<globalevent name="safe_shutdown" interval="5" event="script" value="restarter.lua"/>  
 
Sinceramente espero que seja útil para vocês isso, duvidas podem postar que estarei ajudando...

Sabe aquele negocio chato de quando vc tem que mudar level ou editar algum char que voçê tem que ir no phpmyadmin etc?
poisé isso acabou! :b
 
 
Crie uma pasta em C:\xampp\htdocs
 
com o nome: adminpro.php
 
e cole isso:

<?PHP //README: if nick contain "'" use "\'". For example: nick = The'Knight so use in the form The\'Knight ,,,-WORKS! if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) { $main_content .= 'Welcome to advanced admin panel! Mainly you can edit players. Coded by <a href="http://otland.net/members/turs0n/">turson</a>'; //admin panel menu (player+account) $main_content .= '<br /><br /><div style="width:100%;border:1px solid #c6c6c6;padding:3px 0 3px 0"> <b>EDIT PLAYER -></b> <a href="?subtopic=admin&action=namelock">Name</a> | <a href="?subtopic=admin&action=exp">Experience</a> | <a href="?subtopic=admin&action=level">Level</a> | <a href="?subtopic=admin&action=others">Others</a> | <a href="?subtopic=admin&action=position">Position</a> | <a href="?subtopic=admin&action=delete">Delete</a> <br> <b>EDIT ACCOUNT -></b> <a href="?subtopic=admin&action=acc">Account Number</a> | <a href="?subtopic=admin&action=pass">Password</a> | <a href="?subtopic=admin&action=mail">E-mail</a> | <a href="?subtopic=admin&action=access">Access</a> <br><center><font color="red"><b>PLAYER MUST BE OFFLINE!</b></font></center> </div><br>'; /////////////////////////////////CHARACTER//////////////////////////////////// //namelock if (isset($_POST['ok1'])){ $SQL->query("UPDATE `players` SET `name` = ".$SQL->quote( $_POST['newname'] )." WHERE name = ".$SQL->quote( $_POST['name0'] ).";"); $main_content .= "Player name has been changed.";} //exp if (isset($_POST['ok2'])){ $SQL->query("UPDATE `players` SET experience = experience + ".$SQL->quote( $_POST['exp'] )." WHERE name = ".$SQL->quote( $_POST['name1'] ).";"); $main_content .= "Experience has been added.";} //level if (isset($_POST['ok3'])){ $SQL->query("UPDATE `players` SET level = ".$SQL->quote( $_POST['level'] )." WHERE name = ".$SQL->quote( $_POST['name2'] ).";"); $main_content .= "Level has been set.";} //others if (isset($_POST['ok4'])){ $SQL->query("UPDATE `players` SET health=".$SQL->quote( $_POST['health'] ).",healthmax=".$SQL->quote( $_POST['health'] ).",mana=".$SQL->quote( $_POST['mana'] ).",manamax=".$SQL->quote( $_POST['mana'] ).",cap=".$SQL->quote( $_POST['cap'] ).",maglevel=".$SQL->quote( $_POST['maglevel'] )." WHERE name = ".$SQL->quote( $_POST['name3'] ).";"); $main_content .= "Informations has been changed.";} //delete if (isset($_POST['ok5'])){ $SQL->query("DELETE from `players` WHERE name = ".$SQL->quote( $_POST['name4'] ).";"); $main_content .= "Character has beed deleted.";} //pos if (isset($_POST['ok10'])){ $SQL->query("UPDATE `players` SET group_id = ".$SQL->quote( $_POST['newpos'] )." WHERE name = ".$SQL->quote( $_POST['name9'] ).";"); $main_content .= "Player position has been changed.";} /////////////////////////////////////////ACCOUNT/////////////////////////////////////// //acc if (isset($_POST['ok6'])){ $SQL->query("UPDATE `accounts` INNER JOIN `players` ON `accounts`.`id` = `players`.`account_id` SET accounts.name=".$SQL->quote( $_POST['newacc'] )." WHERE players.name = ".$SQL->quote( $_POST['name5'] ).";"); $main_content .= "Account number has beed changed.";} //password if (isset($_POST['ok7'])){ $SQL->query("UPDATE `accounts` INNER JOIN `players` ON `accounts`.`id` = `players`.`account_id` SET accounts.password=".$SQL->quote( $_POST['newpass'] )." WHERE players.name = ".$SQL->quote( $_POST['name6'] ).";"); $main_content .= "Password has beed changed.";} //mail if (isset($_POST['ok8'])){ $SQL->query("UPDATE `accounts` INNER JOIN `players` ON `accounts`.`id` = `players`.`account_id` SET accounts.email=".$SQL->quote( $_POST['newmail'] )." WHERE players.name = ".$SQL->quote( $_POST['name7'] ).";"); $main_content .= "E-Mail adress has beed changed.";} //mail if (isset($_POST['ok9'])){ $SQL->query("UPDATE `accounts` INNER JOIN `players` ON `accounts`.`id` = `players`.`account_id` SET accounts.page_access=".$SQL->quote( $_POST['newaccess'] )." WHERE players.name = ".$SQL->quote( $_POST['name8'] ).";"); $main_content .= "Page access has beed changed.";} ////////////CHARACTER FORM/////////// //namelock form if($_GET["action"]=="namelock"){ $main_content .= '<form action="?subtopic=admin" method="post"> New Player Name <input type="text" name="newname"><br> Old Player Name <input type="text" name="name0"><br><input type="submit" value="OK" name="ok1"></form>';} //exp form if($_GET["action"]=="exp"){ $main_content .= '<form action="?subtopic=admin" method="post"> Add experience <input type="text" name="exp"> (only numbers)<br> Player Name <input type="text" name="name1"><br><input type="submit" value="OK" name="ok2"></form>';} //level form if($_GET["action"]=="level"){ $main_content .= '<form action="?subtopic=admin" method="post"> Set player level <input type="text" name="level"> (only numbers)<br> Player Name <input type="text" name="name2"><br><input type="submit" value="OK" name="ok3"></form>';} //others form if($_GET["action"]=="others"){ $main_content .= '<form action="?subtopic=admin" method="post"> Health <input type="text" name="health"> (only numbers)<br> Mana <input type="text" name="mana"> (only numbers)<br> Cap <input type="text" name="cap"> (only numbers)<br> MagLevel <input type="text" name="maglevel"> (only numbers)<br> Player Name <input type="text" name="name3"><br><input type="submit" value="OK" name="ok4"></form>';} //delete form if($_GET["action"]=="delete"){ $main_content .= '<form action="?subtopic=admin" method="post"> Player Name <input type="text" name="name4"><br><b>ARE YOU SURE?</b> <input type="submit" value="YES" name="ok5"></form>';} //pos form if($_GET["action"]=="position"){ $main_content .= '<form action="?subtopic=admin" method="post"> Position <input type="text" name="newpos"><i>example(1-player,2-tutor,3-senior tutor,4-gamemaster,5-community manager,6-god)</i> <br> Player Name <input type="text" name="name9"><br><input type="submit" value="OK" name="ok10"></form>';} /////////////ACCOUNT FORM//////////////// //account number form if($_GET["action"]=="acc"){ $main_content .= '<form action="?subtopic=admin" method="post"> New account number <input type="text" name="newacc"> <br> Player Name <input type="text" name="name5"><br><input type="submit" value="OK" name="ok6"></form>';} //password form if($_GET["action"]=="pass"){ $main_content .= '<form action="?subtopic=admin" method="post"> New password <input type="text" name="newpass"> <br> Player Name <input type="text" name="name6"><br><input type="submit" value="OK" name="ok7"></form>';} //mail form if($_GET["action"]=="mail"){ $main_content .= '<form action="?subtopic=admin" method="post"> New e-mail adress <input type="text" name="newmail"> <br> Player Name <input type="text" name="name7"><br><input type="submit" value="OK" name="ok8"></form>';} //access form if($_GET["action"]=="access"){ $main_content .= '<form action="?subtopic=admin" method="post"> Page access <input type="text" name="newaccess">(3->admin) <br> Player Name <input type="text" name="name8"><br><input type="submit" value="OK" name="ok9"></form>';} } else $main_content .= "You don't have required access!"; ?>
 
Salve e feixe.
 
 
Agora va em: index.php
 
Após
 

case "adminpanel": $topic = "Admin Panel"; $subtopic = "adminpanel"; include("adminpanel.php"); break;
 
Cole isso:
 

case "admin"; $subtopic = "admin"; $topic = "Advanced Admin Panel"; include("adminpro.php"); break;
 
Salve e feixe.
 
Agora va em C:\xampp\htdocs\layouts\tibiacom
 
abra o layout.php
 
após:
 

<a href='?subtopic=createaccount'> <div id='submenu_createaccount' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'> <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> <div id='ActiveSubmenuItemIcon_createaccount' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div> <div class='SubmenuitemLabel'>Create Account</div> <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div> </div> </a>
 
Cole isso:
 

<a href='?subtopic=admin'> <div id='submenu_adminpanel' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'> <div class='LeftChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div> <div id='ActiveSubmenuItemIcon_adminpanel' class='ActiveSubmenuItemIcon' style='background-image:url(".$layout_name."/images/menu/icon-activesubmenu.gif);'></div> <div class='SubmenuitemLabel'><font color=\"blue\">~<u>Admin PRO</u>~</font></div> <div class='RightChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div> </div>
 
Ficaram assim:
 

 
 
e sejam felizes :b
 
 
Crédito: turson
 
 
obs: Não se preocupem apenas o admin do site conseiguira acessar esta pagina ;p

para terminar com o problema basta ir em:
 
 
C:\xampp\htdocs\config
 
abra o config.php
 
procure pela linha:
 
['verify_code']
 
 
do lado tara 1 coloque 0 pronto.

Olá
 
Após 3 Tentativas d autorizaçao para postar o script em outro forum, o Dono Me Autorizou POSAKPDKPSAKD
 
1. Estatisticas Do Servidor. (Ultimo Char Criado, Top Etc.)
 
Abra O: latestnews.php
E procure pela linha: $time = time(); ( Normalmente Bem No Começo)
 
adicione isso logo abaixo:
 

///////////////////////////////////////////////////////////////////////////////////////// //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.
 
 
Pronto.
CrEdItOs.
 
 

Aleh
 
 
2. Best Guild.
 
 
Faça Um Novo Arquivo com o nome frags.php em: C:\xampp\htdocs
 
Cole Isso Dentro:
 

<?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 AND `k`.`final_hit` = 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>'; ?>
 
agora va em: latestnews
 
e adicione isso:
 

$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>';
 
 
Ta ae.
 
 
Bom Uso.

Olá
 
Após 3 Tentativas d autorizaçao para postar o script em outro forum, o Dono Me Autorizou POSAKPDKPSAKD
 
1. Estatisticas Do Servidor. (Ultimo Char Criado, Top Etc.)
 
Abra O: latestnews.php
E procure pela linha: $time = time(); ( Normalmente Bem No Começo)
 
adicione isso logo abaixo:
 

///////////////////////////////////////////////////////////////////////////////////////// //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.
 
 
Pronto.
CrEdItOs.
 
 

Aleh
 
 
2. Best Guild.
 
 
Faça Um Novo Arquivo com o nome frags.php em: C:\xampp\htdocs
 
Cole Isso Dentro:
 

<?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 AND `k`.`final_hit` = 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>'; ?>
 
agora va em: latestnews
 
e adicione isso:
 

$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>';
 
 
Ta ae.
 
 
Bom Uso.