Jump to content

Recommended Posts

Posted

Topic unlocked.

I'm here to help you once again.

 

PS:My old messages had been deleted due to the IPB change.If someone wasn't helped feel free to PM me again.

 

Thanks.

  • 1 month later...
Posted

In general such a problem, the Queen Ant does not go, and Guards Goddard does not go! Server Advext.

Sorry Google Translate!

User PM'ed.

PS:I'm still here,little bit inactive tho,due to rl problems(working a lot nowdays).

Feel free to PM me with your problems.

  • 2 weeks later...
Posted (edited)
I have to make a server with subclass accumulative (principal + 3 subs)

of any class and race.

and that skilles se accumulate between of a subclass and another.

 

I do it with this SP:

 



set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[lin_SetAquireSkill]
(
@char_id INT,
@subjob_id INT,
@skill_id INT,
@skill_level TINYINT
)
AS
DECLARE @subjob_acu INT

SET NOCOUNT ON

set @subjob_acu = 0

WHILE (@subjob_acu < 3)

BEGIN

SET @subjob_acu = @subjob_acu + 1
IF EXISTS(SELECT skill_lev FROM user_skill WHERE char_id = @char_id AND skill_id = @skill_id AND subjob_id = @subjob_acu)
UPDATE user_skill SET skill_lev = @skill_level WHERE char_id = @char_id AND skill_id = @skill_id AND subjob_id <= @subjob_acu

ELSE
INSERT INTO user_skill (char_id, subjob_id, skill_id, skill_lev) VALUES (@char_id, @subjob_acu, @skill_id, @skill_level);
IF NOT EXISTS(SELECT skill_id FROM user_skill WHERE char_id = @char_id AND skill_id = @skill_id AND skill_lev = @skill_level AND subjob_id = 0)
INSERT INTO user_skill (char_id, subjob_id, skill_id, skill_lev) VALUES (@char_id, 0, @skill_id, @skill_level);

END


 

But only accumulate when "switch subclass".

When you subclass, the skilles of previous class  is cleared and starts loading the skilles of the new class, I need you to stay all skilles of all subclass.

is it possible?

Edited by WaLas
  • 3 months later...
Posted

Hello Phant can you please help me i need to setup an L2off server i have all the files needed but i get some problems with the IP's can you be of some assistance to me please? add me skype albertos.tasos or pm me.

 

Thanks a lot!

  • 5 weeks later...
  • 9 months later...
  • 1 year later...
  • 3 months later...
Posted

Hi. I would like to learn about l2 server setting and development. I am pretty experienced programmer, and looking for some help for fast start. I've been into lineage2 client modding in my youth, but do not know much about server development, i did only set up l2j server. I think l2off is more solid solution for server than l2j. Would be nice if someone could provide me with links to faqs and guides info setting up l2off, decompiling and apis.

Posted

Hi. I would like to learn about l2 server setting and development. I am pretty experienced programmer, and looking for some help for fast start. I've been into lineage2 client modding in my youth, but do not know much about server development, i did only set up l2j server. I think l2off is more solid solution for server than l2j. Would be nice if someone could provide me with links to faqs and guides info setting up l2off, decompiling and apis.

 

Try googling "l2server_l2off_gracia_final_83" and "hauthd", it's in fact all additional software you need to set up basic (and very unsecure) Gracia Final server. You'll also need 64bit server with at least 8 GB RAM (may be virtualized), installed Windows 2008 Server x64 and Microsoft SQL Server 2005.

 

When you get it up and running, you can experiment with scripts and AI. Also google for some information on extenders and AI decompiling. Lot of information can be found also here on this forum...

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

    • ⚡ Weekend special! Upgrade your personal Google account with 5TB storage and Gemini Pro in under 60 seconds.
    • Don't cry, it's a game. If it makes you cum on your monitor, of course, enjoy it. My business has been running for years and will continue to do so. No matter what happens here, the dogs bark, the caravan moves on. Start developing game engines - post them too - after all, I create them too) Salvation:Arena (MOBA) Unreal Engine RED-TEAM REVERSECODE Аліса займається розробкою ще з часів створення денді та сеги-діти які створюють шум для мене просто діти) За ці роки роботи я бачила багато різних людей у цій сфері все що я думаю про це не плачте та насолоджуйтесь життям слава ураїне - котись на свій бразильський форум)   If you'd simply asked me in a private message on the forum to be reinstated, you'd have been unblocked without a problem. I have no enemies—it's just business. I can make any product on the market, models and effects, copyrights—complex tools—at my age, people run large companies. I'm pleased that our beloved MXC* forum will now have a lot of free products. I earn a maximum of $200-$300 a year from this industry. If that excites you, well, have fun with us.       I moderate many gaming communities, here's one of them  if I hated you, you'd be out of here in a minute, brother  so don't get carried away with your wet dreams. On the topic of free work, start doing it yourself—the forum needs good free stuff. Someone will definitely like you here and throw a flower on your grave. Besides, you're forgetting that half the forum is involved in this interface development business and for many developers, it's a good income. So, you want to make life sweeter for them all, not just for me it's actually nice that you're such a noble young man.   Besides, I usually work from behind the scenes and don't move anywhere in the market but nothing stops me from doing what others do - working from the shadows  you won't even see that I'm doing it, it's so funny.   Start doing free work. You promised to do it well and post it to communities on time. Good luck! We'll have fun, that's great!🥰   завжди приємно поспілкуватися з веселими людьми              
    • Complete development packages for Lineage 2 UI development, across all chronicles and an automated tool to update and patch Interface.u & Interface.xdat What I Offer Clean Sources: 100% clean, retail-based interface source code with zero unwanted custom modifications. Interface.u Update Tool: A standalone tool designed to patch, rebuild, and update Interface.u efficiently. Custom Modifications: Custom UI features and tailoring can be implemented upon request. Turnaround Time: Most major versions and protocols are ready for immediate delivery; other versions take up to 1 week. How It Works Let me know the specific chronicle or protocol version you are targeting. I will provide the tool, which is HWID-bound to your machine, for your setup. Once satisfied with the results, we finalize the deal. Pricing & Notes Both products are priced separately based on the target protocol and requirements. Package deals are negotiable if purchasing both. DM for inquiries, demos, and pricing quotes.    
    • Well u need to change when sm1 press exit it keeps it in game..  
    • That’s just part of buying and selling; if your service didn't appeal to me at the time, there's no reason for me to force myself to buy it. After all, I regularly buy other interfaces and clients from other users mostly Russians using USDT. But *I'm* the child here, even though *you're* the incredibly arrogant one.   The payment method or the amounts were never the problem you were. But life goes on; you’d rather stay caught up in your delusions, thinking you’re the protagonist of some anime. Princess Alice 😂   I have all the interfaces for the 474/506/509/520/542/563/557. and olds too.  Some were created by me, including the ARENA P140 interface, which will soon be released for free. This includes everything you make available. It will no longer be a monopoly held by just a few people.   Including your clients with system. like  
  • 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..