show 1-2 pages back
Printable View
Guys i have a problem after i create a character and made lvl 400 i can't make summoner or ragefighter.... i used this code : the code work only with this account that i have and when i make a new a count me neet to put the account another time do anyone know how to resolve this problem ?
Use [MuOnline]
UPDATE AccountCharacter SET Summoner = '1'
GO
UPDATE AccountCharacter SET RageFighter = '1'
GO
someone have other fix ? :)
(thanks 15351535)
or change in sql for default 1 not "NULL"
via table design (but i´m not sure)
i tried to put null 1 at summoner and ragefighter but i can't save... :(
Delete dbo.AccountCharacter
Add New Querty
Quote:
USE [MuOnline]
GO
/****** Object: Table [dbo].[AccountCharacter] Script Date: 06/18/2015 21:25:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AccountCharacter](
[Number] [int] IDENTITY(1,1) NOT NULL,
[Id] [varchar](10) NOT NULL,
[GameID1] [varchar](10) NULL,
[GameID2] [varchar](10) NULL,
[GameID3] [varchar](10) NULL,
[GameID4] [varchar](10) NULL,
[GameID5] [varchar](10) NULL,
[GameIDC] [varchar](10) NULL,
[MoveCnt] [tinyint] NULL,
[Summoner] [tinyint] NULL,
[ExpandedWarehouse] [tinyint] NOT NULL,
[RageFighter] [tinyint] NULL,
CONSTRAINT [PK_AccountCharacter] PRIMARY KEY CLUSTERED
(
[Id] 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].[AccountCharacter] ADD CONSTRAINT [DF_AccountCharacter_Summoner] DEFAULT ((1)) FOR [Summoner]
GO
ALTER TABLE [dbo].[AccountCharacter] ADD CONSTRAINT [DF_Ware] DEFAULT ((0)) FOR [ExpandedWarehouse]
GO
ALTER TABLE [dbo].[AccountCharacter] ADD CONSTRAINT [DF_AccountCharacter_RageFighter] DEFAULT ((1)) FOR [RageFighter]
GO
@MuRedDawn thank you very much , now i can see the rage fighter and summoner but when i go to create rf or summoner i put the name and all the fucking time i receive an error that say incorect character name or it's in use but my database don't have this name and the name contains numeric and alphabetic . i don't know more what to do :(
#OffTopic
Guys really sorry for this off topic, im trying to post a thread but i cant... I think its moderate #pardon
I wanna to start a mu server hosted in my own pc to play with my friends, we played mu on our teenage, so the problem is: Im weekys looking for and testing many servers s6 ep3 and none is good. Anyone can indicate me a mu server season 6 ep 3 or higher without important bugs and without itens custom?
I need your help! Thx!
use s8,delete the s8 features->so you get s6 server,or use "
TitansTech 11.70.80 By Pinkof" <-S6
@15351535
I have this Pinkof release, and i tested it yesterday, i found a lot of bugs and i donto know how to fix it :/
Some xShops itens cant be buyed
Buff duration is wrong
I cant use sum create card
If I knew how to fix this I would use
How u can see, im not expert in server configuration hahaha i need some direction :/
don´t know abouth this release,i use s8 server
guys after 4 hours i finaly resolved the thing with rage figthter and summoner :D
Can you code command /post show multi sub server. Example Scfpostserver (Titantechs)
Thank you for helping me !, if we want to follow the low, the drop list items Ancients.
thanks again.
Code://==============================================================================================================================================================================
// Item Item Min Max Max Opt Item Luck Item Skill Item Max Exc Item Anc Item Drop Monster Monster ID Item
// Type Index Level Level Opt Rate Luck Rate Skill Rate Exc Exc Rate Anc Rate Dur Rate MinLvl MaxLvl Map Name
//==============================================================================================================================================================================
// Hyon SET
7 1 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Hyon Dragon Helm
11 1 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Hyon Dragon Boots
10 1 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Hyon Dragon Gloves
0 14 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Hyon Lightning Sword
// Vinicious SET
7 1 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Vicious Dragon Helm
8 1 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Vicious Dragon Armor
9 1 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Vicious Dragon Pants
13 22 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // vicious Ring of Earth
// Anubis SET
7 3 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Anubis Legendary Helm
8 3 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Anubis Legendary Armor
10 3 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Anubis Legendary Gloves
13 21 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Anubis Ring of Fire
// Isis SET
7 3 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Isis Legendary Helm
8 3 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Isis Legendary Armor
9 3 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Isis Legendary Pants
11 3 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Isis Legendary Boots
// Aruane SET
7 14 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Aruane Guardian Helm
8 14 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Aruane Guardian Armor
9 14 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Aruane Guardian Pants
11 14 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Aruane Guardian Boots
// Muren SET
8 15 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Muren Storm Crow Armor
9 15 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Muren Storm Crow Pants
10 15 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Muren Storm Crow Gloves
13 21 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Muren Ring of fire
// Agnis SET
7 26 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Agnis adamantine Helm
8 26 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Agnis adamantine Armor
9 26 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Agnis adamantine Pants
13 9 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Agnis Ring of Poison
// Browii SET
9 26 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Browii adamantine Pants
10 26 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Browii adamantine Gloves
11 26 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Browii adamantine Boots
13 25 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Browii Pendant of Ice
// Krono SET
7 40 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Krono Red Wing Helm
9 40 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Krono Red Wing Pants
10 40 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Krono Red Wing Gloves
13 24 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1 // Krono Ring of Magic
// Semeden SET
7 10 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Semeden Red Wing Helm
8 10 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Semeden Red Wing Armor
10 10 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Semeden Red Wing Gloves
11 10 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Semeden Red Wing Boots
// Warrior SET
7 5 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Warrior Leather Helm
8 5 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Warrior Leather Armor
9 5 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Warrior Leather Pants
11 5 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Warrior Leather Boots
10 5 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Warrior Leather Gloves
2 1 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Warrior Morning Star
13 8 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Warrior Ring of ice
// Hyperion SET
8 0 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Hyperion Bronze Armor
9 0 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Hyperion Bronze Pants
11 0 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Hyperion Bronze Boots
// Eplet SET
8 6 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Eplete Scale Armor
9 6 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Eplete Scale Pants
7 6 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Eplete Scale Helmet
6 9 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Eplete Plate Shield
13 12 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Eplete Pendant of Lightning
// Garuda SET
8 8 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Garuda Brass Armor
9 8 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Garuda Brass Pants
10 8 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Garuda Brass Gloves
11 8 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Garuda Brass Boots
13 13 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Garuda Pendant of Fire
// Kantata SET
8 9 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Garuda Brass Armor
10 9 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Garuda Brass Pants
11 9 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Garuda Brass Gloves
13 9 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Garuda Brass Boots
13 23 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1 // Garuda Pendant of Fire
// Appolo SET
8 2 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
9 2 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
7 2 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
10 2 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
0 0 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
13 25 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
13 24 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Evis SET
8 4 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
9 4 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
11 4 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
13 26 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Hera SET
7 7 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
9 7 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
11 7 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
10 7 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
7 7 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
6 6 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Ceto Vine SET
11 10 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
9 10 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
10 10 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
7 10 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
0 2 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
13 22 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Gaia SET
9 11 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
8 11 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
7 11 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
10 11 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
4 9 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Odin SET
7 12 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
8 12 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
9 12 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
10 12 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
11 12 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Argo SET
8 13 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
9 13 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
10 13 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Gywen SET
8 14 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
10 14 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
11 14 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
4 5 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
13 28 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Gaion SET
7 15 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
9 15 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
8 15 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
13 27 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Berserker SET
7 6 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1
8 6 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1
9 6 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1
10 6 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
11 6 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Cloud SET
7 8 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
9 8 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1
// Drake SET
8 10 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
9 10 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1
11 10 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1
7 10 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1
// Peize SET
9 11 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1
10 11 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1
11 11 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Elvian SET
10 12 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
11 12 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Vega's SET
7 59 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
8 59 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
9 59 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
0 32 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
// Chamereuui's SET
8 59 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1
9 59 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1
11 59 0 9 6 2 1 1 1 1 0 0 0 5 20 255 1 40 400 -1
0 32 0 9 6 2 1 1 1 1 0 0 0 6 20 255 1 40 400 -1
guys i have a problem i set the movereq_eng.bmd and the movereq in server files but i can't warp in the new map i added ( crywolf and barrack) do anyone know why ?
i'm sure that i added them correctly :)
THE SEALS NOT WORKING
http://i.imgur.com/yu7F2eq.jpg
RE-LOGIN
http://i.imgur.com/fXkStBM.jpg
AND NOT WORKING!
http://i.imgur.com/pdogHeg.jpg
and now realize this change in bd
Quote:
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