-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `intel145_apps`
--

-- --------------------------------------------------------

--
-- Table structure for table `tips`
--

CREATE TABLE `tips` (
  `id` int(11) NOT NULL,
  `stat` char(1) NOT NULL DEFAULT 'I',
  `title` varchar(64) NOT NULL,
  `cat` varchar(64) DEFAULT 'cat',
  `subCat` varchar(64) DEFAULT 'subCat',
  `descr` text NOT NULL,
  `comments` varchar(512) DEFAULT NULL,
  `links` varchar(256) DEFAULT NULL,
  `tags` varchar(128) NOT NULL,
  `moreInfo` varchar(512) DEFAULT NULL,
  `attachments` varchar(128) DEFAULT NULL,
  `tipCreate` timestamp NOT NULL DEFAULT current_timestamp(),
  `tipMod` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;


INSERT INTO `tips` (`id`, `stat`, `title`, `cat`, `subCat`, `descr`, `comments`, `links`, `tags`, `moreInfo`, `attachments`, `tipCreate`, `tipMod`) VALUES
(199, 'I', 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Remove background garbage from jpg image so you can print', 'Go to Gimp Goto Colors Menu -> ThresholdThreshold Tool: Open your image in GIMP, go to the Colors menu, select Threshold to conv', '', '', 'https://www.lifewire.com/how-to-remove-background-gimp-4689190', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(200, 'I', 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Reminders App - To Move Item from one list to another', 'Select Task - Hold down CMD and click item - Drag once you get new reminder icon', 'how to move items - doesn\'t work consistently', '', 'https://tinyurl.com/46scbx8a', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(201, 'I', 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Usb Drive Not Mounting automatically', 'Listing of disk Mounting Points stored in lbin/dataFiles dfOut.txt mountOut.txt; Use these if you have to force mount the drive', '', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(202, 'I', 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Finder Defaults', 'Open Finder -> Go to As List ->Cmd+J - set defaults', 'Show Hidden Files: Cmd + Shift + .. ', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(203, 'I', 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Clean up disk space', '', 'Good tips', '', 'https://tinyurl.com/2b59tjsm', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(204, 'I', 'SUBSUBCAT', 'CAT', 'SUBCAT', 'Cleaning up Big Files', 'Empty Trash; goto settings->storage wait then go into each section to find large files; In messages you can remove large video f', 'Clean up big videos in Messages', '', '', 'MOREINFO', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(206, 'I', 'free test2', 'images', 'photos', 'Images for Web - no cost, copyright, attributions', 'Get free images for web use commercial/personal', 'Did this change update time 17:22:37 and 17:23:46 vs ', 'n', 'https://www.pexels.com/', 'Free Stock I', '2025-06-25 21:22:37', '2025-06-25 21:23:46'),
(213, 'I', '// These ini_set lines should be at the very top of your script ', '// These ini_set lines should be at the very top of your script ', '// These ini_set lines should be at the very top of your script ', '// These ini_set lines should be at the very top of your script\r\nini_set(\'display_errors\', \'Off\'); // Keep this off on live sites\r\nini_set(\'log_errors\', \'On\');\r\nini_set(\'error_log\', __DIR__ . \'/php_error.log\');\r\n\r\nadd thes lines her\r\n', '// These ini_set lines should be at the very top of your script\r\nini_set(\'display_errors\', \'Off\'); // Keep this off on live site', '', 'test', '// These ini_set lines should be at the very top of your script\r\nini_set(\'display_errors\', \'Off\'); // Keep this off on live site', '', '2025-06-26 20:54:30', '2025-06-26 20:55:38'),
(262, 'I', 'Test Script - Unit Test', 'testing', '', 'Good testing options\r\n~/lbin/testFname.sh\r\n\r\n', 'Getopts vs case\r\n-h vs --help', '', 'macos,sh,bash', '', '~/lbin/testFname.sh', '2025-11-05 13:04:00', '2025-11-05 13:04:00'),
(215, 'I', 'Grasses', 'Outdoor', 'plants', 'Pink and Green Grasses', 'Ruby Muhly Grass - $10', '', 'Plants', '', '', '2025-09-30 12:20:00', '2025-09-30 12:21:00'),
(216, 'I', 'Golf Simulator', 'Golf', '', 'Using foam Golf balls; Using Optishot2 $300 Screen: $200 $800 projector brighter lumens;\r\nUsing foam balls only 4” off the wall ', 'added new comments', 'https://www.msn.com/en-us/health/yogapilates/how-to-build-a-realistic-home-golf-simulator-on-a-budget/vi-AA1MEVSX?ocid=msedgntp&', 'Golf', '', '', '2025-09-30 13:14:00', '2025-09-30 13:14:00'),
(217, 'I', 'Cool Tools ', 'woodworking', 'Tools', 'Ideas on how to use other tools; like idea for chainsaw blade', '', 'https://www.facebook.com/share/r/175zQufqzQ/', 'tools', '', '', '2025-09-30 15:00:00', '2025-09-30 15:00:00'),
(218, 'I', 'Flop Shot', 'Golf', 'Chip', 'Flop shot - open face\r\nlower handle step back wider stance\r\nlong swing - back; break wrist;  need to release wrists and club go vertical - release and catch', '', 'https://www.facebook.com/reel/700387316366642', 'Golf', '', '', '2025-09-30 15:47:00', '2025-09-30 15:47:00'),
(219, 'I', 'ForeverGreen', 'golf', 'Tips', 'Multiple pages of tips and videos', '', 'https://golfgreens.com/golfgreens-tip-of-the-day/keep-stroke-short-short-distance-putts/', 'golf', '', '', '2025-10-03 20:21:00', '2025-10-10 20:21:00'),
(220, 'I', 'Macos Tahoe New Spotlight', 'macos', 'tahoe', 'When you invoke Spotlight Search with Command + Spacebar, you can switch to its dedicated modes like so: Applications (Command + 1), Files (Command + 2), Actions (Command + 3), and Clipboard (Command + 4). However, you can switch to these modes faster simply by adding the requisite number to your initial Spotlight invocation. For example, Command + Spacebar + 2 takes you straight to a Files search.', 'markdown - notes; spotlight - apps, files search\r\nMessages - polling; \r\nLock Screen - settings Clock\r\nFacetime - live translatio', 'https://www.macrumors.com/2025/09/24/all-the-new-macos-tahoe-features/', 'macos, tahoe', 'GenMoji - combine emojis\r\nPersonal Voice ; settings\r\nMultiple - Control Centers\r\nHold - assist phone?\r\nJournal - new app;\r\nClipb', '', '2025-10-04 01:55:00', '2025-10-04 01:55:00'),
(221, 'I', 'Get my ip Address', 'ip', '', 'How to get my ip address: https://whatismyipaddress.com/\r\n65.191.206.37 ', '', 'https://whatismyipaddress.com/', 'ip address,ip', '', '', '2025-10-06 00:46:00', '2025-10-06 00:46:00'),
(222, 'I', 'Visual Studio', 'vsc', 'tutorial', 'Videos for Visual Studio tutorials\r\n', '', 'https://code.visualstudio.com/docs/getstarted/introvideos', 'code, vsc,', '', '', '2025-10-04 01:29:00', '2025-11-08 13:47:00'),
(225, 'I', 'AI Code Tips', 'ai', 'code', 'TIps on Code \r\nvalid html, semantics included, responsive, error handling, \r\ndebug code via variable on or off, \r\n\r\nFeatures\r\n======\r\n- bs5\r\n- tailwind.css\r\n\r\ntemplate: \r\n=======\r\ndivPage, divNavBar, divToolBar: divToolBarLeft, divToolBarCenter, divToolBarRight, divTabs,\r\ndivContentMain\r\ndivContent: divContentLeft, divContentCenter, divContentRight\r\ndivFooter: divFooterLeft, divFooterCenter, divFooterRight\r\n\r\n Functions:\r\n========\r\n\r\nTheme Choose\r\nspinner for long processing calls i.e. Ajax\r\nscroll icon up/down on page - goto top/bottom', '', '', 'code, template', '', '', '2025-10-06 11:33:00', '2025-10-06 11:46:51'),
(226, 'I', 'TailWind.css Setup', 'code', 'css', 'set up in TailWind.css:\r\n-create tailwind.config.js\r\n- run tailwindcss --output styleTailWind.css\r\nThis will reduce the size of css to use only css needed\r\nTodo\r\n===\r\nmegamenu ../tailWind/tailWindMegaMenu.html\r\n../tailWind/navBarMega.html\r\n', 'tailwind.config.js\r\nmodule.exports = {\r\n  content: [\r\n    \'./*.php\',\r\n    \'./**/*.php\',\r\n    \'./*.html\',\r\n    \'./**/*.html\',\r\n    \'./*.js\',\r\n    \'./**/*.js\'\r\n  ],\r\n  theme: {\r\n    extend: {\r\n      colors: {\r\n        primary: {\r\n          DEFAULT: \'#2563eb\',\r\n          light: \'#3b82f6\',\r\n          dark: \'#1e40af\'\r\n        }\r\n      }\r\n    }\r\n  },\r\n  plugins: []\r\n};', '/opt/homebrew/var/www/rbutare/tailWind/', 'css', '<script src=\"https://cdn.jsdelivr.net/npm/@tailwindcss/browser@4\"></script><script src=\"https://cdn.jsdelivr.net/npm/@tailwindcss/browser@4\"></script><script src=\"https://cdn.jsdelivr.net/npm/@tailwindcss/browser@4\"></script><script src=\"https://cdn.jsdelid', '', '2025-10-07 10:48:00', '2025-10-07 10:48:00'),
(227, 'I', 'Convert HEIC to jpg', 'images', '', '?? Convert HEIC to JPG Using Finder Quick Actions\r\n-Open Finder and locate your .heic files.\r\n-Select one or multiple HEIC images.\r\n-Right-click (or Control-click) the selection.\r\n-Choose Quick Actions ? Convert Image.\r\n-In the pop-up:\r\n  -Set Format to JPEG\r\n-Choose Image Size (Small, Medium, Large, or Actual Size)\r\n-Click Convert.', '', '', 'heic, image, jpg', '', '', '2025-10-11 20:42:00', '2025-10-11 20:43:08'),
(228, 'I', 'FTP Applications', 'ftp', 'apps', 'Working:\r\n======\r\nfilezilla -\r\nMonsta - https://intellihometech.com/monstaFtp/\r\nftp2024@intellihometech.com\r\nftp.intellihometech.com\r\nhttps://intellihometech.com/monstaFtp/\r\nRick-Beach-732-319-6727-1P;\r\n\r\nFTP Username: ftp2024@intellihometech.com\r\nFTP server: ftp.intellihometech.com\r\nFTP & explicit FTPS port:  21\r\n\r\nNot working:\r\n=======\r\nTransmit\r\nCyberDuck\r\n\r\nLogin: ftp2024@intellihometech.com p: DrumH1;', '', '', 'ftp', '', '', '2025-10-12 18:03:00', '2025-11-08 17:45:00'),
(229, 'I', 'Five Crowns Development', 'develop', 'game', 'Todo\r\n===\r\ncardStyle - for deck pile offset images\r\n', '', '', 'dev', '', '', '2025-10-12 18:05:00', '2025-10-12 18:05:00'),
(230, 'I', 'SlideShow Dev', 'dev', '', 'Todo\r\n- why 2 json\r\n- save config to json \r\n- auto load with config\r\n- config: run, dev, test, dir?\r\n', '', '', 'dev', '', '', '2025-10-12 18:07:00', '2025-10-12 18:07:00'),
(231, 'I', 'Tips Development', 'dev', '', 'Tips Default to current time on load for add - add = mod; create always readonly \r\nChange Banner page and icon \r\nHow to create page icon\r\nMake Links if has string as http: a href\r\nsort by last modDate or id?\r\n\r\n\r\n\r\nhttps://fid.intellihometech.com/apps/tips/gemini/tips.php', '', 'http://localhost/rbutare/gemini/tips.php', 'dev', '', '', '2025-10-12 18:08:00', '2025-10-12 18:08:00'),
(232, 'I', 'Tail Winds Development', 'tutorial', 'tailwinds', 'Tailwinds.css - sample ideas\r\n', '', 'http://localhost/rbutare/tailwind/cruip-tutorials-main/', 'dev', '', '', '2025-10-12 18:11:00', '2025-10-12 18:11:00'),
(233, 'I', 'Tips for Unix Commands', 'unix', 'macos', 'find . -type f -exec chmod 664 {} \\;\r\nfind . -type d -exec chmod 775 {} \\;', '', '', 'macos,unix', '', '', '2025-10-12 20:51:00', '2025-10-12 20:51:00'),
(234, 'I', 'Vim Reset Width', 'vim', '', 'gg gqG \r\ng means : go to the beginning of buffer;\r\ngq means :\r\n\r\nSet textwidth to 80 (:set textwidth=80), \r\nmove to the start of the file (can be done with Ctrl - Home or gg), \r\nand type gqG. \r\ngqG formats the text starting from the current position and to the end \r\n\r\n', 'Non-Ascii characters\r\n/[^\\x00-\\x7F]\r\ng//[^\\x00-\\x7F]/s///g\r\n\r\nSet in Defaults\r\nset textwidth=80\r\n:set wrapmargin=2', 'https://stackoverflow.com/questions/5136902/vim-textwidth-has-no-effect', 'vim', '%s/[^[:print:]]//g', '', '2025-10-12 23:58:00', '2025-11-13 12:21:00'),
(235, 'I', 'Setup Config', 'vsc', 'coding', 'Visual studio setup \r\n.configs\r\nShell\r\nshellcheck fileName\r\nBrew installs - store what is installed\r\n\r\nHow to: \r\nrunsh - for access to remote files\r\ncreate a version - and move on\r\n', 'Todo', '', 'tips, setup, vsc', '', '', '2025-10-15 14:07:00', '2025-11-08 13:47:00'),
(237, 'I', 'Php', 'php', '', 'If php code in file.html - it is avoided ; if you change name to file.php ; then the code is executed.\r\ngood tip to link files so you can run either (sliceImg.php - sliceImg.html); one reads directory other just reads json file ; will also check for modifications dates to see if need to update list or json file', '', 'http://localhost/rbutare/airPlay/sliceImg.php', 'php,html', '', '', '2025-10-17 14:32:00', '2025-10-17 14:32:00'),
(238, 'I', 'Hacks - add type', 'hacks', '', 'Tool hacks - list types of hacks in video', '', 'https://www.facebook.com/share/r/1BG3Sdsk4S/?mibextid=wwXIfr', 'hacks, tools, todo', '', '', '2025-10-18 12:10:00', '2025-10-18 12:10:00'),
(239, 'I', 'Unix Comand Tips', 'tips', '', 'count files in directory - return only number found \r\nls -1 Docs/*.md | wc -l && ls -1 *.md 2>/dev/null\r\n\r\n\r\n', '#!/bin/zsh\r\n\r\necho \"=== MD files in Docs ===\"\r\ncount=$(ls -1 Docs/*.md 2>/dev/null | wc -l)\r\necho \"$count files\"\r\n\r\necho \"\"\r\necho \"=== MD files in root ===\"\r\nls -1 *.md 2>/dev/null || echo \"None (good!)\"\r\n', '', 'unix, cmd', '', '', '2025-10-18 20:52:00', '2025-11-08 13:44:00'),
(240, 'I', 'Add Applications for Slide Gallery', 'apps', 'code', 'brew install\r\n=======\r\n\r\npuppeteer \r\nplaywright\r\nfmpeg is a universal media converter\r\nnode\r\nPandoc is a Haskell library for converting from one markup format to\r\n       another\r\nhtmldoc - convert html to pdf; htmldoc -f output.pdf output.html;', 'Convert to pdf\r\nmarkdown WEDDING_SLIDESHOW_GUIDE.md > docs/WEDDING_SLIDESHOW_GUIDE.html\r\n\r\ncd /opt/homebrew/var/www/rbutare/airPlay\r\nfor file in docs/*.html; do\r\n    /Applications/Google\\ Chrome.app/Contents/MacOS/Google\\ Chrome \\\r\n        --headless --print-to-pdf-no-header \\\r\n        --print-to-pdf=\"docs/$(basename \"$file\" .html).pdf\" \\\r\n        \"file://$PWD/$file\"\r\ndone\r\n', '', 'brew, todo', 'update more information\r\n', '', '2025-10-19 23:18:00', '2025-10-19 23:18:00'),
(241, 'I', 'New Tools python', 'code', 'python', '? Other Ways to Use json.tool:\r\n1. Format a JSON file:\r\n2. Save formatted output:\r\n3. Validate JSON:\r\n4. Sort keys:\r\n? Alternative Tools:\r\nYou could also use:\r\n\r\n1. jq (more powerful):\r\n\r\n2. Node.js:\r\n\r\n3. PHP itself:\r\n\r\nphp listJson.php | php -r \"echo json_encode(json_decode(file_get_contents(\'php://stdin\')), JSON_PRETTY_PRINT);\"\r\n? Why We Used It:\r\nIn our case, we used it to verify the PHP output was:\r\n\r\n? Valid JSON\r\n? Properly formatted\r\n? Includes playlists from subdirectory\r\n? Easy to read and confirm\r\n? Summary:\r\nPart	What It Does	Example Output\r\nphp listJson.php	Runs PHP, outputs JSON	[\"a\",\"b\",\"c\"]\r\n|	Passes output to next command	(invisible)\r\npython3 -m json.tool	Formats JSON nicely	[\\n  \"a\",\\n  \"b\",\\n  \"c\"\\n]\r\nResult: Beautiful, readable JSON! ?\r\n\r\n', '', '', 'phython', '', '', '2025-10-20 22:26:00', '2025-10-20 22:26:00'),
(242, 'I', 'json validator', 'json', '', 'python3 -m json.tool faq.json > /dev/null && echo \"? JSON is valid\" || echo \"? JSON is invalid\"', '', '', 'json, validate, python', '', '', '2025-10-20 23:33:00', '2025-10-20 23:33:00'),
(243, 'I', 'MacOs/Unix Command Tips', 'todo', 'todo', 'ls -AGFp does not work on large directory; need to set COLUMNS=80 in ~/lbin/profileZsh\r\nmaster todo\r\n\r\nTips\r\n- fix sort to be newest to oldest\r\n- mega menu reports: kids, grand, bank, all Tots, managed, non, both man/non\r\nairPlayer\r\n=======\r\n- production run - uses config.json - should be production.json and playListProduction.json - test to make sure they both exist and are current ; create summary of config before running\r\n- find sh created for this\r\n\r\n\r\n', 'Other things todo:\r\n- find visual diff tool for csv8 9 and 9-10 with clipboard fix\r\n- locate working ftp\r\n\r\nVisual Code\r\n=================\r\nallow shell integration for commands to run automatically\r\n- find tutorials\r\n\r\n\r\n', '', 'macos,unix,commands', 'more info ideas from ', '', '2025-10-21 00:02:00', '2025-11-08 13:43:00'),
(244, 'I', 'Bocce Court Installation', 'bocce', '', 'Layers\r\n3-4\" stone ABC\r\n2\" Top Layer Screenings', '', 'https://www.legreillon.com/the-ultimate-diy-guide-to-bocce-court-construction-projects/', 'bocce', '', '', '2025-10-21 11:57:00', '2025-10-21 11:57:00'),
(245, 'I', 'Putting Green Installation Ide', 'golf', 'Putting', 'Good tips on setting up golf green \r\nIdeal Turf - Texas https://ideal-turf.com\r\nSoftware - \r\nCost Calculator - Not available \r\n\r\nTonage Calculator: https://www.hedrickind.com/tonnage-calculator/\r\nTons to Yds: https://cubicyardcalculator.org/tons-to-cubic-yard-calculator/\r\n54 tons to yds 41 Abc 60x50 3\"\r\n45 tons to yds 34 Abc 60x50 2.5\"\r\n40 tons to yds 30 Abc 60x50 2\"\r\nScreenings\r\n21 tons to yds 41 Abc 60x50 2\"\r\n', 'Do you want holes in putting green turf? Won\'t sand wash out and under turf?\r\nDIY Outdoor Putting Green Kits for the Backyard | Ultra Base\r\nhttps://www.ultrabasesystems.com/diy-designer-golf-kits.html', 'https://www.golfwrx.com/659400/taking-the-backyard-putting-green-plunge/?edge_reader_page#', 'putting,install', '', '', '2025-10-22 11:28:00', '2025-12-11 15:50:00'),
(246, 'I', 'Tips todo', 'Todo', 'todo', '== heading of Todo ==\r\n[x] Checkmark?\r\n- [x] Checkmark?\r\n# Not Working\r\n- Double Click  vs single click\r\n- add iPhone\r\n\r\n- add row expansion ;\r\n- add button in actions to view as html page in new tab\r\nxAdd delete \r\n- Data Reports Funcion \r\n- add navbar - Admin, help, etc,\r\n- View info iPhone\r\nxSort by newest \r\nxSet dates on add new\r\nxConfirm date mod on chg \r\n- move css and js scripts to external files of all reusable components \r\n- expansion needs to look like part of same row not different color; perhaps offset when expanded\r\nNeed a better ux to show filter is enabled; after update with a filter on new record is not shown? confusing - what is best approach; always clear filter after add or keep?\r\n\r\n- [x] Do something done\r\n\r\nAdd delete \r\nView info iPhone\r\nSort by newest \r\nSet dates on add new\r\nConfirm date mod on chg \r\nNeed a better ux to show filter is enabled; after update with a filter on new record is not shown? confusing - what is best approach; always clear filter after add or keep?\r\n\r\n== End of Descriptions ==\r\n\r\n\r\n', '-Add delete to update screen\r\n- datatable to show what filtering is happening; button to clear filter\r\n\r\n== Todo ==\r\n- double click should go to edit\r\n- open on single click ; edit button not working\r\n- comment and description should show in markup in datatable\r\n- search by column should be at bottom of page\r\n- LINKS IN DATATABLE SHOULD BE CLICKABLE\r\n- idea for action buttons to be in first column (single icon) click expands to as for (edit, html, print etc)\r\n\r\n\r\n\r\n\r\n== Tips ==\r\n\r\ndefault to sort order be b', 'https://fid.intellihometech.com/apps/tips//tipsNew.php', 'Todo', '= delete or chg', '', '2025-10-22 12:21:00', '2025-12-30 19:28:00'),
(247, 'I', 'Tree Command', 'macos', 'todo', 'homebrew tree command\r\ntree -dsa\r\nget tree view with size in bytes\r\n', '', '', 'macos,todo, command', '', '', '2025-10-25 14:07:00', '2025-11-08 13:44:00'),
(248, 'I', 'PHP', 'php', '', 'php commands\r\nphp -m ; installed components\r\nphp -l test for syntax errors', '', '', 'php', '', '', '2025-10-25 14:11:00', '2025-10-25 14:11:00'),
(249, 'I', 'Node', 'node', 'todo', 'Tools \r\nnode -c assets/js/main.js - check syntax without executing\r\n', '', '', 'todo, node', 'Find tools to use with visual Studio Coding markdownlint README.md', '', '2025-10-25 19:08:00', '2025-11-08 13:44:00'),
(250, 'I', 'good tips', 'Tips', '', 'join boards at corner\r\nBottle cap screw onto tarp\r\nJoin two same size pipes heati', '', 'https://youtube.com/shorts/UwtHJoB0YX4?si=whz0dfMR4cDyl2vJ', 'Tips', '', '', '2025-10-27 16:09:00', '2025-10-27 16:09:00'),
(251, 'I', 'ai copilot', 'ai', 'copilot', 'ask copilot to compare info a cross tabs\r\nSmarter Edge “Copilot Mode”\r\nMulti?tab analysis – I can compare products, summarize across all your open tabs, or consolidate research into one view.\r\n\r\nJourneys – Your browsing history gets grouped by topic (say, “robot vacuums” or “travel planning”), so you can pick up research right where you left off.\r\n\r\nCopilot Actions – I can now handle tasks like unsubscribing from emails, booking reservations, or even opening pages by voice.\r\n\r\nRick, given your love of modular, stepwise workflows, I think the multi?tab analysis + Journeys combo in Edge might be right up your alley—it’s basically a research accelerator. Want me to show you how those two features could streamline your current robot vacuum research project?', 'Long?term Memory – I can now remember key details you share across sessions (and you can edit or delete them anytime). This makes our conversations more continuous and personalized.\r\n\r\nMico (Clippy 2.0) – An optional visual companion that reacts, listens, and adds a more expressive layer to our chats. Totally optional, but fun if you like a more animated presence.\r\n\r\nReal Talk Mode – A new conversation style where I’m more direct and transparent, great for when you want less polish and more straight talk.\r\n', '', 'tips, junk', 'Not sure what this is for\r\n', '', '2025-10-29 02:14:00', '2025-10-29 02:14:00'),
(252, 'I', 'Macos Performance', 'macOS', '', 'Optional: Using:  memory_pressure\r\nUsing vm_stat for detailed stats: vm_stats\r\nChecking Memory (RAM) Usage top -l 1', 'For overall storage management, identify large files with du commands and remove unnecessary files.\r\nTo continuously monitor memory and CPU usage, you can use:\r\ntop -stats pid,command,cpu,mem', '', 'macOS', 'Overview of all mounted filesystems using df: df -h\r\n\r\ndu -sh ~/Documents\r\n\r\nFinding the Largest Files and Folders: du -ah ~/ | sort -rh | head -n 10', '', '2025-10-29 02:16:00', '2025-10-29 02:16:00'),
(253, 'I', 'Ai docs requirements ', 'Vsc', 'Coding', 'create docs requirements.md\r\nPlan.md tasks.md', '', 'https://blog.jetbrains.com/junie/2025/10/how-to-use-a-spec-driven-approach-for-coding-with-ai/', 'Ai, coding todo', 'add samples', '', '2025-10-31 12:50:00', '2025-10-30 12:50:00'),
(254, 'I', 'How to create favicon', 'image', 'favicon', 'Generate favicon.ico with Text - one lettter', '', 'https://favicon.io/favicon-generator/', 'image, favicon', 'https://favicon.io/favicon-generator/ Text', '', '2025-11-01 14:09:00', '2025-11-01 14:09:00'),
(255, 'I', 'Convert Video', 'images', 'ffmpeg', 'convert to smalller mp4\r\nffmpeg -i A211.webm -vcodec libx265 -crf 30 -c:a copy -strict experimental A211.mp4; \r\n\r\n\r\n0\r\n\r\n', '', 'https://stackoverflow.com/questions/18123376/webm-to-mp4-conversion-using-ffmpeg', 'ffmpeg, images, video, mp3,mp4,webm', 'Trim/Shorten/Cut\r\nhttps://shotstack.io/learn/use-ffmpeg-to-trim-video/\r\n\r\nffmpeg -sseof -600 -i input.mp4 -c copy output5.mp4\r\nffmpeg -sseof -00:10:00 -i input.mp4 -c copy output6.mp4\r\nBoth of the above two commands will make a cut of the last 10 minutes of the input video.\r\n\r\nCut Front/Beginning\r\nffmpeg -i $fileOutput1 -ss 00:00:00 -to 00:6:08 -c:v copy -c:a copy $fileTrim\r\nuse time on left to cut at the end\r\n\r\nThe above command uses -to to specify an exact time to cut to from the starting position. The cu', '', '2025-11-01 20:00:00', '2025-11-01 20:00:00'),
(256, 'I', 'List Directory Code', 'listdir', 'code', 'All Directories\r\nhttp://localhost/rbutare/airPlay/listDirAll.html\r\n\r\n\r\n\r\nhttp://localhost/rbutare/airPlay/utilities/php/listDir.php\r\n\r\n', 'http://localhost/rbutare/airPlay/airPlay/utilities/php/listDir.php\r\nhttp://localhost/rbutare/airPlay/airPlay/utilities/php/listDirectory.php\r\nhttp://localhost/rbutare/airPlay/memoriesPlayer/listDirExplorer.php\r\nhttp://localhost/rbutare/airPlay/memoriesPlayer/listDirGraph.php\r\nhttp://localhost/rbutare/airPlaymemoriesPlayer/listDir.php', 'http://localhost/rbutare/airPlay/listDirAll.html', 'directory, listdir', 'explorer', '', '2025-11-01 22:41:00', '2025-11-01 22:41:00'),
(257, 'I', 'Ai Accounts', 'ai', 'code', 'Accounts: zencoder - rickbeachlbi@gmail.com  ', 'xx', 'x', 'openai, ai, code', 'xxx', 'xx', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(258, 'I', 'mySql Access', 'mysql', '', 'If mysql access gets denied from localhost;\r\ngo to cpanel.intellihometech.com - mysql Remote add ip address to allow access\r\n', 'sue ip: 136.56.107.113', '', 'mysql', '', '', '2025-11-03 18:26:00', '2025-11-03 18:26:32'),
(260, 'I', 'Tips Fidelity', 'app', 'todo', 'Create a new set of code to work from to \r\n- cleanup ui\r\n- fix navbar menus; toolbar mouse over icons\r\n- all data search/report\r\n- master app - toggle columns, copy, print, csv, buttons\r\n\r\nTodo for fidelity app https://fid.intellihometech.com/table.php\r\n- Report on high low for year\r\nbegin end year report\r\nreturns for Year, ytd, all; aTot, bTot, cTot etc ', '- Mega Menu\r\n- DataTable\r\n- Search by column\r\n- update connDb - code - refactor \r\n5-18-2018 1,241,302.68\r\n\r\n', 'https://fid.intellihometech.com/table.php', 'apps, fidelity', '', '', '2025-11-05 11:29:00', '2025-11-08 13:42:00'),
(261, 'I', 'Bootstrap 5 Examples', 'bootstrap', 'todo', 'List of all bootstrap examples\r\n~/lbin/tipsSrc/themePlay/bootstrap-5.0.2-examples', '', '/tipsSrc/themePlay/bootstrap-5.0.2-examples', 'todo, bootstrap, example', '', '~/lbin/tipsSrc/themePlay/bootstrap-5.0.2-examples', '2025-11-05 11:40:00', '2025-11-05 11:40:00'),
(263, 'I', 'Chat questions ', 'Ai', 'S', 'Login paid for: ', 'C', 'https://www.tomsguide.com/ai/i-created-one-chatgpt-prompt-that-works-in-absolutely-any-situation-heres-how-to-use-it', 'Ai', 'M', 'T', '2011-12-25 05:00:00', '2025-12-23 16:41:00'),
(264, 'I', 'Golf putting', 'Golf ', '', 'Putting tips', '', 'https://www.facebook.com/share/v/1CWMiKXUE2/?mibextid=wwXIfr', 'Golf, putting', '', '', '2025-11-07 06:16:00', '2025-11-07 06:16:00'),
(265, 'I', 'MacOs Tools Cleanup - Space', 'macOs', '', 'Downloaded from app store: \r\nDisk Diag: - Clean up system files shows good view of disk\r\nMemory Diag: - clean memory\r\n\r\nHomebrew:\r\njdupes - Duplicate file (newer/faster)\r\nfdupes - Duplicate file (finds pairs)', 'CLI/Shell \r\n~/lbin/macCleaner - tool to cleanup system and large files\r\n~/lbin/brewInfo - files installed by homebrew\r\n', '', 'macOs, tools, disk, cleanup', '', '/Users/rbutare/lbin/macCleaner', '2025-11-07 13:50:00', '2025-11-07 13:52:00'),
(266, 'I', 'Visual Diff Tool', 'diff', 'vim', 'Visual diff of two files:\r\nvimdiff file1 file2', 'Good tool to see diffs between two files', 'https://lynxbee.com/compare-files-with-visual-file-diff-tool-of-vim/', 'vim, diff', '', '', '2025-11-07 15:07:00', '2025-11-07 15:07:00'),
(267, 'I', 'Microsoft Copilot Features', 'copilot', '', 'Tips copilot edge msft 365', 'kevinstratvert.com\r\n\r\nTop 10 Copilot Features to Boost Productivity\r\nCompare Files in OneDrive\r\n\r\nUse Copilot to quickly compare two documents side-by-side and highlight differences.\r\n\r\nSummarize Emails in Outlook\r\n\r\nCopilot can extract key points from long email threads, saving time and reducing inbox fatigue.\r\n\r\nGenerate PowerPoint Presentations\r\n\r\nCreate branded, professional slides from a simple prompt or Word document.\r\n\r\nAnalyze Excel Data\r\n\r\nAsk Copilot to find trends, generate charts, or explain for', 'https://youtu.be/sdN7C8xRoH4?si=6PKwBW5XiIGlTOKc', 'msg, edge, copilot, tips', '', '', '2025-11-07 15:28:00', '2025-11-07 15:33:00'),
(268, 'I', 'Outlook - Tips', 'outlook', 'tips', 'How to search:\r\nfrom:spectrum AND isflagged:false - no flag\r\n\r\nUse filter to get advanced search', '', '', 'outlook', '', '', '2025-11-08 12:40:00', '2025-11-08 12:40:00'),
(269, 'I', 'Cleanup Directories Files', 'cleanup', 'todo', 'Goto terminal /Volumes/[nameOfDrive] rm -rfv *.interupted files\r\nscreenshotter - icloud get icons images colors\r\n', 'Cleanup icloud;\r\n\r\nHow to clean up messages of big images/movies\r\n\r\nhttps://beebom.com/how-clear-icon-cache-mac/', 'https://beebom.com/how-clear-icon-cache-mac/', 'cleanup, todo', '/Library/Caches/com.apple.iconservices.store - can cleanup ', '', '2025-11-08 13:36:00', '2025-11-08 13:42:00'),
(270, 'I', 'Apple Genius Bar', 'MacBook', '', 'Problems:\r\nRunning out of Application Memory\r\n- calendar in toolbar/menubar\r\n- remove images from messages\r\n- remove system backup /temporary files\r\n- remove language files\r\n- devtools?', '', '', 'apple, genius', '', '', '2025-11-08 13:50:00', '2025-11-08 13:50:00'),
(271, 'I', 'Southwest trip', 'Trip', '', 'National Park ', '', 'https://www.facebook.com/share/r/1HnKW2mULm/?mibextid=wwXIfr', 'Trip', '', '', '2025-11-08 14:36:00', '2025-11-08 14:36:00'),
(272, 'I', 'Golf swing door', 'Golf', '', 'door frame swing method', '', 'https://www.facebook.com/share/v/14Vy2TgQdrK/?mibextid=wwXIfr', 'Golf', '', '', '2025-11-08 14:44:00', '2025-11-08 14:44:00'),
(273, 'I', 'Trips nc', 'Trips', 'Waterfalls ', 'Top 10', '', 'https://www.facebook.com/share/r/17PbYcKLLF/?mibextid=wwXIfr', 'Nc,trip, waterfall ', '', '', '2025-11-08 16:13:00', '2025-11-08 16:13:00'),
(274, 'I', 'Vsc Requirements documents', 'vsc', 'todo', 'Terms:\r\nModular resuable components, toast, html, bs5, fontawesome, Follow DRY (Don\'t Repeat Yourself) principles,camelCase, card based theme, mobile responsive, \r\nprofessional look and feel, dashboard\r\nfunctions: use/chg bs themes, spinner for slow tasks, page up/down, toast messaging, \r\nadmin: database checks, security. checks, duplicates, bad records, dashboard, tools to add to faq, missing days stock market open (id list of holidays/closings), adhoc queries and tools;  todo list of new/bug features\r\nSettings: global settings debugFlg, theme, user level, adv debugging - additional error messaging depending on the error level\r\n\r\nuse of json configuration files for customization/setup\r\n\r\nDocumentation:\r\nuser, programmer, function calls, flow charts, recommendations for improvement\r\n\r\nimprovements;\r\nrefactor, performance, id long running processes, duplicate/obsolete code, o\r\n\r\nCode breakdown/modules designed for re-use in other apps; organize that way;\r\nstandard app configuration: ', 'Phase 2 (if desired):\r\n\r\nCharts & visualizations\r\nAdvanced filtering sidebar -  flat picker\r\nRecent reports widget\r\nKeyboard shortcuts\r\n\r\nPhase 3 (future):\r\n\r\nUser preferences panel\r\nFavorites system\r\nInteractive tour\r\nCustom report builder\r\n\r\nNext up is implementing report tabs for Data/Chart/Summary views\r\nCan you build an app that \r\n\r\nStructural divs in MVC Template \r\nNow let\'s refactor the includes to be content-only (no major structural divs):', 'https://code.visualstudio.com', 'vsc, todo, requirements', '', '', '2025-11-08 23:19:00', '2025-11-13 03:07:00'),
(275, 'I', 'Golf swing ', 'Golf', '', 'alignments practice ', '', 'https://www.facebook.com/share/r/17jU7GS6rA/?mibextid=wwXIfr', 'Golf, practice ', '', '', '2025-11-09 01:56:00', '2025-11-09 01:56:00'),
(276, 'I', 'Piwigo Gallery Software', 'photoGallery', '', 'Piwigo has been successfully installed at :\r\nhttps://intellihometech.com/piwigo\r\nAdministrative URL : https://intellihometech.com/piwigo/identification.php\r\nadmin page; \r\nhttps://intellihometech.com/admin.php?page=site_update&site=1\r\n', 'admin: OurLifeInPics;\r\n', 'https://intellihometech.com/piwigo', 'piwigo,photos', '', '', '2025-11-09 12:23:00', '2025-11-09 12:45:00'),
(277, 'I', 'Chip with tee', 'Golf', 'Chip', 'Tee grip length in front of chip\r\nFollow thru over tee\r\n\r\n3 tips\r\n\r\n\r\nhttps://www.facebook.com/share/v/167eTLBUT8/?mibextid=wwXIfr', 'Chip with stick in belt\r\nhttps://www.facebook.com/share/r/1QmZ1TLuNh/?mibextid=wwXIfr', 'https://www.facebook.com/share/r/1HTf6T79hh/?mibextid=wwXIfr', 'Golf,chip', '', '', '2025-11-11 04:12:00', '2025-12-14 16:50:00'),
(278, 'I', 'Wish List', 'wish', '', 'Wish List Items\r\n============\r\n- Weather Station\r\n- Heated Blank\r\n- \r\n- Power hedge trimmer\r\nEGO POWER+ 56-volt 26-in Battery Hedge Trimmer 2.5 Ah Battery Included , Charger Included\r\nItem #5207557 |Model #HT2601 $269 lowes with charger; \r\nModel Next door: \r\n- New Vacuum - Hazel\r\n- new slippers or Same shoes\r\n', '', 'https://www.protoolreviews.com/ego-carbon-fiber-rail-hedge-trimmer-review/', 'wishlist', '', '', '2025-11-11 16:54:00', '2025-11-11 21:21:00'),
(279, 'I', 'Websites info', 'Web', 'Hosting', 'website host: inmotionhosting\r\nRegistration : NAMECHEAP.com', '', 'https://www.namecheap.com/myaccount/signout/?loggedout=yes', 'Web,up, hosting,website', '', '', '2025-11-12 07:09:00', '2025-11-12 07:09:00'),
(280, 'I', 'Git Hub Ticket System', 'gitHub', '', 'Ticket system for github', 'Paid on 20251106 $100 for gitpro?', 'https://support.github.com/tickets/personal/0', 'github, support', '', '', '2025-11-12 14:43:00', '2025-11-12 14:43:00'),
(283, 'I', 'Best ai use cases', 'Ai', '', 'Ai for ', '', 'https://github.blog/ai-and-ml/github-copilot/which-ai-model-should-i-use-with-github-copilot/?utm_campaign=LCM_CopilotProOnboarding_dev&utm_source=github', 'Ai, ', '', '', '2025-11-12 20:55:00', '2025-11-12 20:55:00'),
(282, 'I', 'Putting Green Quotes - Excel', 'quote', 'golf', 'Putting green quotes excel ', '', '', 'quote,golf,putting, ', '', '~/Golf/golfFinal/20251111QuotesAll.xlsx', '2025-11-12 15:08:00', '2025-11-12 15:08:00'),
(284, 'I', 'Unix/Macos Commands', 'macos', '', 'curl -X GET \'http://localhost/rbutare/fid/templates/v2/common/admin/tools/permission-checker.php?action=critical\'\r\n\r\nsync directories\r\nrsync -av old new\r\n ', '', '', 'unix, macos', '', '', '2025-11-15 12:45:00', '2025-11-15 12:45:00'),
(285, 'I', 'Git tutorial ', 'Git', '', 'These key commands are now in your toolkit: git init, git add, git commit, git status, git log, git branch, git checkout, git merge, git push, git pull, and git clone.\r\n', '', 'https://deployn.de/en/blog/git-tutorial/', 'Git, tutorial', '', '', '2025-11-17 12:36:00', '2025-11-17 12:36:00'),
(286, 'I', 'Ai best model', 'Ai', 'ai', 'Which model is best for ? \r\nFill in \r\n', 'https://github.blog/ai-and-ml/github-copilot/which-ai-model-should-i-use-with-github-copilot/?utm_campaign=LCM_CopilotProOnboarding_dev&utm_source=github', 'https://github.blog/ai-and-ml/github-copilot/which-ai-model-should-i-use-with-github-copilot/?utm_campaign=LCM_CopilotProOnboarding_dev&utm_source=github', 'Ai, todo', '', '', '2025-11-18 13:18:00', '2025-11-19 12:21:00'),
(287, 'I', 'Vsc plan agent', 'Vsc', 'Ai', 'Plan agent \r\nDefine requirements then see plan to execute ', 'Try out', 'https://youtu.be/xR3fuKtWGN0', 'Vsc,ai', '', '', '2025-11-20 10:52:00', '2025-11-20 10:52:00'),
(288, 'I', 'Testing Commands', 'test', '', 'Confirm sql is running: \r\nnc -vz intellihometech.com 3306\r\n# or\r\ntelnet intellihometech.com 3306', 'add more to this', '', 'test, todo', '', '', '2025-11-20 04:38:00', '2025-11-20 04:38:00'),
(289, 'I', 'ClipChamp Video Editor', 'video', '', 'Video editor to create easy to use', '', 'https://app.clipchamp.com/consumer/home', 'img, video', '', '', '2025-11-23 00:38:00', '2025-11-23 00:38:00'),
(290, 'I', 'Setapp - macpaw', 'macos', 'apps', 'Setapps - 260 plus apps and ios apps\r\nmacCleaner, cleanMyMac, bartender, istat, cyberduck, unclutter, menubar, menubarX\r\nunite?, forklift, cleanmyIphone, touchRetouch, glyphs mini, expressions, \r\nssh config,sql pro,   swiftly Launch, typingmind, riveo, moonlock, mindNote Next, joyCast - improve audio\r\ncommandOne, houdah spot, pdfSqueezer, gemini, supercharge, bartender, displaybuddy, \r\n\r\nwriteCode, permute -convert files, bartender\r\n\r\nAI: boltAi, plus, ', 'Future want eney - ai assistant', 'https://setapp.com/pricing?irgwc=1&afsrc=1&clickid=SqozojQHtxycRgRz93xED1iiUkpWOIxuUzpLyw0&iradid=368247&irpid=2003851&utm_content=TEXT_LINK&utm_campaign=Bing%20Rebates%20by%20Microsoft&sharedid=EdgeBingFlow&utm_medium=affiliate&mpaid=3&utm_source=impactra', 'macos, apps, ios, macpaw', '', '', '2025-11-24 18:09:00', '2025-11-24 18:09:00'),
(291, 'I', 'macos tools', 'macOs', '', 'Tools to test:\r\nmacCleaner - clean up files to get more space\r\nsysDashBoard - Dash board\r\nsysDashBoard.txt - Requirememnts\r\nmemDashBoard - memory Dashboard\r\nmemChk - memory check\r\n\r\n', 'sysDashBoard -h\r\nSystem Dashboard Help\r\n---------------------\r\nOptions:\r\n  --help, -h       Show this help message\r\n  --memory, -m     Memory overview + top processes by RSS\r\n  --cpu, -c        Top processes by CPU usage\r\n  --disk, -d       Disk space usage\r\n  --load, -l       Load average\r\n  --proc, -p       Total process count\r\n  --swap, -s       Swap usage\r\n  --all, -a        Run full dashboard (all checks)', '', 'macOs,lbin', '', '', '2025-11-24 20:24:00', '2025-11-24 20:24:00'),
(292, 'I', 'Brew - all installed files', 'brew', '', 'Installed files/apps from brew\r\nbrew list\r\nsee file in: ~/lbin/brewList.txt', 'fd .mov -E Library -X ls -lh - exclude Library and show ls -lh\r\nfid txt lbin - search directory lbin\r\nfd \"^x.*.txt\" lbin -X vim - send items found to vim\r\nfd  \"xm\" lbin -E  \"*.txt\"  - find files xm without .txt\r\nfd \"^x.*.txt\" lbin  - need to use regular expressions to get all the files \r\nfd  . lbin -e psh -X cat - find anything . in lbin with extension psh -X send to cat', '', 'brew, macos, apps', '', '~/lbin/brewList.txt', '2025-11-26 12:34:00', '2025-11-26 12:34:00'),
(293, 'I', 'macOS applications ', 'Macos', '', 'Mac apps\r\nhttps://github.com/jaywcjlove/awesome-mac', '', 'https://github.com/jaywcjlove/awesome-mac', 'macOS, software ', '', '', '2025-11-26 18:29:00', '2025-11-26 18:29:00'),
(294, 'I', 'Alexa development', 'alexa', 'code', 'alexa Development \r\n', 'alexa ideas:\r\nAlex tell me the weather outside (from my current location) give temperature, real feel and humidity, todays high and low; ', 'https://www.youtube.com/@AlexaDevelopers', 'alexa, code', '', '', '2025-11-30 13:02:00', '2025-11-30 13:02:00'),
(295, 'I', 'Cleaning up disk space ', 'macos', '', 'Commands to cleanup mac disk:\r\n~/lbin/macCleaner\r\n~/lbin/macCache - cache cleaner', 'key folders to check\r\ndu -sh /Users/rbutare/Library/Caches\r\ndu -sh /Users/rbutare/Library/Caches/Google/Chrome\r\ndu -sh /Users/rbutare/.cache\r\ndu -sh /Users/rbutare/.npm\r\n\r\nsudo softwareupdate -l        - shows updates ready to install\r\nsudo softwareupdate --clear-catalog     - clears out files maybe left over from updates of apple installs\r\n\r\nsudo softwareupdate ', '', 'macos', '', '', '2025-12-02 14:34:00', '2025-12-02 14:34:00'),
(296, 'I', 'API keys', 'Api', '', 'API dev keys\r\nFINNHUB_API_KEY=d198di1r01qkcat6n9mgd198di1r01qkcat6n9n0', '\"ALPHA_VANTAGE_API_KEY\": \"A40SNBVIKGJ5KCAR\",\r\n        \"FINNHUB_API_KEY\": \"d198di1r01qkcat6n9mgd198di1r01qkcat6n9n0\",\r\n        \"TWELVE_DATA_API_KEY\": \"1fc95863eb26405aa1c0925bb7ab7b96\",', '', 'Api', '', '', '2025-12-03 01:47:00', '2025-12-03 01:47:00'),
(297, 'I', 'Green 2 ', '', '', 'Xgolf ultra base\r\nMonterey $6400 + shipping Nancy\r\n\r\nPlate compactor venom $409\r\nConcrete cutter $110\r\n2” pavers bocce walkway\r\n3” 45/30\r\n', '', '', 'Putting ', '', '', '2025-12-03 02:49:00', '2025-12-03 02:49:00'),
(298, 'I', 'Plate Compactor', 'tools', 'compactor', 'Vevor Model: RYPBYS35165HP8ZULV0\r\nPlate 23.7 x 18.9\"\r\nCoupon code\r\nAE82CE7CA0CB104E', 'Lowes: https://www.lowes.com/pd/VEVOR-Plate-Compactor-23-7-in-x-18-9-in-Tampers/5015875849?irclickid=SRD0U2V0dxycRtrQtXxZYVEuUkpTErx2UzpLyw0&irgwc=1&afsrc=1&cm_mmc=aff-_-c-_-prd-_-mdv-_-gdy-_-all-_-EdgeBingFlow0-_-2003851-_-0 $399', 'https://www.bing.com/videos/riverview/relatedvideo?q=RYPBYS35165HP8ZULV0&ru=%2fsearch%3fq%3dRYPBYS35165HP8ZULV0%26FORM%3dSHOPZR&mmscn=vwrc&mid=DBC4DB3FACB00F14B225DBC4DB3FACB00F14B225&FORM=WRVORC&ntb=1&msockid=cf1fe8bed03311f0924e20f7910f87ae', 'compactor, tools', 'https://www.vevor.com/promotion/coupon-center-special-119.html?currency=USD&lang=en', '', '2025-12-03 11:09:00', '2025-12-05 09:53:00'),
(299, 'I', 'Weather', '', '', '#!/usr/bin/env php\r\n<?php\r\n// weather.php - Dispatcher-style CLI for VEVOR station\r\n\r\n$options = getopt(\"\", [\"station:\", \"color\", \"debug\"]);\r\n$stationId = $options[\'station\'] ?? \'YOUR_STATION_ID\';\r\n$useColor  = isset($options[\'color\']);\r\n$debug     = isset($options[\'debug\']);\r\n\r\n// Fetch JSON from Weather Underground API\r\n$url = \"https://api.weather.com/v2/pws/observations/current?stationId={$stationId}&format=json&units=m&apiKey=YOUR_API_KEY\";\r\n$json = file_get_contents($url);\r\n$data = json_decode($json, true);\r\n\r\n// Dispatcher: route events\r\nfunction dispatch($data, $useColor) {\r\n    $temp = $data[\'observations\'][0][\'metric\'][\'temp\'];\r\n    $wind = $data[\'observations\'][0][\'metric\'][\'windspeed\'];\r\n    $rain = $data[\'observations\'][0][\'metric\'][\'precipRate\'];\r\n\r\n    $alerts = [];\r\n    if ($temp < 0) $alerts[] = \"Frost Alert\";\r\n    if ($rain > 10) $alerts[] = \"Heavy Rain\";\r\n    if ($wind > 40) $alerts[] = \"Storm Warning\";\r\n\r\n    foreach ($alerts as $alert) {\r\n        echo $useColor ? \"\\033[31m$alert\\033[0m\\n\" : \"$alert\\n\";\r\n    }\r\n}\r\n\r\n// Run dispatcher\r\ndispatch($data, $useColor);\r\n\r\nif ($debug) {\r\n    print_r($data);\r\n}\r\n', 'How to get my zip', '', 'Todo', '', '', '2025-12-04 12:16:00', '2025-12-04 12:16:00'),
(300, 'I', 'zen coder test on lbin', 'code', '', '~/lbin/.zencoder/rules\r\nquetions\r\nWhat would you like me to do?\r\n\r\nDefine coding standards for your project from scratch?\r\nReview and improve existing documentation/coding standards?\r\nCreate specific documentation (e.g., contribution guidelines, code style guide)?\r\nSomething else?\r\nScope - Which part(s) of your repository should this apply to?\r\n\r\nAll scripts (Bash, Shell, Python, PHP, AWK, JavaScript)?\r\nSpecific language or component (e.g., just the Bash scripts, or just Python)?\r\nThe entire lbin project?\r\nFocus Areas - Are there specific aspects you\'d like standards for?\r\n\r\nNaming conventions?\r\nError handling and logging?\r\nCode organization and structure?\r\nDocumentation/comments?\r\nSecurity practices?\r\nPerformance considerations?\r\nAll of the above?\r\nDocumentation Format - What documentation would be most useful?', 'Files Recommended for vsc\r\nCONTRIBUTING.md for contributors?\r\nCODING_STANDARDS.md or STYLE_GUIDE.md?\r\nREADME updates for specific components?\r\nInline examples in existing files?\r\n', '', 'code,todo', '', '', '2025-12-04 21:12:00', '2025-12-04 21:13:00'),
(301, 'I', 'Setapp Apps downloaded', 'setapp, macos, ios', '', 'Macos Apps\r\nAnyTrans - transfer to from ios/macos\r\nistat - system status\r\nmacCleaner - clean up mac $50\r\nBolt AI - AI - coding helper\r\nhoudaspot - $19', 'ios Apps\r\nAnyTrans - transfer to from ios/macos', '', 'setapp, ios, macos', '', '', '2025-12-04 21:22:00', '2025-12-08 16:11:00'),
(302, 'I', 'htaccess', 'webserver', '', '.htaccess\r\n\r\n  1 Options +Indexes$\r\n  2 IndexOptions ScanHTMLTitles FancyIndexing IconsAreLinks$', '', '', 'webserver', '', '', '2025-12-04 21:32:00', '2025-12-04 21:32:00'),
(303, 'I', 'Golf drill no right hand', 'Golf', '', 'Open right hand and swing thru', '', 'https://www.facebook.com/share/v/17hsbxccTc/?mibextid=wwXIfr', 'Golf', '', '', '2025-12-05 09:44:00', '2025-12-05 09:44:00'),
(304, 'I', 'macos pipe settings', 'macos', '', 'set -euo pipefail \r\n\r\nis a common “strict mode” line that makes your shell script fail fast and not silently ignore errors.?\r\nWhat each flag does\r\nset -e\r\nExit the script immediately if any simple command returns a non?zero status (an error), instead of continuing and possibly doing the wrong thing based on bad state.?\r\nset -u\r\n\r\nTreat use of unset variables as an error and exit, which helps catch typos and missing environment variables ($FOO when FOO was never set).?\r\n\r\nset -o pipefail\r\n\r\nMake a pipeline like cmd1 | cmd2 | cmd3 return a non?zero status if any command in the chain fails, not just the last one; this prevents errors in the earlier stages of a pipeline from being silently ignored.?\r\n\r\nTogether, set -euo pipefail makes scripts much safer: they stop on the first real error, they don’t quietly substitute empty strings for missing variables, and they properly detect failures inside pipelines instead of reporting success when something actually broke earlier in the chain.?\r\n\r\n\r\n', '', '', 'macos, tip', '', '', '2025-12-05 23:43:00', '2025-12-05 23:43:00'),
(305, 'I', 'Pinehurst 360 view', 'golf', '', 'Pinehurst 360 view of site', '', 'https://homeofgolf.com/360-tour/?utm_source=newsletter&utm_medium=email&utm_campaign=April2025', 'golf', '', '', '2025-12-06 15:39:00', '2025-12-06 15:39:00'),
(306, 'I', 'Golf swing ', 'Golf', '', 'Alignment stick to club\r\n1 goes down front leg\r\n2 back point to ground\r\n3 follow thru not hit body', '', 'https://www.facebook.com/share/r/1AUYnUjk5F/?mibextid=wwXIfr', 'Golf', '', '', '2025-12-07 06:58:00', '2025-12-07 06:58:00'),
(307, 'I', 'Lazy guy', 'Woodworking ', '', 'Puzzle table \r\nhttps://lazyguydiy.com/how-to-make-a-puzzle-tray-with-storage/', '', 'https://lazyguydiy.com/how-to-make-a-puzzle-tray-with-storage/', 'Woodworking ', '', '', '2025-12-07 13:21:00', '2025-12-07 13:21:00'),
(308, 'I', 'Bootstrap Theme Generator', 'bootstrap', 'colors', 'How to generate Bootstrap themes\r\nhttps://www.haketi.com/bootstrap-themer/\r\n\r\nhttps://bootstrap.build/app\r\n\r\nSimple\r\nhttps://huemint.com/bootstrap-basic/\r\nReal Orange\r\nAdd this to your custom.scss file to override the default bootstrap colors - add this before @import \"bootstrap\";\r\n\r\n$white: #ffffff;\r\n\r\n$theme-colors: (\r\n    \"light\":      #f8e7a9,\r\n    \"dark\":       #f67600,\r\n    \"primary\":    #45342f,\r\n    \"secondary\":  #5a5c66,\r\n    \"info\":       #f97360,\r\n    \"accent1\":    #47cbca,\r\n    \"accent2\":    #008876,\r\n    \"accent3\":    #00a366,\r\n    \"success\":    #59a900,\r\n    \"warning\":    #ffc165,\r\n    \"danger\":     #f40063,\r\n);\r\n\r\nhttps://bootstrapcolors.com/', 'Color Pallettes\r\nhttps://colorhunt.co/palette/\r\n\r\nhttps://piktochart.com/tips/orange-blue-color-paletteAdd this to your custom.scss file to override the default bootstrap colors - add this before @import \"bootstrap\";\r\n\r\n$white: #ffffff;\r\n\r\n$theme-colors: (\r\n    \"light\":      #ede8e8,\r\n    \"dark\":       #0b0400,\r\n    \"primary\":    #224d9d,\r\n    \"secondary\":  #396cb6,\r\n    \"info\":       #3d9dc7,\r\n    \"accent1\":    #603510,\r\n    \"accent2\":    #554d4b,\r\n    \"accent3\":    #aba7aa,\r\n    \"success\":    #1b9f5d,\r\n  ', 'https://www.haketi.com/bootstrap-themer/', 'bootstrap,theme', '', '', '2025-12-07 15:07:00', '2025-12-07 15:30:00'),
(309, 'I', 'Make command file part of macOS Dock', 'macOS', '', '?? How to make your tips.cmd (zsh script) Dock?ready\r\nOpen Automator ? create a new Application.\r\n\r\nAdd Run Shell Script.\r\n\r\nPaste the contents of your tips.cmd (zsh commands).\r\n\r\nSave as Tips.app.\r\n\r\nDrag Tips.app into the Dock.\r\n\r\nNow clicking the Dock icon runs your zsh script like an app.\r\n\r\n? So yes, the file needs to be packaged as a .app (via Automator or similar). A raw .cmd or .zsh file won’t execute from the Dock by itself.', 'For ~/lbin/tips.cmd', '', 'macOS', '', '', '2025-12-07 15:52:00', '2025-12-07 15:52:00'),
(310, 'I', 'Amazon Resale ', 'purchase', '', 'Amazon refurbished\r\nhttps://www.amazon.com/resale\r\namazon warehouse\r\n\r\nOn page seach for Used to find other at lower price', '', 'https://www.amazon.com/resale', 'purchase', '', '', '2025-12-08 15:06:00', '2025-12-08 15:06:00'),
(311, 'I', 'Eney - mac Paw ', 'macOS', '', 'AI assistant\r\n', '', 'https://macpaw.com/eney', 'macaws', '', '', '2025-12-08 20:12:00', '2025-12-08 20:12:00'),
(312, 'I', 'File Differ', 'macOS', '', 'vimdiff file1 file2\r\n\r\nGood file comparison tool', '', '', 'vim, macOS', '', '', '2025-12-08 22:06:00', '2025-12-08 22:06:00'),
(313, 'I', 'fd Fast file Find', 'macOS', '', 'fd from brew\r\n\r\nfd -H /Library - means ignore directory\r\n\r\n$HOME/fdignore\r\n/Library\r\n', '', '', 'macOS', '', '', '2025-12-09 00:31:00', '2025-12-09 00:31:00'),
(314, 'I', 'Pro Cutta - cutting turf', 'turf', '', 'Tool to ease the cutting of seams\r\n 16 ft $599  6ft $249', 'Cutter \r\nhttps://www.jcturf.com/artificial-grass/maintenance/repairs/cut/', 'https://procutta.com/pages/get-out-of-the-harsh-weather-faster', 'turf, golf', '', '', '2025-12-10 03:28:00', '2025-12-10 03:43:00'),
(315, 'I', 'Ecovacs', 'ecovacs', '', 'Model: T80 Omni 12/8/2025 Serial\r\nis there a mode to mop and not go on rugs?\r\nset to deep clean and 2x passes! will cover entire area\r\n\r\nMop & Vac (vac and mop only living area; no bedrooms, laundry, bathrooms, office)\r\nVac  Only (vac only living area; no bedrooms, laundry, bathrooms, office)\r\n', 'Mop all rooms and not go on rugs:\r\nFirstly, you can go into the map, then select the carpet. You can choose the carpet\'s shape(round or rectangular). Once you have completed all the steps, select the No Entry option. Thus, your Deebot will avoid mopping or sweeping those areas where you placed carpets.\r\nThen to just vacuum the rugs?\r\nYou can go back to carpet settings, select the carpets, then select vacuum only.', '', 'ecovacs', '', '', '2025-12-11 20:15:00', '2025-12-11 20:48:00'),
(316, 'I', 'AI - apps Setapp', 'setapp', '', 'List of AI Apps\r\nBoltAI — Beautiful & powerful AI chat for professionals.\r\nElephas — Personal AI writing assistant for Mac.\r\nJoyCast — Improve meeting audio quality.\r\nKeep It Shot — Rename screenshots with AI.\r\nMurmurType — Transcribe your speech.\r\nPDF Pals — Chat with your PDFs.\r\nPlus — Work with text using AI.\r\nReady to Send — Generate draft email replies.\r\nSoulver — Convert and calculate in notes.\r\nSpellar AI – Improve meeting productivity.\r\nSubstage — Control Finder with natural language.\r\nTypingMind — Use a new UI to chat with AI.\r\nWhisperTranscribe — Turn voice into text content.\r\n', 'boltai - works good', '', 'setapp, macos', '', '', '2025-12-12 02:48:00', '2025-12-12 02:48:00'),
(317, 'I', 'USB Validator', 'usb', '', 'How test old usb drive to see if worth saving\r\ncrystalmark test 3d', '', 'https://crystalmark.info/en/download/#CrystalDiskInfo', 'usb', '', '', '2025-12-12 21:59:00', '2025-12-12 21:59:00'),
(318, 'I', 'Visual Studion Code - vsc', 'vsc', 'todo', 'standard Documents - list documents here\r\n', '# Documents\r\n- ENGINEERING_STANDARDS.md,  (put system wide requirements: spinner, scrollbars etc)\r\n- PROJECT_GUIDELINES.md, or \r\n- CONTRIBUTING.md at the root.\r\nCopy/adjust that file into new repos so “no dead controls; disable/hide if not implemented” is part of your default engineering standards.', '', 'vsc,code', '', '', '2025-12-12 22:45:00', '2025-12-14 11:37:00');
INSERT INTO `tips` (`id`, `stat`, `title`, `cat`, `subCat`, `descr`, `comments`, `links`, `tags`, `moreInfo`, `attachments`, `tipCreate`, `tipMod`) VALUES
(319, 'I', 'zsh - commands history', 'macos', 'zsh', 'In zsh, you can easily rerun previous commands from your command history using the following methods:\r\n\r\n1. Using the Arrow Keys\r\nUp Arrow Key: Press the ? (up arrow) key to scroll back through your command history. Each press will take you to the previous command.\r\nDown Arrow Key: Press the ? (down arrow) key to scroll forward through the command history.\r\n2. Using history Command\r\nYou can type history to display a list of previously executed commands. Each command will have a corresponding number.\r\nTo rerun a command, type ! followed by the command number. For example, if the command is listed as 42 in your history, you would type:\r\n!42\r\n3. Using fc\r\nYou can use the fc command to edit and rerun previous commands. By default, fc opens the last command in your default text editor (usually vi or nano):\r\nfc\r\nYou can also specify a range, like this:\r\nfc -l -10\r\nThis would list the last 10 commands. You can then edit the desired command and save it to run it.\r\n4. Using Search\r\nYou can search through your command history interactively by pressing Ctrl + r. This will allow you to type part of a previous command, and it will show you the most recent match.\r\nKeep pressing Ctrl + r to cycle through earlier matches. When you find the command you want, press Enter to run it.\r\n5. Repeating the Last Command\r\nTo quickly repeat the last command you executed, simply type:\r\n!!\r\nThis will execute the most recent command in the history.\r\nSummary\r\nThese methods allow you to efficiently access and rerun previous commands in zsh, making it easier to work with your command line history.', '', '', 'zsh,macos', '', '', '2025-12-14 11:43:00', '2025-12-14 11:43:00'),
(320, 'I', 'testRick', '', '', 'a', '', '', 'test', '', '', '2025-12-14 14:39:00', '2025-12-14 14:45:00'),
(322, 'I', 'Rick1', 'rick1', 'new SubCat', 'rick1', '', '', 'rick1', '', '', '2025-12-14 14:46:00', '2025-12-14 14:46:00'),
(323, 'I', 'New google maps', 'Maps', 'Todo', 'New ai features \r\nFind gf restaurant on my route', '', 'https://www.cnet.com/tech/services-and-software/google-maps-is-getting-more-hands-free-for-when-youre-driving/', 'Maps', '', '', '2025-12-15 16:37:00', '2025-12-15 16:37:00'),
(324, 'H', 'Putting Instructions', 'golf', 'putting', 'Good tools for putting drills', '', 'https://oldduffergolf.com/setting-up-drills/', 'golf, putting', '', '', '2025-12-17 14:35:00', '2025-12-17 14:35:00'),
(325, 'T', 'Golf Stemp Meter', 'Golf', '', '== How to build a stemp meter ==\r\n1. Need Ramp 32\" Mark at 30\" for ball to start\r\n2. Cut the bottom at 20 20-degree angle\r\n3. Cut a support at 20 degrees - place at 10.5\" away\r\n4. Use the IPhone Level App to angle 20 degrees\r\n\r\n== Test Roll ==\r\n1. Roll 3 balls on a level spot\r\n2. Get the average distance that is between 9-11 is average\r\n3. Roll 3 balls in opposite direction\r\n - average two runs that is the stemp rating', '\r\nCategory	        Stimpmeter Speed (feet)	                     Notes==\r\nSlow Greens	          7 – 8 ft	          Common at municipal courses or casual play; easier for beginners.\r\nMedium Greens	 9 – 10 ft	                                       Standard for most public and private courses; balanced difficulty.\r\nFast Greens	         11 – 12 ft	                                       Often found at championship-level courses; requires precise putting.\r\nVery Fast Greens	13+ ft	                                  ', '', 'stemp, golf', '', '', '2025-12-17 14:40:00', '2025-12-17 14:57:00'),
(326, 'I', 'How to say our name phonetically', 'misc', '', 'We Have a delivery appointment for Rick Bhutari\r\n\r\nHi I\'m  Rick Bhutaire\r\n\r\nHi this Rick Bhutaire; Can I speak with Sue Fenger', '', '', 'test', '', '', '2025-12-17 17:15:00', '2025-12-17 17:19:00'),
(327, 'I', 'How to Create Icon for pages', '', '', 'Fav Icon: https://favicon.io/\r\nCreate Text Icon: https://favicon.io/favicon-generator/', '==Code==\r\n<link rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"tips.ico\">', 'https://favicon.io/', 'icon', '', '', '2025-12-18 03:48:00', '2025-12-18 03:52:00'),
(328, 'I', 'Ideas - Creative Ideas - Jigs - Tools', 'jigs', '', '- Creative ideas tools \r\n- What to make', '', 'https://www.msn.com/en-us/channel/source/Ideas%20corner/sr-vid-4rcatrke9745ayrytanyer4cia854emajn7k26e0923cv5yk88ya?ocid=msedgntp&pc=U531&cvid=6944fa99296146f6830592f63671380e&ei=504', 'ideas, tips, jigs', '', '', '2025-12-19 07:41:00', '2025-12-19 07:41:00'),
(329, 'T', 'Intellihometech.com. - home', 'websites', '', '== Information ==\r\n/home/intel145/public_html - home directory\r\n\r\n- move to /home/intel145/websites/intellihometech.com\r\n- /home/intel145/public_html - wedding.php  is aaron wedding  thru software off cpanel\r\n- wedding.php - not working unless put back to index.html file', 'Comment ', '', 'websites, inmotion', '', '', '2025-12-19 08:26:00', '2025-12-19 09:01:00'),
(330, 'T', 'Backup Failed', '', '', '-file failed to backup \r\nUsers/rbutare/Library/Group Containers/group.com.apple.moments/Library/Attachments/D94FDF7D-2624-483F-87C0-3FC2B37DF9C3/4797BCE9-C702-4EBF-864F-A2A77DC4D792” \r\n', '', '', 'backup', '', '', '2025-12-19 21:01:00', '2025-12-19 21:01:00'),
(331, 'T', 'Github files', 'github', '', '== GitHub ==\r\n- .github - folder\r\n-- contains copilot-instructions.md\r\n\r\n== Markdown files Linter ==\r\nmarkdownlinter [fileName]\r\n\r\n== If not working ==\r\nIf it ignores a rule, adjust the wording in copilot-instructions.md to be more direct\r\n (e.g., “Always…” / “Never…” instead of “Prefer…”) and retest.\r\n == Organize by sections ==\r\nYou can organize it with sections (## Shell, ## JSON schema, etc.), but there are no required keys like \r\ntitle: or instructions: and no front?matter needed\r\n## Shell\r\n## JSON', '== List of files: ==\r\n- /README.md\r\n - ./TEST_PLAN.md\r\n - ./common/docs/css-docs.md\r\n - ./CONTRIBUTING.md\r\n - ./.github/copilot-instructions.md\r\n - ./INSTALLATION_GUIDE.md\r\n - ./QUICK_REFERENCE.md\r\n - ./STYLEGUIDE.md\r\n - ./QUICK_START.md\r\n - ./SECURITY.md\r\n - ./DIRECTORY_STRUCTURE.md\r\n', '', 'github, setup', '', '', '2025-12-22 15:35:00', '2025-12-22 17:03:00'),
(332, 'I', 'Replit - Ai code generator', 'code', '', 'Replit - ios / macOs code generator\r\n- convert to php/html/js\r\n- Explorer - folders on right side look in: client/public/index.php \r\n', '', '', 'ai, code', '', '', '2025-12-27 04:45:00', '2025-12-27 04:45:00'),
(333, 'i', 'Mysql Startup - Tips', 'mysql', '', 'Show DataBases;\r\nCREATE DATABASE IF NOT EXISTS intel145_apps;\r\n- show Databases;\r\n- use  intel145_apps;\r\n- show TABLES;\r\n- Describe Tables;\r\n\r\n', '== Commands to test Database ==\r\nrun dbTest.php\r\ndbQuery.php', '', 'mysql', '', '', '2025-12-28 03:52:00', '2025-12-28 03:52:00'),
(335, 'i', 'VSC - md files for doumentation', '', '', '| Markdown File                 | Purpose                                   | Where It Appears            |\r\n|------------------------------|--------------------------------------------|-----------------------------|\r\n| README.md                    | Overview, usage, screenshots               | Extensions, VS Code repo    |\r\n| CHANGELOG.md                 | Version history                            | Extensions, VS Code repo    |\r\n| vsc-extension-quickstart.md  | Developer instructions for new extensions  | Extension templates          |\r\n| docs/.md*                    | Official VS Code documentation             | VS Code docs site           |\r\n| CONTRIBUTING.md              | Contribution guidelines                    | Extensions, VS Code repo    |\r\n| LICENSE.md                   | Licensing information                      | Extensions, VS Code repo    |\r\n| SECURITY.md                  | Security reporting                         | Some extensions             |\r\n| Markdown tooltips / hovers   | In-editor                                  | In-editor                   |\r\n', '', 'https://copilot.microsoft.com/chats/2HwKRvnMaDqQDnuvx2aHb', 'vsc, docs', '', '', '2025-12-30 18:57:00', '2025-12-30 18:57:00'),
(336, 'i', 'VSC - Git Hub Integration', 'vsc', 'setup', 'walks you thru how to setup', '', 'https://code.visualstudio.com/docs/copilot/getting-started', 'vsc', '', '', '2025-12-30 19:06:00', '2025-12-30 19:06:00'),
(337, 'i', 'VSC - Choosing the right AI', 'vsc', '', '== Model type	Models ==\r\n== Fast coding	==\r\n- GPT-4o\r\n-iClaude Sonnet 3.5\r\n- Claude Sonnet 3.7\r\n- Gemini 2.0 Flash\r\n== Reasoning/planning	==\r\n- Claude Sonnet 3.7 Thinking\r\n- o1\r\n- o3-mini', '== @workspace agent ==\r\n-  @workspace agent  to have better focus on entire workspace\r\n- i.e. @workspace agent  complete full documentation', 'https://code.visualstudio.com/docs/copilot/copilot-tips-and-tricks#_choose-your-ai-model', 'vsc, ai', '', '', '2025-12-30 19:07:00', '2025-12-30 19:18:00'),
(338, 'T', 'Capture Screen', 'macos', '', '== Screen Capture options ==\r\n\r\n- Cmd->Shft-3 - Full screen \r\n- Cmd->Shift->4 Partial Screen Draw \r\n- Cmd-Shift-5 - Options for full screen\r\n\r\n', '', '', 'macos,capture', '', '', '2025-12-31 15:53:00', '2025-12-31 16:02:00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tips`
--
ALTER TABLE `tips`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tips`
--
ALTER TABLE `tips`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=339;
COMMIT;

