Code Rewrite

[anantgupta]

Hello,
I am trying to fix this mod so that it is compatible with smf 1.1.12
http://custom.simplemachines.org/mods/index.php?mod=1138

I am weak in database.
i searched and found that $smcFunc doesnt work with smf 1.1.12

Can you rewrite this function so that it works with smf 1.1.12 also ??

function MetaTagsGenerateTeaser ($id_msg)
{
	global $smcFunc;

	$request = $smcFunc['db_query']('', '
		SELECT body
		FROM {db_prefix}messages
		WHERE id_msg = {int:id_msg}',
		array(
			'id_msg' => $id_msg
		));

	list ($teaser) = $smcFunc['db_fetch_row']($request);
	$smcFunc['db_free_result']($request);

 

[anantgupta]

http://www.simplemachines.org/community/index.php?topic=224166.0
http://dev.simplemachines.org/smcfunctions.php

here is the example how it is used.

Found this too

$smcFunc['db_fetch_row'] is similar to http://in.php.net/mysql_fetch_row

$smcFunc['db_free_result'] is similar to http://php.net/mysql_free_result

Help me <3

 

[anantgupta]

Thought of editing the last reply but decided to make another reply <3
Next try...

function MetaTagsGenerateTeaser ($id_msg)
{
	
	$request = db_query("SELECT body
		FROM (smf_messages AS m)
		WHERE m.id_msg = 1");

	list ($teaser) = mysql_fetch_row($request);
	mysql_free_result($request);

	// Format as a plain text string.
	$teaser = MetaTagsSpecialChars(str_replace('<br />', ' ', parse_bbc($teaser)));

	// Less than the teasear limit, just return.
	if(strlen($teaser) < 150)
		return $teaser;

	// Otherwise grab the teaser.
	$teaser = substr($teaser, 0, 150);
	return substr($teaser, 0, strrpos($teaser, ' '));
}

just need array to search for the current post's id_msg and place it here in place of 1.
How to do it ?
People on smf support also not replying damn...
m.id_msg = 1

 

[warezrock]

Problem solved... :P :D

 

[anantgupta]

Yeah.... Thanx warezrock <3
This mod will be out shortly for smf 1.1.12 by warezrock and me :D

 

[Clowner]

do u guys have the version that's compatible with 1.1.12?

 

[anantgupta]

Yeah was working on 1.1.12 only you need it ??