Arsh

Personally im still for the appella, anyway for the pack, ask it in the l2j section.

Wrong Section, that's the L2off section!

Mhm, nevermind, i was meaning another thing with,but it wont work. Anyway, the better thing for you would be just to add the support for the l2off AuthD to l2j

Yes but, if he is going to put across 2 logins, he wont be able to use the same client withouth changing at least the port on the ini's ( so 2 different inis ) or with a self done launcher, or im wrong?

Nope. I asked you why you want to run an l2j and an l2off, not if they are on the same dedicated

Im not understanding what do you mean with " only it has the detail that one will L2J L2Off and the other two ", you are not explaing nothing, you want to run 2 l2off, 2 l2j, or 1 l2off and 1 l2j or what? and you say "one will be and the other two" so you are talking about 3 servers? anyway, i dont think that you can ran an authd and an l2j loginserver on the same host, them should go in conflict for the IP/Port's, either, if you can run them,i dont think that the client will work, cause he have to select on wich login he have to do the login, in this case you have to run them on different ports, so you cannot use the same system " to show 2 servers on the login " to do so, as neyks says, you have to add the support for the AuthD on the l2j gameserver core, other wise just run 2 l2j's or 2 l2off's with theyr right login servers. Anyway i can be wrong... Btw lol why you want to run an l2j + an l2off?

Yes, there are some ways to make you abl to run them

Personal point of view. If i can i start directly with them,less server loading times,less sql executions time,less disk access time ( not only related to l2 ), and i should not bother mysqlf changing them later,so :)

Nah, at least 10k rpm if not 15,but 7200 lol,specially for the SQL server if you have only 1 dedicated

First, you can run over an i7,npc server wont crash,at least i never had problems, second, if you want to take something good,i suggest you to go with another kind of hard disk, like an SSD or SCSI with an higher bandwitch/rpm's Third, get win server 2003, of course an x64 edition.

If you want to do it trought a website too, write php/asp function to open a connection and interact with the sql/cacheD server,and send the packets / data to it,i think that you can do it trought the admin port ( default 2012).

Them are not communicating directly with the database,but with the cacheD

If im not wrong, you cant change the names directly in the game, but for the item, you should be able to do it trought opening a port directly to the CacheD, so it can take the data and write them in real time. But i can be wrong, i have never tryed it.

Right, just run the sql that i have posted on the other threaad linked by embass, its the official dvamp update sql,if you get more errors on the database just let me know

Name: Sandeagle Doubleposting and non sense posts ( i think about spam), here are some: http://www.maxcheaters.com/forum/index.php?topic=164095.0;msg=1230199 http://www.maxcheaters.com/forum/index.php?topic=164583.0;msg=1239538 | http://www.maxcheaters.com/forum/index.php?topic=164583.0;msg=1239545 http://www.maxcheaters.com/forum/index.php?topic=160495.0;msg=1198782 | http://www.maxcheaters.com/forum/index.php?topic=160495.0;msg=1230194 Just see the last 2 links ( refere on the topic " [share] All my files over 5GB L2OFF Server Update Daily! " ) or the complete threads And there are lot more... Arsh.

First he have already solved with the sql,and your user_data its nor for the interlude pack, second, you still love to spam everywhere, duble post, and non sense posts.

I dont get your point.

what about user_item? Edit: you mean the missing fields? here you go, ALTER TABLE user_item ADD [attack_attr_type] [tinyint] NOT NULL DEFAULT 254, [attack_attr_value] [int] NOT NULL DEFAULT 0, [def_attr_fire] [int] NOT NULL DEFAULT 0, [def_attr_water] [int] NOT NULL DEFAULT 0, [def_attr_wind] [int] NOT NULL DEFAULT 0, [def_attr_earth] [int] NOT NULL DEFAULT 0, [def_attr_holy] [int] NOT NULL DEFAULT 0, [def_attr_unholy] [int] NOT NULL DEFAULT 0 GO ------------------------------- ALTER PROCEDURE [DBO].[lin_UpdateUserItem] ( @char_id INT, @item_type INT, @amount INT, @enchant INT, @eroded INT, @bless INT, @ident INT, @wished INT, @warehouse INT, @item_id INT, @attack_attr_type TINYINT, @attack_attr_value INT, @def_attr_fire INT, @def_attr_water INT, @def_attr_wind INT, @def_attr_earth INT, @def_attr_holy INT, @def_attr_unholy INT ) AS SET NOCOUNT ON UPDATE user_item set char_id=@char_id, item_type=@item_type, amount=@amount, enchant=@enchant, eroded=@eroded, bless=@bless, ident=@ident, wished=@wished, warehouse=@warehouse, attack_attr_type=@attack_attr_type, attack_attr_value=@attack_attr_value, def_attr_fire=@def_attr_fire, def_attr_water=@def_attr_water, def_attr_wind=@def_attr_wind, def_attr_earth=@def_attr_earth, def_attr_holy=@def_attr_holy, def_attr_unholy=@def_attr_unholy WHERE item_id=@item_id GO And you miss many others, ill post them later if i have time

You miss the last dVamp SQL updates... this is the procedure update for createitem that you miss.. ALTER PROCEDURE [DBO].[lin_CreateItem] ( @char_id INT, @item_type INT, @amount INT, @enchant INT, @eroded INT, @bless INT, @ident TINYINT, @wished TINYINT, @warehouse INT, @attack_attr_type TINYINT, @attack_attr_value INT, @def_attr_fire INT, @def_attr_water INT, @def_attr_wind INT, @def_attr_earth INT, @def_attr_holy INT, @def_attr_unholy INT ) AS SET NOCOUNT ON insert into user_item (char_id , item_type , amount , enchant , eroded , bless , ident , wished , warehouse,attack_attr_type, attack_attr_value, def_attr_fire, def_attr_water, def_attr_wind, def_attr_earth, def_attr_holy, def_attr_unholy) values (@char_id, @item_type , @amount , @enchant , @eroded , @bless , @ident , @wished , @warehouse,@attack_attr_type, @attack_attr_value, @def_attr_fire, @def_attr_water, @def_attr_wind, @def_attr_earth, @def_attr_holy, @def_attr_unholy) SELECT @@IDENTITY GO Anyway, next time, use the search, some days ago someone asked the same thing

Make all the ip's as 127.0.0.1, under the inis,in the database, make your "inner ip as 127.0.0.1" and "ip" as your external ip, that's all. After that if you are not going to try to connect from an external addres this will be my last answer, cause you are asking / doing the same things since 2 pages.

Im getting an headache from your problem, the reply its still the same,you get this error,cause tryes to connect with the Auth from an ip that its not registered in the server table! there is a why if you put 127.0.0.1 its works....

For the SQL user, search online or get an SQL Server book. About the connection,you are still not doing a basic test, tryng to connect from the outside! Now, if this (probably) its a loopback issue,this mean that when you try to login with the same ip as the wan server ip ( mean,your external ip,the one wrote on the database),the login will try to catch up the client as a server,cause the ip is the same as the one signed in the database.

Suggestion, you shouldnt leave the admin password as default.... same thing for the SQL server user,create a separate login, and block the sa user, that's one of the first security issue.... if you get it from a site,and use it as it is, everyone will know it :) after that, change your world id's [currently 0] in the ini's [to 1]

Could you stop posting crap just to spam in every single thread?

If you could acces from an external client, can be a loopback connection issue...