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 ) :-)
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]
@ [Only registered and activated users can see links. Click Here To Register...]_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,
@ [Only registered and activated users can see links. Click Here To Register...]EFAULT_WEAPON_SID BIGINT,
@ [Only registered and activated users can see links. Click Here To Register...]EFAULT_WEAPON_CODE INT,
@ [Only registered and activated users can see links. Click Here To Register...]EFAULT_ARMOR_SID BIGINT,
@ [Only registered and activated users can see links. Click Here To Register...]EFAULT_ARMOR_CODE INT,
@ [Only registered and activated users can see links. Click Here To Register...]EFAULT_BAG_SID BIGINT,
@ [Only registered and activated users can see links. Click Here To Register...]EFAULT_BAG_CODE INT
AS
BEGIN
SET NOCOUNT ON
DECLARE @ [Only registered and activated users can see links. Click Here To Register...] INT
SET @ [Only registered and activated users can see links. Click Here To Register...] = 0
BEGIN TRANSACTION
SELECT @ [Only registered and activated users can see links. Click Here To Register...] = COUNT(*)
FROM dbo.Character WITH (NOLOCK)
WHERE name = @IN_NAME;
IF @ [Only registered and activated users can see links. Click Here To Register...] > 0
BEGIN
ROLLBACK TRANSACTION
SET @ [Only registered and activated users can see links. Click Here To Register...]_SID = 0;
SET @ [Only registered and activated users can see links. Click Here To Register...] = -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 @ [Only registered and activated users can see links. Click Here To Register...] = -1
ROLLBACK TRANSACTION
GOTO ON_END
END
SET @ [Only registered and activated users can see links. Click Here To Register...]_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
(
@ [Only registered and activated users can see links. Click Here To Register...]EFAULT_WEAPON_SID, -- 0
@ [Only registered and activated users can see links. Click Here To Register...]_SID, -- 1
0, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@ [Only registered and activated users can see links. Click Here To Register...]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
(
@ [Only registered and activated users can see links. Click Here To Register...]EFAULT_ARMOR_SID, -- 0
@ [Only registered and activated users can see links. Click Here To Register...]_SID, -- 1
0, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@ [Only registered and activated users can see links. Click Here To Register...]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
(
@ [Only registered and activated users can see links. Click Here To Register...]EFAULT_BAG_SID, -- 0
@ [Only registered and activated users can see links. Click Here To Register...]_SID, -- 1
0, -- 2
0, -- 3
0, -- 4
0, -- 5
0, -- 6
@ [Only registered and activated users can see links. Click Here To Register...]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 @ [Only registered and activated users can see links. Click Here To Register...]_id INT
SET @ [Only registered and activated users can see links. Click Here To Register...]_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 @ [Only registered and activated users can see links. Click Here To Register...]_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 @ [Only registered and activated users can see links. Click Here To Register...]
-- end of smp_insert_character
END
|