|
You last visited: Today at 08:01
Advertisement
[Release] Heaven's Bazaar
Discussion on [Release] Heaven's Bazaar within the Rappelz Private Server forum part of the Rappelz category.
05/12/2013, 03:00
|
#1
|
elite*gold: 0
Join Date: Jul 2011
Posts: 236
Received Thanks: 74
|
[Release] Heaven's Bazaar
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.
Replacement Queries:
Create New Player Account:
The following fields must be replaced with your own information: - account_id
- account_name
- account_password
- account_email
Code:
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.
Code:
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.
Code:
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.
Code:
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.
Code:
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.
Code:
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.
Code:
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.
Code:
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.
Code:
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.
Code:
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
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.
Note 2: Add More Fields to Your Search
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:
Quote:
SELECT SUMMON.id, summon.name_id, STRING.value, summon.card_id
|
Note 3: Search For More Than Just Names
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:
Quote:
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
You can sort your searches by adding the following at the end of the query:
Quote:
' 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.
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
-- 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.
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% |
|
|
|
05/12/2013, 12:42
|
#2
|
elite*gold: 0
Join Date: May 2013
Posts: 43
Received Thanks: 1
|
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
|
|
|
05/12/2013, 14:32
|
#3
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,780
Received Thanks: 1,461
|
Quote:
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)
|
|
|
05/12/2013, 15:27
|
#4
|
elite*gold: 0
Join Date: May 2013
Posts: 43
Received Thanks: 1
|
Would this work instead?
add_event_state(Buff ID ,Buff Lvl)
|
|
|
05/12/2013, 15:52
|
#5
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,780
Received Thanks: 1,461
|
Quote:
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.
|
|
|
05/12/2013, 16:21
|
#6
|
elite*gold: 0
Join Date: May 2013
Posts: 43
Received Thanks: 1
|
That's what I want thndr can you go on the help thread i have question
|
|
|
05/12/2013, 17:56
|
#7
|
elite*gold: 0
Join Date: Jul 2011
Posts: 236
Received Thanks: 74
|
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.
|
|
|
05/23/2013, 02:02
|
#8
|
elite*gold: 0
Join Date: May 2013
Posts: 43
Received Thanks: 1
|
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
|
|
|
05/23/2013, 02:23
|
#9
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,780
Received Thanks: 1,461
|
Add the following to server_init (b4e51c7c6f9cd671cf2bb33b2aa2d263).lua
At the top of the .lua script add this...
In with what is already there...
Code:
function on_server_init()
roaming()
rare_mob()
guardian_spawn()
random_respawn()
end
So it looks like this...
Code:
function on_server_init()
roaming()
rare_mob()
guardian_spawn()
random_respawn()
ServerBuff()
end
And at the bottom of the script add the buff function...
Code:
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.
|
|
|
05/24/2013, 01:25
|
#10
|
elite*gold: 0
Join Date: Jul 2011
Posts: 236
Received Thanks: 74
|
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:
Code:
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
|
|
|
05/25/2013, 13:35
|
#11
|
elite*gold: 0
Join Date: May 2013
Posts: 11
Received Thanks: 0
|
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 ?
|
|
|
05/25/2013, 17:32
|
#12
|
elite*gold: 0
Join Date: Jul 2011
Posts: 236
Received Thanks: 74
|
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.
|
|
|
05/25/2013, 19:31
|
#13
|
elite*gold: 0
Join Date: May 2013
Posts: 2
Received Thanks: 0
|
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%
|
|
|
05/25/2013, 19:36
|
#14
|
elite*gold: 0
Join Date: Jul 2011
Posts: 236
Received Thanks: 74
|
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
|
|
|
05/25/2013, 19:48
|
#15
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,780
Received Thanks: 1,461
|
Quote:
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.
|
|
|
|
|
Similar Threads
|
Makai's Bazaar
10/21/2012 - Rappelz Private Server - 4 Replies
* Closed *
For a complete and current listing go HERE.
|
[Bazaar]-Bug!
05/18/2012 - WarRock Guides, Tutorials & Modifications - 24 Replies
Heyho Warrock Hacker-Community,
hier in dieser Topic möchte ich euch qerne einen Buq vorstellen. Dieser Bug ist simpel!
Es ist ein Buq, wie man in die Treppen laufen kann!
How-To: 1. Geht zu dieser Treppe. http://imgur.com/UfRah.jpg.
2. Stellt euch qenau so an diese Treppe. http://imgur.com/jmQSy.jpg
3. Dann lauft ihr mit der "A" Taste qeqen die Treppe und drückt abwechselnd "c" und Leertaste.
4. Dann müsste das so aussehen:http://i.imgur.com/Qnmw2.jpg Ihr habt es geschafft!
|
Bazaar hack, any still work?
07/14/2006 - Final Fantasy XI - 0 Replies
I've asked some friends to help me find them and they said mastly all of them are taken down because they don't work. also SE flags you when you use it.....but I don't care lol
|
Vendor/Bazaar Stealing
10/27/2003 - General Gaming Discussion - 1 Replies
1. öffnet n Bazaar Terminal mit /ui action terminalAuctionUse
2. geht zu nem Bank Terminal und öffnet es.. (lasst beide terminals offen, bazaar&bank)
3. jetzt legt ihr euer geld(alles) in die bank und lasst den withdraw screen offen
4. wählt euer item aus das ihr kaufen wollt-> es kommt ne bestätigungs frage diese müsst ihr vorerst offen lassen wie alles andere
5. nu highlighted euer bank terminal und fährt mit eurem cursor über den bestätigungs button der withdraw funktion (noch nicht...
|
All times are GMT +2. The time now is 08:01.
|
|