<?php

function dbconnect() {
	$db = mysql_connect("localhost", "awaldron", "IamMine92");
    if (!$db) { return error("Could not connect to DB.<br>".mysql_error()); }
    else { mysql_select_db("awaldron_ras"); return 1; }
}


function qcol($sql) {
	$res = mysql_query($sql);
	if (mysql_num_rows($res) > 0) {
		for ($i=0; $row = mysql_fetch_row($res); $i++) $arr[$i] = $row[0];
		return $arr;
	} else {
		return FALSE;
	}
}

function qdump($sql,$ctr=1,$out='') {
	$res = mysql_query($sql);
	$num_fields = mysql_num_fields($res);
	if (mysql_num_rows($res) > 0) {
		$out .= '<table border=0 cellspacing=1 cellpadding=4 bgcolor="#999999">'."\n";
		$out .= '<tr bgcolor="#CCCCCC">';
		for ($i=0; $i < $num_fields; $i++) {
			$meta = mysql_fetch_field($res, $i);
			//pre_print_r($meta);
			$out .= '<td><b>'.$meta->name.'</b></td>';
		}
		$out .= '</tr>'."\n";
		for ($j=0; $r = mysql_fetch_row($res); $j++) {
			$out .= '<tr bgcolor="#EEEEEE">';
			for ($i=0; $i < $num_fields; $i++) {
				$out .= '<td>'.$r[$i].'</td>';
			}
			$out .= '</tr>'."\n";
		}
		return $out;
	} else {
		//echo mysql_error();
		return FALSE;
	}
}

function qrow($sql) {
	$res = mysql_query($sql);
	if (mysql_num_rows($res) > 0) {
		$row = mysql_fetch_array($res);
		return $row;
	} else {
		//echo mysql_error();
		return FALSE;
	}
}

function rset($sql) {
	$res = mysql_query($sql);
	if ($res) {
		if (mysql_num_rows($res) > 0) {
			for ($i=0; $row = mysql_fetch_assoc($res); $i++) {
				foreach ($row as $key => $val) $arr[$i][$key] = $val;
			}
			return $arr;
		} else {
			//echo "<P>".$sql."<P>".mysql_error();
			return array();
		}
	} else return FALSE;
}

function qsql($sql) {
	$res = mysql_query($sql);
	if ($res) {
		if (mysql_num_rows($res) == 1) {
			$row = mysql_fetch_row($res);
			return $row[0];
		} else {
			//echo "\n<P>".$sql."\n<P>".mysql_error();
			return FALSE;
		}
	} else return FALSE;
}

function qupdate($sql) {
	if (mysql_query($sql) > 0) return TRUE;
	else {
		//echo "<P>".mysql_error();
		return FALSE;
	}
}

function gallery_reorder( $gal ) {
	$photos = rset("SELECT * FROM ras_gallery_phogal WHERE gal_id=".$gal." ORDER BY `order` ASC");
	$i=1;
	foreach ($photos as $p) {
		$upd = qupdate("UPDATE ras_gallery_phogal SET `order`=".$i." WHERE photo_id=".$p['photo_id']." AND gal_id=".$gal);
		$i++;
	}
}
?>