|
fusionBoard 4.x PL
|
| pio9a |
Dodany dnia 08.02.2011 21:31:28
|
Przedszkolak
Postów: 4
Data rejestracji: 04.01.2009 21:20
|
Jak to naprawić:
Dodatkowe informacje
Unknown column 'field_group' in 'where clause'
Edytowane przez Pieka dnia 08.02.2011 21:32:26
|
| |
|
|
| Wścibski Gość |
Dodany dnia 22.12.2024 23:21:07
|
Pan Kontekstualny
Postów: n^x
Data rejestracji: Zawsze
|
|
| IP: localhost |
|
|
| grzechx |
Dodany dnia 21.02.2011 17:32:37
|
Przedszkolak
Postów: 62
Ostrzeżeń: 2
Data rejestracji: 21.05.2009 17:24
|
Hej,
Próbowałem zainstalować FB ale przy instalacji pojawiał mi się problem z bazą danych, dlatego odinstalowałem FB i zainstalowałem ją ponownie. Teraz przy ponownej instalacji mam komunikat:
Table 'fusion79f66_fb_apply' already existsTable 'fusion79f66_fb_attachments' already existsTable 'fusion79f66_fb_awards' already existsTable 'fusion79f66_fb_bookmarks' already existsTable 'fusion79f66_fb_buddies' already existsTable 'fusion79f66_fb_forums' already existsTable 'fusion79f66_fb_forum_notify' already existsTable 'fusion79f66_fb_groups' already existsTable 'fusion79f66_fb_ignore' already existsTable 'fusion79f66_fb_invites' already existsTable 'fusion79f66_fb_labels' already existsTable 'fusion79f66_fb_posts' already existsTable 'fusion79f66_fb_rate' already existsTable 'fusion79f66_fb_rate_type' already existsTable 'fusion79f66_fb_settings' already existsTable 'fusion79f66_fb_threads' already existsTable 'fusion79f66_fb_titles' already existsTable 'fusion79f66_fb_users' already existsTable 'fusion79f66_fb_warn_rules' already existsDuplicate entry '1' for key 'PRIMARY'Duplicate entry '2' for key 'PRIMARY'Duplicate entry '3' for key 'PRIMARY'Duplicate entry '4' for key 'PRIMARY'Duplicate entry '5' for key 'PRIMARY'Unknown column 'field_group' in 'where clause'Unknown column 'field_group' in 'where clause'Duplicate column name 'user_title'Unknown column 'field_group' in 'where clause'Unknown column 'field_group' in 'where clause'Unknown column 'field_group' in 'field list'Nowa instalacja została zakończona.
A w zakładce ustawienia mam cztery ikony Fusionboard4, jak się tego pozbyć?
Wydaje mi się że problem z instalacją może wynikać z tego że stronę mam na serwerze Home.pl
|
| |
|
|
| QoTheGreat |
Dodany dnia 21.02.2011 18:55:23
|
Przedszkolak
Postów: 35
Pomógł: 1
Ostrzeżeń: 1
Data rejestracji: 18.01.2008 22:35
|
Fusionboard instaluje się poprzez specjalny skrypt. Może instalowałeś na stronie wtyczki w PA?
|
| |
|
|
| grzechx |
Dodany dnia 21.02.2011 20:04:33
|
Przedszkolak
Postów: 62
Ostrzeżeń: 2
Data rejestracji: 21.05.2009 17:24
|
Tak instalowałem w PA ale też przez podanie odpowiedniej ścieżki w oknie adresowym przeglądarki.
|
| |
|
|
| QoTheGreat |
Dodany dnia 21.02.2011 20:34:35
|
Przedszkolak
Postów: 35
Pomógł: 1
Ostrzeżeń: 1
Data rejestracji: 18.01.2008 22:35
|
Jak dodać dodatkowe kategorie pól profilu używając fusionboard4?
W profilu mam różne dziwne błędy pola się nie pojawiają a w zarejestruj wyświetlają się wszystkie, niektóre się dublują. Gdy jako admin edytuję profil też pola pojawiają się zdublowane:
Dodatkowe informacje
Posiadane gry: asdasd
Dodatkowe informacje
Posiadane gry: asdasd
Błędy pojawiły się po zaktualizowaniu PHP-Fusion z 7.00 na najnowszy.
Podmieniłem nowe pliki na stare z F4 .
Edit: Błąd rozwiązany http://www.php-fu...ost_159120
Edytowane przez QoTheGreat dnia 23.02.2011 01:08:42
|
| |
|
|
| matys28 |
Dodany dnia 27.02.2011 15:09:46
|
Przedszkolak
Postów: 6
Data rejestracji: 25.08.2010 19:21
|
Witam!
Mam mały problem - FB 4.02 popsuł rangi na forum.
Chodzi o to że jak dodam moderatora jakiegoś działu, to może przyklejać, zamykać, przenosić tematy, ale pod awatarem jest cały czas napis "Użytkownik" zamiast "Moderator". Po wyłączeniu FB w PA pod awatarem (na forum) jest napis "Moderator". Proszę o pomoc w rozwiązaniu tego problemu.
Pozdrawiam!
Pierwsze prawo motoru - Rozpędź się, a ściana sama się znajdzie! |
| |
|
|
| grzechx |
Dodany dnia 03.03.2011 22:21:11
|
Przedszkolak
Postów: 62
Ostrzeżeń: 2
Data rejestracji: 21.05.2009 17:24
|
Nie wiem dlaczego ale w panelu użytkownika w polu "dodatkowe informacje" mam:
Unknown column 'field_group' in 'where clause'
Próbowałem dodać dodatkowe pola ale też nie mogę.
Edytowane przez Pieka dnia 03.03.2011 22:34:23
|
| |
|
|
| Sony |
Dodany dnia 04.03.2011 12:38:31
|
Początkujący
Postów: 253
Pomógł: 19
Ostrzeżeń: 1
 v7.02.06
Data rejestracji: 19.04.2008 16:21
|
Zmień field_group na field_cat w pliku usercp.php
tjaa  |
| |
|
|
| grzechx |
Dodany dnia 04.03.2011 13:25:04
|
Przedszkolak
Postów: 62
Ostrzeżeń: 2
Data rejestracji: 21.05.2009 17:24
|
Sony, nie mam field_group w tym pliku.
Plik usercp.php wygląda tak
<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: setuser.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| Power Fusion Forum v.2.2.0
| Copyright © 2008-2009 Powered by .:MeF:.
| URL: http://x-iweb.ru/
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at http://www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "../maincore.php";
require_once FORUM."includes/function.php";
require_once THEMES."templates/header.php";
require_once LOCALE.LOCALESET."forum/main.php";
require_once LOCALE.LOCALESET."forum/usercp.php";
include LOCALE.LOCALESET."user_fields.php";
if (iMEMBER) {
$user_id = $userdata['user_id'];
$user_data = $userdata;
opentable($locale['CP100']);
nav_menu("main", false, false);
echo "<table cellpadding='0' cellspacing='1' width='100%' style='margin: 0.8em 0em 0em 0em;'>\n";
echo "<tr>\n";
echo "<td width='100%' valign='top'>\n";
echo "<div class='tbl-border' style='width:24%; float:left;'><div class='tbl2'>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl2'><a href='".FUSION_SELF."'><b>".$locale['CP101']."</b></a></td></tr>\n";
echo "</table>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl2'>".$locale['CP102']."</td></tr>\n";
echo "<tr><td class='tbl1'>";
echo "<div><img src='".THEME."images/bullet.gif' alt='' /><span> </span><a href='".FUSION_SELF."?pm&msg_send=0'>".$locale['CP103']."</a></div>\n";
echo "<div><img src='".FORUM."images/priv.png' alt='' style='vertical-align:middle; border: 0;' /><span> </span><a href='".FUSION_SELF."?pm&folder=inbox'>".$locale['CP104']."</a></div>\n";
echo "<div><img src='".FORUM."images/priv.png' alt='' style='vertical-align:middle; border: 0;' /><span> </span><a href='".FUSION_SELF."?pm&folder=outbox'>".$locale['CP105']."</a></div>\n";
echo "<div><img src='".THEME."images/bullet.gif' alt='' /><span> </span><a href='".FUSION_SELF."?pm&folder=archive'>".$locale['CP106']."</a></div>\n";
echo "<div><img src='".THEME."images/bullet.gif' alt='' /><span> </span><a href='".FUSION_SELF."?pm&folder=options'>".$locale['CP107']."</a></div>\n";
echo "</td></tr>\n";
echo "</table>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl2'>".$locale['CP108']."</td></tr>\n";
echo "<tr><td class='tbl1'>";
echo "<div><img src='".THEME."images/bullet.gif' alt='' /><span> </span><a href='".FUSION_SELF."?subscription=".$user_id."'>".$locale['CP109']."</a></div>\n";
echo "</td></tr>\n";
echo "</table>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl2'>".$locale['CP110']."</td></tr>\n";
echo "<tr><td class='tbl1'>";
echo "<div><img src='".THEME."images/bullet.gif' alt='' /><span> </span><a href='".FUSION_SELF."?editprofile=".$user_id."'>".$locale['CP111']."</a></div>\n";
echo "<div><img src='".THEME."images/bullet.gif' alt='' /><span> </span><a href='".FUSION_SELF."?editsignature=".$user_id."'>".$locale['CP112']."</a></div>\n";
echo "<div><img src='".THEME."images/bullet.gif' alt='' /><span> </span><a href='".FUSION_SELF."?editavatar=".$user_id."'>".$locale['CP113']."</a></div>\n";
echo "</td></tr>\n";
echo "</table>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
echo "<tr><td class='tbl2'>".$locale['CP114']."</td></tr>\n";
echo "<tr><td class='tbl1'>";
echo "<div><img src='".THEME."images/bullet.gif' alt='' /><span> </span><a href='".FUSION_SELF."?editattachments=".$user_id."'>".$locale['CP115']."</a></div>\n";
echo "<div><img src='".THEME."images/bullet.gif' alt='' /><span> </span><a href='".FUSION_SELF."?editpassword=".$user_id."'>".$locale['CP116']."</a></div>\n";
echo "</td></tr>\n";
echo "</table>\n";
echo "</div></div><div class='tbl-border' style='width:75%; float:right'><div class='tbl2'>\n";
if (isset($_GET['editprofile']) && isnum($_GET['editprofile']) && $_GET['editprofile'] == $user_id) {
if (!isset($_GET['editprofile']) || !isnum($_GET['editprofile'])) { redirect("index.php"); }
require_once LOCALE.LOCALESET."edit_profile.php";
if (isset($_GET['update_profile'])) {
$db_values = "";
$result = dbquery("SELECT * FROM ".DB_USER_FIELDS." WHERE field_name != 'user_sig' ORDER BY field_order");
if (dbrows($result)) {
$profile_method = "validate_update";
while($data = dbarray($result)) {
if (file_exists(LOCALE.LOCALESET."user_fields/".$data['field_name'].".php")) {
include LOCALE.LOCALESET."user_fields/".$data['field_name'].".php";
}
if (file_exists(INCLUDES."user_fields/".$data['field_name']."_include.php")) {
include INCLUDES."user_fields/".$data['field_name']."_include.php";
}
}
}
$result = dbquery("UPDATE ".DB_USERS." SET user_name='".$user_data['user_name']."'".$db_values." WHERE user_id='".$user_data['user_id']."'");
redirect("".FUSION_SELF."?editprofile=".$_GET['editprofile']."");
}
$offset_list = "";
for ($i = -13; $i < 17; $i++) {
if ($i > 0) { $offset = "+".$i; } else { $offset = $i; }
$offset_list .= "<option".($offset == $user_data['user_offset'] ? " selected='selected'" : "").">".$offset."</option>\n";
}
set_title($locale['CP111']." - ".$settings['sitename']);
echo "<form name='inputform' method='post' action='".FUSION_SELF."?editprofile=".$_GET['editprofile']."&update_profile'>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl2' colspan='2'><b>".$locale['CP111']."</b></td></tr>\n";
echo "</table>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl1'>\n";
$profile_method = "input";
$result2 = dbquery("SELECT * FROM ".DB_USER_FIELDS." WHERE field_cat != '4' GROUP BY field_cat");
while($data2 = dbarray($result2)) {
$result3 = dbquery("SELECT * FROM ".DB_USER_FIELDS." WHERE field_cat='".$data2['field_cat']."' AND field_name != 'user_sig' ORDER BY field_order");
if (dbrows($result3)) {
echo "</tr>\n";
while($data3 = dbarray($result3)) {
if (file_exists(LOCALE.LOCALESET."user_fields/".$data3['field_name'].".php")) {
include LOCALE.LOCALESET."user_fields/".$data3['field_name'].".php";
}
if (file_exists(INCLUDES."user_fields/".$data3['field_name']."_include.php")) {
include INCLUDES."user_fields/".$data3['field_name']."_include.php";
}
}
}
}
echo "<tr>\n<td align='center' colspan='2' class='tbl'><br />\n";
echo "<input type='submit' name='' value='".$locale['CP201']."' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
} else if (isset($_GET['editpassword']) && isnum($_GET['editpassword']) && $_GET['editpassword'] == $user_id) {
if (!isset($_GET['editpassword']) || !isnum($_GET['editpassword'])) { redirect("index.php"); }
require_once LOCALE.LOCALESET."edit_profile.php";
require_once LOCALE.LOCALESET."user_fields.php";
if (isset($_GET['update_profile'])) {
$user_name = trim(eregi_replace(" +", " ", $_POST['user_name']));
$user_email = trim(stripinput($_POST['user_email']));
$user_new_password = trim(stripinput($_POST['user_new_password']));
$user_new_password2 = trim(stripinput($_POST['user_new_password2']));
if (iADMIN) {
$user_new_admin_password = trim(stripinput($_POST['user_new_admin_password']));
$user_new_admin_password2 = trim(stripinput($_POST['user_new_admin_password2']));
} else {
$user_new_admin_password = "";
}
if ($user_name == "" || $user_email == "") {
$error .= $locale['430']."<br />\n";
} else {
if (preg_check("/^[-0-9A-Z_@\s]+$/i", $user_name)) {
if ($user_name != $user_data['user_name']) {
$result = dbquery("SELECT user_name FROM ".DB_USERS." WHERE user_name='".$user_name."' AND user_id<>'".$userdata['user_id']."'");
if (dbrows($result)) {
$error .= $locale['432']."<br />\n";
}
}
} else {
$error .= $locale['431']."<br />\n";
}
if (preg_check("/^[-0-9A-Z_\.]{1,50}@([-0-9A-Z_\.]+\.){1,50}([0-9A-Z]){2,4}$/i", $user_email)) {
if ($user_email != $user_data['user_email']) {
if ((isset($_POST['user_password'])) && md5(md5($_POST['user_password'])) == $user_data['user_password']) {
$result = dbquery("SELECT user_email FROM ".DB_USERS." WHERE user_email='".$user_email."'");
if (dbrows($result)) {
$error .= $locale['434']."<br />\n";
}
} else {
$error .= $locale['437']."<br />\n";
}
}
} else {
$error .= $locale['433']."<br />\n";
}
}
if ($user_new_password) {
if ((isset($_POST['user_password'])) && md5(md5($_POST['user_password'])) == $user_data['user_password']) {
if ($user_new_password2 != $user_new_password) {
$error .= $locale['435']."<br />";
} else {
if (!preg_match("/^[0-9A-Z@]{6,20}$/i", $user_new_password)) {
$error .= $locale['436']."<br />\n";
}
if ((md5(md5($user_new_password)) == md5(md5($user_new_admin_password))) || (md5(md5($user_new_password)) == $user_data['user_admin_password'])) {
$error .= $locale['439']."<br><br>\n";
}
}
} else {
$error .= $locale['437']."<br />\n";
}
}
if (iADMIN && $user_new_admin_password) {
if ($user_data['user_admin_password']) {
if ((!isset($_POST['user_admin_password'])) || md5(md5($_POST['user_admin_password'])) != $user_data['user_admin_password']) {
$error .= $locale['441']."<br />\n";
}
}
if (!$error) {
if ($user_new_admin_password2 != $user_new_admin_password) {
$error .= $locale['438']."<br />";
} else {
if (!preg_match("/^[0-9A-Z@]{6,20}$/i", $user_new_admin_password)) {
$error .= $locale['440']."<br />\n";
}
if ((md5(md5($user_new_admin_password)) == md5(md5($user_new_password))) || (md5(md5($user_new_admin_password)) == $user_data['user_password'])) {
$error .= $locale['439']."<br><br>\n";
}
}
}
}
$user_hide_email = isnum($_POST['user_hide_email']) ? $_POST['user_hide_email'] : "1";
if ($user_new_password) { $new_pass = " user_password='".md5(md5($user_new_password))."', "; } else { $new_pass = " "; }
if (iADMIN && $user_new_admin_password) { $new_admin_pass = " user_admin_password='".md5(md5($user_new_admin_password))."', "; } else { $new_admin_pass = " "; }
$result = dbquery("UPDATE ".DB_USERS." SET user_name='$user_name',".$new_pass.$new_admin_pass."user_email='$user_email', user_hide_email='$user_hide_email' WHERE user_id='".$user_data['user_id']."'");
redirect("".FUSION_SELF."?editpassword=".$_GET['editpassword']."");
}
set_title($locale['CP116']." - ".$settings['sitename']);
echo "<form name='inputform' method='post' action='".FUSION_SELF."?editpassword=".$_GET['editpassword']."&update_profile'>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl2' colspan='2'><b>".$locale['CP116']."</b></td></tr>\n";
echo "</table>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl1'>\n";
echo "<tr>\n<td align='center' colspan='2' class='tbl'>".$locale['CP203']."<br /><br />\n</td>\n</tr>\n";
echo "<tr>\n<td class='tbl'>".$locale['u001'].":<span style='color:#ff0000'>*</span></td>\n";
echo "<td class='tbl'><input type='text' name='user_name' value='".$user_data['user_name']."' maxlength='30' class='textbox' style='width:200px;' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl'>".$locale['420'].":</td>\n";
echo "<td class='tbl'><input type='password' name='user_password' maxlength='20' class='textbox' style='width:200px;' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl'>".$locale['u003'].":</td>\n";
echo "<td class='tbl'><input type='password' name='user_new_password' maxlength='20' class='textbox' style='width:200px;' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl'>".$locale['u004'].":</td>\n";
echo "<td class='tbl'><input type='password' name='user_new_password2' maxlength='20' class='textbox' style='width:200px;' /></td>\n";
echo "</tr>\n<tr>\n";
if (iADMIN) {
if ($user_data['user_admin_password']) {
echo "<td class='tbl2'>".$locale['421'].":</td>\n";
echo "<td class='tbl2'><input type='password' name='user_admin_password' maxlength='20' class='textbox' style='width:200px;' /></td>\n";
echo "</tr>\n<tr>\n";
}
echo "<td class='tbl2'>".$locale['422'].":</td>\n";
echo "<td class='tbl2'><input type='password' name='user_new_admin_password' maxlength='20' class='textbox' style='width:200px;' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl2'>".$locale['423'].":</td>\n";
echo "<td class='tbl2'><input type='password' name='user_new_admin_password2' maxlength='20' class='textbox' style='width:200px;' /></td>\n";
echo "</tr>\n<tr>\n";
}
echo "<td class='tbl'>".$locale['u005'].":<span style='color:#ff0000'>*</span></td>\n";
echo "<td class='tbl'><input type='text' name='user_email' value='".$user_data['user_email']."' maxlength='100' class='textbox' style='width:200px;' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td class='tbl'>".$locale['u006'].":</td>\n";
echo "<td class='tbl'><label><input type='radio' name='user_hide_email' value='1'".($user_data['user_hide_email'] == "1" ? " checked='checked'" : "")." />".$locale['u007']."</label> ";
echo "<label><input type='radio' name='user_hide_email' value='0'".($user_data['user_hide_email'] == "0" ? " checked='checked'" : "")." />".$locale['u008']."</label></td>\n";
echo "</tr>\n";
echo "<tr>\n<td align='center' colspan='2' class='tbl'><br />\n";
echo "<input type='hidden' name='user_hash' value='".$user_data['user_password']."' />\n";
echo "<input type='submit' name='' value='".$locale['CP201']."' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
} else if (isset($_GET['editavatar']) && isnum($_GET['editavatar']) && $_GET['editavatar'] == $user_id) {
if (!isset($_GET['editavatar']) || !isnum($_GET['editavatar'])) { redirect("index.php"); }
require_once LOCALE.LOCALESET."user_fields.php";
require_once LOCALE.LOCALESET."edit_profile.php";
if (isset($_GET['update_profile'])) {
$newavatar = $_FILES['user_avatar'];
$avatarext = strrchr($newavatar['name'],".");
$avatarname = substr($newavatar['name'], 0, strrpos($newavatar['name'], "."));
if (preg_check("/^[-0-9A-Z_\[\]]+$/i", $avatarname) && preg_check("/(\.gif|\.GIF|\.jpg|\.JPG|\.jpeg|\.JPEG|\.png|\.PNG)$/", $avatarext) && $newavatar['size'] <= 30720) {
$avatarname = $avatarname."[".$userdata['user_id']."]".$avatarext;
move_uploaded_file($newavatar['tmp_name'], IMAGES."avatars/".$avatarname);
chmod(IMAGES."avatars/".$avatarname,0644);
$set_avatar = $avatarname;
if ($size = @getimagesize(IMAGES."avatars/".$avatarname)) {
if ($size['0'] > 100 || $size['1'] > 100) {
createthumbnail($size['2'], IMAGES."avatars/".$avatarname, IMAGES."avatars/tmp_".$avatarname, 100, 100);
@unlink(IMAGES."avatars/".$avatarname);
rename(IMAGES."avatars/tmp_".$avatarname,IMAGES."avatars/".$avatarname);
} elseif (!verify_image(IMAGES."avatars/".$avatarname)) {
@unlink(IMAGES."avatars/".$avatarname);
$set_avatar = "";
}
} else {
@unlink(IMAGES."avatars/".$avatarname);
$set_avatar = "";
}
} else {
$set_avatar = "";
}
if (isset($_POST['del_avatar'])) {
@unlink(IMAGES."avatars/".$user_data['user_avatar']);
$set_avatar = "";
}
$result = dbquery("UPDATE ".DB_USERS." SET user_avatar='".$set_avatar."' WHERE user_id='".$user_data['user_id']."'");
redirect("".FUSION_SELF."?editavatar=".$_GET['editavatar']."");
}
set_title($locale['CP113']." - ".$settings['sitename']);
echo "<form name='inputform' method='post' action='".FUSION_SELF."?editavatar=".$_GET['editavatar']."&update_profile' enctype='multipart/form-data'>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl2' colspan='2'><b>".$locale['CP113']."</b></td></tr>\n";
echo "</table>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
echo "<tr>\n";
echo "<td class='tbl1' width='30%' height='105' align='center' valign='middle'>";
if ($user_data['user_avatar'] && file_exists(IMAGES."avatars/".$user_data['user_avatar'])) {
echo "<img src='".BASEDIR."images/avatars/".$user_data['user_avatar']."' alt='' />";
} else { echo "<img src='".get_forum_image("no_avatar")."' alt='' style='vertical-align:middle; border: 0;' />"; }
echo "</td>\n";
echo "<td width='70%' class='tbl1'>".$locale['CP204']."<br /><input type='checkbox' name='del_avatar' value='y' /> ".$locale['CP207']."";
echo "<input type='hidden' name='user_avatar' value='".$user_data['user_avatar']."' /><br />".$locale['CP205']."</td>";
echo "<tr><td class='tbl2' colspan='2'></td></tr>\n";
echo "<tr>\n";
echo "<td valign='top' class='tbl1'>".$locale['CP206']."</td>\n";
echo "<td class='tbl1'><span class='small2'><input type='file' name='user_avatar' class='textbox' style='width:200px;' /><br />\n";
echo "<span class='small2'>".$locale['u011']."</span><br />\n";
echo "<span class='small2'>".sprintf($locale['u012'], parsebytesize(30720), 100, 100)."</span></td>\n";
echo "</tr>\n";
echo "<tr>\n<td align='center' colspan='2' class='tbl1'><br />\n";
echo "<input type='submit' name='update_profile' value='".$locale['CP201']."' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
echo "</table>\n";
} else if (isset($_GET['editsignature']) && isnum($_GET['editsignature']) && $_GET['editsignature'] == $user_id) {
if (!isset($_GET['editsignature']) || !isnum($_GET['editsignature'])) { redirect("index.php"); }
if (isset($_GET['update_profile'])) {
$user_sig = trim(stripinput(censorwords($_POST['user_sig'])));
$result=dbquery("UPDATE ".DB_USERS." SET user_sig='".$user_sig."' WHERE user_id='".$user_data['user_id']."'");
redirect("".FUSION_SELF."?editsignature=".$_GET['editsignature']."");
}
require_once INCLUDES."bbcode_include.php";
set_title($locale['CP112']." - ".$settings['sitename']);
echo "<form name='inputform' method='post' action='".FUSION_SELF."?editsignature=".$_GET['editsignature']."&update_profile'>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl2' colspan='2'><b>".$locale['CP112']."</b></td></tr>\n";
echo "</table>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl2' colspan='2'>".$locale['CP202']."</td></tr>\n";
echo "<tr><td class='tbl1'><div>".nl2br(parseubb(parsesmileys($user_data['user_sig'])))."</div></td></tr>\n";
echo "</table>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
echo "<tr><td class='tbl2' colspan='2'>".$locale['CP208']."</td></tr>\n";
echo "<tr><td class='tbl1'>\n";
echo "<div class='tbl' style='width:98%'>".display_bbcodes("98%", "user_sig")."</div>\n";
echo "<textarea class='textbox' name='user_sig' cols='60' rows='15' style='width:98%'>".$user_data['user_sig']."</textarea></td></tr>\n";
echo "<tr>\n<td align='center' colspan='2' class='tbl1'><br />\n";
echo "<input type='submit' name='update_profile' value='".$locale['CP201']."' class='button' /></td>\n";
echo "</tr>\n</table>\n</form>\n";
} else if (isset($_GET['pm'])) {
require_once LOCALE.LOCALESET."messages.php";
$msg_settings = dbarray(dbquery("SELECT * FROM ".DB_MESSAGES_OPTIONS." WHERE user_id='0'"));
require_once FORUM."includes/privatmsg.php";
} else if (isset($_GET['subscription']) && isnum($_GET['subscription']) && $_GET['subscription'] == $user_id) {
if (!isset($_GET['subscription']) || !isnum($_GET['subscription'])) { redirect("index.php"); }
$result = dbquery ( "
select t.*, f.*, p.*, tu.user_id, tu.user_name, tu2.user_id as lastpost_id, tu2.user_name as lastpost_name, COUNT(post_id)-1 as replies from " . DB_THREAD_NOTIFY . " tn
left join " . DB_THREADS . " t on t.thread_id=tn.thread_id
left join " . DB_FORUMS . " f on f.forum_id=t.forum_id
left join " . DB_POSTS . " p on p.thread_id=t.thread_id
left join " . DB_USERS . " tu on tu.user_id=t.thread_author
left join " . DB_USERS . " tu2 on t.thread_lastuser = tu2.user_id
where tn.notify_user='".$userdata['user_id']."' and " . groupaccess ( 'forum_access' ) . "
group by p.thread_id order by tn.notify_status asc, t.thread_lastpost desc
" );
$rows = dbrows ( $result );
$unviewed = dbcount ( "(thread_id)", DB_THREAD_NOTIFY, "notify_user='" . $userdata ['user_id'] . "' and notify_status='0'" );
set_title($locale['CP210']." - ".$settings['sitename']);
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr>\n<td class='tbl2 navtitle' colspan='6'><b>".$locale['CP210']."</b> ($unviewed)</td>\n</tr>\n";
echo "</table>\n";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
if ($rows) {
echo "<tr>\n<td class='tbl1 bold' colspan='2' style='width:1%'> </td>\n";
echo "<td class='tbl1 bold'>".$locale['451']."</td>\n";
echo "<td class='tbl1 bold' style='width:1%;white-space:nowrap;'>".$locale['404']."</td>\n";
echo "<td class='tbl1 bold' style='width:1%;white-space:nowrap'>".$locale['454']."</td>\n";
echo "<td class='tbl1 bold' style='width:1%;white-space:nowrap'>".$locale['453']."</td>\n</tr>\n";
while ( $data = dbarray ( $result ) ) {
if ($data ['thread_locked']) {
$image = get_image ( "folderlock" );
$titlebold = "";
} else {
$thread_match = $data ['thread_id'] . "\|" . $data ['thread_lastpost'] . "\|" . $data ['forum_id'];
if ($data ['thread_lastpost'] > $lastvisited) {
if (iMEMBER && preg_match ( "(^\.{$thread_match}$|\.{$thread_match}\.|\.{$thread_match}$)", $userdata ['user_threads'] )) {
$image = get_image ( "folder" );
$titlebold = "";
} else {
$image = get_image ( "foldernew" );
$titlebold = "font-weight:bold;";
}
} else {
$image = get_image ( "folder" );
$titlebold = "";
}
}
echo "<tr>\n<td class='tbl1'><img src='$image' alt='' /></td>\n";
echo "<td class='tbl1'><img src='images/post_icons/".$data['thread_icon']."' alt='".$locale['PF600']."' style='border: 0;' /></td>\n";
$posts_per_page = $forum_settings['posts_num'];
$reps = ceil($data['thread_postcount'] / $posts_per_page);
$threadsubject = "<a href='viewthread.php?thread_id=".$data['thread_id']."'>".$data['thread_subject']."</a>";
if ($reps > 1) {
$ctr = 1; $pages = "";
while ($ctr <= $reps) {
$pnum = "<a href='viewthread.php?thread_id=".$data['thread_id']."&page=$ctr'>$ctr</a> ";
$post_page = "&page=$ctr";
$pages = $pages.$pnum; $ctr++;
}
$threadsubject .= "<br />(".$locale['455'].trim($pages).")";
$post_p = $post_page;
} else { $post_p = ""; }
echo "<td class='tbl2'>";
echo "<a href='" . FORUM . "viewthread.php?thread_id=" . $data ['thread_id'] . "' style='text-decoration:underline;'>" . $data ['thread_subject'] . "</a><br />\n";
echo "<a href='" . BASEDIR . "profile.php?lookup=" . $data ['user_id'] . "' class='alt'>" . $data ['user_name'] . "</a><br />\n";
echo "<a href='" . FORUM . "postify.php?post=off&forum_id=" . $data ['forum_id'] . "&thread_id=" . $data ['thread_id'] . "'>".$locale['CP209']."</a></td>\n";
echo "<td width='1%' class='tbl1' style='white-space:nowrap'>";
echo "<div style='float:left;'>".showdate("forumdate", $data['thread_lastpost'])."<br />\n";
echo "<span class='small'>".$locale['406']."<a href='".BASEDIR."profile.php?lookup=".$data['lastpost_id']."'>".$data['lastpost_name']."</a></span></div>\n";
echo "<div style='float:right;'><a href='forum/viewthread.php?thread_id=".$data['thread_id'].$post_p."#post_".$data['post_id']."' title='".$locale['PF658']."'><img alt='".$locale['PF658']."' src='images/new_post.gif' style='vertical-align:middle; border: 0;' /></a></div>\n";
echo "</td>\n";
echo "<td class='tbl2' style='text-align:center;'>" . number_format ( $data ['replies'] ) . "</td>\n";
echo "<td class='tbl1' style='text-align:center;'>" . number_format ( $data ['thread_views'] ) . "</td>\n</tr>\n";
}
} else {
echo "<tr>\n<td class='tbl1'>\n<div align='center'>".$locale['CP211']."</div>\n</td>\n</tr>\n";
}
echo "</table>\n";
} else if (isset($_GET['editattachments']) && isnum($_GET['editattachments']) && $_GET['editattachments'] == $user_id) {
if (!isset($_GET['editattachments']) || !isnum($_GET['editattachments'])) { redirect("index.php"); }
set_title($locale['CP115']." - ".$settings['sitename']);
if (isset($_GET['delattach']) && isnum($_GET['delattach'])) {
if (!isset($_GET['delattach']) || !isnum($_GET['delattach'])) { redirect("index.php"); }
$result = dbquery("SELECT * FROM ".DB_FORUM_ATTACHMENTS." WHERE attach_id='".$_GET['delattach']."'");
if (dbrows($result) != 0) {
$attach = dbarray($result);
@unlink(FORUM."attachments/".$attach['attach_name']);
$result2 = dbquery("DELETE FROM ".DB_FORUM_ATTACHMENTS." WHERE attach_id='".$_GET['delattach']."'");
}
} elseif(isset($_POST['delselect']) && $_POST['chk_mark']!="") {
if(is_array($_POST['chk_mark']) && count($_POST['chk_mark'])>1){
$result_attach_id="attach_id IN(".implode(',',$_POST['chk_mark']).")";
} else { $result_attach_id="attach_id=".$_POST['chk_mark'][0]; }
$result = dbquery("SELECT * FROM ".DB_FORUM_ATTACHMENTS." WHERE $result_attach_id");
if (dbrows($result) != 0) {
while($attach = dbarray($result)) { @unlink(FORUM."attachments/".$attach['attach_name']); }
$result2 = dbquery("DELETE FROM ".DB_FORUM_ATTACHMENTS." WHERE $result_attach_id");
}
}
if (!isset($_GET['rowstart']) || !isNum($_GET['rowstart'])) $_GET['rowstart'] = 0;
$result = dbquery("SELECT td.*,tdc.*, ttc.thread_subject FROM ".DB_FORUM_ATTACHMENTS." td
INNER JOIN ".DB_POSTS." tdc ON td.post_id=tdc.post_id
INNER JOIN ".DB_THREADS." ttc ON ttc.thread_id=tdc.thread_id
WHERE tdc.post_author = '".$_GET['editattachments']."'
ORDER BY attach_id LIMIT ".$_GET['rowstart'].",20"
);
$result2 = dbquery("SELECT td.post_id AS td_post_id, tdc.post_id
FROM ".DB_FORUM_ATTACHMENTS." td
INNER JOIN ".DB_POSTS." tdc ON td.post_id=tdc.post_id
WHERE tdc.post_author = '".$_GET['editattachments']."'"
);
$count = ""; $i = "";
while($data = dbarray($result2)) { $count = $data['td_post_id']; $i++; }
$rows = $i;
$total = $rows ? $rows : 0;
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl2' colspan='2'><b>".$locale['CP115']."</b></td></tr>\n";
echo "</table>\n";
echo "<table width='100%' cellspacing='1' cellpadding='0' class='tbl-border'>\n";
echo "<tr><td class='tbl1' colspan='3'>".sprintf($locale['CP212'], $total)."</td></tr>\n";
echo "</table>";
if (dbrows($result) != 0) {
echo "<form name='delattachall' method='post' action='".FUSION_SELF."?editattachments=".$_GET['editattachments']."'>";
echo "<table width='100%' align='center' cellpadding='0' cellspacing='1' class='tbl-border'><tr>";
echo "<td width='1%' class='tbl2'></td>";
echo "<td class='tbl2'>".$locale['CP213']."</td>";
echo "<td class='tbl2'>".$locale['CP215']."</td>";
echo "<td class='tbl2'>".$locale['CP214']."</td>";
echo "<td class='tbl2'>".$locale['CP226']."</td>";
echo "<td class='tbl2'>".$locale['CP216']."</td></tr>";
while($attach = dbarray($result)) {
$fileattach = FORUM."attachments/".$attach['attach_name'];
if ($attach['post_title']) { $title = $attach['post_title']; } else {$title = $attach['thread_subject']; }
echo "<tr><td class='tbl1'><input type='checkbox' name='chk_mark[]' value='".$attach['attach_id']."'></td>";
echo "<td class='tbl1'><a href='$fileattach'>".$attach['attach_name']."</a></td>";
echo "<td class='tbl1'><a href='".FORUM."viewthread.php?forum_id=".$attach['forum_id']."&thread_id=".$attach['thread_id']."&pid=".$attach['post_id']."#post_".$attach['post_id']."'>".trimlink($title, 30)."</a><br /><span class='small'>Îò ".showdate("forumdate",$attach['post_datestamp'])."</span></td>";
echo "<td class='tbl1'>".parsebytesize($attach['attach_size'])."</td>";
echo "<td class='tbl1' align='center'>".$attach['attach_count']."</td>";
echo "<td class='tbl1' align='center'><a href='".FUSION_SELF."?editattachments=".$_GET['editattachments']."&delattach=".$attach['attach_id']."' onclick='return Deletefile();'>".$locale['CP217']."</a></td></tr>";
}
echo "<tr><td colspan='9' class='tbl2'><span class='small'><input type='button' class='button' title='".$locale['CP218']."' onclick=\"javascript:setChecked('delattachall','chk_mark[]',1);\" value='".$locale['CP219']."'>
<input type='button' class='button' title='".$locale['CP220']."' onclick=\"javascript:setChecked('delattachall','chk_mark[]',0);\" value='".$locale['CP221']."'>
<input type='submit' class='button' name='delselect' onclick='return Deletefiles();' value='".$locale['CP222']."'></span></td></tr></table>";
echo "</form>\n";
echo "<script language='Javascript' type='text/javascript'>
function setChecked(frmName,chkName,val){
dml=document.forms[frmName];
len=dml.elements.length;
for(i=0;i<len;i++){
if(dml.elements[i].name==chkName){
dml.elements[i].checked=val;
}}}
function Deletefile() {
return confirm('".$locale['CP223']."');
}
function Deletefiles() {
return confirm('".$locale['CP224']."');
}
</script>";
if ($rows > 20) echo "<div align='center' style='margin-top:5px;'>
".makepagenav($_GET['rowstart'],20,$rows,3,FUSION_SELF."?editattachments=".$_GET['editattachments']."&")."
</div>";
} else {
echo "<table width='100%' cellspacing='1' cellpadding='0' class='tbl-border'>\n";
echo "<tr><td class='tbl1' align='center' style='margin-top:5px;'>".$locale['CP225']."</td></tr>\n";
echo "</table>";
}
} else if ($user_id != "0") {
$result = dbquery("SELECT * FROM ".DB_USERS." WHERE user_id='".$user_id."'");
set_title("Ìîé êàáèíåò - ".$settings['sitename']);
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl2' colspan='2'><b>".$locale['CP240']."</b></td></tr>\n";
echo "</table>\n";
echo "<table width='100%' cellspacing='1' cellpadding='0' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl1' colspan='3'>".$locale['CP227']."</td></tr>\n";
echo "<tr><td width='120px' class='tbl1' align='center' rowspan='4'>";
if ($user_data['user_avatar'] && file_exists(IMAGES."avatars/".$user_data['user_avatar'])) {
echo "<img src='".BASEDIR."images/avatars/".$user_data['user_avatar']."' alt='".$locale['CP237']."' />";
} elseif ($forum_settings['not_avatar'] == "1") { echo "<img src='".get_forum_image("no_avatar")."' alt='".$locale['CP238']."' style='vertical-align:middle; border: 0;' />\n"; }
echo "</td><td class='tbl1' style='width:50%;text-align:right;'>".$locale['CP228']."</td>\n<td class='tbl1'>".$userdata['user_email']."</td>\n</tr>\n";
echo "<tr>\n<td class='tbl2' style='width:50%;text-align:right;'>".$locale['CP229']."</td>\n<td class='tbl2'>".showdate("longdate", $userdata ['user_joined'])."</td>\n</tr>\n";
echo "<tr>\n<td class='tbl1' style='width:50%;text-align:right;'>".$locale['CP231']."</td>\n<td class='tbl1'>" . number_format ( ($userdata ['user_posts'] / ((time () - $userdata ['user_joined']) / (3600 * 24))), 1 ) . "</td>\n</tr>\n";
echo "<tr>\n<td class='tbl2' style='width:50%;text-align:right;'>".$locale['CP232']."</td>\n<td class='tbl2'>" . number_format ( $userdata ['user_posts'] ) . "</td>\n</tr>\n";
echo "</table>\n";
$result = dbquery ( "
select t.*, f.*, p.*, tu.user_id, tu.user_name, tu2.user_id as lastpost_id, tu2.user_name as lastpost_name, COUNT(post_id)-1 as replies from " . DB_THREAD_NOTIFY . " tn
left join " . DB_THREADS . " t on t.thread_id=tn.thread_id
left join " . DB_FORUMS . " f on f.forum_id=t.forum_id
left join " . DB_POSTS . " p on p.thread_id=t.thread_id
left join " . DB_USERS . " tu on tu.user_id=t.thread_author
left join " . DB_USERS . " tu2 on t.thread_lastuser = tu2.user_id
where tn.notify_user='".$user_id."' and ".groupaccess('forum_access')." and notify_status='0'
group by p.thread_id order by tn.notify_status asc, t.thread_lastpost desc
" );
$rows = dbrows ( $result );
$unviewed = dbcount ( "(thread_id)", DB_THREAD_NOTIFY, "notify_user='".$user_id."' and notify_status='0'" );
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr>\n<td class='tbl2 ' colspan='6'>".$locale['CP233']." ($unviewed)</td>\n</tr>\n";
if ($rows) {
echo "<tr>\n<td class='tbl1 bold' colspan='2' style='width:1%'> </td>\n";
echo "<td class='tbl1 bold'>".$locale['451']."</td>\n";
echo "<td class='tbl1 bold' style='width:1%;white-space:nowrap'>".$locale['404']."</td>\n";
echo "<td class='tbl1 bold' style='width:1%;white-space:nowrap'>".$locale['454']."</td>\n";
echo "<td class='tbl1 bold' style='width:1%;white-space:nowrap'>".$locale['453']."</td>\n</tr>\n";
while ( $data = dbarray ( $result ) ) {
if ($data ['thread_locked']) {
$image = get_image ( "folderlock" );
$titlebold = "";
} else {
$thread_match = $data ['thread_id'] . "\|" . $data ['thread_lastpost'] . "\|" . $data ['forum_id'];
if ($data ['thread_lastpost'] > $lastvisited) {
if (iMEMBER && preg_match ( "(^\.{$thread_match}$|\.{$thread_match}\.|\.{$thread_match}$)", $userdata ['user_threads'] )) {
$image = get_image ( "folder" );
$titlebold = "";
} else {
$image = get_image ( "foldernew" );
$titlebold = "font-weight:bold;";
}
} else {
$image = get_image ( "folder" );
$titlebold = "";
}
}
echo "<tr>\n<td class='tbl1'><img src='$image' alt='' /></td>\n";
echo "<td class='tbl1'><img src='images/post_icons/".$data['thread_icon']."' alt='".$locale['PF600']."' style='border: 0;' /></td>\n";
$posts_per_page = $forum_settings['posts_num'];
$reps = ceil($data['thread_postcount'] / $posts_per_page);
$threadsubject = "<a href='viewthread.php?thread_id=".$data['thread_id']."'>".$data['thread_subject']."</a>";
if ($reps > 1) {
$ctr = 1; $pages = "";
while ($ctr <= $reps) {
$pnum = "<a href='viewthread.php?thread_id=".$data['thread_id']."&page=$ctr'>$ctr</a> ";
$post_page = "&page=$ctr";
$pages = $pages.$pnum; $ctr++;
}
$threadsubject .= "<br />(".$locale['455'].trim($pages).")";
$post_p = $post_page;
} else { $post_p = ""; }
echo "<td class='tbl2'><span>";
echo "<a href='" . FORUM . "viewthread.php?thread_id=" . $data ['thread_id'] . "' style='text-decoration:underline;'>" . $data ['thread_subject'] . "</a></span><br />\n";
echo "<a href='" . BASEDIR . "profile.php?lookup=" . $data ['user_id'] . "' class='alt'>" . $data ['user_name'] . "</a><br />\n";
echo "<a href='" . FORUM . "postify.php?post=off&forum_id=" . $data ['forum_id'] . "&thread_id=" . $data ['thread_id'] . "'>".$locale['CP235']."</a></td>\n";
echo "<td width='1%' class='tbl1' style='white-space:nowrap'>";
echo "<div style='float:left;'>".showdate("forumdate", $data['thread_lastpost'])."<br />\n";
echo "<span class='small'>".$locale['406']."<a href='".BASEDIR."profile.php?lookup=".$data['lastpost_id']."'>".$data['lastpost_name']."</a></span></div>\n";
echo "<div style='float:right;'><a href='forum/viewthread.php?thread_id=".$data['thread_id'].$post_p."#post_".$data['post_id']."' title='".$locale['PF658']."'><img alt='".$locale['PF658']."' src='images/new_post.gif' style='vertical-align:middle; border: 0;' /></a></div>\n";
echo "</td>\n";
echo "<td class='tbl2' style='text-align:center;'>" . number_format ( $data ['replies'] ) . "</td>\n";
echo "<td class='tbl1' style='text-align:center;'>" . number_format ( $data ['thread_views'] ) . "</td>\n</tr>\n";
}
} else {
echo "<tr>\n<td class='tbl1'>\n<div align='center'>".$locale['CP234']."</div>\n</td>\n</tr>\n";
}
echo "<tr>\n<td class='tbl1' style='text-align:right;'colspan='6'>\n<a href='".FUSION_SELF."?subscription=".$user_id."'>".$locale['CP236']."</a>\n</td>\n</tr>\n";
echo "</table>";
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border' style='margin: 0em 0em 0.8em 0em'>\n";
echo "<tr><td class='tbl2' colspan='3'>".$locale['CP241']."</td></tr>\n";
$result = dbquery(
"SELECT m.*, u.user_id, u.user_name FROM ".DB_MESSAGES." m
LEFT JOIN ".DB_USERS." u ON m.message_from=u.user_id
WHERE message_to='".$userdata['user_id']."' AND message_folder='0' AND message_read='0'
ORDER BY message_datestamp DESC LIMIT 5"
);
if (dbrows($result)) {
echo "<tr>\n<td class='tbl2'><i>".$locale['451']."</i></td>\n";
echo "<td width='1%' class='tbl2' style='white-space:nowrap'><i>".$locale['CP239']."</i></td>\n";
echo "<td width='1%' class='tbl2' style='white-space:nowrap'><i>".$locale['CP245']."</i></td>\n</tr>\n";
while ($data = dbarray($result)) {
$message_subject = $data['message_subject'];
if (!$data['message_read']) { $message_subject = "<strong>".$message_subject."</strong>"; }
echo "<tr>\n<td class='tbl1'>\n";
echo "<a href='".FUSION_SELF."?pm&folder=inbox&msg_read=".$data['message_id']."'>".$message_subject."</a></td>\n";
echo "<td width='1%' class='tbl1' style='white-space:nowrap'><a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>\n";
echo "<td width='1%' class='tbl1' style='white-space:nowrap'>".showdate("shortdate", $data['message_datestamp'])."</td>\n</tr>\n";
}
} else { echo "<tr>\n<td class='tbl1' align='center'>".$locale['CP242']."</td></tr>\n"; }
echo "</table>\n";
$thanked = dbcount("(thanks_id)", DB_PREFIX."forum_thanks JOIN ".DB_POSTS." USING (post_id)", "post_author='".$user_id."'");
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";
echo "<tr><td class='tbl2' colspan='3'><div style='float:left'>".$locale['CP243']."</div><div style='float:right' class='small'>".sprintf($locale['CP244'], "{$thanked}")."</div></td></tr>\n";
$thanks = "";
$thanks_r = dbquery("SELECT post_id FROM ".DB_PREFIX."forum_thanks");
if (dbrows($thanks_r)) {
while ($data_th = dbarray($thanks_r)) { $thanks .= $data_th['post_id'].",0"; }
} else { $thanks = "0"; }
$result = dbquery(
"SELECT p.forum_id, p.thread_id, p.post_id, p.post_message, p.post_smileys, t.thread_author, p.post_title, p.post_datestamp, t.thread_subject, t.thread_views, t.thread_postcount, t.thread_icon, f.forum_name, f.forum_access, u.user_id, u.user_name, th.thanks_datestamp
FROM ".DB_POSTS." p
LEFT JOIN ".DB_THREADS." t ON t.thread_id = p.thread_id
LEFT JOIN ".DB_FORUMS." f ON f.forum_id=p.forum_id
LEFT JOIN ".DB_PREFIX."forum_thanks th ON th.post_id = p.post_id
LEFT JOIN ".DB_USERS." u ON th.user_id = u.user_id
WHERE p.post_id IN($thanks) AND ".groupaccess('f.forum_access')." AND p.post_author = '".$user_id."'
ORDER BY th.thanks_datestamp DESC LIMIT 10"
);
if (dbrows($result)) {
echo "<tr>\n<td class='tbl2'><i>".$locale['451']."</i></td>\n";
echo "<td width='20%' class='tbl2' style='white-space:nowrap'><i>".$locale['CP246']."</i></td>\n";
echo "<td width='20%' class='tbl2' style='white-space:nowrap'><i>".$locale['CP245']."</i></td>\n</tr>\n";
while ($data = dbarray($result)) {
echo "<tr>\n<td class='tbl1'>\n";
echo "<a href='viewthread.php?thread_id=".$data['thread_id']."&pid=".$data['post_id']."#post_".$data['post_id']."' title='".$data['thread_subject']."'>".$data['thread_subject']."</a></td>\n";
echo "<td width='1%' class='tbl1' style='white-space:nowrap'><a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>\n";
echo "<td width='1%' class='tbl1' style='white-space:nowrap'>".showdate("longdate", $data['thanks_datestamp'])."</td>\n</tr>\n";
}
} else { echo "<tr>\n<td class='tbl1' align='center'>".$locale['CP247']."</td></tr>\n"; }
echo "</table>\n";
}
echo "</div></div>\n";
echo "</td>\n</tr>\n</table>\n";
closetable();
} else {
require_once LOCALE.LOCALESET."forum/post.php";
set_title($locale['PF494']." - ".$settings['sitename']);
opentable($locale['PF494']);
require_once FORUM."includes/error_massege.php";
closetable();
}
require_once THEMES."templates/footer.php";
?>
|
| |
|
|
| Sony |
Dodany dnia 04.03.2011 15:45:02
|
Początkujący
Postów: 253
Pomógł: 19
Ostrzeżeń: 1
v7.02.06
Data rejestracji: 19.04.2008 16:21
|
Hmmm, może dlatego, że używasz Power Fusion Forum v.2.2.0, a to jest temat dotyczący fusionBoard 4.x
tjaa |
| |
|
|
| grzechx |
Dodany dnia 04.03.2011 16:05:40
|
Przedszkolak
Postów: 62
Ostrzeżeń: 2
Data rejestracji: 21.05.2009 17:24
|
Nie, używam FusionBoard 4.x , wcześniej miałem zainstalowany Power Fusion Forum. Może stąd te problemy.
|
| |
|
|
| Sony |
Dodany dnia 04.03.2011 17:30:11
|
Początkujący
Postów: 253
Pomógł: 19
Ostrzeżeń: 1
v7.02.06
Data rejestracji: 19.04.2008 16:21
|
W pliku, którym podałeś we wcześniejszym poście w 'Copyright' wyraźnie jest napisane: Power Fusion Forum v.2.2.0
Polecam wgrać ponownie pliki.
tjaa |
| |
|
|
| grzechx |
Dodany dnia 04.03.2011 18:13:03
|
Przedszkolak
Postów: 62
Ostrzeżeń: 2
Data rejestracji: 21.05.2009 17:24
|
Wgrałem nowe pliki i nic, a co ciekawe przy ponownej instalacji mam informacje że tabele już są zainstalowane.
A dodatkowo w ustawieniach mam :
Edytowane przez Pieka dnia 04.03.2011 22:15:11
|
| |
|
|
| krokiet19 |
Dodany dnia 09.03.2011 13:20:02
|
Przedszkolak
Postów: 65
Ostrzeżeń: 4
Data rejestracji: 18.02.2009 19:32
Złamana licencja
|
Również mam ten problem jak kolega wyżej.
Kolejne pytanie, jak podczas pisania posta na forum podczas wyboru emotoikonki chciałbym zmienić kolor tła w tej tabeli. Gdzie to mogę znaleźć?
Wiadomość doklejona:
Problem już rozwiązany, zrezygnowałem z fusionboard. Odinstalowałem wtyczkę, usnąłem tabele z bazy, podmieniłem na oryginalne pliki i mam problem tego typu, że jak kliknę na panel administratora to przenosi mnie na forum. Dlaczego? Co może być przyczyną? Proszę o pomoc bo powoli wątpię w ten support, że tu jest jakaś pomoc.
Edytowane przez krokiet19 dnia 14.03.2011 13:28:26
|
| |
|
|
| DWito11 |
Dodany dnia 26.04.2011 16:18:39
|
Przedszkolak
Postów: 15
Ostrzeżeń: 3
v7.01.06
Data rejestracji: 07.04.2011 18:52
|
Mam pytanie - jak zmienić szerokość kolumny Ostatni Post na głównej forum - chciałbym żeby zajmowała mniej miejsca bym mógł umieścić ikonki nie ograniczając miejsca na opis forum??
|
| |
|
|
| Azot |
Dodany dnia 28.05.2011 14:23:18
|
Przedszkolak
Postów: 7
Ostrzeżeń: 6
Data rejestracji: 05.11.2010 18:36
|
Sprawdzał ktoś czy działa po 7.02.XX?
|
| |
|
|
| rafalgt |
Dodany dnia 06.06.2011 14:53:24
|
Przedszkolak
Postów: 67
Ostrzeżeń: 3
v7.02.05
Data rejestracji: 30.10.2009 16:03
|
Witam. Zastanawiam się czy można by było dorzucić do forum małej ikonki przy nieprzeczytanych postach.
W tej chwili, jeśli mamy w jednym temacie trzy nieprzeczytane posty strona pokazuje nam odrazy ten ostatni, ale nie wiemy ile postów nowych nie przeczytaliśmy wcześniej.
http://zdrowo.inf...
A gdyby był jakiś mini obrazek przy nie przeczytanych postach wiedzielibyśmy że nie czytaliśmy tych postów.
Edytowane przez rafalgt dnia 15.10.2018 15:31:52
|
| |
|
|
| arlid |
Dodany dnia 18.06.2011 14:57:03
|
Początkujący
Postów: 150
Pomógł: 1
Ostrzeżeń: 2
Data rejestracji: 25.04.2007 13:35
|
Co do działania na v7.02.xx to instalowałem, i nie wiem czy to wina jakiejś wtyczki, ale mianowicie po napisaniu tematu, często forum jak gdyby "znikało", nie ma kategorii, nie ma nic, dopiero po zalogowaniu na konto Admina ponownie Forum jest widoczne. Czy przyczyna może tkwić w FB czy gdzieś indziej?
PS: Przepraszam za odświeżenie, spojrzałem nie na tę datę.
Edytowane przez arlid dnia 18.06.2011 14:58:15
|
| |
|
|
| Anemone |
Dodany dnia 25.01.2012 17:04:10
|
Przedszkolak
Postów: 3
Data rejestracji: 25.01.2012 16:35
|
Witam !
Jeżeli było już to pytanie to przepraszam, ale mam problem z fb4 
Jeżeli będzie potrzeba, mogę podać dane do serwera ftp .
Z góry dziękuję za pomoc .
|
| |
|
|
| cyfilis |
Dodany dnia 26.01.2012 00:46:05
|
Przedszkolak
Postów: 23
Ostrzeżeń: 1
Data rejestracji: 28.04.2010 12:54
|
|
| |
|
