Category Archives: Uncategorized

Using a script to look for drone companies

The profession of flying an unmanned aircraft is also called Drone Jobs because they fly even if they’re not on the actual place these apparatus monitor or to correctly study a particular spot,. Drones are generally found in a different place or far away from the studied location, particularly when performing a job that was very dangerous.

Anytime and Anywhere – This what made charter jets shine. Voyagers don’t have to correct their schedule to meet the available commercial flights. They could certainly book anytime to any place. That is the reason it’s usually used by businessmen who need to meet a specific deadline in an alternate place and also by groups or families who would like to enjoy a pleasurable flight.

Customized meal – Most charter jets are made for long hours or days of travel that is why meals are included. The great thing about charter jets is you are able to order or request a flavorful meal that fulfills all your requirements. It is certainly better compared to a commercial flight, particularly if you have allergies in a particular type of food.

Complete Facilities – They make sure that they have complete facilities to can completely cater to all your demands, since this aircraft is generally designed for days of journey. Some jets have beds for supreme relaxation. Some have many more, which you can’t find in a commercial aircraft, and amusement devices to keep the trip lively.

Search & Rescue – This apparatus is also used for more search and rescue operation, so this device can cover large regions since it can fly up to 18,000 feet high or more, and is sure to supply faster, simpler, and more powerful hunting.

Oversight – Nearly all unmanned aircraft has camera that is the reason it is a fantastic device for supervision. Police and military officials commonly use it for supervising clear upward operation, disaster management.

Strong Weapon – This is probably the most important function of this kind of aircraft for military, they use it as a powerful weapon, they can easily disperse even missiles, or compounds, biological hazards, nuclear weapons just by using it, without risking the life of a pilot. If used right it’s indeed the most progressive and may also be an extremely powerful weapon of a certain state.

Unmanned aircraft or UAV comes in various sizes and layouts, each of them is specially designed to meet but also exceed the user’s expectation. A number of businesses also designed their own UAV to totally serve its function. The size of this aircraft begins from 10inches up to a moderate sized genuine aircraft. Make sure to pick a size that would best serve its function.
Folks travel mainly because of these two reasons, either demand or vacation of business, whichever of these two absolutely needs quickly and hassle free transportation and that can only be attained if you picked to travel by aircraft. This is completely faster compared to traveling by ship, which might take you several days or even weeks. It is indeed the quickest, simplest, and most convenient way of traveling.

But if you’d like to travel much faster and in private, then Charter Jets are perfect for you. This kind of transport is highly recommended for businessmen, famous people, or even for those people who wants to travel and enjoy a quiet, relaxing, and pleasurable flight.
The use of unmanned aircraft is absolutely not restricted to military and corporate usage it can also be used by individuals and civilians but since it’s widely used by military and police officers, below are some of their important functions:

This aircraft can properly study a certain room or place without being noticed, that’s why it’s a perfect for security endeavors that are intense.

Aerial traffic –

Cover up exceptionally risky situations – For some other component that is dangerous to your well-being but still needs to be checked, or areas that are exposed in substance, radiation, unmanned aircraft is certainly the finest device. A particular area can be fully checked by it without risking any of the military’s personnel.
If you’re not yet acquainted with this type of aircraft, these some Charter jet information:

Limited Seating – Businessmen, who need to visit a certain plain as fast as possible, without following the commercial flight’s schedule, generally use this sort of aircraft. Most folks think that this aircraft are consistently private and can just be used by two to five men. It actually is based on the size of the charter jet, some can accommodate up to 20 men, which is fewer than a particular commercial aircraft, so you can undoubtedly travel with another group and just break up the expenses. Nevertheless, it’s limited seating to ensure a decent and relaxing flight.

Topnotch Standards – Traveling by charter jet is definitely more expensive than by commercial airplane but with the additional amount which you spent, you are sure to appreciate high quality and topnotch service beginning from the facilities up to the crew.

If you’re planning to have a wonderful holiday or if you have to make an immediate flight, make sure to check charter jets out and you are certain to locate a travel service that perfectly suits your preference.

Comments Off on Using a script to look for drone companies

Filed under Uncategorized

New Drone Laws in August 2016

This week the FAA released new drone regulations that will change for ever aviation. This sweeping change will make it so that anyone over 16 can take a written test and obtain a license to fly commercial drones. A drone operator in Wilmington NC has already met the requirements of the FAA to operate drones. New operators will take a test, wait for a TSA background check, meet the local regulation requirements, and start flying.

DJI is one of the most common drone manufactures that make drones for private and commercial use. These drones use advanced algorithms, GPS, and frequencies to provide the operator with a way to operate the drone safely.

Commercial drone operators still need to abide by a big requirement to no fly over people. Flying over people is not safe and should not be done without the consent of those involve. A closed set filming operation mitigates some of that risk the general public.

Flying near airports requires prior approval. Flying near airplanes is hazardous and should be avoided. To request approval to fly near an airport, the operator will seek approval from a central FAA computer before operating.

Comments Off on New Drone Laws in August 2016

Filed under Uncategorized

Code for deleting all wordpress database

In this post I share how to delete all the posts, comments, tags, and such with a wordpress site.  To delete the proper data from the database you need to know which data is connected and how.  wordpress.org does a great job of describing this in full detail but you can basically see the connection and get through the code below without it.  The following script could take a wordpress site like http://privateschoolsreviews.com  and delete the entire site except for the theme and settings.  It would be blank slate to start over essentially.

The goal is to clean the data from the following tables:

  •  wp_posts
  • wp_term_relationships
  •  wp_term_taxonomy
  • wp_terms

The following code is slightly incomplete but a little modification would have it up and running.

return(mysql_connect(MYSQL_ADDRESS, MYSQL_USERNAME, MYSQL_PASSWORD));
}
$mysql_connect = connect_to_database();
mysql_select_db(‘table’, $mysql_connect);

# Execute SQL command
$sql=”TRUNCATE TABLE wp_posts”;//e_state =’NC’
$result = mysql_query($sql, $mysql_connect);
echo “posts”.mysql_error();

$sql=”TRUNCATE TABLE wp_terms”;//e_state =’NC’
$result = mysql_query($sql, $mysql_connect);
echo “terms”.mysql_error();

$sql=”TRUNCATE TABLE wp_term_relationships”;//e_state =’NC’
$result = mysql_query($sql, $mysql_connect);
echo “terms”.mysql_error();

$sql=”TRUNCATE TABLE wp_term_taxonomy”;//e_state =’NC’
$result = mysql_query($sql, $mysql_connect);
echo “posts”.mysql_error();

$sql=”TRUNCATE TABLE wp_posts”;//e_state =’NC’
$result = mysql_query($sql, $mysql_connect);
echo mysql_error();

$sql=”TRUNCATE TABLE wp_posts”;//e_state =’NC’
$result = mysql_query($sql, $mysql_connect);
echo mysql_error();

TRUNCATE TABLE simply removes all the rows from the tables without deleting the table .  The structure remains but the information that was saved has been removed.  You should make a backup of your entire database because this is not reversible.

 

Comments Off on Code for deleting all wordpress database

Filed under Uncategorized

php Forward Script

Are you looking for a simple script to forward visitors to a new page?  How about have them see the old page and meScripts Gurusmo to update
their bookmarks or show a disclaimer before they are forwarded.  This snazzy little piece of code will do that and even forward to one random page out of the ones that you designate.

 

<?php

$r=rand(1,5);
//  echo any information to the browser then forward

sleep(3); // seconds to pause.
if($r==1)
header(“Location: http://your destination site address”);
if($r==2)
header(“Location: http://your destination site address”);
if($r==3)
header(“Location: http://your destination site address”);
if($r==4)
header(“Location: http://your destination site address”);
if($r==5)
header(“Location: http://your destination site address”);

exit;

?>

A site about private charter jets would benefit from this type of script.  Let’s assume that the site owner wanted to have a simple way to advertise and rotate banners.  He/she could have one lead generation source and direct those leads to 1 of 5 different full-fillers.  As a user visited the site and looked for a particular flight to book, the script would be available behind the banner or text link to one of the advertisers.  If the traveler clicks on the link it will randomly select, show the disclaimer, then forward the link as selected.

The header() function also has the ability to forward with the association of the type of forward.  It isn’t really that much of a use in this usage on a travel site and for this purpose but it may help if you were going to move a site and needed to let the search engines know that the forward was because the page had permanently moved.

Use this for “AB” testing.  If you are running a campaign and want to see which form works better and provides more leads or conversions, use this script to test which one randomly converts.  It is also great for affiliate links and testing which advertisers do a better job of converting the traffic you send them.  I would think that even a kickstarter campaign would be able to make use of this simple 20 line code.

Enjoy and good coding.

Comments Off on php Forward Script

Filed under Uncategorized

Import a Large CSV file into Database

In thiScripts Gurus post I would like to show you how I import a large csv file into a database.  I typically use the import function in my phpadmin and import the file that way but if the file is too large and times out I have to resort to other ways.  I use a “Library” file to handle the mysql connection to the database and insert to the database.  I will cover than in another post.
This script will take the csv file which have uploaded to your host server and parse it and insert it into the database.  The column names will transfer to the database and become the column names in the table.  I didn’t take the time to make a key or unique column but that can be easily done in the phpadmin.  After the file is opened by the script it will be parsed by the comma line by line.  Each line is processed and put into the database table.  Don’t forget to use the “addslashes()” to the script to work with special characters.

<?php

include(‘LIB_mysql.php’);
$fn = ‘Your_CSV_FILE.csv’;

$fd = fopen($fn, “r”);

$sql=”CREATE TABLE Your_New_Table
(
“;
$flag=0;
$xxy=0;
while (!feof($fd)) {

$fields = fgetcsv($fd, 0, “,”);

if($flag==0){
$flag=1;
for($x=0;$x<count($fields);$x++){
$data_fields[$x]=$fields[$x];
if($x>0){
$sql.=”, “;
}
// If the field is a special type then set the type in the database here.
if($fields[$x]==’LEANM09′ ||$fields[$x]==’SCHNAM09′ || $fields[$x]==’MSTREE09′ ||$fields[$x]==’LSTREE09′ ||$fields[$x]==’LCITY09′ ||$fields[$x]==’CONAME09′ ||$fields[$x]==’Location’ ){
$sql.=$fields[$x].” varchar(60)”;
}else{
$sql.=$fields[$x].” varchar(16)”;
}
}

$sql.=”)”;

}else{
{
unset($data_array);
for($x=0;$x<count($fields);$x++){

$data_array[$data_fields[$x]]=addslashes($fields[$x]);
if($data_array[$data_fields[$x]]==”){
$data_array[$data_fields[$x]]=0;
}
}

insert(‘Your_Database’, ‘Your_New_Table’, $data_array);
}

}

}

php?>

This script is great for those wanting to import a large data file to use with wordpress.  I have used this for many different imports such as for hospital databases.  The hospital database was very large and couldn’t be imported with the phpadmin function.  The nurse uniforms database was for the nurses, and doctors, and those in the medical field to find uniforms.  The data was fairly massive and so the script ran without it issue for the initial upload.

Comments Off on Import a Large CSV file into Database

Filed under Uncategorized