- Joined
- Apr 21, 2005
- Messages
- 154
- Reaction score
- 126
Re: Source [MUEMU]
How to allow pk move?
How to allow pk move?
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!//======================================================================================================================================================================================================================================================================================================================
//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
//====================================================================================================================================================================================
//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
your can post link download for the code sql
Thanks
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
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
[1] I m having some trouble with this query... anyone?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
http://forum.ragezone.com/f82/disable-summoner-maps-client-im-1102116/Hi how to disable summonera?
SetByte(0x00403112 + 3, 5); // Create character max chars (default: 6)
offset disable summon button in create character interface
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
[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.
Hi how to disable summonera?
Season 8 work fine
Change ALTER PROCEDURE to CREATE PROCEDURE
Season 8 work fine
[3] muzic25 have you done any progress?The Npc is ok but said no quest....
I'm trying to figuring out the Quest ID...
[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?
This quest is for "Wandering Merchant Zyro"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.
//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
//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
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.
even if you add the quest on the configs if the npc is missing in npctalk function it wont work.
[3] muzic25 have you done any progress?