News Page ?

[Searchtheweb]

Hi,

JanArve, as you already know, i posted before about the need of news area improvement. My website runs on PhpAS 3.0 and I would like to build a page where all my news item would be.

Any idea on how may i achieve that ?

baseurl/stiri/newsid/news.html

stiri means news in Romanian

I would need something in the form of the memberlist, i guess...

Thank you in advance

Best regards,

Searchtheweb

[JanArve]

Hey,

The news items are stored in the "news" table in the database so you could do a query similar to how the games are listed and list the last 10 news items:

Code:

SELECT * FROM news WHERE status = 1 ORDER BY id DESC LIMIT 10

And then display the news in some fashion. The above will display based on news item id, replace "id" with "date" to sort by the date instead.

"title" and "text" and "date" are the other fields in this table.

[Searchtheweb]

I solved it. I used your query and the memberlist.php file, a little bit modified and it works.

Thank you very much.

[JanArve]

Looks good, nice work

[Searchtheweb]

Thank you very much. I'm trying to do my best.

It would be useful, for future phpAS versions, to have a tiny text editor at the game description textarea to help us insert faster a link on a given word.

Best regards,

Searchtheweb