wongerlt

thanks you i fixed it must look like: hunt Giants.\n 1 57 1 10 10553.000000 need collect 10 adenas. And idea with excel is best ,you help me very much :D

Hello, i try to create simple quest on questname-e.dat tag_? quest_id quest_prog main_name prog_name description cnt1 items cnt2 num_items quest_x quest_y quest_z lvl_min lvl_max quest_type entity_name get_item_in_quest UNK_1 UNK_2 contact_npc_id contact_npc_x contact_npc_y contact_npc_z restricions short_description cnt3 req_class cnt4 req_item clan_pet_quest req_quest_complete UNK_3 area_id 1 300 1 Secret Room Hunt Giants To make a special Secret Room Scroll you need hunt Giants.\n 0 0 10553.000000 78428.000000 -3840.000000 1 80 3 Rath 0 1 1 30126 9566.000000 78373.000000 -3808.000000 No Requirements To make a special Secret Room Scroll you need hunt Giants. 0 0 0 0 0 30 and i want add quest items, i think is here cnt1 items cnt2 num_items items and num_items and is here: hunt Giants.\n 0 x 0 y 10553.000000 x and y , but when i try encrypt i got error, im using L2FileEdit. example: x=57 y=10 Tryed and with cmd l2encdec encrypt complete but get critical error in game. How to add items on quest that quest need to collect. thanks

yes https://mega.nz/#!rNMyVQID!r3_5tU_BeLgyf-kt48Aztzn1ztu1IbHq_7hPzeZgRmI totaly no bugs, perfect balance and etc.

before 2 years was shared l2gold trance files with some bug fixes and nothing more.

no point for one or two gm join table.

item_id = 57 AND count > 10 AND owner_id != 1484984 AND owner_id != 1484984

oh rly, then u can connect two tables or just check by owener id. example: item_id = 57 AND count > 10 AND owner_id=1484984

item_id = 57 AND count > 10 AND access_level = 0

use cronjobs

check file encode, with example notepad++ or php version, rly idk :D or if u need just write result to file. <?php $host = ''; //Hosting $user = ''; //Username $pass = ''; //Password $db = ''; //DatabaseName $top = '100'; //Top Number $countpvp = 1; try { $conn = new PDO("mysql:host=$host;dbname=$db", $user, $pass); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $conn->query("SET NAMES 'utf8'"); } catch(PDOException $e) { echo "Connection failed: " . $e->getMessage(); } $out = " <table> <tr> <th align='left'>Name</th> <th align='right'>&nbsp;</th> <th align='right'>PvP</th> </tr> "; $pvp = "SELECT char_name, pvpkills FROM characters WHERE pvpkills > 0 AND accesslevel <= 0 ORDER by pvpkills DESC LIMIT $top "; $pvp = $conn->prepare($pvp); $pvp->execute(); while($row = $pvp->fetch() ) { $countpvp++; $out .= " <tr> <td align='left'><span>".$row['char_name']."</span></td> <td align='right'><span>&nbsp;</span></td> <td align='right'>".$row['pvpkills']."</td> </tr> "; } $out .= " </table> "; file_put_contents("test.doc",$out); // this save doc to next to index.php ?>

at same place where player get rebirth book

try this: <?php $host = ''; //Hosting $user = ''; //Username $pass = ''; //Password $db = ''; //DatabaseName $top = '100'; //Top Number $countpvp = 1; try { $conn = new PDO("mysql:host=$host;dbname=$db", $user, $pass); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $conn->query("SET NAMES 'utf8'"); } catch(PDOException $e) { echo "Connection failed: " . $e->getMessage(); } header("Content-type: application/vnd.ms-word"); header("Content-Disposition: attachment;Filename=test.doc"); ob_start(); echo " <table> <tr> <th align='left'>Name</th> <th align='right'>&nbsp;</th> <th align='right'>PvP</th> </tr> "; $pvp = "SELECT char_name, pvpkills FROM characters WHERE pvpkills > 0 AND accesslevel <= 0 ORDER by pvpkills DESC LIMIT $top "; $pvp = $conn->prepare($pvp); $pvp->execute(); while($row = $pvp->fetch() ) { $countpvp++; echo " <tr> <td align='left'><span>".$row['char_name']."</span></td> <td align='right'><span>&nbsp;</span></td> <td align='right'>".$row['pvpkills']."</td> </tr> "; } echo " </table> "; $out = ob_get_contents(); ob_end_clean(); echo $out; file_put_contents("test.doc",$out); // this save doc to next to index.php ?>

just check results with, example print_r $row... and me suggestion dont use web and game server in same server. Use cronjobs for data update, example every 5min.

do you try to see others skills who have passive type?

View File L2Gold Weapons [for L2J Frozen] L2Gold Weapons [for L2J Frozen] Includes: Client: decrypted itemname.dat, weapongrp.dat Server: stats XML file, SQL file. VirusTotal Link: https://www.virustotal.com/#/file/a8142e733cc61af7cf81bdf6b918fd4420f613a33dfc6d2a7202b8216a03c5ba/detection Submitter wongerlt Submitted 07/03/2018 Category Equipments

very good guide:

change ur project encode to utf-8.

15.

i not remember how write in acis, maybe L2Rebirth not L2RebirthInstance, without Instance word

create or change one of exist npc, type "L2RebirthInstance" then spawn

config/events.properties

what server?

https://mega.nz/#!rNMyVQID!r3_5tU_BeLgyf-kt48Aztzn1ztu1IbHq_7hPzeZgRmI

u can find on google keyword "trance rebirth manager" in this forum i can't find trance shares, maybe it deleted.

eh shitty thing...