bouncer_r/php/lib mirror.php,1.2,1.3
David Farning (dfarning)
fedora-extras-commits at redhat.com
Mon Aug 1 20:39:42 UTC 2005
Author: dfarning
Update of /cvs/fedora/bouncer_r/php/lib
In directory cvs-int.fedora.redhat.com:/tmp/cvs-serv13863/php/lib
Added Files:
mirror.php
Log Message:
cvs cleanup for fedora initial commit
View full diff with command:
/usr/bin/cvs -f diff -kk -u -N -r 1.2 -r 1.3 mirror.php
Index: mirror.php
===================================================================
RCS file: mirror.php
diff -N mirror.php
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ mirror.php 1 Aug 2005 20:39:40 -0000 1.3
@@ -0,0 +1,2033 @@
+<?php
+/**
+ * Application functions. Dependent on lib/db.php!
+ * @package mirror
+ * @subpackage lib
+ * @author Mike Morgan
+ */
+
+
+/**
+ * Arch Delete.
+ * @param int $arch_id
+ * @return bool
+ */
+function mirror_arch_delete($arch_id)
+{
+ return db_query("
+ DELETE FROM
+ archs
+ WHERE
+ arch_id={$arch_id}");
+}
+
+
+/**
+ * Arch Get All.
+ * @return array
+ */
+function mirror_arch_get_all()
+{
+ return db_get("
+ SELECT
+ *
+ FROM
+ archs",MYSQL_ASSOC);
+}
+
+
+/**
+ * Arch Get All for Select List.
+ * @return array
+ */
+function mirror_arch_get_all_select()
+{
+ $archs = db_get("
+ SELECT
+ arch_id,arch_name
+ FROM
+ archs
+ ORDER BY
+ arch_name ASC",MYSQL_ASSOC);
+
+ foreach ($archs as $arch) {
+ $retval[$arch['arch_id']]=$arch['arch_name'];
+ }
+ return $retval;
+}
+
+
+/**
+ * Arch Get One.
+ * @param int $arch_id
+ * @return array
+ */
+function mirror_arch_get_one($arch_id)
+{
+ return db_get_one("
+ SELECT
+ *
+ FROM
+ archs
+ WHERE
+ arch_id = {$arch_id}");
+}
+
+
+/**
+ * Arch Get for Select List by Product, Version.
+ * @param int $product_id
+ * @param int $version_id
+ * @return array $versions
+ */
+function mirror_arch_get_select_pv($product_id,$version_id)
+{
+ $archs = db_get("
+ SELECT
+ repos.arch_id, archs.arch_name
+ FROM
+ repos
+ INNER JOIN
+ archs
+ ON
+ archs.arch_id = repos.arch_id
+ WHERE
+ repos.product_id='{$product_id}'
+ AND
+ repos.version_id='{$version_id}'
+ ORDER BY
+ arch_name ASC",MYSQL_ASSOC);
+
+ foreach ($archs as $arch) {
+ $retval[$arch['arch_id']]=$arch['arch_name'];
+ }
+ return $retval;
+}
+
+
+/**
+ * Arch Insert.
+ * @param string $arch_name
+ * @param int $arch_path
+ * @return bool
+ */
+function mirror_arch_insert($arch_name,$arch_path)
+{
+ return db_query("
+ INSERT INTO
+ archs(arch_name,arch_path)
+ VALUES
+ ('{$arch_name}','{$arch_path}')");
+}
+
+
+/**
+ * Arch Update.
+ * @param int $arch_id
+ * @param string $arch_name
+ * @param int $arch_path
+ * @return array
+ */
+function mirror_arch_update($arch_id,$arch_name,$arch_path)
+{
+ return db_query("
+ UPDATE
+ archs
+ SET
+ arch_name='{$arch_name}',arch_path='{$arch_path}'
+ WHERE
+ arch_id={$arch_id}");
+}
+
+/**
+ * Arch Get Select PV by ID.
+ * @param int $product_id
+ * @param int $version_id
+ * @return array $versions
+ */
+function mirror_arch_get_pv_id($product_id,$version_id)
+{
+ return db_get("
+ SELECT DISTINCT
+ (r.arch_id), a.arch_name
+ FROM
+ repos r, archs a
+ WHERE
+ a.arch_id = r.arch_id
+ AND
+ r.product_id='{$product_id}'
+ AND
+ r.version_id='{$version_id}'
+ ORDER BY
+ arch_name ASC",MYSQL_ASSOC);
+}
+
+
+/**
+ * Continent Insert.
+ * @param string $continent_name
+ * @param int $continent_priority
+ * @return bool
+ */
+function mirror_continent_insert($continent_name,$continent_priority)
+{
+ return db_query("
+ INSERT INTO
+ continents(continent_name,continent_priority)
+ VALUES
+ ('{$continent_name}','{$continent_priority}')");
+}
+
+
+/**
+ * Continent Update.
+ * @param int $continent_id
+ * @param string $continent_name
+ * @param int $continent_priority
+ * @return bool
+ */
+function mirror_continent_update($continent_id,$continent_name,$continent_priority)
+{
+ return db_query("
+ UPDATE
+ continents
[...1640 lines suppressed...]
+ * @param int $version_id
+ * @return bool
+ */
+function mirror_version_delete($version_id)
+{
+ return (db_query("
+ DELETE FROM
+ versions
+ WHERE
+ version_id='{$version_id}'"))?true:false;
+}
+
+
+/**
+ * Version Get.
+ * @return array $versions array containing all version information.
+ */
+function mirror_versions_get()
+{
+ return db_get("
+ SELECT
+ *
+ FROM
+ versions");
+}
+
+
+/**
+ * Version Get One.
+ * @param int $version_id
+ * @return array
+ */
+function mirror_version_get_one($version_id)
+{
+ return db_get_one("
+ SELECT
+ *
+ FROM
+ versions
+ WHERE
+ version_id='{$version_id}'");
+ }
+
+
+/**
+ * Versions Get for Select List.
+ * @return array $versions
+ */
+function mirror_version_get_select()
+{
+ $versions = db_get("
+ SELECT
+ *
+ FROM
+ versions
+ ORDER BY
+ version_name ASC",MYSQL_ASSOC);
+
+ foreach ($versions as $version) {
+ $retval[$version['version_id']]=$version['version_name'];
+ }
+ return $retval;
+}
+
+
+/**
+ * Process statistics request and return result array.
+ * @param array $posts
+ * @return array $stats
+ */
+function mirror_stats_get($posts)
+{
+ if (empty($_POST['x-axis'])) {
+ set_error('You did not define an x-axis.');
+ return null;
+ } elseif (empty($_POST['y-axis'])) {
+ set_error('You did not define a y-axis.');
+ return null;
+ }
+ $x = $_POST['x-axis'];
+ $y = $_POST['y-axis'];
+
+ $x_data = db_get("SELECT * FROM {$x}s ORDER BY {$x}_name ASC",MYSQL_ASSOC);
+ $stats['x_labels'] = mirror_get_labels($x,$x_data);
+
+ $y_data = db_get("SELECT * FROM {$y}s ORDER BY {$y}_name ASC",MYSQL_ASSOC);
+ $stats['y_labels'] = mirror_get_labels($y,$y_data);
+
+ foreach ($y_data as $row) {
+ foreach ($x_data as $col) {
+ $query = "SELECT COUNT(log_id) as count FROM log WHERE {$x}_id = d";
+ $buf = db_fetch(db_query($query));
+ $vals[$col[$x.'_id']] = $buf['count'];
+ }
+ $stats[$row[$y.'_id']] = $vals;
+ }
+
+ return $stats;
+}
+
+
+/**
+ * Process data and return an array of labels.
+ * @param string $name
+ * @param array $data
+ * @return array $labels
+ */
+function mirror_get_labels($name,$data)
+{
+ if (!empty($name)&&!empty($data)) {
+ foreach ($data as $row) {
+ $labels[$row[$name.'_id']]=$row[$name.'_name'];
+ }
+ }
+ return $labels;
+}
+
+
+/**
+ * Task Get All.
+ * @return array
+ */
+function mirror_task_get_all()
+{
+ return db_get("
+ SELECT
+ *
+ FROM
+ tasks",MYSQL_ASSOC);
+}
+
+
+/**
+ * Task Insert.
+ * @param string $task_name
+ * @param int $assigned
+ * @return bool
+ */
+function mirror_task_insert($task_name,$assigned)
+{
+ return db_query("
+ INSERT INTO
+ tasks(task_name,assigned)
+ VALUES
+ ('{$task_name}','{$assigned}')");
+}
+
+
+/**
+ * Task Delete.
+ * @param int $task_id
+ * @return bool
+ */
+function mirror_task_delete($task_id)
+{
+ return db_query("
+ DELETE FROM
+ tasks
+ WHERE
+ task_id={$task_id}");
+}
+
+
+/**
+ * Task Get.
+ * @param int $task_id
+ * @return array
+ */
+function mirror_task_get_one($task_id)
+{
+ return db_get_one("
+ SELECT
+ *
+ FROM
+ tasks t
+ WHERE
+ t.task_id='{$task_id}'");
+ }
+
+
+/**
+ * Task Update.
+ * @param int $task_id
+ * @param string $task_name
+ * @param int $assigned
+ * @return array
+ */
+function mirror_task_update($task_id,$task_name,$assigned)
+{
+ return db_query("
+ UPDATE
+ tasks
+ SET
+ task_name='{$task_name}',assigned='{$assigned}'
+ WHERE
+ task_id={$task_id}");
+}
+
+
+?>
More information about the fedora-extras-commits
mailing list