 |
|
 |
 |
|
|
 |
//-----------------------------------------------------------------
function sql_connect($DBNAME)
{
$HOST = "mysql.caravan.ru";
$USER = "7_angel_7ru";
$PASSWD = "3wj6km";
$DBNAME = "7_angel_7ru";
$db = mysql_connect($HOST, $USER, $PASSWD);
mysql_select_db($DBNAME, $db);
return $db;
}
$dir = "/usr/local/apache/htdocs/img_partners/";
$db=sql_connect();
if (!$addpart) {
$addpart=10;
}
if ($addpart==2) {
if (!$name) {echo "Поле Название обязательно к заполнению!
";$addpart=1;}
if (is_uploaded_file($_FILES["yourfile"]["tmp_name"])) {
$res = move_uploaded_file($_FILES["yourfile"]["tmp_name"], $dir.$_FILES["yourfile"]["name"]);
if (!$res) {echo "Ошибка сохранения логотипа!
";$addpart=1;}
}
}
if ($addpart==4) {
$addpart=3;
}
if ($addpart==6) {
if (!$name) {echo "Поле Название обязательно к заполнению!
";$addpart=3;}
if (is_uploaded_file($_FILES["yourfile"]["tmp_name"])) {
$load_logo_ok=1;
$res = move_uploaded_file($_FILES["yourfile"]["tmp_name"], $dir.$_FILES["yourfile"]["name"]);
if (!$res) {echo "Ошибка сохранения логотипа!
";$addpart=3;}
}
}
if ($addpart==6) {
if ($submit_del) {
$sql="DELETE FROM partners WHERE id=$pid";
$tmp = mysql_query($sql,$db);
}
if ($submit_add) {
if ($logo_old) $logo=$logo_old;
if ($del_logo) $logo="";
if ($load_logo_ok) $logo=$_FILES["yourfile"]["name"];
$name=htmlspecialchars($name);
$email=htmlspecialchars($email);
$url=htmlspecialchars($url);
$text=htmlspecialchars($text);
$logo=htmlspecialchars($logo);
$sql="UPDATE partners SET name='$name',email='$email',url='$url',logo='$logo',sort='$sort',text='$text',is_active='$is_active' WHERE id='$pid';";
$tmp = mysql_query($sql,$db);
}
$addpart=3;
}
if ($addpart==2) {
$sql="select id,sort from partners order by sort;";
$tmp = mysql_query($sql,$db);
while ($tab = mysql_fetch_array($tmp, MYSQL_ASSOC)) {
$sort=$tab["sort"];
}
if ($sort) $sort=$sort+1; else $sort=1;
$logo=$_FILES["yourfile"]["name"];
$name=htmlspecialchars($name);
$email=htmlspecialchars($email);
$url=htmlspecialchars($url);
$text=htmlspecialchars($text);
$logo=htmlspecialchars($logo);
$sql="INSERT INTO partners SET name='$name',email='$email',text='$text',url='$url',logo='$logo',sort='$sort',is_active='$is_active';";
$tmp = mysql_query($sql,$db);
$addpart=3;
}
if ($addpart==8) {
$sql="SELECT id,sort FROM partners ORDER BY sort;";
$tmp = mysql_query($sql,$db);
while ($tab = mysql_fetch_array($tmp, MYSQL_ASSOC)) {
$k++;
$sort_arr[$k]["id"]= $tab["id"];
$sort_arr[$k]["sort"]=$tab["sort"];
}
while (list($key, $val) = each($sort_arr)) {
if ($sort_arr[$key]["id"]==$pid) {
if ($sortd=="up" && $sort_arr[$key-1]["sort"]&&$sort_arr[$key]["sort"]) {
$sql="UPDATE partners SET sort='".$sort_arr[$key-1]["sort"]."' WHERE id='".$sort_arr[$key]["id"]."';";
$tmp = mysql_query($sql,$db);
$sql="UPDATE partners SET sort='".$sort_arr[$key]["sort"]."' WHERE id='".$sort_arr[$key-1]["id"]."';";
$tmp = mysql_query($sql,$db);
}
if ($sortd=="dn" && $sort_arr[$key]["sort"]&&$sort_arr[$key+1]["sort"]) {
$sql="UPDATE partners SET sort='".$sort_arr[$key+1]["sort"]."' WHERE id='".$sort_arr[$key]["id"]."';";
$tmp = mysql_query($sql,$db);
$sql="UPDATE partners SET sort='".$sort_arr[$key]["sort"]."' WHERE id='".$sort_arr[$key+1]["id"]."';";
$tmp = mysql_query($sql,$db);
}
// break;
header ("Location: partners.php?addpart=3");
exit;
}
}
$addpart=3;
}
if ($addpart==3) {
print '';
}
if ($addpart==5) {
$sql="SELECT * FROM partners WHERE id=$pid ;";
$tmp = mysql_query($sql,$db);
$tab = mysql_fetch_array($tmp, MYSQL_ASSOC);
$id=$tab["id"];
$name=$tab["name"];
$url=$tab["url"];
$email=$tab["email"];
$logo=$tab["logo"];
$sort=$tab["sort"];
$text=$tab["text"];
$is_active=$tab["is_active"];
}
if ($addpart==1||$addpart==5) {
?>
";
}
// Вывод списка
if ($addpart==10) {
print '';
print ' ';
print ' ';
print ' ';
print ' ';
$sql="select * from partners where is_active=1 order by sort;";
$tmp = mysql_query($sql,$db);
while ($tab = mysql_fetch_array($tmp, MYSQL_ASSOC)) {
$id=$tab["id"];
$name=$tab["name"];
$url=$tab["url"];
$email=$tab["email"];
$logo=$tab["logo"];
$text=$tab["text"];
print '';
print ' ';
if ($logo) print " ";
print ' | ';
print ' ';
if ($url) print "$name ";
else print "$url$name ";
if ($text) print "$text ";
if ($email) print "e-mail: $email";
print ' | ';
print ' ';
}
print ' ';
}
//-----------------------------------------------------------------
?>
|
|
|
|
 |
|