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
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
Oh ***,refregion.txt have 2 coloums.Db need much more then txt
I don't know how your refregion.txt looks but mines have the same amount of collumns as the db, only difference is that the linking is not done there and they all say NULL there. Just take that txt, put it into excel, replace all NULL's with 0's with search and replace, place it into ur database, and execute the producure that links the regions ..
I don't know how your refregion.txt looks but mines have the same amount of collumns as the db, only difference is that the linking is not done there and they all say NULL there. Just take that txt, put it into excel, replace all NULL's with 0's with search and replace, place it into ur database, and execute the producure that links the regions ..
Query Question!!! 12/22/2010 - EO PServer Hosting - 1 Replies we can use 1077 as MYSQL command and data as 5 so we can
SELECT name FROM cq_user WHERE id=1000000
and we can use 101 and %iter_var_data5 so we can see the result but the problem is the %iter_var_data << can handle only numbers so it's always giving me a ruslt of 0 is there a way to get a value of text from aonther table
i hope you got it!!?
[Question]Query 06/22/2010 - EO PServer Hosting - 4 Replies Guys, i got some problem here can check my query. I try to add new eudemon CancerQueen but eudemon can't hatch. Here my query.
SQL query question 05/09/2010 - Shaiya Private Server - 1 Replies Lock this or delete lol i found my answer :)
[QUESTION]Auto Query 05/08/2010 - EO PServer Hosting - 4 Replies I have got asaved query but i need to know if it can run auto after i close the server without runing it ?
Quick MSQL query question 11/26/2008 - EO PServer Hosting - 4 Replies In my cq_goods I have 13xx lines and I need to change owner id to 1207 for shopping mall. Is there a query that can be made to just alter the owner id and not effect anything else?
