Particle Soft » Jump to Bottom
 

Knowledge Base
Quickly solve problems and get answers to frequently asked questions...

Article #11

Question:
I am unable to approve links with ' in the title or description

Answer:
This is a problem with the wrong function being called. It was fixed in all version after 1.1.0 so either upgrade or open includes/functions_submissions.php and find:

// site has been accepted
$sql = "INSERT INTO " . $dbprefix . "links (topicid, postdate, website, description, url) VALUES (";
$sql .= dbSecure($rec->fields["topicid"]) . ", ";
$sql .= time() . ", ";
$sql .= "'" . dbSecure($rec->fields["website"]) . "', ";
$sql .= "'" . dbSecure($rec->fields["description"]) . "', ";
$sql .= "'" . dbSecure($rec->fields["url"]) . "')";
$db->execute($sql);

Replace with:

// site has been accepted
$sql = "INSERT INTO " . $dbprefix . "links (topicid, postdate, website, description, url) VALUES (";
$sql .= addslashes($rec->fields["topicid"]) . ", ";
$sql .= time() . ", ";
$sql .= "'" . addslashes($rec->fields["website"]) . "', ";
$sql .= "'" . addslashes($rec->fields["description"]) . "', ";
$sql .= "'" . addslashes($rec->fields["url"]) . "')";
$db->execute($sql);

Software:
Particle Links

Versions:
1.1.0


Particle Links
I get a "Not implemented" JavaScript error
The end of very long my phrases get cut off.
When I make a phrase multi-line the text in the header just says T
I am unable to approve links with ' in the title or description
Emails sent are missing the decision
When I edit a topic, it is set as having no parent
The edit website link under manage links doesn't work

Valid XHTML 1.0! Valid CSS!

Particle Soft   » Jump to Top