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

    • https://file.kiwi/85ded214#HP0EQ54upx_76JaA90zfOQ    
    • No complicated KYC, instant setup after purchase!  Boost your connection speed and secure your privacy today!  Official Website: https://novproxy.com?kwd=tt-max
    • Passa o conhecimento mano, só mercenários no mundo do l2.
    • I participate in "forum deal" in role middleman. I will advertise free your product with discounted from your "street store" on different forums. I know these forum addresses,i can post your advertisement on different forums.   Street store must be licensed(i will check license through website),store must pay taxes(i will check payment taxes through tax service website). Please note:seller(you) will decide "will like" to buyer or "not will like" total discount(total discount is price your product with discounted  plus my percentage above). Seller(you) decides what will be my percentage .   If you need free advertising,please write me in messenger for contact who are you by nationality and in which country you live. If you owner street store or you employee street store i will advertise free your product from your street store on different forums.   Country Location:i accept all countries except Ukraine. I will not conduct deals with buyers and sellers from Ukraine. I do not cooperate with country Ukraine. If you Ukrainian by nationality or live in Ukraine,ignore this topic.   Shoes,clothing,furniture,bags,televisions,music centers,telephones,laptops,tablets,refrigerators,washing machines,microwaves,fans.   Advertising process. Buyer sees product with discounted. To buyer likes price. Buyer pays my percentage on to payment details guarantor on forum,seller decides what will be my percentage. Buyer and seller through me decide what will be deadline in days for forum transaction(i will either receive money in specified deadline or i won't receive money).   Guarantor on forum notifies me that buyer paid money to payment details guarantor. I'm sending in "forum deal" address "street store" which ready to sell product with discount to buyer. Buyer arrives on given address,enters in street store,finds employee(seller) and asks "in stock?" this product with discount. If this product in stock employee(seller) shows buyer this product,which buyer saw on forum with discount. Buyer inspects product and if to buyer like product,buyer pays money seller and receives receipt for purchase. If buyer product doesn't like,buyer product doesn't purchase,according to clause in "forum questionnaire" seller must register on forum and write in "forum deal" that buyer has declined refused to purchase this product. Guarantor will return money to buyer(in full amount). If you in role seller don't want to register on forum,then advertising won't be(from me) on different forums. How it will be possible to prove that exactly this buyer,exactly from forum,on which this buyer saw my advertising topic,successfully purchased product. When buyer pays my percentage to guarantor on payment details guarantor,buyer writes to guarantor in private message "code word". When buyer meets with seller in store,buyer informs seller exactly same "code word". Then seller registers on forum and sends to guarantor in private message this "code word"(seller will have such right according to clause in "forum questionnaire"). Guarantor confirms to seller that "code word" is correct. If buyer purchases product,but buyer messages in "forum deal" that he not buy this product(buyer is lying in "forum deal"),then according to clause in "forum questionnaire" seller is connected to "forum deal"(i'll let you know via messenger when you need to connect to "forum deal"). Seller sends in "forum deal" "code word" and sends in "forum deal" screenshot receipt about successful sale product(seller will have such right according to clause "forum questionnaire"). On based "code word" and screenshot receipt about successful sale product guarantor makes decision:send money to middleman or return money to buyer.
  • 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..