echo off
cls
echo  ----
IF NOT EXIST "public_html\phpBB2" GOTO createfiles

:removal
	echo  Removing Previous Test Forum
	RD "public_html\phpBB2" /S /Q
	echo  Previous Test Forum Removed!

:createfiles
	echo  Copying new files
	echo  __________
	echo D > test_forum_create.tmp
	xcopy "applications\phpBB2" "public_html\phpBB2" /E < test_forum_create.tmp
	del test_forum_create.tmp
	echo  __________
	echo  New files copied!

:dumpdb
	echo  Dumping Database...
	echo DROP DATABASE IF EXISTS testforum; > test_forum_create.tmp
	echo CREATE DATABASE testforum; >> test_forum_create.tmp
	mysql -u root < test_forum_create.tmp
	del test_forum_create.tmp
	mysql -u root -D testforum < public_html/phpBB2/sql_dump.sql
	echo  Database Dumped!

:removeold
	echo  Removing SQL File...
	del "public_html\phpBB2\sql_dump.sql"
	echo  SQL File Removed!

:endbat
	echo  ----
	pause