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

Quote:

---

Originally Posted by michael_admin

your can post link download for the code sql

Thanks

---

Code:

---

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

---

Quote:

---

Originally Posted by allexander

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)

Hi how to disable summonera?

Quote:

---

Originally Posted by Luis_br

Code:

---

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.

Quote:

---

Originally Posted by xpam

Hi how to disable summonera?

---

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

offset disable summon button in create character interface

Quote:

---

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

---

Quote:

---

Originally Posted by ikenylee

offset disable summon button in create character interface

---

if not hard you can make can guide ?

Quote:

---

Originally Posted by michael_admin

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

Quote:

---

Originally Posted by allexander

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

Quote:

---

Originally Posted by xpam

Hi how to disable summonera?

---

on file Gameserverinfo - Common

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

Quote:

---

Originally Posted by Luis_br

Season 8 work fine

---

I test S8 and S6 i have bug

you have script por it?

yo can give me?

Thx

Quote:

---

Originally Posted by Luis_br

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'."

Quote:

---

Originally Posted by Luis_br

Season 8 work fine

---

[2] Assist Master in S8 is not working

Check print-screen attached

Quote:

---

Originally Posted by muzic25

The Npc is ok but said no quest....
I'm trying to figuring out the Quest ID...

---

[3] muzic25 have you done any progress?

Quote:

---

Originally Posted by allexander

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

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

Quote:

---

Originally Posted by nofeara

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

---

Quote:

---

Originally Posted by natzugen

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

Quote:

---

Originally Posted by natzugen

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. :)

Quote:

---

Originally Posted by allexander

[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 :):