• 06 team banner 1140x380
    Team Banners

How to reset my Joomla 1.5 password using SQL?

Written by webmaster.

Joomla's admin username can be easily changed with a simple MySQL query. The most convenient way to manage the database is through the phpMyAdmin tool. Go to your cPanel and click on phpMyAdmin in the Databases box. (If you are not using cPanel or do not have phpMyAdmin, you can run the query directly for Joomla's database.)

Once in the phpMyAdmin select the Joomla database from the drop-down menu at left. The page will refresh and the database's tables will be displayed on it. Open the SQL tab (look at the top navigation bar).

In the text field write the following SQL query:

UPDATE `jos_users` SET `password` = MD5( 'new_password' ) WHERE `jos_users`.`username` = "admin" ;

"new_password" - replace this with the new password you wish to use.
"admin" - replace this if your admin username is different.
"jos_" - replace this if your SQL SUBFEX is different.

Once you are ready, click on the GO button to submit the query. If everything goes fine without errors, you should be able to login to Joomla with the new password.

Note: These instructions are valid both for Joomla 1.5.* and Joomla 1.0.*.

Reset all hits to 0 (zero)

Written by webmaster.

if you're not familiar with Joomla! it's one of the most powerful open source content management system frameworks out today. Before Google Analytics was even around Joomla! has been doing simple page view tracking or "hits" as it's called in the admin area.

joomla_hits_counter1.gifOnce we launched the site all of the articles of our Joomla! powered site had huge amounts of "hits". As nice as it was for me to wake up this morning and think 1,587 people viewed my "About Me" page, it was not a true reality. I just needed to reset all the article page hits.

Resetting the hits on a per-page basis is extremely easy, as a matter-of-fact there is a "reset hits" button right next to the hit tracker on every article edit page. That's great, but I had a hundred or so articles I needed to reset. I thought for sure this would be a difficult task, but thanks to the Joomla! forums and the power of the community it was VERY simple.

It can easily be done through phpMyAdmin or on the command line by doing the following SQL query

update jos_content set hits = 0


Yes, that's it. I know I just did a lot of writing for such a simple solution, but I'm new to this blogging thing. Hope it helped.

NOTE: if you CHANCED your database jos_ to any thing els you will need to up date the code line

update brad_content set hits = 0

Eric A Sears - Problem

Written by webmaster.

Back on November of 2014 Eric A Sears entered VE SIGNS. Upon Doing So Handed me a business card with his information apon it. i saw that he offered web services and design services. so when i saw this i took down his email and using my automated email sent him a email letting him know about me and my service. 

well lets just say... i wish he would of contacted me, instead he slandered my name on yelp and VE Signs on yelp.

so im asking that any of my friend or customer also flag his post there was nothing wrong on sending 3 email with different content with no intent of re sending emails if i never got a reply.

here is his information.

Eric A Sears
legendary entertainment group
This e-mail address is being protected from spambots. You need JavaScript enabled to view it

19510 Van Buren Blvd Suite F3-432 Riverside, Ca 92508 - not a office that is a PO box! 

as reported me to godaddy as a SCAM Spammer and godaddy with out a human looking over the clam with a automated system is know pushing me to take a settlement of $75 (im saying extortion!)

with him failing to acceped the signed verified collections im now adding $652 to the bill.

so i paid and now will reviews and service to eric a sears.

hes as posted as a fake name on YELP! - Michael S.
VE SIGNS is where i do sign and graphic design. websites and email services are not related to his mass clam!


(this page will be removed if all posts FAULTS clams are removed)


All You need to start graphics design

Written by webmaster.

Graphic design has an amazing community. Comprised of both the Masters from the pre-computer Era to the Newbies who were raised on the internet and computer-editing applications, there is a huge amount of people sharing their work and expertise online. I know when I was starting out in design, I found tons of inspiration and information from sites like youtube and more. If there’s one issue, however, it’s that there’s almost too much great information out there. I know – good problem to have, right?

But for those designers just starting out, or for those designers who are considering getting into design, the amount of information can be a little overwhelming. Couple this with Paper Leaf’s desire to give back to the design community, and this is what you get: the All-in-One Graphic Design Starter’s Kit. The idea behind this kit is for it to be a one-stop shop for those getting into design – and for it to be completely free. It includes free software (for both Mac & Windows – photo/raster editing, vector editing, and HTML/CSS WYSIWYG editing), eBooks, textures, vectors, brushes, and awesome fonts. If you were to have no idea where to start, you could come here, download everything, read the eBooks and corresponding software guides, and have a great starting point.

All of these items are free, open-source and legal for both me to share & you to download – however, please don’t claim any of them as your own.

Numbering tickets (stickers) with InDesign

Written by webmaster.

Now it’s possible. Now it’s easy and fun. In this simple tutorial you will learn how to use improved bullets and numbering InDesign’s feature to get numbers on your tickets. Our goal will be to create 1000 tickets, numbered from number 1 to 1000. Of course, you are not limited to this number. You can create as many as your like.

We will start with ticket dimensions: 80x30mm. This is important because we are going to impose these tickets on A4 paper. After some calculation I found 15 tickets per page works OK for me - 3 columns and 5 rows. To make room for 1000 tickets we need 67 A4 pages (1000/15 = ~67).

Create new A4 InDesign CS3 document with 67 non facing pages in landscape orientation.

Open pages palette and double click on A master. Make text frame with dimensions matching dimensions of ticket and place it in upper left corner on master page.

Go - Type – Show hidden characters (make it active).

Type some text in newly created text frame and after the first line press Enter 2 times to get 2 paragraph symbols as on image below.


Select second paragraph symbol and lower font size for a couple of points. Open Paragraph styles palette and Option/Alt click on new style icon located at the bottom of palette to create new style. Name your new style to something like “to change”. Leave all settings and click OK. Click on the “to change” style in paragraph palette while you still have selected paragraph symbol.

Now make duplicates of text frame to fill A master page. You will end up with 15 tickets.

If you open page 1 you will find that text frames are not editable. To make all text frames editable select page 1 in pages palette and hold shift key when you click on last page in document (page 67). Open flyout menu and choose “Override All Master Page Items”.

Now go to page 1 and select second paragraph symbol of the first text frame located in upper left corner.

Option/Alt click on bullets and numbering button located in control panel. In the B&N window make following settings:

List type: numbers

List: choose New… name it, and leave both items checked. This is very important step. Each text frame is one story. “Continue across stories” option will allow continuous numbering across all text frames in document.


Format: 1,2,3,4

Number field: default is ^#.^t You can play a lot with this field.
^# - represent auto number
^t - represent tab
No.^# (customized)

Mode: continue from previous number


Open Paragraph styles palette and Alt click on new style icon at the bottom of palette. Name style to something like “numbering”. Click on the new created style name in paragraph palette just to be sure that you applied style to selection.

Deselect everything.
All we have to do now is to call Find/Change to help us with numbering process – Edit – Find/Change and make settings like on image below. Click on Change all button and watch the magic.


Delete unwanted tickets from last page if you want exactly 1000 tickets.
To create crop marks select all text frames on master page and apply CropMarks script with “each object selected”.
That’s it Indy lovers.