Sunday, 3 November 2024

create360degree.com | Features | Registered User vs Guest User

 


Unlocking the Full Potential of create360degree.com

create360degree.com offers a fantastic experience for everyone, but registering for a free account opens up even more creative possibilities! Let's explore some of the features available to both guests and registered users, and see how creating an account enhances your experience.

Feature 1: Easy Registration, Powerful Creation

Guests can create stunning 360 experiences using still images. However, registered users can take their creativity a step further by uploading videos and then selecting the perfect frames for their 360 masterpiece. Registering is quick and easy, you can either use your email address or conveniently sign up with your Google account.

Feature 2: Save Your Creations Forever

Guest creations are automatically saved for 90 minutes, allowing you to explore and share them with others. Registered users enjoy the incredible benefit of permanent storage for their 360 creations. Plus, you get three free storage slots to keep your masterpieces organised and accessible anytime. Need more space? Additional slots are available at an affordable price.

Feature 3: Customization and Control

Both guests and registered users can personalise their 360 experiences with features like:

  • Image rotation

  • Private accessibility as default

  • Rearrangement of images

  • Adding hotspots for interactive elements

Registered users gain even more control:

  • Password protection

  • Privacy settings (public, private, embeddable)

  • Categorization for easy discovery (educational, creativity, location, product)

  • Effortless Hotspot Creation: Search and import existing 360s to create internal links as hotspots, saving you time and effort.

  • Seamless Cross-Linking of hotspot: Add your current 360 as a hotspot to other creations on the platform, building connections between your work.

Feature 4: Preview and Publish with Confidence

Everyone can preview their 360 creation, ensuring it looks and functions exactly as intended.

Ready to Unleash Your Creativity?

Registering for a free account on create360degree.com unlocks a world of creative possibilities. From video uploads and permanent storage to advanced customization tools and effortless hotspot creation, you'll be well on your way to crafting stunning 360 experiences. Sign up today and get started!

Sunday, 22 September 2024

create360degree.com | Bring 3D Objects OR Environment To Life



Ever wanted to show off an object from every angle? create360degree.com lets you create stunning 360° experiences in just 5 easy steps:

  1. Capture your object: Use your phone or camera to take pictures at different angles.
  2. Upload in seconds: Upload your photos effortlessly.
  3. Add interactive hotspots (optional): Want to showcase details or link to other objects? Add hotspots with text, images, or even links!
  4. Preview your masterpiece: Instantly see how your 360° experience will look.
  5. Share with the world: Share your creation with friends, family, or on social media!

Get 3 free slots to create your first 360° experiences! Sign up now at create360degree.com

Friday, 29 March 2024

MySQL: How to Select Entire Row with MAX in Group By (Subquery Method)

 


Code : 

SELECT potential_customers.* from potential_customers where concat(potential_customers.customer_id,'-',potential_customers.next_call) IN

(SELECT concat(PC1.customer_id,'-',MAX(PC1.next_call)) FROM `potential_customers` PC1 GROUP by customer_id);

========================

Subscribe my Channel:-

http://www.youtube.com/user/SanketRooney?sub_confirmation=1


Gaming Channel:-

https://www.youtube.com/@unpoggaming9532


Gaming Instagram:- (@unpog.gaming)

https://www.instagram.com/unpog.gaming/

Facebook Page:-

https://www.facebook.com/UnpossibleNS

Twitter Account:-

https://twitter.com/UnpossiblePOG

Blog:-

https://unpossiblepog.blogspot.com/

Website:-

https://unpossiblepog.com/

========================

Hey guys, there is a limitation in MYSQL, where you use group by and wanted max value, but when you try to fetch a row ID or any other column, it fails.

For example, there is one table on the left side called “potential_customers”, and on the right side, I wrote one query which returns maximum NEXT_CALL value for each customer_id.

So, in current example I wanted row ID 2 & 6.

But if I need ID or whole row, it fails even when you use order by column_name DESC.

Thankfully there is a workaround for this which is to use the combination of subquery and concat.

First, let’s alter the query, to concat customer_id and max of next call. Remove all order by if there is any.

Put that query is sub-query by adding rounded brackets around it.

Now, write a select query before sub query, & in where condition, use concat of required column. Don’t forget to use “IN” keyword.

And as you can see, it returns row ID that we need.

You can call whole column if you want.

So that’s it. Code link is given in the description.

Thanks for watching. Like, Share and Subscribe.