Jump to content

Pandoras

Members
  • Posts

    16
  • Joined

  • Last visited

Everything posted by Pandoras

  1. Hey, I drop you a message kindly check, I'm interested in gepard

  2. https://github.com/rathena/rathena/blob/master/doc/script_commands.txt#L6004-L6020 maybe this can help
  3. Since you updated your client. Have you edit src/config/packets.h, added the packets for your new client and then recompiled? change the client version on clientinfo. You can post what changes you have made.
  4. This happen to me few days ago. I have no VNC or any kind of viewer installed on my VPS (Using console command). I tried restart/stop the emulator but still failed. So I restarted my server and start rathena again. Maybe multiple Login, Map and Char Server are open and that cause the problem.
  5. I'm not sure where to start but how to add multiple lines/value on SQL Insert Into. I want to give rewards to a list of players with 3 different rewards 1 apple, 2 red potions, 30 flywings for example I have a separate table for rewards to insert the items. Here is my code: set .@count, query_sql("SELECT `account_id` FROM `cp_createlog` WHERE `reg_date` BETWEEN '2017-10-24 00:00:00' AND '2017-10-26 23:59:59'", .@account_id); set .@eventname$ = "Testing"; setarray .@prize[0],14532,14592,14001,16682,2751,12210; setarray .@pamount[0],3,3,5,1,1,5; for(set .i, 0; .i < getarraysize(.@count); set .i,.i+1) for(set .j, 0; .j < getarraysize(.@prize); set .j,.j+1) for(set .k, 0; .k < getarraysize(.@pamount); set .k,.k+1) set .@reward$, "( .@account_id[.i], '.@eventname$', .@prize[.j], .@pamount[.k], 0)"; query_sql("INSERT INTO `event_rewards` ( `account_id`, `event_name`, `id`, `amount`, `value` ) VALUES '"+ .@reward$ +"' "); the .@reward$ stands as the value input to the sql insert value. how can i make .@reward$ output to something this: ( 200000, 'Testing', 14532, 3, 0), ( 200000, 'Testing', 14592, 3, 0), ( 200000, 'Testing', 14001, 5, 0), ( 200001, 'Testing', 14532, 3, 0), ( 200001, 'Testing', 14592, 3, 0), ( 200001, 'Testing', 14001, 5, 0) how can I make this possible?
  6. Pandoras

    Help

    Yes you can edit. Quite not sure if it works under different shape. You can check the files under \texture\À¯ÀúÀÎÅÍÆäÀ̽º\login_interface inside your server grf file.
  7. in your inter_athena.conf change 127.0.0.1 to your Public IP/Internal IP.
  8. change: 'md->class_' to: 'md->mob_id'
  9. I think enchantment are inserted to "option_id0, option_val0, option_parm0 -> option_id4, option_val4, option_parm4". Not sure I never tried enchantment on my server. auction, cart_inventory, guild_storage, inventory, mail, storage table have this. Use Update statement to change them back to 0 value
  10. I had this issue before. I just update my g++ to 5.
  11. Upgrade to Debian 9 or Update you g++ to 5.
  12. Yes it is possible using the ROdex, using command/npc no.
  13. rAthena need version 5 of gcc/g++ but wheezy gcc/g++ version is only 4.7.2-1. How can i fix this?
×
×
  • Create New...