المشاركة الأصلية كتبت بواسطة glaiverss
(المشاركة 4120288)
كود PHP:
use [sro_vt_shard]
go
/****** object: Storedprocedure [dbo].[_addnewchar] script date: 04/21/2012 01:48:02 ******/
set ansi_nulls on
go
set quoted_identifier on
go
alter procedure [dbo].[_addnewchar]
@userjid int,
--@charslot int,
@refcharid int,
@charname varchar (64),
@charscale tinyint,
@startregionid int,
@startpos_x real,
@startpos_y real,
@startpos_z real,
@defaultteleport int,
@refmailid int,
@refpantsid int,
@refbootsid int,
@refweaponid int,
@refshield int,
@durmail tinyint,
@durpants tinyint,
@durboots tinyint,
@durweapon tinyint,
@durshield tinyint,
@defaultarrow int
as
set nocount on
declare @slot int
declare @temp int
declare @newcharid int
set @newcharid = 0
-----------------------------------------------------------------------------
-- 1. ij¸¯ÅÍ ½½·Ô ³Ñ¹ö°¡ validÇÑ °ÍÀÎÁö, ±×¸®°í ºó½½·ÔÀÌ ¸Â´ÂÁö ¸ÕÀú üũÇÑ´Ù.
-----------------------------------------------------------------------------
-- start by novice.
Select @temp = count(charid) from _user with (nolock) where userjid = @userjid
if (@temp >= 4)
begin
-- ³Ê¹« ¸¹ÀÚ³ª
return -2
end
-- finish by novice.
-----------------------------------------------------------------------------
-- 2. ij¸¯ÅÍ Ãß°¡Çϱâ
-----------------------------------------------------------------------------
if (@charscale > 68) -- 0100 0100 --> 68 ÀÌ´Ù!
Begin
-- ij¸¯ÅÍ »ý¼º ½ÇÆÐ! ½ºÄÉÀÏ °ªÀÌ ÀÌ»óÇÏ´Ù!
Return -3
end
exec @temp = _isexistingcharname @charname
if (@temp <> 0)
begin
-- ÀÌ¹Ì »ç¿ëÁßÀÎ À̸§À̶ó´Âµ¥?
Return -4
end
begin transaction
-- Àδø½Ã½ºÅÛÀÌ Àû¿ëµÇ¸é¼* ¸¶Áö¸·¿¡ worldid¿Í 1°ªÀ» ´õ ³Ö¾î ÁÖ¾ú´Ù!
Insert into _char (refobjid, charname16, scale, strength, intellect, latestregion,posx, posy, posz, appointedteleport, inventorysize,
lastlogout, curlevel, maxlevel, remaingold, remainstatpoint, remainskillpoint, hp, mp, joblvl_trader, joblvl_hunter, joblvl_robber, worldid)
values (@refcharid, @charname, @charscale, 20, 20, @startregionid, @startpos_x, @startpos_y, @startpos_z, @defaultteleport, 109,
getdate(), 1, 110, 0, 0, 0, 200,200, 1, 1, 1, 1)
set @newcharid = @@identity
if (@@error <> 0 or @@rowcount = 0)
begin
-- ij¸¯ÅÍ »ý¼º ½ÇÆÐ!
Rollback transaction
return -5
end
-- start by novice.
-- ÀÌÁ¦ slot ¾È¾´´Ù.. ±×³É insert ¸¸..
Insert into _user values (@userjid, @newcharid)
-- finish by novice.
-----------------------------------------------------------------------------
-- 3-1. Àåºñ ½½·Ô ä¿ì±â
-- [Àκ¥Å丮 ½½·Ô 96°³] + [Àåºñ½½·Ô 13°³] <- Àκ¥Å丮 È®Àå ¼*ºñ½º ÈÄ 48°³¿¡¼* 96°³·Î Áõ°¡!!!(woos0)
-----------------------------------------------------------------------------
--patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!
Insert into _inventory(charid, slot, itemid)
select @newcharid, cnt, 0
from _refdummyslot with( nolock )
where cnt < 109
if (@@error <> 0)
begin
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
Rollback transaction
return -7
end
--patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!
-- µðÆúÆ®·Î ¼±ÅÃÇÑ ¾ÆÀÌÅÛÀ» ´Ù½Ã ³Ö¾îÁÖÀÚ...
/* ¿ä·± ¼ø¼*·Î Á¤ÀǵǾî ÀÖ´Ù.
0: Equip_slot_helm
1: Equip_slot_mail,
2: Equip_slot_shoulderguard,
3: Equip_slot_gauntlet,
4: Equip_slot_pants,
5: Equip_slot_boots,
6: Equip_slot_weapon,
7: Equip_slot_shield or arrow,
8: Equip_slot_earring,
9: Equip_slot_necklace,
10: Equip_slot_l_ring,
11: Equip_slot_r_ring,
*/
declare @itemid bigint
set @itemid = 0
-- »ó°©
if (@refmailid <> 0)
begin
exec @itemid = _fn_add_initial_equip @newcharid, 1, @refmailid, @durmail
if (@itemid <= 0)
begin
rollback transaction
return -8
end
end
-- ¹ÙÁö
if (@refpantsid <> 0)
begin
exec @itemid = _fn_add_initial_equip @newcharid, 4, @refpantsid, @durpants
if (@itemid <= 0)
begin
rollback transaction
return -9
end
end
-- boots
if (@refbootsid <> 0)
begin
exec @itemid = _fn_add_initial_equip @newcharid, 5, @refbootsid, @durboots
if (@itemid <= 0)
begin
rollback transaction
return -10
end
end
-- weapon
if (@refweaponid <> 0)
begin
exec @itemid = _fn_add_initial_equip @newcharid, 6, @refweaponid, @durweapon
if (@itemid <= 0)
begin
rollback transaction
return -11
end
end
-- ¹æÆÐ
if (@refshield <> 0)
begin
exec @itemid = _fn_add_initial_equip @newcharid, 7, @refshield, @durshield
if (@itemid <= 0)
begin
rollback transaction
return -12
end
end
-- Ȥ½Ã default·Î ¼±ÅÃÇÑ ¹«±â°¡ È°À̶ó¸é È*»ì 250°³µéÀÌ È°Åëµµ ÇÔ²² ÁØ´Ù. ÁÒÄ¡?
If (@defaultarrow <> 0)
begin
exec @itemid = _fn_add_initial_equip @newcharid, 7, @defaultarrow, 250
if (@itemid <= 0)
begin
rollback transaction
return -13
end
end
-----------------------------------------------------------------------------
-- 3-2. ¾Æ¹ÙŸ inventory ½½·Ô ä¿ì±â
-- [¾Æ¹ÙŸ Àκ¥Å丮 ½½·Ô 5°³]
-- apply_avatar_systemÀÌ Àû¿ëµÇ¸é¼* Ãß°¡µÇ´Â ºÎºÐ
-----------------------------------------------------------------------------
--patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!
Insert into _inventoryforavatar(charid, slot, itemid)
select @newcharid, cnt, 0
from _refdummyslot with( nolock )
where cnt < 5
if (@@error <> 0)
begin
-- ¾Æ¹ÙŸ Àκ¥Å丮 »ý¼º ½ÇÆÐ!
Rollback transaction
return -14
end
--patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!patch warning!!!
-----------------------------------------------------------------------------
-- default skill³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
declare @country tinyint
exec @country = _getobjcountry @refcharid
insert into _charskillmastery (charid, masteryid, level)
select @newcharid, masteryid, 0
from _refchardefault_skillmastery with(nolock)
where race = @country or race = 3
if (@@error <> 0)
begin
rollback transaction
return -15
end
insert into _charskill (charid,skillid,enable)
select @newcharid, skillid, 1
from _refchardefault_skill with(nolock)
where race = @country or race = 3
if (@@error <> 0)
begin
rollback transaction
return -16
end
-----------------------------------------------------------------------------
-- ±âº» Äù½ºÆ® ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
insert into _charquest (charid, questid, status, achievementcount, starttime, endtime, questdata1, questdata2)
select @newcharid, id, 1, 0, getdate(), getdate(), 0, 0
from _refquest
where codename in (select codename from _refchardefault_quest with(nolock) where (race = @country or race = 3) and requiredlevel = 1 and service = 1)
if (@@error <> 0)
begin
rollback transaction
return -17
end
-----------------------------------------------------------------------------
-- static avatar initial record ³Ö±â
-----------------------------------------------------------------------------
insert into _staticavatar(charid) values(@newcharid)
if (@@error <> 0)
begin
rollback transaction
return -18
end
-----------------------------------------------------------------------------
-- trijob ä¿ö³Ö±â!!!!!
-----------------------------------------------------------------------------
insert into _chartrijob values (@newcharid, 0, 1, 0, 0, 0)
if (@@error <> 0)
begin
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
Rollback transaction
return -19
end
-----------------------------------------------------------------------------
-- charlist¿¡ id ³Ö¾îÁÖ±â
-----------------------------------------------------------------------------
insert _charnamelist values(@charname, @newcharid)
exec _add_item_extern @charname,'item_mall_return_scroll_high_speed',20,1
exec _add_item_extern @charname,'item_mall_premium_vietnam_goldtime_plus',1,1
exec _add_item_extern @charname,'item_mall_skill_gold_time_service_ticket_4w',1,1
exec _add_item_extern @charname,'item_mall_damage_abs_20p_scroll',11,1
exec _add_item_extern @charname,'item_mall_damage_inc_20p_scroll',11,1
exec _add_item_extern @charname,'item_mall_reverse_return_scroll',11,1
exec _add_item_extern @charname,'item_mall_hp_superset_5_bag',1000,1
exec _add_item_extern @charname,'item_mall_mp_superset_5_bag',1000,1
exec _add_item_extern @charname,'item_cos_p_flute_white',1,1
exec _add_item_extern @charname,'item_cos_p_rabbit_scroll_silk',1,1
-- quick slot Á¤º¸ ÀúÀå¿ë!!!
Exec _addnewclientconfig @newcharid -- by novice...... For saving client configurations...
Commit transaction
return @newcharid
|
