static can help me on skype?
static can help me on skype?
Msg 8101, Level 16, State 1, Line 65
An explicit value for the identity column in table 'Tab_RefTactics' can only be specified when a column list is used and IDENTITY_INSERT is ON.
any idea pls ?
client crash before start can I know y ?
Well, since the query has some MINOR mistakes, i've decided to find what's going wrong and I found the issue, First, the client crashes because the query says badly the data that has to be in characterdata_45000.txt , the query also says "Copy the following line" and the "spaces" between text must be a "tab" space and not 5 spaces, so, i've fixed that too, and, added a new print to textdata_object (this is for the correct display name in the game of the npc)
HATE DE FUCKING "[MENTION=" of the forumPHP Code:USE [SRO_VT_SHARD]
GO
DECLARE [MENTION=551894]Char[/MENTION]NAME VARCHAR (30)
DECLARE [MENTION=806871]NPC[/MENTION]NAME VARCHAR (30)
DECLARE [MENTION=1333458221]Add[/MENTION]NEW VARCHAR (30)
DECLARE @TABNAME VARCHAR (30)
DECLARE @TABNUMBER VARCHAR (30)
DECLARE @TABNEW VARCHAR (30)
DECLARE [MENTION=762167]Group[/MENTION]NUMBER VARCHAR (30)
DECLARE [MENTION=762167]Group[/MENTION]NEW VARCHAR (30)
DECLARE [MENTION=21783]Game[/MENTION]WORDID INT
SET [MENTION=1333458221]Add[/MENTION]NEW = 'NPC' -- 'NPC' to add a new npc, 'TAB' for add a new Tab, 'GROUP' for add a new group!
SET [MENTION=551894]Char[/MENTION]NAME = 'MeTaD' --U Char Name
SET [MENTION=806871]NPC[/MENTION]NAME = 'MeTaD NPC' --U NPC NAME
SET [MENTION=21783]Game[/MENTION]WORDID = 1 --IMPORTANT! GET GAMEWORLD ID FROM THE LOCALY U WANT ADD THE NPC NORMAL CITYs = 1
SET [MENTION=762167]Group[/MENTION]NUMBER = 1
SET @TABNUMBER = 2
SET @TABNAME = 'Items'
--
IF [MENTION=1333458221]Add[/MENTION]NEW = 'NPC' BEGIN
DECLARE [MENTION=447213]Max[/MENTION]LINK VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjChar)+1
DECLARE [MENTION=1333395255]Maxcom[/MENTION]MONID VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjCommon)+1
SET IDENTITY_INSERT _RefObjCommon ON
INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country
,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius
,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link) VALUES
(1 [MENTION=1333395255]Maxcom[/MENTION]MONID,'NPC_' [MENTION=806871]NPC[/MENTION]NAME,'xxx','xxx','SN_NPC_' [MENTION=806871]NPC[/MENTION]NAME,'xxx',0,1,1,2,2,0,5000,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,'npc\npc\chinawoman_Noblegirl_event.bsr','xxx','xxx','xxx','xxx' [MENTION=447213]Max[/MENTION]LINK)
SET IDENTITY_INSERT _RefObjCommon OFF
SET IDENTITY_INSERT _RefObjChar ON
INSERT INTO _RefObjChar (ID,Lvl,CharGender,MaxHP,MaxMP,ResistFrozen,ResistFrostbite,ResistBurn,ResistEShock,ResistPoison,ResistZombie,ResistSleep,ResistRoot,ResistSlow,ResistFear
,ResistMyopia,ResistBlood,ResistStone,ResistDark,ResistStun,ResistDisea,ResistChaos,ResistCsePD,ResistCseMD,ResistCseSTR,ResistCseINT,ResistCseHP,ResistCseMP,Resist24,ResistBomb,Resist26
,Resist27,Resist28,Resist29,Resist30,Resist31,Resist32,InventorySize,CanStore_TID1,CanStore_TID2,CanStore_TID3,CanStore_TID4,CanBeVehicle,CanControl,DamagePortion,MaxPassenger,AssocTactics,PD,MD,PAR,MAR,ER,BR,HR,CHR
,ExpToGive,CreepType,Knockdown,KO_RecoverTime,DefaultSkill_1,DefaultSkill_2,DefaultSkill_3,DefaultSkill_4,DefaultSkill_5,DefaultSkill_6,DefaultSkill_7,DefaultSkill_8,DefaultSkill_9,DefaultSkill_10,TextureType,Except_1
,Except_2,Except_3,Except_4,Except_5,Except_6,Except_7,Except_8,Except_9,Except_10,Link) VALUES
[MENTION=447213]Max[/MENTION]LINK,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,336860180,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
SET IDENTITY_INSERT _RefObjChar OFF
SET IDENTITY_INSERT _RefShop ON
DECLARE [MENTION=373843]shop[/MENTION]ID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShop)+1
INSERT INTO _RefShop (Service,Country,ID,CodeName128,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15 [MENTION=373843]shop[/MENTION]ID,'STORE_' [MENTION=806871]NPC[/MENTION]NAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
SET IDENTITY_INSERT _RefShop OFF
SET IDENTITY_INSERT _RefShopGroup ON
DECLARE [MENTION=373843]shop[/MENTION]GroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopGroup)+1
INSERT INTO _RefShopGroup (Service,Country,ID,CodeName128,RefNPCCodeName,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15 [MENTION=373843]shop[/MENTION]GroupID,'GROUP_STORE_' [MENTION=806871]NPC[/MENTION]NAME,'NPC_' [MENTION=806871]NPC[/MENTION]NAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
SET IDENTITY_INSERT _RefShopGroup OFF
SET IDENTITY_INSERT _RefShopItemGroup ON
DECLARE [MENTION=373843]shop[/MENTION]ItemID VARCHAR (30) = (SELECT MAX (GROUPID) FROM _RefShopItemGroup)+1
INSERT INTO _RefShopItemGroup (Service,GroupID,CodeName128,StrID128_Group)
VALUES (1 [MENTION=373843]shop[/MENTION]ItemID,'STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1','SN_STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1')
SET IDENTITY_INSERT _RefShopItemGroup OFF
SET IDENTITY_INSERT _RefShopTab ON
DECLARE [MENTION=373843]shop[/MENTION]TabID VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+1
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15 [MENTION=373843]shop[/MENTION]TabID,'STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_TAB1','STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1','SN_TAB_WEAPON')
SET IDENTITY_INSERT _RefShopTab OFF
SET IDENTITY_INSERT _RefShopTabGroup ON
DECLARE [MENTION=373843]shop[/MENTION]TabGroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopTabGroup)+1
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group)
VALUES (1,15 [MENTION=373843]shop[/MENTION]TabGroupID,'STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1','SN_STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1')
SET IDENTITY_INSERT _RefShopTabGroup OFF
INSERT INTO _RefMappingShopGroup VALUES (1,15,'GROUP_STORE_' [MENTION=806871]NPC[/MENTION]NAME,'STORE_' [MENTION=806871]NPC[/MENTION]NAME)
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_' [MENTION=806871]NPC[/MENTION]NAME,'STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1')
DECLARE [MENTION=441621]Tactic[/MENTION]SID INT SET [MENTION=441621]Tactic[/MENTION]SID = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+10
INSERT INTO Tab_RefTactics VALUES
[MENTION=441621]Tactic[/MENTION]SID [MENTION=1333395255]Maxcom[/MENTION]MONID,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'NPC_' [MENTION=806871]NPC[/MENTION]NAME)
DECLARE [MENTION=614210]Hive[/MENTION]ID INT SET [MENTION=614210]Hive[/MENTION]ID = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
INSERT INTO Tab_RefHive VALUES
[MENTION=614210]Hive[/MENTION]ID,0,0,0,0,0,0 [MENTION=21783]Game[/MENTION]WORDID,2,'NPC_' [MENTION=806871]NPC[/MENTION]NAME)
DECLARE [MENTION=527330]region[/MENTION] VARCHAR (30) SET [MENTION=527330]region[/MENTION] = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = [MENTION=551894]Char[/MENTION]NAME)
DECLARE @POSX VARCHAR (30) SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = [MENTION=551894]Char[/MENTION]NAME)
DECLARE @POSY VARCHAR (30) SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = [MENTION=551894]Char[/MENTION]NAME)
DECLARE @POSZ VARCHAR (30) SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = [MENTION=551894]Char[/MENTION]NAME)
DECLARE [MENTION=1333422837]Nesti[/MENTION]D INT SET [MENTION=1333422837]Nesti[/MENTION]D = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
INSERT INTO Tab_RefNest VALUES
[MENTION=1333422837]Nesti[/MENTION]D [MENTION=614210]Hive[/MENTION]ID [MENTION=441621]Tactic[/MENTION]SID [MENTION=527330]region[/MENTION],@POSX,@POSY,@POSZ,0,0,0,0,0,0,1,0,1,0)
PRINT 'add this line to characterdata_45000 @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 ' [MENTION=1333395255]Maxcom[/MENTION]MONID+' NPC_' [MENTION=806871]NPC[/MENTION]NAME+' xxx xxx '+'SN_NPC_' [MENTION=806871]NPC[/MENTION]NAME+' xxx 0 1 1 2 2 0 5000 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 npc\npc\chinawoman_Noblegirl_event.bsr xxx xxx xxx xxx 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 336860180 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'
PRINT ''
PRINT 'Add this line to refshop.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 ' [MENTION=373843]shop[/MENTION]ID+' '+'STORE_' [MENTION=806871]NPC[/MENTION]NAME+' -1 xxx -1 xxx -1 xxx -1 xxx'
PRINT ''
PRINT 'Add this line to refshopgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 ' [MENTION=373843]shop[/MENTION]GROUPID+' '+'GROUP_STORE_' [MENTION=806871]NPC[/MENTION]NAME+' '+'NPC_' [MENTION=806871]NPC[/MENTION]NAME+' -1 xxx -1 xxx -1 xxx -1 xxx'
PRINT ''
PRINT 'Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 ' [MENTION=373843]shop[/MENTION]ITEMID+' '+'STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1 '+'SN_STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to refshoptab.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 ' [MENTION=373843]shop[/MENTION]TABID+' '+'STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_TAB1 '+'STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1 SN_TAB_WEAPONS'
PRINT ''
PRINT 'Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 ' [MENTION=373843]shop[/MENTION]TABGROUPID+' '+'STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1 '+'SN_STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 '+'GROUP_STORE_' [MENTION=806871]NPC[/MENTION]NAME+' '+'STORE_' [MENTION=806871]NPC[/MENTION]NAME
PRINT ''
PRINT 'Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1 15 '+'STORE_' [MENTION=806871]NPC[/MENTION]NAME+' '+'STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to textdata_object @ server_dep\silkroad\textdata'
PRINT ''
print '1 SN_NPC_' [MENTION=806871]NPC[/MENTION]NAME+' ' [MENTION=806871]NPC[/MENTION]NAME
print ''
PRINT 'A New NPC Has ADD Succesfuly Restart U Server and Login in ' [MENTION=551894]Char[/MENTION]NAME
END
IF @TABNUMBER = 2 SET @TABNEW = 'STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_TAB2'
IF @TABNUMBER = 3 SET @TABNEW = 'STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_TAB3'
IF @TABNUMBER = 4 SET @TABNEW = 'STORE_' [MENTION=806871]NPC[/MENTION]NAME+'_TAB4'
IF [MENTION=762167]Group[/MENTION]NUMBER = 2 SET [MENTION=762167]Group[/MENTION]NEW = '_GROUP2'
IF [MENTION=762167]Group[/MENTION]NUMBER = 3 SET [MENTION=762167]Group[/MENTION]NEW = '_GROUP3'
IF [MENTION=762167]Group[/MENTION]NUMBER = 4 SET [MENTION=762167]Group[/MENTION]NEW = '_GROUP4'
IF [MENTION=762167]Group[/MENTION]NUMBER = 5 SET [MENTION=762167]Group[/MENTION]NEW = '_GROUP5'
IF [MENTION=762167]Group[/MENTION]NUMBER = 6 SET [MENTION=762167]Group[/MENTION]NEW = '_GROUP6'
IF [MENTION=1333458221]Add[/MENTION]NEW = 'GROUP' BEGIN
SET IDENTITY_INSERT _RefShopTabGroup ON
SET [MENTION=373843]shop[/MENTION]TabGroupID = (SELECT MAX (ID) FROM _RefShopTabGroup)+1
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group)
VALUES (1,15 [MENTION=373843]shop[/MENTION]TabGroupID,'STORE_' [MENTION=806871]NPC[/MENTION]NAME [MENTION=762167]Group[/MENTION]NEW,'SN_STORE_' [MENTION=806871]NPC[/MENTION]NAME [MENTION=762167]Group[/MENTION]NEW)
SET IDENTITY_INSERT _RefShopTabGroup OFF
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_' [MENTION=806871]NPC[/MENTION]NAME,'STORE_' [MENTION=806871]NPC[/MENTION]NAME [MENTION=762167]Group[/MENTION]NEW)
PRINT ''
PRINT 'New Group Added Succesfully '
PRINT 'add this new line to refshoptabgroup.txt @ server_dep\silkroad\textdata'
PRINT '1 15 ' [MENTION=373843]shop[/MENTION]TABGROUPID+' STORE_' [MENTION=806871]NPC[/MENTION]NAME [MENTION=762167]Group[/MENTION]NEW+' SN_STORE_' [MENTION=806871]NPC[/MENTION]NAME [MENTION=762167]Group[/MENTION]NEW
PRINT ''
PRINT 'add this new line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata'
PRINT '1 15 STORE_' [MENTION=806871]NPC[/MENTION]NAME+' STORE_' [MENTION=806871]NPC[/MENTION]NAME [MENTION=762167]Group[/MENTION]NEW
END
IF [MENTION=1333458221]Add[/MENTION]NEW = 'TAB' BEGIN
IF [MENTION=762167]Group[/MENTION]NUMBER = 1 SET [MENTION=762167]Group[/MENTION]NEW = '_GROUP1'
SET IDENTITY_INSERT _RefShopTab ON
SET [MENTION=373843]shop[/MENTION]TabID = (SELECT MAX (ID) FROM _RefShopTab)+1
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15 [MENTION=373843]shop[/MENTION]TabID,@TABNEW,'STORE_' [MENTION=806871]NPC[/MENTION]NAME [MENTION=762167]Group[/MENTION]NEW,'SN_'+@TABNAME)
SET IDENTITY_INSERT _RefShopTab OFF
PRINT ''
PRINT 'New Tab added Sucessfully add this new line to refshoptab.txt @ server_dep\silkroad\textdata'
PRINT '1 15 ' [MENTION=373843]shop[/MENTION]TABID+' STORE_' [MENTION=806871]NPC[/MENTION]NAME+@TABNEW+' STORE_' [MENTION=806871]NPC[/MENTION]NAME [MENTION=762167]Group[/MENTION]NEW+' SN_TAB_'+@TABNAME
END
IF @TABNUMBER > 4 BEGIN
PRINT '@TABNUMBER value does not exist. u must add 2 , 3 OR 4 Tabs Per NPC!'
END
IF [MENTION=762167]Group[/MENTION]NUMBER > 8 BEGIN
PRINT [MENTION=762167]Group[/MENTION]NUMBER value does not exist. u must add 1 , 2 , 3 , 4 , 5 , 6 , 7 OR 8 Groups!'
END
IF [MENTION=1333458221]Add[/MENTION]NEW = '' BEGIN
PRINT [MENTION=1333458221]Add[/MENTION]NEW value does not exist. u must set values NPC , TAB , GROUP'
END
/******************************* Best Query By Statiic don't Re-Release Under u Name*******************************/
See ATACHMENT FOR THE WORKING SQL
Client in crash , Helpmeee !
Done all indetiy and still give this
Sorry im still a beginner ^^Quote:
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 11
Incorrect syntax near '+'.
Msg 102, Level 15, State 1, Line 12
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 12
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 17
Must declare the scalar variable "@MAXCOMMONID".
Msg 137, Level 15, State 2, Line 25
Must declare the scalar variable "@MAXLINK".
Msg 102, Level 15, State 1, Line 28
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 28
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 30
Must declare the scalar variable "@ShopID".
Msg 102, Level 15, State 1, Line 33
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 33
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 35
Must declare the scalar variable "@ShopGroupID".
Msg 102, Level 15, State 1, Line 38
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 38
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 40
Must declare the scalar variable "@ShopItemID".
Msg 102, Level 15, State 1, Line 43
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 43
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 45
Must declare the scalar variable "@ShopTabID".
Msg 102, Level 15, State 1, Line 48
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 48
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 50
Must declare the scalar variable "@ShopTabGroupID".
Msg 137, Level 15, State 2, Line 56
Must declare the scalar variable "@MAXCOMMONID".
Msg 137, Level 15, State 2, Line 73
Must declare the scalar variable "@MAXCOMMONID".
Msg 137, Level 15, State 2, Line 77
Must declare the scalar variable "@SHOPID".
Msg 137, Level 15, State 2, Line 81
Must declare the scalar variable "@SHOPGROUPID".
Msg 137, Level 15, State 2, Line 85
Must declare the scalar variable "@SHOPITEMID".
Msg 137, Level 15, State 2, Line 89
Must declare the scalar variable "@SHOPTABID".
Msg 137, Level 15, State 2, Line 93
Must declare the scalar variable "@SHOPTABGROUPID".
Sql 2005
Done all ID Keys > Yes !
Working as well thanks for sharing :)
Very Thanks ^_^
please i wish any one could make a little youtube clip about it