[Help Thread] Please post your questions here.

[[GA]Sharingan]

Originally Posted by LamiaCore

The problem is I can't tell you a fast general solution for this.
But I already told you a few things you forgot.
(deleting the old dagger-mesh-part, setting correct weight, no additional bones etc)

 Spoiler

Needsellfast already asked me to make an example-video how to add something to an existing model or how to import a new weapon.
At the moment I don't have that much time, so it could take a while :/

After that the best way to learn, is the way I did: Learning by Doing

Yeah learn by doing ^^ but i think for 2 weeks i use blender now its okey

an example video -like- if you have time soon is an good idea.
i try something today about that part to delete old mesh.
Bones and wheights i know nothing but i learn fast. ^^
Some Problems that i have is delete Materials. idk you make them your model have 6 materials you give me back and it has 4. when i delete an material then show up an error on export. but i LEARN!

[fumble2010]

ya Blender is kinda tricky sometime.

Bone = movement points
weight = Vertics bound to the move of a bone

thats the easiest way to explain it ...
@ thanks for your help and yes your right learning by doing is best way
i would also request a video

[アルカード]

nulled

[[GA]Sharingan]

anyone one can give me the 9.3 sframe.

[アルカード]

I made new creature in my db and when i add icon in 02_item.spr i cannot see it ingame.

i made it like this

 Spoiler

icon_creature_0004
1
icon_creature_0004.jpg
34,34
0

[[GA]Sharingan]

Originally Posted by needsellfast

I made new creature in my db and when i add icon in 02_item.spr i cannot see it ingame.

i made it like this

 Spoiler

icon_creature_0004
1
icon_creature_0004.jpg
34,34
0

try to give name in stringresource first. some items have the problem with 9.1 that ingame you not see without a name.. i see on some wings.

look at your itemrdb if is the right name.
then look you have the right format. or try not save and export to jpg. my program has JPEG and jpg i dont know why but its not the same in this prog.
and make all client again.
look spr you have one line at bottom without anything.

[aKa.SeNSeR]

Hallo Leute
nachdem mir dies hier nie beantwortet worden ist, wie man beim Account erstellen Items in die Shopbox gelegt werden und doch sehr viele immer danach gefragt haben hier nun die Lösung ( Rote Zeile beachten ) :-)

 Spoiler

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_insert_character] Script Date: 11.10.2016 14:07:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- start of smp_insert_character
ALTER PROCEDURE [dbo].[smp_insert_character]
@_SID INT OUTPUT,
@IN_NAME NVARCHAR(31),
@IN_ACCOUNT VARCHAR(61),
@IN_ACCOUNT_ID INT,
@IN_SLOT INT,
@IN_X INT,
@IN_Y INT,
@IN_Z INT,
@IN_LAYER INT,
@IN_RACE INT,
@IN_SEX INT,
@IN_LV INT,
@IN_MAX_REACHED_LEVEL INT,
@IN_HP INT,
@IN_MP INT,
@IN_JLV INT,
@IN_JP BIGINT,
@IN_CHA INT,
@IN_SKIN_COLOR INT,
@IN_MODEL_00 INT,
@IN_MODEL_01 INT,
@IN_MODEL_02 INT,
@IN_MODEL_03 INT,
@IN_MODEL_04 INT,
@IN_HAIR_COLOR_INDEX INT,
@IN_TEXTURE_ID INT,
@EFAULT_WEAPON_SID BIGINT,
@EFAULT_WEAPON_CODE INT,
@EFAULT_ARMOR_SID BIGINT,
@EFAULT_ARMOR_CODE INT,
@EFAULT_BAG_SID BIGINT,
@EFAULT_BAG_CODE INT
AS
BEGIN
SET NOCOUNT ON

DECLARE @ INT
SET @ = 0

BEGIN TRANSACTION

SELECT @ = COUNT(*)
FROM dbo.Character WITH (NOLOCK)
WHERE name = @IN_NAME;

IF @ > 0
BEGIN
ROLLBACK TRANSACTION
SET @_SID = 0;
SET @ = -1;
GOTO ON_END
END

INSERT INTO dbo.Character (
-- sid, -- 0
name, -- 1
account, -- 2
account_id, -- 3
slot, -- 4
x, -- 5
y, -- 6
z, -- 7
layer, -- 8
race, -- 9
sex, -- 10
exp, -- 11
last_decreased_exp, -- 12
lv, -- 13
max_reached_level, -- 14
hp, -- 15
mp, -- 16
stamina, -- 17
havoc, -- 18
jlv, -- 19
jp, -- 20
total_jp, -- 21
talent_point, -- 22
job_0, -- 23
job_1, -- 24
job_2, -- 25
jlv_0, -- 26
jlv_1, -- 27
jlv_2, -- 28
immoral_point, -- 29
cha, -- 30
pkc, -- 31
dkc, -- 32
huntaholic_point, -- 33
huntaholic_enter_count, -- 34
ethereal_stone_durability, -- 35
create_time, -- 36
delete_time, -- 37
login_time, -- 38
logout_time, -- 39
login_count, -- 40
play_time, -- 41
belt_00, -- 42
belt_01, -- 43
belt_02, -- 44
belt_03, -- 45
belt_04, -- 46
belt_05, -- 47
permission, -- 48
skin_color, -- 49
model_00, -- 50
model_01, -- 51
model_02, -- 52
model_03, -- 53
model_04, -- 54
hair_color_index, -- 55
hair_color_rgb, -- 56
hide_equip_flag, -- 57
texture_id, -- 58
job, -- 59
gold, -- 60
party_id, -- 61
flag_list, -- 62
-- client_info, -- 63
job_depth, -- 64
summon_0, -- 65
summon_1, -- 66
summon_2, -- 67
summon_3, -- 68
summon_4, -- 69
summon_5, -- 70
main_summon, -- 71
sub_summon, -- 72
remain_summon_time, -- 73
pet, -- 74
main_title, -- 75
sub_title_0, -- 76
sub_title_1, -- 77
sub_title_2, -- 78
sub_title_3, -- 79
sub_title_4, -- 80
remain_title_time, -- 81
arena_point, -- 82
arena_block_time, -- 83
arena_penalty_count, -- 84
arena_penalty_dec_time, -- 85
arena_mvp_count, -- 86
arena_record_0_0, -- 87
arena_record_0_1, -- 88
arena_record_1_0, -- 89
arena_record_1_1, -- 90
arena_record_2_0, -- 91
arena_record_2_1, -- 92
alias, -- 93
chaos, -- 94
adv_chat_count, -- 95
name_changed, -- 96
auto_used, -- 97
pkmode, -- 98
otp_value, -- 99
otp_date, -- 100
chat_block_time -- 101
)
VALUES
(
-- @IN_SID, -- 0 DB? ?? ??
@IN_NAME, -- 1
@IN_ACCOUNT, -- 2
@IN_ACCOUNT_ID, -- 3
@IN_SLOT, -- 4
@IN_X, -- 5
@IN_Y, -- 6
@IN_Z, -- 7
@IN_LAYER, -- 8
@IN_RACE, -- 9
@IN_SEX, -- 10
0, -- 11
0, -- 12
@IN_LV, -- 13
@IN_MAX_REACHED_LEVEL, -- 14
@IN_HP, -- 15
@IN_MP, -- 16
0, -- 17
0, -- 18
@IN_JLV, -- 19
@IN_JP, -- 20
0, -- 21
0, -- 22
0, -- 23
0, -- 24
0, -- 25
0, -- 26
0, -- 27
0, -- 28
0, -- 29
@IN_CHA, -- 30
0, -- 31
0, -- 32
0, -- 33
12, -- 34
0, -- 35
GETDATE(), -- 36
CONVERT( DATETIME, '9999-12-31', 120 ), -- 37
0, -- 38
GETDATE(), -- 39
0, -- 40
0, -- 41
0, -- 42
0, -- 43
0, -- 44
0, -- 45
0, -- 46
0, -- 47
1, -- 48
@IN_SKIN_COLOR, -- 49
@IN_MODEL_00, -- 50
@IN_MODEL_01, -- 51
@IN_MODEL_02, -- 52
@IN_MODEL_03, -- 53
@IN_MODEL_04, -- 54
@IN_HAIR_COLOR_INDEX, -- 55
0, -- 56
0, -- 57
@IN_TEXTURE_ID, -- 58
0, -- 59
0, -- 60
0, -- 61
'', -- 62
-- 0, -- 63
0, -- 64
0, -- 65
0, -- 66
0, -- 67
0, -- 68
0, -- 69
0, -- 70
0, -- 71
0, -- 72
0, -- 73
0, -- 74
0, -- 75
0, -- 76
0, -- 77
0, -- 78
0, -- 79
0, -- 80
0, -- 81
0, -- 82
CONVERT( DATETIME, '2000-1-1', 120 ), -- 83
0, -- 84
CONVERT( DATETIME, '2000-1-1', 120 ), -- 85
0, -- 86
0, -- 87
0, -- 88
0, -- 89
0, -- 90
0, -- 91
0, -- 92
N'', -- 93
0, -- 94
0, -- 95
1, -- 96
0, -- 97
0, -- 98
0, -- 99
GETDATE(), -- 100
0 -- 101
);

IF @@ERROR <> 0
BEGIN
SET @ = -1
ROLLBACK TRANSACTION
GOTO ON_END
END

SET @_SID = SCOPE_IDENTITY();

-- ?? ?? ??
INSERT INTO dbo.Item (
sid, -- 0
owner_id, -- 1
account_id, -- 2
summon_id, -- 3
auction_id, -- 4
keeping_id, -- 5
previous_sid, -- 6
code, -- 7
flag, -- 8
cnt, -- 9
level, -- 10
enhance, -- 11
ethereal_durability, -- 12
endurance, -- 13
gcode, -- 14
create_time, -- 15
wear_info, -- 16
socket_0, -- 17
socket_1, -- 18
socket_2, -- 19
socket_3, -- 20
awaken_sid, -- 21
random_option_sid, -- 22
remain_time, -- 23
elemental_effect_type, -- 24
elemental_effect_expire_time, -- 25
elemental_effect_attack_point, -- 26
elemental_effect_magic_point, -- 27
appearance_code, -- 28
update_time, -- 29
summon_code -- 30
)
VALUES
(
@EFAULT_WEAPON_SID, -- 0
@_SID, -- 1
0, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@EFAULT_WEAPON_CODE, -- 7
0, -- 8
1, -- 9
1, -- 10
0, -- 11
0, -- 12
50, -- 13
6, -- 14
GETDATE(), -- 15
0, -- 16
0, -- 17
0, -- 18
0, -- 19
0, -- 20
0, -- 21
0, -- 22
0, -- 23
0, -- 24
CONVERT( DATETIME, '2000-01-01', 120 ), -- 25
0, -- 26
0, -- 27
0, -- 28
GETDATE(), -- 29
0 -- 30
);

-- ?? ?? ??
INSERT INTO dbo.Item (
sid, -- 0
owner_id, -- 1
account_id, -- 2
summon_id, -- 3
auction_id, -- 4
keeping_id, -- 5
previous_sid, -- 6
code, -- 7
flag, -- 8
cnt, -- 9
level, -- 10
enhance, -- 11
ethereal_durability, -- 12
endurance, -- 13
gcode, -- 14
create_time, -- 15
wear_info, -- 16
socket_0, -- 17
socket_1, -- 18
socket_2, -- 19
socket_3, -- 20
awaken_sid, -- 21
random_option_sid, -- 22
remain_time, -- 23
elemental_effect_type, -- 24
elemental_effect_expire_time, -- 25
elemental_effect_attack_point, -- 26
elemental_effect_magic_point, -- 27
appearance_code, -- 28
update_time, -- 29
summon_code -- 30
)
VALUES
(
@EFAULT_ARMOR_SID, -- 0
@_SID, -- 1
0, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@EFAULT_ARMOR_CODE, -- 7
0, -- 8
1, -- 9
1, -- 10
0, -- 11
0, -- 12
50, -- 13
6, -- 14
GETDATE(), -- 15
2, -- 16
0, -- 17
0, -- 18
0, -- 19
0, -- 20
0, -- 21
0, -- 22
0, -- 23
0, -- 24
CONVERT( DATETIME, '2000-01-01', 120 ), -- 25
0, -- 26
0, -- 27
0, -- 28
GETDATE(), -- 29
0 -- 30
);

-- ?? ?? ??
INSERT INTO dbo.Item (
sid, -- 0
owner_id, -- 1
account_id, -- 2
summon_id, -- 3
auction_id, -- 4
keeping_id, -- 5
previous_sid, -- 6
code, -- 7
flag, -- 8
cnt, -- 9
level, -- 10
enhance, -- 11
ethereal_durability, -- 12
endurance, -- 13
gcode, -- 14
create_time, -- 15
wear_info, -- 16
socket_0, -- 17
socket_1, -- 18
socket_2, -- 19
socket_3, -- 20
awaken_sid, -- 21
random_option_sid, -- 22
remain_time, -- 23
elemental_effect_type, -- 24
elemental_effect_expire_time, -- 25
elemental_effect_attack_point, -- 26
elemental_effect_magic_point, -- 27
appearance_code, -- 28
update_time, -- 29
summon_code -- 30
)
VALUES
(
@EFAULT_BAG_SID, -- 0
@_SID, -- 1
0, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@EFAULT_BAG_CODE, -- 7
0, -- 8
1, -- 9
1, -- 10
0, -- 11
0, -- 12
50, -- 13
6, -- 14
GETDATE(), -- 15
23, -- 16
0, -- 17
0, -- 18
0, -- 19
0, -- 20
0, -- 21
0, -- 22
0, -- 23
0, -- 24
CONVERT( DATETIME, '2000-01-01', 120 ), -- 25
0, -- 26
0, -- 27
0, -- 28
GETDATE(), -- 29
0 -- 30
);

IF NOT EXISTS(SELECT * FROM dbo.PaidItem WHERE account_id = @IN_ACCOUNT_ID AND item_code = 690446)
BEGIN
DECLARE @_id INT
SET @_id = (SELECT ISNULL(MAX(buy_id)+1, 0) FROM dbo.PaidItem)

--Süßer Mondhase 30 Tage
INSERT INTO [dbo].[PaidItem]([buy_id],[account_id],[avatar_id],[avatar_name],[server_name],[taken_account_id],[taken_avatar_id],[taken_avatar_name],[taken_server_name],[item_code],[item_count],[TYPE],[rest_item_count],[confirmed],[confirmed_time],[bought_time],[valid_time],[taken_time],[isCancel])
VALUES @_id,@IN_ACCOUNT_ID,0,'','',@IN_ACCOUNT_ID,0,'','', 690446,1,0,1,1,GETDATE(),GETDATE(),GETDATE()+300,G ETDATE(),0)

END;

ON_SUCCESS:
COMMIT TRANSACTION

ON_END:
RETURN @

-- end of smp_insert_character
END

[azaaza007]

Hi all, does anyone have a NPC to unlock the Guild

[アルカード]

I wanted to change SplashLoading screen to my client.Do i need hex exe to change to new one.since i tried just to edit jpg's and it there isn't change or is there a nui where this should be changed?

[dimonius92]

Don't work script gifts for online, Arcadia v0.2 7.4+8.1

 Spoiler

Assuming your LUAs haven't been modified you won't have to add anything besides your own code. This is the important stuff:

server_init.lua:
Code:
[...]
function on_server_init()
[...]
for_event_by_liveteam() --라이브팀 사용 범위로 NPC_EVENT 스크립트에서 사용된다.
end
[...]NPC_Event.lua:
Code:
[...]
function for_event_by_liveteam()

play_time_event() --플레이 타임 이벤트
[...]
end

function play_time_event()

[...]
set_env( "game.use_time_based_event_script",1 )
set_env( "game.term_for_time_based_event_script",120 )
--change the value above to your desired interval in minutes!
[...]
end

function on_time_based_event_reward()

local state_code = get_local_info() -- 국가코드
local pcbang_grade = get_value("pcbang_user") -- 프리미엄PC방 판단변수
local t_flag = get_flag( "reward_time_event" ) -- 캐릭터 별 플래그 값
local account_t_flag = get_account_flag( "reward_time_event" ) -- 계정 별 플래그 값
local current_time = get_os_date( "%Y-%m-%d %H:%M:%S" )
local flag_current_time = get_os_date( "%Y-%m-%d" )
local event_current_week = 0
local lv = get_value( "level" )

--add your own code below!

[...]
end
[...]

My table:

 Spoiler

[sid]
,[name]
,[account]
,[account_id]
,[party_id]
,[guild_id]
,[prev_guild_id]
,[slot]
,[permission]
,[x]
,[y]
,[z]
,[layer]
,[race]
,[sex]
,[lv]
,[max_reached_level]
,[exp]
,[last_decreased_exp]
,[hp]
,[mp]
,[stamina]
,[havoc]
,[job]
,[job_depth]
,[jlv]
,[jp]
,[total_jp]
,[talent_point]
,[job_0]
,[job_1]
,[job_2]
,[jlv_0]
,[jlv_1]
,[jlv_2]
,[immoral_point]
,[cha]
,[pkc]
,[dkc]
,[huntaholic_point]
,[huntaholic_enter_count]
,[ethereal_stone_durability]
,[gold]
,[chaos]
,[skin_color]
,[model_00]
,[model_01]
,[model_02]
,[model_03]
,[model_04]
,[hair_color_index]
,[hair_color_rgb]
,[hide_equip_flag]
,[texture_id]
,[belt_00]
,[belt_01]
,[belt_02]
,[belt_03]
,[belt_04]
,[belt_05]
,[summon_0]
,[summon_1]
,[summon_2]
,[summon_3]
,[summon_4]
,[summon_5]
,[main_summon]
,[sub_summon]
,[remain_summon_time]
,[pet]
,[create_time]
,[delete_time]
,[login_time]
,[login_count]
,[logout_time]
,[play_time]
,[chat_block_time]
,[adv_chat_count]
,[name_changed]
,[auto_used]
,[guild_block_time]
,[pkmode]
,[otp_value]
,[otp_date]
,[flag_list]
,[client_info]

[ThunderNikk]

What's not working for you?

You just don't get the time based gifts?

Are you sure the .lua edits were done correctly?

I am not sure what this has to do with your character table using global variables.
@

I think you would have to edit the .exe and recompile it. I think.

I actually don't include it in my clients because however they wrote the code in it, it actually overloads some weaker computers and can cause them not to load the game at all.

Gala developers are not exactly good at what they do.

[dimonius92]

Originally Posted by thndr

What's not working for you?

You just don't get the time based gifts?

Are you sure the .lua edits were done correctly?

I am not sure what this has to do with your character table using global variables.

npc_event

 Spoiler

-- Lua 스크립트 암호화
function for_event_by_liveteam()

play_time_event() --플레이 타임 이벤트

end

function play_time_event()

set_env( "game.use_time_based_event_script",1 )
set_env( "game.term_for_time_based_event_script",2 )
--change the value above to your desired interval in minutes!

end

function on_time_based_event_reward()

local state_code = get_local_info() -- 국가코드
local login_time = get_value("login_time") -- 프리미엄PC방 판단변수
local t_flag = get_flag( "login_time" ) -- 캐릭터 별 플래그 값
local account_t_flag = get_account_flag( "login_time" ) -- 계정 별 플래그 값
local current_time = get_os_date( "%Y-%m-%d %H:%M:%S" )
local flag_current_time = get_os_date( "%Y-%m-%d" )
local event_current_week = 0
local lv = get_value( "level" )

insert_item(3620019, 10)
end


function get_module_name()
return "NPC_Event"
end

--================================================== ==========
-- <<<<<< 스킬 카드 변경 이벤트 >>>>>>
--================================================== ==========

function NPC_Event_SkillCard_Changer_contact()

-- 국가 코드 읽어오기
-- get_local_info()의 반환값들
--LOCAL_INFO_KOREA = 1
--LOCAL_INFO_HONGKONG = 2
--LOCAL_INFO_AMERICA = 4
--LOCAL_INFO_EUROPE = 8
--LOCAL_INFO_JAPAN = 16
--LOCAL_INFO_TAIWAN = 32
--LOCAL_INFO_CHINA = 64

local state_code = get_local_info()


-- 대만일 경우
if state_code == 32 then
-- 투구 교환 메뉴
dlg_title("@90994801")
dlg_text( "@90994311" )
dlg_menu( "@90994310", "Change_helm_main()" )
else

dlg_title("@90994301")
dlg_text( "@90994302" )
dlg_menu( "@90010188", "Change_Skill_Card_main()" )

end
dlg_menu( "@90010002", '' )
dlg_show()

end

function Change_helm_main()
dlg_title("@90994801")
dlg_text( "@90994311" )

-- 2랭크 투구 교환
dlg_menu( "@90994312", 'Change_Selected_helm(2)' )
-- 3랭크 투구 교환
dlg_menu( "@90994313", 'Change_Selected_helm(3)' )
dlg_menu( "@90010002", '' )
dlg_show()


end

function Change_Selected_helm( item_rank )

local owned_item_id, selected_item_id

if item_rank == 2 then
owned_item_id = 302203
selected_item_id = 302204
elseif item_rank == 3 then
owned_item_id = 302303
selected_item_id = 302304
else
cprint("server script error : item_rank is not available = ".. item_rank)
end

local count = find_item( owned_item_id )
local handle = get_item_handle( owned_item_id )

-- 삭제할 아이템의 인핸스, 레벨 체크.
local enhance = get_item_enhance( handle )
local level = get_item_level( handle )

local stone_ID = { 0, 0, 0, 0 }

-- 소켓에 박힌 소울스톤ID 얻어오는 함수와 소켓에 소울스톤 박는 함수.
-- get_socket_info( handle, socket_slot_pos )
-- set_socket_info( handle, socket_slot_pos, socket_id )
-- 기존 아이템의 소켓에 박힌 소울 스톤 ID 얻어 오기.
for i = 0, 3 do
stone_ID[i+1] = get_socket_info( handle, i )
end


if count == 0 or is_erasable_item( handle ) == 0 then
dlg_title("@90994801")
dlg_text( "@90994314" )
dlg_menu( "@90010002", '' )
dlg_show()
return
else
delete_item(handle,1)
-- 넣어줄 아이템은 삭제할 아이템의 레벨, 인핸스 상태를 이어 받는다.
insert_item( selected_item_id, 1, enhance, level )

-- 넣어줄 아이템의 소켓에 소울스톤 박기
local new_item_handle = get_item_handle( selected_item_id )

for j = 0, 3 do
set_socket_info( new_item_handle, j, stone_ID[j+1] )
end


dlg_title("@90994801")
local text = sconv("@90994315", "#@item_rank@#",tostring(item_rank) )
dlg_text( text )
dlg_menu( "@90010002", '' )
dlg_show()
end


end

server_init

 Spoiler

--- Lua 스크립트 암호화.
function get_module_name()
return "server_init"
end

function on_server_init()
roaming()
rare_mob()
guardian_spawn()
random_respawn()
for_event_by_liveteam()
end

[TheOnlyOneRaskim]

Originally Posted by aKa.SeNSeR

Hallo Leute
nachdem mir dies hier nie beantwortet worden ist, wie man beim Account erstellen Items in die Shopbox gelegt werden und doch sehr viele immer danach gefragt haben hier nun die Lösung ( Rote Zeile beachten ) :-)

 Spoiler

USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_insert_character] Script Date: 11.10.2016 14:07:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- start of smp_insert_character
ALTER PROCEDURE [dbo].[smp_insert_character]
@_SID INT OUTPUT,
@IN_NAME NVARCHAR(31),
@IN_ACCOUNT VARCHAR(61),
@IN_ACCOUNT_ID INT,
@IN_SLOT INT,
@IN_X INT,
@IN_Y INT,
@IN_Z INT,
@IN_LAYER INT,
@IN_RACE INT,
@IN_SEX INT,
@IN_LV INT,
@IN_MAX_REACHED_LEVEL INT,
@IN_HP INT,
@IN_MP INT,
@IN_JLV INT,
@IN_JP BIGINT,
@IN_CHA INT,
@IN_SKIN_COLOR INT,
@IN_MODEL_00 INT,
@IN_MODEL_01 INT,
@IN_MODEL_02 INT,
@IN_MODEL_03 INT,
@IN_MODEL_04 INT,
@IN_HAIR_COLOR_INDEX INT,
@IN_TEXTURE_ID INT,
@EFAULT_WEAPON_SID BIGINT,
@EFAULT_WEAPON_CODE INT,
@EFAULT_ARMOR_SID BIGINT,
@EFAULT_ARMOR_CODE INT,
@EFAULT_BAG_SID BIGINT,
@EFAULT_BAG_CODE INT
AS
BEGIN
SET NOCOUNT ON

DECLARE @ INT
SET @ = 0

BEGIN TRANSACTION

SELECT @ = COUNT(*)
FROM dbo.Character WITH (NOLOCK)
WHERE name = @IN_NAME;

IF @ > 0
BEGIN
ROLLBACK TRANSACTION
SET @_SID = 0;
SET @ = -1;
GOTO ON_END
END

INSERT INTO dbo.Character (
-- sid, -- 0
name, -- 1
account, -- 2
account_id, -- 3
slot, -- 4
x, -- 5
y, -- 6
z, -- 7
layer, -- 8
race, -- 9
sex, -- 10
exp, -- 11
last_decreased_exp, -- 12
lv, -- 13
max_reached_level, -- 14
hp, -- 15
mp, -- 16
stamina, -- 17
havoc, -- 18
jlv, -- 19
jp, -- 20
total_jp, -- 21
talent_point, -- 22
job_0, -- 23
job_1, -- 24
job_2, -- 25
jlv_0, -- 26
jlv_1, -- 27
jlv_2, -- 28
immoral_point, -- 29
cha, -- 30
pkc, -- 31
dkc, -- 32
huntaholic_point, -- 33
huntaholic_enter_count, -- 34
ethereal_stone_durability, -- 35
create_time, -- 36
delete_time, -- 37
login_time, -- 38
logout_time, -- 39
login_count, -- 40
play_time, -- 41
belt_00, -- 42
belt_01, -- 43
belt_02, -- 44
belt_03, -- 45
belt_04, -- 46
belt_05, -- 47
permission, -- 48
skin_color, -- 49
model_00, -- 50
model_01, -- 51
model_02, -- 52
model_03, -- 53
model_04, -- 54
hair_color_index, -- 55
hair_color_rgb, -- 56
hide_equip_flag, -- 57
texture_id, -- 58
job, -- 59
gold, -- 60
party_id, -- 61
flag_list, -- 62
-- client_info, -- 63
job_depth, -- 64
summon_0, -- 65
summon_1, -- 66
summon_2, -- 67
summon_3, -- 68
summon_4, -- 69
summon_5, -- 70
main_summon, -- 71
sub_summon, -- 72
remain_summon_time, -- 73
pet, -- 74
main_title, -- 75
sub_title_0, -- 76
sub_title_1, -- 77
sub_title_2, -- 78
sub_title_3, -- 79
sub_title_4, -- 80
remain_title_time, -- 81
arena_point, -- 82
arena_block_time, -- 83
arena_penalty_count, -- 84
arena_penalty_dec_time, -- 85
arena_mvp_count, -- 86
arena_record_0_0, -- 87
arena_record_0_1, -- 88
arena_record_1_0, -- 89
arena_record_1_1, -- 90
arena_record_2_0, -- 91
arena_record_2_1, -- 92
alias, -- 93
chaos, -- 94
adv_chat_count, -- 95
name_changed, -- 96
auto_used, -- 97
pkmode, -- 98
otp_value, -- 99
otp_date, -- 100
chat_block_time -- 101
)
VALUES
(
-- @IN_SID, -- 0 DB? ?? ??
@IN_NAME, -- 1
@IN_ACCOUNT, -- 2
@IN_ACCOUNT_ID, -- 3
@IN_SLOT, -- 4
@IN_X, -- 5
@IN_Y, -- 6
@IN_Z, -- 7
@IN_LAYER, -- 8
@IN_RACE, -- 9
@IN_SEX, -- 10
0, -- 11
0, -- 12
@IN_LV, -- 13
@IN_MAX_REACHED_LEVEL, -- 14
@IN_HP, -- 15
@IN_MP, -- 16
0, -- 17
0, -- 18
@IN_JLV, -- 19
@IN_JP, -- 20
0, -- 21
0, -- 22
0, -- 23
0, -- 24
0, -- 25
0, -- 26
0, -- 27
0, -- 28
0, -- 29
@IN_CHA, -- 30
0, -- 31
0, -- 32
0, -- 33
12, -- 34
0, -- 35
GETDATE(), -- 36
CONVERT( DATETIME, '9999-12-31', 120 ), -- 37
0, -- 38
GETDATE(), -- 39
0, -- 40
0, -- 41
0, -- 42
0, -- 43
0, -- 44
0, -- 45
0, -- 46
0, -- 47
1, -- 48
@IN_SKIN_COLOR, -- 49
@IN_MODEL_00, -- 50
@IN_MODEL_01, -- 51
@IN_MODEL_02, -- 52
@IN_MODEL_03, -- 53
@IN_MODEL_04, -- 54
@IN_HAIR_COLOR_INDEX, -- 55
0, -- 56
0, -- 57
@IN_TEXTURE_ID, -- 58
0, -- 59
0, -- 60
0, -- 61
'', -- 62
-- 0, -- 63
0, -- 64
0, -- 65
0, -- 66
0, -- 67
0, -- 68
0, -- 69
0, -- 70
0, -- 71
0, -- 72
0, -- 73
0, -- 74
0, -- 75
0, -- 76
0, -- 77
0, -- 78
0, -- 79
0, -- 80
0, -- 81
0, -- 82
CONVERT( DATETIME, '2000-1-1', 120 ), -- 83
0, -- 84
CONVERT( DATETIME, '2000-1-1', 120 ), -- 85
0, -- 86
0, -- 87
0, -- 88
0, -- 89
0, -- 90
0, -- 91
0, -- 92
N'', -- 93
0, -- 94
0, -- 95
1, -- 96
0, -- 97
0, -- 98
0, -- 99
GETDATE(), -- 100
0 -- 101
);

IF @@ERROR <> 0
BEGIN
SET @ = -1
ROLLBACK TRANSACTION
GOTO ON_END
END

SET @_SID = SCOPE_IDENTITY();

-- ?? ?? ??
INSERT INTO dbo.Item (
sid, -- 0
owner_id, -- 1
account_id, -- 2
summon_id, -- 3
auction_id, -- 4
keeping_id, -- 5
previous_sid, -- 6
code, -- 7
flag, -- 8
cnt, -- 9
level, -- 10
enhance, -- 11
ethereal_durability, -- 12
endurance, -- 13
gcode, -- 14
create_time, -- 15
wear_info, -- 16
socket_0, -- 17
socket_1, -- 18
socket_2, -- 19
socket_3, -- 20
awaken_sid, -- 21
random_option_sid, -- 22
remain_time, -- 23
elemental_effect_type, -- 24
elemental_effect_expire_time, -- 25
elemental_effect_attack_point, -- 26
elemental_effect_magic_point, -- 27
appearance_code, -- 28
update_time, -- 29
summon_code -- 30
)
VALUES
(
@EFAULT_WEAPON_SID, -- 0
@_SID, -- 1
0, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@EFAULT_WEAPON_CODE, -- 7
0, -- 8
1, -- 9
1, -- 10
0, -- 11
0, -- 12
50, -- 13
6, -- 14
GETDATE(), -- 15
0, -- 16
0, -- 17
0, -- 18
0, -- 19
0, -- 20
0, -- 21
0, -- 22
0, -- 23
0, -- 24
CONVERT( DATETIME, '2000-01-01', 120 ), -- 25
0, -- 26
0, -- 27
0, -- 28
GETDATE(), -- 29
0 -- 30
);

-- ?? ?? ??
INSERT INTO dbo.Item (
sid, -- 0
owner_id, -- 1
account_id, -- 2
summon_id, -- 3
auction_id, -- 4
keeping_id, -- 5
previous_sid, -- 6
code, -- 7
flag, -- 8
cnt, -- 9
level, -- 10
enhance, -- 11
ethereal_durability, -- 12
endurance, -- 13
gcode, -- 14
create_time, -- 15
wear_info, -- 16
socket_0, -- 17
socket_1, -- 18
socket_2, -- 19
socket_3, -- 20
awaken_sid, -- 21
random_option_sid, -- 22
remain_time, -- 23
elemental_effect_type, -- 24
elemental_effect_expire_time, -- 25
elemental_effect_attack_point, -- 26
elemental_effect_magic_point, -- 27
appearance_code, -- 28
update_time, -- 29
summon_code -- 30
)
VALUES
(
@EFAULT_ARMOR_SID, -- 0
@_SID, -- 1
0, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@EFAULT_ARMOR_CODE, -- 7
0, -- 8
1, -- 9
1, -- 10
0, -- 11
0, -- 12
50, -- 13
6, -- 14
GETDATE(), -- 15
2, -- 16
0, -- 17
0, -- 18
0, -- 19
0, -- 20
0, -- 21
0, -- 22
0, -- 23
0, -- 24
CONVERT( DATETIME, '2000-01-01', 120 ), -- 25
0, -- 26
0, -- 27
0, -- 28
GETDATE(), -- 29
0 -- 30
);

-- ?? ?? ??
INSERT INTO dbo.Item (
sid, -- 0
owner_id, -- 1
account_id, -- 2
summon_id, -- 3
auction_id, -- 4
keeping_id, -- 5
previous_sid, -- 6
code, -- 7
flag, -- 8
cnt, -- 9
level, -- 10
enhance, -- 11
ethereal_durability, -- 12
endurance, -- 13
gcode, -- 14
create_time, -- 15
wear_info, -- 16
socket_0, -- 17
socket_1, -- 18
socket_2, -- 19
socket_3, -- 20
awaken_sid, -- 21
random_option_sid, -- 22
remain_time, -- 23
elemental_effect_type, -- 24
elemental_effect_expire_time, -- 25
elemental_effect_attack_point, -- 26
elemental_effect_magic_point, -- 27
appearance_code, -- 28
update_time, -- 29
summon_code -- 30
)
VALUES
(
@EFAULT_BAG_SID, -- 0
@_SID, -- 1
0, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@EFAULT_BAG_CODE, -- 7
0, -- 8
1, -- 9
1, -- 10
0, -- 11
0, -- 12
50, -- 13
6, -- 14
GETDATE(), -- 15
23, -- 16
0, -- 17
0, -- 18
0, -- 19
0, -- 20
0, -- 21
0, -- 22
0, -- 23
0, -- 24
CONVERT( DATETIME, '2000-01-01', 120 ), -- 25
0, -- 26
0, -- 27
0, -- 28
GETDATE(), -- 29
0 -- 30
);

IF NOT EXISTS(SELECT * FROM dbo.PaidItem WHERE account_id = @IN_ACCOUNT_ID AND item_code = 690446)
BEGIN
DECLARE @_id INT
SET @_id = (SELECT ISNULL(MAX(buy_id)+1, 0) FROM dbo.PaidItem)

--Süßer Mondhase 30 Tage
INSERT INTO [dbo].[PaidItem]([buy_id],[account_id],[avatar_id],[avatar_name],[server_name],[taken_account_id],[taken_avatar_id],[taken_avatar_name],[taken_server_name],[item_code],[item_count],[TYPE],[rest_item_count],[confirmed],[confirmed_time],[bought_time],[valid_time],[taken_time],[isCancel])
VALUES @_id,@IN_ACCOUNT_ID,0,'','',@IN_ACCOUNT_ID,0,'','', 690446,1,0,1,1,GETDATE(),GETDATE(),GETDATE()+300,G ETDATE(),0)

END;

ON_SUCCESS:
COMMIT TRANSACTION

ON_END:
RETURN @

-- end of smp_insert_character
END

Kommt mir sehr bekannt vor.

[ThunderNikk]

Originally Posted by dimonius92

npc_event

Try adding the new functions to the npc_event module after the module name instead of before the module name.

[MrStubborn]

Hello everyone, I am building a website for rappelz,
so I am curios which Auth and telecaster DB i must use
so suggest me the most common one, and less errors.