\s\n\s\s\s\s\s(\s*)
/', '
', $bookmark); $bookmark = preg_replace('/<\/A>\s\n\s\s\s\s\s(\s*)<\/DL>
/', '', $bookmark); //echo"$bookmark"; preg_match_all('/\s\n\s\s\s\s
";
for ($j = 0; $j < $general_link_count; $j++)
{
//echo"general_url $j: $general_url[$j] name: $general_name[$j]
";
$query = "SELECT * FROM $tablelinks WHERE link_url='$general_url[$j]'";
$result = $wpdb->query($query);
//echo "res: $result
";
if ($result != 1)
{
//$results = $wpdb->get_results("SELECT * FROM $tablelinkcategories WHERE cat_name='cat_ID[$i]'");
$query = "SELECT * FROM $tablelinkcategories WHERE cat_name='General'";
$result = $wpdb->query($query);
if($result == 1)
{
$query = "SELECT * FROM $tablelinkcategories WHERE cat_name='General'";
$results = $wpdb->get_row($query);
$general_cat_ID = $results->cat_id;
}
else
{
echo"
Inserting category General
";
$over_all_cat_count = 1;
$query = "INSERT INTO $tablelinkcategories (cat_id, cat_name, auto_toggle, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, text_before_link, text_after_link, text_after_all, list_limit ) VALUES ('0', 'General', 'N', 'Y', 'Y', 'Y', 'Y', 'name', 'N', '
*\s\n*\s(.*?)(
imp: $cat_ID[$i]
";
//echo"folder: $folder[$i]
";
//$results = $wpdb->get_results("SELECT cat_id FROM $tablelinkcategories WHERE cat_name="$cat_ID");
$query = "SELECT * FROM $tablelinkcategories WHERE cat_name='$cat_ID[$i]'";
$result = $wpdb->query($query);
//echo "res: $result
";
if ($result != 1)
{
echo"
Inserting category $cat_ID[$i].
";
$over_all_cat_count = $over_all_cat_count + 1;
//echo "INSERT INTO $tablelinkcategories (cat_id, cat_name, auto_toggle, show_images, show_description, show_rating, show_updated, sort_order, sort_desc, text_before_link, text_after_link, text_after_all, list_limit) VALUES ('0', '$cat_ID[$i]', 'N', 'Y', 'Y', 'Y', 'Y', 'name', 'N', '
";
}
preg_match_all('/(.*?)<\/A>/', $folder[$i], $b_links);
$b_url = $b_links[1];
$b_name = $b_links[5];
$link_count = count($b_url);
//echo" Inserted {$names[$i]} All done! We added $over_all_cat_count"; ?> categories and $over_all_link_count"; ?> links. Go manage your links.
folder: $folder[$i]
link_count: $link_count
";
for ($j = 0; $j < $link_count; $j++)
{
//echo"url $j: $b_url[$j] name: $b_name[$j]
";
$query = "SELECT * FROM $tablelinks WHERE link_url='$b_url[$j]'";
$result = $wpdb->query($query);
//echo "res: $result
";
if ($result != 1)
{
//$results = $wpdb->get_results("SELECT * FROM $tablelinkcategories WHERE cat_name='cat_ID[$i]'");
$query = "SELECT * FROM $tablelinkcategories WHERE cat_name='$cat_ID[$i]'";
$results = $wpdb->get_row($query);
//echo"results: $results->cat_id
";
$over_all_link_count = $over_all_link_count + 1;
//echo "INSERT INTO $tablelinks (link_url, link_name, link_target, link_category, link_description, link_owner) VALUES('$b_url[$j]', '$b_name[$j]', '', $results->cat_id, '', $user_ID)";
$query = "INSERT INTO $tablelinks (link_url, link_name, link_target, link_category, link_description, link_owner) VALUES('$b_url[$j]', '$b_name[$j]', '', $results->cat_id, '', $user_ID)";
$result = $wpdb->query($query);
}
}
/*$query = "INSERT INTO $tablelinks (link_url, link_name, link_target, link_category, link_description, link_owner)
VALUES('{$urls[$i]}', '".addslashes($names[$i])."', '{$targets[$i]}', $cat_id, '".addslashes($titles[$i])."', $user_ID)\n";
$result = $wpdb->query($query);
echo "