Jforum uzturēšana, izmantojot SQL

Jforum lietotāja izdzēšana

1. Apskata lietotāju datus:

   -- Pēc Id:
   select user_id, username, user_posts, user_email, user_website, user_biography from jforum_users where user_id in (...);
   -- Pēc vārda:
   select user_id, username, user_posts, user_email, user_website, user_biography from jforum_users where username in ("...");
   

2. Izdzēš nepieciešamo lietotāju un tā datus:

   DELETE FROM jforum_posts_text WHERE post_id in(SELECT post_id FROM jforum_posts WHERE user_id in(...));
   DELETE FROM jforum_posts WHERE user_id in(...);
   DELETE FROM jforum_topics WHERE user_id in(...);
   DELETE FROM jforum_topics_watch WHERE user_id in(...);
   DELETE FROM jforum_forums_watch WHERE user_id in(...);
   DELETE FROM jforum_banlist WHERE user_id in(...);
   DELETE FROM jforum_bookmarks WHERE user_id in(...);
   DELETE FROM jforum_sessions WHERE session_user_id in(...);
   DELETE FROM jforum_privmsgs WHERE privmsgs_to_userid in(...);
   DELETE FROM jforum_users WHERE user_id in(...);
   DELETE FROM jforum_user_groups WHERE user_id in(...);

Maksimālā lietotāju skaita atjaunošana

1. Lai atstatītu maksimālo lietotāju skaitu, piemēram, uz 1:

   UPDATE jforum_config SET config_value=1 WHERE config_id=1;