Tranquility

If you would use the latest revision of Hercules, you'll need to execute the SQL updates manually on your database. Depending on which revision you started, you'll have to start updating/upgrading your database with the files that appear to be missing. The possibility is that you didn't modify too many files yet, in that case, you can start with a fresh clone from the Herc repository and add your modifications that way.

File Name: [script] storage{mod}item File Submitter: Tranquility File Submitted: 23 Oct 2015 File Category: Plugins Greetings! The past week I've been messing around with processing how to utilise the storage better for my in-game NPCs & scripts. Coming from rA, I noticed we didn't have the script commands "storageadditem", "storagecountitem", "storagedelitem". Because of that I thought I should give it a try and aim to develop a plugin or a means, to make it possible to use this functionality again. How to use: you can use storageadditem to add an item name or itemid to a players storage. storageadditem <item id>, <amount>{, <account id>} storageadditem<item name>, <amount>{, <account id>} Example: storageadditem(501,10); you can use storagecountitem to count a specific item name or itemid in a players storage. storagecountitem(nameID,{accountID}) returns number of items that meet the conditions Example: .@pots = storagecountitem(501); you can use storagedeltitem to delete a specific item name or itemid in a players storage. storagedelitem <item id>,<amount>{,<account id>} storagedelitem "<item name>",<amount>{,<account id>} Deletes items from the target/attached player. Example: storagedelitem(501,.@pots); Read the Hercules Plugin Manager wiki page if you don't know how to add this functionality to your server. If you have any questions, suggestions or notice any bugs, kindly let me know and I'll see what I can do about it. Uploaded to my Git Repo now for easier access. Click here to download this file

Another question then, how am I able to call *delitem from storage.h? It's located within in the storage_interface struct and I think I need to use that for the storagedelitem script I'm writing. However, when including storage.c I'm able to do it, but it'll throw tons of errors. Struggling with an undeclared MakeDWord when processing "buildin_delitem_delete". intif->delete_petdata(MakeDWord(inv->card[1], inv->card[2])); That line specifically, anyone able to help out there? Latest modification for the storagedelitem script but still stuck on the MakeDWord part. Fixed, had to declare MakeDWord again: //Declaration of MakeDWord to allow the uint32 MakeDWord(uint16 word0, uint16 word1) { return ( (uint32)(word0 ) )| ( (uint32)(word1 << 0x10) );}

Greetings, Upon converting some of my scripts I noticed Herc didn't have a few scriptcommands that rA had. No big deal since we got plugins here! Anyhow, that's what I thought until I bumped into getting stuck with the follow plugin that I'm attempting to create: Fixed the above script, added it incase people are interested. Will 'officially' release it in the plugin release when the below script is finished/working as well. The next script that had to be made was the deletion of items in the storage. Thus storagedelitem came here to ruin my night, the follow is what I got, but doesn't work for one milimeter: The original delitem script is used as reference and is as following: And what I think is needed is the following part from storage.c: Where did I mess up this time? Where didn't I mess up you're probably thinking by now..

Thanks for the update, new toys to play with now

Think it could be something like: set .redeemTable$,"cp_credits";query_sql("SELECT `balance` FROM `" + escape_sql(.redeemTable$) + "` WHERE `account_id` = " + getcharid(3) + " LIMIT 0,30", .@credits);mes "You have "+ .@credits + " donation credits";

Original post with workarounds/'solutions' was made here. However, all solutions provided are workarounds. The issue came into view with the latest generation of nVidia cards and updating drivers/Direct X doesn't solve the issue. The workarounds provided do temporarily solve it, however certain clients force close using some of those workarounds. Toggling "/lightmap" does remove the black squares, however that doesn't fix the horrible sprites with their choppy edges. A permanent solution is still to be sought after, possibly lies in the game client itself though. No real solution was provided on warp portal forums either, so there are no expectations ;p

Greetings, Upon going through the modifications I have to make for my scripts and ideas to work with Herc, I encountered different kinds of shops and other features. However, stubborn as I am, I wonder if it is possible to modify clif.c to add/modify the current currencies for an item from our item database? Taking the source for the Cash/Point shop, I see that currency is being declared, but due to my lack of programming skills I can't think of a way to point it to a new value, namely one from the item database. Is anyone able to push me in the right direction? I've already located the most likely point of origin to modify for this to be possible, the spoiler below contains the cash shop code from clif.c. Thanks in advance. Note: I have done my search and did find this as an option, however I like to expand my horizon and get things done how I have them in mind. Potentially providing a change for others to use. I'm not too lazy to search, just too stubborn to accept workaround to be a valid solution.

Yes you are wrong, it's item type 5, which is classified as armor/headgears. The name doesn't imply its use ^^

i change it to 3000.... but on item_db.conf i realize the "view" V is lowercase so i change it to upper.... but it gives me error when i open the client Change your lua/lub files to the new view ID you've set. It can't find the sprite for the item now.

still nothing... anything else? In that case, show us what you've done to implement it. Add some code boxes with where you put the respective filenames/descriptions. The wiki is quite thorough on what you should add and where though.

Hi zack, is it possible to get this in pre-renewal? It is possible if you take them from the renewal item_db. Since they don't have any effects they should be able to be implemented for pre-renewal too (double check them to be sure though). Currently working on the addition of renewal items to pre-renewal db, it's a horror but someone has to do it. Lol. it sounds easy but it is merged with the item_db at random lines it would be better if it was separated at least and grouped. It is more logical that it's done by order of item ID, which is done now. However a chronological order of implementation wouldn't be bad for purposes like this. However, if you want it, you'll have to just sit those 3-4 hours comparing the two databases and merge changes. I'll be doing the migration for the whole renewal database to pre-renewal and not just the costume items. Just the costume items probably is relatively easy to do, I think it's within the item ID range of like 19k-23k or something? Which is done quite fast.

You're missing the actual sprite. Place them in the respective male/female sprite folders.

Hi zack, is it possible to get this in pre-renewal? It is possible if you take them from the renewal item_db. Since they don't have any effects they should be able to be implemented for pre-renewal too (double check them to be sure though). Currently working on the addition of renewal items to pre-renewal db, it's a horror but someone has to do it.

Are you using "Clean Build > Build" on the whole solution? That part is just for recompilation of your (source) modifications, what is the exact error? Kindly give us more information to be able to help you out.

Tried and used on my live server, conversion completed without any errors. However there could still be some duplicates flaws in the script that I just fail to see. Other than that, it works and can be used for rA > Herc conversion. Made a pull request for it yesterday too, so if the core devs could take a look at it, it'll be able to be used by the masses.

@Dastgir Could you make the pull request you were talking about here if this hasn't been added yet? Would love to see this being possible on Herc too!

Greetings! I am currently working on adding the renewal items to the pre-renewal item database. Or rather, doing it again, since I did it on rA before, but just the SQL queries. However, since Herc is/was making the move for SQL item & mob databases to be deprecated, I thought I should move everything to text anyhow. The real question is, has there been anyone who already attempted to do this? Or is there maybe a plugin for it? (I haven't found it) If no one has taken such actions before, then I guess I'll compare the two files and copy-pasta the non-existing items to a new file and try to remove all renewal features out of it (3rd class skills or upgrade mechanics for example). When there are multiple people interested or someone knows an easier way to do this (besides going renewal itself), it might be possible to just collaborate and commit them on your/mine/our github repository. Kind regards, Tranquility

Thanks! The feedback will be appreciated. As soon it works (flawlessly) for everyone, I or someone else can make a pull request to improve the current conversion tool at the git repository. Which was my original intention to use this post for.

Greetings (future) Herc users, in the past I've asked a lot about migrating from rA to Herc. One of the issues I came across was the non-updated SQL conversion tool. Below in the spoiler is my attempt to update the current available tool, which is to be carried out after a complete rA update. Since I doubt my adjustments I post it here, wondering if a few of the interested people could try this out on their test servers, hoping they'll yield the same results as I do. Do note, the last two queries are to convert your item databases and are thus optional. Remove them from your query if you're already going straight to the conf-file setup. Kindly leave your feedback in the comments below. If I'm missing a ton of things, I'll revise the entire script soon™ by manually comparing both database tables... EDIT: Made some small modifications after recomparing the databases, thus updated the above script. Thanks in advance, Tranquility

They're outdated and only work till the date it was published. There's converter for txt to conf in tools folder I'll have a look at that too, thanks for mentioning that! Just felt like completing the conversion script keeping in mind that others (and myself) are still using SQL item/mob databases. Once I've completed my rA struggle (which probably is a pointless one) I'll compare and fix the current rA > Herc conversion again and post it in pastebin, since I'll not be confident in my commits to the repo.

They're outdated and only work till the date it was published. If you have your mobs & items in the SQL database too, you'll have to convert them to the conf files since Hercules will drop the SQL support for those. There is no convertor for it (yet). For the remainder, you'll have to manually make some of the database modifications yourself, so I suggest backing it up and testing it on your own computer/test server before doing it on your live server.

It very much is, that's why I've been trying to figure it all out =P For renewal based items it'll bring another issue though, shadow gears have a separate type (12) in rA, which is non-existent for Herc. Though probably using the item database from Herc itself would prove easier, it won't if people made modifications to their own database (pre-renewal server with the addition of renewal items for example). Hercules discourage using item_db via SQL, and support for reading SQL db will be deprecated soon. I realised that in other topics. however, is there a way to easily convert SQL databases back to txt or in Hercules' case, conf files? Tokei's tool allows to create most things and convert it to the right format, but it isn't possible (yet) to import a SQL database from a specific emulator. I fail to see why reading from SQL for those things will deprecate soon though, it is convenient and easy to access from phpmyadmin on people's browser, whereas the item_db on the VPS usually requires log-ins via Putty, VNC or some FTP synchronisation, which all seem more labourous to me ;p Thanks for bringing it to our attention though, I'm just curious as to why this change is coming.

It very much is, that's why I've been trying to figure it all out =P For renewal based items it'll bring another issue though, shadow gears have a separate type (12) in rA, which is non-existent for Herc. Though probably using the item database from Herc itself would prove easier, it won't if people made modifications to their own database (pre-renewal server with the addition of renewal items for example).