<?php
require_once "shared/cookies.php";
require_once "shared/functions.php";
require_once "shared/header.php";
require_once "shared/bbcodeParser.php";
?>
<?php
connect_to_database();
select_database();
if (isset($_GET['post']) && $_GET['post'] != "") {
if (get_num_rows("posts", "post_id", $_GET['post']) == 0) {
redirect_to("not_found.php");
} else {
$post_id = $_GET['post'];
$query = query_select("posts");
$query .= query_select_where("post_id", $post_id);
$post = get_array_from_db($query);
$post = $post[0];
}
}
if (!logged_in() || $_SESSION['acess_rank'] == "member" && $post['posted_by'] != $_SESSION['user_id']) {
redirect_to("no_permission.php");
}
?>
<div class="centerBox">
<div class="title">
Edit Post
function table_data_posts()
{
global $post_data;
$post_data = array();
$arr = get_postcnt_abs();
$nrows = get_num_rows();
$i = 0;
$sum = array_sum($arr);
foreach ($arr as $key => $value) {
if ($key) {
$post_data[$i]['post'] = $key;
$post_data[$i]['count'] = $value;
$post_data[$i++]['percent'] = round($value / $sum * 100, 2);
}
}
}
$query = "SELECT table_name FROM user_tables;";
//current user's tables
//"SELECT owner, table_name FROM all_tables;" for all tables
//"SELECT owner, table_name FROM dba_tables;" for ALL tables (requires DBA privilege/role)
$result = odbc_exec($client->get_connection(), $query);
if ($result === false) {
echo "<div class='error_message'>" . odbc_error() . ": " . odbc_errormsg() . "</div>";
}
?>
<div class="entries">
<div class="entry plus_sign">
<a href="?tables&action=edit"><div class="plus-sign"></div></a>
</div>
<?php
if ($result !== false) {
while (odbc_fetch_row($result)) {
$table_name = odbc_result($result, 1);
echo "<div class=\"entry\"" . ">\n";
echo "\t<a class=\"visibility_button\" href=\"?tables&action=delete&target=" . $table_name . "\"></a>\n";
echo "\t<a href=\"?tables&action=view&target=" . $table_name . "\">";
echo "\t\t<b>" . $table_name . "</b>\n";
echo "\t\t<span class=\"date\">" . get_num_rows($client, $table_name) . "</span>\n";
echo "\t</a>\n";
echo "</div>\n";
}
}
odbc_close($client->get_connection());
?>
</div>
<?php
require_once "shared/cookies.php";
require_once "shared/functions.php";
require_once "shared/header.php";
require_once "shared/bbcodeParser.php";
?>
<?php
connect_to_database();
select_database();
if (isset($_GET['user']) && $_GET['user'] != "") {
if (get_num_rows("users", "user_id", $_GET['user']) == 0) {
redirect_to("not_found.php");
} else {
$user_id = $_GET['user'];
$query = query_select("users");
$query .= query_select_where("user_id", $user_id);
$user = get_array_from_db($query);
$user = $user[0];
}
} else {
if (logged_in()) {
$user_id = $_SESSION['user_id'];
$query = query_select("users");
$query .= query_select_where("user_id", $user_id);
$user = get_array_from_db($query);
$user = $user[0];
} else {
redirect_to("not_found.php");
}
$message = $user->lang['PTT_ADD_TAGS_NO_TAGS'] . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], '<a href="' . $meta_info . '">', '</a>');
}
trigger_error($message);
break;
case 'search':
default:
$search_tag = utf8_normalize_nfc(request_var('tag', '', true));
if ($search_tag == '') {
$template->assign_vars(array('S_TAG_SEARCH_ACTION' => append_sid("{$phpbb_root_path}phpbb_topic_tagging.{$phpEx}", 'mode=search'), 'S_SEARCH_STRING' => $search_tag));
page_header($user->lang['PTT_TAGS_RESULT_TITLE']);
$template->set_filenames(array('body' => 'phpbb_topic_tagging_search.html'));
page_footer();
} else {
$start = request_var('start', 0);
$result_set = search_tags($search_tag, $start);
$topics_count = get_num_rows($search_tag);
$s_type_switch = 0;
if ($topics_count > 0) {
foreach ($result_set as $row) {
$topic_id = $row['topic_id'];
$forum_id = $row['forum_id'];
// This will allow the style designer to output a different header
// or even separate the list of announcements from sticky and normal topics
$s_type_switch_test = $row['topic_type'] == POST_ANNOUNCE || $row['topic_type'] == POST_GLOBAL ? 1 : 0;
// Replies
$replies = $auth->acl_get('m_approve', $forum_id) ? $row['topic_replies_real'] : $row['topic_replies'];
if ($row['topic_status'] == ITEM_MOVED) {
$topic_id = $row['topic_moved_id'];
$unread_topic = false;
} else {
$unread_topic = isset($topic_tracking_info[$topic_id]) && $row['topic_last_post_time'] > $topic_tracking_info[$topic_id] ? true : false;
<input type="hidden" name="forum_id" value="<?php
echo $forum['forum_id'];
?>
">
<input type="submit" name="submit" value="Update" class="button">
</td>
</tr>
</form>
<form method="post" action="validation.php">
<tr>
<td>Change Position</td>
<td>
<select name="new_position" class="text">
<?php
$forum_num = get_num_rows("forums", "section_id", $forum['section_id']);
for ($i = 1; $i <= $forum_num; $i++) {
echo "<option value=\"{$i}\" ";
if ($i == $forum['position']) {
echo "selected";
}
echo "> {$i} </option>";
}
?>
</select>
</td>
<td>
<input type="hidden" name="action" value="update_forum_position">
<input type="hidden" name="forum_id" value="<?php
echo $forum['forum_id'];
?>
<?php
require_once "shared/cookies.php";
require_once "shared/functions.php";
require_once "shared/header.php";
require_once "shared/bbCodeParser.php";
connect_to_database();
select_database();
if (!isset($_GET['thread']) || $_GET['thread'] == "" || get_num_rows("threads", "thread_id", $_GET['thread']) == 0) {
redirect_to("not_found.php");
}
$thread_id = $_GET['thread'];
$query = query_select("posts");
$query .= query_select_where("thread_id", $thread_id);
$query .= query_select_order("time_posted", "ASC");
$posts = get_array_from_db($query);
$thread_author = get_value_from_db("threads", "author_id", "thread_id", $thread_id);
$thread_locked = get_value_from_db("threads", "locked", "thread_id", $thread_id);
//if the thread is locked, no one is allowed to post
if (logged_in() && !$thread_locked) {
echo "<form method=\"post\" action=\"new_post.php\">";
echo "<input type=\"hidden\" name=\"thread_id\" value=\"{$thread_id}\" >";
echo "<input type=\"submit\" name=\"submit\" value=\"+ Reply to this thread\" class=\"button plus\">";
echo "</form>";
}
echo "<div class=\"listBoxOuter\">";
echo "<div class=\"listBoxTitle\">";
if ($thread_locked) {
echo "<span class=\"locked\">";
echo "<img src=\"images/lock.png\" width=\"20\" height=\"25\" title=\"This Thread is locked.\" style=\"vertical-align:bottom\">";
echo "</span>";
die("Error executing query: " . mysql_error());
}
$query = " UPDATE forums SET position = ( SELECT @pos := @pos + 1 ) WHERE section_id = {$section_id} ORDER BY position ASC ";
$result = mysql_query($query, $connection);
if (!$result) {
die("Error executing query: " . mysql_error());
}
close_connection($connection);
redirect_to("index_.php");
}
//delete section
if ($_POST['submit'] == "Delete" && $_POST['action'] == "delete_section") {
connect_to_database();
select_database();
$section_id = $_POST['section_id'];
if (get_num_rows("forums", "section_id", $section_id) == 0) {
//means that the section is empty
$query = " DELETE FROM sections\n\t\t\t\t\t\tWHERE section_id = {$section_id}\n\t\t\t";
$result = mysql_query($query, $connection);
if (!$result) {
die("Database query failed: " . mysql_error());
}
} else {
$query = "\n\t\t\t\tDELETE FROM \n\t\t\t\t sections, forums, threads, posts \n\t\t\t\tUSING \n\t\t\t\t sections\n\t\t\t\tJOIN \n\t\t\t\t forums ON sections.section_id = forums.section_id\n\t\t\t\tJOIN \n\t\t\t\t threads ON forums.forum_id = threads.forum_id\n\t\t\t\tJOIN \n\t\t\t\t posts ON threads.thread_id = posts.thread_id\n\t\t\t\tWHERE \n\t\t\t\t sections.section_id = {$section_id}\n\t\t\t";
$result = mysql_query($query, $connection);
if (!$result) {
die("Database query failed: " . mysql_error());
}
if (mysql_affected_rows($connection) == 0) {
//means that all forums inside this section is empty
//deletes section manually
echo "{$section['section_name']}";
echo "</div>";
echo "<table class=\"listBoxTable\">";
echo "<tr>";
echo "<th style=\"width:800px\">Forum</th>";
echo "<th style=\"width:150px\">Threads</th>";
echo "</tr>";
if (empty($forums)) {
echo "<tr><td colspan=\"2\" class=\"center\">Section empty.</td></tr>";
} else {
foreach ($forums as $forum) {
echo "<tr>";
echo "<td class=\"table_name\">";
if ($forum['locked']) {
echo "<span class=\"locked\">";
echo "<img src=\"images/lock.png\" width=\"20\" height=\"25\" title=\"This Forum is locked.\" style=\"vertical-align:bottom\">";
echo "</span>";
}
echo "<a href=\"forum.php?forum={$forum['forum_id']}\">{$forum['forum_name']}</a><br />";
echo "<div class=\"description\">{$forum['description']}</div>";
echo "</td>";
echo "<td class=\"table_thread\">" . get_num_rows("threads", "forum_id", $forum['forum_id']) . "</td>";
echo "</tr>";
}
}
echo "</table>";
echo "<div class=\"listBottom\">";
echo "</div>";
echo "</div>";
}
require_once "shared/footer.php";
}
echo get_value_from_db("forums", "forum_name", "forum_id", $forum_id);
echo "</div>";
echo "<table class=\"listBoxTable\">";
echo "<tr>";
echo "<th style=\"width:850px\">Thread</th>";
echo "<th style=\"width:150px\">Replies</th>";
echo "<th style=\"width:300px\">Last Post</th>";
echo "</tr>";
if (empty($threads)) {
echo "<tr><td colspan=\"3\" class=\"center bold\">There are currently no threads in this forum.</td></tr>";
} else {
foreach ($threads as $thread) {
$poster_id = $thread['author_id'];
$last_poster_id = get_value_from_db("posts", "posted_by", "post_id", $thread['last_post_id']);
$num_of_threads = get_num_rows("posts", "thread_id", $thread['thread_id']) - 1;
$last_post = "#" . $thread['last_post_id'];
echo "<tr>";
echo "<td class=\"table_name\">";
if ($thread['locked']) {
echo "<span class=\"locked\">";
echo "<img src=\"images/lock.png\" width=\"20\" height=\"25\" title=\"This Thread is locked.\" style=\"vertical-align:bottom\">";
echo "</span>";
}
echo "<a href=\"thread.php?thread={$thread['thread_id']}\">{$thread['thread_name']}</a>";
echo "<div class=\"description\">by <a href=\"profile.php?user={$poster_id}\">" . get_value_from_db("users", "username", "user_id", $poster_id) . "</a></div>";
echo "</td>";
echo "<td class=\"table_thread\">" . $num_of_threads . "</td>";
echo "<td class=\"table_thread\">";
echo "<a href=\"profile.php?user={$last_poster_id}\">" . get_value_from_db("users", "username", "user_id", $last_poster_id) . "</a>";
echo "<a href=\"thread.php?thread={$thread['thread_id']}{$last_post}\">>></a><br />";
<div class="table_panel"> <h1><?php echo $target; ?> </h1> <span><?php echo get_num_rows($client, $target); ?> </span> <!-- TODO get edit table button working --> <a class="button delete" href=<?php echo "\"?tables&action=delete&target=" . $target . "\""; ?> ></a> <a class="button edit" href=<?php echo "\"?tables&action=edit&target=" . $target . "\""; ?> ></a> <a class="button add" href=<?php echo "\"?tables&action=add_entry&target=" . $target . "\""; ?> ><div class="plus-sign"></div></a> </div> <div id="save_message" style="display: none;"></div> <?php $query = "select ROWID, a.* from " . $target . " a where rownum<50;"; $result = odbc_exec($client->get_connection(), $query); make_results_table($result, false, $target); ?>
function submit_create_action($sql)
{
//Führt eine Create-Anweisung durch und ermittelt danach die Anzahl der aktuellen Spalten
// und legt diese im Array ab
global $restore;
$tablename = get_tablename($sql);
if (DEBUG) {
echo "<br>Tabellenname: " . $tablename;
echo "<br>Create: " . $sql;
}
$res = mysql_query($sql);
if (!$res === false) {
if (DEBUG) {
echo "<br>Create-Anweisung erfolgreich ausgeführt.";
}
$restore['actual_table'] = $tablename;
$restore['table_ready']++;
} else {
//erster Versuch die Tabelle anzulegen hat nicht geklappt
// versuchen wir es mal mit der alten Syntax
$res = mysql_query(downgrade($sql));
if (!$res === false) {
if (DEBUG) {
echo "<br>Create-Anweisung nach Downgrade erfolgreich ausgeführt.";
}
$restore['actual_table'] = $tablename;
$restore['table_ready']++;
} else {
SQLError($sql, 'Couldn\'t create table: ' . $tablename);
die;
}
}
return get_num_rows($tablename);
}
