$title"; die("$msg"); } function SQLerrorFancy($title,$msg){ global $serverpath; global $forum_user; $page_title=$title; include_once "pageheader.php"; echo "

$title

\n $msg"; include_once "pagefooter.php"; } $handle = mysql_pconnect($sql_url,$sql_user,$sql_pass) or SQLerror("MySQL Database", "Error connecting to the MySQL database"); if (!$handle || $handle==0) SQLerror("MySQL Database", "Error connecting to the MySQL database"); mysql_select_db($sql_db,$handle) or die("Error Switching DB"); //define('FORUM_QUIET_VISIT', 1); //define('FORUM_TURN_OFF_MAINT', 1); define('FORUM_DISABLE_CSRF_CONFIRM', 1); define('FORUM_ROOT', $punbb_relative.$punbb_directory.'/'); require FORUM_ROOT.'include/common.php'; if ($forum_user['username']!="Guest"){ if (user_exists($forum_user['username'],$handle)==false){ addUser($forum_user['username'],$forum_user['group_id'],$handle); } login($forum_user['username']); }else{ $_SESSION['user']==""; $_SESSION['auth']==""; } if ($mt_lock_down==true){ if (is_logged_in()==false || is_member_moderator($_SESSION['user'],$handle)==false){ echo ""; SQLerror("Minetest Extensions","Sorry, but Minetest Extensions has been locked down for editing.

$mt_lock_msg

"); } } function curPageURL() { $pageURL = 'http'; if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";} $pageURL .= "://"; if ($_SERVER["SERVER_PORT"] != "80") { $pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"]; } else { $pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"]; } return $pageURL; } function is_logged_in(){ global $forum_user; if ($forum_user['username']!="Guest"){ return true; } return false; } function login($user){ $_SESSION['auth']="somerandomkey"; $_SESSION['user']=$user; } function addUser($user,$level,$handle){ if ($user==""){ return 0; } if (user_exists($user,$handle)) return 4; $res=mysql_query("INSERT INTO users (name,level) VALUES ('$user','$level')"); if ($res==1){ return 1; }else{ return 3; } } function getUser($user,$handle){ $us= mysql_real_escape_string ($user); $res = mysql_query("SELECT * FROM users WHERE name='$us'",$handle) or die("query error"); if(mysql_num_rows($res)==0){ return 0; } $row = mysql_fetch_array($res) or die(""); return $row; } function require_login(){ if (is_logged_in()==false){ header("location: login.php?redir=".curPageURL()); } } function getNoTopics($tag,$handle){ $qu = mysql_real_escape_string ($tag); $res = mysql_query("SELECT * FROM mods WHERE tags LIKE '%$qu%' AND tags NOT LIKE '%dns%'",$handle); return mysql_num_rows($res); } function getUserId($user,$handle){ $qu = mysql_real_escape_string ($user); $res = mysql_query("SELECT * FROM users WHERE name='$qu'",$handle); $row = mysql_fetch_array($res); if (!$row) return false; return $row['id']; } function user_exists($user,$handle){ $qu = mysql_real_escape_string ($user); $res = mysql_query("SELECT * FROM users WHERE name='$qu'",$handle); return mysql_num_rows($res); } function entry_exists($name,$handle){ $qu = mysql_real_escape_string ($name); $res = mysql_query("SELECT * FROM mods WHERE name='$qu'",$handle); return mysql_num_rows($res); } function entry_read($id,$handle){ return false; } function cat_read($id,$handle){ return false; } function getDownload($mod){ if ($mod['repotype']=="git"){ return $mod['file']."/zipball/master"; }else if ($mod['repotype']=="archive"){ if (strstr($mod['tags'],"code")==true){ return "code_mod.php?url=".$mod[9]; }else{ return $mod['file']; } }else{ } return ""; } function tagLinks($tags){ $array=explode(",",$tags); $result=""; foreach ($array as &$a){ $result.=" $a"; } return $result; } function progressBar($percent,$length,$caption){ echo "
"; echo "
"; echo "
$caption
"; echo "
"; } function updateLikes($id,$handle){ $res = mysql_query("SELECT * FROM votes WHERE mod_id=$id AND liked=true",$handle); $result = mysql_num_rows($res); mysql_query("UPDATE mods SET likes=$result WHERE mod_id=$id",$handle); } function updateUser($id,$handle){ $res = mysql_query("SELECT * FROM votes WHERE owner=$id",$handle); $votes = mysql_num_rows($res); $res = mysql_query("SELECT * FROM mods WHERE owner=$id",$handle); $mods = mysql_num_rows($res); mysql_query("UPDATE users SET mods=$mods WHERE id=$id",$handle); $res = mysql_query("SELECT * FROM reviews WHERE owner_id=$id",$handle); $reviews = mysql_num_rows($res); return ($votes!=0 || $mods!=0 || $reviews!=0); } ?>