I can't seem to manage the reset system. still not showing the right requirements
Printable View
I can't seem to manage the reset system. still not showing the right requirements
how to set stat charactor ?
example
KnightStr = 28000
KnightAgi = 28000
KnightVit = 28000
KnightEne = 28000
WizardStr = 32000
WizardAgi = 32000
WizardVit = 32000
WizardEne = 32000
I think i saw an option in commonserver.cfgQuote:
Originally Posted by pondzas
Can any1 tell me just IT has or It hasnt?Quote:
Originally Posted by chise08
Shared Main zTeam Glow !!!! :thumbup::thumbup::thumbup:
Download Link : http://www.mediafire.com/download/mhf3ybzvbx5b3qo
Pass Rar : EvilzTeam
Pic. :thumbup::thumbup::thumbup:
http://i.imgur.com/RPY7NMM.jpg
@pondzas add glow easy :) no need glow.dll
http://s24.postimg.org/n6q5bcd1x/untitled.jpg
Attachment 146290
giys anyone have editors for all files here ?? thanks
I would also need to text.bmd editor
i can't Create Guild!
GensSystem.dat
CommonServer.cfgQuote:
//===================================================================================
// zGameServer
// ----------------------------------------------------------------------------------
// Description: Gens system settings
// ----------------------------------------------------------------------------------
// Revision: 18:45 23:35 15.12.2013
//===================================================================================
//=====================================
// Main
//=====================================
0
// ----------------------------------------------------------------------------------------------------------------
// Point ReqLvl ReqRes GuildCreate GuildEnter PartyEnter AllianceEnter AllowPK ChatPrice
// ----------------------------------------------------------------------------------------------------------------
0 80 0 0 0 0 0 0 0
end
Quote:
//=====================================
// Guild
//=====================================
ServerGroupGuildChatting = 1 //-> Enable guild chat [1 - On | 0 - Off]
ServerGroupUnionChatting = 1 //-> Enable alliance chat [1 - On | 0 - Off]
GuildCreate = 1 //-> Enable guild create [1 - On | 0 - Off]
GuildCreateLevel = 250 //-> Guild create level [0 - 400]
GuildDestroy = 1 //-> Enable guild destroy [1 - On | 0 - Off]
EnableBattleSoccer = 1 //-> Enable battle soccer [1 - On | 0 - Off]
CastleOwnerGuildDestroyLimit = 1 //-> Enable guild destroy for castle lord [1 - On | 0 - Off]
GuildAllianceMinUsers = 1 //-> Minimun users in guild to alliance create [1 - 20]
Bug found player say !gold mesage although not admin, How to fix ?
4th level wings visual bug on switch character
Guys can someone knows how to create one so that when simplicity was skarost 32 to no more than 200
Guya Item editor? dor this release? tnks
Quote:
Originally Posted by Denied
Me too.
Any news on Seals?
what about unicorn pet visual bug? it disappears when ever you warp or teleport?
thanks!
god bless!
Update Bugs Founded:
1. Seals bought on X Shop : If you used 2 seals and select character the other seal will disappear
- - - Updated - - -
It's already been fixed broQuote:
Originally Posted by 4pLay
Period Item Fixed ^_^
Preiod Item?
hmmm, i just downloaded the updated 1 files and it seems that the pet visual bug is still not fixed? what do you think is the problem? which file?Quote:
Originally Posted by ScriptKid
http://i61.tinypic.com/w00yvl.png
thanks!
god bless!
Test it man!!Quote:
Originally Posted by 4pLay
http://www.mediafire.com/download/gi...S_10_99UP6.rar
Update:
Custom wings Active
Backdoor remove
Pet unicorn fix
Fix Double Goer
Fix player post Command: !
Thank GameServer by Heyned
mine works fine
here:
http://i.imgur.com/fKKCFCG.png
archive broken or damage.Quote:
Originally Posted by pondzas
http://i61.tinypic.com/2i2afdt.png
- - - Updated - - -
and i have used the same client without any editing on it also the updated files.Quote:
Originally Posted by ScriptKid
Use winrar 5 for archive.Quote:
Originally Posted by 4pLay
how to Fix Double Goer bro?Quote:
Originally Posted by pondzas
bug
int UserQuestInfo::GetEpisode()
{
return this->episode_number_;
}
I have already reported the seals bug xDQuote:
Originally Posted by ScriptKid
What exactly the problem with seal?Quote:
Originally Posted by Denied
http://s23.postimg.org/6tljsyj3v/Seal.jpg
Tried googling and searching within this forum, seems like the server files require different ways to setup.
Looked for a guide .. doesn't work well though. Anyone might or can link me?
My problem is that, Using the serverstartup only runs zconnectserver and other doesn't even show up.
OS is running Windows Server 2008 R2
Thanks
Buy Seal of Wealth + Seal of Healing and switch character. You will notice that one will disappear and also they do not have any effect :)Quote:
Originally Posted by phgkhh
guys how to fix ( !gold message ) ? It can also write Players
Can any1 tell me if there's any .ini, txt, cfg to configure percent of luck / skill on item drops?
- - - Updated - - -
is those mixes avaliable on this release?Quote:
Originally Posted by BladeKnight109
Seals and scroll delete when relog has been fixed? coz i tried and still delete...
Back on-topic now
Help me pls.
Me change Database from SQL_Latin_Ganral_CP1_CI_AS to Thai_CI_AS
Database Bug.
who can help me? T_T
Problem in game.
Select Char and auto Disconnnect
the source is last? if i compile gs crash.., gs on the repack run perfect.. but size is not same at compiled by source-
You need to disable some functions, check previous posts.Quote:
Originally Posted by satta87
Compile on vs 2010,remove 6 line of reward from illusiontemle, uncomment root define and it should run smootlyQuote:
Originally Posted by satta87
Creating new wings in chaos machine works?
4th Wings bug in BC 8
help me http://www.uppic.org/image-4133_53A8166D.jpg
- - - Updated - - -
yessupportQuote:
Originally Posted by pondzas
Any one got fix for Seals?
me too! client when frames login is >>>Loading....can't joint gameQuote:
Originally Posted by gmrote
Logs GameServer, Dataserver ??Quote:
Originally Posted by gmrote
Seal Fixed, Expired Item Fixed, Visual Bug Pet Fixed.
https://lh4.googleusercontent.com/-1...%2529-0000.jpg
- - - Updated - - -
Check in log GameServerQuote:
Originally Posted by copysolo
can you give me DB win 7 32 bit with slq 2000 or upload complete server is run please!Quote:
Originally Posted by BladeKnight109
Download Attachments (DB SQL 2000 + ODBC x86, x64):Quote:
Originally Posted by copysolo
Attachment 146328
Write what you changed in the code, because every load that has changed in the code and get semolina
And the request to everyone, do not load each of its release, and then not tell what and where .....
Sorry for translate....
RUS: Нихуя не понятноQuote:
Originally Posted by VadimashRS
ENG: it's incomprehensible
Why not share the fix? thanks!Quote:
Originally Posted by BladeKnight109
I'm finishing Doppelganger events. I will share it in the shortest time.Quote:
Originally Posted by ScriptKid
And will you share sources or only compiled files?Quote:
Originally Posted by BladeKnight109
how about the fix of ikennylee ?
Why there are alot of user still using sql 2000?
SQL server 2005 or 2008 express is free!
SQL server x32 + SQL server mangement
how does S4 wings work? i mean, i dont have them in item.txt in files... sorry if its a noob question but can explain me how to use those wings? thanks!
- - - Updated - - -
When i use that database and run the SQL file, when EXDB start gives an error "Unknown MU DB Identification", anyone knows why?Quote:
Originally Posted by BladeKnight109
Open Table Mu_DBID and add 1234
Search your item.txt => Test wing 1 => Test wing 5!
I did, but now All editors give me the same error... Mumaker, titan editor...Quote:
Originally Posted by BladeKnight109
http://subefotos.com/ver/?c3288ca7fc...78f87e224o.jpg
Use DB manger to create account! It in server file/tool/dbmanagerQuote:
Originally Posted by chise08
I dont have those in item.txt...Quote:
Originally Posted by Sokpheang
I downloaded Files from first post, and update 1... and there's not test wing on txt, can help me?
That update1 don't have season 4 wings!Quote:
Originally Posted by chise08
and then where should i download files with s4 wings???Quote:
Originally Posted by Sokpheang
This is Server with season 4 wings http://www.mediafire.com/download/ck...S_10_99UP5.rarQuote:
Originally Posted by chise08
This is client patch with season 4 wings https://www.mediafire.com/?4e4uwvpus92dc3v
and don't forget to use encoder_w4 from client patch to work!
there is only Game server there, i dont got s4 wings in ITEM.TXT ... where can i get it?Quote:
Originally Posted by Sokpheang
Search in item.txt have test wing 1 test wing 2 .....Quote:
Originally Posted by chise08
@@ Sorry it my bad! that server files don't have test wing!
Use this it have http://www.mediafire.com/download/7b...erverSS6E3.rar
password : muskins.net
Attachment 146336Now its all ok but cannot create character man... i use the database and the query u uploaded... and have this...Quote:
Originally Posted by BladeKnight109
don't use query! just restore database from dbQuote:
Originally Posted by chise08
Use this client! https://www.mediafire.com/?2hkksbrmoy226za (pw = z-team.pro)
and patch this http://www.mediafire.com/download/83...lientPatch.rar
and patch wing!
Yea but i tried to use Database for fix Seals and so, but when i run the query, cannot create characters anymore... even the editors wont work... any solution?Quote:
Originally Posted by Sokpheang
Just wating the Th3AnG3L release the update 2 repack ! he fixes all the bug!
still waiting for the update 2 for Seal fix
Another Bug:
MEMB_STAT information not saving on the database. check it
that is not bug its Stored Procedures incorrect codesQuote:
Originally Posted by ScriptKid
here is the fix
Code:CREATE PROCEDURE WZ_CONNECT_MEMB
@uid varchar(20), @Server varchar(20),
@uip varchar(20)
AS
Begin
BEGIN TRANSACTION
SET NOCOUNT ON
IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED)
WHERE memb___id = @uid )
Begin
UPDATE MEMB_STAT
SET ip = @uip , connectstat = 1 , servername = @Server , ConnectTM = (getdate())
WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,ip,connectstat,servername) valueS (
@uid,
@uip,
1, @Server
)
End
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
right click on stored procedure then delete
@chise08
I've marked it in red for you:
http://i.gyazo.com/934ab73c057629c471b41f66d063d49d.png
Once you're done, open a new query and execute what ScriptKid posted above.
Thank for DB.I hope one day particular will have a copy complete overQuote:
Originally Posted by BladeKnight109
- - - Updated - - -
this winrar of this does not running failsQuote:
Originally Posted by Sokpheang
Run this queryQuote:
Originally Posted by ScriptKid
PHP Code:USE [MuOnline]GO/****** Object: StoredProcedure [dbo].[WZ_PeriodItemInsert] Script Date: 06/24/2014 09:31:32 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER Procedure [dbo].[WZ_PeriodItemInsert] [MENTION=1335]user[/MENTION]Guid int [MENTION=1333352388]Character[/MENTION]Name varchar(10),@ItemCode int [MENTION=41246]OptiOn[/MENTION]Type tinyint [MENTION=404296]Effect[/MENTION]Type1 tinyint [MENTION=404296]Effect[/MENTION]Type2 tinyint [MENTION=2000041465]Total[/MENTION]UsePeriod int [MENTION=817405]expired[/MENTION]ate varchar(20)ASBEGINDECLARE [MENTION=513573]ErrorCode[/MENTION] intDECLARE [MENTION=241967]period[/MENTION]ItemIndex int
SET [MENTION=513573]ErrorCode[/MENTION] = 0SET [MENTION=241967]period[/MENTION]ItemIndex = 0
SET XACT_ABORT ONSET NOCOUNT ON
BEGIN TRANSACTION
SELECT [MENTION=241967]period[/MENTION]ItemIndex = PeriodIndex FROM T_PeriodItem_Info WHERE UserGuid = [MENTION=1335]user[/MENTION]Guid AND CharacterName = [MENTION=1333352388]Character[/MENTION]Name AND OptionType = [MENTION=41246]OptiOn[/MENTION]Type AND UsedInfo = 1
IF ( [MENTION=241967]period[/MENTION]ItemIndex != 0 )BEGINUPDATE T_PeriodItem_Info SET UsedInfo = 0 WHERE UserGuid = [MENTION=1335]user[/MENTION]Guid AND CharacterName = [MENTION=1333352388]Character[/MENTION]Name AND OptionType = [MENTION=41246]OptiOn[/MENTION]Type AND UsedInfo = 1END
INSERT INTO T_PeriodItem_Info (UserGuid, CharacterName, ItemCode, OptionType, EffectType1, EffectType2, LeftTime, BuyDate, ExpireDate, UsedInfo) VALUES( [MENTION=1335]user[/MENTION]Guid, [MENTION=1333352388]Character[/MENTION]Name, @ItemCode, [MENTION=41246]OptiOn[/MENTION]Type, [MENTION=404296]Effect[/MENTION]Type1, [MENTION=404296]Effect[/MENTION]Type2, [MENTION=2000041465]Total[/MENTION]UsePeriod, GETDATE(), CAST [MENTION=817405]expired[/MENTION]ate AS datetime2(0)), 1 )IF( [MENTION=116066]ERROR[/MENTION] <> 0 )BEGINSET [MENTION=513573]ErrorCode[/MENTION] = 2END
IF ( [MENTION=513573]ErrorCode[/MENTION] <> 0 )ROLLBACK TRANSACTIONELSECOMMIT TRANSACTION
SELECT [MENTION=513573]ErrorCode[/MENTION]
SET NOCOUNT OFFSET XACT_ABORT OFFEND
can you paste it on a CODE BBcode?
Code:USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_PeriodItemInsert] Script Date: 06/24/2014 09:31:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[WZ_PeriodItemInsert]
@userGuid int,
@CharacterName varchar(10),
@ItemCode int,
@OptiOnType tinyint,
@EffectType1 tinyint,
@EffectType2 tinyint,
@TotalUsePeriod int,
@expiredate varchar(20)
AS
BEGIN
DECLARE @ErrorCode int
DECLARE @periodItemIndex int
SET @ErrorCode = 0
SET @periodItemIndex = 0
SET XACT_ABORT ON
SET NOCOUNT ON
BEGIN TRANSACTION
SELECT @periodItemIndex = PeriodIndex FROM T_PeriodItem_Info WHERE UserGuid = @userGuid AND CharacterName = @CharacterName AND OptionType = @OptiOnType AND UsedInfo = 1
IF ( @periodItemIndex != 0 )
BEGIN
UPDATE T_PeriodItem_Info SET UsedInfo = 0 WHERE UserGuid = @userGuid AND CharacterName = @CharacterName AND OptionType = @OptiOnType AND UsedInfo = 1
END
INSERT INTO T_PeriodItem_Info (UserGuid, CharacterName, ItemCode, OptionType, EffectType1, EffectType2, LeftTime, BuyDate, ExpireDate, UsedInfo) VALUES
( @userGuid, @CharacterName, @ItemCode, @OptiOnType, @EffectType1, @EffectType2, @TotalUsePeriod, GETDATE(), CAST @expiredate AS datetime2(0)), 1 )
IF( @ERROR <> 0 )
BEGIN
SET @ErrorCode = 2
END
IF ( @ErrorCode <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SELECT @ErrorCode
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
Error:
Msg 102, Level 15, State 1, Procedure WZ_PeriodItemInsert, Line 39
Incorrect syntax near '@expiredate'.
Msg 137, Level 15, State 2, Procedure WZ_PeriodItemInsert, Line 40
Must declare the scalar variable "@ERROR".
What SQL Version you use?
much better if you do is Script Stored Procedure as > CREATE TO then copy the whole query and paste it here then we test
- - - Updated - - -
MSSQL 2008 R2
there.. works now. let me test
- - - Updated - - -
Update:
Seals still gone after switch character
- - - Updated - - -
Anyone who got fix for Seals?
some data have a table T_PeriodItem_Info?
Yes but not all of them..
Show me the Logs DataServer, when you use Seal
With 2 Seals
after switchCode:[00:03:48] SELECT * FROM GameShopPoint WHERE AccountID = 'cloude'
[00:03:53] DELETE FROM GameShopStorage WHERE AccountID = 'cloude' AND AuthIndex = 5453 AND AuthID = 9799 AND ItemID = 6718 AND IBSID = 38 AND IBSCategory = 29 AND IBSIndex = 63
[00:03:53] EXEC WZ_PeriodItemInsert 11, 'sasas', 6718, 2, 6, 53, 10080, '2014-7-1 0:3'
[00:03:56] UPDATE GameShopPoint SET WCoinC = 9899, WCoinP = 69328, GoblinPoint = 7209 WHERE AccountID = 'cloude'
[00:03:58] SELECT * FROM GameShopPoint WHERE AccountID = 'cloude'
- - - Updated - - -Code:[00:05:42] SELECT Summoner FROM AccountCharacter WHERE Id = 'cloude'
[00:05:43] SELECT Id FROM AccountCharacter WHERE Id='cloude'
[00:05:44] SELECT * FROM AccountCharacter WHERE Id='cloude'
[00:05:46] SELECT Name, cLevel, Class, CtlCode, DbVersion FROM vCharacterPreview WHERE Name='Cloude'
[00:05:49] SELECT G_Status FROM GuildMember WHERE Name='Cloude'
[00:05:49] SELECT Name, cLevel, Class, CtlCode, DbVersion FROM vCharacterPreview WHERE Name='Clark'
[00:05:52] SELECT G_Status FROM GuildMember WHERE Name='Clark'
[00:05:53] SELECT Name, cLevel, Class, CtlCode, DbVersion FROM vCharacterPreview WHERE Name='sasas'
[00:05:54] SELECT G_Status FROM GuildMember WHERE Name='sasas'
[00:05:59] SELECT AccountID, cLevel, Class, LevelUpPoint, Experience, Strength, Dexterity, Vitality, Energy, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, CtlCode, Leadership, ChatLimitTime, FruitPoint, Resets, GrandResets, ExpandedInventory, DbVersion, OffExp FROM Character where Name = 'sasas'
[00:06:03] UPDATE AccountCharacter SET GameIDC='sasas' WHERE Id='cloude'
[00:06:03] SELECT * FROM OptionData WHERE Name='sasas'
[00:06:03] SELECT * FROM GameShopPoint WHERE AccountID = 'cloude'
[00:06:03] EXEC WZ_PeriodItemSelectEx 11, 'sasas'
[00:06:04] SELECT * FROM GameShopPoint WHERE AccountID = 'cloude'
[00:06:04] [6720] [2269]
[00:06:04] WZ_LuckyItemSelect 'sasas'
[00:06:05] EXEC GameShopStorageSelect 'cloude'
[00:06:06] EXEC WZ_PeriodItemSelect 11, 'sasas'
[00:06:06] SELECT * FROM GensMember WHERE Name = 'sasas'
[00:06:10] EXEC WZ_MLS_InfoLoad 'sasas'
[00:06:12] EXEC WZ_QMK_InfoLoad 'sasas'
[00:06:12] WZ_QuestExpUserInfoLoad_Fir 'sasas'
[00:06:14] EXEC WZ_MLS_InfoSave 'sasas', 0, 538200, 35507050, 0
Update:
Cashshop GIFT is also not working
what problem bro?Quote:
Originally Posted by ScriptKid
Seals not working?
I can't using 2 brova Weapon? How to fix?
P/S: Fixed DarkLord Pet Item. I will share it. Continue :)
after switch character only 1 seal will remain
Edit Procedue pro.Quote:
Originally Posted by ScriptKid
Error here:
Open WZ_PeriodItemInsert and DeleteQuote:
UPDATE T_PeriodItem_Info SET UsedInfo = 0
- - - Updated - - -Code:SELECT @periodItemIndex = PeriodIndex FROM T_PeriodItem_Info WHERE UserGuid = @userGuid AND CharacterName = @CharacterName AND OptionType = @OptiOnType AND UsedInfo = 1
IF ( @periodItemIndex != 0 )
BEGIN
UPDATE T_PeriodItem_Info SET UsedInfo = 0 WHERE UserGuid = @userGuid AND CharacterName = @CharacterName AND OptionType = @OptiOnType AND UsedInfo = 1
END
And you need edit source code Clear Same Effect
what do you mean clear same effect?
So it should be.Quote:
Originally Posted by ScriptKid
no, it should stll have 2 buffs
- - - Updated - - -
Update:
Fixed Seals when electing character
Open WZ_PeriodItemInsert and Delete
This is tested by me and credits to @bladeKnigh109Code:SELECT @periodItemIndex = PeriodIndex FROM T_PeriodItem_Info WHERE UserGuid = @userGuid AND CharacterName = @CharacterName AND OptionType = @OptiOnType AND UsedInfo = 1
IF ( @periodItemIndex != 0 )
BEGIN
UPDATE T_PeriodItem_Info SET UsedInfo = 0 WHERE UserGuid = @userGuid AND CharacterName = @CharacterName AND OptionType = @OptiOnType AND UsedInfo = 1
END
is MUE Free edition database can work on this server files?
NO.. Database Structure is different.
T_PeriodItem_Info full table :)
Code:USE [MuOnline]
GO
/****** Object: Table [dbo].[T_PeriodItemInfo] Script Date: 06/24/2014 13:27:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_PeriodItemInfo](
[PeriodIndex] [int] IDENTITY(1,1) NOT NULL,
[UserGuid] [int] NOT NULL,
[CharacterName] [char](10) NULL,
[ItemCode] [int] NOT NULL,
[ItemType] [tinyint] NOT NULL,
[EffectType1] [tinyint] NOT NULL,
[EffectType2] [tinyint] NULL,
[UsedTime] [int] NOT NULL,
[LeftTime] [int] NOT NULL,
[BuyDate] [smalldatetime] NOT NULL,
[ExpireDate] [smalldatetime] NOT NULL,
[UsedInfo] [tinyint] NOT NULL,
[OptionType] [tinyint] NOT NULL,
[SerialCode] [bigint] NULL,
[BuyDateConvert] [int] NULL,
[ExpireDateConvert] [int] NULL,
[SetExpire] [tinyint] NULL,
CONSTRAINT [PK_T_PeriodItemInfo] PRIMARY KEY CLUSTERED
(
[PeriodIndex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[T_PeriodItemInfo] ADD CONSTRAINT [DF_T_PeriodItemInfo_ItemType] DEFAULT ((1)) FOR [ItemType]
GO
ALTER TABLE [dbo].[T_PeriodItemInfo] ADD CONSTRAINT [DF_T_PeriodItemInfo_UsedTime] DEFAULT ((0)) FOR [UsedTime]
GO
ALTER TABLE [dbo].[T_PeriodItemInfo] ADD CONSTRAINT [DF_T_PeriodItemInfo_UsedInfo] DEFAULT ((0)) FOR [UsedInfo]
GO
ALTER TABLE [dbo].[T_PeriodItemInfo] ADD CONSTRAINT [DF_T_PeriodItemInfo_OptionType] DEFAULT ((2)) FOR [OptionType]
GO
ALTER TABLE [dbo].[T_PeriodItemInfo] ADD CONSTRAINT [DF_T_PeriodItemInfo_SetExpire] DEFAULT ((0)) FOR [SetExpire]
GO
xtreme you are wrong this is the correct one
Code:USE [MuOnline]
GO
/****** Object: Table [dbo].[T_PeriodItemInfo] Script Date: 06/24/2014 13:27:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_PeriodItem_Info](
[PeriodIndex] [int] IDENTITY(1,1) NOT NULL,
[UserGuid] [int] NOT NULL,
[CharacterName] [char](10) NULL,
[ItemCode] [int] NOT NULL,
[ItemType] [tinyint] NOT NULL,
[EffectType1] [tinyint] NOT NULL,
[EffectType2] [tinyint] NULL,
[UsedTime] [int] NOT NULL,
[LeftTime] [int] NOT NULL,
[BuyDate] [smalldatetime] NOT NULL,
[ExpireDate] [smalldatetime] NOT NULL,
[UsedInfo] [tinyint] NOT NULL,
[OptionType] [tinyint] NOT NULL,
[SerialCode] [bigint] NULL,
[BuyDateConvert] [int] NULL,
[ExpireDateConvert] [int] NULL,
[SetExpire] [tinyint] NULL,
CONSTRAINT [PK_T_PeriodItem_Info] PRIMARY KEY CLUSTERED
(
[PeriodIndex] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[T_PeriodItem_Info] ADD CONSTRAINT [DF_T_PeriodItemInfo_ItemType] DEFAULT ((1)) FOR [ItemType]
GO
ALTER TABLE [dbo].[T_PeriodItem_Info] ADD CONSTRAINT [DF_T_PeriodItemInfo_UsedTime] DEFAULT ((0)) FOR [UsedTime]
GO
ALTER TABLE [dbo].[T_PeriodItem_Info] ADD CONSTRAINT [DF_T_PeriodItemInfo_UsedInfo] DEFAULT ((0)) FOR [UsedInfo]
GO
ALTER TABLE [dbo].[T_PeriodItem_Info] ADD CONSTRAINT [DF_T_PeriodItemInfo_OptionType] DEFAULT ((2)) FOR [OptionType]
GO
ALTER TABLE [dbo].[T_PeriodItem_Info] ADD CONSTRAINT [DF_T_PeriodItemInfo_SetExpire] DEFAULT ((0)) FOR [SetExpire]
GO
bug trap visual in Forest of Imperial Giardian event?
https://lh6.googleusercontent.com/-R...%2529-0020.jpg
you need to add check on viewportadd for skip trapsQuote:
Originally Posted by tranphuoctai
