XoopsModules25x / xoopstube

                )

                . '	(lid, cid, title, vidid, submitter, publisher, status, date, hits, rating, votes, comments, vidsource, published, expired, offline, description, ipaddress, notifypub, vidrating, time, keywords, item_tag, picurl) ';

            $sql .= " VALUES 	('', $cid, '$title', '$vidid', '$submitter', '$publisher', '$status', '$date', 0, 0, 0, 0, '$vidsource', '$publishdate', 0, '$offline', '$descriptionb', '$ipaddress', '$notifypub', '$vidrating', '$time', '$keywords', '$item_tag', '$picurl')";

            if (!$result = $xoopsDB->query($sql)) {

                $_error = $xoopsDB->error() . ' : ' . $xoopsDB->errno();

                XoopsErrorHandler_HandleError(E_USER_WARNING, $_error, __FILE__, __LINE__);

            }

            $newid = mysql_insert_id();

// Add item_tag to Tag-module

                $updated = time();

                $sql     = "UPDATE " . $xoopsDB->prefix('xoopstube_videos') . " SET cid=$cid, title='$title', vidid='$vidid', publisher='$publisher', updated='$updated', offline='$offline', description='$descriptionb', ipaddress='$ipaddress', notifypub='$notifypub', vidrating='$vidrating', time='$time', keywords='$keywords', item_tag='$item_tag', picurl='$picurl' WHERE lid ="

                    . $lid;

                if (!$result = $xoopsDB->query($sql)) {

                    $_error = $xoopsDB->error() . " : " . $xoopsDB->errno();

                    XoopsErrorHandler_HandleError(E_USER_WARNING, $_error, __FILE__, __LINE__);

                }

                $notification_handler = & xoops_gethandler('notification');

                $tags                 = array();

                            'xoopstube_mod'

                        ) . ' (requestid, lid, cid, title, vidid, publisher, vidsource, description, modifysubmitter, requestdate, time, keywords, item_tag, picurl)';

                    $sql .= " VALUES ('', $lid, $cid, '$title', '$vidid', '$publisher', '$vidsource', '$descriptionb', '$modifysubmitter', '$requestdate', '$time', '$keywords', '$item_tag', '$picurl')";

                    if (!$result = $xoopsDB->query($sql)) {

                        $_error = $xoopsDB->error() . " : " . $xoopsDB->errno();

                        XoopsErrorHandler_HandleError(E_USER_WARNING, $_error, __FILE__, __LINE__);

                    }

                } else {

                    redirect_header('index.php', 2, _MD_XOOPSTUBE_MODIFYNOTALLOWED);

                }