[Release] Arabia DB Lines By King$

[killercom]

guys all arabia with amateur is buggy like min crash on being there so i'll wait for a full release he took most of my lines and thought it is working he is begging for thanks

[nourayman]

hmm , i didnt see any credits to the original person who made these lines :S

i think he is called ( killercom )

[Alexiuns]

Originally Posted by killercom

guys all arabia with amateur is buggy like min crash on being there so i'll wait for a full release he took most of my lines and thought it is working he is begging for thanks

hmm i take a 1 line only from you lol

King Dollar: eh da a mousa
[20/09/2012 06:18:08 م] King Dollar: ?
[20/09/2012 06:18:36 م] King Dollar: a mousa
[20/09/2012 06:18:56 م] King Dollar: la ana mish
[20/09/2012 06:18:57 م] King Dollar: adey
[20/09/2012 06:18:58 م] King Dollar: keda
[20/09/2012 06:19:05 م] King Dollar: enta
[20/09/2012 06:19:08 م] King Dollar: 5lst dol
[20/09/2012 06:19:08 م] King Dollar: ??
[20/09/2012 06:19:09 م] King Dollar: _RefInstance_World_Region
_RefInstance_World_Start_Pos
[20/09/2012 06:19:17 م] King Dollar: ok
[20/09/2012 06:19:19 م] King Dollar: :)
[20/09/2012 06:19:21 م] King Dollar: tb gybo
[20/09/2012 06:19:22 م] King Dollar: mnen
[20/09/2012 06:19:22 م] King Dollar: ?
[20/09/2012 06:20:10 م] Mouse: 1 22618

Translate
What is This Mousa ?
Mousa
no i wont mean that
did you finish this is table
_RefInstance_World_Region
Mouse: 1 22618
hmm how you get this is line
okey i will finish all line then give to you


so ? he give me 1 line only and want the credit WDF Lol !

[killercom]

dont need your sick credits

[*FireForce*]

buggy release so fix it then release it

[Alexiuns]

Originally Posted by killercom

dont need your sick credits

No Comment

[nemo08]

hmm I didn't test yet But what's the bugs that in the Release ??

[focus2525]

Query not work line Error

Msg 154, Level 15, State 1, Procedure _LinkRefRegions, Line 148
a USE database statement is not allowed in a procedure, function or trigger.

Pls Help me

set ANSI_NULLS OFF
set QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[_LinkRefRegions]
AS

--- Blow Query is Each Area and FORT matching ---
declare @China int
declare @West_China int
declare @Oasis_Kingdom int
declare @Eu int
declare @Am int
declare @Ca int
declare @ARABIA int

select @China = AssocServer from _RefRegionBindAssocServer where AreaName = 'CHINA'
select @West_China = AssocServer from _RefRegionBindAssocServer where AreaName = 'West_China'
select @Oasis_Kingdom = AssocServer from _RefRegionBindAssocServer where AreaName = 'Oasis_Kingdom'
select @Eu = AssocServer from _RefRegionBindAssocServer where AreaName = 'Eu'
select @Am = AssocServer from _RefRegionBindAssocServer where AreaName = 'Am'
select @Ca = AssocServer from _RefRegionBindAssocServer where AreaName = 'Ca'
select @ARABIA = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA'

update _RefRegionBindAssocServer set AssocServer = @China where AreaName = 'FORT_JA_AREA'
update _RefRegionBindAssocServer set AssocServer = @China where AreaName = 'FORT_BJ_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China where AreaName = 'FORT_DW_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China where AreaName = 'FORT_HM_AREA'
update _RefRegionBindAssocServer set AssocServer = @Oasis_Kingdom where AreaName = 'FORT_HT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Eu where AreaName = 'FORT_CT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Am where AreaName = 'FORT_ER_AREA'
update _RefRegionBindAssocServer set AssocServer = @Ca where AreaName = 'FORT_SK_AREA'
update _RefRegionBindAssocServer set AssocServer = @ARABIA where AreaName = 'ARABIA'

begin TRANSACTION
begin
declare @LinkNum int
declare @this_region int
declare @region_x int
declare @region_z int
declare @wRegionID smallint
declare @wTempRID smallint
declare @col_link varchar(256)
declare @query varchar(256)
declare @db_id_to_link smallint

-- clear all existing region link
set @LinkNum = 1
while (@LinkNum <= 10)
begin
set @query = 'update _RefRegion set LinkedRegion_' + cast(@LinkNum as varchar(10)) + ' = 0'
execute (@query)

set @LinkNum = @LinkNum + 1
end
-- loop all region
declare region_cursor CURSOR FOR
select wRegionID
from _RefRegion
OPEN region_cursor
FETCH NEXT FROM region_cursor INTO @wRegionID
WHILE @@FETCH_STATUS = 0
begin
if (@@error = 0 and @wRegionID <> 0)
begin
-- ´øÀüÀº ½ºÅµ!
if (@wRegionID > 0)
begin
set @LinkNum = 8
while (@LinkNum >= 0)
begin
set @region_z = (@wRegionID & 0xff00) / 256
set @region_x = (@wRegionID & 0x0ff)
set @wTempRID = 0;

if (@LinkNum = 0)
begin
set @region_x = @region_x - 1
set @col_link = 'LinkedRegion_1'
end
else if (@LinkNum = 1)
begin
set @region_x = @region_x - 1
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_2'
end
else if (@LinkNum = 2)
begin
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_3'
end
else if (@LinkNum = 3)
begin
set @region_x = @region_x + 1
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_4'
end
else if (@LinkNum = 4)
begin
set @region_x = @region_x + 1
set @col_link = 'LinkedRegion_5'
end
else if (@LinkNum = 5)
begin
set @region_x = @region_x + 1
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_6'
end
else if (@LinkNum = 6)
begin
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_7'
end
else if (@LinkNum = 7)
begin
set @region_x = @region_x - 1
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_8'
end

set @wTempRID = (@region_z & 0x00ff) * 256
set @wTempRID = @wTempRID + (@region_x & 0x00ff)

select @db_id_to_link = wRegionID
from _RefRegion
where wRegionID = @wTempRID

if (@@ROWCOUNT <> 0)
begin
set @query = 'update _RefRegion set ' + @col_link + ' = ' + cast(@db_id_to_link as varchar(10)) + ' where wRegionID = ' + cast(@wRegionID as varchar(10))
end
else -- Á¸ÀçÇÏÁö ¾Ê´Â region link ´Â 0À¸·Î ä¿î´Ù
begin
set @query = 'update _RefRegion set ' + @col_link + ' = 0 where wRegionID = ' + cast(@wRegionID as varchar(10))
end

execute(@query)
set @LinkNum = @LinkNum - 1
end
end
end
FETCH NEXT FROM region_cursor INTO @wRegionID
end

CLOSE region_cursor
DEALLOCATE region_cursor
COMMIT TRANSACTION
end

USE [SRO_VT_SHARD]
exec _LinkRefRegions

[-LordyK*]

Originally Posted by nemo08

hmm I didn't test yet But what's the bugs that in the Release ??

simple -> this release don't work

[A new hope]

Woah, it was so hard to copy it from the client.

[namoo]

*Query* 1 fixed.

USE [SRO_VT_SHARD]
exec _LinkRefRegions

set ANSI_NULLS OFF
set QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[_LinkRefRegions]
AS

--- Blow Query is Each Area and FORT matching ---
declare @China int 
declare @West_China int
declare @Oasis_Kingdom int
declare @Eu int
declare @Am int
declare @Ca int
declare @ARABIA int

select @China = AssocServer from _RefRegionBindAssocServer where AreaName = 'CHINA'
select @West_China = AssocServer from _RefRegionBindAssocServer where AreaName = 'West_China'
select @Oasis_Kingdom = AssocServer from _RefRegionBindAssocServer where AreaName = 'Oasis_Kingdom'
select @Eu = AssocServer from _RefRegionBindAssocServer where AreaName = 'Eu'
select @Am = AssocServer from _RefRegionBindAssocServer where AreaName = 'Am'
select @Ca = AssocServer from _RefRegionBindAssocServer where AreaName = 'Ca'
select @ARABIA = AssocServer from _RefRegionBindAssocServer where AreaName = 'ARABIA'

update _RefRegionBindAssocServer set AssocServer = @China where AreaName = 'FORT_JA_AREA'
update _RefRegionBindAssocServer set AssocServer = @China where AreaName = 'FORT_BJ_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China where AreaName = 'FORT_DW_AREA'
update _RefRegionBindAssocServer set AssocServer = @West_China where AreaName = 'FORT_HM_AREA'
update _RefRegionBindAssocServer set AssocServer = @Oasis_Kingdom where AreaName = 'FORT_HT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Eu where AreaName = 'FORT_CT_AREA'
update _RefRegionBindAssocServer set AssocServer = @Am where AreaName = 'FORT_ER_AREA'
update _RefRegionBindAssocServer set AssocServer = @Ca where AreaName = 'FORT_SK_AREA'
update _RefRegionBindAssocServer set AssocServer = @ARABIA where AreaName = 'ARABIA' 

begin TRANSACTION
begin 
declare @LinkNum int
declare @this_region int
declare @region_x int
declare @region_z int
declare @wRegionID smallint
declare @wTempRID smallint
declare @col_link varchar(256)
declare @query varchar(256)
declare @db_id_to_link smallint

-- clear all existing region link
set @LinkNum = 1
while (@LinkNum <= 10)
begin
set @query = 'update _RefRegion set LinkedRegion_' + cast(@LinkNum as varchar(10)) + ' = 0'
execute (@query)

set @LinkNum = @LinkNum + 1
end
-- loop all region
declare region_cursor CURSOR FOR
select wRegionID
from _RefRegion
OPEN region_cursor
FETCH NEXT FROM region_cursor INTO @wRegionID
WHILE @@FETCH_STATUS = 0
begin 
if (@@error = 0 and @wRegionID <> 0)
begin
-- ´øÀüÀº ½ºÅµ!
if (@wRegionID > 0)
begin
set @LinkNum = 8
while (@LinkNum >= 0)
begin
set @region_z = (@wRegionID & 0xff00) / 256
set @region_x = (@wRegionID & 0x0ff)
set @wTempRID = 0;

if (@LinkNum = 0)
begin
set @region_x = @region_x - 1
set @col_link = 'LinkedRegion_1'
end
else if (@LinkNum = 1)
begin
set @region_x = @region_x - 1
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_2'
end
else if (@LinkNum = 2)
begin
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_3'
end
else if (@LinkNum = 3)
begin
set @region_x = @region_x + 1
set @region_z = @region_z + 1
set @col_link = 'LinkedRegion_4'
end
else if (@LinkNum = 4)
begin
set @region_x = @region_x + 1
set @col_link = 'LinkedRegion_5'
end
else if (@LinkNum = 5)
begin
set @region_x = @region_x + 1
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_6'
end
else if (@LinkNum = 6)
begin
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_7'
end
else if (@LinkNum = 7)
begin
set @region_x = @region_x - 1
set @region_z = @region_z - 1
set @col_link = 'LinkedRegion_8'
end

set @wTempRID = (@region_z & 0x00ff) * 256
set @wTempRID = @wTempRID + (@region_x & 0x00ff)

select @db_id_to_link = wRegionID
from _RefRegion
where wRegionID = @wTempRID

if (@@ROWCOUNT <> 0)
begin
set @query = 'update _RefRegion set ' + @col_link + ' = ' + cast(@db_id_to_link as varchar(10)) + ' where wRegionID = ' + cast(@wRegionID as varchar(10))
end
else -- Á¸ÀçÇÏÁö ¾Ê´Â region link ´Â 0À¸·Î ä¿î´Ù
begin
set @query = 'update _RefRegion set ' + @col_link + ' = 0 where wRegionID = ' + cast(@wRegionID as varchar(10))
end

execute(@query)
set @LinkNum = @LinkNum - 1
end
end
end
FETCH NEXT FROM region_cursor INTO @wRegionID
end

CLOSE region_cursor
DEALLOCATE region_cursor
COMMIT TRANSACTION
end

[khongtuong]

Bug, but better than you keep it for yourself.

[Alexiuns]

I Remove Some Lines From DB Is You Get It Gzz New Town
2st in the world fixed arabia town in the world iam King$ ^^

[blackmarket12]

Do I need to edit GameServer ?

[glialka]

First of all, you doesnt deserve 1 credit, neither any of you.
All credits goes to cimo and joymax, all what you did, is splitting that **** part by part.
Second, this release is pretty ****** up,even that, you couldnt done perfectly, King$$$$