Monday, April 21, 2008

Forgot your password in Joomla, Drupal, or any other php run cms with mysql database (with management in phpmyadmin)?

Forgot your password in Joomla, Drupal, or any other php run cms with mysql database (with management in phpmyadmin)?

In the event you forget your administrator password or passwords in in Joomla, Drupal, mediawiki, coppermine, etc. (or any opensource php-driven cms with mysql database manageable in phpmyadmin for that matter), a workaround is fortunately available. For newbies, forgetting one's administrator user account's password the only solution will have to be re-installing the entire cms from scratch thus re-creating an administrator account in the process. A solution is as follows:

- Go to site/phpmyadmin (login, of course assuming you have the necessary rights to the database/s)

- Browse for the database, then the table (in the case of Joomla, Drupal, etc. this is commoonly the table 'users') intended to be edited

- click edit user, then under the 'Function' column (dropdown list) choose MD5, edit the 'Value' or your password (you will initially see the encrypted version of your original password), then type in the desired, new password of your choice

- Lastly, don't ever forget your password again, silly! :D

Thanks to pete avila and michael perido for the tip! cool guys from the pacific rim, Philippines :p...

Friday, April 11, 2008

What’s in the ‘mytahanan’ word?

What is “mytahanan?” (www.mytahanan.com being a joomla project undertaken for a realtor friend...)

“Tahanan” is the Filipino (colloquially Tagalog) word for “home.” As distinct as home is from a house, such is also “tahanan” from “bahay.” Thus, www.mytahanan is that real estate web site that deals with selling and presenting Filipinos here and abroad (and those wanting to call the Philippines their home) houses, condominiums, apartments, and other similar premeire properties which aims to provide you that ideal place you would love to call home.

May it be a condominium or studio units in the hectic and hustle bustle commerial and urban locations like Makati or Manila; or quite, cool tranquil, and idyllic vacation spots like Tagaytay and Baguio; or internationally popular summer and beach destinations like Boracay, Malay in the island province of Aklan; or simply city or suburban residential lots and properties in cities within Metro Manila like Las Piñas, Parañaque, Mandaluyong, etc., you will find it here.

If not, you contact us and we will provide you the realty service and deals that you deserve and available in the Real Estate market here in the Philippines.

Contact Philippine Realtor Ms. Joy Coronel, Licensed Real Estate Broker, Philippines, with REB License No. 19358-254-6023 at the ff. contact numbers and details:

Mobile No’s (format applies both national and international calls):
+63 906414 6244
+63 922 323 2312

Telephone (Landline):
+632 254 6023

Yahoo Messenger (different from email address used):
mytahanan

Email:
mytahanan@gmail.com

Website:
http://www.mytahanan.com

Joomla! customization of default pages, textual phrases, messages, instructions, breadcrumbs, etc.

Want to edit or customize the following default Joomla textual phrases, messages, instructions/instruction pages, errors, links, breadcrumbs, etc. (examples: who is online, We\’re sorry but the page you requested could not be found., The database adapter is not available, You are not authorised to view this resource, Incorrect username or password. Please try again, You cannot enter more than one e-mail address, Message subjects, contributed by/ last updated by/ written by, etc.) dynamically generated by default install of Joomla? Check out language/english.php where such text can be edited addordingly… just be careful with the php strings and copyrighted materials where they apply…

Below are the following pages/modules/extensions whose messages/errors that can be edited or customized accordingly for Joomla! 1.0.13 Stable:

// no direct access

// Site page note found

// common
/** mambots */

/** content */

/** classes/html/modules.php */

/** contact.php */

/** classes/html/contact.php */

/** pageNavigation */

/** emailfriend */

/** classes/html/content.php */

/** content.php */

/** poll.php */

/** classes/html/poll.php */

/** registration.php */

/** classes/html/registration.php */

/** classes/html/search.php */

/** templates/*.php */

/**
* Modify this line to reflect how you want the date to appear in your site
*e.g. DEFINE(”_DATE_FORMAT_LC”,”%A, %d %B %Y %H:%M”); //Uses PHP’s strftime Command Format
*/

/** classes/html/usermenu.php */

/** user.php */

/** components/com_user */

/** components/com_banners */

/** components/com_login */

/** components/com_weblinks */

/** components/com_newfeeds */

/** whos_online.php */

/** modules/mod_banners */

/** modules/mod_random_image */

/** modules/mod_stats.php */

/** /adminstrator/components/com_menus/admin.menus.html.php */

/** administrators/components/com_users */

/** administrators/components/com_massmail *//** includes/pdf.php */

For instance, there is that page in joomla that says “There is a Web Link already with that name, please try again.” everytime you double entry or conflicting item in the weblink manager. To add a few instructions or details to that line, you could add desired text therein. ;o) just a tip for those who had the same difficulty of searching for answers when one wants to customize Joomla and its default text and messages.

Important reminders:

1. html tags apply within the ‘text phrase’ only, be carely not to mess around with the rest of the php strings (safe practice is to make a backup copy of english.php)

2. with Joomla! 1.0.13 Stable version, there is no way you could add header items to english.php it will result into errors like:

Warning: Cannot modify header information - headers already sent by (output started at /home/jerome/public_html/site/language/english.php:1) in /home/jerome/public_html/site/index.php on line 238… /home/jerome/public_html/site/index.php on line 239…
/home/jerome/public_html/site/index.php
on line 240…
/home/jerome/public_html/site/index.php
on line 241… /home/jerome/public_html/site/index.php on line 242…

Hope this helps

-end-