}
                 }
                 // zmena a odeslani emailu nebo vypis chyb
                 if (count($errors) == 0) {
                     $newpass = _md5Salt(_wordGen());
                     $text_tags = array("*domain*", "*username*", "*newpass*", "*date*", "*ip*");
                     $text_contents = array(_getDomain(), $userdata['username'], $newpass[2], _formatTime(time()), _userip);
                     if (_mail($userdata['email'], str_replace('*domain*', _getDomain(), $_lang['mod.lostpass.mail.subject']), str_replace($text_tags, $text_contents, $_lang['mod.lostpass.mail.text2']), "Content-Type: text/plain; charset=UTF-8\n" . _sysMailHeader())) {
                         DB::query("UPDATE `" . _mysql_prefix . "-users` SET password='******', salt='" . $newpass[1] . "' WHERE id=" . $userdata['id']);
                         $module .= _formMessage(1, $_lang['mod.lostpass.generated']);
                     } else {
                         $module .= _formMessage(3, $_lang['hcm.mailform.msg.failure2']);
                     }
                     $done = true;
                 } else {
                     $module .= _formMessage(2, _eventList($errors, "errors"));
                     if ($badlink) {
                         _iplogUpdate(1);
                     }
                 }
             }
             // formular
             if (!$done and count($errors) == 0) {
                 $module .= _formOutput("lostpassform", "index.php?m=lostpass&amp;link&amp;user="******"&amp;hash=" . _htmlStr($hash), array(), array(), $_lang['mod.lostpass.generate'], "<input type='hidden' name='action' value='1' />");
             }
         }
     } else {
         $module .= _formMessage(2, str_replace(array("*1*", "*2*"), array(_maxloginattempts, _maxloginexpire / 60), $_lang['login.attemptlimit']));
     }
     break;
 default:
            // vynulovani
            if ($reset) {
                DB::query("UPDATE `" . _mysql_prefix . "-polls` SET votes='" . trim(str_repeat("0-", $answers_count), "-") . "' WHERE id=" . $id);
                DB::query("DELETE FROM `" . _mysql_prefix . "-iplog` WHERE type=4 AND var=" . $id);
            }
            // presmerovani
            define('_redirect_to', 'index.php?p=content-polls-edit&id=' . $id . '&saved');
            return;
        } else {
            DB::query("INSERT INTO `" . _mysql_prefix . "-polls` (author,question,answers,locked,votes) VALUES (" . $author . ",'" . $question . "','" . $answers . "'," . $locked . ",'" . trim(str_repeat("0-", $answers_count), "-") . "')");
            $newid = DB::insertID();
            define('_redirect_to', 'index.php?p=content-polls-edit&id=' . $newid . '&created');
            return;
        }
    } else {
        $message = _formMessage(2, _eventList($errors, 'errors'));
    }
}
/* ---  vystup  --- */
if ($continue) {
    // vyber autora
    if (_loginright_adminpollall) {
        $author_select = "\n    <tr>\n    <td class='rpad'><strong>" . $_lang['article.author'] . "</strong></td>\n    <td>" . _admin_authorSelect("author", $query['author'], "adminpoll=1", "selectmedium") . "</td></tr>\n    ";
    } else {
        $author_select = "";
    }
    // zprava
    if (isset($_GET['saved'])) {
        $message = _formMessage(1, $_lang['global.saved']);
    }
    if (isset($_GET['created'])) {
    }
    /* ---  vystup  --- */
    // pole souvisejicich polozek
    $content_array = array();
    switch ($query['type']) {
        case 1:
            $content_array[] = DB::result(DB::query("SELECT COUNT(id) FROM `" . _mysql_prefix . "-posts` WHERE type=1 AND home=" . $id), 0) . " " . $_lang['admin.content.delete.comments'];
            break;
        case 2:
            $content_array[] = DB::result(DB::query("SELECT COUNT(id) FROM `" . _mysql_prefix . "-articles` WHERE home1=" . $id . " AND home2=-1 AND home3=-1"), 0) . " " . $_lang['admin.content.delete.articles'];
            break;
        case 3:
            $content_array[] = DB::result(DB::query("SELECT COUNT(id) FROM `" . _mysql_prefix . "-posts` WHERE type=3 AND home=" . $id), 0) . " " . $_lang['admin.content.delete.posts'];
            break;
        case 5:
        case 3:
            $content_array[] = DB::result(DB::query("SELECT COUNT(id) FROM `" . _mysql_prefix . "-images` WHERE home=" . $id), 0) . " " . $_lang['admin.content.delete.images'];
            break;
        case 8:
            $content_array[] = DB::result(DB::query("SELECT COUNT(id) FROM `" . _mysql_prefix . "-posts` WHERE type=5 AND home=" . $id), 0) . " " . $_lang['admin.content.delete.posts'];
            break;
        case 9:
            _extend('call', 'ppage.' . $query['type_idt'] . '.delete.confirm', array('contents' => &$content_array, 'query' => $query));
            break;
        default:
            $content_array[] = $_lang['admin.content.delete.norelated'];
    }
    $output .= "\n    <p class='bborder'>" . $_lang['admin.content.delete.p'] . "</p>\n    <h2>" . $_lang['global.item'] . " <em>" . $query['title'] . "</em></h2><br />\n    " . (!empty($content_array) ? "<p>" . $_lang['admin.content.delete.contentlist'] . ":</p>" . _eventList($content_array) . "<div class='hr'><hr /></div>" : '') . "\n\n    <form class='cform' action='index.php?p=content-delete&amp;id=" . $id . "' method='post'>\n    <input type='hidden' name='confirm' value='1' />\n    <input type='submit' value='" . $_lang['admin.content.delete.confirm'] . "' />\n    " . _xsrfProtect() . "</form>\n    ";
} else {
    $output .= _formMessage(3, $_lang['global.badinput']);
}
            }
            // zprava
            if ($done != 0) {
                $output .= _formMessage(1, str_replace(array("*done*", "*total*"), array($done, $item_total), $_lang['admin.other.massemail.send']));
            } else {
                $output .= _formMessage(2, $_lang['admin.other.massemail.noreceiversfound']);
            }
        } else {
            // vypis emailu
            $emails_total = DB::size($query);
            if ($emails_total != 0) {
                $emails = '';
                $email_counter = 0;
                while ($item = DB::row($query)) {
                    ++$email_counter;
                    $emails .= $item['email'];
                    if ($email_counter !== $emails_total) {
                        $emails .= ',';
                    }
                }
                $output .= _formMessage(1, "<textarea class='areasmallwide' rows='9' cols='33' name='list'>" . $emails . "</textarea>");
            } else {
                $output .= _formMessage(2, $_lang['admin.other.massemail.noreceiversfound']);
            }
        }
    } else {
        $output .= _formMessage(2, _eventList($errors, 'errors'));
    }
}
/* ---  vystup  --- */
$output .= "\n<br />\n<form class='cform' action='index.php?p=other-massemail' method='post'>\n<table class='formtable'>\n\n<tr>\n<td class='rpad'><strong>" . $_lang['admin.other.massemail.sender'] . "</strong></td>\n<td><input type='text' name='sender'" . _restorePostValue("sender", _sysmail) . " class='inputbig' /></td>\n</tr>\n\n<tr>\n<td class='rpad'><strong>" . $_lang['posts.subject'] . "</strong></td>\n<td><input type='text' name='subject' class='inputbig'" . _restorePostValue("subject") . " /></td>\n</tr>\n\n<tr class='valign-top'>\n<td class='rpad'><strong>" . $_lang['admin.other.massemail.receivers'] . "</strong></td>\n<td>" . _admin_authorSelect("receivers", -1, "1", "selectbig", null, true, 4) . "</td>\n</tr>\n\n<tr>\n<td class='rpad'><strong>" . $_lang['admin.other.massemail.ctype'] . "</strong></td>\n<td>\n  <select name='ctype' class='selectbig'>\n  <option value='1'>" . $_lang['admin.other.massemail.ctype.1'] . "</option>\n  <option value='2'" . ((isset($_POST['ctype']) and $_POST['ctype'] == 2) ? " selected='selected'" : '') . ">" . $_lang['admin.other.massemail.ctype.2'] . "</option>\n  </select>\n</td>\n</tr>\n\n<tr class='valign-top'>\n<td class='rpad'><strong>" . $_lang['admin.other.massemail.text'] . "</strong></td>\n<td><textarea name='text' class='areabig' rows='9' cols='94'>" . _restorePostValue("text", null, true) . "</textarea></td>\n</tr>\n\n<tr><td></td>\n<td><input type='submit' value='" . $_lang['global.send'] . "' />&nbsp;&nbsp;<label><input type='checkbox' name='maillist' value='1'" . _checkboxActivate(_checkboxLoad("maillist")) . " /> " . $_lang['admin.other.massemail.maillist'] . "</label></td>\n</tr>\n\n</table>\n" . _xsrfProtect() . "</form>\n";
             }
             if ($usernamechange == true) {
                 DB::query("UPDATE `" . _mysql_prefix . "-users` SET username='******' WHERE id=" . $query['id']);
             }
             _extend('call', 'user.edit', array('id' => $query['id'], 'username' => $username));
             define('_redirect_to', 'index.php?p=users-edit&r=1&id=' . $username);
             return;
         } else {
             // vytvoreni
             DB::query("INSERT INTO `" . _mysql_prefix . "-users` (`group`,levelshift,username,publicname,password,salt,logincounter,registertime,activitytime,blocked,massemail,wysiwyg,ip,email,web,skype,msn,jabber,icq,note) VALUES (" . $group . "," . $levelshift . ",'" . $username . "','" . $publicname . "','" . $password[0] . "','" . $password[1] . "',0," . time() . ",0," . $blocked . ",1,0,'','" . $email . "','" . $web . "','" . $skype . "','" . $msn . "','" . $jabber . "'," . $icq . ",'" . $note . "')");
             _extend('call', 'user.new', array('id' => DB::insertID(), 'username' => $username));
             define('_redirect_to', 'index.php?p=users-edit&r=2&id=' . $username);
             return;
         }
     } else {
         $message = _eventList($errors, 'errors');
     }
 }
 /* ---  vystup  --- */
 // zpravy
 $messages_code = "";
 if (isset($_GET['r'])) {
     switch ($_GET['r']) {
         case 1:
             $messages_code .= _formMessage(1, $_lang['global.saved']);
             break;
         case 2:
             $messages_code .= _formMessage(1, $_lang['global.created']);
             break;
     }
 }
Beispiel #6
0
        }
        // vypnuti auto_incrementu pri nulovych hodnotach
        DB::query('SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"');
        // vytvoreni nove struktury
        $pass = _md5Salt($pass);
        $url = DB::esc(_htmlStr($url));
        $email = DB::esc($email);
        require 'data.php';
        // zprava
        if ($sql_error == false) {
            $msg = "<font style='color:green;'>Zdá se, že databáze byla úspěšně nainstalována. Smažte adresář <em>install</em> ze serveru.</font>";
        } else {
            $msg = "Během vyhodnocování SQL dotazů nastala chyba:<hr />" . _htmlStr($sql_error) . '<hr />SQL dotaz:<br />' . _htmlStr($line);
        }
    } else {
        $msg = _eventList($errors);
    }
}
/* --  zprava  -- */
if ($msg != "") {
    $msg = "<div id='message'><div>" . $msg . "</div></div><br />";
}
// vlozeni zacatku hlavicky
require '../require/headstart.php';
?>
<title>Instalace databáze SunLight CMS <?php 
echo _systemversion;
?>
</title>

<style type="text/css">