What is the Du`a (supplication) of Istikhara (guidance prayer)?
O Allah, I consult You as You are All-Knowing and I appeal to You to give me power as You are Omnipotent, I ask You for Your great favor, for You have power and I do not, and You know all of the hidden matters. O Allah! If you know that this matter (then he should mention it) is good for me in my religion, my livelihood, and for my life in the Hereafter, or he said: "for my present and future life" then make it (easy) for me. And if you know that this matter is not good for me in my religion, my livelihood and my life in the Hereafter, or he said: "for my present and future life" then keep it away from me and take me away from it and choose what is good for me wherever it is and please me with it."
When is Istikharah (guidance prayer) Du`a offered, before Tasleem (saying asalamu alikum warahmatu allah wa barakatuh to end the prayer), or after it?
It is offered after Tasleem.
What is the ruling on smoking?
All Perfect Praise is due to Allah, The Lord of The Worlds
Smoking is forbidden (Haram) since it is harmful to one`s health as confirmed by trustful physicians, and Islam has forbidden taking anything that causes harm. The Prophet (PBUH) said: "There should be neither harm nor reciprocated harm." [Ibn Majah and Ahmad]. And Allah Knows Best.
One day, I swore that my wife will be unlawful to me to quit smoking hookah?
All perfect praise be to Allah the Lord of the Worlds. May His peace and blessings be upon Prophet Mohammad and upon all his family and companions.
The best course of action is that you turn to Allah for help and quit the hookah. In addition, acquainting yourself with the risks of smoking hookah will help you take this step. And Allah, The Most Exalted Knows Best