Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 19:43

  • Please register to post and access all features, it's quick, easy and FREE!

 

Rappelz PRIVATE SERVER Commands

Closed Thread
 
Old   #136
 
elite*gold: 0
Join Date: Apr 2010
Posts: 389
Received Thanks: 289
thnx man its working



Strange2010 is offline  
Old   #137
 
elite*gold: 0
Join Date: Jun 2011
Posts: 304
Received Thanks: 177
No prob, wanted to contribute a little.

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:

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


SilentBill is offline  
Old   #138
 
elite*gold: 0
Join Date: Apr 2010
Posts: 389
Received Thanks: 289
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 ~~
Strange2010 is offline  
Old   #139
 
elite*gold: 0
Join Date: Jan 2011
Posts: 26
Received Thanks: 2
When creating a account for a friend how do you insert a new line?

im not the best at sql =) reply fast please


piratehat1 is offline  
Old   #140
 
elite*gold: 0
Join Date: Apr 2010
Posts: 389
Received Thanks: 289
Quote:
Originally Posted by piratehat1 View Post
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
Strange2010 is offline  
Old   #141
 
elite*gold: 0
Join Date: Nov 2010
Posts: 118
Received Thanks: 22
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^^)
Anime Creature is offline  
Thanks
3 Users
Old   #142
 
elite*gold: 0
Join Date: May 2011
Posts: 526
Received Thanks: 346
Quote:
Originally Posted by Anime Creature View Post
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
MuStA2222 is offline  
Old   #143
 
elite*gold: 0
Join Date: Jun 2011
Posts: 304
Received Thanks: 177
Quote:
Originally Posted by Strange2010 View Post
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.
SilentBill is offline  
Old   #144
 
elite*gold: 0
Join Date: Nov 2010
Posts: 118
Received Thanks: 22
Quote:
Originally Posted by Strange2010 View Post
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
Anime Creature is offline  
Old   #145
 
elite*gold: 0
Join Date: Jun 2011
Posts: 304
Received Thanks: 177
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.

.
I added tons of safeguards, so the app shouldn't crash/nuke your DB/allow you to insert strange stuff. Enjoy. Source included, etc...
SilentBill is offline  
Thanks
3 Users
Old   #146
 
elite*gold: 0
Join Date: Mar 2009
Posts: 150
Received Thanks: 27
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
Makenci is online now  
Old   #147
 
elite*gold: 0
Join Date: Jun 2011
Posts: 304
Received Thanks: 177
Quote:
Originally Posted by Makenci View Post
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.
SilentBill is offline  
Old   #148
 
elite*gold: 0
Join Date: Jan 2011
Posts: 26
Received Thanks: 2
ID of the 160 ancient summoner armor ?
piratehat1 is offline  
Old   #149
 
elite*gold: 0
Join Date: Jun 2011
Posts: 304
Received Thanks: 177
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.
. It's the same URL as before, so any of the previous links will work.
SilentBill is offline  
Thanks
2 Users
Old   #150
 
elite*gold: 0
Join Date: May 2011
Posts: 17
Received Thanks: 0
thanks vry much
ll help me


ahmed78945 is offline  
Closed Thread



« Previous Thread | Next Thread »



All times are GMT +2. The time now is 19:43.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.