Tema: mysql y php
Ver Mensaje Individual
  #1 (permalink)  
Antiguo 27/10/2004, 17:27
anebg
 
Fecha de Ingreso: junio-2004
Mensajes: 28
Antigüedad: 19 años, 10 meses
Puntos: 0
mysql y php

<?php

$allok = 1;
$dodbstuf = 1;
$islocalreq = 0;

//@@ fill in your config info here !
$db_hostname = "localhost";
$db_database = "db_hackutech_gratishost_com";
$db_user = "XXXXX";
$db_pass = "XXXXX";

$bb_baseurl = "./foro";
$bb_cookiename = "phpbb2mysql"; // _data, _sid

if (isset ($HTTP_COOKIE_VARS[$bb_cookiename .'_sid']))
$sid = $HTTP_COOKIE_VARS[$bb_cookiename .'_sid'];
else $dodbstuf = 0;

if (isset ($_SERVER["REMOTE_ADDR"]))
$clientaddr = $_SERVER["REMOTE_ADDR"];
if ( ($clientaddr == "127.0.0.1") && (1) ) //@@
$islocalreq = 1;

if (isset ($_SERVER['SCRIPT_NAME']))
$formname = $_SERVER['SCRIPT_NAME'];

// connect, select database
if ( ($allok) && ($dodbstuf) )
if (! $link = mysql_connect ($db_hostname, $db_user, $db_pass))
{ $allok = 0; $dberrs = "Error opening db."; }
elseif (! mysql_select_db ($db_database))
{ $allok = 0; $dberrs = "Error selecting db."; }

// figure query
if ( ($allok) && ($dodbstuf) )
$query = "SELECT u.user_id, u.username,"
." u.user_new_privmsg, u.user_unread_privmsg"
." FROM phpbb_sessions AS ss, phpbb_users as u"
." WHERE ss.session_id = '$sid'"
." AND ss.session_user_id = u.user_id";

//@ print $query."<p>\n";

// do the query
if ( ($allok) && ($dodbstuf) )
if (! $result = mysql_query ($query))
{ $allok = 0; $dberrs = "Query failed : " .mysql_error(); }
else
{
$numrows = mysql_num_rows ($result);
$numfields = mysql_num_fields ($result);
}

// extract results
if ( ($allok) && ($dodbstuf) )
if ( ($numrows > 0) && ($numfields > 0) )
{
$uinfo = mysql_fetch_array($result, MYSQL_NUM);
$uid = $uinfo [0];
$uname = $uinfo [1];
$upmnew = $uinfo [2];
$upmunread = $uinfo [3];
}

// finally, put up our toolbar
if ( (isset ($uname)) && ($uname != 'Anonymous') )
include("index.php");
else
print"<table width=\"39%\" border=\"1px\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#333333\">"
." <tr bgcolor=\"#000000\">"
." <font style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #CCCCCC; \">Eres un usuario Ánónimo; no puedes accesar a esta sección..</font></td>"
." <font style=\"font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color: #CCCCCC; \">Tienes que registrarte en el Foro!</font></td>
."</tr>"
."</table>";


// wrap up - free resultset, close db, show errs (if any)
if ( ($dodbstuf) && ($result) )
mysql_free_result ($result);
if ( ($dodbstuf) && ($link) )
mysql_close ($link);
if ( ($dodbstuf) && (! $allok) )
{ print $dberrs; }

?>

esto es conectando mi phpbb a mi index para que allan usuarios registrados pero me sale un error Parse error:

parse error in /home/virtual/sitio13494/www/prueba.php on line 74 alguien me puede ayudar