AnnieRuru

ok ... now I hit this encoding issue already from this post http://rathena.org/board/topic/77088-certain-map-weapon-restriction/?p=239079 the original diff looks like this + while ( i <= l && k < MAX_RESTRICTED_LIST ) { + if ( w4[i] != ' ' && w4[i] != ' ' && w4[i] != ',' && w4[i] != '\0' ) { + temp[j++] = w4[i]; + } + else if ( w4[i-1] != ' ' && w4[i-1] != ' ' && w4[i-1] != ',' ) { + temp[j] = '\0';it has the '\0'but when upload to rathena pastebin, it becomes + if ( w4[i] != ' ' && w4[i] != ' ' && w4[i] != ',' && w4[i] != '' ) { + temp[j++] = w4[i]; + } + else if ( w4[i-1] != ' ' && w4[i-1] != ' ' && w4[i-1] != ',' ) { + temp[j] = '';the \0 DISAPPEAR !no need to say if I view it raw, some weird symbols again ... + if ( w4[i] != ' ' && w4[i] != ' ' && w4[i] != ',' && w4[i] != '�' ) { + temp[j++] = w4[i]; + } + else if ( w4[i-1] != ' ' && w4[i-1] != ' ' && w4[i-1] != ',' ) { + temp[j] = '�';if download from the pastebin, it also has the problemso I use back attachment ... attachment doesn't have this problem

if ( isequipped(4128) ) { unequip EQI_HAND_L; end; } put this at the most beginning of your script field

don't use query_sql here use attachrid-on-all-accounts addrid better [paste=dbdfw23gsxm]

xxxxx,Custom_Hat,Custom Hat, ....... { if ( !isequipped(4128) ) bonus bNoMagicDamage, 90; },{},{}

bonus2 bAddEff,e,x; Adds a x/100 chance to cause effect e to the target when attacking (e.g. x=100 makes 1% chance, x=10000 makes 100% chance, etc) Eff_Stone 0 Eff_Freeze 1 Eff_Stun 2 Eff_Sleep 3 Eff_Poison 4 Eff_Curse 5 Eff_Silence 6 Eff_Confusion 7 Eff_Blind 8 Eff_Bleeding 9 Eff_DPoison 10 Eff_Fear 309 Eff_Burning 310 stone, freeze, stun and sleep ... are possible candidates ... if you want a custom made effect here ... you have to do source modification

mob controller system ? http://rathena.org/board/topic/91000-make-this-query-check-on-1000-pet-intimacy/?p=238215 just patch it, even your code above will work ... even without using mobspawn script command yes, this source modification will make the monster able to detect other monster in battle.c if ( md->state.killer ) state |= BCT_ENEMY; //By default everyone hates mobs. EDIT: I know you are decent level scripter ... if you wanna learn mob controller script I can teach ya

[paste=1a4xw30mq7va] actually strtok is not thread safe ... I'm thinking writing a new one ok done lol, quite fast [paste=43c3y0h62jbk] EDIT: I think there's some problem with encoding ... I use attachment for the time being noitem_20140108_.patch

getitembound ? character bound I think

item type 11 -> IT_DELAYCONSUME actually I think it fits the description item type 11 is actually meant for itemskill if you change wing of fly (601) into item type 2 (IT_USABLE), this item will no longer working meaning, itemskill is only work on item type 11 run this query and you'll find most of them has itemskill with it select * from item_db_re where type = 11; the reason it says delay consume is because of the targeting cursor for example Fire Scroll (690) when you use it, the cursor comes out, but the item haven't consumed yet it only consumed after the target is valid ( you can't cast on players in non-pvp map ... etc )

I'm sure you can hold shift to kill the mob its a client side limitation -> players can only be attack in pvp/gvg/battleground maps its the same principle that a player under @killable in non-pvp map, other players need to hold shift key to target him/her as for the script ... seems like I don't have enough time for it ... I bookmarked more than 20 topics now ... this is just 1 of them

http://dba.stackexchange.com/questions/15250/how-to-do-a-case-sensitive-search-in-where-clause by default, the table creation use charset = latin1; means it couldn't do a case-sensitive search if you want to do a case-sensitive in a query, use BINARY select * from `char` where name = binary('AnnieRuru');however using BINARY might have performance hit if it is a big tableso its more recommend to convert your sql table to collate with latin1_general_cs let's say this is a sample table create table testtest ( id int(11) primary key auto_increment, name varchar(23) )engine = innodb;do an alter table syntax alter table testtest modify column name varchar(23) collate latin1_general_cs;or just put it into the table creation create table testtest ( id int(11) primary key auto_increment, name varchar(23) )engine = innodb default charset = latin1 collate latin1_general_cs; @leondedios set .@garbage,query_sql("SELECT `codes`,`redeem_time` FROM `reward_logs` ORDER BY pool ASC LIMIT 25",.@code$); for(set .@i,1; .@i <= .@garbage; set .@i,.@i++) { query_sql "DELETE FROM `reward_logs` WHERE `codes` = '" + escape_sql(.@code$[0]) + "'"; // Number 1 row will be deleted. query_sql "DELETE FROM `reward_logs` WHERE `codes` = '" + escape_sql(.@code$[.@i]) + ""; // Numbers from 2-25 rows will be deleted. }change into set .@garbage,query_sql("SELECT `code`,`redeem_time` FROM `reward_logs` ORDER BY pool ASC LIMIT 25",.@code$); for(set .@i,1; .@i <= .@garbage; set .@i,.@i++) { query_sql "DELETE FROM `reward_logs` WHERE `code` = '" + escape_sql(.@code$[0]) + "'"; // Number 1 row will be deleted. query_sql "DELETE FROM `reward_logs` WHERE `code` = '" + escape_sql(.@code$[.@i]) + ""; // Numbers from 2-25 rows will be deleted. }

update item_db_re set script = 'if (strcharinfo(3) == "prontera") { delitem 12103,1; monster "this",-1,-1,"--ja--",-3,1,""; } else dispbottom "This item can\'t be used on your current map.";', type = 11 where id = 12103;no idea why you say not working make sure you have change the item type from 2 to 11

LMAO !! I totally forgot about it because I copy-pasted from my old source edits http://www.eathena.ws/board/index.php?s=&showtopic=273922&view=findpost&p=1502506 yes yours will run much smoother my source coding skill still sux big time ...

if you want to learn quest log system http://www.eathena.ws/board/index.php?s=&showtopic=269839&view=findpost&p=1481667 let me test is this working in latest rathena ... seems still working for me ... or maybe I'm just using outdated client ...

@lighta item type 11 ( IT_DELAYCONSUME ) can be reuse again and again you can try update item_db_re set type = 11 where id = 501and your red potion will becomes unlimited usage item type IT_DELAYCONSUME is actually meant for itemskill itemskill doesn't seem to work with item type 0 (IT_HEALING) or 2 (IT_USABLE), so itemskill has to use type 11 because of its unique characteristic of this item type it has became a trick for us to use item type 11 for reusable items to lessen the burden of making nobranch mapflag open db\map-index.txt, find ^([a-z0-9_@-]*)$replace with regular expression \1 mapflag nobranchthen there's only a few lines need to edit ...

yeah I got it ... and yes that coding style belongs to zephyrus .. I can read it no wonder this patch doesn't compatible with eamod check your inbox

what I mean is I want the source code of the successenchant script command nvm I found it here http://hercules.ws/board/topic/1709-can-anyone-help-me-on-this-script-commands/ script [paste=67x3nspmzn25] source [paste=5oruqcnhfr4o]

dunno why he can gives wrong answer change this value higher like 100 and, don't use addtimer command too much its exactly like this to happen, better switch your script to use sleep2 command

that's nice ! I think can use this pastebin from now on forget about 1. it just a minor issue lol 2 and 4 has been fixed 3. actually the [Type] there ... there's too many I'm thinking we actually just use some of them athena (default) C++ PHP JavaScript SQL Diff Text issit possible to only enable only these few, so there's no need to drag the long long drop-box ... 5. I dunno ... so that when I look my own pastebin from my user profile I can click on the topic link from this paste to see this script belongs to which topic ... this one is not important, just some minor suggestion ... or actually I can just paste the topic url into the [Title] straight away

just fixed it, me just play around with this new pastebin

how to post a reply/comment on the badge nomination ?

successenchant .@part,.@Enchant;what is this script command ? I never seen this command before enchanting an armor is actually just putting a card into 4th socket of the armor which you can always do it with getitem2 http://rathena.org/board/topic/77031-armor-enchanter-npc/?p=170869

note that the type of timer runs in an event script, make sure all them are running without rid attached I think if you want to play around with the script, I better rewrite it, since this script is so unoptimized [paste=5wz8uee3plf5] hehe ... use this new pastebin if you want to make obstacles create a new npc with sprite ID -1 and trigger OnTouch mjolnir_04,151,209,5 script koth_slow#1 -1,2,2,{ end; OnTouch: // sc_start SC_STUN, rand(1000,5000), 1; // sc_start SC_BLIND, rand(5000,10000), 1; sc_start SC_DECREASEAGI, rand(1000,5000), 10; end; OnInit: while ( checkcell( strnpcinfo(4), .@x = rand(450), .@y = rand(450), cell_chknopass ) ); movenpc strnpcinfo(0), .@x, .@y; end; }there are a bunch of status change (sc_) defined in const.txt, you can play around with themits better to randomize the npc location every time the event start so after the "GO!" announcement, add donpcevent "koth_slow#1"; ... and so on to move the npc into random locations

how about you post your pc.h and atcommand.c file in this pastebin http://rathena.org/board/pastebin/ so I make the edit for ya

akkarin just made a pastebin into our forum now should be eliminate the problem the tabbing caused by {code} tag http://rathena.org/board/pastebin/5jaxbnhp4a3l/type/athena/ http://rathena.org/board/pastebin/40ln8nw44o32/ PS: actually I just want to test the new pastebin system lol