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 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 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 Vb.net Database Delete A Record From A DAO Recordset delete recordset Sub DeleteDuplicateShippers() Dim dbsNorthwind As DAO.Database Dim rstShippers As DAO.Recordset Dim strSQL As String Dim strName As String On Error GoTo ErrorHandler Set dbsNorthwind = CurrentDb strSQL = "SELECT * FROM Shippers ORDER BY CompanyName, ShipperID" Set rstShippers = dbsNorthwind.OpenRecordset(strSQL, dbOpenDynaset) ' If no records in Shippers table, exit. If rstShippers.EOF Then Exit Sub strName = rstShippers![CompanyName] rstShippers.MoveNext Do Until rstShippers.EOF If rstShippers![CompanyName] = strName Then rstShippers.Delete Else strName = rstShippers![CompanyName] End If rstShippers.MoveNext Loop Exit Sub ErrorHandler: MsgBox "Error #: " & Err.Number & vbCrLf & vbCrLf & Err.Description End Function Vb.net 0 10/09/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 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 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 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 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 Archive Color Change Script color convert javascript step Home Page div {float:left;} ---------------- ---------------- -------------------- ---Test---- R: G: B: Try it yourself: R: G: B:Transfer RGB Color Values Color Hex Code Color Hex Code Color Hex Code Alice blue #F0F8FF Antique white #FAEBD7 Aqua #00FFFF Aquamarine #7FFFD4 Azure #F0FFFF Beige #F5F5DC Bisque #FFE4C4 Black #000000 Blanche dalmond #FFEBCD Blue #0000FF Blue violet #8A2BE2 Brown #A52A2A Burlywood #DEB887 Cadet blue #5F9EA0 Chartreuse #7FFF00 Chocolate #D2691E Coral #FF7F50 Cornflower blue #6495ED Cornsilk #FFF8DC Crimson #DC143C Cyan #00FFFF Dark blue #00008B Dark cyan #008B8B Dark goldenrod #B8860B Dark gray #A9A9A9 Dark green #006400 Dark khaki #BDB76B Dark magenta #8B008B Dark olive green #556B2F Dark orange #FF8C00 Dark orchid #9932CC Dark red #8B0000 Dark salmon #E9967A Dark seagreen #8DBC8F Dark slate blue #483D8B Dark slate gray #2F4F4F Dark turquoise #00DED1 Dark violet #9400D3 Deep pink #FF1493 Deep sky blue #00BFFF Dim gray #696969 Dodger blue #1E90FF Firebrick #B22222 Floral white #FFFAF0 Forest green #228B22 Fuchsia #FF00FF Gainsboro #DCDCDC Ghost white #F8F8FF Gold #FFD700 Goldenrod #DAA520 Gray #808080 Green #008000 Green yellow #ADFF2F Honeydew #F0FFF0 Hot pink #FF69B4 Indian red #CD5C5C Indigo #4B0082 Ivory #FFFFF0 Khaki #F0E68C Lavender #E6E6FA Lavender blush #FFF0F5 Lawngreen #7CFC00 Lemon chiffon #FFFACD Light blue #ADD8E6 Light coral #F08080 Light cyan #E0FFFF Light goldenrod yellow #FAFAD2 Light green #90EE90 Light grey #D3D3D3 Light pink #FFB6C1 Light salmon #FFA07A Light seagreen #20B2AA Light sky blue #87CEFA Light slate gray #778899 Light steel blue #B0C4DE Light yellow #FFFFE0 Lime #00FF00 Lime green #32CD32 Linen #FAF0E6 Magenta #FF00FF Maroon #800000 Medium aquamarine #66CDAA Medium blue #0000CD Medium orchid #BA55D3 Medium purple #9370DB Medium sea green #3CB371 Medium slate blue #7B68EE Medium spring green #00FA9A Medium turquoise #48D1CC Medium violet red #C71585 Midnight blue #191970 Mint cream #F5FFFA Misty rose #FFE4E1 Moccasin #FFE4B5 Navajo white #FFDEAD Navy #000080 Old lace #FDF5E6 Olive drab #6B8E23 Orange #FFA500 Orange red #FF4500 Orchid #DA70D6 Pale goldenrod #EEE8AA Pale green #98FB98 Pale turquoise #AFEEEE Pale violet red #DB7093 Papaya whip #FFEFD5 Peach puff #FFDAB9 Peru #CD853F Pink #FFC8CB Plum #DDA0DD Powder blue #B0E0E6 Purple #800080 Red #FF0000 Rosy brown #BC8F8F Royal blue #4169E1 Saddle brown #8B4513 Salmon #FA8072 Sandy brown #F4A460 Sea green #2E8B57 Sea shell #FFF5EE Sienna #A0522D Silver #C0C0C0 Sky blue #87CEEB Slate blue #6A5ACD Snow #FFFAFA Spring green #00FF7F Steelblue #4682B4 Tan #D2B48C Teal #008080 Thistle #D8BFD8 Tomato #FF6347 Turquoise #40E0D0 Violet #EE82EE Wheat #F5DEB3 White #FFFFFF Whitesmoke #F5F5F5 Yellow #FFFF00 Yellow green #9ACD32 "; Php 7 12/28/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 Browsers Customizing 10 Handy Firefox About:config Hacks firefox configuration fire fox Takeaway: If you really want to fine-tune your Firefox functionality, you have to roll up your sleeves and tinker with the about:config page. Jack Wallen shares some simple hacks to make Firefox work the way you want. Unless you�re a Firefox power user, you may not be familiar with the about:config page. The Firefox about:config page is not so much a page as it is a somewhat hidden configuration section. It�s hidden because it�s fairly powerful and not nearly as simple to use as the standard Preferences window. In the about:config page, you have to know what you are doing or you can mess things up a bit. In fact, when you attempt to go to that page for the first time, you have to accept an agreement (which is really just a warning) before you can continue. How this page works is simple. You reach the page by entering about:config in the address bar. There are entries (one per line) that handle various types of configurations. Each entry has a searchable keyword. The entries can be of Boolean, integer, or string value. Entries contain Name, Status, Type, and Value. Typically, you will be modifying only the Value, by double-clicking on it and making the change. With all of that in mind, let�s take a look at 10 of the best ways you can �hack� the about:config page. Tip If Firefox is fubar�d because you accidentally misconfigured about:config, you can fix it in one of two ways: Make a backup of your prefs.js file before you start editing. Then, if something goes wrong, you can restore it by copying it over the corrupt file. If you can�t restore via a backup prefs.js file, you can exit Firefox and issue the command firefox -safe-mode to bring up the Firefox Safe Mode screen. Then, just select Reset All User Preferences To Firefox Defaults. Note: This will restore all user preferences to their default values. 1: Speed up Firefox This hack requires a few steps. Search for pipelining in the filter and you should see: network.http.pipelining: Change this to true. network.http.proxy.pipelining: Change this to true. network.http.pipelining.maxrequests: Change this to 8. Now search for max-connections and you should see: network.http.max-connections: Change this to 96. network.http.max-connections-per-server: Change this to 32. 2: Disable antivirus scanning This is only for the Windows version. If you�re downloading large files, this scanning can seriously slow things down. And since you will most likely scan the downloaded file anyway, you�ll probably want to disable this. Of course, if you are uber paranoid (not a bad trait for computing), you might want to leave this entry alone. To disable antivirus scanning, search for scanWhenDone and you should see: browser.download.manager.scanWhenDone: Change this to false. 3: Open Javascript popups as tabs If a popup window lacks the features of a browser window, Firefox will handle it like a popup. If you would prefer to open all windows, including popups, as new tabs, you need to tell Firefox in about:config. Search for newwindow and you will see three entries. Of those three entries, you will want to modify: browser.link.open_newwindow.restriction: Change this to 0. 4: Spell checking in all fields By default, Firefox checks spelling only in multiple-line text boxes. You can set it to check spelling in all text boxes. Search for spellcheckdefault and you should see: layout.spellcheckDefault: Change this to 2. 5: Open search bar results in new tab When you use the search bar, the results display in the current tab. This can be a nuisance because you will navigate out of the page you are currently in. To make sure Firefox always opens search results in a new tab, search for openintab and you should see: browser.search.openintab: Change this to true. 6: Auto export bookmarks In Firefox 3, bookmarks are automatically saved and exported for you. The only problem is that by default, they�re saved as places.sqlite instead of the more convenient bookmarks.html. To change this setting so that they can be easily re-imported, search for autoExportHTML and you should see: browser.bookmarks.autoExportHTML: Change this to true. 7: Disable extension install delay One of the few gripes I have with Firefox is the silly countdown you must endure every time you want to install an extension. Fortunately, this can be disabled. Search for enable_delay and you should see: security.dialog_enable_delay: Change this to 0. 8: View source code in an external editor When you need to view the source of a page, it opens up in browser popup. Most developers would probably like to have that opened in their favorite editor instead of having to cut and paset. To do this, there are two entries to modify. Search for view_source.editor and you will see: view_source.editor.external: Change this to true. view_source.editor.path: Change this to the explicit path to your editor of choice. 9: Get more add-on search results When you do a search in the Add-on window, you�ll see just five results. You might find it more efficient to increase this number. Search for getAddons and you should see: extension.getAddons.maxResults: Change this to 10 (or higher, if you want to see even more). 10: Redefine the Backspace button Did you know you can configure Firefox to use the backspace button to either go back a page or go up a page? This keeps power users from having to go back and forth from the keyboard to the mouse. Search for backspace and you will see: browser.backspace_action: Change this to 0 for previous page and 1 for page up. Browsers 1867 09/09/2023 Windows <=8 Network Access Skydrive Like You Would A Hard Drive skydrive sky drive map network cid windows live account Windows 7 may differ the Windows 8 procedure. Log in to your skydrive account to get your cid: First you need to get your cid= number after logging into your Microsoft Skydrive account using your browser. It will have a format like https://skydrive.live.com/?mkt=en-US&v=FirstRunView#cid=8aca12345b98765. Yours may be slightly different since this was the first time I logged in to my account, but the number at the end. This is the url to map: https://d.docs.live.net/8aca12345b98765/ Open Windows File Explorer Highlight the word "Computer" on the left hand side. The network drive Icon will appear at the top middle. Click it. Use one of the higher drive letters and copy and past the new url into the folder box. Then save. Windows will try to connect if it can and prompt you for your windows live account user name and password Now you can copy and save files to your new drive. Just remember the files will only write and read based on your internet connection and speed. Similar to windows 8 http://rashedtalukder.com/how-to-map-skydrive-folder-on-windows-rt-desktop-mode/ Windows <=8 1136 09/09/2023 WP Database Access Wordpress Connection String connection string wordpress Source File wpdb() is located in wp-includes/wp-db.php. "$wbdb->dbh" WP 2 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 WP Customizing Adding A Link To The Admin Panel plugin function.php hyperlink wordpress admin http://wordpress.org/support/topic/add-link-to-admin-panel 2 cases 1. Plugin use this plugin : (it'll add a new menu item in your admin panel) <?php /* Plugin Name: Add-Admin-Menu Author: Sanjay Menon */ function mt_add_pages() { // The first parameter is the Page name(admin-menu), second is the Menu name(menu-name) //and the number(5) is the user level that gets access add_menu_page('admin-menu', 'menu-name', 5, __FILE__, 'mt_toplevel_page'); } // mt_oplevel_page() displays the page content for the custom Test Toplevel menu function mt_toplevel_page() { echo ' <div class="wrap"> <h2>New admin menu</h2> <li><a href="http://www.icore.net.tc"><h3>Author Homepage</h3></a></li> </div>'; } add_action('admin_menu', 'mt_add_pages'); ?> OR 2. function.php You just have to put that piece of code in "functions.php" file inside your WordPress Theme. function mt_add_pages() { add_menu_page('admin-menu', 'menu-name', 5, __FILE__, 'mt_toplevel_page'); } function mt_toplevel_page() { echo ' <div class="wrap"> <h2>New admin menu</h2> <li><a href="http://www.icore.net.tc"><h3>Author Homepage</h3></a></li> </div>'; } add_action('admin_menu', 'mt_add_pages'); EXAMPLE 2: You may already have developed your own cool admin. No problem, have wordpress link to your admin and use the example modification to check to see if the user is logged in via wordpress. Just add a link to come back. This way wordpress will not mess up your styling you use in your admin. <?php /* Plugin Name: swd_admin Description: Link to swd admin Author: Software Web Design Version: 0.1 example mystuff modification session_start(); include("config.php"); require_once("../wp-load.php"); if(!is_user_logged_in() && $bypass!=true){ echo "This site is under construction"; exit; } else { $wordpress=true; $LEVEL=10; $_SESSION['LEVEL']=10; } */ add_action('admin_menu', 'swd_setup_menu'); function swd_setup_menu(){ add_menu_page( 'SWD Plugin Page', 'Go to SWD Admin', 'manage_options', 'admin-plugin', 'swd_menu' ); } function swd_menu(){ echo "<h1>SWD Menu</h1>"; echo " <a href='/swd-admin/boardOfDirectorsView.php'>Board Passwords</a> <a href='/swd-admin/directorsView.php'>Directors</a> <a href='/swd-admin/libraryView.php'>Library</a> <a href='/swd-admin/libraryCategoryView.php'>Library Categories</a>"; } ?> WP 2389 09/09/2023 _Misc Software Setup Aimersoft Converter Ultimate IFO Option convert movies DVD file IFO How to load DVD folders, ISO files and IFO files? Last Revised: 2013-08-28 11:14:46 2 FAQ for the following product: DVD Ripper Video Converter Pro DVD to iPad Converter You can follow the two ways below to load DVD folders, ISO files and IFO files. 1. Please click the arrow on the right of the DVD button, and then select Load DVD Folder, Load ISO Files or Load IFO Files to load the files into the program from your hard drive or disc. 2. Please click the File menu and select the corresponding command to load files into the program from your hard drive or disc. Note: 1. If you select Load DVD Folder, the whole DVD folder will open. It is suggested to select the VIDEO_TS folder, and then you can load all files in this folder including trailers or commercials into the program. 2. If you select Load IFO Files, you had better choose the biggest IFO file containing the main movie, which will help you save much time because you needn't convert unnecessary parts. Tip: You can right click the IFO files to choose Property to check the size of them. http://support.aimersoft.com/how-tos/Load-DVD-folder-ISO-IFO.html _Misc Software 1052 09/09/2023 Mysql Database Alter Table change table alter table [Add More Fields] ALTER TABLE warehouse ADD fire_protection tinyint(4) NOT NULL default '0' AFTER interstate, ADD fire_water tinyint(4) NOT NULL default '0' AFTER fire_protection, ADD fire_inertgas tinyint(4) NOT NULL default '0' AFTER fire_water, ADD fire_CO2 tinyint(4) NOT NULL default '0' AFTER fire_inertgas; [rename fields] ALTER TABLE `warehouse` CHANGE `AMPERAGE` `amperage` SMALLINT(6) DEFAULT '0' NOT NULL RENAME TABLE current_db.tbl_name TO other_db.tbl_name; ALTER TABLE orders ADD `responsecode` tinyint(4) NOT NULL default '0', ADD `responsesubcode` tinyint(4) NOT NULL default '0', ADD `reasoncode` tinyint(4) NOT NULL default '0', ADD `reasontext` varchar(255) NOT NULL default '', ADD `authcode` varchar(20) NOT NULL default '', ADD `avscode` varchar(5) NOT NULL default '', ADD `transid` tinyint(4) NOT NULL default '0'; [EMPTY TABLE] TRUNCATE TABLE table Mysql 2 09/09/2023 Mysql Query Alter Tables add field delete alter table rename update table auto increment engine collation [Collation] To change the default character set and collation of a table including those of existing columns (note the convert to clause): alter table convert to character set utf8mb4 collate utf8mb4_unicode_ci; [Reset auto increment to the lowest possible value] ALTER TABLE tablename AUTO_INCREMENT = 1 [rename Engine] ALTER TABLE tablename ENGINE = INNODB; [Single Add] ALTER TABLE `equipment` ADD `hp` SMALLINT NOT NULL AFTER `price`; [Add Multiple Fields] ' the field before this was interstate. ALTER TABLE warehouse ADD fire_protection tinyint(4) NOT NULL default '0' AFTER interstate, ADD fire_water tinyint(4) NOT NULL default '0' AFTER fire_protection, ADD fire_inertgas tinyint(4) NOT NULL default '0' AFTER fire_water, ADD fire_CO2 tinyint(4) NOT NULL default '0' AFTER fire_inertgas; [rename fields] Example: To rename a column named prod_name to product_full_name while keeping its data type as VARCHAR(100) and NOT NULL constraint: ALTER TABLE lastbackup CHANGE COLUMN table_folder source VARCHAR(75) NOT NULL; ALTER TABLE lastbackup CHANGE COLUMN database_name source_from VARCHAR(30) NOT NULL; ALTER TABLE `eqMaintenance` CHANGE `filter2id` `filter_options` varchar(60) RENAME TABLE current_db.tbl_name TO other_db.tbl_name; ALTER TABLE orders ADD `responsecode` tinyint(4) NOT NULL default '0', ADD `responsesubcode` tinyint(4) NOT NULL default '0', ADD `reasoncode` tinyint(4) NOT NULL default '0', ADD `reasontext` varchar(255) NOT NULL default '', ADD `authcode` varchar(20) NOT NULL default '', ADD `avscode` varchar(5) NOT NULL default '', ADD `transid` tinyint(4) NOT NULL default '0'; [EMPTY TABLE] TRUNCATE TABLE table Mysql 1770 09/09/2023 Javascript String Array Information length array size count Array Object Properties Property Description constructor Returns the function that created the Array object's prototype length Sets or returns the number of elements in an array prototype Allows you to add properties and methods to an Array object Array Object Methods Method Description concat() Joins two or more arrays, and returns a copy of the joined arrays indexOf() Search the array for an element and returns it's position join() Joins all elements of an array into a string lastIndexOf() Search the array for an element, starting at the end, and returns it's position pop() Removes the last element of an array, and returns that element push() Adds new elements to the end of an array, and returns the new length reverse() Reverses the order of the elements in an array shift() Removes the first element of an array, and returns that element slice() Selects a part of an array, and returns the new array sort() Sorts the elements of an array splice() Adds/Removes elements from an array toString() Converts an array to a string, and returns the result unshift() Adds new elements to the beginning of an array, and returns the new length valueOf() Returns the primitive value of an array Javascript 1296 09/09/2023 Vb.net String Array Manipulation count split explode [Return number of element in array] dotg.count= items in array [Split a patterned string into separate elements like a csv file] myfile="dog,10,cat,40,fish,50" dotg=split(myfile,",") Vb.net 1039 09/09/2023 Javascript Text Box Auto Clear Text Box Input text - auto clear w FIND A STORE onblur="this.value=(this.value=='') ? 'Enter a Zip Code' : this.value;" onfocus="clearText(this);" value="Enter a Zip Code" /> Javascript 1460 09/09/2023 Php Function Automatically Make Urls Clickable hyperlinks click email url link function _make_url_clickable_cb($matches) { $ret = ''; $url = $matches[2]; if ( empty($url) ) return $matches[0]; // removed trailing [.,;:] from URL if ( in_array(substr($url, -1), array('.', ',', ';', ':')) === true ) { $ret = substr($url, -1); $url = substr($url, 0, strlen($url)-1); } //return $matches[1] . "$url" . $ret; return $matches[1] . "$url" . $ret; } function _make_web_ftp_clickable_cb($matches) { $ret = ''; $dest = $matches[2]; $dest = 'http://' . $dest; if ( empty($dest) ) return $matches[0]; // removed trailing [,;:] from URL if ( in_array(substr($dest, -1), array('.', ',', ';', ':')) === true ) { $ret = substr($dest, -1); $dest = substr($dest, 0, strlen($dest)-1); } return $matches[1] . "$dest" . $ret; } function _make_email_clickable_cb($matches) { $email = $matches[2] . '@' . $matches[3]; return $matches[1] . "$email"; } function MakeHyperlink($ret) { $ret = ' ' . $ret; // in testing, using arrays here was found to be faster $ret = preg_replace_callback('#([\s>])([\w]+?://[\w\\x80-\\xff\#$%&~/.\-;:=,?@\[\]+]*)#is', '_make_url_clickable_cb', $ret); $ret = preg_replace_callback('#([\s>])((www|ftp)\.[\w\\x80-\\xff\#$%&~/.\-;:=,?@\[\]+]*)#is', '_make_web_ftp_clickable_cb', $ret); $ret = preg_replace_callback('#([\s>])([.0-9a-z_+-]+)@(([0-9a-z-]+\.)+[0-9a-z]{2,})#i', '_make_email_clickable_cb', $ret); // this one is not in an array because we need it to run last, for cleanup of accidental links within links $ret = preg_replace("#(]+?>|>))]+?>([^>]+?)#i", "$1$3", $ret); $ret = trim($ret); return $ret; } Php 1617 09/09/2023 Css Formatting Background Changes background css fixed url background- hand property for: background-color body {background-color: coral;} background-image body { background-image: url("paper.gif"); background-color: #cccccc; } background-position body { background-image: url('w3css.gif'); background-repeat: no-repeat; background-attachment: fixed; background-position: center; } background-size #example1 { background: url(mountain.jpg); background-repeat: no-repeat; background-size: auto; } #example2 { background: url(mountain.jpg); background-repeat: no-repeat; background-size: 300px 100px; } background-repeat body { background-image: url("paper.gif"); background-repeat: repeat-y; } background-origin #example1 { border: 10px dashed black; padding: 25px; background: url(paper.gif); background-repeat: no-repeat; background-origin: content-box; } background-clip Specify how far the background should extend within an element: div { border: 10px dotted black; padding: 15px; background: lightblue; background-clip: padding-box; } background-attachment A background-image that will not scroll with the page (fixed): body { background-image: url("img_tree.gif"); background-repeat: no-repeat; background-attachment: fixed; } How to position a background-image on x-axis: div { background-image: url('w3css.gif'); background-repeat: no-repeat; background-position-x: center; } How to position a background-image on y-axis: div { background-image: url('w3css.gif'); background-repeat: no-repeat; background-position-y: center; } <table> <tr> <th>Value</th> <th>Description</th> <th>CSS</th> </tr> <tr> <td> <i> background-color </i> </td> <td>Specifies the background color to be used</td> <td>body { background-color:yellow; } h1 { background-color:#00ff00; } p { background-color:rgb(255,0,255); } </td> </tr> <tr> <td> <i> background-position</i> </td> <td>Specifies the position of the background images</td> <td>body { background-image:url('smiley.gif'); background-repeat:no-repeat; background-attachment:fixed; background-position:center; } </td> </tr> <tr> <td> <i> background-size</i> </td> <td>Specifies the size of the background images</td> <td> div { background:url(img_flwr.gif); background-size:80px 60px; background-repeat:no-repeat; } </td> </tr> <tr> <td> <i> background-repeat </i> </td> <td>Specifies how to repeat the background images</td> <td>body { background-image:url('paper.gif'); background-repeat:repeat-y; } </td> </tr> <tr> <td> <i> background-origin </i> </td> <td>Specifies the positioning area of the background images</td> <td>div { background-image:url('smiley.gif'); background-repeat:no-repeat; background-position:left; background-origin:content-box; } </td> </tr> <tr> <td> <i> background-clip </i> </td> <td>Specifies the painting area of the background images</td> <td>div { background-color:yellow; background-clip:content-box; } </td> </tr> <tr> <td> <i> background-attachment </i> </td> <td>Specifies whether the background images are fixed or scrolls with the rest of the page</td> <td>body { background-image:url('w3css.gif'); background-repeat:no-repeat; background-attachment:fixed; } </td> </tr> <tr> <td> <i> background-image </i> </td> <td>Specifies ONE or MORE background images to be used</td> <td>body { background-image:url('paper.gif'); background-color:#cccccc; } </td> </tr> </table> body { background-image: url(../images/backg.gif); background-repeat: no-repeat; background-position: top center; background-attachment: fixed } background-color:white;opacity:.5;filter:alpha(opacity=50); // for firefox and IE background-color: transparent; color: orange; Css 1621 09/09/2023 Javascript Function Bearing Bearing heading latitude longitude GPS function bearing(startLat, startLng, destLat, destLng){ startLat = toRadians(startLat); startLng = toRadians(startLng); destLat = toRadians(destLat); destLng = toRadians(destLng); y = Math.sin(destLng - startLng) * Math.cos(destLat); x = Math.cos(startLat) * Math.sin(destLat) - Math.sin(startLat) * Math.cos(destLat) * Math.cos(destLng - startLng); brng = Math.atan2(y, x); brng = toDegrees(brng); return (brng + 360) % 360; } Javascript 2 09/09/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 Microsoft Excel Form Button To Go To A Certain Sheet button sheet Solution 1 Alternately, if you are using a Macro Enabled workbook: Add any control at all from the Developer -> Insert (Probably a button) When it asks what Macro to assign, choose New. For the code for the generated module enter something like: Thisworkbook.Sheets("Sheet Name").Activate Microsoft Excel 2 09/09/2023 Css Formatting Centering A Table center table The old way to center a table was easy: ... The "align" attribute has been deprecated, however, in favor of CSS (Cascading Style Sheets), and this is a good thing. However, it's not so obvious how to center a table using CSS. The obvious way might appear to use the CSS "text-align: center;" somewhere, maybe like one of these: OR ... OR, if you get really desperate, ... None of these will work. The table itself will be left-aligned, but all the content in the table cells will be centered. Why? Because "text-align" applies to inline content, not to a block-level element like "table". Method 1 To center a table, you need to set the margins, like this: table.center {margin-left:auto; margin-right:auto;} And then do this: ... At this point, Mozilla and Opera will center your table. Internet Explorer 5.5 and up, however, needs you to add this to your CSS as well: body {text-align:center;} Method 2 If you want your table to be a certain percentage width, you can do this: table#table1 {width:70%; margin-left:15%; margin-right:15%;} And then in your HTML/XHTML, you would do this: ... Note that I was using an id to describe the table. You can only use an id once on a page. If you had many tables on a page that you wanted to be the same width and centered, you would do this in your CSS: table.center {width:70%; margin-left:15%; margin-right:15%;} And this in your HTML: ... ... Method 3 If you want your table to be of fixed width, define your CSS like this: div.container {width:98%; margin:1%;} table#table1 {text-align:center; margin-left:auto; margin-right:auto; width:100px;} tr,td {text-align:left;} Set "width:100px" to whatever width you need. "text-align: center" is there for Internet Explorer, which won't work without it. Unfortunately, "text-align: center" will center all the text inside your table cells, but we counter that by setting "tr" and "td" to align left. In your HTML, you would then do this: ... Once again, I'm using an id. If you need to center several tables the same way, use a class instead of an id. Css 1744 09/09/2023 WP Customizing Change Footer Credits On WordPress footer credits add_filter Many WordPress website and blog themes come with design credits in the footer area at the bottom of each Web page. If you commissioned a designer to create a custom theme for your WordPress business site, you can simply ask him to change the footer credits, but for an "off the shelf" free or premium template, you will need to edit the footer section of the template to alter the credits. Although this might sound complicated, the process is straightforward and even a novice with limited WordPress knowledge should be able to accomplish this task. Ads by Google 10 Keys for Mktg Success This free guide shows the metrics and the tactics you need to improve vocus.com?/?Marketing Step 1 Log in to WordPress from the homepage of your business blog or website. Step 2 Click the website's name on the left side of the top WordPress navigation menu. Step 3 Select "Themes" from the drop-down menu to open the Themes page in the Appearance settings section. Step 4 Click "Editor" under the Appearance tab in the left menu. Step 5 Click "Footer (footer.php)" in the Templates section on the right side of the page to open the footer template file in the Edit Themes pane. If you can't find the footer.php file, look for another PHP file with "foot" or "footer" in the filename. Step 6 Scroll to the credit line of code, which will look similar to this: Content © . WordPress Theme by Example WordPress Theme Step 7 Highlight and delete the elements of the footer credits that you want to change. For example, to remove just the theme designer's credit but retain your website's name and copyright line, delete the following: Theme by Example WordPress Theme To retain the designer's credit but remove the link to her website, remove "" and "" but leave the other text in place. Alternatively, you can add text or links to the footer credits by using the same format. Step 8 Scroll to the bottom of the page and click the blue "Update File" button to save and implement your changes. Under the genesis framework, I used the following above the do_actions in the Genesis footer.php to replace there results. add_filter( 'genesis_footer_creds_text', 'custom_footer_creds_text' ); function custom_footer_creds_text() { echo '[div class="creds"][p]'; echo 'Copyright © '; echo date('Y'); echo ' · [a href="http://www.softwarewebdesign.com"]Software Web Design[/a] · Built by Software Web Design'; echo '[/p][/div]'; } WP 1622 09/09/2023 Javascript Date Check For Valid Date valid date Sample html: Valid date format: mm/dd/yyyy The Script: Javascript 1548 09/09/2023 Php Function Choosing What Errors To See error reporting Developer php_flag display_startup_errors on .htacess php_flag display_errors on / Turn off all error reporting error_reporting(0); // Report simple running errors error_reporting(E_ERROR | E_WARNING | E_PARSE); // Reporting E_NOTICE can be good too (to report uninitialized // variables or catch variable name misspellings ...) error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE); // Report all errors except E_NOTICE error_reporting(E_ALL & ~E_NOTICE); // Report all PHP errors error_reporting(E_ALL); // Report all PHP errors error_reporting(-1); // Same as error_reporting(E_ALL); ini_set('error_reporting', E_ALL) Php 2 09/09/2023 Php Files Clean Url ? url clean & # if you ever add variables to the url line you need to use this function urldecode for passing gets. $urlpart1=urldecode($urlpart1); $urlpart2=urldecode($urlpart2); $url="http://www.mydomain.com?$urlpart1&$urlpart2; Do not use it on a completed url. It will totally mess everything up. Php 1325 09/09/2023 Javascript Function Comment Out Lines comment rem Creating Single Line Comments To create a single line comment in JavaScript, you place two slashes "//" in front of the code or text you wish to have the JavaScript interpreter ignore. When you place these two slashes, all text to the right of them will be ignored, until the next line. These types of comments are great for commenting out single lines of code and writing small notes. JavaScript Code: Display: I have comments in my JavaScript code! Each line of code that is colored red is commented out and will not be interpreted by the JavaScript engine. Creating Multi-line Comments Although a single line comment is quite useful, it can sometimes be burdensome to use when disabling long segments of code or inserting long-winded comments. For this large comments you can use JavaScript's multi-line comment that begins with /* and ends with */. JavaScript Code: Display: I have multi-line comments! Quite often text editors have the ability to comment out many lines of code with a simple key stroke or option in the menu. If you are using a specialized text editor for programming, be sure that you check and see if it has an option to easily comment out many lines of code! Javascript 1507 09/09/2023 Mysql Query Concat concat mysql query UPDATE parts SET pdf=CONCAT(partid,'.pdf'), part_image=CONCAT(partid,'.jpg') WHERE pdf="" This example numbers the picture names to match the id of the record. APENDING data before and after a field. UPDATE `iwspackage` SET iwspackageimg=CONCAT('package',packageid,'.jpg'); UPDATE ads SET img1=CONCAT(adid,'a.jpg'), img2=CONCAT(adid,'b.jpg') , img3=CONCAT(adid,'c.jpg') , img4=CONCAT(adid,'d.jpg'), pdf=CONCAT(adid,'.pdf') WHERE adid>7; Mysql 1933 09/09/2023 Php Database Concat - Combine Fields Or Text add join concat APENDING data before and after a field. UPDATE `iwspackage` SET iwspackageimg=CONCAT('package',packageid,'.jpg'); UPDATE ads SET img1=CONCAT(adid,'a.jpg'), img2=CONCAT(adid,'b.jpg') , img3=CONCAT(adid,'c.jpg') , img4=CONCAT(adid,'d.jpg'), pdf=CONCAT(adid,'.pdf') WHERE adid>7; Php 2 09/09/2023 Javascript Function Confirm() yes no cancel message box JavaScript Confirm Example Below is an example of how you would use a confirm dialogue box to warn users about something, giving them the option to either continue on or stay put. HTML & JavaScript Code: Display: Note the part in red. This is where all the magic happens. We call the confirm function with the message, "Leave Tizag?". JavaScript then makes a popup window with two choices and will return a value to our script code depending on which button the user clicks. If the user clicks OK, a value of 1 is returned. If a user clicks cancel, a value of 0 is returned.. We store this value in answer by setting it equal to the confirm function call. After answer has stored the value, we then use answer as a conditional statement. If answer is anything but zero, then we will send the user away from Tizag.com. If answer is equal to zero, we will keep the user at Tizag.com because they clicked the Cancel button. In either case, we have a JavaScript alert box that appears to inform the user on what is going to happen. It will say, "Bye bye!" if they choose to leave and, "Thanks for sticking around!" if they choose to stay. Javascript 2000 09/09/2023 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 Javascript Formatting Converting Numbers To Strings Using ToFixed() fixed decimal places number format Question: When I convert numbers to strings, can I guarantee exactly n decimal places in the resultant string? Answer: The simplest way of converting a number variable to string is to concatenate the variable with an empty string. However, this conversion does not guarantee the number of decimal places in the string. If you want exactly n decimal places in the conversion result, use the toFixed method, like this: str = x.toFixed(n); Here x is the number to be converted, the string str is the conversion result, and n specifies how many fractional decimal places must appear in the resultant string. The method can also be used without the parameter n - you can simply write: x.toFixed(), which is equivalent to x.toFixed(0). Consider these examples: var x = 2.31; var s = x.toFixed() // result: '2' var s0 = x.toFixed(0) // result: '2' var s1 = x.toFixed(1) // result: '2.3' var s2 = x.toFixed(2) // result: '2.31' var s3 = x.toFixed(3) // result: '2.310' var s4 = x.toFixed(4) // result: '2.3100' The toFixed method might not always ensure the correct rounding of the conversion results. For example, (0.947).toFixed(0) may produce either '0' or '1', depending on the browser; in most versions of Microsoft Internet Explorer (0.947).toFixed(0) produces '0' while in Mozilla Firefox or Google Chrome the same conversion produces '1'. Below are the actual conversion results in your browser: (0.947).toFixed(0) // '0' ('0' in MSIE, but '1' in Firefox) (0.0947).toFixed(1) // '0.0' ('0.0' in MSIE, but '0.1' in Firefox) (0.00947).toFixed(2) // '0.00' ('0.00' in MSIE, but '0.01' in Firefox) (0.000947).toFixed(3) // '0.000' ('0.000' in MSIE, but '0.001' in Firefox) For correct rounding, use the Math.round method or Math.round in combination with toFixed like this: x=0.947; s0=(Math.round(x)).toFixed(0) // '1' x=0.0947; s1=(Math.round(10*x)/10).toFixed(1) // '0.1' x=0.00947; s2=(Math.round(100*x)/100).toFixed(2) // '0.01' x=0.000947; s3=(Math.round(1000*x)/1000).toFixed(3) // '0.001' Javascript 1552 09/09/2023 Php Variables Cookies cookies json_encode store arrays post get session Storing Settings To delete a cookie in PHP, you must use the setcookie() function with an expiration time in the past. This tells the user's browser to remove the cookie. Steps to Delete a PHP Cookie Ensure no output is sent to the browser before calling setcookie(), as it modifies HTTP headers. Call the setcookie() function with the same name and parameters (path, domain, etc.) that were used when the cookie was created. Set the expiration time to a time in the past, for example, an hour ago (time() - 3600). The value of the cookie can be set to an empty string. Example Code php // Set a cookie (example, expires in 30 days) $cookie_name = "username"; $cookie_value = "John Doe"; setcookie($cookie_name, $cookie_value, time() + (86400 * 30), "/"); // 86400 = 1 day // ... your other code ... // To delete the cookie named "username": // Set the expiration date to one hour ago (or any time in the past) setcookie("username", "", time() - 3600, "/"); setcookie("humans_21909", "", time() - 3600, "/"); // Optionally, you can also unset the cookie from the current script's $_COOKIE superglobal array unset($_COOKIE['username']); echo "Cookie 'username' has been deleted."; This example stores my variables into cookies and retrieves them back when I want them: $appid="635667735729502691";$appidLast=""; if($_GET["BACK"]==1) { $savedSessions=array();$savedRequests=array(); $savedSessions= json_decode($_COOKIE["SESSIONARRAY".$appid]); $savedPosts= json_decode($_COOKIE["POSTARRAY".$appid]); $savedGets= json_decode($_COOKIE["GETARRAY".$appid]); foreach($savedSessions as $k=>$value) { $_SESSION[$k]=$value; } foreach($savedPosts as $k=>$value) { $_POST[$k]=$value; } foreach($savedGets as $k=>$value) { $_GET[$k]=$value; } } //CHECK CURRENT APPLICATION else{ $json = json_encode($_SESSION, true);setcookie('SESSIONARRAY'.$appid,$json, time()+1800,"/"); $json = json_encode($_POST, true);setcookie('POSTARRAY'.$appid,$json,time()+1800,"/"); $json = json_encode($_GET, true);setcookie('GETARRAY'.$appid,$json,time()+1800,"/"); } Php 837 09/09/2023 Css Formatting Create A Scrolling Div scroll bars Divs Resources Hebrew/Greek Your Content Luke 2 New International Version The Birth of Jesus 2 In those days Caesar Augustus issued a decree that a census should be taken of the entire Roman world. 2 (This was the first census that took place while[a] Quirinius was governor of Syria.) 3 And everyone went to their own town to register. 4 So Joseph also went up from the town of Nazareth in Galilee to Judea, to Bethlehem the town of David, because he belonged to the house and line of David. 5 He went there to register with Mary, who was pledged to be married to him and was expecting a child. 6 While they were there, the time came for the baby to be born, 7 and she gave birth to her firstborn, a son. She wrapped him in cloths and placed him in a manger, because there was no guest room available for them. 8 And there were shepherds living out in the fields nearby, keeping watch over their flocks at night. 9 An angel of the Lord appeared to them, and the glory of the Lord shone around them, and they were terrified. 10 But the angel said to them, “Do not be afraid. I bring you good news that will cause great joy for all the people. 11 Today in the town of David a Savior has been born to you; he is the Messiah, the Lord. 12 This will be a sign to you: You will find a baby wrapped in cloths and lying in a manger.” 13 Suddenly a great company of the heavenly host appeared with the angel, praising God and saying, 14 “Glory to God in the highest heaven, and on earth peace to those on whom his favor rests.” 15 When the angels had left them and gone into heaven, the shepherds said to one another, “Let’s go to Bethlehem and see this thing that has happened, which the Lord has told us about.” 16 So they hurried off and found Mary and Joseph, and the baby, who was lying in the manger. 17 When they had seen him, they spread the word concerning what had been told them about this child, 18 and all who heard it were amazed at what the shepherds said to them. 19 But Mary treasured up all these things and pondered them in her heart. 20 The shepherds returned, glorifying and praising God for all the things they had heard and seen, which were just as they had been told. 21 On the eighth day, when it was time to circumcise the child, he was named Jesus, the name the angel had given him before he was conceived. Jesus Presented in the Temple 22 When the time came for the purification rites required by the Law of Moses, Joseph and Mary took him to Jerusalem to present him to the Lord 23 (as it is written in the Law of the Lord, “Every firstborn male is to be consecrated to the Lord”[b]), 24 and to offer a sacrifice in keeping with what is said in the Law of the Lord: “a pair of doves or two young pigeons.”[c] 25 Now there was a man in Jerusalem called Simeon, who was righteous and devout. He was waiting for the consolation of Israel, and the Holy Spirit was on him. 26 It had been revealed to him by the Holy Spirit that he would not die before he had seen the Lord’s Messiah. 27 Moved by the Spirit, he went into the temple courts. When the parents brought in the child Jesus to do for him what the custom of the Law required, 28 Simeon took him in his arms and praised God, saying: 29 “Sovereign Lord, as you have promised, you may now dismiss[d] your servant in peace. 30 For my eyes have seen your salvation, 31 which you have prepared in the sight of all nations: 32 a light for revelation to the Gentiles, and the glory of your people Israel.” 33 The child’s father and mother marveled at what was said about him. 34 Then Simeon blessed them and said to Mary, his mother: “This child is destined to cause the falling and rising of many in Israel, and to be a sign that will be spoken against, 35 so that the thoughts of many hearts will be revealed. And a sword will pierce your own soul too.” 36 There was also a prophet, Anna, the daughter of Penuel, of the tribe of Asher. She was very old; she had lived with her husband seven years after her marriage, 37 and then was a widow until she was eighty-four.[e] She never left the temple but worshiped night and day, fasting and praying. 38 Coming up to them at that very moment, she gave thanks to God and spoke about the child to all who were looking forward to the redemption of Jerusalem. 39 When Joseph and Mary had done everything required by the Law of the Lord, they returned to Galilee to their own town of Nazareth. 40 And the child grew and became strong; he was filled with wisdom, and the grace of God was on him. The Boy Jesus at the Temple 41 Every year Jesus’ parents went to Jerusalem for the Festival of the Passover. 42 When he was twelve years old, they went up to the festival, according to the custom. 43 After the festival was over, while his parents were returning home, the boy Jesus stayed behind in Jerusalem, but they were unaware of it. 44 Thinking he was in their company, they traveled on for a day. Then they began looking for him among their relatives and friends. 45 When they did not find him, they went back to Jerusalem to look for him. 46 After three days they found him in the temple courts, sitting among the teachers, listening to them and asking them questions. 47 Everyone who heard him was amazed at his understanding and his answers. 48 When his parents saw him, they were astonished. His mother said to him, “Son, why have you treated us like this? Your father and I have been anxiously searching for you.” 49 “Why were you searching for me?” he asked. “Didn’t you know I had to be in my Father’s house?”[f] 50 But they did not understand what he was saying to them. 51 Then he went down to Nazareth with them and was obedient to them. But his mother treasured all these things in her heart. 52 And Jesus grew in wisdom and stature, and in favor with God and man. Css 3 09/09/2023 Php Function Create Graphic Button On The Fly grapic button image color session_start(); session_register('sessioncode'); //Header("Content-type: image/jpeg"); //echo "beg test"; $filename = "images/image1.gif"; $im = imagecreate(55, 15); $bg = imagecolorallocate($im, 255, 255, 255); $textcolor = imagecolorallocate($im, 100, 100, 100); imagecolortransparent($im, $bg); //imagestring($im, 5, 0, 0, substr(strtoupper(md5("Myshit".$sessioncode)), 0,6), $textcolor); imagestring($im, 5, 0, 0, substr(strtoupper("Myshit"), 0,6), $textcolor); imageGif($im,$filename); ImageDestroy($im); //*************************************************************** $filename = "images/image.gif"; $img = ImageCreate(200,20); $red = ImageColorAllocate($img, 255, 0, 0); $white = ImageColorAllocate($img, 255, 255, 255); ImageString($img, 3, 3, 3, "Uh, this is an image!", $white); ImageGif($img, $filename); ImageDestroy($img); echo ""; echo "Finished"; exit(); ?> Php 1235 09/09/2023 Vb.net Variables Create New Arrays array null Read through entire array For Each fruit As String In MV Console.WriteLine(fruit) Next max number of elements array.length For L = 0 To MV.GetUpperBound(0) elements stored Either Dim strings = New String() {"a", "b", "c"} or Dim strings() As String = {"a", "b", "c"} or strings() As String = {} should work Vb.net 2 09/09/2023 Vb.net Database Create Read Only Recordset create recordset error list box LISTBOX Imports System.Data.Oledb Solution Beta1 'Grabs data from a table and posts it into a ListView Dim Table_ As String = "mulitreplace ORDER BY title" Dim query As String = "SELECT * FROM " & Table_ Dim MDBConnString_ As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=webtools1.mdb;" Dim ds As New DataSet Dim cnn As OleDbConnection = New OleDbConnection(MDBConnString_) cnn.Open() Dim cmd As New OleDbCommand(query, cnn) Dim da As New OleDbDataAdapter(cmd) da.Fill(ds, Table_) cnn.Close() Dim t1 As DataTable = ds.Tables(Table_) txMultiAction.Items.Clear() txMultiAction.ValueMember = "replaceid" txMultiAction.DisplayMember = "title" txMultiAction.DataSource = ds.Tables(Table_) Dim row As DataRow Dim Item(2) As String For Each row In t1.Rows Item(0) = row(0) Item(1) = row(1) Item(2) = row(2) 'MsgBox(Item(1)) 'Dim NextListItem As New ListViewItem(Item) 'ListView1.Items.Add(NextListItem) Next 'end Beta Dim con As New OledbConnection("Provider=microsoft.Jet.oledb.4.0DataSource=D:mydata.mdb;") Dim cmd As New OledbCommand Public var1 As String Public Sub New() con.Open() cmd.Connection = con cmd.CommandText = "SELECT * FROM table1" End Sub Public Sub creates() cmd.CommandText = "INSERT INTO table1(Neyms) VALUES('" + var1 + "')" cmd.ExecuteNonQuery() End Sub Permalink Posted 16-Jan-13 22:39pm vinodkumarnie Solution 2 Grabs data from a table and posts it into a ListView Dim Table_ As String = "Table1" Dim query As String = "SELECT * FROM " & Table_ Dim MDBConnString_ As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TestDatabase.mdb;" Dim ds As New DataSet Dim cnn As OleDbConnection = New OleDbConnection(MDBConnString_) cnn.Open() Dim cmd As New OleDbCommand(query, cnn) Dim da As New OleDbDataAdapter(cmd) da.Fill(ds, Table_) cnn.Close() Dim t1 As DataTable = ds.Tables(Table_) Dim row As DataRow Dim Item(2) As String For Each row In t1.Rows Item(0) = row(0) Item(1) = row(1) Dim NextListItem As New ListViewItem(Item) ListView1.Items.Add(NextListItem) Next Vb.net 2 09/09/2023 Css Formatting Creating And Styling Borders border property color size Web border border-block border-block-color border-block-end-color border-block-end-style border-block-end-width border-block-start-color border-block-start-style border-block-start-width border-block-style border-block-width border-bottom border-bottom-color border-bottom-left-radius border-bottom-right-radius border-bottom-style border-bottom-width border-collapse border-color border-end-end-radius border-end-start-radius border-image border-image-outset border-image-repeat border-image-slice border-image-source border-image-width border-inline border-inline-color border-inline-end-color border-inline-end-style border-inline-end-width border-inline-start-color border-inline-start-style border-inline-start-width border-inline-style border-inline-width border-left border-left-color border-left-style border-left-width border-radius border-right border-right-color border-right-style border-right-width border-spacing border-start-end-radius border-start-start-radius border-style border-top border-top-color border-top-left-radius border-top-right-radius border-top-style border-top-width border-width Hello, I want to display a box around a div, and I want it's size to adjust to the text width. In Firefox, this code works as I want. In IE6/IE7, the box is as big as possible. I want to make this work for IE6 and IE7 (I actually care less about FF, because it's for an intranet). I tried different values for display and width (which only has one value anyway), but none does what I need. Here's the relevant CSS code: /* Div acting like a box */ div.box { border: solid 1px #CCCCCC; background-color: #f9f9f9; display: table; padding: 4px; margin: 4px 4px 0px 4px; } My DOCTYPE is: ============================================== ***double **** Box properties treat all block-level formatting elements like a virtual 'box'. The height and width of the box is determined by (going from inner-most dimension outward) the height and width of the contained elements (text and/or images) plus heights and widths for space around the element ('padding'), plus the height and widths created by added borders ('border'), along with exterior margin values ('margin') relative to elements exterior to the virtual box. The border properties allow borders to be defined (of course) for any element. These properties give a much wider array of display options for creating line effects around elements than has previously been possible in HTML. If a border is rendered for an element with an inherent or assigned 'inline' 'display' property status, the browser may render a border for each line if the element spans more than one line. Selector { border: [width] [line-style] [color] } Example Ext/Doc: blockquote { border: medium dashed #ff0000 } In-Line: this is a beautiful blockquote test -------------------------------------------------------------------------------- [border-width] [width] IE | N4B4 Please see the description of allowed values in the 'border-width' property. [border-style] [line-style] IE | N4B4 Please see the explanations of these values in the 'border-style' property. [border-color] [color] IE | N4B4 Please see the explanations of these values in the 'border-color' property. -------------------------------------------------------------------------------- border-top [IE | N] Applicable Tags: ALL HTML Equivalent: | Inherit From Parent: No Default Values: NA What Is It? This property controls the properties of the top border of an element. The border is drawn using the included color value. If no color is specified, the value will be taken from the 'color' property. If the property is used on an element with an inherent or assigned 'inline' 'display' property status, the browser may render a border for each line if the element spans more than one line. Usage: Selector { border-top: [width] [line-style] [color] } Example Ext/Doc: div.out { border-top: 10px outset #ffffff } In-Line: this is a beautiful test -------------------------------------------------------------------------------- [border-width] [width] IE | N Please see the description of allowed values in the 'border-width' property. [border-style] [line-style] IE | N Please see the explanations of these values in the 'border-style' property. [border-color] [color] IE | N Please see the explanations of these values in the 'border-color' property. -------------------------------------------------------------------------------- border-right [IE | N] Applicable Tags: ALL HTML Equivalent: | Inherit From Parent: No Default Values: NA What Is It? This property controls the properties of the right border of an element. The border is drawn using the included color value. If no color is specified, the value will be taken from the 'color' property. If the property is used on an element with an inherent or assigned 'inline' 'display' property status, the browser may render a border for each line if the element spans more than one line. Usage: Selector { border-right: [width] [line-style] [color] } Example Ext/Doc: em { border-right: thick double yellow } In-Line: this is a beautiful test -------------------------------------------------------------------------------- [border-width] [width] IE | N Please see the description of allowed values in the 'border-width' property. [border-style] [line-style] IE | N Please see the explanations of these values in the 'border-style' property. [border-color] [color] IE | N Please see the explanations of these values in the 'border-color' property. -------------------------------------------------------------------------------- border-bottom [IE | N] Applicable Tags: ALL HTML Equivalent: | Inherit From Parent: No Default Values: NA What Is It? This property controls the properties of the bottom border of an element. The border is drawn using the included color value. If no color is specified, the value will be taken from the 'color' property. If the property is used on an element with an inherent or assigned 'inline' 'display' property status, the browser may render a border for each line if the element spans more than one line. Usage: Selector { border-bottom: [width] [line-style] [color] } Example Ext/Doc: span { border-bottom: solid green } In-Line: this is a beautiful test -------------------------------------------------------------------------------- [border-width] [width] IE | N Please see the description of allowed values in the 'border-width' property. [border-style] [line-style] IE | N Please see the explanations of these values in the 'border-style' property. [border-color] [color] IE | N Please see the explanations of these values in the 'border-color' property. -------------------------------------------------------------------------------- border-left [IE | N] Applicable Tags: ALL HTML Equivalent: | Inherit From Parent: No Default Values: NA What Is It? This property controls the properties of the left border of an element. The border is drawn using the included color value. If no color is specified, the value will be taken from the 'color' property. If the property is used on an element with an inherent or assigned 'inline' 'display' property status, the browser may render a border for each line if the element spans more than one line. Usage: Selector { border-left: [width] [line-style] [color] } Example Ext/Doc: strong { border-left: thin groove blue } In-Line: this is a beautiful test -------------------------------------------------------------------------------- [border-width] [width] IE | N Please see the description of allowed values in the 'border-width' property. [border-style] [line-style] IE | N Please see the explanations of these values in the 'border-style' property. [border-color] [color] IE | N Please see the explanations of these values in the 'border-color' property. -------------------------------------------------------------------------------- border-width [IE | N4B3] Applicable Tags: ALL HTML Equivalent: | Inherit From Parent: No Default Value: medium What Is It? This property controls the thickness for one to four border sides. If multiple borders are specified, they are given as a space separated list of width values. Value assignments: 1 value present: All four borders are set to that value. 2 values present: Top and bottom borders receive first value while right and left borders are set to the second value. 3 values present: Top - first value, right&left - second value, bottom - third value. 4 values present: Top, right, bottom and left respectively. Usage: Selector { border-width: [width] } Example Ext/Doc: strong { border-width: thick } In-Line: this is a beautiful test -------------------------------------------------------------------------------- thin | medium | thick explicit IE | N4B3 These values set the weight (thickness) of the line used to draw the borders. The browser will determine what thicknesses these keywords shall hold. 'medium' is the default value. [length] calculated IE | N4B3 This is an explicit or relative size measurement of the thickness of the border. Consult the Units Page for acceptable length unit systems. -------------------------------------------------------------------------------- border-top-width [IE | N4B3] Applicable Tags: ALL HTML Equivalent: | Inherit From Parent: No Default Value: medium What Is It? This controls the thickness of the top border. Usage: Selector { border-top-width: [width] } Example Ext/Doc: strong { border-top-width: thin } In-Line: this is a beautiful test -------------------------------------------------------------------------------- [border-width] [width] IE | N4B3 Please see the description of allowed values in the 'border-width' property. -------------------------------------------------------------------------------- border-right-width [IE | N4B3] Applicable Tags: ALL HTML Equivalent: | Inherit From Parent: No Default Value: medium What Is It? This controls the thickness of the right border. Usage: Selector { border-right-width: [width] } Example Ext/Doc: strong { border-right-width: 10px } In-Line: this is a beautiful test -------------------------------------------------------------------------------- [border-width] [width] IE | N4B3 Please see the description of allowed values in the 'border-width' property. -------------------------------------------------------------------------------- border-bottom-width [IE | N4B3] Applicable Tags: ALL HTML Equivalent: | Inherit From Parent: No Default Value: medium What Is It? This controls the thickness of the bottom border. Usage: Selector { border-bottom-width: [width] } Example Ext/Doc: strong { border-bottom-width: medium } In-Line: this is a beautiful test Browser Notes - Netscape 4 Beta 3 Rendering of border properties on single sides (in contrast to using the shorthand 'border-width' property) cuts in to the rendering of adjacent elements. -------------------------------------------------------------------------------- [border-width] [width] IE | N4B3 Please see the description of allowed values in the 'border-width' property. -------------------------------------------------------------------------------- border-style [IE | N4B3] Applicable Tags: ALL HTML Equivalent: | Inherit From Parent: No Default Value: none What Is It? This property controls the type of line used for the border of the current element. It uses from one to four space separated values which are bound to the four borders as illustrated in the "What Is It?" section of the 'border-width' attribute. Usage: Selector { border-style: [line-style] } Example Ext/Doc: strong { border-style: groove } In-Line: this is a beautiful test none explicit IE | N4B3 Default value. No border is rendered, regardless of any 'border-width' present. dotted explicit IE | N A dotted line drawn on top of the background of the element. dashed explicit IE | N A dashed line drawn on top of the background of the element. solid explicit IE | N4B3 A solid line. groove explicit IE | N4B3 A 3-D groove is drawn based upon the [color] value. ridge explicit IE | N4B3 A 3-D ridge is rendered based upon the [color] value. inset explicit IE | N4B3 A 3-D inset is rendered based upon the [color] value. outset explicit IE | N4B3 A 3-D outset is rendered based upon the [color] value. double explicit IE | N4B3 A double line drawn on top of the background of the element. The two lines with the space between adds up to the 'border-width' properties. -------------------------------------------------------------------------------- border-color [IE | N4B3] Applicable Tags: ALL HTML Equivalent: | Inherit From Parent: No Default Value: The value of the 'color' property. What Is It? This property controls the color for one to four border sides. It uses from one to four space separated values which are bound to the four borders as illustrated in the "What Is It?" section of the 'border-width' attribute. If no color is specified, this value will be taken from the 'color' property. Usage: Selector { border-color: [color] } Example Ext/Doc: strong { border-color: blue } In-Line: this is a beautiful test [color] explicit IE | N4B3 This value specifies the color to use in creating the border. Please see the section on Color Units for more details. -------------------------------------------------------------------------------- Value Description none No border. dotted Dotted line drawn over the top of the element. dashed Dashed line drawn over the top of the element. solid Solid line. double Double line drawn over the top of the element; the width of the two lines and the space between them equals the border-width value. groove 3-D groove drawn in colors based upon color. ridge 3-D ridge drawn in colors based upon color. inset 3-D inset drawn in colors based upon color. outset 3-D outset drawn in colors based upon color. border-top-width Css 3 09/09/2023 Html Formatting Creating Page Breaks print break Printing CSS and Printing By Joe Burns Use these to jump around or read it all... [Page Break] [The Format] [Setting A Specific Page Break] I get a lot of questions asking if there are ways to "force" people's browsers to do certain things. The events most often asked for are to force a browser to bookmark the page, to set user preferences, and this one: How can I force a person's browser to print my page? The short and truthful answer is that you can't. There's no command or tag, to my knowledge, that produces a print when your page loads. There are just too many factors involved. Is the user's printer turned on? Can the Web page fit nicely in the print space set by the viewer? And most importantly: Does the viewer want to print your page? It would cheese me if I logged into your page and all of a sudden my printer was humming. Update! As of 10/99 there is still no way to force a printer to print a page; however, you can initiate a print request. See the tutorial. You can take some control when the user decides he or she does want to print your page. Through the magic of Style Sheets, you can now make a point of indicating where the pages will break during the print process. As of 12/21/98, this CSS2 command is supported only by Internet Explorer browsers version 4 and above. -------------------------------------------------------------------------------- Page Break There are two commands you're worried about here: page-break-after page-break-before You can pretty much pick out what each does. The first sets the printing page break just before the element, the second sets the page break just after. Each command has, in theory anyway, four attributes: always | auto | left | right always tells the browser to break the print page after this element always. auto is the default. You're telling the browser to do what it would do anyway: Page break where the page ends. left is not supported by any browser yet. It is used if your printer will print both sides of a page, like a manuscript. If the page is a left-facing page, use this attribute. right is what you use if it's a right-facing page. -------------------------------------------------------------------------------- The Format Here's what it looks like in your page's tags: That format will produce a print page break before each H2 on the page. Would you like to try it out? This page has four H2 headings. Go ahead and print the page. Each H2 will use a new page and will act as the Header for the printed page. Remember, though, that you have to be using Internet Explorer 4 or better. -------------------------------------------------------------------------------- Setting A Specific Page Break Maybe it's better not to have every H2 break the page. Maybe you'd like a page break at a specific point to keep a particular look. You do that by setting up a class of page breaks. You can set up the class on any HTML command, but I think the best method is to set up the class within a or command. That way there's some white space where the page can break. Here's a look at the format (this will sit between your tags): This then will be the activator for the page break: You can set up as many different classes as you'd like as long as you keep following the same format as above. -------------------------------------------------------------------------------- And That's That... This is another one of those commands that I would use if there's a need for it, regardless of the type of browser the viewer is running. Those that understand the command get the effect, and those that don't just get a straight page print. Either way, the user gets a nice print of the page. It's just that in one of the prints, you're able to set a few parameters. Html 2 09/09/2023 Windows <=8 Customizing Creating Your Own Menu Using The Windows Toolbar toolbar too bar desktop desk top right click folder task bar Even though it is cool using the bricks in the start menu I still like putting my favorite apps on the windows task bar without pinning. It takes up a lot less space. To do this: Right click on the desk top and create a new folder. Give it a Short name so it does not take up much space on the tool bar I like my desk top clean so I just dragged and dumped everything I use a lot on this folder. You will need to copy and paste if you want an icon to stay on the desk top. Leave the folder on your desktop. Right click on the task bar and click on toolbars-new toolbar. From the dialogue box select the Desktop. Select the file folder that you named. You now have all your favorites on the task bar. After you reboot the will be list by alpha. Windows <=8 1296 09/09/2023 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 Css Formatting Customizing Formats For Mircrosoft IE ONLY !ie IE firefox browser css I had a table that would format for either FireFox or IE but not both. I used the border-collapse property with "!ie" at the end which IE recognizes but other browswers do Not. Try it with other styling in your css Specify a border collapse for ie #directory table{border-color:#000000; border-collapse:separate; border-collapse:collapse !ie; border-spacing:0px;} #event td{padding:10px 10px 10px 10px;} Css 1276 09/09/2023 WP Setup Data List Plugin widget data list plugin WP_Widget register_widget add_action This plug in just displays a list of language types for computers and web development /* Plugin Name: Language Categories Plugin URI: http://softwarewebdesign.com Description: List Language Catagories. Version: 1.0 Author: Software Web Design Author URI: http://softwarewebdesign.com License: GPL2 */ // WP_Widget_Language_Catagory to WP_Widget_Language_Catagory class dbase{ var $num=0; var $id=0; var $fieldname=""; var $data; var $insertoption=""; var $quickarray=true; function multipleRecs($value){ if($value==true)$value=false; else $value=true; $this->quickarray=$value;return true; } function tableOption($query){ $q = mysql_query($query); $num_fields = mysql_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=mysql_field_flags($q,$ii); if(strpos($fieldinfo,"rimary_key")>0){ $this->fieldname=mysql_field_name($q,$ii);break; } } } function dbsql2($query){ $this->insertoption=$query; } function dbsql($query){ global $db; global $dc;global $debug; if($debug!=true)$result=mysql_query($query); else $result=mysql_query($query) or die(mysql_error().' from '.$query); if(!$result){ if($debug==true){ echo "Error:".$query;exit; }else{ echo "Error:".substr($query,0,10);exit;} } $sql= strtolower($query); if(strpos($sql,"nsert into")==1)$AC=1; if(strpos($sql,"elect")==1){ $AC=2;$this->num=mysql_numrows($result); } if(strpos($sql,"pdate")==1 || strpos($sql,"elete")==1)$AC=3; switch($AC){ case 1: $this->id=mysql_insert_id(); break; case 2: if($this->num==0 && $this->insertoption!=""){ $this->dbq($this->insertoption); return false; } if($this->num==0) return false; if($this->num==1 && $this->quickarray==true)$this->data=mysql_fetch_array($result); else $this->data=$result; break; case 3: break; } // end switch } } // end class class WP_Widget_Language_Catagory extends WP_Widget { // The widget construct. This creates title and description on wordpress admin widget page function WP_Widget_Language_Catagory() { $widget_ops = array( 'classname' => 'widget_LanguageCatagory', 'description' => __( "Language Catagory List for picking search topic" ) ); $this->WP_Widget('LanguageCatagory', __('sw - Language Catagory'), $widget_ops); } // End function WP_Widget_Language_Catagory // This code displays the widget on the screen. function widget($args, $instance) { extract($args); echo $before_widget; if(!empty($instance['title'])) { echo $before_title . $instance['title'] . $after_title; } $q=new dbase(); $sql="SELECT * FROM language ORDER BY language"; $q->multipleRecs(true); $q->dbsql($sql);$result=$q->data; echo"\n"; for($i=1;$i<=$q->num;$i++){ $r=mysql_fetch_array($result); //echo "".$r[1].""; echo "".$r[1].""; } echo"\n"; echo $after_widget; } // End function widget. } // end class WP_Widget_BareBones // Register the widget. add_action('widgets_init', create_function('', 'return register_widget("WP_Widget_Language_Catagory");')); ?> WP 1403 09/09/2023 WP Database Database Access database WP 2 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