المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : All FGW Problems Fixs-----#Ri3o


Dev.Ri3o
29-04-2016, 09:17 AM
http://www4.0zz0.com/2015/11/27/18/243536469.gif (https://www.0zz0.com)

http://www4.0zz0.com/2015/11/27/18/884808031.gif (https://www.0zz0.com)

http://www4.0zz0.com/2015/11/27/18/702514124.gif (https://www.0zz0.com)

اصلاح مشاكل ال FGW فى ثوانى

http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)

Fix Envy


USE [SRO_VT_SHARD]
GO
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41540'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41550'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41560'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41570'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41580'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41590'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42460'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42470'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42480'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42490'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42500'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42510'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42520'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42530'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43420'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43430'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43440'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43450'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43460'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43470'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43480'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43490'


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)

Fix Boss Uniques


USE [SRO_VT_SHARD]
GO
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43580'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43590'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43600'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43610'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43620'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43630'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43640'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43650'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43660'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43670'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43680'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43690'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43700'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43710'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43720'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43730'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43740'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43750'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43760'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43770'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43780'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43790'


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)

Fix Treasure Box


USE [SRO_VT_SHARD]
GO
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41600'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41610'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41620'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41630'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41640'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '41650'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42540'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42550'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42560'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42570'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42580'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42590'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42600'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '42610'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43500'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43510'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43520'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43530'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43540'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43550'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43560'
UPDATE Tab_RefNest SET dwMaxTotalCount = 1 WHERE dwTacticsID LIKE '43570'


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)

Fix DC On FGW

https://www.sendspace.com/file/lmc34y

http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)

http://www4.0zz0.com/2015/11/27/18/735351340.gif (https://www.0zz0.com)

Hamza FiGo
29-04-2016, 03:44 PM
تم شكرا

تم تعديل اسم الموضوع من proplems لــ problems.

elbattawy1st
29-04-2016, 04:09 PM
تسلم ^_^

Dev.LumiusCux
29-04-2016, 04:31 PM
تسلم ^^

Dev.BigBear
29-04-2016, 05:13 PM
عاش :thumbsup:

ruxana
17-08-2016, 09:31 PM
re upload link please

Mostafa Mosaad
18-08-2016, 03:44 AM
برنس :soccer_h4h:

roske
24-10-2016, 10:55 AM
http://www4.0zz0.com/2015/11/27/18/243536469.gif (https://www.0zz0.com)


http://www4.0zz0.com/2015/11/27/18/884808031.gif (https://www.0zz0.com)


http://www4.0zz0.com/2015/11/27/18/702514124.gif (https://www.0zz0.com)
حل لجميع مشاكل ال FGW
فى ناس كتير سألتنى عن حلول مشاكل ال FGW
...


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)



Fix Envy
http://www3.0zz0.com/2016/01/07/19/710085124.gif (https://www.sendspace.com/file/l6szo5)


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)

Fix Boss Uniques
http://www3.0zz0.com/2016/01/07/19/710085124.gif (https://www.sendspace.com/file/w9s5ao)


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)



Fix DC Proplem
http://www3.0zz0.com/2016/01/07/19/710085124.gif (https://www.sendspace.com/file/uukk1l)


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)

Fix Treasure Box
http://www3.0zz0.com/2016/01/07/19/710085124.gif (https://www.sendspace.com/file/mzqppk)


الQuery بيصلح كل الForgotten World (يعنى الTogui ب الFlame .. بكل حاجة تخصهم


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)


http://www4.0zz0.com/2015/11/27/18/735351340.gif (https://www.0zz0.com)





حضرتك انا عندي في السرفر كل حاجه تمام بس اليونك مش بتظهر وعملت الكويري ومش راضيا ايه الحل ؟

ابو ليلى
24-10-2016, 11:00 PM
الله ينور يا معلم تسلم ايدك

roske
04-11-2016, 05:58 AM
http://www4.0zz0.com/2015/11/27/18/243536469.gif (https://www.0zz0.com)


http://www4.0zz0.com/2015/11/27/18/884808031.gif (https://www.0zz0.com)


http://www4.0zz0.com/2015/11/27/18/702514124.gif (https://www.0zz0.com)
حل لجميع مشاكل ال FGW
فى ناس كتير سألتنى عن حلول مشاكل ال FGW
...


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)



Fix Envy
http://www3.0zz0.com/2016/01/07/19/710085124.gif (https://www.sendspace.com/file/l6szo5)


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)

Fix Boss Uniques
http://www3.0zz0.com/2016/01/07/19/710085124.gif (https://www.sendspace.com/file/w9s5ao)


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)



Fix DC Proplem
http://www3.0zz0.com/2016/01/07/19/710085124.gif (https://www.sendspace.com/file/uukk1l)


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)

Fix Treasure Box
http://www3.0zz0.com/2016/01/07/19/710085124.gif (https://www.sendspace.com/file/mzqppk)


الQuery بيصلح كل الForgotten World (يعنى الTogui ب الFlame .. بكل حاجة تخصهم


http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)


http://www4.0zz0.com/2015/11/27/18/735351340.gif (https://www.0zz0.com)




حضرتك انا عندي FGW مش بينزل الموبس في المكان ده ممكن حل ؟

http://www14.0zz0.com/2016/11/04/05/616297043.jpg

Dev.Ri3o
04-11-2016, 11:19 AM
لا ال FGW مش بينززل Mobs اصلا انت كدأ تتأكد من ال Triggers اللى فى ال SRO_VT_SHARD و ال TabRefNest و ال TabRefTactics و ال TabRefHive تاخد سطور ال Mobs نفسها من Database EVO
هو كدة ال Spot مش موجود اصلا

roske
04-11-2016, 07:13 PM
هيا كانت شغاله عندي عادي ومفهاش حاجه بس لعبت في TabRefNest
ايه رايك اخد باك اب وحط
1-TabRefNest
2-Triggers
3-TabRefTactics
4-TabRefHive

ولا انتا شايف ايه ؟

Dev.Ri3o
05-11-2016, 04:23 PM
هيا كانت شغاله عندي عادي ومفهاش حاجه بس لعبت في TabRefNest
ايه رايك اخد باك اب وحط
1-TabRefNest
2-Triggers
3-TabRefTactics
4-TabRefHive

ولا انتا شايف ايه ؟

زى ما انت قولت انك لعبت فى ال TabRefNest يعنى عملت مشكلة فى ال Spot انا هقولك على حل بس تركز معايا
انت تشوف ال Database اللى انت شغال عليها قبل ما تعدب فى ال TabRefNest وتاخدو منها وتحطو عندك ولو انت
ضيفت NPC او اى حاجة ليها Spot خد ال TabRefNest بتاع ال Database للى انت شغال عليها قبل ما تعدل فى ال TabRefNest وحطو Past بدل اللى عندك او تعمل Restore لل Database كلها ولو ضفت حاجة ضيفها من الاول تانى ومتقربش تانى لل TabRefNest

roske
05-11-2016, 05:19 PM
زى ما انت قولت انك لعبت فى ال TabRefNest يعنى عملت مشكلة فى ال Spot انا هقولك على حل بس تركز معايا
انت تشوف ال Database اللى انت شغال عليها قبل ما تعدب فى ال TabRefNest وتاخدو منها وتحطو عندك ولو انت
ضيفت NPC او اى حاجة ليها Spot خد ال TabRefNest بتاع ال Database للى انت شغال عليها قبل ما تعدل فى ال TabRefNest وحطو Past بدل اللى عندك او تعمل Restore لل Database كلها ولو ضفت حاجة ضيفها من الاول تانى ومتقربش تانى لل TabRefNest

هوا انا كل اللي عملتو من كام يوم زوت عدد الموبز فطريت ارجعها تاني كونت واخد
TabRefNest Copy

ولما مسحتهم حطيتهم past وال ID اتغير بتاعهم

Dev.Ri3o
05-11-2016, 05:33 PM
ما هو عشان كدة حصل مشكلة فى ال Spot ال FGW Mobs احسن حل انك تشيل ال TabRefNest اللى عندك

USE [SRO_VT_SHARD]
GO
truncate table Tab_RefNest


وبعد كدة تعمل Restore لل Database القديمة اللى انت معدلتش فيها بأسم تانى وتاخد منها ال TabRefNest اللى Spot ال FGW مظبوطين فى
وتاخدو Copy وتحطو مكان ال TabRefNest اللى انت مسحتو
او تعمل Restore لل Database كلها احسن

roske
06-11-2016, 06:41 AM
اشطه

roske
06-11-2016, 08:54 AM
تمام اتعملت بس مش بينزا Envy
عملت الكويري ال 3 اللي فوق اشتغلت تمام بس اليونكات مش بتنزل

Dev.Ri3o
06-11-2016, 08:25 PM
ال Queries دى بتصلح Spot ال Uniqes لو هى مضافة عندك فى ال TabRefNest و ال TabRefTactisc و ال TabRefHive او يا اما انت مش بتقتل كل ال Mobs فى ال FGW عشان كدة ال Boss Uniqes مش بتظهر اتاكد كويس

roske
07-11-2016, 02:25 AM
انا بخلصها كلها بس مش بتنزل اليونك اللي بينزل بعد Envy