Messages

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

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:

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']