Add Item to NPC

**loli89** · 21-12-11

Works fine, but only for the first item.
If i want to add a new item after i closed mssql i got this strange errors:

Meldung 2627, Ebene 14, Status 1, Zeile 21
Violation of PRIMARY KEY constraint 'PK__RefPackageItem'. Cannot insert duplicate key in object 'dbo._RefPackageItem'.
The statement has been terminated.
(1 Zeile(n) betroffen)
Meldung 2627, Ebene 14, Status 1, Zeile 79
Violation of PRIMARY KEY constraint 'PK__RefPricePolicyOfItem'. Cannot insert duplicate key in object 'dbo._RefPricePolicyOfItem'.
The statement has been terminated.
Meldung 2627, Ebene 14, Status 1, Zeile 100
Violation of PRIMARY KEY constraint 'PK__RefShopGoods_renewal'. Cannot insert duplicate key in object 'dbo._RefShopGoods'.
The statement has been terminated.

Any solutions?

edit
omg forgot to count id up -.- :D

**Hean** · 21-12-11

Originally Posted by loli89

Works fine, but only for the first item.
If i want to add a new item after i closed mssql i got this strange errors:

Meldung 2627, Ebene 14, Status 1, Zeile 21
Violation of PRIMARY KEY constraint 'PK__RefPackageItem'. Cannot insert duplicate key in object 'dbo._RefPackageItem'.
The statement has been terminated.
(1 Zeile(n) betroffen)
Meldung 2627, Ebene 14, Status 1, Zeile 79
Violation of PRIMARY KEY constraint 'PK__RefPricePolicyOfItem'. Cannot insert duplicate key in object 'dbo._RefPricePolicyOfItem'.
The statement has been terminated.
Meldung 2627, Ebene 14, Status 1, Zeile 100
Violation of PRIMARY KEY constraint 'PK__RefShopGoods_renewal'. Cannot insert duplicate key in object 'dbo._RefShopGoods'.
The statement has been terminated.

Any solutions?

edit
omg forgot to count id up -.- :D

Also check if that item exist bevore. Maybe if someone knows mssql more then me smthing like
if (CodeName128 = exist) execute code

or something like that.

**Caipi** · 21-12-11

PHP Code:

 USE SRO_VT_SHARD /* ITEMS TO NPC FOR GOLD by Caipi */
Declare @ItemID int
Declare @yourPrice int
Declare @WhichTAB varchar(74)



SET @ItemID = 23                            /* The Item ID of the Item you want to add to the NPC*/ --## <--
SET @yourPrice = 5000                        /* The price per Unit */ --## <--
SET @WhichTAB = 'STORE_CH_POTION_TAB1'        /* To which Tab at which NPC you want to add the Item*/



/* Codename instead of the ID */ 
Declare @CodeName varchar (74) SET @CodeName = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @ItemID)

/* Which Itemdata.txt is affected in the Media.pk2*/
Declare @newItemID varchar(5)
Declare @lastPrice varchar(25) SET @lastPrice = (SELECT Price FROM _RefObjCommon WHERE ID = @ItemID)
Declare @yourPriceCHAR varchar(25) SET @yourPriceCHAR = @yourPrice
IF (@ItemID < 5000) SET @newItemID = 5000
else if (@ItemID < 10000) SET @newItemID = 10000
else if (@ItemID < 15000) SET @newItemID = 15000
else if (@ItemID < 20000) SET @newItemID = 20000
else if (@ItemID < 25000) SET @newItemID = 25000
else if (@ItemID < 30000) SET @newItemID = 30000
else if (@ItemID < 35000) SET @newItemID = 35000
else if (@ItemID < 40000) SET @newItemID = 40000
else SET @newItemID = 45000
print ''
print @CodeName + ' from Media\server_dep\silkroad\textdata\itemdata_'+@newItemID+'.txt'
print 'Change the current Price of '+@lastPrice+' to '+@yourPriceCHAR+' at the itemdata_'+@newItemID+'. (For the visual Price ingame)'
/*END which Itemdata.txr*/

/*for _RefObjCommon Price*/
UPDATE _RefObjCommon SET Price = @yourPrice WHERE ID = @ItemID

/* for _RefPackageItem */
IF EXISTS (SELECT CodeName128 FROM _RefPackageItem WHERE CodeName128 = 'Package_'+@CodeName)
    BEGIN
        print 'Already added @ RefPackageItem/.txt!'
    END
ELSE BEGIN
Declare @SN varchar(74) SET @SN = (SELECT NameStrID128 FROM _RefObjCommon WHERE ID = @ItemID)
Declare @DESC varchar(74) SET @Desc = (SELECT DescStrID128 FROM _RefObjCommon WHERE ID = @ItemID)
Declare @DDJ varchar(74) SET @DDJ = (SELECT AssocFileIcon128 FROM _RefObjCommon WHERE ID = @ItemID)
INSERT INTO _RefPackageItem (Service,Country,CodeName128,SaleTag,ExpandTerm,NameStrID,DescStrID,AssocFileIcon,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128) 
VALUES (1,15,'PACKAGE_'+@CodeName,0,'EXPAND_TERM_ALL',@SN,@Desc,@DDJ,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
Declare @TOPID varchar (10) SET @TOPID = (SELECT MAX(ID) FROM _RefPackageItem)
print ''
print 'Add the following line @ refpackageitem.txt'
print '1    15    '+@TOPID+'    PACKAGE_'+@CodeName+'    0    EXPAND_TERM_ALL    '+@SN+'    '+@DESC+'    '+@DDJ+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
print ''
END

/* for _RefPricePolicyOfItem */
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND PaymentDevice = 1 AND Cost = @yourPrice)
    BEGIN
        print 'Already added @ RefPricePolicyOfItem/.txt!'
    END
ELSE BEGIN
INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDevice,PreviousCost,Cost,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,1,0,@yourPrice,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
Declare @NEWPRICE varchar(15) SET @NEWPRICE = @yourPrice
print ''
print 'Add the following line @ refpricepolicyofitem.txt'
print '1    15    PACKAGE_'+@CodeName+'    1    0    '+@NEWPRICE+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
print ''
END

/* for _RefShopGoods */
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefShopGoods WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND RefTabCodeName = @WhichTAB)
    BEGIN
        print 'Already added @ RefShopGoods/.txt!'
    END
ELSE BEGIN
Declare @newSLOTINDEX varchar(15) SET @newSLOTINDEX = (SELECT MAX(SlotIndex) FROM _RefShopGoods WHERE RefTabCodeName = @WhichTAB)+1
INSERT INTO _RefShopGoods (Service,Country,RefTabCodeName,RefPackageItemCodeName,SlotIndex,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15,@WhichTAB,'PACKAGE_'+@CodeName,@newSLOTINDEX,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
print ''
print 'Add the following line @ refshopgoods.txt'
print '1    15    '+@WhichTAB+'    '+'PACKAGE_'+@CodeName+'    '+@newSLOTINDEX+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
print ''
END

/* for _RefScrapOfPackageItem */
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND RefItemCodeName = @CodeName)
    BEGIN
        print 'Already added @ RefScrapOfPackageItem/.txt!'
    END
ELSE BEGIN
INSERT INTO _RefScrapOfPackageItem (Service,Country,RefPackageItemCodeName,RefItemCodeName,OptLevel,Variance,Data,MagParamNum,MagParam1,MagParam2,MagParam3,MagParam4,MagParam5,MagParam6,MagParam7,MagParam8,MagParam9,MagParam10,MagParam11,MagParam12,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,@CodeName,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
Declare @ScrapIndex varchar(15)
SET @ScrapIndex = (SELECT MAX([Index]) FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName)
print ''
print 'Add the following line @ refscrapofpackageitem.txt'
print '1    15    '+'PACKAGE_'+@CodeName+'    '+@CodeName+'    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    '+@ScrapIndex
print ''
END
print ''
print ''
print 'Done!'

**fathyhero** · 22-12-11

nice jop ^^

**vantuto** · 28-02-12

Thank you bro

**MaXing** · 28-02-12

Please RE-upload

**higorhaner** · 28-02-12

Please RE-upload²

**elj0o0ker** · 29-02-12

Please , upload it at Mediafire or any thing alse
cuz , Multiupload not working :(

**RevelatioN** · 01-03-12

reupload please Multiupload doesn't work :(

**Kollegah** · 01-03-12

reupload plz

**RevelatioN** · 02-03-12

Originally Posted by Caipi

PHP Code:

 USE SRO_VT_SHARD /* ITEMS TO NPC FOR GOLD by Caipi */

Declare @ItemID int

Declare @yourPrice int

Declare @WhichTAB varchar(74)

 
 
 
SET @ItemID = 23                            /* The Item ID of the Item you want to add to the NPC*/ --## <--

SET @yourPrice = 5000                        /* The price per Unit */ --## <--

SET @WhichTAB = 'STORE_CH_POTION_TAB1'        /* To which Tab at which NPC you want to add the Item*/

 
 
 
/* Codename instead of the ID */ 

Declare @CodeName varchar (74) SET @CodeName = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @ItemID)

 
/* Which Itemdata.txt is affected in the Media.pk2*/

Declare @newItemID varchar(5)

Declare @lastPrice varchar(25) SET @lastPrice = (SELECT Price FROM _RefObjCommon WHERE ID = @ItemID)

Declare @yourPriceCHAR varchar(25) SET @yourPriceCHAR = @yourPrice

IF (@ItemID < 5000) SET @newItemID = 5000

else if (@ItemID < 10000) SET @newItemID = 10000

else if (@ItemID < 15000) SET @newItemID = 15000

else if (@ItemID < 20000) SET @newItemID = 20000

else if (@ItemID < 25000) SET @newItemID = 25000

else if (@ItemID < 30000) SET @newItemID = 30000

else if (@ItemID < 35000) SET @newItemID = 35000

else if (@ItemID < 40000) SET @newItemID = 40000

else SET @newItemID = 45000

print ''

print @CodeName + ' from Media\server_dep\silkroad\textdata\itemdata_'+@newItemID+'.txt'

print 'Change the current Price of '+@lastPrice+' to '+@yourPriceCHAR+' at the itemdata_'+@newItemID+'. (For the visual Price ingame)'

/*END which Itemdata.txr*/

 
/*for _RefObjCommon Price*/

UPDATE _RefObjCommon SET Price = @yourPrice WHERE ID = @ItemID

 
/* for _RefPackageItem */

IF EXISTS (SELECT CodeName128 FROM _RefPackageItem WHERE CodeName128 = 'Package_'+@CodeName)

    BEGIN

        print 'Already added @ RefPackageItem/.txt!'

    END

ELSE BEGIN

Declare @SN varchar(74) SET @SN = (SELECT NameStrID128 FROM _RefObjCommon WHERE ID = @ItemID)

Declare @DESC varchar(74) SET @Desc = (SELECT DescStrID128 FROM _RefObjCommon WHERE ID = @ItemID)

Declare @DDJ varchar(74) SET @DDJ = (SELECT AssocFileIcon128 FROM _RefObjCommon WHERE ID = @ItemID)

INSERT INTO _RefPackageItem (Service,Country,CodeName128,SaleTag,ExpandTerm,NameStrID,DescStrID,AssocFileIcon,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128) 

VALUES (1,15,'PACKAGE_'+@CodeName,0,'EXPAND_TERM_ALL',@SN,@Desc,@DDJ,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')

Declare @TOPID varchar (10) SET @TOPID = (SELECT MAX(ID) FROM _RefPackageItem)

print ''

print 'Add the following line @ refpackageitem.txt'

print '1    15    '+@TOPID+'    PACKAGE_'+@CodeName+'    0    EXPAND_TERM_ALL    '+@SN+'    '+@DESC+'    '+@DDJ+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'

print ''

END

 
/* for _RefPricePolicyOfItem */

IF EXISTS (SELECT RefPackageItemCodeName FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND PaymentDevice = 1 AND Cost = @yourPrice)

    BEGIN

        print 'Already added @ RefPricePolicyOfItem/.txt!'

    END

ELSE BEGIN

INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDevice,PreviousCost,Cost,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)

VALUES (1,15,'PACKAGE_'+@CodeName,1,0,@yourPrice,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')

Declare @NEWPRICE varchar(15) SET @NEWPRICE = @yourPrice

print ''

print 'Add the following line @ refpricepolicyofitem.txt'

print '1    15    PACKAGE_'+@CodeName+'    1    0    '+@NEWPRICE+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'

print ''

END

 
/* for _RefShopGoods */

IF EXISTS (SELECT RefPackageItemCodeName FROM _RefShopGoods WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND RefTabCodeName = @WhichTAB)

    BEGIN

        print 'Already added @ RefShopGoods/.txt!'

    END

ELSE BEGIN

Declare @newSLOTINDEX varchar(15) SET @newSLOTINDEX = (SELECT MAX(SlotIndex) FROM _RefShopGoods WHERE RefTabCodeName = @WhichTAB)+1

INSERT INTO _RefShopGoods (Service,Country,RefTabCodeName,RefPackageItemCodeName,SlotIndex,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)

VALUES (1,15,@WhichTAB,'PACKAGE_'+@CodeName,@newSLOTINDEX,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')

print ''

print 'Add the following line @ refshopgoods.txt'

print '1    15    '+@WhichTAB+'    '+'PACKAGE_'+@CodeName+'    '+@newSLOTINDEX+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'

print ''

END

 
/* for _RefScrapOfPackageItem */

IF EXISTS (SELECT RefPackageItemCodeName FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND RefItemCodeName = @CodeName)

    BEGIN

        print 'Already added @ RefScrapOfPackageItem/.txt!'

    END

ELSE BEGIN

INSERT INTO _RefScrapOfPackageItem (Service,Country,RefPackageItemCodeName,RefItemCodeName,OptLevel,Variance,Data,MagParamNum,MagParam1,MagParam2,MagParam3,MagParam4,MagParam5,MagParam6,MagParam7,MagParam8,MagParam9,MagParam10,MagParam11,MagParam12,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)

VALUES (1,15,'PACKAGE_'+@CodeName,@CodeName,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')

Declare @ScrapIndex varchar(15)

SET @ScrapIndex = (SELECT MAX([Index]) FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName)

print ''

print 'Add the following line @ refscrapofpackageitem.txt'

print '1    15    '+'PACKAGE_'+@CodeName+'    '+@CodeName+'    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    '+@ScrapIndex

print ''

END

print ''

print ''

print 'Done!'

can you explain with video or something please

**Kira** · 02-03-12

Just Like :P

Here u Go

**BD001** · 03-03-12

multiupload is down :( could you reupload it.. mediafire?

**Kira** · 03-03-12

Originally Posted by BD001

multiupload is down :( could you reupload it.. mediafire?

Here u Go
Just Like :P

**RevelatioN** · 03-03-12

is this program adding items automatically or what??
can anyone please tell me how to add items to NPC from the DB

Add Item to NPC

LinkBack

Thread Tools

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Re: [Release] Add Item to NPC

Posting Permissions