New Year's surprise!

[faighenzho]

Originally Posted by Triacman

Well in view that you can connect with that client, here I leave the Atlantica Server unpacked + IAT repaired and supporting full text + possibility that the GIGAS can put its cannon properly, I also added that they can use their official language of preference as well they don't have to go around editing the language files. Happy New Year to you too.

Very good..thank you for sharing

[joshy9]

Hi may i ask i do i fix these so i can control a town without it resetting to no control after server reset? how do i manuelly fix the errors or is there a sql fix? no sure where and how to fix them.

UPDATE [dbp].[tbl_VillageStructure]
to
UPDATE [dbo].[tbl_VillageStructure]

UPDATE dbo.tbl_GuildTraning SET StartHourvary = 0 WHERE GuildUnique = @Unique
to
UPDATE dbo.tbl_GuildTraining SET StartHourvary = 0 WHERE GuildUnique = @Unique

Edit - Ok so i have figured out how to fix both of these myself.

now the only 2 i would love to try get working is making the server public so my family could join who lives outside my home network (external ip i am going to need i think).

also does anyone know how to stop NPCs walking on the spot? they walk once i click outside the game but walk on spot when i click in game. thank you for all the help.

[Richar12]

Hello everyone, I would like to ask a question? How can I change the name of my character without having to delete it and start over, try from the SQL, but the table restarts when I log in if anyone knows what tables I have to modify thank you.

[rezky123]

Originally Posted by Richar12

Hello everyone, I would like to ask a question? How can I change the name of my character without having to delete it and start over, try from the SQL, but the table restarts when I log in if anyone knows what tables I have to modify thank you.

AT_GameDB01 in table person, you can add some gold in there

[Richar12]

Originally Posted by rezky123

AT_GameDB01 in table person, you can add some gold in there

Thank you very much I just looked at the table

[x123x123x]

Originally Posted by joshy9

also does anyone know how to stop NPCs walking on the spot? they walk once i click outside the game but walk on spot when i click in game. thank you for all the help.

File: CharAttackInfo.ndt, attribute MOVE. This attribute indicates whether the NPC should move or not.
example:
COLUMBUS - Atb no MOVE (SYSTEMNPC+MERCHANTNPC). He stands still.
MURAMASA - Atb MOVE (SYSTEMNPC+MAKESKILLNPC+MOVE). He is moving.

 Spoiler

Char	Name	NameTextNum	Gender	AttackType	WpnType	EscapeRate	EquipType	ClsType	Synastry	Magic	Skill	Magic2	Skill2	Magic3	Skill3	Magic4	Skill4	Magic5	Skill5	Aggressive	bAgrsiveWhenBattle	AiPoint	MeleeRange	LongRange	MinDmg	MaxDmg	PvPDamageRate	PvPDamageRevision	CriticalRate	PvPBaseLife	AC	DefBaseRate	PvPDefBaseRate	Str	Dex	Vit	Intl	Exp	Level	JobType	Grade	MinActivePower	MaxActivePower	IncActivePowerRate	CharBasicEV	MagicDef	SummonItem	DemoBattle	SpecialQuestLevel	UseFight	GhostGroup1	GhostGroup2	GhostGroup3	GhostGroup4	GhostGroup5	AttackDM	MagicDM	HitNormal	HitCritical	TransForm	Atb	MoveDistance	AttackDistance_Min	AttackDistance_Max	ViewDistance	MagicDistance	BF_AttackType	CellSize_X	CellSize_Y	LightModelKind	MtStr	MtDex	MtVit	MtMag	MtMinDmg	MtMaxDmg	MtAC	MtLifeRate	MtLifeBase	MtMdef	HPRate	MPRate	HitRate	SeriesRate	CounterRate	CounterRange	CounterNum
COLUMBUS	콜롬버스	357	1	ATTACKTYPE_SWORD	WPNTYPE_NBS	ESCTYPE_NBS	NULL	NULL	SYN_HUMAN	NULL	25	NULL	1	NULL	1	NULL	1	NULL	1	0	1	100	1	1	1	2	1000	0	0	2500	-95	0	0	50	50	50	50	2	200	JT_MELEE	0	80	120	0	0	0	0	0	0	0	0	0	0	0	0	CENTERDM1	CENTERDM1	HITREDBLOOD	HITREDBLOOD_CRI	NULL	SYSTEMNPC+MERCHANTNPC	10	1	1	20	1	BF_ATTACKTYPE_SWORD	1	1	NULL	1000	1000	1000	1000	1000	1000	500	1000	1000	1000	8000	100	100	135	0	0	0
MURAMASA	무라마사	358	1	ATTACKTYPE_SWORD	WPNTYPE_NBS	ESCTYPE_NBS	NULL	NULL	SYN_HUMAN	NULL	25	NULL	1	NULL	1	NULL	1	NULL	1	0	1	100	1	1	1	2	1000	0	0	2500	-95	0	0	50	50	50	50	2	200	JT_MELEE	0	80	120	0	0	0	0	0	0	0	0	0	0	0	0	CENTERDM1	CENTERDM1	HITREDBLOOD	HITREDBLOOD_CRI	NULL	SYSTEMNPC+MAKESKILLNPC+MOVE	10	1	1	20	1	BF_ATTACKTYPE_SWORD	1	1	NULL	1000	1000	1000	1000	1000	1000	500	1000	1000	1000	8000	100	100	135	0	0	0

Changes must be on the server and client side. The server side takes precedence.

[Richar12]

Hello everyone, can someone tell me in which table I can modify the attributes of my house, as an insight to raise the level, thanks

[Triacman]

Originally Posted by Richar12

Hello everyone, I would like to ask a question? How can I change the name of my character without having to delete it and start over, try from the SQL, but the table restarts when I log in if anyone knows what tables I have to modify thank you.

Run Microsoft SQL Server Management Studio, then click New Query, then copy and paste the following stored proc and run it, then refresh the stored proc area to ensure the process name appears, then right-click the name of the process and click on Excecute Stored Procedure, the following data will appear:
@ID -> Here write 100
@ID -> Here write the PersonID that corresponds to the Character.
@ -> Here write 2 to change Character name
@ame -> Here write the new name you want.
@Name -> Here write the current name.
That's all, I hope I helped you.

USE [AT_GameDB01]
GO
/****** Object: StoredProcedure [dbo].[rsp_CambiarNombre] Script Date: 3/3/2020 23:56:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/*================================================= ============================
Nombre de la Función: rsp_CambiarNombre
Fecha de edición: 03/03/2020
Explicación: Puede cambiar el nombre del Clan, Nación o Personaje según el modo que use.
Modo = 0 : Cambia el nombre de Clan
Modo = 1 : Cambia el nombre de la Nación
Modo = 2 : Cambia el nombre del Personaje

Resultado = 1 : Significa que hubo éxito en la ejecución del proceso almacenado.
Resultado = -2 : Significa que el nombre que se quiere cambiar ya existe y no puede usarse
Editado adecuadamente por: Triacman
================================================== ===========================*/
CREATE PROCEDURE [dbo].[rsp_CambiarNombre]
@ID int,
@ID int,
@ tinyint,
@ame nvarchar(24),
@Name nvarchar(24)
AS
SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @ nvarchar(50)
DECLARE @ int


IF @ = 2
BEGIN
IF EXISTS ( SELECT * FROM [dbo].[tbl_Person] WHERE [NAME] = @ame )
BEGIN
select -2, @ame
RETURN
END

SELECT @Name = [Name] FROM [dbo].[tbl_Person] WHERE [PersonID] = @ID
END


BEGIN TRAN
BEGIN TRY
IF @ = 0 /* Cambia el nombre del Clan*/
BEGIN
SET @ = 0
EXEC @ = AT_Community.AT_Community.dbo.rasp_ChangeName 2, @ID, @Name, @ame
IF @ <> 1
BEGIN
set @ = 'UPDATE tbl_GuildUnit'
goto WriteErrorLog
END
END
ELSE IF @ = 1 /* Cambia el nombre de la Nación */
BEGIN
IF EXISTS (SELECT * FROM dbo.tbl_Nation WHERE NationName = @ame)
begin
SET @ = -2
set @ = 'UPDATE tbl_Nation'
goto WriteErrorLog
end
ELSE
begin
UPDATE [dbo].[tbl_Nation] SET [NationName] = @ame FROM [dbo].[tbl_Nation] WHERE [NationName] LIKE '*%' or NationName = @Name
IF @@ROWCOUNT <> 0
BEGIN
SET @ = -3
set @ = 'UPDATE tbl_Nation'
goto WriteErrorLog
END
end
END
ELSE IF @ = 2 -- Cambia el nombre del personaje.
BEGIN
-- Cambia todas las tablas que contienen nombres de personajes.
UPDATE [dbo].[tbl_Person] SET [Name] = @ame WHERE [PersonID] = @ID
IF @ <> 0
BEGIN
set @ = 'UPDATE tbl_Person'
goto WriteErrorLog
END

UPDATE [dbo].[tbl_FriendList] SET [FriendName] = @ame WHERE [FriendName] = @Name
IF @ <> 0
BEGIN
set @ = 'UPDATE tbl_FriendList'
goto WriteErrorLog
END

UPDATE [dbo].[tbl_FolloWer] SET [fName] = @ame WHERE [fName] = @Name
IF @ <> 0
BEGIN
set @ = 'UPDATE tbl_FolloWer'
goto WriteErrorLog
END

UPDATE [dbo].[tbl_PersonIndunMax] SET [Name] = @ame WHERE [Name] = @Name
IF @ <> 0
BEGIN
set @ = 'UPDATE tbl_PersonIndunMax'
goto WriteErrorLog
END

UPDATE [dbo].[tbla_PersonName] SET [PersonName] = @ame WHERE [PersonID] = @ID
IF @ <> 0
BEGIN
set @ = 'UPDATE tbla_PersonName'
goto WriteErrorLog
END

UPDATE [dbo].[tbl_House] SET [HouseName] = @ame WHERE [PersonID] = @ID
IF @ <> 0
BEGIN
set @ = 'UPDATE tbl_House'
goto WriteErrorLog
END

UPDATE [dbo].[tbl_BattleFieldCharInfo] SET [CharName] = @ame WHERE [CharName] = @Name
IF @ <> 0
BEGIN
set @ = 'UPDATE tbl_BattleFieldCharInfo'
goto WriteErrorLog
END

UPDATE [dbo].[tbl_TournamentLog] SET [DstName] = @ame WHERE [DstName] = @Name
IF @ <> 0
BEGIN
set @ = 'UPDATE tbl_TournamentLog'
goto WriteErrorLog
END

UPDATE [dbo].[tbl_WTMRecord] SET [Name] = @ame WHERE [Name] = @Name
IF @ <> 0
BEGIN
set @ = 'UPDATE tbl_WTMRecord'
goto WriteErrorLog
END

UPDATE [dbo].[tbla_rank_9] SET [Name] = @ame WHERE [Name] = @Name
IF @ <> 0
BEGIN
set @ = 'UPDATE tbla_rank_9'
goto WriteErrorLog
END

INSERT INTO [dbo].[tbl_ChangeName] (Reg_date,PersonID,BeforeName,AfterName,flag) SELECT GETDATE(), @ID, @Name, @ame, 0
IF @ <> 0
BEGIN
set @ = 'UPDATE tbl_ChangeName'
goto WriteErrorLog
END
END
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK TRAN

insert into tbl_SPError ( ErrorDate, ErrorNumber, ErrorSeverity, ErrorState, ErrorProcedure, ErrorLine, ErrorMessage, ErrorParam )
SELECT
getdate(), ERROR_NUMBER() as ErrorNumber, ERROR_SEVERITY() as ErrorSeverity, ERROR_STATE() as ErrorState,
ERROR_PROCEDURE() AS ErrorProcedure, ERROR_LINE() as ErrorLine, ERROR_MESSAGE(),
@ID = ' + isnull(CONVERT(varchar, @ID), '' ) + ',' +
@ = ' + isnull(CONVERT(varchar, @), '' ) + ',' +
@ame = ' + isnull(CONVERT(varchar, @ame), '' ) + ',' +
@Name = ' + isnull(CONVERT(varchar, @Name), '' )

select @, @ame
RETURN
END CATCH


IF @@TRANCOUNT > 0
COMMIT TRAN

SELECT 1, @ame
RETURN

WriteErrorLog:

IF @@TRANCOUNT > 0
ROLLBACK TRAN

insert into tbl_SPError ( ErrorDate, ErrorNumber, ErrorSeverity, ErrorState, ErrorProcedure, ErrorLine, ErrorMessage, ErrorParam )
SELECT
getdate(), 65544, 0, 0, 'rsp_ChangeName' AS ErrorProcedure, ERROR_LINE() as ErrorLine, @ + ' 문에 적용된 행이 없습니다.',
@ID = ' + isnull(CONVERT(varchar, @ID), '' ) + ',' +
@ = ' + isnull(CONVERT(varchar, @), '' ) + ',' +
@ame = ' + isnull(CONVERT(varchar, @ame), '' ) + ',' +
@Name = ' + isnull(CONVERT(varchar, @Name), '' )

select @, @ame
RETURN

[x123x123x]

You can change your nickname this way.

USE [AT_GameDB01]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[rsp_ChangeName]
@ServerID = 100,
@PersonID = 16008, -- from table Person
@Mode = 2, -- mode 2 is change person nickname
@ChangeName = N'NewNickName',
@BeforeName = N'OldNickName'

SELECT 'Return Value' = @return_value

GO

OR one line:

exec [dbo].[rsp_ChangeName] 100, 16008, 2, N'NewNickName', N'OldNickName'

[Richar12]

Originally Posted by faighenzho

This is a KREON v5 client which is similar to this version and can connect to the front server

Happy new year! Continue your hobby, good luck

Thanks for sharing, but I have a problem, I already changed the version of the frontend and versioninfo for 50613 I also modified the ServerIP file for my ip, but when opening the client the screen stays black and it does not show the login

[joeuk]

have same problem, anyone with solution ?

[nagitan]

PLease what file i edit to monster drop your info (basic, location, item etc) to 70% ~~80%?

Thanks

[devillangel]

Originally Posted by nagitan

PLease what file i edit to monster drop your info (basic, location, item etc) to 70% ~~80%?

Thanks

Rates and items are in chariteminfo.ntd ( CharInfo\CharItemInfo.ndt ) it can be edited as file or in game from GM panel.

[nagitan]

Originally Posted by devillangel

Rates and items are in chariteminfo.ntd ( CharInfo\CharItemInfo.ndt ) it can be edited as file or in game from GM panel.

thanks for answer....Yes but there dont have rate mobs info drop, information of mobs (Basic info, location info, item info etc.)

have some file i can edit it? Thanks

[devillangel]

Originally Posted by nagitan

thanks for answer....Yes but there dont have rate mobs info drop, information of mobs (Basic info, location info, item info etc.)

have some file i can edit it? Thanks

When you edit for example drop and save on server/client monster info will reflect those drops. Similar way work file monsterattackinfo etc files in folder/s .
Monster summon locations are directed by file npcgroupinfo .