Jump to content
  • 0

Requesting Card Seller Script

tsubasa amami

Asked by tsubasa amami,

 Share

Question

38 answers to this question

Recommended Posts

Capuche Poporing

Capuche

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

tabs were broken. Don't forget to load item_db table in mysql

  • Upvote 1
heartfilia Poring

heartfilia

Posted
Posted

 

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

 

Not working on 3ceam?

 

[Error]:  Loading NPC file: npc/custom/sinAstreaRO/normalcardshop.txt

script error on npc/custom/sinAstreaRO/normalcardshop.txt line 4

    parse_line: expect command, missing function name or calling undeclared func

tion

     1 : {

     2 : mes "Welcome to card seller ... meh lazy to say";

     3 :     next;

*    4 :     '.'@s = select( .alphabet_menu$ ) -1;

     5 :     close2;

     6 :     callshop "card_mob#"+ .alphabet$[.@s], 1;

     7 :     end;

     8 : OnInit:

     9 :     freeloop 1;

JassMax Poring

JassMax

Posted
Posted (edited) 
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

tabs were broken. Don't forget to load item_db table in mysql

 

Hi, script working fine! but there is no option for mvp and min-boss cards!

i tired Annie's script it wasn't works

 

alright solved now! had to add tab with annie's script

Thanks annie and Capuche.

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
Edited by JassMax
alvinjade Poring

alvinjade

Posted
Posted (edited)

 

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

 

 

hi..i would like to use this script.. can you teach me how to use this? im using this setup here http://rathena.org/board/topic/84746-tutorial-how-to-create-ragnarok-offline-2013-client-tutorial/ and this error keep on showing..

post-28185-0-31358800-1408452893_thumb.jpg

 

and also i would like to know how to add item_db table in mysql..

 

SOLVED!

Edited by alvinjade
  • 0
Charlemagne19 Santa Poring

Charlemagne19

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

  • 1
Racaae Garling

Racaae

Posted
Posted
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.
  • 0
Charlemagne19 Santa Poring

Charlemagne19

Posted
Posted (edited)
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 by Skorm
Removed Script that wasn't in code blocks.
  • 0
Racaae Garling

Racaae

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

  • 0
Charlemagne19 Santa Poring

Charlemagne19

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

  • 0
alura Poring

alura

Posted
Posted (edited)

i tried running this sql

but i get some errors 

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

 

image.png

Edited by alura

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to question listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...