From 866658cded5b92ddb2681dead1ebaf111d712fcc Mon Sep 17 00:00:00 2001 From: cassiopc Date: Mon, 6 Aug 2012 11:09:10 +0200 Subject: init --- boca-1.5.0/src/private/createdb.php | 70 +++++++++++++++++++++++++++++++++++++ 1 file changed, 70 insertions(+) create mode 100644 boca-1.5.0/src/private/createdb.php (limited to 'boca-1.5.0/src/private/createdb.php') diff --git a/boca-1.5.0/src/private/createdb.php b/boca-1.5.0/src/private/createdb.php new file mode 100644 index 0000000..e06682d --- /dev/null +++ b/boca-1.5.0/src/private/createdb.php @@ -0,0 +1,70 @@ +#!/usr/bin/php +. +//////////////////////////////////////////////////////////////////////////////// +//Last updated 21/jul/2012 by cassio@ime.usp.br +$ds = DIRECTORY_SEPARATOR; +if($ds=="") $ds = "/"; + +if(is_readable(getcwd() . $ds . '..' .$ds . 'db.php')) { + require_once(getcwd() . $ds . '..' .$ds . 'db.php'); + @include_once(getcwd() . $ds . '..' .$ds . 'version.php'); +} else { + if(is_readable(getcwd() . $ds . 'db.php')) { + require_once(getcwd() . $ds . 'db.php'); + @include_once(getcwd() . $ds . 'version.php'); + } else { + echo "unable to find db.php"; + exit; + } +} +if (getIP()!="UNKNOWN" || php_sapi_name()!=="cli") exit; +ini_set('memory_limit','600M'); +ini_set('output_buffering','off'); +ini_set('implicit_flush','on'); +@ob_end_flush(); + +if(system('test "`id -u`" -eq "0"',$retval)===false || $retval!=0) { + echo "Must be run as root\n"; + exit; +} +echo "\nThis will erase all the data in your bocadb database."; +echo "\n***** YOU WILL LOSE WHATEVER YOU HAVE THERE!!! *****"; +echo "\nType YES and press return to continue or anything else will abort it: "; +$resp = strtoupper(trim(fgets(STDIN))); +if($resp != 'YES') exit; + +echo "\ndropping database\n"; +DBDropDatabase(); +echo "creating database\n"; +DBCreateDatabase(); +echo "creating tables\n"; +DBCreateContestTable(); +DBCreateSiteTable(); +DBCreateSiteTimeTable(); +DBCreateUserTable(); +DBCreateLogTable(); +DBCreateProblemTable(); +DBCreateAnswerTable(); +DBCreateTaskTable(); +DBCreateLangTable(); +DBCreateRunTable(); +DBCreateClarTable(); +DBCreateBkpTable(); +echo "creating initial fake contest\n"; +DBFakeContest(); +?> -- cgit v1.2.3