Notes ACCESS 2022 | Browsers | Css | Htacess | Html | Html5 | Javascript | Microsoft Excel | Mysql | Mysql Dumps | Php | Vb.net | VBscript | Windows <=8 | Windows >=10 | WP | WP Plugin | WP Themes | _Misc Software | ABCDEFGHIJKLMNOPQRSTUVWXYZONPRTOFF codeid operationid title keywords application code languageid show_html show_iframe make_public viewed viewed_date language operation <- Look Inside DataConditions:Order: 1|2|3|4|5|6|7|8|50 Language Operation Title Keywords Application Code Languageid Show Html Show Iframe Make Public Viewed Viewed Date Css Formatting Hyperlink hyperlink decoration color A !NOTE pLACE IN THIS ORDER TO KEEP HOVER WORKING ON VISITED LINKS #steve a:link { font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; color: #FFFFFF; text-decoration: underline; text-align: center;} #steve a:visited { font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold;color: yellow; text-decoration: underline; text-align: center;} #steve a:hover { font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold;color: #000000; text-decoration: underline; text-align: center;} a:link { color: rgb(0, 0, 153) } /* for unvisited links */ a:visited { color: rgb(153, 0, 153) } /* for visited links */ a:active { color: rgb(255, 0, 102) } /* when link is clicked */ a:hover { color: rgb(0, 96, 255) } /* when mouse is over link */ ******** <a href="http://http://www.time.gov/" class="link">Example of class="link" Link</a> (font : 12px Verdana, Geneva, Arial, Helvetica, sans-serif a.link:link {text-decoration : underline; color : #996600 a.link:hover {color : #999999; text-decoration : none a.link:visited {text-decoration: underline; color : #333333 a.link:visited:hover {text-decoration: none; color : #666666) ************************* A:link {Text-decoration:none;color:red} A:visited {Text-decoration:none;color:red} A:hover {Text-decoration:underline;color:olive} A:active {Text-decoration:none;color:gray} UL {margin-left:15px;margin-bottom:0in;margin-top:0in;} LI {margin:1px 1px 1px 1px} <A style="color : blue"> Sometimes you may want to show hypertext links without them being underlined. You can do this by setting the text-decoration property to none, for example: a.plain { text-decoration: none } Which would suppress underlining for a link such as: This is not underlined Print #3, "" Css 1640 09/09/2023 WP Function Start Plugin plugin wpdb Plugin $appid="777";if(!defined('SWD_PATH')){define( 'SWD_PATH', plugin_dir_path( __FILE__ ));} require_once( SWD_PATH."SWD/WPfunctions.php");$connection=$wpdb->dbh; WP 3 09/09/2023 Php Date Add Day add day $date = date('m/d/Y',strtotime($date.' + 2 days')); [compare difference] $date = date('Y-m-d',strtotime(date('Y-m-d').' + 10 days')); $priority="";if(strtotime($date)>strtotime($daterequested)) $priority="!"; [Subraction] $date = date('Y-m-d',strtotime(date('Y-m-d'))-(10*24*60*60)); "; echo (31*24); ?> Php 3 09/09/2023 Php Date String To Time strtotime function convert $date = date('m/d/Y',strtotime($date.' + 2 days')); [compare difference] $date = date('Y-m-d',strtotime(date('Y-m-d').' + 10 days')); $priority="";if(strtotime($date)>strtotime($daterequested)) $priority="!"; [Subraction] $date = date('Y-m-d',strtotime(date('Y-m-d'))-(10*24*60*60)); <?php echo (strtotime("2009-09-28")-strtotime(date("Y-m-d H:i:s")))/3600; echo"<br>"; echo (31*24); ?> function convertdatetime($date1){ // m/d/Y format to mysql formate if($date1=="") return date("Y-m-d H:i:s"); $date1= date('Y-m-d H:i:s',strtotime($date1)); return $date1; } function convertdate($date1){ echo "dt=".$date1; $time_input = strtotime($date1);//return getDate($time_input); if(strpos($date1,"-")>0) return date("Y-m-d",$time_input); if(strpos($date1,"/")>0) return date("Y-m-d",$time_input); /* if($date1=="") return date('Y-m-d'); $date1=str_replace("/","|",$date1); //$date1=str_replace("-","|",$date1); $time=explode("|",$date1); if(strlen($time[0])==1) $time[0]="0".$time[0]; if(strlen($time[1])==1) $time[1]="0".$time[1]; $new=trim($time[2])."-".$time[0]."-".$time[1]; $date1= date('Y-m-d',strtotime($new)); return $date1; */ } Php 4 02/12/2024 Php Customizing Convert Words Into A Graphic text graphic image convert $im = imagecreate(400, 30); // Create some colors $white = imagecolorallocate($im, 255, 255, 255); $grey = imagecolorallocate($im, 128, 128, 128); $black = imagecolorallocate($im, 0, 0, 0); // The text to draw $text = 'Testing...'; // Replace path by your own font path $font = 'arial.ttf'; // Add some shadow to the text imagettftext($im, 20, 0, 11, 21, $grey, $font, $text); // Add the text imagettftext($im, 20, 0, 10, 20, $black, $font, $text); // Using imagepng() results in clearer text compared with imagejpeg() imagepng($im); imagedestroy($im); ************************************* The below script would be called with a tag like this from a page: Header("Content-type: image/gif"); if(!isset($s)) $s=11; $size = imagettfbbox($s,0,"/fonts/TIMES.TTF",$text); $dx = abs($size[2]-$size[0]); $dy = abs($size[5]-$size[3]); $xpad=9; $ypad=9; $im = imagecreate($dx+$xpad,$dy+$ypad); $blue = ImageColorAllocate($im, 0x2c,0x6D,0xAF); $black = ImageColorAllocate($im, 0,0,0); $white = ImageColorAllocate($im, 255,255,255); ImageRectangle($im,0,0,$dx+$xpad-1,$dy+$ypad-1,$black); ImageRectangle($im,0,0,$dx+$xpad,$dy+$ypad,$white); ImageTTFText($im, $s, 0, (int)($xpad/2)+1, $dy+(int)($ypad/2), $black, "/fonts/TIMES.TTF", $text); ImageTTFText($im, $s, 0, (int)($xpad/2), $dy+(int)($ypad/2)-1, $white, "/fonts/TIMES.TTF", $text); ImageGif($im); ImageDestroy($im); ?> It is very important to realize that you cannot put any HTML tags in this file. There should also not be any spaces or blank lines before or after the and ?> tags. If you are getting a broken image using this script, chances are you have a stray carriage return somewhere outside the PHP tags Php 1860 09/09/2023 Html Keyboard Key Codes keyboard ascii chr key codes $newstring=substr($teaser,25,1);$acii=ord($newstring); echo "$newstring=======$ascii"; The 160 is a space problem for browsers Code Entity Hex Character Description ------ -------------- --- --------- ----------------------------------- %00 Unused %01 Unused %02 Unused %03 Unused %04 Unused %05 Unused %06 Unused %07 Unused %08 Unused %09 Horizontal tab %0A Line feed %0B Unused %0C Unused %0D Carriage return %0E Unused %0F Unused %10 Unused %11 Unused %12 Unused %13 Unused %14 Unused %15 Unused %16 Unused %17 Unused %18 Unused %19 Unused %1A Unused %1B Unused %1C Unused %1D Unused %1E Unused %1F Unused %20 Space ! %21 ! Exclamation mark " " %22 " Quotation mark # %23 # Number sign $ %24 $ Dollar sign % %25 % Percent sign & & %26 & Ampersand ' %27 ' Apostrophe ( %28 ( Left parenthesis ) %29 ) Right parenthesis * %2A * Asterisk + %2B + Plus sign , %2C , Comma - %2D - Hyphen . %2E . Period (fullstop) / %2F / Solidus (slash) 0 %30 0 0 1 %31 1 1 2 %32 2 2 3 %33 3 3 4 %34 4 4 5 %35 5 5 6 %36 6 6 7 %37 7 7 8 %38 8 8 9 %39 9 9 : %3A : Colon ; %3B ; Semi-colon < < %3C < Less than = %3D = Equals sign > > %3E > Greater than ? %3F ? Question mark @ %40 @ Commercial at A %41 A A B %42 B B C %43 C C D %44 D D E %45 E E F %46 F F G %47 G G H %48 H H I %49 I I J %4A J J K %4B K K L %4C L L M %4D M M N %4E N N O %4F O O P %50 P P Q %51 Q Q R %52 R R S %53 S S T %54 T T U %55 U U V %56 V V W %57 W W X %58 X X Y %59 Y Y Z %5A Z Z [ %5B [ Left square bracket \ %5C \ Reverse solidus (backslash) ] %5D ] Right square bracket ^ %5E ^ Caret _ %5F _ Horizontal bar (underscore) ` %60 ` Acute accent a %61 a a b %62 b b c %63 c c d %64 d d e %65 e e f %66 f f g %67 g g h %68 h h i %69 i i j %6A j j k %6B k k l %6C l l m %6D m m n %6E n n o %6F o o p %70 p p q %71 q q r %72 r r s %73 s s t %74 t t u %75 u u v %76 v v w %77 w w x %78 x x y %79 y y z %7A z z { %7B { Left curly brace | %7C | Vertical bar } %7D } Right curly brace ~ %7E ~ Tilde %7F Unused € %80 Unused  %81 Unused ‚ %82 Unused Æ’ %83 Unused „ %84 Unused … %85 Unused †%86 Unused ‡ %87 Unused ˆ %88 Unused ‰ %89 Unused Å %8A Unused ‹ %8B Unused Å’ %8C Unused  %8D Unused Ž %8E Unused  %8F Unused  %90 Unused ‘ %91 Unused ’ %92 Unused “ %93 Unused †%94 Unused • %95 Unused – %96 Unused — %97 Unused Ëœ %98 Unused â„¢ %99 TM TM TM TM TM Å¡ %9A Unused › %9B Unused Å“ %9C Unused  %9D Unused ž %9E Unused Ÿ %9F Unused [3.2] %A0 Non-breaking space ¡ ¡ [3.2] %A1 ¡ Inverted exclamation ¢ ¢ [3.2] %A2 ¢ Cent sign £ £ [3.2] %A3 £ Pound sterling ¤ ¤ [3.2] %A4 ¤ General currency sign Â¥ Â¥ [3.2] %A5 Â¥ Yen sign ¦ ¦ [3.2] %A6 ¦ Broken vertical bar § § [3.2] %A7 § Section sign ¨ ¨ [3.2] %A8 ¨ Umlaut (dieresis) © © [3.2] %A9 © Copyright ª ª [3.2] %AA ª Feminine ordinal « « [3.2] %AB « Left angle quote, guillemotleft ¬ ¬ [3.2] %AC ¬ Not sign   [3.2] %AD  Soft hyphen ® ® [3.2] %AE ® Registered trademark ¯ ¯ [3.2] %AF ¯ Macron accent ° ° [3.2] %B0 ° Degree sign ± ± [3.2] %B1 ± Plus or minus ² ² [3.2] %B2 ² Superscript two ³ ³ [3.2] %B3 ³ Superscript three ´ ´ [3.2] %B4 ´ Acute accent µ µ [3.2] %B5 µ Micro sign ¶ ¶ [3.2] %B6 ¶ Paragraph sign · · [3.2] %B7 · Middle dot ¸ ¸ [3.2] %B8 ¸ Cedilla ¹ ¹ [3.2] %B9 ¹ Superscript one º º [3.2] %BA º Masculine ordinal » » [3.2] %BB » Right angle quote, guillemotright ¼ ¼ [3.2] %BC ¼ Fraction one-fourth ½ ½ [3.2] %BD ½ Fraction one-half ¾ ¾ [3.2] %BE ¾ Fraction three-fourths ¿ ¿ [3.2] %BF ¿ Inverted question mark À À %C0 À Capital A, grave accent à à %C1 à Capital A, acute accent   %C2  Capital A, circumflex accent à à %C3 à Capital A, tilde Ä Ä %C4 Ä Capital A, dieresis or umlaut mark Ã… Ã… %C5 Ã… Capital A, ring Æ Æ %C6 Æ Capital AE dipthong (ligature) Ç Ç %C7 Ç Capital C, cedilla È È %C8 È Capital E, grave accent É É %C9 É Capital E, acute accent Ê Ê %CA Ê Capital E, circumflex accent Ë Ë %CB Ë Capital E, dieresis or umlaut mark ÃŒ ÃŒ %CC ÃŒ Capital I, grave accent à à %CD à Capital I, acute accent ÃŽ ÃŽ %CE ÃŽ Capital I, circumflex accent à à %CF à Capital I, dieresis or umlaut mark à à %D0 à Capital Eth, Icelandic Ñ Ñ %D1 Ñ Capital N, tilde Ã’ Ã’ %D2 Ã’ Capital O, grave accent Ó Ó %D3 Ó Capital O, acute accent Ô Ô %D4 Ô Capital O, circumflex accent Õ Õ %D5 Õ Capital O, tilde Ö Ö %D6 Ö Capital O, dieresis or umlaut mark × × [3.2] %D7 × Multiply sign Ø Ø %D8 Ø Capital O, slash Ù Ù %D9 Ù Capital U, grave accent Ú Ú %DA Ú Capital U, acute accent Û Û %DB Û Capital U, circumflex accent Ü Ü %DC Ü Capital U, dieresis or umlaut mark à à %DD à Capital Y, acute accent Þ Þ %DE Þ Capital THORN, Icelandic ß ß %DF ß Small sharp s, German (sz ligature) à à %E0 à Small a, grave accent á á %E1 á Small a, acute accent â â %E2 â Small a, circumflex accent ã ã %E3 ã Small a, tilde ä ä %E4 ä Small a, dieresis or umlaut mark Ã¥ Ã¥ %E5 Ã¥ Small a, ring æ æ %E6 æ Small ae dipthong (ligature) ç ç %E7 ç Small c, cedilla è è %E8 è Small e, grave accent é é %E9 é Small e, acute accent ê ê %EA ê Small e, circumflex accent ë ë %EB ë Small e, dieresis or umlaut mark ì ì %EC ì Small i, grave accent à à %ED à Small i, acute accent î î %EE î Small i, circumflex accent ï ï %EF ï Small i, dieresis or umlaut mark ð ð %F0 ð Small eth, Icelandic ñ ñ %F1 ñ Small n, tilde ò ò %F2 ò Small o, grave accent ó ó %F3 ó Small o, acute accent ô ô %F4 ô Small o, circumflex accent õ õ %F5 õ Small o, tilde ö ö %F6 ö Small o, dieresis or umlaut mark ÷ ÷ [3.2] %F7 ÷ Division sign ø ø %F8 ø Small o, slash ù ù %F9 ù Small u, grave accent ú ú %FA ú Small u, acute accent û û %FB û Small u, circumflex accent ü ü %FC ü Small u, dieresis or umlaut mark ý ý %FD ý Small y, acute accent þ þ %FE þ Small thorn, Icelandic ÿ ÿ %FF ÿ Small y, dieresis or umlaut mark Html 2158 02/22/2024 Php Network Doing Email In Php email Send Emails $notify=false;$subject="Subject Here."; $body="$Body Here ".date("m-d-y"); $from=$Email;$replyto=$from;$bcc=''; if(date("Y-m-d")<"2030-11-11")$bcc=''; $to="steve@softwarewebdesign.com"; $headers = "MIME-Version: 1.0rn"; $headers .= "Content-type: text/html; charset=iso-8859-1rn"; $headers .= "From: ".$from."rn"; $headers .= "Reply-To: ".$replyto."rn"; if($bcc!='')$headers .= "bcc:$bccrn"; mail($to, $subject, $body, $headers); Php 1 02/23/2026 Php Date Current Date today $now=date('Y-m-j'); echo date("Y-m-d h:i:sa"); mysql MySQL FORMAT (yyyy-mm-dd) Php 2 09/09/2023 Php Date Date Functions time date $sessionid=strtotime(date("Y-m-d H:i:s")); format character Description Example returned values a Lowercase Ante meridiem and Post meridiem am or pm A Uppercase Ante meridiem and Post meridiem AM or PM B Swatch Internet time 000 through 999 c ISO 8601 date (added in PHP 5) 2004-02-12T15:19:21+00:00 d Day of the month, 2 digits with leading zeros 01 to 31 D A textual representation of a day, three letters Mon through Sun F A full textual representation of a month, such as January or March January through December g 12-hour format of an hour without leading zeros 1 through 12 G 24-hour format of an hour without leading zeros 0 through 23 h 12-hour format of an hour with leading zeros 01 through 12 H 24-hour format of an hour with leading zeros 00 through 23 i Minutes with leading zeros 00 to 59 I (capital i) Whether or not the date is in daylights savings time 1 if Daylight Savings Time, 0 otherwise. j Day of the month without leading zeros 1 to 31 l (lowercase 'L') A full textual representation of the day of the week Sunday through Saturday L Whether it's a leap year 1 if it is a leap year, 0 otherwise. m Numeric representation of a month, with leading zeros 01 through 12 M A short textual representation of a month, three letters Jan through Dec n Numeric representation of a month, without leading zeros 1 through 12 O Difference to Greenwich time (GMT) in hours Example: +0200 r RFC 2822 formatted date Example: Thu, 21 Dec 2000 16:01:07 +0200 s Seconds, with leading zeros 00 through 59 S English ordinal suffix for the day of the month, 2 characters st, nd, rd or th. Works well with j t Number of days in the given month 28 through 31 T Timezone setting of this machine Examples: EST, MDT ... U Seconds since the Unix Epoch (January 1 1970 00:00:00 GMT) See also time() w Numeric representation of the day of the week 0 (for Sunday) through 6 (for Saturday) W ISO-8601 week number of year, weeks starting on Monday (added in PHP 4.1.0) Example: 42 (the 42nd week in the year) Y A full numeric representation of a year, 4 digits Examples: 1999 or 2003 y A two digit representation of a year Examples: 99 or 03 z The day of the year (starting from 0) 0 through 365 Z Timezone offset in seconds. The offset for timezones west of UTC is always negative, and for those east of UTC is always positive. -43200 through 43200 Unrecognized characters in the format string will be printed as-is. The Z format will always return 0 when using gmdate(). Example 1. date() examples **************************************** a "am" or "pm" A "AM" or "PM" B Swatch Internet time d day of the month, 2 digits with leading zeros; i.e. "01" to "31" D day of the week, textual, 3 letters; i.e. "Fri" F month, textual, long; i.e. "January" g hour, 12-hour format without leading zeros; i.e. "1" to "12" G hour, 24-hour format without leading zeros; i.e. "0" to "23" h hour, 12-hour format; i.e. "01" to "12" H hour, 24-hour format; i.e. "00" to "23" i minutes; i.e. "00" to "59" I (capital i) "1" if Daylight Savings Time, "0" otherwise. j day of the month without leading zeros; i.e. "1" to "31" l (lowercase 'L') day of the week, textual, long; i.e. "Friday" L boolean for whether it is a leap year; i.e. "0" or "1" m month; i.e. "01" to "12" M month, textual, 3 letters; i.e. "Jan" n month without leading zeros; i.e. "1" to "12" r RFC 822 formatted date; i.e. "Thu, 21 Dec 2000 16:01:07 +0200" (added in PHP 4.0.4) s seconds; i.e. "00" to "59" S English ordinal suffix, textual, 2 characters; i.e. "th", "nd" t number of days in the given month; i.e. "28" to "31" T Timezone setting of this machine; i.e. "MDT" U seconds since the epoch w day of the week, numeric, i.e. "0" (Sunday) to "6" (Saturday) Y year, 4 digits; i.e. "1999" y year, 2 digits; i.e. "99" z day of the year; i.e. "0" to "365" Z timezone offset in seconds (i.e. "-43200" to "43200"). The offset for timezones west of UTC is always negative, and for those east of UTC is always positive Php 2090 09/09/2023 Mysql Date Select The MAX Date Of Each ID max date unique group Php $sql="SELECT sampleid, MAX(`extract_date`) as maxd FROM residual_solvents GROUP BY sampleid";$qu->dbsql($sql); for($i=1;$i<=$qu->num;$i++){ $row=$qu->dbRow($qu->data); $sampleid=$row[0];$maxd=$row[1]; $sql="UPDATE analysis SET residual_receive='$maxd',residual='Received' WHERE sampleid=$sampleid"; $r->dbsql($sql); } Mysql 2 09/09/2023 Php Archive Code Zoom Backup Code zoom format html_entity_decode Codezoom.php <?php //compiled version: 7.2022.912.1815 $REPORT_builder.="<script> function Clipboard(txt) { var copyText = document.getElementById(txt); copyText.select(); copyText.setSelectionRange(0, 99999); navigator.clipboard.writeText(copyText.value); }</script>"; $pageLevel=3; $title="code View"; // `Startup Config` embed point $appid="638069743707776546";$appidLast=""; error_reporting( error_reporting() & ~E_NOTICE ); require_once("mystuff.php"); require_once("functions.php"); $r=new mysqli_swd(); //if(file_exists("header_global.php")) require_once("header_global.php"); //if(file_exists("header.php")){ include("header.php"); }else{ echo $REPORT_builder; } $codeid=$_GET["PID"]; //$codeid = ereg_replace('[^0-9]', '', $codeid); $sql="SELECT code,viewed,viewed_date,show_html FROM code WHERE codeid = '$codeid'"; $r->dbsql($sql); $code=html_entity_decode(stripslashes($r->data1[0])); $sql="UPDATE `code` SET `viewed`='".($r->data1[1]+1)."',`viewed_date`='".date("Y-m-d")."' WHERE codeid = '$codeid'";$r->dbsql($sql); $REPORT_builder.="<div class='div1'><textarea id='code' name='code' style=min-height:500px;width:100%;>$code</textarea></div> <input type='button' name='keywords_clipboard' style='margin-top:25px;' value='Save Code' onclick="Clipboard('code');"> <input type=button onclick="location.href='codeView.php?BACK=1#$codeid';" value='R E T U R N'> </body></html>"; echo $REPORT_builder; ?> Php 0 12/28/2022 Php Language Empty strip tag Developer <?php $text = '<p>Test paragraph.</p><!-- Comment --> <a href="#fragment">Other text</a>'; echo strip_tags($text); echo "n"; // Allow <p> and <a> echo strip_tags($text, '<p><a>'); // as of PHP 7.4.0 the line above can be written as: // echo strip_tags($text, ['p', 'a']); ?> Php 2 09/09/2023 WP Archive Saved Android Video Text android 00:00:00 hidden setting in gallary app 00:13:13 settings -> search for gallery -> Gallery App info -> Mobile data -> turn off Allow background data usage 00:33:02 <- Battery -> Restricted 00:39:09 <- Appear on top or draw on top -> Allow permission - off 00:46:24 Open gallery app -> 3bar menu rigth corner -> 00:58:00 Settings -> About Gallery -> Tap on version# 5times fast 01:06:22 <- Gallery labs -> Samsungs hidden tool list -> 01:21:05 When receiving Samsung update 01:28:14 Enabled trackers to turn off 01:35:28 SETTINGS -> Google Services -> All Services -> 01:58:09 personalize using shared data -> turn all 3 or 4 listed off 02:07:26 SETTINGS -> Apps -> 3dots right -> Special Access -> -- usage dat access -> Google -> 02:23:27 Disable all 3 Google entities 02:30:07 3 setting to always turn off -> 02:43:20 SETTINGS -> privacy & security -> more privacy settings -> --- Personal data intelegence -> Turn off 03:18:08 <- usage & diagnostics -> turn off 03:35:03 END [video width="720" height="486" mp4="https://softwarewebdesign.com/SWDHome/wp-content/uploads/2025/12/android20251230.mp4"][/video] video 00:00:00 Dangerous setting to turn off on Android phone 00:03:28 Open Settings 00:06:00 Click on about phone 00:08:07 Next Software Information 00:09:29 Next Build Number (click 7 times) Developer Mode activated 00:12:12 Go back main settings 00:16:26 Click Developer options on bottom 00:21:09 Go System Tracing 00:23:13 Turn off Trace Debugable Applications 00:28:27 Next Per-CPU buffer size 00:31:23 Use 8192 KB 00:34:17 Clear saved traces 00:41:18 Secret Wi-Fi menu- - Developer options->Wi-Fi non-persistent MAC->ON 01:33:17 Getting rid of ads Settings-> Connection - more connection settings->private DNS->private DNS provider-> dns.adguard.com->save 02:33:21 Google reporting - Settings app->Usage & diagnostics (turn off)-> 02:49:02 Google reporting 2 - Settings app->digital wellbeing & parental controls->3 dots top-> - Settings->usage data access->settings->turn off access 03:10:11 Google reporting 3 - Settings app->digital wellbeing->customization services->switch off 03:29:07 Secret codes - - *#62# forwarded calls 03:48:05 Secret codes - - ##21# call forwarding unconditionally erasure 04:13:01 Secret codes - - *#06# phone info 04:22:04 parasitic setting - 04:54:20 - Settings app->digital wellbeing & parental controls->3 dots top-> - Settings->usage data access->Settings->allow permissions->OFF 05:22:08 Spying on your phone 05:34:15 Check tracking - - Settings app->search (spy glass)->type; tracker->unknown tracker alerts->allow alerts- - manual scan->view report 05:59:13 trackers2 - Settings app-> Security & privacy->permission used 24 hr->three dots - - Show system apps->permissions tab->physical activity->customization service->See all custom {link} some apps may require permissions to work 06:41:19 Creation of the developer menu in settings- repeat 07:14:13 END [video width="480" height="720" mp4="https://softwarewebdesign.com/SWDHome/wp-content/uploads/2025/12/AndroidDangerousSettings.mp4"][/video] WP 5 12/22/2022 Vb.net Files Create A Copy Or Move A File In A Different Directory copy files move files File Management ' Copy the file to a new location without overwriting existing file. My.Computer.FileSystem.CopyFile( "C:UserFilesTestFilestestFile.txt", "C:UserFilesTestFiles2testFile.txt") ' Copy the file to a new folder, overwriting existing file. My.Computer.FileSystem.CopyFile( "C:UserFilesTestFilestestFile.txt", "C:UserFilesTestFiles2testFile.txt", Microsoft.VisualBasic.FileIO.UIOption.AllDialogs, Microsoft.VisualBasic.FileIO.UICancelOption.DoNothing) ' Copy the file to a new folder and rename it. My.Computer.FileSystem.CopyFile( "C:UserFilesTestFilestestFile.txt", "C:UserFilesTestFiles2NewFile.txt", Microsoft.VisualBasic.FileIO.UIOption.AllDialogs, Microsoft.VisualBasic.FileIO.UICancelOption.DoNothing) ================== overwrite defaults to false need to add ",true" inside the function The My.Computer.FileSystem.MoveFile method can be used to move a file to another folder. If the target structure does not exist, it will be created. To move a file Use the MoveFile method to move the file, specifying the file name and location for both the source file and the target file. This example moves the file named test.txt from TestDir1 to TestDir2. Note that the target file name is specified even though it is the same as the source file name. VB Copy My.Computer.FileSystem.MoveFile("C:TestDir1test.txt", "C:TestDir2test.txt") To move a file and rename it Use the MoveFile method to move the file, specifying the source file name and location, the target location, and the new name at the target location. This example moves the file named test.txt from TestDir1 to TestDir2 and renames it nexttest.txt. VB Copy My.Computer.FileSystem.MoveFile("C:TestDir1test.txt", "C:TestDir2nexttest.txt", FileIO.UIOption.AllDialogs, FileIO.UICancelOption.ThrowException) Vb.net 0 12/10/2023 Php Formatting Html_entity_decode decode format Restoring Html Saves (PHP 4 >= 4.3.0, PHP 5, PHP 7, PHP 8) html_entity_decode — Convert HTML entities to their corresponding characters Description ¶ html_entity_decode(string $string, int $flags = ENT_QUOTES | ENT_SUBSTITUTE | ENT_HTML401, ?string $encoding = null): string html_entity_decode() is the opposite of htmlentities() in that it converts HTML entities in the string to their corresponding characters. More precisely, this function decodes all the entities (including all numeric entities) that a) are necessarily valid for the chosen document type — i.e., for XML, this function does not decode named entities that might be defined in some DTD — and b) whose character or characters are in the coded character set associated with the chosen encoding and are permitted in the chosen document type. All other entities are left as is. Parameters ¶ string The input string. flags A bitmask of one or more of the following flags, which specify how to handle quotes and which document type to use. The default is ENT_QUOTES | ENT_SUBSTITUTE | ENT_HTML401. Available flags constants Constant Name Description ENT_COMPAT Will convert double-quotes and leave single-quotes alone. ENT_QUOTES Will convert both double and single quotes. ENT_NOQUOTES Will leave both double and single quotes unconverted. ENT_SUBSTITUTE Replace invalid code unit sequences with a Unicode Replacement Character U+FFFD (UTF-8) or &#xFFFD; (otherwise) instead of returning an empty string. ENT_HTML401 Handle code as HTML 4.01. ENT_XML1 Handle code as XML 1. ENT_XHTML Handle code as XHTML. ENT_HTML5 Handle code as HTML 5. encoding An optional argument defining the encoding used when converting characters. If omitted, encoding defaults to the value of the default_charset configuration option. Although this argument is technically optional, you are highly encouraged to specify the correct value for your code if the default_charset configuration option may be set incorrectly for the given input. The following character sets are supported: Supported charsets Charset Aliases Description ISO-8859-1 ISO8859-1 Western European, Latin-1. ISO-8859-5 ISO8859-5 Little used cyrillic charset (Latin/Cyrillic). ISO-8859-15 ISO8859-15 Western European, Latin-9. Adds the Euro sign, French and Finnish letters missing in Latin-1 (ISO-8859-1). UTF-8 ASCII compatible multi-byte 8-bit Unicode. cp866 ibm866, 866 DOS-specific Cyrillic charset. cp1251 Windows-1251, win-1251, 1251 Windows-specific Cyrillic charset. cp1252 Windows-1252, 1252 Windows specific charset for Western European. KOI8-R koi8-ru, koi8r Russian. BIG5 950 Traditional Chinese, mainly used in Taiwan. GB2312 936 Simplified Chinese, national standard character set. BIG5-HKSCS Big5 with Hong Kong extensions, Traditional Chinese. Shift_JIS SJIS, SJIS-win, cp932, 932 Japanese EUC-JP EUCJP, eucJP-win Japanese MacRoman Charset that was used by Mac OS. '' An empty string activates detection from script encoding (Zend multibyte), default_charset and current locale (see nl_langinfo() and setlocale()), in this order. Not recommended. Note: Any other character sets are not recognized. The default encoding will be used instead and a warning will be emitted. Return Values ¶ Returns the decoded string. Changelog ¶ Version Description 8.1.0 flags changed from ENT_COMPAT to ENT_QUOTES | ENT_SUBSTITUTE | ENT_HTML401. 8.0.0 encoding is nullable now. Examples ¶ Example #1 Decoding HTML entities <?php $orig = "I'll "walk" the <b>dog</b> now"; $a = htmlentities($orig); $b = html_entity_decode($a); echo $a; // I'll &quot;walk&quot; the &lt;b&gt;dog&lt;/b&gt; now echo $b; // I'll "walk" the <b>dog</b> now ?> Notes ¶ Php 2 09/09/2023 Php Formatting Htmlentities html convert format Html, Php Saves (PHP 4, PHP 5, PHP 7, PHP 8) htmlentities — Convert all applicable characters to HTML entities Description ¶ htmlentities( string $string, int $flags = ENT_QUOTES | ENT_SUBSTITUTE | ENT_HTML401, ?string $encoding = null, bool $double_encode = true ): string This function is identical to htmlspecialchars() in all ways, except with htmlentities(), all characters which have HTML character entity equivalents are translated into these entities. The get_html_translation_table() function can be used to return the translation table used dependent upon the provided flags constants. If you want to decode instead (the reverse) you can use html_entity_decode(). Parameters ¶ string The input string. flags A bitmask of one or more of the following flags, which specify how to handle quotes, invalid code unit sequences and the used document type. The default is ENT_QUOTES | ENT_SUBSTITUTE | ENT_HTML401. Available flags constants Constant Name Description ENT_COMPAT Will convert double-quotes and leave single-quotes alone. ENT_QUOTES Will convert both double and single quotes. ENT_NOQUOTES Will leave both double and single quotes unconverted. ENT_IGNORE Silently discard invalid code unit sequences instead of returning an empty string. Using this flag is discouraged as it » may have security implications. ENT_SUBSTITUTE Replace invalid code unit sequences with a Unicode Replacement Character U+FFFD (UTF-8) or &#FFFD; (otherwise) instead of returning an empty string. ENT_DISALLOWED Replace invalid code points for the given document type with a Unicode Replacement Character U+FFFD (UTF-8) or &#FFFD; (otherwise) instead of leaving them as is. This may be useful, for instance, to ensure the well-formedness of XML documents with embedded external content. ENT_HTML401 Handle code as HTML 4.01. ENT_XML1 Handle code as XML 1. ENT_XHTML Handle code as XHTML. ENT_HTML5 Handle code as HTML 5. encoding An optional argument defining the encoding used when converting characters. If omitted, encoding defaults to the value of the default_charset configuration option. Although this argument is technically optional, you are highly encouraged to specify the correct value for your code if the default_charset configuration option may be set incorrectly for the given input. The following character sets are supported: Supported charsets Charset Aliases Description ISO-8859-1 ISO8859-1 Western European, Latin-1. ISO-8859-5 ISO8859-5 Little used cyrillic charset (Latin/Cyrillic). ISO-8859-15 ISO8859-15 Western European, Latin-9. Adds the Euro sign, French and Finnish letters missing in Latin-1 (ISO-8859-1). UTF-8 ASCII compatible multi-byte 8-bit Unicode. cp866 ibm866, 866 DOS-specific Cyrillic charset. cp1251 Windows-1251, win-1251, 1251 Windows-specific Cyrillic charset. cp1252 Windows-1252, 1252 Windows specific charset for Western European. KOI8-R koi8-ru, koi8r Russian. BIG5 950 Traditional Chinese, mainly used in Taiwan. GB2312 936 Simplified Chinese, national standard character set. BIG5-HKSCS Big5 with Hong Kong extensions, Traditional Chinese. Shift_JIS SJIS, SJIS-win, cp932, 932 Japanese EUC-JP EUCJP, eucJP-win Japanese MacRoman Charset that was used by Mac OS. '' An empty string activates detection from script encoding (Zend multibyte), default_charset and current locale (see nl_langinfo() and setlocale()), in this order. Not recommended. Note: Any other character sets are not recognized. The default encoding will be used instead and a warning will be emitted. double_encode When double_encode is turned off PHP will not encode existing html entities. The default is to convert everything. Return Values ¶ Returns the encoded string. If the input string contains an invalid code unit sequence within the given encoding an empty string will be returned, unless either the ENT_IGNORE or ENT_SUBSTITUTE flags are set. Changelog ¶ Version Description 8.1.0 flags changed from ENT_COMPAT to ENT_QUOTES | ENT_SUBSTITUTE | ENT_HTML401. 8.0.0 encoding is nullable now. Examples ¶ Example #1 A htmlentities() example <?php $str = "A 'quote' is <b>bold</b>"; // Outputs: A 'quote' is <b>bold</b> echo htmlentities($str); // Outputs: A 'quote' is <b>bold</b> echo htmlentities($str, ENT_QUOTES); ?> Example #2 Usage of ENT_IGNORE <?php $str = "x8F!!!"; // Outputs an empty string echo htmlentities($str, ENT_QUOTES, "UTF-8"); // Outputs "!!!" echo htmlentities($str, ENT_QUOTES | ENT_IGNORE, "UTF-8"); ?> See Also ¶ html_entity_decode() - Convert HTML entities to their corresponding characters get_html_translation_table() - Returns the translation table used by htmlspecialchars and htmlentities htmlspecialchars() - Convert special characters to HTML entities nl2br() - Inserts HTML line breaks before all newlines in a string urlencode() - URL-encodes string Php 2 09/09/2023 Mysql Dumps Archive Database: `softwax3_myfiles file contact -- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jan 25, 2023 at 11:46 AM -- Server version: 5.7.23-23 -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; -- -- Database: `softwax3_myfiles` -- -- -------------------------------------------------------- -- -- Table structure for table `contacts` -- CREATE TABLE `contacts` ( `contactid` smallint(6) NOT NULL, `last_name` varchar(25) NOT NULL, `first_name` varchar(25) NOT NULL, `phone` varchar(12) NOT NULL, `email` varchar(50) NOT NULL, `additional_info` varchar(300) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `file` -- CREATE TABLE `file` ( `fileid` mediumint(9) NOT NULL, `categoryid` tinyint(4) NOT NULL, `file` varchar(100) NOT NULL, `description` text NOT NULL, `computer_used` varchar(10) NOT NULL, `date_created` date NOT NULL, `date_modified` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `fileCategory` -- CREATE TABLE `fileCategory` ( `categoryid` tinyint(4) NOT NULL, `category` varchar(25) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `fileUpdates` -- CREATE TABLE `fileUpdates` ( `fileid` smallint(6) NOT NULL, `session` int(11) NOT NULL, `title` varchar(50) NOT NULL, `version` varchar(19) NOT NULL, `description` text NOT NULL, `file_exe` varchar(50) NOT NULL, `file_ini` varchar(50) NOT NULL, `file_other` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `folderCategory` -- CREATE TABLE `folderCategory` ( `categoryid` tinyint(4) NOT NULL, `category` varchar(25) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `folders` -- CREATE TABLE `folders` ( `folderid` smallint(6) NOT NULL, `categoryid` smallint(6) NOT NULL, `folder_num` smallint(6) NOT NULL, `description` varchar(40) NOT NULL, `keywords` tinytext NOT NULL, `archive` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `government` -- CREATE TABLE `government` ( `movieid` smallint(6) NOT NULL, `title` varchar(100) NOT NULL, `comment` varchar(400) NOT NULL, `file` varchar(100) NOT NULL, `image` varchar(10) NOT NULL, `viewed` smallint(6) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `iphistory` -- CREATE TABLE `iphistory` ( `historyid` mediumint(9) NOT NULL, `date` date NOT NULL, `ipaddress` varchar(19) NOT NULL, `counter` smallint(6) NOT NULL, `blocking` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `movie` -- CREATE TABLE `movie` ( `movieid` mediumint(9) NOT NULL, `title` varchar(50) NOT NULL, `star5` tinyint(4) NOT NULL, `coverImage` varchar(9) NOT NULL, `rating` tinyint(4) NOT NULL, `genere` varchar(60) NOT NULL, `description` text NOT NULL, `year` smallint(6) NOT NULL, `download` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `projects` -- CREATE TABLE `projects` ( `projectid` smallint(6) NOT NULL, `project` varchar(20) NOT NULL, `date_modified` date NOT NULL, `table_name` varchar(25) NOT NULL, `fields` text NOT NULL, `date_fields` varchar(25) NOT NULL, `txx` text NOT NULL, `date_txx` varchar(25) NOT NULL, `txtFileName` varchar(25) NOT NULL, `txxFileName` varchar(25) NOT NULL, `txxPath` varchar(50) NOT NULL, `computer` varchar(100) NOT NULL, `list_report` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `storage` -- CREATE TABLE `storage` ( `storageid` tinyint(4) NOT NULL, `date_stored` date NOT NULL, `stored` varchar(250) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `useradmin` -- CREATE TABLE `useradmin` ( `userid` mediumint(9) NOT NULL, `lastname` varchar(30) NOT NULL DEFAULT '', `firstname` varchar(30) NOT NULL DEFAULT '', `email` varchar(70) NOT NULL DEFAULT '', `username` varchar(20) NOT NULL DEFAULT '', `password` varchar(20) NOT NULL DEFAULT '', `level` tinyint(4) NOT NULL DEFAULT '0', `logintimes` mediumint(9) NOT NULL DEFAULT '0', `lastlogin` date NOT NULL DEFAULT '0000-00-00', `accesspages` varchar(255) NOT NULL DEFAULT '', `ipaddress` varchar(19) NOT NULL, `locked` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `contacts` -- ALTER TABLE `contacts` ADD PRIMARY KEY (`contactid`), ADD KEY `last_name` (`last_name`,`first_name`); -- -- Indexes for table `file` -- ALTER TABLE `file` ADD PRIMARY KEY (`fileid`), ADD KEY `categoryid` (`categoryid`); -- -- Indexes for table `fileCategory` -- ALTER TABLE `fileCategory` ADD PRIMARY KEY (`categoryid`); -- -- Indexes for table `fileUpdates` -- ALTER TABLE `fileUpdates` ADD PRIMARY KEY (`fileid`); -- -- Indexes for table `folderCategory` -- ALTER TABLE `folderCategory` ADD PRIMARY KEY (`categoryid`); -- -- Indexes for table `folders` -- ALTER TABLE `folders` ADD PRIMARY KEY (`folderid`); -- -- Indexes for table `government` -- ALTER TABLE `government` ADD PRIMARY KEY (`movieid`); -- -- Indexes for table `iphistory` -- ALTER TABLE `iphistory` ADD PRIMARY KEY (`historyid`); -- -- Indexes for table `movie` -- ALTER TABLE `movie` ADD PRIMARY KEY (`movieid`), ADD KEY `download` (`download`); -- -- Indexes for table `projects` -- ALTER TABLE `projects` ADD PRIMARY KEY (`projectid`); -- -- Indexes for table `useradmin` -- ALTER TABLE `useradmin` ADD PRIMARY KEY (`userid`), ADD KEY `lastname` (`lastname`,`firstname`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `contacts` -- ALTER TABLE `contacts` MODIFY `contactid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `file` -- ALTER TABLE `file` MODIFY `fileid` mediumint(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `fileCategory` -- ALTER TABLE `fileCategory` MODIFY `categoryid` tinyint(4) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `fileUpdates` -- ALTER TABLE `fileUpdates` MODIFY `fileid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `folderCategory` -- ALTER TABLE `folderCategory` MODIFY `categoryid` tinyint(4) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `folders` -- ALTER TABLE `folders` MODIFY `folderid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `government` -- ALTER TABLE `government` MODIFY `movieid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `iphistory` -- ALTER TABLE `iphistory` MODIFY `historyid` mediumint(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `movie` -- ALTER TABLE `movie` MODIFY `movieid` mediumint(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `projects` -- ALTER TABLE `projects` MODIFY `projectid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `useradmin` -- ALTER TABLE `useradmin` MODIFY `userid` mediumint(9) NOT NULL AUTO_INCREMENT; COMMIT; Mysql Dumps 3 09/09/2023 Mysql Dumps Archive Database: `softwax3_codeSaver` code language operation Backup -- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jan 25, 2023 at 11:57 AM -- Server version: 5.7.23-23 -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; -- -- Database: `softwax3_codeSaver` -- -- -------------------------------------------------------- -- -- Table structure for table `code` -- CREATE TABLE `code` ( `codeid` mediumint(9) NOT NULL, `code` text NOT NULL, `title` varchar(70) NOT NULL, `keywords` varchar(100) NOT NULL, `application` varchar(35) NOT NULL, `languageid` tinyint(4) NOT NULL, `operationid` mediumint(9) NOT NULL, `show_html` tinyint(4) NOT NULL, `show_iframe` tinyint(4) NOT NULL, `make_public` tinyint(4) NOT NULL, `viewed` mediumint(9) NOT NULL, `viewed_date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `contact_us` -- CREATE TABLE `contact_us` ( `contactid` mediumint(9) NOT NULL, `Subject` varchar(100) NOT NULL, `Body` text NOT NULL, `EmailReply` tinyint(4) NOT NULL, `Email` varchar(80) NOT NULL, `PhoneReply` tinyint(4) NOT NULL, `Phone` varchar(20) NOT NULL, `MailReply` tinyint(4) NOT NULL, `Name` varchar(50) NOT NULL, `Address` varchar(50) NOT NULL, `City` varchar(20) NOT NULL, `State` varchar(20) NOT NULL, `Zip` varchar(20) NOT NULL, `dateof` date NOT NULL, `ipaddress` varchar(19) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `language` -- CREATE TABLE `language` ( `languageid` tinyint(6) NOT NULL, `language` varchar(25) NOT NULL, `menu_column` tinyint(4) NOT NULL, `menu_row` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `operation` -- CREATE TABLE `operation` ( `operationid` smallint(6) NOT NULL, `operation` varchar(25) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `settingid` smallint(6) NOT NULL, `title` varchar(30) NOT NULL, `value` varchar(70) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `settings_Large` -- CREATE TABLE `settings_Large` ( `settingid` smallint(6) NOT NULL, `title` varchar(30) NOT NULL, `value` varchar(1000) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `useradmin` -- CREATE TABLE `useradmin` ( `userid` mediumint(9) NOT NULL, `lastname` varchar(30) NOT NULL DEFAULT '', `firstname` varchar(30) NOT NULL DEFAULT '', `email` varchar(70) NOT NULL DEFAULT '', `username` varchar(20) NOT NULL DEFAULT '', `password` varchar(20) NOT NULL DEFAULT '', `level` tinyint(4) NOT NULL DEFAULT '0', `logintimes` mediumint(9) NOT NULL DEFAULT '0', `lastlogin` date NOT NULL DEFAULT '0000-00-00', `accesspages` varchar(255) NOT NULL DEFAULT '', `ipaddress` varchar(19) NOT NULL, `locked` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `websites` -- CREATE TABLE `websites` ( `siteid` smallint(6) NOT NULL, `url` varchar(100) NOT NULL, `title` varchar(50) NOT NULL, `comment` text NOT NULL, `year` smallint(6) NOT NULL, `personal` tinyint(4) NOT NULL, `ecommerce` tinyint(4) NOT NULL, `event_register` tinyint(4) NOT NULL, `email_news` tinyint(4) NOT NULL, `calendar` tinyint(4) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `code` -- ALTER TABLE `code` ADD PRIMARY KEY (`codeid`), ADD KEY `languageid` (`languageid`), ADD KEY `operationid` (`operationid`), ADD KEY `application` (`application`); -- -- Indexes for table `contact_us` -- ALTER TABLE `contact_us` ADD PRIMARY KEY (`contactid`); -- -- Indexes for table `language` -- ALTER TABLE `language` ADD PRIMARY KEY (`languageid`); -- -- Indexes for table `operation` -- ALTER TABLE `operation` ADD PRIMARY KEY (`operationid`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`settingid`); -- -- Indexes for table `settings_Large` -- ALTER TABLE `settings_Large` ADD PRIMARY KEY (`settingid`); -- -- Indexes for table `useradmin` -- ALTER TABLE `useradmin` ADD PRIMARY KEY (`userid`), ADD KEY `lastname` (`lastname`,`firstname`); -- -- Indexes for table `websites` -- ALTER TABLE `websites` ADD PRIMARY KEY (`siteid`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `code` -- ALTER TABLE `code` MODIFY `codeid` mediumint(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `contact_us` -- ALTER TABLE `contact_us` MODIFY `contactid` mediumint(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `language` -- ALTER TABLE `language` MODIFY `languageid` tinyint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `operation` -- ALTER TABLE `operation` MODIFY `operationid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `settingid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `settings_Large` -- ALTER TABLE `settings_Large` MODIFY `settingid` smallint(6) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `useradmin` -- ALTER TABLE `useradmin` MODIFY `userid` mediumint(9) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `websites` -- ALTER TABLE `websites` MODIFY `siteid` smallint(6) NOT NULL AUTO_INCREMENT; COMMIT; Mysql Dumps 3 09/09/2023 Php Database Find Orphans left join orphan delete // Child to parent using left join to find orphans Select * from table1groups left join table1 on table1groups.musgraveid=table1.musgraveid LIMIT 0, 30 Select * from table1groups left join table1 on table1groups.musgraveid=table1.musgraveid Where table1.musgraveid IS NULL LIMIT 0, 30 Select * from `customer` left join invoices on `customer.customerid`=invoices.customerid Where invoices.customerid IS NULL LIMIT 0, 300 Php 2 09/09/2023 Php Function Ziping And Unziping Server Folders Using Php zip unzip directory folder backup mysql backup directory // I use a browser script that send the proper data to back up since if have multiple accounts. I separate the small files in one zip and large files in another. Under case 1. you will notice mp3 and zip this prevents bloated zips which may fail. Video and music should be done seperately from the rest of the files. I included a mysql backup that gets the data and makes a .sql file if you give it database information. class Utils { public static function listDirectory($dir) { $result = array(); $root = scandir($dir); foreach($root as $value) { if($value === '.' || $value === '..') { continue; } if(is_file("$dir$value")) { $result[] = "$dir$value"; continue; } if(is_dir("$dir$value")) { $result[] = "$dir$value/"; } foreach(self::listDirectory("$dir$value/") as $value) { $result[] = $value; } } return $result; } } /* use if you need to rename or auto download $file = '/path/to/zip/file.zip'; $file_name = basename($file); header("Content-Type: application/zip"); header("Content-Disposition: attachment; filename=" . $file_name); header("Content-Length: " . filesize($file)); readfile($file); exit; */ $project=$_GET["pr"];$projectid=$_GET["id"];$PHPfolder=$_GET["fo"];$PHPdatabase=$_GET["db"];$user=$_GET["us"]; $password=$_GET["pa"];$return1=$_GET["re"]; $exportstring="pr=$project&fo=$PHPfolder&db=$PHPdatabase&us=$user&pa=$password&re=$return1&id=$projectid"; $server="localhost"; $AC=$_GET["L"]; $topDir=dirname(__FILE__); $folder0="/".$PHPfolder; $source_dir = $topDir.$folder0."/"; if(strlen($PHPfolder)==1)$source_dir = $topDir."/"; // For those sites where zipdemo is in their root if(is_dir($topDir."/BACKED")==false){ mkdir($topDir."/BACKED", 0777); } if($AC=="" && strlen($PHPdatabase)>1){ mysql_connect($server,$user,$password); mysql_select_db($PHPdatabase); $backupFile =$source_dir.$PHPdatabase.".sql"; $result .= "# MySQL Data Backup of ".$PHPdatabase."\n"; $result .= "# This was generated on " . date("m/d/Y") . "\n\n"; $tables = mysql_list_tables($PHPdatabase); for($i = 0; $i < mysql_num_rows($tables); $i++){ $table = mysql_tablename ($tables, $i); if(substr($table,0,7)!="tblStat"){ $result .= "# Start of $table \n"; $result .= "TRUNCATE TABLE $table;\n"; $query = mysql_query("select * from $table"); $num_fields = mysql_num_fields($query); $result .= "$table fields (\n"; for($ii = 0; $ii < $num_fields; $ii++) { $result.= mysql_field_name($query,$ii)."-".mysql_field_type($query,$ii)."(".mysql_field_len($query,$ii).")".mysql_field_flags($query,$ii)."\n"; } $result.=");\n"; $numrow = mysql_num_rows($query); while( $row = mysql_fetch_array($query, MYSQL_NUM)) { $result .= "INSERT INTO ".$table." VALUES("; for($j=0; $j<$num_fields; $j++) { $row[$j] = addslashes($row[$j]); $row[$j] = str_replace("\n","\\n",$row[$j]); $row[$j] = str_replace("\r","",$row[$j]); if (isset($row[$j])) $result .= "\"$row[$j]\""; else $result .= "\"\""; if ($j<($num_fields-1)) $result .= ", "; } $result .= ");\n"; } } if ($i+1 != mysql_num_rows($tables)) $result .= "\n"; } $ID++; // =================== $fp = fopen($backupFile, "w"); fwrite($fp, $result); // Move to the start of the file fclose($fp); } //echo $topDir."/BACKED".$folder0."L.zip"; echo $exportstring;exit; switch($AC){ case 1: $zip_file = $topDir."/BACKED/".$project."L.zip"; $fi0=$_GET["fi0"]; $exportstring.="&fi0=$fi0&fi1=/BACKED/".$project."L.zip"; break; default: $zip_file = $topDir."/BACKED/".$project.".zip"; $exportstring.="&fi0=/BACKED/".$project.".zip"; break; } //echo $zip_file;exit; $file_list = Utils::listDirectory($source_dir); //echo "shit2";exit; $zip = new ZipArchive(); if ($zip->open($zip_file, ZIPARCHIVE::CREATE) === true) { foreach ($file_list as $file) { if ($file !== $zip_file) { switch($AC){ case 1: if(filesize($file)>= 250000 && strpos($file,".zip")==0 && strpos($file,".mp3")==0) $zip->addFile($file, substr($file, strlen($source_dir))); break; default: if(filesize($file)<= 250000) $zip->addFile($file, substr($file, strlen($source_dir))); break; } } //$i++;if($i==10)break; } $zip->close(); } if($AC==""){ header("location:zipdemo.php?$exportstring&L=1");exit; } else{ header("location:http://$return1?$exportstring"); exit; } ?> This script includes header files which may hiccup if error reporting is set to show warnings. The one below will handle warnings. class Utils { public static function listDirectory($dir) { $result = array(); $root = scandir($dir); foreach($root as $value) { if($value === '.' || $value === '..') { continue; } if(is_file("$dir$value")) { $result[] = "$dir$value"; continue; } if(is_dir("$dir$value")) { $result[] = "$dir$value/"; } foreach(self::listDirectory("$dir$value/") as $value) { $result[] = $value; } } return $result; } } /* $file = '/path/to/zip/file.zip'; $file_name = basename($file); header("Content-Type: application/zip"); header("Content-Disposition: attachment; filename=" . $file_name); header("Content-Length: " . filesize($file)); readfile($file); exit; */ $project=$_GET["pr"];$projectid=$_GET["id"];$PHPfolder=$_GET["fo"];$PHPdatabase=$_GET["db"];$user=$_GET["us"]; $password=$_GET["pa"];$return1=$_GET["re"]; $project="Peak_Wellness";$PHPdatabase="the1324812461410";$user="the1324812461410";$password="v4K#htNPNfeG"; $return1="www.softwarewebdesign.com/SWD/EMAIL/backmeup.php";$projectid=27; $exportstring="pr=$project&fo=$PHPfolder&db=$PHPdatabase&us=$user&pa=$password&re=$return1&id=$projectid"; $server="the1324812461410.db.11744884.hostedresource.com"; $AC=$_GET["L"]; $topDir=dirname(__FILE__); $folder0="/".$PHPfolder; $source_dir = $topDir."/"; //.$folder0."/"; if(is_dir($topDir."/BACKED")==false){ mkdir($topDir."/BACKED", 0777); } if($AC=="" && strlen($PHPdatabase)>1){ mysql_connect($server,$user,$password); mysql_select_db($PHPdatabase); $backupFile =$source_dir.$PHPdatabase.".sql"; $result .= "# MySQL Data Backup of ".$PHPdatabase."\n"; $result .= "# This was generated on " . date("m/d/Y") . "\n\n"; $tables = mysql_list_tables($PHPdatabase); for($i = 0; $i < mysql_num_rows($tables); $i++){ $table = mysql_tablename ($tables, $i); if(substr($table,0,7)!="tblStat"){ $result .= "# Start of $table \n"; $result .= "TRUNCATE TABLE $table;\n"; $query = mysql_query("select * from $table"); $num_fields = mysql_num_fields($query); $result .= "$table fields (\n"; for($ii = 0; $ii < $num_fields; $ii++) { $result.= mysql_field_name($query,$ii)."-".mysql_field_type($query,$ii)."(".mysql_field_len($query,$ii).")".mysql_field_flags($query,$ii)."\n"; } $result.=");\n"; $numrow = mysql_num_rows($query); while( $row = mysql_fetch_array($query, MYSQL_NUM)) { $result .= "INSERT INTO ".$table." VALUES("; for($j=0; $j<$num_fields; $j++) { $row[$j] = addslashes($row[$j]); $row[$j] = str_replace("\n","\\n",$row[$j]); $row[$j] = str_replace("\r","",$row[$j]); if (isset($row[$j])) $result .= "\"$row[$j]\""; else $result .= "\"\""; if ($j<($num_fields-1)) $result .= ", "; } $result .= ");\n"; } } if ($i+1 != mysql_num_rows($tables)) $result .= "\n"; } $ID++; // =================== $fp = fopen($backupFile, "w"); fwrite($fp, $result); // Move to the start of the file fclose($fp); } //echo "Done sql";exit; //echo $topDir."/BACKED".$folder0."L.zip"; echo $exportstring;exit; switch($AC){ case 1: $zip_file = $topDir."/BACKED/".$project."L.zip"; $fi0=$_GET["fi0"]; $exportstring.="&fi0=$fi0&fi1=/BACKED/".$project."L.zip"; break; default: $zip_file = $topDir."/BACKED/".$project.".zip"; $exportstring.="&fi0=/BACKED/".$project.".zip"; break; } //echo $zip_file;exit; $file_list = Utils::listDirectory($source_dir); //echo "shit2";exit; $zip = new ZipArchive(); if ($zip->open($zip_file, ZIPARCHIVE::CREATE) === true) { foreach ($file_list as $file) { if ($file !== $zip_file) { switch($AC){ case 1: if(filesize($file)>= 250000 && strpos($file,".zip")==0 && strpos($file,".mp3")==0) $zip->addFile($file, substr($file, strlen($source_dir))); break; default: if(filesize($file)<= 250000) $zip->addFile($file, substr($file, strlen($source_dir))); break; } } //$i++;if($i==10)break; } $zip->close(); } /* if($AC==""){ header("location:zipdemo.php?$exportstring&L=1");exit; } else{ header("location:http://$return1?$exportstring"); exit; } */ if($AC==""){ echo "Continue"; exit; } else{ echo "Continue"; exit; } ?> To unzip an archive just upload the archive and this script into the directory and run. Do this for both zips to get the complete archive. UNZIP SCRIPT $topDir=dirname(__FILE__)."/"; //echo $topDir;exit; $zip = new ZipArchive; if ($zip->open('SUBWAYL.zip') === TRUE) { $zip->extractTo($topDir); $zip->close(); echo 'ok'; } else { echo 'failed'; } ?> Php 1767 09/09/2023 Javascript Controls List Box Controls Another Listbox And Fills In A Text Box list box text box onchange header dropdown Search & PHPScript 2025/12 // started on lastbackupView.php function dropdown_to_text (dropID,textID){ var e = document.getElementById(dropID); var f = document.getElementById(textID); var ddown = e.options[e.selectedIndex].value; f.value=ddown; } function list_action(id){ var e = document.getElementById(id); var value = e.value; var text = e.options[e.selectedIndex].text; var sel = document.getElementById('searchcombo1'); document.getElementById('SEARCH').value=document.getElementById(id).value; var val = e.name; for(var i = 0, j = sel.options.length; i < j; ++i) { val2=sel.options[i].innerHTML; val2=val2.substr(0,val.length); if(val2 === val) { sel.selectedIndex = i; break; } } } Javascript 2 09/09/2023 Php Database Delete left join delete orphans // using Left Join to kill orphans DELETE FROM `cart` USING `cart` LEFT JOIN orders ON cart.sessionid=orders.sessionid WHERE orderid IS NULL AND updated<'2006-01-01' Php 2 09/09/2023 WP Themes Archive Software Web Design Home Page Code page plugin ?? Executive Pro /public_html/SWDHome/wp-content/themes/executive-pro/pagesw.php <?php /** * Genesis Framework. * Template Name: SWpages * * WARNING: This file is part of the core Genesis Framework. DO NOT edit this file under any circumstances. * Please do all modifications in the form of a child theme. * * @package GenesisTemplates * @author StudioPress * @license GPL-2.0+ * @link http://my.studiopress.com/themes/genesis/ */ //* This file handles pages, but only exists for the sake of child theme forward compatibility. /* Moved to admin panel function include_link() { $_SESSION["LEVEL"]=10; echo"Access <a href='/admin31/LoginScreen.php?UR=s0ftw8r3&PD=w3bd3s1gn' target='NewWindow'>Secondary Admin</a>"; } */ function include_page() { global $page1;global $wpdb; global $row; $dirSW="/wp-content/themes/executive-pro"; switch($page1){ case 48: include(get_theme_root_uri()."/executive-pro/colorconvert.php");break; case 53: //InsertCodeSW($page1); break; //BEGIN OF NOTES BEGIN OF NOTES BEGIN OF NOTES BEGIN OF NOTES BEGIN OF NOTES BEGIN OF NOTES BEGIN OF NOTES BEGIN OF NOTES BEGIN OF NOTES BEGIN OF NOTES BEGIN OF NOTES $PDS_=$_GET['PDS_'];$PDS_ = ereg_replace('[^0-9]', '', $PDS_); $SB=$_GET["SB"]; $url=site_url()."?page_id=53&PDS_=$PDS_";$varView="?page_id=53&PDS_=$PDS_&SB=$SB"; $SB="`".$_GET["SB"]."`"; //compiled version: 1.2013.212.0512 function stripDESC($var1){ $m=strpos($var1,'DESC'); if($m>0)$var1=substr($var1,0,$m-1); return $var1; } function CreateLinks($inx,$num,$range,$ALPHA,$VIEW,$varView){ $ratio=(int)($num/$range);$start=1;$maxlinks=30; if($ratio<$num/$range)$ratio+=1; $end=$ratio; if($ratio>$maxlinks){ $start=$inx/$range-$maxlinks/2; if($start<1)$start=1; $end=$start+$maxlinks; if($end>$ratio){ $end=$ratio;$start=$end-$maxlinks; } } for($i=$start;$i<=$end;$i++){ switch($VIEW){ case 2: $submenu.="<A Href='$varView&INX=".($i-1)*$range."&NUM=$num&ALPHA=$ALPHA&VIEW=$VIEW'>$i</A>&nbsp;|&nbsp;"; break; default: $submenu.="<A Href='$varView&INX=".($i-1)*$range."&NUM=$num&ALPHA=$ALPHA&VIEW=$VIEW'>$i</A>&nbsp;|&nbsp;"; } } $dis1.=$submenu; return $dis1; } //include("../admin31/mystuff.php"); //include("../admin31/functions.php"); $varForm="codeForm.php"; // HEADER CODE HERE $prn=$_GET["prn"]; $AC=$_GET["AC"]; $AC = ereg_replace('[^0-9]', '', $AC); switch ($AC){ default: echo "<div id='swnotes' style='float:right;'>"; $sessionListSave='@'.$sessionListSave; $defaultSearchField="code.title"; $_SESSION["TABLENAME"]="code"; $INX=$_GET["INX"];$NUM=$_GET["NUM"];$ALPHA=$_GET["ALPHA"];$VIEW=$_GET["VIEW"];$report=$_GET["report"]; $BUTTON=$_POST['BUTTON'];$search1=$_POST["SEARCH"];$FID=$_POST["updaterecord"]; if($_POST["resetSM"]=="*")$search1="*"; if($_POST["resetLG"]=="**")$search1="**"; if($_GET['PDS_KILL']!='')$_SESSION['PDS_SAVE']=''; //if($PDS_!=''){ $_SESSION['PDS_SAVE']=$PDS_;$_SESSION['INX1']=$_GET['INX']; $_SESSION['NUM1']=$_GET['NUM']; $_SESSION['ALPHA1']=$_GET['ALPHA'] ; $_SESSION['VIEW1']=$_GET['VIEW'];$INX=0;$NUM=0;$ALPHA='';$VIEW=0; } //ELSE $PDS_=$_SESSION['PDS_SAVE']; // `Start Report` $sql="SELECT * FROM language ORDER BY language"; $rlang=mysql_query($sql);$numlang=mysql_numrows($rlang); for($i=1;$i<=$numlang;$i++){ $l=mysql_fetch_array($rlang); $lang[$l[0]]=$l[1]; } if($_SESSION["FIELDSAVE"]=="")$_SESSION["FIELDSAVE"]=$defaultSearchField; if($FID==""){ $FID=$_SESSION["FIELDSAVE"]; } else $_SESSION["FIELDSAVE"]=$FID; if($search1=="*" || $search1=="**"){ $_SESSION["SEARCHSAVE"]=""; if($search1=="**"){ $_SESSION['PDS_SAVE']="";$PDS_=""; } $search1=""; } if($search1==""){ $search1=$_SESSION["SEARCHSAVE"]; } else{ $INX="";$_SESSION["SEARCHSAVE"]=$search1; } if($_POST["inside_search"]=="on" || $_SESSION['INSIDE']=='on'){ $_SESSION['INSIDE']='on';$checked1='checked';$anywhere='%'; } //* Place in Alpha Choice ** if($prn==""){ for($i=65;$i<=90;++$i){ $dis1.="<a class='locate' href='$varView&VIEW=2&ALPHA=".chr($i)."'>".chr($i)."&nbsp;&nbsp;&nbsp;</a>"; } echo $dis1; // ** END ALPHA CHOICE ** // `Report Before Search` echo "<form name='search' method='post' action='$varView'><table width=300><tr>"; echo "<td class=search><input name='SEARCH' type='text' size=20 maxlength=60 value='".$search1."' title='** or * Reset Search.'> <input name='resetSM' type='submit' value='*'><input name='resetLG' type='submit' value='**'><br>"; echo "<select name='updaterecord' size=1>n"; if($FID=="code.title")$FID="code.title"; if($FID=='code.title')echo "<option selected value='code.title'>titlen"; else echo"<option value='code.title'>titlen"; if($FID=='code.code')echo "<option selected value='code.code'>coden"; else echo"<option value='code.code'>coden"; if($FID=='code.keywords')echo "<option selected value='code.keywords'>keywordsn"; else echo"<option value='code.keywords'>keywordsn"; // `Report Search Fields` echo"</select>n"; // `Report Search2` echo "<input name='BUTTON' type='submit' value='SEARCH'>&nbsp;&nbsp;<input type='checkbox' name='inside_search' title='Check me to look inside the data.' $checked1>&nbsp;&nbsp;Look inside data </form>"; // `Report Start Task` echo "</table>"; } //Form variables on update $maxrec=40;if($report==1 || $prn==1)$maxrec=500000; $table='';$terms='';$where='';$AND='WHERE'; $t1="operation";$tables.="$t1,"; $terms.="$t1.operation,"; if(strpos('|'.$where,'WHERE')>0)$AND="AND"; else if($AND=='')$AND="WHERE"; $where.=" $AND code.operationid=operation.operationid";$AND=' AND'; $t0="code";$tables.="$t0"; $terms.="$t0.codeid,$t0.operationid,$t0.title,$t0.code,$t0.keywords, $t0.languageid,$t0.show_html,$t0.make_public,$t0.viewed,$t0.viewed_date"; // `Report Terms` $cancel==false; // `Sql Report` if($PDS_!='' && $cancel==false){ $where.=" $AND $t0.languageid='$PDS_'";$AND='AND'; } if($SB=="``"){ $SB=$_SESSION["SORTBY"]; }else{ if($_SESSION["SORTBY"]==$SB)$SB=$SB." DESC"; $_SESSION["SORTBY"]=$SB; } if($SB=="``" || $SB=="")$sort="`operation`"; else{ $sort=$SB; // `Sort Report Header Links` } if($SB!=""){ $innerjoin=stripDESC($SB);$innerjoin=str_replace("`","",$innerjoin); if(strpos($terms,".".$innerjoin)==0){ $SB="``";$_SESSION["SORTBY"]="";$search1=""; $_SESSION["SEARCHSAVE"]=""; $sort='`operation`'; } } $innerjoin="SELECT $terms FROM $tables $where"; $countrecs="SELECT count(codeid) FROM $tables $where"; $whereAlpha="$AND $FID LIKE '$ALPHA%'"; if($FID!=''){ $whereSearch=" $AND $FID LIKE '".$anywhere.$search1."%'";$AND='AND'; } else { $whereSearch="$AND $FID LIKE '".$anywhere.$search1."%'";$AND='AND'; } if(strpos('|'.$search1,'=')==1){ if(strpos($innerjoin,'WHERE')==0)$AND='WHERE';$search1=substr($search1,1,strlen($search1)-1); $whereSearch=" $AND $search1";$AND='AND'; } $sortcount=0; $orderby=" ORDER BY $sort"; // `Sql Where` append to innerjoin //*************** START REPORT VIEWS ========================== switch($VIEW){ case 2: //======= REPORT ALPHA ========== $whereSearch=str_replace('WHERE','AND',$whereSearch); switch($INX){ case '': $query=$innerjoin.$whereAlpha.$whereSearch; $INX=0; default: $query=$innerjoin.$whereAlpha.$whereSearch." ORDER BY $sort LIMIT ".$INX.",".$maxrec; } $query2=$countrecs.$whereAlpha.$whereSearch; break; // ============= END ALPAHA ================================== default: // next VIEW switch($search1){ case ''://no search used switch($INX){ case '': $query=$innerjoin; $INX=0; default: $query=$innerjoin.$orderby." LIMIT ".$INX.",".$maxrec; } $query2=$countrecs; break; default://SEARCH USED HERE switch($INX){ case '': $query=$innerjoin.$whereSearch; $INX=0; default: $query=$innerjoin.$whereSearch.$orderby." LIMIT ".$INX.",".$maxrec; } $query2=$countrecs.$whereSearch; break; } // end search } // end report $result2=mysql_query($query2); $row2=mysql_fetch_array($result2);$NUM=$row2[0]; $result99=mysql_query($query); $numcode=mysql_numrows($result99); if($VIEW=='')$VIEW=0; if($report!=1){ if($prn==""){ if($NUM>$maxrec) echo CreateLinks($INX,$NUM,$maxrec,$ALPHA,$VIEW,$varView);$dis1=''; echo "<br><form action='$varForm?FORM=0&PID=$PID&INX=$INX&NUM=$NUM&ALPHA=$ALPHA&VIEW=$VIEW' method=post><input type=button value='Printer Friendly' onclick="location.href='$varView?ALPHA=$ALPHA&VIEW=$VIEW&prn=1'"></form>"; } } // == START PRINTING HEADERS OR CHECK FOR DATA REPORT ==== $width="style='width:900px;'"; $dis1.="<table border=1 class=view $width><tr>"; $dis1.="<td class=view ><a href='$varView&SB=languageid'>Languageid</a></td><td class=view><a href='$varView&SB=operation'>Operation</a></td> <td class=view ><a href='$varView&SB=title'>Title</a></td> <td class=view ><a href='$varView&SB=code'>Code</a></td> <td class=view ><a href='$varView&SB=keywords'>Keywords</a></td> <td class=view ><a href='$varView&SB=viewed'>Viewed</a></td><td>Details</td>"; // `Report Append Title` $dis1.="</tr>"; echo $dis1; $cnt=0;// =============== START PRINTING VALUES =========== for($i=1;$i<=$numcode;$i++){ $rcode=mysql_fetch_array($result99); $operation=stripslashes($rcode['operation']); $codeid=$rcode['codeid']; $operationid=$rcode['operationid']; $title=$rcode['title']; $title=stripslashes($title); $keywords=$rcode['keywords']; $keywords=stripslashes($keywords); $languageid=$rcode['languageid']; $show_html=$rcode['show_html']; $make_public=$rcode['make_public']; $viewed=$rcode['viewed']; $viewed_date=$rcode['viewed_date']; $code=$rcode['code']; if($show_html==1) { $code="<textarea rows=4 cols=40>".stripslashes($code)."</textarea>"; } else { $code="<textarea rows=4 cols=40>".stripslashes($code)."</textarea>"; } // `Report Format` if($class=='')$class='class=alt'; else $class=''; $cnt++;$dis.="n<tr $class>"; $dis.="<td class=view>$lang[$languageid]</td> <td class=view>$operation</td> <td class=view>$title</td> <td class=view>$code</td> <td class=view>$keywords</td> <td class=viewnumber align=right>$viewed</td><td class=view><a href='$varView&AC=1&PID=$codeid' name='$codeid'>Get Results</a></td> "; // `Report Append Variable` $dis.="</tr>"; //Generate Totals Here } echo "$dis</table></div>"; if($NUM>$maxrec) echo CreateLinks($INX,$NUM,$maxrec,$ALPHA,$VIEW,$varView); $urlreturn=$varView;if($_GET['URL']!='' || $_SESSION['URLSAVE']!=''){ if($_GET['URL']!=''){ $_SESSION['URLSAVE']=$_GET['URL']; } $urlreturn=$_SESSION['URLSAVE']; } // `End Report` break; case 1: $maxrec=40; $PID=$_GET["PID"]; $PID = ereg_replace('[^0-9]', '', $PID); $table='';$terms='';$where='';$AND=''; $t0="code";$tables.="$t0"; $terms.="$t0.codeid,$t0.title,$t0.code,$t0.show_html,$t0.make_public"; $where="WHERE codeid=$PID"; $innerjoin="SELECT $terms FROM $tables $where"; $query=$innerjoin; $result99=mysql_query($query);$num=mysql_numrows($result99); $dis1.="<div id='swnotes' style='width:880px;float:right;'>"; echo $dis1; $cnt=0;// =============== START PRINTING VALUES =========== for($i=1;$i<=$num;$i++){ $rcode=mysql_fetch_array($result99); $codeid=$rcode['codeid']; $show_html=$rcode['show_html']; $title=$rcode['title']; $title=stripslashes($title); //$code=stripslashes($code); if($show_html==0)$code="<textarea cols=100 rows=30>$code</textarea>"; $make_public=$rcode['make_public']; if($show_html==1) {$b[0]='checked'; $code=stripslashes($rcode['code']); $code=str_replace(chr(10),"<br>",$code); } else { $b[0]=''; $code="<textarea cols=60 rows=40>".stripslashes($rcode['code'])."</textarea>"; } if($make_public==1)$b[1]='checked'; else $b[1]=''; $dis1=array("show_html"=>"<input type='checkbox' name='show_html' ".$b[0].">","make_public"=>"<input type='checkbox' name='make_public' ".$b[1].">","bulldung"=>"scoopshovel"); //REPORT FORMAT here if($class=='')$class='class=alt'; else $class=''; $cnt++;$dis.="<h3>$title</h3>$code</td>"; $dis.=""; } echo $dis; echo "<p><input type=button name='return' value='Return' onclick="location.href='$varView#$PID';"></p></div>"; $sql="UPDATE code SET viewed=viewed+1, viewed_date='".date("Y-m-d")."' WHERE codeid=$codeid"; mysql_query($sql); break; } break; // END OF NOTES END OF NOTES END OF NOTES END OF NOTES END OF NOTES END OF NOTES END OF NOTES END OF NOTES END OF NOTES END OF NOTES END OF NOTES END OF NOTES case 89: InsertCodeSW($page1); break; default: echo admin_url()."<br>". site_url()."<br>". content_url()."<br>". includes_url()."<br>". wp_upload_dir()."<br>". get_template_directory_uri()."<br>". ABSPATH."<br>". get_theme_root_uri(); } } $page1=$post->ID; if(is_user_logged_in()){ add_action('genesis_before_sidebar_widget_area', 'include_link'); } add_action('genesis_entry_footer', 'include_page'); /* add_action('genesis_after_post_content', 'include_page'); function include_page() { global $wpdb; $page_id = genesis_get_custom_field('products'); $page_data = get_page( $page_id ); $title = $page_data->post_title; switch($page_data->ID){ case 69: echo "product prices coming soon"; break; default: echo "why are we here"; break; } } */ genesis(); WP Themes 1 12/22/2022 _Misc Software Object How To Save A Microsoft Publisher File As An Image File jpg png Publisher 365 1. Launch Publisher. Click the “File†tab and click “Open.†2. Browse to the location on your computer where your Microsoft Publisher file is currently saved. Double-click the file to open it. 3. Click the “File†tab and click “Export†from the menu that appears. 4. Select “Change File Type†under the heading “File Types.†5. Click an image file format from the list displayed under the heading “Image File Types.†Available formats include PNG, JPEG, GIF, TIFF and BMP. 6. Click the “Save†button. Publisher saves a copy of your file in your chosen image format. _Misc Software 2 09/09/2023 Browsers Security Remove Free.instantgreenapp.com From Edge instantgreenapp.com popups Edge 1. In Edge, go to Settings and more 2. Select Settings > Cookies and site permissions. 3. Under All permissions, select Pop-ups and redirects. 4. Turn ON the Block toggle. Remove Free.instantgreenapp.com from Edge Open Microsoft Edge. Click on the three dots in the top right corner to expand the Edge menu. Scroll down to Settings. In the left menu, click on Site permissions. Click on Notifications. Click on the three dots on the right of the Free.instantgreenapp.com domain and click Remove. ? See the next step: Malwarebytes. Browsers 0 01/06/2024 Mysql Database Query Language num show Developer 1. Using the SHOW TABLES Command: You can use the SHOW TABLES command to list all tables in a specific database and then check if your table is among them. SHOW TABLES LIKE 'your_table_name'; Mysql 0 03/14/2025 Vb.net Files File Drag Drop Listview drag drop file 3rd party Developer 12/31/25 ai search To programmatically drag multiple files from your VB.NET application and drop them onto a third-party application, you must prepare a DataObject in a standard format that other Windows programs can understand. The standard format for files is DataFormats.FileDrop. Initiating the Drag Operation In your VB.NET application, for the control you want to initiate the drag from (e.g., a Button or a ListView item), use the DoDragDrop method within a mouse event (like MouseDown): vb.net WEBTOOLS USING File1 control Private Sub File1_MouseDown(sender As Object, e As MouseEventArgs) Handles File1.MouseDown ' Create a StringCollection to hold the paths of the files you want to drag. Dim filePaths As New System.Collections.Specialized.StringCollection ' Add the full, qualified paths of the files to the collection. ' This example uses a single file for brevity; you can add multiple paths here. For Each Item As String In File1.SelectedItems Try filePaths.Add(Path.TREE2 + "" + Item.ToString) Catch ex As Exception Continue For End Try Next 'filePaths.Add(Path.Combine(Application.StartupPath, "TestData1.txt")) 'filePaths.Add(Path.Combine(Application.StartupPath, "TestData2.txt")) ' ... add all other file paths ... ' Create a DataObject and set the FileDrop list. Dim data As New DataObject() data.SetFileDropList(filePaths) ' Initiate the drag-and-drop operation, allowing "Copy" or "All" effects. ' Using DragDropEffects.Copy is standard for file drag-and-drop between apps. File1.DoDragDrop(data, DragDropEffects.Copy) End Sub =========== Imports System.IO Imports System.Windows.Forms Public Class Form1 Private originalSelection As List(Of Integer) Public Sub New() InitializeComponent() ' Example setup ListBox1.SelectionMode = SelectionMode.MultiExtended ListBox1.AllowDrop = False ' We are dragging out, not in ' Add some example file paths ListBox1.Items.Add("C:TempFile1.txt") ListBox1.Items.Add("C:TempFile2.txt") ListBox1.Items.Add("C:TempFile3.txt") End Sub ' Capture selection before mouse down Private Sub ListBox1_MouseDown(sender As Object, e As MouseEventArgs) Handles ListBox1.MouseDown originalSelection = New List(Of Integer)(ListBox1.SelectedIndices.Cast(Of Integer)()) End Sub ' Start drag without losing selection Private Sub ListBox1_MouseMove(sender As Object, e As MouseEventArgs) Handles ListBox1.MouseMove If e.Button = MouseButtons.Left AndAlso originalSelection IsNot Nothing AndAlso originalSelection.Count > 0 Then ' Restore original selection in case it changed ListBox1.ClearSelected() For Each idx In originalSelection ListBox1.SelectedIndices.Add(idx) Next ' Prepare file drop list Dim files As New List(Of String) For Each idx In originalSelection Dim path As String = ListBox1.Items(idx).ToString() If File.Exists(path) Then files.Add(path) End If Next If files.Count > 0 Then Dim data As New DataObject(DataFormats.FileDrop, files.ToArray()) ListBox1.DoDragDrop(data, DragDropEffects.Copy) End If End If End Sub End Class =========== Compatibility with Third-Party Applications When dragging between different applications, you must use the standard Windows drag-and-drop formats (like DataFormats.FileDrop). Most third-party applications that support receiving files via drag-and-drop will be listening for this standard format in their own DragEnter and DragDrop event handlers. The crucial step is creating a DataObject and using SetFileDropList() to ensure the data is provided in a standard, interoperable format. The third-party application must have its AllowDrop property set to True for the target control to accept drops. Some older or specific third-party applications might expect different data formats (like a MemoryStream or specific custom formats), but the file path array is the most common and widely supported method. For more information on programmatically simulating a drop to a third-party application without a user's manual mouse action (which is complex and often requires Windows API calls), refer to resources on programmatic drag-and-drop on Microsoft Learn. o programmatically drag a file from your VB.NET application and drop it onto a third-party application, you need to initiate a standard OLE drag-and-drop operation from your VB.NET application. The third-party application, if built to accept standard Windows file drops (like Windows Explorer or Notepad), will handle the drop automatically. Step-by-Step Implementation The key is to create a DataObject containing the file path(s) in the DataFormats.FileDrop format and then call the DoDragDrop method. 1. Set up the UI (e.g., a Button or a ListView) You'll need a control in your application from which the drag operation will start. A Button or ListView item's MouseDown event is a good place to initiate this. 2. Implement the MouseDown event In the MouseDown event of your source control, you will: Specify the full path of the file(s) you want to drag. Create a DataObject. Set the data using DataFormats.FileDrop. Call DoDragDrop to start the operation. Here is a VB.NET code snippet (for Windows Forms) that initiates a drag operation with a single file: vb.net Imports System.IO Imports System.Collections.Specialized ' Required for StringCollection Private Sub YourControl_MouseDown(sender As Object, e As MouseEventArgs) Handles YourControl.MouseDown ' Only start the drag if the left mouse button is pressed If e.Button = Windows.Forms.MouseButtons.Left Then ' Define the path(s) to the file(s) you want to drag. ' Use StringCollection for multiple files, or a String array for one or more. Dim filePaths As New StringCollection() ' Example: Add a specific file from your application's startup path Dim filePath As String = Path.Combine(Application.StartupPath, "YourFileName.txt") ' Ensure the file exists before attempting to drag it If File.Exists(filePath) Then filePaths.Add(filePath) ' Create a DataObject and set the file drop list Dim data As New DataObject() data.SetFileDropList(filePaths) ' Start the drag-and-drop operation, allowing Copy effects Me.DoDragDrop(data, DragDropEffects.Copy) Else MessageBox.Show("File not found: " & filePath) End If End If End Sub Considerations for Third-Party Applications Standard Formats: By using DataFormats.FileDrop and a StringCollection of paths, your application adheres to the standard Windows OLE drag-and-drop contract, ensuring compatibility with most third-party applications that support file drops (e.g., Windows Explorer, email clients, specific document management systems). Permissions (UIPI): Be aware of User Interface Privilege Isolation (UIPI). If your VB.NET application is running with Administrator privileges, it will not be able to drag and drop files into a third-party application running as a standard (non-administrator) user (e.g., dragging from an elevated Visual Studio instance to a normal Windows Explorer window). If this is an issue, run both applications at the same privilege level. Programmatic Drop (Advanced): If the target application does not support standard drag-and-drop or you need to automate the "drop" part of the process without user interaction (e.g., navigating to a specific folder within the target app first), this becomes significantly more complex, often requiring Windows API calls (SendMessage, WM_DROPFILES) or UI automation tools, which are beyond basic drag-and-drop functionality. The simple DoDragDrop method handles the initiation of the drag, but the target controls the drop Re: Need help dragging File FROM ListView to Explorer (and other places) Use the listview mousedown event. If the left button is held down and you have files selected, use Code: listviewname.dodragdrop(dataformats.filedrop, new string() {“file1.extâ€, etc}) The dataformats and the string array of filenames are the important parts. Windows explorer will recognise your files. All of your previous code was what you’d use to enable dropping in your listview. You might want to keep your listview’s allowdrop property, and handle dragover, so you can see that something is being dragged above your listview. Don’t handle the dragdrop event if you don’t want files dropped in your listview ================================= Private Sub ListView1_DragDrop1(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles ListView1.DragDrop If e.Data.GetDataPresent(DataFormats.FileDrop) Then Dim MyFiles() As String Dim i As Integer ' Assign the files to an array. MyFiles = e.Data.GetData(DataFormats.FileDrop) ' Loop through the array and add the files to the list. For i = 0 To MyFiles.Length - 1 Dim lvitem As New ListViewItem lvitem.Text = System.IO.Path.GetFileNameWithoutExtension(MyFiles(i)) 'File Name "Notepad" lvitem.SubItems.Add(My.Computer.FileSystem.GetFileInfo(MyFiles(i)).Extension) 'Just the extension, soon to be type lvitem.SubItems.Add(((My.Computer.FileSystem.GetFileInfo(MyFiles(i)).Length) / 1000) & " KB") 'File Size e.g. "2,400KB" lvitem.SubItems.Add(My.Computer.FileSystem.GetFileInfo(MyFiles(i)).DirectoryName) 'Path ListView1.Items.Add(lvitem) Next End If End Sub 3rd party To programmatically simulate a drag-and-drop operation in VB.NET, where files are dropped into a third-party application, you can use the DoDragDrop method in combination with the Windows API for more advanced scenarios. Below is an example of how you can achieve this: Example: Drag and Drop Files to a Third-Party Application Imports System.Runtime.InteropServices Imports System.Windows.Forms Public Class DragDropHelper Private Shared Function FindWindow(lpClassName As String, lpWindowName As String) As IntPtr End Function Private Shared Function SendMessage(hWnd As IntPtr, Msg As Integer, wParam As IntPtr, lParam As IntPtr) As IntPtr End Function Private Const WM_DROPFILES As Integer = &H233 Public Shared Sub DragAndDropFile(filePath As String, targetWindowTitle As String) ' Find the target window by its title Dim targetWindowHandle As IntPtr = FindWindow(Nothing, targetWindowTitle) If targetWindowHandle = IntPtr.Zero Then MessageBox.Show("Target application window not found.") Return End If ' Create a DataObject containing the file path Dim dataObject As New DataObject(DataFormats.FileDrop, New String() {filePath}) ' Simulate the drag-and-drop operation Clipboard.SetDataObject(dataObject, True) SendMessage(targetWindowHandle, WM_DROPFILES, IntPtr.Zero, IntPtr.Zero) End Sub End Class Another example using file explorer Private Sub Form1_MouseDown(sender As Object, e As MouseEventArgs) Handles Me.MouseDown Dim data As New DataObject() Dim filePaths As New StringCollection filePaths.Add(Path.Combine(Application.StartupPath, "TestData.txt")) data.SetFileDropList(filePaths) DoDragDrop(data, DragDropEffects.Copy) End Sub Vb.net 1 01/03/2026 _Misc Software Customizing Setting NMEA Settings 1200 Monitor 1200 20/20 NMEA Linking 20/20 1200 MONITOR NMEAS SETTINGS 1. press the 3 square-4 square button top 2. Click on GNS position output settings 3.click on configuration. you can add a new profile here we called our 2025 4. Our guy had us turn port 2 on set baud rate 38400 5. Next turn the CGA->on, RMC->on, VTG->on 6. Click on each of the + signs and set each value to 5hz _Misc Software 0 04/09/2025 Vb.net Controls DoEvents In .NET doevents Developer 18 Application.DoEvents() Vb.net 0 12/14/2023 Css Formatting Bullets And Numbering bullets li ul ol 5.6.3 'list-style-type' Value: disc | circle | square | decimal | lower-roman | upper-roman | lower-alpha | upper-alpha | none Initial: disc Applies to: elements with 'display' value 'list-item' Inherited: yes Percentage values: N/A This property is used to determine the appearance of the list-item marker if 'list-style-image' is 'none' or if the image pointed to by the URL cannot be displayed. OL { list-style-type: decimal } /* 1 2 3 4 5 etc. */ OL { list-style-type: lower-alpha } /* a b c d e etc. */ OL { list-style-type: lower-roman } /* i ii iii iv v etc. */ 5.6.4 'list-style-image' Value: | none Initial: none Applies to: elements with 'display' value 'list-item' Inherited: yes Percentage values: N/A This property sets the image that will be used as the list-item marker. When the image is available it will replace the marker set with the 'list-style-type' marker. UL { list-style-image: url(http://png.com/ellipse.png) } 5.6.5 'list-style-position' Value: inside | outside Initial: outside Applies to: elements with 'display' value 'list-item' Inherited: yes Percentage values: N/A The value of 'list-style-position' determines how the list-item marker is drawn with regard to the content. For a formatting example see section 4.1.3. 5.6.6 'list-style' Value: [disc | circle | square | decimal | lower-roman | upper-roman | lower-alpha | upper-alpha | none] || [inside | outside] || [ | none] Initial: not defined for shorthand properties Applies to: elements with 'display' value 'list-item' Inherited: yes Percentage values: N/A The 'list-style' property is a shorthand notation for setting the three properties 'list-style-type', 'list-style-image' and 'list-style-position' at the same place in the style sheet. UL { list-style: upper-roman inside } UL UL { list-style: circle outside } LI.square { list-style: square } Setting 'list-style' directly on 'LI' elements can have unexpected results. Consider: level 1 level 2 Since the specificity (as defined in the cascading order) is higher for the first rule in the style sheet in the example above, it will override the second rule on all 'LI' elements and only 'lower-alpha' list styles will be used. It is therefore recommended to set 'list-style' only on the list type elements: OL.alpha { list-style: lower-alpha } UL { list-style: disc } In the above example, inheritance will transfer the 'list-style' values from 'OL' and 'UL' elements to 'LI' elements. A URL value can be combined with any other value: UL { list-style: url(http://png.com/ellipse.png) disc } In the example above, the 'disc' will be used when the image is unavailable. Css 2134 09/09/2023 _Misc Software Ini Creating A .user.ini File For Linux user ini Developer ; cPanel-generated php ini directives, do not edit ; Manual editing of this file may result in unexpected behavior. ; To make changes to this file, use the cPanel MultiPHP INI Editor (Home >> Software >> MultiPHP INI Editor) ; For more information, read our documentation (https://go.cpanel.net/EA4ModifyINI) [PHP] display_errors = Off max_execution_time = 600 max_input_time = 600 max_input_vars = 5000 memory_limit = 512M post_max_size = 516M session.gc_maxlifetime = 1440 session.save_path = "/var/cpanel/php/sessions/ea-php81" upload_max_filesize = 512M zlib.output_compression = Off _Misc Software 0 05/04/2025 Javascript Form Input - First Caps capital first onblur Javascript 1596 09/09/2023 VBscript Function Open An Application Like Notepad And File Using Your Browser load application PhpScript INI WSFTP INI ftpClient INI CopyFiles INI Macromedia INI VBscript 1547 09/09/2023 Javascript Archive Gps Google Map Copy gps Google Map Calculations Backup Latitude and Longitude of a Point Steves Farms - Pick Field Get the Latitude and Longitude of a Point When you click on the map, move the marker or enter an address the latitude and longitude coordinates of the point are inserted in the boxes below. onclick="showLatLong(, );" LongitudeLatitude Slope: Intercept= LatitudeLongitudeBearingDistanceGPS Points hpHeckman hpHill HpLake hpNorth hpSheep hpSwest hpTopMid sparky ghetto Access points None sev05A sev05B sev06A sev06B sev07 sev08 sev09 sev10 Access points DegreesMinutesSeconds Latitude: Longitude: Show Point from Latitude and Longitude Use this if you know the latitude and longitude coordinates of a point and want to see where on the map the point is. Use: + for N Lat or E Long - for S Lat or W Long.Example: +40.689060 -74.044636Note: Your entry should not have any embedded spaces. Decimal Deg. Latitude: Decimal Deg. Longitude: Example: +34 40 50.12 for 34N 40' 50.12" DegreesMinutesSeconds Latitude: Longitude: Javascript 1 02/20/2026 Javascript Object .select(); Clipboard Clipboard object of document.getElementById().select; Click on the button to copy the text from the text field. Try to paste the text (e.g. ctrl+v) afterwards in a different window, to see the effect. Copy text Dim dbs As Database Dim rs As Recordset Dim strSQL As String Set dbs = CurrentDb strSQL = 'your query here Set rs = dbs.OpenRecordset(strSQL) If Not (rs.EOF And rs.BOF) Then rs.MoveFirst 'get results using rs.Fields() Else 'Use results rs.MoveFirst Do While Not rs.EOF 'do something like rs("SomeFieldName") rs.MoveNext Loop DoCmd.SetWarnings False DoCmd.RunSQL "DELETE * FROM NameOfTable" DoCmd.SetWarnings True Sub InsertIntoX2() Dim dbs As Database ' Modify this line to include the path to Northwind ' on your computer. Set dbs = OpenDatabase("Northwind.mdb") ' Create a new record in the Employees table. The ' first name is Harry, the last name is Washington, ' and the job title is Trainee. dbs.Execute " INSERT INTO Employees " _ & "(FirstName,LastName, Title) VALUES " _ & "('Harry', 'Washington', 'Trainee');" dbs.Close End Sub Javascript 0 07/29/2022 WP Database Database Access database WP 2 09/09/2023 Php Function Protecting Passwords Encrypt Decrypt security password Security Code App $qu=new mysqli_swd();$sql="SELECT loginid,username,password FROM loginInfo";$qu->dbsql($sql); $ciphering = "AES-128-CTR";$iv_length = openssl_cipher_iv_length($ciphering);$options = 0;$encryption_iv = '1234567891011121'; $encryption_key = SWD_KEY; if(SWD_KEY!="JesusIsLord"){ECHO "SHIT";EXIT;} for($i=1;$i<=$qu->num;$i++){ $row=$qu->dbRow($qu->data); $username=addslashes(openssl_encrypt($row[1], $ciphering,$encryption_key, $options, $encryption_iv)); $password= addslashes(openssl_encrypt($row[2], $ciphering,$encryption_key, $options, $encryption_iv)); $sql="UPDATE loginInfo SET username='$username',password='$password' WHERE loginid=".$row[0];$r->dbsql($sql); } exit; Php 3 02/22/2024 Php Files Activate75.php activate security Developer //require_once($_SERVER['DOCUMENT_ROOT']."/activate75.php"); if($bypass!=true){ $appid="636390303046554890"; $user='softwax3_build99';$password='Web2Build.now';$database='softwax3_SoftwareUsers'; $connection = swd_mysql("localhost", $user,$password,$database); //if($appid>"636390303046554897"){$qu=new mysqli_swd();}else{$qu=new dbase();} $qu=new mysqli_swd(); $sql="SELECT lock_device,security_level FROM users WHERE device_name='".$_COOKIE["machine_id"]."'"; $qu->dbsql($sql); if($qu->num==0 || $qu->data1[0]==1) { echo "You are locked out";exit; } $_SESSION['LEVEL']=$qu->data1[1]; $LEVEL=$qu->data1[1]; define('SWD_AUTHENTICATE', true);define('SWD_KEY', 'JesusIsLord'); } if($bypass==true){define('SWD_AUTHENTICATE', true);} ?> Php 0 05/11/2025 Php Formatting Remove Ascii > 127 ascii remove delete String Cleanup Php 0 03/07/2024 Php Variables Using Arrays array "35","Ben"=>"37","Joe"=>"43"); arsort($age); ?> Definition and Usage The arsort() function sorts an associative array in descending order, according to the value. Tip: Use the asort() function to sort an associative array in ascending order, according to the value. Tip: Use the krsort() function to sort an associative array in descending order, according to the key. Syntax arsort(array, sorttype) Parameter Values Parameter Description array Required. Specifies the array to sort sorttype Optional. Specifies how to compare the array elements/items. Possible values: 0 = SORT_REGULAR - Default. Compare items normally (don't change types) 1 = SORT_NUMERIC - Compare items numerically 2 = SORT_STRING - Compare items as strings 3 = SORT_LOCALE_STRING - Compare items as strings, based on current locale 4 = SORT_NATURAL - Compare items as strings using natural ordering 5 = SORT_FLAG_CASE - ?> Php 2 09/09/2023 Php Files Download Files While Changing Name download header $filename = "theDownloadedFileIsCalledThis.mp3"; $myFile = "/absolute/path/to/my/file.mp3"; $mm_type="application/octet-stream"; header("Cache-Control: public, must-revalidate"); header("Pragma: hack"); // WTF? oh well, it works... header("Content-Type: " . $mm_type); header("Content-Length: " .(string)(filesize($myFile)) ); header('Content-Disposition: attachment; filename="'.$filename.'"'); header("Content-Transfer-Encoding: binaryn"); readfile($myFile); Php 1402 09/09/2023 Php Formatting Strip Html Tags strip html Library $text = 'Test paragraph. Other text'; echo strip_tags($text); echo "n"; // Allow and echo strip_tags($text, ''); // as of PHP 7.4.0 the line above can be written as: // echo strip_tags($text, ['p', 'a']); ?> The strip_tags() function strips a string from HTML, XML, and PHP tags. Note: HTML comments are always stripped. This cannot be changed with the allow parameter. Note: This function is binary-safe. Syntax strip_tags(string,allow) Parameter Values Parameter Description string Required. Specifies the string to check allow Optional. Specifies allowable tags. These tags will not be removed Technical Details Return Value: Returns the stripped string Example Strip the string from HTML tags, but allow <b> tags to be used: <?php echo strip_tags("Hello <b><i>world!</i></b>","<b>"); ?> Php 4 09/09/2023 Php Files Create Directory File List After Database Backup file list database backup example Backup Sites %s', escapeshellarg($host), escapeshellarg($user), escapeshellarg($pass), escapeshellarg($dbname), escapeshellarg($filename) ); $output = []; $result_code = 0; // Execute the command exec($command, $output, $result_code); if ($result_code === 0) { return "Database dump successful."; } else { return "Error creating database dump. Command output: " . implode("n", $output); } } // Configuration variables //$server='localhost';$user='softwax3_Steve99';$password='pay99.bill';$database='softwax3_accounting'; $DBHOST = $server; $DBUSER = $user; $DBPASS = $password; $DBNAME = $database; $BACKUP_FILE = 'backup_'.$database. date('Y-m-d_H-i-s') . '.sql'; // Run the backup function $message = backup_mysql_database($DBHOST, $DBUSER, $DBPASS, $DBNAME, $BACKUP_FILE); echo $message; $newname=str_replace(".sql",".txt",$BACKUP_FILE); rename($BACKUP_FILE, $newname); $current_dir="./"; $dir = opendir($current_dir); echo "directory=".$current_dir; while ($file = readdir($dir)){ $fullpath=$current_dir.$file; $filedate=date('Y-m-j', filemtime($fullpath)); $fsize=filesize($fullpath)/1000; $fsize=(int)$fsize;$fsize=$fsize/1000; $bulletin[]=$file."@".$fsize."@".$filedate; } closedir($dir); $count1=count($bulletin); sort($bulletin); reset($bulletin); //if($DI=='')ECHO "?DI="; $dis.="Files(by Name)"; //while (list ($key, $val) = each ($bulletin)){ foreach($bulletin as $key=>$val) { //} while (list ($key, $val) = each ($bulletin)){ $mark=explode('@',$val); $count+=1; if($mark[0]=="index.php")continue; if(strpos($mark[0],".")==0) $dis.="".$mark[0]."Directory"; else $dis.="".$mark[0]."(".$mark[1].") MB ".$mark[2].""; //if($count==(int)($count1/2)) echo " "; } $dis.=""; echo $dis; ?> Php 0 12/19/2025 Php Formatting Physically Resize An Image resize image /* * File: SimpleImage.php * Author: Simon Jarvis * Copyright: 2006 Simon Jarvis * Date: 08/11/06 * Link: http://www.white-hat-web-design.co.uk/articles/php-image-resizing.php * * This program is free software; you can redistribute it and/or * modify it under the terms of the GNU General Public License * as published by the Free Software Foundation; either version 2 * of the License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details: * http://www.gnu.org/licenses/gpl.html * */ class SimpleImage { var $image; var $image_type; function load($filename) { $image_info = getimagesize($filename); $this->image_type = $image_info[2]; if( $this->image_type == IMAGETYPE_JPEG ) { $this->image = imagecreatefromjpeg($filename); } elseif( $this->image_type == IMAGETYPE_GIF ) { $this->image = imagecreatefromgif($filename); } elseif( $this->image_type == IMAGETYPE_PNG ) { $this->image = imagecreatefrompng($filename); } } function save($filename, $image_type=IMAGETYPE_JPEG, $compression=75, $permissions=null) { if( $image_type == IMAGETYPE_JPEG ) { imagejpeg($this->image,$filename,$compression); } elseif( $image_type == IMAGETYPE_GIF ) { imagegif($this->image,$filename); } elseif( $image_type == IMAGETYPE_PNG ) { imagepng($this->image,$filename); } if( $permissions != null) { chmod($filename,$permissions); } } function output($image_type=IMAGETYPE_JPEG) { if( $image_type == IMAGETYPE_JPEG ) { imagejpeg($this->image); } elseif( $image_type == IMAGETYPE_GIF ) { imagegif($this->image); } elseif( $image_type == IMAGETYPE_PNG ) { imagepng($this->image); } } function getWidth() { return imagesx($this->image); } function getHeight() { return imagesy($this->image); } function resizeToHeight($height) { $ratio = $height / $this->getHeight(); $width = $this->getWidth() * $ratio; $this->resize($width,$height); } function resizeToWidth($width) { $ratio = $width / $this->getWidth(); $height = $this->getheight() * $ratio; $this->resize($width,$height); } function scale($scale) { $width = $this->getWidth() * $scale/100; $height = $this->getheight() * $scale/100; $this->resize($width,$height); } function resize($width,$height) { $new_image = imagecreatetruecolor($width, $height); imagecopyresampled($new_image, $this->image, 0, 0, 0, 0, $width, $height, $this->getWidth(), $this->getHeight()); $this->image = $new_image; } } ?> ============ Save the above file as SimpleImage.php and take a look at the following examples of how to use the script. The first example below will load a file named picture.jpg resize it to 250 pixels wide and 400 pixels high and resave it as picture2.jpg include('SimpleImage.php'); $image = new SimpleImage(); $image->load('picture.jpg'); $image->resize(250,400); $image->save('picture2.jpg'); ?> If you want to resize to a specifed width but keep the dimensions ratio the same then the script can work out the required height for you, just use the resizeToWidth function. include('SimpleImage.php'); $image = new SimpleImage(); $image->load('picture.jpg'); $image->resizeToWidth(250); $image->save('picture2.jpg'); ?> You may wish to scale an image to a specified percentage like the following which will resize the image to 50% of its original width and height include('SimpleImage.php'); $image = new SimpleImage(); $image->load('picture.jpg'); $image->scale(50); $image->save('picture2.jpg'); ?> You can of course do more than one thing at once. The following example will create two new images with heights of 200 pixels and 500 pixels include('SimpleImage.php'); $image = new SimpleImage(); $image->load('picture.jpg'); $image->resizeToHeight(500); $image->save('picture2.jpg'); $image->resizeToHeight(200); $image->save('picture3.jpg'); ?> The output function lets you output the image straight to the browser without having to save the file. Its useful for on the fly thumbnail generation header('Content-Type: image/jpeg'); include('SimpleImage.php'); $image = new SimpleImage(); $image->load('picture.jpg'); $image->resizeToWidth(150); $image->output(); ?> The following example will resize and save an image which has been uploaded via a form if( isset($_POST['submit']) ) { include('SimpleImage.php'); $image = new SimpleImage(); $image->load($_FILES['uploaded_image']['tmp_name']); $image->resizeToWidth(150); $image->output(); } else { ?> } ?> Php 1189 09/09/2023 WP Plugin Plug-in Scriptures show table of records Custom dbh; $table='';$terms='';$where="";$AND='WHERE'; $orderby="ORDER BY dateof DESC"; //>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> $pageLevel=3;$bypass=true;$varView="https://jesusovergangs.com/demo/"; $savedPosts=array(); $savedGets=array(); $_POST['resetSM']=isset($_POST['resetSM'])?$_POST['resetSM']:''; if($_POST['resetSM']!=""){ foreach($_SESSION as $k=>$value) { unset($_SESSION[$k]); } foreach($_GET as $k=>$value) { unset($_GET[$k]); } foreach($_POST as $k=>$value) { unset($_POST[$k]); } } else { $savedPosts= json_decode(stripslashes($_SESSION["jsonPost"]),JSON_OBJECT_AS_ARRAY); $savedGets= json_decode(stripslashes($_SESSION["jsonGet"]),JSON_OBJECT_AS_ARRAY); } ///echo $savedPosts["SEARCH"]."=============".$_POST['SEARCH']; print_r ($savedPosts); $_POST['value']=isset($_POST['value']) ? $_POST['value'] : ''; $_GET['RESET']=isset($_GET['RESET']) ? $_GET['RESET'] : ''; $_GET['prn']=isset($_GET['prn'])?$_GET['prn']:''; $_GET['BACK']=isset($_GET['BACK'])?$_GET['BACK']:''; $_POST['inside_search']=isset($_POST['inside_search'])?$_POST['inside_search']:$savedPosts['inside_search']; if($_POST['inside_search']=="on"){ $checked1="checked"; $anywhere="%"; } $_GET['URL']=isset($_GET['URL'])?$_GET['URL']:''; $_POST['BUTTON']=isset($_POST['BUTTON'])?$_POST['BUTTON']:''; $_POST['SEARCH']=isset($_POST['SEARCH'])?$_POST['SEARCH']:$savedPosts["SEARCH"]; $search1= $_POST['SEARCH']; $_POST['updaterecord1']=isset($_POST['updaterecord1'])?$_POST['updaterecord1']:$savedPosts["updaterecord1"]; $FID1=$_POST['updaterecord1']; $_POST['resetLG']=isset($_POST['resetLG'])?$_POST['resetLG']:''; $_REQUEST['txWhere']=isset($_REQUEST['txWhere'])?$_REQUEST['txWhere']:''; $txWhere=$_REQUEST["txWhere"]; $_REQUEST['txOrderby']=isset($_REQUEST['txOrderby'])?$_REQUEST['txOrderby']:$savedPosts["txOrderby"]; $txOrderby= htmlspecialchars($_REQUEST['txOrderby'],ENT_QUOTES); //echo">>>>".$txOrderby; $ALL=isset($_GET['ALL'])?$_GET['ALL']:''; $_GET['MULTINPUT']=isset($_GET['MULTINPUT'])?$_GET['MULTINPUT']:''; $_GET['PDS_']=isset($_GET['PDS_'])?$_GET['PDS_']:''; $_GET['PDS_KILL']=isset($_GET['PDS_KILL'])?$_GET['PDS_KILL']:''; $_GET['INX']=isset($_GET['INX'])?$_GET['INX']:$savedGets['INX']; $INX=$_GET['INX']; $_GET['VIEW']=isset($_GET['VIEW'])?$_GET['VIEW']:''; $_GET['NUM']=isset($_GET['NUM'])?$_GET['NUM']:''; $_GET['ALPHA']=isset($_GET['ALPHA'])?$_GET['ALPHA']:''; $_GET['SB']=isset($_GET['SB'])?$_GET['SB']:''; $_GET['report']=isset($_GET['report'])?$_GET['report']:''; $part['query']=isset($part['query'])?$part['query']:''; $part['fragment']=isset($part['fragment'])?$part['fragment']:''; $prn=$_GET["prn"]; $_SESSION['INSIDE']=isset($_SESSION['INSIDE'])?$_SESSION['INSIDE']:''; //$_SESSION['MULTINPUT']=isset($_SESSION['MULTINPUT'])?$_SESSION['MULTINPUT']:'';$_SESSION['MULIUPDATEFIELD']=isset($_SESSION['MULIUPDATEFIELD'])?$_SESSION['MULIUPDATEFIELD']:''; $_SESSION['TABLENAME']=isset($_SESSION['TABLENAME']) ? $_SESSION['TABLENAME'] : ''; $_SESSION['PDS_SAVE']=isset($_SESSION['PDS_SAVE'])?$_SESSION['PDS_SAVE']:''; $_SESSION['SORTBY']=isset($_SESSION['SORTBY'])?$_SESSION['SORTBY']:''; $_SESSION['FIELDSAVE']=isset($_SESSION['FIELDSAVE'])?$_SESSION['FIELDSAVE']:''; $_SESSION['SEARCHSAVE']=isset($_SESSION['SEARCHSAVE'])?$_SESSION['SEARCHSAVE']:''; $_SESSION['URLSAVE']=isset($_SESSION['URLSAVE'])?$_SESSION['URLSAVE']:''; $ALPHA=$_GET['ALPHA']; if($ALPHA!=''){ $_SESSION['ALPHA_SAVE']=$ALPHA; } ELSE $ALPHA=$_SESSION['ALPHA_SAVE']; if($_POST["SEARCH"]!=""){$_SESSION['ALPHA_SAVE']="";$ALPHA="";} if($txWhere!="") {$whereCondition=$AND.$txWhere; $AND=" AND ";} if($ALPHA!=""){$whereAlpha="$AND $FID1 LIKE '$ALPHA%'";$AND=" AND ";} //store data for restart //echo $jsonSess = json_encode($_SESSION); $_SESSION["jsonPost"]= json_encode($_POST); $_SESSION["jsonGet"]= json_encode($_GET); $dis.=""; $dis1='';$dis.=""; $dis.="$dis1"; if($LEVEL>3){$dis.="";}else {$dis.="";} $title1="n "; //vb.net comboSearchFields function start $selectme=array();$ftitle=explode(".",$FID1); $selectme[$ftitle[1]]="selected"; $title1.="dateofn"; $title1.="commentn"; // `Report Search Fields` $title1.="n"; $dis.=$title1; // `Report Search2` $dis.="Look Inside Data Conditions:Order: "; // `Report Start Task` $dis.="n"; function CreateLinks($inx,$num,$range){ global $ALPHA; global $VIEW;global $txWhere; $ratio=(int)($num/$range);$start=1;$maxlinks=30; if($ratio<$num/$range)$ratio+=1; $end=$ratio; if($ratio>$maxlinks){ $start=$inx/$range-$maxlinks/2; if($start<1)$start=1; $end=$start+$maxlinks; if($end>$ratio){ $end=$ratio;$start=$end-$maxlinks; } } for($i=$start;$i<=$end;$i++){ switch($VIEW){ case 2: $submenu.="$i |"; break; default: $submenu.="$i |"; } } $dis1.=$submenu; return $dis1; } //Form variables on update $maxrec=20; $whereInnerjoin="";$whereSearch="";$AND=" WHERE "; $table='';$terms='';$where=""; $orderby=" ORDER BY dateof DESC"; if($txOrderby!="")$orderby=" ORDER BY ".$txOrderby; //global $wbdb; $connection=$wbdb->dbh; $whereInnerjoin="";$whereCondition="";$whereAlpha="";$whereSearch="";$AND="WHERE "; $table='';$terms='';$where="";$AND='WHERE '; $t0="scripture_comment";$tables.="$t0";$r=new mysqli_swd(); $terms.="$t0.commentid,$t0.dateof,$t0.comment,$t0.caregoryid"; if($search1!=''){ $sec1=substr($search1,0,1); if($sec1=="<" || $sec1==">"){ $search1=substr($search1,1,strlen($search1)-1); switch($sec1){ case "<": $whereSearch.=$AND.$FID1." <= '$search1'";$AND=' AND ';break; case ">": $whereSearch.=$AND.$FID1." >= '$search1'";$AND=' AND ';break; } } else { $whereSearch.=$AND.$FID1." LIKE '".$anywhere.$search1."%'"; $AND=' AND '; } } if(function_exists("global_search_filter")){ $whereSearch.=global_search_filter($t0); } // `Report Terms` $innerjoin="SELECT $terms FROM $tables ".$whereInnerjoin.$whereSearch.$txWhere.$orderby; $NUM=$r->num; //asss // `Sql Where` MODIFY VARIOUS WHERE'S // echo $innerjoin."".$countrecs.""; $cancel==false; //CREATE ORDER BY if($NUM>$maxrec && $report=='') echo CreateLinks($INX,$NUM,$maxrec); // `Sql Where` MODIFY VARIOUS WHERE'S $cancel==false; //CREATE ORDER BY if($SB=="``"){ $SB=$_SESSION["SORTBY"]; }else{ if($_SESSION["SORTBY"]==$SB)$SB=$SB." DESC"; $_SESSION["SORTBY"]=$SB; } $cancel==false; // `Sql Report` 1st Custom Changes to SQL [$t?,$table,$where,$whereAlpha,$whereSearch,$orderby] & Back?RETID= if($SB=="``" || $SB=="")$sort="`dateof` DESC".$txOrderby; //include txtbox order by else{ $sort=$SB.$txOrderby; } //Prepare multiple column sort. if(gettype($sortColumn)=='array'){ for($ii=1;$ii<=count($sortColumn);$ii++){ if(strpos("|".$sort,stripDESC($sortColumn[$ii]))==0) $sort.=",".$sortColumn[$ii]; } } // `Sort Report Header Links` $orderby=" ORDER BY $sort"; //$_SESSION["SORTBY"]=$sort; // `Sql Where` append to innerjoin // `Sort Report Header Links` if($INX=="")$INX=0; $query=$innerjoin; $r->dbsql($query);$result=$r->data;$NUM=$r->num; if($NUM>$maxrec){ $dis.= CreateLinks($INX,$NUM,$maxrec); $query=$innerjoin." LIMIT ".$INX.",".$maxrec; }else{ $query=$innerjoin; } //$countrecs="SELECT count(commentid) FROM innerjoin"; $query2=$countrecs; //END DESIGN CODE //$innerjoin="SELECT $terms FROM $tables $where"; $grouping=false; $r->dbsql($query);$result=$r->data;$num=$r->num; $disTitle="Dateof Comment"; //if($grouping==true)echo "$disTitle";else echo "".$disTitle; rem line in vb $cnt=0;// =============== START PRINTING VALUES =========== $dis.="".$disTitle; // add line in vb for($i=1;$i<=$num;$i++){ $row=$r->dbRow($result); $defaultField='One of these fields listed below'; $commentid=$row['commentid']; $dateof=$row['dateof']; $dateof=convertmdy($dateof); $comment=$row['comment']; $comment=ShortenString($comment); $caregoryid=$row['caregoryid']; // `Report Format` //Create Totals Here $cnt++;//manually assign the defaultField varaible from extracted terms. if($lastfield!=$defaultField && $grouping==true){ $dis.="n"; $dis.="$defaultField $disTitlen"; $lastfield=$defaultField; } if($class=='')$class='class=alt'; else $class=''; $cnt++;$dis.="n"; $dis.="$dateof $comment"; //$dis.=" $commentid $dateof $comment $caregoryid"; $dis.=""; //Generate Totals Here } return $dis.""; } include("WPfunctions.php"); add_shortcode("shit", "Scriptures"); ?> WP Plugin 1 12/22/2022 WP Plugin Plug-in Keep Colorado Free wordpress admin plugin shortcode membership form Custom dbh; function MemberCheck($atts){ global $wpdb; global $appid;global $connection; //print_r ($atts);exit; $dis= $_COOKIE["Member"]; //if($dis!="true"){ header("Location:https://www.keepcofree.com/member-login/");exit; } if(substr($dis,0,4)!="true" || $dis=="true"){ ?>dbsql($sql); if($atts["level"]==1)return; if($atts["level"]==2 && $r->data1["paid"]==0){ ?> WP Plugin 3 12/22/2022 WP Files WPfunctions.php function mysql plugin quickarray=$value;return true; } function tableOption($query){ global $connection; $q = mysqli_query($connection,$query); //mysql_query($query); $num_fields = mysqli_num_fields($q); for($ii = 0; $ii < $num_fields; $ii++) { //$result.= mysql_field_name($query,$ii)."-".mysql_field_type($query,$ii)."(".mysql_field_len($query,$ii).")".mysql_field_flags($query,$ii)."n"; $fieldinfo=mysqli_field_flags($q,$ii); if(strpos($fieldinfo,"rimary_key")>0){ $this->fieldname=mysql_field_name($q,$ii);break; } } } function dbRow($result){ return mysqli_fetch_array($result,MYSQLI_BOTH); //,MYSQLI_BOTH } function dbTable($result,$k){ $table_info = mysqli_fetch_field_direct($result, $k); //print_r($table_info);echo""; $this->fieldlength = $table_info->max_length; $this->fieldname = $table_info->name; $this->fieldtable = $table_info->table; $this->fieldtype = $table_info->type; $this->fieldflag = $table_info->flags; } function dbsql2($query){ $this->insertoption=$query; } function dbsql($query){ global $db; global $dc;global $debug; global $appid; global $connection; global $wpdb; // $result=mysqli_query($connection,$query); // or die(mysqli_error().' from '.$query); //;mysql_query($query) $result=mysqli_query($wpdb->dbh,$query); if(!$result){ if($debug==true){ echo "Error:".$query;exit; }else{ echo "Error:".substr($query,0,1000);exit;} } $sql= strtolower($query); if(strpos($sql,"nsert into")==1)$AC=1; if(strpos($sql,"elect")==1){ $AC=2;$this->num=mysqli_num_rows($result); } if(strpos($sql,"pdate")==1 || strpos($sql,"elete")==1)$AC=3; switch($AC){ case 1: $this->id=mysqli_insert_id($connection); break; case 2: if($this->num==0 && $this->insertoption!=""){ $this->dbq($this->insertoption); return false; } if($this->num==0) return false; if($appid!=""){ $this->data1=mysqli_fetch_array($result,MYSQLI_BOTH);mysqli_data_seek($result,0); //mysql_data_seek($result,0); $this->data=$result; }else{ if($this->num==1 && $this->quickarray==true)$this->data=mysqli_fetch_array($result,MYSQLI_BOTH); //mysql_fetch_array($result); else $this->data=$result; } $this->fields = mysqli_num_fields($result); return true; break; case 3: return true; break; } // end switch } } // end class function sizepicture($picture,$maxwidth,$maxheight){ list($width, $height, $type, $attr) = getimagesize($picture); if($width==0)$width=1;if($height==0)$height=1; $size[2]=$width;$size[3]=$height; $hratio=$height/$maxheight; $wratio=$width/$maxwidth; if ($wratio>$hratio){ $ratio=$width/$height; if($width>$maxwidth){ $height=(int)($maxwidth/$ratio);$width=$maxwidth; } }else{ $ratio=$height/$width; if($height>$maxheight){ $width=(int)($maxheight/$ratio);$height=$maxheight; } } $size[0]=$width;$size[1]=$height; return $size; } function replaceForm($longadd){ $longadd=stripslashes($longadd); $longadd=str_replace(chr(160),chr(32),$longadd); $longadd=str_replace("'","'",$longadd); $longadd=str_replace(chr(34),""",$longadd); return $longadd; } function replacePunctuation($longadd){ $longadd=stripslashes($longadd); $longadd=str_replace(chr(160),chr(32),$longadd); return $longadd; } function radiochecked($var,$item){ if($var==$item) return "checked"; else return ""; } function checkboxchecked($value){ if($value==1) return "checked"; else return ""; } function checkhtml($var){ $var2=strip_tags($var); if($var2!=$var){ echo "Mail Server Crashed";exit; } if(strpos("|".$var,"http:")>0){ echo "Mail Server Crashed";exit; } $var=addslashes($var); return $var; } function stripDESC($var1){ $m=strpos($var1,'DESC'); if($m>0)$var1=substr($var1,0,$m-1); return $var1; } function ShortenString($var1){ global $prn; $var1=stripslashes($var1); $var1=str_replace(chr(160),chr(32),$var1); $var1=str_replace(chr(13),'',$var1); if(strlen($var1)>100 && $prn==''){ // $var1=substr($var1,0,40).'....'; //$var1="".$var1.""; } //if($var1=='')$var1='? '; if(strpos($var1,'.location')>0 || strpos($var1,'.href')>0)$var1='spam'; return $var1; } function checkBlanks($value){ if($value!="")return "".$value; else return ""; } function convertmdy($date1){ if($date1==""||$date1=="0000-00-00"){ $date1="";return date("m/d/y"); } $new=strtotime($date1); $date1= date('m/d/Y',$new); return $date1; } function convertmdytime($date1){ if($date1==""||$date1=="0000-00-00"){ $date1="";return $date1; } $time=strtotime($date1); $date1= date('m/d/Y H:i:s',$time); return $date1; } function convertdate($date1){ if($date1=="") return date('Y-m-d'); $date1=str_replace("/","|",$date1); $date1=str_replace("-","|",$date1); $time=explode("|",$date1); if(strlen($time[0])==1) $time[0]="0".$time[0]; if(strlen($time[1])==1) $time[1]="0".$time[1]; $new=trim($time[2])."-".$time[0]."-".$time[1]; $date1= date('Y-m-d',strtotime($new)); return $date1; } function convertdatetime($date1){ if($date1=="") return date("Y-m-d H:i:s"); $date1=str_replace("/","|",$date1);$date1=str_replace(" ","|",$date1);$date1=str_replace(":","|",$date1); $date1=str_replace("-","|",$date1); $time=explode("|",$date1); if(strlen($time[0])==1) $time[0]="0".$time[0]; if(strlen($time[1])==1) $time[1]="0".$time[1]; $date1=trim($time[2])."-".$time[0]."-".$time[1]." ".$time[3].":".$time[4].":".$time[5]; $date1= date('Y-m-d H:i:s',strtotime($date1)); return $date1; } ?> WP 0 07/29/2022 Php Archive Software Web Activation.php reg75 Reg75.php dbsql($sql); $row=$qu->data1; $device_name=isset($row['device_name'])?$row['device_name']:''; $device_name=$device_name; $lock_device=isset($row['lock_device'])?$row['lock_device']:0; $lock_device_=$lock_device; if($_COOKIE["machine_id"]=="")setcookie("machine_id",$device_name,time()+60*60*24*700 ,"/","softwarewebdesign.com"); for($i=1;$i<=7;$i++){ switch($i){ case 1: $server='localhost';$user='softwax3_Steve99';$password='pay99.bill';$database='softwax3_accounting'; break; case 2: $server='localhost';$user='softwax3_Steve99';$password='pay99.bill';$database='softwax3_accountingP';break; case 3: $server='localhost';$user='softwax3_Steve99';$password='pay99.bill';$database='softwax3_cropMap';break; case 4: $server='localhost';$user='softwax3_Steve99';$password='pay99.bill';$database='softwax3_hairShoppe';break; case 5: $server='localhost';$user='softwax3_Steve99';$password='pay99.bill';$database='softwax3_emailAccts';break; case 6: $server='localhost';$user='softwax3_Steve99';$password='pay99.bill';$database='softwax3_invoices';break; case 7: $server='localhost';$user='softwax3_Steve99';$password='pay99.bill';$database='softwax3_Tips';break; default: } //MAKE SURE USER IS IN THE APPLICATIONS ADMIN DATABASE $connection = mysqli_connect($server, $user,$password); mysqli_select_db($connection, $database); //$db = mysql_pconnect($server, $user,$password); mysql_select_db($database); $qu=new mysqli_swd(); $sql="SELECT * FROM useradmin WHERE lastname='$device_name'";$qu->dbsql($sql); if($qu->num==0){ $sql="INSERT INTO `useradmin`(`userid`, `lastname`, `firstname`, `email`, `username`, `password`, `level`, `logintimes`, `lastlogin`, `accesspages`, `ipaddress`, `locked`) VALUES (NULL,'$device_name','fnmae','email1','uname','[passvalue-6]',10,10,'','[value-11]','[value-12]',$lock_device)";$qu->dbsql($sql); } else { $sql="UPDATE `useradmin` SET `lastname`='$device_name',`locked`= $lock_device WHERE lastname='$device_name'"; $qu->dbsql($sql); } } } if($_GET["EM"]==1){ setcookie("machine_id","INACTIVE",time()+60*60*24*700 ,"/","softwarewebdesign.com");header("location:index75.php");exit; } $ID=$_GET["ID"];if($ID=="")$ID=0; $FORM=$_REQUEST['FORM']; $user='softwax3_build99';$password='Web2Build.now';$database='softwax3_SoftwareUsers';// swd 10/23/19 $connection = mysqli_connect($server, $user,$password); mysqli_select_db($connection, $database);// swd 10/23/19 if($FORM==2){ setcookie("machine_id",$_GET["DEVICE"],time()+60*60*24*700 ,"/","softwarewebdesign.com"); header("location:index75.php"); exit; } if($FORM==""){ $FORM=0;$caption99="NEW"; } $appid="1975"; $PID=$_GET['PID']; if($PID>0){ UpdateDbases($PID); header("location:reg75.php"); exit; } //LOAD MASTER USERS DATABASE $qu=new mysqli_swd();$sql="SELECT * FROM users ORDER BY device_name";$qu->dbsql($sql); $result=$qu->data; $varVerify="admin31/usersVerify.php"; $varView="/reg75.php"; ?> users View Not Found The requested URL /reg75.php was not found on this server. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Apache Server at www.softwarewebdesign.com Port 443 Current Users UseridDevice NameDevice TypeLock Device"; for($i=1;$i<=$qu->num;$i++){ //echo $qu->num; $row=$qu->dbRow($result); $userid=isset($row['userid'])?$row['userid']:''; $userid_=$userid; $device_name=isset($row['device_name'])?$row['device_name']:''; $device_name=$device_name; $device_name_=$device_name; $device_type=isset($row['device_type'])?$row['device_type']:''; $device_type_=$device_type; $lock_device=isset($row['lock_device'])?$row['lock_device']:''; $lock_device_=$lock_device; echo" $device_name$device_type"; if($class=='')$class='class=alt'; else $class=''; //if($LEVEL>8)$dis.=""; } echo ""; //if($NUM>$maxrec && $report=='') echo CreateLinks($INX,$NUM,$maxrec); // `End Report` /* if(strpos($_SERVER["SERVER_NAME"],"ww.")!=1 || $_SERVER["HTTPS"]!="on") { header("location:https://www.softwarewebdesign.com/reg75.php"); exit; } setcookie("user_id","GreatOne",time()+60*60*24*700 ,"/","softwarewebdesign.com"); setcookie("password_id","Agriculture",time()+60*60*24*700 ,"/","softwarewebdesign.com"); //if($_POST["machine"]!="")setcookie("machine_id",$_POST["machine"],time()+60*60*24*700 ,"/","softwarewebdesign.com"); header("location:https://www.softwarewebdesign.com/index75.php"); */ $sql="SELECT * FROM users WHERE userid=$ID";$qu->dbsql($sql); $row=$qu->data1; if($qu->num>0)$caption99="Update"; $userid=isset($row['userid'])?$row['userid']:0; $userid_=$userid; $device_name=isset($row['device_name'])?$row['device_name']:''; $device_name=$device_name; $device_name_=$device_name; $device_type=isset($row['device_type'])?$row['device_type']:0; $device_type_=$device_type; $lock_device=isset($row['lock_device'])?$row['lock_device']:0; $lock_device_=$lock_device; ?> Form Users Form Device Name: Device type> Smart Phone > Tablet > Laptop > Desktop Lock Device: > Php 2 01/30/2023 Php Function Deletefile.php delete exist file Backup File Info "; switch($AC){ case 1: if(file_exists($upfile))unlink($upfile); $upfile=str_replace("/thm/","/",$upfile); if(file_exists($upfile))unlink($upfile); echo "File is Deleted. Please close this window"; break; default: if(file_exists($upfile)){ if(file_exists($upfile)){ if(mime_content_type($upfile)=="image/jpeg"){ $dimen=sizepicture($upfile,300,400); echo " "; }else{ echo $upfile.""; } echo "If not, just close this window"; } }else echo "This file does not exist. Close this window."; break; } ?> Php 0 05/18/2025 Php Function SESSION VARIABLES NOT WORKING DEBUG $_SESSION HEMPDBASE " size="20" maxlength="50" required> Php 0 03/02/2024