Jump to content

Secrets

Developer
  • Posts

    587
  • Joined

  • Days Won

    44

Community Answers

  1. Secrets's post in query dropcardid mvp was marked as the answer   
    .@rst = query_sql("SELECT inventory.card0, inventory.card1, inventory.card2, inventory.card3 FROM inventory INNER JOIN mob_db_re ON inventory.card0 = mob_db_re.dropcardid OR inventory.card1 = mob_db_re.dropcardid OR inventory.card2 = mob_db_re.dropcardid OR inventory.card3 = mob_db_re.dropcardid WHERE mob_db_re.mexp != 0 AND mob_db_re.dropcardid != 0", .@card0, .@card1, .@card2, .@card3); if(.@rst == -1) { //query error end; } mes "Total items with MVP cards :" + .@rst; // Use .@card0 - .@card4 to do whatever you want  
  2. Secrets's post in error running the game after encrypting using GRF editor was marked as the answer   
    Make sure you replaced your old cps.dll with the one GRF Editor generated for your client.
  3. Secrets's post in PVP Ladder Annieruru's edition - Some question (SOLVED) was marked as the answer   
    enable pvp_noguild and nosave mapflag
  4. Secrets's post in How to check account is loggedin? was marked as the answer   
    Q: How to check account is loggedin or player online by php script?
    A: Use this MySQL query.
    SELECT COUNT(*) FROM `char` WHERE online = 1 AND account_id = <your variable> Q:  How to disable Database cach on memory ?
    A: No, you can't. That would require some serious rewrite on rAthena source code and its performance would drop by a lot.
  5. Secrets's post in No rule to make target 'chmod'. Stop. was marked as the answer   
    sudo make server && chmod a+x login-server && chmod a+x char-server && chmod a+x map-server  
  6. Secrets's post in Error Leaving directory was marked as the answer   
    use this command to resolve the error
    chmod +x athena-start  
  7. Secrets's post in How to add items in Cash Shop Window? was marked as the answer   
    Edit /db/import/item_cash_db.txt
  8. Secrets's post in 2015-11-04aRagexe BUT 99/70 Trans Only Server was marked as the answer   
    Yes, I even use a newer client for my 2nd class server
  9. Secrets's post in can anyone help me with this script? was marked as the answer   
    You can't use a Hercules instance script on rAthena.
  10. Secrets's post in New account Job Level 10 Instant was marked as the answer   
    - script #whatever -1,{ OnPCLoginEvent: if(!#firstCharJLv && BaseLevel == 1 && JobLevel == 1){ JobLevel = 10; #firstCharJLv = 1; } }  
  11. Secrets's post in Item Bonus doesn't working. was marked as the answer   
    Looks fine to me. Unless you messed up the script that sets @kill variable.
  12. Secrets's post in help Convert mob_db.conf was marked as the answer   
    You may try importing this in Tokei's Server Database Editor and export it as rA database, or you can use Herc's mob_db.sql as base and strip the SQL stuffs out.
  13. Secrets's post in Problem with item's icon and description. was marked as the answer   
    You have to modify System/itemInfo.lua instead of those 2 txt files.
  14. Secrets's post in #CASHPOINTS to Items was marked as the answer   
    set command is deprecated. Use direct assignment instead.
    For example: #CASHPOINTS += (.@amount*10);
  15. Secrets's post in MS Visual C++ 2010 Express Edition was marked as the answer   
    You can compile the exe on your computer and upload it to your server if you wanna save disk space.
    Or even better, use Linux instead.
  16. Secrets's post in New charactor creation trouble! Client 2015-11-04 was marked as the answer   
    You're right. Using Thai RO client might be the cause of this issue, because it doesn't have Doram sprite yet.
     
    คิดว่าน่าจะเป็นเพราะใช้ตัวเกมเซิฟไทย ลองใช้ของเซิฟเกาหลีดูนะ
  17. Secrets's post in Random Option Not Appear was marked as the answer   
    You have to start from option index 0 or the option will not appear client-side.
  18. Secrets's post in New Dress Changer was marked as the answer   
    if(getlook(LOOK_BODY2)){
    // User already has jRO outfit on. Do something...
    }
  19. Secrets's post in drops.conf was marked as the answer   
    Some monsters are boss-flagged like Angeling, Abysmal Knight.
    MVPs are, well, MVPs.
  20. Secrets's post in while(set($@t,$@t+1) < 10){ was marked as the answer   
    try
    npctalk (10-$@t)+"";
  21. Secrets's post in Script that can remove copied skill by plagiarism was marked as the answer   
    You can read which skill is copied but not modify it by accessing these variables. CLONE_SKILL, CLONE_SKILL_LV (for plagiarism) and REPRODUCE_SKILL, REPRODUCE_SKILL_LV (for reproduce).
  22. Secrets's post in [rAthena Updates?] Where to find them ? was marked as the answer   
    We post noteworthy updates here.
    https://rathena.org/board/forum/10-development-news/
     
    All commit logs can be found at
    https://github.com/rathena/rathena/commits/master
  23. Secrets's post in How to check if an equip is already enchanted ? was marked as the answer   
    *getequipcardid(<equipment slot>,<card slot>)
    Returns value from equipped item slot in the indicated slot (0, 1, 2, or 3).
    This function returns CARD ID, 255,254,-255 (for card 0, if the item is produced).
    It's useful for when you want to check whether an item contains cards, enchantments or if it's signed.
    Use the script command above to retrieve enchantment id from a card slot and compare it to your conditions.
  24. Secrets's post in New Error for me =_= was marked as the answer   
    Relevant issue: https://github.com/rathena/rathena/issues/1210
  25. Secrets's post in OnPCLogoutEvent was marked as the answer   
    Because the label is being ran before the player is actually removed from the map.
×
×
  • Create New...