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
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 ~~
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^^)
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^^)
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.
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 ~~
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...
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.
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.
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.
