Jump to content

Brian

Members
  • Posts

    2223
  • Joined

  • Last visited

  • Days Won

    24

Everything posted by Brian

  1. Did you leave the page/tabs for a while, then click Edit / Quote and have those problems? That's happened to me a couple times -- I think it's because of our caching CDN. If you load the page then wait a while, your HTTP request might get routed to a different edge node the next time you click a link (Edit/Quote). Next time if you leave the page open for a while (10+ minutes), reload the page before clicking Edit or Quote. PS: these issues should not cause Internet Explorer to crash .. that's just IE
  2. I think it's the client that determines what's in the GM right-click menu.
  3. The "no PK" maps are defined by trunk/npc/mapflag/nopvp.txt Make sure your server is loading that script, and that all town/indoor maps are listed in that file.
  4. - script apple -1,{ OnWhisperGlobal: set .@item_id, 512; // Apple if (countitem(.@item_id)) { if (Hp) { dispbottom "You don't require resurrection at this moment."; } else { set .@count, callsub(S_getrevivecount); // if they have less than 3 revives this hour if (.@count < 3) { callsub S_setrevivecount, .@count +1; dispbottom "Your Acolytes are now praying in Prontera, please wait 10 seconds for the final judgement."; sleep2 10000; recovery 0; dispbottom "You have "+(3 - (.@count+1))+" revives left for this hour."; } else { dispbottom "You can only be revived 3x every hour."; } } } else { dispbottom "You need to have a "+getitemname(.@item_id)+" in your inventory."; } end; S_getrevivecount: set .@now_hour, atoi(gettimestr("%y%m%d%H",9)); // YYMMDDHH if (atoi(delchar(revive+"",8)) < .@now_hour) return 0; // if their last revive was not this hour, then they have used 0 revives this hour else return atoi(charat(revive+"",8)); S_setrevivecount: set revive, atoi(gettimestr("%y%m%d%H",9) + getarg(0)); return; }
  5. guild_vs4,0,0,0 script die_and_warp -1,{ OnPCDieEvent: if (strcharinfo(3) == "guild_vs4") warp "SavePoint",0,0; end; }
  6. Looks like one of your fame list sizes is set to a negative number. trunk/conf/char_athena.conf // Size for the fame-lists fame_list_alchemist: 10 fame_list_blacksmith: 10 fame_list_taekwon: 10
  7. I agree with Euphy. If you want a custom "word" to trigger a NPC, I think it'd be better to make a custom atcommand. You can use bindatcmd to make @questitem open your Dynamic Quest NPC.
  8. trunk/sql-files/upgrades/upgrade_svn17194.sqlALTER TABLE `char` ADD COLUMN `moves` int(11) unsigned NOT NULL DEFAULT '0';
  9. Brian

    No-IP

    Then maybe your ISP does not allow incoming traffic on those ports.
  10. Yes, because those files only modify the existing tables mob_skill_db and item_db2. trunk/sql-files/mob_skill_db_re.sql # # Table structure for table `mob_skill_db` # DROP TABLE IF EXISTS `mob_skill_db`; CREATE TABLE IF NOT EXISTS `mob_skill_db` ( trunk/sql-files/item_db2_re.sql# # Table structure for table `item_db2` # DROP TABLE IF EXISTS `item_db2`; CREATE TABLE `item_db2` (
  11. To import a SQL file using the < operator, you don't run "mysql.exe" directly. 1. open a command prompt 2. 'cd' to C:\Program Files\MySQL\MySQL Server 5.0\bin\ 3. then type: mysql.exe -h myip -u myuser -p ragnarok < C:\Desktop\trunk\sql-files\mob_skill_db.sql
  12. Yes, your "Ragnarok" database is named ragnarok Do you have the MySQL command-line client installed on your computer? It might be in a folder like C:\Program Files\MySQL\bin\mysql.exe You'd have to 'cd' into that folder, then type mysql -h myip -u myuser -p ragnarok < C:\Desktop\trunk\sql-files\mob_skill_db.sql
  13. Brian

    No-IP

    It looks like your ports are still closed. http://www.yougetsignal.com/tools/open-ports/
  14. on CentOS to update everything: yum -y updateTo list what updates will be installed, and prompt Y/N:yum updateTo update just 1 package or several packages that match a search:yum update gcc yum update mysql*
  15. Brian

    No-IP

    201.9.18.91 is your WAN IP right? (click here to check) "Connection refused" means your router is not properly configured. You need to open ports 6900, 6121, 5121 and forward them to your computer's LAN IP.
  16. Brian

    MD5 Passwords

    You can also search by their login ID: UPDATE `login` SET `user_pass` = MD5('NEW_PASSWORD') WHERE `userid`='THEIR_LOGIN_ID';
  17. In Linux: 1. delete the old folder rm -rf trunk/1b. or if you want to keep the folder as a backup, just rename it:mv trunk/ old_trunk/ 2. then checkout a new SVN Working Copy. svn co http://svn.code.sf.net/p/rathena/svn/trunk/ trunk/
  18. Brian

    No-IP

    You don't need to replace the IP addresses in the last line. It should stay as-is: subnet: 255.0.0.0:127.0.0.1:127.0.0.1
  19. That probably means your folder is not a SVN Working Copy. Can you check if there is a .svn folder ? ls -a ~/Arbeitsfläche/trunk/
  20. The first error "#1062 - Duplicate entry '1' for key 'PRIMARY'" is probably because you are importing main.sql again. When you imported main.sql the first time, it already created the server account with account_id = 1. If you want to re-import main.sql, you should delete all the tables from your Ragnarok database first. The second error -- you can fix this by using the 'mysql' command-line client instead of phpMyAdmin. To import a file: mysql -h 127.0.0.1 -u USER -p DATABASE < /path/to/rathena/sql-files/mob_skill_db.sql- replace 127.0.0.1 with your MySQL server's IP - replace USER with your MySQL username - replace DATABASE with your Ragnarok database name - when prompted, enter your MySQL password.
  21. Connect to your MySQL database, then use the REPAIR TABLE query. Ex: REPAIR TABLE `char`;If you use a MySQL client GUI program, it probably has a tool where you can "Select All" tables and click Repair.
  22. In your client's GRF or data folder, edit /data/viewpointtable.txt and remove the line(s) for each Abbey map.
  23. thanks Euphy :) PS: your tyranitars are amazing

  24. oops I forgot we have to change it to clif_broadcast() so we can include the player's bl. Find (that same line): intif_broadcast(message,strlen(message)+1,0);Replace with: clif_broadcast(&sd->bl, message, (int)strlen(message)+1, 3, SELF);Save, recompile, and that should work. PS: to make the rare_drop_announce trigger sooner, you could temporarily set it higher @setbattleflag rare_drop_announce 9000
×
×
  • Create New...