Database update statement

UPDATE `wp_posts` SET post_title = REPLACE (post_title, “
”, “<p>”)

UPDATE wp_posts SET post_content = REPLACE(post_content, 'http://oldurl/', 'http://newurl/');
UPDATE wp_posts_nodomain SET post_content = REPLACE(post_content, 'http://oldurl/', 'http://newurl/');

test SELECT COUNT(*) post_content FROM wp_posts WHERE post_content LIKE '%http://oldurl%';

Partnerships for Research and Education in Materials (PREM)

The main goal of Partnerships for Research and Education in Materials (PREM) is to enhance diversity in materials research and education by stimulating the development of formal, long-term, collaborative research and education partnerships between minority-serving colleges and universities and the NSF Division of Materials Research (DMR)-supported centers and facilities.

Center's Page
Center’s Page
Admin Screen
Admin Screen
Single Page
Single Page

Add .pdf, .doc, .ppt icons-indicators with css

Long time ago got this code from    /*   http://my-dimension.com/blog/category/xhtml-css/   */
Download all images in zip file

a[href^=”http://”]:not([href*=”iringweb.com”])::after {
content: “”;
background: url(/images/external.png) center right no-repeat;
padding-right: 1em;
}

a[href^=”mailto:”] {
background: transparent url(‘/images/mail_icon.gif’) 100% 50% no-repeat;
padding-right: 18px;
}
a[href$=”.doc”] {
background: transparent url(‘/images/word_icon.gif’) 100% 50% no-repeat;
padding-right: 18px;
}

a[href$=”.pdf”] {
background: transparent url(‘/images/pdf_icon.gif’) 100% 50% no-repeat;
padding-right: 18px;
}

a[href$=”.ppt”] {
background: transparent url(‘/images/powerpoint_icon.gif’) 100% 50% no-repeat;
padding-right: 18px;
}

#bodyContent a.external,
#bodyContent a[href ^=”https://”],
.link-https {
background: url(‘/images/lock_icon.gif’) center right no-repeat;
padding-right: 16px;
}

Economics Department, Stanford University

A  website for the Economics Department at Stanford University has the following features:

  • Each section on the site is updated by non-technical  Content Managers that have set of access permissions restricted to the areas of their responsibility.
  • Custom Content types for  Courses,  Faculty Profiles, Graduate Student Profiles, Publications, Seminars
  • Single point of entry for each information item
  • Training/help section

Tools:  Drupal 5.9 with  intensive use of CCK and Views, jQuery, css, PHP

Launched 2008

Front Page
Front Page
Faculty
Faculty
Seminars (Views with custom php code)
Seminars (Views with custom php code)
Job Market Candidates (A View)
Job Market Candidates (A View)
Graduate (Static Page)
Graduate (Static Page)

hover text

http://meyerweb.com/eric/css/edge/popups/demo.html

<div class=”help_register” >

<a href=”/faq/”> <img src=”http://irina.redroom.com/sites/all/themes/redroom/images/questionmark.png”  /> <span> This is the address where we will send emails and newsletters. We won�t share this address with anyone without your permission. </span> </a>

</div>
</div>
</div>
<style>
.help_register�� {� position:absolute;�� left: 42em; }
div.help_register a span {display: none;}
div.help_register a:hover { display: block; } /*ie workaround for hover to work */
div.help_register� a:hover span {�� �display: block;
position:absolute;
width: 18em;
left: 10px;
text-decoration:none;
border: 1px dotted #900; background-color:#eee; padding: .8em;
z-index: 20;
}
</style>