Well I got this query from epicsoul but cant get it work
I must change
AssocFile256 = 'xxx'
to
AssocFile256 = 'c:\regioninfo.txt'
But when I change nothing happened.Refregion table is still clean.How can I get it work
I must change
AssocFile256 = 'xxx'
to
AssocFile256 = 'c:\regioninfo.txt'
But when I change nothing happened.Refregion table is still clean.How can I get it work
PHP Code:
USE [SRO_VT_SHARD]
GO
<-- for epvpers from epicsoul :)--->
/****** Object: StoredProcedure [dbo].[_InsertRefRegion] Script Date: 05/10/2012 22:45:19 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_InsertRefRegion]
@RegionID as smallint,
@X_NotUsed as int,
@Z_NotUsed as int,
@Continent as varchar(128),
@AreaName as varchar(128),
@IsBattleField as tinyint,
@ClimateID as int,
@Capacity as int
as
begin transaction
begin
declare @_x tinyint
declare @_z tinyint
if (@RegionID > 0)
begin
set @_x = @RegionID % 256
set @_z = @RegionID / 256
end
else
begin
set @_x = 0
set @_z = 0
end
if (exists(select wRegionID from _RefRegion where wRegionID = @RegionID))
begin
update _RefRegion
set X = @_x, Z = @_z, ContinentName = @Continent, AreaName = @AreaName, IsBattleField = @IsBattleField,
Climate = @ClimateID, MaxCapacity = @Capacity, AssocObjID = 0,
<-- insert the refregion path here-->
AssocFile256 = 'xxx'
where wRegionID = @RegionID
end
else
begin
insert into _RefRegion(wRegionID, X, Z, ContinentName, AreaName, IsBattleField, Climate, MaxCapacity, AssocObjID, AssocServer, AssocFile256)
values (@RegionID, @_x, @_z, @Continent, @AreaName, @IsBattleField, @ClimateID, @Capacity, 0, 0, 'xxx')
end
if (@@error <> 0)
begin
raiserror('리젼정보 추가 [혹은 갱신] 실패했다! [RID: %d]' , 1, 16, @RegionID)
rollback transaction
return
end
commit transaction
end
