Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sneak Preview: New UNIX.COM UserCP VueJS Demo
Top Forums Web Development Sneak Preview: New UNIX.COM UserCP VueJS Demo Post 303030908 by Neo on Tuesday 19th of February 2019 04:27:37 AM
Old 02-19-2019
Update:

Created new DB table for tracking badge notifications and currently testing.

Will use this data in the new Vue UserCP I'm working on for listing the various badges users have received after testing:

Code:
mysql> describe neo_system_notifications;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| noteid   | int(10)      | NO   | PRI | NULL    | auto_increment |
| dateline | int(10)      | NO   |     | NULL    |                |
| userid   | int(10)      | NO   |     | NULL    |                |
| username | varchar(100) | NO   |     | NULL    |                |
| count    | int(10)      | NO   |     | NULL    |                |
| text     | varchar(256) | NO   |     | NULL    |                |
| type     | varchar(64)  | NO   |     | badge   |                |
+----------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)


Seems to be working OK:

Code:
mysql> select * from neo_system_notifications ;
+--------+------------+-----------+----------------+-------+------------------------------------------------------------+-------+
| noteid | dateline   | userid    | username       | count | text                                                       | type  |
+--------+------------+-----------+----------------+-------+------------------------------------------------------------+-------+
|      1 | 1550567302 | 302177877 | sadique.manzar |     2 | Posts This Past Month, Discussions Started This Past Month | badge |
|      2 | 1550569598 | 302069760 | anaigini45     |     1 | Discussions Started This Past Month                        | badge |
+--------+------------+-----------+----------------+-------+------------------------------------------------------------+-------+
2 rows in set (0.00 sec)

 

6 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

License with demo???

I'm trying to setup a test environment to test upgrading to Solaris 8 or 9. Though when I go to install the demo version of Sun1 (forte/sun workshop as named before) it'll still ask for a 20 hexidecminal password for just a demo. huh? Ok so I added a 20 character thing in there it passed... (2 Replies)
Discussion started by: merlin
2 Replies

2. UNIX for Dummies Questions & Answers

Shell basic graphics demo.

I have been thinking about another shell scripting project using the Arduino Diecimila board. I was going to make a kids level slow 8 channel Logic Analyser. I thought about using the termiinal esc code graphics characters. This is the test code using said terminal escape codes. I have only... (2 Replies)
Discussion started by: wisecracker
2 Replies

3. What is on Your Mind?

Vuejs Periodic Table by Kadin Zhang

Was working on Vue.js and stumbled upon this beautiful Vue project by Kadin Zhang Periodicity is a dynamic periodic table built with Vue.js that animates and graphs data to aid the visualization of chemical concepts. The code is available on GitHub (2 Replies)
Discussion started by: Neo
2 Replies

4. What is on Your Mind?

Major Changes in New UserCP (v0.63) Prototype

Regarding the latest version of the UserCP prototype (version 0.63) I have made a lot of major changes, including Added a "Posts Timeline" table for the recent posts, complimenting the non-table version earlier, which has been moved off the main menu (link at the bottom of the table). Added a... (4 Replies)
Discussion started by: Neo
4 Replies

5. What is on Your Mind?

New UserCP Update Profile Image Page (UserCP Screeching Frog 0.7485)

Update! UserCP Screeching Frog 0.7485 Created a new page for uploaded a profile picture (profile pictures are different than avatar pictures). https://www.unix.com/usercp/#/settings/other https://www.unix.com/members/1-albums225-picture1158.png ... (0 Replies)
Discussion started by: Neo
0 Replies

6. What is on Your Mind?

Video Overview of the Vue.js UserCP @UNIX.com

Here is my second live video screencast (in my life, using Camtasia) with voice for the new usercp: Overview of the Vue.js UserCP @UNIX.com Shout outs to Don Cragun, Corona688, Rudi, Wolf, Made in Germany, stomp, Ravinder, Creative Tim, PubNub and others in the video. Thanks. If you are... (1 Reply)
Discussion started by: Neo
1 Replies

LEARN ABOUT DEBIAN

mysqmail-postfix-logger

mysqmail-postfix-logger(8)				      System Manager's Manual					mysqmail-postfix-logger(8)

NAME

       mysqmail-postfix-logger - logs smtp traffic to a mysql database

SYNOPSIS

       mysqmail-postfix-logger subprogram [ args ...  ]

DESCRIPTION

       mysqmail-postfix-logger	reads the syslog using tail -F and for each lines, does an action in a selected table in the selected mysql server
       (configuration done using /etc/mysqmail.conf). All messages that have been delivered are marqued as so in the from and in the to  field	of
       the smtp traffic table.

       mysqmail-postfix-logger uses a table corresponding to this one:

       CREATE TABLE  IF NOT EXISTS smtp_logs (
	 id int(11) NOT NULL auto_increment,
	 newmsg_id bigint(20) default NULL,
	 bounce_qp int(11) default NULL,
	 bytes int(11) NOT NULL default '0',
	 sender_user varchar(128) NOT NULL default '',
	 sender_domain varchar(128) NOT NULL default '',
	 delivery_id bigint(20) default NULL,
	 delivery_user varchar(128) NOT NULL default '',
	 delivery_domain varchar(128) NOT NULL default '',
	 delivery_success enum('yes','no') NOT NULL default 'no',
	 time_stamp timestamp(14) NOT NULL,
	 PRIMARY KEY  (id),
	 UNIQUE KEY bounce_qp (bounce_qp),
	 UNIQUE KEY newmsg_id (newmsg_id),
	 KEY sender_domain (sender_domain),
	 KEY delivery_domain (delivery_domain) ) TYPE=MyISAM;

VERSION

       This documentation describes mysqmail-postfix-logger version 0.1.4.  See http://gplhost.com/softwares-mysqmail.html for updates.

SEE ALSO

       syslog(3), logger(8)

															mysqmail-postfix-logger(8)
All times are GMT -4. The time now is 06:37 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy