can someone upload file to rapidshare pls..i can't open link from karnage. thanx before
Printable View
can someone upload file to rapidshare pls..i can't open link from karnage. thanx before
Auth error: It looks like an application is already using one of the ports required by auth. If you need to you can change those in config.txt. As for the SQL errors, it looks like the worldstatus and server tables aren't valid (I can't read spanish :)) Maybe you aren't pointing the DSNs at Lin2DB? Maybe they don't have the right privelliges? Bad database maybe?Quote:
Originally Posted by matrixane
LogD: This takes a lot of resources, you don't really need to run it unless you like tons of data to dig through. Here's the fix for your error:
Run that on the appropriate database, SQL can be found here for convinience:Code:/********************************************
lin_CheckLogTimeTable2
do check whether real time log table is exist or not
INPUT
@strDate varchar(16),
@nWorld int
OUTPUT
return
made by
young
date
2002-11-11
********************************************/
CREATE PROCEDURE [DBO].[lin_CheckLogTimeTable2]
(
@strDate varchar(16),
@nWorld int
)
AS
SET NOCOUNT ON
declare @table_name varchar(60)
declare @table2_name varchar(60)
declare @view_name varchar(60)
declare @sql varchar(2048)
-- check log_realtime
set @table_name = @strDate + 'log_realtime_' + cast (@nWorld as varchar)
set @sql = 'select * from sysobjects (nolock) where name = '''+ @table_name + ''''
exec ( @sql)
if ( @@ROWCOUNT = 0)
begin
set @sql = 'exec lin_MakeLogTable ''' + @table_name + ''''
exec (@sql)
end
-- check log_audit
set @table_name = @strDate + 'log_audit_' + cast (@nWorld as varchar)
set @sql = 'select * from sysobjects (nolock) where name = '''+ @table_name + ''''
exec ( @sql)
if ( @@ROWCOUNT = 0)
begin
set @sql = 'exec lin_MakeLogTable ''' + @table_name + ''''
exec (@sql)
end
-- check log_data ( store 0~12 hour log)
set @table_name = @strDate + 'log_data_' + cast (@nWorld as varchar)
set @sql = 'select * from sysobjects (nolock) where name = '''+ @table_name + ''''
exec ( @sql)
if ( @@ROWCOUNT = 0)
begin
set @sql = 'exec lin_MakeLogTable ''' + @table_name + ''''
exec (@sql)
end
-- check log_data2 ( store 12~24 hour log)
set @table2_name = @strDate + 'log_data2_' + cast (@nWorld as varchar)
set @sql = 'select * from sysobjects (nolock) where name = '''+ @table2_name + ''''
exec ( @sql)
if ( @@ROWCOUNT = 0)
begin
set @sql = 'exec lin_MakeLogTable ''' + @table2_name + ''''
exec (@sql)
end
-- check log_data0 ( view )
set @view_name = @strDate + 'log_data0_' + cast (@nWorld as varchar)
set @sql = 'select * from sysobjects (nolock) where name = '''+ @view_name + ''''
exec ( @sql)
if ( @@ROWCOUNT = 0)
begin
-- set @sql = 'exec lin_MakeLogTable ''' + @table_name + ''''
set @sql = 'CREATE VIEW dbo.' + @view_name + ' ( '
+ ' act_time, log_id, actor, actor_account, target, target_account, location_x, location_y, location_z, '
+ 'etc_str1, etc_str2, etc_str3, '
+ 'etc_num1, etc_num2, etc_num3, etc_num4, etc_num5, etc_num6, etc_num7, etc_num8, etc_num9, etc_num10, '
+ 'STR_actor, STR_actor_account, STR_target, STR_target_account, item_id '
+ ' ) AS '
+ ' SELECT act_time, log_id, actor, actor_account, target, target_account, location_x, location_y, location_z, '
+ ' etc_str1, etc_str2, etc_str3, '
+ ' etc_num1, etc_num2, etc_num3, etc_num4, etc_num5, etc_num6, etc_num7, etc_num8, etc_num9, etc_num10, '
+ ' STR_actor, STR_actor_account, STR_target, STR_target_account, item_id '
+ ' from ' + @table_name + ' (nolock) UNION ALL '
+ ' SELECT act_time, log_id, actor, actor_account, target, target_account, location_x, location_y, location_z, '
+ ' etc_str1, etc_str2, etc_str3, '
+ ' etc_num1, etc_num2, etc_num3, etc_num4, etc_num5, etc_num6, etc_num7, etc_num8, etc_num9, etc_num10, '
+ ' STR_actor, STR_actor_account, STR_target, STR_target_account, item_id '
+ ' from ' + @table2_name + ' (nolock) '
exec (@sql)
end
-- check chat
set @table_name = @strDate + 'log_chat_' + cast (@nWorld as varchar)
set @sql = 'select * from sysobjects (nolock) where name = '''+ @table_name + ''''
exec ( @sql)
if ( @@ROWCOUNT = 0)
begin
set @sql = 'exec lin_MakeChatLogTable ''' + @table_name + ''''
exec (@sql)
end
GO
http://es-l2.com/~shawnmb/linchecklogtimetable2.sql
Thanks ..man i try to setup again... ^^
this files link down?
i need this file link or mirrer link plz..........all........
Hi and sorry for my bad english,
How do configure the client for this C4server? I had a server C3 and i want upload with this server. I launch the C4 server without problem but I can't enter in my server with C4 client. I don't now if change the l2.ini or Host and how...
Thinks per advance for your reply. Bye
Virus Found with ESET antivirus :ranting:
There's no virus. It's a fake virus. Ignore it.
False positive, yeah, most antivirus apps don't like asian applications for some reason.
if this is the release thats been spread like wildfire though here and postpacific from 99Nets there is a virus within the patch.dll. LOL !!!! the reason why u need to add the ip in host file is becasue the patch.dll has a call home function which can send data from your server to who ever's on the other end. the way the call home function works is this it sends info to that ip if ip sends back a value the dll works if the connection is closed then no server will start this is why your getting crashes on the server. the easiest solution for this problem is to disassemble the dll strip out the bad code and leave the patches in places make the call home stop and force the dll to jump anyways. then problem solved.
"NEO i can only show you the door its you who must walk though it"
You and your six posts make me stagger in awe as I read your wise posts. [Sarcasm]
yea i was told this by a dev who opened the DLL from our server which i gm, he worked on the file and got it working without the call home and ip in hosts.Quote:
Originally Posted by Shawnmb
i sugesst you open the patch.dll up and tell me what you see then we will see if the sarcasm remains.
Hi,
Can you reply my question because I'm a noob for patch the client. When I launch the server all is correctly but when I want connect in my serveur with the C4 client I can't connect... I have a Gameguard error or this message: Login or password isn't correctly... I don't know if modify the data client .dat or just modifi the l2.ini or hosts. If you can upload your system for me I will be very happy
Thinks per advance for your informations or upload!!!! Sorry for my bad english... ^^
Hello to all,
i hust wanted to ask if there is a fixed l2server.exe cuz every time im trying to run it im getting an error : clone patch failed
Thanks.
This is because patch.dll does it. Don't worry about it.
Do you have l2extend and patch.dll attached?Quote:
Hi,
Can you reply my question because I'm a noob for patch the client. When I launch the server all is correctly but when I want connect in my serveur with the C4 client I can't connect... I have a Gameguard error or this message: Login or password isn't correctly... I don't know if modify the data client .dat or just modifi the l2.ini or hosts. If you can upload your system for me I will be very happy
Thinks per advance for your informations or upload!!!! Sorry for my bad english... ^^
You're a moron. This was proved to be FALSE. There is no back door. The virus is a false. All the dll does is look for an ok to turn itself on. Nothing more. It doesn't send any of your server info away. -.- You need the IP in hosts file because zzcat turned his end off, but other people managed to crack it and get a new server up. All you're doing is rerouting off from zzcat's server to a new one. Learn what you're talking about before posting.Quote:
if this is the release thats been spread like wildfire though here and postpacific from 99Nets there is a virus within the patch.dll. LOL !!!! the reason why u need to add the ip in host file is becasue the patch.dll has a call home function which can send data from your server to who ever's on the other end. the way the call home function works is this it sends info to that ip if ip sends back a value the dll works if the connection is closed then no server will start this is why your getting crashes on the server. the easiest solution for this problem is to disassemble the dll strip out the bad code and leave the patches in places make the call home stop and force the dll to jump anyways. then problem solved.
"NEO i can only show you the door its you who must walk though it"
PS: I've looked for myself. Have you?
damn.,.,,.i configurated server like in manual ,started all servers like in manual and l2server.exe brokes down
L2Server.exe has encountered a problem and needs to close. We are sorry for the inconvenience. bla bla bla.,...,,.,.
what i should to do? ;)
sry for my language i'm from lithuania :D