Codezwiz >> Forums >> General PHP Nuke Help >> Buddylist install help-SQL code file

Hi

Has anyone used Buddylist mod, and was successful. I am having problem installing.

I can not install the SQL cod for this mod. Does any has the SQL code.

hi theeoneandonly,

here is the link
[ Register or login to view links on this board. ]

thanks

in the path folder

phpbb_root_path

theres a file called 'db_update.php', place it into your forums root folder, for example if the path is called 'forum', you'll drop the db_update file inside there.

As an administrator you'll run the file, link should be
yourdomain.com/forum/db_update.php

If you need anymore assistance, please let me know.

Justin

Hi

I did that before, but
[ Register or login to view links on this board. ]

That page goes to my main page of the Forum.

Before this, I downloaded different mod from the same site. They had the SQL code in it. I just pasted in my SQL, and works fine Looks like this

#-----[ SQL ]-------------------------------------------
#
ALTER TABLE phpbb_users ADD user_profile_views mediumint( 8 ) NOT NULL;

#
#-----[ SQL ]-------------------------------------------
#
CREATE TABLE phpbb_profile_views ( user_id    mediumint( 8 ) NOT NULL,
            time    int( 11 ) NOT NULL,
            ip_address char( 20 ) NOT NULL );

I just noticed, that I see an BUDDY Icon on the post

But when view a user profile I get this message

Could not obtain buddies information

DEBUG MODE

SQL Error : 1146 Table 'izappoin_max.nuke_bbbuddies' doesn't exist

SELECT buddy_id FROM nuke_bbbuddies WHERE user_id = 7 AND buddy_id = 22

Line : 230
File : usercp_viewprofile.php

And when I click on the Buddy Icon,

The topic or post you requested does not exist

Register

here ya go. You'll probably want to go into phpmyadmin and delete the table that got created from your install..it should be called phpbb_bbbuddies or somethin like that just to clean up a bit. Once you run this the table will be nuke_bbbuddies.

<?php
/***************************************************************************
* db_update.php
* -------------------
* copyright : ©2003 Freakin' Booty ;-P
* built for : Buddy list v0.9.5
*
*
***************************************************************************/

/***************************************************************************
*
* 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.
*
***************************************************************************/

if (!eregi("modules.php", $PHP_SELF)) {
die ("You can't access this file directly...");
}
if ($popup != "1"){
$module_name = basename(dirname(__FILE__));
require("modules/".$module_name."/nukebb.php");
}
else
{
$phpbb_root_path = 'modules/Forums/';
}
define('IN_PHPBB', true);

include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include('header.php');
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX, $nukeuser);
init_userprefs($userdata);
//
// End session management
//

if( !$userdata['session_logged_in'] )
{
$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
header($header_location . append_sid('login.'.$phpEx.'?redirect=db_update.'.$phpEx));
exit;
}

if( $userdata['user_level'] != ADMIN )
{
message_die(GENERAL_MESSAGE, 'You are not authorised to run access this page');
}

$sql = array();
$sql[] = 'CREATE TABLE ' . $prefix . '_bbbuddies (user_id mediumint(8) UNSIGNED NOT NULL DEFAULT 0, buddy_id mediumint(8) UNSIGNED NOT NULL DEFAULT 0)';

for( $i = 0; $i < count($sql); $i++ )
{
if( !$result = $db->sql_query ($sql[$i]) )
{
message_die(GENERAL_ERROR, 'Could not update database', '', __LINE__, __FILE__, $sql[$i]);
}

$sql_message .= '- ' . $sql[$i] . ' ';
}

$message = 'Database updated successfully The following queries were executed: ' . $sql_message . ' Please be sure to delete this file now ' . sprintf ($lang['Click_return_index'], '<a href="' . append_sid ('index.'.$phpEx) . '">', '</a>');
message_die (GENERAL_MESSAGE, $message);

?>