jonathandsimmons

Hmm, when I initially posted this I thought I had a css issue. If you ready through my both my post you’ll find I realized it was actually a style sheet link reference.

I’d love to try and help you figure out your problem. Could you give me a little more detail about your circumstances?

I fixed it. I should know by now not to code past midnight.

To be honest it must have just been a type somewhere because this morning I opened the file and typed the following and it worked fine.

require_once(‘myfolder/myfile.php’);

I found that this is only possible by using the excerpt window when creating a post. If you let WordPress auto generate the excerpt the links will not be live as it does not parse the excerpt fully.

Got it. Yes I was still logged in as admin. I never thought to log out.

That did it. Well you forgot the ( after get_users but other wise great.

for anyone else looking you should have:

get_users('blog_id=' . $myvar . '&orderby=nicename&role=subscriber');

Thanks again for the help I had tried a few things but didn’t put the spaces after the periods. So glad that did it!

Thanks I those are great options. I tired switch to blog bt it was a little more work than I wanted. In the end I was able to achieve my goal with get_blog_option.

Again Thanks for the advice Tim.

Are you referring to having a different login username?

or could you rather elaborate as to which user name your are referring to please?

Using get_row fixed my issue and I was able to assign it the he variable with my above mentioned method. Thanks for the help guys.

Thanks tim, I’m moving on to some php tutorial site and forums. I appreciate your help though.

ok so I got it to show me the array properly after realizing I never declared the output type. So now a clean version of my code is:

$testing = $wpdb->get_results( "SELECT * FROM $wpdb->options WHERE option_name = 'siteurl'", OBJECT_K);
print_r($testing);

which results in:

Array ( [0] => Array ( [option_id] => 1 [blog_id] => 0 [option_name] => siteurl [option_value] => https://examplesite.com/ [autoload] => yes ) )

can anyone tell me how I can assign this values to a new variable?

I tried:

$testing = $testing['option_value'];

but that did not work.

The weird thing is I know the query is working. If I remove the WHERE and everything after it outputs the desired table. Something is going wrong when I try to specify a particular option_name.

any ideas what I’ve got wrong in the code?

So I just tried this. I made sure was on a user site as I know I’m not yet specifying a user or blog in the query (don’t even know if I will be able to?). I’ve also switched to something more obvious for the option_name so the code is now

<?php  $testing = $wpdb->get_results( "SELECT FROM $wpdb->options WHERE option_name = '$siteurl'");
var_dump($testing);
?>

but that just gave me:
array(0) { }

rather than the site name. Thoughts?

Yes I’m aware that the account is not really deleted. I’m looking for a better notification than just the pink bar. When a user install surpasses the hundreds mark it would get old checking for what users deleted their site. To take action on canceling subscriptions or other paid services.

You’re are right though I might be able to hook to the function that is making the change. I was hoping someone had already done some of the legwork.

Also I just realized in the mysql database I changed the entry under site url and home (home was on page two)

I was incorrect in stating that it was my cpanel. It’s actually cpanel/dns/redirect. Depending on your hosting provider it may be elsewhere. Ours is dreamhost for example doesn’t do this in the dns section.

Either was when you find this in your hosting admin you can specify if the domain works with, without, or both.

A couple of examples.
this is what ours looked like: https://cl.ly/50xz
this is what one of my personal ones with a basic cpanel looks like
https://cl.ly/51TO