The Modern JavaScript Tutorial

The Modern JavaScript Tutorial is a collection of very detailed articles explaining JavaScript from the basics to advanced topics.

The GitHub repo has 12k+ stars.

How to train above level 30 in "Yendorian Tales 3 - The Tyrants of Thaine"?

Problem

In Yendorian Tales 3, The Tyrants of Thaine I cannot train above level 30. The only potential trainer seems to be the one in the keep, but he does not yet accept me.

Solution

I went through the following steps

• Opened the save file with a hex editor
• Searched for "1E" hex value (meaning 30 in decimal, as in level 30 of one character), changed it to "1F" (decimal 31)
• This increased the level of one of the characters to 31 (mine was the 4th character)
• Loaded up the save-game, went to the trainer in the keep. The trainer unlocked something, because I could trained one of the level 30 guys to 31 (in my case the 1st character), then saved
• With the editor I decreased the artificially increased level of the 4th character back to 30. Loaded up the game and proceeded normally

Source

I am not sure, but I might have downloaded the game from DOS Games Archive.

Before you play this, you should definitely check out Yendor 2

Export binary data field into a file from Microsoft SQL Server, using BCP utility

The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format.

Start a command prompt in the place where you wish the file saved and execute the following command:

BCP "SELECT BinaryField FROM TableWithBinaryField WHERE Id = 1" queryout [OutputFileName] -S [ServerName] -d [DataBaseName] -U [Username] -P [Password]

The first parameter is the query that selects the field that needs to be exported. The italic values have to be specified by you, without the [] straight parenthesis characters around.
If you wish to use a trusted connection then replace the -U Username -P [Password] part with -T.

After executing the command, just press Enter at every question it throws at you.

Here is an examplewhen you wish to specify a username and password:
BCP "SELECT BinaryField FROM TableWithBinaryField WHERE Id = 1" queryout FileName.pdf -S MyServer -d ProductionDatabase -U sa -P secretPassword1

Here is an another example with trusted connection, where no username and password have to be specified:
BCP "SELECT BinaryField FROM TableWithBinaryField WHERE Id = 1" queryout FileName.pdf -S MyServer -d ProductionDatabase -T

Vodafone 360 synch with Nokia E51

Vodafone 360, formerly ZYB, an online service which I mostly use to store my contacts, has problems with SMS sending to my Nokia E51.
Usually I abandon a service after I encounter a serious error but this one is very important to me because it is the only solution to extract a usable contact list from all the stupid services I use on the internet.
So without the service sending me the application in SMS I cannot synchronize my phone with the service. I contacted them. After several email-based discussions they manually validated my phone number and sent me the following instruction list:
If you are still unable to download "360 People", below are SyncML settings that you can use to sync your profile.

"Please carry out the steps below to manually configure a Nokia E51 to synchronize contacts via SyncML.

1. Press the Menu key.
2. Select Tools.
3. Select Sync.
4. Press Options; a pop-up menu will appear.
5. Select New sync profile; if the handset asks to copy values from an existing profile, press 'No'.
6. Select Sync profile name.
7. Enter 'People'.
8. Press OK.
9. Select Applications.
10. Select Contacts.
11. Highlight Include in sync, then press Options to change the value to "Yes".
12. Select Remote database.
13. Enter 'contacts'
14. Press OK.
15. Press Back.
16. Press Back again.
17. Select Connection settings.
18. Select Host address.
19. Enter 'http://sync.vodafone360.com'
20. Press OK.
21. Select User name.
22. Enter your [360 username]
23. Press OK.
24. Select Password.
25. Enter [Your 360 Password]
26. Press OK.
27. Press Back.
28. Press Back again.
29. Select 'People', a pop-up menu will appear.
30. Select Synchronise; a pop-up menu will appear.
31. Select a valid data connection."

I followed the steps and the synchronization worked perfectly.
They still have a lot of issues they need to repair but the service is usable.

I hope I helped someone!

Ultimate HTACCESS tutorial

I found this tutorial to be the most useful.

• Ultimate Htaccess Tutorial for .htaccess files 

Still, not useful enough.