Card Seller

[fictionx]

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

Edited October 26, 2017 by fictionx

[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 `"+ [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 `"+ .@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.-

Edited November 22, 2017 by fictionx

[LOVE0825]

SQL?

[Alayne]

I might be mistaken, but I can't see a distinction in your sql command to get mvp / mini boss or normal only. 

I suppose you were willing to use the Mode option, but I think that using MEXP column would be easier.

Also, you're only filling array by using 

"card_mob#"+ .alphabet$[.@i]

This will never add anything in 

-	shop	card_mob#miniboss	-1,501:1000
-	shop	card_mob#MVP	-1,501:1000

As 'miniboss' and 'MVP' aren't exactly letters from the alphabet ^^

[fictionx]

10 hours ago, Alayne said:

I might be mistaken, but I can't see a distinction in your sql command to get mvp / mini boss or normal only. 

I suppose you were willing to use the Mode option, but I think that using MEXP column would be easier.

Also, you're only filling array by using 

"card_mob#"+ .alphabet$[.@i]

This will never add anything in 

-	shop	card_mob#miniboss	-1,501:1000
-	shop	card_mob#MVP	-1,501:1000

As 'miniboss' and 'MVP' aren't exactly letters from the alphabet ^^

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 );

 

Edited November 22, 2017 by fictionx

[Alayne]

Yeah I know but this request you have gives the first letter of all names grouped by first letter. So a, b, c... But you'll never have miniboss or mvp as a result. See what I mean? 

[fictionx]

Solved, please close this topic.

 

Thank you @Alayne