prefix . 'admin_user_message'; $table_users = $wpdb->prefix . 'users'; if(isset($_POST['pageingSubmitted'])) { $actualPageOrg = $_POST['actualPage']; $userid = $_POST['userid']; $actualPage = $actualPageOrg-1; $actualPage = $actualPage * 10; $query = "SELECT * FROM $table_name where receiver = '$userid' ORDER BY date DESC, time DESC limit $actualPage,10"; $result = mysql_query($query); } else { $query = "SELECT * FROM $table_name WHERE receiver = '$current_user->ID' ORDER BY date DESC, time DESC limit 0,10"; $result = mysql_query($query); $firstCall = "true"; } $num_rows = mysql_num_rows($result); /* if(!$num_rows) { echo "Folgender Fehler trat bei der Abfrage auf: ".mysql_error(); } */ $queryPageingObject = "SELECT * FROM $table_name WHERE receiver = '$current_user->ID' ORDER BY date DESC, time"; $resultPageingObject = mysql_query($queryPageingObject); $num_rowsPageingObject = mysql_num_rows($resultPageingObject); ?>
| | |
" . $count . ""; } } } else { if ($actualPageOrg == $count) { echo $count . " | "; } else { if ($firstCall == 'true' && $count == '1') { echo $count . " | "; } else { echo "" . $count . ""," | "; } } } $count++; } ?>
= '1') { while($row = mysql_fetch_row($result)) { //finde den Absender Nickname aus der Usertabelle $querySender = "SELECT user_nicename FROM $table_users WHERE ID = '$row[1]'"; $resultSender = mysql_query($querySender); ?>
: : : :
45) { $cutString = "..."; } else { $cutString = ""; } if ($row[6] == '0') { ?> );> );>