Hi, fantasma! It is difficult to correctly delete users and all their posts via SQL-console because you will need to track many changes in DB.
The way to minimize DB changes is to alter posts` author field to Guest for instead of deleted users.
To do so, for the posts written by the users you've just deleted. Your SQL query will look like:
UPDATE <DB_Prefix>_posts SET poster_id = 1 WHERE ID IN (<list of users id>)
1,176 2008-07-16 12:26
Re: [extension request] mass delete user (6 replies, posted in PunBB 1.3 extensions)
1,177 2008-07-15 05:59
Re: Users need to connect twice (14 replies, posted in PunBB 1.2 troubleshooting)
Cew27, if you have the same problem as TMuet does just delete file cache_config.php from directory <FORUM_ROOT>/cache/.
1,178 2008-07-10 13:05
Re: Only shows 1 topic in each forum..what to do? (1 replies, posted in PunBB 1.2 troubleshooting)
scarboy, please insert the code from the file viewtopic.php into the post for me to see it (you can use tag "Code" for this)
1,179 2008-07-10 06:42
Re: How to install pun_attachment extensions? (9 replies, posted in PunBB 1.3 extensions)
Hunglan, are there any messages or errors on the page when you upload the avatar?
1,180 2008-07-09 13:17
Re: pun_bbcode (13 replies, posted in PunBB 1.3 extensions)
New version of Pun BBCode available from SVN repository. Here you can see the changes
1,181 2008-07-09 05:48
Re: [HELP] install.php error [HELP] (2 replies, posted in General discussion)
Hi, RuKuZ! Make sure that in the directory "include/dblayer" there is a file named "mysql.php".
1,182 2008-07-08 12:28
Re: How to install pun_attachment extensions? (9 replies, posted in PunBB 1.3 extensions)
Hi, hunglan!
1- Are there any errors on the page or in the log file?
2- This post will help you to install the extension. You don't need to run install_function.php.
1,183 2008-07-02 10:52
Re: $type of extern.php (1 replies, posted in PunBB 1.3 troubleshooting)
We have taken your request into account and added a new hook to add a new type of output. You can see the changes here
1,184 2008-07-02 07:13
Re: Errors on /admin/extensions.php (8 replies, posted in PunBB 1.3 troubleshooting)
Maybe this link will help you
1,185 2008-07-01 10:08
Re: Displaying all of a users posts (4 replies, posted in Feature requests)
Hi! To see user's posts:
Go to <FORUM_ROOT>/search.php
Write the user's name, whos posts you want to see in "Author search" field
Then select "Posts" in "Show result as" list and click "Submit".
1,186 2008-07-01 05:29
Re: Cannot log in as admin (6 replies, posted in PunBB 1.2 troubleshooting)
prstech, this post should help you
1,187 2008-07-01 05:22
Re: Notice: Undefined index: Avatar info change in (1 replies, posted in PunBB 1.2 troubleshooting)
This problem was discussed here
1,188 2008-06-30 13:38
Re: Hook requests (151 replies, posted in PunBB 1.3 extensions)
Johu, why you think that usage ex_start in insecure?
If you need to make checking like this (Line 81-82):
if ($forum_user['g_read_board'] == '0')
exit($lang_common['No view']);Just do it (checking) in hook "ex_start". To add new action use hook "ex_new_action"
1,189 2008-06-30 13:09
Re: Multi Forums (8 replies, posted in Feature requests)
Xavier77, what exactly you can't find?
If you use MySQL you should:
Find file <FORUM_URL>/include/dblayer/mysql.php
Find code Line 76-79:
if (defined('PUN_SHOW_QUERIES'))$q_start = get_microtime();
if ($unbuffered)
Replace this lines with this:
if (defined('PUN_SHOW_QUERIES'))$q_start = get_microtime();
$sql = str_replace($this->prefix.'users', <your forum user table> , $sql);
if ($unbuffered)
1,190 2008-06-30 12:09
Re: How to move a forum to other category? i am going to phpmyadmin.. (2 replies, posted in PunBB 1.2 troubleshooting)
Hi!
qdb, to move a forum to other category you should:
Log in with administrator privileges and go to <FORUM_URL>/admin_forums.php.
Choose forum which category you need to change and click on "Edit"
Select the proper category in Category List
Press the button "Save Changes"
1,191 2008-06-27 08:09
Re: Multi Forums (8 replies, posted in Feature requests)
Hi!
Maybe this topic will help you to solve your problem.
1,192 2008-06-27 07:30
Re: Extension questions (8 replies, posted in PunBB 1.3 extensions)
Of course, you will
1,193 2008-06-26 18:28
Re: Bad HTTP_REFERER. <- Localhost? <- SMF Converted? (12 replies, posted in PunBB 1.2 troubleshooting)
Try to execute next SQL:
UPDATE config SET conf_value = '<url to your forum>' WHERE conf_name = 'o_base_url';
Alter config to <DB_REFIX>_config if necessary.And delete all .php files in the <FORUM_ROOT>/cache directory.
1,194 2008-06-26 17:55
Re: where do i add javascript.....? (9 replies, posted in PunBB 1.2 modifications, plugins and integrations)
quaker wrote:
could i do the same line and use my script in that location?
Yes, you could
1,195 2008-06-26 11:35
Re: RSS Feed url's and page title (9 replies, posted in PunBB 1.3 troubleshooting)
fantasma, in report you wrote:
add this in the next update of punbb
What exectly would you like us to add to the next update?
1,196 2008-06-26 10:30
Re: it's bug? (4 replies, posted in PunBB 1.3 troubleshooting)
This bug appeared after the parameter of group settings was removed from the core. The parameter determined the number of seconds after which a user could change the topic subject - we decided not to use this option any longer. Surely, this bug has been already fixed in SVN. We are also planning to release a test hotfix for PunBB 1.3 RC which would fix this bug.
1,197 2008-06-26 08:14
Re: it's bug? (4 replies, posted in PunBB 1.3 troubleshooting)
Yes, it's bug. Soon hotfix will be ready to correct it
1,198 2008-06-26 08:07
Re: How to install the new extensions (6 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Hi, Bowser.
To install extension:
Download the extension you need. This is probably a zip file containing a folder.
Unzip/copy this folder to directory <FORUM_ROOT>/extensions/.
Log in with administrator privileges and go to "Administration" / "Install extensions" (<FORUM_URL>/admin/extensions.php?section=install).
Click "Install extension" link for the extension you have just copied.
Read installation notices (if any) and press "Install extension" to start installation process.
1,199 2008-06-25 18:47
Re: RSS Feed url's and page title (9 replies, posted in PunBB 1.3 troubleshooting)
Hi, miller. If you need to remove Page 1, etc. from all forum pages, you should replace Line 583 from inlclude/functions.php
$crumbs .= (is_array($pun_page['crumbs'][$i]) ? htmlspecialchars($pun_page['crumbs'][$i][0]) : htmlspecialchars($pun_page['crumbs'][$i])).((isset($pun_page['page']) && $i == ($num_crumbs - 1)) ? ' ('.$lang_common['Page'].' '.$pun_page['page'].')' : '').($i > 0 ? $lang_common['Title separator'] : '');with this
$crumbs .= (is_array($pun_page['crumbs'][$i]) ? htmlspecialchars($pun_page['crumbs'][$i][0]) : htmlspecialchars($pun_page['crumbs'][$i])).($i > 0 ? $lang_common['Title separator'] : '');1,200 2008-06-18 08:37
Re: basic question about 1.3 (4 replies, posted in General discussion)
3. Go to "Administration" and choose bookmark "Extensions", than click on "Install extensions".