Jump to content

Recommended Posts

Posted

Vhalior evil noob don't hunt posts on my topic :D (that decreases my own post count).

 

Changeset 201

 

Doormen, misc

 

Doormen

- castle doormen are now retail-like (possibility to teleport in and out, drop of "open/close all doors" function).

- addition of 56 teleports location.

- unhardcode all CHDoormen HTMs.

- addition of many missing Doormen (Siegable CHs ones, 2 at Frontier Border) and fix some templates (Doormen of Hell were bugged as hell).

- drop of all useless HTMs.

 

Misc

- GmListTable is moved on datatable section.

- 2 spawns of Squashs have been dropped (in 4s...) Ty Vonak.

- TaskPriority is dropped (useless crap).

 

This commit doesn't fix yet CH doors issue.

Posted

I can't help but notice the IRC channel is empty :C

 

Also, I switched from the l2j nightlies to this svn, however I noticed when trying to manually edit sql data:

CREATE TABLE `spawnlist` (
  `npc_templateid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `locx` mediumint(6) NOT NULL DEFAULT '0',
  `locy` mediumint(6) NOT NULL DEFAULT '0',
  `locz` mediumint(6) NOT NULL DEFAULT '0',
  `heading` mediumint(6) NOT NULL DEFAULT '0',
  `respawn_delay` mediumint(5) NOT NULL DEFAULT '0',
  `periodOfDay` tinyint(1) unsigned NOT NULL DEFAULT '0'
);

 

The spawnlist table has no key fields. Is this intentional or was it something that was over-looked:

7wTJz.jpg

 

Posted

IRC has been deserted since a long time (months ago). Basically it has never been populated, to be honest, lol. 3 max isn't a * real* success, but an honorable fail :P.

 

Spawnlist doesn't have primary key from basic. So far, I think it's a generic L2J mark (correct me if I'm wrong), from IL (and surely before) to current times. You have to add one column only for that if you really need.

Posted

IRC has been deserted since a long time (months ago). Basically it has never been populated, to be honest, lol. 3 max isn't a * real* success, but an honorable fail :P.

 

Spawnlist doesn't have primary key from basic. So far, I think it's a generic L2J mark (correct me if I'm wrong), from IL (and surely before) to current times. You have to add one column only for that if you really need.

 

I guess it's not actually needed, though I know it can really hurt the performance in some cases:

 

"1) Since you are not using an explicit primary key, the mysqld node will end up randomly connecting to whatever ndbd node it happens to choose, from which the transaction is re-routed to the right data nodes. This unnecessary adds (doubles!) network latency.

 

2) When inserting, fetching the unique autoincrement value acts like a global lock for all inserts. You can parallelize all you want, but it doesn't get any faster. (There is ndb_autoincrement_prefetch_sz to prefetch a number of keys in a batch, but still, always always use primary key.)"

 

Though since it's only a fetch during the load of the server, I guess it's not a big deal.

Posted

non?

or all, depends of PoV. Project is project, there isn't "stable" version. We move on, each commit corrects bugs. If you miss 10 revisions, you got between 20 and 40 bugs and/or less content for sure compared to latest version (average quests commited per commit is 3, you calculate).

 

Use latest revision each time. The only bug I introduced those days are CH doors. Previous bug was inventory refactor, 3 months ago and knownlist refactor, 5-6 months ago.

Posted

or all, depends of PoV. Project is project, there isn't "stable" version. We move on, each commit corrects bugs. If you miss 10 revisions, you got between 20 and 40 bugs and/or less content for sure compared to latest version (average quests commited per commit is 3, you calculate).

 

Use latest revision each time. The only bug I introduced those days are CH doors. Previous bug was inventory refactor, 3 months ago and knownlist refactor, 5-6 months ago.

Ok, thanks.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



  • Posts

    • Hi, I'm selling Interface sources. I was working with one of bigger Essence projects (for ±1 year) delivering them Interface source KR. Per this period gathered knowledge about UE, UE Scripting, saw a lot of tools and their progression. So finally I decided that I can open up my own sales topic. I'm selling source for any protocol - If I don't have source, I will need you to provide whole system folder or for Essence/main - provide me protocol number. Sources are acquired by my OWN decompiler - written in Java, so we're not using popular UEExplorer upgraded by anyone. Decompiler extracts already compile ready sources. It outputs clean code, however constants are mapped 60-70%. Why only 60-70%? Well tl;dr when you compile any sources, they take at that time constant value and place it instead of = CONST_NAME to = THAT_CONST_NAME_VALUE, so it's not possible to have const name instead of value. Example of output: https://pastebin.com/cjyXcJvT for bigger .uc class (557p). p.s pastebin messed up encoding, but KR symbols are preserved - you won't see "?" symbols, rather you will see proper original korean text. I will give you guide as well, how not to mess it up with your editor VS Code/Notepad++ or what you use it to make them preserve it. You will get source + my compiler wrapper (written in java) - works on Windows/Mac/Linux - it has small GUI but supports CLI. Small notice, who thinks 'this is decompiled source' - basically all sources that are on sale are made by decompiling .u and applying changes. I think powerhouse few years ago was ArtToKill/kick (kick added support for INT64 to the publicly available compiler sources) etc. So no - there are no straight from 'creator' sources anywhere, all sellers offer the same - just the quality is different. UEExplorer upgraded was a big step, however, it introduces still a lot of nesting, if statements wrapping incorrectly which could lead to bugs. There are many things how to identify poor quality sources, as if the seller tries to sell 'out-of-box' when they see it compiles - sad news, some bugs are in the logic due to seller focusing only on 'it compiles' rather than issues that their decompiler is not capable so solve. On request I can restore ±100% const mapping.   Later I can attach compiled .u to try. Price is 400EUR. Payment methods USDT (Crypto). I'm still in debate with myself, wether to start selling XDat Editor with structures and ClientDat with 100% all files openings (no unk namings) and improved experience (such as comments support in .dat files, mass sync, improved performance and so on). P.s. If you ask me to give you some project's custom interface - the price may vary - there are couple things per project that need to be hand checked and adjusted (for example Innadril completely changes tokens which then I need to adjust my program to their token Ids). So it might take more time = more money. P.s.s. I have more things in the garage, like my own dsetup source that can allow you 'unlocking' system with your desired encrypting - you don't need to wait till 'patched' systems start appearing and so on, but I think at this time everyone who needs it make them selves it. AAC crypt removals and so on, BuildZone, everything that 'unlocks' client, however, I don't plan to make them on sale as mentioned, everyone can do them.  
    • It has been a while since I updated this thread. I am currently actively working on a full-scale port of the shader library to ensure the fast and accurate transfer of all effects. I have decompiled the original game and created a tool that fully logs the entire *Lineage 2 Interlude* particle system. This allows me to extract the original formulas hardcoded into the game, resulting in a high-fidelity port. For instance, *Lineage 2* uses an `appRnd` system that generates unique randomization patterns for different skills, giving them distinct visual characteristics; there are countless formulas and technical nuances like this. Ultimately, I will derive all the key formulas and replicate the geometry with high precision. Twelve basic geometry formulas have already been ported. The effect was created in 10 minutes using a .uc file, HLSL formulas, and SpriteEmitter particle blending formulas.   https://prnt.sc/_3UDLQVX_Y-_
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..