root/trunk/robots/fix_fa_IR.php

Revision 1, 0.9 KB (checked in by anonymous, 7 years ago)

initial import

Line 
1#!/usr/bin/php
2<?
3include('../includes/includes.inc.php');
4include('../includes/config/dntp.inc.php');
5
6$lang = $argv[1];
7$messages = array();
8
9$db=&DB::connect($dsn);
10if (DB::isError($db))
11    error_log($_SERVER['HTTP_HOST'].' | '.__FILE__.' | Connexion SQL impossible : '.$db->getMessage());
12    $db->setFetchMode(DB_FETCHMODE_ASSOC);
13
14    $msgstr_r = $db->query('SELECT * FROM `dntp_msgstr` WHERE `key` = 1 AND `msgstr` = "" AND `lang` LIKE "fa_IR" AND `last` = "y"');
15
16if(DB::isError($msgstr_r))
17    error_log($msgstr_r->getUserInfo());
18    else
19while($message = $msgstr_r->fetchRow())
20{
21    $msgstr = $db->getOne('SELECT msgstr FROM dntp_msgstr WHERE lang="fa_IR" AND id=? AND last="y" AND `key`=0', array($message['id']));
22    $db->query('UPDATE dntp_msgstr SET msgstr=? WHERE id_msgstr=?', array($msgstr, $message['id_msgstr']) );
23    echo "UPDATE dntp_msgstr SET msgstr='$msgstr' WHERE id_msgstr='{$message['id_msgstr']}'\n";
24}
25
26$db->disconnect();
27
28?>
Note: See TracBrowser for help on using the browser.