SQL Return 0

[Thejuster]

Hello i have made this NPC

 

prontera,157,176,7	script	Discord	47,{

        //OnInit:
    while(1) {

	query_sql("SELECT * FROM `discordbot` WHERE `id`='1'", .@item);
	//query_sql("SELECT `messaggio` FROM `discordbot` WHERE `id` LIKE '1'", .@msg);
	announce "Discord> " + escape_sql(.@item[1]),0,0x0965f9;
	sleep 3000;
	
    }
}

 

My Table  discordbot

 

   INT(10)      VARCHAR  (255)
+---------+----------------------+
|   ID    |     MESSAGGIO        |  
+---------+----------------------+
|   1     |    Hello World       |
+---------+----------------------+

On client i see:

 

for wath reason i dont see my text from database?

 

[Hyroshima]

alter var int to str: .@item -> .@item$

[Thejuster]

Not work

i see empty string   

only  

 

"Discord>   "

 

and nothing 

 

prontera,157,176,7	script	Discord	47,{

        //OnInit:
    while(1) {

	
        query_sql("SELECT * FROM `discordbot` WHERE `id`='1'", .@item);
	
	announce "Discord> " + .@item$ ,0,0x0965f9;
	sleep 3000;
	
    }
}

 

and try whit this

 

prontera,157,176,7	script	Discord	47,{

        //OnInit:
    while(1) {

	
        query_sql("SELECT `messaggio` FROM `discordbot` WHERE `id`='1'", .@item);
	
	announce "Discord> " + .@item$ ,0,0x0965f9;
	sleep 3000;
	
    }
}

empty string.

Edited March 13, 2019 by Thejuster

[Start_]

Try this

prontera,157,176,7	script	Discord	47,{
	end;
OnInit:
	query_sql("SELECT * FROM `discordbot` WHERE `id`='1'", .@item$);
	announce "Discord> " + escape_sql(.@item$[0]),0,0x0965f9;
	announce "Discord> " + escape_sql(.@item$[1]),0,0x0965f9;
	end;
}

 

Edited March 14, 2019 by TARTs

[Emistry]

query_sql("SELECT `messaggio` FROM `discordbot` WHERE `id` = 1", .@item$);
announce "Discord> " + escape_sql(.@item$), 0, 0x0965f9;

and its not advised to use `SELECT * FROM ...` in query, its a common mistake did by alot beginner when they didnt aware of the total columns returned by the script command.

and each array assigned are meant for each individual column.