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

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

hmp, added the npc and everythin is fine, but i cant seem to add items to that npc.. im getting crashed each time i try.

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

help me. i can't make a new group

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

NICE ! THIS IS WORKING FOR ME FINALLY !!

Quote:

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
add this line to characterdata_45000 @ server_dep\silkroad\textdata

1 46377 JOAO xxx xxx SN_NPC_JOAO 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 2645 STORE_JOAO -1 xxx -1 xxx -1 xxx -1 xxx

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

1 15 2818 GROUP_STORE_JOAO NPC_JOAO -1 xxx -1 xxx -1 xxx -1 xxx

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

1 87 STORE_JOAO_GROUP1 SN_STORE_JOAO_GROUP1

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

1 15 6434 STORE_JOAO_TAB1 STORE_JOAO_GROUP1 SN_TAB_WEAPONS

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

1 15 2837 STORE_JOAO_GROUP1 SN_STORE_JOAO_GROUP1

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

1 15 GROUP_STORE_JOAO STORE_JOAO

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

1 15 STORE_JOAO STORE_JOAO_GROUP1

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

i added all lines in mediapk2 , but now my sroclient dont start, this just crash after click Start :S any help please?

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

Quote:

Originally Posted by SupremeSRO

NICE ! THIS IS WORKING FOR ME FINALLY !!

i added all lines in mediapk2 , but now my sroclient dont start, this just crash after click Start :S any help please?

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

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

thanks proxy1997 and arabianfox for their help and statiic for query

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

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?

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

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 :|?

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

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

could u help me static :)

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

Error when run on 2005

Code:

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

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

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

where the line of media :w00t:

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

Quote:

Originally Posted by 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?

Same By Me any one Know how to fix this?

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

Quote:

Originally Posted by proxy1997

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

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

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

Quote:

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

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

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

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

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.

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

static can help me on skype?

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 ?

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

client crash before start can I know y ?

1 Attachment(s)

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

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)

PHP 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*******************************/

HATE DE FUCKING "[MENTION=" of the forum

See ATACHMENT FOR THE WORKING SQL

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

Client in crash , Helpmeee !

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

Done all indetiy and still give this

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

Sorry im still a beginner ^^

Sql 2005
Done all ID Keys > Yes !

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

Working as well thanks for sharing :)

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

Very Thanks ^_^

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

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