卓众外网 卓众数字化平台-----------------------------------------------------------------------------------------------------------------------------------------------
内网地址:172.20.10.212
外网地址:114.255.9.212
服务器账号: iwomedia iwomedia8151
web服务器路径:/home/y/etc/nginx/
mydql账号 iwomedia iwomedia
部署的项目
项目名称:
卓众数字化平台
项目URL:
new.bjzzcd.com; new1.bjzzcb.com; 172.20.10.212
管理员账号:iwo.zhubian@iwomedia.cn
管理员密码:123456
远程地址:
/home/y/share/htdocs/wormhole
卓众内网 JIRA-----------------------------------------------------------------------------------------------------------------------------------------------
名称:卓众内网
内网地址:172.20.37.17
服务器账号 zhaitao zhaitao
web服务器路径:/etc/nginx
MYSQL数据库账号密码 iwomedia iwomedia
---------------------------------------------------------
项目名称:
JIRA BUG跟踪
项目URL:
http://pm.iwomedia.cn/
管理员账号:zhaitao@iwomedia.cn
管理员密码:19*****6!h****d
远程地址:
/home/xingy/pm/jira
备注: 这个是用tomcat搭建的,监听的是9080端口。
美滴滴线上 美滴滴医院端后台 美滴滴运营后台 美滴滴接口 匠客测试版---------------------------------------------------------------------------------------------------------------------------
内网地址:10.10.32.149
外网地址:120.132.52.158
服务器账号: fuq fuq
web服务器路径:/etc/nginx
MYSQL数据库账号密码 root ubuntu@158
部署的项目
---------------------------------------------------------
项目名称:
美滴滴医院端后台
项目URL:
yiyuan.meididi.iwomedia.cn
管理员账号:yiyuan
管理员密码:123456
远程地址:
/data/web/htdocs/yimei/
---------------------------------------------------------
项目名称:
美滴滴运营后台
项目URL:
admin.meididi.iwomedia.cn
管理员账号:yangxl
管理员密码:123456
远程地址:
/data/web/htdocs/yimei/
---------------------------------------------------------
项目名称:
美滴滴接口 线上
项目URL:
api.meididi.iwomedia.cn
远程地址:
/data/web/htdocs/yimei/
内网
yimei.iwomedia.cn/api.php?r=
接口的配置文件在卓众外网114.255.9.212
---------------------------------------------------------
项目名称:
匠客测试版
项目URL:
http://dev.jker.iwomedia.cn/
管理员账号:admin@admin.com
管理员密码:jker123
远程地址:
/home/zhaitao/jker/
备注: 项目未必是最新的,可能是从/home/piaojh/jkerweb/trunk/htdocs/jker复制过来的
---------------------------------------------------------
卓众接口服务器 导购beta-----------------------------------------------------------------------------------------------------------------------------------------------
内网地址:10.10.8.147
外网地址:180.150.179.141
服务器账号 yangxiulian xiulian123456
web服务器路径:/home/y/etc/nginx/
MYSQL数据库账号密码 iwomedia iwomedia
---------------------------------------------------------
中机象屿-----------------------------------------------------------------------------------------------------------------------------------------------
外网地址:123.57.155.146
服务器账号 root Zjxy2aliyun
web服务器路径:/home/y/etc/nginx/
MYSQL数据库账号密码 iwomedia iwomedia
联系人QQ:515929555付天一 55560661编辑一枚
---------------------------------------------------------
IDFA :select distinct idfa from app_idfa where channel=2 and is_callback=1 and instime<1448899200 and instime>=1446307200 into outfile '/tmp/14.xls'
按天统计阅读数。date_format(article_instime, '%Y-%m-%d') 将数据库中的2016-10-01 17:32:27改成2016-10-01
select date_format(article_instime, '%Y-%m-%d') as '日期',sum(view_nums) as '阅读数',sum(share_view_nums) as '分享阅读数' from app_article where article_instime>='2016-01-09' and article_instime<='2016-03-26' group by date_format(article_instime, '%Y%m%d') order by article_instime asc
FROM_UNIXTIME(instime,'%Y%m%d')将数据库中的1435237700 改成2016-10-01
SELECT FROM_UNIXTIME(instime,'%Y%m%d') as 时间,count(*) as 总数
FROM `app_idfa` where channel=2 group by FROM_UNIXTIME(instime,'%Y%m%d') order by instime asc
select DATE_FORMAT(create_time,'%Y%u') weeks,count(caseid) count from tc_case group by weeks; select DATE_FORMAT(create_time,'%Y%m%d') days,count(caseid) count from tc_case group by days; select DATE_FORMAT(create_time,'%Y%m') months,count(caseid) count from tc_case group by months;
按周统计阅读、分享数。
select '2015-09-06','--','2015-09-13',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-09-06' and article_instime<'2015-09-13' union
select '2015-09-13','--','2015-09-20',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-09-13' and article_instime<'2015-09-20' union
select '2015-09-20','--','2015-09-27',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-09-20' and article_instime<'2015-09-27' union
select '2015-10-04','--','2015-10-11',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-10-04' and article_instime<'2015-10-11' union
select '2015-10-11','--','2015-10-18',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-10-11' and article_instime<'2015-10-18' union
select '2015-10-18','--','2015-10-25',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-10-18' and article_instime<'2015-10-25' union
select '2015-11-01','--','2015-11-08',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-11-01' and article_instime<'2015-11-08' union
select '2015-11-08','--','2015-11-15',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-11-08' and article_instime<'2015-11-15' union
select '2015-11-15','--','2015-11-22',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-11-15' and article_instime<'2015-11-22' union
select '2015-11-22','--','2015-11-29',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-11-22' and article_instime<'2015-11-29' union
select '2015-11-29','--','2015-12-06',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-11-29' and article_instime<'2015-12-06' union
select '2015-12-06','--','2015-12-13',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-12-06' and article_instime<'2015-12-13' union
select '2015-12-13','--','2015-12-20',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-12-13' and article_instime<'2015-12-20' union
select '2015-12-27','--','2016-01-03',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2015-12-27' and article_instime<'2016-01-03' union
select '2016-01-03','--','2015-01-10',sum(view_nums) [url=]as[/url] yuedu,sum(share_view_nums) [url=]as[/url] fenxiang [url=]from[/url] app_article [url=]where[/url] article_instime>='2016-01-03' and article_instime<'2016-01-10'
匠客 百度知道开放平台---------------------------------------------------------------------------------------------------------------------------------------------------
URL:
http://zhidao.baidu.com/opendev/
账号:datunrd
密码: Jiangke2015
aappkey:1383
securitykey54F3A148D50ACB31C153FD1A4A7A6A1
匠客问答小秘
账号:匠客问答小秘 | admin@admin.com
密码:jker123
内网地址:10.10.57.118
外网地址:120.132.50.141
URL:http://www.jker.cn
服务器账号 ubuntu ubuntucmtoday
web服务器路径:/home/y/etc/nginx/
MYSQL数据库账号密码
洛阳中收:
服务器地址同匠客
账号:phpcms
密码:qazmlp123
联系人QQ:30092124宋姐
打印数据库信息
var_dump(Yii::app()->db->connectionString);
var_dump(Yii::app()->db->username);
var_dump(Yii::app()->db->password);
strtolower($_SERVER['HTTP_OS'])
strip_tags(trim($_SERVER['HTTP_SID']))
strip_tags(trim($_SERVER['HTTP_DEVICEID']))
---------------------------------------------------------------------------------------------------------------------------
RSS源 接口服务器
http://api.daogou.bjzzcb.com/m/rss/rssdd
gii
http://api.daogou.bjzzcb.com/gii/ 用于自动生成model和action
配置文件在接口服务器的/home/y/share/pear/zhaoyang/config/daogou.php下面
'modules' => array(
// uncomment the following to enable the Gii tool
// 'gii' => array(
// 'class' => 'system.gii.GiiModule',
// 'password' => '1',
// // If removed, Gii defaults to localhost only. Edit carefully to taste.
// 'ipFilters' => array('127.0.0.1', '172.20.38.113'),
// ),
),
ip过滤需要加上121.69.27.14
---------------------------------------------------------------------------------------------------------------------------
秒针刷量监控页面
http://api.daogou.bjzzcb.com/m/Statistical/shualiang/?t=1
service php5-fpm start
service nginx start
service mysql start
/bin/bash /home/xingy/pm/jira/bin/startup.sh
/home/y/bin/searchd -c /home/y/etc/sphinx/wormhole_intl.conf
/usr/bin/svnserve -d -T -r /home/svn/resp/
rm -f /var/log/rsync/rsyncd.pid
/usr/bin/rsync --daemon
/usr/bin/python /home/y/bin/index_manage.py intl restart
/usr/bin/python /home/y/bin/index_manage.py inner restart
/usr/bin/python /home/y/bin/index_manage.py album restart
/usr/local/bin/supervisord -c /home/y/etc/supervisor/supervisord.conf
exit 0
---------------------------------------------------------------------------------------------------------------------------
自媒体项目:
测试环境:
http://chuanyue.zimeiti.iwomedia.cn 172.20.34.16
BETA环境:
http://zimeiti.beta.iwomedia.cn/ 180.150.179.141
线上环境:
http://v.carguide.com.cn
180.150.179.141
|