if ($_GET['v'] == "odp") {
$Query = 'SELECT * FROM ' . $pre . 'pw WHERE pw_id="' . db_real_escape_string($_GET['id']) . '" and pw_do="' . $_SESSION['user_id'] . '" and pw_typ="1"';
$result = db_query($Query) or die(db_error());
while ($row = db_fetch($result)) {
$Query1 = 'SELECT * FROM ' . $pre . 'user WHERE user_id="' . db_real_escape_string($row['pw_od']) . '"';
$result1 = db_query($Query1) or die(db_error());
while ($row1 = db_fetch($result1)) {
$user_login = $row1['user_login'];
$user_loginn = namen($row1['user_login']);
}
$pw_id = $row['pw_id'];
$pw_temat = $row['pw_tytul'];
}
$smarty->assign("od_login", $user_login);
$smarty->assign("od_loginn", $user_loginn);
$smarty->assign("pw_id", $pw_id);
$smarty->assign("temat", $pw_temat);
}
if ($_GET['v'] == "" and $_GET['id'] != "") {
$Query1 = 'SELECT * FROM ' . $pre . 'user WHERE user_id="' . db_real_escape_string($_GET['id']) . '"';
$result1 = db_query($Query1) or die(db_error());
while ($row1 = db_fetch($result1)) {
$user_login = $row1['user_login'];
$user_loginn = namen($row1['user_login']);
}
$smarty->assign("od_login", $user_login);
$smarty->assign("od_loginn", $user_loginn);
}
$smarty->assign("title", 'PW - ' . $ust['nazwa']);
$smarty->display($ust['templates'] . '/pw.send.tpl');
}
<?php
include "subheader.php";
$Query = "SELECT * FROM " . $pre . "strony WHERE strony_wys='1' AND strony_id='" . db_real_escape_string($_GET['id']) . "' ORDER by strony_id DESC";
$result = db_query($Query) or die(db_error());
while ($row = db_fetch($result)) {
$page_nazwa = $row['strony_nazwa'];
$page_id = $row['strony_id'];
$page_nazwa_n = namen($row['strony_nazwa']);
$page_tresc = $row['strony_tresc'];
$wys = $row['strony_wys'];
}
if ($wys == 1) {
$smarty->assign("page_nazwa", $page_nazwa);
$smarty->assign("page_nazwa_n", $page_nazwa_n);
$smarty->assign("page_tresc", $page_tresc);
$smarty->assign("page_id", $page_id);
$smarty->assign("title", $page_nazwa . ' - ' . $ust['nazwa']);
}
$smarty->display($ust['templates'] . '/page.tpl');
$privatekey = "6Le6YbsSAAAAAF8gb5L6eVXlEd2eFXjQ2aK__u1y";
$smarty->assign("token_img", recaptcha_get_html($publickey));
$visitors_online = new usersOnline();
$strona_panel = "ok";
$smarty->caching = 0;
$smarty->assign("fb_login", $ust['fb_on']);
$smarty->assign("pay_set", $pay_set);
$smarty->assign("pay_typ", $ust['pay_typ']);
$smarty->assign("pay_typ_sms", $ust['pay_typ_sms']);
$smarty->assign("meta_desc", $ust['meta_desc']);
$smarty->assign("meta_key", $ust['meta_key']);
$smarty->assign("meta_title", $ust['meta_title']);
$smarty->assign("site_url", $ust['adres']);
$smarty->assign("site_nazwa", $ust['nazwa']);
$smarty->assign("user_nick", $_SESSION['user_nick']);
$smarty->assign("user_nickn", namen($_SESSION['user_nick']));
$smarty->assign("user_id", $_SESSION['user_id']);
$smarty->assign("user_adm", $_SESSION['logadm']);
$smarty->assign("gift_on", $ust['gift']);
$smarty->assign("templa", $ust['templates']);
$smarty->assign("oglp", $ust['oglp']);
$smarty->assign("u_usr", $u_usr);
$smarty->assign("lang", $lang);
$smarty->assign("gtime", time());
//Reklama
$smarty->assign("rtop", $ust['r_top']);
$smarty->assign("rtopu", $ust['r_topu']);
$smarty->assign("rpro", $ust['r_pro']);
$smarty->assign("rprou", $ust['r_prou']);
$smarty->assign("rmenu", $ust['r_menu']);
$smarty->assign("rmenuu", $ust['r_menuu']);
$kom_data[] = $row['kom_data'];
$kom_nick[] = $row['kom_nick'];
$kom_nickn[] = namen($row['kom_nick']);
$kom_tresc[] = $row['kom_tresc'];
$kom_idu[] = $row['kom_idu'];
$kom_ile++;
}
$Query = "SELECT * FROM " . $pre . "news WHERE news_wys='1' AND news_id='" . db_real_escape_string($_GET['id']) . "' ORDER by news_id DESC";
$result = db_query($Query) or die(db_error());
while ($row = db_fetch($result)) {
$news_tytul = $row['news_tytul'];
$news_tytul_n = namen($row['news_tytul']);
$news_tresc = $row['news_tresc'];
$news_data = $row['news_data'];
$news_autor = $row['news_user'];
$news_autorn = namen($row['news_user']);
$news_autorid = $row['news_userid'];
$news_id = $row['news_id'];
$ocena = $row['news_ocena'];
$ileg = $row['news_ileg'];
$wys = $row['news_wys'];
}
if ($wys == 1) {
$smarty->assign("news_tytul", $news_tytul);
$smarty->assign("news_tytul_n", $news_tytul_n);
$smarty->assign("news_tresc", $news_tresc);
$smarty->assign("news_data", $news_data);
$smarty->assign("news_autor", $news_autor);
$smarty->assign("news_autorn", $news_autorn);
$smarty->assign("news_autorid", $news_autorid);
$smarty->assign("news_id", $news_id);
$nr = 1;
}
$strona = $nr;
}
$ile = 36;
$start = ($strona - 1) * $ile;
$wykonaj = db_query($zapytanie) or die("Nie działa zapytanie" . $zapytanie);
$ile_rek = db_num_rows($wykonaj);
$podstron = ceil($ile_rek / $ile);
$zapytanie .= " LIMIT {$start},{$ile}";
$final = db_query($zapytanie) or die("Nie działa zapytanie końcowe");
while ($rowe = db_fetch($final)) {
if (!in_array($rowe['user_id'], $ou_id) and $_SESSION['user_id'] != $rowe['user_id'] and get_user_online($rowe['user_id']) >= 1) {
$ouab = $ouab + 1;
$ou_login[] = $rowe['user_login'];
$ou_loginn[] = namen($rowe['user_login']);
$ou_wiek[] = get_user_wiek($rowe['user_y']);
$ou_img[] = $rowe['user_fotka'];
$ou_id[] = $rowe['user_id'];
$ou_woj[] = get_user_woj($rowe['user_woj']);
$ou_miasto[] = $rowe['user_miasto'];
$ou_plec[] = get_user_plec($rowe['user_plec']);
$ou_plecnr[] = $rowe['user_plec'];
$ou_online[] = "1";
//$ou_id[]=$rowe['user_id'];
}
}
}
$smarty->assign("ou_login", $ou_login);
$smarty->assign("ou_loginn", $ou_loginn);
$smarty->assign("ou_wiek", $ou_wiek);
}
echo ' align="center"><a href="index.php?page=komentarze&action=galerie&typ=g&id=' . $row['user_id'] . '" title="Zobacz komentarze">' . $row['user_login'] . '</a> [' . $ilek . ']</td>
</tr>';
$i++;
}
echo '</table>';
if ($i == "1") {
echo '<center><b>Brak</b></center>';
}
} else {
$k = 0;
$Query = 'SELECT * FROM ' . $pre . 'komentarze WHERE kom_typ="g" AND kom_idk="' . db_real_escape_string($_GET['id']) . '" ORDER by kom_id DESC ';
$result = db_query($Query) or die(db_error());
while ($row = db_fetch($result)) {
echo '
Nick: <b>';
if ($row['kom_idu'] == "") {
echo '' . $row['kom_nick'] . '';
} else {
echo '<a href="../user/' . namen($row['kom_nick']) . '/' . $row['kom_idu'] . '">' . $row['kom_nick'] . '</a>';
}
echo '</b> Data: <b>' . $row['kom_data'] . '</b> - <b><a href="index.php?page=komentarze&action=galerie&typ=g&id=' . htmlspecialchars($_GET['id']) . '&id_del=' . $row['kom_id'] . '&v=delete"><b>Usuń</b></a></b><br>
' . $row['kom_tresc'] . '<br><hr><br>
';
$k++;
}
if ($k == "0") {
echo '<center><b>Brak komentarzy.</b></center>';
}
}
}
$g_nazwa = $row['g_nazwa'];
}
$delt = "DELETE FROM " . $pre . "temat WHERE t_id='" . $t_id . "'";
db_query($delt);
header("Location: " . $ust['adres'] . "grupa/" . $g_id . "/" . namen($g_nazwa) . "_del-t:ok");
exit;
} else {
if ($_GET['del'] == "post") {
$Query1 = 'SELECT * FROM ' . $pre . 'komentarze WHERE kom_del="' . db_real_escape_string($_GET['id']) . '" and kom_typ="gr"';
$result1 = db_query($Query1) or die(db_error());
while ($row1 = db_fetch($result1)) {
$kom_idk = $row1['kom_idk'];
$kom_id = $row1['kom_id'];
}
$Query = 'SELECT * FROM ' . $pre . 'temat WHERE t_id="' . $kom_idk . '"';
$result = db_query($Query) or die(db_error());
while ($row = db_fetch($result)) {
$t_id = $row['t_id'];
$g_id = $row['t_g'];
$t_nazwa = $row['t_nazwa'];
}
$up = "UPDATE " . $pre . "temat SET t_ile=t_ile-1 WHERE t_id='" . $t_id . "'";
db_query($up);
$delk = "DELETE FROM " . $pre . "komentarze WHERE kom_id='" . $kom_id . "'";
db_query($delk);
header("Location: " . $ust['adres'] . "temat/" . $t_id . "/" . namen($t_nazwa) . "_del-p:ok");
exit;
}
}
}
}
<?php
session_start();
include "../db_connect.php";
include "../include/function.php";
include "../admin/namen.php";
if ($_SESSION['user_id'] >= 1) {
if ($_POST['nazwa'] != "") {
$in = "INSERT INTO " . $pre . "temat(`t_nazwa`, `t_user`, `t_g`, `t_data`, `t_dataz`,`t_ile`)VALUES('" . htmlspecialchars($_POST['nazwa']) . "', '" . $_SESSION['user_id'] . "', '" . htmlspecialchars($_GET['id']) . "', NOW(), NOW(),'0')";
db_query($in);
$idi = db_insert_id();
$del = md5($idi . "-" . rand(0, 200));
$up = "UPDATE " . $pre . "temat SET t_del='" . $del . "' WHERE t_id='" . $idi . "'";
db_query($up);
$in = "INSERT INTO " . $pre . "komentarze(`kom_nick`, `kom_tresc`, `kom_data`, `kom_typ`, `kom_idk`, `kom_idu`) VALUES ('" . htmlspecialchars($_SESSION['user_nick']) . "', '" . htmlspecialchars($_POST['tresc']) . "', NOW(), 'gr', '" . $idi . "', '" . $_SESSION['user_id'] . "')";
db_query($in);
} else {
header("Location: ../grupa/" . $_GET['id'] . "/" . $_GET['nazwa'] . "_create:pn");
exit;
}
}
header("Location: ../temat/" . $idi . "/" . namen($_POST['nazwa']) . "");
$zapytanie = "SELECT * FROM " . $pre . "mov INNER JOIN " . $pre . "mov_access ON fo_id=mov_id WHERE user_id = " . (int) $_SESSION['user_id'] . " ORDER by fo_id DESC";
if (!$strona) {
$nr = $_GET["strona"];
if ($nr == 0) {
$nr = 1;
}
$strona = $nr;
}
$ile = 100;
$start = ($strona - 1) * $ile;
$wykonaj = db_query($zapytanie) or die("Nie działa zapytanie" . $zapytanie);
$ile_rek = db_num_rows($wykonaj);
$podstron = ceil($ile_rek / $ile);
$zapytanie .= " LIMIT {$start},{$ile}";
$final = db_query($zapytanie) or die("Nie działa zapytanie końcowe");
$i = 1;
$rows = array();
$key = 0;
while ($row = db_fetch($final)) {
$rows[$key] = $row;
$rows[$key]['user_loginn'] = namen($row['user_login']);
if ($row['fo_custom_file'] == 1) {
$rows[$key]['fo_fm'] = $row['fo_fm'];
} else {
$rows[$key]['fo_fm'] = get_you($row['fo_fm']);
}
$key++;
}
$smarty->assign("rows", $rows);
$smarty->assign("title", 'Moje kupione filmy - ' . $ust['nazwa']);
$smarty->display($ust['templates'] . '/filmy.tpl');
$i_d[] = $row['i_d'];
$i_m[] = $row['i_m'];
$i_y[] = $row['i_y'];
$i_h[] = $row['i_h'];
$i_mi[] = $row['i_mi'];
$i_nazwa[] = $row['i_nazwa'];
$i_opis[] = $row['i_opis'];
$i_a++;
}
$smarty->assign("i_id", $i_id);
$smarty->assign("i_d", $i_d);
$smarty->assign("i_m", $i_m);
$smarty->assign("i_y", $i_y);
$smarty->assign("i_h", $i_h);
$smarty->assign("i_mi", $i_mi);
$smarty->assign("i_nazwa", $i_nazwa);
$smarty->assign("i_opis", $i_opis);
$smarty->assign("i_a", $i_a);
$smarty->assign("stan", $_GET['stan']);
$Querys = 'SELECT * FROM ' . $pre . 'user WHERE user_id="' . db_real_escape_string($_GET['id']) . '" and user_akt="1"';
$results = db_query($Querys) or die(db_error());
while ($rows = db_fetch($results)) {
$userlo = $rows['user_login'];
$smarty->assign("user_lo", $rows['user_login']);
$smarty->assign("user_plec", $rows['user_plec']);
$smarty->assign("user_lon", namen($rows['user_login']));
$smarty->assign("user_loid", $rows['user_id']);
$userloid = $rows['user_id'];
}
$smarty->assign("title", $lang['467'] . ' ' . $userlo . ' - ' . $ust['nazwa']);
$smarty->display($ust['templates'] . '/profil-imprezy.tpl');
$smarty->assign("czlonek", $row['c_akt']);
}
$smarty->assign("g_id", $g_id);
$smarty->assign("g_typ", $g_typ);
$smarty->assign("g_nazwan", $g_nazwan);
$smarty->assign("g_nazwa", $g_nazwa);
$smarty->assign("g_data", $g_data);
$smarty->assign("g_user", $g_user);
$kom_ile = 0;
$Query = 'SELECT * FROM ' . $pre . 'komentarze WHERE kom_idk="' . db_real_escape_string($_GET['id']) . '" AND kom_typ="gr" ORDER by kom_id ASC';
$result = db_query($Query) or die(db_error());
while ($row = db_fetch($result)) {
$kom_data[] = $row['kom_data'];
$kom_nick[] = $row['kom_nick'];
$kom_nickf[] = get_user_foto($row['kom_idu']);
$kom_nickn[] = namen($row['kom_nick']);
$kom_tresc[] = $row['kom_tresc'];
$kom_idu[] = $row['kom_idu'];
$kom_del[] = $row['kom_del'];
$kom_ile++;
}
$smarty->assign("kom_data", $kom_data);
$smarty->assign("kom_nick", $kom_nick);
$smarty->assign("kom_nickf", $kom_nickf);
$smarty->assign("kom_nickn", $kom_nickn);
$smarty->assign("kom_idu", $kom_idu);
$smarty->assign("kom_tresc", $kom_tresc);
$smarty->assign("kom_ile", $kom_ile);
$smarty->assign("kom_del", $kom_del);
$smarty->assign("gt_id", $gt_id);
$smarty->assign("gt_nazwan", $gt_nazwan);
$Query = 'SELECT * FROM ' . $pre . 'strony ORDER by strony_id DESC ';
$result = db_query($Query) or die(db_error());
while ($row = db_fetch($result)) {
echo '<tr>
<td width="5%"';
if ($i % 2 == 0) {
echo ' bgcolor="#dddddd" ';
}
echo ' align="center">' . $row['strony_id'] . '</td>
<td width="65%"';
if ($i % 2 == 0) {
echo ' bgcolor="#dddddd" ';
}
echo ' align="center"><a href="index.php?page=strony&action=view&id=' . $row['strony_id'] . '" title="' . $lang['232'] . '">' . $row['strony_nazwa'] . '</a>
<br>
Adres: <textarea name="" style="width:400px;height:20px;">' . $ust['adres'] . 'page/' . $row['strony_id'] . '/' . namen($row['strony_nazwa']) . '</textarea>
</td>
<td width="10%"';
if ($i % 2 == 0) {
echo ' bgcolor="#dddddd" ';
}
echo ' align="center">';
if ($row['strony_wys'] == "1") {
echo '<img src="style/images/ok16.png" title="' . $lang['233'] . '">';
} else {
echo '<b title="' . $lang['234'] . '">---</b>';
}
echo '</td>
<td width="5%"';
if ($i % 2 == 0) {
echo ' bgcolor="#dddddd" ';
$Query = 'SELECT * FROM ' . $pre . 'zgloszenia ORDER by zg_id DESC';
$result = db_query($Query) or die(db_error());
while ($row = db_fetch($result)) {
echo '
<table>
<tr>
<td><a href="index.php?page=zgloszenia&id_del=' . $row['zg_id'] . '&v=delete">' . $lang['272'] . '</a></td>
<td></td>
</tr>
<tr>
<td>' . $lang['273'] . '</td>
<td><a href="user/' . namen(get_login_user($row['zg_kto'])) . '/' . $row['zg_kto'] . '">' . get_login_user($row['zg_kto']) . '</a></td>
</tr>
<tr>
<td>' . $lang['274'] . '</td>
<td><a href="user/' . namen(get_login_user($row['zg_kogo'])) . '/' . $row['zg_kogo'] . '">' . get_login_user($row['zg_kogo']) . '</a> - <a href="index.php?page=user&v=delete&id=' . $row['zg_kogo'] . '" onclick="return(potwierdz())"><img src="style/images/delete.png" title="' . $lang['277'] . '"></a></td>
</tr>
<tr>
<td>' . $lang['275'] . '</td>
<td>' . $row['zg_data'] . '</td>
</tr>
<tr>
<td>' . $lang['276'] . '</td>
<td>' . $row['zg_tresc'] . '</td>
</tr>
</table>
<hr>
';
$k++;
}
if ($k == "0") {
<?php
include "subheader.php";
$Query = 'SELECT * FROM ' . $pre . 'grupa ORDER by g_nazwa ASC';
$result = db_query($Query) or die(db_error());
while ($row = db_fetch($result)) {
$g_id[] = $row['g_id'];
$g_nazwan[] = namen($row['g_nazwa']);
$g_nazwa[] = $row['g_nazwa'];
$g_typ[] = $row['g_typ'];
$g_data[] = $row['g_data'];
$g_user[] = $row['g_user'];
$g_del[] = $row['g_del'];
}
$smarty->assign("g_id", $g_id);
$smarty->assign("g_typ", $g_typ);
$smarty->assign("g_nazwan", $g_nazwan);
$smarty->assign("g_nazwa", $g_nazwa);
$smarty->assign("g_data", $g_data);
$smarty->assign("g_user", $g_user);
$smarty->assign("g_del", $g_del);
$smarty->assign("go", $_GET['go']);
$smarty->assign("stan", $_GET['stan']);
$smarty->assign("title", $lang['590'] . ' - ' . $ust['nazwa']);
$smarty->display($ust['templates'] . '/grupy.tpl');
$kom_tresc[] = $row['kom_tresc'];
$kom_idu[] = $row['kom_idu'];
$kom_foto[] = get_user_foto($row['kom_idu']);
$kom_ile++;
}
if ($ust['ukv'] >= 1 and $_GET['id'] != $_SESSION['user_id'] and $_SESSION['user_id'] >= 1 and $_COOKIE['view_' . $_GET['id'] . ''] == "") {
$in = "INSERT INTO `" . $pre . "kv`(`kv_kto`,`kv_kogo`,`kv_data`) VALUES ('" . $_SESSION['user_id'] . "','" . $_GET['id'] . "',NOW())";
db_query($in);
setcookie("view_" . $_GET['id'] . "", $_GET['id'], time() + 86400, "/");
}
$Query = 'SELECT * FROM ' . $pre . 'user WHERE user_id="' . db_real_escape_string($_GET['id']) . '"';
$result = db_query($Query) or die(db_error());
while ($row = db_fetch($result)) {
$login = $row['user_login'];
$smarty->assign("login", $row['user_login']);
$smarty->assign("loginn", namen($row['user_login']));
$smarty->assign("id", $row['user_id']);
$smarty->assign("datao", $row['user_data_o']);
$smarty->assign("wiek", get_user_wiek($row['user_y']));
$smarty->assign("d", $row['user_d']);
$smarty->assign("m", $row['user_m']);
$smarty->assign("y", $row['user_y']);
$smarty->assign("profil_vip", $row['user_vip']);
$smarty->assign("profil_plec", get_user_plec($row['user_plec']));
$smarty->assign("user_plec", $row['user_plec']);
$smarty->assign("profil_wzrost", $row['user_wzrost']);
$smarty->assign("profil_kolor_oczu", $row['user_kolor_oczu']);
$smarty->assign("profil_kolor_wlosu", $row['user_kolor_wlosu']);
$smarty->assign("profil_budowa_ciala", get_dane($row['user_budowa_ciala'], $u_usr['lang'], $row['user_plec']));
$smarty->assign("profil_pale", $row['user_pale']);
$smarty->assign("profil_alkochol", $row['user_alkochol']);
$nr = 1;
}
$strona = $nr;
}
$ile = 36;
$start = ($strona - 1) * $ile;
$wykonaj = db_query($zapytanie) or die("Nie działa zapytanie" . $zapytanie);
$ile_rek = db_num_rows($wykonaj);
$podstron = ceil($ile_rek / $ile);
$zapytanie .= " LIMIT {$start},{$ile}";
$final = db_query($zapytanie) or die("Nie działa zapytanie końcowe");
$a = 0;
while ($row = db_fetch($final)) {
if ($_SESSION['user_id'] != $row['user_id']) {
$u_login[] = $row['user_login'];
$u_loginn[] = namen($row['user_login']);
$u_wiek[] = get_user_wiek($row['user_y']);
$u_img[] = $row['user_fotka'];
$u_id[] = $row['user_id'];
$u_woj[] = get_user_woj($row['user_woj']);
$u_miasto[] = $row['user_miasto'];
$u_plec[] = get_user_plec($row['user_plec']);
$u_plecnr[] = $row['user_plec'];
$u_online[] = get_user_online($row['user_id']);
}
}
}
$smarty->assign("u_login", $u_login);
$smarty->assign("u_loginn", $u_loginn);
$smarty->assign("u_wiek", $u_wiek);
$smarty->assign("u_img", $u_img);
<?php
session_start();
include "../db_connect.php";
include "../include/function.php";
include "../include/namen.php";
if ($_SESSION['user_id'] >= 1) {
if ($_POST['nazwa'] != "") {
$in = "INSERT INTO " . $pre . "grupa(`g_nazwa`, `g_user`, `g_typ`, `g_data`)VALUES('" . htmlspecialchars($_POST['nazwa']) . "', '" . $_SESSION['user_id'] . "', '" . htmlspecialchars($_POST['typ']) . "', NOW())";
db_query($in);
$idi = db_insert_id();
$del = md5($idi . "-" . rand(0, 200));
$up = "UPDATE " . $pre . "grupa SET g_del='" . $del . "' WHERE g_id='" . $idi . "'";
db_query($up);
$in = "INSERT INTO " . $pre . "czlonkowie(`c_user`, `c_g`, `c_akt`)VALUES('" . $_SESSION['user_id'] . "', '" . $idi . "', '1')";
db_query($in);
} else {
header("Location: ../grupy/create/pn/");
exit;
}
}
header("Location: ../grupa/" . $idi . "/" . namen($_POST['nazwa']) . "_add_g:ok");
