Jump to content
  • 0

Help with this script please?

Yukaiii

Asked by Yukaiii,

 Share

Question

Yukaiii Garling

Yukaiii

Posted
  • Group:  Members
  • Topic Count:  72
  • Topics Per Day:  0.02
  • Content Count:  170
  • Reputation:   9
  • Joined:  11/20/13
  • Last Seen:  
Posted 
-	script	mvppoint01	-1,{
OnNPCKillEvent:
		if(getgmlevel() >= 10 && getgmlevel() <= 98) {end;}
setarray .@monsterID[0],1038,1039,1046,1059,1086,1087,1112,1115,1147,1150,1157,1159,1190,1251,1252,1272,1312,1373,1389,1418,1492,1511,1583,1623,1630,1658,1685,1688,1719,1785,1885,2068,
2800,2801,2802,2803,2844,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2830,2831,2832,2834,2839,
2850,2851,2852,2853,2894,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,2869,2870,2871,2872,2873,2880,2881,2882,2884,2889,2898; // ID Dos Boss
for(set @a,0; @a <= getarraysize(.@monsterID); set @a,@a+1)
if(killedrid == .@monsterID[@a]){
set @CID,getcharid(0);set @name$,"";
query_sql "SELECT `name` FROM `mvp` WHERE `char_id`="+@CID+"",@name$;
if ( @name$ == "" ) {
query_sql "INSERT INTO `mvp` (`char_id`,`account_id`,`name`,`mvps`,`pontos`) VALUES ("+@CID+",'"+getcharid(3)+"','"+strcharinfo(0)+"',1,1)",@esc$;
set #MVPPOINTS,#MVPPOINTS+1;
 message strcharinfo(0),"[Ragnarok]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs.";
end;
}

query_sql "UPDATE `mvp` SET `mvps` = `mvps` +1,`pontos` = `pontos` +1 WHERE `char_id`="+@CID+"",@esc$;
query_sql "SELECT `name`,`mvps`, `pontos` FROM `mvp` ORDER BY `pontos` DESC LIMIT "+$topmvp+"",@nick$,@kills,@mvppoints;
set #MVPPOINTS,@mvppontos;
  message strcharinfo(0),"[Ragnarok]: Você possui "+@mvppoints+" ponto(s) de MvPs.";
  end;
}}
-	script	mvppoint02	-1,{
OnNPCKillEvent:
		if(getgmlevel() >= 10 && getgmlevel() <= 98) {end;}
setarray .@monsterID[0],1708,1734,1751,1768,1779,1832,1871,1917,1990,1991,2202,
2833,2835,2836,2837,2838,2840,2841,
2883,2885,5886,2887,2888,2890,2891,2895,2899; // ID Dos Boss
for(set @a,0; @a <= getarraysize(.@monsterID); set @a,@a+1)
if(killedrid == .@monsterID[@a]){
set @CID,getcharid(0);set @name$,"";
query_sql "SELECT `name` FROM `mvp` WHERE `char_id`="+@CID+"",@name$;
if ( @name$ == "" ) {
query_sql "INSERT INTO `mvp` (`char_id`,`account_id`,`name`,`mvps`,`pontos`) VALUES ("+@CID+",'"+getcharid(3)+"','"+strcharinfo(0)+"',1,3)",@esc$;
set #MVPPOINTS,#MVPPOINTS+3;
message strcharinfo(0),"[Ragnarok]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs.";
end;
}
set #MVPPOINTS,#MVPPOINTS+3;
query_sql "UPDATE `mvp` SET `mvps` = `mvps` +1,`pontos` = `pontos` +3 WHERE `char_id`="+@CID+"",@esc$;
message strcharinfo(0),"[Ragnaeok]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs.";
end;
}}
-	script	mvppoint03	-1,{
OnNPCKillEvent:
		if(getgmlevel() >= 10 && getgmlevel() <= 98) {end;}
setarray .@monsterID[0],1646,1647,1648,1649,1650,1651,1874,1929,1956,1957,2022,
2824,2825,2826,2827,2828,2829,2843,
2874,2875,2876,2877,2878,2879,2893,2896,2897; // ID Dos Boss
for(set @a,0; @a <= getarraysize(.@monsterID); set @a,@a+1)
if(killedrid == .@monsterID[@a]){
set @CID,getcharid(0);set @name$,"";
query_sql "SELECT `name` FROM `mvp` WHERE `char_id`="+@CID+"",@name$;
if ( @name$ == "" ) {
query_sql "INSERT INTO `mvp` (`char_id`,`account_id`,`name`,`mvps`,`pontos`) VALUES ("+@CID+",'"+getcharid(3)+"','"+strcharinfo(0)+"',1,5)",@esc$;
set #MVPPOINTS,#MVPPOINTS+5;
 message strcharinfo(0),"[Ragnarok]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs.";
end;
}
set #MVPPOINTS,#MVPPOINTS+5;
query_sql "UPDATE `mvp` SET `mvps` = `mvps` +1,`pontos` = `pontos` +5 WHERE `char_id`="+@CID+"",@esc$;
message strcharinfo(0),"[Ragnarok]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs.";
end;
}}

-	script	ranking_MVP_semanal	-1,{
OnMon0406:

query_sql "SELECT `account_id`,`name`,`mvps`,`pontos` FROM `mvp` WHERE `pontos`>='1' ORDER BY `pontos` DESC, `mvps` DESC LIMIT 0,1",$@MVPSemanal,$@MVPnome$,$@MVPsqt,$@MVPPts;
if($@MVPSemanal)
{
		set $historicomvp,$historicomvp+1;
		query_sql "UPDATE `mvp` SET `premio_mvp` = 607 WHERE `account_id`='"+$@MVPSemanal+"'";
  		Announce "Vencedor do ranking MvP semanal é: "+$@MVPnome$+", MvPs: "+$@MVPsqt+" Pontos: "+$@MVPPts+".",8;
		query_sql "UPDATE `mvp` SET `mvps`='0',`pontos`='0'";
query_sql "INSERT INTO `premio_mvp` (`historico`,`account_id`,`name`,`mvps`,`pontos`) VALUES ('"+$historicomvp+"','"+$@MVPSemanal+"','"+$@MVPnome$+"','"+$@MVPsqt+"','"+$@MVPPts+"')";
		sleep2 4000;
  		Announce "O Player "+$@MVPnome$+" receberá como prêmio: 1 "+getitemname(607)+".",8;
		end;
}}

//====================

prontera,127,213,5	script	Ranking Mvp	857,{

	if (getgmlevel() > 90) {

		mes "[^0000FFTop MvP "+$topmvp+"^000000]";

		mes "O que deseja fazer?";

		switch(select("Ver Top",(($a) ? "Desligar anúncio":"Ligar anúncio"),"Resetar Top MvP:Número de posições")) {

			case 1: break;

			case 2:

				set $a, ($a) ? 0 : 1;

				close;

			case 3:

				query_sql "TRUNCATE `mvp`";

				close;

			case 4:

				mes "Digite o número de posições do top mvp.";

				input $topmvp;

				break;

		}

		next;

	}

	query_sql "SELECT `name`,`mvps`, `pontos` FROM `mvp` ORDER BY `pontos` DESC LIMIT "+$topmvp+"",@names$,@mvpkills,@mvppontos;

	message strcharinfo(0), "---------------[Top MvP "+$topmvp+"]---------------";

	for (set @c, 0; @c < $topmvp; set @c, @c + 1) {
	message strcharinfo(0),"-----------------------------------------------";
	message strcharinfo(0), "("+(@c+1)+"º) Player: "+@names$[@c]+" | Matou: "+@mvpkills[@c]+" MvP's | Pontos: "+@mvppontos[@c]+".";
		

	}

	close;

}

Guys, how are you?
Could someone help me with this script?
everything works normally, in fact I needed his sql table..
I don't know anything about SQL HAHA.
If anyone can help me with this I would really appreciate it.

I apologize for it being something very old... but I like old things, they hold me back HAHA 😅😃

 

ERRO:

image.thumb.png.65a23759d8277d71c45f60945e0ad6f5.png

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0
maciel Metaling

maciel

Posted
  • Group:  Members
  • Topic Count:  26
  • Topics Per Day:  0.01
  • Content Count:  78
  • Reputation:   3
  • Joined:  06/27/20
  • Last Seen:  
Posted
48 minutes ago, Yukaiii said:

Pessoal, como vão?
Alguém pode me ajudar com esse script?
Tudo funciona normalmente, na verdade eu precisava da tabela sql dele..
Não entendo nada de SQL HAHA.
Se alguém puder me ajudar com isso eu realmente agradeceria.

Peço desculpas por ser algo muito antigo... mas eu gosto de coisas antigas, elas me seguram HAHA 😅😃

 

ERRO:

imagem.polegar.png.65a23759d8277d71c45f60945e0ad6f5.png

CREATE TABLE `mvp` (
  `char_id` INT(11) NOT NULL,           -- ID do personagem
  `account_id` INT(11) NOT NULL,        -- ID da conta do jogador
  `name` VARCHAR(30) NOT NULL,          -- Nome do jogador
  `mvps` INT(11) DEFAULT 0,             -- Número de MVPs derrotados
  `pontos` INT(11) DEFAULT 0,           -- Pontos de MVP acumulados
  `premio_mvp` INT(11) DEFAULT 0,       -- Indicação se o jogador recebeu o prêmio de MVP
  PRIMARY KEY (`char_id`)
);
 

  • Like 1
Link to comment
Share on other sites
  • 0
Yukaiii Garling

Yukaiii

Posted
  • Group:  Members
  • Topic Count:  72
  • Topics Per Day:  0.02
  • Content Count:  170
  • Reputation:   9
  • Joined:  11/20/13
  • Last Seen:  
  • Author
Posted (edited)
1 hora atrás, maciel disse:

CREATE TABLE `mvp` (
  `char_id` INT(11) NOT NULL, -- ID do personagem
  `account_id` INT(11) NOT NULL, -- ID da conta do jogador
  `name` VARCHAR(30) NOT NULL, -- Nome do jogador
  `mvps` INT(11) DEFAULT 0, -- Número de MVPs derrotados
  `pontos` INT(11) DEFAULT 0, -- Pontos de MVP acumulados
  `premio_mvp` INT(11) DEFAULT 0, -- Indicação se o jogador recebeu o prêmio de MVP
  PRIMARY KEY (`char_id`)
);
 

Agora eu tenho esse erro amigo.

os outros sumiram

imagem.polegar.png.9a60f9511385c57ebc8bcdac687dac5b.png

Edited by Yukaiii
Link to comment
Share on other sites
  • 0
maciel Metaling

maciel

Posted
  • Group:  Members
  • Topic Count:  26
  • Topics Per Day:  0.01
  • Content Count:  78
  • Reputation:   3
  • Joined:  06/27/20
  • Last Seen:  
Posted
3 hours ago, Yukaiii said:

Agora eu tenho esse erro amigo.

os outros sumiram

imagem.polegar.png.9a60f9511385c57ebc8bcdac687dac5b.png

-- Criação da tabela para armazenar informações dos MVPs
CREATE TABLE IF NOT EXISTS `mvp` (
    `char_id` INT(11) NOT NULL,
    `account_id` INT(11) NOT NULL,
    `name` VARCHAR(50) NOT NULL,
    `mvps` INT(11) DEFAULT 0,
    `pontos` INT(11) DEFAULT 0,
    `premio_mvp` INT(11) DEFAULT 0,
    PRIMARY KEY (`char_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Criação da tabela para registrar histórico de premiações de MVP
CREATE TABLE IF NOT EXISTS `premio_mvp` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `historico` INT(11) NOT NULL,
    `account_id` INT(11) NOT NULL,
    `name` VARCHAR(50) NOT NULL,
    `mvps` INT(11) NOT NULL,
    `pontos` INT(11) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Exemplo de inserção de dados iniciais (opcional)
INSERT INTO `mvp` (`char_id`, `account_id`, `name`, `mvps`, `pontos`) VALUES
(1, 1001, 'Jogador1', 0, 0),
(2, 1002, 'Jogador2', 0, 0),
(3, 1003, 'Jogador3', 0, 0);

-- A tabela 'mvp' é utilizada para armazenar as mortes de MVPs, enquanto a tabela 'premio_mvp' armazena o histórico de premiações.
 

correcao.txt

Link to comment
Share on other sites
  • 0
Yukaiii Garling

Yukaiii

Posted
  • Group:  Members
  • Topic Count:  72
  • Topics Per Day:  0.02
  • Content Count:  170
  • Reputation:   9
  • Joined:  11/20/13
  • Last Seen:  
  • Author
Posted

Obrigado amigo! Vou testar quando chegar do trabalho. E te falo

Link to comment
Share on other sites
  • 0
Yukaiii Garling

Yukaiii

Posted
  • Group:  Members
  • Topic Count:  72
  • Topics Per Day:  0.02
  • Content Count:  170
  • Reputation:   9
  • Joined:  11/20/13
  • Last Seen:  
  • Author
Posted
On 10/8/2024 at 4:29 PM, maciel said:

-- Criação da tabela para armazenar informações dos MVPs
CREATE TABLE IF NOT EXISTS `mvp` (
    `char_id` INT(11) NOT NULL,
    `account_id` INT(11) NOT NULL,
    `name` VARCHAR(50) NOT NULL,
    `mvps` INT(11) DEFAULT 0,
    `pontos` INT(11) DEFAULT 0,
    `premio_mvp` INT(11) DEFAULT 0,
    PRIMARY KEY (`char_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Criação da tabela para registrar histórico de premiações de MVP
CREATE TABLE IF NOT EXISTS `premio_mvp` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `historico` INT(11) NOT NULL,
    `account_id` INT(11) NOT NULL,
    `name` VARCHAR(50) NOT NULL,
    `mvps` INT(11) NOT NULL,
    `pontos` INT(11) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Exemplo de inserção de dados iniciais (opcional)
INSERT INTO `mvp` (`char_id`, `account_id`, `name`, `mvps`, `pontos`) VALUES
(1, 1001, 'Jogador1', 0, 0),
(2, 1002, 'Jogador2', 0, 0),
(3, 1003, 'Jogador3', 0, 0);

-- A tabela 'mvp' é utilizada para armazenar as mortes de MVPs, enquanto a tabela 'premio_mvp' armazena o histórico de premiações.
 

correcao.txt 5.57 kB · 3 downloads

Amigo agora estou tendo esses erros.image.thumb.png.e424759e5ea0f04d5e084d79a72a6dc5.png

Link to comment
Share on other sites
  • 0
Racaae Magmaring

Racaae

Posted
  • Group:  Members
  • Topic Count:  0
  • Topics Per Day:  0
  • Content Count:  212
  • Reputation:   94
  • Joined:  06/02/12
  • Last Seen:  
Posted
22 hours ago, Yukaiii said:

Amigo agora estou tendo esses erros.image.thumb.png.e424759e5ea0f04d5e084d79a72a6dc5.png

Hi. The server is trying to find table named "rank_mvp", which does not exist.
The table used in the script you shared is called "mvp". You need to pick a name to use, it cannot have two different names.

In case you have more errors, drop/delete both tables "mvp" and "premio_mvp" and insert this code in any NPC: 

OnInit:
	query_sql "CREATE TABLE IF NOT EXISTS `mvp` ("
		 		+ " `char_id` INT(11) NOT NULL,"
		 		+ " `account_id` INT(11) NOT NULL,"
		 		+ " `name` VARCHAR(30) NOT NULL,"
		 		+ " `mvps` INT(11) DEFAULT 0,"
		 		+ " `pontos` INT(11) DEFAULT 0,"
		 		+ " `premio_mvp` INT(11) DEFAULT 0,"
		 		+ " PRIMARY KEY (`char_id`)"
		 		+ " )";
	query_sql "CREATE TABLE IF NOT EXISTS `premio_mvp` ("
		 		+ " `id` INT(11) NOT NULL AUTO_INCREMENT,"
		 		+ " `historico` INT(11) NOT NULL,"
		 		+ " `account_id` INT(11) NOT NULL,"
		 		+ " `name` VARCHAR(50) NOT NULL,"
		 		+ " `mvps` INT(11) NOT NULL,"
		 		+ " `pontos` INT(11) NOT NULL,"
		 		+ " PRIMARY KEY (`id`)"
		 		+ " )";
	end;
}

Then reload the NPCs. It's working fine here, I tested.

 

  

-	script	mvppoint01	-1,{
OnNPCKillEvent:
	if (getgmlevel() >= 10 && getgmlevel() <= 98) {
		end;
	}
	setarray .@monsterID[0],1038,1039,1046,1059,1086,1087,1112,1115,1147,1150,1157,1159,1190,1251,1252,1272,1312,1373,1389,1418,1492,1511,1583,1623,1630,1658,1685,1688,1719,1785,1885,2068,
	2800,2801,2802,2803,2844,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2830,2831,2832,2834,2839,
	2850,2851,2852,2853,2894,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,2869,2870,2871,2872,2873,2880,2881,2882,2884,2889,2898; // ID Dos Boss
	for(set @a,0; @a <= getarraysize(.@monsterID); set @a,@a+1)
		if (killedrid == .@monsterID[@a]) {
			set @CID,getcharid(0);set @name$,"";
			query_sql "SELECT `name` FROM `mvp` WHERE `char_id`="+@CID+"",@name$;
			if ( @name$ == "" ) {
				query_sql "INSERT INTO `mvp` (`char_id`,`account_id`,`name`,`mvps`,`pontos`) VALUES ("+@CID+",'"+getcharid(3)+"','"+strcharinfo(0)+"',1,1)",@esc$;
				set #MVPPOINTS,#MVPPOINTS+1;
				message strcharinfo(0),"[Ragnarok]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs.";
				end;
			}
			query_sql "UPDATE `mvp` SET `mvps` = `mvps` +1,`pontos` = `pontos` +1 WHERE `char_id`="+@CID+"",@esc$;
			query_sql "SELECT `name`,`mvps`, `pontos` FROM `mvp` ORDER BY `pontos` DESC LIMIT "+$topmvp+"",@nick$,@kills,@mvppoints;
			set #MVPPOINTS,#mvppontos;
			message strcharinfo(0),"[Ragnarok]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs.";
		}
		end;

OnInit:
	query_sql "CREATE TABLE IF NOT EXISTS `mvp` ("
		 		+ " `char_id` INT(11) NOT NULL,"
		 		+ " `account_id` INT(11) NOT NULL,"
		 		+ " `name` VARCHAR(30) NOT NULL,"
		 		+ " `mvps` INT(11) DEFAULT 0,"
		 		+ " `pontos` INT(11) DEFAULT 0,"
		 		+ " `premio_mvp` INT(11) DEFAULT 0,"
		 		+ " PRIMARY KEY (`char_id`)"
		 		+ " )";
	query_sql "CREATE TABLE IF NOT EXISTS `premio_mvp` ("
		 		+ " `id` INT(11) NOT NULL AUTO_INCREMENT,"
		 		+ " `historico` INT(11) NOT NULL,"
		 		+ " `account_id` INT(11) NOT NULL,"
		 		+ " `name` VARCHAR(50) NOT NULL,"
		 		+ " `mvps` INT(11) NOT NULL,"
		 		+ " `pontos` INT(11) NOT NULL,"
		 		+ " PRIMARY KEY (`id`)"
		 		+ " )";
	end;
}

-	script	mvppoint02	-1,{
OnNPCKillEvent:
	if(getgmlevel() >= 10 && getgmlevel() <= 98) {
		end;
	}
	setarray .@monsterID[0],1708,1734,1751,1768,1779,1832,1871,1917,1990,1991,2202,
	2833,2835,2836,2837,2838,2840,2841,
	2883,2885,5886,2887,2888,2890,2891,2895,2899; // ID Dos Boss
	for(set @a,0; @a <= getarraysize(.@monsterID); set @a,@a+1)
		if(killedrid == .@monsterID[@a]){
			set @CID,getcharid(0);set @name$,"";
			query_sql "SELECT `name` FROM `mvp` WHERE `char_id`="+@CID+"",@name$;
			if ( @name$ == "" ) {
				query_sql "INSERT INTO `mvp` (`char_id`,`account_id`,`name`,`mvps`,`pontos`) VALUES ("+@CID+",'"+getcharid(3)+"','"+strcharinfo(0)+"',1,3)",@esc$;
				set #MVPPOINTS,#MVPPOINTS+3;
				message strcharinfo(0),"[Ragnarok]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs.";
				end;
			}
			set #MVPPOINTS,#MVPPOINTS+3;
			query_sql "UPDATE `mvp` SET `mvps` = `mvps` +1,`pontos` = `pontos` +3 WHERE `char_id`="+@CID+"",@esc$;
			message strcharinfo(0),"[Ragnaeok]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs.";
			end;
		}
}

-	script	mvppoint03	-1,{
OnNPCKillEvent:
	if(getgmlevel() >= 10 && getgmlevel() <= 98) {
		end;
	}
	setarray .@monsterID[0],1646,1647,1648,1649,1650,1651,1874,1929,1956,1957,2022,
	2824,2825,2826,2827,2828,2829,2843,
	2874,2875,2876,2877,2878,2879,2893,2896,2897; // ID Dos Boss
	for(set @a,0; @a <= getarraysize(.@monsterID); set @a,@a+1)
		if(killedrid == .@monsterID[@a]){
			set @CID,getcharid(0);set @name$,"";
			query_sql "SELECT `name` FROM `mvp` WHERE `char_id`="+@CID+"",@name$;
			if ( @name$ == "" ) {
				query_sql "INSERT INTO `mvp` (`char_id`,`account_id`,`name`,`mvps`,`pontos`) VALUES ("+@CID+",'"+getcharid(3)+"','"+strcharinfo(0)+"',1,5)",@esc$;
				set #MVPPOINTS,#MVPPOINTS+5;
				message strcharinfo(0),"[Ragnarok]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs.";
				end;
			}
			set #MVPPOINTS,#MVPPOINTS+5;
			query_sql "UPDATE `mvp` SET `mvps` = `mvps` +1,`pontos` = `pontos` +5 WHERE `char_id`="+@CID+"",@esc$;
			message strcharinfo(0),"[Ragnarok]: Você possui "+#MVPPOINTS+" ponto(s) de MvPs.";
			end;
		}
}

-	script	ranking_MVP_semanal	-1,{
OnMon0406:

	query_sql "SELECT `account_id`,`name`,`mvps`,`pontos` FROM `mvp` WHERE `pontos`>='1' ORDER BY `pontos` DESC, `mvps` DESC LIMIT 0,1",$@MVPSemanal,$@MVPnome$,$@MVPsqt,$@MVPPts;
	if($@MVPSemanal)
	{
		set $historicomvp,$historicomvp+1;
		query_sql "UPDATE `mvp` SET `premio_mvp` = 607 WHERE `account_id`='"+$@MVPSemanal+"'";
  		Announce "Vencedor do ranking MvP semanal é: "+$@MVPnome$+", MvPs: "+$@MVPsqt+" Pontos: "+$@MVPPts+".",8;
		query_sql "UPDATE `mvp` SET `mvps`='0',`pontos`='0'";
		query_sql "INSERT INTO `premio_mvp` (`historico`,`account_id`,`name`,`mvps`,`pontos`) VALUES ('"+$historicomvp+"','"+$@MVPSemanal+"','"+$@MVPnome$+"','"+$@MVPsqt+"','"+$@MVPPts+"')";
		sleep2 4000;
  		Announce "O Player "+$@MVPnome$+" receberá como prêmio: 1 "+getitemname(607)+".",8;
		end;
	}
}

//====================


prontera,127,213,5	script	Ranking Mvp	857,{

	if (getgmlevel() > 90) {

		mes "[^0000FFTop MvP "+$topmvp+"^000000]";

		mes "O que deseja fazer?";

		switch(select("Ver Top",(($a) ? "Desligar anúncio":"Ligar anúncio"),"Resetar Top MvP:Número de posições")) {

			case 1: break;

			case 2:

				set $a, ($a) ? 0 : 1;

				close;

			case 3:

				query_sql "TRUNCATE `mvp`";

				close;

			case 4:

				mes "Digite o número de posições do top mvp.";

				input $topmvp;

				break;

		}

		next;

	}

	query_sql "SELECT `name`,`mvps`, `pontos` FROM `mvp` ORDER BY `pontos` DESC LIMIT "+$topmvp+"",.@names$,.@mvpkills,.@mvppontos;

	message strcharinfo(0), "---------------[Top MvP "+$topmvp+"]---------------";

	for (set @c, 0; @c < $topmvp; set @c, @c + 1) {
	message strcharinfo(0),"-----------------------------------------------";
	message strcharinfo(0), "("+(@c+1)+"º) Player: "+.@names$[@c]+" | Matou: "+.@mvpkills[@c]+" MvP's | Pontos: "+.@mvppontos[@c]+".";
		

	}

	close;

}

 

Link to comment
Share on other sites

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
×
×
  • Create New...