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 =(

Charlemagne19 · March 23

On 8/19/2014 at 12:09 AM, alvinjade said:

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

Hi, this post is long ago but still if someone can answer please.
Where can I paste this script?
This is my first time doing this.
I just love this game and i want to customize it. please answer

Racaae · March 23

2 hours ago, Charlemagne19 said:

Hi, this post is long ago but still if someone can answer please.
Where can I paste this script?
This is my first time doing this.
I just love this game and i want to customize it. please answer

Hi. From rAthena wiki:

New scripts must be saved as a text file first. The file may be located anywhere in the rAthena directory, but is in the npc folder by default.
So create a .txt file and paste the script in it.
For an NPC to be loaded, it needs to be added to a .conf file. This is typically npc/scripts_custom.conf. Add a line, and enter your NPC file in the following format:

npc: npc/path/to/your_card_seller_script.txt

After adding the script, it must be loaded before the script contents take effect in game. There are a few ways to do this.

The map server can be rebooted. This is generally the safest route though not the most convenient for active servers.
The GM command @reloadscript maybe used in game, though this may cause monster spawn bugs.

Charlemagne19 · March 23

17 hours ago, Racaae said:
Hi. From rAthena wiki:

New scripts must be saved as a text file first. The file may be located anywhere in the rAthena directory, but is in the npc folder by default.
So create a .txt file and paste the script in it.
For an NPC to be loaded, it needs to be added to a .conf file. This is typically npc/scripts_custom.conf. Add a line, and enter your NPC file in the following format:
npc: npc/path/to/your_card_seller_script.txt
After adding the script, it must be loaded before the script contents take effect in game. There are a few ways to do this.

The map server can be rebooted. This is generally the safest route though not the most convenient for active servers.

The GM command @reloadscript maybe used in game, though this may cause monster spawn bugs.

Spoiler

//================= Hercules Configuration ================================
//= _ _ _
//= | | | | | |
//= | |_| | ___ _ __ ___ _ _| | ___ ___
//= | _ |/ _ \ '__/ __| | | | |/ _ \/ __|
//= | | | | __/ | | (__| |_| | | __/\__ \
//= \_| |_/\___|_| \___|\__,_|_|\___||___/
//================= License ===============================================
//= This file is part of Hercules.
//= http://herc.ws - http://github.com/HerculesWS/Hercules
//=
//= Copyright (C) 2012-2021 Hercules Dev Team
//= Copyright (C) Athena Dev Teams
//=
//= Hercules is free software: you can redistribute it and/or modify
//= it under the terms of the GNU General Public License as published by
//= the Free Software Foundation, either version 3 of the License, or
//= (at your option) any later version.
//=
//= This program is distributed in the hope that it will be useful,
//= but WITHOUT ANY WARRANTY; without even the implied warranty of
//= MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
//= GNU General Public License for more details.
//=
//= You should have received a copy of the GNU General Public License
//= along with this program. If not, see <http://www.gnu.org/licenses/>.
//=========================================================================
//= Custom Scripts
//=========================================================================
// Note: The scripts listed in this file are not maintained by the Hercules
// dev team and may be outdated or incompatible with the current
// version of the emulator, or cause security or stability issues.
//=========================================================================

// All the custom scripts, remove the '//' to enable...
// Place your scripts here!

//"npc/location/to/script.txt",

//================= Basic Scripts =========================================
"npc/custom/itembind.txt",
"npc/custom/warper.txt",
"npc/custom/jobmaster.txt",
"npc/custom/platinum_skills.txt",
"npc/custom/healer.txt",
"npc/custom/breeder.txt",
"npc/custom/itemmall.txt",
// Remove '//' to enable item mall npc
"npc/custom/stylist.txt",
"npc/custom/resetnpc.txt",
"npc/custom/card_remover.txt",
"npc/custom/item_signer.txt",
"npc/custom/woe_controller.txt",
"npc/custom/bartershop.txt",
"npc/custom/expandedbartershop.txt",
"npc/custom/zeroui.txt",
"npc/custom/dialogalign.txt",

//================= Other Scripts =========================================
// -- MVP Arena
//"npc/custom/etc/mvp_arena.txt",
// -- Penal Servitude (Jails Quest)
//"npc/custom/etc/penal_servitude.txt",
// -- Banks
//"npc/custom/etc/bank_kafra.txt",
//"npc/custom/etc/bank.txt",
// -- Lottery (very flexible)
//"npc/custom/etc/lottery.txt",
// -- Stock Market (Play on it, earn money, very flexible)
//"npc/custom/etc/stock_market.txt",
// -- Russian Roulette + Rock Scissors Paper (warning! contains OBB/OVB/OCA/etc. prizes!)
//"npc/custom/etc/rpsroulette.txt",
// -- Black Jack
//"npc/custom/etc/blackjack.txt",
// -- Hire ninja squads to assassinate an enemy!
//"npc/custom/etc/shifty_assassin.txt",
// -- Train your monsters to fight against other players' monsters
//"npc/custom/etc/monster_arena.txt",
// -- Raceway mini-game
//"npc/custom/etc/morroc_raceway.txt",
// -- Random change of Drop/Exp rates 1x ~ 1.5x every 6 hours on your server
//"npc/custom/etc/floating_rates.txt",
// -- Wedding script that supports same-sex marriages
//"npc/custom/etc/marriage.txt",
// -- Warper that works only after locations are unlocked
//"npc/custom/etc/quest_warper.txt",

//================= Quest Scripts =========================================
// -- Dynamic Quest Scripts
//"npc/custom/quests/hunting_missions.txt",
//"npc/custom/quests/quest_shop.txt",
//"npc/custom/quests/questboard.txt",
// -- Treasure Hunters Guild Quests (40 Quests + Special Guild Shop)
//"npc/custom/quests/thq/THQS_ChatingNPC.txt",
//"npc/custom/quests/thq/THQS_GuildNPC.txt",
//"npc/custom/quests/thq/THQS_QuestNPC.txt",
//"npc/custom/quests/thq/THQS_Quests.txt",
//"npc/custom/quests/thq/THQS_TTShop.txt",
// -- Equipment Quests
//"npc/custom/quests/elvenear.txt",
//"npc/custom/quests/sunglasses.txt",
//"npc/custom/quests/bandit_beard.txt",
//"npc/custom/quests/event_6_new_hats.txt",
//"npc/custom/quests/may_hats.txt",
//"npc/custom/quests/kings_items.txt",
// -- Misc Item Quests
//"npc/custom/quests/dead_branch.txt",
//"npc/custom/quests/berzebub.txt",
//"npc/custom/quests/jewel_case.txt",
// -- Godly Equipment Quests (be careful!)
//"npc/custom/quests/valhallen.txt",
//"npc/custom/quests/kaho_balmung.txt",
//"npc/custom/quests/kahohorn.txt",

//================= Event Scripts =========================================
// -- Daily Events
//"npc/custom/events/disguise.txt",
//"npc/custom/events/mushroom_event.txt",
//"npc/custom/events/cluckers.txt",
// -- Holiday Events
//"npc/custom/events/xmas_rings_event.txt",
//"npc/custom/events/valentinesdayexp.txt",
//"npc/custom/events/hallow06.txt",
//"npc/custom/events/uneasy_cemetery.txt",

//================= Unofficial Scripts ====================================
// -- Unofficial Airplane script
//"npc/custom/etc/airplane.txt",
// -- Thanatos Tower Statues Quest
//"npc/custom/quests/tha_statues.txt",
// -- Custom quests from official Umbalian Quests
//"npc/custom/quests/sphinx_mask.txt",
//"npc/custom/quests/umbalian_language.txt",
// -- Unofficial Battlegrounds
//"npc/custom/battleground/bg_common.txt",
//"npc/custom/battleground/bg_tierra_01.txt",
//"npc/custom/battleground/bg_tierra_02.txt",
//"npc/custom/battleground/bg_flavius_01.txt",
//"npc/custom/battleground/bg_flavius_02.txt",
//"npc/custom/battleground/bg_kvm01.txt",
//"npc/custom/battleground/bg_kvm02.txt",
//"npc/custom/battleground/bg_kvm03.txt",

// Custom
"npc/custom/support_me.txt",

SIR THIS IS MY WHOLE NPC SCRIPT_CUSTOM... WHere should i put the new script? Sorry for this stupid question but i don't know. I can't understand how scripts work but i am trying to figure this out... can you help me make this easy please???

Edited March 23 by Skorm
Removed Script that wasn't in code blocks.

Racaae · March 23

1 hour ago, Charlemagne19 said:

//"npc/custom/battleground/bg_kvm03.txt",

// Custom
"npc/custom/support_me.txt",

=======================>>>> SIR THIS IS MY WHOLE NPC SCRIPT_CUSTOM... WHere should i put the new script? Sorry for this stupid question but i don't know. I can't understand how scripts work but i am trying to figure this out... can you help me make this easy please???

EXAMPLE
Open a text editor program and paste the whole card seller script.
Click the save option, save it in your server folder /npc/ and name it carloscardseller.txt
Now on npc/scripts_custom, add a empty new line at the end of the file and add:

If you are using rAthena:


npc: npc/carloscardseller.txt

Just like this, if you are using Hercules:

// Custom
"npc/custom/support_me.txt",
"npc/carloscardseller.txt",

All NPCs in the server comes from txt files. Each line is a different file. So you're adding your file with your NPC so the server knows where it is, simple.

Charlemagne19 · March 23

4 hours ago, Racaae said:
EXAMPLE
Open a text editor program and paste the whole card seller script.
Click the save option, save it in your server folder /npc/ and name it carloscardseller.txt
Now on npc/scripts_custom, add a empty new line at the end of the file and add:

If you are using rAthena:
npc: npc/carloscardseller.txt
Just like this, if you are using Hercules:
// Custom
"npc/custom/support_me.txt",
"npc/carloscardseller.txt",
All NPCs in the server comes from txt files. Each line is a different file. So you're adding your file with your NPC so the server knows where it is, simple.

image.png.92c2651a18c026b80dc542e33d9d1759.png

Charlemagne19 · March 23

Just now, Charlemagne19 said:

LIKE THIS SIR?

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

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