readtable

[content_band style=”color: #333;” bg_color=”#ffddea” border=”all” inner_container=”true”] [custom_headline style=”margin-top: 0;” level=”h3″ looks_like=”h3″]Control Panel[/custom_headline]

[insert_php]
global $ipt_fsqm_info, $wpdb;
$current_user = wp_get_current_user();
$formid=$current_user->description;
echo “FORM>>”,$formid.PHP_EOL;
$fordb=$current_user->user_login;
$syntax=’blog_id=1&orderby=nicename&role=subscriber’;
$blogusers = get_users($syntax);
$total=0;
foreach ( $blogusers as $user ) {
$ematch=$user->user_email;
$user = get_user_by( ’email’, $ematch );
$checker=$user->description;
if ($fordb==$checker){
//echo $ematch;
$sql=”SELECT mcq FROM 4zgc14mywebsitetransfercom_1667397749.wp_fsq_data WHERE (form_id = $formid AND email=’$ematch’)”;
$myrows = $wpdb->get_var($sql);
$myheaders = mysqli_real_query($sqlx);
print_r($myheaders);
//print_r($myrows);
//
echo “GOING FOR IT>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>”.PHP_EOL;

$needle = “i:”;
$lastPos = 0;
$positions = array();
while (($lastPos = strpos($myrows, $needle, $lastPos))!== false) {
$positions[] = $lastPos;
$lastPos = $lastPos + strlen($needle);
}
// Displays 3 and 10
$counter=0;
foreach ($positions as $value) {
// echo $value .”
“;
$postart[$counter]=$value;
$counter=$counter+1;
}
//
echo “FROM THE FORM>>>>>>>>>>>>”.PHP_EOL;
$needle = “:{s:”;
$lastPos = 0;
$positions = array();
while (($lastPos = strpos($myrows, $needle, $lastPos))!== false) {
$positions[] = $lastPos;
$lastPos = $lastPos + strlen($needle);
}
// Displays 3 and 10
$counter=0;
foreach ($positions as $value) {
//echo $value .”
“;
$posend[$counter]=$value;
$subby[$counter]=substr($myrows,$postart[$counter]+2,$posend[$counter]-$postart[$counter]);
//echo $subby.PHP_EOL;
$counter=$counter+1;
}
//
$counter=0;
foreach ($subby as $value) {
$itshere=strpos($value,”;”);
$dada=substr($value,0,$itshere);
//echo $dada.PHP_EOL;
$mcqer[$counter]=$dada;
$counter=$counter+1;
}
//IF THINGS GO WRONG UNDO THE BELOW REPORT
//print_r($mcqer);
//
//CHECKITOUT
echo “NOW GOING TO REPORT ON HEADERS>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>”;
$sqlx=”DESCRIBE 4zgc14mywebsitetransfercom_1667397749.wp_fsqm_direct_$formid”;
echo $sqlx.PHP_EOL;
$myrows=$wpdb->get_results($sqlx,ARRAY_A);
//print_r($myrows);
for ($i = 0; $i < count($myrows); $i++) { $compare[$i]=$myrows[$i][Field]; } //print_r($compare); $counter=0; for ($i = 0; $i < count($compare); $i++) { $test=substr($compare[$i],0,3); if ($test=="mcq") { //echo "MCQ DETECTED".PHP_EOL; $compareme[$counter]=substr($compare[$i],3); $counter=$counter+1; } if ($test=="pin") { echo "PIN detected at ".$i.PHP_EOL; if ($i‘;$total=$total+1;} else {
$real=$real+1;}
}}
//START COMPARE
$bad=0;
echo “END”.PHP_EOL;
if (count($mcqer)==count($compareme)) {echo “Database correct length”.PHP_EOL;} else {echo “Database compare length error”.PHP_EOL;}
for ($i = 0; $i < count($compareme); $i++) { //echo "GO>“.$mcqer[$i].”COMPARE “.$compareme[$i].PHP_EOL;
if ($mcqer[$i]==$compareme[$i]) {
echo “”;} else {echo “”;$bad=$bad+1;}
}
echo “Total number of bads “.$bad.PHP_EOL;
if ($bad>0) {
echo “Fixing bad arrangement”.PHP_EOL;
//first is always after ref
$appender=’mcq’.$mcqer[0];
echo “First Fix>”.$appender.PHP_EOL;
$sql=”ALTER TABLE 4zgc14mywebsitetransfercom_1667397749.wp_fsqm_direct_$formid MODIFY COLUMN $appender BIGINT AFTER ref”;
$results = $wpdb->get_results($sql);
for ($i = 1; $i < count($mcqer); $i++) { $appendix='mcq'.$mcqer[$i]; //echo $i."Fix>“.$appendix.PHP_EOL;
$sql=”ALTER TABLE 4zgc14mywebsitetransfercom_1667397749.wp_fsqm_direct_$formid MODIFY COLUMN $appendix BIGINT AFTER $appender”;
echo $sql.PHP_EOL;
$results = $wpdb->get_results($sql);
$appender=$appendix;
}
} else
{echo “Nothing to fix”.PHP_EOL;}
[/insert_php]