Jump to content
  • 0

Question

9 answers to this question

Recommended Posts

Posted


florian,123,123,5 script Florian PvP Ladder 837,{

query_sql "SELECT `char`.char_id,`char`.`name`,global_reg_value.`value` FROM global_reg_value LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id WHERE global_reg_value.str='fpvppts' ORDER BY CAST(`global_reg_value`.`value` AS UNSIGNED) DESC LIMIT 20", .@lad_id, .@lame$, .@lount;

mes "^0000FFRank^000000) ^AA0000Name^000000 - ^008800Kills^000000:^FF8C00Deaths^000000";

for( set .@x,0; .@x<=5; set .@x,.@x+1 )

{

query_sql (" SELECT `value` FROM `global_reg_value` WHERE `str`='fdpvppts' AND `char_id`='"+.@lad_id[.@x]+"' ",.@death);

mes "^0000FF"+(.@x+1)+"^000000) ^AA0000"+.@lame$[.@x]+"^000000 - ^008800"+.@lount[.@x]+"^000000:^FF8C00"+.@death+"^000000";

}

close;

}

- script FlorianPvP -1,{

OnPCKillEvent:

if(strcharinfo(3) == "florian") set fpvppts,fpvppts+1;

end;

OnPCDieEvent:

if(strcharinfo(3) == "florian") set fdpvppts,fdpvppts+1;

end;

}

Posted
-	script	AutoLadderReset	-1,{

OnSun2358:

	query_sql("DELETE FROM `global_reg_value` WHERE `str`='fpvppts'");
	query_sql("DELETE FROM `global_reg_value` WHERE `str`='fdpvppts'");

	announce "PvP Ladder has been reset! ",bc_all,0xFFF8DC;
	end;

}

It would reset the ladder every Sunday 11:58PM, though I am not sure it would work properly because the players need to reconnect, I think

Posted
-	script	AutoLadderReset	-1,{

OnSun2358:
	query_sql("DELETE FROM `global_reg_value` WHERE `str`='fpvppts'");
	query_sql("DELETE FROM `global_reg_value` WHERE `str`='fdpvppts'");

	announce "PvP Ladder has been reset! ",bc_all,0xFFF8DC;
	end;

OnWhisperGlobal:
	if(getgmlevel() > 40){
	query_sql("DELETE FROM `global_reg_value` WHERE `str`='fpvppts'");
	query_sql("DELETE FROM `global_reg_value` WHERE `str`='fdpvppts'");

	announce "The PvP Ladder has been reset by a GM! ",bc_all,0xFFF8DC;
	}
	end;	

}

reset via whisper/pm AutoLadderReset

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.

  • Recently Browsing   0 members

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