Auto Clean!

[xt]

Exista vreo optiune sau un mod pentru a sterge userii care nu sunt activi?

[flowers]

Inactive Users

This hack allows you to check how many users who have never been activated and it makes you choose whether to contact them or to delete them.

It will only work if you have enabled account activation on your forums (user or admin).

[BuGsY]

Eu îţi recomand MODificarea Prune users. NU este necesar să dai ALTER la tabela cu utilizatori.

[xt]

Imi place ca la hack-ul ala ce mi-a zis flowers pot sa setez sa trimita mail daca userul nu e activ cel putin asa am citit ca vroiam sa vad acolo scrie ca sa adaug un fiser in template subsilver, daca folosesc alt template merge?

[flowers]

In loc de subSilver, pui stilul pe care il ai tu. Atentie daca vrei sa menti si subSilver, trebuie editate si fisierele lui.

[xt]

Scuze ca deranjez din nou dar nu inteleg exact la ce se refera aici:
#
#-----[ SQL ]------------------------------------------
#
# If you don't know how to execute sql queries, then copy
# mysql_install.php into your phpbb directory and run it.
# (assuming you use mysql)
# After process delete it.
#
# If you don't use mysql, you'll have to edit these queries accordingly
#
# If you have a different table prefix then change this command accordingly.
# I have used the default table prefix!
#

ALTER TABLE phpbb_users ADD user_inactive_emls TINYINT( 1 ) NOT NULL ;
ALTER TABLE phpbb_users ADD user_inactive_last_eml INT( 11 ) NOT NULL ;

[flowers]

Ai 2 variante sa faci modificari in baza de date. Foloseste una din ele:

• copiaza fisierul mysql_install.php in radacina forumului si ruleaza-l din browser, apoi il stergi (daca folosesti MySQL, altfel trebuie sa editezi interogarile in concordanta cu baza de date folosita) ;
• executa in phpMyAdmin interogarile:

  Cod: Selectaţi tot

  ALTER TABLE phpbb_users ADD user_inactive_emls TINYINT( 1 ) NOT NULL ; 
  ALTER TABLE phpbb_users ADD user_inactive_last_eml INT( 11 ) NOT NULL ;

  Este folosit prefixul default pentru tabele phpbb_, daca ai altul, fa modificarile de rigoare.

[xt]

Cod: Selectaţi tot

Warning: Cannot modify header information - headers already sent by (output started at /home/xtro/public_html/extension.inc:28) in /home/xtro/public_html/includes/sessions.php on line 293

Warning: Cannot modify header information - headers already sent by (output started at /home/xtro/public_html/extension.inc:28) in /home/xtro/public_html/includes/sessions.php on line 294

Warning: Cannot modify header information - headers already sent by (output started at /home/xtro/public_html/extension.inc:28) in /home/xtro/public_html/includes/page_header.php on line 474

Warning: Cannot modify header information - headers already sent by (output started at /home/xtro/public_html/extension.inc:28) in /home/xtro/public_html/includes/page_header.php on line 476

Warning: Cannot modify header information - headers already sent by (output started at /home/xtro/public_html/extension.inc:28) in /home/xtro/public_html/includes/page_header.php on line 477

Mi-a aparut eroarea asta sus inainte de forum si de asemenea cand incerc sa rulez mysql_install.php :

Cod: Selectaţi tot

Warning: Cannot modify header information - headers already sent by (output started at /home/xtro/public_html/extension.inc:28) in /home/xtro/public_html/includes/sessions.php on line 182

Warning: Cannot modify header information - headers already sent by (output started at /home/xtro/public_html/extension.inc:28) in /home/xtro/public_html/includes/sessions.php on line 183

Warning: Cannot modify header information - headers already sent by (output started at /home/xtro/public_html/extension.inc:28) in /home/xtro/public_html/mysql_install.php on line 37

UP#1
Ok, aia am rezolvat-o dar acuma mi-o dat eroare asta si nu-i dau de cap, apare cand dau inactive users din admin cpanel:

Cod: Selectaţi tot

Could not obtain list of inactive users

DEBUG MODE

SQL Error : 1054 Unknown column 'user_inactive_emls' in 'field list'

SELECT user_id, username, user_lastvisit, user_regdate, user_posts, user_email, user_active, user_inactive_emls, user_inactive_last_eml FROM phpbb_users WHERE ( user_active = 0 AND user_actkey <> '' ) AND user_id <> -1 ORDER BY user_regdate ASC

Line : 79
File : /home/xtro/public_html/admin/admin_users_inactive.php

[editat="BuGsY"]mesaj editat deoarece erau două mesaje trimise consecutive, xt vezi Regulament forum[/editat]

[BuGsY]

Xt, răspunsul l-ai primit de la flowers, nu ai făcut modificările necesare bazei de date pentru rularea corectă a MODificării instalate de tine.

[xt]

Am incercat sa fac modificarile necesare folosint mysql_install.php dar imi spune ca nu am fisierul db_update.php !