lstaticl

+10 по 2м проектам. И как раз сегодня закончилась денежка на хостинге.... прям невезение какое-то :)

Notepad++

Или если посерьезнее, Netbeans

бесплатно в ЯК - это почти нереально.

Из ЖЖ и др блогов оч быстро ссылки учитываются

В выдаче очень сильно сниппеты поменялись. И У меня в том числе, хотя хороший АП, по основным запросам наконец-то вышли на топ1 :)

блин, а у меня почему-то не прошла, я ее 26-ого вроде добавил... :(

плохо... -30 :(

Оба сайта точно не на бесплатном двиге (точно не: Joomla, bitrix, shopScript, DLE, drupal, modx, WP, OSc). Вероятно самописные, либо перекроенные платные.

У котеджа в HTML коде много подчеркнуть можно :)

<!-- total queries - 21
cached queries - 20
total time - 0.12

select url from static_page
CACHED

select users.paid_flag as paid,city.name as city,object_.category_id,object_.object_status_id,object_.realty_type_id,object_.currency_id,object_.id,object_.name,object_.price,object_.price_ot,object_.price_do,object_.distance,object_.direction_ids,object_.users_id,object_.city_id,object_.sms_up from object_,users,city where object_.object_status_id=2 and object_.users_id=users.id and object_.city_id=city.id order by object_.sms_up desc, object_.id desc limit 5
CACHED

select * from direction
CACHED

select * from infrastructure_obj
CACHED

select * from currency
CACHED

select * from object_status
CACHED

select * from category
CACHED

select * from realty_type
CACHED

select * from akzia where active_status=1  and FIND_IN_SET('main',category_ids) order by id
0.12

select articles.*,
			city.name as city,
			articles_category.name as category,
		 	articles_category.name_en as cat
		from articles,city, articles_category
		where articles.city_id=city.id 
			and articles.articles_category_id=articles_category.id 
			and articles.active_status=1 
			and articles_category.active_status=1 
			and city.active_status=1  and articles_category_id = 130 order by id desc limit 1
CACHED

select articles.*,
			city.name as city,
			articles_category.name as category,
		 	articles_category.name_en as cat
		from articles,city, articles_category
		where articles.city_id=city.id 
			and articles.articles_category_id=articles_category.id 
			and articles.active_status=1 
			and articles_category.active_status=1 
			and city.active_status=1  and articles_category_id=119 order by id desc limit 1
CACHED

select news.*,city.name as city,news_category.name as category from news,city,news_category where city_id=1 and news_category.id=1 and news.city_id=city.id and news.news_category_id=news_category.id and news.active_status=1 and news_category.active_status=1 and city.active_status=1 order by id desc limit 15
CACHED

select news.*,city.name as city,news_category.name as category from news,city,news_category where city_id!=1 and news_category.id=1 and news.city_id=city.id and news.news_category_id=news_category.id and news.active_status=1 and news_category.active_status=1 and city.active_status=1 order by id desc limit 10
CACHED

select news.*,city.name as city,news_category.name as category from news,city,news_category where news_category.id=115 and news.city_id=city.id and news.news_category_id=news_category.id and news.active_status=1 and news_category.active_status=1 and city.active_status=1 order by id desc limit 5
CACHED

select articles.*,
			city.name as city,
			articles_category.name as category,
		 	articles_category.name_en as cat
		from articles,city, articles_category
		where articles.city_id=city.id 
			and articles.articles_category_id=articles_category.id 
			and articles.active_status=1 
			and articles_category.active_status=1 
			and city.active_status=1  and articles_category_id not in (30, 87, 89, 119, 120, 130) order by id desc limit 3
CACHED

select articles.*,
			city.name as city,
			articles_category.name as category,
		 	articles_category.name_en as cat
		from articles,city, articles_category
		where articles.city_id=city.id 
			and articles.articles_category_id=articles_category.id 
			and articles.active_status=1 
			and articles_category.active_status=1 
			and city.active_status=1  and articles_category_id=87 order by id desc limit 1
CACHED

select news.*,city.name as city,news_category.name as category from news,city,news_category where news_category.id=114 and news.city_id=city.id and news.news_category_id=news_category.id and news.active_status=1 and news_category.active_status=1 and city.active_status=1 order by id desc limit 5
CACHED

select * from city where active_status=1 order by sort_index desc, name
CACHED

select * from direction where city_id=1 order by name
CACHED

select * from currency order by id
CACHED

select main_t.*,city.name as city
		from partners main_t,city
		where main_t.city_id=city.id 
			and main_t.active_status=1 
			and city.active_status=1
CACHED

 -->

Судя по именам таблиц, самописная.

Скиньте в личку УРЛ на сайт, посмотрим что дублируется.

Да это все понятно. И то что update.php, который будет из фала в БД переливать, написать можно за 15-20 мин.

А если у вас на хосте нету MySQL? Тогда тока работа с файлом. (То что таких хостов не так много, это тоже ежу понятно:) )