// *******************************************************************
// include/config.php
// *******************************************************************
// *******************************************************************
// MySQL Connection Information
// leave $dbhost as is. localhost will work on most virtual servers
// change dbuser to your usr login
// change dbpasswd to your login password
// change dbname to your database name
// All the above settings must be completed before installing PHPLinks
// *******************************************************************
// MySQL server hostname
$dbhost = "localhost";
// MySQL server username
$dbuser = "wexfordlin_db1";
// MySQL server password
$dbpasswd = "2Wd3e?g98";
// MySQL database name
$dbname = "wexfordlin_db1";
// *******************************************************************
// phpLinks Language
// choose your language here.
//
// *******************************************************************
$language = "english";
// *******************************************************************
// MySQL Table Names
// *******************************************************************
$tb_categories = "phplinks_categories";
$tb_links = "phplinks_links";
$tb_settings = "phplinks_settings";
$tb_temp = "phplinks_temp";
$tb_related = "phplinks_related";
$tb_terms = "phplinks_terms";
$tb_reviews = "phplinks_reviews";
$tb_specs = "phplinks_specs";
$tb_sessions = "phplinks_sessions";
// *******************************************************************
// Other Settings
//
// *******************************************************************
// These are default values you can set to prefill the blanks
// when you manually add a site from admin. Can be blank as well.
$prefill_email = "user@email.com";
$prefill_username = "username";
$prefill_password = "password";
$prefill_hint = "hint";
?>
// *******************************************************************
// include/functions.php
// *******************************************************************
if($db = mysql_pconnect($dbhost, $dbuser, $dbpasswd)){
mysql_select_db($dbname, $db);
} else {
echo mysql_error();
exit;
}
function sql_query($sql){
global $db;
return @mysql_query($sql, $db);
}
function sql_fetch_array($result){
return @mysql_fetch_array($result);
}
function sql_num_rows($result){
return @mysql_num_rows($result);
}
function sql_insert_id(){
global $db;
return mysql_insert_id($db);
}
function getLangList ($dirName){
global $language;
$d = dir($dirName);
while($entry = $d->read()){
if($entry != "." && $entry != ".." && $entry != "CVS"){
$entry = eregi_replace(".php", "", $entry);
echo "\n";
}
}
$d->close();
}
function getDirList ($dirName){
global $theme;
$d = dir($dirName);
while($entry = $d->read()){
if($entry != "." && $entry != ".." && $entry != "CVS"){
echo "\n";
}
}
$d->close();
}
function getFlagList($dirName, $Country){
$d = dir($dirName);
while($entry = $d->read()){
if($entry != "." && $entry != ".." && $entry != "CVS"){
$short_entry = eregi_replace(".gif", "", $entry);
$short_entry = eregi_replace("_", " ", $short_entry);
$html .= "\n";
}
$get_rows_plus = $catName . eregi_replace("_"," ",$get_rows[Category]);
$get_rows_plus .= " >> ";
admin_drop_cats($get_rows[ID], $get_rows_plus, $cats);
}
}
function admin_drop_top_cats($catID, $catName, &$cats){
global $tb_categories;
$get_cats = sql_query("
select
ID,
Category,
PID,
AllowSites
from
$tb_categories
where
PID='$catID'
order by
Category asc
");
while($get_rows = sql_fetch_array($get_cats)){
$cats .= "\n";
$get_rows_plus = $catName . $get_rows[Category] . " >> ";
admin_drop_top_cats($get_rows[ID], $get_rows_plus, $cats);
}
}
function admin_related_cats($catID, $catName, &$cats){
global $tb_categories;
$get_cats = sql_query("
select
ID,
Category,
PID,
AllowSites
from
$tb_categories
where
PID='$catID'
order by
Category asc
");
while($get_rows = sql_fetch_array($get_cats)){
if($get_rows[AllowSites] == "Y"){
$cats .= "\n";
}
$get_cats_plus = $catName . $get_rows[Category] . " >> ";
admin_related_cats($get_rows[ID], $get_cats_plus, $cats);
}
}
function nav_links($nr, $pp, $pnp, $pn, $url){
global $sr, $functions_1, $functions_2, $functions_3,
$functions_4, $functions_5, $functions_6;
if(!isset($pn)){$pn = 1;}
if($nr > $pp){
$pnav = $functions_1;
$tp = $nr / $pp;
if($tp != intval($tp)){$tp = intval($tp) + 1;}
$cp = 0;
while($cp++ < $tp){
if(($cp < $pn - $pnp or $cp > $pn + $pnp) and $pnp != 0){
if($cp == 1){
$pnav .= " <<" . $functions_2 . " ...";
}
if($cp == $tp){
$pnav .= " ... " . $functions_3 . ">>";
}
} else {
if($cp == $pn){
$pnav .= " [ $cp ]";
} else {
$pnav .= " [ $cp ] ";
}
}
}
}
$pnav .= " ..." . $functions_4;
$pnav .= ($sr + 1)." - ";
if($nr > ($sr + $pp)){
$pnav .= $sr + $pp;
} else {
$pnav .= $nr;
}
$pnav .= $functions_5 . $nr . $functions_6;
return $pnav;
}
function draw_sites($total_sites, $get_sites){
global $pp, $np, $cp, $PID, $show, $table, $functions_7, $functions_8,
$functions_9, $functions_10, $functions_11, $functions_12,
$functions_13, $functions_14, $functions_15, $functions_16,
$functions_17, $functions_18, $table2, $FormattedDate, $main_table,
$user_outer_frame;
if($total_sites > $pp){
// This draws the What's New|Cool|Pop bar
if(isset($show)){
$htmlsrc = $table2 . "
\r\n\t";
$htmlsrc .= "";
$htmlsrc .= $functions_7;
switch ($show) {
case "new":
$htmlsrc .= $functions_8;
break;
case "cool":
$htmlsrc .= $functions_9;
break;
case "pop":
$htmlsrc .= $functions_10;
break;
}
$htmlsrc .= " | \r\n
\r\n\r\n";
$html = whattable("100%","center","",$htmlsrc);
}
$htmlsrc = $table2 . "\r\n\t";
$htmlsrc .= "";
if(isset($show)){
$nav_url = "index.php?show=" . $show . "&";
} else {
$nav_url = "index.php?PID=" . $PID . "&";
}
$htmlsrc .= nav_links($total_sites, $pp, $np, $cp, $nav_url);
$htmlsrc .= " | \r\n
\r\n\r\n";
$html .= navtable("100%","center","",$htmlsrc);
$repeathtml = $htmlsrc;
unset($htmlsrc);
}
if(sql_num_rows($get_sites)>0){
while($sites_array = sql_fetch_array($get_sites)){
$hr++;
$cell_color = "BgTable1";
$i % 2 ? 0: $cell_color = "BgTable2";
$htmlsrc .= $main_table . "";
$htmlsrc .= "\r\n\t";
$htmlsrc .= " ";
$htmlsrc .= "" . stripslashes($sites_array["site_name"]) . "";
$htmlsrc .= " ";
$htmlsrc .= $sites_array["site_url"] . "";
$htmlsrc .= " " . $functions_11 . "";
$htmlsrc .= " " . $functions_12 . "";
$htmlsrc .= "(";
$htmlsrc .= ($sites_array["total_reviews"]+0) . ")";
$htmlsrc .= " ...";
$htmlsrc .= stripslashes($sites_array["site_description"]);
$htmlsrc .= "... ";
$htmlsrc .= "" . $functions_13;
ereg("([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",
$sites_array["added"], $regs) . "";
$htmlsrc .= date($FormattedDate,
mktime($regs[4], $regs[5], $regs[6],
$regs[2], $regs[3], $regs[1]));
$htmlsrc .= " ";
$htmlsrc .= $functions_14;
ereg("([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",
$sites_array[last_update], $regs);
$htmlsrc .= date($FormattedDate,
mktime($regs[4], $regs[5], $regs[6],
$regs[2], $regs[3], $regs[1]));
$htmlsrc .= " ";
$htmlsrc .= $functions_15 . "";
$htmlsrc .= eregi_replace("_"," ",$sites_array[category_name]);
$htmlsrc .= " ";
$htmlsrc .= $functions_16 . $sites_array[hits_in] . "";
$htmlsrc .= " " . $functions_17;
$htmlsrc .= $sites_array[hits_out] . "";
$htmlsrc .= " | \r\n
\r\n\r\n";
$i++;
$html .= table("99%","center","",$htmlsrc);
unset($htmlsrc);
}
} else {
$htmlsrc = $table . "\r\n\t";
$htmlsrc .= " ";
$htmlsrc .= " |
";
$htmlsrc .= $functions_18 . "
| \r\n
\r\n\r\n";
$html .= table("100%","center","",$htmlsrc);
unset($htmlsrc);
}
$html .= navtable("100%","center","",$repeathtml);
unset($repeathtml);
return $html;
}
function draw_search_sites($total_sites, $get_sites, $split_term){
global $pp, $np, $cp, $PID, $show, $sterm, $logic, $maximum, $table,
$functions_19, $functions_11, $functions_12, $functions_13,
$functions_14, $functions_15, $functions_16, $functions_17,
$functions_20, $table2, $FormattedDate, $functions_22,
$user_outer_frame;
if($total_sites > $pp){
$htmlsrc = $table2 . "\r\n\t";
$nav_url = "index.php?logic=" . $logic . "&maximum=";
$nav_url .= $maximum . "&term=" . $sterm . "&";
$htmlsrc .= nav_links($total_sites, $pp, $np, $cp, $nav_url);
$htmlsrc .= " | \r\n
\r\n\r\n";
$repeathtml = $htmlsrc;
$html = navtable("100%","center","",$htmlsrc);
unset($htmlsrc);
}
if(sql_num_rows($get_sites)>0){
$htmlsrc = $table2 . "" . $functions_22 . " |
";
$html .= whattable("100%","center","",$htmlsrc);
unset($htmlsrc);
while($sites_array = sql_fetch_array($get_sites)){
$cell_color = "BgTable1";
$j % 2 ? 0: $cell_color = "BgTable2";
$htmlsrc .= $main_table . "\r\n\t";
$htmlsrc .= " ";
$htmlsrc .= "" . stripslashes($sites_array[site_name]);
$htmlsrc .= " ";
$su = "" . $sites_array[site_url];
$su .= "";
$i = 0;
while($split_term[$i]){
$su_html = eregi_replace("($split_term[$i])","\\1", $su);
$su = $su_html;
$i++;
}
$htmlsrc .= $su;
$htmlsrc .= " " . $functions_11 . "";
$htmlsrc .= " " . $functions_12 . "";
$htmlsrc .= "(";
$htmlsrc .= ($sites_array[total_reviews]+0) . ")";
$htmlsrc .= " ";
$sd = stripslashes($sites_array[site_description]);
$i = 0;
while($split_term[$i]){
$sd_html = eregi_replace("($split_term[$i])","\\1", $sd);
$sd = $sd_html;
$i++;
}
$htmlsrc .= "..." . $sd . "... ";
$htmlsrc .= "" . $functions_13;
ereg("([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$sites_array[added], $regs);
$htmlsrc .= date($FormattedDate,mktime($regs[4], $regs[5], $regs[6],$regs[2],$regs[3], $regs[1]));
$htmlsrc .= " ";
$htmlsrc .= $functions_14;
ereg("([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$sites_array[last_update], $regs);
$htmlsrc .= date($FormattedDate,mktime($regs[4], $regs[5], $regs[6],$regs[2],$regs[3], $regs[1]));
$htmlsrc .= " ";
$htmlsrc .= $functions_15 . "";
$htmlsrc .= eregi_replace("_", " ", $sites_array[category_name]);
$htmlsrc .= " ";
$htmlsrc .= $functions_16 . $sites_array[hits_in] . "";
$htmlsrc .= " " . $functions_17;
$htmlsrc .= $sites_array[hits_out] . "";
$htmlsrc .= " | \r\n
\r\n\r\n";
$j++;
$html .= table("99%","center","",$htmlsrc);
unset($htmlsrc);
}
} else {
$htmlsrc .= $table2 . "";
$htmlsrc .= "\r\n\t ";
$htmlsrc .= $functions_20 . "
| \r\n
\r\n\r\n";
$html .= navtable("100%","center","",$htmlsrc);
unset($htmlsrc);
}
$html .= whattable("100%","center","",$repeathtml);
unset($repeathtml);
return $html;
}
function draw_search_categories($get_categories, $split_term){
global $sterm, $table, $table2, $tb_categories, $functions_21;
if(sql_num_rows($get_categories)>0){
$htmlsrc = $table2 . "";
$htmlsrc .= "\r\n\t" . $functions_21;
$htmlsrc .= " | \r\n
\r\n";
$html = whattable("100%","center","",$htmlsrc);
unset($htmlsrc);
$htmlsrc = $table2 . "\r\n\t";
while($cats_array = sql_fetch_array($get_categories)){
$gcid = $cats_array[category_id];
while($gcid > 0){
$mlc_sql = "
select
*
from
$tb_categories
where
ID = '$gcid'
";
$mlc_query = sql_query($mlc_sql);
$mlc_array = sql_fetch_array($mlc_query);
$cat_array[] = $mlc_array["Category"];
$pid_array[] = $mlc_array["ID"];
$gcid = $mlc_array["PID"];
}
$count = sizeof($pid_array);
$cat_html .= "";
for($depth=$count; $depth>=0; $depth--){
if(isset($pid_array[$depth])){
$build_cat_html .= " >> ";
$build_cat_html .= ereg_replace("_"," ",
($cat_array[$depth]));
$p++;
}
}
$i = 0;
while($split_term[$i]){
$bolded_cat_html = eregi_replace("($split_term[$i])",
"\\1",
$build_cat_html);
$i++;
}
unset($build_cat_html);
$cat_html .= $bolded_cat_html . " ";
unset($bolded_cat_html);
if($p == $count){
$cat_html .= " ";
}
$htmlsrc .= $cat_html;
unset($cat_html);
unset($pid_array);
unset($cat_array);
unset($p);
unset($count);
}
$htmlsrc .= " | \r\n
\r\n\r\n";
$html .= table("98%","center","",$htmlsrc);
unset($htmlsrc);
}
return $html;
}
function getmicrotime(){
list($sec, $usec) = explode(" ", microtime());
return ($sec + $usec);
}
?>
// *******************************************************************
// include/common.php
// *******************************************************************
$gl_sql = "
select
*
from
$tb_settings
where
ID='1'
";
$gl_query = sql_query($gl_sql);
$gl = sql_fetch_array($gl_query);
$validate = $gl["ManuallyValidate"];
$url_validate = $gl["URLValidate"];
$email_submission = $gl["NewSubmissionEmail"];
$email_deletion = $gl["SiteDeletionEmail"];
$email_addition = $gl["SiteAdditionEmail"];
$default_country = $gl["DefaultCountry"];
$colcount = $gl["ColCount"];
$pp = $gl["PerPage"];
$np = $gl["NavLinks"];
$base_path = $gl["BasePath"];
$base_url = $gl["BaseURL"];
$site_title = $gl["SiteTitle"];
$owner_name = $gl["Name"];
$owner_email = $gl["Email"];
$FormattedDate = $gl["DateFormat"];
$user_outer_frame = $gl["OuterFrame"];
$adm_body = "";
$menu_body = "";
$top_body = "";
?>
$session_key = "id";
$session_value = "data";
$session_time = "expire";
$sdbh = "";
$expire = 300;
function sess_open($save_path, $session_name){
global $dbhost, $dbuser, $dbpasswd, $sdbh;
if (! $sdbh = mysql_pconnect($dbhost, $dbuser, $dbpasswd)){
echo mysql_error();
exit;
}
return true;
}
function sess_close(){
return true;
}
function sess_read($key){
global $sdbh, $dbname, $tb_sessions, $session_key, $session_value, $session_time;
$query = "
select
$session_value
from
$tb_sessions
where
$session_key = '$key'
and
$session_time > UNIX_TIMESTAMP()
";
$result = mysql_db_query($dbname, $query, $sdbh);
if($record = mysql_fetch_row($result)){
return $record[0];
} else {
return false;
}
}
function sess_write($key, $val){
global $sdbh, $dbname, $tb_sessions, $expire;
$value = addslashes($val);
$query = "
replace into
$tb_sessions
values (
'$key',
'$value',
UNIX_TIMESTAMP() + $expire
)
";
$result = mysql_db_query($dbname, $query, $sdbh);
echo mysql_error();
return $result;
}
function sess_destroy($key){
global $sdbh, $dbname, $tb_sessions, $session_key;
$query = "
delete from
$tb_sessions
where
$session_key = '$key'
";
$result = mysql_db_query($dbname, $query, $sdbh);
return $result;
}
function sess_gc($maxlifetime){
global $sdbh, $dbname, $tb_sessions, $session_time;
$query = "
delete from
$tb_sessions
where
$session_time < UNIX_TIMESTAMP()
";
$result = mysql_db_query($dbname, $query, $sdbh);
return mysql_affected_rows($sdbh);
}
session_set_save_handler("sess_open","sess_close","sess_read","sess_write","sess_destroy","sess_gc");
?>
No Web Site