So, few days after migration from Ikonboard CGI Forum v2 to Vanilla Forum I’ve noticed, that some posts has wrong date. Database was copied into local copy for local r/w access.
Download and install mysql CPP connector
Do not forget to add mysqlcppconn.lib to additional linker input dependencies in project settings // or add #pragma comment( lib, “mysqlcppconn.lib” ) to vanied.cpp
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
#include "mysqlx\xdevapi.h" using namespace ::mysqlx; ... sql::mysql::MySQL_Driver* driver; sql::Connection* con; string ID = ""; string dt = ""; driver = sql::mysql::get_mysql_driver_instance(); con = driver->connect("tcp://10.10.250.11:3306", "solan_tv", ""); con->setSchema("test"); sql::Statement* stmt; stmt = con->createStatement(); ... string updDataSQL = "UPDATE GDN_Discussion set DateInserted=" + dt + " where DiscussionID=" + ID + ";"; stmt->execute(updDataSQL); ... |
To launch files from Chrome’s context menu, I’ve registered a simple new URI handler: https://docs.microsoft.com/en-us/previous-versions/windows/internet-explorer/ie-developer/platform-apis/aa767914(v=vs.85) i.e. vanied:
Now, add it into Chrome (or Edge) context menu through Windows Registry:
|
1 2 3 4 5 6 7 8 9 10 |
HKEY_CLASSES_ROOT vanied (Default) = "URL:Vanied Protocol" URL Protocol = "" DefaultIcon (Default) = "devenv.exe,1" shell open command (Default) = "D:\projects\vanied\Release\vanied.exe" "%1" |
Context Menu Editor plugin for Chrome: cme3.4.0.cab
After installing right click on Options:
Add new item
Edit and apply. Except info.linkUrl there are number of different data. More – https://developer.chrome.com/extensions/contextMenus#property-onclick-info
