[basicllsw]

I have problem with loading string(text) from my db

When i'm load string from table.I got blank string all times.

this is my test command to load string

Код:

cmd:vhouse(pid,params[])
{
	#pragma unused params
	new d[32],a[32],p[32],r[32];
	new rows;
	mysql_query(handle,"SELECT * FROM `adminlog`");
	rows = cache_num_rows();
	for(new i=0;i<rows;i++)
	{
	    cache_get_field_content(0,"Date",d[i]);
        cache_get_field_content(0,"Admin",a[i]);
        cache_get_field_content(0,"Player",p[i]);
        cache_get_field_content(0,"Reason",r[i]);
        sfm(pid,-1,"Date: %s,Admin: %s,Player: %s,Reason: %s",d[i],a[i],p[i],r[i]);
	}
	return 1;
	

}

This data in adminlog Table



And this is mysql_log.txt

Код:

[12:34:03] [DEBUG] cache_get_row_count - connection: 1
[12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Date", connection: 1, max_len: 1
[12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Date", data: "11/พฤศจิกายน/2014 - 15:15"
[12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Admin", connection: 1, max_len: 1
[12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Admin", data: "izcream"
[12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Player", connection: 1, max_len: 1
[12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Player", data: "ไม่มี"
[12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Reason", connection: 1, max_len: 1
[12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Reason", data: "สร้าง Pickup"
[12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Date", connection: 1, max_len: 1
[12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Date", data: "11/พฤศจิกายน/2014 - 15:15"
[12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Admin", connection: 1, max_len: 1
[12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Admin", data: "izcream"
[12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Player", connection: 1, max_len: 1
[12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Player", data: "ไม่มี"
[12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Reason", connection: 1, max_len: 1
[12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Reason", data: "สร้าง Pickup"
[12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Date", connection: 1, max_len: 1
[12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Date", data: "11/พฤศจิกายน/2014 - 15:15"
[12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Admin", connection: 1, max_len: 1
[12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Admin", data: "izcream"
[12:34:03] [DEBUG] cache_get_field_content - row: 0, field_name: "Player", connection: 1, max_len: 1
[12:34:03] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Player", data: "ไม่มี"

When i use /vhouse cmd i got blank string




how to fix it


ps.sorry for my bad english