Support » Networking WordPress » Associated database tables?

  • With the addition of a new network site, I noticed that additional database tables were added (shows you how new I am to this). How do I know which tables belong to the current site? I checked out get_current_site();, but it always returns the super-site and not the hosted network site’s information.

    Goal/Reason: My users are able to click on a link that generates a PDF document on the fly. The file, rewards.php, exists outside of WordPress. I need to be able to pass the networked site’s id so that rewards.php knows which table to pull the information from.

    Thoughts: I know that the wp_2_* tables belongs to the first hosted site. Can I create the table name with ‘wp_’ . $site_id . ‘_postmeta’ with $site_id pulled from a native WP API call? The resulting link to rewards.php being something like: rewards.php?sid=1&pid=23 (actually I would use some sort of pathetic 2-way encryption to at least give the impression that a person can’t simply change the values and get every ‘reward’ posted to each network site. rewards.php?generate=c2lkPTEmcGlkPTIz )

    Note: I will worry about security and the fact that it is pretty dumb to generate table names from the query string later.

    Stumped and tired of google…

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Associated database tables?’ is closed to new replies.