<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[rightorwrong的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/rightorwrong</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; rightorwrong]]></copyright><item><title><![CDATA[mysql复杂统计sql语句]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/130420027</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/130420027</guid><author>rightorwrong</author><pubDate>Fri, 28 Apr 2023 09:45:23 +0800</pubDate><description><![CDATA[计数时COUNT(IF(expr,1,NULL))，SUM(IF(expr,1,0))，注意COUNT使用。一张表的多条件分类统计，使用COUNT(DISTINCT CASE WHEN)语句。多张表进行多条件分类汇总统计，使用UNION ALL语句。]]></description><category></category></item><item><title><![CDATA[SQL语句注意的几点]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/126418007</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/126418007</guid><author>rightorwrong</author><pubDate>Fri, 19 Aug 2022 09:39:52 +0800</pubDate><description><![CDATA[SQL性能优化]]></description><category></category></item><item><title><![CDATA[GeoServer 2.20.x切片路径]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/125896372</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/125896372</guid><author>rightorwrong</author><pubDate>Wed, 20 Jul 2022 17:13:39 +0800</pubDate><description><![CDATA[GeoServer切片保存目录]]></description><category></category></item><item><title><![CDATA[android使用web3j调用fisco bcos区块链接口]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/120416778</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/120416778</guid><author>rightorwrong</author><pubDate>Wed, 22 Sep 2021 16:07:48 +0800</pubDate><description><![CDATA[fisco bcos平台的http接口在接口名和输入参数上与web3j平台略有不同。sendRawTransaction提供上链操作，开发中使用web3j创建RawTransaction时，少了一个blockLimit字段不能调用成功。

    使用web3j需要自己实现交易字段的签名操作。调用sendRawTransaction接口后，还需调用getTransactionReceipt获取合约接口的返回值，此接口调用需要处理延时。


...]]></description><category></category></item><item><title><![CDATA[用chrome 播放GB28181中的视频]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/103109904</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/103109904</guid><author>rightorwrong</author><pubDate>Sun, 17 Nov 2019 16:45:02 +0800</pubDate><description><![CDATA[1、海康做为下级平台，提供设备清单及视频点播请求

下级平台注册后，Catalog命令就可以取到点位信息，注意GB28181的请求响应方式，注意请求中字段的准确

发送INVITE请求就能取到PS视频流，PS流比较好解析

注意I帧、P帧PS流的封装。每帧的第一个分片有PS头信息，后面的分片就是RTP头加上视频数据。

PS流组成帧数据根据RTP的mark值组成一帧

PS流组帧后使用ffmpeg...]]></description><category></category></item><item><title><![CDATA[PushMeBaby测试发布版推送功能]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/48180887</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/48180887</guid><author>rightorwrong</author><pubDate>Wed, 02 Sep 2015 17:17:33 +0800</pubDate><description><![CDATA[注意几个问题
1.调试版本与发布版本token不一样，token串的空格保留
2.发布版本修改2个地方

    result =
MakeServerConnection("gateway.push.apple.com",
2195, &socket, &peer);


    result = SSLSetPeerDomainName(context,
"gateway.]]></description><category></category></item><item><title><![CDATA[iterator与reverse_iterator]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/17558563</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/17558563</guid><author>rightorwrong</author><pubDate>Wed, 25 Dec 2013 16:56:04 +0800</pubDate><description><![CDATA[std::list::iterator intIter = --intRIter.base(); //用(++intRIter).base()也可
intIter = intList.erase(intIter);
intRIter = intList::reverse_iterator(intIter);


intRIter = intList::reverse_iterator(i]]></description><category></category></item><item><title><![CDATA[bmp文件转jpg文件---获取bmp数据]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/12151279</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/12151279</guid><author>rightorwrong</author><pubDate>Sun, 29 Sep 2013 08:45:01 +0800</pubDate><description><![CDATA[FILE* pFile = fopen(szFilePath, "rb");if(pFile != NULL)
{	
	int nClose = 1;												BITMAPFILEHEADER bmpFileHeader = {0};
	if(fread(&bmpFileHeader, sizeof(bmpFileHeader), 1, pFile) == 1)
	{]]></description><category></category></item><item><title><![CDATA[ocx控件获取使用App的窗口句柄]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/10514331</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/10514331</guid><author>rightorwrong</author><pubDate>Thu, 29 Aug 2013 14:25:53 +0800</pubDate><description><![CDATA[在CXxxCtrl文件中HWND hAppWnd = NULL;
if (m_pInPlaceSite != NULL)
  m_pInPlaceSite->GetWindow(&hAppWnd);]]></description><category></category></item><item><title><![CDATA[CMarkUp创建有子属性xml使用]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/9662951</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/9662951</guid><author>rightorwrong</author><pubDate>Wed, 31 Jul 2013 08:29:20 +0800</pubDate><description><![CDATA[const char* const XmlTag = "\r\n";
 CMarkup tempXml;
 tempXml.AddElem("Item");
 tempXml.AddChildElem("ItemId", 111);
 tempXml.AddChildElem("ItemName", "My111");

 CMarkup xmlDoc(XmlTag);
 xmlDo]]></description><category></category></item><item><title><![CDATA[tcp接收xml数据解析]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/9137687</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/9137687</guid><author>rightorwrong</author><pubDate>Thu, 20 Jun 2013 15:41:39 +0800</pubDate><description><![CDATA[避免tcp接收xml数据时加上xml数据长度，根据xml数据特点来解析recv到的xml数据
 int nPos1 = 0;
 int nPos2 = 0;
 int nTempPos = 0;
 int nXmlParseStep = 0;
 std::string strRequest;
 std::string strXmlNode;
 char szXmlData[1024]]]></description><category></category></item><item><title><![CDATA[文件格式对应http的Content-Type字段]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/8998087</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/8998087</guid><author>rightorwrong</author><pubDate>Fri, 31 May 2013 10:16:02 +0800</pubDate><description><![CDATA["doc" = "application/msword"
"bin" = "application/octet-stream"
"dll" = "application/octet-stream"
"exe" = "application/octet-stream"
"pdf" = "application/pdf"
"p7c" = "application/pkcs7-mime"
"]]></description><category></category></item><item><title><![CDATA[openssl asn.1使用]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/8687629</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/8687629</guid><author>rightorwrong</author><pubDate>Mon, 18 Mar 2013 16:04:40 +0800</pubDate><description><![CDATA[unsigned int unTempLen = 0;
 unsigned char szBuffer[8] = {0};
 unsigned char szOut[1024] = {0};
 ASN1_INTEGER asn1Int;
 asn1Int.length = 8;
 asn1Int.type = V_ASN1_INTEGER;
 asn1Int.data = szBuff]]></description><category></category></item><item><title><![CDATA[简单方法创建透明区域]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/8666629</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/8666629</guid><author>rightorwrong</author><pubDate>Wed, 13 Mar 2013 09:24:29 +0800</pubDate><description><![CDATA[CRect areaRect(0, 0, 0, 0);
 CRect clientRect(0, 0, 0, 0);
 GetClientRect(&clientRect);
 CWnd* pWnd = GetDlgItem(IDC_STATIC_TRANS);
 if(pWnd && IsWindow(pWnd->m_hWnd))
 {
  pWnd->GetWindowRect(&]]></description><category></category></item><item><title><![CDATA[记录一个函数,五个字节产生一个0x10的数据]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/8178886</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/8178886</guid><author>rightorwrong</author><pubDate>Tue, 13 Nov 2012 15:41:03 +0800</pubDate><description><![CDATA[void __cdecl sub_ida_func(int nInLen, char* pInputData, int nSize, char *pDestData)
 {
__asm
{

PUSHAD
sub     esp, 18h
mov     esi, [ebp+10h]
mov     edi, [ebp+8h]
mov     ecx, edi
test]]></description><category></category></item><item><title><![CDATA[MDI程序单文档多视图同时显示]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/7318336</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/7318336</guid><author>rightorwrong</author><pubDate>Sun, 04 Mar 2012 17:39:06 +0800</pubDate><description><![CDATA[程序需要一个view一直显示,其它view可以使用同一个doc.一直显示的view可以是是新建MFC工程时CVideoClientApp::InitInstance中的文档默认的view
再新建view时可以通过如下的方法来创建view就能实现一个doc多个view的功能
CView* CMDITestApp::IfViewOpen(CRuntimeClass* pNewViewClass)]]></description><category></category></item><item><title><![CDATA[directshow播放,界面无响应问题的查找]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/7318324</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/7318324</guid><author>rightorwrong</author><pubDate>Sun, 04 Mar 2012 17:33:04 +0800</pubDate><description><![CDATA[1.一般没有调用m_pVWindow->put_MessageDrain((OAHWND)hMsgDrainWnd);
2.放在主线程中调用
3.有时播放窗口为对话框子窗口
    调用m_pVWindow->put_MessageDrain()时要设置为其父窗口]]></description><category></category></item><item><title><![CDATA[SourceFilter 时间戳问题]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/6625097</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/6625097</guid><author>rightorwrong</author><pubDate>Fri, 22 Jul 2011 10:43:48 +0800</pubDate><description><![CDATA[对于SourceFilter编写，在FillBuffer中打错时间戳会使cpu占用100%]]></description><category></category></item><item><title><![CDATA[再写DirectShow TransformFilter]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/6445636</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/6445636</guid><author>rightorwrong</author><pubDate>Wed, 25 May 2011 18:04:00 +0800</pubDate><description><![CDATA[G729的音频解码filter。音频的filter，在Transform函数中不用打时间戳。G729使用的是网上的lib库，va_g729a_使用filter播放时，视频播放的很慢，这个问题要查一查]]></description><category></category></item><item><title><![CDATA[Android视频监控方案]]></title><link>https://blog.youkuaiyun.com/rightorwrong/article/details/6441401</link><guid>https://blog.youkuaiyun.com/rightorwrong/article/details/6441401</guid><author>rightorwrong</author><pubDate>Tue, 24 May 2011 09:14:00 +0800</pubDate><description><![CDATA[<br />JNI.<br />网络通讯功能及解码功能由C++完成，提供JNI接口。在linux下编译通过<br />android调用jni接口获取帧数据解析成RGB数据后使用surface方法进行播放]]></description><category></category></item></channel></rss>