How to Export User list from WordPress Database for mailing lists

[private]

** Please read important!

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 Capture How to Export User list from Wordpress Database for mailing lists And now you must run a Query! In this Tab you will look for the following box ie Use Tables > Select Wp-users Capture1 How to Export User list from Wordpress Database for mailing listsNext 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. Capture2 How to Export User list from Wordpress Database for mailing listsHit Update Query and you will get something like this Capture3 How to Export User list from Wordpress Database for mailing lists Hit Submit Query Button and you will get a full list of users something like this Capture4 How to Export User list from Wordpress Database for mailing lists 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 Capture5 How to Export User list from Wordpress Database for mailing listsAnd now i hit go to save the CSV file , ready for my use!

Please Note!

**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]

Creating graphics in Power point

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

envelope1 Creating graphics in Power point

This is how my version’s outcome looked like and below is Tom’s Version created entirely in PowerPoint

envelope2a Creating graphics in Power point

Tom also shares a video and step by step tutorial on his site Go take a look![/private]

How to Create a Vector Diamond Necklace and a Chain

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.

It is not a basic learning tutorial , i expect you to already know drawing tools , basics of drawing , pathfinder tool , live paint and using guides.

OR if you are starting out Read more tutorials on this site

Step 1

CREATING THE DIAMOND SHAPE

Star-off by creating a circle and we all know how to it by now 🙂
01 How to Create a Vector Diamond Necklace and a Chain
Next we will make use of the guides and star dividing the shape with equally sized straight lines and guide as a reference.
02 How to Create a Vector Diamond Necklace and a Chain
03 How to Create a Vector Diamond Necklace and a Chain

Step 2

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.
04 How to Create a Vector Diamond Necklace and a Chain
Keeping the intersecting point of the guides and the lines as a reference align a square inside it , similar to the one seen below.
05 How to Create a Vector Diamond Necklace and a Chain
As shown below create a copy like we did with the lines and rotate it .
06 How to Create a Vector Diamond Necklace and a Chain
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.
07 How to Create a Vector Diamond Necklace and a Chain
And here i have a copy done again you can do this by hitting CTRL+D which will repeat your last action.
08 How to Create a Vector Diamond Necklace and a Chain
With guides being our reference start drawing lines as shown below these are in pink color so you can see the progress

Step 3

ADDING DETAILS

09 How to Create a Vector Diamond Necklace and a Chain
10 How to Create a Vector Diamond Necklace and a Chain
11 How to Create a Vector Diamond Necklace and a Chain

Step 4

COLORING

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 .
12 How to Create a Vector Diamond Necklace and a Chain
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.
13 How to Create a Vector Diamond Necklace and a Chain
Fill it up with gradience as show below
14 How to Create a Vector Diamond Necklace and a Chain
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.
15 How to Create a Vector Diamond Necklace and a Chain
16 How to Create a Vector Diamond Necklace and a Chain

Step 5

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.

17 How to Create a Vector Diamond Necklace and a Chain

Using live Paint fill it up with gradient Create a copy and align in the middle

18 How to Create a Vector Diamond Necklace and a Chain

Group the diamond shape that we created above and start placing it inside the RING that we created.

19 How to Create a Vector Diamond Necklace and a Chain
20 How to Create a Vector Diamond Necklace and a Chain
21 How to Create a Vector Diamond Necklace and a Chain

Give a gradient to the rings as show below.

22 How to Create a Vector Diamond Necklace and a Chain

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 )
23 How to Create a Vector Diamond Necklace and a Chain

Again take a copy of this broader circle and place at the top , and draw an oval shape filled with same gradient.

Step 6

CREATING THE CHAIN

24 How to Create a Vector Diamond Necklace and a Chain

Start building the chain with the copy of the same thing

25 How to Create a Vector Diamond Necklace and a Chain
26 How to Create a Vector Diamond Necklace and a Chain
27 How to Create a Vector Diamond Necklace and a Chain

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

28 How to Create a Vector Diamond Necklace and a Chain

FINAL PREVIEW

Create more copies and give a bit of transparencies.

29 How to Create a Vector Diamond Necklace and a Chain

 

30 How to Create a Vector Diamond Necklace and a Chain

How to Create a Vector Diamond Necklace and a Chain[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]

DOWNLOAD THE SOURCE FILE WHEN YOU ARE A MEMBERLogin Or Sign up

You May also like Some more Vector Basic Drawing Tutorials Or Complete list of Tutorials!

[categorythumbnaillist 13]

 

illustrator technique : How to Coloring Artwork Using Live Color advanced illustrator tutorials

 

%5BUNSET%5D illustrator technique : How to Coloring Artwork Using Live Color advanced illustrator tutorialsOk 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…)