/**
* Creating new session
*
*
*
* @param string Session name
* @access public
*/
function session($name)
{
$this->name = $name;
ini_set('session.use_only_cookies', '1');
if (!isset($_SERVER['HTTP_USER_AGENT']) || $this->checkBot($_SERVER['HTTP_USER_AGENT'])) {
session_set_cookie_params(0);
// current browser session only
session_name($name);
@session_start();
// setting expiration time for session (the easiest way)
$expiretime = 60 * 60 * 1;
// 2 hours
if (isset($_SESSION['expire']) && $_SESSION['expire'] < time()) {
$_SESSION['DATA'] = '';
}
$_SESSION['expire'] = time() + $expiretime;
if (isset($_SESSION['DATA'])) {
$this->data = unserialize($_SESSION['DATA']);
} else {
$this->data = array();
}
$this->started = 1;
Define("SESSION_ID", session_name() . "=" . session_id());
Define("SID", session_name() . "=" . session_id());
}
}
public function setSection($section)
{
if ($section == "admin") {
Define('USE_DIR', DIR_APPLICATION);
$this->data['section'] = $this->language->get('menu_backend');
return "§ion=admin";
} else {
Define('USE_DIR', DIR_ROOT);
$this->data['section'] = $this->language->get('menu_frontend');
return "";
}
}
function setup_import()
{
Define("HOST_ADDR", "localhost");
// if the database cluster is on the same server as this application use 'localhost' otherwise the appropriate address (192.168.0.2 for example).
Define("PORT_NO", "5432");
// default port is 5432. If you have or had more than one db cluster at the same time, consider ports 5433,... etc.
Define("DATABASE_NAME", "testdb");
// the database you want to import
Define("USER_NAME", "username");
// role having rights to read the database
Define("PASSWORD", "??????");
// password for role
}
public static function Prepare($config)
{
Define('DS', DIRECTORY_SEPARATOR);
Define('FRAMEWORK_DIR', dirname(dirname(__FILE__)) . "/cherryphp");
Define('APP_DIR', dirname(dirname(__FILE__)));
spl_autoload_register(array('Cherry', 'LoadClass'));
Init::$Router = (require APP_DIR . DS . 'router.php');
if (!empty($config)) {
Init::$Config = (require $config . "config.php");
} else {
Init::$Config = (require APP_DIR . DS . 'config.php');
}
foreach (Init::$Config['define'] as $k => $v) {
Define($k, Init::$Config['define'][$k]);
}
#spl_autoload_register(array('Cherry','appClass'));
return new self();
}
<?php
session_start();
$_POST = json_decode(file_get_contents("php://input"), true);
if (isset($_SESSION['net_id'])) {
include "advanced_user_oo.php";
Define('DATABASE_SERVER', $hostname);
Define('DATABASE_USERNAME', $username);
Define('DATABASE_PASSWORD', $password);
Define('DATABASE_NAME', 'event_manager');
class DbInfo
{
var $res = false;
var $delete_res = '';
}
$mysqli = new mysqli(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME);
$db_info = new DbInfo();
$event_id = $_POST['event_id'];
$room_id = $_POST['room_id'];
if (empty($_POST['session_start'])) {
$session_start = null;
} else {
$session_start = $_POST['session_start'];
}
if (empty($_POST['session_end'])) {
$session_end = null;
} else {
$session_end = $_POST['session_end'];
}
$net_id = $_POST['net_id'];
$waiter_id = $_POST['waiter_id'];
<?php
/**
* Libraries loader
*
* Used to load required libraries
*
* @author Serge Dzheigalo <*****@*****.**>
* @package framework
* @copyright ActiveUnit, Inc. 2001-2004
* @version 1.0
* @modified 01-Jan-2004
*/
Define("THIS_URL", $_SERVER['REQUEST_URI']);
// liblary modules loader
if ($lib_dir = @opendir("./lib")) {
while (($lib_file = readdir($lib_dir)) !== false) {
if (preg_match("/\\.php\$/", $lib_file) && $lib_file != "loader.php") {
include_once "./lib/{$lib_file}";
}
}
closedir($lib_dir);
}
// Insert the path where you unpacked log4php
require_once dirname(__FILE__) . '/log4php/Logger.php';
// Tell log4php to use our configuration file.
Logger::configure(dirname(__FILE__) . '/log4php/config.php');
/**
* vcard.php
*
* This file shows an attched vcard
*
* @copyright © 1999-2007 The SquirrelMail Project Team
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
* @version $Id: vcard.php 12127 2007-01-13 20:07:24Z kink $
* @package squirrelmail
*/
/**
* Path for SquirrelMail required files.
* @ignore
*/
Define('SM_PATH', '../');
/* SquirrelMail required files. */
require_once SM_PATH . 'include/validate.php';
require_once SM_PATH . 'functions/date.php';
require_once SM_PATH . 'functions/page_header.php';
require_once SM_PATH . 'functions/mime.php';
require_once SM_PATH . 'include/load_prefs.php';
/* globals */
sqgetGlobalVar('username', $username, SQ_SESSION);
sqgetGlobalVar('key', $key, SQ_COOKIE);
sqgetGlobalVar('onetimepad', $onetimepad, SQ_SESSION);
sqgetGlobalVar('passed_id', $passed_id, SQ_GET);
sqgetGlobalVar('mailbox', $mailbox, SQ_GET);
sqgetGlobalVar('ent_id', $ent_id, SQ_GET);
sqgetGlobalVar('startMessage', $startMessage, SQ_GET);
/* end globals */
<?php
/*
* @version 0.1 (auto-set)
*/
Define('IWIDTH', 120);
Define('IHEIGHT', 20);
Define('TEXTLENGTH', 5);
Define('FROMFILE', './lib/codebook.txt');
Define('FONT', './lib/_vimage_tahoma.ttf');
include_once "./lib/general.class.php";
if (!defined('ENVIRONMENT')) {
error_reporting(E_ALL ^ E_NOTICE ^ E_DEPRECATED ^ E_STRICT);
ini_set('display_errors', 0);
}
$position = (int) $_GET['n'];
$file = fopen(FROMFILE, "r");
$content = fread($file, filesize(FROMFILE));
fclose($file);
while ($position > strlen($content)) {
$position -= strlen($content);
}
$text = substr($content, $position, 3 * TEXTLENGTH);
$text = preg_replace("/[^a-zA-Z0-9]+/", '', $text);
$text = substr($text, 0, TEXTLENGTH);
$text = strtolower($text);
header("Content-type: image/png");
$im = ImageCreate(IWIDTH, IHEIGHT);
if ($im === false) {
die("Cannot Initialize new GD image stream");
}
<?php
Define("pageLoaderConfFile", "{$settings['moduleAddress']}/{$sysVar['op']}/config/config");
$config = pageLoaderConfFile . ".php";
if (file_exists($config)) {
require_once $config;
} else {
die("Page Loader sub system is down !");
}
} else {
// default to agipa 119601, first format implemented
Define("PAPER_SIZE", "A4");
Define("PAPER_ORIENTATION", "P");
Define("V_MARGIN", 6);
Define("H_MARGIN", 13);
Define("COL_SIZE", 22);
Define("ROW_SIZE", 16);
Define("COL_NUM", 9);
Define("ROW_NUM", 17);
Define("V_PADDING", 0);
Define("H_PADDING", 0);
Define("BARCODE_WIDTH", 20);
Define("BARCODE_HEIGHT", 10);
Define("TEXT_HEIGHT", 3);
Define("TEXT_SIZE", 8);
}
require_once \Pasteque\PT::$ABSPATH . "/lib/barcode-master/php-barcode.php";
$font = "./lib/barcode-master/NOTTB___.TTF";
$pdf = new \FPDF(PAPER_ORIENTATION, "mm", PAPER_SIZE);
$pdf->setMargins(H_MARGIN, V_MARGIN);
$pdf->setAutoPageBreak(false, V_MARGIN);
$pdf->AddPage();
$pdf->SetFont('Arial', 'B', TEXT_SIZE);
function pdf_barcode($pdf, $productId, $col, $row)
{
$product = \Pasteque\ProductsService::get($productId);
$x = H_MARGIN + $col * COL_SIZE + $col * H_PADDING;
$y = V_MARGIN + $row * ROW_SIZE + $row * V_PADDING;
$pdf->SetXY($x, $y);
$pdf->Cell(BARCODE_WIDTH, TEXT_HEIGHT, utf8_decode($product->reference), 0, 1, "C");
define('FILENAME_ORDERS_INVOICE', 'invoice.php');
define('FILENAME_ORDERS_PACKINGSLIP', 'packingslip.php');
define('FILENAME_ORDERS_STATUS', 'orders_status.php');
define('FILENAME_PAGES', 'pages.php');
define('FILENAME_POPUP_FILE_MANAGER', 'popup_file_manager.php');
define('FILENAME_POPUP_FORBIDDEN', 'popup_forbidden.php');
define('FILENAME_POPUP_IMAGE', 'popup_image.php');
define('FILENAME_POPUP_INFO_PAGES', 'popup_info_pages.php');
define('FILENAME_POPUP_PAGES', 'popup_pages.php');
define('FILENAME_PRODUCTS_ATTRIBUTES', 'products_attributes.php');
define('FILENAME_PRODUCTS_EXPECTED', 'products_expected.php');
define('FILENAME_REVIEWS', 'reviews.php');
define('FILENAME_SERVER_INFO', 'server_info.php');
define('FILENAME_SHIPPING_MODULES', 'shipping_modules.php');
define('FILENAME_STATS_CREDITS', 'stats_credits.php');
define('FILENAME_STATS_CUSTOMERS', 'stats_customers.php');
define('FILENAME_STATS_PRODUCTS_PURCHASED', 'stats_products_purchased.php');
define('FILENAME_STATS_PRODUCTS_VIEWED', 'stats_products_viewed.php');
define('FILENAME_TAX_CLASSES', 'tax_classes.php');
define('FILENAME_TAX_RATES', 'tax_rates.php');
define('FILENAME_WHOS_ONLINE', 'whos_online.php');
define('FILENAME_XSELL_PRODUCTS', 'xsell.php');
define('FILENAME_ZONES', 'zones.php');
define('FILENAME_ADMIN_ACCOUNT', 'admin_account.php');
define('FILENAME_ADMIN_MEMBERS', 'admin_members.php');
Define('FILENAME_FORBIDDEN', 'forbidden.php');
define('FILENAME_LOGIN', 'login.php');
define('FILENAME_LOGOFF', 'logoff.php');
define('FILENAME_PASSWORD_FORGOTTEN', 'password_forgotten.php');
define('FILENAME_UPDATE_PRODUCTS_PRICES', 'update_products_prices.php');
$linkable_files = array('account.php' => 'SSL', 'account_edit.php' => 'SSL', 'account_history.php' => 'SSL', 'account_history_info.php' => 'SSL', 'account_newsletters.php' => 'SSL', 'account_notifications.php' => 'SSL', 'account_password.php' => 'SSL', 'address_book.php' => 'SSL', 'address_book_process.php' => 'SSL', 'advanced_search_and_results.php' => 'NONSSL', 'checkout_confirmation.php' => 'SSL', 'checkout_payment.php' => 'SSL', 'checkout_payment_address.php' => 'SSL', 'checkout_process.php' => 'SSL', 'checkout_shipping.php' => 'SSL', 'checkout_shipping_address.php' => 'SSL', 'checkout_success.php' => 'SSL', 'content.php' => 'NONSSL', 'cookie_usage.php' => 'NONSSL', 'create_account.php' => 'SSL', 'create_account_success.php' => 'SSL', 'index.php' => 'NONSSL', 'images_window.php' => 'NONSSL', 'login.php' => 'SSL', 'logoff.php' => 'SSL', 'newsletter_subscribe.php' => 'SSL', 'options_window.php' => 'NONSSL', 'password_forgotten.php' => 'SSL', 'popup_content.php' => 'REQUEST_TYPE', 'popup_image.php' => 'REQUEST_TYPE', 'product_info.php' => 'NONSSL', 'product_listing.php' => 'NONSSL', 'product_reviews.php' => 'NONSSL', 'product_reviews_info.php' => 'NONSSL', 'product_reviews_write.php' => 'SSL', 'products_new.php' => 'NONSSL', 'reviews.php' => 'NONSSL', 'search_result.php' => 'NONSSL', 'shopping_cart.php' => 'NONSSL', 'specials.php' => 'NONSSL', 'ssl_check.php' => 'NONSSL', 'tell_a_friend.php' => 'SSL');
Define('InvalidStartDate', 1142);
Define('InvalidCostIssued', 1143);
Define('InvalidQuantityRequired', 1144);
Define('InvalidQuantityReceived', 1145);
Define('InvalidStandardCost', 1146);
Define('IncorrectSerialNumber', 1147);
Define('WorkOrderDoesntExist', 1148);
Define('InvalidIssuedQuantity', 1149);
Define('InvalidTransactionDate', 1150);
Define('InvalidReceivedQuantity', 1151);
Define('ItemNotControlled', 1152);
Define('ItemSerialised', 1153);
Define('BatchNumberDoesntExist', 1154);
Define('BatchIsEmpty', 1155);
Define('NoSuchArea', 1156);
Define('NoSuchSalesMan', 1157);
/* Array of Descriptions of errors */
$ErrorDescription['1'] = _('No Authorisation');
$ErrorDescription['1000'] = _('Incorrect Debtor Number Length');
$ErrorDescription['1001'] = _('Debtor No Already Exists');
$ErrorDescription['1002'] = _('Incorrect Debtor Name Length');
$ErrorDescription['1003'] = _('Invalid Address Line');
$ErrorDescription['1004'] = _('Currency Code Not Setup');
$ErrorDescription['1005'] = _('Sales Type Not Setup');
$ErrorDescription['1006'] = _('Invalid Client Since Date');
$ErrorDescription['1007'] = _('Hold Reason Not Setup');
$ErrorDescription['1008'] = _('Payment Terms Not Setup');
$ErrorDescription['1009'] = _('Invalid Discount');
$ErrorDescription['1010'] = _('Invalid Payment Discount');
$ErrorDescription['1011'] = _('Invalid Last Paid');
$ErrorDescription['1012'] = _('Invalid Last Paid Date');
* @since 20-Jan-2004
* @version 2.4
*/
/**
* Used for building query string
*/
Define("PARAMS_DELIMITER", "pz_");
/**
* Used for building query string
*/
Define("STRING_DELIMITER", "sz_");
/**
* Used for building query string
*/
Define("EQ_DELIMITER", "qz_");
/**
* Framework Module Class
*
* Used by all modules to work correctly in project framework
*
* @package framework
* @author Serge Dzheigalo
* @copyright http://www.activeunit.com/ (c) 2002
* @version 1.0b
*/
class module {
/**
* @var string module name
*/
<?php
/**
* ����������
*
* Saverestore
*
* @package MajorDoMo
* @author Serge Dzheigalo <*****@*****.**> http://smartliving.ru/
* @version 0.6 (2010-08-30) WINDOWS ONLY!
*/
//
//
Define('UPDATER_URL', 'http://updates.au78.com/updates/');
class saverestore extends module
{
/**
* saverestore
*
* Module class constructor
*
* @access private
*/
function saverestore()
{
$this->name = "saverestore";
$this->title = "<#LANG_MODULE_SAVERESTORE#>";
$this->module_category = "<#LANG_SECTION_SYSTEM#>";
$this->checkInstalled();
}
/**
<?php
/**
* Main project script
*
* @package MajorDoMo
* @author Serge Dzheigalo <*****@*****.**> http://smartliving.ru/
* @version 1.1
*/
Define('BTRACED', 1);
// Get the received data from the iPhone (XML data)
$body = @file_get_contents('php://input');
// Try to load the XML
$xml = simplexml_load_string($body);
// If there was an error report it...
if ($xml == false) {
// Error loading XML..., send it back to the iPhone
echo '{ "id":902, "error":true, "message":"Cant load XML", "valid":true }';
exit;
} else {
// Get username and password
$username = $xml->username;
$password = $xml->password;
// Optional: You can check the username and password against your database
// Uncomment for hardcoded testing
// if (($username != 'user') && ($password != 'test'))
// {
// echo '{ "id":1, "error":true, "valid":true }';
// exit();
// }
// Get device identification
<?Define("TEMPORARY_CACHE", "ARtvewYHb2MMdggebRtkG24A");?>
//
// serendipity_plugin_freetag.php
//
@define('PLUGIN_FREETAG_NAME', 'エントリータグの表示');
@define('PLUGIN_FREETAG_BLAHBLAH', 'エントリーの既存タグの一覧を表示します。');
@define('PLUGIN_FREETAG_NEWLINE', '各タグの後に改行を入れますか?');
@define('PLUGIN_FREETAG_XML', 'XML アイコンを表示しますか?');
@define('PLUGIN_FREETAG_SCALE', '(Technorati、flickr のように)タグのフォントサイズを人気度に依存して変化させますか?');
@define('PLUGIN_FREETAG_UPGRADE1_2', 'エントリー番号の %d 個のタグをアップグレード中: %d');
@define('PLUGIN_FREETAG_MAX_TAGS', 'いくつのタグを表示するべきですか?');
@define('PLUGIN_FREETAG_TRESHOLD_TAG_COUNT', 'How many occurences must a tag have in order to be shown?');
@define('PLUGIN_EVENT_FREETAG_TAGCLOUD_MIN', 'タグ クラウドの最小フォントサイズ(単位:パーセント)');
@define('PLUGIN_EVENT_FREETAG_TAGCLOUD_MAX', 'タグ クラウドの最大フォントサイズ(単位:パーセント)');
@define('PLUGIN_EVENT_FREETAG_USE_FLASH', 'タグ クラウドの表示に Flash を使いますか?');
@define('PLUGIN_EVENT_FREETAG_FLASH_TAG_COLOR', 'Flash タグの色 (rrggbb)');
@Define('PLUGIN_EVENT_FREETAG_FLASH_TRANSPARENT', 'Flash タグ クラウドの背景色を透過にしますか?');
@define('PLUGIN_EVENT_FREETAG_FLASH_BG_COLOR', 'Flash タグ クラウドの背景色 (rrggbb)');
@define('PLUGIN_EVENT_FREETAG_FLASH_WIDTH', 'Flash タグ クラウドの幅');
@define('PLUGIN_EVENT_FREETAG_FLASH_SPEED', 'Flash タグ クラウドのモーション速度');
@define('PLUGIN_FREETAG_META_KEYWORDS', 'HTML ソースに埋め込む meta keywords の数 (0: 無効)');
@define('PLUGIN_EVENT_FREETAG_RELATED_ENTRIES', 'タグに関連するエントリー一覧:');
@define('PLUGIN_EVENT_FREETAG_SHOW_RELATED', 'タグによる関連エントリーを表示しますか?');
@define('PLUGIN_EVENT_FREETAG_SHOW_RELATED_COUNT', '関連エントリーをいくつ表示しますか?');
@define('PLUGIN_EVENT_FREETAG_EMBED_FOOTER', 'フッターでタグを表示しますか?');
@define('PLUGIN_EVENT_FREETAG_EMBED_FOOTER_DESC', 'If enabled, the tags will be shown in the footer of an entry. If disabled, the tags will be put inside the body/extended part of your entries.');
@define('PLUGIN_EVENT_FREETAG_LOWERCASE_TAGS', '半角英字は小英字(ABC ではなく abc)に');
@define('PLUGIN_EVENT_FREETAG_RELATED_TAGS', '関連タグ');
@define('PLUGIN_EVENT_FREETAG_TAGLINK', 'タグ リンク');
@define('PLUGIN_EVENT_FREETAG_CAT2TAG', 'すべてのカテゴリーに関連するタグを作成しますか?');
@define('PLUGIN_EVENT_FREETAG_CAT2TAG_DESC', 'If enabled, all categories that an entry is assigned to will be added as tags to your entry. You can set all category associations of all your existing entries within the "Manage Tags" menu of your Administration Suite.');
@define('PLUGIN_EVENT_FREETAG_TEMPLATE', 'サイドバーテンプレート');
var $files = [];
var $role_name;
var $role_description;
var $assignment_id;
var $priv_level = 1;
var $roles = [];
var $members = [];
}
$res = new UserInfo();
$_POST = json_decode(file_get_contents("php://input"), true);
if (isset($_SESSION['course_id'])) {
include "advanced_user_oo.php";
Define('DATABASE_SERVER', $hostname);
Define('DATABASE_USERNAME', $username);
Define('DATABASE_PASSWORD', $password);
Define('DATABASE_NAME', 'assignment_router');
$mysqli = new mysqli(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME);
$res->priv_level = $_SESSION['priv_level'];
$res->roles = $_SESSION['roles'];
$course_id = $_SESSION['course_id'];
$res->course_id = $course_id;
if (isset($_SESSION['msg'])) {
$res->msg = $_SESSION['msg'];
}
if ($_SESSION['priv_level'] == 1) {
$net_id = $_SESSION['net_id'];
$assignment_id = $_SESSION['assignment_id'];
$query = "SELECT m.role_id, r.role_name, r.role_description\n FROM role_members m\n INNER JOIN assignment_roles r\n ON r.role_id=m.role_id AND m.assignment_id=r.assignment_id\n WHERE m.net_id='{$net_id}' AND m.assignment_id='{$assignment_id}'";
$result = $mysqli->query($query);
list($role_id, $role_name, $role_description) = $result->fetch_row();
$res->assignment_id = $assignment_id;
define('LNG_NewsletterStatistics_Snapshot', 'Statistics Snapshot');
define('LNG_NewsletterStatistics_Snapshot_OpenStats', 'Open Statistics');
define('LNG_NewsletterStatistics_Snapshot_LinkStats', 'Link Statistics');
define('LNG_NewsletterStatistics_Snapshot_UnsubscribeStats', 'Unsubscribe Statistics');
define('LNG_NewsletterStatistics_Snapshot_ForwardStats', 'Forwarding Statistics');
define('LNG_NewsletterStatistics_Snapshot_Heading', 'Statistics Snapshot');
define('LNG_NewsletterStatistics_StartSending', 'Start Sending');
define('LNG_NewsletterStatistics_FinishSending', 'Finished Sending');
define('LNG_NewsletterStatistics_SendingTime', 'Sending Time');
define('LNG_NewsletterStatistics_SentTo', 'Sent To');
define('LNG_NewsletterStatistics_SentBy', 'Sent By');
define('LNG_NewsletterStatistics_Opened', 'Opened');
define('LNG_NotFinishedSending', 'Not finished sending');
define('LNG_NewsletterStatistics_Snapshot_SendSize', '%s of %s');
Define('LNG_EmailOpens_Unique', '%s Unique Opens');
Define('LNG_EmailOpens_Total', '%s Total Opens');
define('LNG_PreviewThisNewsletter', 'Preview this email campaign');
define('LNG_DateOpened', 'Date Opened');
define('LNG_NewsletterStatistics_Snapshot_OpenHeading', 'View open rates and email addresses for email campaign \'%s\', sent %s');
define('LNG_NewsletterStatistics_Snapshot_OpenHeading_Unique', 'View <b>unique</b> open rates and email addresses for email campaign \'%s\', sent %s');
define('LNG_NewsletterHasNotBeenOpened', 'This email campaign has not yet been opened by any recipients.');
define('LNG_NewsletterHasNotBeenOpened_CalendarProblem', 'This email campaign has not yet been opened by any recipients during the selected date range.');
define('LNG_NewsletterStatistics_Snapshot_LinkHeading', 'View link click statistics for email campaign \'%s\', sent %s');
define('LNG_NewsletterWasNotOpenTracked', 'Open tracking has been disabled for this email campaign.');
define('LNG_NewsletterHasNotBeenClicked_NoLinksFound', 'No links were found in this email campaign.');
define('LNG_NewsletterWasNotTracked_Links', 'Link tracking has been disabled for this email campaign.');
define('LNG_NewsletterStatistics_Snapshot_UnsubscribesHeading', 'View unsubscribe rates and email addresses for newsletter \'%s\', sent %s');
define('LNG_NewsletterHasNoUnsubscribes', 'This email campaign has not yet received any unsubscribe requests.');
define('LNG_NewsletterHasNoUnsubscribes_CalendarProblem', 'This email campaign has not yet received any unsubscribe requests during the selected date range.');
define('LNG_NewsletterStatistics_Snapshot_ForwardsHeading', 'View email forwarding details for email campaign \'%s\', sent %s');
define('LNG_NewsletterHasNoForwards', 'This email campaign has not yet been forwarded or did not include a send-to-friend link.');
{
var $login_error = "NONE";
var $fields = [];
var $values = [];
var $assignment_id;
var $priv_level = 1;
var $students = [];
}
$res = new UserInfo();
$_POST = json_decode(file_get_contents("php://input"), true);
if (isset($_SESSION['assignment_id'])) {
include "advanced_user_oo.php";
Define('DATABASE_SERVER', $hostname);
Define('DATABASE_USERNAME', $username);
Define('DATABASE_PASSWORD', $password);
Define('DATABASE_NAME', 'individualizer');
$mysqli = new mysqli(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME);
$assignment_id = $_SESSION['assignment_id'];
$res->priv_level = $_SESSION['priv_level'];
$res->assignment_id = $assignment_id;
$query = "SELECT field_1, field_2, field_3, field_4, field_5, field_6\n FROM fields\n WHERE assignment_id='{$assignment_id}'";
$result = $mysqli->query($query);
$json = array();
while ($row = $result->fetch_assoc()) {
$json[] = $row;
}
$res->fields = $json;
if ($res->priv_level == 1) {
$net_id = $_SESSION['net_id'];
$query = "SELECT field_1, field_2, field_3, field_4, field_5, field_6\n FROM students\n WHERE net_id='{$net_id}' AND assignment_id='{$assignment_id}'";
$result = $mysqli->query($query);
<?php
Define("smsConfFile", "{$settings['moduleAddress']}/{$sysVar['op']}/config/config");
$config = smsConfFile . ".php";
if (file_exists($config)) {
require_once $config;
/* Model */
$subSystem = $settings[moduleAddress] . "/" . $settings[moduleName] . "/" . $settings[modelAddress] . "/" . $settings[moduleName] . $settings[ext2];
if (file_exists($subSystem)) {
require_once $subSystem;
$m_sms = new m_sms();
$system->run($subSystem, 'On');
} else {
$system->run($subSystem, 'Off');
}
/* Controller */
$subSystem = $settings[moduleAddress] . "/" . $settings[moduleName] . "/" . $settings[moduleController] . "/" . $settings[moduleName] . $settings[ext2];
if (file_exists($subSystem)) {
require_once $subSystem;
$c_sms = new c_sms();
$system->run($subSystem, 'On');
} else {
$system->run($subSystem, 'Off');
}
} else {
die("SMS sub system is down !");
}
Define('WATERMARK_TEXT_FONT', '1');
// font size of water mark 1 / 2 / 3 / 4 / 5
Define('TEXT_SHADOW', '0');
// Showing a shadow with water mark text 1 - yes / 0 - no
Define('TEXT_COLOR', '#000000');
// water mark text colour
Define('WATERMARK_ALIGN_H', 'right');
// water mark horizontal alignment left / right / center
Define('WATERMARK_ALIGN_V', 'bottom');
//water mark vertical alignment top / bottom / center
Define('WATERMARK_MARGIN', 10);
// water mark margin
Define('WATERMARK_TEXT', '');
// text displayed on uploaded pics
Define('DEFAULT_IMAGE', 'file:dimg.jpg');
Define('SITE_URL', 'http://localhost:8888/');
// paths
define("FULL_PATH", 'YOUR FULL PATH');
// physical full path for site
define("ROOT_PATH", 'YOUR ROOT PATH');
// physical root path for site
define("PEAR_DIR", FULL_PATH . 'extlibs/Pear/');
// path of pear directory
define("CACHE_DIR", FULL_PATH . 'cache/');
//path of cache directory
define("LOG_PATH", ROOT_PATH . 'zidisha_contents/logs/');
// physical root path for site
define("DOCUMENT_DIR", ROOT_PATH . 'zidisha_contents/documents/');
// borrower document directory
define('TMP_IMAGE_DIR', FULL_PATH . 'images/tmp/');
// tmp image directory
var $login_error = "NONE";
var $profiles = [];
var $connections = [];
var $summaries = [];
var $net_id;
var $full_name;
var $priv_level = 1;
}
$res = new UserInfo();
$_POST = json_decode(file_get_contents("php://input"), true);
if (isset($_SESSION['net_id'])) {
include "advanced_user_oo.php";
Define('DATABASE_SERVER', $hostname);
Define('DATABASE_USERNAME', $username);
Define('DATABASE_PASSWORD', $password);
Define('DATABASE_NAME', 'network_analyzer');
$mysqli = new mysqli(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME);
$net_id = $_SESSION['net_id'];
$res->net_id = $net_id;
$res->full_name = $_SESSION['full_name'];
$res->priv_level = $_SESSION['priv_level'];
$query = "SELECT user_name FROM summaries WHERE net_id='{$net_id}'; ";
$result = $mysqli->query($query);
list($user) = $result->fetch_row();
if (empty($user)) {
$course_id = $_SESSION['canvas_course_id'];
$query = "INSERT INTO summaries (net_id, user_name, course_id) VALUES\n ('{$net_id}','{$res->full_name}', '{$course_id}'); ";
$mysqli->query($query);
}
$query = "SELECT * FROM profiles WHERE net_id='{$net_id}' ORDER BY full_name; ";
$query .= "SELECT * FROM connections WHERE net_id='{$net_id}' ORDER BY profile_id1, profile_id2; ";
<?
/**
* Layouts
*
* Layouts
*
* @package MajorDoMo
* @author Serge Dzheigalo <*****@*****.**> http://smartliving.ru/
* @version 0.2 (wizard, 18:09:58 [Sep 10, 2010])
*/
Define('DEF_TYPE_OPTIONS', 'html=HTML Code|app=Application|url=URL'); // options for 'TYPE' //page=Page|
//
//
class layouts extends module {
/**
* layouts
*
* Module class constructor
*
* @access private
*/
function layouts() {
$this->name="layouts";
$this->title="Layouts";
$this->module_category="CMS";
$this->checkInstalled();
}
/**
* saveParams
*
* Saving module parameters
<?php
session_start();
$_POST = json_decode(file_get_contents("php://input"), true);
if (isset($_SESSION['course_id'])) {
include "advanced_user_oo.php";
Define('DATABASE_SERVER', $hostname);
Define('DATABASE_USERNAME', $username);
Define('DATABASE_PASSWORD', $password);
Define('DATABASE_NAME', 'submission_viewer');
$mysqli = new mysqli(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME);
$inserts = $_POST['inserts'];
$query = "INSERT IGNORE INTO course_sections\n (canvas_course_id, section_num, section_id)\n VALUES " . $inserts;
$result = $mysqli->query($query);
$mysqli->close();
echo json_encode($result);
}
if (!CModule::IncludeModule("currency")) {
// trigger_error("Currency is not installed");
return false;
}
// Number of processed recurring records at one time
Define("SALE_PROC_REC_NUM", 3);
// Number of recurring payment attempts
Define("SALE_PROC_REC_ATTEMPTS", 3);
// Time between recurring payment attempts (in seconds)
Define("SALE_PROC_REC_TIME", 43200);
Define("SALE_PROC_REC_FREQUENCY", 7200);
// Owner ID base name used by CSale<etnity_name>ReportHelper clases for managing the reports.
Define("SALE_REPORT_OWNER_ID", 'sale');
global $SALE_TIME_PERIOD_TYPES;
$SALE_TIME_PERIOD_TYPES = array("H" => GetMessage("I_PERIOD_HOUR"), "D" => GetMessage("I_PERIOD_DAY"), "W" => GetMessage("I_PERIOD_WEEK"), "M" => GetMessage("I_PERIOD_MONTH"), "Q" => GetMessage("I_PERIOD_QUART"), "S" => GetMessage("I_PERIOD_SEMIYEAR"), "Y" => GetMessage("I_PERIOD_YEAR"));
Define("SALE_VALUE_PRECISION", 2);
define('BX_SALE_MENU_CATALOG_CLEAR', 'Y');
$GLOBALS["AVAILABLE_ORDER_FIELDS"] = array("ID" => array("COLUMN_NAME" => "ID", "NAME" => GetMessage("SI_ORDER_ID"), "SELECT" => "ID,DATE_INSERT", "CUSTOM" => "Y", "SORT" => "ID"), "LID" => array("COLUMN_NAME" => GetMessage("SI_SITE"), "NAME" => GetMessage("SI_SITE"), "SELECT" => "LID", "CUSTOM" => "N", "SORT" => "LID"), "PERSON_TYPE" => array("COLUMN_NAME" => GetMessage("SI_PAYER_TYPE"), "NAME" => GetMessage("SI_PAYER_TYPE"), "SELECT" => "PERSON_TYPE_ID", "CUSTOM" => "Y", "SORT" => "PERSON_TYPE_ID"), "PAYED" => array("COLUMN_NAME" => GetMessage("SI_PAID"), "NAME" => GetMessage("SI_PAID_ORDER"), "SELECT" => "PAYED,DATE_PAYED,EMP_PAYED_ID", "CUSTOM" => "Y", "SORT" => "PAYED"), "PAY_VOUCHER_NUM" => array("COLUMN_NAME" => GetMessage("SI_NO_PP"), "NAME" => GetMessage("SI_NO_PP_DOC"), "SELECT" => "PAY_VOUCHER_NUM", "CUSTOM" => "N", "SORT" => "PAY_VOUCHER_NUM"), "PAY_VOUCHER_DATE" => array("COLUMN_NAME" => GetMessage("SI_DATE_PP"), "NAME" => GetMessage("SI_DATE_PP_DOC"), "SELECT" => "PAY_VOUCHER_DATE", "CUSTOM" => "N", "SORT" => "PAY_VOUCHER_DATE"), "DELIVERY_DOC_NUM" => array("COLUMN_NAME" => GetMessage("SI_DATE_PP_DELIVERY_DOC_NUM"), "NAME" => GetMessage("SI_DATE_PP_DOC_DELIVERY_DOC_NUM"), "SELECT" => "DELIVERY_DOC_NUM", "CUSTOM" => "N", "SORT" => "DELIVERY_DOC_NUM"), "DELIVERY_DOC_DATE" => array("COLUMN_NAME" => GetMessage("SI_DATE_PP_DELIVERY_DOC_DATE"), "NAME" => GetMessage("SI_DATE_PP_DOC_DELIVERY_DOC_DATE"), "SELECT" => "DELIVERY_DOC_DATE", "CUSTOM" => "N", "SORT" => "DELIVERY_DOC_DATE"), "PAYED" => array("COLUMN_NAME" => GetMessage("SI_PAID"), "NAME" => GetMessage("SI_PAID_ORDER"), "SELECT" => "PAYED,DATE_PAYED,EMP_PAYED_ID", "CUSTOM" => "Y", "SORT" => "PAYED"), "CANCELED" => array("COLUMN_NAME" => GetMessage("SI_CANCELED"), "NAME" => GetMessage("SI_CANCELED_ORD"), "SELECT" => "CANCELED,DATE_CANCELED,EMP_CANCELED_ID", "CUSTOM" => "Y", "SORT" => "CANCELED"), "STATUS" => array("COLUMN_NAME" => GetMessage("SI_STATUS"), "NAME" => GetMessage("SI_STATUS_ORD"), "SELECT" => "STATUS_ID,DATE_STATUS,EMP_STATUS_ID", "CUSTOM" => "Y", "SORT" => "STATUS_ID"), "PRICE_DELIVERY" => array("COLUMN_NAME" => GetMessage("SI_DELIVERY"), "NAME" => GetMessage("SI_DELIVERY"), "SELECT" => "PRICE_DELIVERY,CURRENCY", "CUSTOM" => "Y", "SORT" => "PRICE_DELIVERY"), "ALLOW_DELIVERY" => array("COLUMN_NAME" => GetMessage("SI_ALLOW_DELIVERY"), "NAME" => GetMessage("SI_ALLOW_DELIVERY1"), "SELECT" => "ALLOW_DELIVERY,DATE_ALLOW_DELIVERY,EMP_ALLOW_DELIVERY_ID", "CUSTOM" => "Y", "SORT" => "ALLOW_DELIVERY"), "PRICE" => array("COLUMN_NAME" => GetMessage("SI_SUM"), "NAME" => GetMessage("SI_SUM_ORD"), "SELECT" => "PRICE,CURRENCY", "CUSTOM" => "Y", "SORT" => "PRICE"), "SUM_PAID" => array("COLUMN_NAME" => GetMessage("SI_SUM_PAID"), "NAME" => GetMessage("SI_SUM_PAID1"), "SELECT" => "SUM_PAID,CURRENCY", "CUSTOM" => "Y", "SORT" => "SUM_PAID"), "USER" => array("COLUMN_NAME" => GetMessage("SI_BUYER"), "NAME" => GetMessage("SI_BUYER"), "SELECT" => "USER_ID", "CUSTOM" => "Y", "SORT" => "USER_ID"), "PAY_SYSTEM" => array("COLUMN_NAME" => GetMessage("SI_PAY_SYS"), "NAME" => GetMessage("SI_PAY_SYS"), "SELECT" => "PAY_SYSTEM_ID", "CUSTOM" => "Y", "SORT" => "PAY_SYSTEM_ID"), "DELIVERY" => array("COLUMN_NAME" => GetMessage("SI_DELIVERY_SYS"), "NAME" => GetMessage("SI_DELIVERY_SYS"), "SELECT" => "DELIVERY_ID", "CUSTOM" => "Y", "SORT" => "DELIVERY_ID"), "DATE_UPDATE" => array("COLUMN_NAME" => GetMessage("SI_DATE_UPDATE"), "NAME" => GetMessage("SI_DATE_UPDATE"), "SELECT" => "DATE_UPDATE", "CUSTOM" => "N", "SORT" => "DATE_UPDATE"), "PS_STATUS" => array("COLUMN_NAME" => GetMessage("SI_PAYMENT_PS"), "NAME" => GetMessage("SI_PS_STATUS"), "SELECT" => "PS_STATUS,PS_RESPONSE_DATE", "CUSTOM" => "N", "SORT" => "PS_STATUS"), "PS_SUM" => array("COLUMN_NAME" => GetMessage("SI_PS_SUM"), "NAME" => GetMessage("SI_PS_SUM1"), "SELECT" => "PS_SUM,PS_CURRENCY", "CUSTOM" => "Y", "SORT" => "PS_SUM"), "TAX_VALUE" => array("COLUMN_NAME" => GetMessage("SI_TAX"), "NAME" => GetMessage("SI_TAX_SUM"), "SELECT" => "TAX_VALUE,CURRENCY", "CUSTOM" => "Y", "SORT" => "TAX_VALUE"), "BASKET" => array("COLUMN_NAME" => GetMessage("SI_ITEMS"), "NAME" => GetMessage("SI_ITEMS_ORD"), "SELECT" => "", "CUSTOM" => "Y", "SORT" => ""));
CModule::AddAutoloadClasses("sale", array("CSaleDelivery" => $DBType . "/delivery.php", "CSaleDeliveryHandler" => $DBType . "/delivery_handler.php", "CSaleLocation" => $DBType . "/location.php", "CSaleLocationGroup" => $DBType . "/location_group.php", "CSaleBasket" => $DBType . "/basket.php", "CSaleUser" => $DBType . "/basket.php", "CSaleOrder" => $DBType . "/order.php", "CSaleOrderProps" => $DBType . "/order_props.php", "CSaleOrderPropsGroup" => $DBType . "/order_props_group.php", "CSaleOrderPropsValue" => $DBType . "/order_props_values.php", "CSaleOrderPropsVariant" => $DBType . "/order_props_variant.php", "CSaleOrderUserProps" => $DBType . "/order_user_props.php", "CSaleOrderUserPropsValue" => $DBType . "/order_user_props_value.php", "CSaleOrderTax" => $DBType . "/order_tax.php", "CSalePaySystem" => $DBType . "/pay_system.php", "CSalePaySystemAction" => $DBType . "/pay_system_action.php", "CSaleTax" => $DBType . "/tax.php", "CSaleTaxRate" => $DBType . "/tax_rate.php", "CSalePersonType" => $DBType . "/person_type.php", "CSaleDiscount" => $DBType . "/discount.php", "CSaleUserAccount" => $DBType . "/user.php", "CSaleUserTransact" => $DBType . "/user_transact.php", "CSaleUserCards" => $DBType . "/user_cards.php", "CSaleRecurring" => $DBType . "/recurring.php", "CSaleStatus" => $DBType . "/status.php", "CSaleLang" => $DBType . "/settings.php", "CSaleGroupAccessToSite" => $DBType . "/settings.php", "CSaleGroupAccessToFlag" => $DBType . "/settings.php", "CSaleAuxiliary" => $DBType . "/auxiliary.php", "CSaleAffiliate" => $DBType . "/affiliate.php", "CSaleAffiliatePlan" => $DBType . "/affiliate_plan.php", "CSaleAffiliatePlanSection" => $DBType . "/affiliate_plan_section.php", "CSaleAffiliateTier" => $DBType . "/affiliate_tier.php", "CSaleAffiliateTransact" => $DBType . "/affiliate_transact.php", "CSaleExport" => $DBType . "/export.php", "CSaleMeasure" => "general/measurement.php", "CSaleProduct" => $DBType . "/product.php", "CSaleViewedProduct" => $DBType . "/product.php", "CSaleHelper" => "general/helper.php", "CSalePullSchema" => "general/pull_schema.php", "CSaleMobileOrderUtils" => "general/mobile_order.php", "CSaleMobileOrderPull" => "general/mobile_order.php", "CBaseSaleReportHelper" => "general/sale_report_helper.php", "CSaleReportSaleOrderHelper" => "general/sale_report_helper.php", "CSaleReportUserHelper" => "general/sale_report_helper.php", "CSaleReportSaleFuserHelper" => "general/sale_report_helper.php", "IBXSaleProductProvider" => "general/product_provider.php", "CSaleStoreBarcode" => $DBType . "/store_barcode.php", "Bitrix\\Sale\\OrderTable" => "lib/order.php", "Bitrix\\Sale\\BasketTable" => "lib/basket.php", "Bitrix\\Sale\\FuserTable" => "lib/fuser.php", "Bitrix\\Sale\\StatusTable" => "lib/status.php", "Bitrix\\Sale\\PaySystemTable" => "lib/paysystem.php", "Bitrix\\Sale\\DeliveryTable" => "lib/delivery.php", "Bitrix\\Sale\\DeliveryHandlerTable" => "lib/deliveryhandler.php", "Bitrix\\Sale\\PersonTypeTable" => "lib/persontype.php", "\\Bitrix\\Sale\\OrderTable" => "lib/order.php", "\\Bitrix\\Sale\\BasketTable" => "lib/basket.php", "\\Bitrix\\Sale\\FuserTable" => "lib/fuser.php", "\\Bitrix\\Sale\\StatusTable" => "lib/status.php", "\\Bitrix\\Sale\\PaySystemTable" => "lib/paysystem.php", "\\Bitrix\\Sale\\DeliveryTable" => "lib/delivery.php", "\\Bitrix\\Sale\\DeliveryHandlerTable" => "lib/deliveryhandler.php", "\\Bitrix\\Sale\\PersonTypeTable" => "lib/persontype.php", "CSaleReportSaleGoodsHelper" => "general/sale_report_helper.php", "CSaleReportSaleProductHelper" => "general/sale_report_helper.php", "Bitrix\\Sale\\ProductTable" => "lib/product.php", "Bitrix\\Sale\\GoodsSectionTable" => "lib/goodssection.php", "Bitrix\\Sale\\SectionTable" => "lib/section.php", "Bitrix\\Sale\\StoreProductTable" => "lib/storeproduct.php", "\\Bitrix\\Sale\\ProductTable" => "lib/product.php", "\\Bitrix\\Sale\\GoodsSectionTable" => "lib/goodssection.php", "\\Bitrix\\Sale\\SectionTable" => "lib/section.php", "\\Bitrix\\Sale\\StoreProductTable" => "lib/storeproduct.php", "CSaleBasketFilter" => "general/sale_cond.php", "CSaleCondCtrlGroup" => "general/sale_cond.php", "CSaleCondCtrlBasketGroup" => "general/sale_cond.php", "CSaleCondCtrlBasketFields" => "general/sale_cond.php", "CSaleCondCtrlBasketProps" => "general/sale_cond.php", "CSaleCondCtrlBasketProductFields" => "general/sale_cond.php", "CSaleCondCtrlBasketProductProps" => "general/sale_cond.php", "CSaleCondCtrlOrderFields" => "general/sale_cond.php", "CSaleCondCtrlCommon" => "general/sale_cond.php", "CSaleCondTree" => "general/sale_cond.php", "CSaleDiscountActionApply" => "general/sale_act.php", "CSaleActionCtrlGroup" => "general/sale_act.php", "CSaleActionCtrlDelivery" => "general/sale_act.php", "CSaleActionCtrlBasketGroup" => "general/sale_act.php", "CSaleActionCtrlGiftsGroup" => "general/sale_act.php", "CSaleActionCtrlSubGroup" => "general/sale_act.php", "CSaleActionCondCtrlBasketFields" => "general/sale_act.php", "CSaleActionCtrlBasketProductFields" => "general/sale_act.php", "CSaleActionCtrlBasketProductProps" => "general/sale_act.php", "CSaleActionTree" => "general/sale_act.php", "CSaleDiscountConvert" => "general/discount_convert.php"));
function GetBasketListSimple($bSkipFUserInit = False)
{
$fUserID = CSaleBasket::GetBasketUserID($bSkipFUserInit);
if ($fUserID > 0) {
return CSaleBasket::GetList(array("NAME" => "ASC"), array("FUSER_ID" => $fUserID, "LID" => SITE_ID, "ORDER_ID" => "NULL"));
} else {
return False;
}
}
function GetBasketList($bSkipFUserInit = False)
{
$fUserID = CSaleBasket::GetBasketUserID($bSkipFUserInit);
<?php
session_start();
$_POST = json_decode(file_get_contents("php://input"), true);
if (isset($_SESSION['course_id'])) {
include "advanced_user_oo.php";
Define('DATABASE_SERVER', $hostname);
Define('DATABASE_USERNAME', $username);
Define('DATABASE_PASSWORD', $password);
Define('DATABASE_NAME', 'session_logger');
$mysqli = new mysqli(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME);
$course_id = $_SESSION['course_id'];
$settings = $_POST['settings'];
$query = "UPDATE courses SET settings='{$settings}' WHERE course_id='{$course_id}'";
$result = $mysqli->query($query);
$mysqli->close();
echo json_encode($result);
}
include_once("./config.php");
include_once("./lib/loader.php");
startMeasure('TOTAL'); // start calculation of execution time
include_once(DIR_MODULES."application.class.php");
$session=new session("prj");
$db=new mysql(DB_HOST, '', DB_USER, DB_PASSWORD, DB_NAME); // connecting to database
// get settings
$settings = SQLSelect('SELECT NAME, VALUE FROM settings');
$total = count($settings);
for ($i = 0; $i < $total; $i ++)
Define('SETTINGS_' . $settings[$i]['NAME'], $settings[$i]['VALUE']);
// language selection by settings
if (SETTINGS_SITE_LANGUAGE && file_exists(ROOT . 'languages/' . SETTINGS_SITE_LANGUAGE . '.php')) include_once (ROOT . 'languages/' . SETTINGS_SITE_LANGUAGE . '.php');
include_once (ROOT . 'languages/default.php');
if (defined('SETTINGS_SITE_TIMEZONE')) {
ini_set('date.timezone', SETTINGS_SITE_TIMEZONE);
}
$qry="1";
if ($_GET['level']) {
$qry.=" AND shouts.IMPORTANCE>=".(int)$_GET['level'];
}
<?php
Define('DATABASE_SERVER', 'localhost');
Define('DATABASE_USERNAME', 'flext');
Define('DATABASE_PASSWORD', 'p@ssword');
Define('DATABASE_NAME', 'flextest');
// MySQL database I/O PHP class example as a WebORB for PHP service
class dbio_example
{
private $mysqli;
private $err_prefix = "WebORB Remoting Error: 'dbio_example' class database ";
public function __construct()
{
error_reporting(0);
# Silence error messages and return them to WebORB
# Connect to MySQL database....
$this->mysqli = new mysqli(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME);
if (mysqli_connect_errno()) {
$msg = $this->err_prefix . "could not connect: " . mysqli_connect_error();
throw new Exception($msg);
}
}
public function getUsers()
{
# Return a list of all the 'flextest' users
if (!($result = $this->mysqli->query("SELECT * from users ORDER by userid"))) {
$msg = $this->err_prefix . "SELECT query error: " . $this->mysqli->error;
$this->mysqli->close();
throw new Exception($msg);
}
while ($row = $result->fetch_assoc()) {
<?php
session_start();
$_POST = json_decode(file_get_contents("php://input"), true);
if (isset($_SESSION['wiki_id'])) {
include "advanced_user_oo.php";
Define('DATABASE_SERVER', $hostname);
Define('DATABASE_USERNAME', $username);
Define('DATABASE_PASSWORD', $password);
Define('DATABASE_NAME', 'wiki');
class WikiPage
{
var $users = [];
var $posts = [];
var $comments = [];
var $headings = [];
}
$mysqli = new mysqli(DATABASE_SERVER, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME);
$wiki_page = new WikiPage();
$wiki_id = $_SESSION['wiki_id'];
$query = "SELECT u.user_id, u.user_name, u.user_email, u.net_id\n FROM users u\n INNER JOIN wiki_users p\n ON p.user_id=u.user_id\n\t\tWHERE wiki_id='{$wiki_id}'\n GROUP BY u.user_id\n ORDER BY u.user_name; ";
$query .= "SELECT page_id, heading_id, heading_name\n FROM headings\n WHERE wiki_id='{$wiki_id}'\n ORDER BY page_id, heading_id ASC;";
$query .= "SELECT post_id, version, wc, creator_id, heading_id, page_id, edit_date,\n post_txt, prev, u.user_id, u.user_name, (SELECT COUNT(*) FROM likes l WHERE l.post_id=p.post_id) AS likes\n FROM posts p\n INNER JOIN users u\n ON u.user_id=p.creator_id\n WHERE wiki_id='{$wiki_id}'\n ORDER BY page_id, heading_id, prev, post_id, version ASC;";
$query .= "SELECT post_id, comment_id, heading_id, page_id, c.user_id, wc, comment_date, comment_txt, u.user_name as commentor\n FROM comments c\n INNER JOIN users u\n ON u.user_id=c.user_id\n WHERE wiki_id='{$wiki_id}'\n ORDER BY post_id, comment_id ASC;";
$mysqli->multi_query($query);
$mysqli->next_result();
$result = $mysqli->store_result();
$json = array();
while ($row = $result->fetch_assoc()) {
$json[] = $row;
}
