есть модуль kino-mod-dle вот инструкция по установке
выполнил все действия кроме этого
не могу понять как должен выглядеть запрос
если можно напишите запрос который надо просто вставить в phpMyAdmin/SQL
| Код |
|---|
Делаем запрос...
ALTER TABLE `dle_post` ADD `year` VARCHAR( 5 ) NOT NULL ,
ADD `quality` VARCHAR( 225 ) NOT NULL ,
ADD `director` TEXT NOT NULL ,
ADD `actors` TEXT NOT NULL ;
1 engine/inc/adnews.php
после
<div class="hr_line"></div>
<table width="100%">
добавить
<tr>
<td height="29" style="padding-left:5px;">Год:</td>
<td><input class="edit" type="text" size="55" name="year" id="year"></td>
</tr>
<tr>
<td height="29" style="padding-left:5px;">Режиссер:</td>
<td><input class="edit" type="text" size="55" name="director" id="director"></td>
</tr>
<tr>
<td height="29" style="padding-left:5px;">В ролях:</td>
<td><textarea rows="5" style="width:600px;" name="actors"></textarea></td>
</tr>
<tr>
<td height="29" style="padding-left:5px;">Качество:</td>
<td><input class="edit" type="text" size="55" name="quality" id="quality"></td>
</tr>
после
else $alt_name = totranslit( stripslashes( $alt_name ), true, false );
добавить
$year = $_POST['year'];
$quality = $_POST['quality'];
$director = $_POST['director'];
$directorlist = explode(",", $director);
$director = '';
$ndirector = count($directorlist);
foreach($directorlist as $key=>$value)
{
$director .= trim($value);
if ($key < $ndirector-1)
$director .= "|";
}
$actors = $_POST['actors'];
$actorslist = explode(",", $actors);
$actors = '';
$nactors = count($actorslist);
foreach($actorslist as $key=>$value)
{
$actors .= trim($value);
if ($key < $nactors-1)
$actors .= "|";
}
заменить запрос
$db->query( "INSERT INTO " . PREFIX . "_post (date, ...
на
$db->query( "INSERT INTO " . PREFIX . "_post (date, autor, short_story, full_story, xfields, title, descr, keywords, category, alt_name, allow_comm, approve, allow_main, fixed, allow_rate, allow_br, votes, access, symbol, flag, tags, metatitle, year, quality, director, actors) values ('$thistime', '{$member_id['name']}', '$short_story', '$full_story', '$filecontents', '$title', '{$metatags['description']}', '{$metatags['keywords']}', '$category_list', '$alt_name', '$allow_comm', '$approve', '$allow_main', '$news_fixed', '$allow_rating', '$allow_br', '$add_vote', '$group_regel', '$catalog_url', '1', '{$_POST['tags']}', '{$metatags['title']}', '$year', '$quality', '$director', '$actors')" );
2. engenengine/inc/editnews.php
после
$row['metatitle'] = stripslashes( $row['metatitle'] );
добавить
$director = str_replace("|", ", ", $row['director']);
$actors = str_replace("|", ", ", $row['actors']);
после
<div class="hr_line"></div>
<table width="100%">
добавить
<tr>
<td height="29" style="padding-left:5px;">Год:</td>
<td><input class="edit" type="text" size="55" name="year" id="year" value="{$row['year']}"></td>
</tr>
<tr>
<td height="29" style="padding-left:5px;">Качество:</td>
<td><input class="edit" type="text" size="55" name="quality" id="quality" value="{$row['quality']}"></td>
</tr>
<tr>
<td height="29" style="padding-left:5px;">Режиссер:</td>
<td><input class="edit" type="text" size="55" name="director" id="director" value="{$director}"></td>
</tr>
<tr>
<td height="29" style="padding-left:5px;">В ролях:</td>
<td><textarea rows="5" style="width:600px;" name="actors">{$actors}</textarea></td>
</tr>
после
else {
$full_story = $db->safesql( $parse->BB_Parse( $full_story, false ) );
$short_story = $db->safesql( $parse->BB_Parse( $short_story, false ) );
}
добавить
$year = $_POST['year'];
$quality = $_POST['quality'];
$director = $_POST['director'];
$directorlist = explode(",", $director);
$director = '';
$ndirector = count($directorlist);
foreach($directorlist as $key=>$value)
{
$director .= trim($value);
if ($key < $ndirector-1)
$director .= "|";
}
$actors = $_POST['actors'];
$actorslist = explode(",", $actors);
$actors = '';
$nactors = count($actorslist);
foreach($actorslist as $key=>$value)
{
$actors .= trim($value);
if ($key < $nactors-1)
$actors .= "|";
}
заменить
$result = $db->query( "UPDATE " . PREFIX . "_post set title='$title', date='$thistime', short_story='$short_story', full_story='$full_story', descr='{$metatags['description']}', keywords='{$metatags['keywords']}', category='$category_list', alt_name='$alt_name', allow_comm='$allow_comm', approve='$approve', allow_main='$allow_main', allow_rate='$allow_rating', fixed='$news_fixed', allow_br='$allow_br', votes='$add_vote', access='$group_regel', symbol='$catalog_url', flag='1', editdate='$added_time', editor='{$member_id['name']}', reason='$editreason', view_edit='$view_edit', tags='{$_POST['tags']}', metatitle='{$metatags['title']}' WHERE id='$item_db[0]'" );
} else {
$result = $db->query( "UPDATE " . PREFIX . "_post set title='$title', short_story='$short_story', full_story='$full_story', descr='{$metatags['description']}', keywords='{$metatags['keywords']}', category='$category_list', alt_name='$alt_name', allow_comm='$allow_comm', approve='$approve', allow_main='$allow_main', allow_rate='$allow_rating', fixed='$news_fixed', allow_br='$allow_br', votes='$add_vote', access='$group_regel', symbol='$catalog_url', editdate='$added_time', editor='{$member_id['name']}', reason='$editreason', view_edit='$view_edit', tags='{$_POST['tags']}', metatitle='{$metatags['title']}' WHERE id='$item_db[0]'" );
}
на
$result = $db->query( "UPDATE " . PREFIX . "_post set title='$title', year='$year', quality='$quality', director='$director', actors='$actors', date='$thistime', short_story='$short_story', full_story='$full_story', descr='{$metatags['description']}', keywords='{$metatags['keywords']}', category='$category_list', alt_name='$alt_name', allow_comm='$allow_comm', approve='$approve', allow_main='$allow_main', allow_rate='$allow_rating', fixed='$news_fixed', allow_br='$allow_br', votes='$add_vote', access='$group_regel', symbol='$catalog_url', flag='1', editdate='$added_time', editor='{$member_id['name']}', reason='$editreason', view_edit='$view_edit', tags='{$_POST['tags']}', metatitle='{$metatags['title']}' WHERE id='$item_db[0]'" );
} else {
$result = $db->query( "UPDATE " . PREFIX . "_post set title='$title', year='$year', quality='$quality', director='$director', actors='$actors', short_story='$short_story', full_story='$full_story', descr='{$metatags['description']}', keywords='{$metatags['keywords']}', category='$category_list', alt_name='$alt_name', allow_comm='$allow_comm', approve='$approve', allow_main='$allow_main', allow_rate='$allow_rating', fixed='$news_fixed', allow_br='$allow_br', votes='$add_vote', access='$group_regel', symbol='$catalog_url', editdate='$added_time', editor='{$member_id['name']}', reason='$editreason', view_edit='$view_edit', tags='{$_POST['tags']}', metatitle='{$metatags['title']}' WHERE id='$item_db[0]'" );
}
3. engine/modules/show.short.php
после
$tpl->set( '{approve}', "" );
добавить
$directorsList = explode('|',$row['director']);
$directors = '';
$cntDirectors = count($directorsList);
$ai = 0;
foreach ($directorsList as $director)
{
$ai++;
$director = trim($director);
$directors .= '<a style="text-decoration: underline;" href="/index.php?do=directors&director='.str_replace(' ','_',$director).'" title="'.$director.'">'.$director.'</a>';
if ($ai<$cntDirectors) $directors .= ', ';
}
unset($directorsList);
if (!empty($row['director'])) {
$directorall= $directors;
}
$tpl->set( '{directorall}', $directorall);
$actorsList = explode('|',$row['actors']);
$actors = '';
$cntActors = count($actorsList);
$ai = 0;
foreach ($actorsList as $actor)
{
$ai++;
$actor = trim($actor);
$actors .= '<a style="text-decoration: underline;" href="/index.php?do=actors&actor='.str_replace(' ','_',$actor).'" title="'.$actor.'">'.$actor.'</a>';
if ($ai<$cntActors) $actors .= ', ';
}
unset($actorsList);
if (!empty($row['actors'])) {
$actorall= $actors;
}
$tpl->set( '{actorall}', $actorall);
$year1 = $row['year'];
$tpl->set( '{year}', $year1!='' ? '<a style="text-decoration: underline;" href="/index.php?do=year&year='.str_replace(' ','_',$year1).'" title="'.$year1.'">'.$year1.'</a>' : '');
$quality = $row['quality'];
$tpl->set( '{quality}', $year1!='' ? '<a style="text-decoration: underline;" href="/index.php?do=quality&quality='.str_replace(' ','_',$quality).'" title="'.$quality.'">'.$quality.'</a>>' : '');
4. engine/modules/show.full.php
тоже самое что и в 3-м пенкте после
$tpl->set( '{category-icon}', "{THEME}/dleimages/no_icon.gif" );
}
5. engine/engine.php
engine.php заменить
6. шаблон/shortstory.tpl и fullstory.tpl
в нужное место вставить
{year}
{directorall}
{actorall}
{quality}
7 шаблон/addnews.html
в нужно место добавить
<tr>
<td>Год:</td>
<td><input class="edit" type="text" size="55" name="year" id="year"></td>
</tr>
<tr>
<td>Качество:</td>
<td><input class="edit" type="text" size="55" name="quality" id="quality"></td>
</tr>
<tr>
<td>Режиссер:</td>
<td><input class="edit" type="text" size="55" name="director" id="director"></td>
</tr>
<tr>
<td>В ролях:</td>
<td><textarea rows="5" style="width:600px;" name="actors"></textarea></td>
</tr>
8. engine/modules/addnews.php
после
$alt_name = trim( $parse->process( stripslashes( $_POST['alt_name'] ) ) );
добавить
$year = $_POST['year'];
$quality = $_POST['quality'];
$director = $_POST['director'];
$directorlist = explode(",", $director);
$director = '';
$ndirector = count($directorlist);
foreach($directorlist as $key=>$value)
{
$director .= trim($value);
if ($key < $ndirector-1)
$director .= "|";
}
$actors = $_POST['actors'];
$actorslist = explode(",", $actors);
$actors = '';
$nactors = count($actorslist);
foreach($actorslist as $key=>$value)
{
$actors .= trim($value);
if ($key < $nactors-1)
$actors .= "|";
}
заменить
$db->query( "UPDATE " . PREFIX . "_post set title='$title', short_story='$short_story', full_story='$full_story', xfields='$filecontents', category='$category_list', alt_name='$alt_name', allow_comm='$allow_comm', approve='$approve', allow_main='$allow_main', allow_rate='$allow_rating', fixed='$news_fixed', allow_br='$allow_br', flag='1', tags='" . $_POST['tags'] . "' WHERE id='$id'" );
на
$db->query( "UPDATE " . PREFIX . "_post set title='$title', year='$year', quality='$quality', director='$director', actors='$actors', short_story='$short_story', full_story='$full_story', xfields='$filecontents', category='$category_list', alt_name='$alt_name', allow_comm='$allow_comm', approve='$approve', allow_main='$allow_main', allow_rate='$allow_rating', fixed='$news_fixed', allow_br='$allow_br', flag='1', tags='" . $_POST['tags'] . "' WHERE id='$id'" );
заменить
$db->query( "INSERT INTO " . PREFIX . "_post (date, autor, short_story, full_story, xfields, title, keywords, category, alt_name, allow_comm, approve, allow_main, fixed, allow_rate, allow_br, flag, tags) values ('$thistime', '$member_id[name]', '$short_story', '$full_story', '$filecontents', '$title', '', '$category_list', '$alt_name', '$allow_comm', '$approve', '$allow_main', '$news_fixed', '$allow_rating', '$allow_br', '1', '" . $_POST['tags'] . "')" );
на
$db->query( "INSERT INTO " . PREFIX . "_post (date, autor, short_story, full_story, xfields, title, year, quality, director, actors, keywords, category, alt_name, allow_comm, approve, allow_main, fixed, allow_rate, allow_br, flag, tags) values ('$thistime', '$member_id[name]', '$short_story', '$full_story', '$filecontents', '$title', '$year', '$quality','$director', '$actors', '', '$category_list', '$alt_name', '$allow_comm', '$approve', '$allow_main', '$news_fixed', '$allow_rating', '$allow_br', '1', '" . $_POST['tags'] . "')" );
|
| Код |
|---|
заменить запрос
$db->query( "INSERT INTO " . PREFIX . "_post (date, ...
на
$db->query( "INSERT INTO " . PREFIX . "_post (date, autor, short_story, full_story, xfields, title, descr, keywords, category, alt_name, allow_comm, approve, allow_main, fixed, allow_rate, allow_br, votes, access, symbol, flag, tags, metatitle, year, quality, director, actors) values ('$thistime', '{$member_id['name']}', '$short_story', '$full_story', '$filecontents', '$title', '{$metatags['description']}', '{$metatags['keywords']}', '$category_list', '$alt_name', '$allow_comm', '$approve', '$allow_main', '$news_fixed', '$allow_rating', '$allow_br', '$add_vote', '$group_regel', '$catalog_url', '1', '{$_POST['tags']}', '{$metatags['title']}', '$year', '$quality', '$director', '$actors')" );
|
если можно напишите запрос который надо просто вставить в phpMyAdmin/SQL
