Question about query

[LegendM]

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 


[FoxRayz]

PHP Code:

USE [SRO_VT_SHARD] 


Make sure this one is the same as your shard name

[Kape7]

That makes no sense, that query is from the vsro files and it is not used for insert the info from the regioninfo file. Also for what you need it?

[LegendM]

Originally Posted by Synx7

That makes no sense, that query is from the vsro files and it is not used for insert the info from the regioninfo file. Also for what you need it?

I want add new regions using this query?So I cant ? <.<

[pH33n1x<3]

it doesn't work.. i mean you can't add new data to _refregion from regioninfo.txt

[LegendM]

Originally Posted by pH33n1x<3

it doesn't work.. i mean you can't add new data to _refregion from regioninfo.txt

But this query exactly for that :/

[Janick_]

@LegendM, just copy them from the refregion.txt on client , should take some time but not that long.

Ctrl+a, ctrl+c then ctrl+v in _RefRegion table should do the job

[LegendM]

Originally Posted by Janick_

@LegendM, just copy them from the refregion.txt on client , should take some time but not that long.

Ctrl+a, ctrl+c then ctrl+v in _RefRegion table should do the job

Oh ***,refregion.txt have 2 coloums.Db need much more then txt

[Janick_]

Originally Posted by LegendM

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 ..

[ahmed4ever2u]

/**Have Fun **/
use SRO_VT_SHARd
delete from _RefRegion
BULK INSERT _RefRegion FROM 'c:\regioninfo.txt' WITH (FIELDTERMINATOR = '\t')

[LegendM]

Originally Posted by Janick_

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 ..

Can you show yours?

@ahmed

It need special query

[Janick_]

Originally Posted by LegendM

Can you show yours?

@ahmed

It need special query

It only shows 3 rows on that screen, idk why, but thats how it looks.