function getList($name, $db, $mail) { $t = loadLists($db, ""); foreach ($t["list"] as $list) { if (strcasecmp($list["name"], $name) == 0) { return $list["id"]; } } $newList = addList($db, $name); if (!$newList['total'] || $newList['total'] < 1) { err("error creating new list.", $mail); } return $newList['list'][0]['id']; }
function showResults() { #---------------------------------------------------------------------- #--- Output the page header. echo "<h1>Fun Statistics</h1>\n\n<br>"; echo "<p style='padding-left:20px;padding-right:20px;font-weight:bold'>Here you see a selection of fun statistics, based on official WCA competition results.</p>"; echo "<p style='padding-left:20px;padding-right:20px;font-weight:bold'>There are also three separate statistics pages: <a href='misc/evolution/'>Evolution of Records</a>, <a href='misc/sum_of_ranks/'>Sum of Ranks</a>, and <a href='misc/missing_averages/'>Missing Averages</a>.</p>"; echo "<p style='padding-left:20px;padding-right:20px;color:gray;font-size:10px'>Generated on " . wcaDate() . ".</p>"; #--- Get all the list definitions. defineAllLists(); global $lists; #--- Output the links to the individual lists. echo "<ul style='padding-left:20px'>\n"; foreach ($lists as $list) { echo "<li style='padding-bottom:5px'><a style='color:#33C;font-weight:normal' href='#{$list['0']}'>{$list['1']}</a></li>\n"; } echo "</ul>\n\n"; #--- Output the lists. $ctr = 0; foreach ($lists as $list) { addList($list, ++$ctr); } }
function showResults () { #---------------------------------------------------------------------- #--- Output the page header. echo "<h1>Fun Statistics</h1>\n\n"; echo "<p style='padding-left:20px;padding-right:20px;font-weight:bold'>Here you see a selection of fun statistics, based on official WCA competition results.</p>"; echo "<p style='padding-left:20px;padding-right:20px;color:gray;font-size:10px'>Generated on " . wcaDate() . ".</p>"; #--- Get all the list definitions. defineAllLists(); global $lists; #--- Output the links to the individual lists. echo "<ul style='padding-left:20px'>\n"; foreach( $lists as $list ) echo "<li style='padding-bottom:5px'><a style='color:#33C;font-weight:normal' href='#$list[0]'>$list[1]</a></li>\n"; echo "</ul>\n\n"; #--- Output the lists. $ctr = 0; foreach( $lists as $list ) addList( $list, ++$ctr ); }
<?php require '../core/sessions.php'; require '../core/functions.php'; getGetVar(); require_once '../core/db.php'; startSession(); getPersonalList($id); getUserToken($id); if ($_COOKIE['online'] == $id) { if (isset($_POST['list_name_submit']) && !empty($_POST['list_name_submit'])) { if (empty($_POST['list_name'])) { $_SESSION['temp_msg'] = 'Please enter a list name'; header('Location: ../edit-list.php?id=' . $id . '&success=false'); exit; } $listName = $_POST['list_name']; addList($userID, $listName); $_SESSION['temp_msg'] = $listAdded_success; header('Location: ../edit-list.php?id=' . $id . '&success=true'); exit; } } ?>
<?php /** Use this file to add another list into the database. The given filename is assumed to be in the correct order $listname should be the organzation that produced the list such as afi, or imdb **/ require_once "scrape.php"; require_once "addict_database.php"; $ad = new AddictDatabase(); $afi100 = readList("lists/afi_ids.txt"); addList($afi100); function addList($list) { global $ad; $current = $ad->getMovies(); $ad->resetAFIRank(); foreach ($list as $movie) { if (in_array($movie['id'], array_keys($current))) { $ad->updateAFIRank($movie['id'], $movie['rank']); echo "Updated " . $movie['id'] . " to #" . $movie['rank'] . "<br>"; } else { $ad->addMovie($movie['id'], $movie['title'], NULL, $movie['rank']); echo "Added " . $movie['id'] . " as #" . $movie['rank'] . "<br>"; } } } function readList($filename) { $fp = fopen($filename, "r"); $movies = array(); $count = 1;
<?php header('Content-Type: text/xml; charset=utf-8'); require_once "../includes/session.php"; require_once "../includes/functions.php"; require_once "../includes/connect.php"; if (isset($_GET['item'])) { addList(); } else { if (isset($_GET['delete'])) { deleteList(); showList(); } else { showList(); } } function addList() { global $connection; $day = $_GET['day']; $sql = "SELECT id, name FROM food WHERE id IN (" . $_GET['item'] . ")"; $result_set = mysql_query($sql, $connection); confirm_query($result_set); if (mysql_num_rows($result_set) >= 1) { echo "<foods>"; while ($foods = mysql_fetch_array($result_set)) { $sql = "INSERT INTO food_day (food_id, date) VALUES(" . $foods['id'] . ", '" . get_date_of_day($day) . "')"; $results = mysql_query($sql, $connection); confirm_query($results); echo "<food id='" . mysql_insert_id($connection) . "'>" . $foods['name'] . "</food>"; }
<?php require_once 'config.php'; require_once 'functions.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { if (!empty($_POST['list_title']) and !empty($_POST['list_paragraph'])) { addList($_POST['list_title'], $_POST['list_paragraph'], $conn); } }
$qmin = min($ac); if ($count >= 10) { $grades = 10; } else { $grades = $count; } $step = ($qmax - $qmin) / $grades; foreach ($at as $i => $tag) { $t['cloud'][] = array('tag' => htmlarray($tag['name']), 'id' => (int) $tag['id'], 'w' => tag_size($qmin, $ac[$i], $step)); } $t['total'] = $count; jsonExit($t); } elseif (isset($_GET['addList'])) { check_write_access(); stop_gpc($_POST); $t = addList($db, _post('name')); jsonExit($t); } elseif (isset($_GET['renameList'])) { check_write_access(); stop_gpc($_POST); $t = array(); $t['total'] = 0; $id = (int) _post('list'); $name = str_replace(array('"', "'", '<', '>', '&'), array('', '', '', '', ''), trim(_post('name'))); $db->dq("UPDATE {$db->prefix}lists SET name=?,d_edited=? WHERE id={$id}", array($name, time())); $t['total'] = $db->affected(); $r = $db->sqa("SELECT * FROM {$db->prefix}lists WHERE id={$id}"); $t['list'][] = prepareList($r); jsonExit($t); } elseif (isset($_GET['deleteList'])) { check_write_access();