SET resolved_by = ?, time_resolved = ?
WHERE request_id = ?', array($user->id, time(), $request['request_id']));
}
Flyspray::logEvent($task['task_id'], 13);
$_SESSION['SUCCESS'] = L('taskreopenedmsg');
# FIXME there are several pages using this form, details and pendingreq at least
#Flyspray::Redirect(CreateURL('details', $task['task_id']));
break;
// ##################
// adding a comment
// ##################
// ##################
// adding a comment
// ##################
case 'details.addcomment':
if (!Backend::add_comment($task, Post::val('comment_text'))) {
Flyspray::show_error(L('nocommententered'));
break;
}
if (Post::val('notifyme') == '1') {
// If the user wanted to watch this task for changes
Backend::add_notification($user->id, $task['task_id']);
}
$_SESSION['SUCCESS'] = L('commentaddedmsg');
Flyspray::Redirect(CreateURL('details', $task['task_id']));
break;
// ##################
// Tracking
// ##################
// ##################
// Tracking
/**
* Edits the task in $task using the parameters in $args
* @param array $task a task array
* @param array $args usually $_POST
* @access public
* @return array array(STATUS_CODE, msg)
*/
function edit_task($task, $args)
{
global $user, $db, $fs, $proj;
if ($proj->id != Post::val('project_id', $task['project_id'])) {
$proj = new Project(Post::val('project_id', $task['project_id']));
}
if (!$proj->id) {
return array(ERROR_INPUT, L('cannotedittaskglobally'));
}
if (!$user->can_edit_task($task) && !$user->can_correct_task($task)) {
return array(ERROR_PERMS);
}
// check missing fields
if (!array_get($args, 'item_summary') || !array_get($args, 'detailed_desc')) {
return array(ERROR_RECOVER, L('summaryanddetails'));
}
foreach ($proj->fields as $field) {
if ($field->prefs['value_required'] && !array_get($args, 'field' . $field->id) && !($field->prefs['force_default'] && !$user->perms('modify_all_tasks'))) {
return array(ERROR_RECOVER, L('missingrequired') . ' (' . $field->prefs['field_name'] . ')');
}
}
$time = time();
$plugins = trim(implode(' ', array_get($args, 'detailed_desc_syntax_plugins', array())));
if (!$plugins) {
$plugins = $proj->prefs['syntax_plugins'];
}
$db->x->autoExecute('{tasks}', array('project_id' => $proj->id, 'item_summary' => array_get($args, 'item_summary'), 'detailed_desc' => array_get($args, 'detailed_desc'), 'mark_private' => intval($user->can_change_private($task) && array_get($args, 'mark_private')), 'last_edited_by' => intval($user->id), 'last_edited_time' => $time, 'syntax_plugins' => $plugins, 'percent_complete' => array_get($args, 'percent_complete')), MDB2_AUTOQUERY_UPDATE, sprintf('task_id = %d', $task['task_id']));
// Now the custom fields
foreach ($proj->fields as $field) {
$field_value = $field->read(array_get($args, 'field' . $field->id));
$fields = array('field_id' => array('value' => $field->id, 'key' => true), 'task_id' => array('value' => $task['task_id'], 'key' => true), 'field_value' => array('value' => $field_value));
$db->Replace('{field_values}', $fields);
}
// [RED] Update last changed date and user
$db->x->execParam('UPDATE {redundant} SET last_changed_time = ?,
last_changed_by_real_name = ?, last_changed_by_user_name = ?,
last_edited_by_real_name = ?, last_edited_by_user_name = ?
WHERE task_id = ?', array($time, $user->infos['real_name'], $user->infos['user_name'], $user->infos['real_name'], $user->infos['user_name'], $task['task_id']));
// Prepare assignee list
$assignees = explode(';', trim(array_get($args, 'assigned_to')));
$assignees = array_map(array('Flyspray', 'UserNameToId'), $assignees);
$assignees = array_filter($assignees, create_function('$x', 'return ($x > 0);'));
// Update the list of users assigned this task, if changed
if ($user->perms('edit_assignments') && count(array_diff($task['assigned_to'], $assignees)) + count(array_diff($assignees, $task['assigned_to']))) {
// Delete the current assignees for this task
$db->x->execParam('DELETE FROM {assigned}
WHERE task_id = ?', $task['task_id']);
// Store them in the 'assigned' table
foreach ($assignees as $val) {
$fields = array('user_id' => array('value' => $val, 'key' => true), 'task_id' => array('value' => $task['task_id'], 'key' => true));
$db->Replace('{assigned}', $fields);
}
// Log to task history
Flyspray::logEvent($task['task_id'], 14, implode(' ', $assignees), implode(' ', $task['assigned_to']), '', $time);
// Notify the new assignees what happened. This obviously won't happen if the task is now assigned to no-one.
if (count($assignees)) {
$new_assignees = array_diff($assignees, $task['assigned_to']);
// Remove current user from notification list
if (!$user->infos['notify_own']) {
$new_assignees = array_filter($new_assignees, create_function('$u', 'global $user; return $user->id != $u;'));
}
if (count($new_assignees)) {
Notifications::send($new_assignees, ADDRESS_USER, NOTIFY_NEW_ASSIGNEE, array('task_id' => $task['task_id']));
}
}
}
// Get the details of the task we just updated
// To generate the changed-task message
$new_details_full = Flyspray::GetTaskDetails($task['task_id']);
$changes = Flyspray::compare_tasks($task, $new_details_full);
foreach ($changes as $change) {
if ($change[4] == 'assigned_to_name') {
continue;
}
Flyspray::logEvent($task['task_id'], 3, $change[6], $change[5], $change[4], $time);
}
if (count($changes) > 0) {
Notifications::send($task['task_id'], ADDRESS_TASK, NOTIFY_TASK_CHANGED, array('changes' => $changes));
}
Backend::add_comment($task, array_get($args, 'comment_text'), $time);
Backend::delete_files(array_get($args, 'delete_att'));
Backend::upload_files($task['task_id'], '0', 'usertaskfile');
return array(SUBMIT_OK, L('taskupdated'));
}
$this->msql->Insert("comm", $obj);
sleep(2);
header("Location: index.php");
}
}
$obj = new Backend();
$user_name = $_COOKIE["username"];
$res_arr = $obj->get_comment($user_name);
$users_online = $obj->get_user_online();
if (isset($_POST["hide_add_comm"])) {
$name = $_POST["hide_name"];
if ($_POST["hide_recipient"] == "") {
$recipient = $_POST["hide_user"];
} else {
$recipient = $_POST["hide_recipient"];
}
$status = $_POST["hide_type"];
$comment = $_POST["hide_comment"];
$comment = trim($comment);
$comment = mysql_real_escape_string($comment);
$comment = strip_tags($comment);
$obj->add_comment($name, $recipient, $comment, $status);
}
if (isset($_POST["hide-publick"])) {
$users = $obj->get_user();
$comment_type = "public";
}
if (isset($_POST["hide-private"])) {
$users = $obj->get_user_online();
$comment_type = "private";
}
$project = $task['project_id'];
$added = time() - rand(1, 315360000);
// Find someone who is allowed to add comment, do not use global groups
$sqltext = "SELECT uig.user_id\n FROM {users_in_groups} uig\n JOIN {groups} g ON g.group_id = uig.group_id AND g.add_comments = 1\n AND (g.project_id = 0 OR g.project_id = ?)\n WHERE g.group_id NOT IN (1, 2, 7, 8, 9)\n ORDER BY {$RANDOP} ";
$sql = $db->Query($sqltext, array($project));
$row = $db->FetchRow($sql);
$reporter = new User($row['user_id']);
// User might still not be able to add a comment, if he can not see the task...
// Just try again until a suitable one comes out from the query. It will finally.
// Try to enhance the query also to return fewer unsuitable ones.
while (!$reporter->can_view_task($task)) {
$row = $db->FetchRow($sql);
$reporter = new User($row['user_id']);
}
$comment = 'Comment.';
Backend::add_comment($task, $comment);
$sql = $db->Query('SELECT MAX(comment_id) FROM {comments}');
$comment_id = $db->FetchOne($sql);
$db->Query('UPDATE {comments} SET user_id = ?, date_added = ? WHERE comment_id = ?', array($reporter->id, $added, $comment_id));
}
// And 5000000 attachments total, either to task or comment
for ($i = 1; $i <= $maxattachments; $i++) {
$sql = $db->Query("SELECT comment_id, task_id, user_id, date_added FROM {comments} ORDER BY {$RANDOP} LIMIT 1");
list($comment_id, $task_id, $user_id, $date_added) = $db->FetchRow($sql);
$fname = "Attachment {$i}";
if (rand(1, 100) == 1) {
$comment_id = 0;
}
$origname = GetAttachmentDescription() . " {$i}";
$db->Query("INSERT INTO {attachments}\n ( task_id, comment_id, file_name,\n file_type, file_size, orig_name,\n added_by, date_added)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)", array($task_id, $comment_id, $fname, 'application/octet-stream', 1024, $origname, $user_id, $date_added));
}
function createTestData()
{
# quick safety
exit;
if (PHP_SAPI !== 'cli') {
die('Please call it only from commandline');
}
global $db, $fs, $proj, $user, $notify;
// Use this only on a new test installation, code does not work on
// an existing one, and never will.
### Simulation Settings ###
# Set conservative data as default, setup bigger values for further performance tests.
# maybe setting moved out of this function to make performance graphs with multiple runs..
// Borg Inc. is a big multinational company delivering
$maxproducts = 3;
# =projects
$maxversions = 3;
// both to it's
$maxcorporateusers = 5;
// working in
$maxcorporates = 3;
// and
$maxindividualusers = 5;
// who are all happy to report to us about
$maxtasks = 10;
// There are many problems in our products. And then there are also
$maxviewers = 10;
// who just like to watch what's going on here at Borg Inc.
// Our users are also keen to add attachments to their reports and comments, so there are
$maxattachments = 5;
// in our database;
// Our users are also very active with commenting.
$maxcomments = 20;
// To handle all the resulting work, we need
$maxadmins = 2;
$maxmanagers = 2;
$maxdevelopers = 3;
// people working together all over the globe to care for their needs.
### End of Simulation Settings ###
// We also have both a very innovative and standardized naming scheme for our products.
// And we have also made one big invention offered only to our customers in the world:
// Time travel! You can comment on tasks and other comments in them even before the task
// is even opened or the original comment made.
// Add more according to your taste...
$subjects[] = "%s sucks!";
$subjects[] = "%s is utterly crap!";
$subjects[] = "Developers of %s should be hanged!";
$subjects[] = "Developers of %s should be strangled!";
$subjects[] = "Developers of %s should be eaten alive by zombies!";
$subjects[] = "Developers of %s should be thrown in a pit of snakes!";
$subjects[] = "Who is the idiot responsible for %s?";
error_reporting(E_ALL);
// die('Enable me by commenting this out by editing and read the contents first!'.basename(__FILE__).' at line '.__LINE__);
define('IN_FS', 1);
require_once dirname(__FILE__) . '/../includes/fix.inc.php';
require_once dirname(__FILE__) . '/../includes/class.flyspray.php';
require_once dirname(__FILE__) . '/../includes/constants.inc.php';
require_once dirname(__FILE__) . '/../includes/i18n.inc.php';
require_once dirname(__FILE__) . '/../includes/class.tpl.php';
require_once dirname(__FILE__) . '/../vendor/autoload.php';
$conf = parse_ini_file('../flyspray.conf.php', true) or die('Cannot open config file.');
$db = new Database();
$db->dbOpenFast($conf['database']);
$RANDOP = 'RAND()';
if ($db->dblink->dataProvider == 'postgres') {
$RANDOP = 'RANDOM()';
}
#die();
$fs = new Flyspray();
$user = new User(1);
$proj = new Project(1);
$notify = new Notifications();
load_translations();
for ($i = 1; $i <= $maxadmins; $i++) {
$user_name = "admin{$i}";
$real_name = "Administrator {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different one!
$email = null;
// $user_name . '@example.com';
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, 1, 1);
}
for ($i = 1; $i <= $maxmanagers; $i++) {
$user_name = "pm{$i}";
$real_name = "Project Manager {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different one!
$email = null;
// $user_name . '@example.com';
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, 2, 1);
}
$db->Query('UPDATE {projects} SET project_is_active = 0 WHERE project_id = 1');
// Show more columns by default, trying to make database or flyspray crash under stress.
$db->Query("UPDATE {prefs} SET pref_value = 'id project category tasktype severity summary status openedby dateopened progress comments attachments votes' WHERE pref_name = 'visible_columns'");
// Add 3 different Global developer groups with different
// view rights first, then assign developers to them at random.
// Borg Inc. has a strict hierarchy on who can see and do what.
// Somewhat more relaxed with our own developers.
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open,view_comments,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,modify_own_tasks) " . "VALUES('Developer Group 1', 'Developer Group 1', 0, 1, 1, 0, 1, 1, 1, 1, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open,view_comments,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,modify_own_tasks) " . "VALUES('Developer Group 2', 'Developer Group 2', 0, 1, 1, 0, 0, 1, 1, 1, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open,view_comments,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,modify_own_tasks) " . "VALUES('Developer Group 3', 'Developer Group 3', 0, 1, 1, 0, 0, 0, 1, 1, 1)");
// Add also general groups for corporate users, individual users and viewers.
// Allow only login. Not so relaxed with them bastards.
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open) " . "VALUES('Corporate Users', 'Corporate Users', 0, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open) " . "VALUES('Trusted Users', 'Trusted Users', 0, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open) " . "VALUES('Non-trusted Users', 'Non-trusted Users', 0, 1)");
for ($i = 1; $i <= $maxdevelopers; $i++) {
$user_name = "dev{$i}";
$real_name = "Developer {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different one!
$email = null;
// $user_name . '@example.com';
$group = rand(7, 9);
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// We have been really active in the past years, AND have a lot of projects.
for ($i = 1; $i <= $maxproducts; $i++) {
$projname = strtoupper(substr(md5(uniqid(mt_rand(), true)), 0, mt_rand(8, 12)));
$projname = 'Borg Inc. Product ' . preg_replace('/^(.{3})(.+)$/', '$1-$2', $projname);
$db->Query('INSERT INTO {projects}
( project_title, theme_style, intro_message,
others_view, anon_open, project_is_active,
visible_columns, visible_fields, lang_code,
notify_email, notify_jabber, disp_intro)
VALUES (?, ?, ?, ?, ?, 1, ?, ?, ?, ?, ?, ?)', array($projname, 'CleanFS', "Welcome to {$projname}", 0, 0, 'id category tasktype severity summary status openedby dateopened progress comments attachments votes', 'supertask tasktype category severity priority status private assignedto reportedin dueversion duedate progress os votes', 'en', '', '', 1));
add_project_data();
}
// Assign some of the poor developers to project manager or project developer groups
// rights to some of the projects they must work on.
for ($i = 1; $i <= $maxproducts; $i++) {
$projid = $i + 1;
$sql = $db->Query('SELECT group_id FROM {groups} WHERE project_id = ? AND manage_project = 1', array($projid));
$pmgroup = $db->FetchOne($sql);
$sql = $db->Query('SELECT group_id FROM {groups} WHERE project_id = ? AND manage_project = 0', array($projid));
$pdgroup = $db->FetchOne($sql);
$pmlimit = intval($maxdevelopers / 100) + rand(-2, 2);
$pdlimit = intval($maxdevelopers / 20) + rand(-10, 10);
$pmlimit = $pmlimit < 1 ? 1 : $pmlimit;
$pdlimit = $pdlimit < 1 ? 1 : $pdlimit;
$sql = $db->Query("SELECT user_id FROM {users_in_groups} WHERE group_id in (7, 8, 9) ORDER BY {$RANDOP} limit {$pmlimit}");
$pms = $db->fetchCol($sql);
$sql = $db->Query("SELECT user_id FROM {users_in_groups} WHERE group_id in (8, 9) ORDER BY {$RANDOP} limit {$pdlimit}");
$pds = $db->fetchCol($sql);
foreach ($pms as $pm) {
$db->Query('INSERT INTO {users_in_groups} (user_id, group_id) values (?, ?)', array($pm, $pmgroup));
}
foreach ($pds as $pd) {
$check = $db->Query('SELECT * FROM {users_in_groups} WHERE user_id = ? AND group_id = ?', array($pd, $pmgroup));
if (!$db->CountRows($check)) {
$db->Query('INSERT INTO {users_in_groups} (user_id, group_id) values (?, ?)', array($pd, $pdgroup));
}
}
}
// Create corporate users.
for ($i = 1; $i <= $maxcorporateusers; $i++) {
$user_name = "cu{$i}";
$real_name = "Corporate user {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different ones!
$email = null;
// $user_name . '@example.com';
$group = 10;
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// Now, create corporate user groups for some of our projects.
// Just %5 change of getting added.
for ($i = 1; $i <= $maxcorporates; $i++) {
for ($j = 1; $j <= $maxproducts; $j++) {
if (rand(1, 20) == 1) {
$projid = $j + 1;
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,add_comments,create_attachments,group_open,view_comments) " . "VALUES('Corporate {$i}', 'Corporate {$i} Users', {$projid}, 0, 0, 1, 1, 1, 1, 1,1,1)");
$sql = $db->Query('SELECT MAX(group_id) FROM {groups}');
$group_id = $db->FetchOne($sql);
// Then, add users
for ($k = $i; $k <= $maxcorporateusers; $k += $maxcorporates) {
$username = "******";
$sql = $db->Query('SELECT user_id FROM {users} WHERE user_name = ?', array($username));
$user_id = $db->FetchOne($sql);
$db->Query('INSERT INTO {users_in_groups} (user_id, group_id) VALUES (?, ?)', array($user_id, $group_id));
}
}
}
}
// And also those individual users...
for ($i = 1; $i <= $maxindividualusers; $i++) {
$user_name = "iu{$i}";
$real_name = "Individual user {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different ones!
$email = null;
// $user_name . '@example.com';
$group = rand(11, 12);
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// That's why we need some more global groups with different viewing rights
// And 100 users just viewing our progress
for ($i = 1; $i <= $maxindividualusers; $i++) {
$user_name = "basic{$i}";
$real_name = "Basic {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different ones!
$email = null;
// $user_name . '@example.com';
$group = 4;
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// But that was not enough for all needed permission, so in practice, every
// project also has between 1 AND 20 project groups.
//
// Must recreate, so rights for new projects get loaded. Otherwise,
// even first user in database can't create tasks.
$user = new User(1);
// And that's why we've got $maxtasks opened within the last 10 years
for ($i = 1; $i <= $maxtasks; $i++) {
$project = rand(2, $maxproducts);
// Find someone who is allowed to open a task, do not use global groups
$sql = $db->Query("SELECT uig.user_id\n\t\t\tFROM {users_in_groups} uig\n\t\t\tJOIN {groups} g ON g.group_id = uig.group_id AND g.open_new_tasks = 1 AND (g.project_id = 0 OR g.project_id = ?)\n\t\t\tWHERE g.group_id NOT IN (1, 2, 7, 8, 9)\n\t\t\tORDER BY {$RANDOP} LIMIT 1", array($project));
$reporter = $db->FetchOne($sql);
$sql = $db->Query("SELECT category_id FROM {list_category}\n\t\t\tWHERE project_id = ?\n\t\t\tAND category_name <> 'root'\n\t\t\tORDER BY {$RANDOP} LIMIT 1", array($project));
$category = $db->FetchOne($sql);
$opened = time() - rand(1, 315360000);
$args = array();
$args['project_id'] = $project;
$args['date_opened'] = time() - rand(1, 315360000);
// 'last_edited_time' => time(),
$args['opened_by'] = $reporter;
$args['product_category'] = $category;
$args['task_severity'] = 1;
$args['task_priority'] = 1;
// 'task_type', , 'product_version',
// 'operating_system', , 'estimated_effort',
// 'supertask_id',
$sql = $db->Query("SELECT project_title FROM {projects} WHERE project_id = ?", array($project));
$projectname = $db->FetchOne($sql);
$subject = $subjects[rand(0, count($subjects) - 1)];
$subject = sprintf($subject, $projectname);
$args['item_summary'] = "Task {$i} ({$subject})";
// 'detailed_desc'
// echo $args['item_summary'] . "\r\n";
$ok = Backend::create_task($args);
if ($ok === 0) {
echo "Failed to create task.\r\n";
} else {
list($id, $token) = $ok;
$db->Query('UPDATE {tasks} SET opened_by = ?, date_opened = ? WHERE task_id = ?', array($reporter, $opened, $id));
}
}
# end for maxtasks
// One task in ten of is unconfirmed, probably just bullshit, not assigned to anyone,
// and we add just a comment "Cannot reproduce".
for ($i = 1; $i <= $maxcomments; $i++) {
$taskid = rand(2, $maxtasks + 1);
$task = Flyspray::GetTaskDetails($taskid, true);
$project = $task['project_id'];
$added = time() - rand(1, 315360000);
// Find someone who is allowed to add comment, do not use global groups
$sqltext = "SELECT uig.user_id\n\t\t\tFROM {users_in_groups} uig\n JOIN {groups} g ON g.group_id = uig.group_id AND g.add_comments = 1\n AND (g.project_id = 0 OR g.project_id = ?)\n WHERE g.group_id NOT IN (1, 2, 7, 8, 9)\n ORDER BY {$RANDOP} ";
$sql = $db->Query($sqltext, array($project));
$row = $db->FetchRow($sql);
$reporter = new User($row['user_id']);
// User might still not be able to add a comment, if he can not see the task...
// Just try again until a suitable one comes out from the query. It will finally.
// Try to enhance the query also to return fewer unsuitable ones.
while (!$reporter->can_view_task($task)) {
$row = $db->FetchRow($sql);
$reporter = new User($row['user_id']);
}
$comment = 'Comment.';
Backend::add_comment($task, $comment);
$sql = $db->Query('SELECT MAX(comment_id) FROM {comments}');
$comment_id = $db->FetchOne($sql);
$db->Query('UPDATE {comments} SET user_id = ?, date_added = ? WHERE comment_id = ?', array($reporter->id, $added, $comment_id));
}
# end for maxcomments
// And $maxattachments total, either to task or comment
for ($i = 1; $i <= $maxattachments; $i++) {
$sql = $db->Query("SELECT comment_id, task_id, user_id, date_added FROM {comments} ORDER BY {$RANDOP} LIMIT 1");
list($comment_id, $task_id, $user_id, $date_added) = $db->FetchRow($sql);
$fname = "Attachment {$i}";
if (rand(1, 100) == 1) {
$comment_id = 0;
}
$origname = getAttachmentDescription() . " {$i}";
$db->Query("INSERT INTO {attachments}\n ( task_id, comment_id, file_name,\n file_type, file_size, orig_name,\n added_by, date_added)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)", array($task_id, $comment_id, $fname, 'application/octet-stream', 1024, $origname, $user_id, $date_added));
}
// // But at least we have been able to solve approximately half of the tasks
// Of course, many of the tasks are somehow related to each other, so add
// parents, relationships, dependencies, duplicates etc. last.
// Do this ones last, after creating all the other data.
// Approximately 200 hundred of our projects are already closed or deleted.
// Cannot be sure when using random...
for ($i = 1; $i < 200; $i++) {
}
// Some of our developers AND project managers couldn't take all that AND have already left the premises
// No wonder, because we've got those corporate AND individual users always complaining
// AND whining, not to speak about our management.
$db->dbClose();
}
function action_addcomment($task)
{
global $user, $db, $fs, $proj;
if (!Backend::add_comment($task, Post::val('comment_text'), null, Post::val('comment_text_syntax_plugins'))) {
return array(ERROR_RECOVER, L('nocommententered'));
}
if (Post::val('notifyme') == '1') {
// If the user wanted to watch this task for changes
Backend::add_notification($user->id, $task['task_id']);
}
return array(SUBMIT_OK, L('commentaddedmsg'));
}
function createTestData()
{
# quick safety
exit;
if (PHP_SAPI !== 'cli') {
die('');
}
// Use this only on a new test installation, code does not work on
// an existing one, and never will.
// Borg Inc. is a big multinational company delivering
$maxproducts = 50;
// both to it's
$maxcorporateusers = 450;
// working in
$maxcorporates = 50;
// and
$maxindividualusers = 10;
// who are all happy to report to us about
$maxtasks = 150;
// the many problems in our products. And then there are also
$maxviewers = 50;
// who just like to watch what's going on here at Borg Inc.
// Our users are also keen to add attachments to their reports and comments, so there are
$maxattachments = 500;
// in our database;
// Our users are also very active with commenting.
$maxcomments = 750;
// To handle all the resulting work, we need
$maxadmins = 3;
$maxmanagers = 5;
$maxdevelopers = 50;
// people working together all over the globe to care for their needs.
// We also have both a very innovative and standardized naming scheme for our products.
// And we have also made one big invention offered only to our customers in the world:
// Time travel! You can comment on tasks and other comments in them even before the task
// is even opened or the original comment made.
// Add more according to your taste...
$subjects[] = "%s sucks!";
$subjects[] = "%s is utterly crap!";
$subjects[] = "Developers of %s should be hanged!";
$subjects[] = "Developers of %s should be strangled!";
$subjects[] = "Developers of %s should be eaten alive by zombies!";
$subjects[] = "Developers of %s should be thrown in a pit of snakes!";
$subjects[] = "Who is the idiot responsible for %s?";
error_reporting(E_ALL);
// die('Enable me by commenting this out by editing and read the contents first!'.basename(__FILE__).' at line '.__LINE__);
define('IN_FS', 1);
require_once dirname(__FILE__) . '/../includes/fix.inc.php';
require_once dirname(__FILE__) . '/../includes/class.flyspray.php';
require_once dirname(__FILE__) . '/../includes/constants.inc.php';
require_once dirname(__FILE__) . '/../includes/i18n.inc.php';
require_once dirname(__FILE__) . '/../includes/class.tpl.php';
require_once dirname(__FILE__) . '/../vendor/autoload.php';
$conf = @parse_ini_file('../flyspray.conf.php', true) or die('Cannot open config file.');
$db = new Database();
$db->dbOpenFast($conf['database']);
$RANDOP = 'RAND()';
if ($db->dblink->dataProvider == 'postgres') {
$RANDOP = 'RANDOM()';
}
$fs = new Flyspray();
$user = new User(1);
$proj = new Project(1);
$notify = new Notifications();
load_translations();
for ($i = 1; $i <= $maxadmins; $i++) {
$user_name = "admin{$i}";
$real_name = "Administrator {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different one!
$email = null;
// $user_name . '@foo.bar.baz.org';
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, 1, 1);
}
for ($i = 1; $i <= $maxmanagers; $i++) {
$user_name = "pm{$i}";
$real_name = "Project Manager {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different one!
$email = null;
// $user_name . '@foo.bar.baz.org';
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, 2, 1);
}
$db->Query('UPDATE {projects} SET project_is_active = 0 WHERE project_id = 1');
// Show more columns by default, trying to make database or flyspray crash under stress.
$db->Query("UPDATE {prefs} SET pref_value = 'id project category tasktype severity summary status openedby dateopened progress comments attachments votes' WHERE pref_name = 'visible_columns'");
// Add 3 different Global developer groups with different
// view rights first, then assign developers to them at random.
// Borg Inc. has a strict hierarchy on who can see and do what.
// Somewhat more relaxed with our own developers.
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open,view_comments,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,modify_own_tasks) " . "VALUES('Developer Group 1', 'Developer Group 1', 0, 1, 1, 0, 1, 1, 1, 1, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open,view_comments,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,modify_own_tasks) " . "VALUES('Developer Group 2', 'Developer Group 2', 0, 1, 1, 0, 0, 1, 1, 1, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open,view_comments,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,modify_own_tasks) " . "VALUES('Developer Group 3', 'Developer Group 3', 0, 1, 1, 0, 0, 0, 1, 1, 1)");
// Add also general groups for corporate users, individual users and viewers.
// Allow only login. Not so relaxed with them bastards.
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open) " . "VALUES('Corporate Users', 'Corporate Users', 0, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open) " . "VALUES('Trusted Users', 'Trusted Users', 0, 1)");
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,group_open) " . "VALUES('Non-trusted Users', 'Non-trusted Users', 0, 1)");
for ($i = 1; $i <= $maxdevelopers; $i++) {
$user_name = "dev{$i}";
$real_name = "Developer {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different one!
$email = $email = null;
$user_name . '@foo.bar.baz.org';
$group = rand(7, 9);
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// We have been really active in the past years, AND have a lot of projects.
for ($i = 1; $i <= $maxproducts; $i++) {
$projname = strtoupper(substr(md5(uniqid(mt_rand(), true)), 0, mt_rand(8, 12)));
$projname = 'Borg Inc. Product ' . preg_replace('/^(.{3})(.+)$/', '$1-$2', $projname);
$db->Query('INSERT INTO {projects}
( project_title, theme_style, intro_message,
others_view, anon_open, project_is_active,
visible_columns, visible_fields, lang_code,
notify_email, notify_jabber, disp_intro)
VALUES (?, ?, ?, ?, ?, 1, ?, ?, ?, ?, ?, ?)', array($projname, 'CleanFS', "Welcome to {$projname}", 0, 0, 'id category tasktype severity summary status openedby dateopened progress comments attachments votes', 'supertask tasktype category severity priority status private assignedto reportedin dueversion duedate progress os votes', 'en', '', '', 1));
add_project_data();
}
// Assign some of the poor developers project manager or project developer
// rights to some of the projects they must work on.
for ($i = 1; $i <= $maxproducts; $i++) {
$projid = $i + 1;
$sql = $db->Query('SELECT group_id FROM {groups} WHERE project_id = ? AND manage_project = 1', array($projid));
$pmgroup = $db->FetchOne($sql);
$sql = $db->Query('SELECT group_id FROM {groups} WHERE project_id = ? AND manage_project = 0', array($projid));
$pdgroup = $db->FetchOne($sql);
$pmlimit = intval($maxdevelopers / 100) + rand(-2, 2);
$pdlimit = intval($maxdevelopers / 20) + rand(-10, 10);
$pmlimit = $pmlimit < 1 ? 1 : $pmlimit;
$pdlimit = $pdlimit < 1 ? 1 : $pdlimit;
$sql = $db->Query("SELECT user_id FROM {users_in_groups} WHERE group_id in (7, 8, 9) ORDER BY {$RANDOP} limit {$pmlimit}");
$pms = $db->fetchCol($sql);
$sql = $db->Query("SELECT user_id FROM {users_in_groups} WHERE group_id in (8, 9) ORDER BY {$RANDOP} limit {$pdlimit}");
$pds = $db->fetchCol($sql);
foreach ($pms as $pm) {
$db->Query('INSERT INTO {users_in_groups} (user_id, group_id) values (?, ?)', array($pm, $pmgroup));
}
foreach ($pds as $pd) {
$check = $db->Query('SELECT * FROM {users_in_groups} WHERE user_id = ? AND group_id = ?', array($pd, $pmgroup));
if (!$db->CountRows($check)) {
$db->Query('INSERT INTO {users_in_groups} (user_id, group_id) values (?, ?)', array($pd, $pdgroup));
}
}
}
// Create corporate users.
for ($i = 1; $i <= $maxcorporateusers; $i++) {
$user_name = "cu{$i}";
$real_name = "Corporate user {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different ones!
$email = $email = null;
$user_name . '@foo.bar.baz.org';
$group = 10;
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// Now, create corporate user groups for some of our projects.
// Just %5 change of getting added.
for ($i = 1; $i <= $maxcorporates; $i++) {
for ($j = 1; $j <= $maxproducts; $j++) {
if (rand(1, 20) == 1) {
$projid = $j + 1;
$db->Query("INSERT INTO {groups} " . "(group_name,group_desc,project_id,manage_project,view_tasks, view_groups_tasks, view_own_tasks,open_new_tasks,add_comments,create_attachments,group_open,view_comments) " . "VALUES('Corporate {$i}', 'Corporate {$i} Users', {$projid}, 0, 0, 1, 1, 1, 1, 1,1,1)");
$sql = $db->Query('SELECT MAX(group_id) FROM {groups}');
$group_id = $db->FetchOne($sql);
// Then, add users
for ($k = $i; $k <= $maxcorporateusers; $k += $maxcorporates) {
$username = "******";
$sql = $db->Query('SELECT user_id FROM {users} WHERE user_name = ?', array($username));
$user_id = $db->FetchOne($sql);
$db->Query('INSERT INTO {users_in_groups} (user_id, group_id) VALUES (?, ?)', array($user_id, $group_id));
}
}
}
}
// And also those individual users...
for ($i = 1; $i <= $maxindividualusers; $i++) {
$user_name = "iu{$i}";
$real_name = "Individual user {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different ones!
$email = $email = null;
$user_name . '@foo.bar.baz.org';
$group = rand(11, 12);
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// That's why we need some more global groups with different viewing rights
// And 100000 users just viewing our progress
for ($i = 1; $i <= $maxindividualusers; $i++) {
$user_name = "basic{$i}";
$real_name = "Basic {$i}";
$password = $user_name;
$time_zone = 0;
// Assign different ones!
$email = $email = null;
$user_name . '@foo.bar.baz.org';
$group = 4;
Backend::create_user($user_name, $password, $real_name, '', $email, 0, $time_zone, $group, 1);
}
// But that was not enough for all needed permission, so in practice, every
// project also has between 1 AND 20 project groups.
//
// Must recreate, so rights for new projects get loaded. Otherwise,
// even first user in database can't create tasks.
$user = new User(1);
// And that's why we've got 1000000 tasks opened within the last 10 years
for ($i = 1; $i <= $maxtasks; $i++) {
$project = rand(2, $maxproducts);
// Find someone who is allowed to open a task, do not use global groups
$sql = $db->Query("SELECT uig.user_id\n FROM {users_in_groups} uig\n JOIN {groups} g ON g.group_id = uig.group_id AND g.open_new_tasks = 1\n AND (g.project_id = 0 OR g.project_id = ?)\n WHERE g.group_id NOT IN (1, 2, 7, 8, 9)\n ORDER BY {$RANDOP} LIMIT 1", array($project));
$reporter = $db->FetchOne($sql);
$sql = $db->Query("SELECT category_id FROM {list_category} WHERE project_id = ? AND category_name <> 'root' ORDER BY {$RANDOP} LIMIT 1", array($project));
$category = $db->FetchOne($sql);
$opened = time() - rand(1, 315360000);
$args = array();
$args['project_id'] = $project;
$args['date_opened'] = time() - rand(1, 315360000);
// 'last_edited_time' => time(),
$args['opened_by'] = $reporter;
$args['product_category'] = $category;
$args['task_severity'] = 1;
$args['task_priority'] = 1;
// 'task_type', , 'product_version',
// 'operating_system', , 'estimated_effort',
// 'supertask_id',
$sql = $db->Query("SELECT project_title FROM {projects} WHERE project_id = ?", array($project));
$projectname = $db->FetchOne($sql);
$subject = $subjects[rand(0, count($subjects) - 1)];
$subject = sprintf($subject, $projectname);
$args['item_summary'] = "Task {$i} ({$subject})";
// 'detailed_desc'
// echo $args['item_summary'] . "\r\n";
$ok = Backend::create_task($args);
if ($ok === 0) {
echo "Failed to create task.\r\n";
} else {
list($id, $token) = $ok;
$db->Query('UPDATE {tasks} SET opened_by = ?, date_opened = ? WHERE task_id = ?', array($reporter, $opened, $id));
}
}
// One task in ten of is unconfirmed, probably just bullshit, not assigned to anyone,
// and we add just a comment "Cannot reproduce".
for ($i = 1; $i <= $maxcomments; $i++) {
$taskid = rand(2, $maxtasks + 1);
$task = Flyspray::GetTaskDetails($taskid, true);
$project = $task['project_id'];
$added = time() - rand(1, 315360000);
// Find someone who is allowed to add comment, do not use global groups
$sqltext = "SELECT uig.user_id\n FROM {users_in_groups} uig\n JOIN {groups} g ON g.group_id = uig.group_id AND g.add_comments = 1\n AND (g.project_id = 0 OR g.project_id = ?)\n WHERE g.group_id NOT IN (1, 2, 7, 8, 9)\n ORDER BY {$RANDOP} ";
$sql = $db->Query($sqltext, array($project));
$row = $db->FetchRow($sql);
$reporter = new User($row['user_id']);
// User might still not be able to add a comment, if he can not see the task...
// Just try again until a suitable one comes out from the query. It will finally.
// Try to enhance the query also to return fewer unsuitable ones.
while (!$reporter->can_view_task($task)) {
$row = $db->FetchRow($sql);
$reporter = new User($row['user_id']);
}
$comment = 'Comment.';
Backend::add_comment($task, $comment);
$sql = $db->Query('SELECT MAX(comment_id) FROM {comments}');
$comment_id = $db->FetchOne($sql);
$db->Query('UPDATE {comments} SET user_id = ?, date_added = ? WHERE comment_id = ?', array($reporter->id, $added, $comment_id));
}
// And 5000000 attachments total, either to task or comment
for ($i = 1; $i <= $maxattachments; $i++) {
$sql = $db->Query("SELECT comment_id, task_id, user_id, date_added FROM {comments} ORDER BY {$RANDOP} LIMIT 1");
list($comment_id, $task_id, $user_id, $date_added) = $db->FetchRow($sql);
$fname = "Attachment {$i}";
if (rand(1, 100) == 1) {
$comment_id = 0;
}
$origname = GetAttachmentDescription() . " {$i}";
$db->Query("INSERT INTO {attachments}\n ( task_id, comment_id, file_name,\n file_type, file_size, orig_name,\n added_by, date_added)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)", array($task_id, $comment_id, $fname, 'application/octet-stream', 1024, $origname, $user_id, $date_added));
}
function GetAttachmentDescription()
{
$type = rand(1, 100);
if ($type > 80 && $type <= 100) {
return 'Information that might help solve the problem';
} elseif ($type == 79) {
return 'Pic of my pet alligator';
} elseif ($type == 78) {
return 'Pic of my pet rhinoceros';
} elseif ($type == 77) {
return 'Pic of my pet elephant';
} elseif ($type == 76 || $type == 75) {
return 'Pic of my pet monkey';
} elseif ($type == 74 || $type == 73) {
return 'Pic of my undulate';
} elseif ($type == 72 || $type == 71) {
return 'Pic of my goldfish';
} elseif ($type == 70 || $type == 69) {
return 'Pic of my pet pig';
} elseif ($type == 68 || $type == 67) {
return 'Pic of my pet snake';
} elseif ($type == 66 || $type == 65) {
return 'Pic of my pet rat';
} elseif ($type == 64 || $type == 63) {
return 'Pic of my pet goat';
} elseif ($type == 62 || $type == 61) {
return 'Pic of my pet rabbit';
} elseif ($type == 60 || $type == 59) {
return 'Pic of my pet gerbil';
} elseif ($type == 58 || $type == 57) {
return 'Pic of my pet hamster';
} elseif ($type == 56 || $type == 55) {
return 'Pic of my pet chinchilla';
} elseif ($type == 54 || $type == 53) {
return 'Pic of my pet guinea pig';
} elseif ($type == 52 || $type == 51) {
return 'Pic of my pet turtle';
} elseif ($type == 50 || $type == 49) {
return 'Pic of my pet lizard';
} elseif ($type == 48 || $type == 47) {
return 'Pic of my pet frog';
} elseif ($type == 46 || $type == 45) {
return 'Pic of my pet tarantula';
} elseif ($type == 44 || $type == 43) {
return 'Pic of my pet hermit crab';
} elseif ($type == 42 || $type == 41) {
return 'Pic of my pet parrot';
} elseif ($type >= 40 && $type < 25) {
return 'Pic of my dog';
} else {
return 'Pic of my cat';
}
}
// // But at least we have been able to solve approximately half of the tasks
// Of course, many of the tasks are somehow related to each other, so add
// parents, relationships, dependencies, duplicates etc. last.
// Do this ones last, after creating all the other data.
// Approximately 200 hundred of our projects are already closed or deleted.
// Cannot be sure when using random...
for ($i = 1; $i < 200; $i++) {
}
// Some of our developers AND project managers couldn't take all that AND have already left the premises
// No wonder, because we've got those corporate AND individual users always complaining
// AND whining, not to speak about our management.
$db->dbClose();
function add_project_data()
{
global $db;
$sql = $db->Query('SELECT project_id FROM {projects} ORDER BY project_id DESC', false, 1);
$pid = $db->fetchOne($sql);
$cols = array('manage_project', 'view_tasks', 'open_new_tasks', 'modify_own_tasks', 'modify_all_tasks', 'view_comments', 'add_comments', 'edit_comments', 'delete_comments', 'show_as_assignees', 'create_attachments', 'delete_attachments', 'view_history', 'add_votes', 'close_own_tasks', 'close_other_tasks', 'assign_to_self', 'edit_own_comments', 'assign_others_to_self', 'add_to_assignees', 'view_reports', 'group_open', 'view_estimated_effort', 'view_current_effort_done', 'track_effort', 'add_multiple_tasks', 'view_roadmap', 'view_own_tasks', 'view_groups_tasks', 'edit_assignments');
$args = array_fill(0, count($cols), '1');
array_unshift($args, 'Project Managers', 'Permission to do anything related to this project.', intval($pid));
$db->Query("INSERT INTO {groups}\n ( group_name, group_desc, project_id,\n " . join(',', $cols) . ")\n VALUES ( " . $db->fill_placeholders($cols, 3) . ")", $args);
// Add 1 project specific developer group too.
$args = array_fill(1, count($cols) - 1, '1');
array_unshift($args, 'Project Developers', 'Permission to do almost anything but not manage project.', intval($pid), 0);
$db->Query("INSERT INTO {groups}\n ( group_name, group_desc, project_id,\n " . join(',', $cols) . ")\n VALUES ( " . $db->fill_placeholders($cols, 3) . ")", $args);
$db->Query("INSERT INTO {list_category}\n ( project_id, category_name,\n show_in_list, category_owner, lft, rgt)\n VALUES ( ?, ?, 1, 0, 1, 4)", array($pid, 'root'));
$db->Query("INSERT INTO {list_category}\n ( project_id, category_name,\n show_in_list, category_owner, lft, rgt )\n VALUES ( ?, ?, 1, 0, 2, 3)", array($pid, 'Backend / Core'));
// We develop software for a lot of operating systems.
// Add your favorite ones to the end so we get more data.
$os = 1;
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'All', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 3.0', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 3.1', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 3.11', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 95', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows ME', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 2000', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows XP', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Vista', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 7', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 8', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 8.1', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows 10', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.0', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.1', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.2', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.3', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.4', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.5', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.6', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'OS X 10.7', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Server 2003', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Server 2003 R2', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Server 2008', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Server 2008 R2', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Server 2012', $os++));
$db->Query("INSERT INTO {list_os}\n ( project_id, os_name, list_position, show_in_list )\n VALUES (?, ?, ?, 1)", array($pid, 'Windows Server 2012 R2', $os++));
// We've got also a lot of versions.
// Never go over 42! It's the universal answer to everything. So in that version,
// every possible bug is finally solved AND every feature request implemented.
$totalversions = rand(3, 42);
$present = rand(1, $totalversions);
for ($i = 1; $i <= $totalversions; $i++) {
$tense = $i == $present ? 2 : ($i < $present ? 1 : 3);
$db->Query("INSERT INTO {list_version}\n ( project_id, version_name, list_position,\n show_in_list, version_tense )\n VALUES (?, ?, ?, 1, ?)", array($pid, sprintf('%d.0', $i), $i, $tense));
}
}
}
