Client is a regular thing.
Moreover, the extension is rar.
Main Clack only changed the cereal.
+Master lvl Show bag Fix
&
It is a thing to have done GG in Crack.
Jpn Season5 Part3 = Kor Season 5 Part4
Jpn is advanced.
Sorry my bad English
Printable View
hey Dudi, any success with sp_get_payitem procedure? :rolleyes:
Well never people share the code and didnt help...
Try with this... im not shure if this works, but y try to made to works XD
i think its works! test it please!Quote:
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[SP_GET_PAYITEM] Script Date: 08/06/2010 20:02:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_GET_PAYITEM]
@AccountID varchar(10),
@CharName varchar(10),
@ServerCode int
As
Begin
BEGIN TRANSACTION
DECLARE @iGIFT_GUID INT
DECLARE @iGIFT_KIND INT
DECLARE @iGIFT_NAME VARCHAR(50)
SET NOCOUNT ON
IF EXISTS (SELECT AccountID Guid FROM SP_GET_PAYITEM WHERE AccountID = @AccountID)
BEGIN
SELECT 0 As ResultCode, '' As GiftName
END
ELSE
BEGIN
IF EXISTS (SELECT TOP 1 Guid FROM SP_GET_PAYITEM WHERE Date_Give < GetDate() and RegCheck = 0 ORDER BY Guid ASC)
BEGIN
SELECT TOP 1 @iGIFT_GUID = Guid, @iGIFT_KIND = GiftKind FROM SP_GET_PAYITEM WHERE Date_Give < GetDate() and RegCheck = 0 ORDER BY Guid ASC
UPDATE SP_GET_PAYITEM SET Server = @ServerCode, AccountID = @AccountID, CharName = @CharName, Date_Reg = GetDate(), RegCheck = 1 WHERE Guid = @iGIFT_GUID
SELECT @iGIFT_NAME = GiftName FROM SP_GET_PAYITEM WHERE GiftKind = @iGIFT_KIND
SELECT 1 As ResultCode, @iGIFT_NAME As GiftName
END
ELSE
BEGIN
SELECT 0 As ResultCode, '' As GiftName
END
END
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
End
pd: change MuOnline for your database, i use all database in one.
Try this:
Code:USE [MU2003_EVENT_DATA]
GO
/****** Object: StoredProcedure [dbo].[SP_SET_PAYITEM] Script Date: 08/07/2010 00:13:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_SET_PAYITEM]
@AccountID varchar(10),
@Unknown int
AS
BEGIN
SET NOCOUNT ON
DECLARE @ItemGetCount INT
IF EXISTS (SELECT * FROM T_PAYITEM_COUNT WHERE AccountID = @AccountID)
BEGIN
SELECT @ItemGetCount = GetItemCount FROM T_PAYITEM_COUNT WHERE AccountID = @AccountID
IF (@ItemGetCount >= 6)
BEGIN
SELECT 0 AS IsFirst, 3 AS ResultCode
END
ELSE
BEGIN
SELECT 0 AS IsFirst, 0 AS ResultCode
UPDATE T_PAYITEM_COUNT SET GetItemCount=GetItemCount+@Unknown WHERE AccountID = @AccountID
END
END
ELSE
BEGIN
SELECT 1 AS IsFirst, 0 AS ResultCode
INSERT INTO T_PAYITEM_COUNT (AccountID, GetItemCount) VALUES (@AccountID, 1)
END
END
SET NOCOUNT OFF
GO
Code:USE [MU2003_EVENT_DATA]
GO
/****** Object: StoredProcedure [dbo].[SP_GET_PAYITEM] Script Date: 08/07/2010 00:14:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Batch submitted through debugger: SQLQuery8.sql|7|0|C:\Users\root\AppData\Local\Temp\2\~vsD4FE.sql
CREATE PROCEDURE [dbo].[SP_GET_PAYITEM]
@AccountID varchar(10),
@Unknown int
AS
BEGIN
SET NOCOUNT ON
DECLARE @ItemGetCount INT
IF EXISTS (SELECT * FROM T_PAYITEM_COUNT WHERE AccountID = @AccountID)
BEGIN
SELECT @ItemGetCount = GetItemCount FROM T_PAYITEM_COUNT WHERE AccountID = @AccountID
IF (@ItemGetCount >= 6) -- You can change it for your own needs
BEGIN
SELECT 0 AS IsFirst, 3 AS ResultCode
END
ELSE
BEGIN
SELECT 0 AS IsFirst, 0 AS ResultCode
END
END
ELSE
BEGIN
SELECT 1 AS IsFirst, 0 AS ResultCode
END
END
SET NOCOUNT OFF
GO
Generated on SQL 2008.Code:USE [MU2003_EVENT_DATA]
GO
/****** Object: Table [dbo].[T_PAYITEM_COUNT] Script Date: 08/07/2010 00:15:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T_PAYITEM_COUNT](
[AccountID] [varchar](10) NOT NULL,
[GetItemCount] [int] NULL,
CONSTRAINT [PK_T_PAYITEM_COUNT] PRIMARY KEY CLUSTERED
(
[AccountID] 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
LOL, i'm too late xD!
edit:
Ema Leto, your procedure is wrong:
Original procedure takes two parameters ;]Code:0:17:51 SQLSTATE:42000, Ář´ÜÁ¤ş¸:[Microsoft][SQL Server Native Client 10.0][SQL Server]Procedure or function 'SP_GET_PAYITEM' expects parameter '@ServerCode', which was not supplied., Äő¸®ą®: EXEC SP_GET_PAYITEM 'Dudi', 1
btw:
gs uses EventItemBag53.txt for Santa Clause.
Thanks dudi!
itembags ;)
ItemBag53
ItemBag54Code://==========================================================================
//Translated & Archives of Data by Ema Leto
//Information of the file: Santa Event - Item Bag 1
//==========================================================================
//=====================================================================================
//Drop Options
//Name Zen Type Item Level Drop NorDrop ExcDrop
//=====================================================================================
1
"Santa Event" 30000 0 0 0 0 100 0
end
//==================================================================
//Item Drops
//Type Index MinLvl MaxLvl Skill Luck Opt Exc Name
//==================================================================
2
1000
12 15 0 0 0 0 0 0 //Jewel of Chaos
end
4000
13 0 0 0 0 0 0 0 //Guardian Angel
13 1 0 0 0 0 0 0 //Satan
end
4000
14 19 5 6 0 0 0 0 //Devil Square Invitation
13 18 6 7 0 0 0 0 //Invisibility Cloak
14 28 7 7 0 0 0 0 //Lost Map
13 51 4 5 0 0 0 0 //Scroll of Blood
end
and itembag55Code://==========================================================================
//Translated & Archives of Data by Ema Leto
//Information of the file: Santa Event - Item Bag 2
//==========================================================================
//=====================================================================================
//Drop Options
//Name Zen Type Item Level Drop NorDrop ExcDrop
//=====================================================================================
1
"Santa Event" 60000 0 0 0 0 100 0
end
//==================================================================
//Item Drops
//Type Index MinLvl MaxLvl Skill Luck Opt Exc Name
//==================================================================
2
10000
13 68 0 0 0 0 0 0 //Snowman Transformation Ring
14 99 0 0 0 0 0 0 //Christmas Firecracker
end
end
Lucky Coin have same producer i think.Code://==========================================================================
//Translated & Archives of Data by Ema Leto
//Information of the file: Santa Event - Item Bag 3
//==========================================================================
//=====================================================================================
//Drop Options
//Name Zen Type Item Level Drop NorDrop ExcDrop
//=====================================================================================
1
"Santa Event" 90000 0 0 0 0 100 0
end
//==================================================================
//Item Drops
//Type Index MinLvl MaxLvl Skill Luck Opt Exc Name
//==================================================================
2
10000
13 67 0 0 0 0 0 0 //Pet Rudolf
end
end
For lucky coin works:
Item Bag 56, 57 and 58
56 its for exchange of 10 coin
57 for 20 and 58 for 30
npc are delgado, but Golden Archer replace this npc
i can register luck coins, but when you touch the button dont give a item XD.
Missing procedure :)
Edit: now es dont give error, and in client show message for imte gift, but dont recive nothing T_T
Here is C1 18 F8 07 packet STRUCT. Header is 4 byte long.Quote:
//0xC1,0x18,0xF8,0x07,0x01,0x00,0x00,0x00,0x6E,0x01,0x00,0x00,0x06,0x00,0x00,0x00,0x00,0x00,0x00,0x00,0xE8,0x03,0x00,0x00
struct PMSG_GENS_INFO
{
PGMSG_HEADER h;
int GensType; //4
int Ranking; //8
int Symbol; //12
int Contribution; //16
int NextContrib; //20
};
Credits : Me
still crashing. can u upload main crack in other host ?
The No sound version is being uploaded in rapidshare,megaupload,filefront, so it takes a while.
---------- Post added at 02:02 AM ---------- Previous post was at 12:07 AM ----------
Client 1.3A+ Jpn Full (Season5 Part3) No Sound Crack
Download Season5_Part3_Jpn(1.03A+)_Crack.rar
RapidShare: 1-CLICK Web hosting - Easy Filehosting
MEGAUPLOAD - The leading online storage and file delivery service
ClientIP = 127.0.0.1
ClientExeVersion = 1.03.27 (1.3A+)
ClientExeSerial = ResonanceS5EP3JP
※Change log
1.Main.exe Cracked
2.Fix Master Level Show
or post original links of 1.03A+ full client
---------- Post added at 02:09 AM ---------- Previous post was at 02:06 AM ----------
main 1.03A+ uncrack not modified
http://www.toxicmu.com/main/
MU Itemshop is disabled in 1.03A+ JPN :(
There isn't disabled, new Item Shop uses different protocol
(headcode 0xD2, old uses 0xF5). So it not work.
Dudi, works santa event? :P
Here is Thanks giving Event
Monsters:
Config of Drop - Lunar RabbitCode://Thanksgiving Event
//======================================================================================================================================================================================================================================================================
//Numb Rate Name Level HP MP MinDmg MaxDmg Def MagDef Attack Success Move AttType Range View MoveSpeed AttSpeed Regen Attri ItemR MoneyR MaxI ResWind ResPois ResIce ResWater ResFire
//======================================================================================================================================================================================================================================================================
413 1 "Lunar Rabbit" 70 25000 0 0 0 100 0 0 100 3 0 0 1 100 0 120 1 200 10 0 0 254 254 254 254
414 1 "Helper Ellen" 90 10000 0 180 195 70 20 300 100 5 0 5 5 400 1500 10 1 200 10 0 0 0 0 0 0
EventItemBag46:
Config of Helper EllenCode://==========================================================================
//Translated & Archives of Data by Ema Leto
//Information of the file: Moon Harvest - Lunar Rabbit
//==========================================================================
//=========================
//Map Drop
//Map Drop Min Max
//=========================
0
0 0 0 1000 //Lorencia
1 0 0 1000 //Dungeon
2 0 0 1000 //Devias
3 0 0 1000 //Noria
4 0 0 1000 //LostTower
5 0 0 1000 //Exile
6 0 0 1000 //Arena
7 0 0 1000 //Atlans
8 0 0 1000 //Tarkan
9 0 0 1000 //DevilSquare
10 0 0 1000 //Icarus
end
//=====================================================================================
//Drop Options
//Name Zen Type Item Level Drop NorDrop ExcDrop
//=====================================================================================
1
"Moon Harvest" 30000 0 0 0 0 100 1
end
//==================================================================
//Item Drops
//Type Index MinLvl MaxLvl Skill Luck Opt Exc Name
//==================================================================
2
2300
5 2 0 0 1 0 0 1 //Serpent Staff
5 3 0 0 1 0 0 1 //Thunder Staff
1 3 0 0 1 0 0 1 //Tomahawk
0 5 0 0 1 0 0 1 //Blade
4 4 0 0 1 0 0 1 //Tiger Bow
4 12 0 0 1 0 0 1 //Serpent Crossbow
2 8 0 0 1 0 0 1 //Battle Scepter
7 6 0 0 0 0 0 1 //Scale Helm
8 6 0 0 0 0 0 1 //Scale Armor
9 6 0 0 0 0 0 1 //Scale Pants
10 6 0 0 0 0 0 1 //Scale Gloves
11 6 0 0 0 0 0 1 //Scale Boots
7 7 0 0 0 0 0 1 //Sphinx Mask
8 7 0 0 0 0 0 1 //Sphinx Armor
9 7 0 0 0 0 0 1 //Sphinx Pants
10 7 0 0 0 0 0 1 //Sphinx Gloves
11 7 0 0 0 0 0 1 //Sphinx Boots
7 12 0 0 0 0 0 1 //Wind Helm
8 12 0 0 0 0 0 1 //Wind Armor
9 12 0 0 0 0 0 1 //Wind Pants
10 12 0 0 0 0 0 1 //Wind Gloves
11 12 0 0 0 0 0 1 //Wind Boots
6 5 0 0 1 0 0 1 //Dragon Slayer Shield
6 11 0 0 1 0 0 1 //Serpent Shield
end
500
5 5 0 0 1 0 0 1 //Legendary Staff
4 14 0 0 1 0 0 1 //Aquagold Crossbow
2 5 0 0 1 0 0 1 //Crystal Sword
0 14 0 0 1 0 0 1 //Lightning Sword
2 9 0 0 1 0 0 1 //Master Scepter
7 1 0 0 0 0 0 1 //Dragon Helm
10 1 0 0 0 0 0 1 //Dragon Gloves
11 1 0 0 0 0 0 1 //Dragon Boots
7 14 0 0 0 0 0 1 //Guardian Helm
10 14 0 0 0 0 0 1 //Guardian Gloves
11 14 0 0 0 0 0 1 //Guardian Boots
7 3 0 0 0 0 0 1 //Legendary Helm
8 3 0 0 0 0 0 1 //Legendary Gloves
10 3 0 0 0 0 0 1 //Legendary Boots
7 26 0 0 0 0 0 1 //Adamantine Mask
10 26 0 0 0 0 0 1 //Adamantine Gloves
11 26 0 0 0 0 0 1 //Adamantine Boots
6 13 0 0 1 0 0 1 //Chaos Dragon Shield
6 14 0 0 1 0 0 1 //Legendary Shield
end
100
12 15 0 0 0 0 0 0 //Jewel of Chaos
end
50
14 14 0 0 0 0 0 0 //Jewel of Soul
end
30
14 22 0 0 0 0 0 0 //Jewel of Creation
end
20
14 13 0 0 0 0 0 0 //Jewel of Bless
end
end
EventItemBag47
Monsters of the Event.Code://==========================================================================
//Translated & Archives of Data by Ema Leto
//Information of the file: Moon Harvest 2 - Helper Ellen
//==========================================================================
//=========================
//Map Drop
//Map Drop Min Max
//=========================
0
0 0 0 1000 //Lorencia
1 0 0 1000 //Dungeon
2 0 0 1000 //Devias
3 0 0 1000 //Noria
4 0 0 1000 //LostTower
5 0 0 1000 //Exile
6 0 0 1000 //Arena
7 0 0 1000 //Atlans
8 0 0 1000 //Tarkan
9 0 0 1000 //DevilSquare
10 0 0 1000 //Icarus
end
//=====================================================================================
//Drop Options
//Name Zen Type Item Level Drop NorDrop ExcDrop
//=====================================================================================
1
"Helper Ellen" 200000 0 0 0 0 100 1
end
//==================================================================
//Item Drops
//Type Index MinLvl MaxLvl Skill Luck Opt Exc Name
//==================================================================
2
5000
13 1 0 0 0 0 0 0 //Satan
2500
12 15 0 0 0 0 0 0 //Jewel of Chaos
end
Put this in MonsterSetBase
Fortune Puch EventCode://==========================================================================
//Events - Mobs - Thanksgiving Event
//Mob Map Rad X Y X2 Y2 Dir Amount Name
//==========================================================================
3
413 37 30 1 1 255 255 -1 25 //Lunar Rabbit
413 33 30 1 1 255 255 -1 25 //Lunar Rabbit
413 8 30 1 1 255 255 -1 25 //Lunar Rabbit
413 4 30 1 1 255 255 -1 25 //Lunar Rabbit
413 7 30 1 1 255 255 -1 15 //Lunar Rabbit
end
//==================================================
//Events - Npcs - Thanksgiving Event
//Mob Map Rad X Y Dir Name
//==================================================
0
414 51 0 48 222 3 //Helper Ellen
end
MonsterSetBase:
EventItemBag37:Code://==========================================================================
//Events - Fortune Pouch
//Mob Map Rad X Y X2 Y2 Dir Amount Name
//==========================================================================
3
365 37 30 1 1 255 255 -1 25 //Fortune Pouch
365 33 30 1 1 255 255 -1 25 //Fortune Pouch
365 8 30 1 1 255 255 -1 25 //Fortune Pouch
365 4 30 1 1 255 255 -1 25 //Fortune Pouch
365 7 30 1 1 255 255 -1 15 //Fortune Pouch
end
Option in CommonServer for works:Code://==========================================================================
//Translated & Archives of Data by Ema Leto
//Information of the file: New Year - Fortune Pouch
//==========================================================================
//=========================
//Map Drop
//Map Drop Min Max
//=========================
0
0 0 0 1000 //Lorencia
1 0 0 1000 //Dungeon
2 0 0 1000 //Devias
3 0 0 1000 //Noria
4 0 0 1000 //LostTower
5 0 0 1000 //Exile
6 0 0 1000 //Arena
7 0 0 1000 //Atlans
8 0 0 1000 //Tarkan
9 0 0 1000 //DevilSquare
10 0 0 1000 //Icarus
end
//=====================================================================================
//Drop Options
//Name Zen Type Item Level Drop NorDrop ExcDrop
//=====================================================================================
1
"New Year" 10000 0 0 0 0 100 1
end
//==================================================================
//Item Drops
//Type Index MinLvl MaxLvl Skill Luck Opt Exc Name
//==================================================================
2
295
13 2 0 0 0 0 0 0 //Horn of Uniria
13 0 0 0 0 0 0 0 //Guardian Angel
14 20 0 0 0 0 0 0 //Remedy of Love
14 9 1 1 0 0 0 0 //Olive of Love
end
60
13 1 0 0 0 0 0 0 //Satan
13 3 0 0 0 0 0 0 //Horn of Dinorant
end
30
12 15 0 0 0 0 0 0 //Jewel of Chaos
14 14 0 0 0 0 0 0 //Jewel of Soul
end
15
14 13 0 0 0 0 0 0 //Jewel of Bless
14 22 0 0 0 0 0 0 //Jewel of Life
end
end
NewYearLuckyBagMonsterEventOn =1
This works perfect with the itembags.
Dont delete credits please :).
thanks ema
btw
hey dudi, can u correct the procedures for santa event?
thanks :P
summoner skill tree works in 1.03A+ JPN main
It's not a big difference if struct will look like thisQuote:
the GensType is a BYTE variable, not one int, look at main...
or like thisCode:struct PMSG_GENS_INFO
{
PGMSG_HEADER h;
BYTE GensType; //4
BYTE null1;
BYTE null2;
BYTE null3;
int Ranking; //8
int Symbol; //12
int Contribution; //16
int NextContrib; //20
};
This last 3 bytes are not used in protocol...Code:struct PMSG_GENS_INFO
{
PGMSG_HEADER h;
int GensType; //4
int Ranking; //8
int Symbol; //12
int Contribution; //16
int NextContrib; //20
};
Thanks ToMMeG... this is very useful
I have one problem with gens... When i join a Gen, I don't see the gen symbol next to the name of the character
Someone have GenSystem source? please^^