prefix . 'admin_user_message';
$table_users = $wpdb->prefix . 'users';
/*
//finde alle Nachrichten, die an current_user versendet hat
$query = "SELECT * FROM yojoma_admin_user_messages WHERE sender = '$current_user->ID' ORDER BY date DESC, time DESC";
$result = mysql_query($query);
$num_rows = mysql_num_rows($result);
*/
if(isset($_POST['pageingSubmitted'])) {
$actualPageOrg = $_POST['actualPage'];
$userid = $_POST['userid'];
$actualPage = $actualPageOrg-1;
$actualPage = $actualPage * 10;
$query = "SELECT * FROM $table_name where sender = '$userid' ORDER BY date DESC, time DESC limit $actualPage,10";
$result = mysql_query($query);
} else {
$query = "SELECT * FROM $table_name WHERE sender = '$current_user->ID' ORDER BY date DESC, time DESC limit 0,10";
$result = mysql_query($query);
$firstCall = "true";
}
$num_rows = mysql_num_rows($result);
$queryPageingObject = "SELECT * FROM $table_name WHERE sender = '$current_user->ID' ORDER BY date DESC, time";
$resultPageingObject = mysql_query($queryPageingObject);
$num_rowsPageingObject = mysql_num_rows($resultPageingObject);
?>
= '1') {
while($row = mysql_fetch_row($result)) {
//finde den EmpfŠnger Nickname aus der Usertabelle
$queryReceiver = "SELECT user_nicename FROM $table_users WHERE ID = '$row[2]'";
$resultReceiver = mysql_query($queryReceiver);
?>