komnda |
23-08-2013 12:23 AM |
طلبك مش هيخرج من هنا
http://img607.imageshack.us/img607/792/4rwa.jpg
http://img153.imageshack.us/img153/8531/rzh.gif
طلبات من خارج السيرفر وشروحات
1- عـمل سـيرفر خـاص
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
2- عـاوز مـلفات مـوقع
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
HERE
3-
فى 3 طـرق لعـمل السـيرفـر و 3 طـرق ليـهم شـرح واحـد تـمام
1- عـلى هـماشى
ده لازمـ يخـشو مـعاك فـى رووم عـشان يـبقا فـى شـبكة
اقـفل الـ FireWall
http://www2.0zz0.com/2013/08/23/00/973187606.gif
2-
Ip Static
وده بـتطلبو مـن الـشركة
HERE
بتـكلم الـشركة تـقولهم عـايز static IP هـيقلولك على حاجه تعـملها مـن المـوقع وخـلال 24 سـاعه يتقدر تدخل على صفحه الروتر تاخد ال IP
بس خلى بالك من حاجه فى link عندنا ب 80 جنيه فى الشهر مش زى tedata ب 10 جنيه بس فى الشهر
http://www2.0zz0.com/2013/08/23/00/973187606.gif
3-
VPS
HERE
شرح ليه
IIS
VPS ده بيكون جهاز بتشغل عليه السيرفر بتاعك والمميزات اللى فيه انه فيه سرعه اتصال عاليه جدا بالنت وبيكون شغال 24/7 وبامكانيات جهاز عاليه جدا علشان تشيل لعيبه فى السيرفر بتاعك اكتر وفى شركات كتير بتاعت VPS
http://www2.0zz0.com/2013/08/23/00/973187606.gif
4-
ملفات dump كتيره واللعبه تقيله
البرنامج اهو
حمل دولات الاول واتبع الشرح
http://www27.zippyshare.com/v/44783088/file.html
http://www27.zippyshare.com/v/79904684/file.html
شرح الاستخدام
http://www2.0zz0.com/2013/08/23/00/973187606.gif
1- حط ملف برنامج RemoveDumpFiles فى ملفات السيرفر
2- افتح xvi
3- اضغط file بعدين opean واختار الى انت عايزه زي Sr_GM او Sr_SM او GlobalManger
4- بعدين اضغط فوق على XVIScript واختار file وبعدين opean T تانى واختار RemoveDump File
5- واعمل ExecuTe
6- اعمل Save او CTRL +S واقفل مبروك عليك كده مافيش ملفات Dump تانى
طلبات من جوا اللعبه وشروحات
http://www2.0zz0.com/2013/08/23/00/973187606.gif
1-
شرح لـ Stall 500b
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
2-
ازاى اغير اسم المدن
textdata_object
فـى الميــديـا
http://www2.0zz0.com/2013/08/23/00/973187606.gif
3-
عايز احط Music
لتغير موسيقي ال Intro
music\roc_bgm_total.ogg
........................
لتغير موسيقي FW
music\fortress_war.ogg
........................
لتغير موسيقي المدن
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]
http://www2.0zz0.com/2013/08/23/00/973187606.gif
4-
عاوز اغير اسامى npc
عايز تغير اسم الـ npc
من Media\server_dep\silkroad\textdata\textdata_object
http://www2.0zz0.com/2013/08/23/00/973187606.gif
5-
+255
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
6-
نسبه نجاح الماجيك بوب
HERE
او ممكن تخلى 10 75
التحكم فى الايتم فى ماجيك بوب
SRO_VT_SHARD -> Tables -> _RefGachaItemSet
فى الداتا بيز و الميديا
العمود رقم 3 بيكون فيه كود الايتم
بص العمود رقم 3 بيكون فيه كود الايتم
خود الكود كوبى و ابحث عنه فى ال Common
هتعرف السطر ده بتاع أى اتم بالضبط
و الايتم ألى عايز تلغيها اعمل ال service بتاعها 0
ألى هو اول عمود
و common ف
Sro_vt_shard
في تابل اسمه refcommon
http://www2.0zz0.com/2013/08/23/00/973187606.gif
7-
دلوقتى عاوز الناس تنزل معاه سيلك مثلا او ايتم
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
8-
كيفية مسح حاجات من F10
SRO_VT_SHARD -> Tables -> RefShopGoods
هتلاقى كل حاجه موجوده فى ال item mall اعمل ال service 0 لو عايز تقفلها ومتنساش تعمل فى الكلينت زى ما هتعمل فى الداتابيز من .text اسمه refshopgoods برضه
http://www2.0zz0.com/2013/08/23/00/973187606.gif
9-
عايز اعرف ازاي انزل لفل البونيك مثلا roc lvl 100 اخليه 90
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
10-
دلوقتى وانتا جوا اللعبه عملت صوره لل guild ومش باينه
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
11-
عاوز اظبط نسبه نجاح ++
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
12-
عاوز تضيف premuim 30%
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
13-
الفورتيس
HERE
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
14-
انا محتاج اعدل علي الـ logo و الـ logo big
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
15-
انا عندي client d16 عايز اخد منو ملفات الاسلحة d16 اخد ملفات ايه
كود PHP:
Data\prim\mesh\item\china\armor\
Data\prim\mesh\item\china\weapon
Data\prim\mesh\item\europe\armor
Data\prim\mesh\item\europe\weapon
Data\prim\mtrl\etc
Data\prim\mtrl\item\china\armor
Data\prim\mtrl\item\china\weapon
Data\prim\mtrl\item\etc
Data\prim\mtrl\item\europe\weapon
Data\prim\skel\item\china\armor
Data\prim\skel\item\china\weapon
Data\prim\skel\item\europe\weapon
Data\res\item\china\shield
Data\res\item\china\weapon
Data\res\item\europe\shield
Data\res\item\europe\weapon
Media\icon\item\china
Media\icon\item\china\acc
Media\icon\item\china\man_item
Media\icon\item\china\shield
Media\icon\item\china\weapon
Media\icon\item\china\woman_item
Media\icon\item\europe
Media\icon\item\europe\acc
Media\icon\item\europe\man_item
Media\icon\item\europe\shield
Media\icon\item\europe\weapon
Media\icon\item\europe\woman_item
Particles\system
Particles\textures
http://www2.0zz0.com/2013/08/23/00/973187606.gif
16-
ازاى امسح البريميوم من اى حد
كود PHP:
USE SRO_VT_SHARD
DELETE FROM _TimedJob WHERE CharID = 'ID'
http://www2.0zz0.com/2013/08/23/00/973187606.gif
17-
i want to know how to make the item at npc FB
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
18-
ازاي اعدل حاجا في الميديا
HERE
كيفيه عمل ابديت
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
19-
تغيير مكان ال Unique و تعديل وقت النزول
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
20-
انا عندى موب عايز اعملو Unique
كود PHP:
USE SRO_VT_SHARD
GO
update _RefObjCommon set Rarity = 3 where CodeName128 = 'Code el mob hna'
Print 'Mob has been changed to unique'
Print 'Query Has Created by Alaa2k'
http://www2.0zz0.com/2013/08/23/00/973187606.gif
21-
عاوز ga ينزل بونك بس
HERE
22-
1-
عاوز تغير اسعار الايتم
حضرتك اول طلب هتروح Refpriceofitem
ودور علي الكود اللي عايز تغير سعرو واعمل Paymnetdevice
1 = Gold
2 = Silk
4 = Gift Silk (Received Silk)
16 = Point (vSRO); Premium Silk (iSRO & kSRO)
32 = Honor Point
64 = Copper Coin
128 = Iron Coin
256 = Silver Coin
512 = Gold Coin
1024 = Arena Coin
2-
دلوقتى دخلت الجيم ملئتش البرميم مش موجود
go refobjcommon
ودور علي كود البريميم واعمل ال service 1 مش 0
http://www2.0zz0.com/2013/08/23/00/973187606.gif
23-
اعمل تيتل يعجبك
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
24-
ازاي اعمل SPEED
و اغير و اعدل علي الوقت بتعها
HERE
اكتب /makeitem speed ودوس F3 هيجبلك كل الSpeed اللى فى الجيم
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
25-
ازاي اضبط Arena
SMC->SR_Scheduler
SCHEDULE_DEF_BATTLE_ARENA_MATCH_POINT
SCHEDULE_DEF_BATTLE_ARENA_MATCH_FLAG
دول لازم شغالين 24 ساعة
SCHEDULE_DEF_BATTLE_ARENA_XXX_PARTICIPATION
دا معاد التسجيل
SCHEDULE_DEF_BATTLE_ARENA_XXX
معاد الأرينا نفسها.
متعلق به
HERE
عشان تظبط الوقت
http://www2.0zz0.com/2013/08/23/00/973187606.gif
26-
MaxStock
SQL / SRO_VT_SHARD / TABLES / RefObjItem
MaxStock خليها الرقم اللى انت عايزو
http://www2.0zz0.com/2013/08/23/00/973187606.gif
27-
عاوز الناس تنزل لفل مثلا 110
هتفتح SQL
وبعدين تختار
SRO_VT_Shard /Programmability/Stored Procedures /_AddNewChar
كود PHP:
-- ہخ´ّ½أ½؛إغہج ہû؟ëµا¸é¼* ¸¶ءِ¸·؟، WorldID؟ح 1°ھہ» ´ُ ³ض¾î ءض¾ْ´ظ!
INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,
LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,
GetDate(), 1, 1, 0, 0, 0, 200,200, 1, 1, 1, 1)
1,1
خليها
110.110
http://www2.0zz0.com/2013/08/23/00/973187606.gif
28-
ازاي ادخل على سيرفير من دون Edx Loder
عايز اخش من Launcher
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
29-
عاوز تظبط اكونت [GM]
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
30-
جميع ملفات New Pets Attack ميديا وداتا
All Follow Pets
All Follow Pets
All Follow Pets
All Follow Pets
http://www2.0zz0.com/2013/08/23/00/973187606.gif
31-
تضيف ايتم ل char معين
كود PHP:
USE(SRO_VT_SHARD)
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)
set @CharName = 'YourCharName'
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,1
ده عشان تضيف ايتم لـ Char معين عدل على ITEM_EU_TSTAFF_11_SET_B_RARE بكود الايتم اللى عايزو
32-
عاوز ترجع الشخصيه janjan
كود PHP:
USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25000, posX= 982 , posY= -0.421872 ,posZ= 140 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0,
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0
http://www2.0zz0.com/2013/08/23/00/973187606.gif
33-
عايز كويري مسح الناس الي واخدة جميع الفورتيس وار و يبداو يخدوها من الاول
كود PHP:
USE SRO_VT_SHARD
UPDATE _SiegeFortress SET GuildID = 0
http://www2.0zz0.com/2013/08/23/00/973187606.gif
34-
عاوز الناس المعاهم جلوبال ميكتبش فيه
كود PHP:
USE [SRO_VT_SHARD]
Exec [Dbo].[_SEEK_N_DESTROY_ITEM] ['ITEM Code Name' ]
لو عاوز تقفل الجلوبال خالص
هتروح علي Ref.Shopgood's في ال Media وهتعمل بحث عن كلمت CHAT و هتيحي في الاول هتلقيها 1هتخليها 0 و نفس الكلام بردو في SRO_VT_SHARD
http://www2.0zz0.com/2013/08/23/00/973187606.gif
35-
open all skill to gm
كود PHP:
USE [SRO_VT_SHARD]
DECLARE @CharName varchar(255)
DECLARE @CharID INT
SET @CharName='MyReturn'
SELECT @CharID = CharID FROM _Char WHERE CharName16=@CharName
UPDATE _CharSkillMastery SET Level = '120' WHERE CharID=@CharID
INSERT INTO _CharSkill VALUES (@CharID,1,1)
INSERT INTO _CharSkill VALUES (@CharID,2,1)
INSERT INTO _CharSkill VALUES (@CharID,40,1)
INSERT INTO _CharSkill VALUES (@CharID,70,1)
INSERT INTO _CharSkill VALUES (@CharID,298,1)
INSERT INTO _CharSkill VALUES (@CharID,306,1)
INSERT INTO _CharSkill VALUES (@CharID,314,1)
INSERT INTO _CharSkill VALUES (@CharID,322,1)
INSERT INTO _CharSkill VALUES (@CharID,346,1)
INSERT INTO _CharSkill VALUES (@CharID,378,1)
INSERT INTO _CharSkill VALUES (@CharID,418,1)
INSERT INTO _CharSkill VALUES (@CharID,463,1)
INSERT INTO _CharSkill VALUES (@CharID,558,1)
INSERT INTO _CharSkill VALUES (@CharID,569,1)
INSERT INTO _CharSkill VALUES (@CharID,580,1)
INSERT INTO _CharSkill VALUES (@CharID,588,1)
INSERT INTO _CharSkill VALUES (@CharID,596,1)
INSERT INTO _CharSkill VALUES (@CharID,604,1)
INSERT INTO _CharSkill VALUES (@CharID,647,1)
INSERT INTO _CharSkill VALUES (@CharID,655,1)
INSERT INTO _CharSkill VALUES (@CharID,672,1)
INSERT INTO _CharSkill VALUES (@CharID,689,1)
INSERT INTO _CharSkill VALUES (@CharID,699,1)
INSERT INTO _CharSkill VALUES (@CharID,708,1)
INSERT INTO _CharSkill VALUES (@CharID,716,1)
INSERT INTO _CharSkill VALUES (@CharID,724,1)
INSERT INTO _CharSkill VALUES (@CharID,735,1)
INSERT INTO _CharSkill VALUES (@CharID,746,1)
INSERT INTO _CharSkill VALUES (@CharID,757,1)
INSERT INTO _CharSkill VALUES (@CharID,765,1)
INSERT INTO _CharSkill VALUES (@CharID,773,1)
INSERT INTO _CharSkill VALUES (@CharID,781,1)
INSERT INTO _CharSkill VALUES (@CharID,789,1)
INSERT INTO _CharSkill VALUES (@CharID,797,1)
INSERT INTO _CharSkill VALUES (@CharID,805,1)
INSERT INTO _CharSkill VALUES (@CharID,813,1)
INSERT INTO _CharSkill VALUES (@CharID,821,1)
INSERT INTO _CharSkill VALUES (@CharID,829,1)
INSERT INTO _CharSkill VALUES (@CharID,853,1)
INSERT INTO _CharSkill VALUES (@CharID,885,1)
INSERT INTO _CharSkill VALUES (@CharID,925,1)
INSERT INTO _CharSkill VALUES (@CharID,933,1)
INSERT INTO _CharSkill VALUES (@CharID,943,1)
INSERT INTO _CharSkill VALUES (@CharID,952,1)
INSERT INTO _CharSkill VALUES (@CharID,960,1)
INSERT INTO _CharSkill VALUES (@CharID,968,1)
INSERT INTO _CharSkill VALUES (@CharID,976,1)
INSERT INTO _CharSkill VALUES (@CharID,984,1)
INSERT INTO _CharSkill VALUES (@CharID,992,1)
INSERT INTO _CharSkill VALUES (@CharID,1003,1)
INSERT INTO _CharSkill VALUES (@CharID,1014,1)
INSERT INTO _CharSkill VALUES (@CharID,1025,1)
INSERT INTO _CharSkill VALUES (@CharID,1033,1)
INSERT INTO _CharSkill VALUES (@CharID,1041,1)
INSERT INTO _CharSkill VALUES (@CharID,1049,1)
INSERT INTO _CharSkill VALUES (@CharID,1053,1)
INSERT INTO _CharSkill VALUES (@CharID,1057,1)
INSERT INTO _CharSkill VALUES (@CharID,1065,1)
INSERT INTO _CharSkill VALUES (@CharID,1073,1)
INSERT INTO _CharSkill VALUES (@CharID,1081,1)
INSERT INTO _CharSkill VALUES (@CharID,1089,1)
INSERT INTO _CharSkill VALUES (@CharID,1099,1)
INSERT INTO _CharSkill VALUES (@CharID,1108,1)
INSERT INTO _CharSkill VALUES (@CharID,1116,1)
INSERT INTO _CharSkill VALUES (@CharID,1124,1)
INSERT INTO _CharSkill VALUES (@CharID,1132,1)
INSERT INTO _CharSkill VALUES (@CharID,1140,1)
INSERT INTO _CharSkill VALUES (@CharID,1148,1)
INSERT INTO _CharSkill VALUES (@CharID,1153,1)
INSERT INTO _CharSkill VALUES (@CharID,1158,1)
INSERT INTO _CharSkill VALUES (@CharID,1163,1)
INSERT INTO _CharSkill VALUES (@CharID,1168,1)
INSERT INTO _CharSkill VALUES (@CharID,1173,1)
INSERT INTO _CharSkill VALUES (@CharID,1178,1)
INSERT INTO _CharSkill VALUES (@CharID,1189,1)
INSERT INTO _CharSkill VALUES (@CharID,1200,1)
INSERT INTO _CharSkill VALUES (@CharID,1217,1)
INSERT INTO _CharSkill VALUES (@CharID,1234,1)
INSERT INTO _CharSkill VALUES (@CharID,1244,1)
INSERT INTO _CharSkill VALUES (@CharID,1253,1)
INSERT INTO _CharSkill VALUES (@CharID,1261,1)
INSERT INTO _CharSkill VALUES (@CharID,1269,1)
INSERT INTO _CharSkill VALUES (@CharID,1271,1)
INSERT INTO _CharSkill VALUES (@CharID,1273,1)
INSERT INTO _CharSkill VALUES (@CharID,1275,1)
INSERT INTO _CharSkill VALUES (@CharID,1286,1)
INSERT INTO _CharSkill VALUES (@CharID,1297,1)
INSERT INTO _CharSkill VALUES (@CharID,1308,1)
INSERT INTO _CharSkill VALUES (@CharID,1316,1)
INSERT INTO _CharSkill VALUES (@CharID,1324,1)
INSERT INTO _CharSkill VALUES (@CharID,1332,1)
INSERT INTO _CharSkill VALUES (@CharID,1337,1)
INSERT INTO _CharSkill VALUES (@CharID,1342,1)
INSERT INTO _CharSkill VALUES (@CharID,1350,1)
INSERT INTO _CharSkill VALUES (@CharID,1358,1)
INSERT INTO _CharSkill VALUES (@CharID,1368,1)
INSERT INTO _CharSkill VALUES (@CharID,1377,1)
INSERT INTO _CharSkill VALUES (@CharID,1385,1)
INSERT INTO _CharSkill VALUES (@CharID,1393,1)
INSERT INTO _CharSkill VALUES (@CharID,1398,1)
INSERT INTO _CharSkill VALUES (@CharID,1403,1)
INSERT INTO _CharSkill VALUES (@CharID,1408,1)
INSERT INTO _CharSkill VALUES (@CharID,1410,1)
INSERT INTO _CharSkill VALUES (@CharID,1412,1)
INSERT INTO _CharSkill VALUES (@CharID,1414,1)
INSERT INTO _CharSkill VALUES (@CharID,1422,1)
INSERT INTO _CharSkill VALUES (@CharID,1430,1)
INSERT INTO _CharSkill VALUES (@CharID,1438,1)
INSERT INTO _CharSkill VALUES (@CharID,1443,1)
INSERT INTO _CharSkill VALUES (@CharID,1448,1)
INSERT INTO _CharSkill VALUES (@CharID,1465,1)
INSERT INTO _CharSkill VALUES (@CharID,1482,1)
INSERT INTO _CharSkill VALUES (@CharID,1499,1)
INSERT INTO _CharSkill VALUES (@CharID,1509,1)
INSERT INTO _CharSkill VALUES (@CharID,1518,1)
INSERT INTO _CharSkill VALUES (@CharID,1526,1)
INSERT INTO _CharSkill VALUES (@CharID,1534,1)
INSERT INTO _CharSkill VALUES (@CharID,1539,1)
INSERT INTO _CharSkill VALUES (@CharID,1544,1)
INSERT INTO _CharSkill VALUES (@CharID,1549,1)
INSERT INTO _CharSkill VALUES (@CharID,1557,1)
INSERT INTO _CharSkill VALUES (@CharID,1565,1)
INSERT INTO _CharSkill VALUES (@CharID,1573,1)
INSERT INTO _CharSkill VALUES (@CharID,1578,1)
INSERT INTO _CharSkill VALUES (@CharID,1583,1)
INSERT INTO _CharSkill VALUES (@CharID,1588,1)
INSERT INTO _CharSkill VALUES (@CharID,1593,1)
INSERT INTO _CharSkill VALUES (@CharID,1598,1)
INSERT INTO _CharSkill VALUES (@CharID,1609,1)
INSERT INTO _CharSkill VALUES (@CharID,1617,1)
INSERT INTO _CharSkill VALUES (@CharID,1628,1)
INSERT INTO _CharSkill VALUES (@CharID,3149,1)
INSERT INTO _CharSkill VALUES (@CharID,3167,1)
INSERT INTO _CharSkill VALUES (@CharID,3176,1)
INSERT INTO _CharSkill VALUES (@CharID,3224,1)
INSERT INTO _CharSkill VALUES (@CharID,3340,1)
INSERT INTO _CharSkill VALUES (@CharID,3349,1)
INSERT INTO _CharSkill VALUES (@CharID,3364,1)
INSERT INTO _CharSkill VALUES (@CharID,3379,1)
INSERT INTO _CharSkill VALUES (@CharID,3391,1)
INSERT INTO _CharSkill VALUES (@CharID,3406,1)
INSERT INTO _CharSkill VALUES (@CharID,3409,1)
INSERT INTO _CharSkill VALUES (@CharID,3415,1)
INSERT INTO _CharSkill VALUES (@CharID,3430,1)
INSERT INTO _CharSkill VALUES (@CharID,3431,1)
INSERT INTO _CharSkill VALUES (@CharID,3446,1)
INSERT INTO _CharSkill VALUES (@CharID,3461,1)
INSERT INTO _CharSkill VALUES (@CharID,3467,1)
INSERT INTO _CharSkill VALUES (@CharID,3473,1)
INSERT INTO _CharSkill VALUES (@CharID,7139,1)
INSERT INTO _CharSkill VALUES (@CharID,7159,1)
INSERT INTO _CharSkill VALUES (@CharID,7203,1)
INSERT INTO _CharSkill VALUES (@CharID,7322,1)
INSERT INTO _CharSkill VALUES (@CharID,7385,1)
INSERT INTO _CharSkill VALUES (@CharID,7390,1)
INSERT INTO _CharSkill VALUES (@CharID,7392,1)
INSERT INTO _CharSkill VALUES (@CharID,7404,1)
INSERT INTO _CharSkill VALUES (@CharID,7418,1)
INSERT INTO _CharSkill VALUES (@CharID,7474,1)
INSERT INTO _CharSkill VALUES (@CharID,7484,1)
INSERT INTO _CharSkill VALUES (@CharID,7513,1)
INSERT INTO _CharSkill VALUES (@CharID,7520,1)
INSERT INTO _CharSkill VALUES (@CharID,7536,1)
INSERT INTO _CharSkill VALUES (@CharID,7554,1)
INSERT INTO _CharSkill VALUES (@CharID,7577,1)
INSERT INTO _CharSkill VALUES (@CharID,7582,1)
INSERT INTO _CharSkill VALUES (@CharID,7584,1)
INSERT INTO _CharSkill VALUES (@CharID,7596,1)
INSERT INTO _CharSkill VALUES (@CharID,7612,1)
INSERT INTO _CharSkill VALUES (@CharID,7637,1)
INSERT INTO _CharSkill VALUES (@CharID,7651,1)
INSERT INTO _CharSkill VALUES (@CharID,7672,1)
INSERT INTO _CharSkill VALUES (@CharID,7675,1)
INSERT INTO _CharSkill VALUES (@CharID,7688,1)
INSERT INTO _CharSkill VALUES (@CharID,7798,1)
INSERT INTO _CharSkill VALUES (@CharID,7805,1)
INSERT INTO _CharSkill VALUES (@CharID,7829,1)
INSERT INTO _CharSkill VALUES (@CharID,7838,1)
INSERT INTO _CharSkill VALUES (@CharID,7839,1)
INSERT INTO _CharSkill VALUES (@CharID,7853,1)
INSERT INTO _CharSkill VALUES (@CharID,7862,1)
INSERT INTO _CharSkill VALUES (@CharID,7877,1)
INSERT INTO _CharSkill VALUES (@CharID,7881,1)
INSERT INTO _CharSkill VALUES (@CharID,7894,1)
INSERT INTO _CharSkill VALUES (@CharID,7899,1)
INSERT INTO _CharSkill VALUES (@CharID,7907,1)
INSERT INTO _CharSkill VALUES (@CharID,7919,1)
INSERT INTO _CharSkill VALUES (@CharID,7931,1)
INSERT INTO _CharSkill VALUES (@CharID,7938,1)
INSERT INTO _CharSkill VALUES (@CharID,7947,1)
INSERT INTO _CharSkill VALUES (@CharID,7953,1)
INSERT INTO _CharSkill VALUES (@CharID,7959,1)
INSERT INTO _CharSkill VALUES (@CharID,7962,1)
INSERT INTO _CharSkill VALUES (@CharID,7972,1)
INSERT INTO _CharSkill VALUES (@CharID,7980,1)
INSERT INTO _CharSkill VALUES (@CharID,7995,1)
INSERT INTO _CharSkill VALUES (@CharID,7997,1)
INSERT INTO _CharSkill VALUES (@CharID,8010,1)
INSERT INTO _CharSkill VALUES (@CharID,8024,1)
INSERT INTO _CharSkill VALUES (@CharID,8050,1)
INSERT INTO _CharSkill VALUES (@CharID,8084,1)
INSERT INTO _CharSkill VALUES (@CharID,8097,1)
INSERT INTO _CharSkill VALUES (@CharID,8103,1)
INSERT INTO _CharSkill VALUES (@CharID,8109,1)
INSERT INTO _CharSkill VALUES (@CharID,8115,1)
INSERT INTO _CharSkill VALUES (@CharID,8119,1)
INSERT INTO _CharSkill VALUES (@CharID,8129,1)
INSERT INTO _CharSkill VALUES (@CharID,8133,1)
INSERT INTO _CharSkill VALUES (@CharID,8142,1)
INSERT INTO _CharSkill VALUES (@CharID,8150,1)
INSERT INTO _CharSkill VALUES (@CharID,8164,1)
INSERT INTO _CharSkill VALUES (@CharID,8171,1)
INSERT INTO _CharSkill VALUES (@CharID,8183,1)
INSERT INTO _CharSkill VALUES (@CharID,8195,1)
INSERT INTO _CharSkill VALUES (@CharID,8204,1)
INSERT INTO _CharSkill VALUES (@CharID,8214,1)
INSERT INTO _CharSkill VALUES (@CharID,8220,1)
INSERT INTO _CharSkill VALUES (@CharID,8221,1)
INSERT INTO _CharSkill VALUES (@CharID,8238,1)
INSERT INTO _CharSkill VALUES (@CharID,8239,1)
INSERT INTO _CharSkill VALUES (@CharID,8250,1)
INSERT INTO _CharSkill VALUES (@CharID,8253,1)
INSERT INTO _CharSkill VALUES (@CharID,8276,1)
INSERT INTO _CharSkill VALUES (@CharID,8291,1)
INSERT INTO _CharSkill VALUES (@CharID,8304,1)
INSERT INTO _CharSkill VALUES (@CharID,8316,1)
INSERT INTO _CharSkill VALUES (@CharID,8320,1)
INSERT INTO _CharSkill VALUES (@CharID,8338,1)
INSERT INTO _CharSkill VALUES (@CharID,8347,1)
INSERT INTO _CharSkill VALUES (@CharID,8348,1)
INSERT INTO _CharSkill VALUES (@CharID,8361,1)
INSERT INTO _CharSkill VALUES (@CharID,8370,1)
INSERT INTO _CharSkill VALUES (@CharID,8379,1)
INSERT INTO _CharSkill VALUES (@CharID,8383,1)
INSERT INTO _CharSkill VALUES (@CharID,8390,1)
INSERT INTO _CharSkill VALUES (@CharID,8399,1)
INSERT INTO _CharSkill VALUES (@CharID,8405,1)
INSERT INTO _CharSkill VALUES (@CharID,8410,1)
INSERT INTO _CharSkill VALUES (@CharID,8414,1)
INSERT INTO _CharSkill VALUES (@CharID,8416,1)
INSERT INTO _CharSkill VALUES (@CharID,20494,1)
INSERT INTO _CharSkill VALUES (@CharID,20497,1)
INSERT INTO _CharSkill VALUES (@CharID,20500,1)
INSERT INTO _CharSkill VALUES (@CharID,21215,1)
INSERT INTO _CharSkill VALUES (@CharID,21217,1)
INSERT INTO _CharSkill VALUES (@CharID,30578,1)
INSERT INTO _CharSkill VALUES (@CharID,30584,1)
INSERT INTO _CharSkill VALUES (@CharID,30590,1)
INSERT INTO _CharSkill VALUES (@CharID,30596,1)
INSERT INTO _CharSkill VALUES (@CharID,30600,1)
http://www2.0zz0.com/2013/08/23/00/973187606.gif
36-
eu drop remove
كود PHP:
USE [SRO_VT_SHARD_INIT]
GO
UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 14181 AND 14869
UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 12844 AND 14180
UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 11417 AND 12843
UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 10897 AND 11416
UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 14181 AND 14869
UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 12844 AND 14180
UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 11417 AND 12843
UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 10897 AND 11416
UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 14181 AND 14869
UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 12844 AND 14180
UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 11417 AND 12843
UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 10897 AND 11416
http://www2.0zz0.com/2013/08/23/00/973187606.gif
37-
avatar gm
كود PHP:
USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)
set @CharName = 'GM'
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_AVATAR_M_GM_UNIFORM',1,0
http://www2.0zz0.com/2013/08/23/00/973187606.gif
38-
ودة عشان تنقل من DB ل DB تنية
كود PHP:
USE SRO_VT_SHARD
GO
TRUNCATE TABLE [dbo].[_RefObjItem]
GO
insert into SRO_VT_SHARD.dbo._RefObjItem select * from SRO_VT_SHARD1.dbo._RefObjItem
http://www2.0zz0.com/2013/08/23/00/973187606.gif
39-
اضافه دجرى جديد مثلا 14 او 15
HERE
نزل الملفات وحطها بدل العندك import
http://www2.0zz0.com/2013/08/23/00/973187606.gif
40-
عايز اغير لفل ايتم
عايز اغير سعر ايتم
1 - _RefObjCommon
2 - _RefPricePolocyOfItem
http://www2.0zz0.com/2013/08/23/00/973187606.gif
41-
فى ايتم فى npc بس مش بتعرف تشتريها
بوص يا باشا Go SRO_VT_SHARD
GO
_RefShop
بوص هالئي في Item في الاول الصفة الاولي بتاعية service
في Item مكتوب جمبة واحد 1
دة بيبوقا يتشري ولي صفر 0 دة مش بيتشرا وي لو عندك مشكلة كراش في F10
اقفل شويه ايتم
42-
موضوع ازاي نديف item fe NPC * Avater
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
43-
◄◄◄حصريا Souless Arch weapon System►►►
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
44-
ازااى اخلــى items الـ silk والـ avatars تتحط فى الــ stall والـ exchange مع العلم انها كلها بجميع انوعها غير قابلة للمبادلة
SRO_VT_SHARD / TABLES / RefObjCommon
CanTrade = 1
بدل 0
http://www2.0zz0.com/2013/08/23/00/973187606.gif
45-
لو سمحت كنت عايز اعرف اعدل ازي hp بتع الموبيس
من تابل refobjchar
وعلشان تجيب كود الموبس من refobjcommon
http://www2.0zz0.com/2013/08/23/00/973187606.gif
46-
تعديل الوان الــ Mobs-Avatars-Weapons
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
47-
الوحوش مش بتظهر ومفيش وحوش فى اللعبه
مع ان كل حاجا انت عاملها تمام
اول حاجا مطلوب منك انك تحمل الملف ده
HERE
تحطها فى C
تانى حاجا هتاخد الكويرى ده وتكتبوا فى SQL
كود PHP:
DELETE FROM [SRO_VT_SHARD ].[dbo].[Tab_RefNest]
USE [SRO_VT_SHARD]
GO
BULK INSERT Tab_RefNest FROM 'C:\RefNEst.txt' WITH (FIELDTERMINATOR = '\t')
واعمل Save
http://www2.0zz0.com/2013/08/23/00/973187606.gif
48-
HOW TO CHANGE PREMUIM %%
1*هتــروح للــ Line بـتــاع الــ Prem فـ الـ _RefObjCommon هتــروح علــى أخــر صـفـ هتــلاقـى أسمــوا Link أعــرفـ مكتــوبـ فيــه رقــمـ كــامـ !
2*هتــروح علــى الرقــمـ اللـى أنــتـ شفتــوا (Link) فـ _RefObjItem هتــروح علــى الــ Desc2_128 عشــانـ تعــرفـ أســمـ الــ Skill !
3*هتــروح علــى _RefSkill وتجيــبـ Line الــ Skill وتغيــر بقــى الـ Params علــى حســبـ مـ أنــتـ عــايــز ..
4* متنســاشـ تغيــر فـى الميــديـا بــردوا !
http://www2.0zz0.com/2013/08/23/00/973187606.gif
49-
Honor Points
اقتباس:
USE [SRO_VT_SHARD]
DECLARE @CharName Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @CharName = 'Charname'
SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName)
SET @CampID = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID)
SET @Graduates = '1234'
SET @HonorPoints= @Graduates * 39
--------------------
UPDATE [Dbo].[_TrainingCamp]
SET GraduateCount = @Graduates
WHERE [Dbo].[_TrainingCamp].[ID] = @CampID
UPDATE [dbo].[_TrainingCampMember]
SET HonorPoint = @HonorPoints
WHERE [dbo].[_TrainingCampMember].[CampID]=@CampID
|
غير الكلام الاحمر
http://www2.0zz0.com/2013/08/23/00/973187606.gif
50-
عايز انزل جاينت او جاينت بارتى
مبدأيـاً ، مفيــش فى الــ Console اوامر للوحــوش الــ Party
بــس ممكن تنــزل الانواع الثـآنية
كود:
/loadmonster MOB_TK_BONELORD 1 GIANT
/loadmonster MOB_TK_BONELORD 1 STRONG
/loadmonster MOB_TK_BONELORD 1 CHAMP
Giant=Giant
Champ=Champion
Strong=Elite
و ملحــوظة . . الــ Console كله لازم بيبقى بحروف Capital
http://www2.0zz0.com/2013/08/23/00/973187606.gif
51-
شرح تعديل Time ال Event So Ok
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
52-
اعمل Auto Notice فى الGame
ببرنامج اسمو auto notic
HERE
حمل البرنامج واكتب ip server واكتب الuser بتاع الجم وبعدين اكتب النوتيك واختار كل كام دقيقة
الباس cpg
http://www2.0zz0.com/2013/08/23/00/973187606.gif
53-
Change mob level
كود PHP:
USE SRO_VT_SHARD
Declare @link int, @codename varchar(max), @level int, @newlevel int;
set @codename = 'SN_MOB_SD_HIKE' /* <- from textdata_object.txt */
set @link = (SELECT Link FROM _RefObJCommon WHERE NameStrID128 = @codename)
set @newlevel = (
case
when (SELECT Lvl FROM _RefObjChar WHERE ID = @link)+10 <= 120 THEN (SELECT Lvl FROM _RefObjChar WHERE ID = @link)+10
ELSE 120
end);
UPDATE _RefObjChar SET Lvl = @newlevel WHERE ID = @link
UPDATE _RefObjChar SET ExpToGive = cast(ExpToGive*1.1 as bigint) WHERE ID = @link
UPDATE _RefObjChar SET MaxHP = cast(MaxHP*1.1 as bigint) WHERE ID = @link
http://www2.0zz0.com/2013/08/23/00/973187606.gif
54-
Change title by cher name
كود PHP:
use SRO_VT_SHARD
Update _Char
set HwanLevel = 'Title Num'
where CharName16 = 'Cher Name'
http://www2.0zz0.com/2013/08/23/00/973187606.gif
55-
شرح عمل اى Item FB واتحكم فى state
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
56-
شرح تقل NPC او Mobs- Unique او ضبط وقت ال Unique
New
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
57=
ممكن Query SPEED Char and Fellow Pet
كود PHP:
USE SRO_VT_SHARD
UPDATE _REFOBJCOMMON SET Speed 1 = xx , Speed2 = xx WHERE CodeName128 = 'Item'
مكان ال xx غير بالسرعه إللي إنتا عايزها
100 = 100%
500 = 500%
ومكان Item كود الChar او ال Pet
http://www2.0zz0.com/2013/08/23/00/973187606.gif
58-
Best Query For Fix Server
كود PHP:
USE[SRO_VT_SHARD]
UPDATE [_RefSkill]SET[Param24]=25 WHERE Basic_Code='SKILL_CH_COLD_GANGGI_A_04'--Restart GameServer
http://www2.0zz0.com/2013/08/23/00/973187606.gif
59-
Query To Set New Max Stack For Elements
كود PHP:
---------------Query Made By Alaa2k ------------- Don't Release it with ur name -----
DECLARE @Stack as Varchar (MAX)
Set @Stack = 'العدد'
update _RefObjItem set MaxStack = @Stack where ID between 4198 and 4209
update _RefObjItem set MaxStack = @Stack where ID between 4222 and 4233
update _RefObjItem set MaxStack = @Stack where ID between 4210 and 4221
update _RefObjItem set MaxStack = @Stack where ID between 4234 and 4245
Print 'Done'
Print 'Made By Alaa2k'
http://www2.0zz0.com/2013/08/23/00/973187606.gif
60-
█◄حصريا شرح تغيير الـ MaxStack لـ Hp,Mp And Elixirs►█
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
61-
New Lucky Skill For Euro - Chinese ♥♥♥♥
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
62 -
تغيير الكود البيجى بعد ما اكتب Id:And:Pass :helpsmilie:
عاوز تغير الرمز هتفتح Server.Cfg
بعد كدا اعمل FIND على IBUVCharacterSet
هتلاقيه قودمها كلام امسحو وى حوط الى عاوزو يجى فى image code وى فوق عند IBUVStringSize هتلاقى قودمها 6 يعنى يختار كام رقم وى يحوطو فى image code
http://www2.0zz0.com/2013/08/23/00/973187606.gif
63 -
كويرى عشان تحوط افاتار جديد فى السيرفر
query return no result it means the avatar is not added already in database
كود PHP:
USE SRO_VT_SHARD
GO
BEGIN
Declare @CodeName1 varchar(129)
Declare @CodeName2 varchar(129)
Declare @Type1 varchar(129)
Declare @Type int
Declare @Gender1 varchar(129)
Declare @Gender int
END
SET @CodeName1 = 'AVATAR_M_DRAGONDRESS' --- @Type = DRESS/ HAT/ ATTACH
SET @CodeName2= 'avatar_m_dragondress' --- @Gender = MALE/ FEMALE
SET @Type1 = 'DRESS'
SET @Gender1 = 'MALE'
/* Query for _RefObjCommon */
IF (@Type1 = 'HAT' OR @Type1 = 'DRESS' OR @Type1 = 'ATTACH')
IF (@Type1 = 'DRESS')
BEGIN
SET @Type = '3'
END
IF (@Type1 = 'HAT')
BEGIN
SET @Type = '1'
END
IF (@Type1 = 'ATTACH')
BEGIN
SET @Type = '2'
END
BEGIN
Declare @CodeName varchar(129) Set @CodeName = 'ITEM_MALL_' + @Codename1
Declare @SN varchar(74) SET @SN = 'SN_' +@CodeName
Declare @DESC varchar(74) SET @DESC = @SN + '_TT_DESC'
Declare @BSR1 varchar(129) SET @BSR1 = 'item\avatar\'+ @CodeName2 + '.bsr'
Declare @BSR2 varchar(129) SET @BSR2 = 'item\etc\drop_ch_eventbox.bsr'
Declare @DDJ varchar(74) SET @DDJ = 'Premium\Avatar\' + @CodeName2 + '.ddj'
Declare @ObjectName varchar(129) SET @ObjectName = '??? ?? (?)'
Declare @ObjectName1 varchar(129) SET @ObjectName1 = '[?,?,?,?,?,??]'
Declare @ObjectName2 varchar(129) SET @ObjectName2 = '[?,??]'
Declare @ObjectName3 varchar(129) SET @ObjectName3 = '[??,??]'
Declare @AssocFile varchar(129) SET @AssocFile = 'xxx'
Declare @Link int SET @Link = (SELECT MAX(Link)+1 FROM _RefObjCommon)
Declare @ID int SET @ID = (SELECT MAX(Link)+1 FROM _RefObjCommon)
END
BEGIN
INSERT INTO _RefObjCommon(Service,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,Canbuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link)
VALUES (1,@CodeName,@ObjectName,@AssocFile,@SN,@DESC,1,0,3,1,13,@Type,180000,3,0,0,1,1,159,1,1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,@BSR1,@BSR2,@DDJ,@AssocFile,@AssocFile,@Link)
END
/* Query for _RefObjItem */
IF (@Gender1 = 'MALE' OR @Gender1 = 'FEMALE')
IF (@Gender1 = 'MALE')
BEGIN
SET @Gender = '1'
END
IF (@Gender1 = 'FEMALE')
BEGIN
SET @Gender = '0'
END
IF (@Type1 = 'HAT' OR @Type1 = 'DRESS' OR @Type1 = 'ATTACH')
IF (@Type1 = 'DRESS')
BEGIN
INSERT INTO _RefObjItem(ID,MaxStack,ReqGender,ReqStr,ReqInt,ItemClass,SetID,Dur_L,Dur_U,PD_L,PD_U,PDInc,ER_L,ER_U,ERInc,PAR_L,PAR_U,PARInc,BR_L,BR_U,MD_L,MD_U,MDInc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDInt_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAttackMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAttackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAttackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMax_L,PAStrMax_U,MAInt_Min_L,MAInt_Min_U,MAInt_Max_L,MAInt_Max_U,HR_L,HR_U,HRInc,CHR_L,CHR_U,Param1,Desc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,Desc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7,Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param10,Desc10_128,Param11,Desc11_128,Param12,Desc12_128,Param13,Desc13_128,Param14,Desc14_128,Param15,Desc15_128,Param16,Desc16_128,Param17,Desc17_128,Param18,Desc18_128,Param19,Desc19_128,Param20,Desc20_128,MaxMagicOptCount,ChildItemCount,Link)
VALUES (@ID,1,@Gender,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,574,@ObjectName1,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,4,1,0)
END
IF (@Type1 = 'HAT')
BEGIN
INSERT INTO _RefObjItem(ID,MaxStack,ReqGender,ReqStr,ReqInt,ItemClass,SetID,Dur_L,Dur_U,PD_L,PD_U,PDInc,ER_L,ER_U,ERInc,PAR_L,PAR_U,PARInc,BR_L,BR_U,MD_L,MD_U,MDInc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDInt_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAttackMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAttackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAttackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMax_L,PAStrMax_U,MAInt_Min_L,MAInt_Min_U,MAInt_Max_L,MAInt_Max_U,HR_L,HR_U,HRInc,CHR_L,CHR_U,Param1,Desc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,Desc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7,Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param10,Desc10_128,Param11,Desc11_128,Param12,Desc12_128,Param13,Desc13_128,Param14,Desc14_128,Param15,Desc15_128,Param16,Desc16_128,Param17,Desc17_128,Param18,Desc18_128,Param19,Desc19_128,Param20,Desc20_128,MaxMagicOptCount,ChildItemCount,Link)
VALUES (@ID,1,@Gender,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,513,@ObjectName2,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,2,0,0)
END
IF (@Type1 = 'ATTACH')
BEGIN
INSERT INTO _RefObjItem(ID,MaxStack,ReqGender,ReqStr,ReqInt,ItemClass,SetID,Dur_L,Dur_U,PD_L,PD_U,PDInc,ER_L,ER_U,ERInc,PAR_L,PAR_U,PARInc,BR_L,BR_U,MD_L,MD_U,MDInc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDInt_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAttackMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAttackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAttackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMax_L,PAStrMax_U,MAInt_Min_L,MAInt_Min_U,MAInt_Max_L,MAInt_Max_U,HR_L,HR_U,HRInc,CHR_L,CHR_U,Param1,Desc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,Desc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7,Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param10,Desc10_128,Param11,Desc11_128,Param12,Desc12_128,Param13,Desc13_128,Param14,Desc14_128,Param15,Desc15_128,Param16,Desc16_128,Param17,Desc17_128,Param18,Desc18_128,Param19,Desc19_128,Param20,Desc20_128,MaxMagicOptCount,ChildItemCount,Link)
VALUES (@ID,1,@Gender,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,1280,@ObjectName3,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,1,0,0)
END
print ''
print 'The query executed successfully.'
print ''
print ' Query made By H34D.B4NG3R.'
[COLOR="rgb(220, 20, 60)"]Now add the avatar item mall
[/COLOR]
كود PHP:
USE SRO_VT_SHARD_INIT
GO
Declare @CodeName varchar (74)
Declare @yourPrice int
Declare @WhichTAB varchar(74)
SET @CodeName = 'ITEM_MALL_AVATAR_W_BLUE_SOULKNIGHT_ATTACH' /* The Spawncode of the item you want to add */
SET @yourPrice = 130 /* Silkprice */
SET @WhichTAB = 'MALL_AVATAR_ATTACH' /* To which Tab of the Item Mall do you want to add the Item*/
Declare @Data varchar(15) SET @Data = '0' /*Leave '0' as long as you're adding Avatars - otherwise Quantity of Item*/
IF exists(SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = @CodeName)
BEGIN
/*Only Avatar Tabs possible at the moment*/IF (@WhichTAB = 'MALL_AVATAR_ATTACH' OR @WhichTAB = 'MALL_AVATAR_DRESS' OR @WhichTAB = 'MALL_AVATAR_HAT') /*To make sure that the Tab is correct (in order to missspellings)*/
BEGIN
/* Codename instead of the ID */
Declare @ItemID int SET @ItemID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @CodeName)
/* Which Itemdata.txt is affected in the Media.pk2*/
Declare @newItemID varchar(5)
IF (@ItemID < 5000) SET @newItemID = 5000
else if (@ItemID < 10000) SET @newItemID = 10000
else if (@ItemID < 15000) SET @newItemID = 15000
else if (@ItemID < 20000) SET @newItemID = 20000
else if (@ItemID < 25000) SET @newItemID = 25000
else if (@ItemID < 30000) SET @newItemID = 30000
else if (@ItemID < 35000) SET @newItemID = 35000
else if (@ItemID < 40000) SET @newItemID = 40000
else SET @newItemID = 45000
print ''
print @CodeName + ' from Media\server_dep\silkroad\textdata\itemdata_'+@newItemID+'.txt'
print ''
/*END which Itemdata.txt*/
/* for _RefPackageItem */
IF EXISTS (SELECT CodeName128 FROM _RefPackageItem WHERE CodeName128 = 'Package_'+@CodeName)
BEGIN
Declare @SN1 varchar(74) SET @SN1 = (SELECT NameStrID FROM _RefPackageItem WHERE CodeName128 = 'PACKAGE_'+@CodeName)
Declare @DESC1 varchar(74) SET @Desc1 = (SELECT DescStrID FROM _RefPackageItem WHERE CodeName128 = 'PACKAGE_'+@CodeName)
Declare @DDJ1 varchar(74) SET @DDJ1 = (SELECT AssocFileIcon FROM _RefPackageItem WHERE CodeName128 = 'PACKAGE_'+@CodeName)
Declare @TOPID1 varchar (10) SET @TOPID1 = (SELECT ID FROM _RefPackageItem WHERE CodeName128 = 'PACKAGE_'+@CodeName)
print '##Check the following lines @ refpackageitem.txt!'
print '1 15 '+@TOPID1+' PACKAGE_'+@CodeName+' 0 EXPAND_TERM_ALL '+@SN1+' '+@DESC1+' '+@DDJ1+' -1 xxx -1 xxx -1 xxx -1 xxx'
print ''
END
ELSE BEGIN
Declare @SN varchar(74) SET @SN = (SELECT NameStrID128 FROM _RefObjCommon WHERE ID = @ItemID)
Declare @DESC varchar(74) SET @Desc = (SELECT DescStrID128 FROM _RefObjCommon WHERE ID = @ItemID)
Declare @DDJ varchar(74) SET @DDJ = (SELECT AssocFileIcon128 FROM _RefObjCommon WHERE ID = @ItemID)
INSERT INTO _RefPackageItem (Service,Country,CodeName128,SaleTag,ExpandTerm,NameStrID,DescStrID,AssocFileIcon,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,0,'EXPAND_TERM_ALL',@SN,@Desc,@DDJ,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
Declare @TOPID varchar (10) SET @TOPID = (SELECT MAX(ID) FROM _RefPackageItem)
print ''
print 'Add the following line @ refpackageitem.txt'
print '1 15 '+@TOPID+' PACKAGE_'+@CodeName+' 0 EXPAND_TERM_ALL '+@SN+' '+@DESC+' '+@DDJ+' -1 xxx -1 xxx -1 xxx -1 xxx'
print ''
END
/* for _RefPricePolicyOfItem */
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName)
BEGIN
print '##Check the following lines @ RefPricePolicyOfItem.txt!'
Declare @NEWPRICE1 varchar(15) SET @NEWPRICE1 = (SELECT Cost FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND PaymentDevice = 2)
print '1 15 PACKAGE_'+@CodeName+' 2 0 '+@NEWPRICE1+' -1 xxx -1 xxx -1 xxx -1 xxx'
print '1 15 PACKAGE_'+@CodeName+' 4 0 0 -1 xxx -1 xxx -1 xxx -1 xxx'
print '1 15 PACKAGE_'+@CodeName+' 16 0 0 -1 xxx -1 xxx -1 xxx -1 xxx'
print ''
END
ELSE BEGIN
INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDevice,PreviousCost,Cost,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,2,0,@yourPrice,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDevice,PreviousCost,Cost,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,4,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDevice,PreviousCost,Cost,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,16,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
Declare @NEWPRICE varchar(15) SET @NEWPRICE = @yourPrice
print ''
print 'Add the following lines @ refpricepolicyofitem.txt'
print '1 15 PACKAGE_'+@CodeName+' 2 0 '+@NEWPRICE+' -1 xxx -1 xxx -1 xxx -1 xxx'
print '1 15 PACKAGE_'+@CodeName+' 4 0 0 -1 xxx -1 xxx -1 xxx -1 xxx'
print '1 15 PACKAGE_'+@CodeName+' 16 0 0 -1 xxx -1 xxx -1 xxx -1 xxx'
print ''
END
/* for _RefShopGoods */
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefShopGoods WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND RefTabCodeName = @WhichTAB)
BEGIN
print '##Check the following lines @ RefShopGoods.txt!'
Declare @WhichTAB1 varchar(74) SET @WhichTAB1 = (SELECT RefTabCodeName FROM _RefShopGoods WHERE RefPackageItemCodeName = 'PACKAGE_'+@CodeName)
Declare @newSLOTINDEX1 varchar(15) SET @newSLOTINDEX1 = (SELECT SlotIndex FROM _RefShopGoods WHERE RefPackageItemCodeName = 'PACKAGE_'+@CodeName AND RefTabCodeName = @WhichTAB1)
print '1 15 '+@WhichTAB1+' '+'PACKAGE_'+@CodeName+' '+@newSLOTINDEX1+' -1 xxx -1 xxx -1 xxx -1 xxx'
print ''
END
ELSE BEGIN
Declare @newSLOTINDEX varchar(15) SET @newSLOTINDEX = (SELECT MAX(SlotIndex) FROM _RefShopGoods WHERE RefTabCodeName = @WhichTAB)+1
INSERT INTO _RefShopGoods (Service,Country,RefTabCodeName,RefPackageItemCodeName,SlotIndex,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15,@WhichTAB,'PACKAGE_'+@CodeName,@newSLOTINDEX,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
print ''
print 'Add the following line @ refshopgoods.txt'
print '1 15 '+@WhichTAB+' '+'PACKAGE_'+@CodeName+' '+@newSLOTINDEX+' -1 xxx -1 xxx -1 xxx -1 xxx'
print ''
END
/* for _RefScrapOfPackageItem */
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND RefItemCodeName = @CodeName)
BEGIN
print '##Check the following lines @ RefScrapOfPackageItem.txt!'
Declare @ScrapIndex1 varchar(15)
SET @ScrapIndex1 = (SELECT [Index] FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName)
Declare @Data1 varchar(15) SET @Data1 = (SELECT Data FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName)
print '1 15 '+'PACKAGE_'+@CodeName+' '+@CodeName+' 0 0 '+@Data1+' 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx '+@ScrapIndex1
print ''
END
ELSE BEGIN
INSERT INTO _RefScrapOfPackageItem (Service,Country,RefPackageItemCodeName,RefItemCodeName,OptLevel,Variance,Data,MagParamNum,MagParam1,MagParam2,MagParam3,MagParam4,MagParam5,MagParam6,MagParam7,MagParam8,MagParam9,MagParam10,MagParam11,MagParam12,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,@CodeName,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
Declare @ScrapIndex varchar(15)
SET @ScrapIndex = (SELECT [Index] FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName)
print ''
print 'Add the following line @ refscrapofpackageitem.txt'
print '1 15 '+'PACKAGE_'+@CodeName+' '+@CodeName+' 0 0 '+@Data+' 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx '+@ScrapIndex
print ''
END
print ''
print ''
print 'Done!'
END
ELSE BEGIN
print 'The @WhichTAB value is incorrect!'
END
END
else begin
print '@CodeName value does not exist.'
http://www2.0zz0.com/2013/08/23/00/973187606.gif
64 -
Make Max Plus In server
عاوز الماكس بلص هتروح على
SRO_VT_SHARD>Stored Porocedures>System Stored Porocedures>_ADD_ITEM_EXTERN
بعد كدا دور على Optlevl وحوط الماكس بلص
http://www2.0zz0.com/2013/08/23/00/973187606.gif
65 -
;كيفيه عمل npc واضافه ايتم وتاب
HERE
HERE
HERE
HERE
HERE
ده شرح فيديو
HERE
HERE
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
66 -
Add New NPC Script
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
67 -
عاوز تعمل درب موبس اعمل الكويرى دا
كود PHP:
USE SRO_VT_SHARD -----> ( Komnda ) <-----
GO
DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real
SET @MonsterID = 3810 <-------- Mob,Unique ID you want Add Drop in
SET @DropRatio = 1 <-------- Drop Ration 1=100% , 0.5 = 50%
SET @ItemID = 24165 <-------- ITEM ID You want Add in Drop
INSERT _RefMonster_AssignedItemDrop
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6,
RefMagicOptionID7,
CustomValue7,
RefMagicOptionID8,
CustomValue8,
RefMagicOptionID9,
CustomValue9,
RentCodeName
)
VALUES(@MonsterID , @ItemID, 0, 0, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')
دا عشان تجيب id الموبس
كود PHP:
Use Sro_vt_shard select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC'
دا عشان تجيب id الايتم
كود PHP:
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_CH_TBLADE_11_SET_A_RARE'
http://www2.0zz0.com/2013/08/23/00/973187606.gif
68 -
عاوز لما تخرج من جيلد تعمل تيلبورت تتدخل جيلد تانى حط الكيرى دى هنا
SRO_VT_SHARD>Programmability>stored Preocedures>system stored Preocedures>_AddTimedJob
تشيل الى فيها وتحط دى
كود PHP:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 06/14/2014 19:29:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
--##If you want to only have one not both, then just modify the line below!
if (@JobID = 1 or @JobID = 2)
BEGIN
return -1
END
ELSE
BEGIN
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
return @NewJobID
وتعمل Execuite
http://www2.0zz0.com/2013/08/23/00/973187606.gif
69 -
حـــصـــريا على Silkraod4arab تعديل Data.Pk2 لتغير لون او رسم اى شئ فى Silkraod بنفسك
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
70 -
۩۞۩ حصـــــــ ـ ـرياّ .. غير لــــون سلاحك فى اقل من دقيقتين ۩۞۩
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
71 -
<< حصريا ازاي تعمل نظام شحن سيلك عن طريق الكروت في الموقع بتاعك >>
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
72 -
برنامج Scan Files
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
73 -
.. How To Delete SKill ..
عاوز تشيل اى اسكيل روح على SRO_VT_SHARD RefSkil
دور على الاسكيل الى عاوز تقفلها واعمل Service 0
او اعمل الكويرى دا
كود PHP:
use SRO_VT_SHARD
update _RefSkill
set Service = '0'
where Basic_Code = 'CODE SKILL HNA'
http://www2.0zz0.com/2013/08/23/00/973187606.gif
74 -
[COLOR="rgb(102, 205, 170)"]Honor Buff Fix Bug SQL
[/COLOR]
كود PHP:
USE [SRO_VT_SHARD]
DECLARE @CharName Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @CharName = '[GM] SaD_BirD'
SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName)
SET @CampID = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID)
SET @Graduates = '1234'
SET @HonorPoints= @Graduates * 39
--------------------
UPDATE [Dbo].[_TrainingCamp]
SET GraduateCount = @Graduates
WHERE [Dbo].[_TrainingCamp].[ID] = @CampID
UPDATE [dbo].[_TrainingCampMember]
SET HonorPoint = @HonorPoints
WHERE [dbo].[_TrainingCampMember].[CampID]=@CampID
http://www2.0zz0.com/2013/08/23/00/973187606.gif
75 -
[COLOR="rgb(102, 205, 170)"]ازاي اخلي الريس Res. لي ليفل 125 مثلا او 130 ؟
[/COLOR]
كود PHP:
UPDATE _RefSkill
set Param10=130
where Basic_Code='SKILL_EU_CLERIC_REBIRTHA_SPECIAL_B_02'
set param10 = 130
130 ده اللفل
غير الكود طبعا لكود ال سكيل مثلا الكود الفوق ده
black res
http://www2.0zz0.com/2013/08/23/00/973187606.gif
76 -
ازاى اخلى الايتم ميتعملهاش TRADE او EXCHANGE ..
-SRO_VT_SHARD / TABLES / RefObjCommon
CanTrade = 1
1 يعنى تتحط و0 يعنى لا :751:
http://www2.0zz0.com/2013/08/23/00/973187606.gif
77 -
10 Original Grap Pets
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
78 -
How To Protect Your Server From Ddos
HERE
تم تجديد الروابط
KiwiGuard Full Crack
HERE
Simple FW
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
79 -
برنامجAvatar Add
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
80 -
♥♥♥ الى عاوز يخلى اى حد يموت اليونكات ياخد silk ♥♥♥
[/COLOR] HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
81 -
الموضوع الاول عن اضافه الابديت العربى الجديد ***
[/COLOR] HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
82 -
New Viking & Hallowen & Red Devil & Blue Soul Knight Work 100%
[/COLOR] HERE
وديه صور ليهم
[/COLOR] HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
83 -
New Program Mobs Editor
[/COLOR] HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
84 -
New Unique
[/COLOR] HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
85 -
سيلك .. بالساعه
[/COLOR] HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
86 -
Scroll To remove adv From Any Item .
[/COLOR] HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
87 -
[Guide] [vSRO] How to Fix Attack / Pick Pet Bug
[/COLOR] HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
88 -
Blue Devil Scroll Procedure
[/COLOR] HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
89 -
gm logo شغال 100%
[/COLOR] HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
90 -
برامج لمساعده gm
[/COLOR] HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
91 -
برنامج Query Fast Get v1.0.04
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
92 -
♥♫█►►how to add new speed Drug Of Typoon 600%♥♫█►►
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
93 -
Crystal elixers
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
94 -
كام افتار New
HERE
HERE
HERE
HERE
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
95 -
عودة JanGanSRO ~~ Unique Killer like rev6 & Unique Killer Rank
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
96 -
اتحكم فى db من غير دخول ال vps
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
97 -
كيفيـــة عمـــــل أبديـــــت
HERE
بعد ما تخلص الابديت هيجيلك ايرور لان فى خطوه لسا لازم تعملها وهيا موجوه فى الموضوع ده
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
98 -
How to Active Or Disable SafeZone
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
99 -
█ ₪ ҉ حصريـــا : Magic-pop 12 , 13Degree ҉ ₪ █
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
100 -
حصريا علي سلك رود Fulll NPC ARABIA
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
101 -
۩(●̮●)۩ How To Change Start Hawan Level To ۩(●̮●)۩
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
102 -
Realese Auto Plus Notic
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
103 -
حصريا : ازاي تأمن الـ Account database بتاعتك لو اتسرقت
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
104 -
Query For FTW Gold
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
105 -
شرح اهم الخيارات فى smc
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
106 -
New Vote4Silk system
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
107 -
الان علي s4a برنامج الحمايه <<AntiDDoSGuardian>>
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
108 -
زود عدد الموبس فى سيرفرك
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
109 -
Fixed GameServer register gold
استخدم الكويرى ده
كود PHP:
Use FEAR_VT_SHARD
--Query By Yui
INSERT INTO _RefPricepolicyofitem
(Service,Country,RefPackageItemCodeName,PaymentDevice
,PreviousCost,Cost,Param1,
Param1_Desc128,Param2,Param2_Desc128
,Param3,Param3_Desc128,Param4,Param4_Desc128)
VALUES
(1,15,'item code here',1,0,1,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
http://www2.0zz0.com/2013/08/23/00/973187606.gif
110 -
شرح اضافة مستخدم جديد في الـ SQL (غير sa)
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
111 -
Change SQL password by Query too Easy
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
112 -
>>>>>Relocation of Space Transportation<<<<<
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
113 -
طريقة اضافة افاتار بالتفصيل المممممممممممل
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
114 -
v-Sro Happy Event Fixed %100 Work
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
115 -
Halloween event
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
116 -
شغل 2 shard in your Server
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
117 -
كيفية منع كلمات غير ممنوعة مثل الشتايم و اسماء ال GM
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
118 -
◄◄█♫♥حصريا ملفات Taiwan-SRO باخر تعديلات سيلكرود♥♫█►►
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
119 -
برنامج Point Unique Reward
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
120 -
Shop Code Maker v1.3
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
_______________________________________
[COLOR="rgb(0, 255, 255)"] 1- بعض WebSite Files
[/COLOR]
[COLOR="rgb(0, 255, 255)"]1-myth Online Website
[/COLOR]
HERE
[COLOR="rgb(0, 255, 255)"]2- Project-X Website
[/COLOR]
HERE
[COLOR="rgb(0, 255, 255)"]3- blackRose Gaming Web Site
[/COLOR]
HERE
[COLOR="rgb(0, 255, 255)"]4- Silkroad Castle web site
[/COLOR]
HERE
[COLOR="rgb(0, 255, 255)"]5- website Christmas
[/COLOR]
HERE
[COLOR="rgb(0, 255, 255)"]6- ludoworks web site
[/COLOR]
HERE
[COLOR="rgb(0, 255, 255)"]7-Panic Sro WebSite
[/COLOR]
HERE
[COLOR="rgb(0, 255, 255)"]8- Silkroad Online Web 2008
[/COLOR]
HERE
[COLOR="rgb(0, 255, 255)"]9- immortaltion Sro WebSite
[/COLOR]
HERE
[COLOR="rgb(0, 255, 255)"]10 - Epic Website
[/COLOR]
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
2- بعض Db>s
- 1 - Phoenix Sro
HERE
- 2 - Sality
HERE
- 3- My Self edit Dresses and Nation Online DB [Release]
HERE
=- 4 - Mirror-Sro
كود PHP:
Info :
Cap 250
PVP
Free Silk
Cont FTW working 100%
this DB = DB evolution after noop edit
HERE
- 5- Thuder Road
HERE
- 6 - Database Troy Sro D14 Pvp
HERE
- 7 - Gold road
HERE
- 8 - DB Arabin Road D10
HERE
- 9 - DB D16 Good Edits
HERE
- 10 - Db Raw Sro
HERE
- 11 - Db Cap 80 Good Edits
HERE
- 12 - DB Gngwc Sro
HERE
- 13 - Db Glory NetWork
HERE
- 14 - Thuder Road
HERE
- 15 - Vogueun limited
HERE
- 16 - You Road
HERE
17 -SanTiAGOSro
HERE
18- Db Blue Sro
HERE
19 - Legend Data Base All News , No Bugs, D13,D14
HERE
20 - Ultra-Sro
HERE
21 - ImmortalitySro
HERE
22 - Desert RoaD SHARD
HERE
Massive Sro
soon
http://www2.0zz0.com/2013/08/23/00/973187606.gif
3- بعض Full Client
1- Arabin Road
Soon
2- Mirror - sRO
HERE
3- peclawz
HERE
4- Client Jae
HERE
5- SANTiAGO
HERE
6- R_Friends_Gaming_Net
HERE
7- Blue_Sro
HERE
8- client dg 13
HERE
9 - Legend Data Base All News , No Bugs
HERE
10 - Ultra-Sro
HERE
11 - Ezma
HERE
12 - Client PokaSro
HERE
13= client desert-road
client
14 - Client Massive Sro
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
4- Sql + برامج السيرفر
Here
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
_____________________________++___________________ __________
كل معلومات عن جيلد فى Sql
▐♥ حصريا Some Information About Guild At SQL ♥ ▐
HERE
http://www2.0zz0.com/2013/08/23/00/973187606.gif
http://img43.imageshack.us/img43/4544/srw.gif
http://img43.imageshack.us/img43/465/l66.gif
لو جنانـ انكـ تعملـ سيرفر ويقبلكــ مشاكلـ -- اتجننـــ !ّ!
متجدد باستمرار
تـم الـتنسيق .
|