<?php
ini_set("include_path", "/home/hromi1/kyberia/inc:/home/hromi1/kyberia/boxiky/");
include_once "kyberia.inc";
$database = new CLASS_KYBERIA();
$set = $database->query("select distinct email, login,password from user where user_active='yes'");
while ($set->next()) {
echo "<BR>" . $set->getString('login') . " :: " . $set->getString('email') . " :: " . $set->getString('password');
}
<?php
ini_set("include_path", "./inc:./boxiky/:./config:../inc:../boxiky/:../config");
include_once "kyberia.inc";
$database = new CLASS_KYBERIA();
$q = "select * from session";
$set = $database->query($q);
while ($set->next()) {
echo $set->getString('user_name') . " : " . $set->getString('friends_serial') . "<br>";
}
<?php
ini_set("include_path", "./inc:./boxiky/:./config:../inc:../boxiky/:../config");
include_once "kyberia.inc";
$database = new CLASS_KYBERIA();
$q = "select * from session";
$set = $database->query($q);
while ($set->next()) {
$user_id = $set->getString('user_id');
$q2 = "select friend_id from friends where user_id={$user_id}";
$set2 = $database->query($q2);
$friends_serial = "";
while ($set2->next()) {
$friends_serial .= $set2->getString('friend_id') . ";";
}
$database->query("update session set friends_serial='{$friends_serial}' where user_id={$user_id}");
echo $set->getString('user_name') . " : " . $set->getString('friends_serial') . "<br>";
}
?>
<body>
<?php
ini_set("include_path", "/home/hromi1/kyberia/inc:/home/hromi1/kyberia/boxiky/:/home/hromi1/kyberia/config/");
include_once "kyberia.inc";
$database = new CLASS_KYBERIA();
$event = $_POST['event'];
if ($event == 'accept') {
$email = $_POST['email'];
$mailbody = "zdravim ta clovece\ndocela rad ti oznamujem ze si bol(a) zaregistrovany(a) do diskusneho systemu kyberia.sk s loginom " . $_POST['login'] . "..takze ked chces, zaloguj sa dnu & uzivaj si kyberpriestor..help k systemu najdes tu: http://www.kyberia.sk/index.php?action=article&node_id=179.....ako prve by som ti asi poradil nastavit si ikonku v sekcii \"nastavenie\"...tot vse..\n\ns pozdravom\nhromi@kyberia.sk\n\n";
if (!empty($_POST['message'])) {
$mailbody .= "poznamka od registratora> " . $_POST['message'];
}
// mail("*****@*****.**",'registracia na kyberia.sk',$mailbody,"From: hromi@kyberia.sk\nReturn-path: kyberia@kyberia.sk");
mail($email, 'registracia na kyberia.sk', $mailbody, "From: kyberia@kyberia.sk\nReturn-path: kyberia@kyberia.sk");
$id = $_POST['id'];
$database->query("update user set user_active='yes' where id='{$id}'");
} elseif ($event == 'refuse') {
$email = $_POST['email'];
$mailbody = "zdravim ta clovece\nbohuzial ti musim oznamit ze si nebol zaregistrovany do systemu kyberia.sk....pokial mas este stale zaujem o to stat sa clenom kyberie, pokus sa znova, mozno budes mat tentokrat stastie,alebo budem mat empatickejsiu naladu ;-)\n\ns pozdravom hromi@kyberia.sk";
if (!empty($_POST['message'])) {
$mailbody .= "P.S> " . $_POST['message'];
}
mail($email, 'registracia na kyberia.sk', $mailbody, "From: kyberia@kyberia.sk\nReturn-path: kyberia@kyberia.sk");
echo $mailbody;
$id = $_POST['id'];
$database->query("delete from user where id='{$id}'");
} elseif ($event == 'delete') {
$database->query("delete from user where id='{$id}'");
}
echo "<table border=1><tr><td>id</td><td>login</td><td>web</td><td>info</td><td>change status</td></tr>";
$q = "select * from user where user_active!='yes' order by id desc";
<html><head>
<?php
ini_set("include_path", "/home/hromi1/kyberia/inc:/home/hromi1/kyberia/boxiky/");
include_once "kyberia.inc";
$database = new CLASS_KYBERIA();
$set = $database->query("select * from user order by id");
echo "<form method='post'><table>";
while ($set->next()) {
echo "<tr>";
echo "<td>", $set->getString('id'), "</td>";
echo "<td>", $set->getString('forum_name'), "</td>";
echo "<td>", $set->getString('login'), "</td>";
echo "</tr>";
}
echo "</table>";
<?php
echo "updating...";
ini_set("include_path", "../inc:../boxiky/:../config");
include_once "kyberia.inc";
$database = new CLASS_KYBERIA();
// that's all folks
$q4 = "update user set user_k='3'";
$database->query($q4);
/* inicializacia, uz netreba
$database->query("UPDATE k_logs SET k_amount=sign(k_amount)");
$database->query("UPDATE submissions SET submission_k=0");
$database->query("UPDATE dennik SET karma=0");
$r = $database->query("SELECT * FROM k_logs");
while($r->next()) {
if ($r->getString("node_type") == 'dennik')
$database->query("UPDATE dennik SET karma=karma+".$r->getString("k_amount")." WHERE id=".$r->getString('node_id'));
else
$database->query("UPDATE submissions SET submission_k=submission_k+".$r->getString("k_amount")." WHERE submission_id=".$r->getString('node_id'));
}
*/
?>
<html><head>
<?php
ini_set("include_path", "/home/hromi1/kyberia/inc:/home/hromi1/kyberia/boxiky/");
include_once "kyberia.inc";
$database = new CLASS_KYBERIA();
$set = $database->query("select user.login as login,forum.* from forum left join user on user.id=forum.forum_owner order by forum_id");
echo "<form method='post'><table>";
while ($set->next()) {
echo "<tr>";
echo "<td>", $set->getString('forum_id'), "</td>";
echo "<td>", $set->getString('forum_name'), "</td>";
echo "<td>", $set->getString('login'), "</td>";
echo "</tr>";
}
echo "</table>";
<?php
ini_set("include_path", "/home/hromi1/kyberia/inc:/home/hromi1/kyberia/boxiky/:/home/hromi1/kyberia/config");
include_once "kyberia.inc";
$database = new CLASS_KYBERIA();
$q = "select * from forum";
$set = $database->query($q);
while ($set->next()) {
$q = "select count(*) as pocet from submissions where forum_id='" . $set->getString('forum_id') . "'";
$set2 = $database->query($q);
$set2->next();
$q = "select submission_timestamp from submissions where forum_id='" . $set->getString('forum_id') . "' order by submission_timestamp desc limit 1";
$set3 = $database->query($q);
$set3->next();
$q = "update forum set last_submission='" . $set3->getString('submission_timestamp') . "', forum_submissions='" . $set2->getString('pocet') . "' where forum_id='" . $set->getString('forum_id') . "'";
echo $q . "<br>";
$database->query($q);
}
<?php
ini_set("include_path", "/home/hromi1/kyberia/inc:/home/hromi1/kyberia/boxiky/:/home/hromi1/kyberia/config");
include_once "kyberia.inc";
$database = new CLASS_KYBERIA();
$set = $database->query("alter table forum modify forum_public enum('private', 'public', 'moderated') default 'public'");
$set = $database->query("update user set admin = 'yes' where id = '840'");
<?php
include_once "../inc/kyberia.inc";
$database = new CLASS_KYBERIA();
$q = "select id_user from sessions where last<date_sub(NOW(),INTERVAL 1 HOUR)";
echo $q;
$set = $database->query($q);
while ($set->next()) {
$q = "update user set user_action='',user_mode='off',user_action_param_name='',user_action_param_id='',user_action_param_value='' where id='" . $set->getString('id_user') . "'";
echo $q;
$database->query($q);
$database->query("delete from sessions where id_user='******'id_user') . "'");
}
<?php
ini_set("include_path", "./inc:./boxiky/:./config:../inc:../boxiky/:../config");
include_once "kyberia.inc";
$database = new CLASS_KYBERIA();
//toto je povodne stanovenie dK podla charizmy
$q = "select count(*) as pocet,friend_id from friends group by friend_id ";
$q2 = "select count(*) as psubm,u.login as ulogin, u.id as uid, u.user_karma as ukarma, u.user_k as uk from submissions as s inner join user as u on \nu.id = s.submission_owner group by s.submission_owner";
$q3 = "select count(*) as psubmall,sum(s.submission_k) as allkarma from submissions as s, user as u where s.submission_owner=u.id";
//vynulovanie povodnych kariem
//co ak niekto zacne prispievat hrozne nahovno
$q4 = "update user set user_k='0'";
$database->query($q4);
$set = $database->query($q);
$set3 = $database->query($q3);
$set3->next();
$pomerall = $set3->getString('allkarma') / $set3->getString('psubmall');
//Vsetka karma v systeme
echo "allkarma: " . $set3->getString('allkarma') . "<br>";
//celkovy pocet prispevkov
echo "psubmall: " . $set3->getString('psubmall') . "<br>";
//pomer karmy na prispevok celek kyberky
echo "pomerall: " . $pomerall . "<br>";
//najprv sa stanovi dkarma podla charizmy
while ($set->next()) {
$q0 = "update user set charisma='" . $set->getString('pocet') . "' where id='" . $set->getString('friend_id') . "'";
echo $q0 . "<br>";
$database->query($q0);
$q0 = "update user set user_k='" . $set->getString('pocet') . "' where id='" . $set->getString('friend_id') . "'";
echo $q0 . "<br>";
$database->query($q0);
<?php
ini_set("include_path", "/home/hromi1/kyberia/inc:/home/hromi1/kyberia/boxiky/:/home/hromi1/kyberia/config");
include_once "kyberia.inc";
$database = new CLASS_KYBERIA();
$set = $database->query("update user set login = '******' where id = '2031'");
if ($user = $kyberia->isLogged()) {
$user_id = $user['user_id'];
$user_mode_message = $user['user_mode_message'];
if ($user['admin'] == 'yes') {
define('ADMIN', true);
} else {
define('ADMIN', false);
}
$user_name = $user['user_name'];
$user_status = $user['user_mode'];
$user_amount = $user['user_amount'];
$user_mail = $user['user_mail'];
$user_active_icons = $user['user_active_icons'];
$user_icons_in_forum = $user['user_icons_in_forum'];
$mail_name = $user['mail_name'];
$kyberia->query("UPDATE user SET last_click=NOW() WHERE id={$user_id}");
// friends
$fr_array = explode(";", $user['user_friends_serial']);
foreach ($fr_array as $frid) {
if (is_numeric($frid)) {
$friend_array[$frid] = $frid;
}
}
}
//toto uz nejak nepouzivame
//turns on error reporting for mr. admin
if ($user_id != 38 && $_GET['debug']) {
error_reporting(0);
}
//veci ak sa pristupuje do fora
if ($action == 'forum') {
