Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Release] X-Team Sources (S4, S6, S8)

Junior Spellweaver
Joined
Dec 27, 2007
Messages
195
Reaction score
0
Re: Source [MUEMU]

how to change languge offset to another languge like to Unicode ( UTF8 ) Ss8
 
Newbie Spellweaver
Joined
Dec 6, 2015
Messages
75
Reaction score
12
Re: Source [MUEMU]

I dont understand one thing.

To Fix bug when log in stuck on server select guide asks that disable #define ENCRYPT_STATE 0 // Change 1 by 0

But later shows up guide about antihack where need enable ENCRYPT_STATE to 1 again.. have i missed something again?
 
(づ。◕‿‿◕。)
Loyal Member
Joined
Jun 23, 2014
Messages
1,853
Reaction score
424
Re: Source [MUEMU]

if you want the encrypt you either change the mhpserver.ini path in gs or in mhp server and enable the encrypt in server and client
 
Novice C++
Joined
Feb 14, 2011
Messages
576
Reaction score
230
Re: Source [MUEMU]

I m trying to add Tercia Quests but i m struggle to understand how. If anyone can explain or post an example of first quest will be appreciated:

So here is QuestWorld
Code:
//======================================================================================================================================================================================================================================================================================================================
//Index   Group   Number   StartType   MonsterClass   CurrentState   NextIndex1   NextState1   NextIndex2   NextState2   NextIndex3   NextState3   RequireIndex   RequireGroup   RequireState   RequireMinLevel   RequireMaxLevel   RequireFamily   RequireCooldown   DW      DK      FE      MG      DL      SU      RF
//======================================================================================================================================================================================================================================================================================================================
0         20      0        0           566            0              1            1            *            *            *            *            *              *              *              350               400               *               *                 1       1       1       1       1       1       1
1         20      0        1           566            0              2            1            *            *            *            *            *              20             *              350               400               *               *                 1       1       1       1       1       1       1
2         20      0        1           566            0              4            2            *            *            *            *            *              20             *              350               400               *               *                 1       1       1       1       1       1       1
3         20      0        1           566            1              *            *            *            *            *            *            *              20             *              350               400               *               *                 1       1       1       1       1       1       1
4         20      0        1           566            2              *            *            *            *            *            *            *              20             *              350               400               *               *                 1       1       1       1       1       1       1

QuestWorldObjective:

Code:
//====================================================================================================================================================================================
//Number   Type   Index   Quantity   Level   Option1   Option2   Option3   NewOption   RequireIndex   RequireGroup   RequireState   DW      DK      FE      MG      DL      SU      RF
//====================================================================================================================================================================================
0          2      0       1000000    0       0         0         0         0           4              20             1              1       1       1       1       1       1       1

The dialog is working until requirements and reward panel then i m stuck....i tried to shuffle the states but with no success.
what i need to know:
State:
0- i suppose it is start
1- i suppose it is continue
2- i think is require
4- i do not know (i sea these used only in RequireState column
3- i do not know if there is a 3 and what is used for

StartType:
i can sea at all quests that this column is set to 0 but if i change it to 0 instead of one quest i can sea every Index as a single quest so i moved to 1 but if i change first Index to 1 the quest its not available anymore so i let Index 0 to 0 to be able to start the quest, i suppose is kind off similar to State.
what i need to know:
0- ?
1- ?
2- if it exist or any other
 
Last edited:
Junior Spellweaver
Joined
Apr 21, 2005
Messages
154
Reaction score
126
Re: Source [MUEMU]

your can post link download for the code sql

Thanks

Code:
CREATE function [dbo].[fn_rank_gens]
(
  [USER=1333344765]name[/USER] varchar(10),
  [USER=2000149960]familia[/USER] int
)
returns int
as
begin
declare @valor int;

set @valor = 0;

WITH cte AS (
SELECT DENSE_RANK() OVER (ORDER BY contribution DESC) AS Rank, Name
FROM Gens_Rank where family = [USER=2000149960]familia[/USER])
select @valor = rank from cte where Name =  [USER=1333344765]name[/USER];

return @valor;
end

ALTER PROCEDURE [dbo].[WZ_GetCharacterGensInfo]
  [USER=1333344765]name[/USER] varchar(10),
  [USER=2000148848]fami[/USER]ly int
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

IF (  [USER=2000148848]fami[/USER]ly = 1 )
BEGIN
SELECT dbo.fn_rank_gens  [USER=1333344765]name[/USER],1)as Rank, Contribution FROM Gens_Rank WHERE Name =  [USER=1333344765]name[/USER] and Family=1
END
ELSE
BEGIN
SELECT dbo.fn_rank_gens  [USER=1333344765]name[/USER],2)as Rank, Contribution FROM Gens_Rank WHERE Name =  [USER=1333344765]name[/USER] and Family=2
END

SET NOCOUNT OFF
SET XACT_ABORT OFF

END
 
Joined
Nov 29, 2009
Messages
507
Reaction score
92
Re: Source [MUEMU]

I m trying to add Tercia Quests but i m struggle to understand how. If anyone can explain or post an example of first quest will be appreciated:

So here is QuestWorld
Code:
//======================================================================================================================================================================================================================================================================================================================
//Index   Group   Number   StartType   MonsterClass   CurrentState   NextIndex1   NextState1   NextIndex2   NextState2   NextIndex3   NextState3   RequireIndex   RequireGroup   RequireState   RequireMinLevel   RequireMaxLevel   RequireFamily   RequireCooldown   DW      DK      FE      MG      DL      SU      RF
//======================================================================================================================================================================================================================================================================================================================
0         20      0        0           566            0              1            1            *            *            *            *            *              *              *              350               400               *               *                 1       1       1       1       1       1       1
1         20      0        1           566            0              2            1            *            *            *            *            *              20             *              350               400               *               *                 1       1       1       1       1       1       1
2         20      0        1           566            0              4            2            *            *            *            *            *              20             *              350               400               *               *                 1       1       1       1       1       1       1
3         20      0        1           566            1              *            *            *            *            *            *            *              20             *              350               400               *               *                 1       1       1       1       1       1       1
4         20      0        1           566            2              *            *            *            *            *            *            *              20             *              350               400               *               *                 1       1       1       1       1       1       1

QuestWorldObjective:

Code:
//====================================================================================================================================================================================
//Number   Type   Index   Quantity   Level   Option1   Option2   Option3   NewOption   RequireIndex   RequireGroup   RequireState   DW      DK      FE      MG      DL      SU      RF
//====================================================================================================================================================================================
0          2      0       1000000    0       0         0         0         0           4              20             1              1       1       1       1       1       1       1

The dialog is working until requirements and reward panel then i m stuck....i tried to shuffle the states but with no success.
what i need to know:
State:
0- i suppose it is start
1- i suppose it is continue
2- i think is require
4- i do not know (i sea these used only in RequireState column
3- i do not know if there is a 3 and what is used for

StartType:
i can sea at all quests that this column is set to 0 but if i change it to 0 instead of one quest i can sea every Index as a single quest so i moved to 1 but if i change first Index to 1 the quest its not available anymore so i let Index 0 to 0 to be able to start the quest, i suppose is kind off similar to State.
what i need to know:
0- ?
1- ?
2- if it exist or any other

RequireState:
0 = nothing
1 = accept
2 = cancel
3 = finish
4 = reject

StartType
0 = it means it will not be notified until you click the NPC
1 = it means you will have a notification if you meet lvl requirements for the quest, it will show a factorial near the mana orb thing, just like how you start the tutorial quest...

In requirements/objective/rewards:
Number
0
1
2
and so on.... they mean how requirements appear in your GUI.. like 0= Mon: bullfighter x 1/1,,,1=Item: Large Potion x 1/1,,,2= Level: Reach lvl 25 etc....

Type under Objective
1 = You are required to kill a monster
4 = You must possess this item

Type under Reward
1 = Experience Reward
2 = Zen Reward
4 = Item Reward
16 = Gens Contribution

Index for Objective
So if you have Type = 1 under Objective, the index must be a monster index example: 3 = Spider

So if you have Type =4 under Objective, the index must be an item index example: 7168 = apple

and the Quantity, of course its a quantity...

and the rest Level, Option 1, Option 2, Option 3, New Option would mean, item level, item skill, item luck, item option, and exc option index....

So if you say you already understand the questworld for tercia, can you share it to me, so that i will be able to test it.... I am puzzled by this right now, i can't seem to get the dialog(remember they are daily questsssss,not same for mon/tues/wed/thurs).. ohh btw, talking about the diaglog, as i have tested them, not all of them are actually correctly called, meaning if you accept the quest they will tell you its unfortunate that you cancelled, but the quest continues and if you meet the requirements you will get the reward... Example are the gens quest shared to us by michi/lordbilly/or whoever shared it first...If you noticed their dialog it is not correct but you get the quest..(although you can just edit it easily with questwords editor, not a big problem---but it's a lot)
 
Initiate Mage
Joined
Jul 20, 2011
Messages
3
Reaction score
0
Re: Source [MUEMU]

Hi how to disable summonera?
 
Novice C++
Joined
Feb 14, 2011
Messages
576
Reaction score
230
Re: Source [MUEMU]

Code:
CREATE function [dbo].[fn_rank_gens]
(
  @[I][B][URL="http://forum.ragezone.com/members/1333344765.html"]name[/URL][/B][/I] varchar(10),
  @[I][B][URL="http://forum.ragezone.com/members/2000149960.html"]familia[/URL][/B][/I] int
)
returns int
as
begin
declare @valor int;

set @valor = 0;

WITH cte AS (
SELECT DENSE_RANK() OVER (ORDER BY contribution DESC) AS Rank, Name
FROM Gens_Rank where family = @[I][B][URL="http://forum.ragezone.com/members/2000149960.html"]familia[/URL][/B][/I])
select @valor = rank from cte where Name =  @[I][B][URL="http://forum.ragezone.com/members/1333344765.html"]name[/URL][/B][/I];

return @valor;
end

ALTER PROCEDURE [dbo].[WZ_GetCharacterGensInfo]
  @[I][B][URL="http://forum.ragezone.com/members/1333344765.html"]name[/URL][/B][/I] varchar(10),
  @[I][B][URL="http://forum.ragezone.com/members/2000148848.html"]fami[/URL][/B][/I]ly int
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

IF (  @[I][B][URL="http://forum.ragezone.com/members/2000148848.html"]fami[/URL][/B][/I]ly = 1 )
BEGIN
SELECT dbo.fn_rank_gens  @[I][B][URL="http://forum.ragezone.com/members/1333344765.html"]name[/URL][/B][/I],1)as Rank, Contribution FROM Gens_Rank WHERE Name =  @[I][B][URL="http://forum.ragezone.com/members/1333344765.html"]name[/URL][/B][/I] and Family=1
END
ELSE
BEGIN
SELECT dbo.fn_rank_gens  @[I][B][URL="http://forum.ragezone.com/members/1333344765.html"]name[/URL][/B][/I],2)as Rank, Contribution FROM Gens_Rank WHERE Name =  @[I][B][URL="http://forum.ragezone.com/members/1333344765.html"]name[/URL][/B][/I] and Family=2
END

SET NOCOUNT OFF
SET XACT_ABORT OFF

END
[1] I m having some trouble with this query... anyone?

[2] Still no progress with new quests check attachement maybe someone know what i m doing wrong....i used as example a similar quest from gens, still stuck in reward & require panel.
 

Attachments

You must be registered for see attachments list
Last edited:
Junior Spellweaver
Joined
Apr 21, 2005
Messages
154
Reaction score
126
Re: Source [MUEMU]

thx

You have solution for it:

Hi

I have bug Season 6 Assist Master can't accept new members

Message Is not Guild Master

Thx

Season 8 work fine



[1] I m having some trouble with this query... anyone?

[2] Still no progress with new quests sea attach maybe someone know what i m doing wrong....i used as example a similar quest from gens, still stuck in reward & require panel.

Change ALTER PROCEDURE to CREATE PROCEDURE



Hi how to disable summonera?

on file Gameserverinfo - Common

find SUCreateType = 0 , change to SUCreateType = 1 and test
 
Novice C++
Joined
Feb 14, 2011
Messages
576
Reaction score
230
Re: Source [MUEMU]

Change ALTER PROCEDURE to CREATE PROCEDURE

[1] This is not changing anything already tried that by deleting old procedure + old function.... i have the same error:

"Incorrect syntax near '@name'."

Season 8 work fine

[2] Assist Master in S8 is not working

Check print-screen attached

The Npc is ok but said no quest....
I'm trying to figuring out the Quest ID...
[3] muzic25 have you done any progress?
 

Attachments

You must be registered for see attachments list
Last edited:
Joined
Nov 29, 2009
Messages
507
Reaction score
92
Re: Source [MUEMU]

[1] This is not changing anything already tried that by deleting old procedure + old function.... i have the same error:

"Incorrect syntax near '@name'."

[3] muzic25 have you done any progress?

Uhm, the gens contribution and icon changing is function even with that error...

Uhm, can you share me you questworldtextfile for tercia quest... I just wanna test it.. Thanks.
 
(づ。◕‿‿◕。)
Loyal Member
Joined
Jun 23, 2014
Messages
1,853
Reaction score
424
Re: Source [MUEMU]

even if you add the quest on the configs if the npc is missing in npctalk function it wont work.
 
Novice C++
Joined
Feb 14, 2011
Messages
576
Reaction score
230
Re: Source [MUEMU]

Uhm, the gens contribution and icon changing is function even with that error...

Uhm, can you share me you questworldtextfile for tercia quest... I just wanna test it.. Thanks.
This quest is for "Wandering Merchant Zyro"

QuestWorld:

Code:
//Test
//Index   Group   Number   StartType   MonsterClass   CurrentState   NextIndex1   NextState1   NextIndex2   NextState2   NextIndex3   NextState3   RequireIndex   RequireGroup   RequireState   RequireMinLevel   RequireMaxLevel   RequireFamily   RequireCooldown   DW      DK      FE      MG      DL      SU      RF
//======================================================================================================================================================================================================================================================================================================================
20        20      1        0           568            0              22           1            21           2            *            *            *              *              *              1                 702               *               *                 1       1       1       1       1       1       1
20        20      1        0           568            0              22           1            21           2            *            *            20             20             0              1                 702               *               *                 1       1       1       1       1       1       1
20        20      1        0           568            0              22           1            21           2            *            *            20             20             4              1                 702               *               *                 1       1       1       1       1       1       1
21        20      1        0           568            2              *            *            *            *            *            *            21             20             2              *                 *                 *               *                 1       1       1       1       1       1       1
21        20      1        0           568            2              *            *            *            *            *            *            21             20             4              1                 702               *               *                 1       1       1       1       1       1       1
22        20      1        1           568            1              *            *            *            *            *            *            22             20             1              *                 *                 *               *                 1       1       1       1       1       1       1
22        20      1        1           568            1              *            *            *            *            *            *            22             20             4              1                 702               *               *                 1       1       1       1       1       1       1

QuestWorldObjective:

Code:
//Test
//====================================================================================================================================================================================
//Number   Type   Index   Quantity   Level   Option1   Option2   Option3   NewOption   RequireIndex   RequireGroup   RequireState   DW      DK      FE      MG      DL      SU      RF
//====================================================================================================================================================================================
0          4      7322    10         0       0         0         0         0           22             20             1              1       1       1       1       1       1       1

QuestWorldReward

Code:
0          4      7320    1          0       0         0         0         0           22             20             1              1       1       1       1       1       1       1 
1          4      7325    1          0       0         0         0         0           22             20             1              1       1       1       1       1       1       1

even if you add the quest on the configs if the npc is missing in npctalk function it wont work.

of course fix from muzic25 is needed
 
Last edited:
Back
Top