Revcms News

[FunzyKiller]

I am Having problems with news, as u can see the 2nd picture thrs a very uncommon blue line and posted on 01-01-70, i dont know how it looks like. anyone can fix it? i dont know how the page look like when i go to news but it gives me this. and another problems. the author is 0 not sure why is it. should be the owner name but its 0.

 

[JayC]

Change author in your database to be a varchar or text instead of an integer value and then when you post, your username will actually go in there,
And the 2nd image doesn't have a title because you're not looking at an actual article?

 

[FunzyKiller]

Yes the 2nd picture. Haven't look at an actual articles but can u see its weird the line appear and I check someone else cms when it enter to the news it direct them to the latest news but I don't.
 
yes i fixed the author thank you, and forget thrs another problem tht it doesnt direct me to the latest news when i click the news, and another problem that i forget to tell is the articles picture doesn't show at the me.page thrs no pic in it just words etc.

 

[JayC]

Make sure the link redirects you to the news id and make sure its grabs the last couple ID's... and make sure that the images are in the correctly folder link

 

[FunzyKiller]

In the database image? There's a link to image but not sure change to where.
 
And how do u make the news direct to your latest news?

 

[Marcel]

You mean something like this ?

<?php
$to5 = mysql_query("SELECT * FROM cms_news ORDER BY ID DESC LIMIT 50") or die(mysql_error());
?>

 

[flyest]

And how do u make the news direct to your latest news?

<a href="/index.php?url=news&id={newsID-1}">{newsTitle-1}</a>
<a href="/index.php?url=news&id={newsID-2}">{newsTitle-2}</a>
<a href="/index.php?url=news&id={newsID-3}">{newsTitle-3}</a>

 

[FunzyKiller]

<a href="/index.php?url=news&id={newsID-1}">{newsTitle-1}</a>
<a href="/index.php?url=news&id={newsID-2}">{newsTitle-2}</a>
<a href="/index.php?url=news&id={newsID-3}">{newsTitle-3}</a>

do i copy the first line or the 3 line? and where do i put?
 

You mean something like this ?

<?php
$to5 = mysql_query("SELECT * FROM cms_news ORDER BY ID DESC LIMIT 50") or die(mysql_error());
?>

doesnt work, idk whr to place, i place in my news.php but it doesn't help.

 

[Marcel]

I can do it for you through team viewer and give you the correct codes.

 

[FunzyKiller]

Ah okay thanks, but I'm in school now when I get home I'll pm u for the team viewer.

 

[Marcel]

Ah okay thanks, but I'm in school now when I get home I'll pm u for the team viewer.

Cool.

 

[Wickd]

I didn't read the thread but i'm guessing you want to change that "0" thing, right?
Run this query.

ALTER TABLE cms_news MODIFY author VARCHAR(25) NOT NULL;

 

[FunzyKiller]

I didn't read the thread but i'm guessing you want to change that "0" thing, right?
Run this query.

ALTER TABLE cms_news MODIFY author VARCHAR(25) NOT NULL;

yes i fixed it. thank you. but having trouble when thrs no picture on the articles on me.php. not sure how do i change the pathway for images.

 

[Wickd]

yes i fixed it. thank you. but having trouble when thrs no picture on the articles on me.php. not sure how do i change the pathway for images.

Well depends where're your images located. Make sure you got the right directory (example ; r63/c_images/top_story)

 

[FunzyKiller]

Well depends where're your images located. Make sure you got the right directory (example ; r63/c_images/top_story)

thrs 2 path located, 1 is from the db and 1 is from the hk posting news. so i not sure about it

 

[Wickd]

thrs 2 path located, 1 is from the db and 1 is from the hk posting news. so i not sure about it

Doesn't matter there should be only one path depending on where your images are located.

 

[FunzyKiller]

Doesn't matter there should be only one path depending on where your images are located.

i tried change the path for the hk news. to the exact one but it doesn't show the picture. ill try again.

 

[JayC]

Inspect element, see where the path is. Change it til the image appears, copy that and put that as the image path.

 

[FunzyKiller]

ah yes thank you, i inspect element but idk whr do i change the path, a very ty.
 

Inspect element, see where the path is. Change it til the image appears, copy that and put that as the image path.

problems solves, thankyou but i'm still having trouble that the articles will direct me to the latest page.

 

[flyest]

You will find the code in the promo box div in me.php and community.php.


Sent from my iPhone using Tapatalk