$table_row = get_data_abs($cbs, $nr, $oms, $regio, $cbs2, $regio2, $col, $eindjaar);
echo $table_row;
$rand = start_graph();
$nr = 1687;
$oms = 'percentage achterstandsleerlingen op totaal aantal basisschoolleerlingen';
$graph = true;
$eindjaar = false;
$cols = array('val3', 'val7');
$scale = 100;
$table_row = get_data_cols($cbs, $regio, $nr, $oms, $graph, $cols, $rand, $eindjaar, $scale, $cbs2, $regio2);
echo $table_row;
echo "</tbody>";
echo "</table>";
include 'source.php';
$graph_title = 'percentage achterstandsleerlingen';
$graph_type = 'single_bar_graph';
$xml_file = date("Ymd") . $rand;
show_graph($graph_title, $graph_type, $rand, $xml_file, $cbs, $cbs2, $regio, $regio2);
?>
<div id="BarChartJeugd5"></div>
<script type="text/javascript"><!--
var BarChartJeugd5 = new FusionCharts( "../fusioncharts/Column3D.swf",
"BarChartJeugd_5", "625", "350", "0", "1" );
BarChartJeugd5.setXMLUrl("../temp/<?php
echo $xml_file;
?>
.xml");
BarChartJeugd5.render("BarChartJeugd5");
// -->
</script>
function wpr_dashboard()
{
global $wpdb;
$action = @$_GET['action'];
switch ($action) {
case 'graph':
$nid = (int) $_GET['nid'];
show_graph($nid);
break;
default:
?>
<style>
#throw {
font-family:Tahoma, Geneva, sans-serif;
font-size:17px;
background-color: #dae5d8;
color:#666;
padding: 10px;
}
#throw td {
padding: 10px;
font-weight: bold;
}
#statstable {
background-color: #dae5d8;
margin-bottom:10px;
}
.statrow {
background-color:#FFF;
}
#news {
}
</style>
<div style="display:block;">
<div class="wrap">
<table width="100%" >
<tr>
<td valign="top"><table width="100%">
<tr>
<td>
<div style="display:block;">
<h2>Subscriber Count</h2>
<table cellpadding="10" id="statstable" width="100%">
<br/>
<tr id="throw">
<td>Newsletter Name</td>
<td>Confirmed Subscribers</td>
<td>Unconfirmed Subscribers</td>
<td>Unsubscribed Subscibers</td>
</tr>
<?php
$query = "select * from " . $wpdb->prefix . "wpr_newsletters";
$ns = $wpdb->get_results($query);
foreach ($ns as $n) {
?>
<tr class="statrow">
<td style="padding: 10px;"><?php
echo $n->name;
?>
</td>
<td style="padding: 10px;"><?php
$nid = $n->id;
$query = "select count(*) num from " . $wpdb->prefix . "wpr_subscribers where nid={$nid} and active=1 and confirmed=1;";
$num = $wpdb->get_results($query);
$num = (int) $num[0]->num;
echo $num;
?>
</td>
<td style="padding: 10px;"><?php
$nid = $n->id;
$query = "select count(*) num from " . $wpdb->prefix . "wpr_subscribers where nid={$nid} and active=1 and confirmed=0;";
$num = $wpdb->get_results($query);
$num = (int) $num[0]->num;
echo $num;
?>
</td>
<td style="padding: 10px;"><?php
$nid = $n->id;
$query = sprintf("select count(*) num from {$wpdb->prefix}wpr_subscribers where nid=%d and active=0 and confirmed=1;", $nid);
$num = $wpdb->get_results($query);
$num = (int) $num[0]->num;
echo $num;
?>
</td>
</tr>
<?php
}
?>
</table>
</div>
<hr size="1" color="#CCCCCC"/>
<hr size="1" color="#CCCCCC"/>
<h2>Subscribe to the WP Responder Email Newsletter</h2>
Enter your name and email address below to subscribe to the WP Responder newsletter. <br />
<table>
<tr>
<td style="padding-left:40px; border: 1px solid #ccc; background-color:#FFF; padding:20px;">
<form action="http://www.wpresponder.com/?wpr-optin=1" method="post">
<span class="wpr-subform-hidden-fields">
<input type="hidden" name="blogsubscription" value="all" />
<input type="hidden" name="newsletter" value="1" />
<input type="hidden" name="fid" value="1" />
</span>
<table>
<tr>
<td><span class="wprsfl wprsfl-name">Name:</span></td>
<td><span class="wprsftf wpr-subform-textfield-name"><input type="text" name="name" /></td>
</tr>
<tr>
<td><span class="wprsfl wprsfl-email">E-Mail Address:</span></td>
<td><span class="wprsftf wpsftf-email"><input type="text" name="email" /></span>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" value="Subscribe" class="button-primary" /></td>
</tr>
<tr>
<td colspan="2" align="center"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<h2>Report A Bug</h2>
<div id="reportbug"><form method="post" id="reportform" action="http://www.expeditionpost.com/wpr/sb.php">
<table width="100%">
<tr>
<td>Name:</td>
<td><label>
<input type="text" size="90" name="name" id="name" />
</label></td>
</tr>
<tr>
<td>E-Mail Address:</td>
<td><label>
<input type="text" size="90" name="email" id="email" />
</label></td>
</tr>
<tr>
<td>Description:</td>
<td><label>
<textarea name="desc" id="desc" cols="60" rows="6"></textarea>
</label></td>
</tr>
<tr>
<td>Steps To Replicate:</td>
<td><label>
<textarea name="stepstoreplicate" id="stepstoreplicate" cols="60" rows="5"></textarea>
</label></td>
</tr>
<tr>
<td> </td>
<td><label>
<input name="button" class="button-primary" type="submit" id="button" onclick="MM_validateForm('name','','R','email','','RisEmail','title','','R','desc','','R','stepstoreplicate','','R');return document.MM_returnValue" value="Submit Bug" />
</label></td>
</tr>
</table>
</form>
</div></td>
<td></td>
</tr>
</table></td>
</tr>
</table>
</div>
</a>
<?php
break;
}
}
}
$life = $user->max_rpc_time - $user->create_time;
$ind = $life / $granularity;
$ind = (int) $ind;
$yarr[$ind]++;
if ($ind > $maxind) {
$maxind = $ind;
}
}
$xarr = array();
for ($i = 0; $i <= $maxind; $i++) {
$xarr[$i] = $i;
if (is_null($yarr[$i])) {
$yarr[$i] = 0;
}
}
if ($show_text) {
show_text($xarr, $yarr);
} else {
draw_graph($xarr, $yarr);
}
}
function show_form()
{
echo "\n\t\t<form action=user_graph.php>\n\t\tX axis:\n\t\t<select name=xaxis>\n\t\t<option value=active>Active time\n\t\t</select>\n\n\t\t<p>\n\t\tY axis:\n\t\t<select name=yaxis>\n\t\t<option value='count'>Count\n\t\t<option value='rac'>RAC\n\t\t<option value='tc'>Total credit\n\t\t</select>\n\n\t\t<p>\n\t\tShow active users?\n\t\t<input type=checkbox name=active>\n\n\t\t<p>\n\t\tShow inactive users?\n\t\t<input type=checkbox name=inactive>\n\n\t\t<p>\n\t\tGranularity:\n\t\t<input name=granularity value=86400>\n\n\t\t<p>\n\t\tShow as text?\n\t\t<input type=checkbox name=show_text>\n\n\t\t<p>\n\t\t<input type=submit name=submit value=OK>\n\t\t</form>\n\t";
}
if ($_GET['submit']) {
show_graph();
} else {
show_form();
}
function wpr_dashboard()
{
global $wpdb;
$action = @$_GET['action'];
switch ($action) {
case 'graph':
$nid = (int) $_GET['nid'];
show_graph($nid);
break;
default:
?>
<style>
#throw {
font-family:Tahoma, Geneva, sans-serif;
font-size:17px;
background-color: #dae5d8;
color:#666;
padding: 10px;
}
#throw td {
padding: 10px;
font-weight: bold;
}
#statstable {
background-color: #dae5d8;
margin-bottom:10px;
}
.statrow {
background-color:#FFF;
}
#news {
}
</style>
<div class="wrap">
<table width="100%" >
<tr>
<td valign="top"><table width="100%">
<tr>
<td>
<div style="display:block;">
<h2>Subscriber Count</h2>
<table cellpadding="10" id="statstable" width="100%">
<br/>
<tr id="throw">
<td>Newsletter Name</td>
<td>Confirmed Subscribers</td>
<td>Unconfirmed Subscribers</td>
<td>Unsubscribed Subscibers</td>
</tr>
<?php
$query = "select * from " . $wpdb->prefix . "wpr_newsletters";
$ns = $wpdb->get_results($query);
foreach ($ns as $n) {
?>
<tr class="statrow">
<td style="padding: 10px;"><?php
echo $n->name;
?>
</td>
<td style="padding: 10px;"><?php
$nid = $n->id;
$query = "select count(*) num from " . $wpdb->prefix . "wpr_subscribers where nid={$nid} and active=1 and confirmed=1;";
$num = $wpdb->get_results($query);
$num = (int) $num[0]->num;
echo $num;
?>
</td>
<td style="padding: 10px;"><?php
$nid = $n->id;
$query = "select count(*) num from " . $wpdb->prefix . "wpr_subscribers where nid={$nid} and active=1 and confirmed=0;";
$num = $wpdb->get_results($query);
$num = (int) $num[0]->num;
echo $num;
?>
</td>
<td style="padding: 10px;"><?php
$nid = $n->id;
$query = sprintf("select count(*) num from {$wpdb->prefix}wpr_subscribers where nid=%d and active=0 and confirmed=1;", $nid);
$num = $wpdb->get_results($query);
$num = (int) $num[0]->num;
echo $num;
?>
</td>
</tr>
<?php
}
?>
</table>
</div>
<hr size="1" color="#CCCCCC"/>
<hr size="1" color="#CCCCCC"/>
<h2>Subscribe to the WP Responder Email Newsletter</h2>
Enter your name and email address below to subscribe to the WP Responder newsletter. <br />
<form action="http://nodesman.com/?wpr-optin=1" method="post">
<span class="wpr-subform-hidden-fields">
<input type="hidden" name="blogsubscription" value="none" />
<input type="hidden" name="newsletter" value="6" />
<input type="hidden" name="fid" value="2" />
</span>
<table>
<tr>
<td><span class="wprsfl wprsfl-name">Name:</span></td>
<td><span class="wprsftf wpr-subform-textfield-name">
<input type="text" name="name" /></td>
</tr>
<tr>
<td><span class="wprsfl wprsfl-email">E-Mail:</span></td>
<td><span class="wprsftf wpsftf-email">
<input type="text" name="email" />
</span>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" value="Subscribe" /></td>
</tr>
<tr>
<td colspan="2" align="center"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<h2>Report A Bug</h2>
Javelin is actively developed. You can see the development progress at the <a href="https://github.com/nodesman/javelin">GitHub repo</a>. While I take great deal of efforts to ensure that the plugin is bug free, a few tend to slip through. Please open a bug report at the official repo to see a fix for it in the next release. Opening a bug takes only a minute or two. <p> <a href="https://github.com/nodesman/javelin/issues/new" class="wpr-action-button">Click here to report a bug</a></p>
</div>
<?php
break;
}
}
