table data?

Hi cybershot!

There are plugin options in the options table, but the best place to retrieve the donations data is from the dgx-donation custom post type – each donation is saved in a post of that type.

Hope this helps!

Cheers…

…Allen

that would help. But where is that custom post type in the database? I am looking for it. I found the options and I was able to get some but it doesn’t print out what I would like. I get this

Last amount contributed was 2014-02-22 02:34:24 Amount: 5.00

I was hoping to find information about the charity it was donated to and just the amount. I created a widget to get this information from the database

I can’t find that post type anywhere in the database

Hi cybershot!

If your post table is wrd_posts, you should see donations using something like

SELECT * FROMwrd_postsWHERE post_type = "dgx-donation" LIMIT 0 , 30

and then details, e.g. like the amount, should be in your post meta table, e.g.

SELECT * FROMwrd_postmeta` WHERE meta_key = “_dgx_donate_amount”

I was able to get a value for my widget. This is for a sidebar widget I made to get the last amount donated. There might be a better way but this seems to work.

$rValue = "";
        $query = ("SELECT * FROM wp_sav_postmeta WHERE meta_key = '_dgx_donate_amount';");
        $result = mysql_query($query);
        if ($row = mysql_fetch_array($result)){
            $rValue = $row[3];
			echo "Last amount donated: $" . $rValue;
		} else {
			echo "No donations as of yet.";
		}