{--} MMO Games Development Forums
Building up your own servers is easy,!
  Usergroups  ·  Register ·    Profile  ·  Log in to check your private messages  ·   Log in     

FAQ · Search · Memberlist


[Guide] Fix Bug 32000 trong Command của DL

 
Post new topic   Reply to topic    {--} MMO Games Development Forums Forum Index -> MU Guides - Tutorials
View previous topic :: View next topic  
Author Message
nT | Heartdie
Junior 2
Junior 2
nT | Heartdie

Joined: 26 Aug 2007
Posts: 24
Location: C:/AppServ

PostPosted: 26/08/2007 22:38    Post subject: [Guide] Fix Bug 32000 trong Command của DL Reply with quote

// Một số bản MU khi tạo ra nhân vật DL đã có sẵn 32000 Point Command. Hãy cùng tôi Fix Bug này nhé !

+ Chạy Query Analyzer của MySQL
+ Chạy 2 đoạn Code dưới đây là bạn đã Fix được Bug này rồi.
Query 1
Quote:
-- =============================================
-- Fix Command For Dark Lord Class
-- HTTP://MuoDEV.MyForum.Ro
-- =============================================

CREATE TRIGGER [Update_Command] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].Leadership=32000
From Inserted
Where Inserted.Leadership=25 and
[Character].accountid=inserted.accountid
and [Character].name=inserted.name


Query 2
Quote:
-- =============================================
-- Fix Command For Dark Lord Class
-- HTTP://MuoDEV.MyForum.Ro
-- =============================================

UPDATE Character
SET Leadership= ('32000')
WHERE CtlCode<64


Chúc bạn thành công !
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    {--} MMO Games Development Forums Forum Index -> MU Guides - Tutorials All times are GMT - 7 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group  ·  Theme and Graphics by Tim Blackman
Fa-ti si tu propriul forum GRATUIT, pe www.myforum.ro