Merry Xmas fellow webmasters, please I will like to know nairaland frontpage works. I mean how is the moving thread to frontpage works, am currently working on a project that needs that frontpage feature. Please anybody that knows about this should comment.

Contact the moderator in the section you upload your topic. If its a good topic I believe it would be move to the front page

Raiders:
Contact the moderator in the section you upload your topic. If its a good topic I believe it would be move to the front page

Thanks fr the reply, am nt asking fr my post to be moved to frontpage, but want to know how it works so I can implement it on my project.

maekhel:

Thanks fr the reply, am nt asking fr my post to be moved to frontpage, but want to know how it works so I can implement it on my project.

My guess is:

-NL has a file called "frontpage" or "featured".
-NL has a database table called "frontpage" or "featured".
-NL uses sql to insert and/or update the "frontpage" table...

Your knowledge of sql will help u achieve this cos u'll have to "join" posts into the frontpage table.

Note: I'm just guessing.

maekhel:

Thanks fr the reply, am nt asking fr my post to be moved to frontpage, but want to know how it works so I can implement it on my project.

I have done that stuff over and over again. Heres how it work:

1. you have a table named "frontpage" which is joined by the field "id_topic" for e.g referencing the "id" of the "topics" table.

2. You then have an admin accessible only "move to frontpage" link/button on each topic and if a topic is frontpage-worthy, click on this link and it takes you to a page or just lauch a modal where you will have the topic title in a text box. You can now modify the title the way you want it to appear on the frontpage. you can also have the link to the topic in another text box so you can modify it to add a permalink to a specific post on the thread.

3. When you are done, submit this to your frontpage table.

**** You can also place other fields in the frontpage table to control sticky et all.

onyengbu:

I have done that stuff over and over again. Heres how it work:

1. you have a table named "frontpage" which is joined by the field "id_topic" for e.g referencing the "id" of the "topics" table.

2. You then have an admin accessible only "move to frontpage" link/button on each topic and if a topic is frontpage-worthy, click on this link and it takes you to a page or just lauch a modal where you will have the topic title in a text box. You can now modify the title the way you want it to appear on the frontpage. you can also have the link to the topic in another text box so you can modify it to add a permalink to a specific post on the thread.

3. When you are done, submit this to your frontpage table.

**** You can also place other fields in the frontpage table to control sticky et all.

tanks fr dis info

download pbnl script intall and go tru the script it will help u no how its been done

There will be so many ways to achieve this without having a separate table that will have all the post id of all topics that have at one time made front page.

You don't have to create any table now.just create a status column in the table holding your topics then create a button in front of each topic from the admin end that will be clicked and the status of that topic will be updated by anything you give it so you had in your query a WHERE CLAUSE to select according to the status of each row. Eg if you want those topics that have a status=1 to always be on the front-page, you just include it in your SQL. Select * from topicstable where status=1. That's alll

cbrass:
You don't have to create any table now.just create a status column in the table holding your topics then create a button in front of each topic from the admin end that will be clicked and the status of that topic will be updated by anything you give it so you had in your query a WHERE CLAUSE to select according to the status of each row. Eg if you want those topics that have a status=1 to always be on the front-page, you just include it in your SQL. Select * from topicstable where status=1. That's alll

So how do you then sort the topics to show them according to when you added them?

MrAnonymous:
So how do you then sort the topics to show them according to when you added them?

You can create a timestamp column for that, if you don't have already.

So the query becomes something like:

Select * from topicstable where status=1 order by frontpage_timestamp

You run that query on the homepage.

adewasco2k:
There will be so many ways to achieve this without having a separate table that will have all the post id of all topics that have at one time made front page.

Absolutely. All it takes is adding extra columns on your topics table.