Tranquility

How are we able to call upon that client side interpretation and is it impossible to call upon it from the server itself? (like opening UI windows)

Are we even able to give a flat (physical & magical) n% damage bonus these days? Or do we need to combine the magical & physical attacks to get such an item bonus? For the Anel do Capiroto [1] or Devil's Ring [1] I made a start, but it doesn't do what I think it should. The item should give the bonus if you have the str + 1 / str + 2 / str +3 essence compounded on _any_ item and then give the bonus effect, next to giving the default effect of +5% damage increase. This is what I have, perhaps others are able to assist to expand our item_db with these new items. 28505,Devils_Ring,Devil's Ring,4,,,50,,0,,1,0xFFFFFFFF,63,2,136,,100,0,0,{if (isequippedcnt(4908) >= 1 || isequippedcnt(4909) >= 1 || isequippedcnt(4910) >= 1) {bonus2 bAddRace,RC_All,5; bonus2 bMagicAddRace,RC_All,5;} bonus2 bAddRace,RC_All,5; bonus2 bMagicAddRace,RC_All,5;},{},{}

There are several hosting companies available and each and every one will claim to be the best choice. Go through the list, visit their website, see their packages and try to contact them instead of waiting for them to contact you ;p

Your character and map server need to point to your LAN/WAN IP (depending if you're just running it as a test server or not). Don't use localhost (127.0.0.1) as your IP address for ýour char/map servers.

I think removing the quest_function file from "lua files\quest" solved the issue for me in the past.

In that case, this should solve your issue so you can get the whole table in: https://rathena.org/board/topic/103193-upgrade-20150619/

Are you using it for donation purposes? That aside, I myself have used a script to take a value from cp_credits (balance) and converted them to donation credits (could be cash points for you). This script might help you find what you are looking for: switch(@menu) { case 1: query_sql("SELECT `balance` FROM `" + escape_sql(.redeemTable$) + "` WHERE `account_id` = " + getcharid(3) + " LIMIT 0,30", .@credits); if (.@credits > 0){ mes "How many Donation Credits do you wish to redeem?"; next; mes .npcName$; input .@withdrawCredits,1,.@credits; query_sql("UPDATE `" + escape_sql(.redeemTable$) + "` SET `balance` = `balance` - " + .@withdrawCredits + " WHERE `account_id` = " + getcharid(3) + ""); getitem 30017,.@withdrawCredits; mes .@withdrawCredits + "x " + getitemname(30017); } else { mes "My records indicate that there are no rewards awaiting to be redeemed."; mes "My deepest apologies for the misunderstanding."; } break; case 2: query_sql("SELECT `balance` FROM `" + escape_sql(.redeemTable$) + "` WHERE `account_id` = " + getcharid(3) + " LIMIT 0,30", .@credits); mes "You currently have " + .@credits + " donation credits."; break; case 3: mes "I am here to allow for the redemption of donation credits for " + .serverName$ + "."; mes "Donations may be made to the server via the control panel."; break; default: mes "Very well then."; mes "Good day to you."; break; } This script is a modification of the fluxcp donation NPC and where I have getitem(30017) you should be able to add/change your cashpoints. Whether you do it by writing to another database table or making a script that runs in the background is up to you.

Can you view your SQL database in phpmyadmin or any other workbench?

Fixed after copy/pasting the values from the git itself. For some reason that fixed the issue in mysql workbench. No clue where it went wrong when pulled/updated from the GIT itself. The query used is in this spoiler: EDIT: Revised and retried on an empty database, was missing a new line after the dashes in the comment section to make it work without errors for me.

Bump, hoped that this update wouldn't be hard to apply.

Looks quite nice, pretty clean, not too fancy (which I like). The feed with the coloured labels also are quite nice. I didn't notice the "learn more" button initially, might want to make it a tad more flashy, or it could be due to the small image size in the lightbox.

Check here: https://rathena.org/board/topic/102247-2014-client-support/

Hello, Upon upgrading the databases, I noticed the addition of the roulette database is proving to be difficult. The query from the update: -- -- Table structure for `db_roulette` -- CREATE TABLE IF NOT EXISTS `db_roulette` ( `index` int(11) NOT NULL default '0', `level` smallint(5) unsigned NOT NULL, `item_id` smallint(5) unsigned NOT NULL, `amount` smallint(5) unsigned NOT NULL DEFAULT '1', `flag` smallint(5) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`index`) ) ENGINE=MyISAM; ends up with error 1064. However, I don't see where a mistake in the syntax is made to cause that. Running MySQL 5.5, this was tested in MySQL WorkBench with the full error being: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`index` int(11) NOT NULL default '0', `level` smallint(5) unsigned NO' at line 1 I've replaced the whole text once and typed it out myself to prevent possible characters being mistaken, but I think that shouldn't throw this error if there was something wrong in that to start with. What can be done to fix this simple issue? Kind regards, Tranquility

This piece of work is awesome. Makes the CP more of a wiki! Wouldn't this be able to become a 'default' FluxCP addon for both rA & Herc's version of FluxCP? Optional to enable/use it, but certainly easier to maintain this way?

The information on Byteflux' page should still be correct: http://screencast.com/t/dKCCSWnZVw Obtained from: https://code.google.com/p/fluxcp/wiki/Screencasts

Probably the same answer as this:

I have packet_db in the db folder and in the db\import folder. You need to have the packets you have stated there to be identical to the packets you insert in the client (which you get prompted for when diffing it (with NEMO)). If you've don't that correctly, it should work without any issues.

Try using the default keys first, see if that works. Using the same client without any issues with the default keys atm.

Currently using 2013-08-07 and it works. However Tokeiburu has released a modified new prontera grf that should work with your client. Edit: here's the link, credits to Tokeiburu.

Yeah i already login ingame but it pop-up in my map-serv.sql [Warning]: Skipping packet version 33. [Warning]: The packet_db table only has support up to version 30. May i ask, is there any conflicts with my Diff Client? THANK YOU again! When diffing, make sure you have the "disable packet obfuscation" patch enabled. After making all those changes server side, make sure you've recompiled your server.

Try changing your packet_db to the corresponding version of your client (25), same for the packet_keys (which has no information in my current packet_db, so you might have to look them up and add them to your client diff if you use packet obfuscation).

You're lacking the right msgstringtable and might need to update your itemInfo.lua files and/or add bitmap files for your custom items if that what you're showing is a custom item (currently no information about it, just a blank screenshot). Try to get the latest translation files and updated itemInfo.lua (can be done by just updating kRO/kRO Renewal).