$response_query = "SELECT pn.*, u.user_id, u.user_name, u.user_avatar, u.user_status
FROM ".DB_POST_NOTIFY." pn
LEFT JOIN ".DB_USERS." u ON pn.notify_sender = u.user_id
WHERE post_id='".$this->post_id."' GROUP BY pn.notify_mood_id ORDER BY pn.notify_mood_id ASC, pn.post_id ASC";
$inf_newtable[] = DB_FORUM_MOODS." (
mood_id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
mood_name TEXT NOT NULL,
mood_description TEXT NOT NULL,
mood_icon VARCHAR(50) NOT NULL DEFAULT '',
mood_notify SMALLINT(4) NOT NULL DEFAULT '-101',
mood_access SMALLINT(4) NOT NULL DEFAULT '-101',
mood_status SMALLINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (mood_id)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
$inf_newtable[] = DB_POST_NOTIFY." (
post_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
notify_mood_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
notify_datestamp INT(10) UNSIGNED NOT NULL DEFAULT '0',
notify_user MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
notify_sender MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
notify_status tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
KEY notify_datestamp (notify_datestamp)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";
Category Forum
Suspected Bugs and Errors - 9Labels
None yet
Statistics
2 participants
Notifications
You are not receiving notifications from this thread.
Related Questions