debug ( '/db/dbMain.inc included' );
require incPath . 'configDb.inc.php';
require incPath . '_db/driver/' . dbDriver . '.inc.php';
function db_NameFromUrl( $user ) { debug( "fn. db_NameFromUrl" );
$sql = "SELECT name FROM _User WHERE url = '$user'";
return dbGetOne( $sql );
}
function db_activeUsernameArray() { debug( "fn. db_activeUsernameArray" );
$sql = 'SELECT username
FROM _User
WHERE status = "active"
ORDER BY ord';
return dbGetCol( $sql );
}
function db_menuUsernameArray() { debug( "fn. db_menuUsernameArray" );
$sql = 'SELECT DISTINCT url, name
FROM _User
LEFT JOIN _Content USING (user_id)
WHERE _User.status = "active"
AND _Content.status = "active"
ORDER BY ord';
return dbGet2ColAssoc( $sql );
}
function db_menuUsernameAboutMeArray() { debug( "fn. db_menuUsernameAboutMeArray" );
$sql = 'SELECT username
FROM _User
LEFT JOIN _Content USING (user_id)
WHERE _User.status = "active"
AND _Content.status = "aboutMeActive"
ORDER BY ord';
return dbGetCol( $sql );
}
function db_contentAllActive() { debug( "fn. db_contentAllActive ()" );
$sql = "SELECT cont_id, title, text, username, DATE_FORMAT(dateTime, '%e.%c.%Y, %k.%i') dateTime
FROM _Content
INNER JOIN _User USING (user_id)
WHERE _Content.status = 'active'
AND _User.status = 'active'
ORDER BY _Content.dateTime DESC
LIMIT 29";
return dbGetTable( $sql );
}
function db_allActiveUserContents( $user ) {
$user = mysql_real_escape_string($user); debug( "fn. db_allActiveUserContents ($user)" );
$sql = "SELECT cont_id, title, text, DATE_FORMAT(dateTime, '%e.%c.%Y, %k.%i') dateTime
FROM _Content
INNER JOIN _User USING (user_id)
WHERE url = '$user'
AND _Content.status = 'active'
AND _User.status = 'active'
ORDER BY _Content.dateTime";
return dbGetTable( $sql );
}
function db_Content( $cont_id ) {# title and text
$cont_id = (int) $cont_id; debug( "fn. db_Content ($cont_id)" );
$sql = "SELECT
title, text, DATE_FORMAT(dateTime, '%e.%c.%Y, %k.%i') dateTime, _Content.status,
username
FROM _Content
INNER JOIN _User USING (user_id)
WHERE cont_id = $cont_id";
return dbGetRowAssoc( $sql );
}
function db_loginChk( $username, $password ) {
$username = mysql_real_escape_string( $username );
$password = mysql_real_escape_string( $password ); debug( "fn. db_loginChk ($username, $password)" );
$sql = "SELECT user_id, status FROM _User WHERE username = '$username' AND password = '$password'";
return dbGetRow( $sql );
}
function db_image_id_last() {
$sql = "SELECT img_id FROM _Image ORDER BY img_id DESC LIMIT 1";
return dbGetOne( $sql );
}
function db_image_id_user_insert( $user_id) {
$user_id = (int) $user_id;
$sql = "INSERT INTO _Image (user_id) VALUES ( $user_id)";
return dbExec( $sql );
}
function db_image_id_user_last( $user_id ) {
$user_id = (int) $user_id;
$sql = "SELECT img_id FROM _Image WHERE user_id = $user_id ORDER BY img_id DESC LIMIT 1";
return dbGetOne( $sql );
}
function db_Image_id_user( $user_id ) {
$user_id = (int) $user_id;
$sql = "SELECT img_id FROM _Image WHERE user_id = $user_id ORDER BY img_id";
return dbGetCol( $sql );
}
function db_ContentsUser( $user_id, $type=null ) {
$user_id = (int) $user_id; debug( "fn. db_ContentsUser ($user_id)" );
if ($type=='aboutMe') $sql = "SELECT cont_id, title, text, status FROM _Content WHERE user_id = $user_id AND status IN ('aboutMeActive', 'aboutMeInactive') ORDER BY dateTime DESC";
else $sql = "SELECT cont_id, title, text, status FROM _Content WHERE user_id = $user_id AND status IN ('active', 'inactive') ORDER BY dateTime DESC";
return dbGetTable( $sql );
}
function db_contentEdit( $cont_id, $title, $text, $status ) {
if ($title && $text) {
$cont_id = (int) $cont_id;
$title = mysql_real_escape_string( $title );
$text = mysql_real_escape_string( $text ); debug( "fn. db_ContentsEdit ($cont_id, $title, $text)" );
$sql = "UPDATE _Content SET title = '$title', text='$text', status='$status' WHERE cont_id=$cont_id";
return dbExec( $sql );
}
}
function db_contentInsert( $user_id, $title, $text, $status='active' ) {
if ($title && $text) {
$user_id = (int) $user_id;
$title = mysql_real_escape_string( $title );
$text = mysql_real_escape_string( $text ); debug( "fn. db_ContentsInsert ($user_id, $title, $text, $status)" );
$sql = "INSERT INTO _Content
(user_id, status, dateTime, title, text) VALUES
( $user_id, '$status', now(), '$title', '$text')";
return dbExec( $sql );
}
}
function db_aboutMeActiveContents( $user ) {
$user = mysql_real_escape_string($user); debug( "fn. db_aboutMeActiveContents ($user)" );
$sql = "SELECT cont_id, title, text, DATE_FORMAT(dateTime, '%e.%c.%Y, %k.%i') dateTime
FROM _Content
INNER JOIN _User USING (user_id)
WHERE url = '$user'
AND _Content.status = 'aboutMeActive'
AND _User.status = 'active'
ORDER BY _Content.dateTime DESC
LIMIT 1";
return dbGetRowAssoc( $sql );
}
?> debug ( '/inc/createPage.inc.php included' );
# gets some basic page data and includes page template file
function db2html( $text ) { # 1.) \n (new line) ->
2.) [003] ->
$text = nl2br($text);
$text = str_replace(' ', ' ', $text);
$offset = 0;
while ($pos = strpos( $text, '[', $offset )) {
$id = substr( $text, $pos+1, 3 ); # echo "
$filenamefile path:
$filePath"); if (file_exists($filePath)) require $filePath; elseif ( serverType == 'dev' && debug ) debug( "Warning: template file
$filenamefile path:
$filePathis missing!", usrError); ?>