F2 Script Success!

/home/flockshepherd904/public_html/sli-enterprises.net/SLI-Include/sli-test2.inc
/home/flockshepherd904/public_html/sli-enterprises.net/SLI-Include/sli-test2.inc
global $SLI_Hitcount;

SLI_Populate_ISBN_Array($SLIMbrid,$SLIgenretable,$genretablekey);
/*
echo ‘list populated:(‘.$SLI_ISBN_Array[0].’)
‘;
echo ‘list populated:(‘.$SLI_ISBN_Array[1].’)
‘;
echo ‘list populated:(‘.$SLI_ISBN_Array[2].’)
‘;
echo ‘list populated:(‘.$SLI_ISBN_Array[3].’)
‘;
echo ‘list populated:(‘.$SLI_ISBN_Array[4].’)
‘;
echo ‘list populated:(‘.$SLI_ISBN_Array[5].’)
‘;
echo ‘hit count:(‘.$SLI_Hitcount.’)
‘;
*/
// set up defaults

$var_class1 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$var_style1 = “background-color: #ed0c5b; color: #ffffff;”;

$img_style1= ” “;
$img_style2= ” “;
$img_style3= ” “;
$img_style4= ” “;
$img_style5= ” “;
$img_style6= ” “;
$img_style7= ” “;
$img_style8= ” “;
$img_style9= ” “;
$img_style10= ” “;
$img_style11= ” “;
$img_style12= ” “;
$img_style13= ” “;
$img_style14= ” “;
$img_style15= ” “;

$img_pic1= ” “;
$img_pic2= ” “;
$img_pic3= ” “;
$img_pic4= ” “;
$img_pic5= ” “;
$img_pic6= ” “;
$img_pic7= ” “;
$img_pic8= ” “;
$img_pic9= ” “;
$img_pic10= ” “;
$img_pic11= ” “;
$img_pic12= ” “;
$img_pic13= ” “;
$img_pic14= ” “;
$img_pic15= ” “;

$img_authn1= ” “;
$img_authn2= ” “;
$img_authn3= ” “;
$img_authn4= ” “;
$img_authn5= ” “;
$img_authn6= ” “;
$img_authn7= ” “;
$img_authn8= ” “;
$img_authn9= ” “;
$img_authn10= ” “;
$img_authn11= ” “;
$img_authn12= ” “;
$img_authn13= ” “;
$img_authn14= ” “;
$img_authn15= ” “;

$var_class0 = “ 0)
{
$var_isbn = $SLI_ISBN_Array[0];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;

$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);

$var_class1 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style1 = “ “;

$img_authn1 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title1 = $book_2_row[1];
$var_style1 = “background-color: #eb177a; color: #ffffff;”;
}

if ($match_count > 1)
{
$var_isbn = $SLI_ISBN_Array[1];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class2 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style2 = “ “;

$img_authn2 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title2 = $book_2_row[1];
$var_style2 = “background-color: #af09d9; color: #ffffff;”;
}

if ($match_count > 2)
{
$var_isbn = $SLI_ISBN_Array[2];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class3 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style3 = “ “;

$img_authn3 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title3 = $book_2_row[1];
$var_style3 = “background-color: #ba5b48; color: #ffffff;”;
}

if ($match_count > 3)
{
$var_isbn = $SLI_ISBN_Array[3];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class4 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style4 = “ “;

$img_authn4 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title4 = $book_2_row[1];
$var_style4 = “background-color: #e6c027; color: #ffffff;”;
}

if ($match_count > 4)
{
$var_isbn = $SLI_ISBN_Array[4];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class5 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style5 = “ “;

$img_authn5 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title5 = $book_2_row[1];
$var_style5 = “background-color: #09eded; color: #ffffff;”;
}

if ($match_count > 5)
{
$var_isbn = $SLI_ISBN_Array[5];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class6 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style6 = “ “;

$img_authn6 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title6 = $book_2_row[1];
$var_style6 = “background-color: #9927d6; color: #ffffff;”;
}

if ($match_count > 6)
{
$var_isbn = $SLI_ISBN_Array[6];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class7 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style7 = “ “;

$img_authn7 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title7 = $book_2_row[1];
$var_style7 = “background-color: #e08620; color: #ffffff;”;
}

if ($match_count > 7)
{
$var_isbn = $SLI_ISBN_Array[7];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class8 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style8 = “ “;

$img_authn8 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title8 = $book_2_row[1];
$var_style8 = “background-color: #2be3c7; color: #ffffff;”;
}

if ($match_count > 8)
{
$var_isbn = $SLI_ISBN_Array[8];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class9 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style9 = “ “;

$img_authn9 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title9 = $book_2_row[1];
$var_style9 = “background-color: #6ce304; color: #ffffff;”;
}

if ($match_count > 9)
{
$var_isbn = $SLI_ISBN_Array[9];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class10 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style10 = “ “;

$img_authn10 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title10 = $book_2_row[1];
$var_style10 = “background-color: #0e15eb; color: #ffffff;”;
}

if ($match_count > 10)
{
$var_isbn = $SLI_ISBN_Array[10];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class11 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style11 = “ “;

$img_authn11 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title11 = $book_2_row[1];
$var_style11 = “background-color: #eb177a; color: #ffffff;”;
}

if ($match_count > 11)
{
$var_isbn = $SLI_ISBN_Array[11];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class12 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style12 = “ “;

$img_authn12 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title12 = $book_2_row[1];
$var_style12 = “background-color: #af09d9; color: #ffffff;”;
}

if ($match_count > 12)
{
$var_isbn = $SLI_ISBN_Array[12];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class13 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style13 = “ “;

$img_authn13 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title13 = $book_2_row[1];
$var_style13 = “background-color: #ba5b48; color: #ffffff;”;
}

if ($match_count > 13)
{
$var_isbn = $SLI_ISBN_Array[13];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class14 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style14 = “ “;

$img_authn14 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title14 = $book_2_row[1];
$var_style14 = “background-color: #e6c027; color: #ffffff;”;
}

if ($match_count > 14)
{
$var_isbn = $SLI_ISBN_Array[14];
$book_2_query = “(SELECT $booktableisbn,$booktabletitle,$bookphotolink,$bookauthfname,$bookauthlname FROM $SLIbooktable WHERE $booktableisbn = \”$var_isbn\”)”;
$book_2_result = mysql_query($book_2_query);
$book_2_row = mysql_fetch_row($book_2_result);
$var_class15 = “fasc-button fasc-size-large fasc-type-popout fasc-rounded-medium ico-fa fasc-ico-before fa-book”;
$img_style15 = “ “;

$img_authn15 = “by: “.$book_2_row[3].” “.$book_2_row[4];

$var_title15 = $book_2_row[1];
$var_style15 = “background-color: #09eded; color: #ffffff;”;
}

// Finally update the member table with the isbns
// SELECT Syntax for member_profile_table

$selcount = 0;
$memberuserkey = ‘T01_email’;
$memberusertable = ‘member_profile_table’;

$query = “SELECT * FROM $memberusertable WHERE $memberuserkey = \”$SLIMbrid\””;

$result = mysql_query($query)
or die (“Couldn’t execute query.”);

$memberrow = mysql_fetch_assoc($result);

// Now the member record is in the $memberrow Array

$SLI_mbr_type = $memberrow[“T01_mbr_type”];
$SLI_join_date = $memberrow[“T01_join_date”];
$SLI_pass = $memberrow[“T01_pass”];
$SLI_login_switch = $memberrow[“T01_login_switch”];
$SLI_first_name = $memberrow[“T01_first_name”];
$SLI_last_name = $memberrow[“T01_last_name”];
$SLI_bio = $memberrow[“T01_bio”];
$SLI_photo_link = $memberrow[“T01_photo_link”];
$SLI_book_count = $memberow[“T01_book_count”];
$SLI_page_visits = $memberrow[“T01_page_visits”];
$SLI_slipper_total = $memberrow[“T01_slipper_total”];

// Finally update the member table with the isbns

mysql_query(“REPLACE INTO $memberusertable
SET
T01_email=\”$SLIMbrid\”,
T01_mbr_type = \”$SLI_mbr_type\”,
T01_join_date = \”$SLI_join_date\”,
T01_pass = \”$SLI_pass\”,
T01_login_switch = \”$SLI_login_switch\”,
T01_first_name = \”$SLI_first_name\”,
T01_last_name = \”$SLI_last_name\”,
T01_bio = \”$SLI_bio\”,
T01_photo_link = \”$SLI_photo_link\”,
T01_book_count = \”$SLI_book_count\”,
T01_page_visits = \”$SLI_page_visits\”,
T01_slipper_total = \”$SLI_slipper_total\”,
T01_slider_list01=$SLI_ISBN_Array[0],
T01_slider_list02=$SLI_ISBN_Array[1],
T01_slider_list03=$SLI_ISBN_Array[2],
T01_slider_list04=$SLI_ISBN_Array[3],
T01_slider_list05=$SLI_ISBN_Array[4],
T01_slider_list06=$SLI_ISBN_Array[5],
T01_slider_list07=$SLI_ISBN_Array[6],
T01_slider_list08=$SLI_ISBN_Array[7],
T01_slider_list09=$SLI_ISBN_Array[8],
T01_slider_list10=$SLI_ISBN_Array[9],
T01_slider_list11=$SLI_ISBN_Array[10],
T01_slider_list12=$SLI_ISBN_Array[11],
T01_slider_list13=$SLI_ISBN_Array[12],
T01_slider_list14=$SLI_ISBN_Array[13],
T01_slider_list15=$SLI_ISBN_Array[14],
T01_slider_list16=$SLI_ISBN_Array[15],
T01_slider_list17=$SLI_ISBN_Array[16],
T01_slider_list18=$SLI_ISBN_Array[17],
T01_slider_list19=$SLI_ISBN_Array[18],
T01_slider_list20=$SLI_ISBN_Array[19]
“)
or die (‘REPLACE did not work ‘.mysql_error());

[/insert_php]

 

[insert_php]
echo $img_style1;echo $img_pic1;echo $var_class0;echo $var_class1;
[/insert_php]

style=”
[insert_php]
echo $var_style1;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg001/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style1;
[/insert_php]
“>
[insert_php]
echo $var_title1;
[/insert_php]
[insert_php]
echo $img_authn1;
[/insert_php]

[insert_php]
echo $img_style2;echo $img_pic2;echo $var_class0;echo $var_class2;
[/insert_php]

style=”
[insert_php]
echo $var_style2;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg002/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style2;
[/insert_php]
“>
[insert_php]
echo $var_title2;
[/insert_php]
[insert_php]
echo $img_authn2;
[/insert_php]

[insert_php]
echo $img_style3;echo $img_pic3;echo $var_class0;echo $var_class3;
[/insert_php]

style=”
[insert_php]
echo $var_style3;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg003/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style3;
[/insert_php]
“>
[insert_php]
echo $var_title3;
[/insert_php]
[insert_php]
echo $img_authn3;
[/insert_php]

[insert_php]
echo $img_style4;echo $img_pic4;echo $var_class0;echo $var_class4;
[/insert_php]

style=”
[insert_php]
echo $var_style4;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg004/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style4;
[/insert_php]
“>
[insert_php]
echo $var_title4;
[/insert_php]
[insert_php]
echo $img_authn4;
[/insert_php]

[insert_php]
echo $img_style5;echo $img_pic5;echo $var_class0;echo $var_class5;
[/insert_php]

style=”
[insert_php]
echo $var_style5;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg005/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style5;
[/insert_php]
“>
[insert_php]
echo $var_title5;
[/insert_php]
[insert_php]
echo $img_authn5;
[/insert_php]

[insert_php]
echo $img_style6;echo $img_pic6;echo $var_class0;echo $var_class6;
[/insert_php]

style=”
[insert_php]
echo $var_style6;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg006/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style6;
[/insert_php]
“>
[insert_php]
echo $var_title6;
[/insert_php]
[insert_php]
echo $img_authn6;
[/insert_php]

[insert_php]
echo $img_style7;echo $img_pic7;echo $var_class0;echo $var_class7;
[/insert_php]

style=”
[insert_php]
echo $var_style7;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg007/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style7;
[/insert_php]
“>
[insert_php]
echo $var_title7;
[/insert_php]
[insert_php]
echo $img_authn7;
[/insert_php]

[insert_php]
echo $img_style8;echo $img_pic8;echo $var_class0;echo $var_class8;
[/insert_php]

style=”
[insert_php]
echo $var_style8;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg008/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style8;
[/insert_php]
“>
[insert_php]
echo $var_title8;
[/insert_php]
[insert_php]
echo $img_authn8;
[/insert_php]

[insert_php]
echo $img_style9;echo $img_pic9;echo $var_class0;echo $var_class9;
[/insert_php]

style=”
[insert_php]
echo $var_style9;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg009/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style9;
[/insert_php]
“>
[insert_php]
echo $var_title9;
[/insert_php]
[insert_php]
echo $img_authn9;
[/insert_php]

[insert_php]
echo $img_style10;echo $img_pic10;echo $var_class0;echo $var_class10;
[/insert_php]

style=”
[insert_php]
echo $var_style10;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg010/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style10;
[/insert_php]
“>
[insert_php]
echo $var_title10;
[/insert_php]
[insert_php]
echo $img_authn10;
[/insert_php]

[insert_php]
echo $img_style11;echo $img_pic11;echo $var_class0;echo $var_class11;
[/insert_php]

style=”
[insert_php]
echo $var_style11;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg011/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style11;
[/insert_php]
“>
[insert_php]
echo $var_title11;
[/insert_php]
[insert_php]
echo $img_authn11;
[/insert_php]

[insert_php]
echo $img_style12;echo $img_pic12;echo $var_class0;echo $var_class12;
[/insert_php]

style=”
[insert_php]
echo $var_style12;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg012/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style12;
[/insert_php]
“>
[insert_php]
echo $var_title12;
[/insert_php]
[insert_php]
echo $img_authn12;
[/insert_php]

[insert_php]
echo $img_style13;echo $img_pic13;echo $var_class0;echo $var_class13;
[/insert_php]

style=”
[insert_php]
echo $var_style13;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg013/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style13;
[/insert_php]
“>
[insert_php]
echo $var_title13;
[/insert_php]
[insert_php]
echo $img_authn13;
[/insert_php]

[insert_php]
echo $img_style14;echo $img_pic14;echo $var_class0;echo $var_class14;
[/insert_php]

style=”
[insert_php]
echo $var_style14;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg014/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style14;
[/insert_php]
“>
[insert_php]
echo $var_title14;
[/insert_php]
[insert_php]
echo $img_authn14;
[/insert_php]

[insert_php]
echo $img_style15;echo $img_pic15;echo $var_class0;echo $var_class15;
[/insert_php]

style=”
[insert_php]
echo $var_style15;
[/insert_php]

href=”http://www.sli-enterprises.net/bookpages/bpg015/” target=”_blank” data-fasc-style=”
[insert_php]
echo $var_style15;
[/insert_php]
“>
[insert_php]
echo $var_title15;
[/insert_php]
[insert_php]
echo $img_authn15;
[/insert_php]

 

Session Manager SLIMbrid 1:
Session Manager SLIMbrid 2: 0

Loading...