1 Attachment(s)
[Help] error code colorshop
Attachment 153628 Hi help please new code please colorshop error...! solver please
Code:
Code:
USE [atum2_db_1]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[atum_StoreUpdateColorCode]
@UniqueNumber BIGINT,
@ColorCode INT
AS
UPDATE td_Store
SET ShapeItemNum = @ColorCode
WHERE UniqueNumber = @UniqueNumber
UPDATE atum2_db_account.dbo.ti_BuildingNPCSET BuildingName = 'Colorshop' WHERE BuildingIndex = 9367;
UPDATE atum2_db_account.dbo.ti_BuildingNPC
SET NPCIndex = 108 WHERE BuildingIndex = 9367;
UPDATE atum2_db_account.dbo.ti_BuildingNPC
SET NPCName = 'Paint Shop' WHERE BuildingIndex = 9367;
UPDATE atum2_db_account.dbo.ti_BuildingNPC
SET GreetingTalk = '\g[Bygeniou City Paint Shop]\w The color of your GEAR can be changed here.' WHERE BuildingIndex = 9367;
UPDATE [atum2_db_account].[dbo].[ti_BuildingNPC] SET [BuildingKind]=17 WHERE [BuildingIndex]=9367
Re: [Help] error code colorshop
He's using 1:1 the script i published some time ago....