Forum Replies Created
-
for rss ? ok..
the remove_filter “plugin” works
Thank you very much
it was a test plugin .. i tried to understand the db relationships, and i did .. now i know now how to update a post tag .. so there is nothing usable?
ok
Applause
Great! .. im gonna try it right now
brb..Update 1: No mail yet. Dont know if i have set that up correct. Can see this in phpmyadmin, in wp_users..
ID : 2
user_login : xxxxxxx
user_pass : 63db6f94498b383aa4eebb38b9d41505
user_nicename :
user_email : xxxxxx@gmail.com
user_url :
user_registered : 2007-11-26 08:21:45
user_activation_key :
user_status : 0
display_name :
user_activation_key shouldnt be empty ?
Update 2: in wp_usermeta..
umeta_id : 12
user_id : 2
meta_key : act_code
meta_value : 12345678 (eight numbers & letters value)
dammit! this is a winxp test server with wamp.. dont think mail() works here
Yess .. i did it..
Wrote some lines that gets a posts TAGS .. how do i proceed ?
<?php
//
// Fetch a WP posts tags by Kent
//
$db_type = 'mysql';
$db_host = 'localhost';
$db_name = 'xxxxx';
$db_user = 'xxxxx';
$db_pass = 'xxxxx';
// Just picked one, for testing.
$post_id = "6";
@mysql_connect($db_host,$db_user,$db_pass) or die ("Couldnt connect to database!");
@mysql_select_db($db_name) or die ("Couldnt select the requested MySQL table!");
$fetch_post_tags = mysql_query("
SELECT
wp_posts.ID AS POID,
wp_term_relationships.object_id AS RELID,
wp_term_relationships.term_taxonomy_id AS TAXID,
wp_term_taxonomy.taxonomy AS TAXONO,
wp_term_taxonomy.term_id AS TAX_TERID,
wp_terms.term_id AS TERID,
wp_terms.name AS HOT_TAG_NAME
FROM
wp_posts,
wp_term_relationships,
wp_term_taxonomy,
wp_terms
WHERE
(wp_posts.ID = wp_term_relationships.object_id AND wp_posts.ID = '$post_id')
AND
(wp_term_taxonomy.taxonomy = 'post_tag' AND wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
AND
(wp_term_taxonomy.term_id = wp_terms.term_id)
ORDER BY wp_terms.name ASC
") or die ("Cant fetch data!");
if (mysql_num_rows($fetch_post_tags) > 0)
{
$rowid = 1;
echo "<table border="1">";
echo "<caption>WP posts tags</caption>";
echo "<tr style="background-color: #DDEAD5;">";
echo "<th scope="col">Post ID</th><th scope="col">Tag</th></tr>";
while ($blog = mysql_fetch_array($fetch_post_tags))
{
if ($rowid == 1)
{
echo "<tr><th scope="row">" . $blog['POID'] . "</th>";
}
else
{
echo "<tr><th scope="row"> </th>";
}
echo "<td>" . $blog['HOT_TAG_NAME'] . "</td></tr>";
$rowid++;
}
echo "</table>";
}
else
{
echo "Found nothing!";
}
?>Please dont kill me.. im no pro coder..
fel: ok.. to bad .. im trying figure out the relationships in the DB , seems complex. Why isnt there a wp_tags table?
Will you implement it? or should i try do some coding myself?
hmm ok
think ill wait and get back to that page later then..
omg sry ..
add_profile_tab(__(‘Name’), ‘edit_profile’, ‘moderate’, ‘this-file-was-missing.php’);
So many ppl in this forum .. i can’t breathe
cant get new profile tab/page link to work..
