xMrPwN

to ip tou sql server (;

im refering to ppl who don't use that ready stuff but have the experience to create sth themselves and need a short guide to help them ;]

ti en0eis na "valeis" teleports? na valeis ta teleport links sta html i na valeis ta teleport stin database? pes m akrivws ti ekanes

did you try using any buffer and changing the imports?

s0z posted here by accident xD

ebneusmenos ap tin periptosi s ekana ena guide me c/p auta p s eipa prin xP anyway epd me petixes k se kali dia8esi addare xmrpwn sto skype ;]

i host i patched system p 8a exis ala3ei to l2.ini dn s lew parapano ------>search

dokimase to 3ana xwris na sviseis to palio s skill_trees, apla pernodas panw t to kenourgio... an dn benei perase ta xeirokinita

sto $db_serv vazeis tin ip stin opia ine i database, as ine k no-ip sta ala dn alazeis tpt exete tin port tou mysql (3306) anixti sto router k se exeption (TCP&UDP) sto firewall tou pc? an nai veveo8eite oti to user p exete valei den ine grameno stin database ws "localhost" an nai kante to "%" i kante ena neo user me host "%" PS: %=any host, gia pio sigekrimena an 8elete valte ti dieu8insi tou site sto user EDIT: pos epitrepete tetia pramata sto forum??? http://l2insanity.gr/forum/index.php?showtopic=52 =|

zitas para pola gia na ta apadisei kapios se reply, psa3e sto forum, ine gemato me leptomeri guides, i borei k na vreis apadisi se kapio alo help post.... ine k ena magiko koubaki panw de3ia p grafei "Search" (:

pare gia online players http://www.4shared.com/file/232887197/ec932b94/web.html perasta ola mesa st site ala3e kwdikous klp sto stats.php mesa sto confgi k meta perna t online-players.php opou 8es an ta exis kanei swsta opou exis valei na dixnei to file 8a s dixnei: Online Players: 1234 <-----oi online players meta dn 8elei k pl mialo na ala3eis 2-3 pramata gia na dixnei ta hero, boss status ktl... gia top pvp, pk 8a bei kapws etc <?php function connect() { include "config/stats.php"; } $sexes = array('Male', 'Famale'); $online = array('0' => "<font color=#FF0000><b>OFFLINE</b></font>", '1' => "<font color=#035922><b>ONLINE</b></font>"); $klan = array('0' => "No Clan"); $FORM = "" ; $query_chars = "select char_name,level,sex,classid,pkkills from characters WHERE accesslevel=0 AND pkkills >= 1 order by pkkills desc limit 20;"; connect(); $link = mysql_query($query_chars); $i=1; $r=255; while ( $row=mysql_fetch_row($link) ) { $timer2=$row[4]/1000; $datetime2 = gmstrftime("%d.%m.%Y v %H:%M:%S", $timer2); $query = "select classname from char_templates where classid=$row[3]"; $link2 = mysql_query($query); $class = mysql_fetch_row($link2); $FORM .= "<table><tr> <td align=center><font color=#808080><b> $i.</b></span></td> <td align=center><font color=#AE5C08> $row[0]</td> <td align=center><font color=#808080><b> Sex:</b></td> <td align=center><font color=#AE5C08> ".$sexes[$row[2]]."</font></td> <td align=center><font color=#808080><b> Class:</b></td> <td align=center><font color=#AE5C08> ".$class[0]."</font></td> <td align=center><font color=#808080><b> Pk:</b></td> <td class='Stil5' align=center><font color=#CC0099> $row[4]</font></td><br> </tr></table>"; $i++; $r -= 0; } mysql_close(); echo $FORM; ?> PS: auto ine pio leptomeres, grafei k to filo k tin clan tou char, to eixa ftia3ei palia k t ekana c/p kai gia castle ine xese mesa diadikasia, akoma dn exw sini8isei p0s na to kanw swsta...

-images on skills or items are client's problem, try to full update it deleting any files from other servers -what gmshop? you found it on mxc? did you put in on the server correctlly?

what do you mean add them? you don't get them through forgotten scrolls, aka they're not working??

msn kap00t k benw mono ap ebuddy 1-2 fores ti mera... re file pes m edw ti 8es k an dw oti den travaei 8a se help apo skype 0tan boresw...

{translation from my same guide in greek section} Ok, I don't know if this guide has been posted before but I'll make it very detailed Let's Start Supposing that we go to our web's files and we make a folder "/config" and inside we create a file "stats.php" inside it we put the following: <?php $db_user = "USER"; $db_pass = "PSW"; $db_name = "DATABASE"; $db_serv = "HOST(ip)"; $res = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]"); $resdb = mysql_select_db ( "$db_name",$res ); return $res; ?> we fill them according to our database the infos of how to connect to the database will be in this file(all infos are secure with this form) -------------------------------------------------------------------------------------------- afterwards, the page we want to show the infos must have on it's top: <?php include "config/stats.php" ?> and these: <?php mysql_connect($db_serv,$db_user,$db_pass) or die(mysql_error()); mysql_select_db($db_name) or die(mysql_error()); afterwards we write what we want from the file, to load from the database here are some examples for: //Total Accounts $query = ("SELECT * FROM accounts WHERE accesslevel>=0"); $result = mysql_query($query) or die(mysql_error()); $acc2=mysql_numrows($result); //GMs Online $query = ("SELECT * FROM characters WHERE accesslevel=200 and online=1"); $result = mysql_query($query) or die(mysql_error()); $GM=mysql_numrows($result); //Online Players $query = ("SELECT * FROM characters WHERE accesslevel<=0 and online=1"); $result = mysql_query($query) or die(mysql_error()); $online=mysql_numrows($result); //Total Characters $query = ("SELECT * FROM characters WHERE accesslevel>=0"); $result = mysql_query($query) or die(mysql_error()); $char2=mysql_numrows($result); //Total clans $get_config_data="SELECT clan_id FROM clan_data"; $query = ("SELECT clan_id FROM clan_data WHERE clan_id>0"); $result = mysql_query($query) or die(mysql_error()); $clan2=mysql_numrows($result); last lines of each code, for example: "$clan2=mysql_numrows($result);" clan2 will the name in wich everything will be written on the file, we can modify it if we want to then we conclude connect code with: mysql_close(); mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error()); mysql_select_db($db_name) or die(mysql_error()); ?> and after everything is written, to show the info, about total characters for example, on the site we write: Total Characters: <?php print ("$char2"); ?> (//Total characters(the script) must be in the same page in wich Total Characters: will be shown, if it's not, we simply add this on that page: <?php include "ToFilePouTaExeis.php" ?> I hope i've been helpful :) PS: whoever can please take my karma back to 0 ;p

pes m ti 8es apo msg, an xriastei na se add gia na se help 8a se add...

Ok, den 3erw an exi 3anaginei kt tetio post ala egw 8a t kanw pl leptomerws ;) As arxisoume... orea, as ipo8esoume oti sta arxeia tou site kanoume ena fakelo /config/ k mesa kanoume ena arxeio stats.php k mesa grafoume auta: <?php $db_user = "USER"; $db_pass = "PSW"; $db_name = "DATABASE"; $db_serv = "HOST(ip)"; $res = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]"); $resdb = mysql_select_db ( "$db_name",$res ); return $res; ?> ta siblirwnoume opos prepei eki 8a ine ta info gia na sindeode auta p 8a dixnoun ta stats me tin database -------------------------------------------------------------------------------------------- meta, se opia selida valoume stats, 8a prepei na exei mesa auto to code(sto top): <?php include "config/stats.php" ?> kai auta: <?php mysql_connect($db_serv,$db_user,$db_pass) or die(mysql_error()); mysql_select_db($db_name) or die(mysql_error()); istera grafoume ti 8eloume na diavazei apo tin database oriste merika paradeigmata: //Total Accounts $query = ("SELECT * FROM accounts WHERE accesslevel>=0"); $result = mysql_query($query) or die(mysql_error()); $acc2=mysql_numrows($result); //GMs Online $query = ("SELECT * FROM characters WHERE accesslevel=200 and online=1"); $result = mysql_query($query) or die(mysql_error()); $GM=mysql_numrows($result); //Online Players $query = ("SELECT * FROM characters WHERE accesslevel<=0 and online=1"); $result = mysql_query($query) or die(mysql_error()); $online=mysql_numrows($result); //Total Characters $query = ("SELECT * FROM characters WHERE accesslevel>=0"); $result = mysql_query($query) or die(mysql_error()); $char2=mysql_numrows($result); //Total clans $get_config_data="SELECT clan_id FROM clan_data"; $query = ("SELECT clan_id FROM clan_data WHERE clan_id>0"); $result = mysql_query($query) or die(mysql_error()); $clan2=mysql_numrows($result); auta p ine stin teleutea seira ka8e code px sto "$clan2=mysql_numrows($result);" to clan2 ine to name m t opio 8a grafete to ka8eti sto file, auto to alazoume an 8eloume... telos klinoume to code tou connect me: mysql_close(); mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error()); mysql_select_db($db_name) or die(mysql_error()); ?> k afou ine ola gramena, gia na di3oume px sto site tous total characters grafoume: Total Characters: <?php print ("$char2"); ?> (//Total characters(to script) 8a prepei na ine stin idia selida p 8a 8es na t di3oume, an ine alou apla vazoume eki p 8a ta dixnoume ena: <?php include "ToFilePouTaExeis.php" ?> Elpizw na voi8isa :) PS: to karma m sto 0 opios borei ;p

orea, as ipo8esoume oti sta arxeia tou site kaneis ena fakelo /config/ k mesa kaneis ena arxeio stats.php k mesa grafeis auta: <?php $db_user = "USER"; $db_pass = "PSW"; $db_name = "DATABASE"; $db_serv = "SQL_SERVER"; $res = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]"); $resdb = mysql_select_db ( "$db_name",$res ); return $res; ?> ta siblirwneis opos prepei eki 8a ine ta info gia na sindeode auta p 8a dixnoun ta stats me tin database -------------------------------------------------------------------------------------------- meta, se opia selida valeis stats, 8a prepei na exis mesa auto to code(sto top): <?php include "config/stats.php" ?> kai auta: <?php mysql_connect($db_serv,$db_user,$db_pass) or die(mysql_error()); mysql_select_db($db_name) or die(mysql_error()); istera grafeis ti 8eleis na diavazei apo tin database oriste merika paradeigmata: //Total Accounts $query = ("SELECT * FROM accounts WHERE accesslevel>=0"); $result = mysql_query($query) or die(mysql_error()); $acc2=mysql_numrows($result); //GMs Online $query = ("SELECT * FROM characters WHERE accesslevel=200 and online=1"); $result = mysql_query($query) or die(mysql_error()); $GM=mysql_numrows($result); //Online Players $query = ("SELECT * FROM characters WHERE accesslevel<=0 and online=1"); $result = mysql_query($query) or die(mysql_error()); $online=mysql_numrows($result); //Total Characters $query = ("SELECT * FROM characters WHERE accesslevel>=0"); $result = mysql_query($query) or die(mysql_error()); $char2=mysql_numrows($result); //Total clans $get_config_data="SELECT clan_id FROM clan_data"; $query = ("SELECT clan_id FROM clan_data WHERE clan_id>0"); $result = mysql_query($query) or die(mysql_error()); $clan2=mysql_numrows($result); auta p ine stin teleutea seira ka8e code px sto "$clan2=mysql_numrows($result);" to clan2 ine to name m t opio 8a grafete to ka8eti sto file, auto to alazeis an 8es... telos klineis to code tou connect me: mysql_close(); mysql_connect($db_serv,$db_user,$db_pass) or die (mysql_error()); mysql_select_db($db_name) or die(mysql_error()); ?> k afou ine ola gramena, gia na di3eis px sto site tous total characters grafeis: Total Characters: <?php print ("$char2"); ?> (//Total characters(to script) 8a prepei na ine stin idia selida p 8a 8es na t di3eis, an ine alou apla vale eki p 8a ta dixneis ena: <?php include "ToFilePouTaExeis.php" ?>

+1 :)

ki0m0s, exei....

i WAS looking for a bottable server, im not that kind of bot addict =P anyway it's better without bot ;)

im not using bot =P

www.raidfight.eu ;p it's the most retail thing i could find ;p

change the configs so that it won't need mail activation ;)

did you execute the db.sql into your database?