Debugmes after updating to latest rA GIT

[Lord Ganja]

I'm always getting this debug msg after I updated to the latest GIT

[Debug]: script debug : 0 110007296 : MySQL - Creating `accountlock` table ...

Could it be because of the Script Engine Upgrade?

 

This is the part of the script,

OnInit:
	query_sql "show tables like 'accountlock'",.@AL$;
	if (.@AL$[0] == "") {
		debugmes "MySQL - Creating `accountlock` table ...";  // create table the first time - myzter
		set $accountlock$,"2.0";
		query_sql "CREATE TABLE IF NOT EXISTS `accountlock` ( `account_id` int(11) unsigned NOT NULL DEFAULT '0',`passwd` varchar(255) NOT NULL DEFAULT '0',`recov_pwd` varchar(255) NOT NULL DEFAULT '0',PRIMARY KEY (`account_id`)) ENGINE=MyISAM";
		end;
	}

 it should only show the debugmes on the first time I run the script. but now it always show the debug.

[Lord Ganja]

just remove the whole thing then ...

Wouldn't it affect anything if I removed the whole thing?

It's okay as long as the accountlock table is already created?

 

 

EDIT:

 

FIXED after updating to ebaefc14762b519479ec17596dedf8f53cb37388

Edited September 2, 2015 by Lord Ganja

[Azeroth]

I'm always getting this debug msg after I updated to the latest GIT

[Debug]: script debug : 0 110007296 : MySQL - Creating `accountlock` table ...

Could it be because of the Script Engine Upgrade?

 

This is the part of the script,

OnInit:
	query_sql "show tables like 'accountlock'",.@AL$;
	if (.@AL$[0] == "") {
		debugmes "MySQL - Creating `accountlock` table ...";  // create table the first time - myzter
		set $accountlock$,"2.0";
		query_sql "CREATE TABLE IF NOT EXISTS `accountlock` ( `account_id` int(11) unsigned NOT NULL DEFAULT '0',`passwd` varchar(255) NOT NULL DEFAULT '0',`recov_pwd` varchar(255) NOT NULL DEFAULT '0',PRIMARY KEY (`account_id`)) ENGINE=MyISAM";
		end;
	}

 it should only show the debugmes on the first time I run the script. but now it always show the debug.

 

 

it creates a table for `accountlock` for debugmes so nothing to worry about it.

[Lord Ganja]

 

I'm always getting this debug msg after I updated to the latest GIT

[Debug]: script debug : 0 110007296 : MySQL - Creating `accountlock` table ...

Could it be because of the Script Engine Upgrade?

 

This is the part of the script,

OnInit:
	query_sql "show tables like 'accountlock'",.@AL$;
	if (.@AL$[0] == "") {
		debugmes "MySQL - Creating `accountlock` table ...";  // create table the first time - myzter
		set $accountlock$,"2.0";
		query_sql "CREATE TABLE IF NOT EXISTS `accountlock` ( `account_id` int(11) unsigned NOT NULL DEFAULT '0',`passwd` varchar(255) NOT NULL DEFAULT '0',`recov_pwd` varchar(255) NOT NULL DEFAULT '0',PRIMARY KEY (`account_id`)) ENGINE=MyISAM";
		end;
	}

 it should only show the debugmes on the first time I run the script. but now it always show the debug.

 

 

it creates a table for `accountlock` for debugmes so nothing to worry about it.

 

It should only create the table once right?

But everytime I restart/reload the server, the debug mes always appear.. PLUS the full npc script doesn't work.

 

I already checked the table `accountlock on the database, and it's already created.. But still whenever I restart/reload the server the debug mes still appear.

[Azeroth]

 

 

I'm always getting this debug msg after I updated to the latest GIT

[Debug]: script debug : 0 110007296 : MySQL - Creating `accountlock` table ...

Could it be because of the Script Engine Upgrade?

 

This is the part of the script,

OnInit:
	query_sql "show tables like 'accountlock'",.@AL$;
	if (.@AL$[0] == "") {
		debugmes "MySQL - Creating `accountlock` table ...";  // create table the first time - myzter
		set $accountlock$,"2.0";
		query_sql "CREATE TABLE IF NOT EXISTS `accountlock` ( `account_id` int(11) unsigned NOT NULL DEFAULT '0',`passwd` varchar(255) NOT NULL DEFAULT '0',`recov_pwd` varchar(255) NOT NULL DEFAULT '0',PRIMARY KEY (`account_id`)) ENGINE=MyISAM";
		end;
	}

 it should only show the debugmes on the first time I run the script. but now it always show the debug.

 

 

it creates a table for `accountlock` for debugmes so nothing to worry about it.

 

It should only create the table once right?

But everytime I restart/reload the server, the debug mes always appear.. PLUS the full npc script doesn't work.

 

I already checked the table `accountlock on the database, and it's already created.. But still whenever I restart/reload the server the debug mes still appear.

 

 

There's a problem with your script itself

maybe you can try contact quesoph about this Account Lock System i got bought this also but i haven't try it.

Edited September 1, 2015 by Azeroth

[Lord Ganja]

I already did contact him. But seems he's not really active.. Anyway, thanks. And favor please, if you ever tried it and encountered the same problem as mine, please let me know of what solution you did.

[Emistry]

just remove the debugmes if you dont want it... it's not really needed.

[Lord Ganja]

just remove the debugmes if you dont want it... it's not really needed.

 

Even if I removed it, this part still keeps on triggering even if the table is already created..

query_sql "show tables like 'accountlock'",.@AL$;
	if (.@AL$[0] == "") {
		debugmes "MySQL - Creating `accountlock` table ...";  // create table the first time - myzter
		set $accountlock$,"2.0";
		query_sql "CREATE TABLE IF NOT EXISTS `accountlock` ( `account_id` int(11) unsigned NOT NULL DEFAULT '0',`passwd` varchar(255) NOT NULL DEFAULT '0',`recov_pwd` varchar(255) NOT NULL DEFAULT '0',PRIMARY KEY (`account_id`)) ENGINE=MyISAM";
		end;
	}

Maybe I should change? dunno 

if (.@AL$[0] == "") {

[Emistry]

just remove the whole thing then ...