Dg Add [الأرشيف] - الموقع العربي الاول للعبة Silkroad Online

loaymoataz123

28-03-2017, 12:32 AM

دلوقتي انا شغال علي vsro dg 11 و كنت عاوز اضيف dg 12 مثلا
ازاي اخد الملفات من client تاني و احطها ف client vsro
و ازاي اعدل علي ال داتا وكل حاجه تتعلق ب ال dg اللي هضيفه

لو سمحتوا عاوز شرح كامل لاضافه اي Dg

ويريت لو ترفعولي الملفات الي اضيفها

جزاكم الله خير

pop2009

28-03-2017, 04:54 AM

ديه كويري هتساعدك انك تفتح ال Items D12 & D13 في داتا بيز
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH%'

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 8994 AND 9005

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9008 AND 9025

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9028 AND 9045

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9048 AND 9065

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9068 AND 9085

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9088 AND 9105

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9114 AND 9125

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9134 AND 9145

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9154 AND 9225

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID = 38620

loaymoataz123

28-03-2017, 05:24 AM

تمام طيب الملفات بقي اللي هحطها ف ال media وdatabase

وطريقه بعد ازنك

Dev.Klito

28-03-2017, 10:29 AM

ديه كويري هتساعدك انك تفتح ال Items D12 & D13 في داتا بيز
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH%'

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 8994 AND 9005

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9008 AND 9025

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9028 AND 9045

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9048 AND 9065

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9068 AND 9085

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9088 AND 9105

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9114 AND 9125

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9134 AND 9145

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9154 AND 9225

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID = 38620

تمام طيب الملفات بقي اللي هحطها ف ال media وdatabase

وطريقه بعد ازنك

استخدم الــ query اللى فوق دى هتظبط الداتا و البرنامج دا هيجبلك سطور كل حاجة للمديا

https://mega.nz/#!SF8wDCYA!NjawmNo0mw5KstBwekfQVSxKM1OIfCXN1KljFuk pwfk

يغلق بسبب وجود موضوع اخر غير مجاب ...

##