![]() | | ||||||||
| | #1 |
| HyperActive Warrior War Room Member Join Date: May 2010
Posts: 425
Thanks: 47
Thanked 21 Times in 8 Posts
|
I need a way to export all the trackback links from the wordpress comments queue. But just the trackback ones, not the spammy comments with links in them. Is there a plugin or something else for that? |
| | |
| | #2 |
| HyperActive Warrior War Room Member Join Date: May 2010
Posts: 425
Thanks: 47
Thanked 21 Times in 8 Posts
|
Please? |
| | |
| | #3 |
| Watching you... War Room Member Join Date: Dec 2008 Location: Waterdown, Ontario, Canada
Posts: 6,498
Blog Entries: 2 Thanks: 1,757
Thanked 3,046 Times in 1,815 Posts
|
To export where? Why don't you delete the spam first, so that you have only real feedback there...? |
| | |
| | |
| | #4 |
| HyperActive Warrior War Room Member Join Date: May 2010
Posts: 425
Thanks: 47
Thanked 21 Times in 8 Posts
|
to a whatever list just the urls of the sites sent trackbacks (linking to me) |
| | |
| | #5 |
| Watching you... War Room Member Join Date: Dec 2008 Location: Waterdown, Ontario, Canada
Posts: 6,498
Blog Entries: 2 Thanks: 1,757
Thanked 3,046 Times in 1,815 Posts
|
Post in the Programming Talk subforum and ask for somebody with MySQL query knowledge. You will need a query that lists only the commen_type = trackback. |
| | |
| | |
| | #6 |
| HyperActive Warrior War Room Member Join Date: May 2010
Posts: 425
Thanks: 47
Thanked 21 Times in 8 Posts
|
i can do that, but i was looking for an automated/ready solution
|
| | |
| | #7 |
| Watching you... War Room Member Join Date: Dec 2008 Location: Waterdown, Ontario, Canada
Posts: 6,498
Blog Entries: 2 Thanks: 1,757
Thanked 3,046 Times in 1,815 Posts
|
Learn MySQL ![]() go to your phpMyadmin > select the database > click the wp_comments on the left Click "Search" on the top - and leave all the fields selected In the field where it says: Add search conditions (body of the "where" clause): - type this: comment_type = "trackback" Hit the GO button next to it... It should list only the TBs. Then select all and Export. |
| | |
| | |
| | #8 |
| HyperActive Warrior War Room Member Join Date: May 2010
Posts: 425
Thanks: 47
Thanked 21 Times in 8 Posts
|
Thanks ![]() Seems that it can also be exported to excel and do whatever you want then ![]() pretty cool! |
| | |
| | #9 |
| HyperActive Warrior War Room Member Join Date: Jun 2009
Posts: 109
Thanks: 7
Thanked 25 Times in 15 Posts
|
Hi Fking, I've been looking for something similar, found a cool tool promoted by a fellow warrior: Wordpress Indexing Plugin - Use With SEO Link Vine , UAW, AMA,FTS The tool looks rock star, I will test it out next week. Hope this helps |
| | |
![]() |
|
| Tags |
| comments, exporting, links, queue, trackback, wordpress |
| Thread Tools | |
| |
![]() |