int _tmain(int argc, _TCHAR* argv[])
{
_tsetlocale(LC_ALL, _T("")); // fixes VS11DP quirk
// open csv file
RCSVFileRO file;
if (argc == 2)
{
if (!file.Open(CorrectPath(argv[1])))
{_putts(_T("Unable to open file: ") + CorrectPath(argv[1])); PAUSERETURN(-1);}
}
else if (argc == 1)
{
if (!file.Open(CorrectPath(_T("strings.csv"))))
{_putts(_T("Please supply the name of CSV-file.")); PAUSERETURN(-2);}
}
else
{_putts(_T("Invalid argument count.")); PAUSERETURN(-3);}
if (file.GetLineCount() == 0)
{_putts(_T("Empty file.")); PAUSERETURN(1);}
if (file.GetLineCount() < 2)
{_putts(_T("File must contain at least two lines.")); PAUSERETURN(-4);}
if (file.GetFieldCount() < 2)
{_putts(_T("File must contain at least two columns.")); PAUSERETURN(-5);}
// generate header file contents
RString str;
str += _T("// strings.h : Defines the strings to be used throughout the application.\r\n");
str += _T("//\r\n");
str += _T("\r\n");
int n = 1000;
int i, j;
for (i = 1; i < file.GetLineCount(); i++)
if (_tcscmp(file.GetField(i, 0), _T("")) != 0)
str += RString(_T("#define ")) + file.GetField(i, 0) + _T(" ") + NumberToString(n++) + _T("\r\n");
str += _T("\r\n");
str += _T("inline void LoadStrings()\r\n");
str += _T("{\r\n");
str += _T("\tINT_PTR nLanguage;\r\n");
for (i = 1; i < file.GetFieldCount(); i++)
{
str += _T("\r\n");
str += (RString)_T("\tnLanguage = GetLangMgr()->GetLanguage(_T(\"") + file.GetField(0, i) + _T("\"));\r\n");
str += (RString)_T("\tif (nLanguage == -1)\r\n");
str += (RString)_T("\t\tnLanguage = GetLangMgr()->AddLanguage(_T(\"") + file.GetField(0, i) + _T("\"), _T(\"") + file.GetField(1, i)
+ _T("\"), _T(\"\"));\r\n\r\n");
for (j = 1; j < file.GetLineCount(); j++)
{
if (_tcscmp(file.GetField(j, 0), _T("")) == 0)
continue; // skip empty ids
str += (RString)_T("\tGetLangMgr()->SetString(nLanguage, ") + NumberToString(j-1) + _T(", _T(\"") +
file.GetField(j, i) + _T("\"), false);\r\n");
}
}
str += _T("}\r\n");
// write to file
RString strFilePath = CorrectPath(argc == 2 ? argv[1] : _T("strings.csv"));
strFilePath = strFilePath.Left(strFilePath.ReverseFind(_T('\\'))+1) + _T("strings.h");
RArray<BYTE> data = StringToData(str, CHARSET_ANSI);
if (!DataToFile(data, strFilePath))
{_tprintf(_T("Failed to open %s for writing.\n"), (LPCTSTR)strFilePath); PAUSERETURN(-6);}
_tprintf(_T("Created %s succesfully.\n"), (LPCTSTR)strFilePath);
PAUSERETURN(0);
}
void ParseFileName(RString_ strFileName, RString &strTitle, RString &strYear)
{
INT_PTR m, n;
RString strTemp;
strTitle = strFileName;
strYear.Empty();
// only keep file name
n = strTitle.ReverseFind(_T('\\'));
if (n != -1)
strTitle = strTitle.Mid(n + 1);
//strTitle.MakeLower();
// strip file extension (max 4 chars)
n = strTitle.ReverseFind(_T('.'));
if (n != -1 && strTitle.GetLength() - n < 6)
strTitle = strTitle.Left(n);
// replace []{} by ()
strTitle.Replace(_T('['), _T('('));
strTitle.Replace(_T(']'), _T(')'));
strTitle.Replace(_T('{'), _T('('));
strTitle.Replace(_T('}'), _T(')'));
/*
// replace anything not ,()0-9a-zA-Z by a space
for (int i = 0; i < strTitle.GetLength(); i++)
if (!(strTitle[i] == _T(',')) &&
!(strTitle[i] == _T('\'')) &&
!(strTitle[i] == _T('(')) &&
!(strTitle[i] == _T(')')) &&
!(strTitle[i] >= _T('0') && strTitle[i] <= _T('9')) &&
!(strTitle[i] >= _T('A') && strTitle[i] <= _T('Z')) &&
!(strTitle[i] >= _T('a') && strTitle[i] <= _T('z')))
*((LPTSTR)(LPCTSTR)strTitle + i) = _T(' ');
*/
// replace ._ by a space
strTitle.Replace(_T('.'), _T(' '));
strTitle.Replace(_T('_'), _T(' '));
// remove redundant space
while (strTitle.Replace(_T(" "), _T(" ")));
strTitle.Trim();
// find year between (), strip anything following it
for (n = 0; (n = strTitle.Find(_T('('), n)) != -1; n++)
{
if (n+5 < strTitle.GetLength() && strTitle[n+5] == _T(')'))
{
strTemp = strTitle.Mid(n+1, 4);
if (StringToNumber(strTemp) > 1900)
{
strYear = strTemp;
strTitle = strTitle.Left(n);
break;
}
}
}
// remove anything between ()
for (m = 0, n = 0; (m = strTitle.Find(_T('('), n)) != -1 &&
(n = strTitle.Find(_T(')'), m)) != -1; m = 0, n = 0)
strTitle = strTitle.Left(m) + strTitle.Mid(n+1);
// find year not in (), but not as first word, strip anything following it
strTitle.Replace(_T('('), _T(' '));
strTitle.Replace(_T(')'), _T(' '));
while (strTitle.Replace(_T(" "), _T(" ")));
strTitle.Trim();
if (strYear.IsEmpty())
{
m = 0;
while (true)
{
if (m >= strTitle.GetLength())
break;
n = strTitle.Find(_T(' '), m);
if (n == -1)
n = strTitle.GetLength();
if (m == n)
{m = n + 1; continue;}
if (n - m == 4)
{
strTemp = strTitle.Mid(m, n - m);
if (StringToNumber(strTemp) > 1900 && m > 0)
{
strYear = strTemp;
strTitle = strTitle.Left(m);
break;
}
}
m = n + 1;
}
}
while (strTitle.Replace(_T(" "), _T(" ")));
strTitle.Trim();
// place some literals in front
if (strTitle.GetLength() > 5 && strTitle.Right(5) == _T(", the"))
strTitle = _T("the ") + strTitle.Left(strTitle.GetLength() - 5);
if (strTitle.GetLength() > 5 && strTitle.Right(5) == _T(", The"))
strTitle = _T("The ") + strTitle.Left(strTitle.GetLength() - 5);
if (strTitle.GetLength() > 3 && strTitle.Right(3) == _T(", a"))
strTitle = _T("a ") + strTitle.Left(strTitle.GetLength() - 3);
if (strTitle.GetLength() > 3 && strTitle.Right(3) == _T(", A"))
strTitle = _T("A ") + strTitle.Left(strTitle.GetLength() - 3);
strTitle.Replace(_T(','), _T(' '));
while (strTitle.Replace(_T(" "), _T(" ")));
strTitle.Trim();
//TRACE0(_T("ParseFileName\n strFileName = ") + strFileName + _T("\n strTitle = ") +
// strTitle + _T("\n strYear = ") + strYear + _T("\n"));
}
void ParseFileName(RString_ strFileName, RString &strTitle, RString &strYear, INT_PTR &nSeason, INT_PTR &nEpisode, RString &strAirDate, BYTE &bType)
{
INT_PTR m, n;
RString strTemp, strSeason, strEpisode;
RString strYearTmp, strMonthTmp, strDayTmp;
strTitle = strFileName;
strYear.Empty();
// only keep file name
n = strTitle.ReverseFind(_T('\\'));
if (n != -1)
strTitle = strTitle.Mid(n + 1);
//strTitle.MakeLower();
// strip file extension (max 4 chars)
n = strTitle.ReverseFind(_T('.'));
if (n != -1 && strTitle.GetLength() - n < 6)
strTitle = strTitle.Left(n);
// replace []{} by ()
strTitle.Replace(_T('['), _T('('));
strTitle.Replace(_T(']'), _T(')'));
strTitle.Replace(_T('{'), _T('('));
strTitle.Replace(_T('}'), _T(')'));
/*
// replace anything not ,()0-9a-zA-Z by a space
for (int i = 0; i < strTitle.GetLength(); i++)
if (!(strTitle[i] == _T(',')) &&
!(strTitle[i] == _T('\'')) &&
!(strTitle[i] == _T('(')) &&
!(strTitle[i] == _T(')')) &&
!(strTitle[i] >= _T('0') && strTitle[i] <= _T('9')) &&
!(strTitle[i] >= _T('A') && strTitle[i] <= _T('Z')) &&
!(strTitle[i] >= _T('a') && strTitle[i] <= _T('z')))
*((LPTSTR)(LPCTSTR)strTitle + i) = _T(' ');
*/
// remove urls
RString strUrl;
if (GetFirstMatch(strTitle, _T("([wW][wW][wW]\\.[^\\.]*?\\.[cC][oO][mM])"), &strUrl, NULL))
{
m = strTitle.Find(strUrl, 0);
if (m >= 0)
strTitle = strTitle.Left(m) + strTitle.Right(strTitle.GetLength() - (m + strUrl.GetLength()));
}
// replace ._ -by a space
strTitle.Replace(_T('.'), _T(' '));
strTitle.Replace(_T('_'), _T(' '));
strTitle.Replace(_T('-'), _T(' '));
// remove redundant space
while (strTitle.Replace(_T(" "), _T(" ")));
strTitle.Trim();
// find year between (), strip anything following it
for (n = 0; (n = strTitle.Find(_T('('), n)) != -1; n++)
{
if (n + 5 < strTitle.GetLength() && strTitle[n + 5] == _T(')'))
{
strTemp = strTitle.Mid(n + 1, 4);
if (StringToNumber(strTemp) > 1900)
{
strYear = strTemp;
strTitle = strTitle.Left(n);
break;
}
}
}
// remove anything between ()
for (m = 0, n = 0; (m = strTitle.Find(_T('('), n)) != -1 &&
(n = strTitle.Find(_T(')'), m)) != -1; m = 0, n = 0)
strTitle = strTitle.Left(m) + strTitle.Mid(n + 1);
// for TV shows. Find the season and episode and remove everything following it
if (GetFirstMatch(strTitle, _T("([Ss]\\d?\\d[Ee]\\d?\\d)"), &strTemp, NULL))
{
m = strTitle.Find(strTemp, 0);
if (GetFirstMatch(strTemp, _T("[Ss](\\d?\\d)[Ee](\\d?\\d)"), &strSeason, &strEpisode, NULL))
{
nSeason = StringToNumber(strSeason);
nEpisode = StringToNumber(strEpisode);
bType = DB_TYPE_TV;
}
if (m >= 0)
strTitle = strTitle.Left(m);
}
// for TV shows by date and parse date aired
if (GetFirstMatch(strTitle, _T("(\\d\\d\\d\\d) (\\d?\\d) (\\d?\\d)"), &strYearTmp, &strMonthTmp, &strDayTmp, NULL))
{
const RString Month[12] = { _T("Jan"), _T("Feb"), _T("Mar"), _T("Apr"),
_T("May"), _T("Jun"), _T("Jul"), _T("Aug"), _T("Sep"), _T("Oct"), _T("Nov"), _T("Dec") };
strAirDate = strDayTmp + _T(" ") + Month[StringToNumber(strMonthTmp) - 1] + _T(". ") + strYearTmp;
bType = DB_TYPE_TV;
}
// find year not in (), but not as first word, strip anything following it
strTitle.Replace(_T('('), _T(' '));
strTitle.Replace(_T(')'), _T(' '));
while (strTitle.Replace(_T(" "), _T(" ")));
strTitle.Trim();
if (strYear.IsEmpty())
{
m = 0;
while (m < strTitle.GetLength())
{
n = strTitle.Find(_T(' '), m);
if (n == -1)
n = strTitle.GetLength();
if (m == n)
{
m = n + 1; continue;
}
if (n - m == 4)
{
strTemp = strTitle.Mid(m, n - m);
if (StringToNumber(strTemp) > 1900 && m > 0)
{
strYear = strTemp;
strTitle = strTitle.Left(m);
break;
}
}
m = n + 1;
}
}
// strip 'season[s] \\d' and anything following it
RString strSeasons;
if (GetFirstMatch(strTitle, _T("([Ss]eason[s]? ?\\d?\\d(?: ?- ?\\d?\\d)?)"), &strSeasons, NULL))
{
m = strTitle.Find(strSeasons, 0);
if (m >= 0)
strTitle = strTitle.Left(m);
bType = DB_TYPE_TV;
}
//Remove episode numbers of the form XXofYY - TODO: process to return episode number
RString strOf;
if (GetFirstMatch(strTitle, _T("(\\d?\\d[oO][fF]\\d?\\d)"), &strOf, NULL))
{
m = strTitle.Find(strOf, 0);
if (m > 0)
strTitle = strTitle.Left(m);
bType = DB_TYPE_TV;
}
// strip common movie descriptors and everything after
static const RString strDescriptors[] = { _T("webrip"), _T("dvdrip"), _T("dvdscr"), _T("xvid"), _T("bdrip"),
_T("brrip"), _T("hdtv"), _T("pdtv"), _T("box set"), _T("box-set"), _T("x264") };
foreach(strDescriptors, strD)
{
m = strTitle.FindNoCase(strD, 0);
if (m > 0)
strTitle = strTitle.Left(m);
}
