Author Topic: Modified News.php (Read 31420 times)

Alreadythere · « **Reply #15 on:** February 02, 2006, 02:03:41 pm »

Quote from: Khalem on February 02, 2006, 01:23:49 pm

- Find a better way to pull a single result without doing the foreach loop.

I guess you are talking about code like

$result = $this -> bot -> db -> select("SELECT id, time  FROM news WHERE type = '2' OR type = '1' ORDER BY id DESC LIMIT 0, 1");
if (!empty($result))
foreach ($result as $val)
{
	$newsdate = gmdate("dS M, H:i", $val[1]);
}

Just try

Code: [Select]

$result = $this -> bot -> db -> select("SELECT id, time  FROM news WHERE type = '2' OR type = '1' ORDER BY id DESC LIMIT 0, 1");
if (!empty($result))
	$newsdate = gmdate("dS M, H:i", $result[0][1]);

$result is an array, $result[0] is the first entry - which has to exist, otherwise it would be empty. And you know that there won't be a second entry anyways.

Aesgaard · « **Reply #16 on:** February 28, 2007, 02:32:20 am »

Is it just me or is all the host servers down ?

jjones666 · « **Reply #17 on:** February 28, 2007, 08:21:09 am »

The latest version of !news should be in Bebot 0.2.11. For a good alternative search for NewNews on the forum (by Glarawyn).

-jj-

Aesgaard · « **Reply #18 on:** September 02, 2007, 02:07:10 pm »

News for version 0.4 would be nice *sigh*

Joulette · « **Reply #19 on:** November 25, 2007, 06:01:02 pm »

In the news module, there's unfortunately no way to delete a headline item if it breaks the gui, which is what happened to our new today. I added a headline item that broke the gui. Now I don't have a way to delete it, and we can't view the news either.

Any suggestions?

thanks

Blueeagle · « **Reply #20 on:** November 26, 2007, 07:52:46 am »

Best way would be to not use html-ish tags in the items. Those should ofcourse have been converted to < and > before being inserted.

For now deleting them from the database manually using either the command line or some administrator tool would be best.