Try this code, pal youtube vanced .
$user_id = 232; // Replace this with the desired user ID

$sql = 'SELECT COUNT(topic_id) AS num_topics
FROM ' . TOPICS_TABLE . '
WHERE ' . $topic_type . '
AND topic_visibility = ' . ITEM_APPROVED . '
AND topic_moved_id = 0
AND topic_poster = ' . $user_id;