![]() |
|
| ||||
| İlk başta karışık görünebilir ama pek çok kişinin işine yarayacağına eminim, 0 ve 1 'leri değiştirerek işlemleri tersine çevirebilirsiniz. phpbb_ ön ek değerini (prefix) kendi ön ekinize göre değiştirmeyi unutmayın. Bazılarını kontrol etmedim hatalı varsa lütfen yazın... Tüm kullanıcıların rütbelerini resetler Code: UPDATE phpbb_users SET user_rank = 0 WHERE user_id <> -1; Code: UPDATE phpbb_users SET user_level = 0 WHERE user_id <> -1; Code: UPDATE phpbb_users SET user_style = 1 WHERE user_id <> -1; Code: UPDATE phpbb_users SET user_notify = 0 WHERE user_id <> -1; Code: UPDATE phpbb_users SET user_notify_pm = 0 WHERE user_id <> -1; Code: UPDATE phpbb_users SET user_attachsig = 0 WHERE user_id <> -1; Code: UPDATE phpbb_users SET user_active = 1 WHERE user_id <> -1; Code: UPDATE phpbb_posts SET enable_sig = 0 WHERE user_id <> -1; Code: UPDATE phpbb_users SET user_sig = '', user_sig_bbcode_uid = '' WHERE user_id <> -1; Code: UPDATE phpbb_users SET user_timezone = '-3.00' WHERE user_id <> -1; Code: UPDATE phpbb_topics SET topic_views = 0; Code: UPDATE phpbb_users SET user_allowbbcode = 1 WHERE user_id <> -1; Code: UPDATE phpbb_users SET user_dateformat = 'd.m.Y, H:i' WHERE user_id <> -1; Code: TRUNCATE phpbb_sessions; Code: UPDATE phpbb_users SET user_password = MD5('şifreni_yaz') WHERE user_id = 2;
Code: UPDATE phpbb_users SET username = 'yeni_kullanıcı_adı' WHERE user_id = 2; Code: UPDATE phpbb_config SET config_value = unix_timestamp( '2005-08-14 12:00:00' ) WHERE config_name = 'board_startdate'; Code: DELETE FROM phpbb_users WHERE user_posts = 0 AND user_id <> -1; Code: UPDATE phpbb_users SET user_posts = '100' WHERE username = 'kullanıcı_adı'; Code: UPDATE phpbb_config SET config_value = 'www.canver.net' WHERE config_name = 'server_name'; Code: UPDATE phpbb_config SET config_value = '/phpbb2/' WHERE config_name = 'script_path'; Code: UPDATE phpbb_users SET user_posts = '0' WHERE user_id <> 2 AND user_id <> -1; Code: TRUNCATE phpbb_posts; TRUNCATE phpbb_posts_text; TRUNCATE phpbb_topics; UPDATE phpbb_forums SET forum_last_post_id = '0', forum_posts = '0', forum_topics = '0'; Code: UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'eski.canver.net', 'www.canver.net'); Code: UPDATE phpbb_users SET user_avatar = '', user_avatar_type = '0' WHERE user_id <> -1; Code: TRUNCATE phpbb_privmsgs; TRUNCATE phpbb_privmsgs_text; UPDATE phpbb_users SET user_new_privmsg= '0', user_unread_privmsg = '0', user_last_privmsg = '0' WHERE user_id <> -1; Code: UPDATE phpbb_users SET user_allow_viewonline = 1 WHERE user_id <> -1; Code: UPDATE phpbb_users SET user_lang = 'turkish' WHERE user_id <> -1; Code: UPDATE phpbb_users SET user_level = 1 WHERE username = 'KULLANICI_ADI'; Code: UPDATE `phpbb_users` SET `phpBBSecurity_answer` = '', `phpBBSecurity_question` = '' WHERE `user_id` = -1; Code: UPDATE phpbb_config SET config_value = 'domain_name_here' WHERE config_name = 'cookie_domain'; UPDATE phpbb_config SET config_value = 'domain_name_here' WHERE config_name = 'server_name'; UPDATE phpbb_config SET config_value = 'path_to_phpBB' WHERE config_name = 'cookie_path'; UPDATE phpbb_config SET config_value = 'domain_name_here' WHERE config_name = 'script_path'; Code: UPDATE phpbb_posts SET enable_sig = '1' WHERE poster_id = 'your_user_id';
__________________ phpBB3 forum hizmetleri, phpBB3 SEO |
![]() |
| Konuyu Toplam 1 üye okuyor. (0 Kayıtlı üye ve 1 Misafir) | |
| Konu Seçenekleri | |
| |
Okuduğunuz Konuya Benzer Konular | ||||
| Konu | Konuyu Açan | Forum | Cevaplar | Son Mesaj |
| Veritabanı Oluşturma ve Sql Yükleme | KaaN | Database | 3 | 27-12-2006 16:31:18 |
| Dünyada en iyi 25 php template search engine (Makale) | wasgo | Makale & Çeviri yazılar | 8 | 16-08-2006 04:15:42 |
| Dünyada en iyi 25 php template search engine (Makale) | wasgo | Gold webmaster Genel | 0 | 01-08-2006 23:36:36 |
| Veritabanı Oluşturma ve Sql Yükleme | KaaN | Makale & Çeviri yazılar | 0 | 20-06-2006 02:47:32 |
| AOL, Mynet'le Türkiye pazarında | xfatihx | Gündemdeki konular & Haberler | 7 | 14-06-2006 19:20:28 |