Re-Release NPC Query [Add your own NPC in 3 Minutes]

DieEyes · 09/18/2012, 19:18

Hello, Epvpers.

First of all lets give the Query credit to Statiic

I noticed that many of you guys cant use the query right!! there is some things im sure Statiic forgot it or couse he just started to write a query in that time.

I recommend you to read the statiic topic first so you will understand how to solve some issues about Indetity.

Here is my edited query and tested by me.

1- open an character and stay at the spot you want to create at it the npc and after close it.

Now the query

To add new Npc.

PHP Code:



use [SRO_VT_SHARD_INIT] 
 
DECLARE @CHARNAME VARCHAR (30)  
DECLARE @NPCNAME VARCHAR (30)  
DECLARE @ADDNEW VARCHAR (30)  
DECLARE @GAMEWORDID INT  
SET @CHARNAME = 'DieEyes' --U Char Name  
SET @NPCNAME = 'STATIC' --U NPC NAME  
SET @GAMEWORDID = 1 --IMPORTANT! GET GAMEWORLD ID FROM THE LOCALY U WANT ADD THE NPC NORMAL CITYs = 1  
SET @ADDNEW = 'NPC'  
--  
IF @ADDNEW = 'NPC' BEGIN  
DECLARE @MAXLINK VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjChar)+1  
DECLARE @MAXCOMMONID 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,@MAXCOMMONID,'NPC_'+@NPCNAME,'xxx','xxx','SN_NPC_'+@NPCNAME,'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',@MAXLINK)  
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  
(@MAXLINK,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 @ShopID 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,@ShopID,'STORE_'+@NPCNAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')  
SET IDENTITY_INSERT _RefShop OFF  
SET IDENTITY_INSERT _RefShopGroup ON  
DECLARE @ShopGroupID 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,@ShopGroupID,'GROUP_STORE_'+@NPCNAME,'NPC_'+@NPCNAME,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')  
SET IDENTITY_INSERT _RefShopGroup OFF  
SET IDENTITY_INSERT _RefShopItemGroup ON  
DECLARE @ShopItemID VARCHAR (30) = (SELECT MAX (GROUPID) FROM _RefShopItemGroup)+1  
INSERT INTO _RefShopItemGroup (Service,GroupID,CodeName128,StrID128_Group)  
VALUES (1,@ShopItemID,'STORE_'+@NPCNAME+'_GROUP1','SN_STORE_'+@NPCNAME+'_GROUP1')  
SET IDENTITY_INSERT _RefShopItemGroup OFF  
SET IDENTITY_INSERT _RefShopTab ON  
DECLARE @ShopTabID VARCHAR (30)= (SELECT MAX (ID) FROM _RefShopTab)+1  
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab)  
VALUES (1,15,@ShopTabID,'STORE_'+@NPCNAME+'_TAB1','STORE_'+@NPCNAME+'_GROUP1','SN_TAB_WEAPON')  
SET IDENTITY_INSERT _RefShopTab OFF  
SET IDENTITY_INSERT _RefShopTabGroup ON  
DECLARE @ShopTabGroupID VARCHAR (30) = (SELECT MAX (ID) FROM _RefShopTabGroup)+1  
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group)  
VALUES (1,15,@ShopTabGroupID,'STORE_'+@NPCNAME+'_GROUP1','SN_STORE_'+@NPCNAME+'_GROUP1')  
SET IDENTITY_INSERT _RefShopTabGroup OFF  
INSERT INTO _RefMappingShopGroup VALUES (1,15,'GROUP_STORE_'+@NPCNAME,'STORE_'+@NPCNAME)  
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_'+@NPCNAME,'STORE_'+@NPCNAME+'_GROUP1')  
DECLARE @TACTICSID INT SET @TACTICSID = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+10  
INSERT INTO Tab_RefTactics VALUES  
(@TACTICSID,@MAXCOMMONID,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_'+@NPCNAME)  
BEGIN 
DECLARE @HIVEID INT  SET @HIVEID = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1  
INSERT INTO Tab_RefHive VALUES  
(@HIVEID,0,0,0,0,0,0,@GAMEWORDID,2,'NPC_'+@NPCNAME)  
END 
BEGIN 
DECLARE @REGION VARCHAR (30) SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)  
DECLARE @POSX VARCHAR (30) SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)  
DECLARE @POSY VARCHAR (30) SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)  
DECLARE @POSZ VARCHAR (30) SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)  
DECLARE @NESTID INT SET @NESTID = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1  
INSERT INTO Tab_RefNest VALUES  
(@NESTID,@HIVEID,@TACTICSID,@REGION,@POSX,@POSY,@POSZ,0,0,0,0,0,0,1,0,1,0)  
END 
PRINT 'add this line to characterdata_45000 @ server_dep\silkroad\textdata'  
PRINT ''  
PRINT '1    '+@MAXCOMMONID+'    '+'NPC_'+@NPCNAME+'    xxx    xxx    '+'SN_NPC_'+@NPCNAME+'    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    '+@SHOPID+'    '+'STORE_'+@NPCNAME+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'  
PRINT ''  
PRINT 'Add this line to refshopgroup.txt @ server_dep\silkroad\textdata'  
PRINT ''  
PRINT '1    15    '+@SHOPGROUPID+'    '+'GROUP_STORE_'+@NPCNAME+'    '+'NPC_'+@NPCNAME+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'  
PRINT ''  
PRINT 'Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata'  
PRINT ''  
PRINT '1    '+@SHOPITEMID+'    '+'STORE_'+@NPCNAME+'_GROUP1    '+'SN_STORE_'+@NPCNAME+'_GROUP1'  
PRINT ''  
PRINT 'Add this line to refshoptab.txt @ server_dep\silkroad\textdata'  
PRINT ''  
PRINT '1    15    '+@SHOPTABID+'    '+'STORE_'+@NPCNAME+'_TAB1    '+'STORE_'+@NPCNAME+'_GROUP1    SN_TAB_WEAPONS'  
PRINT ''  
PRINT 'Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata'  
PRINT ''  
PRINT '1    15    '+@SHOPTABGROUPID+'    '+'STORE_'+@NPCNAME+'_GROUP1    '+'SN_STORE_'+@NPCNAME+'_GROUP1'  
PRINT ''  
PRINT 'Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata'  
PRINT ''  
PRINT '1    15    '+'GROUP_STORE_'+@NPCNAME+'    '+'STORE_'+@NPCNAME  
PRINT ''  
PRINT 'Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata'  
PRINT ''  
PRINT '1    15    '+'STORE_'+@NPCNAME+'    '+'STORE_'+@NPCNAME+'_GROUP1'  
PRINT ''  
PRINT 'A New NPC Has ADD Succesfuly Restart U Server and Login in '+@CHARNAME  
END

To add a new Tab.

PHP Code:



use [SRO_VT_SHARD_INIT] 
 
DECLARE @CHARNAME VARCHAR (30) 
DECLARE @NPCNAME VARCHAR (30) 
DECLARE @ADDNEW VARCHAR (30) 
DECLARE @TABNAME VARCHAR (30) 
DECLARE @TABNUMBER VARCHAR (30)  
DECLARE @TABNEW VARCHAR (30) 
DECLARE @GROUPNUMBER VARCHAR (30)  
DECLARE @GROUPNEW VARCHAR (30) 
-- 
SET @ADDNEW = 'TAB' -- 'NPC' to add a new npc, 'TAB' for add a new Tab, 'GROUP' for add a new group! 
SET @CHARNAME = 'DieEyes' --U Char Name 
SET @NPCNAME = 'STATIC' --U NPC NAME 
SET @GROUPNUMBER  = 1 
SET @TABNUMBER = 4 
SET @TABNAME = 'Hat' 
-- 
IF @TABNUMBER = 2 SET @TABNEW = '_TAB2' 
IF @TABNUMBER = 3 SET @TABNEW = '_TAB3' 
IF @TABNUMBER = 4 SET @TABNEW = '_TAB4' 
IF @GROUPNUMBER = 1 SET @GROUPNEW = '_GROUP1' 
IF @GROUPNUMBER  = 2 SET @GROUPNEW = '_GROUP2' 
IF @GROUPNUMBER  = 3 SET @GROUPNEW = '_GROUP3' 
IF @GROUPNUMBER  = 4 SET @GROUPNEW = '_GROUP4' 
IF @GROUPNUMBER  = 5 SET @GROUPNEW = '_GROUP5' 
IF @GROUPNUMBER  = 6 SET @GROUPNEW = '_GROUP6' 
IF @ADDNEW = 'TAB' BEGIN 
SET IDENTITY_INSERT _RefShopTab ON 
DECLARE @ShopTabID VARCHAR (30) SET @ShopTabID = (SELECT MAX (ID) FROM _RefShopTab)+1 
INSERT INTO _RefShopTab (Service,Country,ID,CodeName128,RefTabGroupCodeName,StrID128_Tab) 
VALUES (1,15,@ShopTabID,'STORE_'+@NPCNAME+@TABNEW,'STORE_'+@NPCNAME+@GROUPNEW,'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    '+@SHOPTABID+'    STORE_'+@NPCNAME+@TABNEW+'    STORE_'+@NPCNAME+@GROUPNEW+'    SN_TAB_'+@TABNAME 
END

To add a Group.

PHP Code:



DECLARE @CHARNAME VARCHAR (30) 
DECLARE @NPCNAME VARCHAR (30) 
DECLARE @ADDNEW VARCHAR (30) 
DECLARE @GROUPNUMBER VARCHAR (30)  
DECLARE @GROUPNEW VARCHAR (30) 
SET @CHARNAME = 'DieEyes' --U Char Name 
SET @NPCNAME = 'STATIC' --U NPC NAME 
SET @GROUPNUMBER  = 2 
SET @ADDNEW = 'GROUP' 
-- 
IF @GROUPNUMBER  = 2 SET @GROUPNEW = '_GROUP2' 
IF @GROUPNUMBER  = 3 SET @GROUPNEW = '_GROUP3' 
IF @GROUPNUMBER  = 4 SET @GROUPNEW = '_GROUP4' 
IF @GROUPNUMBER  = 5 SET @GROUPNEW = '_GROUP5' 
IF @GROUPNUMBER  = 6 SET @GROUPNEW = '_GROUP6' 
IF @ADDNEW = 'GROUP' BEGIN  
SET IDENTITY_INSERT _RefShopTabGroup ON 
DECLARE @ShopTabGroupID VARCHAR (30) SET @ShopTabGroupID = (SELECT MAX (ID) FROM _RefShopTabGroup)+1 
INSERT INTO _RefShopTabGroup (Service,Country,ID,CodeName128,StrID128_Group) 
VALUES (1,15,@ShopTabGroupID,'STORE_'+@NPCNAME+@GROUPNEW,'SN_STORE_'+@NPCNAME+@GROUPNEW) 
SET IDENTITY_INSERT _RefShopTabGroup OFF 
INSERT INTO _RefMappingShopWithTab VALUES (1,15,'STORE_'+@NPCNAME,'STORE_'+@NPCNAME+@GROUPNEW) 
PRINT '' 
PRINT 'New Group Added Succesfully ' 
PRINT 'add this new line to refshoptabgroup.txt @ server_dep\silkroad\textdata' 
PRINT '1    15    '+@SHOPTABGROUPID+'    STORE_'+@NPCNAME+@GROUPNEW+'    SN_STORE_'+@NPCNAME+@GROUPNEW 
PRINT '' 
PRINT 'add this new line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata' 
PRINT '1    15    STORE_'+@NPCNAME+'    STORE_'+@NPCNAME+@GROUPNEW 
END

Thats it. Dont thanks me just send your greetings to Static

@$$ · 09/18/2012, 22:44

Copy Paste From R-z

DieEyes · 09/18/2012, 22:48

Quote:

Originally Posted by @$$

Copy Paste From R-z

Maybe iam the same person?

~~StarMage~~ · 09/19/2012, 05:33

i don't like use query to add my new npc i prefer use my hand and add everything in tablets to be sure it will work 100% whatever if this query working with out problems as you say it will be a good release from you so you got my thanks i know the full credits to static but you got my thanks because you did the fix and i'll test the query when i go to home & thank you for your hard work

DieEyes · 09/19/2012, 09:28

Quote:

Originally Posted by StarMage

i don't like use query to add my new npc i prefer use my hand and add everything in tablets to be sure it will work 100% whatever if this query working with out problems as you say it will be a good release from you so you got my thanks i know the full credits to static but you got my thanks because you did the fix and i'll test the query when i go to home & thank you for your hard work

Thanks for your words. Static query was crushing the media. now its working 100% waiting your feed back for tell to peoples if its work or no.

CrazyGirL_ZSZC · 09/19/2012, 10:25

Quote:

Msg 8101, Level 16, State 1, Line 61
An explicit value for the identity column in table 'Tab_RefHive' can only be specified when a column list is used and IDENTITY_INSERT is ON.

how to solve that?

DieEyes · 09/19/2012, 10:29

go Tools > Options... > Designers > and Clean "Prevent saving changes that require table re-creation" .
now
_RefObjCommon > Design > right click ID Column Set a primary key > Column Properties > Indetity Spercification > (Is Indetity) set "Yes" same with the others.
NOW DO THE SAME WITH Tab_RefHive and Tab_RefNest BUT SET INDENTITY OFF
ok now u can exec the querys without any errro

Nexus7 · 03/03/2013, 22:46

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.

I made all you said!

*]°ReddoX°[* · 04/11/2013, 18:20

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

how to solve that ?

IceAmStiel · 04/11/2013, 18:58

Quote:

Originally Posted by *]°ReddoX°[*

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

how to solve that ?

Install SQL Server 2008 R2, you aren't allowed to declare + set variables directly at 2005.

If you don't want to install a new version simply change the declarations as follows..

Code:

DECLARE @MAXLINK VARCHAR (30) = (SELECT MAX (ID) FROM _RefObjChar)+1

->

Code:

Declare	@MAXLINK varchar(30);
SELECT	@MAXLINK = MAX(ID) + 1 FROM dbo._RefObjChar;

Zodiao · 04/11/2013, 19:12

^Caipi,
you mean

PHP Code:



Declare    @MAXLINK varchar(30);
SET @MAXLINK = SELECT MAX(ID) + 1 FROM dbo._RefObjChar;

i guess.

IceAmStiel · 04/11/2013, 19:16

Quote:

Originally Posted by Sir*EviL

^Caipi,
you mean

PHP Code:

Declare @MAXLINK varchar(30); SET @MAXLINK = SELECT MAX(ID) + 1 FROM dbo._RefObjChar;

i guess.

Nono, Caipi means it as he wrote it

Colb · 04/15/2013, 04:54

Did everything as posted, and it crashes my client o.0

And yes, I modified pk2.

spider560 · 05/01/2013, 15:50

fine thnx

MissinGDeaTh · 01/19/2015, 23:43

group query done, added to media succesfully. client crashs before loading