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

[Luis_br]

your can post link download for the code sql

Thanks

CREATE function [dbo].[fn_rank_gens]
(
  @name varchar(10),
  @familia 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 = @familia)
select @valor = rank from cte where Name =  @name;

return @valor;
end

ALTER PROCEDURE [dbo].[WZ_GetCharacterGensInfo]
  @name varchar(10),
  @family int
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

IF (  @family = 1 )
BEGIN
SELECT dbo.fn_rank_gens  @name,1)as Rank, Contribution FROM Gens_Rank WHERE Name =  @name and Family=1
END
ELSE
BEGIN
SELECT dbo.fn_rank_gens  @name,2)as Rank, Contribution FROM Gens_Rank WHERE Name =  @name and Family=2
END

SET NOCOUNT OFF
SET XACT_ABORT OFF

END

[nofeara]

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

//======================================================================================================================================================================================================================================================================================================================
//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:

//====================================================================================================================================================================================
//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)

[xpam]

Hi how to disable summonera?

[allexander]

CREATE function [dbo].[fn_rank_gens]
(
  @name varchar(10),
  @familia 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 = @familia)
select @valor = rank from cte where Name =  @name;

return @valor;
end

ALTER PROCEDURE [dbo].[WZ_GetCharacterGensInfo]
  @name varchar(10),
  @family int
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

IF (  @family = 1 )
BEGIN
SELECT dbo.fn_rank_gens  @name,1)as Rank, Contribution FROM Gens_Rank WHERE Name =  @name and Family=1
END
ELSE
BEGIN
SELECT dbo.fn_rank_gens  @name,2)as Rank, Contribution FROM Gens_Rank WHERE Name =  @name 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.

[LarvasFaint]

Hi how to disable summonera?

http://forum.ragezone.com/f82/disabl...nt-im-1102116/

[ikenylee]

offset disable summon button in create character interface

SetByte(0x00403112 + 3, 5); // Create character max chars (default: 6)

[xpam]

offset disable summon button in create character interface

if not hard you can make can guide ?

[Luis_br]

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

- - - Updated - - -

[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

- - - Updated - - -

Hi how to disable summonera?

on file Gameserverinfo - Common

find SUCreateType = 0 , change to SUCreateType = 1 and test

[michael_admin]

Season 8 work fine

I test S8 and S6 i have bug

you have script por it?

yo can give me?

Thx

[allexander]

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?

[nofeara]

[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.

[Natzugen]

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

[allexander]

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:

//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:

//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

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

[RevolGaming]

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

A simple copy paste to add it into the source and ofc change the npc id. :)

[muzic25]

[3] muzic25 have you done any progress?

Sorry everyone i don't have much time to wrote the Elemental/Tercia/Zyro quest's and fixing bugs on the source
but don't worry if i have some free time I'll post some things