[How to add .sql on phpmyadmin]

5 hours ago, celeron0134 said:

good day rathena.. i tried this

/*
DROP TABLE IF EXISTS `pvp_ranking`;

CREATE TABLE IF NOT EXISTS `pvp_ranking` (
`Char_ID` int(11) unsigned NOT NULL DEFAULT '0',
`PlayerName` varchar(255) NULL DEFAULT '',
`Kills` varchar(255) NULL DEFAULT '',
`Deaths` varchar(255) NULL DEFAULT '',
PRIMARY KEY (`Char_ID`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `woe_ranking`;

CREATE TABLE IF NOT EXISTS `woe_ranking` (
`Char_ID` int(11) unsigned NOT NULL DEFAULT '0',
`PlayerName` varchar(255) NULL DEFAULT '',
`Kills` varchar(255) NULL DEFAULT '',
`Deaths` varchar(255) NULL DEFAULT '',
`EmpBreak` varchar(255) NULL DEFAULT '',
PRIMARY KEY (`Char_ID`)
) ENGINE=MyISAM;
*/

i copied and saved it as .sql, then open my phpmyadmin, clicked on ragnarok then clicked import.. i chose the file.sql then pressed go.. and i just see this

this is table from ranking npc? just talk to the npc it will automatically create pvp_ranking and woe_ranking table.

[PVP, WoE, GVG: Woe Ranking List ( GvG, Emp Break, Guild Rank ) with Points and Shop]

2 hours ago, 3TAJIOH said:

Yes, but the ID and name of character are not correct.

im using this script too working fine. try not to use nickname.

[PVP, WoE, GVG: Woe Ranking List ( GvG, Emp Break, Guild Rank ) with Points and Shop]

16 hours ago, 3TAJIOH said:

No emperium breaker statistics on Woe SE. How can i Fix it?

Go to: npc / guild2 / agit_main_se.txt

find:

OnStartArena:
	set [email protected],getcharid(2);

replace with this:

OnStartArena:
	set [email protected]$, strcharinfo(0);
	query_sql( "SELECT * FROM woe_ranking WHERE `PlayerName` = '"+strcharinfo(0)+"'", [email protected], [email protected]$, [email protected], [email protected], [email protected]);
	set .WoeBreakPoints, 1;
	set ToTalB , [email protected] + .WoeBreakPoints;
	set [email protected],getcharid(2);
	
	if([email protected]$ == strcharinfo(0)){
	query_sql("UPDATE `woe_ranking` SET `EmpBreak` = '"+ToTalB+"' WHERE `PlayerName` = '"+strcharinfo(0)+"'");
	}else{
	query_sql("INSERT INTO `woe_ranking` (`Char_ID`,`PlayerName`,`Kills`,`Deaths`,`EmpBreak`) VALUES ('"+getcharid(0)+"', '"+strcharinfo(0)+"', '"[email protected]+"', '"[email protected]+"', '"+ToTalB+"')"); 
	}

untested.

 

15 hours ago, 3TAJIOH said:

Also bug with nicknames. 2180 - another char on account of KeeperSura, but I killed KeeperSura, nickname is true.

npc script get or save the name of the character not the nickname.

[Different appearance/identity of a custom item.]

did you update the sprite id in the item script?

 

ID,Name,Name,Type,Price,Sell,Weight,ATK[:MATK],DEF,Range,Slot,Job,Class,Gender,Loc,wLV,eLV[:maxLevel],Refineable,View,{ Script },{ OnEquip_Script },{ OnUnequip_Script }

[CentOS 8 Stable?]

much better if you use centos7 or ubuntu

[@gstorage isn't working.]

1 hour ago, Hale said:

Hello rAthena!

I don't know why but only accounts with group ID of 99 can use the @gstorage, other groups cannot especially for normal players. I already placed @gstorage at conf/groups.conf and still not working. Kindly please help me, Thanks!

 

groups: (
{
	id: 0 /* group 0 is the default group for every new account */
	name: "Player"
	level: 0
	inherit: ( /*empty list*/ )
	commands: {
		
		refresh: true
		alootid: true
		autoloot: true
		autoloottype: true
		request: true
		go: true
		warp: true
		mobinfo: true
		iteminfo: true
		whodrops: true
		time: true
		jailtime: true
		allskill: true
		commands: true
		storage: true
		hominfo: true
		homstats: true
		whereis: true
		who: true
		homlevel: true
		duel: true
		glvl: true
		gstorage: true
		changegm: true

}
	permissions: {
		/* without this basic permissions regular players could not 
		trade or party */
		can_trade: true
		can_party: true
		attendance: true
	}
},

 

Guildmaster need to allow in ALT + G guild storage of the member

[Utility: SoloPack Command with Gepard Function (UniqueID)]

View File

SoloPack Command with Gepard Function (UniqueID)

---

Report all error/bugs in the forum post not in the PM for faster fix, Thanks!

By downloading this file, you agree with my Terms of Service:

• You are not allowed remove my signature from any of the included files.
• You are not allowed claim my work as yours.

 

If you like it, give me a 

---

• Submitter
  BeWan
• Submitted
  03/10/2020
• Category
  Utilities
• Video
• Content Author
  BeWan

 

[PVP, WoE, GVG: Woe Ranking List ( GvG, Emp Break, Guild Rank ) with Points and Shop]

On 3/2/2020 at 11:01 PM, Jacktuloco said:

How can I add a shop to this good script? @BeWan

I already update the file. shop added 

[need script for pvp point shop npc]

use this multi purpose ranking list with points and shop
 

 

[Utility: GuildPack NPC with Gepard Function (UniqueID)]

View File

GuildPack NPC with Gepard Function (UniqueID)

---

Report all error/bugs in the forum post not in the PM for faster fix, Thanks!

By downloading this file, you agree with my Terms of Service:

• You are not allowed remove my signature from any of the included files.
• You are not allowed claim my work as yours.

If you like it, give me a 

---

• Submitter
  BeWan
• Submitted
  03/06/2020
• Category
  Utilities
• Video
• Content Author
  BeWan

 

[PVP, WoE, GVG: Woe Ranking List ( GvG, Emp Break, Guild Rank ) with Points and Shop]

6 hours ago, JinYuichi said:

 

hi @BeWan First of all, thanks for the script, but I think it should be modified a little more. and add other functions if you can.
well, first when I test the scrip, all tops give the same information, murders, dead and emp. I think that part should be separated.
and I also noticed that the murders and deaths take it for the same data,
and already taking advantage, it will be possible to add the prize function per month, for example, the first places, receive a prize every 30 days.
Upon receiving your prize they are announced by the entire server, if it is not too much to ask.

pdt if something is not understood is why I am using the google translator

yes same information but different rank list when you choose on the 3 option(kills, deaths, emp break).

[SL spirit doesn't half cast delay of shield boomerang]

you can add sl.yml mod to fix that issue. 

[how to remove the animation of peco peco mount?]

8 hours ago, AHMADSHIDQI said:

I want to remove the animation of peco-peco of paladin / knight, as well as the gryphon and ferus of RK and RG
but i want the effect of riding and cavalry mastery still
is it possible?

you mean no peco-peco sprite but the effect still there? yeah this is possible

[Hilfe bei error Meldungen]

you have problem on line 198 and 201in "db / pre-re / job_basehpsp_db.txt

ctrl + g and enter the line 198 or 202

[Need help for npc Refine ticket +6-+10 100%]

 

[woe ranking script]

@IsabelaFernandez enjoy.
 

 

[PVP, WoE, GVG: Woe Ranking List ( GvG, Emp Break, Guild Rank ) with Points and Shop]

View File

Woe Ranking List ( GvG, Emp Break, Guild Rank ) with Points and Shop

---

 

In response to this post : 

https://rathena.org/board/topic/122667-woe-ranking-script/

https://rathena.org/board/topic/121631-woe-rankings-script/#comment-373249

https://rathena.org/board/topic/96397-woe-ranking/

https://rathena.org/board/topic/109488-ranking-woe/
 

By downloading this file, you agree with my Terms of Service:

• You are not allowed remove my signature from any of the included files.
• You are not allowed claim my work as yours.

 

If you like it, give me a 

---

• Submitter
  BeWan
• Submitted
  02/27/2020
• Category
  PvP, GvG, WoE, Battleground
• Video
• Content Author
  BeWan

 

[Downloaded recolors but am missing sprite 32 and ?]

1 hour ago, Skits said:

what about the accinfo and accessoryidname? info lub?

no need.

[Downloaded recolors but am missing sprite 32 and ?]

you don't need 32 and ? sprite/act files on armor items.

[Annieruru's Dota PVP Ladder (Help)]

use this.i update it i already include the reset pvp ladder

about problem #2 you need to put it on your ro.grf

data / wav / 

pvp_ladder.txt

[Job Master Basic Skill Check]

On 2/26/2020 at 6:41 AM, Kinkykids said:

I need the npc to check the Novice Skill "Basic Skill" if it is Level 9 to allow job changing.

it will work. anyway here
 

if (getskilllv("NV_BASIC") == 9) {
		mes "message";
		close;
	}else{
		mes "message";
		close;
	}

try this.

if (.SkillPointCheck && SkillPoint) {
		mes "Please use all your skill points before proceeding.";
		close;
	}

 

[WoE Rankings Script]

sure.

 

[How to fix "restart_mode=on"?]

use this.

 

 

runserver.bat serv.bat

[KOE problems]

to fix problem #1 apply this patch.

 

koe.patch

[Announce MVP Card (item_flag.txt)]

upload empty manner.txt file in your ro grf. it can fix your problem.