fictionx

Hi, i wondering if someone can help me to fix the following code that i have from php. The problem that i have, it's that isn't counting the total card in the server, always stated in null valor.

@Easycore can you upload to the last rev :P?. Actually the diff is outdated @edit: For some reason only in linux i had the problem when i tried to apply the diff

try this: In skill.cpp case UNT_MAGNUS: //if (!battle_check_undead(tstatus->race,tstatus->def_ele) && tstatus->race!=RC_DEMON) // break; skill_attack(BF_MAGIC,ss,&unit->bl,bl,sg->skill_id,sg->skill_lv,tick,0); break;

Thank you for the content, as i see the ranking and happy hour isn't available right?

1.- In skill.cpp change status_heal(src, 0, status_get_lv(bl)*(95+15*rate)/100, 2); to status_heal(src, status_get_lv(bl)*(95+15*rate)/100,0 , 2); 2.- require more edit and testing, you can check in skill.cpp too

Hi, i'm wondering if exist a real solution for the bug that have the clients 2017+ with the hairstyle who are above of the style 27. i tried using https://github.com/secretdataz/NEMO/commit/c88fbbb24f61458a6907da7f057754f62cfb2c97 but isn't working. The problem appear when you change your hairstyle and relog the character. The client crashes instantanly. I've tried it on: 2017-06-14 2017-05-17 2017-12-28 Greetings.-

Wonderful service, he's so fast that only take a few minutes to do the work [10/10] Highly recommended

Hope you can do it Thank you ! UP

Hi, thank you for your response. This addon recollects the entire data of the MvP Cards that the players have. For example: In the menu display all the MvP Card with his bmp image, and below of this image it will appear a number (0) or (1,2,3,etc...), and that means that one or two, three, etc players of the server have that cards. Note: I'll edit the title of this topic. Greetings.-

Hi, Anyone have a database card for flux cp?. i have saw in some server that i cannot remember right now, but this addon it's very popular. Greetings.-

Solved, please close this topic. Thank you @Alayne

Oh, that is true, i'll try to fix that issue. So, the following syntax for try to recover data from normal, mvp and boss cards should be work right?. query_sql("SELECT `"+ [email protected]_db$ +"`.`id` FROM `"+ [email protected]_db$ +"` RIGHT JOIN `"+ [email protected]_db$ +"` ON `"+ [email protected]_db$ +"`.`id` = `"+ [email protected]_db$ +"`.`dropcardid` WHERE type = 6 group by name_japanese", [email protected]); query_sql("SELECT `"+ [email protected]_db$ +"`.`id` FROM `"+ [email protected]_db$ +"` RIGHT JOIN `"+ [email protected]_db$ +"` ON `"+ [email protected]_db$ +"`.`id` = `"+ [email protected]_db$ +"`.`dropcardid` WHERE mexp > 0 and type = 6 by name_japanese", [email protected]); query_sql("SELECT `"+ [email protected]_db$ +"`.`id` FROM `"+ [email protected]_db$ +"` RIGHT JOIN `"+ [email protected]_db$ +"` ON `"+ [email protected]_db$ +"`.`id` = `"+ [email protected]_db$ +"`.`dropcardid` WHERE mode & 32 and type = 6 by name_japanese", [email protected]); Note: i'm using the following script : Link Greetings.-

That array fill the shop name, the full syntax is npcshopadditem "card_mob#"+ .alphabet$[[email protected]], [email protected][[email protected]], 1000000; id was called from [email protected] = query_sql( "select item_db_re.id from item_db_re right join mob_db_re on item_db_re.id = mob_db_re.dropcardid where type = 6 and left( name_japanese, 1 ) = '"+ .alphabet$[[email protected]] +"' group by name_japanese ", [email protected] );

Awesome !

Hi, I'm wondering if someone can help me to fix the following script, the problem that it have is with the menus, for example in the option "Normal Cards" appear MvP Cards, in the option "Mini-boss","MvP Cards", there is no cards in the shop. prontera,155,177,5 script Card Seller 100,{ mes "Welcome to card seller ... meh lazy to say"; next; if ( select ( "Normal Cards", "Mini-boss Cards", "MVP Cards" ) == 1 ) { [email protected] = select( .alphabet_menu$ ) -1; close2; callshop "card_mob#"+ .alphabet$[[email protected]], 1; end; } close2; callshop "card_mob#"+( ( @menu == 2 )? "miniboss":"MVP" ), 1; end; OnInit: if (checkre(0)) { [email protected]_db$ = "mob_db_re"; [email protected]_db$ = "item_db_re"; } else { [email protected]_db$ = "mob_db"; [email protected]_db$ = "item_db"; } freeloop 1; [email protected] = query_sql( "SELECT DISTINCT LEFT( `name_japanese`, 1 ) AS alphabets FROM `"+ [email protected]_db$ +"` RIGHT JOIN `"+ [email protected]_db$ +"` ON `"+ [email protected]_db$ +"`.`id` = `"+ [email protected]_db$ +"`.`dropcardid` WHERE ~(`MODE`) & 32 AND `type` = 6 GROUP BY `name_japanese` ORDER BY alphabets;", .alphabet$ ); for ( [email protected] = 0; [email protected] < [email protected]; [email protected]++ ) { .alphabet_menu$ = .alphabet_menu$ + .alphabet$[[email protected]] +" Cards:"; [email protected] = query_sql( "SELECT `"+ [email protected]_db$ +"`.`id` FROM `"+ [email protected]_db$ +"` RIGHT JOIN `"+ [email protected]_db$ +"` ON `"+ [email protected]_db$ +"`.`id` = `"+ [email protected]_db$ +"`.`dropcardid` WHERE ~(`MODE`) & 32 AND `type` = 6 AND LEFT( `name_japanese`, 1 ) = '"+ .alphabet$[[email protected]] +"' GROUP BY `name_japanese` ORDER BY `name_japanese` LIMIT 128;", [email protected] ); npcshopdelitem "card_mob#"+ .alphabet$[[email protected]], 501; for ( [email protected] = 0; [email protected] < [email protected]; [email protected]++ ) npcshopadditem "card_mob#"+ .alphabet$[[email protected]], [email protected][[email protected]], 1000000; } freeloop 0; end; } - shop card_mob#A -1,501:1000 - shop card_mob#B -1,501:1000 - shop card_mob#C -1,501:1000 - shop card_mob#D -1,501:1000 - shop card_mob#E -1,501:1000 - shop card_mob#F -1,501:1000 - shop card_mob#G -1,501:1000 - shop card_mob#H -1,501:1000 - shop card_mob#I -1,501:1000 - shop card_mob#J -1,501:1000 - shop card_mob#K -1,501:1000 - shop card_mob#L -1,501:1000 - shop card_mob#M -1,501:1000 - shop card_mob#N -1,501:1000 - shop card_mob#O -1,501:1000 - shop card_mob#P -1,501:1000 - shop card_mob#Q -1,501:1000 - shop card_mob#R -1,501:1000 - shop card_mob#S -1,501:1000 - shop card_mob#T -1,501:1000 - shop card_mob#U -1,501:1000 - shop card_mob#V -1,501:1000 - shop card_mob#W -1,501:1000 - shop card_mob#X -1,501:1000 - shop card_mob#Y -1,501:1000 - shop card_mob#Z -1,501:1000 - shop card_mob#miniboss -1,501:1000 - shop card_mob#MVP -1,501:1000 Greetings.-