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

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.

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

Quote:

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.

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:

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:

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.

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.

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.

Bazaar hack, any still work?I&#39;ve asked some friends to help me find them and they said mastly all of them are taken down because they don&#39;t work. also SE flags you when you use...
0 Replies - Final Fantasy XI