viewallsmart5

[insert_php]
global $wpdb;
$level=$_GET[‘level’];
echo “Level number “.$level.PHP_EOL;
$current_user = wp_get_current_user();
$fordb=$current_user->user_login;
$uem=$current_user->user_email;
//echo $uem.PHP_EOL;
$formid=$current_user->description;
echo “Form Number >”.$formid.PHP_EOL;

$sql=”SELECT layout FROM i3121151_wp1.wp_fsq_form WHERE id=$formid”;
$sqll=”SELECT design FROM i3121151_wp1.wp_fsq_form WHERE id=$formid”;
$fname= $wpdb->get_var($sql);
$testing= $wpdb->get_var($sqll);

$sections=((substr_count($fname, ‘”title”‘))-1);
//echo “Number of sections>”.$sections.PHP_EOL;
$finda='”title”‘;
$findb=”subtitle”;

$headings=array();$totalq=array();

for ($x = 2; $x <= $sections; $x++) { $sectiona=strposx($fname,"timer",$x); $sectionb=strposx($fname,"timer",$x+1); $newsection=substr($fname,$sectiona,($sectionb-$sectiona)); $quests=substr_count($newsection,"container"); //echo "Quests>“.$quests;
$totalq[$x-1]=$quests;
$posa=strposx($fname,$finda,$x+1);
$posb=strposx($fname,$findb,$x+1);
$newstring=substr($fname,$posa+10,(($posb-10)-$posa));
$quotestart=strposx($newstring,'”‘,1);
$quoteend=strposx($newstring,'”‘,2);
$newstring=substr($newstring,$quotestart+1,(($quoteend-$quotestart)-1));
//echo $newstring.PHP_EOL;
$headings[$x-1]=$newstring;
}
//print_r($headings);
//print_r($totalq);

//echo $fname.PHP_EOL.PHP_EOL;

mysql_close();

function rev ($string, $char)
{
if (false !== strrpos ($string, $char))
{
return strlen ($string) – strrpos ($string, $char) – 1;
}
}

function strposX($haystack, $needle, $number){
if($number == ‘1’){
return strpos($haystack, $needle);
}elseif($number > ‘1’){
return strpos($haystack, $needle, strposX($haystack, $needle, $number – 1) + strlen($needle));
}else{
return error_log(‘Error: Value for parameter $number is out of range’);
}
}

//extract sub questions

$count=0;$qnumber=0;
$subq=array();

foreach($headings as $key => $value) {

for ($x = 1; $x <= $totalq[$key]; $x++) {$finder="Question P".($x+$qnumber); //echo $finder.PHP_EOL; $whereit=strpos($testing,$finder); $keepers=substr($testing ,0,$whereit); $whereit2=rev($keepers,"richtext"); $whereit3=strlen($keepers)-$whereit2; $lengy=$whereit3-$whereit; //echo "HERE ".$whereit." IS IS ".$whereit3." LENG>“.$lengy.PHP_EOL;
$mememe=substr($testing,$whereit3,($whereit-$whereit3));
$gobegin=strposx($mememe,”:”,4);
$goend=strposx($mememe,”:”,5);
$tada=substr($mememe,$gobegin+2,($goend-$gobegin)-5);
$count=$count+1;$subq[$count]=$tada;
//echo $tada.PHP_EOL;
}
$qnumber=$qnumber+$totalq[$key];
}
//print_r($subq);

$resulttable=”wp_fsqm_direct_”.$formid;

$sqll=”SELECT count(id) FROM $resulttable”;
$resulter= $wpdb->get_var($sqll);
//echo “THIS IS IT>”.$resulter.PHP_EOL;
//echo $sqll.PHP_EOL;

$sqll=”SELECT pinfo0 FROM $resulttable”;
$namelist=$wpdb->get_results($sqll);
//print_r($namelist);
$namelistfull=array();
foreach ($namelist as $key => $value) {
$namelistfull[$key]=$value->pinfo0;
}
//print_r($namelistfull);

for ($x = 1; $x <= $resulter; $x++) { $offer=$x-1; $sql="SELECT * FROM $resulttable ORDER BY id LIMIT 1 OFFSET $offer"; //echo $sql; $resultz= $wpdb->get_row($sql);
//print_r($resultz);

$userinput=array();$count=0;

foreach ($resultz as $key => $value) {
$subs = substr($key, 0, 3);
if ($subs==”mcq”){$count=$count+1;$userinput[$count]=$value;}
}
//print_r($userinput);
$len = count($userinput);
$r[$x]= array_slice($userinput,0, $len / 2);
$p[$x]=array_slice($userinput, $len / 2);
//print_r($r);//print_r($p);

}
//echo “The r’s original”.PHP_EOL;
//print_r($r);
//echo “The p’s original”.PHP_EOL;
//print_r($p);

$len = count($headings);
$newheadings= array_slice($headings,0, $len / 2);
//print_r($newheadings);

//slice and dice time
$sliceme=$totalq[$level+1];
//echo “slicing by “.$sliceme.PHP_EOL;
$elance = count($r);
$elance=intval($elance);
//echO “Elance is “.$elance.PHP_EOL;

$onyourmarks=0;

if ($level>0){
for ($x = 1; $x <= $level;$x++) { $onyourmarks=$onyourmarks+$totalq[$x]; } } //echo "Starting block is ".$onyourmarks.PHP_EOL; for ($x = 1; $x <= $elance;$x++) { $outputr[$x] = array_slice($r[$x],$onyourmarks,$sliceme); $outputp[$x]= array_slice($p[$x],$onyourmarks,$sliceme); } $r=$outputr; $p=$outputp; //echo "The r's original".PHP_EOL; //print_r($r); //echo "The p's original".PHP_EOL; //print_r($p); //end slice $fruit = array ( "0p0" => array(“0”),
“0p1” => array(“0”),
“0p2” => array(“0”),
“0p3” => array(“0”),
“0p4” => array(“0”),
“0p5” => array(“0”),
“0p6” => array(“0”),
“0p7” => array(“0”),
“0p8” => array(“0”),
“0p9” => array(“0”),
“0p10” => array(“0”),

“1p0” => array(“0”),
“1p1” => array(“0”),
“1p2” => array(“0”),
“1p3” => array(“0”),
“1p4” => array(“0”),
“1p5” => array(“0”),
“1p6” => array(“0”),
“1p7” => array(“0”),
“1p8” => array(“0”),
“1p9” => array(“0”),
“1p10” => array(“0”),

“2p0” => array(“0”),
“2p1” => array(“0”),
“2p2” => array(“0”),
“2p3” => array(“0”),
“2p4” => array(“0”),
“2p5” => array(“0”),
“2p6” => array(“0”),
“2p7” => array(“0”),
“2p8” => array(“0”),
“2p9” => array(“0”),
“2p10” => array(“0”),

“3p0” => array(“0”),
“3p1” => array(“0”),
“3p2” => array(“0”),
“3p3” => array(“0”),
“3p4” => array(“0”),
“3p5” => array(“0”),
“3p6” => array(“0”),
“3p7” => array(“0”),
“3p8” => array(“0”),
“3p9” => array(“0”),
“3p10” => array(“0”),

“4p0” => array(“0”),
“4p1” => array(“0”),
“4p2” => array(“0”),
“4p3” => array(“0”),
“4p4” => array(“0”),
“4p5” => array(“0”),
“4p6” => array(“0”),
“4p7” => array(“0”),
“4p8” => array(“0”),
“4p9” => array(“0”),
“4p10” => array(“0”),

“5p0” => array(“0”),
“5p1” => array(“0”),
“5p2” => array(“0”),
“5p3” => array(“0”),
“5p4” => array(“0”),
“5p5” => array(“0”),
“5p6” => array(“0”),
“5p7” => array(“0”),
“5p8” => array(“0”),
“5p9” => array(“0”),
“5p10” => array(“0”),

“6p0” => array(“0”),
“6p1” => array(“0”),
“6p2” => array(“0”),
“6p3” => array(“0”),
“6p4” => array(“0”),
“6p5” => array(“0”),
“6p6” => array(“0”),
“6p7” => array(“0”),
“6p8” => array(“0”),
“6p9” => array(“0”),
“6p10” => array(“0”),

“7p0” => array(“0”),
“7p1” => array(“0”),
“7p2” => array(“0”),
“7p3” => array(“0”),
“7p4” => array(“0”),
“7p5” => array(“0”),
“7p6” => array(“0”),
“7p7” => array(“0”),
“7p8” => array(“0”),
“7p9” => array(“0”),
“7p10” => array(“0”),

“8p0” => array(“0”),
“8p1” => array(“0”),
“8p2” => array(“0”),
“8p3” => array(“0”),
“8p4” => array(“0”),
“8p5” => array(“0”),
“8p6” => array(“0”),
“8p7” => array(“0”),
“8p8” => array(“0”),
“8p9” => array(“0”),
“8p10” => array(“0”),

“9p0” => array(“0”),
“9p1” => array(“0”),
“9p2” => array(“0”),
“9p3” => array(“0”),
“9p4” => array(“0”),
“9p5” => array(“0”),
“9p6” => array(“0”),
“9p7” => array(“0”),
“9p8” => array(“0”),
“9p9” => array(“0”),
“9p10” => array(“0”),

“10p0” => array(“0”),
“10p1” => array(“0”),
“10p2” => array(“0”),
“10p3” => array(“0”),
“10p4” => array(“0”),
“10p5” => array(“0”),
“10p6” => array(“0”),
“10p7” => array(“0”),
“10p8” => array(“0”),
“10p9” => array(“0”),
“10p10” => array(“0”),);

$allin=array();
for ($x = 1; $x <= $resulter; $x++) { foreach ($p[$x] as $key => $value) {
//echo $key;
$fruitref=$r[$x][$key].”p”.$p[$x][$key];
//echo $fruitref.PHP_EOL;
$fruitnow=$fruit[$fruitref][$x-1];
$fruitnow=$fruitnow+1;
$fruit[$fruitref][$x-1]=$fruitnow;

$allin[$x][$key]=$r[$x][$key].”,”.$p[$x][$key].”,'”.$namelistfull[$x-1].”‘”;

}
//print_r($fruit);
}
//print_r($allin);
$googleit=””;

for ($x = 1; $x <= $resulter; $x++) { foreach ($p[$x] as $key => $value) {
$fruitref=$r[$x][$key].”p”.$p[$x][$key];
$allin[$x][$key]=$allin[$x][$key].”,”.$fruit[$fruitref][$x-1];

$googleit=$googleit.”[‘X’,”.$allin[$x][$key].”],”.”
“;
}
}
//print_r($allin);
//print_r($fruit);

$googleit=substr($googleit, 0, -5);
//echo $googleit;
$titleit=$newheadings[$level];

[/insert_php]