XoopsModules25x / xoopstube

            $sql = 'INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('xoopstube_videos')

                   . '  (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 = $GLOBALS['xoopsDB']->query($sql)) {

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

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

            }

            $newid = $GLOBALS['xoopsDB']->getInsertId();

            // Add item_tag to Tag-module

                $sql     = 'UPDATE ' . $GLOBALS['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 = $GLOBALS['xoopsDB']->query($sql)) {

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

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

                }

                $notificationHandler   = xoops_getHandler('notification');

                $tags                  = array();

                    $sql = 'INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('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 = $GLOBALS['xoopsDB']->query($sql)) {

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

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

                    }

                } else {

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

                }