echo " <link>http:" . $sys_url . "</link>\n"; echo " <description>" . htmlspecialchars($sys_name . " - " . $sys_title) . "</description>\n"; echo " <language>en-us</language>\n"; echo " <image>\n"; echo " <title>" . htmlspecialchars($sys_name) . "</title>\n"; echo " <url>http:" . $sys_url . $sys_logo_small_image . "</url>\n"; echo " <link>http:" . $sys_url . "</link>\n"; echo " <description>" . htmlspecialchars($sys_name . " - " . $sys_title) . "</description>\n"; echo " <width>66</width>\n"; echo " <height>73</height>\n"; echo " </image>\n"; echo " <item>\n"; echo " <title><b>News:</b></title>\n"; echo " <link>http:" . $sys_url . "news.php</link>\n"; echo " </item>\n"; $db = new DB_SourceBiz(); $db->query("SELECT * FROM news WHERE news.status_new='A' ORDER BY news.modification_new DESC limit 5"); $i = 0; while ($db->next_record()) { echo " <item>\n"; echo " <title>" . htmlspecialchars($db->f("subject_new")) . "</title>\n"; echo " <link>http:" . $sys_url . "newbynewid.php?id=" . $db->f("newid") . "</link>\n"; echo " </item>\n"; $i++; } $blklen = 5; $time = floor(time() / 5); $db->query("SELECT COUNT(*) as cnt FROM enterprise WHERE enterprise.status='A'"); $db->next_record(); $entcnt = $db->f("cnt"); $blkcnt = floor($entcnt / $blklen);
# # $Id: inscat.php,v 1.2 2003/02/25 11:45:44 helix Exp $ # ###################################################################### require "./include/prepend.php3"; page_open(array("sess" => "SourceBiz_Session", "auth" => "SourceBiz_Auth", "perm" => "SourceBiz_Perm")); require "./include/header.inc"; $bx = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align); $be = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align); ?> <!-- content --> <?php if ($perm->have_perm("admin")) { if (isset($category) && !empty($category)) { $dbcat = new DB_SourceBiz(); // Look if Category is already in table $columns = "*"; $tables = "categories"; $where = "type='{$type}' AND category='{$category}'"; if (!$dbcat->query("SELECT {$columns} FROM {$tables} WHERE {$where}")) { mysql_die($dbcat); } else { switch ($action) { case "ins": if ($dbcat->num_rows() > 0) { $be->box_full($t->translate("Error"), $t->translate("Category") . " {$category} " . $t->translate("already exists")); } else { $set = "type='{$type}',category='{$category}'"; if (!$dbcat->query("INSERT {$tables} SET {$set}")) { mysql_die($dbcat);
require "./include/config.inc"; require "./include/lib.inc"; echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n"; echo "<!DOCTYPE rss PUBLIC \"-//Netscape Communications//DTD RSS 0.91//EN\"\n"; echo " \"http://my.netscape.com/publish/formats/rss-0.91.dtd\">\n"; echo "<rss version=\"0.91\">\n"; echo " <channel>\n"; echo " <title>" . htmlspecialchars($sys_name) . " - News</title>\n"; echo " <link>http:" . $sys_url . "</link>\n"; echo " <description>" . htmlspecialchars($sys_name . " - " . $sys_title) . "</description>\n"; echo " <language>en-us</language>\n"; echo " <image>\n"; echo " <title>" . htmlspecialchars($sys_name) . "</title>\n"; echo " <url>http:" . $sys_url . $sys_logo_small_image . "</url>\n"; echo " <link>http:" . $sys_url . "</link>\n"; echo " <description>" . htmlspecialchars($sys_name . " - " . $sys_title) . "</description>\n"; echo " <width>66</width>\n"; echo " <height>73</height>\n"; echo " </image>\n"; $db = new DB_SourceBiz(); $db->query("SELECT * FROM news WHERE news.status_new='A' ORDER BY news.modification_new DESC limit 5"); $i = 0; while ($db->next_record()) { echo " <item>\n"; echo " <title>" . htmlspecialchars($db->f("subject_new")) . "</title>\n"; echo " <link>http:" . $sys_url . "newbynewid.php?id=" . $db->f("newid") . "</link>\n"; echo " </item>\n"; $i++; } echo " </channel>\n"; echo "</rss>\n";
} else { // If enterprise id specified if (isset($id)) { // Look if enterprise is already in table $columns = "*"; $tables = "enterprise"; $where = "entid='{$id}'"; if (!$db->query("SELECT {$columns} FROM {$tables} WHERE {$where}")) { mysql_die($db); } else { // If enterprise in table if ($db->next_record()) { // If enterprise owner is logged in user if ($db->f("user") == $auth->auth["uname"] || $perm->have_perm("admin")) { // Look if profile is already in table $dbprf = new DB_SourceBiz(); $columns = "*"; $tables = "profile,enterprise"; $where = "entid_prf='{$id}' AND enterprise.entid = profile.entid_prf"; if ($dbprf->query("SELECT {$columns} FROM {$tables} WHERE {$where}")) { // If profile in table if ($dbprf->next_record()) { // Modify existing profile prfmod($dbprf); } else { // Insert new profile prfform($db); } } else { mysql_die($db); }
if ($bystr == "") { $bystr = $t->translate("All"); } $bx->box_title($t->translate("Users") . ": " . $bystr); $bx->box_body_begin(); ?> <table border=0 align=center cellspacing=1 cellpadding=1 width=100%> <?php echo "<tr><td><b>" . $t->translate("No") . ".</b></td><td><b># " . $t->translate("Ent") . "</b></td><td><b>" . $t->translate("Username") . "</b></td><td><b>" . $t->translate("Realname") . "</b></td><td><b>" . $t->translate("E-Mail") . "</b></td></tr>\n"; $i = 1; while ($db->next_record()) { $columns = "COUNT(*)"; $tables = "enterprise"; $where = "user=\"" . $db->f("username") . "\" AND status=\"A\""; $num = ""; $dbn = new DB_SourceBiz(); if ($dbn->query("SELECT {$columns} AS cnt FROM {$tables} WHERE {$where}")) { $dbn->next_record(); $num = "[" . sprintf("%03d", $dbn->f("cnt")) . "]"; } echo "<tr><td>" . sprintf("%d", $i) . "</td>\n"; echo "<td><a href=\"" . $sess->url("enterprises.php") . $sess->add_query(array("by" => "filter", "author" => $db->f("username"))) . "\">{$num}</a></td>\n"; echo "<td>" . $db->f("username") . "</td>\n"; echo "<td>" . $db->f("realname") . "</td>"; echo "<td><<a href=\"mailto:" . mailtoencode($db->f("email_usr")) . "\">" . ereg_replace("@", " at ", htmlentities($db->f("email_usr"))) . "</a>></td>"; echo "</tr>\n"; $i++; } echo "</table>\n"; } $bx->box_body_end();
# it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2 or later of the GPL. # # $Id: recentnews.php,v 1.2 2003/02/25 11:45:44 helix Exp $ # ###################################################################### require "./include/prepend.php3"; page_open(array("sess" => "SourceBiz_Session")); if (isset($auth) && !empty($auth->auth["perm"])) { page_close(); page_open(array("sess" => "SourceBiz_Session", "auth" => "SourceBiz_Auth", "perm" => "SourceBiz_Perm")); } header("Content-Type: text/plain"); // Disabling cache header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1 header("Pragma: no-cache"); // HTTP/1.0 require "./include/config.inc"; require "./include/lib.inc"; $db = new DB_SourceBiz(); $db->query("SELECT * FROM news WHERE news.status_new='A' ORDER BY news.modification_new DESC limit 10"); $i = 0; while ($db->next_record()) { echo $db->f("subject_new") . "\n"; $timestamp = mktimestamp($db->f("modification_new")); echo timestr($timestamp) . "\n"; echo $sys_url . "newbynewid.php?id=" . $db->f("newid") . "\n"; $i++; } @page_close();
echo " \"http://my.netscape.com/publish/formats/rss-0.91.dtd\">\n"; echo "<rss version=\"0.91\">\n"; echo " <channel>\n"; echo " <title>" . htmlspecialchars($sys_name) . " - Enterprises</title>\n"; echo " <link>http:" . $sys_url . "</link>\n"; echo " <description>" . htmlspecialchars($sys_name . " - " . $sys_title) . "</description>\n"; echo " <language>en-us</language>\n"; echo " <image>\n"; echo " <title>" . htmlspecialchars($sys_name) . "</title>\n"; echo " <url>http:" . $sys_url . $sys_logo_small_image . "</url>\n"; echo " <link>http:" . $sys_url . "</link>\n"; echo " <description>" . htmlspecialchars($sys_name . " - " . $sys_title) . "</description>\n"; echo " <width>66</width>\n"; echo " <height>73</height>\n"; echo " </image>\n"; $db = new DB_SourceBiz(); $blklen = 5; $time = floor(time() / 5); $db->query("SELECT COUNT(*) as cnt FROM enterprise WHERE enterprise.status='A'"); $db->next_record(); $entcnt = $db->f("cnt"); $blkcnt = floor($entcnt / $blklen); if ($entcnt % $blklen > 0) { $blkcnt += 1; } $offset = $time % $blkcnt; if ($offset == 0) { $offset = $blkcnt; } $offset = $offset * $blklen - $blklen; if ($offset + $blklen >= $entcnt) {
###################################################################### require "./include/prepend.php3"; page_open(array("sess" => "SourceBiz_Session", "auth" => "SourceBiz_Auth", "perm" => "SourceBiz_Perm")); require "./include/header.inc"; $bx = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align); $be = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align); ?> <!-- content --> <?php if ($perm->have_perm("admin")) { ### ### Submit Handler ### ## Get a database connection $db = new DB_SourceBiz(); // Check if there was a submission while (is_array($HTTP_POST_VARS) && (list($key, $val) = each($HTTP_POST_VARS))) { switch ($key) { case "create": // Create a new user if (empty($username) || empty($password) || empty($email_usr)) { // Do we have all necessary data? $be->box_full($t->translate("Error"), $t->translate("Please enter") . " <B>" . $t->translate("Username") . "</B>, <B>" . $t->translate("Password") . "</B> " . $t->translate("and") . " <B>" . $t->translate("E-Mail") . "</B>!"); break; } /* Does the user already exist? NOTE: This should be a transaction, but it isn't... */ $db->query("select * from auth_user where username='******'"); if ($db->nf() > 0) { $be->box_full($t->translate("Error"), $t->translate("User") . " <B>{$username}</B> " . $t->translate("already exists") . ".");
if (!$db->query("SELECT {$columns} FROM {$tables} WHERE {$where}")) { mysql_die($db); } else { $db->next_record(); // Move uploaded logo to logo directory if (!empty($logo_name)) { $to = $sys_logo_dir . $db->f("entid") . "ent_" . basename($logo_name); if (!copy($logo, $to)) { $be->box_full($t->translate("Error"), $t->translate("Unable to copy logofile to logo directory")); } if (!chmod($to, 0666)) { $be->box_full($t->translate("Error"), $t->translate("Unable to change logofile mode")); } } // Insert new counters $dbcnt = new DB_SourceBiz(); $tables = "counter"; $set = "entid=" . $db->f("entid"); if (!$dbcnt->query("INSERT {$tables} SET {$set}")) { mysql_die($dbcnt); } else { // Select and show new enterprise with counters entbyentid($db, $db->f("entid")); if ($ml_notify) { $msg = "insert enterprise {$name} by " . $auth->auth["uname"] . "."; mailuser("admin", "insert enterprise", $msg); } } } } }
###################################################################### require "./include/prepend.php3"; page_open(array("sess" => "SourceBiz_Session", "auth" => "SourceBiz_Auth", "perm" => "SourceBiz_Perm")); require "./include/header.inc"; $bx = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align); $bi = new box("80%", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align); $be = new box("", $th_box_frame_color, $th_box_frame_width, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_error_font_color, $th_box_body_align); ?> <!-- content --> <?php ### ### Submit Handler ### ## Get a database connection $db = new DB_SourceBiz(); // Check if there was a submission while (is_array($HTTP_POST_VARS) && (list($key, $val) = each($HTTP_POST_VARS))) { switch ($key) { case "u_edit": // Change user parameters if ($auth->auth["uid"] == $u_id) { // user changes his own account $password = trim($password); $cpassword = trim($cpassword); $realname = trim($realname); $email_usr = trim($email_usr); if (strcmp($password, $cpassword)) { // password are identical? $be->box_full($t->translate("Error"), $t->translate("The passwords are not identical") . ". " . $t->translate("Please try again") . "!"); break;
header("Pragma: no-cache"); // HTTP/1.0 require "./include/config.inc"; require "./include/newlib.inc"; require "./include/entlib.inc"; require "./include/conlib.inc"; require "./include/svclib.inc"; require "./include/prolib.inc"; require "./include/sollib.inc"; require "./include/cuslib.inc"; require "./include/cmtlib.inc"; require "./include/translation.inc"; require "./include/lang.inc"; require "./include/box.inc"; $t = new translation($la); $db = new DB_SourceBiz(); $bx = new box("95%", $th_box_frame_color, 0, $th_box_title_bgcolor, $th_box_title_font_color, $th_box_title_align, $th_box_body_bgcolor, $th_box_body_font_color, $th_box_body_align); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <meta http-equiv="expires" content="0"> <meta http-equiv="Refresh" content="1200; URL=<?php echo $sys_url . "sitebar.php"; ?> "> <title><?php echo $sys_name; ?> - <?php