コード例 #1
0
ファイル: showsub.php プロジェクト: Raak15/subtitols
        }
        echo $clangState;
        ?>
</td>
					<td>
						<?php 
        if ($clangEdited > 0) {
            echo "{$wikilang_edited} " . obtenerFecha(bd_getLastTimeEdited($myID, $v, $clangID));
        }
        ?>
    </td>
  </tr>
 <?php 
        $query = "select count(*) from lasttranslated where subID={$myID} and fversion={$v} and lang_id={$clangID}";
        $cresult = mysql_query($query);
        if (mysql_result($cresult, 0) > 0 && !bd_isMerged($myID, $fversion, $clangID)) {
            ?>
  <tr>
    <td>lel&nbsp;</td>
    <td><span class="newsDate">
    <?php 
            echo $wikilang_translated_by;
            ?>
    </span></td>
    <td colspan="5" class="newsDate">
<?php 
            $query = "select distinct(authorID) from subs where subID={$myID} and fversion={$v} and lang_id={$clangID}";
            $result = mysql_query($query);
            while ($urow = mysql_fetch_assoc($result)) {
                echo '<a href="/user/' . $urow['authorID'] . '" >';
                echo bd_getUsername($urow['authorID']);
コード例 #2
0
ファイル: antitroll_do.php プロジェクト: Raak15/subtitols
while ($numresults > 0) {
    $query = "select entryID,edited_seq,version from subs where subID={$id} and fversion={$fversion} and lang_id={$lang} and authorID={$author} and last=1";
    $result = mysql_query($query);
    $numresults = mysql_affected_rows();
    while ($row = mysql_fetch_assoc($result)) {
        $entry = $row['entryID'];
        $seq = $row['edited_seq'];
        $version = $row['version'];
        if (!$notoriginal) {
            $query = "delete from subs where entryID={$entry}";
            mysql_query($query);
        }
        if ($version > 0) {
            if ($notoriginal) {
                $query = "delete from subs where entryID={$entry}";
                mysql_query($query);
            }
            $minver = $version - 1;
            $query = "update subs set last=1 where subID={$id} and fversion={$fversion} and lang_id={$lang} and edited_seq={$seq} and version={$minver}";
            mysql_query($query);
        }
    }
}
if (bd_getOriginalLang($id, $fversion) != $lang && !bd_isMerged($id, $fversion, $lang)) {
    tn_check($id, $fversion, bd_getOriginalLang($id, $fversion), $lang);
    bd_confirmTranslated($id, $fversion, $lang);
}
$authorName = bd_getUsername($authorName);
log_insert(LOG_troll, "User {$authorname}", $_SESSION['userID'], $id, bd_userIsModerador());
location("/antitroll.php?id={$id}&fversion={$fversion}&lang={$lang}");
bbdd_close();