首页 › 问答中心 › 剑灵怎么在商城添加商品

a1234526 发表于 2021-9-30 20:35:37

剑灵怎么在商城添加商品

自写了个sql,尝试添加"白蛇鳞"到商城,东西添加成功了,但在购买的时候,可购买熟练显示为0,加不了,这个怎么破
https://z3.ax1x.com/2021/09/30/4oHSld.png
sql:

declare @maxid int,@additemid int,@addname varchar(50)
set @additemid=830313
set @addname='白蛇鳞'
select @maxid=MAX(GoodsId)+1 from Goods
select @maxid
insert into Goods (GoodsId,GoodsName,GoodsAppGroupCode,GoodsType,DeliveryType,SaleStatus,EffectiveFrom,EffectiveTo,SaleableQuantity,RefundUnitCode,IsRefundable,IsAvailableRecurringPayment,Changed,ChangerAdminAccount,GoodsDescription,GoodsData,GoodsPurchaseType,GoodsPurchaseCheckMask) select @maxid,@addname,GoodsAppGroupCode,GoodsType,DeliveryType,SaleStatus,EffectiveFrom,EffectiveTo,SaleableQuantity,RefundUnitCode,IsRefundable,IsAvailableRecurringPayment,Changed,ChangerAdminAccount,@addname,GoodsData,GoodsPurchaseType,GoodsPurchaseCheckMask from Goods where GoodsId=52107
insert INTO GoodsItems(GoodsId,ItemId,ItemQuantity,ItemExpirationType,ItemData,DeliveryPriority) select @maxid,@additemid,100,ItemExpirationType,ItemData,DeliveryPriority from GoodsItems where GoodsId=52107
insert into GoodsCategories(GoodsId,CategoryId,DisplayOrder) select @maxid,CategoryId,DisplayOrder from GoodsCategories where GoodsId=52107
insert into GoodsBasicPrices(GoodsId,CurrencyGroupId,BasicSalePrice,RefundFee) select @maxid,CurrencyGroupId,BasicSalePrice,RefundFee from GoodsBasicPrices where GoodsId=52107
insert into GoodsItemBasicPrices(GoodsId,ItemId,CurrencyGroupId,BasicSalePrice) select @maxid,@additemid,CurrencyGroupId,BasicSalePrice from GoodsItemBasicPrices where GoodsId=52107
insert into GoodsSalePricePolicies(GoodsId,CurrencyGroupId,PricePolicyType,EffectiveFrom,EffectiveTo,SalePrice) select @maxid,CurrencyGroupId,PricePolicyType,EffectiveFrom,EffectiveTo,SalePrice from GoodsSalePricePolicies where GoodsId=52107
insert into GoodsDisplay(GoodsId,LanguageCode,GoodsDisplayName,GoodsDisplayDescription) select @maxid,LanguageCode,@addname,@addname from GoodsDisplay where GoodsId=52107

xiaoyuzhuce01 发表于 2021-11-21 01:03:05

一样的问题，请教大佬解决了吗

lider0722 发表于 2021-11-27 07:31:32

在刷新一次遊戲看看?
畢竟目前是單機版 可能系統上有漏物品 可以叫出來但是無法使用之類

业余 发表于 2021-12-4 07:55:52

谢谢楼主分享！66666666666666666！

bigcool 发表于 2022-1-1 02:54:06

解决了嘛？

查看完整版本: 剑灵怎么在商城添加商品