..:: AsmBB ::..: How to delete 1 thread and all of it posts?
<img src="https://board.asm32.info/images/title.svg" alt="Title img">
<h1>AsmBB is ultrafast web forum, written entirely in assembly language. This site is the official support development forum and demo/test installation.</h1>
tag:board.asm32.info,2018-03-06:Thread3172022-03-02T04:19:36Zganuonglachanh on How to delete 1 thread and all of it posts?tag:board.asm32.info,2018-03-06:Post162402022-03-02T04:19:36Z
<p>Hi Jeff
You can post in new thread and we’ll have some discussions, and some solutions are being implemented in DEV trunk</p>
ganuonglachanh Jeff on How to delete 1 thread and all of it posts?tag:board.asm32.info,2018-03-06:Post162372022-02-23T23:06:41Z
<p>@ganuonglachanh ,I have some ideas on spam solutions, but i need to talk to a developer to implement them. You available to talk? send me a limited message...</p>
JeffSeafar on How to delete 1 thread and all of it posts?tag:board.asm32.info,2018-03-06:Post162362022-02-20T03:34:32Z
<blockquote><header>Seafar</header><p><img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/smile.gif" alt=":-)" /> <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/smile.gif" alt=":-)" /> <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/smile.gif" alt=":-)" /> <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/smile.gif" alt=":-)" /> <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/smile.gif" alt=":-)" /> <a href="https://--/">My link</a>
</p></blockquote><p>This forum contains 16023 posts in 251 threads.
</p>
<p>We have 349 registered users.
</p>
<p>The latest registered user is: Seafar
</p>
<p>In the last 24h there was 366 visitors on the forum.
</p>
SeafarSeafar on How to delete 1 thread and all of it posts?tag:board.asm32.info,2018-03-06:Post162352022-02-20T03:34:09Z
<p><img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/smile.gif" alt=":-)" /> <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/smile.gif" alt=":-)" /> <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/smile.gif" alt=":-)" /> <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/smile.gif" alt=":-)" /> <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/smile.gif" alt=":-)" /> <a href="https://--/">My link</a> </p>
Seafarjohnfound on How to delete 1 thread and all of it posts?tag:board.asm32.info,2018-03-06:Post162282022-01-19T10:05:12Z
<blockquote><header>majorlabi</header><blockquote><header>kari</header><p>The remove threads button in UI is a most for admins.
</p></blockquote><p>True, without that we can't control bots and users that uses their account for advertising purposes only. Hoping @johnfound will consider this in the future.
</p></blockquote>
<p>Well, IMHO, handling massive database operations by SQL requests is much faster than clicking on buttons in the UI. But yes, much dangerous as well.
</p>
<p>Although, early or later I will create such admin tools.
</p>
<p>But to control bots and malicious users, another kind of control is needed and such control is already here in the latest dev versions of the engine.
</p>
<p>I have just updated the engine with the latest features. Now every user can be limited by the posting rate, including the new registered users. The rate limit can automatically decrease, so the administrator can check the user behavior before the bot or the user can do big damage.
</p>
johnfoundmajorlabi on How to delete 1 thread and all of it posts?tag:board.asm32.info,2018-03-06:Post162222021-03-15T14:49:06Z
<blockquote><header>kari</header><p>The remove threads button in UI is a most for admins.
</p></blockquote><p>True, without that we can't control bots and users that uses their account for advertising purposes only. Hoping @johnfound will consider this in the future.</p>
majorlabikari on How to delete 1 thread and all of it posts?tag:board.asm32.info,2018-03-06:Post162032020-11-05T16:47:25Z
<p>Johnfound if i have 200 spam threads per day on my board i have to type your command 200 times to delete them?The remove threads button in UI is a most for admins.
And please make a importer from wordpress , vbulletin ,xenforo ,is a good way to make your board grow up fast.
If a had a importer from wordpress ill switch to asm board instantly ;-).
Have nice day.</p>
kariganuonglachanh on How to delete 1 thread and all of it posts?tag:board.asm32.info,2018-03-06:Post161042020-04-08T13:13:19Z
<blockquote><header>johnfound</header><p>Well, you can delete a thread, but this is kind of risky operation, because there is no such operation in the UI. And this was made on purpose. Because one of the main ideas in AsmBB is to limit the power of the administrators and moderators and give the visitors some more freedom to self-organize.
</p>
<p>Of course the administrator can do everything with the database, but my intention was to make some things not so easy.
</p>
<p>So, you can delete a thread and all it's posts only from the SQLite console:
</p>
<pre><code class=""> delete from threads where id = %THREADID%;
</code></pre>
<p>Or respectively:
</p>
<pre><code class=""> delete from threads where slug = "%VERY_BAD_THREAD_SLUG%";
</code></pre>
<p>But, well, deleting from the database is kind of risky operation. Are you ready to delete all your database by typing one wrong word? <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/wink.gif" alt=";-)" />
</p></blockquote>
<p>Thank you johnfound, I'm looking for a quick way to clean my test Database. In production, we need to do it more and more carefully <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/rofl.gif" alt="rofl" />
</p>
ganuonglachanh johnfound on How to delete 1 thread and all of it posts?tag:board.asm32.info,2018-03-06:Post161032020-04-08T10:15:49Z
<blockquote><header>ganuonglachanh</header><p>I can't delete a thread and all it's post? <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/tongue.gif" alt=":-P" /> Did I miss something?
</p></blockquote>
<p>Well, you can delete a thread, but this is kind of risky operation, because there is no such operation in the UI. And this was made on purpose. Because one of the main ideas in AsmBB is to limit the power of the administrators and moderators and give the visitors some more freedom to self-organize.
</p>
<p>Of course the administrator can do everything with the database, but my intention was to make some things not so easy.
</p>
<p>So, you can delete a thread and all it's posts only from the SQLite console:
</p>
<pre><code class=""> delete from threads where id = %THREADID%;
</code></pre>
<p>Or respectively:
</p>
<pre><code class=""> delete from threads where slug = "%VERY_BAD_THREAD_SLUG%";
</code></pre>
<p>But, well, deleting from the database is kind of risky operation. Are you ready to delete all your database by typing one wrong word? <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/wink.gif" alt=";-)" /> </p>
johnfoundganuonglachanh on How to delete 1 thread and all of it posts?tag:board.asm32.info,2018-03-06:Post161022020-04-07T17:33:22Z
<p>I can't delete a thread and all it's post? <img class="inline" src="/templates/Urban+Sunrise/_images/emoticons/tongue.gif" alt=":-P" /> Did I miss something?</p>
ganuonglachanh