sabri ünal 29.07.2006, 12:14
düşünün ki yeni bir mod yüklediğiniz ve onunla birlikte yeni bir tablo geliyor, peki phpBB o tabloları görüyor mu? hayır... peki ya bir de sitemiz ve onun db si varsa!
bu fix veya mod ile VERİTABANINDAKİ tüm veriler yedekleniyor...
eğer siteniz ve forumunuz tek alandaysa, tek noktadan yedeklemeye yarıyor...
- Kod: Tümünü seç
###############################################
## Hack Title: db_utils
## Hack Version: 1.0.0
## Author: Garold W. Robinson setheep@hotmail.com
## Description: modification of the admin_db_utils.php to back-up your entire database
## Compatibility: 2.0.0 - 2.0.4
##
## Installation Level: Easy
## Installation Time: 5 minutes
## Files To Edit: 1
## admin/admin_db_utilities.php
##
##
## Included Files: NA
##
## History:
##
## Version 1.0.0: This initial version
##
##
## Author Notes:
## None
##
## Support: http://www.phpbbhacks.com/forums
## Copyright: ©2003 <title> <version> - Garold W. Robinson
##
###############################################
## You downloaded this hack from phpBBHacks.com, the #1 source for phpBB related downloads.
## Please visit http://www.phpbbhacks.com/forums for support.
###############################################
##
###############################################
## This hack is released under the GPL License.
## This hack can be freely used, but not distributed, without permission.
## Intellectual Property is retained by the hack author(s) listed above.
###############################################
#
#-----[ OPEN ]------------------------------------------
#
admin/admin_db_utilities.php
#
#-----[ FIND ]------------------------------------------
#
$tables = array('auth_access', 'banlist', 'categories', 'config', 'disallow', 'forums', 'forum_prune', 'groups', 'posts', 'posts_text', 'privmsgs', 'privmsgs_text', 'ranks', 'search_results', 'search_wordlist', 'search_wordmatch', 'sessions', 'smilies', 'themes', 'themes_name', 'topics', 'topics_watch', 'user_group', 'users', 'vote_desc', 'vote_results', 'vote_voters', 'words');
#
#-----[ REPLACE WITH ]------------------------------------------
#
$result = mysql_list_tables($dbname);
$i = 0;
while ($i < mysql_num_rows ($result)) {
$tables[$i] = mysql_tablename ($result, $i);
$i++;
}
#
#-----[ FIND ]------------------------------------------
#
if($backup_type != 'data')
{
echo "#\n# TABLE: " . $table_prefix . $table_name . "\n#\n";
echo $table_def_function($table_prefix . $table_name, "\n") . "\n";
}
if($backup_type != 'structure')
{
$table_content_function($table_prefix . $table_name, "output_table_content");
}
}
#
#-----[ REPLACE WITH ]------------------------------------------
#
if($backup_type != 'data')
{
echo "#\n# TABLE: $table_name \n#\n";
echo $table_def_function($table_name, "\n") . "\n";
}
if($backup_type != 'structure')
{
$table_content_function($table_name, "output_table_content");
}
}
#
#-----[ SAVE & CLOSE ALL FILES ]--------------------------
#
#End
En son sabri ünal tarafından, 10.08.2006, 13:16 tarihinde değiştirildi, toplamda 2 değişiklik yapıldı.
Mutluyum, biraz komedi takılıyorum! sakın kızmayın yakında geçer, sebebini ben de bilmiyorum! yeni bir aşk da bulmuş değilim!