Omitting specific cards? Script from AnnieRuru.

[Currently]

comodo,193,155,4 script Fiesta Cards 100,{

mes "[Fiesta Carder]";

mes "Welcome to the world of Fiesta Ragnarok Online!";

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:

freeloop 1;

.@total = query_sql("select distinct left( name_japanese, 1 ) as aaa 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 aaa", .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;

}

.@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 mexp = 0 group by item_db.id order by name_japanese limit 128", .@id );

npcshopdelitem "card_mob#miniboss", 501;

for ( .@i = 0; .@i < .@nb; .@i++ )

npcshopadditem "card_mob#miniboss", .@id[.@i], 1000000;

npcshopdelitem "card_mob#miniboss", 4147; // lol ... ok me lazy already

.@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 mexp != 0 group by item_db.id order by name_japanese limit 128", .@id );

npcshopdelitem "card_mob#MVP", 501;

for ( .@i = 0; .@i < .@nb; .@i++ )

npcshopadditem "card_mob#MVP", .@id[.@i], 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

 

 

How to remove specific cards such as "Poring Card" in this script? 

 

This script is from AnnieRuRu btw.

 

[Capuche]

Replace under oninit

OnInit:
	freeloop 1;
	.@list$ = "4001,4002";// black list card normal mob
	.@total = query_sql("select distinct left( name_japanese, 1 ) as aaa 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 aaa", .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] +"' and mob_db.dropcardid not in ("+ .@list$ +") 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;
	}
	.@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 mexp = 0 group by item_db.id order by name_japanese limit 128", .@id );
	npcshopdelitem "card_mob#miniboss", 501;
	for ( .@i = 0; .@i < .@nb; .@i++ )
		npcshopadditem "card_mob#miniboss", .@id[.@i], 1000000;
	npcshopdelitem "card_mob#miniboss", 4147; // lol ... ok me lazy already
	.@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 mexp != 0 group by item_db.id order by name_japanese limit 128", .@id );
	npcshopdelitem "card_mob#MVP", 501;
	for ( .@i = 0; .@i < .@nb; .@i++ )
		npcshopadditem "card_mob#MVP", .@id[.@i], 1000000;
	freeloop 0;
	end;

.@list$ = "4001,4002";// black list card normal mob