Issues Posting News and Events

[TAV1702]

Has anyone else encountered a problem posting news and events? I believe we have a coding issue when it comes to magic quotes on a server.

Here is one example. Notice no pictures or urls work properly and notice all the extra added characters?

The Fort Worth ARTCC invites you to play the odds with our combined Casino and Suicide Ops night. Find your way to Eldorado in Shreveport, or Win-a-Star in Oklahoma City! Getting out of DFW will be a real event. Taking off into arriving traffic is somewhat of a feat. Are you up for the challenge?\r\n\r\nPrizes are as follows: (2) Flight1 Title Software (up to $59.95 in value) and (2) Blueprint Scenery (FSX or FS2004, excluding KJFK and KEWR) Prizes will be distributed evenly between OKC/SHV (1 Flight1 prize and 1 Blueprint prize handed out at each airport.)\r\n\r\nSuicide ops will be taking place at DFW.\r\n\r\nCasino Ops rundown:\r\n\r\n1.Prizes will only been awarded to pilots to depart or arrive at a \\\"Casino Airport\\\" (KOKC or KSHV).\r\n\r\n2. Pilots will guess a number between 0-100. They can either choose their own number, or have the ZFW website generate a random one for them.\r\n\r\n3. To be eligible for a prize, pilots will need to fill out an entry form on the ZFW ARTCC website (http://zfwartcc.net/?p=30) For more details, please visit the ZFW website. Ground controllers will do their best to send a private message to each pilot to remind them to submit their entry on the ZFW website.\r\n\r\n4. Winning numbers will be predetermined by ZFW management via a number generator prior to the event and winners will be notified within 24 hours of the conclusion of the event.\r\n\r\n“So, are ya feelin lucky?â€Â\r\n\r\nPilot Preferred Routes:\r\n\r\nIn order to accommodate as much traffic as possible, please try your best to file one of these preferred routes.\r\n\r\nKSHV->KDFW\r\nProps/Jets: GGG.CQY8\r\nPreferred Altitudes: 12k, 14k, 16K, FL180, FL200.\r\n\r\nKDFW->KSHV:\r\nProps:HUBB7.GGG\r\nPreferred Altitudes: 11k, 13k\r\nJets: GARL4.GGG SHV\r\nPreferred Altitudes: 15k, 17k\r\n\r\nKOKC->KDFW\r\nProps/Jets with RNAV capability: MUDDE1.MOOSE.UKW3\r\nProps/Jets: IRW.UKW3\r\nPreferred Altitudes Jets: FL210, FL230, FL250\r\nPreferred Altitudes Props: 17k, FL190,\r\n\r\nKDFW->KOKC\r\nProps: JACKY6.IRW\r\nPreferred Altitudes: 16k, FL180,\r\nJets: TEX3.IRW\r\nPreferred Altitudes: FL200, FL220, FL240\r\n\r\nScenery:\r\nDFW FSX/P3D/FS9: http://www.fsdreamteam.com/products_kdfw.html\r\n\r\nOKC FSX: http://www.fspilotshop.com/taburet-okla ... -2180.html\r\n\r\nLouisiana: http://www.fspilotshop.com/megascenery- ... -4686.html\r\n\r\nDFW Charts: http://airnav.com/airport/KDFW\r\n\r\nOKC Charts: http://airnav.com/airport/KOKC\r\n\r\nSHV Charts: http://airnav.com/airport/KSHV

Nice huh? This is how our news and events post. Any ideas? I would love to fix this issue. Our news and events is pretty much useless as far as posting goes unless we use all plain text.

And my apologies if this has been covered. I searched and found no answers. Thanks for taking a look at this.

[simpilot]

Have you tried adding "addslashes" to the incoming text from the form? I have already added it to the pilotname field in my development version to fix pilot names with apostrophes.

public static function AddNewsItem($subject, $body) {
 $subject = DB::escape($subject);
 $body = DB::escape($body);
 $postedby = Auth::$userinfo->firstname . ' ' . Auth::$userinfo->lastname;

 //added to combat pilot names with apostrophes
 $postedby = addslashes($postedby);

 $sql = 'INSERT INTO ' . TABLE_PREFIX . "news (subject, body, postdate, postedby)
 VALUES ('$subject', '$body', NOW(), '$postedby')";
 $res = DB::query($sql);
 if (DB::errno() != 0) return false;
 return true;
}

maybe try

$body = addslashes($body);

[TAV1702]

Thanks Dave I'll give that a try and see if it helps.