Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- require_once ('config.php');
- /**
- Fuck Yea
- `ymo::+++odNhdhhs+++-
- `:ohmdymMdy+/s` .:::oymy:`
- -symdho:....:+sddNds/yds `:yNmyhm:
- .+ymhmMmyyyyyyyyymNmdMN/dd:`/hmmy+/hm+
- `/hdo:` `/hdds++++++yNmNs. -NNdho+-oNy.
- .sdh:` `.-////////-` +No:/yNNMMd:`
- `hms.` ``````````` -shdhdNhdmNo
- /my. ::./oyhhhyyyyyyyyyhyhyoo:. ``.///:`+No
- `/No` hd:+/.``` .+++::-.:/shd/. oM.
- hm/ -/` `//oooyhyyo/+sdy- .my
- /M/ `..++/ .sN/ hh
- oN `hN/` hh
- oM `:y: `my
- +M: -M/
- `hm. sN`
- `dd- .my
- `hm:` sN.
- `/ms. :No
- -smo` .mh`
- /hh/` -dh`
- `:yhy:. `.:+h/ `.ods`
- `.+yds:-+oyyyyyMm` -oyho-
- `.-/sdmdhmmdo+-:NMo...........-/ssdo-`
- ``-:+oyyyso:-.``..:/ooymMNmssssssssssyo:-.
- `.:oyyyyo+::.` sNoN+
- `ohyo/-` -No/ms`
- `/dh/ my :mh.
- +++++++/ -++/ -ody` .:+++/:` :++: `/++/. `/hh/`-hy+/`.++++++++` `/+++/
- yyyo///: :yys`/dyyy` :yys/+yyo` oyy+:syy/. .oyyooyyyh--yyy+////` :yyyyy-
- yyysooo` :yys`mmyyy``yyy- ... oyyyyyy+` `yyyyy/.omhyyyoooo+ .yys-yys`
- yyy+--- -yyyym+yyy``syy:``+/:` oyyyo+yy/` /hyyo` .yyyy::::- `oyysosyy+ ```
- yyy: `+yyhysys: .oyyosyy+` oyy+ `/yyo` hyy+ -yyyooooo.:yys+++syy--ss/
- -::` :ms:::-` `.-::-. -::. -::. +m+- `:::oddo:`-::. .::.`::.
- `oN+` `mh .+hho:``
- `sN/ oN. .+syho+-```
- .hMo```` `dd .:+ydhy+:.``
- +mNNmyyhds` :M/ `-+syhho+:`
- .yMM/hm- :dd+` hm. .:oMmho`
- .ddmh `dd` -y+ `Nh +MhMM/
- /M`ym- .mh- :N+ `Ny.MNN-
- /M``oN+ `ods dd. `M++N-Ns
- -y` .- `md . .: oh
- +M/
- */
- if (!$klasa->wypelniony($_POST)) {
- $klasa->CatchExc('Err');
- header('Location: index.php');
- }
- global $a;
- global $szkoly;
- //echo "1:".$_POST['school'];
- //echo '2:'.$_POST['city'];
- //echo '3:'.$_POST['type'];
- //echo '4:'.$_POST['duration'];
- if ($_POST['school'] == 'Select School...')
- $school = null;
- else
- $school = $_POST['school'];
- if ($_POST['city'] == 'Select City...')
- $city = null;
- else
- $city = $_POST['city'];
- if ($_POST['type'] == "Select Type...")
- $type = null;
- else
- $type = $_POST['type'];
- if ($_POST['duration'] == 'Select Duration...')
- $duration = null;
- else
- $duration = $_POST['duration'];
- if (empty($school) and empty($city) and empty($type) and empty($duration)) {
- $klasa->CatchExc('Huju wybierz a nie!');
- header('Location: index.php');
- } else {
- $sql = "select * FROM s_miasta,s_szkoly,s_kursy WHERE (s_miasta.id_miasto = s_szkoly.id_miasto) and (s_kursy.id_szkola = s_szkoly.id_szkola) order by miasto asc ";
- if (!empty($school))
- $school = "and s_szkoly.nazwa_szkoly='$school'";
- else
- $school = "and (s_szkoly.id_szkola = s_kursy.id_szkola)";
- if (!empty($city))
- $city = "and s_miasta.miasto='$city'";
- if (!empty($type))
- $type = "and type='$type'";
- if (!empty($duration)) {
- $dur = explode(" ", $duration);
- $duration= "and duration='$dur[0]'";
- }
- //echo $sql . $where;
- $sql = $sql.$where;
- //---------------------------------------------------------------------------------------------------------------------------------------------------
- //$sql = mysql_query("select * from s_miasta $city");
- $sql = mysql_query("select * from s_szkoly,s_miasta,s_kursy where (s_szkoly.id_miasto = s_miasta.id_miasto) $type $duration $city $school group by s_miasta.id_miasto having count(s_szkoly.id_szkola)>0 ");
- //echo "select * from s_szkoly,s_miasta,s_kursy where (s_szkoly.id_miasto = s_miasta.id_miasto) and(s_szkoly.id_szkola = s_kursy.id_szkola) $city $school group by s_miasta.id_miasto having count(s_szkoly.id_szkola)>0 ";
- echo mysql_error();
- //echo "1:select * from s_miasta $city";
- while ($miasta = mysql_fetch_assoc($sql)) {
- echo '<ul class="menu_list city">';
- echo '<li class="menu_head">' . $miasta['miasto'] . '</li>';
- $id_miasto = $miasta['id_miasto'];
- $sql1 = mysql_query("select * from s_szkoly,s_miasta,s_kursy where (s_szkoly.id_miasto = s_miasta.id_miasto) $type $duration $school group by s_szkoly.id_szkola having count(id_kurs)>0 and s_szkoly.id_miasto='$id_miasto' ");
- //$sql1 = mysql_query("select * from s_szkoly where id_miasto='$id_miasto' $school ");
- //echo "select * from s_szkoly,s_miasta,s_kursy where (s_szkoly.id_miasto = s_miasta.id_miasto) $type $duration $school group by s_szkoly.id_szkola having count(id_kurs)>0 and s_szkoly.id_miasto='$id_miasto' ";
- echo mysql_error();
- while ($szkoly = mysql_fetch_assoc($sql1)) {
- echo '<ul class="menu_body school">';
- $id_szkola = $szkoly['id_szkola'];
- $a = $szkoly['nazwa_szkoly'];
- echo '<li class="menu_head">' . $szkoly['nazwa_szkoly'] . "<b><a href='szkoly/add_feedback.php?szkola=$id_szkola&miasto=$id_miasto'> Dodaj feedback</a></b></li>";
- $sql3 = mysql_query("select * from s_feedback where id_szkola=$id_szkola and id_miasto=$id_miasto");
- //echo "3: select * from s_feedback where id_szkola=$id_szkola and id_miasto=$id_miasto";
- echo mysql_error();
- $ile = mysql_num_rows($sql3);
- if ($ile > 0) {
- while ($feedbacki = mysql_fetch_assoc($sql3)) {
- echo '<ul>';
- echo "Feedback's :<ul>";
- echo '<li>Opis: <b>' . $feedbacki['tresc'] . '</b></li>';
- echo '<li>Data: <b>' . $feedbacki['data'] . '</b></li></ul>';
- echo '</ul>//-----------------------------------------------<br />';
- }
- }
- $sql2 = mysql_query("select * from s_szkoly,s_miasta,s_kursy where (s_szkoly.id_miasto = s_miasta.id_miasto) and (s_kursy.id_szkola = s_szkoly.id_szkola) $school $type $duration and s_szkoly.id_miasto='$id_miasto' and s_szkoly.nazwa_szkoly='$a'");
- // echo "select * from s_szkoly,s_miasta,s_kursy where (s_szkoly.id_miasto = s_miasta.id_miasto) and (s_kursy.id_szkola = s_szkoly.id_szkola) $school $type $duration and s_szkoly.id_miasto='$id_miasto' and s_szkoly.id_szkola='$a'";
- // echo "select * from s_szkoly,s_miasta,s_kursy where (s_szkoly.id_miasto = s_miasta.id_miasto) and (s_kursy.id_szkola = s_szkoly.id_szkola) $school $type $duration and s_szkoly.id_miasto='$id_miasto' ";
- //echo "4: select * from s_kursy where id_szkola='$id_szkola' $type $duration";
- echo mysql_error();
- while ($kursy = mysql_fetch_assoc($sql2)) {
- $id_kurs = $kursy['id_kurs'];
- echo '<ul class="menu_body courses">';
- echo '<li class="menu_head">Nazwa kursu: <b>' . $kursy['nazwa'] . '</b></li><ul>';
- echo '<li>Cena: <b> ' . $kursy['cena'] . '</b></li>';
- echo '<li>Opis: <b> ' . $kursy['opis'] . '</b></li>';
- echo '<li>Inne: <b> ' . $kursy['others'] . '</b></li></ul>';
- echo '</ul>';
- }
- echo '</ul>';
- }
- echo '</ul>';
- }
- //echo "<ul>aaa<li>bbb<ul>ddd<li>eee</li></ul></li>ccc</ul>";
- <?
- /**
- * Klasy dla Wingles.com
- * Author(c) Milosz Sobczak & Patryk Blicharski
- *
- */
- require ('lang.class.php');
- class general
- {
- private $LANGini;
- public $LANGSite;
- public $xx;
- public $baza_config = array("baza_user" => "miloszbr_milosz", "baza_haslo" =>
- "Jakubek1", "baza_host" => "localhost", "baza_nazwa" => "miloszbr_wingles");
- function __construct()
- {
- $this->connect_db();
- }
- public function connect_db()
- {
- @mysql_connect($this->baza_config['baza_host'], $this->baza_config['baza_user'],
- $this->baza_config['baza_haslo']) or die(__('err_db1'));
- @mysql_select_db($this->baza_config['baza_nazwa']) or die(__('err_db2'));
- mysql_query('SET CHARSET latin2');
- return true;
- }
- public function Get_mini_content($name)
- {
- $lang = Lang::get_language();
- $sql = "select content from articles where alias='$name' and lang='$lang' limit 1";
- $sql = mysql_fetch_array(mysql_query($sql));
- echo $sql['content'];
- }
- //komunikaty bledow view
- public function ShowExc($good=0)
- {
- $err = $_SESSION['err'];
- $err_good = $_SESSION['err_good'];
- if ($err != null) {
- if ($err_good == 0)
- {
- echo '<div class="wrong rounded" id="info"><p>'.$err.'</p></div>';
- }
- else
- {
- echo '<div class="right rounded" id="info"><p>'.$err.'</p></div>';
- }
- $_SESSION['err'] = null;
- $_SESSION['err_good'] = null;
- }
- }
- public function CatchExc($err, $good=0)
- {
- $_SESSION['err'] = $err;
- $_SESSION['err_good'] = $good;
- }
- //-----------------------
- public function back($site = 'index.php')
- {
- header("Location: $site");
- }
- //------SEKCJA USERA-----
- public function czyzalogowany()
- {
- if (empty($_SESSION['wingles_user'])) {
- $this->user = null;
- return false;
- } else {
- $this->user = $_SESSION['wingles_user'];
- return $this->user;
- }
- }
- public function CzyNieAktywne($login)
- {
- $sql = "SELECT aktywny from users where user='$login' and aktywny=0";
- $wynik = mysql_query($sql);
- $ile_wynik = mysql_num_rows($wynik);
- if (!$wynik)
- return false;
- if ($ile_wynik > 0)
- return true;
- else
- return false;
- }
- public function logowanie($login, $haslo)
- {
- $sql = "SELECT * FROM users WHERE user='$login' and pass=sha1('$haslo') limit 1";
- $wynik = mysql_query($sql);
- $ile_wynik = mysql_num_rows($wynik);
- if (!$wynik)
- return false;
- if ($ile_wynik > 0) {
- $klucz = mysql_fetch_assoc($wynik);
- $_SESSION['wingles_user_id'] = $klucz['id'];
- $_SESSION['wingles_user'] = $login;
- return true;
- }
- }
- public function wylogowanie()
- {
- $old = $_SESSION['wingles_user'];
- unset($_SESSION['wingles_user']);
- unset($_SESSION['wingles_user_id']);
- $wynik_niszczenia = session_destroy();
- if (!empty($old)) {
- if ($wynik_niszczenia) {
- return true;
- } else
- return false;
- } else
- return false;
- }
- public function wypelniony($zmienne_form)
- {
- foreach ($zmienne_form as $klucz => $wartosc) {
- if (!isset($klucz) || ($wartosc == ''))
- return false;
- }
- return true;
- }
- public function dobry_email($adres)
- {
- if (!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$",
- $adres)) {
- return false;
- } else
- return true;
- }
- public function rejestruj($user, $haslo, $email, $wiek, $plec)
- {
- $sql = "select * from users where user='$user'";
- $wynik = mysql_query($sql);
- if (!$wynik)
- throw new exception(__('err_onequery'));
- $istnienie = mysql_num_rows($wynik);
- if ($istnienie > 0)
- throw new exception(__('user_reg_err1'));
- //-----------------------------------
- $data = date("y-m-d");
- $token = md5($user . $data);
- $ip = $_SERVER['REMOTE_ADDR'];
- $sql = "insert into users values (null, '$user', sha1('$haslo'), '$email','$token',$wiek,'$plec','$data','$ip',0)";
- $wynki = mysql_query($sql);
- if (!$wynik)
- throw new exception(__('user_reg_err2'));
- $list = __('reg_mail_string', array($user, $token));
- mail($email, "Rejestracja użytkownika", $list, "From: <test@strona.pl>");
- return true;
- }
- //-----------------------USERY------------------------------------------------------------------
- //-----------------------JEZYK STRONY-----------------------------------------------------------
- /** !!!!!!!!!!!!!!!!!DO WYWALENIA!!!!!!!!!!!!!!!!!!!!!1
- *
- *
- * public function UstawJezyk($jezyk = "")
- * {
- * if (!empty($_SESSION['wingles_lang']) and $_SESSION['wingles_lang'] != $jezyk and
- * $jezyk != "")
- * {
- * $czy = true;
- * } else
- * if (!empty($_SESSION['wingles_lang']) and $_SESSION['wingles_lang'] == $jezyk)
- * {
- * $czy = false;
- * }
- * if (empty($_SESSION['wingles_lang']) or $czy == true)
- * {
- * $lang = substr($_SERVER['HTTP_ACCEPT_LANGUAGE'], 0, 2);
- * $sql = "select lang from language where lang='$jezyk' limit 1";
- * $sql = mysql_query($sql);
- * $istnienie = mysql_num_rows($sql);
- * $klucz = mysql_fetch_assoc($sql);
- * //echo "lang:$lang<br>";
- * //echo 'klucz:' . $klucz['lang'];
- * //echo "<br>jezyk:$jezyk<br>";
- * //echo 'sesja:'. $_SESSION['wingles_lang'];
- * //echo '<br> Langsite: '.$this->LANGini;
- * if ($istnienie <= 0)
- * {
- *
- * $_SESSION['wingles_lang'] = $lang;
- * $this->LANGini = $lang;
- *
- * } else
- * {
- * $this->LANGSite = $jezyk;
- * $_SESSION['wingles_lang'] = $jezyk;
- * echo 'b';
- *
- * }
- * }
- * //echo "$this->LangSite";
- * }
- * public function DajLang($dzial, $wartosc)
- * {
- *
- * return $this->LANGini[$dzial][$wartosc];
- * }
- *
- *
- **/
- }
- ?>
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement