rokimoki

Drop the info man, this is not CIA.

Lol some one has his contact? We were friends in the scripting community he even dedicated a happy birthday to me: https://youtu.be/0fHKyqzfdy8 I was trying to contact him for years. I hope he is well.

Hi, it's possible to do if you have mvp logs activated. And of course item log for any kind of card. (but I think this is not enabled by default, so you may lost all tracking from time behind). As you can see in this table is stored any MVP killed and tells which mvp was killed and what exp, item was rewarded and which map and who. This is not useful at all because if the guy sells the card, the track is "lost", but you can ask SQL to char, bank, inventory, etc... to see where is a card, but then you leave the track of who got or where it was adquired. What you want is, when a card is dropped get unique ID, and save who got it and where, I think this needs SRC editing and SQL modification in order to make an optimized script. But, this is the help I can give you, maybe if some one read this and wanna help further or tell a better solution is ok. EDIT: For now you can do these to examine your DB. SQL for inventory: SELECT t2.name_english, t3.name FROM inventory t1 INNER JOIN item_db t2 INNER JOIN `char` t3 ON t1.nameid = t2.id AND t1.char_id = t3.char_id WHERE t1.nameid IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card') OR t1.card1 IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card') OR t1.card2 IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card') OR t1.card3 IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card'); SQL for bank: Storage saves only account id SELECT t2.name_english, t1.account_id, t3.userid FROM `storage` t1 INNER JOIN item_db t2 INNER JOIN `login` t3 ON t1.nameid = t2.id AND t1.account_id = t3.account_id WHERE t1.nameid IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card') OR t1.card1 IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card') OR t1.card2 IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card') OR t1.card3 IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card'); And you can keep looking for guild storage, etc.

Hi, I want to know if is possible to set up a server with renewall features (stats, exp, and everything) but just locked to an episode, for example Revo-Classic. I am asking because the new euRO server is gonna be OBT soon, but I just want to make a server for my guild for testing purposes, and it's my first time playing a revo-classic like server. I found this and that, but wow one with rAthena and other with Hercules. Any further recomendation? Thanks!

Where is the Package Claim at Prontera? The package claim is a system which I did not coded, so this version send the item to a character from your account, maybe I have to edit the speeching script... Are you able to make the script? thanks in advanced! Actually no, because it's not my script (the package claim), you will receive the item to the selected char before deleting current character. PD: I edited the text in the github

Where is the Package Claim at Prontera? The package claim is a system which I did not coded, so this version send the item to a character from your account, maybe I have to edit the speeching script...

Script Type: Quest Script Name: Bloody Branch Quest Made for: Elaria Woon Reloaded Made by: Rokimoki Latest version: Bloody Branch Quest Ragnarok version: Any version Note: This script was made for Elaria Woon Reloaded, since they are going to close I will upload two scripts I made for them. Description: This is a quest that gives a Bloody Branch, this can be configured, even the item as the quantity that gives. The special thing in this quest is that the NPC will appear randomly in any previously configured map. When appear the NPC will ask for X items, you give the items and you get the reward, simple, but the NPC will only work for 10 uses every time the NPC spawns. Configuration: Search for: // ============== NPC CONFIGURATION ============== Then you will see the configuration instructions, I think it's pretty clear, the hard part is the npc duplicate, if you set or change new maps in .mapListBB$[0] then you must do the same in npc duplicate. For example: I add my custom map "lolmap-01" in the array, setarray(.mapListBB$[0], "prontera", "payon", "geffen", "lolmap-01" // new map added, last map DON'T HAVE coma ); then I add this line as npc duplicate: lolmap-01,100,100,4 duplicate(Bloody Guy) Bloody Guy::bblolmap-01 4_M_ROKI And that's it. Reward Configuration: Search for: // here starts the reward section Then, you will see the getitem, you can add more getitem, edit the item id and quantity etc... even add cash points... Enjoy. BloodyBranchQuest.txt

Script Type: Quest Script Name: Soul Reborn Made for: Elaria Woon Reloaded Made by: Rokimoki Latest version: SoulReborn.txt Ragnarok version: Pre-Renewall - SQL Server Note: This script was made for Elaria Woon Reloaded, since they are going to close I will upload two scripts I made for them. Description: You must be an advanced class 99/70 to Soul Reborn, this mean your character will be deleted from your account. In order to have a reward you need another character in your account to send the reward to his/her inventory. The reward, at this point, must be an etc item or usable item, because the sql query to insert the reward in the `inventory` table is prepared to be like that, of course you can change it to give anything you want. Enjoy. SoulReborn.txt

I will recode MVC when I have some time this summer.

Easy to add with a new SQL table, if you want I can help you with that.

You can add NOW() in the sql syntax and will put a datetime with the current server time... As far I know, timestamp is for linux epoch time purpouses, but you can use a datetime and use NOW() when update or insert

nice xD I don't even know how to use it, but thanks (ofc I open it with photoshop)

Sorry, there is a problem We could not locate the item you are trying to view. Error code: 2D161/2

this looks so cool, I am a disaster in graphic designing xD