To display amount of users already joined your network

Join the Conversation Publier la réponse

Edy Lee

Admin

Joined: 2024-11-24 00:57:42

2025-09-29 01:42:24

Yes anyone can develop it futher

Edy Lee

Admin

Joined: 2024-11-24 00:57:42

2025-09-29 02:21:40

Add in your index.php:

// count all users
$get_total_users = $db->query("SELECT COUNT(*) as count FROM users") or _error("SQL_ERROR");
$total_users = (int) $get_total_users->fetch_assoc()['count'];

// assign to smarty
$smarty->assign('total_users', $total_users);

Richard Wing

Admin

Joined: 2025-01-18 19:22:40

2025-10-03 07:29:22

Add in your index.php:

// count all users
$get_total_users = $db->query("SELECT COUNT(*) as count FROM users") or _error("SQL_ERROR");
$total_users = (int) $get_total_users->fetch_assoc()['count'];

// assign to smarty
$smarty->assign('total_users', $total_users);

Mike Sieck

Member

Joined: 2025-12-28 00:13:09

2025-12-28 02:29:43

Add in your index.php:

// count all users
$get_total_users = $db->query("SELECT COUNT(*) as count FROM users") or _error("SQL_ERROR");
$total_users = (int) $get_total_users->fetch_assoc()['count'];

// assign to smarty
$smarty->assign('total_users', $total_users);

Edy Lee

Admin

Joined: 2024-11-24 00:57:42

2025-12-29 13:21:38

Add in your index.php:

// count all users
$get_total_users = $db->query("SELECT COUNT(*) as count FROM users") or _error("SQL_ERROR");
$total_users = (int) $get_total_users->fetch_assoc()['count'];

// assign to smarty
$smarty->assign('total_users', $total_users);