Moon2PL

Server website : www.l2dasparion.pl Forum: www.l2dasparion.pl/forum Server opening: 24.02.2012 - 16.00(GMT+01:00) Staff: Dasp Owner & Java Developer & Web Master Vega Java Developer & Game Master Florek GM Assistant & Tester Rates: Exp/Sp x10 Party Exp/SP x2.0 Adena x8 Drop x8 Spoil x8 RB Drop x8 Qust Drop x5 Quest Reward x5 Enchant Chance Like l2off Safe Enchant: 3/4 Max Enchant: 16 Luxury Gatekeeper Shame NPC Buffer (1h all buffs) Class Manager Delevel NPC Subclass no-quest Easy nobless quest Auto learn skills Auto Events: TvT, CTF, DM, TW, VIP Offline shops system Seven Signs Olympiad Castle sieges Four Sepulchers Skill's 100% Balanced Classes Unique Geodata Dual Box Allowed 1main +1box Full geodata & pathnode Procesor IntelŸ XeonŸ E5540 (8 cores x 2,53 GHz, 8 MB cache L3) Ram `12GB DDR3 1 333 MHz Disc SAS (2 x 146GB, 15K rpm) Transfer: Unlimited Connection: 100mb If you have any questions about server check our website & forum - www.l2dasparion.pl

rly good share ! ty:)

GJ BTW Can you do script for smthink like you reach 20lvl and this tittle dissapear auto?

<?PHP $class_list=array( 0=>"Fighter",1=>"Warrior",2=>"Gladiator",3=>"Warlord",4=>"Knight",5=>"Paladin",6=>"Dark Avenger",7=>"Rogue", 8=>"Treasure Hunter",9=>"Hawkeye",10=>"Mage",11=>"Wizard",12=>"Sorcerer",13=>"Necromancer",14=>"Warlock",15=>"Cleric", 16=>"Bishop",17=>"Prophet",18=>"Elven Fighter",19=>"Elven Knight",20=>"Temple Knight",21=>"Swordsinger",22=>"Elven Scout",23=>"Plains Walker", 24=>"Silver Ranger",25=>"Elven Mage",26=>" Elven Wizard",27=>" Spellsinger",28=>"Elemental Summoner ",29=>"Oracle", 30=>"Elder",31=>"Dark Fighter",32=>"Palus Knightr",33=>"Shillien Knight",34=>"Bladedancer",35=>"Assasin",36=>"Abyss Walker", 37=>"Phantom Ranger",38=>"Dark Mage",39=>"Dark Wizard",40=>"Spellhowler",41=>"Phantom Summoner",42=>"Shillien Oracle",43=>"Shilien Elder", 44=>"Orc Fighter",45=>"Orc Raider",46=>"Destroyer",47=>"Orc Monk",48=>"Tyrant",49=>"Orc Mage",50=>"Orc Shaman",51=>"Overlord", 52=>"Warcryer",53=>"Dwarven Fighter",54=>"Scavenger",55=>"Bounty Hunter",56=>"Artisan", 57=> "Warsmith", 88=>"Duelist",89=>"Dreadnought",90=>"Phoenix Knight",91=>"Hell Knight",92=>"Sagittarius",93=>"Adventurer",94=>"Archmage",95=>"Soultaker", 96=>"Arcana Lord",97=>"Cardinal",98=>"Hierophant",99=>"Evas Templar",100=>"Sword Muse",101=>"Wind Rider",102=>"Moonlight Sentinel", 103=>"Mystic Muse",104=>"Elemental Master",105=>"Evas Saint",106=>"Shillien Templar",107=>"Spectral Dancer",108=>"Ghost Hunter", 109=>"Ghost Sentinel",110=>"Storm Screamer",111=>"Spectral Master",112=>"Shillien Saint",113=>"Titan",114=>"Grand Khavatari", 115=>"Dominator",116=>"Doomcryer",117=>"Fortune Seeker",118=>"Maestro", 123=>"Male Soldier",124=>"Female Soldier",125=>"Trooper",126=>"Warder",127=>"Berserker", 128=>"Male Soulbreaker",129=>"Female Soulbreaker",130=>"Arbalester",131=>"Doombringer", 132=>"Male Soulhound",133=>"Female Soulhound",134=>"Trickster",135=>"Inspector",136=>"Judicator" ); // db config $db_user = ""; //your sql username goes here $db_pass = ""; //your sql password goes here $db_name = ""; //your database name goes here $db_serv = ""; //the address of the database goes here // db connection! $db = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]"); mysql_select_db ( $db_name ); function do_query($query) { $arr = array(); $result = mssql_query($query) or die("Error SQL: ".mssql_get_last_message()); for ($x=0; $arr[$x] = mssql_fetch_assoc($result); $x++); unset($arr[count($arr)-1]); return $arr; } $query = mysql_query("SELECT char_name,olympiad_nobles.class_id as 'class_id' FROM characters LEFT JOIN clan_data ON clan_data.clan_Id = characters.clanId INNER JOIN olympiad_nobles ON olympiad_nobles.charId = characters.charId WHERE competitions_won > 0 ORDER BY class_id "); $heroes_actuales = mysql_query; if (sizeof($heroes_actuales) == 0) echo "No heroes found."; else { echo " <table class='info'>\n <td width='60%' align='left'><font color='CC3300'><b>Name</b></font></td> <td align='left'><font color='CC3300'><b>Class</b></font></td> </tr> "; $i=0; while ($hero = mysql_fetch_assoc($query)) { if (!($i%2)) echo "<tr align='center'>"; else echo "<tr align='center'>"; echo " <td align='left'>".$hero['char_name']."</td> <td align='left'>".$class_list[$hero['class_id']]."</td> <td align='left'> "; echo $hero['pname']."</td><td align='left'>"; echo $hero['aname']."</td><td align='left'>".$hero['win_count']."</td></tr>"; $i++; } echo "</table>"; } ?> ajjj this is not hero status, but top hero points - Before choosing a hero. Someone have script hero current list?

Hi! I Looking for tutorial "How to make 2 servers on 1 machine?". Someone can help? If the tutorial does not exist, can I ask for some information? I used the search options and unfortunately nothing found. Ty.

Done :)

Hi, I'm need rb status on the list - no map. Could anyone have? Thank you!

ehh at was ftp problem. now all work fine! big thx for help all ! :-)

My l2j characters table. CREATE TABLE IF NOT EXISTS `characters` ( `account_name` VARCHAR(45) DEFAULT NULL, `charId` INT UNSIGNED NOT NULL DEFAULT 0, `char_name` VARCHAR(35) NOT NULL, `level` TINYINT UNSIGNED DEFAULT NULL, `maxHp` MEDIUMINT UNSIGNED DEFAULT NULL, `curHp` MEDIUMINT UNSIGNED DEFAULT NULL, `maxCp` MEDIUMINT UNSIGNED DEFAULT NULL, `curCp` MEDIUMINT UNSIGNED DEFAULT NULL, `maxMp` MEDIUMINT UNSIGNED DEFAULT NULL, `curMp` MEDIUMINT UNSIGNED DEFAULT NULL, `face` TINYINT UNSIGNED DEFAULT NULL, `hairStyle` TINYINT UNSIGNED DEFAULT NULL, `hairColor` TINYINT UNSIGNED DEFAULT NULL, `sex` TINYINT UNSIGNED DEFAULT NULL, `heading` MEDIUMINT DEFAULT NULL, `x` MEDIUMINT DEFAULT NULL, `y` MEDIUMINT DEFAULT NULL, `z` MEDIUMINT DEFAULT NULL, `exp` BIGINT UNSIGNED DEFAULT 0, `expBeforeDeath` BIGINT UNSIGNED DEFAULT 0, `sp` INT UNSIGNED NOT NULL DEFAULT 0, `karma` INT UNSIGNED DEFAULT NULL, `fame` MEDIUMINT UNSIGNED NOT NULL default 0, `pvpkills` SMALLINT UNSIGNED DEFAULT NULL, `pkkills` SMALLINT UNSIGNED DEFAULT NULL, `clanid` INT UNSIGNED DEFAULT NULL, `race` TINYINT UNSIGNED DEFAULT NULL, `classid` TINYINT UNSIGNED DEFAULT NULL, `base_class` TINYINT UNSIGNED NOT NULL DEFAULT 0, `transform_id` SMALLINT UNSIGNED NOT NULL DEFAULT 0, `deletetime` bigint(13) unsigned NOT NULL DEFAULT '0', `cancraft` TINYINT UNSIGNED DEFAULT NULL, `title` VARCHAR(16) DEFAULT NULL, `title_color` MEDIUMINT UNSIGNED NOT NULL DEFAULT '16777079', `accesslevel` MEDIUMINT DEFAULT 0, `online` TINYINT UNSIGNED DEFAULT NULL, `onlinetime` INT DEFAULT NULL, `char_slot` TINYINT UNSIGNED DEFAULT NULL, `newbie` MEDIUMINT UNSIGNED DEFAULT 1, `lastAccess` bigint(13) unsigned NOT NULL DEFAULT '0', `clan_privs` MEDIUMINT UNSIGNED DEFAULT 0, `wantspeace` TINYINT UNSIGNED DEFAULT 0, `isin7sdungeon` TINYINT UNSIGNED NOT NULL default 0, `punish_level` TINYINT UNSIGNED NOT NULL DEFAULT 0, `punish_timer` INT UNSIGNED NOT NULL DEFAULT 0, `power_grade` TINYINT UNSIGNED DEFAULT NULL, `nobless` TINYINT UNSIGNED NOT NULL DEFAULT 0, `subpledge` SMALLINT NOT NULL DEFAULT 0, `lvl_joined_academy` TINYINT UNSIGNED NOT NULL DEFAULT 0, `apprentice` INT UNSIGNED NOT NULL DEFAULT 0, `sponsor` INT UNSIGNED NOT NULL DEFAULT 0, `varka_ketra_ally` TINYINT NOT NULL DEFAULT 0, `clan_join_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0', `clan_create_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0', `death_penalty_level` SMALLINT UNSIGNED NOT NULL DEFAULT 0, `bookmarkslot` SMALLINT UNSIGNED NOT NULL DEFAULT 0, `vitality_points` SMALLINT UNSIGNED NOT NULL DEFAULT 0, `createTime` bigint(13) unsigned NOT NULL DEFAULT '0', `language` VARCHAR(2) DEFAULT NULL, PRIMARY KEY (`charId`), KEY `clanid` (`clanid`) ); I make that and still no heroes: $LIMIT="60"; // TOP PAGE LIMIT $OBJ_ID="charId"; // Characters Table object id field name $ACCS_LVL="accesslevel"; // Characters Table access level field name $minenchant="3"; // Safe Enchant of Server $maxenchant="16"; // Max Enchant of Server $ETCITEMS="4037,57"; // Top Items Ids $MAX_ACCESS="120"; // Full Access level $EGM_ACCESS="120"; // Event GM Access level $NORMAL_ACCESS="2"; // Normal GM Access level include("config/_config_procs.php"); error_reporting(0); ?>

structure for heroes l2j. -- ---------------------------- -- Table structure for `heroes` -- ---------------------------- DROP TABLE IF EXISTS `heroes`; CREATE TABLE `heroes` ( `charId` decimal(11,0) NOT NULL DEFAULT '0', `class_id` decimal(3,0) NOT NULL DEFAULT '0', `count` decimal(3,0) NOT NULL DEFAULT '0', `played` decimal(1,0) NOT NULL DEFAULT '0', `message` varchar(300) NOT NULL DEFAULT '', PRIMARY KEY (`charId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of heroes -- ---------------------------- I check now olymp.php

Unfortunately does not work. : ( I have Heroes on the table "heroes". Mayby not for freya l2j..

Big thanks :-) for help, but i have this error: Current Heroes No heroes found. I must config only heroes.php ? My server for now is l2j nighty freya.

No, I'm not sad. Thank you for having tried to help me. I'm left waiting for help other members of this forum.

Unfortunately I did not find anything here about my problem/hero stat.

i use Search at http://l2jserver.com but nothing i find.. I use tags: hero stat, hero, hero script and nothing.