Community of the Month #48 – Voting | Forum Promotion

cJByGjO.png


Contest Information

Community of the Month is a monthly contest where members can vote on whose website or forum most deserves recognition.

Voting Rules

  • You must have made at least 15 posts on FP within the past three months to vote in CoTM.
  • You may only vote for one of the sites listed below (which were submitted in the first half of this month).
  • You may not vote for a site that you submitted to CoTM.
  • You may not vote for a site you are an administrator on.
  • You may not ask others to vote for a site you own, or are an administrator on.
  • You may not create duplicate accounts, or use others’ accounts, to vote for a site.
  • Any other tactic to gain additional votes may result in the votes being discounted, and/or further action.

Contest Prizes

  • Advertisements: The winning site will be featured on the Community Billboard for one month.
  • Sticky: Your Promotion Directory topic will be stickied for one month.
  • Free Service: You will receive one free service of your choice on FP.

Submissions to this Month’s Contest

Site Name: Code Forum
Site Link: https://codeforum.org

Site Name: Webmaster Chill
Site Link: https://webmasterchill.com

Site Name: Admin Tech
Site Link: https://admintech.flarum.cloud/

Site Name: baysidegamers
Site Link: https://www.baysidegamers.com

Site Name: WWE Forums
Site Link: https://wweforums.net/

Site Name: Revillution – Your portal to entertainment
Site Link: https://www.revillution.net

Site Name: Total Transformers
Site Link: https://totaltransformers.proboards.com/

Site Name: 2 Hours Until Closing Time
Site Link: https://2hoursuntilclosing.boards.net/

Site Name: VGR
Site Link: https://www.vgr.com/forum

Site Name: The Fireside Chats
Site Link: https://firesidechats.home.blog/

Site Name: The Admin Connection
Site Link: https://adminconnection.forumotion.com/

Site Name: Webmaster Place
Site Link: https://Webmaster.Place

Site Name: BudgetRoot
Site Link: https://budgetroot.com

Site Name: DestroyRepeat
Site Link: https://destroyrepeat.com

Site Name: CODForums
Site Link: https://www.codforums.com

Site Name: PS5Daily
Site Link: https://ps5daily.com

Site Name: PS5Forum
Site Link: https://ps5forum.com

Site Name: SwitchForum
Site Link: https://www.switchforum.com

Site Name: The Division Forums
Site Link: https://thedivisionforums.com

Vote for your favorite site!

To vote, reply to this topic with the name of the site you’re voting for! Votes will be accepted until 5:00 PM US Central Time (11:00 PM GMT) on the first day of next month.

Singapore Hosting from JustVPS Start at $2.52/mo for WordPress or $3.68 for KVM (1st Month)!

JustVPS is new to LEB and this is their first offer.  They’re offering VMs and WordPress hosting in Singapore.  That’s a less common hosting location than the major geographies (SF Bay, NYC, Dallas, Netherlands, London, etc.) and their offers are…well, just!

  • 1GB RAM VM with 25GB disk/1TB transfer starting at $3.68/mo (first month, then $4.90/mo)
  • Or up that to  2GB RAM and double the disk for $5.93/mo (first month, then $7.90/mo)
  • Or if you want to host WordPress but not get into the details of managing it yourself, check out their WordPress hosting at only $2.52/mo or $25.20/year

If you’re looking for Singapore-based hosting, check out their Looking Glass below and decide if JustVPS is right for you.  They are registered in the Lion City itself (Singapore, as Virtual Electronics PTE, 01918829E). Their Terms of Service is available on their web site. They accept Visa/Mastercard, PayPal, Crypto, AliPay.

Here’s a little about JustVPS in their own words:

“We implement powerful Cloud Hosting solutions to help you develop and manage your projects. With our Cloud VPS solutions, you can utilize maximum server power and smartly allocate available resources to fit any growth. Let’s take a closer look at the advantages of Just Cloud VPS.

Total scalability – We simplify things for you to focus on what matters most. Just Cloud VPS is designed to support your projects with maximum scalability. Scale up or down whenever you need it and manage your budget with ease.

99.999% uptime – Just Cloud VPS is much more reliable than a regular VPS. With Just Cloud VPS, Compute Nodes form a core of resources within a cloud environment. Even if one of the Compute Nodes fails, your Just Cloud VPS is instantly recreated on another

Cloud Compute Node – This will happen so quickly that you won’t even notice. And this lets us achieve 99.999% uptime.

Powered by OpenNebula – OpenNebula is a powerful and easy to use open source Cloud Management Platform. Enjoy flexibility, simplicity and scalability.”

If you have been a customer of JustVPS or you give them a try out now, please comment below.

Now read more to see the offers!

Just Cloud Light

  • 1024 MB RAM
  • 1x vCPU
  • 25GB SSD space
  • 1TB transfer
  • 100 Mbps uplink
  • 1x IPv4
  • 1x IPv6
  • KVM/Cloud/OpenNebula
  • Coupon: Justbest2
  • $3.68/month for the first purchase, then $4.90
  • $37.35/year for the first purchase, then $58.80
  • (ORDER)

Just Cloud Basic

  • 2048 MB RAM
  • 1x vCPU
  • 55GB SSD space
  • 1TB transfer
  • 100 Mbps uplink
  • 1x IPv4
  • 1x IPv6
  • KVM/Cloud/OpenNebula
  • Coupon: Justbest2
  • $5.93/month for the first purchase, then $7.90
  • $59.85/year for the first purchase, then $94.80
  • (ORDER)

WordPress Hosting

  • 5GB Disk Space
  • 5 Domains
  • 10 Subdomains
  • 10 Email Accounts
  • 10 MySQL Databases
  • 5 FTP Accounts
  • Unmetered bandwidth
  • $2.52/month or $25.20/year
  • (ORDER)

NETWORK INFO:

  • Server Location: Singapore
  • Test IPv4: 103.150.10.30
  • Test IPv6: 2405:f740::19
  • Test files: http://sg.lg.justvps.online/100MB.test
  • Looking glass: http://sg.lg.justvps.online/

HOST NODE INFO:

  • 2 x Intel(R) Xeon(R) Gold 5118 CPU @ 2.30GHz
  • 768 GB ECC RAM
  • 8 x 3.2TB SSDs
  • DRBD9 (2 replica) Network Distribute Storage
  • 4 x 10 Gbps uplink

Please let us know if you have any questions/comments and enjoy!

raindog308

I’m Andrew, techno polymath and long-time LowEndTalk community Moderator. My technical interests include all things Unix, perl, python, shell scripting, and relational database systems. I enjoy writing technical articles here on LowEndBox to help people get more out of their VPSes.

[WTS] WordPress hosting starting from $2.4 per month!

Host4biz offers 20 % OFF for WordPress hosting!

Visit: Host4biz
Use code: SENXFJ
Get 20% OFF for the first month!

Location: Warsaw, Poland

WP-1
$2.4 per month
10 Gb NVMe SSD drive
10 Mailboxes
1 Web domain
5 Subdomains
WordPress Toolkit
Jetpack
Imunify360 Antivirus
HTTP/2 support
Web Application Firewall
ORDER NOW

WP-2
$4.2 per month
30 Gb NVMe SSD drive
30 Mailboxes
5 Web domains
10 Subdomains
WordPress Toolkit
Jetpack
Imunify360 Antivirus
HTTP/2 support
Web Application Firewall
ORDER NOW

WP-3
$6.02 per month
50 Gb NVMe SSD drive
50 Mailboxes
10 Web domains
20 Subdomains
WordPress Toolkit
Jetpack
Imunify360 Antivirus
HTTP/2 support
Web Application Firewall
ORDER NOW

.

WordPress hosting starting from $2.4 per month! | Proxies123.com

Host4biz offers 20 % OFF for WordPress hosting!

Visit: Host4biz
Use code: SENXFJ
Get 20% OFF for the first month!

Location: Warsaw, Poland

WP-1
$2.4 per month
10 Gb NVMe SSD drive
10 Mailboxes
1 Web domain
5 Subdomains
WordPress Toolkit
Jetpack
Imunify360 Antivirus
HTTP/2 support
Web Application Firewall
ORDER NOW

WP-2
$4.2 per month
30 Gb NVMe SSD drive
30 Mailboxes
5 Web domains
10 Subdomains
WordPress Toolkit
Jetpack
Imunify360 Antivirus
HTTP/2 support
Web Application Firewall
ORDER NOW

WP-3
$6.02 per month
50 Gb NVMe SSD drive
50 Mailboxes
10 Web domains
20 Subdomains
WordPress Toolkit
Jetpack
Imunify360 Antivirus
HTTP/2 support
Web Application Firewall
ORDER NOW

WordPress hosting starting from $2.4 per month! | Forum Promotion

Host4biz offers 20 % OFF for WordPress hosting!

Visit: Host4biz
Use code: SENXFJ
Get 20% OFF for the first month!

Location: Warsaw, Poland

WP-1
$2.4 per month
10 Gb NVMe SSD drive
10 Mailboxes
1 Web domain
5 Subdomains
WordPress Toolkit
Jetpack
Imunify360 Antivirus
HTTP/2 support
Web Application Firewall
ORDER NOW

WP-2
$4.2 per month
30 Gb NVMe SSD drive
30 Mailboxes
5 Web domains
10 Subdomains
WordPress Toolkit
Jetpack
Imunify360 Antivirus
HTTP/2 support
Web Application Firewall
ORDER NOW

WP-3
$6.02 per month
50 Gb NVMe SSD drive
50 Mailboxes
10 Web domains
20 Subdomains
WordPress Toolkit
Jetpack
Imunify360 Antivirus
HTTP/2 support
Web Application Firewall
ORDER NOW

virtual machines – VM Instance is deleted after beeing inactive for some month?

Hello everyone and thank you for your help.

2 years ago i started a smal project on google platform and used the pre build WordPress from Bitnami.
Then i worked once in a while on the website. This time the payment and so the project was deaktivated for around 3-5 month. Now i wanted to aktivate it again, what i also did. But i cant find any old instance. The project it self is still there but the hole instance where all the data is safed doesnt apear to be anywhere.
Does google cloud delete instances after time automatically?
If yes, is there any way to get my WordPress data recovered?

Thank you a lot, i used a lot of time to create that side and it would be rly bad to do it all over again.

postgresql – Postgres: How can you select last 12 months only, and return total count of each month, even with null/empty months?

I’m using Postgres, and my dataset is a orders table. I am trying to learn how to show total amount of orders per month, per user (assuming there’s only one user in this case).

My dataset:

id, user_id, total, created_at

My current query:

SELECT
       DATE_TRUNC('month',created_at)
         AS  total_orders,
       COUNT(id) AS count
FROM orders
WHERE id = 1
GROUP BY DATE_TRUNC('month',created_at);

This returns:

Total orders | count
2021-01-01 00:00:00, 1

However, here’s the tricky part (to me at least) – i am using this to generate some graphs. Specifically, the last 12 months. So i would like the query to return the last 12 months, and include 0 for when no orders were created. So this is expected output:

Total orders | count
2021-04-01 00:00:00, 0
2021-03-01 00:00:00, 0
2021-02-01 00:00:00, 0
2021-01-01 00:00:00, 1
2020-12-01 00:00:00, 0
2020-11-01 00:00:00, 0
2020-10-01 00:00:00, 0
2020-09-01 00:00:00, 0
2020-08-01 00:00:00, 0
2020-07-01 00:00:00, 0
2020-06-01 00:00:00, 0
2020-05-01 00:00:00, 0
2020-04-01 00:00:00, 0

How can i accomplish this? the ultimate goal is to be super lightweight so that its not resource intensive and fast.

Can I reenter the USA with 1 month on stamp [duplicate]

I have a H1b visa stamp valid till Aug 2021 and an i-797 valid till Dec 2022. Can I travel outside the country and re-enter in July 2021 without getting a new stamp?

Max sum held over a month

I need help with a formula that needs to calculate the max sum held at one time for each month.
In this example it would be 42 for March. Month is determined by "Held from"

Sum Held from To
10 01/03/2021 10/03/2021
11 05/03/2021 15/03/2021
12 14/03/2021 still holding
13 28/03/2021 10/04/2021
14 29/03/2021 29/03/2021
15 29/03/2021 29/03/2021
15 01/04/2021 still holding

Can I re-enter the US with 1 month validity

I have a new passport and the H1b visa stamp in my old passport expires on Aug 21. I have a valid I-797 till Dec 22. Can I travel outside the US and return in July without getting a new visa stamp or will I need to get a new stamp before re-entry?

Thanks