Requesting Card Seller Script

tsubasa amami · November 2, 2012

Hi, can anyone help me with Card Seller Npc's? "A to Z" miniboss and MVP. thank you so much.

i've searched the forums for 2 days but am unable to find it =(

tsubasa amami · November 2, 2012

i understand what u mean, but i dont know how to add / create npc's and everytime i try to overwrite a npc / edit it the whole npc will be lost. so im here to request and see if anyone can help me. this is the request section right? hope i aint flouting any rules.

Emistry · November 2, 2012

use this tool to generate your shop script...

https://rathena.org/board/index.php?/files/file/2597-shoper/

Euphy · November 2, 2012

http://www.eathena.ws/board/index.php?showtopic=240194

AnnieRuru · November 2, 2012

http://rathena.org/b...ay/#entry149250

SQL abuse

prontera,156,184,5	script	kjdsfksdfj	100,{
.@nb = query_sql("select distinct left( name_japanese, 1 ) as aaa from item_db where type = 6 union select distinct left( name_japanese, 1 ) from item_db2 where type = 6 order by aaa", .@list$ );
for ( .@i = 0; .@i < .@nb; .@i++ )
	.@menu$ = .@menu$ + .@list$[.@i] +":";
.@alphabet$ = .@list$[ select( .@menu$ ) -1 ];
.@menu$ = "";
.@nb = query_sql("select id, name_japanese from item_db where type = 6 and left( name_japanese, 1 ) = '"+ .@alphabet$ +"' and name_japanese not like '%+%' union select id, name_japanese from item_db2 where type = 6 and left( name_japanese, 1 ) = '"+ .@alphabet$ +"' and name_japanese not like '%+%' order by name_japanese limit 128", .@id, .@name$ );
for ( .@i = 0; .@i < .@nb; .@i++ )
	.@menu$ = .@menu$ + .@name$[.@i] +":";
.@select = select( .@menu$ ) -1;
getitem .@id[ .@select ], 1;
close;
}

EDIT: tomorow I'll try do with dynamic shop ... so it will look just like in-game shop

Edited November 2, 2012 by AnnieRuru

tsubasa amami · November 4, 2012

@ Euphy link's down =x @emistry how do i use it? @annieruru hi there, thanks for responding. but it seems that after adding that scipt and after reloading script / restarting server , the npc would not load up still. am i doing anything wrong here?

@emistry , after adding the npc using the shopper3.0 prog. the npc doesnt show up at all. can you guild me thru it? thanks a lot.

can any1 tell me how come the npc doesn't load up after i reloadscript? it has no error, its just that the npc wont even show up at the place that i intended to place it at.

Edited November 4, 2012 by tsubasa amami

Euphy · November 5, 2012

The link is fine, you have to be logged in to download attachments.

http://pastebin.com/raw.php?i=2GPBMMgg

tsubasa amami · November 5, 2012

hi euphy, thank you for replying. Can you tell me what's wrong with my script? after i reloaded the script in, the npc doesn't appear at all. i've read about something to add in conf file that i have? is there any way that u can teach me what is it about? thank you so much.

Peopleperson49 · November 7, 2012

I didn't create this but I still have it in my old script repository. I hope it helps. It might need slight updating, but it has most cards.

Peopleperson49

AllCardShop.txt

Edit: Sorry I didn't realize that Euphy has already posted pretty much the same thing. When I clicked the link before it gave me an invalid page. Oh well...

Edited November 7, 2012 by Peopleperson49

stydianx · November 8, 2012

adding custom NPC's:

put file in trunk/npc/custom

then update your athena-custom by puting <filename>.txt

else..

somethings wrong with your script..

if you can let me see your script, i might be able to edit it for you or look if theres something wrong..

Peopleperson49 · November 8, 2012

You will follow this format in your scripts_custom.conf: npc: npc/custom/AllCardShop.txt.

Peopleperson49

AnnieRuru · November 10, 2012

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

just write for fun

Edited November 10, 2012 by AnnieRuru

Euphy · November 10, 2012

Annie, that's awesome. You should make a release for that. xD

AnnieRuru · November 10, 2012

LMAO !!

but to me this script is very easy :ani_swt3:

and me lazy to remove certain mobs

I notice certain MVPs is being repeated in mini-boss, and lazy to find them out 1 by 1 hahaha

maybe some other day when I think its time to update my old script, yeah this one might add to the collections

currently trying to tackle this script

Ryokem · November 10, 2012

LMAO !!

but to me this script is very easy

LMAO.

I loved the "aaa" variable xD

Euphy · November 10, 2012

npcshopdelitem "card_mob#miniboss", 501,4027,4049,4055,4061,4091,4093,4095,4105,4111,4147,4153,4170,4273,4292,4344;
npcshopdelitem "card_mob#MVP", 501,4074,4127,4210,4246,4410,4419;

I think that's all of them.

AnnieRuru · November 10, 2012

just when I found out can use IN statement to counter the value being repeated in other table

select item_db.id, name_english from item_db
right join mob_db on item_db.id = mob_db.dropcardid
where mode & 32 and type = 6 and mexp != 0 and item_db.id in
(
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
)
group by item_db.id order by name_japanese limit 128;

this execution time is 0.4 seconds compare to 0.002 sec without using IN <.<

so ... have to use Euphy's method...

thx to Euphy <3

@Ryokem

lol, me no programming background ... high school graduate only, hahaha of cos sure laughable XD

Edited November 10, 2012 by AnnieRuru

Ryokem · November 10, 2012

@Ryokem

lol, me no programming background ... high school graduate only, hahaha of cos sure laughable XD

Well, it was some sort of fun xD Anyway variable names are arbitrary even if common sense says to use sort of names to identify them xD

And well, I'm attending the 5th yeah at university about Informatic Technologies, but I'm impressed about your "self-made" knowledges about scripting and querying.

Nothing to make fun of you, on the contrary you are kind of enviable.

Anyway I believe that listing cards as Euphy said will be better from a client-side point of view, sql will just slow down the process even if it works pretty well ^^

AnnieRuru · November 11, 2012

Anyway I believe that listing cards as Euphy said will be better from a client-side point of view, sql will just slow down the process even if it works pretty well ^^

but I called them up only once inside OnInit: label

means the query is only executed only once during server startup

if you mean the script on post#5 I agree

but the script on post#12 I have to disagree

I also knew that long time ago though

EDIT:

or probably a better way is ...

A~Z use query_sql + dynamic shop

mini-boss and MVP use "shop" npc ?

seems this idea is better

EDIT2:

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:
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;
}
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,4054:1000000,4241:1000000,4391:1000000,4428:1000000,4426:1000000,4290:1000000,4300:1000000,4392:1000000,4171:1000000,4397:1000000,4174:1000000,4398:1000000,4179:1000000,4266:1000000,4451:1000000,4250:1000000,4423:1000000,4354:1000000,4047:1000000,4163:1000000,4384:1000000,4431:1000000,4394:1000000,4395:1000000,4197:1000000,4198:1000000,4393:1000000,4203:1000000,4207:1000000,4440:1000000,4396:1000000,4254:1000000,4238:1000000,4237:1000000,4429:1000000,4406:1000000,4427:1000000,4306:1000000,4183:1000000
-	shop	card_mob#MVP	-1,4236:1000000,4359:1000000,4425:1000000,4145:1000000,4168:1000000,4386:1000000,4142:1000000,4134:1000000,4137:1000000,4123:1000000,4330:1000000,4441:1000000,4352:1000000,4408:1000000,4128:1000000,4324:1000000,4363:1000000,4365:1000000,4430:1000000,4403:1000000,4419:1000000,4376:1000000,4357:1000000,4276:1000000,4361:1000000,4146:1000000,4399:1000000,4132:1000000,4131:1000000,4143:1000000,4135:1000000,4144:1000000,4148:1000000,4121:1000000,4407:1000000,4342:1000000,4263:1000000,4367:1000000,4318:1000000,4302:1000000,4305:1000000,4374:1000000,4372:1000000

like this perhaps, and the query

// mini-boss
select item_db.id, name_japanese from item_db right join mob_db on item_db.id = mob_db.dropcardid
where mode & 32 and type = 6 and mexp = 0
and item_db.id not in
(
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 item_db.id not in
(
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;

// MVP
select item_db.id, name_japanese from item_db right join mob_db on item_db.id = mob_db.dropcardid
where mode & 32 and type = 6 and mexp != 0
and item_db.id not in
(
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 item_db.id not in
(
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;

EDIT3:

found out the reason that slowing down the query time is because of having 'group by' inside 'in'

so removed it

Edited November 11, 2012 by AnnieRuru

Ryokem · November 11, 2012

Anyway I believe that listing cards as Euphy said will be better from a client-side point of view, sql will just slow down the process even if it works pretty well ^^
but I called them up only once inside OnInit: label
means the query is only executed only once during server startup

if you mean the script on post#5 I agree

but the script on post#12 I have to disagree

I also knew that long time ago though

Tho, I didn't even notice the script in Post #5 and #12 were different, anyway the one at Post #12 is sure way better than #5. xD

And about which script to use, mostly depends if he wants the list to auto-update each time a new card is added to the database or not.

Both seems good even if I still really can't get why to use the server heap using sql when you don't really need to

AnnieRuru · November 11, 2012

lol if it is pvp ladder or quest board script

where the data is manipulated in-game

of course have to execute query_sql in real-time

but this script,

1.

to add a new card, also means need to add things like num2itemdesctable.txt etc at the client side

it also means, need to shut down the server to do so

so my method of using OnInit is correct

2.

my query only search inside `item_db` table, not `item_db2` table LMAO /heh

GM Takumirai · November 11, 2012

what if i just want the normal cards , and removing mini boss and mvp cards? what to remove in the script?

Ryokem · November 11, 2012

what if i just want the normal cards , and removing mini boss and mvp cards? what to remove in the script?

You have to rewrite the query changing some fields.

lol if it is pvp ladder or quest board script

where the data is manipulated in-game

of course have to execute query_sql in real-time

but this script,

1.

to add a new card, also means need to add things like num2itemdesctable.txt etc at the client side

it also means, need to shut down the server to do so

so my method of using OnInit is correct

2.

my query only search inside `item_db` table, not `item_db2` table LMAO

1. Yeh, I just said that in case of client updates, your SQL method will auto-update

2. Heh, too lazy to read the whole query

AnnieRuru · November 11, 2012

what if i just want the normal cards , and removing mini boss and mvp cards? what to remove in the script?

prontera,155,177,5    script    Card Seller    100,{
   mes "Welcome to card seller ... meh lazy to say";
   next;
   .@s = select( .alphabet_menu$ ) -1;
   close2;
   callshop "card_mob#"+ .alphabet$[.@s], 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;
   }
   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

GM Takumirai · November 11, 2012

thanks annie

rmon008 · October 22, 2013

what if i just want the normal cards , and removing mini boss and mvp cards? what to remove in the script?

prontera,155,177,5    script    Card Seller    100,{
    mes "Welcome to card seller ... meh lazy to say";
    next;
    .@s = select( .alphabet_menu$ ) -1;
    close2;
    callshop "card_mob#"+ .alphabet$[.@s], 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;
    }
    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

i tried to use that script but i got this error trying to open any category on it

Sign In

Requesting Card Seller Script

Question

Link to comment

Share on other sites

37 answers to this question

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Recently Browsing 0 members