|
You last visited: Today at 06:55
Advertisement
[Error] creating char error
Discussion on [Error] creating char error within the SRO Private Server forum part of the Silkroad Online category.
01/28/2015, 14:20
|
#16
|
elite*gold: 0 
Join Date: Aug 2012
Posts: 748
Received Thanks: 227
|
Can I see your _AddNewChar SP?
Quote:
Originally Posted by xExorcist
Use a clean database or another _AddNewChar SP
|
And, xExorcist, you can't tell anyone to use a clean database as a solution, that's stupid tbh, most-likely he at least has changed one thing in his database, that he is not willing to re-change.
|
|
|
|
01/29/2015, 06:24
|
#17
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
Quote:
Originally Posted by Zodiao
Can I see your _AddNewChar SP?
And, xExorcist, you can't tell anyone to use a clean database as a solution, that's stupid tbh, most-likely he at least has changed one thing in his database, that he is not willing to re-change.
|
That's why we said try a different _AddNewChar procedure, probably something is wrong there.
|
|
|
|
|
01/29/2015, 08:13
|
#18
|
elite*gold: 15
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
|
here's my _AddNewChar SP
PHP Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewChar] Script Date: 1/29/2015 8:12:20 AM ******/
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, 27091, 853.681, 622.920532, 966.03125, 2094, 109,
GetDate(), 1, 1, 5000000, 0,1000000, 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!!!
-----------------------------------------------------------------------------
-- 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
-------------------------
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_COS_C_PEGASUS_SCROLL',5,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HP_SUPERSET_5_BAG',8000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_MP_SUPERSET_5_BAG',8000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_ARCHEMY_POTION_SPEED_11',10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',3,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_M_ADMIRAL',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_M_ADMIRAL_ATTACH',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_M_ADMIRAL_HAT',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_W_ADMIRAL',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_W_ADMIRAL_ATTACH',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_AVATAR_W_ADMIRAL_HAT',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_REVERSE_RETURN_SCROLL',11,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_M_NASRUN',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_AVATAR_W_NASRUN',1,1
-- Start Euro Full Gear ----
if @RefCharID <=14887 And @RefCharID >=14875 And @RefMailID = '11623' -- Euro Male Germant
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 12175, 39 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 12211, 39 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 12319, 39 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0 --RING
END
if @RefCharID <=14887 And @RefCharID >=14875 And @RefMailID = '11617' -- Euro Male Armor
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 11671, 45 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 11707, 45 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 11815, 45 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0 --RING
END
if @RefCharID <=14887 And @RefCharID >=14875 And @RefMailID = '11620' -- Euro Male protector
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 11923, 39 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 11959, 39 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 12067, 39 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0 --RING
END
--- Female Side ! ------
if @RefCharID <=14900 And @RefCharID >=14888 And @RefMailID = '11632' -- Euro female Germant
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 13687, 32 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 13723, 32 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 13831, 32 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0 --RING
END
if @RefCharID <=14900 And @RefCharID >=14888 And @RefMailID = '11626' -- Euro female Armor
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 13183, 45 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 13219, 45 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 13327, 45 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0 --RING
END
if @RefCharID <=14900 And @RefCharID >=14888 And @RefMailID = '11629' -- Euro female protector
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 13435, 39 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 13471, 39 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 13579, 39 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 14695, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 14731, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 14659, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 14659, 0 --RING
END
-- End --
-- Start China Full Gear ----
IF @RefCharID<=1919 AND @RefCharID>=1907 and @RefMailID = '3643' -- Chinesse Male Gear CLOTHES
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 791, 39 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 863, 39 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 971, 39 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0 --RING
END
IF @RefCharID<=1919 AND @RefCharID>=1907 and @RefMailID = '3637' -- Chinesse Male Gear ARRMOR
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 287, 48 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 359, 48 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 467, 48 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0 --RING
end
IF @RefCharID<=1919 AND @RefCharID>=1907 and @RefMailID = '3640' -- Chinesse Male Gear LIGHT
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 539, 44 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 611, 44 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 719, 44 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0 --RING
END
--- Female Side ! ------
IF @RefCharID<=1932 AND @RefCharID>=1920 and @RefMailID = '3652' -- Chinesse Woman Gear CLOTHES
BEGIN
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 1547, 39 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 1619, 39 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 1727, 39 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0 --RING
END
IF @RefCharID<=1932 AND @RefCharID>=1920 and @RefMailID = '3646' -- Chinesse Woman Gear ARRMOR
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 1043, 48 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 1115, 48 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 1223, 48 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0 --RING
end
IF @RefCharID<=1932 AND @RefCharID>=1920 and @RefMailID = '3649' -- Chinesse Woman Gear LIGHT
begin
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 0, 1295, 44 --HAT
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 2, 1367, 44 --SHOULDER
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 3, 1475, 44 --HAND
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 9, 1835, 0 --Earring
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 10, 1871, 0 --NECKLACE
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 11, 1799, 0 --RING
EXEC @ItemID = _FN_ADD_INITIAL_EQUIP @NewCharID, 12, 1799, 0 --RING
END
---
insert into _InventoryForAvatar (CharID,slot,ItemID) SELECT @NewCharID, cnt, 0
FROM _RefDummySlot with( nolock )
WHERE cnt < 5
-- Quick Slot Á¤º¸ ÀúÀå¿ë!!!
exec _AddNewClientConfig @NewCharID -- by novice...... for saving client configurations...
COMMIT TRANSACTION
RETURN @NewCharID
|
|
|
|
|
01/29/2015, 08:49
|
#19
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
Try using this one 
|
|
|
|
|
01/29/2015, 20:41
|
#20
|
elite*gold: 15
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
|
same problem :/
|
|
|
|
|
01/29/2015, 21:32
|
#21
|
elite*gold: 0
Join Date: Aug 2012
Posts: 748
Received Thanks: 227
|
Code:
_IsExistingCharName
Check this procedure. or post it here.
|
|
|
|
|
01/29/2015, 21:42
|
#22
|
elite*gold: 15
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
|
Quote:
Originally Posted by Zodiao
Code:
_IsExistingCharName
Check this procedure. or post it here. |
PHP Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_IsExistingCharName] Script Date: 1/29/2015 9:41:39 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
----------------------------------------------------------------------
-- 4. Á÷¾÷ ¸í ¹× Á÷¾÷°¡¸í Áߺ¹ »ý¼º ¹æÁö ¹ö±× ÇȽº ÆÐÄ¡
----------------------------------------------------------------------
ALTER PROCEDURE [dbo].[_IsExistingCharName]
@CharNameToCheck AS VARCHAR(64)
AS
IF (EXISTS(SELECT CharID FROM _CharNameList WITH (NOLOCK) WHERE CharName16 = @CharNameToCheck))
BEGIN
RETURN 1
END
--------------------------------------------------------------------------------------------
-- ¹«¿ª »ï°¢ 2Â÷ ÆÐÄ¡¸¦ À§ÇØ Nick Name¿ª½Ãµµ ÇÔ²² Áߺ¹ üũ ´ë»ó¿¡ Æ÷ÇԵǾî¾ß ÇÑ´Ù.
-- 2006/5/29 overdrv
--------------------------------------------------------------------------------------------
IF (EXISTS(SELECT CharID FROM _CharNickNameList WITH (NOLOCK) WHERE NickName16 = @CharNameToCheck))
BEGIN
RETURN 1
END
RETURN 0
here it is, and if there's a way to add start item with Full Blue and depending on char gender items ?
|
|
|
|
|
01/30/2015, 02:45
|
#23
|
elite*gold: 0
Join Date: Aug 2012
Posts: 748
Received Thanks: 227
|
Obviously you deleted your charname from specific table but not all.
clean up your database.
also consider to add in your check @ _Char too..not sure if it's legit.
Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_IsExistingCharName] Script Date: 1/29/2015 9:41:39 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
----------------------------------------------------------------------
-- 4. Á÷¾÷ ¸í ¹× Á÷¾÷°¡¸í Áߺ¹ »ý¼º ¹æÁö ¹ö±× ÇȽº ÆÐÄ¡
----------------------------------------------------------------------
ALTER PROCEDURE [dbo].[_IsExistingCharName]
@CharNameToCheck AS VARCHAR(64)
AS
IF (EXISTS(SELECT CharID FROM _CharNameList WITH (NOLOCK) WHERE CharName16 = @CharNameToCheck))
BEGIN
RETURN 1
END
--------------------------------------------------------------------------------------------
-- ¹«¿ª »ï°¢ 2Â÷ ÆÐÄ¡¸¦ À§ÇØ Nick Name¿ª½Ãµµ ÇÔ²² Áߺ¹ üũ ´ë»ó¿¡ Æ÷ÇԵǾî¾ß ÇÑ´Ù.
-- 2006/5/29 overdrv
--------------------------------------------------------------------------------------------
IF (EXISTS(SELECT CharID FROM _CharNickNameList WITH (NOLOCK) WHERE NickName16 = @CharNameToCheck))
BEGIN
RETURN 1
END
--------------------------------------------------------------------------------------------
IF (EXISTS(SELECT CharID FROM _Char WITH (NOLOCK) WHERE CharName16 = @CharNameToCheck))
BEGIN
RETURN 1
END
RETURN 0
|
|
|
|
|
01/31/2015, 23:25
|
#24
|
elite*gold: 0
Join Date: Feb 2014
Posts: 885
Received Thanks: 1,419
|
Quote:
Originally Posted by MissinGDeaTh
ye, this error only when i try to create char with such a name exists.
|
Then you are missing exist char names at _CharNameList.
|
|
|
|
|
02/01/2015, 11:45
|
#25
|
elite*gold: 0
Join Date: Mar 2010
Posts: 177
Received Thanks: 11
|
Quote:
Originally Posted by Muhab Ashraf
Then you are missing exist char names at _CharNameList.
|
can you tell me how to fix it ?
|
|
|
|
|
02/01/2015, 11:48
|
#26
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,653
|
Quote:
Originally Posted by Little Messi
can you tell me how to fix it ?
|
I don't know if that's the problem but, add all the char names @ this table.
|
|
|
|
|
02/01/2015, 12:12
|
#27
|
elite*gold: 0
Join Date: Mar 2010
Posts: 177
Received Thanks: 11
|
Quote:
Originally Posted by xExorcist
I don't know if that's the problem but, add all the char names @ this table.
|
it must be automatic, i mean every sec a char is being created. i wont be able to add all char names to that table. if you know what i mean.
|
|
|
|
|
02/01/2015, 15:31
|
#28
|
elite*gold: 0
Join Date: Feb 2014
Posts: 885
Received Thanks: 1,419
|
Char names added automatically to This table but seems you have deleted them or you have removed Insert line from _AddNewChar
|
|
|
|
|
02/01/2015, 16:10
|
#29
|
elite*gold: 15
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
|
Quote:
Originally Posted by Muhab Ashraf
Char names added automatically to This table but seems you have deleted them or you have removed Insert line from _AddNewChar
|
it's here :/
|
|
|
|
 |
|
Similar Threads
|
SHardManager - ODBC error while creating a new char
12/20/2016 - SRO Private Server - 10 Replies
Hello !
I ve downloaded the Blue-Sro DB cuz it has a lot of good edits. I can make my char ,play etc... But when i make a new acc and try to make a new char i get an error in-game and at shardmaneger too. I tired it with 3-4 accs , sometimes it works but sometimes not and crash the shared manager.
I ve used db clearing queries , but still not working.
Please help me !
Thanks !
|
help me fix this error when creating patch!!!
02/09/2014 - Flyff Private Server - 9 Replies
Help me fix this error please .
Img»Simple File Sharing and Storage.
Img»https://fbcdn-sphotos-b-a.akamaihd.net/hphoto s-ak-prn1/t1/15126_348198991985962_579784067_n.jpg
|
SMP error while creating account
11/01/2012 - Rappelz Private Server - 0 Replies
SMP problem solved on my own *lol*
2nd LUA problem solved on my own, too XD
|
error while creating a new char
03/24/2012 - SRO Private Server - 2 Replies
http://www10.0zz0.com/2012/03/23/22/244814214.jpg
|
error creating guild
03/22/2012 - Dekaron Private Server - 3 Replies
every time I try to create guild'' says FAILED TO CREATE GUILD 'already restored the DB is more in the same things I've been editing each type before deleting manually give each guild did this annoying problem for my DB and Character.bak aloken I hope you can help me ...
|
All times are GMT +1. The time now is 06:55.
|
|
![[Error] creating char error](https://www.elitepvpers.com/forum/iconimages/sro-private-server/error-creating-char-error_ltr.gif){kind=small}
