!_Ahmed Elabbasy_!
20-05-2015, 06:13 AM
http://www14.0zz0.com/2013/11/16/11/632565550.gif
نوصو منقول للافادة
Alchemy3x
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2044'
http://www5.0zz0.com/2013/10/31/02/766996312.png
- Edit MaxStack for all items of stack = 50.
USE [SRO_VT_SHARD_INIT]
GO
UPDATE dbo._RefObjItem
SET MaxStack = 10000
WHERE MaxStack = 50
http://www5.0zz0.com/2013/10/31/02/766996312.png
تعديل ال dara Devil مش كاملة
UPDATE _RefSkill SET Basic_ChainCode=9046 WHERE ID=9035
UPDATE _RefSkill SET Basic_ChainCode=9047 WHERE ID=9036
UPDATE _RefSkill SET Basic_ChainCode=9048 WHERE ID=9037
UPDATE _RefSkill SET Basic_ChainCode=9049 WHERE ID=9038
UPDATE _RefSkill SET Basic_ChainCode=9050 WHERE ID=9039
UPDATE _RefSkill SET Basic_ChainCode=9051 WHERE ID=9040
UPDATE _RefSkill SET Basic_ChainCode=9052 WHERE ID=9041
UPDATE _RefSkill SET Basic_ChainCode=9053 WHERE ID=9042
http://www5.0zz0.com/2013/10/31/02/766996312.png
Fix FW Uniqe
use SRO_VT_SHARD_INIT
UPDATE _RefObjCommon SET TypeID3=1, TypeID4=1, Rarity=3
WHERE (CodeName128 LIKE 'MOB_FW_KYKLOPES_%') OR
(CodeName128 LIKE 'MOB_FW_WHITETIGER_%') OR
(CodeName128 LIKE 'MOB_FW_DARKEAGLE%') OR
(CodeName128 LIKE 'MOB_FW_HAGIAZO%') OR
(CodeName128 LIKE 'MOB_FW_BIGSPIDER_%') OR
(CodeName128 LIKE 'MOB_FW_HANGA%')
http://www5.0zz0.com/2013/10/31/02/766996312.png
open Skill 125
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 1 AND 273
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 276 AND 3481
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3486 AND 3491
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3493 AND 8321
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8328 AND 8328
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8331 AND 12176
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12178 AND 12186
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12188 AND 12196
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12198 AND 12199
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12201 AND 12206
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12210 AND 12216
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12218 AND 12222
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12225 AND 12306
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12323 AND 20309
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20311 AND 20501
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20503 AND 21266
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 21268 AND 29693
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 29696 AND 30897
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31038 AND 31086
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31088 AND 31103
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31105 AND 31181
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31190 AND 31196
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31198 AND 31924
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32088 AND 32874
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32891 AND 32894
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32897 AND 32904
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33042 AND 33045
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33077 AND 33287
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33289 AND 33294
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33296 AND 33300
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33302 AND 33307
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33309 AND 33312
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33314 AND 33338
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33340 AND 33347
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33349 AND 33372
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33374 AND 33382
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33740 AND 33785
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 7182 AND 7184
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 3436 AND 3440
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 5409 AND 5409
تغير ال ID
USE [SRO_VT_ACCOUNT]
declare @AtualID varchar (30)
declare @NewID varchar (30)
set @AtualID = 'youridhere'
set @NewID = 'newidhere'
update tb_user set struserid = @NewID
where struserid = @ActualID
http://www5.0zz0.com/2013/10/31/02/766996312.png
Fix Honor Rank
USE SRO_VT_SHARD
TRUNCATE TABLE _TrainingCampHonorRank
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50)
exec _TRAINING_CAMP_UPDATEHONORRANK
http://www5.0zz0.com/2013/10/31/02/766996312.png
جميع مسارات الجيم
Media
1-لتغير شكل اللانشر:
media\launcher_europe\bg_4
media\launcher_europe\bg_5
2-لتغير شكل ازرار اللانشر:
media\launcher\start [زرار Start]
media\launcher\exit [زرار Exit]
media\launcher\option [زرار Option]
media\launcher\guide
3-لتغير شكل موقع اللعبة بتاعك الي فوق في اللانشر:
media\launcher_europe\homepage_4
media\launcher_europe\homepage_5
4-لتغير شكل او لون تحميل ال Update:
media\launcher_europe\gauge
5-لتغير لينك موقع ال Homepage:
media\launcher_europe\reflinkurl.txt
6-لتغير شكل ال Start Loading:
interface\loading\start_loading_01
interface\loading\start_loading_02
interface\loading\start_loading_03
interface\loading\start_loading_04
interface\loading\start_loading_05
interface\loading\start_loading_06
interface\loading\start_loading_07
interface\loading\start_loading_08
interface\loading\start_loading_09
interface\loading\start_loading_10
7-لتغير اسم الجيم في ال Intro الاولي :
interface\outer\logo_big
8-تغير اسم الجيم الي فوق ال ID , PW:
interface\outer\logo
9-لتغير شكل Loading عند التيلبورت:
Jangan] interface\loading\loading_zangan]
Forgotten World] interface\loading\loading_wreck_2011]
Echo Valley In Alex] interface\loading\loading_valley]
Alex north] interface\loading\loading_thiefzone]
Thieves town] interface\loading\loading_thief]
Samarkand] interface\loading\loading_samarkand]
Jangan cave] interface\loading\loading_royalmausoleum]
Dead] interface\loading\loading_rebirth]
Roc] interface\loading\loading_loksan]
Jupiter] interface\loading\loading_jupiter_field]
Hotan] interface\loading\loading_hotan]
FW Jangan] interface\loading\loading_fort_jangan_2011]
FW Hotan] interface\loading\loading_fort_hotan_2011]
FW Bandit] interface\loading\loading_fort_bijuckdan_2011]
Donwhang] interface\loading\loading_dunwhang]
Loading] interface\loading\loading_europe_1]
Loading] interface\loading\loading_europe_2]
Loading] interface\loading\loading_default]
Cave donwhang] interface\loading\loading_dungeons_donwhang]
Constantinople] interface\loading\loading_constantinople]
China loading] interface\loading\loading_china_1]
China loading] interface\loading\loading_china_2]
China loading] interface\loading\loading_china_3]
China loading] interface\loading\loading_china_4]
Create ch char] interface\loading\loading_charactercustom]
Create eu char ] interface\loading\loading_charactercustom_europe]
Alex south] interface\loading\loading_alex]
10-تغير لون و شكل Loading:
media\interface\gauge_loading [اللون]
media\interface\loading_form [الشكل]
11-لتغير اي كتابة داخل الجيم[Chat box - Notice - Etc]:
media\server_dep\silkroad\textdata\textuisystem.tx t
12-لتغير ال Intro:
]isro] media\script\intro\jupiter_login.txt
vsro] media\script\intro\egypt.txt
13-لتغير لون ال Plus:
media\resinfo\itemstypenumber.txt
14-لتغير Effect السلاح:
media\resinfo\itemrare.txt
15-لتغير اسم اي شي في الجيمMonster - Npc - Avatars - Weapons - Armors - Etc]
media\server_dep\silkroad\textdata\textdata_object .txt
16-لتغير شكل Skills bar:
media\interface\underbar\ub_new_mainbar2
17-كل جاجة عن FortressWar:
media\icon\etc\fortress_axe.ddj
media\icon\etc\fortress_hammer.ddj
media\icon\etc\mark_fortress2.ddj
media\icon\etc\mark_fortress3.ddj
media\icon\item\fort\fortress_axe.ddj
media\icon\item\fort\fortress_hammer.ddj
media\icon\npc\fortress_battleaide.ddj
media\icon\npc\fortress_manager.ddj
media\icon\npc\fortress_offical.ddj
media\icon\npc\fortress_smith.ddj
media\icon\npc\fortress_trainer.ddj
media\interface\chattingwnd\chat_lamp_fortress.ddj
media\interface\guide\fortress_defensive_position. ddj
media\interface\guide\fortress_fort_stone.ddj
media\interface\guide\fortress_gate.ddj
media\interface\guide\fortress_guard_tower.ddj
media\interface\guide\fortress_headquarters.ddj
media\resinfo\iffortressbusiness.txt
media\resinfo\iffortressbusinessslot.txt
media\resinfo\iffortressmakeitemwnd.txt
media\resinfo\iffortressmakeitemwndslot.txt
media\resinfo\iffortressmap.txt
media\resinfo\iffortresswarapplywnd.txt
media\resinfo\iffortresswarapplywndslot.txt
media\resinfo\iftw_fortressstructure.txt
media\server_dep\silkroad\textdata\siegefortress.t xt
media\server_dep\silkroad\textdata\siegefortressba ttlerank.txt
media\server_dep\silkroad\textdata\siegefortressgu ard.txt
media\server_dep\silkroad\textdata\siegefortressit emforge.txt
media\server_dep\silkroad\textdata\siegefortressre ward.txt
اكتر حاجة مهمة في Data هي اشكال الاسلحة
1-تغير شكل السلاح:
data\prim\mesh\item
data\prim\mtrl\item
data\res\item
1-لتغير موسيقي ال Intro:
music\roc_bgm_total.ogg
2-لتغير موسيقي FW:
music\fortress_war.ogg
3-لتغير موسيقي المدن:
Jangan] music\jangan_town.ogg]
Donwhang] music\donwhang_town.ogg]
Constantinople] music\easterneurope_town.ogg]
Smarkand] music\centralasia_town.ogg]
Baghdad] music\arabia_town.ogg]
Alex south] music\egypt_town_alexandria1.ogg]
Alex north] music\egypt_town_alexandria2.ogg]
Roc] music\roc_battle.ogg]
1-Avatars:
و ابحث عن الافاتار الي انت عايزة\particles\system
2-Pets:
و بردو تبحث عن الحيوان الي انت عايزة\particles\cos
3-Npcs:
particles\npc
4-شكل ضربة الاسكيل:
particles\hiteffec
لسا بنقول يا هادى الشغل لسا جاى
http://www6.0zz0.com/2013/10/31/01/698124232.png
نوصو منقول للافادة
Alchemy3x
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2044'
http://www5.0zz0.com/2013/10/31/02/766996312.png
- Edit MaxStack for all items of stack = 50.
USE [SRO_VT_SHARD_INIT]
GO
UPDATE dbo._RefObjItem
SET MaxStack = 10000
WHERE MaxStack = 50
http://www5.0zz0.com/2013/10/31/02/766996312.png
تعديل ال dara Devil مش كاملة
UPDATE _RefSkill SET Basic_ChainCode=9046 WHERE ID=9035
UPDATE _RefSkill SET Basic_ChainCode=9047 WHERE ID=9036
UPDATE _RefSkill SET Basic_ChainCode=9048 WHERE ID=9037
UPDATE _RefSkill SET Basic_ChainCode=9049 WHERE ID=9038
UPDATE _RefSkill SET Basic_ChainCode=9050 WHERE ID=9039
UPDATE _RefSkill SET Basic_ChainCode=9051 WHERE ID=9040
UPDATE _RefSkill SET Basic_ChainCode=9052 WHERE ID=9041
UPDATE _RefSkill SET Basic_ChainCode=9053 WHERE ID=9042
http://www5.0zz0.com/2013/10/31/02/766996312.png
Fix FW Uniqe
use SRO_VT_SHARD_INIT
UPDATE _RefObjCommon SET TypeID3=1, TypeID4=1, Rarity=3
WHERE (CodeName128 LIKE 'MOB_FW_KYKLOPES_%') OR
(CodeName128 LIKE 'MOB_FW_WHITETIGER_%') OR
(CodeName128 LIKE 'MOB_FW_DARKEAGLE%') OR
(CodeName128 LIKE 'MOB_FW_HAGIAZO%') OR
(CodeName128 LIKE 'MOB_FW_BIGSPIDER_%') OR
(CodeName128 LIKE 'MOB_FW_HANGA%')
http://www5.0zz0.com/2013/10/31/02/766996312.png
open Skill 125
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 1 AND 273
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 276 AND 3481
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3486 AND 3491
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3493 AND 8321
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8328 AND 8328
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8331 AND 12176
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12178 AND 12186
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12188 AND 12196
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12198 AND 12199
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12201 AND 12206
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12210 AND 12216
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12218 AND 12222
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12225 AND 12306
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12323 AND 20309
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20311 AND 20501
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20503 AND 21266
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 21268 AND 29693
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 29696 AND 30897
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31038 AND 31086
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31088 AND 31103
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31105 AND 31181
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31190 AND 31196
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31198 AND 31924
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32088 AND 32874
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32891 AND 32894
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32897 AND 32904
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33042 AND 33045
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33077 AND 33287
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33289 AND 33294
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33296 AND 33300
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33302 AND 33307
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33309 AND 33312
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33314 AND 33338
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33340 AND 33347
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33349 AND 33372
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33374 AND 33382
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33740 AND 33785
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 7182 AND 7184
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 3436 AND 3440
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 5409 AND 5409
تغير ال ID
USE [SRO_VT_ACCOUNT]
declare @AtualID varchar (30)
declare @NewID varchar (30)
set @AtualID = 'youridhere'
set @NewID = 'newidhere'
update tb_user set struserid = @NewID
where struserid = @ActualID
http://www5.0zz0.com/2013/10/31/02/766996312.png
Fix Honor Rank
USE SRO_VT_SHARD
TRUNCATE TABLE _TrainingCampHonorRank
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50)
exec _TRAINING_CAMP_UPDATEHONORRANK
http://www5.0zz0.com/2013/10/31/02/766996312.png
جميع مسارات الجيم
Media
1-لتغير شكل اللانشر:
media\launcher_europe\bg_4
media\launcher_europe\bg_5
2-لتغير شكل ازرار اللانشر:
media\launcher\start [زرار Start]
media\launcher\exit [زرار Exit]
media\launcher\option [زرار Option]
media\launcher\guide
3-لتغير شكل موقع اللعبة بتاعك الي فوق في اللانشر:
media\launcher_europe\homepage_4
media\launcher_europe\homepage_5
4-لتغير شكل او لون تحميل ال Update:
media\launcher_europe\gauge
5-لتغير لينك موقع ال Homepage:
media\launcher_europe\reflinkurl.txt
6-لتغير شكل ال Start Loading:
interface\loading\start_loading_01
interface\loading\start_loading_02
interface\loading\start_loading_03
interface\loading\start_loading_04
interface\loading\start_loading_05
interface\loading\start_loading_06
interface\loading\start_loading_07
interface\loading\start_loading_08
interface\loading\start_loading_09
interface\loading\start_loading_10
7-لتغير اسم الجيم في ال Intro الاولي :
interface\outer\logo_big
8-تغير اسم الجيم الي فوق ال ID , PW:
interface\outer\logo
9-لتغير شكل Loading عند التيلبورت:
Jangan] interface\loading\loading_zangan]
Forgotten World] interface\loading\loading_wreck_2011]
Echo Valley In Alex] interface\loading\loading_valley]
Alex north] interface\loading\loading_thiefzone]
Thieves town] interface\loading\loading_thief]
Samarkand] interface\loading\loading_samarkand]
Jangan cave] interface\loading\loading_royalmausoleum]
Dead] interface\loading\loading_rebirth]
Roc] interface\loading\loading_loksan]
Jupiter] interface\loading\loading_jupiter_field]
Hotan] interface\loading\loading_hotan]
FW Jangan] interface\loading\loading_fort_jangan_2011]
FW Hotan] interface\loading\loading_fort_hotan_2011]
FW Bandit] interface\loading\loading_fort_bijuckdan_2011]
Donwhang] interface\loading\loading_dunwhang]
Loading] interface\loading\loading_europe_1]
Loading] interface\loading\loading_europe_2]
Loading] interface\loading\loading_default]
Cave donwhang] interface\loading\loading_dungeons_donwhang]
Constantinople] interface\loading\loading_constantinople]
China loading] interface\loading\loading_china_1]
China loading] interface\loading\loading_china_2]
China loading] interface\loading\loading_china_3]
China loading] interface\loading\loading_china_4]
Create ch char] interface\loading\loading_charactercustom]
Create eu char ] interface\loading\loading_charactercustom_europe]
Alex south] interface\loading\loading_alex]
10-تغير لون و شكل Loading:
media\interface\gauge_loading [اللون]
media\interface\loading_form [الشكل]
11-لتغير اي كتابة داخل الجيم[Chat box - Notice - Etc]:
media\server_dep\silkroad\textdata\textuisystem.tx t
12-لتغير ال Intro:
]isro] media\script\intro\jupiter_login.txt
vsro] media\script\intro\egypt.txt
13-لتغير لون ال Plus:
media\resinfo\itemstypenumber.txt
14-لتغير Effect السلاح:
media\resinfo\itemrare.txt
15-لتغير اسم اي شي في الجيمMonster - Npc - Avatars - Weapons - Armors - Etc]
media\server_dep\silkroad\textdata\textdata_object .txt
16-لتغير شكل Skills bar:
media\interface\underbar\ub_new_mainbar2
17-كل جاجة عن FortressWar:
media\icon\etc\fortress_axe.ddj
media\icon\etc\fortress_hammer.ddj
media\icon\etc\mark_fortress2.ddj
media\icon\etc\mark_fortress3.ddj
media\icon\item\fort\fortress_axe.ddj
media\icon\item\fort\fortress_hammer.ddj
media\icon\npc\fortress_battleaide.ddj
media\icon\npc\fortress_manager.ddj
media\icon\npc\fortress_offical.ddj
media\icon\npc\fortress_smith.ddj
media\icon\npc\fortress_trainer.ddj
media\interface\chattingwnd\chat_lamp_fortress.ddj
media\interface\guide\fortress_defensive_position. ddj
media\interface\guide\fortress_fort_stone.ddj
media\interface\guide\fortress_gate.ddj
media\interface\guide\fortress_guard_tower.ddj
media\interface\guide\fortress_headquarters.ddj
media\resinfo\iffortressbusiness.txt
media\resinfo\iffortressbusinessslot.txt
media\resinfo\iffortressmakeitemwnd.txt
media\resinfo\iffortressmakeitemwndslot.txt
media\resinfo\iffortressmap.txt
media\resinfo\iffortresswarapplywnd.txt
media\resinfo\iffortresswarapplywndslot.txt
media\resinfo\iftw_fortressstructure.txt
media\server_dep\silkroad\textdata\siegefortress.t xt
media\server_dep\silkroad\textdata\siegefortressba ttlerank.txt
media\server_dep\silkroad\textdata\siegefortressgu ard.txt
media\server_dep\silkroad\textdata\siegefortressit emforge.txt
media\server_dep\silkroad\textdata\siegefortressre ward.txt
اكتر حاجة مهمة في Data هي اشكال الاسلحة
1-تغير شكل السلاح:
data\prim\mesh\item
data\prim\mtrl\item
data\res\item
1-لتغير موسيقي ال Intro:
music\roc_bgm_total.ogg
2-لتغير موسيقي FW:
music\fortress_war.ogg
3-لتغير موسيقي المدن:
Jangan] music\jangan_town.ogg]
Donwhang] music\donwhang_town.ogg]
Constantinople] music\easterneurope_town.ogg]
Smarkand] music\centralasia_town.ogg]
Baghdad] music\arabia_town.ogg]
Alex south] music\egypt_town_alexandria1.ogg]
Alex north] music\egypt_town_alexandria2.ogg]
Roc] music\roc_battle.ogg]
1-Avatars:
و ابحث عن الافاتار الي انت عايزة\particles\system
2-Pets:
و بردو تبحث عن الحيوان الي انت عايزة\particles\cos
3-Npcs:
particles\npc
4-شكل ضربة الاسكيل:
particles\hiteffec
لسا بنقول يا هادى الشغل لسا جاى
http://www6.0zz0.com/2013/10/31/01/698124232.png