1
Items / Re: New Item: Add membergroup
« on: November 27, 2011, 12:22:06 am »
Igualmente tengo el mismo problema y me interesa mucho el item.
Yo pienso que el error esta aqui:
Ejemplo para SMF 1.1
Ejemplo para SMF 2.0
¿Quedaria asi el nuevo codigo para addmembergroup en SMF 2.0?:
Mas lineas de codigo necesitan nuevos comandos.
RE-FIX este item please.
MAS INFO (Changes in SMF 2.0 ):
http://docs.simplemachines.org/index.php?topic=1433.0#post_db
The main functions are listed below:
Yo pienso que el error esta aqui:
Ejemplo para SMF 1.1
Code: [Select]
$result = db_query("SELECT ID_GROUP, groupName
FROM {$db_prefix}membergroups
WHERE minPosts = -1",
__FILE__, __LINE__);
Ejemplo para SMF 2.0
Code: [Select]
// Get all the topics in board 1
$result = $smcFunc['db_query']('', "
SELECT t.id_topic, m.poster_name, m.subject
FROM {db_prefix}topics AS t
INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
WHERE t.id_board = {int:id_board}
LIMIT 10",
array(
'id_board' => 1,
));
¿Quedaria asi el nuevo codigo para addmembergroup en SMF 2.0?:
Code: [Select]
// Get all non post-based membergroups
$result = $smcFunc['db_query']('', "
SELECT id_group, group_name
FROM {db_prefix}membergroups
WHERE min_posts = -1",
);
Mas lineas de codigo necesitan nuevos comandos.
RE-FIX este item please.
MAS INFO (Changes in SMF 2.0 ):
http://docs.simplemachines.org/index.php?topic=1433.0#post_db
The main functions are listed below:
Quote
Function used in SMF 1.1
db_query
mysql_fetch_assoc
mysql_fetch_row
mysql_num_rows
mysql_free_result
mysql_real_escape_string or mysql_escape_string
SMF 2.0 equivalent
$smcFunc['db_query']
$smcFunc['db_fetch_assoc']
$smcFunc['db_fetch_row']
$smcFunc['db_num_rows']
$smcFunc['db_free_result']
$smcFunc['db_escape_string']