Jump to content

Captain

Members
 View Profile  See their activity

  • Posts

    17

  • Joined

  • Last visited

 Content Type 

Posts posted by Captain

    Rental item with card

    in Script Requests

    Posted

    Hi,

     

    I am looking for an NPC which could give rental item with card

    for example a rental knife [4] and the possibility to choose which card we want to put in it (drops/cecil damon )

     

     

    because currently if a player puts cards in an item rental slot it disappears with the item

     

    display of the cursor on the homunculus

    in Client-side Support

    Posted

    Hi, I have a bug with the display of the cursor on the homunculus, instead of having a sword in pvp there is a circle which makes the homunculus impossible to focus with skill/ or regular attack :

    unknown.png

    /ns or shift doesn't work

     

    How i can replace the circle by the sword because currently it is impossible to kill a homunculus at pvp ?

    PVP ranking sql LAG

    in Scripting Support

    Posted · Edited by Captain

    Hi

    i use this simple script for my pvp ranking : 

    prontera,141,175,5	script	PVP Ranking	430,{
	.@limitRanking = 10;
	.@limitEnemies = 10;

	mes "[PvP Ranking]";
	//menu "Classement du mois", L_RankMonth, "Classement de la semaine", L_RankWeek, "Classement du jour", L_RankDay;

	select "Classement du mois", "Classement de la semaine", "Classement du jour", "Mes ennemis";
	if (@menu < 4) {
		// Ranking
		switch(@menu) {
			case 1:
				.@ranking$ = "MONTH";
				.@message$ = "Classement du mois";
				break;
			case 2:
				.@ranking$ = "WEEK";
				.@message$ = "Classement de la semaine";
				break;
			case 3:
				.@ranking$ = "DAY";
				.@message$ = "Classement du jour";
				break;
		}

		
		query_sql("SELECT `pvplog`.`killer_id` AS CID, `char`.`name`, COUNT(`pvplog`.`killer_id`) AS count_kill, (SELECT COUNT(`pvplog`.`victim_id`) from pvplog where victim_id = CID) FROM `pvplog` INNER JOIN `char` ON `char`.`char_id` = `pvplog`.`killer_id` WHERE " + .@ranking$ + "(`pvplog`.`pvp_date`) = " + .@ranking$ + "(CURRENT_DATE()) GROUP BY `char`.`name` ORDER BY count_kill DESC LIMIT " + .@limitRanking, .@cid, .@name$, .@count_kill, .@count_death);
		
		mes .@message$;
		for( @i = 0; @i < getarraysize(.@name$); @i++ ) {
			mes "Top " + (@i+1) + ": ^2ecc71" + .@name$[@i] + "^000000 kill/death: ^e74c3c" + .@count_kill[@i] + "/"+ .@count_death[@i] + "^000000";
		}

	} else if (@menu == 4) {
		query_sql("SELECT `char`.`name`, COUNT(`char`.`name`) AS count_kill FROM `pvplog` INNER JOIN `char` ON `char`.`char_id` = `pvplog`.`killer_id` WHERE `pvplog`.`victim_id` = " + getcharid(0) + " GROUP BY `char`.`name` ORDER BY count_kill DESC LIMIT " + .@limitEnemies, .@name$, .@count_kill);
		
		mes "Top your enemies:";
		for( @i = 0; @i < getarraysize(.@name$); @i++ ) {
			mes "Top 1: ^e74c3c" + .@name$[0] + "^000000 kill you ^2ecc71" + .@count_kill[0] + "^000000 times" + "^000000";
		}
	}
	close;


	L_RankMonth:
		mes "Ranking of month";
		close;
	
	L_RankWeek:
		mes "Ranking of week";
		close;

	L_RankDay:
		mes "Ranking of day";
		close;

	end;
	OnInit :
	waitingroom "[ PVP Ranking ]",0;
}

-	script	pvplog	-1,{

	OnPCKillEvent:
	if (strcharinfo(3) == "guild_vs3") {
		query_sql("INSERT INTO `pvplog` (`killer_id`, `victim_id`, `map`) VALUES ('" + getcharid(0) + "', (SELECT `char_id` FROM `char` WHERE `name` = '" + rid2name(killedrid) + "'), '" + strcharinfo(3) + "');");
		end;
		}
}

    The ranking work, but when there are more than ~1000-1200 log in the table,   when using the NPC there is a lag/freeze of 3-4 seconds before displaying the ranking.

     

    The sql part which displays the ranking 

    query_sql("SELECT `pvplog`.`killer_id` AS CID, `char`.`name`, COUNT(`pvplog`.`killer_id`) AS count_kill, (SELECT COUNT(`pvplog`.`victim_id`) from pvplog where victim_id = CID) FROM `pvplog` INNER JOIN `char` ON `char`.`char_id` = `pvplog`.`killer_id` WHERE " + .@ranking$ + "(`pvplog`.`pvp_date`) = " + .@ranking$ + "(CURRENT_DATE()) GROUP BY `char`.`name` ORDER BY count_kill DESC LIMIT " + .@limitRanking, .@cid, .@name$, .@count_kill, .@count_death);

     

    How to remove the lag?

    Mindbreak/Provoke on guildmember

    in Database Support

    Posted

    Hi

     

    I am trying to configure the skill mindbreak and provoke to work on guild members only in WoE/GVG map

     

    I added the flag "guildonly : true "  but it"s possible to use on guild members everywhere 

     Name: PF_MINDBREAKER
    Description: Mind Breaker
    MaxLevel: 5
    TargetType: Attack
    DamageFlags:
      NoDamage: true
    Flags:
      GuildOnly: true

    There is a flag for only gvg/woe map ?

    Thx

     

    How edit accname ?

    in Client-side Support

    Posted · Edited by Captain

    Hello,

    I have a problem with accname.lub , with grf editor i see :

    accnamebefore.PNG.a450f5b54b50347d3a4e9045428eafa8.PNG

    i save the file with the "save as" function into accname.lub or accname.lua to edit him.

    But when i open accname.lub or accname.lua with notepad++ or visual studio code the file appears as its :

    filechange.PNG.0e9b6933d035488bfc2fd81499ac3ce6.PNG

    How i can edit/save accname.lub or lua with the good letters ?

     

     

     

     

×
×
  • Create New...