unknown column 'last_mac'

[Break San 3]

I have an error in the script takes the table

 

 

  Reveal hidden contents

 

 

- script DualClient -1,{OnInit:setarray .@map$,"bat_room","guild_vs1","pvp_n_1-5","pvp_room","quiz_01","prtg_cas01","prtg_cas02","prtg_cas03","prtg_cas04","prtg_cas05","gefg_cas01","gefg_cas02","gefg_cas03","gefg_cas04","gefg_cas05";set .@size, getarraysize(.@map$);set .map$, ":";for ( set .@i, 0; .@i < .@size; set .@i, .@i +1 ) {setmapflag .@map$[.@i], mf_loadevent;set .map$, .map$ + .@map$[.@i] + ":";}end;OnPCLoadMapEvent:query_sql "SELECT `name` FROM `char` INNER JOIN `login` ON `login`.`account_id` = `char`.`account_id` WHERE `char`.`online` = '1' AND `login`.`last_ip` IN (SELECT `last_ip` FROM `login` WHERE `login`.`account_id` = '"+getcharid(3)+"')",.@nome$;query_sql "SELECT `name` FROM `char` INNER JOIN `login` ON `login`.`account_id` = `char`.`account_id` WHERE `char`.`online` = '1' AND `login`.`last_mac` IN (SELECT `last_mac` FROM `login` WHERE `login`.`account_id` = '"+getcharid(3)+"')",.@nomemac$;for(set @i,0; @i < getarraysize(.@nome$) && getarraysize(.@nome$) > 1; set @i,@i+1){if(getcharid(0) == getcharid(0,.@nome$[@i])) continue;}for(set @j,0; @j < getarraysize(.@nomemac$) && getarraysize(.@nomemac$) > 1; set @j,@j+1){if(getcharid(0) == getcharid(0,.@nomemac$[@j])) continue;}if (getarraysize(.@nome$) > 1 && getarraysize(.@nomemac$) > 1) {dispbottom "[ATENÇÃO] Você não pode entrar neste mapa enquanto estiver com mais de uma CONTA online.";dispbottom "[Informação] Número de contas online: "+getarraysize(.@nomemac$)+".";warp "SavePoint", 0,0;}end;} 

-	script	DualClient	-1,{OnInit:setarray .@map$,"bat_room","guild_vs1","pvp_n_1-5","pvp_room","quiz_01","prtg_cas01","prtg_cas02","prtg_cas03","prtg_cas04","prtg_cas05","gefg_cas01","gefg_cas02","gefg_cas03","gefg_cas04","gefg_cas05";set .@size, getarraysize(.@map$);set .map$, ":";for ( set .@i, 0; .@i < .@size; set .@i, .@i +1 ) {setmapflag .@map$[.@i], mf_loadevent;set .map$, .map$ + .@map$[.@i] + ":";}end;OnPCLoadMapEvent:query_sql "SELECT `name` FROM `char` INNER JOIN `login` ON `login`.`account_id` = `char`.`account_id` WHERE `char`.`online` = '1' AND `login`.`last_ip` IN (SELECT `last_ip` FROM `login` WHERE `login`.`account_id` = '"+getcharid(3)+"')",.@nome$;query_sql "SELECT `name` FROM `char` INNER JOIN `login` ON `login`.`account_id` = `char`.`account_id` WHERE `char`.`online` = '1' AND `login`.`last_mac` IN (SELECT `last_mac` FROM `login` WHERE `login`.`account_id` = '"+getcharid(3)+"')",.@nomemac$;for(set @i,0; @i < getarraysize(.@nome$) && getarraysize(.@nome$) > 1; set @i,@i+1){if(getcharid(0) == getcharid(0,.@nome$[@i])) continue;}for(set @j,0; @j < getarraysize(.@nomemac$) && getarraysize(.@nomemac$) > 1; set @j,@j+1){if(getcharid(0) == getcharid(0,.@nomemac$[@j])) continue;}if (getarraysize(.@nome$) > 1 && getarraysize(.@nomemac$) > 1) {dispbottom "[ATENÇÃO] Você não pode entrar neste mapa enquanto estiver com mais de uma CONTA online.";dispbottom "[Informação] Número de contas online: "+getarraysize(.@nomemac$)+".";warp "SavePoint", 0,0;}end;} 

 

 

 

 

[thanna 11]

you have to import the sql of that plugin 

[Break San 3]

  On 12/11/2014 at 10:20 AM, thanna said:

you have to import the sql of that plugin 

 

 

The problem I do not have the sql.

[thanna 11]

  On 12/11/2014 at 10:54 AM, Break San said:

 

  On 12/11/2014 at 10:20 AM, thanna said:

you have to import the sql of that plugin 

 

 

The problem I do not have the sql.

execute this on your database mate

 

ALTER TABLE `login` ADD COLUMN `last_mac` VARCHAR(18) NOT NULL DEFAULT '' AFTER `pincode_change` ;

ALTER TABLE `login` ADD COLUMN `last_mac` VARCHAR(18) NOT NULL DEFAULT ''  AFTER `pincode_change` ; 

[Break San 3]

  On 12/11/2014 at 11:06 AM, thanna said:

 

  On 12/11/2014 at 10:54 AM, Break San said:

 

  On 12/11/2014 at 10:20 AM, thanna said:

you have to import the sql of that plugin 

 

 

The problem I do not have the sql.

execute this on your database mate

 

ALTER TABLE `login` ADD COLUMN `last_mac` VARCHAR(18) NOT NULL DEFAULT '' AFTER `pincode_change` ;

ALTER TABLE `login` ADD COLUMN `last_mac` VARCHAR(18) NOT NULL DEFAULT ''  AFTER `pincode_change` ; 

 

 

let me know some script to block dual acc on a map?

[kyeme 71]

  On 12/11/2014 at 12:06 PM, Break San said:

 

  On 12/11/2014 at 11:06 AM, thanna said:

 

  On 12/11/2014 at 10:54 AM, Break San said:

 

  On 12/11/2014 at 10:20 AM, thanna said:

you have to import the sql of that plugin 

 

 

The problem I do not have the sql.

execute this on your database mate

 

ALTER TABLE `login` ADD COLUMN `last_mac` VARCHAR(18) NOT NULL DEFAULT '' AFTER `pincode_change` ;

ALTER TABLE `login` ADD COLUMN `last_mac` VARCHAR(18) NOT NULL DEFAULT ''  AFTER `pincode_change` ; 

 

 

let me know some script to block dual acc on a map?

 

http://herc.ws/board/topic/6724-about-1-per-mac-ip-except-vending-or-at/?hl=dual

[Break San 3]

 

  On 12/11/2014 at 1:06 PM, kyeme said:

  On 12/11/2014 at 12:06 PM, Break San said:

  On 12/11/2014 at 11:06 AM, thanna said:

  On 12/11/2014 at 10:54 AM, Break San said:

  On 12/11/2014 at 10:20 AM, thanna said:

you have to import the sql of that plugin

The problem I do not have the sql.

execute this on your database mate
ALTER TABLE `login` ADD COLUMN `last_mac` VARCHAR(18) NOT NULL DEFAULT '' AFTER `pincode_change` ;

ALTER TABLE `login` ADD COLUMN `last_mac` VARCHAR(18) NOT NULL DEFAULT '' AFTER `pincode_change` ;

let me know some script to block dual acc on a map?

http://herc.ws/board/topic/6724-about-1-per-mac-ip-except-vending-or-at/?hl=dual

It is possible to put in a certain map?

  Reveal hidden contents

- script Only1perMAC -1,{OnPCLoginEvent: if (getgmlevel() >= 99) end; if (query_sql("SELECT `char`.`name` FROM `char` LEFT JOIN login ON `char`.account_id=login.account_id WHERE login.last_mac=(SELECT last_mac FROM login WHERE account_id="+getcharid(3)+") AND `char`.online=1 AND `char`.char_id!="+getcharid(0), .@name$) >= 1) { for (set .@i,0; .@i<getarraysize(.@name$); set .@i,.@i+1) { if (!checkvending(.@name$[.@i])) set .@samemac, .@samemac +1; } if (.@samemac >= 1) { announce "Sorry, only 1 account per computer can be logged in at a time.", bc_self; sleep2 1000; atcommand "@kick "+strcharinfo(0); } } end;}

-	script	Only1perMAC	-1,{OnPCLoginEvent:	if (getgmlevel() >= 99) end;	if (query_sql("SELECT `char`.`name` FROM `char` LEFT JOIN login ON `char`.account_id=login.account_id WHERE login.last_mac=(SELECT last_mac FROM login WHERE account_id="+getcharid(3)+") AND `char`.online=1 AND `char`.char_id!="+getcharid(0), .@name$) >= 1) {		for (set .@i,0; .@i<getarraysize(.@name$); set .@i,.@i+1) {			if (!checkvending(.@name$[.@i]))				set .@samemac, .@samemac +1;		}		if (.@samemac >= 1) {			announce "Sorry, only 1 account per computer can be logged in at a time.", bc_self;			sleep2 1000;			atcommand "@kick "+strcharinfo(0);		}	}	end;}

 

 

 

Edited December 11, 2014 by Break San