Brian

Looks like the same error as post=78414? Gepard fixed it in r15573

Here's one way you could do the SQL query: SELECT `char`.`name`, global_reg_value.`value` FROM global_reg_value LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id WHERE global_reg_value.`str` = 'PVPTotal' ORDER BY CAST(global_reg_value.`value` AS SIGNED) DESC LIMIT 5; So your NPC script could look something like: query_sql "SELECT `char`.`name`, global_reg_value.`value` " + "FROM global_reg_value LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id " + "WHERE global_reg_value.`str` = 'PVPTotal' " + "ORDER BY CAST(global_reg_value.`value` AS SIGNED) DESC " + "LIMIT 5", .@name$, .@points; mes "Hall Of Fame: TOP5"; for (set .@i,0; .@i < getarraysize(.@name$); set .@i,.@i+1) { mes (.@i+1) + ". " + .@name$[.@i] + " ("+ .@points[.@i] +")"; }

Are you trying to make something.tk --> somethingelse.no-ip.info ? That would be a CNAME record. To setup [manastoryro.tk] Type = CNAME Record Host Name = @ IP Address = <somethingelse>.no-ip.info (your No-IP sub-domain) To setup [www.manastoryro.tk], the settings would be the same except Host Name = www

GMXeon posted one here. // Script whipped up by [GM]Xeon ;D // No street chatrooms + vends - Prontera edition // http://www.eathena.ws/board/index.php?showtopic=186170 - script NoChatVendPront -1,{ OnWhisperGlobal: if (!getgmlevel()) end; OnInit: setcell "prontera",1,1,312,392,cell_nochat,0; setcell "prontera",1,1,312,392,cell_novending,0; setcell "prontera",134,190,177,217,cell_nochat,1; setcell "prontera",82,200,124,207,cell_nochat,1; setcell "prontera",125,199,125,208,cell_nochat,1; setcell "prontera",126,198,126,209,cell_nochat,1; setcell "prontera",127,197,127,210,cell_nochat,1; setcell "prontera",128,196,128,211,cell_nochat,1; setcell "prontera",129,195,129,212,cell_nochat,1; setcell "prontera",130,194,130,213,cell_nochat,1; setcell "prontera",131,193,131,214,cell_nochat,1; setcell "prontera",132,192,132,215,cell_nochat,1; setcell "prontera",133,191,133,216,cell_nochat,1; setcell "prontera",148,231,163,268,cell_nochat,1; setcell "prontera",147,230,164,230,cell_nochat,1; setcell "prontera",146,229,165,229,cell_nochat,1; setcell "prontera",145,228,166,228,cell_nochat,1; setcell "prontera",144,227,167,227,cell_nochat,1; setcell "prontera",143,226,168,226,cell_nochat,1; setcell "prontera",142,225,169,225,cell_nochat,1; setcell "prontera",141,224,170,224,cell_nochat,1; setcell "prontera",140,223,171,223,cell_nochat,1; setcell "prontera",139,222,172,222,cell_nochat,1; setcell "prontera",138,221,173,221,cell_nochat,1; setcell "prontera",137,220,174,220,cell_nochat,1; setcell "prontera",136,219,175,219,cell_nochat,1; setcell "prontera",135,218,176,218,cell_nochat,1; setcell "prontera",187,200,229,207,cell_nochat,1; setcell "prontera",186,199,186,208,cell_nochat,1; setcell "prontera",185,198,185,209,cell_nochat,1; setcell "prontera",184,197,184,210,cell_nochat,1; setcell "prontera",183,196,183,211,cell_nochat,1; setcell "prontera",182,195,182,212,cell_nochat,1; setcell "prontera",181,194,181,213,cell_nochat,1; setcell "prontera",180,193,180,214,cell_nochat,1; setcell "prontera",179,192,179,215,cell_nochat,1; setcell "prontera",178,191,178,216,cell_nochat,1; setcell "prontera",148,130,163,176,cell_nochat,1; setcell "prontera",147,177,164,177,cell_nochat,1; setcell "prontera",146,178,165,178,cell_nochat,1; setcell "prontera",145,179,166,179,cell_nochat,1; setcell "prontera",144,180,167,180,cell_nochat,1; setcell "prontera",143,181,168,181,cell_nochat,1; setcell "prontera",142,182,169,182,cell_nochat,1; setcell "prontera",141,183,170,183,cell_nochat,1; setcell "prontera",140,184,171,184,cell_nochat,1; setcell "prontera",139,185,172,185,cell_nochat,1; setcell "prontera",138,186,173,186,cell_nochat,1; setcell "prontera",137,187,174,187,cell_nochat,1; setcell "prontera",136,188,175,188,cell_nochat,1; setcell "prontera",135,189,176,189,cell_nochat,1; setcell "prontera",134,190,177,217,cell_novending,1; setcell "prontera",82,200,124,207,cell_novending,1; setcell "prontera",125,199,125,208,cell_novending,1; setcell "prontera",126,198,126,209,cell_novending,1; setcell "prontera",127,197,127,210,cell_novending,1; setcell "prontera",128,196,128,211,cell_novending,1; setcell "prontera",129,195,129,212,cell_novending,1; setcell "prontera",130,194,130,213,cell_novending,1; setcell "prontera",131,193,131,214,cell_novending,1; setcell "prontera",132,192,132,215,cell_novending,1; setcell "prontera",133,191,133,216,cell_novending,1; setcell "prontera",148,231,163,268,cell_novending,1; setcell "prontera",147,230,164,230,cell_novending,1; setcell "prontera",146,229,165,229,cell_novending,1; setcell "prontera",145,228,166,228,cell_novending,1; setcell "prontera",144,227,167,227,cell_novending,1; setcell "prontera",143,226,168,226,cell_novending,1; setcell "prontera",142,225,169,225,cell_novending,1; setcell "prontera",141,224,170,224,cell_novending,1; setcell "prontera",140,223,171,223,cell_novending,1; setcell "prontera",139,222,172,222,cell_novending,1; setcell "prontera",138,221,173,221,cell_novending,1; setcell "prontera",137,220,174,220,cell_novending,1; setcell "prontera",136,219,175,219,cell_novending,1; setcell "prontera",135,218,176,218,cell_novending,1; setcell "prontera",187,200,229,207,cell_novending,1; setcell "prontera",186,199,186,208,cell_novending,1; setcell "prontera",185,198,185,209,cell_novending,1; setcell "prontera",184,197,184,210,cell_novending,1; setcell "prontera",183,196,183,211,cell_novending,1; setcell "prontera",182,195,182,212,cell_novending,1; setcell "prontera",181,194,181,213,cell_novending,1; setcell "prontera",180,193,180,214,cell_novending,1; setcell "prontera",179,192,179,215,cell_novending,1; setcell "prontera",178,191,178,216,cell_novending,1; setcell "prontera",148,130,163,176,cell_novending,1; setcell "prontera",147,177,164,177,cell_novending,1; setcell "prontera",146,178,165,178,cell_novending,1; setcell "prontera",145,179,166,179,cell_novending,1; setcell "prontera",144,180,167,180,cell_novending,1; setcell "prontera",143,181,168,181,cell_novending,1; setcell "prontera",142,182,169,182,cell_novending,1; setcell "prontera",141,183,170,183,cell_novending,1; setcell "prontera",140,184,171,184,cell_novending,1; setcell "prontera",139,185,172,185,cell_novending,1; setcell "prontera",138,186,173,186,cell_novending,1; setcell "prontera",137,187,174,187,cell_novending,1; setcell "prontera",136,188,175,188,cell_novending,1; setcell "prontera",135,189,176,189,cell_novending,1; end; }

The SQL query herenow posted actual does this: "count how many accounts in the `login` table have the same IP as you" instead, it should be: "count how many online chars have the same IP as you" SELECT COUNT(char_id) FROM `char` LEFT JOIN `login` ON `char`.account_id=login.account_id WHERE online AND last_ip = (SELECT `last_ip` FROM `login` WHERE `account_id` = "+getcharid(3)+") Example: only3perIP.txt

Yea, you can only use one, <aid> OR <yellow>. If you try to use both, GM sprites will NOT display.

You could add the 'monster_noteleport' mapflag to all maps. mapflag#monster_noteleport (This might be easier than disabling every mob's Teleport skill.) The source equivalent would be "enable flag.monster_noteleport on every map by default". add this in map.c around line 2812: // on all maps, block monsters from teleporting map[i].flag.monster_noteleport = 1; So now that function looks like:

Is this the guide you are looking for? GDB

Thanks Ind, but Would it be possible to add code that sums up the <time> and if the overall time is negative, then block it if they don't have permission to @unban. Right now, the code you added checks for ANY negative <time>. @ban +23h PlayerName @ban +1d-1h PlayerName ^ both of these mean "add 23 hours" to the char's ban, but the 2nd one would fail because it has a negative sign.

rAthena already supports this feature! since r15489, 3 weeks ago.

../trunk/conf/log_athena.conf // Logging tables/files // Following settings specify where to log to. If 'sql_logs' is // enabled, SQL tables are assumed, otherwise flat files. // Dead Branch Log log_branch_db: log/branchlog.log //log_branch_db: branchlog // Drops & Pickups log_pick_db: log/picklog.log //log_pick_db: picklog // Zeny log_zeny_db: log/zenylog.log //log_zeny_db: zenylog // MVP Drops log_mvpdrop_db: log/mvplog.log //log_mvpdrop_db: mvplog // GM Log log_gm_db: log/atcommandlog.log //log_gm_db: atcommandlog // NPC Log log_npc_db: log/npclog.log //log_npc_db: npclog // CHAT Log log_chat_db: log/chatlog.log //log_chat_db: chatlog The default settings are for TXT logs (saved in the /log/ folder). To use SQL, you have to switch them to SQL configs, or add this to /conf/import/log_conf.txt log_branch_db: branchlog log_pick_db: picklog log_zeny_db: zenylog log_mvpdrop_db: mvplog log_gm_db: atcommandlog log_npc_db: npclog log_chat_db: chatlog

- script map_self_announce -1,{ OnPCLoadMapEvent: if (compare("prontera,geffen,payon", strcharinfo(3))) announce "You have entered the map: " + strcharinfo(3), bc_self; end; } prontera mapflag loadevent geffen mapflag loadevent payon mapflag loadevent 1. add the mapname in 'compare' in the 1st string 2. add the 'loadevent' mapflag to that map

Use <flag> bc_self So just change the 0 in Emistry's example to bc_self. (0 is bc_all)

There is a simpler way: /conf/battle/monster.conf // Respawn rate of monsters on a map. 50 would make mobs respawn twice as fast (half delay time) (Note 2) //Note: This does not affects mobs with inmediate respawn (most normal mobs) mob_spawn_delay: 100 plant_spawn_delay: 100 boss_spawn_delay: 100 If you don't mind bosses having 0 respawn delay too, you can set boss_spawn_delay to 0. "Boss" are all monsters that have MD_BOSS mode (this includes MVPs and mini bosses).

I agree. @Law: there are full examples in CeresCP - emblema.php (check guild.php for an example how to use it) FluxCP - /lib/functions/imagecreatefrombmpstring.php (check /modules/guild/emblem.php for an example)

Does Mac have a different disk format for CD/DVD ? I thought most CDs use ISO 9660 and most DVDs are UDF. If both Mac and Windows use UDF, then it's just the Adobe Photoshop CS5 files on the DVD that are different right? I would think you can put a Mac Adobe Photoshop CS5 DVD in your Windows DVD drive, and the MacOS X virtual machine would read it.

564

Yes you could do that and it would work. Script files can have any extension (or none at all), as long as the filename and path in scripts_custom.conf match the actual filename.

This topic explains how: How to relocate to the SourceForge SVN To update your SQL tables, use the upgrade_svn*****.sql in the /trunk/sql-files/ folder. They work the same way as in eAthena, so if you were up-to-date prior to r15000, you would need to run all the ones after 15000: - upgrade_svn15003.sql - upgrade_svn15420_log.sql - upgrade_svn15519_log.sql - upgrade_svn15531_db.sql

554

530 !

In rAthena, there is no such column `guildwinscount`. The error must be from some customization you are trying to add, or you are not using rAthena.

513 !

505

I used GRF Builder to repack and it works fine for me. http://www.grfbuilder.com/#download