Menu
▾
▴
xoops-svn
|
From: <be...@us...> - 2014-03-08 10:04:27
|
Revision: 12361
http://sourceforge.net/p/xoops/svn/12361
Author: beckmi
Date: 2014-03-08 10:04:21 +0000 (Sat, 08 Mar 2014)
Log Message:
-----------
Updating to version 2.40, which is Trabis' Membership 2.30 module converted to XOOPS 2.5.6 Admin GUI, with added cloning
Modified Paths:
--------------
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/-.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/AD.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/AE.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/AG.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/AI.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/AQ.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/AS.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/BV.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/CD.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/CH.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/CL.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/DJ.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/DM.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/DO.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/FK.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/FM.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/GD.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/GH.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/GM.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/GN.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/GQ.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/GW.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/HM.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/HN.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/IO.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/KM.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/KN.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/KW.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/LA.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/LI.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/LR.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/LT.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/MA.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/MH.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/ML.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/MM.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/MR.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/MT.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/MU.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/MV.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/MW.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/NE.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/NG.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/NI.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/PG.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/RW.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/SC.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/SN.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/SR.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/ST.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/SV.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/SY.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/TD.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/TJ.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/TM.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/UK.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/UM.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/UZ.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/VC.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/VU.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/ZM.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/ZR.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/index.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/language/english/blocks.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/language/english/main.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/language/english/modinfo.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/rank.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/sql/mysql.sql
XoopsModules/xmmemberstats/trunk/xmmemberstats/xoops_version.php
Added Paths:
-----------
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/about.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/admin_footer.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/admin_header.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/bigdump.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/functions.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/background.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/banner_bg.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/bg.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/index.html
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/left_both.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/no.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/no_big.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/right_both.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/top_bg.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/warning.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/yes-current.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/yes-disabled.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/yes.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/img/yes_big.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/import.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/index.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/ip-to-country.csv
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/main.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/menu.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/style.css
XoopsModules/xmmemberstats/trunk/xmmemberstats/blocks/xmmemberstats_block.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/docs/
XoopsModules/xmmemberstats/trunk/xmmemberstats/docs/changelog.txt
XoopsModules/xmmemberstats/trunk/xmmemberstats/docs/credits.txt
XoopsModules/xmmemberstats/trunk/xmmemberstats/docs/index.html
XoopsModules/xmmemberstats/trunk/xmmemberstats/docs/install.txt
XoopsModules/xmmemberstats/trunk/xmmemberstats/docs/lang_diff.txt
XoopsModules/xmmemberstats/trunk/xmmemberstats/docs/license.txt
XoopsModules/xmmemberstats/trunk/xmmemberstats/docs/readme.txt
XoopsModules/xmmemberstats/trunk/xmmemberstats/extra/
XoopsModules/xmmemberstats/trunk/xmmemberstats/extra/clone_plugin/
XoopsModules/xmmemberstats/trunk/xmmemberstats/extra/clone_plugin/xmmemberstats.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/bots.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/davatar.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/A2.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/AX.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/_.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/grguest.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/module_logo.png
XoopsModules/xmmemberstats/trunk/xmmemberstats/include/
XoopsModules/xmmemberstats/trunk/xmmemberstats/include/common.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/language/english/admin.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/language/english/help/
XoopsModules/xmmemberstats/trunk/xmmemberstats/language/english/help/help.html
XoopsModules/xmmemberstats/trunk/xmmemberstats/language/english/help/index.html
XoopsModules/xmmemberstats/trunk/xmmemberstats/templates/blocks/xmmemberstats_block.html
XoopsModules/xmmemberstats/trunk/xmmemberstats/templates/xmmemberstats_index.html
XoopsModules/xmmemberstats/trunk/xmmemberstats/templates/xmmemberstats_rank.html
Removed Paths:
-------------
XoopsModules/xmmemberstats/trunk/xmmemberstats/blocks/membership_block.php
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/Thumbs.db
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/flags/Thumbs.db
XoopsModules/xmmemberstats/trunk/xmmemberstats/images/membership_logo.gif
XoopsModules/xmmemberstats/trunk/xmmemberstats/install/
XoopsModules/xmmemberstats/trunk/xmmemberstats/sql/index.html
XoopsModules/xmmemberstats/trunk/xmmemberstats/templates/blocks/membership_block.html
Added: XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/about.php
===================================================================
--- XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/about.php (rev 0)
+++ XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/about.php 2014-03-08 10:04:21 UTC (rev 12361)
@@ -0,0 +1,38 @@
+<?php
+// $Id$ //
+// ------------------------------------------------------------------------ //
+// XOOPS - PHP Content Management System //
+// Copyright (c) 2000 XOOPS.org //
+// <http://www.xoops.org/> //
+// ------------------------------------------------------------------------ //
+// This program is free software; you can redistribute it and/or modify //
+// it under the terms of the GNU General Public License as published by //
+// the Free Software Foundation; either version 2 of the License, or //
+// (at your option) any later version. //
+// //
+// You may not change or alter any portion of this comment or credits //
+// of supporting developers from this source code or any supporting //
+// source code which is considered copyrighted (c) material of the //
+// original comment or credit authors. //
+// //
+// This program is distributed in the hope that it will be useful, //
+// but WITHOUT ANY WARRANTY; without even the implied warranty of //
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
+// GNU General Public License for more details. //
+// //
+// You should have received a copy of the GNU General Public License //
+// along with this program; if not, write to the Free Software //
+// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
+// ------------------------------------------------------------------------ //
+//
+
+include_once dirname(__FILE__) . '/admin_header.php';
+
+xoops_cp_header();
+
+$aboutAdminGM = new ModuleAdmin();
+
+echo $aboutAdminGM->addNavigation('about.php');
+echo $aboutAdminGM->renderAbout('6KJ7RW5DR3VTJ', false);
+
+include 'admin_footer.php';
Property changes on: XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/about.php
___________________________________________________________________
Added: svn:keywords
## -0,0 +1 ##
+Author Date Id Rev URL
\ No newline at end of property
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/admin_footer.php
===================================================================
--- XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/admin_footer.php (rev 0)
+++ XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/admin_footer.php 2014-03-08 10:04:21 UTC (rev 12361)
@@ -0,0 +1,10 @@
+<?php
+
+echo "<div class='adminfooter'>\n"
+ ." <div style='text-align: center;'>\n"
+ ." <a href='http://www.xoops.org' target='_blank'><img src='{$pathIcon32}/xoopsmicrobutton.gif' alt='XOOPS' title='XOOPS'></a>\n"
+ ." </div>\n"
+ ." " . _AM_MODULEADMIN_ADMIN_FOOTER . "\n"
+ ."</div>";
+
+xoops_cp_footer();
Property changes on: XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/admin_footer.php
___________________________________________________________________
Added: svn:keywords
## -0,0 +1 ##
+Author Date Id Rev URL
\ No newline at end of property
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/admin_header.php
===================================================================
--- XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/admin_header.php (rev 0)
+++ XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/admin_header.php 2014-03-08 10:04:21 UTC (rev 12361)
@@ -0,0 +1,25 @@
+<?php
+
+$path = dirname(dirname(dirname(dirname(__FILE__))));
+include_once $path . '/mainfile.php';
+include_once $path . '/include/cp_functions.php';
+require_once $path . '/include/cp_header.php';
+
+global $xoopsModule;
+
+$thisModuleDir = $GLOBALS['xoopsModule']->getVar('dirname');
+
+// Load language files
+xoops_loadLanguage('admin', $thisModuleDir);
+xoops_loadLanguage('modinfo', $thisModuleDir);
+xoops_loadLanguage('main', $thisModuleDir);
+
+$pathIcon16 = '../'.$xoopsModule->getInfo('icons16');
+$pathIcon32 = '../'.$xoopsModule->getInfo('icons32');
+$pathModuleAdmin = $xoopsModule->getInfo('dirmoduleadmin');
+
+if ( file_exists($GLOBALS['xoops']->path($pathModuleAdmin.'/moduleadmin.php'))) {
+ include_once $GLOBALS['xoops']->path($pathModuleAdmin.'/moduleadmin.php');
+ } else {
+ redirect_header("../../../admin.php", 5, _AM_XMMEMBERSTATS_MODULEADMIN_MISSING, false);
+ }
Property changes on: XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/admin_header.php
___________________________________________________________________
Added: svn:keywords
## -0,0 +1 ##
+Author Date Id Rev URL
\ No newline at end of property
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/bigdump.php
===================================================================
--- XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/bigdump.php (rev 0)
+++ XoopsModules/xmmemberstats/trunk/xmmemberstats/admin/bigdump.php 2014-03-08 10:04:21 UTC (rev 12361)
@@ -0,0 +1,1026 @@
+<?php
+
+// BigDump ver. 0.34b from 2011-09-04
+// Staggered import of an large MySQL Dump (like phpMyAdmin 2.x Dump)
+// Even through the webservers with hard runtime limit and those in safe mode
+// Works fine with Internet Explorer 7.0 and Firefox 2.x
+
+// Author: Alexey Ozerov (alexey at ozerov dot de)
+// AJAX & CSV functionalities: Krzysiek Herod (kr81uni at wp dot pl)
+// Copyright: GPL (C) 2003-2011
+// More Infos: http://www.ozerov.de/bigdump
+
+// This program is free software; you can redistribute it and/or modify it under the
+// terms of the GNU General Public License as published by the Free Software Foundation;
+// either version 2 of the License, or (at your option) any later version.
+
+// THIS SCRIPT IS PROVIDED AS IS, WITHOUT ANY WARRANTY OR GUARANTEE OF ANY KIND
+
+// USAGE
+
+// 1. Adjust the database configuration in this file
+// 2. Remove the old tables on the target database if your dump doesn't contain "DROP TABLE"
+// 3. Create the working directory (e.g. dump) on your web server
+// 4. Upload bigdump.php and your dump files (.sql, .gz) via FTP to the working directory
+// 5. Run the bigdump.php from your browser via URL like http://www.yourdomain.com/dump/bigdump.php
+// 6. BigDump can start the next import session automatically if you enable the JavaScript
+// 7. Wait for the script to finish, do not close the browser window
+// 8. IMPORTANT: Remove bigdump.php and your dump files from the web server
+
+// If Timeout errors still occure you may need to adjust the $linepersession setting in this file
+
+// LAST CHANGES
+
+// *** Fix ajax error on some OS
+// *** Fix ajax bug on Google Chrome and Safari
+// *** Query delimiter treatment added
+// *** Only list SQL, GZ and CSV files
+// *** Sort the file listing A-Z
+// *** Add string quotes setting
+
+
+// Database configuration
+
+$db_server = 'localhost';
+$db_name = '';
+$db_username = '';
+$db_password = '';
+
+// Other settings (optional)
+
+$filename = ''; // Specify the dump filename to suppress the file selection dialog
+$ajax = true; // AJAX mode: import will be done without refreshing the website
+$linespersession = 3000; // Lines to be executed per one import session
+$delaypersession = 0; // You can specify a sleep time in milliseconds after each session
+ // Works only if JavaScript is activated. Use to reduce server overrun
+
+// CSV related settings (only if you use a CSV dump)
+
+$csv_insert_table = ''; // Destination table for CSV files
+$csv_preempty_table = false; // true: delete all entries from table specified in $csv_insert_table before processing
+$csv_delimiter = ','; // Field delimiter in CSV file
+$csv_add_quotes = true; // If your CSV data already have quotes around each field set it to false
+$csv_add_slashes = true; // If your CSV data already have slashes in front of ' and " set it to false
+
+// Allowed comment markers: lines starting with these strings will be ignored by BigDump
+
+$comment[]='#'; // Standard comment lines are dropped by default
+$comment[]='-- ';
+$comment[]='DELIMITER'; // Ignore DELIMITER switch as it's not a valid SQL statement
+// $comment[]='---'; // Uncomment this line if using proprietary dump created by outdated mysqldump
+// $comment[]='CREATE DATABASE'; // Uncomment this line if your dump contains create database queries in order to ignore them
+$comment[]='/*!'; // Or add your own string to leave out other proprietary things
+
+// Pre-queries: SQL queries to be executed at the beginning of each import session
+
+// $pre_query[]='SET foreign_key_checks = 0';
+// $pre_query[]='Add additional queries if you want here';
+
+// Connection charset should be the same as the dump file charset (utf8, latin1, cp1251, koi8r etc.)
+// See http://dev.mysql.com/doc/refman/5.0/en/charset-charsets.html for the full list
+// Change this if you have problems with non-latin letters
+
+$db_connection_charset = '';
+
+// Default query delimiter: this character at the line end tells Bigdump where a SQL statement ends
+// Can be changed by DELIMITER statement in the dump file (normally used when defining procedures/functions)
+
+$delimiter = ';';
+
+// String quotes character
+
+$string_quotes = '\''; // Change to '"' if your dump file uses double qoutes for strings
+
+
+// *******************************************************************************************
+// If not familiar with PHP please don't change anything below this line
+// *******************************************************************************************
+
+if ($ajax)
+ ob_start();
+
+define ('VERSION','0.34b');
+define ('DATA_CHUNK_LENGTH',16384); // How many chars are read per time
+define ('MAX_QUERY_LINES',300); // How many lines may be considered to be one query (except text lines)
+define ('TESTMODE',false); // Set to true to process the file without actually accessing the database
+
+header("Expires: Mon, 1 Dec 2003 01:00:00 GMT");
+header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
+header("Cache-Control: no-store, no-cache, must-revalidate");
+header("Cache-Control: post-check=0, pre-check=0", false);
+header("Pragma: no-cache");
+
+@ini_set('auto_detect_line_endings', true);
+@set_time_limit(0);
+
+if (function_exists("date_default_timezone_set") && function_exists("date_default_timezone_get"))
+ @date_default_timezone_set(@date_default_timezone_get());
+
+// Clean and strip anything we don't want from user's input [0.27b]
+
+foreach ($_REQUEST as $key => $val) {
+ $val = preg_replace("/[^_A-Za-z0-9-\.&= ;\$]/i",'', $val);
+ $_REQUEST[$key] = $val;
+}
+
+?>
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<title>BigDump ver. <?php echo (VERSION); ?></title>
+<meta http-equiv="CONTENT-TYPE" content="text/html; charset=iso-8859-1"/>
+<meta http-equiv="CONTENT-LANGUAGE" content="EN"/>
+
+<meta http-equiv="Cache-Control" content="no-cache/"/>
+<meta http-equiv="Pragma" content="no-cache"/>
+<meta http-equiv="Expires" content="-1"/>
+<meta name="robots" content="noindex, nofollow">
+
+<style type="text/css">
+<!--
+
+body
+{ background-color:#FFFFF0;
+}
+
+h1
+{ font-size:20px;
+ line-height:24px;
+ font-family:Arial,Helvetica,sans-serif;
+ margin-top:5px;
+ margin-bottom:5px;
+}
+
+p,td,th
+{ font-size:14px;
+ line-height:18px;
+ font-family:Arial,Helvetica,sans-serif;
+ margin-top:5px;
+ margin-bottom:5px;
+ text-align:justify;
+ vertical-align:top;
+}
+
+p.centr
+{
+ text-align:center;
+}
+
+p.smlcentr
+{ font-size:10px;
+ line-height:14px;
+ text-align:center;
+}
+
+p.error
+{ color:#FF0000;
+ font-weight:bold;
+}
+
+p.success
+{ color:#00DD00;
+ font-weight:bold;
+}
+
+p.successcentr
+{ color:#00DD00;
+ background-color:#DDDDFF;
+ font-weight:bold;
+ text-align:center;
+}
+
+td
+{ background-color:#F8F8F8;
+ text-align:left;
+}
+
+td.transparent
+{ background-color:#FFFFF0;
+}
+
+th
+{ font-weight:bold;
+ color:#FFFFFF;
+ background-color:#AAAAEE;
+ text-align:left;
+}
+
+td.right
+{ text-align:right;
+}
+
+form
+{ margin-top:5px;
+ margin-bottom:5px;
+}
+
+div.skin1
+{
+ border: 5px solid #3333EE;
+ background-color:#AAAAEE;
+ text-align:center;
+ vertical-align:middle;
+ padding:3px;
+ margin:1px;
+}
+
+td.bg3
+{ background-color:#EEEE99;
+ text-align:left;
+ vertical-align:top;
+ width:20%;
+}
+
+th.bg4
+{ background-color:#EEAA55;
+ text-align:left;
+ vertical-align:top;
+ width:20%;
+}
+
+td.bgpctbar
+{ background-color:#EEEEAA;
+ text-align:left;
+ vertical-align:middle;
+ width:80%;
+}
+
+-->
+</style>
+
+</head>
+
+<body>
+
+<center>
+
+<table width="780" cellspacing="0" cellpadding="0">
+<tr><td class="transparent">
+
+<!-- <h1>BigDump: Staggered MySQL Dump Importer ver. <?php echo (VERSION); ?></h1> -->
+
+<?php
+
+function skin_open()
+{
+echo ('<div class="skin1">');
+}
+
+function skin_close()
+{
+echo ('</div>');
+}
+
+skin_open();
+echo ('<h1>BigDump: Staggered MySQL Dump Importer v'.VERSION.'</h1>');
+skin_close();
+
+$error = false;
+$file = false;
+
+// Check PHP version
+
+if (!$error && !function_exists('version_compare')) { echo ("<p class=\"error\">PHP version 4.1.0 is required for BigDump to proceed. You have PHP ".phpversion()." installed. Sorry!</p>\n");
+ $error=true;
+}
+
+// Check if mysql extension is available
+
+if (!$error && !function_exists('mysql_connect')) { echo ("<p class=\"error\">There is no mySQL extension available in your PHP installation. Sorry!</p>\n");
+ $error=true;
+}
+
+// Calculate PHP max upload size (handle settings like 10M or 100K)
+
+if (!$error) { $upload_max_filesize=ini_get("upload_max_filesize");
+ if (preg_match("/([0-9]+)K/i",$upload_max_filesize,$tempregs)) $upload_max_filesize=$tempregs[1]*1024;
+ if (preg_match("/([0-9]+)M/i",$upload_max_filesize,$tempregs)) $upload_max_filesize=$tempregs[1]*1024*1024;
+ if (preg_match("/([0-9]+)G/i",$upload_max_filesize,$tempregs)) $upload_max_filesize=$tempregs[1]*1024*1024*1024;
+}
+
+// Get the current directory
+
+if (isset($_SERVER["CGIA"]))
+ $upload_dir=dirname($_SERVER["CGIA"]);
+else if (isset($_SERVER["ORIG_PATH_TRANSLATED"]))
+ $upload_dir=dirname($_SERVER["ORIG_PATH_TRANSLATED"]);
+else if (isset($_SERVER["ORIG_SCRIPT_FILENAME"]))
+ $upload_dir=dirname($_SERVER["ORIG_SCRIPT_FILENAME"]);
+else if (isset($_SERVER["PATH_TRANSLATED"]))
+ $upload_dir=dirname($_SERVER["PATH_TRANSLATED"]);
+else
+ $upload_dir=dirname($_SERVER["SCRIPT_FILENAME"]);
+
+// Handle file upload
+
+if (!$error && isset($_REQUEST["uploadbutton"])) { if (is_uploaded_file($_FILES["dumpfile"]["tmp_name"]) && ($_FILES["dumpfile"]["error"])==0) {
+ $uploaded_filename=str_replace(" ","_",$_FILES["dumpfile"]["name"]);
+ $uploaded_filename=preg_replace("/[^_A-Za-z0-9-\.]/i",'',$uploaded_filename);
+ $uploaded_filepath=str_replace("\\","/",$upload_dir."/".$uploaded_filename);
+
+ if (file_exists($uploaded_filename)) { echo ("<p class=\"error\">File $uploaded_filename already exist! Delete and upload again!</p>\n");
+ } elseif (!preg_match("/(\.(sql|gz|csv))$/i",$uploaded_filename)) { echo ("<p class=\"error\">You may only upload .sql .gz or .csv files.</p>\n");
+ } elseif (!@move_uploaded_file($_FILES["dumpfile"]["tmp_name"],$uploaded_filepath)) { echo ("<p class=\"error\">Error moving uploaded file ".$_FILES["dumpfile"]["tmp_name"]." to the $uploaded_filepath</p>\n");
+ echo ("<p>Check the directory permissions for $upload_dir (must be 777)!</p>\n");
+ } else { echo ("<p class=\"success\">Uploaded file saved as $uploaded_filename</p>\n");
+ }
+ } else { echo ("<p class=\"error\">Error uploading file ".$_FILES["dumpfile"]["name"]."</p>\n");
+ }
+}
+
+// Handle file deletion (delete only in the current directory for security reasons)
+
+if (!$error && isset($_REQUEST["delete"]) && $_REQUEST["delete"]!=basename($_SERVER["SCRIPT_FILENAME"])) { if (preg_match("/(\.(sql|gz|csv))$/i",$_REQUEST["delete"]) && @unlink(basename($_REQUEST["delete"])))
+ echo ("<p class=\"success\">".$_REQUEST["delete"]." was removed successfully</p>\n");
+ else
+ echo ("<p class=\"error\">Can't remove ".$_REQUEST["delete"]."</p>\n");
+}
+
+// Connect to the database, set charset and execute pre-queries
+
+if (!$error && !TESTMODE) { $dbconnection = @mysql_connect($db_server,$db_username,$db_password);
+ if ($dbconnection)
+ $db = mysql_select_db($db_name);
+ if (!$dbconnection || !$db) { echo ("<p class=\"error\">Database connection failed due to ".mysql_error()."</p>\n");
+ echo ("<p>Edit the database settings in ".$_SERVER["SCRIPT_FILENAME"]." or contact your database provider.</p>\n");
+ $error=true;
+ }
+ if (!$error && $db_connection_charset!=='')
+ @mysql_query("SET NAMES $db_connection_charset", $dbconnection);
+
+ if (!$error && isset ($pre_query) && sizeof ($pre_query)>0) { reset($pre_query);
+ foreach ($pre_query as $pre_query_value) { if (!@mysql_query($pre_query_value, $dbconnection)) { echo ("<p class=\"error\">Error with pre-query.</p>\n");
+ echo ("<p>Query: ".trim(nl2br(htmlentities($pre_query_value)))."</p>\n");
+ echo ("<p>MySQL: ".mysql_error()."</p>\n");
+ $error=true;
+ break;
+ }
+ }
+ }
+} else { $dbconnection = false;
+}
+
+// DIAGNOSTIC
+// echo("<h1>Checkpoint!</h1>");
+
+// List uploaded files in multifile mode
+
+if (!$error && !isset($_REQUEST["fn"]) && $filename=="") { if ($dirhandle = opendir($upload_dir)) {
+ $files=array();
+ while (false !== ($files[] = readdir($dirhandle)));
+ closedir($dirhandle);
+ $dirhead=false;
+
+ if (sizeof($files)>0) {
+ sort($files);
+ foreach ($files as $dirfile) {
+ if ($dirfile != "." && $dirfile != ".." && $dirfile!=basename($_SERVER["SCRIPT_FILENAME"]) && preg_match("/\.(sql|gz|csv)$/i",$dirfile)) { if (!$dirhead) { echo ("<table width=\"100%\" cellspacing=\"2\" cellpadding=\"2\">\n");
+ echo ("<tr><th>Filename</th><th>Size</th><th>Date&Time</th><th>Type</th><th> </th><th> </th>\n");
+ $dirhead=true;
+ }
+ echo ("<tr><td>$dirfile</td><td class=\"right\">".filesize($dirfile)."</td><td>".date ("Y-m-d H:i:s", filemtime($dirfile))."</td>");
+
+ if (preg_match("/\.sql$/i",$dirfile))
+ echo ("<td>SQL</td>");
+ elseif (preg_match("/\.gz$/i",$dirfile))
+ echo ("<td>GZip</td>");
+ elseif (preg_match("/\.csv$/i",$dirfile))
+ echo ("<td>CSV</td>");
+ else
+ echo ("<td>Misc</td>");
+
+ if ((preg_match("/\.gz$/i",$dirfile) && function_exists("gzopen")) || preg_match("/\.sql$/i",$dirfile) || preg_match("/\.csv$/i",$dirfile))
+ echo ("<td><a href=\"".$_SERVER["PHP_SELF"]."?start=1&fn=".urlencode($dirfile)."&foffset=0&totalqueries=0&delimiter=".urlencode($delimiter)."\">Start Import</a> into $db_name at $db_server</td>\n <td><a href=\"".$_SERVER["PHP_SELF"]."?delete=".urlencode($dirfile)."\">Delete file</a></td></tr>\n");
+ else
+ echo ("<td> </td>\n <td> </td></tr>\n");
+ }
+ }
+ }
+
+ if ($dirhead)
+ echo ("</table>\n");
+ else
+ echo ("<p>No uploaded SQL, GZ or CSV files found in the working directory</p>\n");
+ } else { echo ("<p class=\"error\">Error listing directory $upload_dir</p>\n");
+ $error=true;
+ }
+}
+
+// Single file mode
+
+if (!$error && !isset ($_REQUEST["fn"]) && $fil...
[truncated message content] |
Thanks for helping keep SourceForge clean.
X