fictionx

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 `"+ .@item_db$ +"`.`id` FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_db$ +"` ON `"+ .@item_db$ +"`.`id` = `"+ .@mob_db$ +"`.`dropcardid` WHERE type = 6 group by name_japanese", .@id); query_sql("SELECT `"+ .@item_db$ +"`.`id` FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_db$ +"` ON `"+ .@item_db$ +"`.`id` = `"+ .@mob_db$ +"`.`dropcardid` WHERE mexp > 0 and type = 6 by name_japanese", .@MVP); query_sql("SELECT `"+ .@item_db$ +"`.`id` FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_db$ +"` ON `"+ .@item_db$ +"`.`id` = `"+ .@mob_db$ +"`.`dropcardid` WHERE mode & 32 and type = 6 by name_japanese", .@BOSS); Note: i'm using the following script : Link Greetings.-

That array fill the shop name, the full syntax is npcshopadditem "card_mob#"+ .alphabet$[.@i], .@id[.@j], 1000000; id was called from .@nb = 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$[.@i] +"' group by name_japanese ", .@id );

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 ) { .@s = select( .alphabet_menu$ ) -1; close2; callshop "card_mob#"+ .alphabet$[.@s], 1; end; } close2; callshop "card_mob#"+( ( @menu == 2 )? "miniboss":"MVP" ), 1; end; OnInit: if (checkre(0)) { .@mob_db$ = "mob_db_re"; .@item_db$ = "item_db_re"; } else { .@mob_db$ = "mob_db"; .@item_db$ = "item_db"; } freeloop 1; .@total = query_sql( "SELECT DISTINCT LEFT( `name_japanese`, 1 ) AS alphabets FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_db$ +"` ON `"+ .@item_db$ +"`.`id` = `"+ .@mob_db$ +"`.`dropcardid` WHERE ~(`MODE`) & 32 AND `type` = 6 GROUP BY `name_japanese` ORDER BY alphabets;", .alphabet$ ); for ( .@i = 0; .@i < .@total; .@i++ ) { .alphabet_menu$ = .alphabet_menu$ + .alphabet$[.@i] +" Cards:"; .@nb = query_sql( "SELECT `"+ .@item_db$ +"`.`id` FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_db$ +"` ON `"+ .@item_db$ +"`.`id` = `"+ .@mob_db$ +"`.`dropcardid` WHERE ~(`MODE`) & 32 AND `type` = 6 AND LEFT( `name_japanese`, 1 ) = '"+ .alphabet$[.@i] +"' GROUP BY `name_japanese` ORDER BY `name_japanese` LIMIT 128;", .@id ); npcshopdelitem "card_mob#"+ .alphabet$[.@i], 501; for ( .@j = 0; .@j < .@nb; .@j++ ) npcshopadditem "card_mob#"+ .alphabet$[.@i], .@id[.@j], 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.-

Emp Breaker, Lucky Event, ManHunt still with the same problem that was wrote by srhmike. Hope one day stolao can fix this awesome script

Thank You Developers !

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.

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

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

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.

30,Devils Tower,14400,300,1@tnml,50,104,1@tnml2,1@tnml3 change to 30,Devils Tower,14400,300,1@tnm1,50,104,1@tnml,1@tnm3

Thank You!

@Quesooo Uhm, i can't reproduce your error, it's working fine for me. @Rododark Be careful here: mes "^0000ffAll the traces of entering the central laboratory have been erased. Speaking with the Civilization Explorer seems possible.^000000";

Try to restart the server, maybe the instance_db isn't reloaded.

Probably you missed to put : 30,Devils Tower,14400,300,1@tnml,50,104,1@tnml2,1@tnml3 in instace DB or check if in the script the name is the same that is in the instance_db

it's looking good, pretty clear. good work

https://www.divine-pride.net

would be nice if the 2017 clients support the 64k hairstyle feature

Thank you!. Solved.

Hi, How can i make that the player can't move allowing the mob attack him?. i'm using setcell with the flag cell_walkable,0 but the problem is that command make the player have immunity to attack from a mob. (Like @monsterignore). Thank you in advance

Up for the color and hair style in the newest clients. A lot of crash when i you try to change color hairstyle in 25 and above.

Thank you for the amazing work

Gracias, estaré atento

Hola Zikoziz, si no tienes problemas me lo puedes enviar para subirlo al repositorio. La idea es más que nada mantener activa la comunidad hispana de rAthena, porque estoy seguro de que no somos pocos. Saludos

Estimados, Buenos días, junto con saludarlos les propongo generar un repositorio GIT con la intención de traducir la mayor cantidad de NPCs, ya sea de misiones, ciudades, instancias etc. Incluso de realizar traducciones al iteminfo. El propósito es que la comunidad hispana tenga su propio repositorio con su lengua materna. Si están interesados, podemos seguir el siguiente proyecto. Quedo atento a sus comentarios. FictionX