prefix."contactdir";
if($wpdb->get_var("SHOW TABLE LIKES '".$tb."'") != $tb) {
$sql = "CREATE TABLE IF NOT EXISTS `".$tb."` (".
"`id` int(11) NOT NULL AUTO_INCREMENT,".
"`name` varchar(255) NOT NULL,".
"`email` varchar(255) NOT NULL,".
"`url` varchar(255) NOT NULL,".
"`phone` varchar(255) NOT NULL,".
"`address` text NOT NULL,".
"`cat_id` text NOT NULL,".
"`time_created` int(11) NOT NULL,".
"`status` int(1) NOT NULL,".
"PRIMARY KEY (`id`)".
") ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;";
$wpdb->query($sql);
}
if($wpdb->get_var("SHOW TABLE LIKES '".$tb."_cat'") != $tb."_cat") {
$sql2 = "CREATE TABLE IF NOT EXISTS `".$tb."_cat` (".
"`id` int(4) NOT NULL AUTO_INCREMENT,".
"`name` varchar(255) NOT NULL,".
"`status` int(1) NOT NULL,".
"PRIMARY KEY (`id`)".
") ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;";
$q = $wpdb->query($sql2);
if($q) {
$sql3 = "INSERT INTO `".$tb."_cat` (".
"`id` ,`name` ,`status`) VALUES (".
"NULL , 'General', '1');";
$wpdb->query($sql3);
}
}
$version = "3.0.1";
if(!add_option("contactdir_version",$version)) {
update_option("contactdir_version",$version);
}
$opt_ct[defstatus] = 1;
$opt_ct[showpp] = 30;
$opt_ct[template] = "%name% \nEmail: %mail% \nHemsida: %url% \nTelefon: %phone%\nAdress: %address%\n
';
echo '
';
if($_GET[update]) {
contactdir_update();
}
$version = get_option("contactdir_version");
$ver = str_replace(".","",$version);
if(substr($ver,0,2) < 23) {
echo "
You currently using old version. Please Click Here to update.
";
}
echo "
WP Contact Directory Management ";
if($_POST[Submit]) {
if($contactdir_cat_id) $contactdir_cat_id = serialize($contactdir_cat_id);
if($contactdir_medit) {
$sql = "UPDATE `$tb` SET `name` = '".$contactdir_mname."',".
"`email` = '".$contactdir_mmail."',".
"`url` = '".$contactdir_murl."',".
"`phone` = '".$contactdir_mphone."',".
"`address` = '".$contactdir_maddress."',".
"`cat_id` = '".$contactdir_cat_id."',".
"`status` = '".$contactdir_mstatus."' WHERE `id` = '".$contactdir_medit."' LIMIT 1 ;";
$q = $wpdb->query($sql);
if($q) echo "
";
} else {
$result = $wpdb->query("INSERT INTO `$tb` (`id`, `name`, `email`, `url`, `phone`, `address`, `cat_id`, `time_created`, `status`) VALUES (NULL, '$contactdir_mname', '$contactdir_mmail', '$contactdir_murl', '$contactdir_mphone', '$contactdir_maddress', '$contactdir_cat_id', '".time()."', '$contactdir_mstatus');");
if($result) echo "
";
}
}
if($_GET[edit]) {
$array = $wpdb->get_row("SELECT * FROM `$tb` WHERE `id` = '".$_GET[edit]."'",ARRAY_A);
} else {
$array[status] = 1;
}
?>
query("INSERT INTO `$tb` (`id`, `name`, `email`, `url`, `phone`, `address`, `cat_id`, `time_created`, `status`) VALUES (NULL, '".$array[0]."', '".$array[1]."', '".$array[2]."', '".$array[3]."', '".$array[4]."', '".$cat_id."', '".time()."', '".$_POST[contactdir_status]."');");
}
if($result) echo "
CSV was successfully imported.
";
endif;
}
?>
CSV Importer
CSV Table Sample
name
email
url
phone
address
Name 1
email@email1.com
http://website.com
0123434
Indo
Name 2
email@email2.com
http://website2.com
01234342
Jogja
';
}
function contactdir_addform_shortcode() {
global $wpdb,$c_url;
$tb = $wpdb->prefix."contactdir";
extract($_POST);
$opt_ct = get_option("contactdir_options");
if($contactdir_submit):
if(empty($contactdir_name) or empty($contactdir_email)) {
$error .= "Fyll i namn och e-mail!
";
}
if(!is_email($contactdir_email)) {
$error .= "Ogiltig e-mail!
";
}
$is_ex = $wpdb->get_row("SELECT `id` FROM `$tb` WHERE `email` = '$contactdir_email'",ARRAY_A);
if(is_array($is_ex)) {
$error .= "E-mailen finns redan i telefonboken
";
}
if(empty($error)) {
if($contactdir_cat_id) $contactdir_cat_id = serialize($contactdir_cat_id);
$result = $wpdb->query("INSERT INTO `$tb` (`id`, `name`, `email`, `url`, `phone`, `address`, `cat_id`, `time_created`, `status`) VALUES (NULL, '$contactdir_name', '$contactdir_email', '$contactdir_url', '$contactdir_phone', '$contactdir_address', '$contactdir_cat_id', '".time()."', '".$opt_ct[defstatus]."');");
if($opt_ct[defstatus] != 1) $apm = " and pending for approval.";
if($result) echo "
Din kontakt har lagts till$apm, Tack.
";
}
endif;
?>
$error
"; ?>
prefix."contactdir";
switch($query) {
case "alpha":
$qdb = " WHERE `name` LIKE '".$_GET[depan]."%' AND `status` = 1";
break;
case "cat":
$qdb = " WHERE `cat_id` = '".$_GET[id]."' AND `status` = 1";
break;
case "caricerdas":
$s = $_GET[contact_dir_s];
$qdb = " WHERE (`name` LIKE '%$s%' OR `email` LIKE '%$s%' OR `url` LIKE '%$s%' OR `phone` LIKE '%$s%' OR `address` LIKE '%$s%') AND `status` = 1";
break;
default:
$qdb = " WHERE `status` = 1";
break;
}
?>
';
echo '
';
echo "
WP Contact Directory ";
$version = get_option("contactdir_version");
$ver = str_replace(".","",$version);
if(substr($ver,0,2) < 23) {
echo "
You currently using old version. Please Click Here to update.
";
}
if(function_exists("file_get_contents")) {
$output = file_get_contents("http://ahlul.web.id/tools/plugads/wpcontact.php");
if($output) echo $output;
}
if($delete) {
$_POST[selected_contacts][0] = $delete;
$_POST[action] = "delete";
}
if(is_array($_POST[selected_contacts]))
{
switch($_POST[action]) {
case "aktif":
foreach($_POST[selected_contacts] as $array):
$q = $wpdb->query("UPDATE `$tb` SET `status` = 1 WHERE `id` = ".$array);
endforeach;
if($q) echo "
Selected Contacts is set to active...
";
break;
case "nonaktif":
foreach($_POST[selected_contacts] as $array):
$q = $wpdb->query("UPDATE `$tb` SET `status` = 0 WHERE `id` = ".$array);
endforeach;
if($q) echo "
Selected Contacts is set to pending...
";
break;
case "delete":
foreach($_POST[selected_contacts] as $array):
$q = $wpdb->query("DELETE FROM `$tb` WHERE `id` = ".$array);
endforeach;
if($q) echo "
Selected Contacts is deleted...
";
break;
}
}
?>
';
}
function contactdir_options() {
extract($_POST);
echo '
';
echo '
';
echo "
WP Contact Directory Options ";
if($_POST[Submit]) {
$opt_ct[defstatus] = $contactdir_defstatus;
$opt_ct[showpp] = $contactdir_showpp;
$opt_ct[css] = $contactdir_css;
$opt_ct[template] = $contactdir_template;
if(!is_numeric($contactdir_showpp)):
echo "
Number per page must be numeric...
";
else:
if(!add_option("contactdir_options",$opt_ct)) {
update_option("contactdir_options",$opt_ct);
echo "
New Configurations is saved...
";
}
endif;
}
$opt_ct = get_option("contactdir_options");
$opt_ct_defstatus = $opt_ct[defstatus];
$opt_ct_showpp = $opt_ct[showpp];
$opt_ct_css = $opt_ct[css];
$opt_ct_template = $opt_ct[template];
?>
';
}
function ahlul_credit() {
?>
Support
If you have problem or you wanna to make a website or tools please send email to me, ceo.ahlul@yahoo.com
Donate for me
If you find this plugin is usefull and want make donation for me you can send it to my paypal (ahlul_amc@yahoo.co.id) ;)
Thanks before for donation.
prefix."contactdir_cat";
if($submit and $contactdir_cat_name) {
if($contactdir_cat_edit) {
$q = $wpdb->query("UPDATE `$tb` SET `name` = '$contactdir_cat_name', `status` = '$contactdir_cat_status' WHERE `id` = '$contactdir_cat_edit'");
if($q) echo "
";
} else {
$row = $wpdb->get_row("SELECT `id` FROM `$tb` WHERE `name` = '$contactdir_cat_name'");
if($row) {
echo "
Sorry, category '$contactdir_cat_name' already exists on database...
";
} else {
$q = $wpdb->query("INSERT INTO `$tb` (`id`,`name`,`status`) VALUES (NULL,'$contactdir_cat_name',1)");
if($q):
echo "
New Categories is saved...
";
else:
echo "
Error occured, category not save...
";
endif;
}
}
}
if($_GET[delete]) {
$q = $wpdb->query("DELETE FROM `$tb` WHERE `id` = '".$_GET[delete]."'");
if($q):
echo "
";
else:
echo "
Error occured, category not deleted...
";
endif;
}
if(is_array($cat_delete) and $action = "delete") {
foreach($cat_delete as $array) {
$wpdb->query("DELETE FROM `$tb` WHERE `id` = '".$array."'");
}
echo "
All Selected Categories is deleted...
";
}
?>
';
}
function csv2array($file,$include_table_header = TRUE,$sep = ";") {
$row = 1;
if (($handle = fopen($file, "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, $sep)) !== FALSE) {
$num = count($data);
$array[] = $data;
}
fclose($handle);
if($include_table_header) $array = array_slice($array, 1);
}
return array("data"=>$array,"numfields"=>$num);
}
?>