Dummy Character Don't Appear

[nasagnilac]

We currently working on dummy characters but when the server restart and load the dummy. All of the characters cant be seen in the map and it was based on do_init_vending_autotrade. I hope that someone can help me about showing the characters in the map.

This is the code.

void do_init_autoafk(void)
{
	if (Sql_Query(mmysql_handle,
		"SELECT c.char_id, c.dummy, c.account_id, c.sex FROM `char` as c INNER JOIN `login` as l ON c.account_id = l.account_id AND c.dummy = 1 AND l.dummy = 1;") != SQL_SUCCESS)
	{
		Sql_ShowDebug(mmysql_handle);
		return;
	}

	if (Sql_NumRows(mmysql_handle) > 0) {
		struct s_afk *afk = NULL;

		while (SQL_SUCCESS == Sql_NextRow(mmysql_handle)) {
			char* data;

			afk = NULL;
			CREATE(afk, struct s_afk, 1);
			Sql_GetData(mmysql_handle, 0, &data, NULL); afk->char_id = atoi(data);
			Sql_GetData(mmysql_handle, 2, &data, NULL); afk->account_id = atoi(data);
			Sql_GetData(mmysql_handle, 3, &data, NULL); afk->sex = atoi(data);

			// initialize player
			CREATE(afk->sd, struct map_session_data, 1);
			pc_setnewpc(afk->sd, afk->account_id, afk->char_id, 0, gettick(), afk->sex, 0);
			afk->sd->state.autoafk = 1;
			chrif_authreq(afk->sd, true);
		}
		Sql_FreeResult(mmysql_handle);

		ShowStatus("Done loading '" CL_WHITE "%d" CL_RESET "' afkers.\n");
	}
}