Rappelz PRIVATE SERVER Commands

thnx man its working

No prob, wanted to contribute a little.
:pimp:
If you run into any bugs, PM me.

I didn't find any other EPro, sorry, if anyone does, do tell :P
I'm gonna work on updating already inserted items, but for the time being, here's a new version, with Ancient Cubes: Skill, Strike, and Def corrected, thanks to Makenci, I added Rebirths and Unity Rings (timed, I don't think there are untimed versions) Makenci asked me about the prices, you can't set the price here, the prices are stored in another table, you can adjust how bad the merchant can gouge a player with the ratio. I had capped it at 100x, but I raised it to 100 000 000x since some of the items are incredibly cheap.
But I ramble, here's the download:
[Only registered and activated users can see links. Click Here To Register...]
Again, source included, if anyone wants to fiddle with it.

So, while working on my last version, I noticed something really stupid with the MarketResource table.
It was, during a particularly stupid mistake of mine, forgot my where clause in the update operation, that I found out that table has no primary key. Had it had one, my mistake would not have gone unpunished, now I had to restore my Arcadia DB lol. Side effect of coding at 3 AM I guess.
Anyway, I'm pretty happy how my li'l app's coming along, next release should be more robust, and more complete, I'm adding Update and Delete operations. I will stop for now, or I might end up nuking all my DBs

shouldnt the e-protect save the weapon from losing enchant levels ??
when i enchanted my weapon (was+5) to +6 it failed and the e-protect made it +3 ~~

When creating a account for a friend how do you insert a new line?

im not the best at sql =) reply fast please

Quote:

Originally Posted by piratehat1 When creating a account for a friend how do you insert a new line? im not the best at sql =) reply fast please

you can see a line under ur accounts line
that lines values are all (NULL)
just start writing on that line and a new line will be created

how to start an ursa run?

1. enter ursa caverns via npc
2. write into game server:
#show_huntaholic_lobby_window("YourCharName")
3. create a team
4. have fun (dont forget to add gm/hv buffs first^^)

Quote:

Originally Posted by Anime Creature how to start an ursa run? 1. enter ursa caverns via npc 2. write into game server: #show_huntaholic_lobby_window("YourCharName") 3. create a team 4. have fun (dont forget to add gm/hv buffs first^^)

great :)

Quote:

Originally Posted by Strange2010 shouldnt the e-protect save the weapon from losing enchant levels ?? when i enchanted my weapon (was+5) to +6 it failed and the e-protect made it +3 ~~

Yes, it does work that way, same as the regular ERep. I have no idea why.
I looked for other versions of EPro in the DB, and found only the old E3 version, that works exactly the same way, salvaging only half the enchantment, only it can't be traded/sold to NPCs either. Only solution I can think of is to use the "Perfect" Erep, it works the same way as the regular ERep in the live version.

Quote:

Originally Posted by Strange2010 shouldnt the e-protect save the weapon from losing enchant levels ?? when i enchanted my weapon (was+5) to +6 it failed and the e-protect made it +3 ~~

try these, they'll protect for sure =)

Code/ID Description
960001 Rank 2 Blessed Stabilizing Powder
960002 Rank 3 Blessed Stabilizing Powder
960003 Rank 4 Blessed Stabilizing Powder
960004 Rank 5 Blessed Stabilizing Powder
960005 Rank 6 Blessed Stabilizing Powder
960006 Rank 7 Blessed Stabilizing Powder

Those are in my app's list, btw (shameless plug)
Here's the (probably last) release, lemme know if there's anything wrong, or if you get any new interesting items to add.

[Only registered and activated users can see links. Click Here To Register...].
I added tons of safeguards, so the app shouldn't crash/nuke your DB/allow you to insert strange stuff. Enjoy. Source included, etc...:mofo:

delete items no work -.- or iam idiot^^



and have maybe any1 id for

150: hunter armor, summoner armor and bow
155: hunter armor, summoner armor, bow , dirk and shild
160: hunter armor, summoner armor,cros bow, bow, dirk and shild

Quote:

Originally Posted by Makenci delete items no work -.- or iam idiot^^

Did you put in the correct Item ID? Check the txt file it generates.
It's the sort_id column in the DB.
Also, if it's not one of the items in the list, it won't work, that's by design, not a bug :), that way, you don't mess with (most) of the already established items in the merchants.
Lemme elaborate, you put in the ID in the textbox, then look the item up, if it comes up OK, it should fill the combo boxes (the list things), and enables the button.

ID of the 160 ancient summoner armor ?

ok, I'm gonna post a small explanation on how to delete and update items:
Whenever you insert an item, an entry will be added to a text file called 'ItemsInserted.txt' located wherever you have the exe file. That entry looks something like so:

Sort ID: 9005
Merchant: Bag Guy expansion_acc_bag
Item: Swimsuit Armor 3630062
Price Ratio: 1
Date: 2011/06/14 - 11:30:26 AM

The ID you want to use to delete that item from the merchant is the Sort ID, not the actual Item ID (Maybe I'll change the text, make it less ambiguous)
So, to delete/update that entry, you put in the 9005 in the Item ID, and look it up. If it comes up and fills teh rest of the form, you're good to go, press the delete button and the entry's gone. It will still generate a new entry in the txt file, that looks something like this.

Sort ID: 9137 --DELETED
Merchant: Mare Merchant mare_etc
Item: Assassin Impact 5025025
Price Ratio: 1
Date: 2011/06/14 - 03:46:35 PM

Well, I hope that was clear enough, and again, any suggestion, question or new item IDs, you can reach me via PM or post.

Small functionality fixes, added a SortID label to the textbox, make it more explicit, + Added One handed Axes, courtesy of Makenci and Hunter and Summoner Armors, courtesy of yours truly. Also, added this post's explanation on how to delete and update into the readme.
[Only registered and activated users can see links. Click Here To Register...]. It's the same URL as before, so any of the previous links will work.

thanks vry much
ll help me