请懂数据库的的朋友帮我!在线等谢谢!vbb联盟论坛问题!
请懂数据库的的朋友帮我!在线等谢谢!vbb联盟论坛问题!
我的vbb数据库的前缀:"vbb" 例如:
vbbbbcode
vbbcalendar
vbbcalendarcustomfield
那么我想让联盟论坛的sitelink也是vbb前缀 改下面的什么地方(在什么地方加"vbb")
QUOTE:
DROP TABLE IF EXISTS `sitelink`;
CREATE TABLE `sitelink` (
`sitelinkid` int(10) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`logourl` varchar(255) NOT NULL default '',
`desc` mediumtext NOT NULL,
`displayorder` smallint(5) NOT NULL default '0',
PRIMARY KEY (`sitelinkid`)
) TYPE=MyISAM;
还有sitelink文件怎么改?
PHP 代码:
<?php
// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// ##################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS', 1);
// #################### PRE-CACHE TEMPLATES AND DATA ######################
$phrasegroups = array('cppermission');
$specialtemplates = array();
// ########################## REQUIRE BACK-END ############################
require_once('./global.php');
// ############################# LOG ACTION ###############################
$vbulletin->input->clean_array_gpc('r', array(
'sitelinkid' => TYPE_INT
));
log_admin_action(iif($vbulletin->GPC['sitelinkid'] != 0, "sitelink id = " . $vbulletin->GPC['sitelinkid']));
// ########################################################################
// ######################### START MAIN SCRIPT ############################
// ########################################################################
print_cp_header('联盟论坛管理');
if (empty($_REQUEST['do']))
{
$_REQUEST['do'] = 'modify';
}
// ###################### Start edit #######################
if ($_REQUEST['do'] == 'edit')
{
print_form_header('sitelink', 'update');
if (isset($_REQUEST['sitelinkid']))
{
$sitelink = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "sitelink WHERE sitelinkid = " . intval($_REQUEST['sitelinkid']));
print_table_header(construct_phrase($vbphrase['x_y_id_z'], '联盟论坛', $sitelink['title'], $sitelink['sitelinkid']));
construct_hidden_code('sitelinkid' , $sitelink['sitelinkid']);
}
else
{
$sitelink['url'] = 'http://';
$sitelink['logourl'] = 'http://';
print_table_header('添加新联盟论坛');
}
print_input_row('名称', 'title', $sitelink['title']);
print_input_row('链接', 'url', $sitelink['url']);
print_input_row('图标链接<dfn>如果填写图标链接而没有填写描述，则该联盟论坛链接为图像链接</dfn>', 'logourl', $sitelink['logourl']);
print_textarea_row('描述<dfn>如果填写描述，该联盟论坛将会占用表格一整行的空间</dfn>', 'desc', $sitelink['desc']);
print_input_row('显示顺序', 'displayorder', $sitelink['displayorder']);
print_submit_row($vbphrase['save']);
}
// ###################### Start do update #######################
if ($_POST['do'] == 'update')
{
$vbulletin->input->clean_array_gpc('p', array(
'title' => TYPE_STR,
'url' => TYPE_STR,
'logourl' => TYPE_STR,
'desc' => TYPE_STR,
'sitelinkid' => TYPE_INT,
'displayorder' => TYPE_INT,
));
if (empty($vbulletin->GPC['sitelinkid']))
{
// add new
$db->query("
INSERT INTO " . TABLE_PREFIX . "`sitelink`
(`title`, `url`, `logourl`, `desc`, `displayorder`)
VALUES
('" . $vbulletin->GPC['title'] . "', '" . $vbulletin->GPC['url'] . "', '" . $vbulletin->GPC['logourl'] . "','" . $vbulletin->GPC['desc'] . "','" . $vbulletin->GPC['displayorder'] . "')
");
}
else
{
// update
$db->query("
UPDATE " . TABLE_PREFIX . "`sitelink`
SET `title` = '" . $vbulletin->GPC['title'] . "',
`url` = '" . $vbulletin->GPC['url'] . "',
`logourl` = '" . $vbulletin->GPC['logourl'] . "',
`desc` = '" . $vbulletin->GPC['desc'] . "',
`displayorder` = '" . $vbulletin->GPC['displayorder'] . "'
WHERE `sitelinkid` = " . $vbulletin->GPC['sitelinkid']
);
}
// 更新缓存
$sitelinks = $db->query("SELECT * FROM " . TABLE_PREFIX . "sitelink ORDER BY displayorder");
while ($sitelink = $db->fetch_array($sitelinks))
{
$sitelinkcache[] = $sitelink;
}
build_datastore('sitelinkcache', serialize($sitelinkcache));
define('CP_REDIRECT', 'sitelink.php?$session[sessionurl]do=modify');
print_cp_message("保存联盟论坛{$title}成功", CP_REDIRECT);
}
// ###################### Start Update Display Order #######################
if ($_POST['do'] == 'dodisplayorder')
{
$vbulletin->input->clean_array_gpc('r', array(
'order' => TYPE_ARRAY
));
if (is_array($order))
{
$sitelinks = $db->query("
SELECT sitelinkid,displayorder
FROM " . TABLE_PREFIX . "sitelink
");
while ($sitelink = $db->fetch_array($sitelinks))
{
$displayorder = intval($order["$sitelink[sitelinkid]"]);
if ($sitelink['displayorder'] != $displayorder)
{
$db->query("
UPDATE " . TABLE_PREFIX . "sitelink
SET displayorder = $displayorder
WHERE sitelinkid = $sitelink[sitelinkid]
");
}
}
}
// 更新缓存
$sitelinks = $db->query("SELECT * FROM " . TABLE_PREFIX . "sitelink ORDER BY displayorder");
while ($sitelink = $db->fetch_array($sitelinks))
{
$sitelinkcache[] = $sitelink;
}
build_datastore('sitelinkcache', serialize($sitelinkcache));
define('CP_REDIRECT', "sitelink.php?$session[sessionurl]do=modify");
print_stop_message('saved_display_order_successfully', CP_REDIRECT);
}
// ###################### Start Remove Sitelink #######################
if ($_REQUEST['do'] == 'remove')
{
$vbulletin->input->clean_array_gpc('r', array(
'sitelinkid' => TYPE_INT
));
echo "<p> </p><p> </p>\n";
print_form_header('sitelink', 'kill');
construct_hidden_code('sitelinkid', $vbulletin->GPC['sitelinkid']);
print_table_header('确认删除？');
print_description_row('<blockquote>您确认要删除该联盟论坛？</blockquote>');
print_submit_row($vbphrase['delete'], '', 2, $vbphrase['go_back']);
}
// ###################### Start Kill #######################
if ($_POST['do'] == 'kill')
{
$vbulletin->input->clean_array_gpc('r', array(
'sitelinkid' => TYPE_INT
));
$db->query("DELETE FROM " . TABLE_PREFIX . "sitelink WHERE sitelinkid = ".$vbulletin->GPC['sitelinkid']);
// 更新缓存
$sitelinks = $db->query("SELECT * FROM " . TABLE_PREFIX . "sitelink ORDER BY displayorder");
while ($sitelink = $db->fetch_array($sitelinks))
{
$sitelinkcache[] = $sitelink;
}
build_datastore('sitelinkcache', serialize($sitelinkcache));
define('CP_REDIRECT', "sitelink.php?$session[sessionurl]do=modify");
print_cp_message("删除联盟论坛成功", CP_REDIRECT);
}
// ###################### Start Modify Sitelinks #######################
if ($_REQUEST['do'] == 'modify')
{
$sitelinks = $db->query("SELECT * FROM " . TABLE_PREFIX . "sitelink ORDER BY displayorder");
if ($db->num_rows($sitelinks))
{
print_form_header('sitelink', 'dodisplayorder');
print_table_header('编辑联盟论坛', 4);
print_cells_row(array('名称', '图标', $vbphrase['display_order'], $vbphrase['controls']), 1);
while ($sitelink = $db->fetch_array($sitelinks))
{
$cell = array();
$cell[] = "<a href=\"$sitelink[url]\">$sitelink[title]</a>";
$cell[] = "<img src=\"$sitelink[logourl]\" border=\"0\"/>";
$cell[] = "<input type=\"text\" class=\"bginput\" name=\"order[$sitelink[sitelinkid]]\" value=\"$sitelink[displayorder]\" tabindex=\"1\" size=\"3\" />";
$cell[] =
construct_link_code($vbphrase['edit'], "sitelink.php?$session[sessionurl]do=edit&sitelinkid=$sitelink[sitelinkid]").
construct_link_code($vbphrase['delete'], "sitelink.php?$session[sessionurl]do=remove&sitelinkid=$sitelink[sitelinkid]");
print_cells_row($cell);
}
print_submit_row($vbphrase['save_display_order'], NULL, 4);
echo "<p align=\"center\">" . construct_link_code('添加新联盟论坛', "sitelink.php?$session[sessionurl]do=edit")."</p>";
}
else
{
print_stop_message("no_sitelink_found", "sitelink.php?$session[sessionurl]do=add");
}
}
print_cp_footer();
?>
就是说在哪些变量前加"vbb"
谢谢
2005-09-15, 13:44
平板模式
