NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^

[nandoloanda]

i m getting the follow error ------> CharID don't differ with link from RefObfChar
the querry worked 100% but when i go to stard my SR_Shard_Manager i get this error :/
any help?

 

[FantasiaSRO]

add this line to characterdata_45000 @ server_dep\silkroad\textdata

1 47001 FantZero xxx xxx SN_NPC_FantZero 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

Add this line to refshop.txt @ server_dep\silkroad\textdata

1 15 90 STORE_FantZero -1 xxx -1 xxx -1 xxx -1 xxx

Add this line to refshopgroup.txt @ server_dep\silkroad\textdata

1 15 2816 GROUP_STORE_FantZero NPC_FantZero -1 xxx -1 xxx -1 xxx -1 xxx

Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata

1 84 STORE_FantZero_GROUP1 SN_STORE_FantZero_GROUP1

Add this line to refshoptab.txt @ server_dep\silkroad\textdata

1 15 6429 STORE_FantZero_TAB1 STORE_FantZero_GROUP1 SN_TAB_WEAPONS

Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata

1 15 2834 STORE_FantZero_GROUP1 SN_STORE_FantZero_GROUP1

Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata

1 15 GROUP_STORE_FantZero STORE_FantZero

Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata

1 15 STORE_FantZero STORE_FantZero_GROUP1

A New NPC Has ADD Succesfuly Restart U Server and Login in Fantasia


I've added this and client keeps crashing :|?

 

[bestprem]

go Tools > Options... > Designers > and Clean "Prevent saving changes that require table re-creation" .
now

could u help me static

 

[zerround]

Error when run on 2005

Msg 102, Level 15, State 1, Line 13
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 13
Incorrect syntax near '+'.
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 19
Must declare the scalar variable "@MAXCOMMONID".
Msg 137, Level 15, State 2, Line 27
Must declare the scalar variable "@MAXLINK".
Msg 102, Level 15, State 1, Line 30
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 30
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 32
Must declare the scalar variable "@ShopID".
Msg 102, Level 15, State 1, Line 35
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 35
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 37
Must declare the scalar variable "@ShopGroupID".
Msg 102, Level 15, State 1, Line 40
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 40
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 42
Must declare the scalar variable "@ShopItemID".
Msg 102, Level 15, State 1, Line 45
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 45
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 47
Must declare the scalar variable "@ShopTabID".
Msg 102, Level 15, State 1, Line 50
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 50
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 52
Must declare the scalar variable "@ShopTabGroupID".
Msg 137, Level 15, State 2, Line 58
Must declare the scalar variable "@MAXCOMMONID".
Msg 137, Level 15, State 2, Line 75
Must declare the scalar variable "@MAXCOMMONID".
Msg 137, Level 15, State 2, Line 79
Must declare the scalar variable "@SHOPID".
Msg 137, Level 15, State 2, Line 83
Must declare the scalar variable "@SHOPGROUPID".
Msg 137, Level 15, State 2, Line 87
Must declare the scalar variable "@SHOPITEMID".
Msg 137, Level 15, State 2, Line 91
Must declare the scalar variable "@SHOPTABID".
Msg 137, Level 15, State 2, Line 95
Must declare the scalar variable "@SHOPTABGROUPID".

 

[adminsxza]

the Query give my only this msg
Command(s) completed successfully.

where the line of media :w00t:

 

[H4rdStyl3]

i m getting the follow error ------> CharID don't differ with link from RefObfChar
the querry worked 100% but when i go to stard my SR_Shard_Manager i get this error :/
any help?

Same By Me any one Know how to fix this?

 

[H4rdStyl3]

For each line you have to use the key "TAB" as space not just the usual " ". + Characterdata info is not correct - add it on ur own.
Still can't find out why I can't add items or even names to this npc seems that I am going to rebuild it on the hard way.......

Client crash after add succesfully NPC in db
Dont know what you mean to do... pls help me

 

[FantasiaSRO]

I've notice one thing...

The red letters are missing, so ADD THEM!! if you're not sure what to add, check refobjcommon what it says there!

if you add the lines, it'll say you have to add some lines to media, check the line for chardata

1 91919 NPC_Myseriacoin xxx xxx SN_NPC_Myseriacoin 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

 

[Nexus2oo7]

Msg 8101, Level 16, State 1, Line 56
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.


its already ON

 

[infor]

help please

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.

 

[lepitismak]

static can help me on skype?

 

[marwanayman]

Re: [RELEASE] NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^

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 ?

 

[marwanayman]

client crash before start can I know y ?

 

[MeTaD]

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)

USE [SRO_VT_SHARD]
GO
DECLARE  [USER=551894]Char[/USER]NAME VARCHAR (30)
DECLARE  [USER=806871]NPC[/USER]NAME VARCHAR (30)
DECLARE  [USER=1333458221]Add[/USER]NEW VARCHAR (30)
DECLARE @TABNAME VARCHAR (30)
DECLARE @TABNUMBER VARCHAR (30) 
DECLARE @TABNEW VARCHAR (30)
DECLARE  [USER=762167]Group[/USER]NUMBER VARCHAR (30) 
DECLARE  [USER=762167]Group[/USER]NEW VARCHAR (30)
DECLARE  [USER=21783]Game[/USER]WORDID INT

SET  [USER=1333458221]Add[/USER]NEW = 'NPC' -- 'NPC' to add a new npc, 'TAB' for add a new Tab, 'GROUP' for add a new group!
SET  [USER=551894]Char[/USER]NAME = 'MeTaD' --U Char Name
SET  [USER=806871]NPC[/USER]NAME = 'MeTaD NPC' --U NPC NAME
SET  [USER=21783]Game[/USER]WORDID = 1 --IMPORTANT! GET GAMEWORLD ID FROM THE LOCALY U WANT ADD THE NPC NORMAL CITYs = 1
SET  [USER=762167]Group[/USER]NUMBER  = 1
SET @TABNUMBER = 2
SET @TABNAME = 'Items'

--

IF  [USER=1333458221]Add[/USER]NEW = 'NPC' BEGIN
DECLARE  [USER=447213]Max[/USER]LINK VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjChar)+1
DECLARE  [USER=1333395255]Maxcom[/USER]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  [USER=1333395255]Maxcom[/USER]MONID,'NPC_'  [USER=806871]NPC[/USER]NAME,'xxx','xxx','SN_NPC_'  [USER=806871]NPC[/USER]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'  [USER=447213]Max[/USER]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
  [USER=447213]Max[/USER]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  [USER=373843]shop[/USER]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  [USER=373843]shop[/USER]ID,'STORE_'  [USER=806871]NPC[/USER]NAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
SET IDENTITY_INSERT _RefShop OFF
SET IDENTITY_INSERT _RefShopGroup ON
DECLARE  [USER=373843]shop[/USER]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  [USER=373843]shop[/USER]GroupID,'GROUP_STORE_'  [USER=806871]NPC[/USER]NAME,'NPC_'  [USER=806871]NPC[/USER]NAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
SET IDENTITY_INSERT _RefShopGroup OFF
SET IDENTITY_INSERT _RefShopItemGroup ON
DECLARE  [USER=373843]shop[/USER]ItemID VARCHAR (30) = (SELECT MAX (GROUPID) FROM _RefShopItemGroup)+1
INSERT INTO _RefShopItemGroup (Service,GroupID,CodeName128,StrID128_Group)
VALUES (1  [USER=373843]shop[/USER]ItemID,'STORE_'  [USER=806871]NPC[/USER]NAME+'_GROUP1','SN_STORE_'  [USER=806871]NPC[/USER]NAME+'_GROUP1')
SET IDENTITY_INSERT _RefShopItemGroup OFF
SET IDENTITY_INSERT _RefShopTab ON
DECLARE  [USER=373843]shop[/USER]TabID VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+1
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15  [USER=373843]shop[/USER]TabID,'STORE_'  [USER=806871]NPC[/USER]NAME+'_TAB1','STORE_'  [USER=806871]NPC[/USER]NAME+'_GROUP1','SN_TAB_WEAPON')
SET IDENTITY_INSERT _RefShopTab OFF
SET IDENTITY_INSERT _RefShopTabGroup ON
DECLARE  [USER=373843]shop[/USER]TabGroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopTabGroup)+1
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group)
VALUES (1,15  [USER=373843]shop[/USER]TabGroupID,'STORE_'  [USER=806871]NPC[/USER]NAME+'_GROUP1','SN_STORE_'  [USER=806871]NPC[/USER]NAME+'_GROUP1')
SET IDENTITY_INSERT _RefShopTabGroup OFF
INSERT INTO _RefMappingShopGroup VALUES (1,15,'GROUP_STORE_'  [USER=806871]NPC[/USER]NAME,'STORE_'  [USER=806871]NPC[/USER]NAME)
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_'  [USER=806871]NPC[/USER]NAME,'STORE_'  [USER=806871]NPC[/USER]NAME+'_GROUP1')
DECLARE  [USER=441621]Tactic[/USER]SID INT SET  [USER=441621]Tactic[/USER]SID = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+10
INSERT INTO Tab_RefTactics VALUES
  [USER=441621]Tactic[/USER]SID  [USER=1333395255]Maxcom[/USER]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_'  [USER=806871]NPC[/USER]NAME)
DECLARE  [USER=614210]Hive[/USER]ID INT  SET  [USER=614210]Hive[/USER]ID = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
INSERT INTO Tab_RefHive VALUES
  [USER=614210]Hive[/USER]ID,0,0,0,0,0,0  [USER=21783]Game[/USER]WORDID,2,'NPC_'  [USER=806871]NPC[/USER]NAME)
DECLARE  [USER=527330]region[/USER] VARCHAR (30) SET  [USER=527330]region[/USER] = (SELECT (LatestRegion) FROM _Char WHERE CharName16 =  [USER=551894]Char[/USER]NAME)
DECLARE @POSX VARCHAR (30) SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 =  [USER=551894]Char[/USER]NAME)
DECLARE @POSY VARCHAR (30) SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 =  [USER=551894]Char[/USER]NAME)
DECLARE @POSZ VARCHAR (30) SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 =  [USER=551894]Char[/USER]NAME)
DECLARE  [USER=1333422837]Nesti[/USER]D INT SET  [USER=1333422837]Nesti[/USER]D = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
INSERT INTO Tab_RefNest VALUES
  [USER=1333422837]Nesti[/USER]D  [USER=614210]Hive[/USER]ID  [USER=441621]Tactic[/USER]SID  [USER=527330]region[/USER],@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	'  [USER=1333395255]Maxcom[/USER]MONID+'	NPC_'  [USER=806871]NPC[/USER]NAME+'	xxx	xxx	'+'SN_NPC_'  [USER=806871]NPC[/USER]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	'  [USER=373843]shop[/USER]ID+'	'+'STORE_'  [USER=806871]NPC[/USER]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	'  [USER=373843]shop[/USER]GROUPID+'	'+'GROUP_STORE_'  [USER=806871]NPC[/USER]NAME+'	'+'NPC_'  [USER=806871]NPC[/USER]NAME+'	-1	xxx	-1	xxx	-1	xxx	-1	xxx'
PRINT ''
PRINT 'Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1	'  [USER=373843]shop[/USER]ITEMID+'	'+'STORE_'  [USER=806871]NPC[/USER]NAME+'_GROUP1	'+'SN_STORE_'  [USER=806871]NPC[/USER]NAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to refshoptab.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1	15	'  [USER=373843]shop[/USER]TABID+'	'+'STORE_'  [USER=806871]NPC[/USER]NAME+'_TAB1	'+'STORE_'  [USER=806871]NPC[/USER]NAME+'_GROUP1	SN_TAB_WEAPONS'
PRINT ''
PRINT 'Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1	15	'  [USER=373843]shop[/USER]TABGROUPID+'	'+'STORE_'  [USER=806871]NPC[/USER]NAME+'_GROUP1	'+'SN_STORE_'  [USER=806871]NPC[/USER]NAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1	15	'+'GROUP_STORE_'  [USER=806871]NPC[/USER]NAME+'	'+'STORE_'  [USER=806871]NPC[/USER]NAME
PRINT ''
PRINT 'Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata'
PRINT ''
PRINT '1	15	'+'STORE_'  [USER=806871]NPC[/USER]NAME+'	'+'STORE_'  [USER=806871]NPC[/USER]NAME+'_GROUP1'
PRINT ''
PRINT 'Add this line to textdata_object @ server_dep\silkroad\textdata'
PRINT ''
print '1	SN_NPC_'  [USER=806871]NPC[/USER]NAME+'								'  [USER=806871]NPC[/USER]NAME
print ''
PRINT 'A New NPC Has ADD Succesfuly Restart U Server and Login in '  [USER=551894]Char[/USER]NAME
END
IF @TABNUMBER = 2 SET @TABNEW = 'STORE_'  [USER=806871]NPC[/USER]NAME+'_TAB2'
IF @TABNUMBER = 3 SET @TABNEW = 'STORE_'  [USER=806871]NPC[/USER]NAME+'_TAB3'
IF @TABNUMBER = 4 SET @TABNEW = 'STORE_'  [USER=806871]NPC[/USER]NAME+'_TAB4'
IF  [USER=762167]Group[/USER]NUMBER  = 2 SET  [USER=762167]Group[/USER]NEW = '_GROUP2'
IF  [USER=762167]Group[/USER]NUMBER  = 3 SET  [USER=762167]Group[/USER]NEW = '_GROUP3'
IF  [USER=762167]Group[/USER]NUMBER  = 4 SET  [USER=762167]Group[/USER]NEW = '_GROUP4'
IF  [USER=762167]Group[/USER]NUMBER  = 5 SET  [USER=762167]Group[/USER]NEW = '_GROUP5'
IF  [USER=762167]Group[/USER]NUMBER  = 6 SET  [USER=762167]Group[/USER]NEW = '_GROUP6'
IF  [USER=1333458221]Add[/USER]NEW = 'GROUP' BEGIN 
SET IDENTITY_INSERT _RefShopTabGroup ON
SET  [USER=373843]shop[/USER]TabGroupID = (SELECT MAX (ID) FROM _RefShopTabGroup)+1
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group)
VALUES (1,15  [USER=373843]shop[/USER]TabGroupID,'STORE_'  [USER=806871]NPC[/USER]NAME  [USER=762167]Group[/USER]NEW,'SN_STORE_'  [USER=806871]NPC[/USER]NAME  [USER=762167]Group[/USER]NEW)
SET IDENTITY_INSERT _RefShopTabGroup OFF
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_'  [USER=806871]NPC[/USER]NAME,'STORE_'  [USER=806871]NPC[/USER]NAME  [USER=762167]Group[/USER]NEW)
PRINT ''
PRINT 'New Group Added Succesfully '
PRINT 'add this new line to refshoptabgroup.txt @ server_dep\silkroad\textdata'
PRINT '1	15	'  [USER=373843]shop[/USER]TABGROUPID+'	STORE_'  [USER=806871]NPC[/USER]NAME  [USER=762167]Group[/USER]NEW+'	SN_STORE_'  [USER=806871]NPC[/USER]NAME  [USER=762167]Group[/USER]NEW
PRINT ''
PRINT 'add this new line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata'
PRINT '1	15	STORE_'  [USER=806871]NPC[/USER]NAME+'	STORE_'  [USER=806871]NPC[/USER]NAME  [USER=762167]Group[/USER]NEW

END

IF  [USER=1333458221]Add[/USER]NEW = 'TAB' BEGIN
IF  [USER=762167]Group[/USER]NUMBER = 1 SET  [USER=762167]Group[/USER]NEW = '_GROUP1'
SET IDENTITY_INSERT _RefShopTab ON
SET  [USER=373843]shop[/USER]TabID = (SELECT MAX (ID) FROM _RefShopTab)+1
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)
VALUES (1,15  [USER=373843]shop[/USER]TabID,@TABNEW,'STORE_'  [USER=806871]NPC[/USER]NAME  [USER=762167]Group[/USER]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	'  [USER=373843]shop[/USER]TABID+'	STORE_'  [USER=806871]NPC[/USER]NAME+@TABNEW+'	STORE_'  [USER=806871]NPC[/USER]NAME  [USER=762167]Group[/USER]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  [USER=762167]Group[/USER]NUMBER > 8 BEGIN
PRINT   [USER=762167]Group[/USER]NUMBER value does not exist. u must add  1 , 2 , 3 , 4 , 5 , 6 , 7 OR 8 Groups!'
END
IF  [USER=1333458221]Add[/USER]NEW = '' BEGIN
PRINT   [USER=1333458221]Add[/USER]NEW value does not exist. u must set values NPC , TAB , GROUP'
END
/******************************* Best Query By Statiic don't Re-Release Under u Name*******************************/

HATE DE Ducking "[USER=" of the forum

See ATACHMENT FOR THE WORKING SQL

 

[JairValerio]

Client in crash , Helpmeee !

 

[EslamGalal]

Done all indetiy and still give this

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".

Sorry im still a beginner ^^

Sql 2005
Done all ID Keys > Yes !

 

[Razor1337]

Working as well thanks for sharing

 

[omarkabo]

Very Thanks ^_^

 

[glennhollanda]

please i wish any one could make a little youtube clip about it

 

[ledangvu96]

Hi guys im sorry if I digging this up but i am learning SQL through Sro private. After had executed the queries, my sr_gamemanager.exe kept getting error saying that "cannot find the asscoc item...".

I did some research but could not find a solid solution, some said can delete the error items in
_RefPackageItem
_RefPricePolicyOfItem
_RefScrapOfPackageItem
_RefShopGoods

But it seemed there are many items that caused the error.

I am using a clean v188 database and client.