ODLinks - Edit/Remove links

' . $msg . '

'; if($loadpage==true) odlinksadmin_main_links(0, 0); echo ''; } function odlinksadmin_approve_links($id, $action){ global $_GET, $_POST, $wpdb, $table_prefix; $odlinkssettings=get_option('odlinksdata'); $linkb=$PHP_SELF."?page=odlinksposts&odlinks_admin_page_arg=odlinksposts"; if(isset($id) && $action){ switch($action){ case "ok": ?>

Approving new link ....

get_results($sql); for($i=0; $iget_results($sql); for($x=0; $xn_url == $row>l_id){ $warning .= 'Warning: This URL already exists:'; $warning .= ''; $warning .= '

'; } } ?>

URL:

Title:

Email:

Description:

Visible?

Category:

  

Deleted link...

get_results($sql); for($i=0; $in_url."
"; echo "Title: ".$row->n_title."
"; echo "Description: ".$row->n_description."
"; echo "Email: ".$row->n_email."
"; } $url_back = admin_url("admin.php?page=odlinksposts&odlinks_admin_page_arg=odlinksposts&odlinks_admin_action=approvelinks"); echo '

'; $sql="DELETE FROM {$table_prefix}odnew_links WHERE n_id=$id"; $wpdb->query($sql); }else{ ?>

Removing a new link...

get_results($sql); for($i=0; $i

Are you sure you want to delete the website n_url ?>?

  
query($sql); ?>

New link added:


URL:
Title:
Email:
Description:
Category id:

'; $sql="DELETE FROM {$table_prefix}odnew_links WHERE n_url='$url'"; $wpdb->query($sql); break; case "edit": $id=$_POST['odlinksdata']['id']; $url=$_POST['odlinksdata']['url']; $title=$_POST['odlinksdata']['title']; $description=$_POST['odlinksdata']['description']; $parent=$_POST['odlinksdata']['parent']; $email=$_POST['odlinksdata']['email']; $sql="update {$table_prefix}odlinks (l_url, l_title, l_description, l_c_id, l_hide, l_author_mail) VALUES ('".$url."', '".$title."', '".$description."', '".$parent."', 'visible', '".$email."') WHERE l_id=" .$id; $wpdb->query($sql); ?>

Updated:


URL:
Title:
Email:
Description:
Category id:

The site removed from the approval list.

query($sql); $sql="INSERT INTO {$table_prefix}odbanned (c_domain) VALUES('".$new_ban_url."')"; $wpdb->query($sql); echo "and added as ban to the banned list!"; }else{ ?>

Banning a new link/site ...

get_results($sql); for($i=0; $i
The URL, or URL parts to be added to the "banned URLs" list:

  

Newly submitted links ready to be approved:

get_results($sql); if(!empty($results)){ ?>
".$row->n_url.""; print ""; print ""; print ""; ?>
Ok Website URL Title & Description Category Email DeleteBan
n_url."\">".$row->n_title.""; print "
".$row->n_description."
".$row->n_email."
query($sql); ?>

The record added to the list of banned IP addresses.

Record:

'; break; case "edit": $sql="SELECT * FROM {$table_prefix}odbanned WHERE b_id=$id"; $results=$wpdb->get_results($sql); for($i=0; $i

Edit Banned Strings/Urls

  

The selected ban record deleted from the list successfully.

get_results($sql); for($i=0; $iRecord: ".$row->c_domain."
"; } $url_back = admin_url("admin.php?page=odlinksposts&odlinks_admin_page_arg=odlinksposts&odlinks_admin_action=bannedlinks"); echo '

'; $sql="DELETE FROM {$table_prefix}odbanned WHERE b_id=$id"; $wpdb->query($sql); }else{ ?>

Removing a Banned record...

get_results($sql); for($i=0; $i

Are you sure you want to delete this entry?
String: c_domain?>

  

This page displays the banned IP/URL addresses.
You can choose to edit or delete a specific ban record.
The URLs that contains any banned string will be automatically rejected.

Add a banned address to the list

Record:

get_results($sql); if(!empty($results)){ ?>
b_id."\">".$row->c_domain.""; echo "
Edit URL/IP/String Delete
b_id ."\">"; } ?>
query($sql); ?>

Record updated successfully.


URL:
Title:
Email:
Description:
Category id:

'; } } function odlinksadmin_edit_ban($id){ global $_GET, $_POST, $wpdb, $table_prefix; $odlinkssettings=get_option('odlinksdata'); if(isset($id)){ $id=$_POST['odlinksdata']['id']; $url=$_POST['odlinksdata']['url']; $sql="update {$table_prefix}odbanned set c_domain='".$url."' WHERE b_id=" .$id; $wpdb->query($sql); ?>

Record updated successfully.

String:

'; } } function odlinksadmin_main_links($id, $action){ global $table_prefix, $wpdb, $_GET; $linkb=$PHP_SELF."?page=odlinksposts&odlinks_admin_page_arg=odlinksposts"; if(isset($id) && $action){ switch($action){ case "delete": if(isset($_POST['odlinksdata']['delete_link'])){ ?>

Deleted link...

get_results($sql); for($i=0; $il_url."
"; echo "Title: ".$row->l_title."
"; echo "Description: ".$row->l_description."
"; echo "Email: ".$row->l_author_mail."
"; } $sql="DELETE FROM {$table_prefix}odlinks WHERE l_id=$id"; $wpdb->query($sql); }else{ ?>

Deleted link ....

get_results($sql); for($i=0; $i

Are you sure you want to delete the website l_url?>?

  
get_results("SELECT * FROM {$table_prefix}odlinks WHERE l_id='".$id."'"); if(!empty($results)) { for($i=0; $i

Edit Website




  

get_row($sql, ARRAY_A); $NumberOfResults=$result['count']; $sql="SELECT * FROM {$table_prefix}odlinks"; $results=$wpdb->get_results($sql); if(!empty($results)){ ?>

 

l_hide == "visible"){ $new_link="Yes"; } else{ $new_link="No"; } echo ""; echo ""; print ""; print ""; echo "
Edit WebSite URL Visible Title Date Delete
l_url ?> ".$new_link."l_url."\">".$row->l_title."".$row->l_date.""; echo"l_id ."\">"; ?>