Execute($sql); if ($recordSet === false) { log_error($sql); } // get main listings data while (!$recordSet->EOF) { $listing_Title = make_db_unsafe ($recordSet->fields['Title']); $recordSet->MoveNext(); } // end while if ($ekle == "") { // Listeyi Gösterir $listingID = isset($listingID) ? $listingID : 0; $kasa = Oyu_Al($listingID); //if ($kasa['Sayi']!= 0) { $html .= "
$listing_Title Comments New Comment
|
Close Page
";
//}
// find the number of users
$sql="SELECT
Adi,
Oy,
Tarih,
Yorum
FROM
" . $config['table_prefix'] . "Yorumlar
WHERE
Listing_ID = $listingID AND
Aktif = 1
ORDER BY
Tarih DESC";
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$recordSet = $conn->Execute($sql);
if ($recordSet === false) log_error($sql);
$num_rows = $recordSet->RecordCount();
$html .= next_prev2($num_rows, $cur_page, ""); // put in the next/previous stuff
// build the string to select a certain number of users per page
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$limit_str = $cur_page * $config['listings_per_page'];
$recordSet = $conn->SelectLimit($sql, $config['listings_per_page'], $limit_str );
if ($recordSet === false) log_error($sql);
$say = $limit_str;
$count = 0;
//$html .= "\n Please Enter Fullname Please Enter Your Comment Please Enter Email Please Enter Overall Satisfaction
General Rating :
\n";
$html .= "
";
while (!$recordSet->EOF) {
// alternate the colors
if ($count == 0)
{
$count++;
}
else
{
$count = 0;
}
//strip slashes so input appears correctly
//$edit_Yorum_ID = $recordSet->fields['Yorum_ID'];
//$edit_Listing_ID = make_db_unsafe ($recordSet->fields['Listing_ID']);
$edit_Adi = make_db_unsafe ($recordSet->fields['Adi']);
//$edit_Telefon = make_db_unsafe ($recordSet->fields['Telefon']);
//$edit_Email = make_db_unsafe ($recordSet->fields['Email']);
$edit_Oy = make_db_unsafe ($recordSet->fields['Oy']);
$edit_Oy1 = make_db_unsafe ($recordSet->fields['Oy1']);
$edit_Oy2 = make_db_unsafe ($recordSet->fields['Oy2']);
$edit_Oy3 = make_db_unsafe ($recordSet->fields['Oy3']);
$edit_Oy4 = make_db_unsafe ($recordSet->fields['Oy4']);
$edit_month = make_db_unsafe ($recordSet->fields['month']);
$edit_year = make_db_unsafe ($recordSet->fields['year']);
$edit_Yorum = make_db_unsafe ($recordSet->fields['Yorum']);
//$edit_Aktif = $recordSet->fields['Aktif'];
$edit_Tarih = $recordSet->UserTimeStamp($recordSet->fields['Tarih'],'j M Y');
$html .= "
".($say+1)."
$edit_Adi
$edit_Tarih
$edit_Yorum
";
$recordSet->MoveNext();
$say++;
} // end while
$html .= "
\r\n\r\n";
$html .= "
";
}
else {
$action = isset($action) ? $action : '';
if ($action != "createNewUser")
{
// first, grab the user's main info
global $conn;
// $sql = "SELECT * FROM " . $config['table_prefix'] . "UserDB WHERE ID = '$edit'";
$sql="SELECT
" . $config['table_prefix'] . "listingsDB.ID,
" . $config['table_prefix'] . "listingsDB.Title
FROM
" . $config['table_prefix'] . "listingsDB
WHERE
" . $config['table_prefix'] . "listingsDB.ID = $listingID
ORDER BY
" . $config['table_prefix'] . "listingsDB.Title ;";
$listingss = Array();
$sad = 0;
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
$recordSet = $conn->Execute($sql);
if ($recordSet === false) log_error($sql);
while (!$recordSet->EOF) {
// collect up the main DB's various fields
$listingss[$sad] = Array();
$listingss[$sad]['ID'] = $recordSet->fields['ID'];
$listingss[$sad]['Title'] = make_db_unsafe ($recordSet->fields['Title']);
$recordSet->MoveNext();
$sad++ ;
} // end while
$html .= "
";
} // end ($action != "createNewUser")
else
{
// create the user
if ($edit_Adi == "")
{
$html .= "