function save_quote($data)
{
if (!is_admin()) {
return;
}
$table = "ez_quotes";
return db_save($table, $data);
}
function update_wrapper_730()
{
include '/usr/share/nginx/html/php/730_core.php';
$players = get_100_users();
if (empty($players) || !isset($players[0]['steamid']) || !is_array($players)) {
die;
}
update_730($players);
db_save('start_steamid_730', $steamid1 + 100);
}
public function testSimpeSave()
{
$save = array("content_type" => "page", "subtype" => "static", "title" => "one page", "parent" => "0", "is_deleted" => "0");
$save_post = array("content_type" => "post", "subtype" => "static", "title" => "one post", "parent" => "0", "is_deleted" => "0");
$content = db_save('content', $save);
$content2 = db_save('content', $save);
$content3 = db_save('content', $save);
$content4 = db_save('content', $save);
$content5 = db_save('content', $save_post);
$content6 = db_save('content', $save_post);
$this->assertTrue(true, !$content);
$this->assertTrue(true, !$content2);
$this->assertTrue(true, $content != $content2);
$this->assertTrue(true, $content2 != $content3);
$this->assertTrue(true, $content3 != $content4);
$this->assertTrue(true, $content4 != $content5);
$this->assertTrue(true, $content5 != $content6);
}
public function testLimitAndPaging()
{
$add_page = db_save('content', $this->save);
$add_page = db_save('content', $this->save);
$add_page = db_save('content', $this->save);
$add_page = db_save('content', $this->save);
$pages_count = db_get('content', 'limit=2&count_paging=1');
$first_page = db_get('content', 'limit=2');
$second_page = db_get('content', 'limit=2¤t_page=2');
$first_page_items = count($first_page);
$second_page_items = count($second_page);
$ids_on_first_page = array();
foreach ($first_page as $item) {
$this->assertTrue(isset($item['id']));
$ids_on_first_page[] = $item['id'];
}
foreach ($second_page as $item) {
$this->assertTrue(isset($item['id']));
$this->assertFalse(in_array($item['id'], $ids_on_first_page));
}
$this->assertEquals($first_page_items, $second_page_items, 'First page item count: ' . $first_page_items . ', second page item count: ' . $second_page_items);
$this->assertTrue(intval($pages_count) > 1);
// @todo: fix the count_paging param to return integer $this->assertTrue(is_int($pages_count));
}
<?php
include '../../include.php';
if ($posting) {
langTranslatePost('title,description');
db_save('pages');
url_change_post('./');
}
echo drawTop();
$f = new form('pages', @$_GET['id']);
$f->set_field(array('type' => 'text', 'name' => 'title' . langExt(), 'label' => getString('title')));
$f->set_field(array('type' => 'textarea', 'class' => 'tinymce', 'name' => 'description' . langExt(), 'label' => getString('description')));
$f->unset_fields('url,isSecure');
if (url_id('module_id')) {
$f->set_field(array('type' => 'hidden', 'name' => 'module_id', 'value' => $_GET['module_id']));
} else {
$f->unset_fields('module_id');
}
if (url_id('modulette_id')) {
$f->set_field(array('type' => 'hidden', 'name' => 'modulette_id', 'value' => $_GET['modulette_id']));
} else {
$f->unset_fields('modulette_id');
}
if (isset($_GET['url'])) {
$f->set_field(array('type' => 'hidden', 'name' => 'url', 'value' => $_GET['url']));
}
langUnsetFields($f, 'title,description');
langTranslateCheckbox($f);
echo $f->draw();
echo drawBottom();
<?php
include '../include.php';
if ($posting) {
error_debug('user is posting', __FILE__, __LINE__);
if ($uploading) {
list($_POST['content'], $_POST['type_id']) = file_get_uploaded('content', 'docs_types');
}
langTranslatePost('title,description');
$id = db_save('docs');
//debug();
db_checkboxes('categories', 'docs_to_categories', 'documentID', 'categoryID', $id);
if (getOption('channels')) {
db_checkboxes('channels', 'docs_to_channels', 'doc_id', 'channel_id', $id);
}
url_change('info.php?id=' . $id);
}
if (url_id()) {
$d = db_grab('SELECT title, description FROM docs WHERE id = ' . $_GET['id']);
$pageAction = getString('edit');
} else {
$pageAction = getString('add_new');
}
echo drawTop();
//load code for JS
$extensions = array();
$doctypes = array();
$types = db_query('SELECT description, extension FROM docs_types ORDER BY description');
while ($t = db_fetch($types)) {
$extensions[] = '(extension != "' . $t['extension'] . '")';
$doctypes[] = ' - ' . $t['description'] . ' (.' . $t['extension'] . ')';
<?php
include '../../include.php';
if ($posting) {
if ($_GET['doc_id'] == 'new') {
$_GET['doc_id'] = false;
}
if ($uploading) {
$_POST['extension'] = file_type($_FILES['content']['name']);
$_POST['content'] = file_get_uploaded('content');
}
$id = db_save('dl_docs', @$_GET['doc_id']);
db_checkboxes('categories', 'dl_docs_to_categories', 'doc_id', 'category_id', $id);
url_drop('id');
} elseif (url_action('delete')) {
db_delete('dl_docs');
url_drop('id,action');
}
echo drawTop();
if (!empty($_GET['doc_id'])) {
if ($_GET['doc_id'] == 'new') {
$_GET['doc_id'] = false;
}
$f = new form('dl_docs', @$_GET['doc_id'], ($_GET['doc_id'] ? 'Edit' : 'Add') . ' Document');
$f->set_title_prefix($page['breadcrumbs']);
$f->set_field(array('name' => 'title', 'label' => getString('title'), 'type' => 'text'));
$f->unset_fields('extension');
$f->set_field(array('name' => 'content', 'label' => getString('file'), 'type' => 'file', 'additional' => getString('upload_max') . file_get_max()));
$f->set_field(array('name' => 'categories', 'label' => getString('categories'), 'type' => 'checkboxes', 'options_table' => 'dl_categories', 'option_title' => 'title', 'linking_table' => 'dl_docs_to_categories', 'object_id' => 'doc_id', 'option_id' => 'category_id'));
echo $f->draw();
} else {
function apiKeyBox()
{
if (admin_password() && isset($_POST['apikeyfield']) && isset($_POST['apikeysubmit'])) {
db_save('akey', $_POST['apikeyfield']);
}
$apikey = db_load('akey');
echo '<div class="col2 rt"><h2>Api Key:</h2><br><form action="', $_SERVER['PHP_SELF'], '" method=post><input name="apikeyfield" type="text" placeholder="', $apikey, '"><br><input name="pass" type="password" class="ddinput"><input type=submit name=apikeysubmit value=apikeysubmit></form></div>';
}
<?php
include "include.php";
url_query_require();
if ($posting) {
$_POST['translations_do'] = true;
langTranslatePost('description');
$_POST["topic_id"] = $_GET["id"];
$id = db_save("bb_followups", false);
db_query('UPDATE bb_topics SET thread_date = GETDATE(), replies = (SELECT COUNT(*) FROM bb_followups WHERE topic_id = ' . $_POST['topic_id'] . ') WHERE id = ' . $_POST['topic_id']);
//send followup email to all topic contributors
if (getOption("bb_notifyfollowup")) {
$addresses = array();
$languages = db_array('SELECT code FROM languages');
foreach ($languages as $l) {
$addresses[$l] = array();
}
//get topic poster email, put in correct bucket
$poster = db_grab("SELECT \n\t\t\t\tu.email, \n\t\t\t\tl.code \n\t\t\tFROM bb_topics t \n\t\t\tJOIN users u ON t.created_user = u.id \n\t\t\tJOIN languages l ON u.language_id = l.id\n\t\t\tWHERE u.is_active = 1 AND t.id = " . $_POST["topic_id"]);
$addresses[$poster['code']][] = $poster['email'];
//get followup poster emails
$repliers = db_table("SELECT \n\t\t\t\tu.email,\n\t\t\t\tl.code\n\t\t\tFROM bb_followups f \n\t\t\tJOIN users u ON u.id = f.created_user \n\t\t\tJOIN languages l ON u.language_id = l.id\n\t\t\tWHERE u.is_active = 1 AND f.is_active = 1 AND f.topic_id = " . $_POST["topic_id"]);
foreach ($repliers as $r) {
$addresses[$r['code']][] = $r['email'];
}
foreach ($addresses as $lang => $emails) {
$topic = db_grab('SELECT
t.title' . langExt($lang) . ' title,
y.title' . langExt($lang) . ' type,
t.created_date
FROM bb_topics t
<?php
include "../../include.php";
if ($posting) {
$id = db_save("queries");
url_change("./");
}
echo drawTop();
if (isset($_GET["id"])) {
$r = db_grab("SELECT \n\t\t\tq.databaseID,\n\t\t\td.dbname,\n\t\t\tq.name,\n\t\t\tq.description,\n\t\t\tq.query,\n\t\t\tq.is_active\n\t\tFROM queries q \n\t\tJOIN queries_databases d ON d.id = q.databaseID\n\t\tWHERE q.id = " . $_GET["id"]);
/*db_switch($r["dbname"]);
db_query($r["query"], false, true);
db_switch($_josh["db"]["database"]);*/
} else {
$r["is_active"] = 1;
}
$form = new intranet_form();
$form->addRow("hidden", "", "is_active", $r["is_active"]);
$form->addRow("select", "Database", "databaseID", "SELECT id, dbname from queries_databases order by dbname", @$r["databaseID"], true);
$form->addRow("itext", "Name", "name", @$r["name"], "", false, 50);
$form->addRow("textarea", "Description", "description", @$r["description"]);
$form->addRow("textarea-plain", "Query", "query", @$r["query"]);
$form->addRow("submit", "Save Changes");
if (isset($_GET["id"])) {
$form->draw("<a href='/queries/'>Database Queries</a> > Edit Query");
} else {
$form->draw("Add New Query");
}
echo drawBottom();
<?php
include '../../include.php';
if ($posting) {
format_post_bits('is_selected');
langTranslatePost('name,description');
$id = db_save('soc_members');
url_change_post('../');
}
echo drawTop();
$f = new form('soc_members', @$_GET['id'], $page['title']);
$f->set_field(array('name' => 'name' . langExt(), 'type' => 'text', 'label' => getString('title')));
$f->set_field(array('name' => 'country_id', 'type' => 'select', 'sql' => 'SELECT id, en FROM jr_countries ORDER BY en'));
$f->set_field(array('name' => 'description' . langExt(), 'type' => 'textarea', 'class' => 'tinymce', 'label' => getString('description')));
langUnsetFields($f, 'name,description');
langTranslateCheckbox($f);
$f->set_title_prefix($page['breadcrumbs']);
echo $f->draw();
echo drawBottom();
<?php
include "../../include.php";
if ($posting) {
$id = db_save("web_news_blurbs");
url_change_post("../");
} elseif (url_action('delete')) {
db_delete('web_news_blurbs', $_GET['delete_id']);
url_change('../');
}
echo drawTop();
$f = new form("web_news_blurbs", @$_GET["id"]);
$f->set_title(drawHeader());
echo $f->draw();
echo drawBottom();
if ($r["statusID"] != 9) {
//open
$typeRequired = false;
} elseif (!$r["type_id"]) {
//closed, no type
$typeRequired = false;
} else {
$typeRequired = true;
}
//$page['is_admin'] = ($page['is_admin'] && ($r["departmentID"] == $_SESSION["departmentID"])) ? true : false;
if ($uploading) {
//upload an attachment
$_POST['content'] = file_get_uploaded('userfile');
$_POST['extension'] = file_ext($_FILES['userfile']['name']);
$_POST["ticketID"] = $_GET["id"];
$id = db_save('helpdesk_tickets_attachments', false);
url_change();
} elseif ($posting) {
//add a comment
//auto-assign ticket if unassigned and followup poster is an IT admin
$followupAdmin = !empty($_POST['is_admin']) ? 1 : 0;
if ($page['is_admin'] && !$followupAdmin && empty($r["ownerID"])) {
//set to it staff assigned if no status
if ($r["statusID"] == 1) {
$r["statusID"] = 2;
}
db_query('UPDATE helpdesk_tickets SET ownerID = ' . user() . ', statusID = ' . $r["statusID"] . ', updated_date = GETDATE() WHERE id = ' . $_GET['id']);
}
//insert followup
db_query('INSERT INTO helpdesk_tickets_followups (
ticketID,
<?php
include 'include.php';
if ($posting) {
error_debug('handling bb post', __FILE__, __LINE__);
format_post_bits('is_admin');
langTranslatePost('title,description');
$id = db_save('bb_topics');
db_query('UPDATE bb_topics SET thread_date = GETDATE(), replies = (SELECT COUNT(*) FROM bb_followups WHERE topic_id = ' . $id . ') WHERE id = ' . $id);
if (getOption('channels')) {
db_checkboxes('channels', 'bb_topics_to_channels', 'topic_id', 'channel_id', $id);
}
//notification
if ($_POST['is_admin'] == '1') {
//get addresses of everyone & send with message
emailUser(db_array('SELECT email FROM users WHERE is_active = 1'), $_POST['title'], drawEmail(bbDrawTopic($id, true)));
} elseif (getOption('bb_notifypost') && getOption('channels') && getOption('languages')) {
//get addresses of everyone with indicated interests and send
$channels = array_post_checkboxes('channels');
$languages = db_table('SELECT id, code FROM languages');
foreach ($languages as $l) {
$addresses = db_array('SELECT DISTINCT u.email FROM users u JOIN users_to_channels_prefs u2cp ON u.id = u2cp.user_id WHERE u.is_active = 1 AND u.language_id = ' . $l['id'] . ' AND u2cp.channel_id IN (' . implode(',', $channels) . ')');
$topic = db_grab('SELECT
ISNULL(u.nickname, u.firstname) firstname,
u.lastname,
t.title' . langExt($l['code']) . ' title,
t.description' . langExt($l['code']) . ' description,
y.title' . langExt($l['code']) . ' type,
t.created_date
FROM bb_topics t
LEFT JOIN bb_topics_types y ON t.type_id = y.id
<?php
include "../../include.php";
if ($posting) {
langTranslatePost('title');
$id = db_save('links');
url_drop('id');
} elseif (url_action('delete') && url_id('delete_id')) {
db_delete('links', $_GET['delete_id']);
url_drop('delete_id,action');
}
echo drawTop();
if (url_id()) {
//form
$f = new form('links', @$_GET['id']);
$f->set_field(array('type' => 'text', 'name' => 'title' . langExt(), 'label' => getString('title')));
langUnsetFields($f, 'title');
langTranslateCheckbox($f);
echo $f->draw();
} else {
//modules list
$t = new table('links', drawHeader());
$t->set_column('draggy', 'd', ' ');
$t->set_column('title', 'l', getString('title'));
$t->set_column('delete', 'd', ' ');
$result = db_table('SELECT l.id, l.title' . langExt() . ' title FROM links l WHERE l.is_active = 1 ORDER BY l.precedence');
$t->set_draggable('draggy');
foreach ($result as &$r) {
$r['draggy'] = draw_img('/images/icons/move.png');
$r['title'] = draw_link('links.php?id=' . $r['id'], $r['title']);
$r['delete'] = drawColumnDelete($r['id']);
function resetUpdateCounters($id)
{
if ($id == 'prices') {
db_save('440_pricelist_v4_time', (int) 0);
}
if ($id == 'schema') {
db_save('440_schema_time', (int) 0);
}
}
<?php
$included = isset($_josh);
if (!$included) {
include '../include.php';
}
$r = array();
if ($posting) {
langTranslatePost('title,description');
$id = db_save('external_orgs');
db_checkboxes('types', 'external_orgs_to_types', 'org_id', 'type_id', $id);
if (getOption('channels')) {
db_checkboxes('channels', 'external_orgs_to_channels', 'org_id', 'channel_id', $id);
}
url_change_post('./type.php?id=' . db_grab('SELECT type_id FROM external_orgs_to_types WHERE org_id = ' . $id));
//pure hackery
} elseif ($included) {
$title = getString('add_new');
$_josh['referrer'] = false;
$_josh['request']['path_query'] = 'edit.php';
//shoddy way of setting the form target
$r['url'] = 'http://';
} else {
url_query_require();
echo drawTop();
$title = $page['title'];
$r = db_grab('SELECT id, title, url, description from external_orgs WHERE id = ' . $_GET['id']);
}
if ($included) {
$_GET['id'] = false;
}
<?php
include '../../include.php';
if ($posting) {
if ($_GET['category_id'] == 'new') {
$_GET['category_id'] = false;
}
$id = db_save('dl_categories', @$_GET['category_id']);
url_drop('category_id');
} elseif (url_action('delete')) {
db_delete('dl_categories');
url_drop('action,id');
}
echo drawTop();
if (!empty($_GET['category_id'])) {
//category form
if ($_GET['category_id'] == 'new') {
$_GET['category_id'] = false;
}
$f = new form('dl_categories', $_GET['category_id'], ($_GET['category_id'] ? 'Edit' : 'Add') . ' Category');
$f->set_title_prefix($page['breadcrumbs']);
echo $f->draw();
} else {
//list of categories
$result = db_table('SELECT id, title, ' . db_updated() . ' FROM dl_categories WHERE is_active = 1 ORDER BY precedence');
$links = $page['is_admin'] ? array(url_query_add(array('category_id' => 'new'), false) => getString('add_new')) : false;
$t = new table('dl_categories', drawHeader($links));
$t->set_column('draggy', 'd', ' ');
$t->set_column('title', 'l', getString('title'));
$t->set_column('updated', 'r', getString('updated'));
$t->set_column('delete', 'd', ' ');
<?php
include "../../include.php";
url_query_require();
if ($posting) {
$id = db_save("wiki_topics");
db_checkboxes("tags", "wiki_topics_to_tags", "topicID", "tagID", $id);
url_change("topic.php?id=" . $id);
}
echo drawTop();
$r = db_grab("SELECT id, title, description, type_id FROM wiki_topics WHERE id = " . $_GET["id"]);
$form = new intranet_form();
if ($page['is_admin']) {
$form->addUser("created_user", "Posted By", $_SESSION["user_id"], false, true);
}
$form->addRow("itext", "Title", "title", $r["title"], "", true, 255);
$form->addRow("select", "Type", "type_id", "SELECT id, description FROM wiki_topics_types", $r["type_id"], true);
$form->addCheckboxes("tags", "Tags", "wiki_tags", "wiki_topics_to_tags", "topicID", "tagID", $_GET["id"]);
$form->addRow("textarea", "Description", "description", $r["description"], "", true);
$form->addRow("submit", "post wiki topic");
$form->draw("Add a Wiki Topic");
echo drawBottom();
<?php
include "../../include.php";
if ($posting) {
langTranslatePost('title');
$id = db_save('modules');
url_drop('id');
}
echo drawTop();
if (url_id()) {
//form
$f = new form('modules', @$_GET['id']);
$f->set_field(array('type' => 'text', 'name' => 'title' . langExt(), 'label' => getString('title')));
langUnsetFields($f, 'title');
langTranslateCheckbox($f);
echo $f->draw();
} else {
//modules list
$t = new table('modules', drawHeader());
$t->set_column('is_selected', 'd', ' ');
$t->set_column('draggy', 'd', ' ');
$t->set_column('title', 'l', getString('title'));
$t->set_column('pages', 'r');
$result = db_table('SELECT m.id, m.title' . langExt() . ' title, m.is_active, (SELECT COUNT(*) FROM pages p WHERE p.module_id = m.id AND p.modulette_id IS NULL) pages FROM modules m ORDER BY m.precedence');
$t->set_draggable('draggy');
foreach ($result as &$r) {
$r['is_selected'] = draw_form_checkbox('foo', $r['is_active'], false, 'ajax_set(\'modules\', \'is_active\', ' . $r['id'] . ', ' . abs($r['is_active'] - 1) . ');');
$r['draggy'] = draw_img('/images/icons/move.png');
$r['title'] = draw_link('./?id=' . $r['id'], $r['title']);
$r['pages'] = draw_link('pages.php?module_id=' . $r['id'], format_quantitize($r['pages'], 'page'));
}
<?php
include "include.php";
if ($posting) {
langTranslatePost('title,description');
$id = db_save('cal_events');
if (getOption('channels')) {
db_checkboxes('channels', 'cal_events_to_channels', 'event_id', 'channel_id', $id);
}
url_query_add(array("month" => $_POST['start_dateMonth'], "year" => $_POST['start_dateYear']));
}
if (!isset($_GET['month']) || !isset($_GET['year'])) {
url_query_add(array("month" => $_josh['month'], "year" => $_josh['year']));
}
echo drawTop();
echo drawNavigationCal($_GET['month'], $_GET['year']);
//get events
$result = db_query('SELECT
e.id,
DAY(e.start_date) startDay,
e.title' . langExt() . ' title,
t.color
FROM cal_events e
JOIN cal_events_types t ON e.type_id = t.id
' . getChannelsWhere('cal_events', 'e', 'event_id') . '
AND
MONTH(e.start_date) = ' . $_GET['month'] . ' AND
YEAR(e.start_date) = ' . $_GET['year']);
while ($r = db_fetch($result)) {
$events[$r['startDay']][$r['id']]['title'] = $r['title'];
$events[$r['startDay']][$r['id']]['color'] = $r['color'];
<?php
include "../../include.php";
if (url_action("delete")) {
db_delete("openings");
url_drop();
} elseif ($posting) {
//debug();
if ($id = db_save("openings")) {
url_change("position.php?id=" . $id);
}
}
echo drawTop();
?>
<table class="left" cellspacing="1">
<?php
if ($page['is_admin']) {
$colspan = 4;
echo drawHeaderRow("Open Positions", $colspan, "new", "#bottom");
} else {
$colspan = 3;
echo drawHeaderRow("Open Positions", $colspan);
}
?>
<tr>
<th width="50%">Title</th>
<th width="30%">Location</th>
<th class="r" width="20%"><nobr>Last Update</nobr></th>
<?php
if ($page['is_admin']) {
?>
$price = sprintf("%.2f", $item['valve_avg'] / 100);
} else {
if (isset($price) && $price != 0 && $price != -1) {
$price = sprintf("%.2f", cs_price($item['name']) / 100);
} else {
$price = 0;
$num_unpriced++;
}
}
echo '<tr><td><img src="' . $item['img_url'] . '"></td><td data-sort-value="' . $price . '">' . ($price != 0 ? $price : 'N/A') . '</td><td>' . $item['name'] . '</td></tr>';
$pricelist[$item['name']] = array('img' => $item['img_url'], 'price' => $price, 'classid' => isset($item['classid']) ? $item['classid'] : '');
}
echo '</table>';
echo $num_unpriced, ' Unpriced items remain.';
file_put_contents(json_directory() . '/cs_schema.json', json_encode($pricelist));
db_save('730_schemalist_time', array('time' => time(), 'priced' => $num_priced));
//echo '<br><br>';
//echo cs_price( 'Nova | Tempest (Minimal Wear)' );
function cs_price($itemName)
{
$col = db_init('market_730', 'item_prices');
//old query that worked: array( array( '$match' => array( 'name' =>$itemName ) ), array( '$group' => array( '_id'=>null, 'avgPrice' => array( '$avg'=> '$price' ) ) ) );
$count = $col->count(array("name" => "{$itemName}"));
if ($count == 0) {
//$res = json_decode( get_data( 'http://steamcommunity.com/market/priceoverview/?appid=730&market_hash_name=' . urlencode( $itemName ) ), true );
//if(isset($res['success'] ) && $res['success'] == true && (isset($res['lowest_price']) || isset($res['median_price']) ) ){
// if (isset($res['median_price']))
// return substr($res['median_price'], 1);
// if (isset($res['lowest_price']))
// return substr($res['lowest_price'], 1);
//}
<?php
include "include.php";
if ($posting) {
$id = db_save("helpdesk_tickets_types");
url_change("type.php?id=" . $id);
}
echo drawTop();
if (isset($_GET["id"])) {
$result = db_query("SELECT description FROM helpdesk_tickets_types WHERE id = " . $_GET["id"]);
$r = db_fetch($result);
}
$form = new intranet_form();
$form->addRow("itext", "Type Name", "description", @$r["description"]);
if (isset($_GET["id"])) {
$form->addRow("submit", "Save Changes");
$form->draw("Edit Ticket Type");
} else {
$form->addRow("submit", "Add Type");
$form->draw("Add New Ticket Type");
}
echo drawBottom();
function download_chunks($chunklist, $effective_url)
{
global $db, $prefix, $filetime;
$mh = curl_multi_init();
$connections = array();
$files = array();
curl_multi_setopt($mh, CURLMOPT_PIPELINING, 1);
curl_multi_setopt($mh, CURLMOPT_MAXCONNECTS, 1);
foreach ($chunklist as $chunk) {
if (db_is_file_downloaded($db, $chunk["filename"])) {
// this file is already downloaded, skip downloading
l("skip downloading: : " . $chunk["filename"]);
// fill in the corresponding array elements to make these arrays synchronized with $chunklist
$connections[] = null;
$files[] = null;
continue;
}
l("going to download: " . $chunk["filename"]);
$url = str_replace("playlist.m3u8", $chunk["filename"], $effective_url);
$c = new_curl($url);
$f = fopen(DATA_DIR . $chunk["filename"], "w");
curl_setopt($c, CURLOPT_FILE, $f);
curl_multi_add_handle($mh, $c);
$connections[] = $c;
$files[] = $f;
}
//execute the handles
$still_running;
do {
$mrc = curl_multi_exec($mh, $still_running);
curl_multi_select($mh, 5);
} while ($still_running > 0);
l("all downloads finished");
$t = $filetime;
for ($i = 0; $i < count($connections); $i++) {
$c = $connections[$i];
$chunk = $chunklist[$i];
if ($c) {
curl_multi_remove_handle($mh, $c);
$status = curl_getinfo($c, CURLINFO_HTTP_CODE);
if ($status == 200) {
db_add_file($db, $t, $chunk["filename"], $chunk["duration"]);
} else {
l("chunk download failed, status: " . $status . ", filename: " . $chunk["filename"]);
}
$t += $chunk["duration"];
}
}
$filetime = $t;
foreach ($files as $f) {
if ($f) {
fclose($f);
}
}
curl_multi_close($mh);
db_save($db);
}
<?php
include "../../include.php";
if ($posting) {
$id = db_save("wiki_topics_types");
url_change();
}
echo drawTop();
?>
<table class="left" cellspacing="1">
<?php
echo drawHeaderRow("Types", 2);
$tags = db_query("SELECT \n\t\tt.id, \n\t\tt.description,\n\t\t(SELECT COUNT(*) FROM wiki_topics w WHERE w.type_id = t.id) topics\n\t\tFROM wiki_topics_types t \n\t\tWHERE t.is_active = 1\n\t\tORDER BY t.description");
if (db_found($tags)) {
?>
<tr>
<th align="left">Type</th>
<th align="right">#</th>
</tr>
<?php
while ($t = db_fetch($tags)) {
?>
<tr>
<td><?php
if ($t["topics"]) {
?>
<a href="type.php?id=<?php
echo $t["id"];
?>
"><?php
}
<?php
include "../../include.php";
if ($posting) {
langTranslatePost('title');
$id = db_save('organizations');
url_drop('id');
} elseif (url_action('delete') && url_id('delete_id')) {
db_delete('organizations', $_GET['delete_id']);
url_drop('delete_id,action');
}
echo drawTop();
if (url_id()) {
//form
$f = new form('organizations', @$_GET['id']);
$f->set_field(array('type' => 'text', 'name' => 'title' . langExt(), 'label' => getString('title')));
langUnsetFields($f, 'title');
langTranslateCheckbox($f);
echo $f->draw();
} else {
//modules list
$t = new table('organizations', drawHeader());
$t->set_column('draggy', 'd', ' ');
$t->set_column('title', 'l', getString('title'));
$t->set_column('delete', 'd', ' ');
$result = db_table('SELECT id, title' . langExt() . ' title FROM organizations WHERE is_active = 1 ORDER BY precedence');
foreach ($result as &$r) {
$r['draggy'] = draw_img('/images/icons/move.png');
$r['title'] = draw_link('organizations.php?id=' . $r['id'], $r['title']);
$r['delete'] = drawColumnDelete($r['id']);
}
<?php
$included = isset($_josh);
if (!$included) {
include '../include.php';
}
$r = false;
if ($posting) {
langTranslatePost('title,description,publication');
$id = db_save("press_clips");
if (getOption('channels')) {
db_checkboxes('channels', 'press_clips_to_channels', 'clip_id', 'channel_id', $id);
}
url_change_post("/press-clips/clip.php?id=" . $id);
} elseif ($included) {
$action = getString('add_new');
$_josh["request"]["path_query"] = "edit.php";
//shoddy way of setting the form target
$r["url"] = "http://";
} elseif (url_id()) {
$action = getString('edit');
echo drawTop();
$r = db_grab("SELECT id, title, url, publication, pub_date, description, type_id from press_clips WHERE id = " . $_GET["id"]);
$r["title"] = format_title($r["title"], "US");
} else {
$action = getString('add_new');
echo drawTop();
if (isset($_GET["title"])) {
$r["title"] = format_title($_GET["title"], "US");
}
if (isset($_GET["url"])) {
<?php
include "../../include.php";
if (url_action("delete")) {
db_delete('board_members');
url_drop();
} elseif ($posting) {
$id = db_save('board_members');
url_change();
}
echo drawTop();
echo drawTableStart();
if ($page['is_admin']) {
$colspan = 2;
echo drawHeaderRow("Board Members", $colspan, "new", "#bottom");
} else {
$colspan = 3;
echo drawHeaderRow("Board Members", $colspan);
}
$result = db_query("SELECT\n\t\t\t\tm.id,\n\t\t\t\tm.firstname,\n\t\t\t\tm.lastname,\n\t\t\t\tm.board_position,\n\t\t\t\to.description organization\n\t\t\tFROM board_members m\n\t\t\tJOIN organizations o ON m.organization_id = o.id\n\t\t\tWHERE m.is_active = 1\n\t\t\tORDER BY o.description, m.lastname, m.firstname");
if (db_found($result)) {
?>
<tr>
<th align="left" width="60%">Name</th>
<th align="left" width="40%">Position on Board</th>
<?php
if ($page['is_admin']) {
echo "<th width='16'></th>";
}
?>
</tr>
if (isset($_josh)) {
//included
$_josh["request"]["path_query"] = "/news/edit.php";
} else {
//page loaded on its own
include "../../include.php";
if ($posting) {
if (isset($_FILES["content"]["name"]) && !empty($_FILES["content"]["name"])) {
list($_POST["content"], $_POST["fileTypeID"]) = file_get_uploaded("content", "docs_types");
}
if (isset($_FILES["image"]["name"]) && !empty($_FILES["image"]["name"])) {
list($_POST["image"], $_POST["imageTypeID"]) = file_get_uploaded("image", "docs_types");
//die($_POST["image"]);
}
$id = db_save("news_stories");
db_checkboxes("corporationID", "news_stories_to_organizations", "newsID", "organizationID", $id);
url_change("./?id=" . $id);
}
echo drawTop();
$r = db_grab("SELECT \n\t\tn.headline,\n\t\tn.outlet,\n\t\tn.pubdate,\n\t\tn.url,\n\t\tn.description\n\t\tFROM news_stories n\n\t\tWHERE id = " . $_GET["id"]);
}
$form = new intranet_form();
$form->addCheckboxes("corporationID", "Organization", "organizations", "news_stories_to_organizations", "newsID", "organizationID", @$_GET["id"]);
$form->addRow("itext", "Headline", "headline", @$r["headline"], "", true, 255);
$form->addRow("itext", "News Outlet", "outlet", @$r["outlet"], "", true, 255);
$form->addRow("date", "Date", "pubdate", @$r["pubdate"], "", true);
$form->addRow("file", "Image<br>(optional)", "image", "", "", false);
$form->addRow("file", "File<br>(optional)", "content", "", "", true);
$form->addRow("itext", "URL<br>(optional)", "url", @$r["url"], "", false, 255);
$form->addRow("textarea-plain", "Description<br>(optional)", "description", @$r["description"]);
