nitrous

As of right now, I'm pretty sure you can leave it at 0, since none of the random options use that value.

*setrandomoption(<equipment indice>,<index>,<id>,<value>,<param>{,<char id>}); index parameter can be 0 to MAX_ITEM_RDM_OPT-1 (default 0-4). You're missing the <index> parameter, which is the value that tells you which slot to put it in (0 - 4).

This wont work either because you can't use 'set' if the player is online. Instead, try something like this. - script S_ComebackNPC -1,{ OnInit: .@c = query_sql("SELECT account_id FROM login WHERE lastlogin < '2016-06-02'", .@aid); for (.@i = 0; .@i < .@c; .@i++) { if (query_sql("SELECT value FROM acc_reg_num WHERE account_id = "+.@aid[.@i]+" AND key = '#comebackreward'", .@v) == 0) query_sql("INSERT INTO acc_reg_num(account_id, key, index, value) VALUE ("+.@aid[.@i]+", '#comebackreward', 0, 1)"); } end; OnPCLoginEvent: if (#comebackreward) { #comebackreward = 0; getitem 501, 1; } }

I'm 99% sure that by the time you've selected your char and logging into the map server, the database has already updated the lastlogin column.

remove guild_vs2 mapflag noteleport from the end of the script

Yeah but he said he didn't want to change the scripts, just make a new questprogress command that mimics herc's command.

/** * questprogress(<ID>{,PLAYTIME|HUNTING{,<char_id>}}) **/ BUILDIN_DEF(questprogress, "i??"), BUILDIN_FUNC(questprogress) { struct map_session_data *sd; enum quest_check_type type = HAVEQUEST; int ret; if( script_hasdata(st, 3) ) type = (enum quest_check_type)script_getnum(st, 3); if (!script_charid2sd(4,sd)) return SCRIPT_CMD_FAILURE; ret = quest_check(sd, script_getnum(st, 2), type)); if (ret == 0) ret = 1; if (ret == -1) ret = 0; script_pushint(st, ret); return SCRIPT_CMD_SUCCESS; } haven't tested it but it should work

in rAthena it's called checkquest https://github.com/rathena/rathena/blob/master/doc/script_commands.txt#L8377

if ( Class==Job_High_wizard ){ bonus bDefRate,-50; bonus bDef2Rate,-50; bonus bInt,20; bonus bDex,20; bonus bVit,20; bonus2 bSkillAtk,"WZ_METEOR",35; bonus2 bSkillAtk,"WZ_JUPITEL",35; bonus2 bSkillAtk,"WZ_STORMGUST",35; bonus2 bSkillAtk,"WZ_VERMILION",35; bonus2 bSubRace,RC_DemiHuman,10; bonus2 bSubRace,RC_Player,10; bonus2 bAddEffWhenHit,Eff_Stone,500; bonus bMaxHPrate,20; bonus2 bIgnoreMdefClassRate,Class_Normal,20; bonus3 bAutoSpellWhenHit,"PF_FOGWALL",5,100;} else if( Class==Job_Professor ){ bonus bInt,20; bonus bDex,20; bonus bVit,20; bonus bMaxHPrate,20; bonus2 bSkillAtk,"MG_COLDBOLT",35; bonus2 bSkillAtk,"MG_FIREBOLT",20; bonus2 bSkillAtk,"MG_LIGHTNINGBOLT",20; bonus2 bSkillAtk,"WZ_EARTHSPIKE",20; bonus2 bSkillAtk,"WZ_HEAVENDRIVE",20; bonus2 bSubRace,RC_DemiHuman,10; bonus2 bSubRace,RC_Player,10; bonus bDefRate,-20; bonus bDef2Rate,-20; bonus2 bSubEle,Ele_Wind,25;} else if(Class==Job_Acolyte) { bonus bInt,20; bonus bDex,20; bonus bVit,20; bonus bMaxHPrate,20; bonus2 bSkillAtk,"AL_HOLYLIGHT",300; bonus2 bSubRace,RC_DemiHuman,10; bonus2 bSubRace,RC_Player,10; bonus2 bIgnoreMdefClassRate,Class_Normal,20; bonus bDefRate,-67; bonus bDef2Rate,-67; bonus2 bAddEffWhenHit,Eff_Silence,500; skill "SA_DISPELL",5;} },{},{} try this

You have to use this version *setnpcdisplay("<npc name>", "<display name>", <class id>) The NPC name is the name that's in the script header, display name is the name that's shown, and the class id is the sprite id you're disguising the npc. setnpcdisplay(strnpcinfo(0), "Drops", .disguise); setnpcdisplay(strnpcinfo(0), "Poring", .original);

It really depends on how optimized you want it to be. Let's say the size is N long. The problem with looping through the list, is that EVERY time ANY monster dies, it'll look through the list, checking N times. This means that the script takes O(N) time. If N = 1, then it's not too big of a problem. But if N = 100, then it starts becoming a huge problem. You can reduce it to O(1), by using a map (or a dictionary, you can call it what you like). Unfortunately, the Athena scripting language don't have these structures. Instead, we must use arrays. This idea works by putting the cash/zeny rewards in a huge array, then accessing the array using the mob id. If there isn't a reward, then it's zero. If there is a reward, it's non-zero(the actual reward). The OnNPCKillEvent would look like this: OnNPCKillEvent: Zeny += .zeny_list[killedrid]; #CASHPOINTS += .cash_list[killedrid]; end; When you initialize the NPC, however, you need to fill those lists. We can use a similar system as Stolao's, but here's mine. //mobid, zeny, cash setarray .rewards[0], 1002, 10000, 100, 1003, 20000, 230; I don't like strings, integers are easier. We then need to add the rewards into the arrays. for (.@i = 0, .@i < getarraysize(.rewards); .@i += 3) { .zeny_list[.rewards[.@i]] = .rewards[.@i + 1]; .cash_list[.rewards[.@i]] = .rewards[.@i + 2]; } This way, initialization takes O(N) time. The tradeoff, however, is memory. You now have two arrays of the size of the highest monster id you've given a reward to. We can make a few optimizations and we end up with this: - script #extra_drop -1,{ OnNPCKillEvent: Zeny += .zeny_list[killedrid - .minId]; #CASHPOINTS += .cash_list[killedrid - .minId]; end; OnInit: //mobid, zeny, cash .minId = 1001; setarray .rewards[0], 1002, 10000, 100, 1003, 20000, 230; .@rsize = getarraysize(.rewards); for (.@i = 0, .@i < .@rsize; .@i += 3) { .zeny_list[.rewards[.@i] - .minId] = .rewards[.@i + 1]; .cash_list[.rewards[.@i] - .minId] = .rewards[.@i + 2]; } deletearray .rewards[0], .@rsize; end; } If you want to add items with drop rates and things, I'd recommend doing it in source (which is what I did for my project). I haven't tested this, but it should work. I got halfway through this script then decided to switch to source.

Put backticks (`) around it, so it looks like this SELECT * FROM `char`

This is a problem with the 970 (maybe 900 series?) of nVidia graphics cards. The only fix I've heard of is hitting ctrl+alt+delte, then going back to the game.

What does #login and #logout contain?

Why have the extra for loop, when you could just use addrid(0)? OnHour00: if(gettime(5) == 1){ query_sql("DELETE FROM `acc_reg_num` WHERE `key` = '#DRewardCon'"); addrid(0); #DRewardCon = 0; } end;

AFAIK that's in the client, you'll have to use a hex editor to change it.

That's literally what Emistry wrote for you, you just have to change OnClockXXXX to the time you want it on.

Do you have that file in your grf?

The only hard part is the renewal -> pre-renewal stat conversion. Some people have their own formulas, but choose to keep it for themselves.

If we put it all together: prontera,150,181,4 script Healer#h1-1::Healer 533,{ emotion 21; while( .@i < .sc_size ){ sc_end .sc_status[.@i]; set .@i,.@i + 1; } sc_start SC_BLESSING,.buff_duration,10; sc_start SC_INCREASEAGI,.buff_duration,10; sc_start SC_GLORIA,.buff_duration,5; sc_start SC_ASPDPOTION2,.buff_duration,0; sc_start SC_MAGNIFICAT,.buff_duration,10; sc_start SC_SUFFRAGIUM,.buff_duration,10; sc_start SC_ASSUMPTIO,.buff_duration,10; percentheal 100,100; if(getgroupid() >= 5 ){ sc_start(SC_CP_HELM, (.buff_duration), 1); sc_start(SC_CP_ARMOR, (.buff_duration), 1); sc_start(SC_CP_SHIELD, (.buff_duration), 1); sc_start(SC_CP_WEAPON, (.buff_duration), 1); switch ( basejob ) { case Job_Alchemist: set .@spirit, 445; break; case Job_Monk: set .@spirit, 447; break; case Job_Star_Gladiator: set .@spirit, 448; break; case Job_Sage: set .@spirit, 449; break; case Job_Crusader: set .@spirit, 450; break; case Job_SuperNovice: set .@spirit, 451; break; case Job_Knight: set .@spirit, 452; break; case Job_Wizard: set .@spirit, 453; break; case Job_Priest: set .@spirit, 454; break; case Job_Bard: case Job_Dancer: set .@spirit, 455; break; case Job_Rogue: set .@spirit, 456; break; case Job_Assassin: set .@spirit, 457; break; case Job_Blacksmith: set .@spirit, 458; break; case Job_Hunter: set .@spirit, 460; break; case Job_Soul_Linker: set .@spirit, 461; break; default: if ( upper == 1 && baselevel < 70 ) set .@spirit, 494; } if ( .@spirit ) { sc_start4 sc_spirit, .buff_duration, 5, .@spirit,0,0; skilleffect .@spirit, 5; } } dispbottom "Thanks."; while( getbrokenid(1) ) // repair getbrokenid(1); repairall; // atcommand "@repairall"; end; OnInit: set .buff_duration,600000; setarray .sc_status, SC_STONE,SC_FREEZE,SC_STUN,SC_SLEEP,SC_POISON,SC_CURSE,SC_SILENCE,SC_CONFUSION,SC_BLIND,SC_BLEEDING, SC_QUAGMIRE,SC_AETERNA,SC_HALLUCINATION,SC_SLOWDOWN,SC_BERSERK,SC_CHANGEUNDEAD, SC_STRIPWEAPON,SC_STRIPSHIELD,SC_STRIPARMOR,SC_STRIPHELM; set .sc_size,getarraysize( .sc_status ); waitingroom " H e a l e r",0; end; }

It should be an option to diff in NEMO Alternatively, you can preload your client with the savedata folder and set /showname to 1 in OptionInfo.lua

use /showname and it will change the font face to the non-bold version, which lets you see the party names and guild names.

That's your guild title.

I think he wants to prevent cheating by making a client that doesn't use dinput.dll

It works, but it doesn't work well. Basically every time a player walks somewhere, it checks to see if there's anyone already on the cell. This will block freewalk. Unfortunately, the way the client handles skills doesn't lend itself to this system. Normally if you cast a spell out of range, the client calculates the distance it needs to travel and sends a walk request to the server. If there's someone standing on the cell that the client chose, the server will reject the request and the player will not move at all. So while it does block freewalk, it also prevents legitimate ways to occupy the same cell.