phpBB2 by Przemo

maminowiec · **Pomógł:** 551 razy Posty: 1729

lui754, tak dodaje slesze ale jest błąd

Gadatliwa Kasia

Seba123 · **Pomógł:** 74 razy Posty: 868

Poprawiony plik go_url.php

Kod:

<?php
/***************************************************************************
* go_url.php
* -------------------
* begin : Friday, May 14, 2004
* author : bthivent
* email : bthivent@aol.com
*
* $Id: $
*
*
***************************************************************************/

/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

$userid = intval($HTTP_GET_VARS['id']);
if(!ereg('^\d+$', $userid) || $userid < 0)
{
die('Hacking attempt');
}

$sql = "SELECT user_website, user_hits_url
FROM " . USERS_TABLE ."
WHERE user_id = '" . $userid . "'";

if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Error sql', '', __LINE__, __FILE__, $sql);
}
if ( !( $row = $db->sql_fetchrow($result) ) )
{
message_die(GENERAL_ERROR, 'Error, user website was not found', '', __LINE__, __FILE__, $sql);
}
else
{
$user_hits_url = $row['user_hits_url'] + "1";
$sql = "UPDATE " . USERS_TABLE ."
SET user_hits_url = '" . $user_hits_url ."'
WHERE user_id = '" . $userid . "'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Error, website hits were not updated', '', __LINE__, __FILE__, $sql);
}
echo '<SCRIPT LANGUAGE="JavaScript">';
echo 'document.location.href="' . $row['user_website'] . '"';
echo '</SCRIPT>';
}

?>

lui754 · **Pomógł:** 591 razy Posty: 2699

seba czemu dodałeś 2 zapytania?

Kod:

$sql = "SELECT user_website, user_hits_url
FROM " . USERS_TABLE ."
WHERE user_id = '" . $userid . "'";

$sql = "SELECT user_website, user_hits_url
FROM " . USERS_TABLE ."
WHERE user_id = '" . $userid . "'";

Seba123 · **Pomógł:** 74 razy Posty: 868

Przypadkiem. Poza tym, to nie dwa zapytania, tylko 2x to samo przypisałem do zmiennej.

axas · Posty: 81

a takia propozycja, a czy dało by radę zrobić moda aby też zliczał wejścia na stronę użytkownika z postów??