Jump to content

Tranquility

Members
  • Posts

    118
  • Joined

  • Last visited

  • Days Won

    3

Tranquility last won the day on March 31 2015

Tranquility had the most liked content!

Profile Information

  • Gender
    Male
  • Location
    Netherlands

Recent Profile Visitors

2458 profile views

Tranquility's Achievements

Poring

Poring (1/15)

17

Reputation

8

Community Answers

  1. 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)
  2. 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;},{},{}
  3. 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
  4. 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.
  5. I think removing the quest_function file from "lua files\quest" solved the issue for me in the past.
  6. In that case, this should solve your issue so you can get the whole table in: https://rathena.org/board/topic/103193-upgrade-20150619/
  7. 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.
  8. Can you view your SQL database in phpmyadmin or any other workbench?
  9. 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.
  10. Bump, hoped that this update wouldn't be hard to apply.
  11. 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.
  12. Check here: https://rathena.org/board/topic/102247-2014-client-support/
×
×
  • Create New...