الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=289)
-   -   All FGW Problems Fixs-----#Ri3o (https://silkroad4arab.com/vb/showthread.php?t=601388)

Dev.Ri3o 29-04-2016 09:17 AM

All FGW Problems Fixs-----#Ri3o
 
http://www4.0zz0.com/2015/11/27/18/243536469.gif

http://www4.0zz0.com/2015/11/27/18/884808031.gif

http://www4.0zz0.com/2015/11/27/18/702514124.gif

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

http://www4.0zz0.com/2015/11/27/18/171651594.gif

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

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

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

Fix DC On FGW

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

http://www4.0zz0.com/2015/11/27/18/171651594.gif

http://www4.0zz0.com/2015/11/27/18/735351340.gif


Hamza FiGo 29-04-2016 03:44 PM

رد: All FGW Proplems Fix-----#Ri3o
 
تم شكرا

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

elbattawy1st 29-04-2016 04:09 PM

رد: All FGW Problems Fixs-----#Ri3o
 
تسلم ^_^

Dev.LumiusCux 29-04-2016 04:31 PM

رد: All FGW Problems Fixs-----#Ri3o
 
تسلم ^^

Dev.BigBear 29-04-2016 05:13 PM

رد: All FGW Problems Fixs-----#Ri3o
 
عاش :thumbsup:

ruxana 17-08-2016 09:31 PM

رد: All FGW Problems Fixs-----#Ri3o
 
re upload link please

Mostafa Mosaad 18-08-2016 03:44 AM

رد: All FGW Problems Fixs-----#Ri3o
 
برنس :soccer_h4h:

roske 24-10-2016 10:55 AM

رد: All FGW Problems Fixs-----#Ri3o
 
اقتباس:

المشاركة الأصلية كتبت بواسطة ameral (المشاركة 5265514)
http://www4.0zz0.com/2015/11/27/18/243536469.gif


http://www4.0zz0.com/2015/11/27/18/884808031.gif


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


http://www4.0zz0.com/2015/11/27/18/171651594.gif



Fix Envy
http://www3.0zz0.com/2016/01/07/19/710085124.gif


http://www4.0zz0.com/2015/11/27/18/171651594.gif

Fix Boss Uniques
http://www3.0zz0.com/2016/01/07/19/710085124.gif


http://www4.0zz0.com/2015/11/27/18/171651594.gif



Fix DC Proplem
http://www3.0zz0.com/2016/01/07/19/710085124.gif


http://www4.0zz0.com/2015/11/27/18/171651594.gif

Fix Treasure Box
http://www3.0zz0.com/2016/01/07/19/710085124.gif


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


http://www4.0zz0.com/2015/11/27/18/171651594.gif


http://www4.0zz0.com/2015/11/27/18/735351340.gif




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

ابو ليلى 24-10-2016 11:00 PM

رد: All FGW Problems Fixs-----#Ri3o
 
  • الله ينور يا معلم تسلم ايدك

roske 04-11-2016 05:58 AM

رد: All FGW Problems Fixs-----#Ri3o
 
اقتباس:

المشاركة الأصلية كتبت بواسطة ameral (المشاركة 5265514)
http://www4.0zz0.com/2015/11/27/18/243536469.gif


http://www4.0zz0.com/2015/11/27/18/884808031.gif


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


http://www4.0zz0.com/2015/11/27/18/171651594.gif



Fix Envy
http://www3.0zz0.com/2016/01/07/19/710085124.gif


http://www4.0zz0.com/2015/11/27/18/171651594.gif

Fix Boss Uniques
http://www3.0zz0.com/2016/01/07/19/710085124.gif


http://www4.0zz0.com/2015/11/27/18/171651594.gif



Fix DC Proplem
http://www3.0zz0.com/2016/01/07/19/710085124.gif


http://www4.0zz0.com/2015/11/27/18/171651594.gif

Fix Treasure Box
http://www3.0zz0.com/2016/01/07/19/710085124.gif


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


http://www4.0zz0.com/2015/11/27/18/171651594.gif


http://www4.0zz0.com/2015/11/27/18/735351340.gif




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

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

Dev.Ri3o 04-11-2016 11:19 AM

رد: All FGW Problems Fixs-----#Ri3o
 
لا ال FGW مش بينززل Mobs اصلا انت كدأ تتأكد من ال Triggers اللى فى ال SRO_VT_SHARD و ال TabRefNest و ال TabRefTactics و ال TabRefHive تاخد سطور ال Mobs نفسها من Database EVO
هو كدة ال Spot مش موجود اصلا

roske 04-11-2016 07:13 PM

رد: All FGW Problems Fixs-----#Ri3o
 
هيا كانت شغاله عندي عادي ومفهاش حاجه بس لعبت في TabRefNest
ايه رايك اخد باك اب وحط
1-TabRefNest
2-Triggers
3-TabRefTactics
4-TabRefHive

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

Dev.Ri3o 05-11-2016 04:23 PM

رد: All FGW Problems Fixs-----#Ri3o
 
اقتباس:

المشاركة الأصلية كتبت بواسطة roske (المشاركة 5283253)
هيا كانت شغاله عندي عادي ومفهاش حاجه بس لعبت في 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

رد: All FGW Problems Fixs-----#Ri3o
 
اقتباس:

المشاركة الأصلية كتبت بواسطة ameral (المشاركة 5283374)
زى ما انت قولت انك لعبت فى ال 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

رد: All FGW Problems Fixs-----#Ri3o
 
ما هو عشان كدة حصل مشكلة فى ال Spot ال FGW Mobs احسن حل انك تشيل ال TabRefNest اللى عندك
كود:

USE [SRO_VT_SHARD]
GO
truncate table Tab_RefNest

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


الساعة الآن 10:12 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.