fictionx

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

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,[email protected],50,104,[email protected],[email protected] change to 30,Devils Tower,14400,300,[email protected],50,104,[email protected],[email protected]

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,[email protected],50,104,[email protected],[email protected] 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

And i have no doubt ;D