fictionx

Members
  • Content count

    97
  • 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

12 Good

1 Follower

About fictionx

  • Rank
    Santa Poring
  • Birthday 07/05/1993

Profile Information

  • Gender
    Male

Recent Profile Visitors

1,062 profile views

Mood

  • Enraged
  • Currently Feeling Enraged
  1. Flux CP Card Database

    Hope you can do it Thank you !
  2. 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.-
  3. 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.-
  4. Card Seller

    Solved, please close this topic. Thank you @Alayne
  5. 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]_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.-
  6. 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] );
  7. October Digest 2017

    Awesome !
  8. 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.-
  9. Emp Breaker, Lucky Event, ManHunt still with the same problem that was wrote by srhmike. Hope one day stolao can fix this awesome script
  10. [Suggestion] Refinary UI

    Thank You Developers !
  11. 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.
  12. 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.
  13. Error Instalation - use_existing

    Hi, I'm trying to install a fresh flux cp, but have problem with the following message " Message: Critical MySQL error in Installer/Updater: Duplicate column name 'use_existing' " and the instalation stop. Anyone have an idea what is the problem?.
  14. 2017-05-17aRagexeRE

    I don't know if i'm the only one who have problems with "illegal format" in the skill "Rich's Coin" (from rebellion) when i try to drag to somewhere. I can not test if the problem is just with this client or my data.