fictionx

Members
  • Content count

    100
  • Avg. Content Per Day

    0
  • Joined

  • Last visited

  • Days Won

    1

fictionx last won the day on September 28 2017

fictionx had the most liked content!

Community Reputation

13 Good

1 Follower

About fictionx

  • Rank
    Poporing
  • Birthday 07/05/1993

Profile Information

  • Gender
    Male

Recent Profile Visitors

1,154 profile views
  1. fictionx

    Help with some problems!

    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
  2. 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.-
  3. fictionx

    Sader's Paid Services

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

    Flux CP Card Database

    Hope you can do it Thank you ! UP
  5. fictionx

    Flux CP Card Database

    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.-
  6. fictionx

    Flux CP Card Database

    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.-
  7. fictionx

    Card Seller

    Solved, please close this topic. Thank you @Alayne
  8. fictionx

    Card Seller

    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]item_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.-
  9. fictionx

    Card Seller

    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] );
  10. fictionx

    October Digest 2017

    Awesome !
  11. fictionx

    Card Seller

    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.-
  12. Emp Breaker, Lucky Event, ManHunt still with the same problem that was wrote by srhmike. Hope one day stolao can fix this awesome script
  13. fictionx

    [Suggestion] Refinary UI

    Thank You Developers !
  14. fictionx

    Error Instalation - use_existing

    I fixed the error, the problem was in cp_itemshop, for some reason in the instalation try to reinstall the same table trying to add the "use_existing". I manually removed the field and the problem has fixed.
  15. fictionx

    Error Instalation - use_existing

    Hmm, i used a empty database. I'll try to delete all the tables that has been installed by the schemes file.