Вверх ↑
Ответов: 701
Рейтинг: 146
#1: 2021-12-31 16:17:16 ЛС | профиль | цитата
Для пользователей браузера Google Chrome. Небольшая статистика посещения сайтов.
Интересно, на каком месте у вас сайт - forum.hiasm.com?

Add(MainForm,2953706,147,147)
{
Width=939
Height=399
Caption="Chrome history"
Point(onClose)
link(onCreate,6711967:doEvent1,[])
link(onClose,6598663:doEvent1,[(193,174)(193,272)])
}
Add(EnvVars,7002440,245,161)
{
Name="LOCALAPPDATA"
Point(doGet)
Point(onGet)
link(onGet,13065512:doStrCatDlm,[])
}
Add(StrCatDelim,11951715,616,315)
{
@Hint=#34:Расположение файла History у меня.|
Str2="\Google\Chrome\User Data\Profile 1\History"
AddHint(75,6,200,13,@Hint)
}
Add(FileTools,16151939,343,161)
{
link(onEnd,9907050:doOpen,[])
link(NewFileName,4874792:Var2,[])
}
Add(Dir,990626,350,49)
{
}
Add(StrCatDelim,5150297,350,98)
{
Str2="\\test.db"
link(Str1,990626:CurrentDir,[])
}
Add(FileTools,6046132,448,259)
{
link(FileName,7508651:Var3,[(454,145)])
}
Add(DS_SQLite,9907050,406,161)
{
Name="History"
Charset=1
link(onOpen,4186973:doEvent1,[])
link(FileName,7508651:Var2,[])
}
Add(DSC_Query,16391078,518,203)
{
SQL="SELECT urls.url,\r\n count (visit_Time) as visits \r\nFROM visits JOIN urls\r\n ON visits.url = urls.id\r\nWHERE (visits.visit_time < 100000000000000000) \r\nGroup BY urls.url\r\nOrder by visits desc;"
DSManager="History"
link(onQuery,22766:doAddRow,[])
link(onColumns,22766:doAddCols,[])
}
Add(MTStrTbl,7809938,777,161)
{
Width=923
Height=330
Align=5
Name="asd"
Point(doVisible)
}
Add(MST_DB,22766,567,203)
{
MSTControl="asdf"
}
Add(Hub,6598663,371,266)
{
link(onEvent1,9907050:doClose,[(396,272)(396,174)])
link(onEvent2,6046132:doDelete,[])
}
Add(Hub,6711967,203,161)
{
OutCount=4
link(onEvent1,5150297:doStrCatDlm,[(235,167)(235,104)])
link(onEvent2,7002440:doGet,[])
link(onEvent3,13273356:doColAction,[(235,181)(235,202)])
link(onEvent4,8927836:doColAction,[(228,188)(228,237)])
}
Add(GetDataEx,7508651,406,140)
{
Angle=3
link(Data,4874792:Var3,[])
}
Add(MST_ColAction,13273356,245,196)
{
Action=9
MaxColWidth=500
Index=-2
MSTControl="asd"
}
Add(GetDataEx,4874792,350,140)
{
link(Data,5150297:Result,[])
}
Add(InfoTip,7313851,91,392)
{
Info=#33:Location of Google Chrome history|10:Windows XP|100:C:\Documents and Settings\<username>\Local Settings\Application Data\Google\Chrome\User Data\Default|106:C:\Documents and Settings\<username>\Local Settings\Application Data\Google\Chrome\User Data\Default\Cache|23:Windows Vista, 7, 8, 10|65:C:\Users\<username>\AppData\Local\Google\Chrome\User Data\Default|71:C:\Users\<username>\AppData\Local\Google\Chrome\User Data\Default\Cache|8:Mac OS X|67:/Users/<username>/Library/Application Support/Google/Chrome/Default|60:/Users/<username>/Library/Caches/Google/Chrome/Default/Cache|10:Linux/Unix|46:/home/<username>/.config/google-chrome/Default|51:/home/<username>/.cache/google-chrome/Default/Cache|31:Format of Google Chrome history|9:Bookmarks|57:Chrome Bookmarks are stored in the 'Bookmarks' JSON file.|5:Cache|144:Chrome Cache is stored using an Index file ('index'), a number of Data Block files ('data_#'), and a number of separate data files ('f_######').|7:Cookies|87:Chrome Cookies are stored in the 'Cookies' SQLite database, within the 'cookies' table.|9:Downloads|119:Chrome Downloads are stored in the 'History' SQLite database, within the 'downloads' and 'downloads_url_chains' tables.|8:Favicons|234:Chrome Favicons are stored in the 'Favicons' SQLite database, within the 'favicons', 'favicon_bitmaps' and 'icon_mapping' tables. Older versions of Chrome stored Favicons in a 'Thumbnails' SQLite database, within the 'favicons' table.|12:Form History|176:Chrome Form History is stored in the 'Web Data' SQLite database, within the 'autofill' table. Older versions of Chrome stored associated dates within an 'autofill_dates' table.|6:Logins|162:Chrome Logins are stored in the 'Login Data' SQLite database, within the 'logins' table. Older versions of Chrome stored Logins in the 'Web Data' SQLite database.|8:Searches|163:Chrome Searches are stored in the 'History' SQLite database, within the 'keyword_search_terms' table. Associated URL information is stored within the 'urls' table.|12:Session Data|109:Chrome Session Data is stored in the 'Current Session', 'Current Tabs', 'Last Session' and 'Last Tabs' files.|10:Thumbnails|204:Chrome Thumbnails are stored in the 'Top Sites' SQLite database, within the 'thumbnails' table. Older versions of Chrome stored Thumbnails in a 'Thumbnails' SQLite database, within the 'thumbnails' table.|14:Website Visits|288:Chrome Website Visits are stored in the 'History' SQLite database, within the 'visits' table. Associated URL information is stored within the 'urls' table. Older versions of Chrome stored archived Website Visits in a separate 'Archived History' SQLite database, within the 'visits' table.|
HAlign=0
Width=1345
Height=501
Margin=10
}
Add(DSC_Query,13205430,518,119)
{
SQL="SELECT datetime(last_visit_time/1000000-11644473600,'unixepoch','localtime'),\r\n url \r\nFROM urls \r\nORDER BY last_visit_time DESC;"
DSManager="History"
}
Add(DSC_Query,1774469,518,161)
{
SQL="SELECT datetime(last_visit_time/1000000-11644473600,'unixepoch','localtime') AS 'date-time',\r\n url,\r\n title\r\nFROM urls\r\nWHERE date(last_visit_time/1000000-11644473600,'unixepoch','localtime') > date('now', '-1 day') \r\nORDER BY last_visit_time DESC;"
DSManager="History"
link(onQuery,9406249:doAddRow,[])
link(onColumns,9406249:doAddCols,[])
}
Add(MTStrTbl,8875967,777,203)
{
Width=923
Height=330
Align=5
Visible=1
Name="asdf"
Point(doVisible)
}
Add(TabControl,2629107,672,168)
{
Top=330
Width=923
Height=30
Align=4
Tabs=#23:История Chrome за сутки|21:Кол-во заходов на URL|
Bitmaps=[]
Bottom=0
link(onChange,10058744:doSet,[])
}
Add(MST_ColAction,8927836,245,231)
{
Action=9
MaxColWidth=500
Index=-2
MSTControl="asdf"
}
Add(Hub,4186973,469,161)
{
link(onEvent1,1774469:doQuery,[])
link(onEvent2,16391078:doQuery,[(508,174)(508,209)])
}
Add(MST_DB,9406249,567,161)
{
MSTControl="asd"
}
Add(MultiSetParam,10058744,721,168)
{
Parameters=#3:1;0|3:0;1|
Count=2
link(onSet1,7809938:doVisible,[])
link(onSet2,8875967:doVisible,[(767,181)(767,216)])
}
Add(StrCatDelim,13065512,294,168)
{
@Hint=#70:Если схема ничего не отображает измените путь к файлу History на свой.|
Str2="\Google\Chrome\User Data\Default\History"
link(onStrCatDlm,16151939:doCopy,[])
AddHint(99,150,197,26,@Hint)
}

карма: 15

0