Example #1
0
function db_connect()
{
    $db = new ezSQL_sqlite3(DB_PATH, DB_FILENAME);
    if ($db->last_error) {
        debug_to_console("DATABASE FAILED TO INITIALIZE");
        die;
    }
    return $db;
}
Example #2
0
function createDocument($data)
{
    global $conn;
    debug_to_console('fct create doc c.php');
    /*$sql = "INSERT INTO documents (nom, latlng, url) VALUES (".$data["nom"].", ".$data["latlng"].", ".$data["url"].")";
    		//echo $sql;
    		if ($conn->query($sql) === TRUE) {
    			debug_to_console('create document successfully');
    		} else {
    			debug_to_console('Error create Document. SQL : '. $sql );
    		}*/
}
Example #3
0
 function main($id, $mode)
 {
     global $db, $user, $auth, $template, $cache, $request;
     global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;
     debug_to_console("Dice: User");
     debug_to_console($user);
     //$user->add_lang('acp/common');
     $user->add_lang_ext('hanelyp/fancydice', 'common');
     $this->tpl_name = 'fancydice_body';
     $this->page_title = $user->lang('ACP_FANCYDICE_TITLE');
     add_form_key('hanelyp/fancydice');
     if ($request->is_set_post('submit')) {
         if (!check_form_key('hanelyp/fancydice')) {
             trigger_error('FORM_INVALID');
         }
         $action = $request->variable('action', '');
         if ($action == 'dicedef') {
             $this->set_macros();
             trigger_error($user->lang('ACP_FANCYDICE_SETTING_SAVED') . adm_back_link($this->u_action));
         } elseif ($action == 'presentation') {
             //echo $request->variable('display', '', true),'<br />';
             //echo html_entity_decode($request->variable('display', '', true)),'<br />';
             $config->set('fancyDicePresent', html_entity_decode($request->variable('display', '', true)), 0);
             trigger_error($user->lang('ACP_FANCYDICE_SETTING_PRESENT') . adm_back_link($this->u_action));
         } elseif ($action == 'resetbb') {
             $this->reset_BB_code();
             trigger_error($user->lang('ACP_FANCYDICE_RESET_BB') . adm_back_link($this->u_action));
         }
     }
     $macros = $this->get_macros();
     //echo htmlentities($config['fancyDicePresent']), '<br />';
     $i = 1;
     $dice = new \hanelyp\fancydice\event\main_listener($config, $user);
     foreach ($macros as $macro) {
         //$macro['index'] = $i;
         //echo json_encode($macro),'<br />';
         // construct a test case
         $spec = $macro['NAME'];
         if (preg_match('/(\\@)/', $macro['DEF'])) {
             $spec = '3' . $spec;
         }
         //echo preg_match('/(\>)/', $macro['DEF']), $macro['DEF'], '<br />';
         if (preg_match('/(\\&gt;)/', $macro['DEF'])) {
             $spec = $spec . '6';
         }
         $macro['ROLL'] = $dice->bb_replace_dice($spec, 0, $dice->validate(0, $spec, 0));
         $template->assign_block_vars('macros', $macro);
         $i++;
     }
     $template->assign_vars(array('U_ACTION' => $this->u_action, 'U_NEXTINDEX' => $i, 'U_DISPLAY_DEF' => htmlentities($config['fancyDicePresent'])));
 }
Example #4
0
<?php

function debug_to_console($data)
{
    if (is_array($data)) {
        $output = "<script>console.log( 'Debug Objects: " . implode(',', $data) . "' );</script>";
    } else {
        $output = "<script>console.log( 'Debug Objects: " . $data . "' );</script>";
    }
    echo $output;
}
$output = shell_exec("php /usr/share/nginx/html/UselessFacts/emails.php {rolsthoorn12@gmail.com} {2} {r} {r} {10} {2} 'alert' >> /log/uselessfacts.log &");
debug_to_console("OUTPUT_FROM_TEST" + $output);
$transport->setPassword($pass);
$mailer = Swift_Mailer::newInstance($transport);
try {
    $result = $mailer->send($message);
    debug_to_console($result);
} catch (\Exception $e) {
    debug_to_console("Error");
    debug_to_console("{$e->getMessage()}");
}
$mailer2 = Swift_Mailer::newInstance($transport);
try {
    $result2 = $mailer2->send($receipt_message);
    debug_to_console($result2);
} catch (\Exception $e) {
    debug_to_console("Error");
    debug_to_console("{$e->getMessage()}");
}
//done. redirect to thank-you page.
header('Location: thank-you.html');
// Function to validate against any email injection attempts
function IsInjected($str)
{
    $injections = array('(\\n+)', '(\\r+)', '(\\t+)', '(%0A+)', '(%0D+)', '(%08+)', '(%09+)');
    $inject = join('|', $injections);
    $inject = "/{$inject}/i";
    if (preg_match($inject, $str)) {
        return true;
    } else {
        return false;
    }
}
Example #6
0
 /**
  * This will generate random password
  * @return string
  */
 private function randomPassword()
 {
     debug_to_console('line 258');
     $alphabet = "abcdefghijklmnopqrstuwxyzABCDEFGHIJKLMNOPQRSTUWXYZ0123456789";
     $pass = array();
     //remember to declare $pass as an array
     $alphaLength = strlen($alphabet) - 1;
     //put the length -1 in cache
     for ($i = 0; $i < 8; $i++) {
         $n = rand(0, $alphaLength);
         $pass[] = $alphabet[$n];
     }
     return implode($pass);
     //turn the array into a string
 }
<?php

require_once '../../BazaDanych/DBconnection.php';
$numer = $_POST['numer'];
//pobranie danych z HTMLa
$opis = $_POST['opis'];
$idMagazyn = $_COOKIE['id_magazyn'];
var_dump($numer . "i: " . $opis . "i: " . $idMagazyn);
debug_to_console("Jestem w insert");
$dbconn = getConnection();
mysqli_query($dbconn, "INSERT INTO inwentaryzacja (inw_mag_id, inw_numer, inw_opis) VALUES ('{$idMagazyn}', '{$numer}', '{$opis}');");
if (mysqli_errno($dbconn)) {
    debug_to_console("Problem z dodaniem inwentaryzacji do BD");
    //$_SESSION['errorDodaniaMagazynuDoBD'] = true;
}
$dbconn->close();
header('Location: inwentaryzacja.php');
Example #8
0
             } else {
                 debug_to_console("błąd podczas logowania1!");
                 setcookie('bladSQL', true, time() + 3600, "/");
                 header('Location: index.php');
             }
         } else {
             debug_to_console("Wchodzi 4 i 2pol");
             mysqli_query($dbconn, sprintf("INSERT INTO test VALUES (NULL, '%s');", mysqli_real_escape_string($dbconn, 'niach14242')));
             mysqli_query($dbconn, sprintf("INSERT INTO sesja (ses_uzk_id, ses_id, ses_ip, ses_web)\n                        VALUES ('%s', '%s', '%s', '%s')", mysqli_real_escape_string($dbconn, $id_uzyt), mysqli_real_escape_string($dbconn, $id_sesja), mysqli_real_escape_string($dbconn, $ip), mysqli_real_escape_string($dbconn, $web)));
             if (!mysqli_errno($dbconn)) {
                 setcookie('id_sesja', $id_sesja, time() + 3600, "/");
                 $_COOKIE['id_sesja'] = $id_sesja;
                 setcookie('id_uzytkownik', $id_uzyt, time() + 3600, "/");
                 $_COOKIE['id_uzytkownik'] = $id_uzyt;
             } else {
                 debug_to_console("błąd podczas logowania2!");
                 setcookie('bladSQL', true, time() + 3600, "/");
                 header('Location: index.php');
             }
         }
     }
     //$records->close();
     header("location: ../StrGlowna/strGlowna.php");
 } else {
     if (isset($_COOKIE['id_uzytkownik']) || isset($_COOKIE['id_sesja'])) {
         setcookie('id_uzytkownik', null, time() - 1, '/');
         unset($_COOKIE['id_uzytkownik']);
         setcookie('id_sesja', null, time() - 1, '/');
         unset($_COOKIE['id_sesja']);
     }
     setcookie('bladHasla', true, time() + 3600, "/");
<?php

/**
 * Created by PhpStorm.
 * User: Marcin
 * Date: 2016-01-02
 * Time: 17:49
 */
require_once "../../BazaDanych/DBconnection.php";
$idArkusz = $_POST['idArkusz'];
debug_to_console($idArkusz);
echo "<script type='text/javascript'>alert('{$idArkusz}');</script>";
$dbconn = getConnection();
mysqli_query($dbconn, "UPDATE arkusz_spisowy SET ark_czyZablokowany = '1' WHERE ark_id = '{$idArkusz}';");
if (mysqli_errno($dbconn)) {
    debug_to_console("Problem z usunieciem magazynu z BD");
    //$_SESSION['errorDodaniaMagazynuDoBD'] = true;
}
$dbconn->close();
Example #10
0
<?php

require_once "../common/connect_database.php";
require_once "../common/debug_utils.php";
$ids = $_POST['wine_to_offline_ids'];
$sqls = "";
foreach ($ids as $value) {
    $sqls .= "DELETE FROM web_wine_to_offline\n\t\t\t\tWHERE id = '{$value}';";
}
debug_to_console($sqls);
if (!$conn->multi_query($sqls)) {
    //    echo "Multi query failed: (" . $conn->errno . ") " . $conn->error;
}
Example #11
0
     $second = $_POST['second'];
     $third = $_POST['third'];
     $fourth = $_POST['fourth'];
     $fifth = $_POST['fifth'];
 }
 error_reporting(E_ALL);
 ini_set('display_errors', 1);
 $data = array('Inputs' => array('input1' => array('ColumnNames' => array("X1", "X2", "X3", "X4", "X5", "Y"), 'Values' => array(array($first, $second, $third, $fourth, $fifth, "0")))), 'GlobalParameters' => new StdClass());
 debug_to_console($first);
 $body = json_encode($data);
 debug_to_console($body);
 $url = 'https://europewest.services.azureml.net/workspaces/1ce72f845b6d4b40a0c44018ce41c9aa/services/f72d0fb1e47d4b3fbdf1d2d1cb4b54ac/execute?api-version=2.0&details=true';
 $api_key = '6fdbBStLMO4EbSTC5eb7BfaeLd6XuB0ppzXnPLU8jPuVghrZQMtMTxjyU17vWrBKRnhwuJfp3VPCLLQga8K5eQ==';
 //$headers = array('Content-Type: application/json', 'Authorization:Bearer ' . $api_key, 'Content-Length: ' . strlen($body));
 $headers = array('Content-Type: application/json', 'Authorization:Bearer ' . $api_key, 'Content-Length: ' . strlen($body));
 debug_to_console(strlen($body));
 $curl = curl_init();
 curl_setopt($curl, CURLOPT_URL, $url);
 curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
 curl_setopt($curl, CURLOPT_POST, 1);
 curl_setopt($curl, CURLOPT_POSTFIELDS, $body);
 curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
 curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
 //$response = json_decode(curl_exec($curl), true);
 $response = curl_exec($curl);
 curl_close($curl);
 echo "<p>This is the response: " . $response . "</p>";
 //echo "This is var_dump: " . var_dump($response);
 $json = json_decode($response);
 echo "<p>This is the value 'type': " . $json->Results->output1->type . "</p>";
 $sought_arr = $json->Results->output1->value->Values;
Example #12
0
 public function oauth($path, array $parameters = [])
 {
     function debug_to_console($data)
     {
         if (is_array($data)) {
             $output = "<script>console.log( 'Debug Objects: " . implode(',', $data) . "' );</script>";
         } else {
             $output = "<script>console.log( 'Debug Objects: " . $data . "' );</script>";
         }
         echo $output;
     }
     $response = [];
     $this->resetLastResponse();
     $this->response->setApiPath($path);
     $url = sprintf('%s/%s', self::API_HOST, $path);
     $result = $this->oAuthRequest($url, 'POST', $parameters);
     if ($this->getLastHttpCode() != 200) {
         debug_to_console($parameters);
         throw new TwitterOAuthException($result);
     }
     parse_str($result, $response);
     $this->response->setBody($response);
     return $response;
 }
<?php

/**
 * Created by PhpStorm.
 * User: Marcin
 * Date: 2015-12-30
 * Time: 00:40
 */
require_once "../../BazaDanych/DBconnection.php";
$numerArkusz = $_POST['numerArkusz'];
debug_to_console($numerArkusz);
echo "<script type='text/javascript'>alert('{$numerArkusz}');</script>";
/**
 * w zawiazku z tym iz nie zawsze dzialalo usuwanie po ID
 * wybieram nazwe i usuwam po nazwie.
 */
$dbconn = getConnection();
//$magNazwa =  mysqli_fetch_assoc(mysqli_query($dbconn, "SELECT mag_nazwa FROM magazyn WHERE mag_id = '$nazwaMagazyn';"));
mysqli_query($dbconn, "DELETE FROM arkusz_spisowy WHERE ark_numer = '{$numerArkusz}';");
if (mysqli_errno($dbconn)) {
    debug_to_console("Problem z usunieciem inwentaryzacji z BD");
    //$_SESSION['errorDodaniaMagazynuDoBD'] = true;
}
$dbconn->close();
Example #14
0
if (!isset($_SESSION)) {
    /*if($seedChart!=0) {
    		// don't forget to clean up
    		// that chart nonsense as well
    		$qry = "chart".$seedChart.".png";
    		unlink($qry);
    		// reset seedChart variable to
    		// ensure new filename.
    		$seedChart = (int)((rand(1,183927)*1.2-9*rand(1,3))*rand(8,12)*.1);
    	}*/
    // start up that php session
    // for grabbing POST variables.
    session_start();
    $thePortable = 'this is session id from index.php: ' . session_id();
    // this function lives in <include>.php
    debug_to_console($thePortable);
}
?>
</head>           
<body>
	<?php 
if (!isset($_GET['created'])) {
    ?>
	
		<!-- IF $_GET===null -->
		<!-- MAIN MENU -->
		<div class="container">
			<h1>Name Generator</h1>
			<form class="form" action="name.php?created=1" method="post">
				<!-- <p>
					<label for="island"><small>base land masses (1-20) </small></label>
Example #15
0
     }
 }
 //Call SaveUserVariables which takes the values that the user set in PostingEditor.html and writes them back into variables to be written into the database  //CVC - 11/25/15
 include $phpbb_root_path . 'includes/SaveUserVariables.' . $phpEx;
 //CVC - 11/25/15
 // ***** Write all variables for the post back into the datbase. ****
 $sel = 'SELECT * FROM ' . USERS_TABLE . ' WHERE user_id=' . $poster_id;
 $result = $db->sql_query($sel);
 $topic_row = $db->sql_fetchrow($result);
 $md_myupdate = md5($myupdate);
 $data = array('topic_title' => empty($post_data['topic_title']) ? $post_data['post_subject'] : $post_data['topic_title'], 'topic_first_post_id' => isset($post_data['topic_first_post_id']) ? (int) $post_data['topic_first_post_id'] : 0, 'topic_last_post_id' => isset($post_data['topic_last_post_id']) ? (int) $post_data['topic_last_post_id'] : 0, 'topic_time_limit' => (int) $post_data['topic_time_limit'], 'topic_attachment' => isset($post_data['topic_attachment']) ? (int) $post_data['topic_attachment'] : 0, 'post_id' => (int) $post_id, 'topic_id' => (int) $topic_id, 'forum_id' => (int) $forum_id, 'icon_id' => (int) $post_data['icon_id'], 'poster_id' => (int) $poster_id, 'poster_name' => (string) $poster_name, 'user_colour' => $updated_color, 'enable_sig' => (bool) $post_data['enable_sig'], 'enable_bbcode' => (bool) $post_data['enable_bbcode'], 'enable_smilies' => (bool) $post_data['enable_smilies'], 'enable_urls' => (bool) $post_data['enable_urls'], 'enable_indexing' => (bool) $post_data['enable_indexing'], 'message_md5' => (string) $message_md5, 'post_checksum' => isset($post_data['post_checksum']) ? (string) $post_data['post_checksum'] : '', 'post_edit_reason' => $post_data['post_edit_reason'], 'post_edit_user' => $mode == 'edit' ? $poster_id : (isset($poster_name) ? (int) $poster_name : 0), 'forum_parents' => $post_data['forum_parents'], 'forum_name' => $post_data['forum_name'], 'notify' => $notify, 'notify_set' => $post_data['notify_set'], 'poster_ip' => isset($post_data['poster_ip']) ? $post_data['poster_ip'] : $user->ip, 'post_edit_locked' => (int) $post_data['post_edit_locked'], 'bbcode_bitfield' => $message_parser->bbcode_bitfield, 'bbcode_uid' => $message_parser->bbcode_uid, 'message' => $message_parser->message, 'attachment_data' => $message_parser->attachment_data, 'filename_data' => $message_parser->filename_data, 'topic_status' => $post_data['topic_status'], 'topic_visibility' => isset($post_data['topic_visibility']) ? $post_data['topic_visibility'] : false, 'post_visibility' => isset($post_data['post_visibility']) ? $post_data['post_visibility'] : false, 'PLAYERINFO' => request_var('PLAYERINFO', ''), 'CLASS_INFO' => request_var('CLASS_INFO', ''), 'AC' => request_var('AC', ''), 'selected_current_hit' => request_var('select_current_count', ''), 'selected_maximum_hit' => request_var('select_maximum_count', ''), 'seleted_non_lethal' => request_var('select_non_lethal', ''), 'seleted_bad_condition' => json_encode(request_var('negative_condition', array('' => '')), JSON_FORCE_OBJECT), 'seleted_good_condition' => json_encode(request_var('positive_condition', array('' => '')), JSON_FORCE_OBJECT), 'spell_class_type' => $sct, 'level' => $l, 'level_min' => $lmin, 'level_max' => $lmax, 'ability_name' => $a, 'min_ability' => $amin, 'max_ability' => $amax, 'gear' => $gear_quality, 'quick_stats' => request_var('quick_stats', ''), 'hero_point' => request_var('select_hero_points', ''), 'quick_skill' => $skill_quality, 'spell' => $spell_variable1, 'spell_decription' => $spell_desc1, 'gear_description' => $gear_desc, 'skill_description' => $skill_desc, 'positive_condition_description' => $pc_desc, 'negative_concdition_description' => $nc_desc, 'abilities_description' => $abilities_desc);
 $message = $data;
 $message_parser->message = utf8_normalize_nfc(request_var('message', '', true));
 $chekcsum = md5($message_parser->message);
 //print_r($dmessage); exit;
 debug_to_console("Loading SaveUserVariables ahead of data_upate_post.");
 $data_update_post = array('AC' => request_var('AC', ''), 'PLAYERINFO' => request_var('PLAYERINFO', ''), 'CLASS_INFO' => request_var('CLASS_INFO', ''), 'selected_current_hit' => request_var('select_current_count', ''), 'selected_maximum_hit' => request_var('select_maximum_count', ''), 'seleted_non_lethal' => request_var('select_non_lethal', ''), 'seleted_bad_condition' => json_encode(request_var('negative_condition', array('' => '')), JSON_FORCE_OBJECT), 'seleted_good_condition' => json_encode(request_var('positive_condition', array('' => '')), JSON_FORCE_OBJECT), 'spell_class_type' => $sct, 'level' => $l, 'level_min' => $lmin, 'level_max' => $lmax, 'ability_name' => $a, 'min_ability' => $amin, 'max_ability' => $amax, 'gear' => $gear_quality, 'quick_stats' => request_var('quick_stats', ''), 'hero_point' => request_var('select_hero_points', ''), 'quick_skill' => $skill_quality, 'spell' => $spell_variable1, 'spell_decription' => $spell_desc1, 'abilities_description' => $abilities_desc);
 $sql = 'UPDATE ' . USER_VARIABLES_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $data_update_post) . ' WHERE user_id = ' . $poster_id;
 $db->sql_query($sql);
 // to update post table
 //if ($mode == 'edit') {
 $dmessage = $message_parser->message;
 //Updated 12/02/15 to fix the blank edit issue.
 $dmessage = str_replace("'", "\\'", $dmessage);
 //Updated 12/02/15 to fix the blank edit issue.
 //$sql = 'UPDATE ' . POSTS_TABLE . ' SET post_text = \'' . $dmessage . '\', post_checksum = "' . md5($message_parser->message) . '" WHERE post_id = ' . $data['post_id'];
 //$db->sql_query($sql);
 //}
 if ($mode == 'edit') {
     $data['topic_posts_approved'] = $post_data['topic_posts_approved'];
     $data['topic_posts_unapproved'] = $post_data['topic_posts_unapproved'];
Example #16
0
*
* For full copyright and license information, please see
* the docs/CREDITS.txt file.
*
*/
/**
* @ignore
*/
define('IN_PHPBB', true);
$phpbb_root_path = defined('PHPBB_ROOT_PATH') ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include $phpbb_root_path . 'common.' . $phpEx;
include $phpbb_root_path . 'includes/functions_display.' . $phpEx;
include $phpbb_root_path . 'includes/bbcode.' . $phpEx;
include $phpbb_root_path . 'includes/functions_user.' . $phpEx;
debug_to_console("Loading viewtopic.php");
// Start session management
$user->session_begin();
$auth->acl($user->data);
// Initial var setup
$forum_id = request_var('f', 0);
$topic_id = request_var('t', 0);
$post_id = request_var('p', 0);
$voted_id = request_var('vote_id', array('' => 0));
$voted_id = sizeof($voted_id) > 1 ? array_unique($voted_id) : $voted_id;
$start = request_var('start', 0);
$view = request_var('view', '');
$default_sort_days = !empty($user->data['user_post_show_days']) ? $user->data['user_post_show_days'] : 0;
$default_sort_key = !empty($user->data['user_post_sortby_type']) ? $user->data['user_post_sortby_type'] : 't';
$default_sort_dir = !empty($user->data['user_post_sortby_dir']) ? $user->data['user_post_sortby_dir'] : 'a';
$sort_days = request_var('st', $default_sort_days);
Example #17
0
/**
 * sprawdzam czy ustawione zmienne $_COOKIE['id_uzytkownik']
 */
debug_to_console($_COOKIE['id_sesja']);
debug_to_console($_COOKIE['id_uzytkownik']);
if (!isset($_COOKIE['id_uzytkownik']) || $_COOKIE['id_uzytkownik'] == null) {
    debug_to_console('jestem w');
    header('location: ../StrLogowanie/index.php');
    exit;
}
/**
 * Sprawdzam czy istnieje record w tabeli SESJA o podanych cookisach.
 */
$dbconn = getConnection();
$wierszSesja = mysqli_fetch_assoc(mysqli_query($dbconn, "SELECT ses_uzk_id FROM sesja WHERE\n      ses_id = '{$_COOKIE['id_sesja']}';"));
debug_to_console("Taki uzk: " . $wierszSesja['ses_uzk_id']);
if (empty($wierszSesja['ses_uzk_id'])) {
    header('location: ../StrLogowanie/index.php');
    exit;
}
/**
 * Sprawdzam czy wybrano magazyn
 */
if (!isset($_COOKIE['id_magazyn']) && $_COOKIE['id_magazyn'] == null) {
    header('Location: ../Magazyn/magazyn.php');
}
/**
 * Sprawdzam czy wybrano inwentaryzacje
 */
if (!isset($_COOKIE['id_inwentaryzacji']) && $_COOKIE['id_inwentaryzacji'] == null) {
    header('Location: ../Inwentaryzacja/inwentaryzacja.php');
<?php

/**
 * Created by PhpStorm.
 * User: Marcin
 * Date: 2016-01-10
 * Time: 02:19
 */
require_once '../../BazaDanych/DBconnection.php';
$nazwa = $_POST['nazwa'];
//pobranie danych z HTMLa
debug_to_console("Jestem w insert");
$dbconn = getConnection();
mysqli_query($dbconn, "INSERT INTO kategoria_towaru VALUES (NULL, '{$nazwa}');");
if (mysqli_errno($dbconn)) {
    debug_to_console("Problem z dodaniem magazynu do BD");
    //$_SESSION['errorDodaniaMagazynuDoBD'] = true;
}
$dbconn->close();
header('Location: kategoria.php');
Example #19
0
function sprawdzTowary()
{
    $ilosc = 0;
    //var_dump("ilosc: " . $ilosc);
    if (isset($_POST['wybraneTowary'])) {
        $dbconn = getConnection();
        mysqli_autocommit($dbconn, false);
        $arrWybraneTowary = $_POST['wybraneTowary'];
        $ilosc = count($arrWybraneTowary);
        $idArk = $_COOKIE['id_arkusza'];
        $idKat = $_COOKIE['id_kategoria'];
        //var_dump($idArk);
        //var_dump($idKat);
        try {
            $result = mysqli_query($dbconn, "SELECT tow_id FROM towar WHERE tow_ark_id = '{$idArk}' AND tow_kat_id='{$idKat}';");
            $resultStare = array();
            while ($row = mysqli_fetch_array($result)) {
                $resultStare[] = $row[0];
            }
            //var_dump($resultStare);
            /*if ($arrWybraneTowary == null) {
                  $rozmiar = count($resultStare);
                  for ($i = 0; $i < $rozmiar; $i++) {
                      $idTow = $resultStare[$i];
                      var_dump("Jestem w null: " . $idTow);
                      $result2 = mysqli_query($dbconn, "UPDATE towar SET tow_ark_id = NULL WHERE tow_id = '$idTow';");
                      if (!$result2) {
                          throw new Exception("Error details: " . mysqli_error($dbconn) . ".");
                      }
                  }
                  return;
              }*/
            if (false) {
                throw new Exception("Error details: " . mysqli_error($dbconn) . ".");
            } else {
                $resultMaxID = mysqli_fetch_array(mysqli_query($dbconn, "SELECT tow_id FROM towar ORDER BY tow_id DESC LIMIT 1"));
                if (false) {
                    throw new Exception("Error details: " . mysqli_error($dbconn) . ".");
                } else {
                    $maxTowID = $resultMaxID['tow_id'];
                    //var_dump($maxTowID);
                    /**
                     * jesli zadne towary NIE byly przypisane do arkusza
                     */
                    if ($resultStare == null) {
                        //var_dump("1 opcja");
                        for ($idTow = 1; $idTow <= $maxTowID; $idTow++) {
                            if (in_array($idTow, $arrWybraneTowary)) {
                                //var_dump($idTow . ' w 1 opcji zaznaczony');
                                debug_to_console($idTow . ' w 1 opcji zaznaczony');
                                $resultUpdate = mysqli_query($dbconn, "UPDATE towar SET tow_ark_id = '{$idArk}' WHERE tow_id = '{$idTow}';");
                                if (!$resultUpdate) {
                                    throw new Exception("Error details: " . mysqli_error($dbconn) . ".");
                                }
                            }
                        }
                    } else {
                        //var_dump("2 opcja");
                        for ($idTow = 1; $idTow <= $maxTowID; $idTow++) {
                            //te ktore byly zaznaczone
                            if (in_array($idTow, $resultStare)) {
                                //jesli teraz nie sa = UPDATE
                                if (!in_array($idTow, $arrWybraneTowary)) {
                                    //var_dump($idTow . ' w 2 opcji odznaczony');
                                    $resultUpdate = mysqli_query($dbconn, "UPDATE towar SET tow_ark_id = NULL WHERE tow_id = '{$idTow}';");
                                    if (!$resultUpdate) {
                                        throw new Exception("Error details: " . mysqli_error($dbconn) . ".");
                                    }
                                }
                            } else {
                                if (in_array($idTow, $arrWybraneTowary)) {
                                    //var_dump($idTow . ' w 2 zaznaczony!');
                                    debug_to_console($idTow . ' was checked!');
                                    $resultUpdate = mysqli_query($dbconn, "UPDATE towar SET tow_ark_id = '{$idArk}' WHERE tow_id = '{$idTow}';");
                                    if (!$resultUpdate) {
                                        throw new Exception("Error details: " . mysqli_error($dbconn) . ".");
                                    }
                                }
                            }
                        }
                    }
                }
            }
            $dbconn->commit();
            debug_to_console("transakcja zakonczona powodzeniem");
        } catch (Exception $e) {
            $dbconn->rollback();
            debug_to_console("transakcja zakonczona NIE-powodzeniem: " . $e->getMessage());
        }
    }
    return $ilosc;
}
<?php

require_once '../../BazaDanych/DBconnection.php';
$dbconn = getConnection();
//w oparciu o cookies
$numer = $_POST['numer'];
//pobranie danych z HTMLa
$opis = $_POST['opis'];
$idInw = $_COOKIE['id_inwentaryzacji'];
$dataRozpoczecia = date('Y-m-d H:i:s');
debug_to_console("Jestem w insert");
$dbconn = getConnection();
mysqli_query($dbconn, "INSERT INTO arkusz_spisowy (ark_inw_id, ark_numer, ark_data_rozp, ark_opis) VALUES ('{$idInw}', '{$numer}', '{$dataRozpoczecia}', '{$opis}');");
if (mysqli_errno($dbconn)) {
    debug_to_console("Problem z dodaniem arkusza_spisowego do BD");
    //$_SESSION['errorDodaniaMagazynuDoBD'] = true;
}
$dbconn->close();
header('Location: arkusz.php');
Example #21
0
                debug_to_console(strlen($body));
                $curl = curl_init($url);
                curl_setopt($curl, CURLOPT_CUSTOMREQUEST, "POST");
                curl_setopt($curl, CURLOPT_POSTFIELDS, $body);
                curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
                curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
                debug_to_console(curl_exec($curl));
                debug_to_console($curl);
                $result = curl_exec($curl);
                echo "curl_getinfo: " . curl_getinfo($result) . '<br/>';
                echo "curl_errno: " . curl_errno($result) . '<br/>';
                echo "curl_error: " . curl_error($result) . '<br/>';
                echo "The var dump outputs the following: ";
                var_dump($result);
                $percent = floor($result * 100);
                debug_to_console($result);
                echo "<p>This is your result: " . $result . "</p>";
                #echo "<p>You are "$percent"% </p>;
                #header('Location: ');
            }
        }
    } catch (Exception $e) {
        die(var_dump($e));
    }
    echo "<h3>Your're registered!</h3>";
}
// Retrieve data
$sql_select = "SELECT * FROM registration_tbl";
$stmt = $conn->query($sql_select);
$registrants = $stmt->fetchAll();
if (count($registrants) > 0) {
Example #22
0
				<div class=" col-lg-4 col-med-4 col-sm-4 col-xs-12 text-center">
					<a  href="<?php 
bloginfo('url');
?>
"><img src="<?php 
echo get_theme_mod('site_logo');
?>
" class="brand-logo"/> </a>
						
					<div class="site-social"> 
						<?php 
$facebook = get_theme_mod('facebook_textbox');
$twitter = get_theme_mod('twitter_textbox');
$instagram = get_theme_mod('instagram_textbox');
$linkedin = get_theme_mod('linkedin_textbox');
debug_to_console('facebook: ' . $facebook);
if ($facebook != NULL) {
    ?>
								<a href="<?php 
    echo $facebook;
    ?>
" ><i class="fa fa-facebook-square" aria-hidden="true"></i></a>
							<?php 
}
if ($twitter != NULL) {
    ?>
								<a href="<?php 
    echo $twitter;
    ?>
" ><i class="fa fa-twitter-square" aria-hidden="true"></i></a>
							<?php 
      <a class="arrow-down" href="#onepagerstory">
				<svg width="80" height="80" viewBox="0 0 80 80" version="1.1" xmlns="http://www.w3.org/2000/svg"><circle class="" cx="40" cy="40" r="32" /><line x1="20" y1="30" x2="40" y2="50" /><line x1="40" y1="50" x2="60" y2="30" /></svg>
      </a>
    </div>
  </div>
<div class="row">
    <section class="onepage-section" id="onepagerstory">
      <?php 
if ($the_query->have_posts()) {
    ?>
        <?php 
    while ($the_query->have_posts()) {
        $the_query->the_post();
        ?>
          <?php 
        debug_to_console(get_field('bild'));
        ?>
          <article id="<?php 
        echo $post->post_name;
        ?>
" class="onepage-element ">
            <div class="row">
              <div class="container">
                <div class="onepage-image col-md-6">

                  <img src="<?php 
        echo get_field('bild')['url'];
        ?>
" alt="<?php 
        echo get_field('bild')['alt'];
        ?>
Example #24
0
 /**
  * @param type $obj
  */
 static function debug($obj)
 {
     if (function_exists('debug_to_console')) {
         debug_to_console($obj);
     }
 }
Example #25
0
/**
 * Created by PhpStorm.
 * User: Marcin
 * Date: 2015-12-26
 * Time: 13:20
 */
?>

<div id="header">
    <div class="tytul">
        <?php 
$wierszUzytkownik = mysqli_fetch_assoc(mysqli_query($dbconn, "SELECT * FROM uzytkownik WHERE\n                        uzk_id = '{$wierszSesja['ses_uzk_id']}';"));
if (!mysqli_errno($dbconn) && !empty($wierszUzytkownik['uzk_id'])) {
    echo "Witaj " . $wierszUzytkownik['uzk_imie'] . " " . $wierszUzytkownik['uzk_nazwisko'] . "!";
} else {
    debug_to_console("błąd podczas pobierania uzytkownika o ID: " . $wierszUzytkownik['uzk_id']);
    $_SESSION['bladSQL'] = true;
    header('Location: index.php');
}
$dbconn->close();
?>
    </div>
    <div class="dane">
        <?php 
if (isset($_COOKIE['id_magazyn']) && $_COOKIE['id_magazyn'] != null) {
    $dbconn = getConnection();
    $wierszMagazyn = mysqli_fetch_assoc(mysqli_query($dbconn, "SELECT mag_nazwa FROM magazyn WHERE mag_id = '{$_COOKIE['id_magazyn']}';"));
    echo 'Magazyn: ' . $wierszMagazyn['mag_nazwa'];
    $dbconn->close();
} else {
    echo '<a href="../Magazyn/magazyn.php" class="tilelink">Wybierz magazyn</a>';
Example #26
0
function request_var_condition()
{
    debug_to_console("* Calling request_var_condition");
    $array = array("negative_condition" => request_var('negative_condition', ''), "positive_condition" => request_var('positive_condition', ''), "gear" => request_var('gear', ''));
    return $array;
}
<?php

/**
 * Created by PhpStorm.
 * User: Marcin
 * Date: 2015-12-16
 * Time: 14:54
 */
require_once "../../BazaDanych/DBconnection.php";
$haslo = $_POST['haslo2'];
$hasloCheck = $_POST['haslo2Check'];
debug_to_console($haslo);
debug_to_console($hasloCheck);
if ($haslo != $hasloCheck) {
    echo "*Hasła nie zgadzają się!";
} else {
    debug_to_console("Hasla takie same");
}
        if ($stan->getPelnowartosciowe() != null || $stan->getUszkodzone() != null || $stan->getZniszczone() != null || $stan->getPrzeterminowane() != null) {
            var_dump("sprawdzam nulle");
            $idStan = $stan->getStanId();
            $pelnowartosciowe = $stan->getPelnowartosciowe();
            if ($pelnowartosciowe == null) {
                $pelnowartosciowe = 0;
            }
            $uszkodzone = $stan->getUszkodzone();
            if ($uszkodzone == null) {
                $uszkodzone = 0;
            }
            $zniszczone = $stan->getZniszczone();
            if ($zniszczone == null) {
                $zniszczone = 0;
            }
            $przeterminowane = $stan->getPrzeterminowane();
            if ($przeterminowane == null) {
                $przeterminowane = 0;
            }
            $dbconn = getConnection();
            $result = mysqli_query($dbconn, "UPDATE stan_rzeczywisty SET stan_pelnowartosciowe = '{$pelnowartosciowe}', stan_uszkodzone = '{$uszkodzone}',\n                stan_zniszczone = '{$zniszczone}', stan_przeterminowane = '{$przeterminowane}' WHERE stan_id = '{$idStan}';");
            if ($result) {
                /*var_dump("zaktualizacjowano " . $idStan);*/
            } else {
                debug_to_console("jakis problem");
            }
            $dbconn->close();
        }
    }
}
header('Location: towaryArkusz.php');
Example #29
0
function selectOneDocument($data)
{
    global $conn;
    $list = array();
    $tab_ligne = array();
    $id = 'id_doc';
    $name = 'nom';
    $lat = 'lat';
    $lng = 'lng';
    $url = 'url';
    $sql = "SELECT id_doc, nom,  X(latlng) lat, Y(latlng) lng , url FROM documents WHERE id=" . $data["id"];
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        $nbLigne = 0;
        while ($row = $result->fetch_row()) {
            $list[] = $row;
        }
        echo json_encode($list);
    } else {
        debug_to_console('No Result. Select Document. SQL : ' . $sql);
    }
}
Example #30
0
<div class="hellk-mobile" >
    <a href = "http://www.twitch.tv/hellkevilk?tt_medium=live_embed&tt_content=text_link" style = "padding:2px 0px 4px; display:block; width:345px; font-weight:normal; font-size:10px;text-decoration:underline;" >
        Stream Hellkevilk
    </a ><br />
    <a href = "http://www.twitch.tv/hllava?tt_medium=live_embed&tt_content=text_link" style = "padding:2px 0px 4px; display:block; width:345px; font-weight:normal; font-size:10px;text-decoration:underline;" >
        Stream TM
    </a >
    <a href = " http://www.twitch.tv/thecylo?tt_medium=live_embed&tt_content=text_link" style = "padding:2px 0px 4px; display:block; width:345px; font-weight:normal; font-size:10px;text-decoration:underline;" >
        Strem Cylo
    </a >

</div >

<div class="tmWrapper" >
    <div class="tm" >
        <iframe src = "http://www.twitch.tv/hellkevilk/embed" frameborder = "0" scrolling = "no" height = "264" width = "434" ></iframe >
        <a href = "http://www.twitch.tv/hellkevilk?tt_medium=live_embed&tt_content=text_link" style = "padding:2px 0px 4px; display:block; width:345px; font-weight:normal; font-size:10px;text-decoration:underline;" >
            Watch live video from hellkevilk on www . twitch . tv
        </a >
    </div >
    <div class="tm" style = "margin-left: 1em;float: right;" >
        <iframe src = "http://www.twitch.tv/hllava/embed" frameborder = "0" scrolling = "no" height = "264" width = "434" ></iframe >
        <a href = "http://www.twitch.tv/hllava?tt_medium=live_embed&tt_content=text_link" style = "padding:2px 0px 4px; display:block; width:345px; font-weight:normal; font-size:10px;text-decoration:underline;" > Watch live video from hllava on www . twitch . tv </a >
    </div >
    <div class="tm" >
         <iframe src = " http://www.twitch.tv/thecylo/embed" frameborder = "0" scrolling = "no" height = "264" width = "434" ></iframe >
         <a href = " http://www.twitch.tv/thecylo?tt_medium=live_embed&tt_content=text_link" style = "padding:2px 0px 4px; display:block; width:345px; font-weight:normal; font-size:10px;text-decoration:underline;" > Watch live video from thecylo on www . twitch . tv </a >
    </div >';
$time_elapsed_secs = microtime(true) - $start;
debug_to_console("twitch " . $time_elapsed_secs);