<?php
$app = (require_once __DIR__ . '/app.php');
$db = $app['db'];
$faker = \Faker\Factory::create();
// Add some users
$db->query(getUserQuery($db, $faker));
// pseudo-randomly get friends for each user
$users = generateFriends(getUsers($db));
generatePosts($db, $users, $faker);
$q = getUpdateFriendsQuery($users);
$db->query($q);
function generatePosts($db, array $users, $faker)
{
$sql = "INSERT INTO posts (status, user_id, created_at) VALUES ";
$values = [];
foreach ($users as $u) {
for ($i = 0; $i < 4; $i++) {
$p = $db->quote($faker->realText(45));
$now = $db->quote(Date('Y-m-d H:i:s'));
$values[] = "({$p}, {$u['id']}, {$now})";
}
}
$sql .= implode(', ', $values);
$db->query($sql);
}
function getUpdateFriendsQuery(array $users)
{
$sql = "INSERT INTO user_friends (friending_user_id, friended_user_id) VALUES ";
$valStr = [];
foreach ($users as $u) {
<?php
define('_VALID', true);
require 'include/config.php';
require 'include/function_global.php';
require 'include/function_smarty.php';
require 'include/function_user.php';
$template = 'user';
$options = getUserQuery();
$username = $options['username'];
$module = $options['module'];
if (!$username) {
require 'classes/auth.class.php';
$auth = new Auth();
$auth->check();
}
$sql = "SELECT * FROM signup WHERE username = '******' LIMIT 1";
$rs = $conn->execute($sql);
if ($conn->Affected_Rows() != 1) {
VRedirect::go($config['BASE_URL'] . '/error/user_missing');
}
$user = $rs->getrows();
$user = $user['0'];
$uid = intval($user['UID']);
if ($options['module'] != '') {
$profile_menu = $module;
$template = 'user_' . $module;
require 'modules/user/' . $module . '.php';
} else {
$options = getUserModule($options['query']);
$module = $options['module'];
