function forum_install()
{
mysql_all_query('CREATE TABLE IF NOT EXISTS `forum_categorias` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`desc` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `forum_respostas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`topic` int(11) NOT NULL,
`owner` int(11) NOT NULL,
`text` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `forum_topics` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cat` int(11) NOT NULL,
`owner` int(11) NOT NULL,
`title` varchar(255) NOT NULL,
`text` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;');
addmenu("Fórum", "forum");
}
function chat_install()
{
mysql_all_query("CREATE TABLE IF NOT EXISTS `chat` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `owner` int(11) NOT NULL,\n `room` int(11) NOT NULL,\n `text` text NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;\n\n\nCREATE TABLE IF NOT EXISTS `chat_rooms` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `nome` varchar(255) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
addmenu("Chat", "chat");
}
//从wx_wechat_module_type中查找类型ID
$sql_typeId = "select id from wx_wechat_module_type where name='{$menuTypeName}'";
$res_typeId = $db->getrow($sql_typeId);
$menuType = $res_typeId['id'];
//将菜单信息保存在wx_wechat_module表中
$seq = $secondMenuNum + 1;
//菜单排序默认为自增一
$sql_insert_first = "insert into wx_wechat_module (name,parentId,seq,menuType,urlPC,urlWechat) values ('{$menuName}','{$menuParentId}','{$seq}','{$menuType}','{$urlPC}','{$urlWechat}')";
$res_insert_first = $db->execsql($sql_insert_first);
if (mysql_affected_rows() > 0) {
/******************菜单添加成功后，根据选项为菜单添加功能************************/
$menuId = mysql_insert_id();
//添加的菜单的moduleId
//为菜单添加功能
$secondError = true;
$secondError = addmenu($menuName, $menuFirstType, $menusecondType, $menuId);
if ($secondError && $error) {
$add['id'] = $menuId;
//添加的菜单的moduleId
$add['error'] = 1;
//添加成功
} else {
/*****************若菜单功能未添加成功，则删除菜单***********************/
$add['error'] = 0;
//添加失败
$sql_del = "delete from wx_wechat_module where id='{$menuId}'";
$res_del = $db->execsql($sql_del);
}
} else {
$add['error'] = 0;
//添加失败
function search_install()
{
addmenu("Busca", "search");
}
$valid = validate_request($guid, $userid);
if (!$valid['success']) {
error_log('Request failed: ' . $valid['message']);
die;
}
$vegetarian = 0;
if ($query) {
$action = $query->request->intent->name;
if ($action == "GetVegetarian") {
$vegetarian = 1;
}
# Get a suggestion for dinner
if ($action == 'GetVegetarian' || $action == 'GetMenu') {
$response = getmenu($db, $vegetarian);
} elseif ($action == 'AddMenu') {
$response = addmenu($db, $query);
} elseif ($action == 'GetRecipe') {
$response = getrecipe($db, $query);
} else {
# if ( $action == 'AMAZON.HelpIntent' ) {
$response = $help;
}
} else {
$response = $help;
}
sendresponse($response, $me);
echo json_encode($response);
/*
Get a menu recommendation
getmenu( $db, $vegetarian );
function minijogos_install()
{
addmenu("Jogos", "minijogos");
}
function comu_install()
{
mysql_all_query("DROP TABLE IF EXISTS `comunidade`;\nCREATE TABLE `comunidade` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `tipo` char(1) NOT NULL COMMENT 'm ou t',\n `nome` varchar(255) NOT NULL,\n `descricao` text,\n `imagem` varchar(255) NOT NULL,\n `link` varchar(255) NOT NULL,\n `user` varchar(255) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
addmenu("Módulos e temas", "comu");
}
