Web Development

02-19-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

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)

Neo

02-19-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

OK... so this table for storing basic badge notification details is working fine:

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 |
|      3 | 1550573088 | 302169481 | Sumanthsv      |     1 | Weeks Active In A Row                                      | badge |
|      4 | 1550573354 | 302132521 | Akshay Hegde   |     1 | Forum Advisor                                              | badge |
|      5 | 1550574998 | 302181958 | johnprogrammer |     2 | Posts Per Day, Weeks Active In A Row                       | badge |
|      6 | 1550575937 | 302132521 | Akshay Hegde   |     2 | Bits, Discussions Started This Past Month                  | badge |
|      7 | 1550577993 | 302132521 | Akshay Hegde   |     1 | Posts This Past Month                                      | badge |
+--------+------------+-----------+----------------+-------+------------------------------------------------------------+-------+
7 rows in set (0.00 sec)

Will wait a day until there are a lot of entries, then write a new Vue.js component in "UserCP Mockup" to display these notifications.

Need to take a break, as this is a lot of work, building so many components.... LOL

This User Gave Thanks to Neo For This Post:

Neo

02-20-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

Mockup Vue Dashboard v0.12

Code:

https://www.unix.com/cp/index.php

New Mockup Table (Mockup Data Only)

Table: Leadership Team
Forum Advisors

TODO:

Write PHP MySQL queries for tables, create and debug Javascript / JSON for tables.

This User Gave Thanks to Neo For This Post:

Neo

02-21-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

Mockup Vue Dashboard v0.13

Code:

https://www.unix.com/cp/index.php

New Mockup Table (Mockup Data Only)

Table: Leadership Team - Avatar Images and New Defaults (sheriff img) Working in Vue.js
Forum Advisors - Avatar Images and New Defaults (chess bishop img) Working in Vue.js
JSON Mockup Tables for above completed.

Write PHP script to query databases and create / write Javascript / JSON.

Mockup Vue Dashboard v0.14

Code:

https://www.unix.com/cp/index.php

New Mockup Table (Mockup Data Only)

Profile Pics and URLs: Updated with User Avatars and URLs
Tables: Fixed minor Vue.js mockup bug with FA titles / roles.

Neo

02-21-2019

Administrator

19,118, 3,359

Join Date: Sep 2000

Last Activity: 15 July 2022, 8:51 AM EDT

Location: Asia Pacific, Cyberspace, in the Dark Dystopia

Posts: 19,118

Thanks Given: 2,351

Thanked 3,359 Times in 1,878 Posts

I'm going to start another discussion thread next, because I have reached a milestone with

Mockup UserCP Version v0.15

https://www.unix.com/cp/index.php

So, on the main dashboard page, all the chart stats and badges, leadership table and forum advisor tables are all using live data from the database.

In a nutshell, that page is basically done for now and I'll start on a new page for the UserCP soon.

Neo