<?php /** * Ohyes Theme * @website Link: https://github.com/lianglee/OhYesTheme * @Package Ohyes * @subpackage Theme * @author Liang Lee * @copyright All right reserved Liang Lee 2014. * @ide The Code is Generated by Liang Lee php IDE. */ $user = elgg_get_logged_in_user_entity()->guid; $get = "SELECT DISTINCT sender FROM prefixes_ohyes_chat WHERE(reciever='{$user}' AND view='0')"; $messages = OhYesChat::Data($get, 'get'); foreach ($messages as $friend) { $friend = get_user($friend->sender); $icon = elgg_view("icon/default", array('entity' => $friend, 'size' => 'tiny')); ?> <div class="friends-list-item" onClick="OhYesChat.newTab(<?php echo $friend->guid; ?> );"> <div class="icon" style="display: inline-table;"> <?php echo $icon; ?> </div> <div class="name" style="display: inline-table;margin-top: -8px;margin-left: 5px;"><?php echo OhYesChat::sttl($friend->name, 23); ?> </div> </div>
/** * Delete Messsages * * Delete older than one 7 days * @NOTE: action is not reversable * */ public function messagesDelete() { global $CONFIG; $delete = "DELETE FROM {$CONFIG->dbprefix}ohyes_chat \n WHERE time < UNIX_TIMESTAMP(\n\t\t\t\t\t\t\tDATE_SUB(NOW(), INTERVAL 7 DAY)\n\t\t\t\t\t\t )"; if (OhYesChat::Data($delete, 'delete')) { return true; } return false; }