How to add social logins to your Moodle site https://elearning.3rdwavemedia.com/blog/how-to-add-social-logins-to-your-moodle-site/3229/ https://docs.moodle.org/37/en/OAuth_2_services
Category: ব্লগ । Blog
ব্লগ । Blog
Sep 02
Investing in Small Cap ETFs
Why Small Cap? https://www.greaterfool.ca/2021/08/28/time-to-go-small/ Apparently IWM increased by 61% in a year (As of June 30th, 2021). https://www.ishares.com/us/products/239710/ishares-russell-2000-etf The 7 Best Small Cap ETFs (3 From Vanguard) for 2021 " In a hurry? Here’s the list: VB – Vanguard Small-Cap ETF ISCB – iShares Morningstar Small-Cap ETF IJR – iShares Core S&P Small-Cap ETF VIOO …
Aug 15
Connected Vehicles in Intelligent Transportation Systems (ITS)
Connected Vehicles in Intelligent Transportation Systems (ITS) https://www.guide2research.com/special-issue/connected-vehicles-in-intelligent-transportation-systems-its Special Issues for Computer Science & Electronics Journals https://www.guide2research.com/special-issues/ Top Major Computer Science and Electronics Conferences : https://research.com/ " Scholars from the United States are still dominating the ranking with 614 scientists representing 61.4% of all leading scientists. The other countries with leading positions in the ranking …
Aug 06
Magento2: update product attributes using sql
cat update_product_attributes_using_sql.sql update catalog_product_entity_int — select * from catalog_product_entity_int set catalog_product_entity_int.value = 1 where (catalog_product_entity_int.attribute_id = 97) and catalog_product_entity_int.entity_id = ( select entity_id from ( SELECT product.entity_id as entity_id FROM bitnami_magento.catalog_product_entity product inner join catalog_product_entity_decimal price on price.entity_id = product.entity_id and (price.attribute_id in (78)) inner join catalog_product_entity_int status_t on (status_t.entity_id = product.entity_id) and (status_t.attribute_id=97) where …
Aug 06
Magento 2: Clear Images in database
truncate table bitnami_magento.catalog_product_entity_gallery; truncate table bitnami_magento.catalog_product_entity_media_gallery_value; truncate table bitnami_magento.catalog_product_entity_media_gallery_value_to_entity; truncate table bitnami_magento.catalog_product_entity_media_gallery_value_video; no warranty given as is
Aug 06
Magento 2: Update data for a custom product attribute
use bitnami_magento; SELECT * FROM bitnami_magento.catalog_product_entity_varcharwhere ( attribute_id = 73 ) — and (value = ”)limit 10 replace into bitnami_magento.catalog_product_entity_varchar (attribute_id, store_id, entity_id, value )SELECT 181, 0, product.entity_id, left(concat(“https://www.amazon.com/s?k=”, product.value),255)FROM bitnami_magento.catalog_product_entity_varchar productinner join catalog_product_entity_int status_t on ( status_t.entity_id = product.entity_id ) and ( status_t.attribute_id = 97 and status_t.value = 1 )where (product.attribute_id=73) — and (value …
Aug 06
Magento 2: Misc. Image related SQLs
select * from bitnami_magento.catalog_product_entity_media_gallery_value_to_entity where value_id in (232574, 242521) — 232574, 242521 select * from bitnami_magento.catalog_product_entity_media_gallery_value_to_entity where value_id in (232574, 242521) — where value like ‘%ud6vtf2a_5ezdxueqvnr%’ –select * from bitnami_magento.catalog_product_entity_media_gallery_value_to_entity select * from bitnami_magento.catalog_product_entity_media_gallery — where value_id in (237733, 237734) where value like ‘%ud6vtf2a_5ezdxueqvnr%’ update bitnami_magento.catalog_product_entity_media_gallery set value = ‘/u/d/ud6vtf2a_5ezdxueqvnr1dyny_1.jpeg’ where value = ‘/u/d/ud6vtf2a_5ezdxueqvnr1dyny.jpeg’ and …
Aug 06
Magento 2: Deactivate Products without images
update catalog_product_entity_int — select * from catalog_product_entity_int set catalog_product_entity_int.value = 2 where (catalog_product_entity_int.attribute_id = 97) and catalog_product_entity_int.entity_id in ( select entity_id from ( Select distinct(product.entity_id) FROM bitnami_magento.catalog_product_entity product left join catalog_product_entity_media_gallery_value_to_entity valentity on valentity.entity_id = product.entity_id left join catalog_product_entity_media_gallery image on image.value_id = valentity.value_id and (image.attribute_id in (90)) inner join catalog_product_entity_int status_t on (status_t.entity_id = …
Aug 04
Traffic Crashes Are Getting Worse. Car Ads Are Part Of the Problem.
More on CityLab: The Plexes of Montreal Make Room for Change With their distinctive details and treacherous outdoor staircases, these two- or three-floor apartment buildings dominate the city’s multi-family rental housing market. Traffic Crashes Are Getting Worse. Car Ads Are Part Of the Problem. What if car companies were banned from boasting their trucks can …
Jul 30
Coding Projects in Scratch
Theme: Science There are a lot of projects for games, simulations, and art. I will share 1 example: Sarah does this: when go clicked…go to front layer. Forever: go to x: 0 y: 0. Sarah’s home should do this: When go clicked…set size to 50%. You need to add this to Sarah: If touching home then …
