xmaniacx

July 1, 2017

any luck on this? i think this is very simple but for me its really hard so anyone out there.... i would really appreciate your help...

i just want to know how to put a specialeffect2 skill on all_odins_power... i've managed to follow some step but whenever the i put the effect buffs is being disabled or the +atk and +matk does not work...

June 28, 2017

@bump for this topic?

June 27, 2017

The special effect is showing but the buffs doest show anymore... help?

February 22, 2013

solved

February 22, 2013

i think its on this part

mes ( .@j++ ) + ". ^777777"+ .@name$ +" ^FF0000"+ .@base +"/"+ .@jobl +"^000000 - ^CC0066"+ .@jname$ +" ^6666FF[ "+ .@map$ +" ]^000000";

there's no "for ( set" something i think.... but.. who knows, i don't know what i'm talking about coz im a noob T_T

February 22, 2013

prontera,159,180,5    script    hjkl    456,{
    query_sql "SELECT `account_id` FROM `char` WHERE `online` = 1 ORDER BY `name` DESC LIMIT 128", .@account_id;
    .@self = getcharid(3);
    mes "x. Name ( Base/Job ) - Class [Map]";
    for( .@i = 0; .@i < getarraysize( .@account_id ); .@i++ )
        if( attachrid( .@account_id [ .@i ]  ) ) {
            .@name$ = rid2name( .@account_id[ .@i ] );
            .@base = BaseLevel;
            .@jobl = JobLevel;
            .@jname$ = jobname( Class );
            .@map$ = strcharinfo(3);
            attachrid( .@self );
            mes ( .@j++ ) + ". ^777777"+ .@name$ +" ^FF0000"+ .@base +"/"+ .@jobl +"^000000 - ^CC0066"+ .@jname$ +" ^6666FF[ "+ .@map$ +" ]^000000";
            if( .@j%10 )
                if( select( "^777777~ Continue", "~ Leave^000000" ) -1 ) close;
        }
    close;
}

boss the script is working fine however its displaying 1. for the 10 players

1. boom

1. dawda

1. 123

1. 1241231

1. and so on........

February 21, 2013

can i request an npc where it shows the current online players on the server by 10 entries per page.

it would display something like this

"1. Name ( Base/Job ) - Class [ Map ]";

"2. Name ( Base/Job ) - Class [ Map ]";

"3. Name ( Base/Job ) - Class [ Map ]";

"4. Name ( Base/Job ) - Class [ Map ]";

"5. Name ( Base/Job ) - Class [ Map ]";

"6. Name ( Base/Job ) - Class [ Map ]";

"7. Name ( Base/Job ) - Class [ Map ]";

"8. Name ( Base/Job ) - Class [ Map ]";

"9. Name ( Base/Job ) - Class [ Map ]";

"10. Name ( Base/Job ) - Class [ Map ]";

next; <<--- if the user is below 10 if you press next you would go to the menu while if its over 10 it continues to the page 2

"11. Name ( Base/Job ) - Class [ Map ]";

"12. Name ( Base/Job ) - Class [ Map ]";

"13. Name ( Base/Job ) - Class [ Map ]";

"14. Name ( Base/Job ) - Class [ Map ]";

"15. Name ( Base/Job ) - Class [ Map ]";

"16. Name ( Base/Job ) - Class [ Map ]";

"17. Name ( Base/Job ) - Class [ Map ]";

"18. Name ( Base/Job ) - Class [ Map ]";

"19. Name ( Base/Job ) - Class [ Map ]";

"20. Name ( Base/Job ) - Class [ Map ]";

next;

"21. Name ( Base/Job ) - Class [ Map ]";

"22. Name ( Base/Job ) - Class [ Map ]";

"23. Name ( Base/Job ) - Class [ Map ]";

"24. Name ( Base/Job ) - Class [ Map ]";

"25. Name ( Base/Job ) - Class [ Map ]";

"26. Name ( Base/Job ) - Class [ Map ]";

"27. Name ( Base/Job ) - Class [ Map ]";

"28. Name ( Base/Job ) - Class [ Map ]";

"29. Name ( Base/Job ) - Class [ Map ]";

"30. Name ( Base/Job ) - Class [ Map ]";

February 18, 2013

This script search 1 item ID you want in the inventory of the player you want (online or offline)

Well i was hoping that for example

Account : 2000000

Accoun'ts Character List

"GM 1" has 21 TCG Card in Cart

"GM 2" has 2 TCG in Inventory

"GM 3" no TCG

Has 1000 TCG Card In Storage

So if i click the NPC it tells me "enter the name of the person you wish to inspect."

input "GM 1"

then "Input the ID of the item you think this person might have."

input "7227(TCG Card)

After that NPC tells "

"GM 1's Account contains 1023 TCG Card." ( total tcg card of all the character on the searched account has. )

or if the account has no TCG, it says "GM1's Account contains 0 TCG Card."

something like this

February 18, 2013

work fine for me .... i using rAthena 17049...

based on the SQL file here

trunk/sql-files/main.sql ( login table )

i think your login table and above login table might be different....

double check it....

else..show your login table structure..

or edit this part ..

	if( query_sql( "SELECT * FROM `login` WHERE `account_id`='"+.@id[.@i]+"'",.@id,.@user_id$,.@user_pass$,.@sex$,.@email$,.@group_id,.@state,.@unban_time,.@expiration_time,.@login_count,.@last_login$,.@last_ip$,.@birth_date$ ) ){
		mes "^777777AID : ^FF0000"+.@id+"^000000";
		mes "^777777User ID : ^FF0000"+.@user_id"^000000";
		mes "^777777Password : ^FF0000"+.@user_pass"^000000";
		mes "^777777Gender : ^FF0000"+.@sex"^000000";
		mes "^777777Email : ^FF0000"+.@email"^000000";
		mes "^777777Group ID : ^FF0000"+.@group_id+"^000000";
		mes "^777777State : ^FF0000"+.@state+"^000000";
		if( .@unban_time ) mes "^777777UnBan Time : ^FF0000"+.@unban_time+"^000000";
		if( .@expiration_time ) mes "^777777Expire Time : ^FF0000"+.@expiration_time+"^000000";
		mes "^777777Login Count : ^FF0000"+.@login_count+"^000000";
		mes "^777777Last Login : ^FF0000"+.@last_login"^000000";
		mes "^777777Last IP : ^FF0000"+.@last_ip"^000000";
		mes "^777777Birthdate : ^FF0000"+.@birth_date"^000000";

I'm using this script and i'm also getting the sql errror, does this error have a major effect on the server if its ignored? and used the script anyways?

February 18, 2013

my players are suspecting me of giving gods item on the player.... can i request a script where if you enter the name of the player the npc would ask you to input the id then if you enter 2629 for megs it would tell you if this account has megs i mean it would say "I found ?? megs in "searched name"'s account......

February 16, 2013

That's pretty easy.

I can make it so it shows the highest online peak of all time.

Taking request...

I hope this works for you.

You can add duplicates for different map. Though i didn't added an example.

Mr. Miles it's not working for me even though i logged in 2 novice it say's there are 0 online user and 0 peak..............

February 15, 2013

can i request a script where the npc tells you what was the highest online peak of the server.

February 9, 2013

i'm following this topic too!

February 8, 2013

sounds good!! i want this script too

Display guild master and guild member · February 2, 2013

Like that ?

prontera,155,155,5	script	Guild manager	56,{
//- Limit 128 guild names
//- NPC name
.@npc$ = "[ Guild manager ]";
//--------------------------------------

L_list:
// Delete variables
// ----------------
if( .@m ) {
	.@m = 0;
	.@cast_owned$ = "";
	setarray .@var$, ".@guild_id", ".@name$", ".@master$", ".@guild_lv", ".@connect_member", ".@max_member", ".@name_m$", ".@castle_id";
	for( .@i = 0; .@i < getarraysize( .@var$ ); .@i++ )
		deletearray getd( .@var$[ .@i ] ), getarraysize( getd( .@var$[ .@i ] ) );
}

// Count guild
// -----------
query_sql( "SELECT COUNT(`guild_id`) FROM `guild`", .@count );

mes .@npc$;
mes "Total: ^FF0000"+ .@count +"^000000 guild"+ ( .@count -1 ? "s." : "." );
mes "^FF0000GOTW Information^000000",
	"Castle : "+ getcastlename( "payg_cas03" ),
	"Owned by Guild : "+getguildname( getcastledata( "payg_cas03",1 ) ),
	"^FF0000WANTED !^000000 Guild Leader : "+ getguildmaster( getcastledata( "payg_cas03",1 ) );
next;


// Menu display name guild
// -----------------------
query_sql( "SELECT `guild_id`, `name`, `master`, `guild_lv` FROM `guild` ORDER BY `guild_id` ASC limit 128",
				.@guild_id, .@name$, .@master$, .@guild_lv );

.@s = select( implode( .@name$, ":" ) ) -1;

.@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id[ .@s ] +"' ORDER BY `position` ASC", .@name_m$ );
for( .@i = 0; .@i < .@size; .@i++ )
	if( getcharid( 0,.@name_m$[ .@i ] ) )
		.@m++;

mes .@npc$;
mes "Guild name: ^FF0000"+ .@name$[ .@s ] +"^000000",
	"Master name: ^FFCC00"+ .@master$[ .@s ] +"^000000",
	"Guild lvl: ^FF00CC"+ .@guild_lv[ .@s ] +"^000000",
	"Members Online: ^0000FF"+ .@m +"^000000",
	"Castle owned: ^CC00CC"+ ( getcastledata( "payg_cas03",1 ) == .@guild_id[ .@s ] ? getcastlename( "payg_cas03" ) : "None" ) +"^000000";


// Menu members
// ------------
switch( select( "~ ^777777Informations members^000000", "~ ^777777Cancel^000000", "~ ^777777Choose another guild^000000" ) ) {
	case 1:
		next;
		break;
	case 2:
		next;
		mes .@npc$;
		mes " ";
		mes "See you soon ^-^";
		close;
	case 3:
		next;
		goto L_list;
}

deletearray .@name_m$, getarraysize( .@name_m$ );
.@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id[ .@s ] +"' ORDER BY `position` ASC", .@name_m$ );

mes .@npc$;
mes "Members of ^0000FF"+ .@name$[ .@s ] +"^000000 guild.",
	"- Red: currently ^FF0000offline^000000.",
	"- Green: currently ^00C957online^000000.",
	" ";

for( .@i = 0; .@i < .@size; .@i++ )
	mes "-> "+ ( getcharid( 0,.@name_m$[ .@i ] ) ? "^00C957" : "^FF0000" ) + .@name_m$[ .@i ] +"^000000";
next;
goto L_list;
}

Boss capu it's about nearly what i want i'd say 80%...........

I've check the script and there is a little bit too much information LOL.............

What i'd like is that when a player click's the flag.......

it would display something like this

mes [ GOTW Information ]";

mes "Castle : payg_cas03/Holy Shadow";

mes "Status : (null/unoccopied) <-- if not owned yet || occupied <-- if occupied";

mes "GM Leader : (none) <--- if not owned yet || guild leader name <-- if owned by a guild";

mes "GM Member : (none) <--- if not owned yet || list of guild member's name who owned the castle";

next;

menu "Enter Castle" "Cancel"

if enter caslte -->>

it would check the character if she/he is a part of the guild that owned the castle...

then if the castle has not been conquered it yet......

It would say "no guild has conquered this castle yet..... ";

something like this............

also i would still like it to have a green and red color if they're online or offline

Display guild master and guild member · February 2, 2013

mes ""+(.@i + 1)+".  "+( ( getcharid( 0,.@name_m$[ .@i ] ) ? "^00FF00" : "^FF0000" )+ .@name_m$[ .@i ]+" "+(.@name_m$[ .@i ](.@master$[ .@s ]) ? "( L )" : "( M )" )+"";
i want to put letter ( M ) for member and ( L ) for leader at the end of the name..........

Just put == in

(.@name_m$[ .@i ](.@master$[ .@s ]) ? "( L )" : "( M )" )

mes (.@i + 1)+".  "+ ( getcharid( 0,.@name_m$[ .@i ] ) ? "^00FF00" : "^FF0000" ) + .@name_m$[ .@i ] +" "+ ( .@name_m$[ .@i ] == .@master$[ .@s ] ? "( L )" : "" ) +"^000000";

@xmaniacx

I don't understand well your request.

If you only want payg_cas03 castle... well something like this ?

prontera,155,155,5	script	Guild manager	56,{
//- Limit 128 guild names
//- NPC name
.@npc$ = "[ Guild manager ]";
//--------------------------------------

L_list:
// Delete variables
// ----------------
if( .@m ) {
	.@m = 0;
	.@cast_owned$ = "";
	setarray .@var$, ".@guild_id", ".@name$", ".@master$", ".@guild_lv", ".@connect_member", ".@max_member", ".@name_m$", ".@castle_id";
	for( .@i = 0; .@i < getarraysize( .@var$ ); .@i++ )
		deletearray getd( .@var$[ .@i ] ), getarraysize( getd( .@var$[ .@i ] ) );
}

// Count guild
// -----------
query_sql( "SELECT COUNT(`guild_id`) FROM `guild`", .@count );

mes .@npc$;
mes " ";
mes "Total: ^FF0000"+ .@count +"^000000 guild"+ ( .@count -1 ? "s." : "." );
mes "Select a guild for more informations.";
next;


// Menu display name guild
// -----------------------
query_sql( "SELECT `guild_id`, `name`, `master`, `guild_lv` FROM `guild` ORDER BY `guild_id` ASC limit 128",
				.@guild_id, .@name$, .@master$, .@guild_lv );

.@s = select( implode( .@name$, ":" ) ) -1;

.@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id[ .@s ] +"' ORDER BY `position` ASC", .@name_m$ );
for( .@i = 0; .@i < .@size; .@i++ )
	if( getcharid( 0,.@name_m$[ .@i ] ) )
		.@m++;

mes .@npc$;
mes "Guild name: ^FF0000"+ .@name$[ .@s ] +"^000000",
	"Master name: ^FFCC00"+ .@master$[ .@s ] +"^000000",
	"Guild lvl: ^FF00CC"+ .@guild_lv[ .@s ] +"^000000",
	"Members Online: ^0000FF"+ .@m +"^000000",
	"Castle owned: ^CC00CC"+ ( getcastledata( "payg_cas03",1 ) == .@guild_id[ .@s ] ? getcastlename( "payg_cas03" ) : "None" ) +"^000000";


// Menu members
// ------------
switch( select( "~ ^777777Informations members^000000", "~ ^777777Cancel^000000", "~ ^777777Choose another guild^000000" ) ) {
	case 1:
		next;
		break;
	case 2:
		next;
		mes .@npc$;
		mes " ";
		mes "See you soon ^-^";
		close;
	case 3:
		next;
		goto L_list;
}

deletearray .@name_m$, getarraysize( .@name_m$ );
.@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id[ .@s ] +"' ORDER BY `position` ASC", .@name_m$ );

mes .@npc$;
mes "Members of ^0000FF"+ .@name$[ .@s ] +"^000000 guild.",
	"- Red: currently ^FF0000offline^000000.",
	"- Green: currently ^00C957online^000000.",
	" ";

for( .@i = 0; .@i < .@size; .@i++ )
	mes "-> "+ ( getcharid( 0,.@name_m$[ .@i ] ) ? "^00C957" : "^FF0000" ) + .@name_m$[ .@i ] +"^000000";
next;
goto L_list;
}

Well what i'm basically trying to say is that.......... in my server every, sunday at 9:00P.M - 10:00PM the castle payg_cas03 is active and whoever conquer this one will be the GOTW...... now what i want is that, whenever the WoE finishes and a certain guild conquer this castle..... like for example the maniac guild owns the Castle..... it would display the information of the guild (guildleader/nameofguild/guildmembers) on the flag........ so that when newbie people view the flag.... it would give them the information on what guild to target during the WoE session...... hope u get what i'm trying to say........

Display guild master and guild member · February 1, 2013

It's more like a script request.. whatever here for you.

prontera,155,155,5	script	Guild manager	56,{
//- Limit 128 guild names
//- NPC name
.@npc$ = "[ Guild manager ]";
//--------------------------------------

L_list:
// Delete variables
// ----------------
.@m = 0;
.@cast_owned$ = "";
setarray .@var$, ".@guild_id", ".@name$", ".@master$", ".@guild_lv", ".@connect_member", ".@max_member", ".@name_m$", ".@castle_id";
for( .@i = 0; .@i < getarraysize( .@var$ ); .@i++ )
	deletearray getd( .@var$[ .@i ] ), getarraysize( getd( .@var$[ .@i ] ) );

// Count guild
// -----------
query_sql( "SELECT COUNT(`guild_id`) FROM `guild`", .@count );

mes .@npc$;
mes " ";
mes "Total: ^FF0000"+ .@count +"^000000 guild"+ ( .@count -1 ? "s." : "." );
mes "Select a guild for more informations.";
next;


// Menu display name guild
// -----------------------
query_sql( "SELECT `guild_id`, `name`, `master`, `guild_lv` FROM `guild` ORDER BY `guild_id` ASC limit 128",
				.@guild_id, .@name$, .@master$, .@guild_lv );

.@s = select( implode( .@name$, ":" ) ) -1;

.@c = query_sql( "SELECT `castle_id` FROM `guild_castle` WHERE `guild_id` = '"+ .@guild_id[ .@s ] +"'", .@castle_id );
for( .@i = 0; .@i < .@c; .@i++ )
	.@cast_owned$ = .@cast_owned$ + .castle$[ .@castle_id[ .@i ] ] + ( .@i == .@c -1 ? "" : ", " );

.@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id[ .@s ] +"' ORDER BY `position` ASC", .@name_m$ );
for( .@i = 0; .@i < .@size; .@i++ )
	if( getcharid( 0,.@name_m$[ .@i ] ) )
		.@m++;

mes .@npc$;
mes "Guild name: ^FF0000"+ .@name$[ .@s ] +"^000000",
	"Master name: ^FFCC00"+ .@master$[ .@s ] +"^000000",
	"Guild lvl: ^FF00CC"+ .@guild_lv[ .@s ] +"^000000",
	"Members Online: ^0000FF"+ .@m +"^000000",
	"Castle owned: ^CC00CC"+ ( .@c ? .@cast_owned$ : "None" ) +"^000000";


// Menu members
// ------------
switch( select( "~ ^777777Informations members^000000", "~ ^777777Cancel^000000", "~ ^777777Choose another guild^000000" ) ) {
	case 1:
		next;
		break;
	case 2:
		next;
		mes .@npc$;
		mes " ";
		mes "See you soon ^-^";
		close;
	case 3:
		next;
		goto L_list;
}

deletearray .@name_m$, getarraysize( .@name_m$ );
.@size = query_sql( "SELECT `name` FROM `guild_member` WHERE `guild_id`= '"+ .@guild_id[ .@s ] +"' ORDER BY `position` ASC", .@name_m$ );

mes .@npc$;
mes "Members of ^0000FF"+ .@name$[ .@s ] +"^000000 guild.",
	"- Red: currently ^FF0000offline^000000.",
	"- Green: currently ^00C957online^000000.",
	" ";

for( .@i = 0; .@i < .@size; .@i++ )
	mes "-> "+ ( getcharid( 0,.@name_m$[ .@i ] ) ? "^00C957" : "^FF0000" ) + .@name_m$[ .@i ] +"^000000";
next;
goto L_list;



OnInit:
deletearray .castle$, getarraysize( .castle$ );	//- prevent duplicate
setarray .castle$, "Neuschwanstein",	"Hohenschwangau",	"Nuernberg",	"Wuerzburg",	"Rothenburg",
				"Repherion",		"Eeyolbriggar",		"Yesnelph",		"Bergel",		"Mersetzdeitz",
				"Bright Arbor",		"Scarlet Palace",	"Holy Shadow",	"Sacred Altar",	"Bamboo Grove Hill",
				"Kriemhild",		"Swanhild",			"Fadhgridh",	"Skoegul",		"Gondul",
				"Earth",			"Air",				"Water",		"Fire",			"Himinn",
				"Andlangr",			"Viblainn",			"Hljod",		"Skidbladnir",	"Mardol",
				"Cyr",				"Horn",				"Gefn",			"Bandis";
end;
}

Display :

- Number of guild (total)

- when you select a guild

-- display guild name, guild master, guild lvl, member online and castle owned by the guild

-- display all member name and check if they are online/offline

Works on rAthena only.

Edit including comment of nanakiwurtz

Capuche!! how do edit this script so that it only reads 1 specific castle!! ( refer to the picture for what i want )

i want to make this script that it only reads the payg_cas03 because that's the castle needed to conquer in order to become the GOTW......

January 29, 2013

NVM....... Problem SOLVED.......

January 27, 2013

+1 to this...........

January 27, 2013

Thank you emistry............. [ PROBLEM SOLIVED ]

January 27, 2013

Hahaha this is very basic but i dont know how to add another name that would be ignore when log in......

if (compare(strcharinfo(0),"[GM]","[ GM ])) end;

January 27, 2013

is it possible to restrict a novice in a waiting room? i mean just like in BG you have to enter into a waiting in order for the game to start...... now what i want is that when the novice click the waitingroom he can't enter the waiting room becoz he's a novice....... LOL!!

January 27, 2013

Holy MACARONI!!!! TY much..............

January 27, 2013

how to make a healing item that when click or consume just like berry it does not disspear meaning if i have 1 pc coca cola can and i click it....... it will heal 100/100 but the item does not dissapear?

January 26, 2013

How about using this:

http://rathena.org/b...how-guildparty/

and then write a script for that ?

This will allow you to fakename with showing your guild and party + emblem.

That means you can fakename your name like [title] + name but your real name stays "name".

So you can whisper normal and your name doesn't gets too long.

i already made that for a big server last year, was pretty good.

Thank you for sharing that one.... i find it useful but i want to use this script too...... I hope you can help me with my error..

@bump For this Old Topic

Sign In

Profiles

Forums

Downloads

Jobs Available

Server Database

Third-Party Services

Top Guides

Store

Crowdfunding

Posts posted by xmaniacx