Jump to content

Brian

Members
  • Posts

    2223
  • Joined

  • Last visited

  • Days Won

    24

Everything posted by Brian

  1. I miss you too <3 1885
  2. /trunk/src/map/chat.h struct map_session_data* usersd[20]; Edit that [20] to [40]. Save, and recompile.
  3. bugreport:1883
  4. Run each of these queries, one at a time. They will list items (in auction, cart_inventory, guild_storage, inventory, mail, storage) with 4 cards in them. SELECT * FROM `auction` WHERE card0 AND card1 AND card2 AND card3; SELECT * FROM `cart_inventory` WHERE card0 AND card1 AND card2 AND card3; SELECT * FROM `guild_storage` WHERE card0 AND card1 AND card2 AND card3; SELECT * FROM `inventory` WHERE card0 AND card1 AND card2 AND card3; SELECT * FROM `mail` WHERE card0 AND card1 AND card2 AND card3; SELECT * FROM `storage` WHERE card0 AND card1 AND card2 AND card3;
  5. Try another program? I use GRF Tool and GRF Builder on Windows 7 64-bit and both programs work for me.
  6. Brian

    # Command

    Read the file /trunk/conf/groups.conf and it explains how to configure the new Group Permissions. <commands> A group of settings <command name> : <bool> or <commandname> : [ <bool>, <bool> ] First boolean value is for atcommand, second one for charcommand. If set to true, group can use command. If only atcommand value is provided, false is assumed for charcommand. If a command name is not included, false is assumed for both atcommand and charcommand. For a full list of available commands, see: doc/atcommands.txt. Command names must not be aliases. For example: item: [true, true] zeny: [true, true] disguise: [true, true] undisguise: [true, true] size: [true, true]
  7. The party share exp range config is in /trunk/conf/inter_athena.conf // Level range for sharing within a party party_share_level: 15
  8. datawavbragis_poem.wav
  9. quest.txt Adding_a_Script restart server Were loading the script with @loadnpc ? The waitingroom was not showing because OnInit is not triggered when you use @loadnpc. It only triggers when the map-server starts or when you use @reloadscript.
  10. Just to clarify: the 'nosave' mapflag does NOT block saving via @save! (Even though 'nogo' mapflag blocks using @go... ) mapflag#nosave means when you are on that map, the server does not save your character's location there. When you relog, you will be back at your SavePoint (or the map,x,y specified in the mapflag). que_moon mapflag nosave SavePoint que_moon mapflag nosave prontera,155,188
  11. I didn't see it before I vote yes also.
  12. Click the button that says "SQL" which opens a query window. Copy-paste those SQL queries and click Go.
  13. Accounts & characters pretty much includes everything. What DO you want to keep? To empty all SQL tables except item/mob databases, run these queries: TRUNCATE TABLE `auction`; TRUNCATE TABLE `cart_inventory`; TRUNCATE TABLE `char`; ALTER TABLE `char` AUTO_INCREMENT=150000; TRUNCATE TABLE `charlog`; TRUNCATE TABLE `friends`; TRUNCATE TABLE `global_reg_value`; TRUNCATE TABLE `guild`; TRUNCATE TABLE `guild_alliance`; TRUNCATE TABLE `guild_castle`; TRUNCATE TABLE `guild_expulsion`; TRUNCATE TABLE `guild_member`; TRUNCATE TABLE `guild_position`; TRUNCATE TABLE `guild_skill`; TRUNCATE TABLE `guild_storage`; TRUNCATE TABLE `homunculus`; TRUNCATE TABLE `hotkey`; TRUNCATE TABLE `interlog`; TRUNCATE TABLE `inventory`; TRUNCATE TABLE `ipbanlist`; TRUNCATE TABLE `login`; ALTER TABLE `login` AUTO_INCREMENT=2000000; TRUNCATE TABLE `mail`; TRUNCATE TABLE `mapreg`; TRUNCATE TABLE `memo`; TRUNCATE TABLE `mercenary`; TRUNCATE TABLE `mercenary_owner`; TRUNCATE TABLE `party`; TRUNCATE TABLE `pet`; TRUNCATE TABLE `quest`; TRUNCATE TABLE `ragsrvinfo`; TRUNCATE TABLE `sc_data`; TRUNCATE TABLE `skill`; TRUNCATE TABLE `skill_homunculus`; TRUNCATE TABLE `sstatus`; TRUNCATE TABLE `storage`;
  14. On your VPS, you have to create a MySQL user/password that is allowed to connect from the IP of your webhost. Then in your FluxCP config, set the MySQL user/pass that you just created.
  15. Edit the file /config/application.php and enable email confirmation: 'RequireEmailConfirm' => true, // Require e-mail confirmation during registration. Then configure your email settings: 'MailerFromAddress' => 'noreply@localhost', // The e-mail address displayed in the From field. 'MailerFromName' => 'MailerName', // The name displayed with the From e-mail address. 'MailerUseSMTP' => false, // Whether or not to use a separate SMTP server for sending mail. 'MailerSMTPUseSSL' => false, // Whether or not mailer should connect using SSL (yes for GMail). 'MailerSMTPUseTLS' => false, // Same as above SSL setting, but for TLS. This setting will override the SSL setting. 'MailerSMTPPort' => null, // When MailerUseSMTP is true: SMTP server port (mailer will default to 25). 'MailerSMTPHosts' => null, // When MailerUseSMTP is true: A string host or array of hosts (e.g., 'host1' or array('host1', 'backuphost')). 'MailerSMTPUsername' => null, // When MailerUseSMTP is true: Authorized username for SMTP server. 'MailerSMTPPassword' => null, // When MailerUseSMTP is true: Authorized password for SMTP server (for above user).
  16. To find out if any other players are connecting from that range of IP addresses, run this SQL query: SELECT * FROM login WHERE last_ip LIKE '180.194.%';
  17. If you only want to allow 1 char per IP in a certain map, you could do something like this: prontera,155,188,0 script TestNPC 910,{ if (callfunc("has_char_from_same_ip", "guild_vs2")) { mes "There is already a char from your IP on guild_vs2."; } else { warp "guild_vs2",0,0; } close; } function script has_char_from_same_ip { set .@my_map$, getarg(0); // get array of char names who are online from the same IP query_sql "SELECT `char`.`name` FROM `char` LEFT JOIN login ON `char`.account_id=login.account_id " + "WHERE last_ip=(SELECT last_ip FROM login WHERE account_id="+playerattached()+") AND online AND `char`.account_id!=" + playerattached(), .@name$; // check each char, and see if they are on the map for (set .@i,0; .@i < getarraysize(.@name$); set .@i,.@i+1) { getmapxy .@map$, .@x, .@y, 0, .@name$[.@i]; if (.@map$ == .@my_map$) return 1; // another char from this IP is already on map } return 0; // no other chars from this IP are on that map }
  18. And in case you want to use the "item_nodc.txt" method, here's how: revert r14553 apply these changes to fully implement item_nodc.txt create a file /db/item_nodc.txt listing the item_id of item(s) that are not discountable (one item_id per line).
  19. Brian

    Restock

    Do you get these items for free, or pay zeny?
  20. ok. I just checked and fixed permissions in ALL categories. Everything should be good now! Thanks again for letting us know.
  21. Fixed. Are there any other projects you can not see the status field?
  22. The default rAthena spawn script should be working fine. /npc/mobs/dungeons/lhz_dun.txt set .@mob,rand(1646,1651); ^ this code picks a random number (mob_id) between 1646 and 1651 inclusive. Double check your file and make sure it includes that line. Did you make any custom changes to your lhz_dun.txt ?
  23. You just put both labels at the beginning of the script, - script NPCNAME -1,{ OnWhisperGlobal: OnInit: // do stuff here end; } then either label will trigger the "do stuff".
  24. No. Labels in each NPC object must be unique (this includes your own labels, like L_Menu, and pre-defined labels like OnWhisperGlobal, OnPCDieEvent, etc). Could your code be combined into 1 OnWhisperGlobal label in the same NPC? If they must be separate, then just make 2 NPCs.
×
×
  • Create New...