Optimised Scriptaculous Module with Thickbox

[Relative0]

I would love to know how to fix this also...... I am trying to find where this line of code even resides at....

Thanks,

Brian

[ivytony]

Originally Posted by Relative0

I would love to know how to fix this also...... I am trying to find where this line of code even resides at....

Thanks,

Brian

It's probably in the link.php file. check whether your WHERE clause is empty or not. I had the same problem but solved.

[Relative0]

Originally Posted by ivytony

It's probably in the link.php file. check whether your WHERE clause is empty or not. I had the same problem but solved.

Thanks kindly for the idea, I am guessing that you are right and that I am still doing something wrong. Here is what I have for a few lines of code in store_basic() in the libs/link.php:

if($this->id===0) {
			$sql = "INSERT INTO " . table_links . " (link_author, link_status, $link_type, link_randkey, link_category,  link_date, link_published_date, link_votes, link_karma, link_title, link_content) VALUES ($link_author, '$link_status', '$link_type', $link_randkey, $link_category, FROM_UNIXTIME($link_date), FROM_UNIXTIME($link_published_date),$link_votes, $link_karma)";
			if($this->debug == true){echo '<hr>store_basic:Insert:' . $sql . '<hr>';}
			$db->query($sql);
			$this->id = $db->insert_id;
		} else {
		// update
			$sql = "UPDATE " . table_links . " set `link_reports`=$link_reports, `link_comments`=$link_comments, link_author=$link_author, link_status='$link_status', link_randkey=$link_randkey, link_category=$link_category, link_modified=NULL, link_date=FROM_UNIXTIME($link_date), link_published_date=FROM_UNIXTIME($link_published_date), link_votes=$link_votes, link_karma=$link_karma, link_field1='$link_field1', link_field2='$link_field2' WHERE link_id=$this->id";

			// Brian had originally Added this ,link_field1='$link_field1', link_field2='$link_field2' WHERE link_id=$this->id"  But it is changed bacl now.
			// In place of  WHERE link_id=$this->id";

			if($this->debug == true){echo '<hr>store_basic:Update:' . $sql . '<hr>';}
			$db->query($sql);
		}

The error that I get is such:

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `link_author` = 1 ORDER BY `link_date` DESC LIMIT 1' at line 1 in /home/content/html/Pligg98/libs/db.php on line 233


Any ideas? Thanks much,

Brian

[abraxas]

I've uploaded scriptaculous to the module folder, but I can not install it as it does not show up in the admin/module management
Is this where it should show up?

I can not find instructions on installing the modified scriptaculous.

Thank you.

[xmlham]

I am getting this error upon selecting article or video:

URL is invalid or blocked: (http://)

EDIT: Nevermind - fixed

[xmlham]

Originally Posted by Relative0

Thanks kindly for the idea, I am guessing that you are right and that I am still doing something wrong. Here is what I have for a few lines of code in store_basic() in the libs/link.php:

if($this->id===0) {
			$sql = "INSERT INTO " . table_links . " (link_author, link_status, $link_type, link_randkey, link_category,  link_date, link_published_date, link_votes, link_karma, link_title, link_content) VALUES ($link_author, '$link_status', '$link_type', $link_randkey, $link_category, FROM_UNIXTIME($link_date), FROM_UNIXTIME($link_published_date),$link_votes, $link_karma)";
			if($this->debug == true){echo '<hr>store_basic:Insert:' . $sql . '<hr>';}
			$db->query($sql);
			$this->id = $db->insert_id;
		} else {
		// update
			$sql = "UPDATE " . table_links . " set `link_reports`=$link_reports, `link_comments`=$link_comments, link_author=$link_author, link_status='$link_status', link_randkey=$link_randkey, link_category=$link_category, link_modified=NULL, link_date=FROM_UNIXTIME($link_date), link_published_date=FROM_UNIXTIME($link_published_date), link_votes=$link_votes, link_karma=$link_karma, link_field1='$link_field1', link_field2='$link_field2' WHERE link_id=$this->id";

			// Brian had originally Added this ,link_field1='$link_field1', link_field2='$link_field2' WHERE link_id=$this->id"  But it is changed bacl now.
			// In place of  WHERE link_id=$this->id";

			if($this->debug == true){echo '<hr>store_basic:Update:' . $sql . '<hr>';}
			$db->query($sql);
		}

The error that I get is such:

Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `link_author` = 1 ORDER BY `link_date` DESC LIMIT 1' at line 1 in /home/content/html/Pligg98/libs/db.php on line 233


Any ideas? Thanks much,

Brian

Check on Page 3...Genghis posted a modified link.php file that gets rid of the error

Does anyone have this error:

Fatal error: Call to undefined function: verify_ownership() in /home/xxxx/domains/xxxxx.com/public_html/submit.php on line 220

[Balle]

hey, i'll try this code, it seems to be exactly what i need

[en3r0]

This is a great mod, just having one problem right now though.

Fresh install of latest version of pligg with GarrX9 template. Replaced existing scriptaculous code with that provided in this thread. Uploaded the stuff correctly, and remembered to put the template files in the correct directory.

The problem comes when reaching step 3 of the submission process. After filling out step 2 and clicking the button to move on, the page that should be step 3 is all white with no code in sight.


Any ideas on what could be wrong?

[en3r0]

Any suggestions would be much appreciated!