Title: Database Conflict
Last modified: August 18, 2016

---

# Database Conflict

 *  [max302](https://wordpress.org/support/users/max302/)
 * (@max302)
 * [19 years, 11 months ago](https://wordpress.org/support/topic/database-conflict/)
 * I have installed a home made script on the header .php file of the default theme
   and I have been getting error messages all aorund since. Here is the integration
   of the script in the in the header file:
    `<!DOCTYPE html PUBLIC "-//W3C//DTD
   XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.
   dtd"> <html xmlns="http://www.w3.org/1999/xhtml">
 * <head profile="[http://gmpg.org/xfn/11"&gt](http://gmpg.org/xfn/11"&gt);
    <meta
   http-equiv="Content-Type" content="<?php bloginfo('html_type'); ?>; charset=<?
   php bloginfo('charset'); ?>" />
 * <title><?php bloginfo('name'); ?> <?php if ( is_single() ) { ?> &raquo; Blog 
   Archive <?php } ?> <?php wp_title(); ?></title>
 * <meta name="generator" content="WordPress <?php bloginfo('version'); ?>" /> <!--
   leave this for stats -->
 * <link rel="stylesheet" href="<?php bloginfo('stylesheet_url'); ?>" type="text/
   css" media="screen" />
    <link rel="alternate" type="application/rss+xml" title
   ="<?php bloginfo('name'); ?> RSS Feed" href="<?php bloginfo('rss2_url'); ?>" /
   > <link rel="pingback" href="<?php bloginfo('pingback_url'); ?>" />
 * <style type="text/css" media="screen">
    /* To accomodate differing install paths
   of WordPress, images are referred only here, and not in the wp-layout.css file.
   If you prefer to use only CSS for colors and what not, then go right ahead and
   delete the following lines, and the image files. */
 *  body { background: url("<?php bloginfo('stylesheet_directory'); ?>/images/kubrickbgcolor.
   jpg"); } 
    <?php /* Checks to see whether it needs a sidebar or not */ if ((!
   $withcomments) && (! is_single())) { ?> #page { background: url("<?php bloginfo('
   stylesheet_directory'); ?>/images/kubrickbg.jpg") repeat-y top; border: none;}
   <?php } else { // No sidebar ?> #page { background: url("<?php bloginfo('stylesheet_directory');?
   >/images/kubrickbgwide.jpg") repeat-y top; border: none; }  <?php } ?> #header{
   background: url("<?php bloginfo('stylesheet_directory'); ?>/images/kubrickheader.
   jpg") no-repeat bottom center; } #footer { background: url("<?php bloginfo('stylesheet_directory');?
   >/images/kubrickfooter.jpg") no-repeat bottom; border: none;}
 * /* Because the template is slightly different, size-wise, with images, this needs
   to be set here
    If you don't want to use the template's images, you can also 
   delete the following two lines. */
 *  #header { margin: 0 !important; margin: 0 0 0 1px; padding: 1px; height: 198px;
   width: 758px; }
    #headerimg { margin: 7px 9px 0; height: 192px; width: 740px;}
 * /* To ease the insertion of a personal header image, I have done it in such a
   way,
    that you simply drop in an image called 'personalheader.jpg' into your /
   images/ directory. Dimensions should be at least 760px x 200px. Anything above
   that will get cropped off of the image. */ /* #headerimg { background: url('<?
   php bloginfo('stylesheet_directory'); ?>/wp-content/themes/default/images/bsod.
   gif') no-repeat top;} */ </style>
 * <?php wp_head(); ?>
    <?php /*---------------------------------Visitor logger------------------------*//*-------
   DB Params-------*/ $ydbuser = "tales_visitor"; // Database user used, change 
   as needed $ydbhost = "localhost"; // Database used $ydbpasswd = "1235789"; //
   Database user password $ydbdatabase = "tales_other"; // Database $ydbconnection
   = mysql_connect($ydbhost,$ydbuser,$ydbpasswd); $ydb = mysql_select_db($ydbdatabase,
   $ydbconnection); /*-----End DB Params-----*/
 * $ytoday = date("Ymj");
    if (strlen($ytoday) == 5) { $ytoday[6] = $ytoday[5]; 
   $ytoday[5] = 0; } $yuserip = getenv("REMOTE_ADDR");  $ycheckip = "SELECT * FROM
   visitcount WHERE userip = '$yuserip'"; $ycheckipq = mysql_query($ycheckip); $
   ycheckipr = mysql_result($ycheckipq,'1','visitcount'); $yprevvisits = mysql_result(
   $ycheckipq,'1','visitcount'); if ($ycheckipr == 0) { $yadduser = "INSERT INTO
   visitcount (userip,lastvisit,visitcount) VALUES ('$yuserip','$ytoday',1)"; mysql_query(
   $yadduser); } else if ($yprevvisits != $ytoday) { $yvisits = $yprevvisits; $yvisits
   ++ ;  $yupdatevisits = "UPDATE visitcount SET visitcount = '$yvisits' AND lastvisit
   = '$ytoday' WHERE userip = '$yuserip'"; mysql_query($yupdatevisits); } ?>
 * </head>
    <body> <div id="page">
 *  <div id="header">
    <div id="headerimg"> <h1><a href="<?php echo get_settings('
   home'); ?>/"><?php bloginfo('name'); ?></a></h1> <div class="description"><?php
   bloginfo('description'); ?></div> </div> </div>
 * Error messages show up on the page at [http://www.talesofanoob.er1.be](http://www.talesofanoob.er1.be)

Viewing 1 replies (of 1 total)

 *  [maerk](https://wordpress.org/support/users/maerk/)
 * (@maerk)
 * [19 years, 11 months ago](https://wordpress.org/support/topic/database-conflict/#post-407800)
 * Ouch! Too much code! For future reference, could you use pastebin.com, or something
   similar, to post long bits of code?
 * I have to say, I’m not a mysql expert, but I’m sure someone will be able to help
   😉

Viewing 1 replies (of 1 total)

The topic ‘Database Conflict’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [maerk](https://wordpress.org/support/users/maerk/)
 * Last activity: [19 years, 11 months ago](https://wordpress.org/support/topic/database-conflict/#post-407800)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics
