1-Login to your hosting account in this case i am currently hosting my site at HostMonster , usually the Cpanel is the same . 2-After you login to CPanel Look for PHP My Admin 3-Now look for Databases Tab And then click on the appropriate Database you want to export user list from After the Database open look for the Query Tab on the top And now you must run a Query! In this Tab you will look for the following box ie Use Tables > Select Wp-users Next Since our Mailing list requires the list in the following order Username , User Email Address , User Display name I chose the following option for the Query. Hit Update Query and you will get something like this Hit Submit Query Button and you will get a full list of users something like this Click on Select All ( located at the end of the list) Now click on the Export button located at the end of the list and in the next window that opens use the options or set them up according to your mailing list provider , ie how to separate the id , email address and name by , or ; My selection is the following And now i hit go to save the CSV file , ready for my use!
**I have very limited knowledge of handling database and coding , i am more of a designer that too self taught 🙂
this is just a presentation of How I export my CSV file . Please do not play around with the database if you do not have enough understanding of what you are doing . I/this site will take no responsibility if you experience any difficulties in the final outcome or any loss of data while you are following this tutorial. It is more of a recording and blogging on my part to save my everyday learning experiences.
I hope this helps you somehow though ! 🙂 Happy exporting![/private]
Frankly speaking i never did explore the power of point , except for creating once in a while backgrounds for presentations for my work . Which in fact is fun and quite rewarding . But using it as a drawing tool? never quite thought of it until Tom Kuhlmann created a similar power point tutorial version of one of my previously written tutorial How to create an envelope icon with a satin Feel
This is how my version’s outcome looked like and below is Tom’s Version created entirely in PowerPoint
Tom also shares a video and step by step tutorial on his site Go take a look![/private]
This detailed advanced illustrator tutorials how to create a diamond sparkling necklace metal tutorial will show you how i created the Diamond necklace available to download freely from Aivault through this post. The steps described here will take you through the process of drawing then coloring using very simple steps.
Star-off by creating a circle and we all know how to it by now 🙂
Next we will make use of the guides and star dividing the shape with equally sized straight lines and guide as a reference.
USING GUIDES FOR DIVIDING THE SHAPE
Create a copy of one horizontal and one vertical line , select the rotate tool , while pressing alt create and rotate a copy of both lines as well as the guide lines.
Keeping the intersecting point of the guides and the lines as a reference align a square inside it , similar to the one seen below.
As shown below create a copy like we did with the lines and rotate it .
Now we need more guides placed , now i dont know any other way of creating the angled guides , i never really explored how to do it 🙂 , my process is to first unlock your diagonal and vertical guide select both using select tool , click on the intersecting point hold shift+alt and rotate the copy . Holding Shift will give you a snap to the middle point. hope it is clear below you can see the screen shot while i rotated the guides.
And here i have a copy done again you can do this by hitting CTRL+D which will repeat your last action.
With guides being our reference start drawing lines as shown below these are in pink color so you can see the progress
Now turn off the guides once you are done. select the full divided / drawn circle with lines and square and using the Paint Bucket Tool fill it up with one color.
Ok you might say why not just fill the circle with foreground color change , the technique i used here is to break the full drawing up in sections and i prefer using live color option HOW? see below.
Here the full drawing is selected and then filled up with one single color . the bounding box you see below show that this is a live color object now .
Click on Expand which you will see on the top bar. This will break the full drawing into devided section making it easy for us to color each. Before doing that left click and ungroup.
Fill it up with gradience as show below
Create a star shape , i will not go into detail on how i did this one in short select the star shape tool with 6 points. create a copy place above and give a slightly tinted color.
CREATING THE BACKGROUND
I created a black bounding box now and had sent it to back so i can better develop the final image. create a circle , and go to object>path offset path to create a bit smaller circle placed inside this one.
Using live Paint fill it up with gradient Create a copy and align in the middle
Group the diamond shape that we created above and start placing it inside the RING that we created.
Give a gradient to the rings as show below.
I created another ring silightly broader to place at the back of this whole drawing. ( create one , offset and use pathfinder to intersect You may want to learn the tools if you dont know then See the Guide here )
Again take a copy of this broader circle and place at the top , and draw an oval shape filled with same gradient.
CREATING THE CHAIN
Start building the chain with the copy of the same thing
And Finally the whole thing is complete give a finishing touch by using copy of the SHINE we create using star shape and place it on top
Create more copies and give a bit of transparencies.
[private]I’m Done! Share what you created if you create something using same technique! OR download the Vector File to explore my work place.[/private]
Ok i love this illustrator technique : How to Coloring Artwork , this one saved me tons of time last night and i “had” to share it with you.
Ever had the need to create same illustration in multiple colors ? no need to recolor selecting each and every color here is a neat little shortcut in Adobe Illustrator to help you out. Here is my problem and solution walk through! (more…)