Block eBay buyers in countries you don’t ship to, or with 0 feedback

Leave a comment

eBay recently streamlined their selling process but they sacrificed  some important features. Specifically, listing items is accomplished with a simpler interface than before and the buyer requirements seems to be missing in action on the new listing form. This is a real bummer as a listing can be ruined when a bum buyer beats out legitimate users 🙁 Thankfully, you can regain your eBay buyer requirements by adjusting your eBay preferences. This means you can set some important requirements like: Block buyers

Read more money tips, tech tips

Sample Synology DiskStation 1813+ System Information

Leave a comment

Example of Synology DiskStation system information output, with a five disk array: General Serial number XXXXXON001918 Model name DS1813+ Total physical memory 4096 MB DSM version DSM 4.3-3810 System time 2013-11-16 12:25:55 Operating time 0 hour(s) 39 minute(s) 35 second(s) Thermal status Normal (32 °C / 90 °F) Network Server name DiskStation DNS 192.168.1.1 Default gateway 192.168.1.1 Workgroup WORKGROUP LAN 1 MAC address 00-11-32-1E-69-9F IP address 192.168.1.22 Subnet mask 255.255.255.0 IPv6 address fe80::211:32ff:fe1d:699f/64 Scope:link LAN 2 MAC address 00-11-32-1E-69-A0 IP

Read more computer tips

iPad Air cannot access (hotmail) mail server?! [SOLVED]

One comment

Q. My new iPad Air stopped downloading my Microsoft Hotmail and now I am stuck at about a month ago on my email! I have it set to download all time email in my settings yet every time I try to download it says something like ‘cannot connect to mail server’. Any ideas? -Ian G. A. Hi Ian, I am sorry to hear about your Hotmail problem. 🙁 It seems that in iOS7 there are a number of issues with

Read more computer tips, iOS, Software Tips

Beneficiary Deeds in Missouri

Leave a comment

A beneficiary deed allows for property to transfer on death (TOD) without going through probate. The beneficiary deed only goes  into effect upon death of the owner, therefore it does not actually transfer property until the owner’s death and therefore it does notpreclude transfer before death. In other words, if an owner executes a beneficiary deed and then decides to sell the property, that it is not a problem. The Missouri Bar provides an overview of Estate Planning methods and

Read more legal, Work

MySQL: Count the total occupancy rate for a time period (month)

2 comments

Recently I encountered a somewhat interesting MySQL/PHP task: determine occupancy for a reservation system. This entailed determining how many reservation days fall within a particular month. It was not possible to simply determine each reservation length (datediff from/to) and sum them because some reservations started before the month in question and other reservations lasted until the month was over. Therefore, one solution is to get the reservation lengths then compare the start and end of the reservation to the start

Read more programming, Software Tips, Work

Synology DS1813+ Review

Leave a comment

My DS1813+ arrived yesterday via FedEx and I will soon be putting it through its paces. This article will be updated periodically. Until the next update, here are some preliminary links: DS1813+ Product Info Synology Network Attached Storage – DS1813+ Productshttp://www.synology.com/products/product.php?product_name=DS1813%2B&lang=usWith its superior performance, scalability, resilience, and comprehensive features, Synology® DS1813+ is the ideal storage solution for your growing SMB. The DS1813+ can help to simplify data… Synology DS1813+ & DS1513+ DiskStations Reviewed – Features, Performance, Conclusion – SmallNetBuilderhttp://www.smallnetbuilder.com/nas/nas-reviews/32157-synology-ds1813-diskstation-reviewed?showall=&start=1DSM 4.2

Read more computer tips, Work

Reverse order of individual items in a delimited string

Leave a comment

Topic: Reversing the order of individual items in a string. Specifics: I had a date contained in a GET query string that was formatted as follows: 01/27/2013 and I needed it reversed to 2013/01/27 Here is a simple method to do the reversing in PHP: $toDate = htmlentities($_GET[‘to’]); $toDateNew = implode(“/”,(array_reverse(explode(“/”,$toDate)))); Explanation of code: First you explode the $toDate variable, then reverse the resulting array, finally you implode that array back into a string. Of course there are other date

Read more Software Tips, tech tips

Set your own date format in MySQL

Leave a comment

Use DATE_FORMAT in MySQL to create your date strings formatted however you like: SELECT CONCAT(YEAR(res_hotel_booking_bookings.created),’-‘,DATE_FORMAT(res_hotel_booking_bookings.created,’%m’) ,’-‘,DATE_FORMAT(res_hotel_booking_bookings.created,’%d’)) AS creationDate, Count(res_hotel_booking_bookings.id) As reservationsMade FROM res_hotel_booking_bookings WHERE res_hotel_booking_bookings.created >= ‘2013-10-15 00:00:00’ AND res_hotel_booking_bookings.created <= ‘2013-10-17 24:00:00’ GROUP BY YEAR(res_hotel_booking_bookings.created), MONTH(res_hotel_booking_bookings.created), DAY(res_hotel_booking_bookings.created) ORDER BY creationDate DESC There are more concise ways to do this, but this was adapted from an earlier method that used CONCAT so I stuck with that… 🙂

Read more Misc Links, tech tips