Евгений Бухарев

SELECT SUM(s.id)*SUM(s.hits) FROM (SELECT p.hits,p.id FROM `htc_post`as p WHERE p.status=2 ORDER BY p.hits DESC LIMIT 4) as s

TIME=`date +%Y-%m-%d-%H-%M-%S`
SERVER_NAME="servername"

MYSQL_FILE=/tmp/$SERVER_NAME-mysql.$TIME.sql.gz
FS_FILE=/tmp/$SERVER_NAME-fs.$TIME.tar.gz

# Archiving databases
mysqldump -u *** --password=*** backup_db | gzip > $MYSQL_FILE
if [ -f $MYSQL_FILE ]; then
    echo $TIME" db dump created"

# Uploading to the cloud
curl --user ***@yandex.ru:***-T "{$MYSQL_FILE}" https://webdav.yandex.ru/backup/database/
#Delete archve
rm $MYSQL_FILE

$model = Hotels::model()->fndByPk(1);
$rooms_model= new Rooms('search');
$rooms_model->hotel_id=$model->id;
$rooms_model->firm_id=Firms::FIRM_ID;
$rooms=$rooms_model->search();

.p2{
display:inline:block;
}

.z1 center{
text-align:center;
}