水晶其源 – 工作学习历程

nginx代理

nginx打开了auth_basic模式，让输入账号密码才能访问网站，以便保护隐私。

可是在微信里面，没有弹出验证的弹窗。

直接显示的没有输入账号密码的样子。

还根本就没法解决，至少眼前我不知道怎么解决。于是我用了代理的方式，判定一下，如果是微信打开就不验证，但是取消autoindex；其他页面还是需要验证，并且有autoindex

server {
listen	80;
charset utf-8;
server_name sample_normal;
root	/data/web/bpo_git/www/sample;
index	index.html index.htm  index.php;
location /{
autoindex on;
auth_basic  "passwd same to mail";
auth_basic_user_file /data/git/cert/passwd;
}
location ~ \.php$ {
include php/enable_php5.conf;
}
}
server {
listen	80;
charset utf-8;
server_name sample_wx;
root	/data/web/bpo_git/www/sample;
index	index.html index.htm  index.php;
location ~ \.php$ {
include php/enable_php5.conf;
}
}
server {
listen	80;
charset	utf-8;
server_name sample.vogso.com;
root	/data/web/bpo_git/www/sample;
index	index.html index.htm index.php;
location /{
if ( $http_user_agent ~* "MicroMessenger" ){
proxy_pass http://sample_wx;
}
if ( $http_user_agent !~* "MicroMessenger" ){
proxy_pass http://sample_normal;
}
}
location ~ \.php$ {
include php/enable_php5.conf;
}
access_log	/data/log/nginx/access/sample.log main;
}

server {

listen 80;

charset utf-8;

server_name sample_normal;

root /data/web/bpo_git/www/sample;

index index.html index.htm index.php;

location /{

autoindex on;

auth_basic "passwd same to mail";

auth_basic_user_file /data/git/cert/passwd;

}

location ~ \.php$ {

include php/enable_php5.conf;

}

server {

listen 80;

charset utf-8;

server_name sample_wx;

root /data/web/bpo_git/www/sample;

index index.html index.htm index.php;

location ~ \.php$ {

include php/enable_php5.conf;

}

server {

listen 80;

charset utf-8;

server_name sample.vogso.com;

root /data/web/bpo_git/www/sample;

index index.html index.htm index.php;

location /{

if ( $http_user_agent ~* "MicroMessenger" ){

proxy_pass http://sample_wx;

}

if ( $http_user_agent !~* "MicroMessenger" ){

proxy_pass http://sample_normal;

}

location ~ \.php$ {

include php/enable_php5.conf;

}

access_log /data/log/nginx/access/sample.log main;

}

因为不是每个属性都可以在if里面使用，我开始想在if里面使用auth，可是这个属性不让在location的if中使用。于是我只能又多写了两个server，然后建立了两个本地才能访问的host，一个是普通页面“sample_normal”，一个是微信的“sample_wx”。最后，再建立了一个正常域名的server，判断“http_user_agent”是否包含“MicroMessenger”，判断是否是微信（nginx中有if但是没有else），然后代理到相应的域名去。

git的自动部署

svn和git都可以修改hooks来做自动部署

打开文件 “yourrep.git/hooks/post-receive”
其实默认没有有个“post-receive.sample”

#!/bin/sh
unset $(git rev-parse --local-env-vars)
cd /data/www/bpo_git
git config http.sslVerify false
git pull origin master &>> git_update.log

#!/bin/sh

unset $(git rev-parse --local-env-vars)

cd /data/www/bpo_git

git config http.sslVerify false

git pull origin master &>> git_update.log

注意，要先去除环境，然后到需要更新的路径，最后再pull一下。中间因为我用的ssl的加密协议，我没有秘钥，所以加了一个忽略秘钥。
这块要注意，如果用户没有实体，就是nologin的用户，绝对不能用global。

ajax跨域

html5开始支持了ajax跨域，不用jsonp的方式了。

这个需要前后台配合。

后台，需要增加两个header

php写法为

header("Access-Control-Allow-Origin: http://api.shiroko.cn");
header("Access-Control-Allow-Credentials: true");

1 2	header("Access-Control-Allow-Origin: http://api.shiroko.cn"); header("Access-Control-Allow-Credentials: true");

如果只是跨域，不用cookie的话，可以

Access-Control-Allow-Origin: *

1	Access-Control-Allow-Origin: *

然后js里面的ajax不用任何修改。

但是如果要用cookie的话，必须设置完整的域名，并且后面的ajax要加两个参数

前台需要ajax增加两个参数

crossDomain : true,
xhrFields: {withCredentials: true},

1 2	crossDomain : true, xhrFields: {withCredentials: true},

具体在jquery的ajax写法为

$.ajax({
type: "POST",
dataType: "json",
url: "http://api.shiroko.cn/rent.php?ac=get_rents",
crossDomain : true,
xhrFields: {withCredentials: true},
success: function(obj){
console.log(obj);
}
});

$.ajax({

type: "POST",

dataType: "json",

url: "http://api.shiroko.cn/rent.php?ac=get_rents",

crossDomain : true,

xhrFields: {withCredentials: true},

success: function(obj){

console.log(obj);

}

});

记住，如果js的ajax加了这两个参数，那么header必须写完整的地址，不能写“*”

crypt在linux上的使用

使用mkpasswd将会生成一组随机的密码，9位。建立邮箱，以及在网站访问上用，还是很方便的。或者是给用户分配随机密码。

$mkpasswd
8Vvm$hU8v

$mkpasswd

8Vvm$hU8v

使用openssl生成crypt的密码，可以在crypt的加密格式上用

openssl passwd -crypt 5IusW4ls
Y3GIlN6gh3TWA

openssl passwd -crypt 5IusW4ls

Y3GIlN6gh3TWA

cocos下sqlite的封装

源文件请点击下载
以内之前做过php习惯用的一些db->getOne()之类的，所以在sqlite里也写了这样的封装，读取数据库会很方便，格式都用了value格式，
下面是demo，源文件太大，不在文章里贴了。

#include "core/db/DBConnector.h"
USING_NS_CC;
void main()
{
bool res = false;
_db = DBConnector::getInstance()->open();
//更新表--
std::string tableName = "user";
/**
*	更新表
*	第一个参数是表名
*	第二个为建表sql，如果表不存在就会创建table用于从sql/sql.xml里取出建表的sql
*	第三个为csv的数据，可以用xls打开修改，方便程序开发之外的人修改，会根据实际的数量来重制表里的数据，数据在sql/目录下有个跟表名一样的.csv文件，如果表没有初试数据可以不写这个参数
*/
_db->upgrade(tableName, Table::getInstance()->getTableByName(tableName), Table::getInstance()->getCSVByName(tableName));
std::stringstream sql;
std::string name = "minamoto";
char now[64];
time_t t = time(NULL);
struct tm* ttime;
ttime = localtime(&t);
strftime(now, 64, "%Y-%m-%d %H:%M:%S", ttime);
std::string date(now);
sql << "INSERT INTO `" << tableName << "` (`name`,`date`) VALUES ('" << name << "','" << date << "')";//添加
bool res = _db->query(sql.str());
sql.clear();
sql.str("");
sql << "REPLACE INTO `" << tableName << "` (`name`,`date`) VALUES ('" << name << "','" << date << "')";//替换
bool res = _db->query(sql.str());
sql.clear();
sql.str("");
name = "shiroko";
int uid = 100001;
sql << "UPDATE `" << tableName << "` SET `name` = '" << name << "' WHERE `uid` = '" << uid << "'";//修改
sql.clear();
sql.str("");
sql << "SELECT COUNT(*) AS `num` FROM `" << tableName << "` WHERE uid = '" << uid << "' LIMIT 1";//查询单个字段
int num = _db->getOne(sql.str()).asInt();
sql.clear();
sql.str("");
sql << "SELECT * FROM `" << tableName << "` WHERE uid = '" << uid << "' LIMIT 1";//查询一行
ValueMap row = _db->getRow(sql.str()).asValueMap();
sql.clear();
sql.str("");
sql << "SELECT * FROM `" << tableName << "` ORDER BY `iid` DESC";//查询多行
ValueVector all = _db->getAll(sql.str()).asValueVector();
}

#include "core/db/DBConnector.h"

USING_NS_CC;

void main()

{

bool res = false;

_db = DBConnector::getInstance()->open();

//更新表--

std::string tableName = "user";

/**

* 更新表

* 第一个参数是表名

* 第二个为建表sql，如果表不存在就会创建table用于从sql/sql.xml里取出建表的sql

* 第三个为csv的数据，可以用xls打开修改，方便程序开发之外的人修改，会根据实际的数量来重制表里的数据，数据在sql/目录下有个跟表名一样的.csv文件，如果表没有初试数据可以不写这个参数

_db->upgrade(tableName, Table::getInstance()->getTableByName(tableName), Table::getInstance()->getCSVByName(tableName));

std::stringstream sql;

std::string name = "minamoto";

char now[64];

time_t t = time(NULL);

struct tm* ttime;

ttime = localtime(&t);

strftime(now, 64, "%Y-%m-%d %H:%M:%S", ttime);

std::string date(now);

sql << "INSERT INTO `" << tableName << "` (`name`,`date`) VALUES ('" << name << "','" << date << "')";//添加

bool res = _db->query(sql.str());

sql.clear();

sql.str("");

sql << "REPLACE INTO `" << tableName << "` (`name`,`date`) VALUES ('" << name << "','" << date << "')";//替换

bool res = _db->query(sql.str());

sql.clear();

sql.str("");

name = "shiroko";

int uid = 100001;

sql << "UPDATE `" << tableName << "` SET `name` = '" << name << "' WHERE `uid` = '" << uid << "'";//修改

sql.clear();

sql.str("");

sql << "SELECT COUNT(*) AS `num` FROM `" << tableName << "` WHERE uid = '" << uid << "' LIMIT 1";//查询单个字段

int num = _db->getOne(sql.str()).asInt();

sql.clear();

sql.str("");

sql << "SELECT * FROM `" << tableName << "` WHERE uid = '" << uid << "' LIMIT 1";//查询一行

ValueMap row = _db->getRow(sql.str()).asValueMap();

sql.clear();

sql.str("");

sql << "SELECT * FROM `" << tableName << "` ORDER BY `iid` DESC";//查询多行

ValueVector all = _db->getAll(sql.str()).asValueVector();

}

cocos2dx webclient封装

源文件，点击下载

实例

 ValueMap param;
param["id"] = 123;
param["name"] = "minamoto";
web::Client::sendAndReceive("http://xxx.xxx.xxx/test.php", param, CC_CALLBACK_1(gainCallback, this));
void gainCallback(std::string str){
CCLOG("callback: %s", str.c_str());
rapidjson::Document d;
d.Parse<rapidjson::kNullType>(str.c_str());
if (d.HasParseError()){
CCLOG("GetParseError %s\n", d.GetParseError());
}
}

ValueMap param;

param["id"] = 123;

param["name"] = "minamoto";

web::Client::sendAndReceive("http://xxx.xxx.xxx/test.php", param, CC_CALLBACK_1(gainCallback, this));

void gainCallback(std::string str){

CCLOG("callback: %s", str.c_str());

rapidjson::Document d;

d.Parse<rapidjson::kNullType>(str.c_str());

if (d.HasParseError()){

CCLOG("GetParseError %s\n", d.GetParseError());

}

源码
client.h

#ifndef __WEB_CLIENT_H__
#define __WEB_CLIENT_H__
#include "cocos2d.h"
#include "network/HttpClient.h"
namespace web{
class Client
{
public:
Client();
virtual ~Client();
/**
*	 发送信息,，并且回调
*/
static void sendAndReceive(std::string address, std::string param, const std::function<void(std::string)>& callback);
static void sendAndReceive(std::string address, cocos2d::ValueMap param, const std::function<void(std::string)>& callback);
static void sendAndReceive(std::string address, std::string param);
static void sendAndReceive(std::string address, cocos2d::ValueMap param);
static void sendAndReceive(std::string address);
static void sendAndReceive(std::string address, const std::function<void(std::string)>& callback);
/**
*	打开
*	@param	address	地址
*/
void open(std::string address);
/**
*	关闭
*/
void close();
/**
*	发送
*	@param	param	参数
*/
void send(std::string param);
void send(cocos2d::ValueMap param);
/**
*	接收
*	@param	callback	回调
*/
void receive(const std::function<void(std::string)>& callback);
/**
*	侦听
*/
void addListener(const std::string &eventName, const std::function<void(cocos2d::EventCustom*)>& callback);
/**
*	连接状态
*	@data	int	code	连接状态代码
*/
static const std::string STATUS;
/**
*	完成
*	@data	std::string	str	服务器返回的字符串
*/
static const std::string COMPLETE;
/**
*	连接关闭
*/
static const std::string CLOSE;
/**
*	错误
*	@data	int code	错误代码
*/
static const std::string ERR;
private:
/*
*	请求
*/
cocos2d::network::HttpRequest* _req;
/**
*	事件
*/
cocos2d::EventDispatcher* _evt;
/**
*	回调
*/
std::function<void(std::string)> _callback;
/**
*	完成
*/
void onComplete(cocos2d::EventCustom* e);
};
}
#endif //__WEB_CLIENT_H__

#ifndef __WEB_CLIENT_H__

#define __WEB_CLIENT_H__

#include "cocos2d.h"

#include "network/HttpClient.h"

namespace web{

class Client

{

public:

Client();

virtual ~Client();

/**

* 发送信息,，并且回调

static void sendAndReceive(std::string address, std::string param, const std::function<void(std::string)>& callback);

static void sendAndReceive(std::string address, cocos2d::ValueMap param, const std::function<void(std::string)>& callback);

static void sendAndReceive(std::string address, std::string param);

static void sendAndReceive(std::string address, cocos2d::ValueMap param);

static void sendAndReceive(std::string address);

static void sendAndReceive(std::string address, const std::function<void(std::string)>& callback);

/**

* 打开

* @param address 地址

void open(std::string address);

/**

* 关闭

void close();

/**

* 发送

* @param param 参数

void send(std::string param);

void send(cocos2d::ValueMap param);

/**

* 接收

* @param callback 回调

void receive(const std::function<void(std::string)>& callback);

/**

* 侦听

void addListener(const std::string &eventName, const std::function<void(cocos2d::EventCustom*)>& callback);

/**

* 连接状态

* @data int code 连接状态代码

static const std::string STATUS;

/**

* 完成

* @data std::string str 服务器返回的字符串

static const std::string COMPLETE;

/**

* 连接关闭

static const std::string CLOSE;

/**

* 错误

* @data int code 错误代码

static const std::string ERR;

private:

* 请求

cocos2d::network::HttpRequest* _req;

/**

* 事件

cocos2d::EventDispatcher* _evt;

/**

* 回调

std::function<void(std::string)> _callback;

/**

* 完成

void onComplete(cocos2d::EventCustom* e);

};

}

#endif //__WEB_CLIENT_H__

clinet.cpp

#include "Client.h"
USING_NS_CC;
using namespace network;
namespace web{
const std::string Client::STATUS = "webClientStatus";
const std::string Client::COMPLETE = "webClientComplete";
const std::string Client::CLOSE = "nodejsClientClose";
const std::string Client::ERR = "webClientError";
Client::Client(){
network::HttpClient::getInstance()->enableCookies(NULL);
_req = new HttpRequest();
_evt = new EventDispatcher();
_evt->setEnabled(true);
}
Client::~Client(){
if (_req) _req->release();
}
void Client::sendAndReceive(std::string address, std::string param, const std::function<void(std::string)>& callback){
Client* client = new Client();
client->open(address);
client->send(param);
client->receive(callback);
}
void Client::sendAndReceive(std::string address, ValueMap param, const std::function<void(std::string)>& callback){
Client* client = new Client();
client->open(address);
client->send(param);
client->receive(callback);
}
void Client::sendAndReceive(std::string address, ValueMap param){
Client* client = new Client();
client->open(address);
client->send(param);
client->close();
}
void Client::sendAndReceive(std::string address){
Client* client = new Client();
client->open(address);
client->close();
}
void Client::sendAndReceive(std::string address, const std::function<void(std::string)>& callback){
Client* client = new Client();
client->open(address);
client->receive(callback);
}
void Client::open(std::string address){
_req->setUrl(address.c_str());
}
void Client::close(){
_req->release();
}
void Client::send(std::string param){
_req->setRequestType(HttpRequest::Type::POST);
const char* postData = param.c_str();
_req->setRequestData(postData, strlen(postData));
}
void Client::send(ValueMap param){
std::stringstream str;
for (std::pair<std::string, Value> v : param){
str << v.first.c_str() << "=" << v.second.asString() << "&";
}
send(str.str());
}
void Client::receive(const std::function<void(std::string)>& callback){
_callback = callback;
addListener(Client::COMPLETE, CC_CALLBACK_1(Client::onComplete, this));
/**/
_req->setResponseCallback(
[=](HttpClient *sender, HttpResponse *response){
if (!response)return;
int statusCode = response->getResponseCode();
_evt->dispatchCustomEvent(Client::STATUS, &statusCode);
if (!response->isSucceed()){
std::string err(response->getErrorBuffer());
CCLOG("err: %s", err.c_str());
_evt->dispatchCustomEvent(Client::ERR, &err);
return;
}
std::vector<char> *buffer = response->getResponseData();
std::string str;
for (char s : *buffer){
str += s;
}
CCLOG("receive: %s", str.c_str());
_evt->dispatchCustomEvent(Client::COMPLETE, &str);
close();
}
);
network::HttpClient::getInstance()->send(_req);
}
void Client::addListener(const std::string &eventName, const std::function<void(EventCustom*)>& callback){
_evt->addCustomEventListener(eventName, callback);
}
void Client::onComplete(EventCustom* e){
std::string str = *(std::string*)e->getUserData();
_callback(str);
}
}

100

101

102

#include "Client.h"

USING_NS_CC;

using namespace network;

namespace web{

const std::string Client::STATUS = "webClientStatus";

const std::string Client::COMPLETE = "webClientComplete";

const std::string Client::CLOSE = "nodejsClientClose";

const std::string Client::ERR = "webClientError";

Client::Client(){

network::HttpClient::getInstance()->enableCookies(NULL);

_req = new HttpRequest();

_evt = new EventDispatcher();

_evt->setEnabled(true);

}

Client::~Client(){

if (_req) _req->release();

}

void Client::sendAndReceive(std::string address, std::string param, const std::function<void(std::string)>& callback){