if ($db->f("rating") == 1) $ratetext = "Positive"; if ($db->f("rating") == 0) $ratetext = "Neutral"; if ($db->f("rating") == -1) $ratetext = "Negative"; $Tpl->SetBlockVar("rate", ""); $Tpl->setVar("ItemNum", $db->f("ItemNum")); $Tpl->setVar("usercomment", stripslashes($db->f("comment"))); $Tpl->setVar("rated_you", $ratetext); $Tpl->setVar("id", $db->f("id")); $query = "select * from purchases where id = '" . $db->f("purchase_id") . "'"; $db->query($query); $db->next_record(); $Tpl->setVar("title", $db->f("title")); $Tpl->Parse("counter", True); } else { $Tpl->Parse("Error", True); } } else { $Tpl->Parse("Error", True); } } elseif($_POST["id"] && $_POST["submit"]){ $db = new clsDBNetConnect; $query = "select * from feedback where `counter` = '" . $_POST["id"] . "'"; $db->query($query); if (!$db->next_record()){ $query = "insert into feedback (`counter`, `being_rated`, `comment`, `date`) values ('" . $_POST["id"] . "', '" . CCGetUserID() . "', '" . mysql_escape_string($_POST["comment"]) . "', '" . time() . "')";
$textdesc[$custtxt->f("id")] = $custtxt->f("description"); $textname[$custtxt->f("id")] = $custtxt->f("name"); $count++; } $custtxt->seek(); $queryfields .= ") and"; while ($custtxt->next_record()) { $Tpl->SetVar("ta_name", multiline($textname[$custtxt->f("id")])); $Tpl->SetVar("ta_description", multiline($textdesc[$custtxt->f("id")])); $Tpl->SetVar("ta_var", "custtxt_area::" . $textvar[$custtxt->f("id")] . "::" . $custtxt->f("id")); $Tpl->SetVar("ta_value", stripslashes($fieldvalues[$custtxt->f("id")])); $Tpl->SetVar("ta_name_" . $custtxt->f("id"), multiline($textname[$custtxt->f("id")])); $Tpl->SetVar("ta_description_" . $custtxt->f("id"), multiline($textdesc[$custtxt->f("id")])); $Tpl->SetVar("ta_var_" . $custtxt->f("id"), "custtxt_area::" . $textvar[$custtxt->f("id")] . "::" . $custtxt->f("id")); $Tpl->SetVar("ta_value_" . $custtxt->f("id"), stripslashes($fieldvalues[$custtxt->f("id")])); $Tpl->Parse("Row", True); } $Tpl->Parse("Custom_TextArea", True); } ////////////////////////////// //Custom TextBox ////////////////////////////// $txtvar = ""; $txtdesc = ""; $txtname = ""; $custtxtvalues = ""; $custtxt = ""; $fieldvalues = ""; $Tpl->SetBlockVar("Custom_TextBox", ""); $custtxt = new clsDBNetConnect(); $query = "select * from custom_textbox where {$cats} and `searchable` = '1'";