Share 32Bit C1 Server

[Sukinae]

@smeli

A question about this procedure connection string in the SQL scripts,

set @conn_str = '127.0.0.' + @world_id + ''';''sa'';''l2online'

Why is the last part of the IP cut?
Is this IP where the MSSQL server should be at or just the "l2server"?
If the IP is the MSSQL server, can I use a FQDN instead?

[Sukinae]

So yeah, if anyone is interested it works with an AWS RDS instance with SQL Server Express 2016.

[steve]

Guys, what is the program and how to open/edit files:

sysstring-e.txt, systemmsg-e.txt, skillname-e.txt, skillgrp.txt, servername-e.txt, npcname-e.txt, etc...

I have file edit of all chronicles, but i cant open these files...

 

Please give me download link with program to edit.

 

thanks

[MimisK]

4 minutes ago, steve said:

Guys, what is the program and how to open/edit files:

sysstring-e.txt, systemmsg-e.txt, skillname-e.txt, skillgrp.txt, servername-e.txt, npcname-e.txt, etc...

I have file edit of all chronicles, but i cant open these files...

 

Please give me download link with program to edit.

 

thanks

l2encdec :)

[steve]

Thanks.

Edited September 13, 2017 by steve

[steve]

how to shutdown the server? on l2server shutdown button says: 20 seconds to shutdown, but server never go down.

 

Any command??

[MimisK]

6 hours ago, steve said:

how to shutdown the server? on l2server shutdown button says: 20 seconds to shutdown, but server never go down.

 

Any command??

I'm not sure if exist command for shutdown.... Use crash & report

[steve]

2 hours ago, MimisK said:

I'm not sure if exist command for shutdown.... Use crash & report

crash & report  causes a rollback of some seconds.

 

I test some grand bosses, i cant enter Baium's Lair via Crystal with Blooded Fabric. Anyone know why?

Edited September 14, 2017 by steve

[smeli]

check in ai sources why. baium is not c1. he is reprogrammed and tested by my own hands

and first player waked baium is not killed by the way

[steve]

Can you help me with baium's teleporter and to remove that feature when you hit gakeeper, will teleport to the jail?

[smeli]

well, solution is to disable in extender attacking teleporters

ps. you know, l2 world full of npcs, full of mobs.  enough targets for mindless violation. other npcs cannot resist but teleporters can

 

------

 

the real problem is that player cannot defend innocent npc. this is against players. 

 

----

when man sees someone beating innocent woman or girl, man must retire and hide because of tolerancy

but game l2 is not about tolerancy. man must defend woman in l2

 

 

Edited September 14, 2017 by smeli

[AlmostGood]

is there technical reason behind restricting abuse of gatekeepers, or its mostly moral-based feature? :P

[smeli]

you are right, that's why only gatekeepers protected, not all the girls in the world

any additional activity near gatekeepers means lags and problems for other players when server online something more than 100

well, abusers can use mass buffing near gatekeepers... but this is limited to mana of abusers

[steve]

cacheD got this error:

After i got another error with tax_change.

How i fix it?

Go ur database, lin2world > Tables and remove "dbo.castle_tax" by right click->Delete

then

Paste this lines in .txt file and rename with .sql, then apply to your mssql.

*UPDATED*

CREATE TABLE [dbo].[castle_tax] (
    [income_update] [datetime] NULL ,
    [tax_change] [datetime] NULL 
) ON [PRIMARY]
GO

Tax now works OK and no more error in cacheD console :)

Edited September 16, 2017 by steve

[steve]

You want remove, when you hit any gatekeeper, html open and gk says, stop attack go jail bla bla and have chance to teleport to that "sucks" jail?

I found this:

Go to ai.obj and search this line: class teleporter : default_npc

then, remove the "handler 1    //  ATTACKED" full

This:

handler 1	//  ATTACKED
	variable_begin
		"attacker"
		"damage"
		"skill_name_id"
		"i0"
		"i1"
		"c1"
		"myself"
		"_choiceN"
		"_code"
		"_from_choice"
	variable_end

	push_event	//  myself
	push_const 28
	add
	fetch_i	//  i_ai0
	push_const 2336
	add
	push_reg_sp
	fetch_i
	push_event	//  myself
	push_const 28
	add
	fetch_i	//  i_ai0
	push_const 2336
	add
	fetch_i
	push_const 1
	add
	assign
	shift_sp -1
	push_event	//  myself
	push_const 28
	add
	fetch_i	//  i_ai1
	push_const 2340
	add
	fetch_i
	push_const 0
	equal
	branch_false L3588
L3587
	shift_sp 1
	push_const 11012
	push_parameter delaytime
	func_call 28	//  func[AddTimerEx]
	shift_sp -2
	shift_sp -1
L3588
	push_event	//  myself
	push_const 28
	add
	fetch_i	//  i_ai1
	push_const 2340
	add
	push_reg_sp
	fetch_i
	push_const 1
	assign
	shift_sp -1
	push_event	//  myself
	push_const 28
	add
	fetch_i	//  i_ai0
	push_const 2336
	add
	fetch_i
	push_const 10
	greater
	branch_false L3590
L3589
	push_event	//  myself
	push_const 28
	add
	fetch_i	//  i_ai0
	push_const 2336
	add
	push_reg_sp
	fetch_i
	push_const 0
	assign
	shift_sp -1
	shift_sp 1
	push_event	//  attacker
	push_const 36
	add
	fetch_i
	push_const 115016
	negate
	push_const 179224
	negate
	push_const 6752
	negate
	func_call 46	//  func[InstantTeleport]
	shift_sp -4
	shift_sp -1
	jump L3591
L3590
	push_event	//  c1
	push_const 276
	add
	push_reg_sp
	fetch_i
	push_event	//  attacker
	push_const 36
	add
	fetch_i
	assign
	shift_sp -1
	shift_sp 1
	push_event	//  c1
	push_const 276
	add
	fetch_i
	push_const 1926
	func_call 44	//  func[ShowSystemMessage]
	shift_sp -2
	shift_sp -1
L3591
handler_end

Save and check it :)