[Release] Heaven's Bazaar

[HeavenOnlyWishes]

Heaven's Bazaar

Before we get on with this "tell all", let me first say, I do not and will not give support for any of the releases from other developers nor the server files themselves. If you have questions pertaining to either of those two items, please ask the person who developed them. I will however answer any questions that pertain to modification of the databases or any lua scripting questions. I will continue to update this when I have the free time. Updates will include all of my stuff, SQL related and scripts that I had released in the past and any that I decide to make in the future. Many of the things listed here are all based on queries and scripts I designed ages ago, if you weren't around back then, then please save your complaints for someone who cares.

Please note that the following is based on the most current server files (8.1), older versions of the server files may have difficulty operating, unless listed as backwards compatible.

The following will be documented and fully tutorial-ed for your convenience.


SQL Queries:

These queries are designed to help you sift through the massive databases to help find specific articles.

Step 1) Open MSSQL and login.
Step 2) Select New Query from the top menu.
Step 3) Copy and Paste one of the following into the New Query window.
Step 4) Click Execute from the top menu.

 Spoiler

Replacement Queries:

Create New Player Account:
The following fields must be replaced with your own information:

• account_id
• account_name
• account_password
• account_email

 Spoiler

USE Auth
INSERT INTO Account(account_id,account,password,email,pk_,creationDate_,updateDate_,creatorId_,updatorId_,portId_,type_,accessDate_,password2)
VALUES(account_id,'account_name','account_password','account_email',1,NULL,NULL,NULL,NULL,NULL,'com.elixir.billing.impl.ImmAccount',NULL,NULL)

Search Queries:

Items:
Lists Item ID and Item Name in Ascending order by the Item's ID.

 Spoiler

SELECT ITEM.id, item.name_id, STRING.value
FROM Arcadia.dbo.ItemResource ITEM, Arcadia.dbo.StringResource STRING
WHERE item.name_id = string.code
ORDER BY id ASC

Quests:
Lists Quest ID and Quest Name in Ascending order by Quest's ID.

 Spoiler

SELECT QUEST.id, quest.text_id_quest, STRING.value
FROM Arcadia.dbo.QuestResource QUEST, Arcadia.dbo.StringResource STRING
WHERE quest.text_id_quest = string.code
ORDER BY id ASC

NPCs:
Lists NPC ID and NPC Title in Ascending order by NPC's ID.

 Spoiler

SELECT NPC.id, npc.text_id, STRING.value
FROM Arcadia.dbo.NPCResource NPC, Arcadia.dbo.StringResource STRING
WHERE npc.text_id = string.code
ORDER BY id ASC

Summons:
Lists Summon ID and Summon Name in Ascending order by Summon's ID.

 Spoiler

SELECT SUMMON.id, summon.name_id, STRING.value
FROM Arcadia.dbo.SummonResource SUMMON, Arcadia.dbo.StringResource STRING
WHERE summon.name_id = string.code
ORDER BY id ASC

Skills:
Lists Skill ID and Skill Name in Ascending order by Skill's ID.

 Spoiler

SELECT SKILL.id, skill.text_id, STRING.value
FROM Arcadia.dbo.SkillResource SKILL, Arcadia.dbo.StringResource STRING
WHERE skill.text_id = string.code
ORDER BY id ASC

States:
Lists State ID and State Name in Ascending order by State's ID.

 Spoiler

SELECT STATE.state_id, state.text_id, STRING.value
FROM Arcadia.dbo.StateResource STATE, Arcadia.dbo.StringResource STRING
WHERE state.text_id = string.code
ORDER BY state_id ASC

Jobs:
Lists Job ID and Job Title in Ascending order by Job's ID.

 Spoiler

SELECT JOB.id, job.text_id, STRING.value
FROM Arcadia.dbo.JobResource JOB, Arcadia.dbo.StringResource STRING
WHERE job.text_id = STRING.code
ORDER BY id ASC

Field Props:
Lists Field Prop ID and Field Prop Name in Ascending order by Field Prop's ID.

 Spoiler

SELECT PROPP.id, propp.text_id, STRING.value
FROM Arcadia.dbo.FieldPropResource PROPP, Arcadia.dbo.StringResource STRING
WHERE propp.text_id = string.code
ORDER BY id ASC

Item and Drop Groups:
Lists various Item information and what Drop Groups that item is in. Replace change_item_id with the ID of the Item you wish to view.

 Spoiler

DECLARE @ITEM_ID int = change_item_id

DECLARE @ITEM int = (SELECT id FROM ItemResource WHERE id = @ITEM_ID)
DECLARE @name_id int = (SELECT name_id FROM ItemResource WHERE id = @ITEM )
DECLARE @tooltip_id int = (SELECT tooltip_id FROM ItemResource WHERE id = @ITEM)
DECLARE @ITEM_N VARCHAR(60) = (SELECT value FROM StringResource WHERE code = @name_id)
DECLARE @ITEM_T VARCHAR(255) = (SELECT value FROM StringResource WHERE code = @tooltip_id)
SELECT id AS "Item ID",@ITEM_N AS "Item Name",@ITEM_T AS "Description",[level] AS "Level",class AS "Class Required",rank AS "Item Rank",use_min_level AS "Min Level Required",use_max_level AS "Max Level Allowed",price AS "Price" FROM itemresource where id = @ITEM
SELECT * FROM DropGroupResource WHERE 
(drop_item_id_00 = @ITEM) OR (drop_item_id_01 = @ITEM) OR (drop_item_id_02 = @ITEM) OR (drop_item_id_03 = @ITEM) OR (drop_item_id_04 = @ITEM)
OR (drop_item_id_05 = @ITEM) OR (drop_item_id_06 = @ITEM) OR (drop_item_id_07 = @ITEM) OR (drop_item_id_08 = @ITEM) OR (drop_item_id_09 = @ITEM)

Note 1: Search Terms

 Spoiler

You can add the following just below the WHERE statement to search for specific terms on any of the following search queries:

AND value LIKE'%search_term%'

This can be further minipulated by adding a % between multiple terms to narrow down your search, for example: %stamina% will only search for items that have the word Stamina in the value, where as, %stamina%saver% will search for items that have both the words Stamina and Saver in their values.

Note 2: Add More Fields to Your Search

 Spoiler

You can increase the fields that the queries pull from each table by adding into the SELECT line, for example, say you wanted to know the card_id as well as the name and id of a summon, you would simply add summon.card_id, to the SELECT line of the query. Thus it would look like this:

SELECT SUMMON.id, summon.name_id, STRING.value, summon.card_id

Note 3: Search For More Than Just Names

 Spoiler

You can even run searches on things other than an item's name, for instance, if you wanted the description instead, you would simply replace item.name_id with item.tooltip_id both in the SELECT line and the WHERE line, as shown here:

SELECT ITEM.id, item.tooltip_id, STRING.value
FROM Arcadia.dbo.ItemResource ITEM, Arcadia.dbo.StringResource STRING
WHERE item.tooltip_id = string.code

Note 4: Sorting Your Searches

 Spoiler

You can sort your searches by adding the following at the end of the query:

ORDER BY something ASC

'something' can be any field that you have included in the SELECT criteria, for example the item's id or even values.

LUA Scripts:

The following scripts are my own personal creations, as such anyone can use them, however, I only ask that you give me credit when you do.

 Spoiler

Automated Buffing Systems:

Please note that these were made for the 6.3 Server Files, and while they will still work for the most part with current 7.4 and 8.1 Server Files, some functionality is not going to.

Rappelz 6.3 Scripts: Not compatible with server files above 6.3

 Spoiler

-- Server Files 6.3

-- Server Files 6.3

-- Server Files 6.3

-- Server Files 6.3

NPC Buff System:

This a configurable NPC Buff System. You can easily modify the costs and the multiplier for each buff. The system is setup to allow 3 tiers of buff, allowing players to choose from 1 of 3 different buff multipliers. Including 12 different buffs and the option to purchase all buffs at once. The instructions for setup are in the script.

-- Server Files 8.1

Tid-Bits:

This is just a few things I found quite interesting, and thought you might be interested to know.

 Spoiler

States:

State ID	State Name	State Effect
2002	Steals MP	Recovers +520 MP with a 51% chance on strike.
2003	Absorbs HP	Recovers 3% HP based on DMG with a 100% chance.
1302	Limitless	+999 to All Main Stats.
1301	Can't Touch This	Reflects 10,000,000 DMG 100% when attacked.
2051	Hunting Creature Card	Increases creature card drop rate.
314015	Immortality	HP Cannot drop below 1; HP cannot drop below 0%

[Pyrochina]

Hi! Thank you so much for these scripts. I just have a little question, what are the three codes of this: (Codes taken from Stage two)

add_state(164407--> Buff ID,500 --> ???,8640000--> ???) -- Halisha +1000

[ThunderNikk]

Originally Posted by Pyrochina

Hi! Thank you so much for these scripts. I just have a little question, what are the three codes of this: (Codes taken from Stage two)

add_state(164407--> Buff ID,500 --> ???,8640000--> ???) -- Halisha +1000

Should be add_state(Buff_ID, Buff_Level, Buff_Duration)

[Pyrochina]

Would this work instead?

add_event_state(Buff ID ,Buff Lvl)

[ThunderNikk]

Originally Posted by Pyrochina

Would this work instead?

add_event_state(Buff ID ,Buff Lvl)

That should give a server wide buff as an event state it will effect everyone who logs on the same. No time duration.

[Pyrochina]

That's what I want thndr can you go on the help thread i have question

[HeavenOnlyWishes]

Yes, you can use the add_event_state() and remove_event_state() built in functions instead of add_state(); These scripts were designed before the add_event_state() function was built into the game system.

I'll make a new version of the Automated Buff System here soon that's made for the newest files soon. As well as a Buff NPC script, and post them.

[Pyrochina]

Hi! I don't know if you could help me make a simple buff for everyone on log in buff script and set it up to work because none of these work for me. Contact me on Skepy

[ThunderNikk]

Add the following to server_init (b4e51c7c6f9cd671cf2bb33b2aa2d263).lua

At the top of the .lua script add this...

        ServerBuff()

In with what is already there...

function on_server_init()
	roaming()
	rare_mob()
	guardian_spawn()
	random_respawn()
end

So it looks like this...

function on_server_init()
	roaming()
	rare_mob()
	guardian_spawn()
	random_respawn()
        ServerBuff()
end

And at the bottom of the script add the buff function...

function ServerBuff()
        add_event_state(1013,20)
        add_event_state(1007,15)
        add_event_state(1008,15)
        add_event_state(1002,10)
        add_event_state(1001,10)
end

Restart your servers.

You can change the buffs and or buff levels all you want.

[HeavenOnlyWishes]

Or you can just add the add_event_state() statements. LUA in Rappelz doesn't require you to setup a function to run most of it's built in methods. And since on_server_init() is already a setup function, you can just add the statements to that function... rather than using a stacked function.

So it would look like this:

function on_server_init()
	roaming()
	rare_mob()
	guardian_spawn()
	random_respawn()
        add_event_state(1013,20)
        add_event_state(1007,15)
        add_event_state(1008,15)
        add_event_state(1002,10)
        add_event_state(1001,10)
end

[muhaadiga]

i just downloaded ABS Stage 3 Full for my 8.1 server i put the line on my own resource
as you said in instruction and i put the lua file but nothing works ?

[HeavenOnlyWishes]

Again.... these systems were designed for 6.3/6.4.... not the 8.1 server files, I can't guarantee that they will work with current server versions. The timers certainly wont....

I'll release new ones that are updated for the 8.1 server files probably some time today.

[Raigeka]

No your way is wrong
just do it like me

function get_module_name()
return "server_init"
end

function on_server_init()
roaming()
rare_mob()
guardian_spawn()
random_respawn()
ServerBuffs()
end

function ServerBuffs()
add_event_state(9948,10)
add_event_state(9947,5)
add_event_state(9946,5)
add_event_state(9945,1)
add_event_state(9944,1)
add_event_state(1101,99)
add_event_state(4553,1)
add_event_state(4003,1)
add_event_state(9923,1)
add_event_state(1013,40)
add_event_state(13423,350)
end

This work in my server 100%

[HeavenOnlyWishes]

Again.... An unnecessary function.... I'm a professional programmer, and I've been programming with LUA for the past 3 years.... Don't tell me I'm wrong, when I'm the one with 64 Thanks....



P.S. Updated Bazaar btw

[ThunderNikk]

Originally Posted by HeavenOnlyWishes

Again.... An unnecessary function.... I'm a professional programmer, and I've been programming with LUA for the past 3 years.... Don't tell me I'm wrong, when I'm the one with 64 Thanks....



P.S. Updated Bazaar btw

But your script does not work...



according to Pyrochina at least, I did not try it myself but since mine is scripted and mine is working I really had no need to try.