Changeset 295


Ignore:
Timestamp:
Feb 7, 2008, 5:27:54 PM (18 years ago)
Author:
maron
Message:

Client texty - zatím bez zobrazení na webu, oprava logu, oprava shoutboxu, ukládání webů, na kterých je banner

Location:
quests
Files:
75 added
12 edited

Legend:

Unmodified
Added
Removed

  • quests/ListQuests.php

    r250 r295  
    144144        <a Title="Pøelo¾ené questy, mù¾ete zde hlasovat, nebo opravovat Quest" href="ListQuests.php?Translate">Pøelo¾ené questy</a><br><br>';
    145145     
    146         WritePages('ListQuests.php?Translate', "WHERE quests.Language = '1' AND quests.Complete = '1'");
     146        WritePages('ListQuests.php?Translate', "WHERE quests.Language <> 0 AND quests.Complete = '1'");
    147147       
    148148        WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User FROM
    149         quests WHERE quests.Language = '1' AND quests.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate');
     149        quests WHERE quests.Language <> 0 AND quests.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate');
    150150      }
    151151     

  • quests/TODO.txt

    r263 r295  
    2626 - search možno order by                        hotovo
    2727 - npc_text                                     hotovo
     28 - odkaz na questy v formuláøi se stejnám entry     horovo
     29 - quest je nepøeložen ve statistice ve formu       hotovo
     30 - pokyny hlasování                             hotovo
    2831 - Rozdìlení pomocí ras
    2932 - menší známka za nedokonèený quest           
    … …  
    3336 - jiné texty než questy - hlavní texty
    3437( page_text, - prioritnì  quest_end_scripts, quest_start_scripts)
    35  - pokyny hlasování                             hotovo
    36  - odkaz na questy v formuláøi se stejnám entry     horovo
    37  - quest je nepøeložen ve statistice ve formu       hotovo
    38  - vyzkoušet hlasování, podmínka user           jebu na to
     38 

  • quests/action.php

    r263 r295  
    2121    if ($shoutbox == '') {
    2222      echo '<form action="action.php?shoutbox=1" method="post">
    23       Uµivatel: ';
     23      U¾ivatel: ';
    2424      if (Licence(0)) echo '<b>'.$_SESSION['User'].'</b><br />'; else  echo '<input type="text" name="user"><br />';
    2525            echo 'Text zprávy: <input type="text" name="text" size="50">
    26             <input type="submit" value="Uloµit"><br />
     26            <input type="submit" value="Ulo¾it"><br />
    2727            </form>';
    2828    } else {
    … …  
    3030        $user = $_POST['user'];
    3131        $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user WHERE user = '$user'"));
    32         if ((!$Line) or ($user == '')) {} else die('Toto jméno je registrováno nemùµete psát za nìj. Pokud jste '.$user.' pak se pøihlaste.');
     32        if ((!$Line) or ($user == '')) {} else die('Toto jméno je registrováno nemù¾ete psát za nìj. Pokud jste '.$user.' pak se pøihlaste.');
    3333      }
    3434      $text = $_POST['text'];
    3535      $Database->SQLCommand("INSERT INTO `shoutbox` ( `user` , `text` , `date` , `IP` )
    3636      VALUES ( '$user', '$text', now(), '".$_SERVER['REMOTE_ADDR']."');");
    37       echo 'Zpráva vloµena!';   
     37      echo 'Zpráva vlo¾ena!<br>Budete pøesmìrováni...';   
     38            echo '
     39        <script type="text/javascript" language="JavaScript" charset="iso-8859-2">
     40            setTimeout("parent.location.href=\'index.php\'",1000)
     41        </script>';
     42
    3843    }
    3944  }

  • quests/includes/global.php

    r286 r295  
    128128        }   
    129129        echo '&nbsp;<a Title="Sestavit speciální fitr" href="page_list.php?filter">Filtr page_text ...</a><br>';
    130       echo '</div>
    131      
    132      
    133       <br />';
     130      echo '</div>';
     131
     132      //client rolovací menu 
     133  /*    echo '<div id="client_menu1" style="background-color: #ffff66;  margin: 5px 0px 0px 0px;" onMouseMove="show(client_menu)" onmouseout="hide(client_menu)">
     134      <a href="client_list.php?filter">client_texty</a></div>       
     135       
     136       <div id="client_menu" onMouseMove="show(client_menu)" onmouseout="hide(client_menu)" style="display: none; background-color: #ffffcc;">
     137        &nbsp;<a Title="Zde mù¾ete zaèít pøekládat client_texty" href="client_list.php?notran">Nepøelo¾ené client_text</a><br>
     138        &nbsp;<a Title="Ve¹keré pøelo¾ené client_texty" href="client_list.php?Translate">Pøelo¾ené client_text</a><br>
     139        ';
     140        if  (Licence(0)) {
     141          echo '&nbsp;<a Title="Nedokonèené client_texty" href="client_list.php?mydevelop">Rozepsané client_text</a><br>
     142          &nbsp;<a Title="V¹echny client_texty, které bych mìl je¹tì oznámkovat" href="client_list.php?my">Moje client_text</a><br>
     143          &nbsp;<a Title="client_texty, které jsem je¹tì neoznámkoval" href="client_list.php?notvote">Neznámkované client</a><br>';
     144        }   
     145        echo '&nbsp;<a Title="Sestavit speciální fitr" href="client_list.php?filter">Filtr client_text ...</a><br>';
     146      echo '</div>';
     147     
     148   */   
     149     
     150     echo '<br />';
    134151   
    135152  /*    echo '<a Title="Pøelo¾ené quest, mù¾ete zde hlasovat, nebo opravovat Quest" href="ListQuests.php?Translate">Pøelo¾ené questy</a><br />';
    … …  
    145162        echo '<a href="priorite.php" Title="Naètení priority questù (Admin only)">Priorita</a><br />';
    146163        echo '<a href="log.php" Title="Log dìní (Admin only)">Log</a><br>';
    147         echo '<a href="https://wow.zdechov.net/mysql/">Database</a><br>';
     164     //   echo '<a href="client_files/generate_SQL.php" Title="Generování clientských souborù (Admin only)">Generování C.S.</a><br>';
     165        echo '<a href="https://wow.zdechov.net/mysql/" Title="PHP my admin (Admin only)">Database</a><br>';
    148166        echo '<br>';
    149167      }
    … …  
    191209    $ID = $Database->SQLCommand("SELECT * FROM shoutbox ORDER BY ID DESC LIMIT 10");
    192210      while ($Line = mysql_fetch_array($ID))
    193         echo '<tr><td><small><b>'.$Line['user'].'</b>: '.$Line['text'].'</small></td></tr>';
     211        echo '<tr><td><span style="font-size: 10"><b>'.$Line['user'].'</b>: '.$Line['text'].'</span></td></tr>';
    194212  echo '</table>
    195213 

  • quests/includes/global_function.php

    r280 r295  
    6464  array('5','Hlasování', 'yellowgreen', 'Pøihlá¹ení u¾ivatelù'),
    6565  array('6','Npc_text', 'tomato', 'Operace s NPC_texty'),
     66  array('7','Page_text', 'aqua', 'Operace s page_texty'),
     67  array('8','Client_text', 'black', 'Operace s clien_texty'),
    6668);
    6769
    … …  
    105107);
    106108
     109$client_files = array(
     110  '0' => 'LocalizationStrings',
     111  '1' => 'SpellBufDescription_1',
     112  '2' => 'SpellDescription_1',
     113  '3' => 'SpellDescription_2',
     114  '4' => 'SpellDescription_3',
     115  '5' => 'SpellDescription_4',
     116  '6' => 'tallent',
     117);
     118$client_text = array(
     119  '0' => 'text',
     120);
     121
    107122?>

  • quests/npc_list.php

    r259 r295  
    120120        <a Title="Pøelo¾ené npc_texty, mù¾ete zde hlasovat, nebo opravovat npc_texty" href="npc_list.php?Translate">Pøelo¾ené npc_texty</a><br><br>';
    121121     
    122         WritePages('npc_list.php?Translate', "WHERE npc_text.Language = '1' AND npc_text.Complete = '1'");
     122        WritePages('npc_list.php?Translate', "WHERE npc_text.Language <> 0 AND npc_text.Complete = '1'");
    123123       
    124124        Write_npc_text("SELECT *, (SELECT user.user FROM user WHERE user.id = npc_text.user) as User FROM
    125         npc_text WHERE npc_text.Language = '1' AND npc_text.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate');
     125        npc_text WHERE npc_text.Language <> 0 AND npc_text.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate');
    126126      }
    127127     

  • quests/npc_save.php

    r263 r295  
    5555      echo 'Zmìny v Npc_textu: '.$entry.' ulo¾eny!<br />';
    5656      WriteLog('Zmìny v npc_textu: '.$entry.' ulo¾eny!
    57       <a href="npc_form.php?ID='.$npc_ID.'">'.$npc_ID.'</a>', 1);
     57      <a href="npc_form.php?ID='.$npc_ID.'">'.$npc_ID.'</a>', 6);
    5858      $Database->SQLCommand("DELETE FROM `npc_vote` WHERE `npc_vote`.`IDnpc` = ".$npc_ID);
    5959    }

  • quests/page_list.php

    r280 r295  
    120120        <a Title="Pøelo¾ené page_texty, mù¾ete zde hlasovat, nebo opravovat page_texty" href="page_list.php?Translate">Pøelo¾ené page_texty</a><br><br>';
    121121     
    122         WritePages('page_list.php?Translate', "WHERE page_text.Language = '1' AND page_text.Complete = '1'");
     122        WritePages('page_list.php?Translate', "WHERE page_text.Language <> 0 AND page_text.Complete = '1'");
    123123       
    124124        Write_page_text("SELECT *, (SELECT user.user FROM user WHERE user.id = page_text.user) as User FROM
    125         page_text WHERE page_text.Language = '1' AND page_text.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate');
     125        page_text WHERE page_text.Language <> 0 AND page_text.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate');
    126126      }
    127127     

  • quests/page_save.php

    r280 r295  
    4444     
    4545      echo 'page_text: '.$entry.' ulo¾en!<br />';
    46       WriteLog('page_text: '.$entry.' ulo¾en! Pøevzat z: <a href="page_form.php?ID='.$page_ID.'">Aj page_text'.$page_ID.'</a>', 6);
     46      WriteLog('page_text: '.$entry.' ulo¾en! Pøevzat z: <a href="page_form.php?ID='.$page_ID.'">Aj page_text'.$page_ID.'</a>', 7);
    4747    } else {
    4848      $sql = "UPDATE page_text SET ";
    … …  
    5555      echo 'Zmìny v page_textu: '.$entry.' ulo¾eny!<br />';
    5656      WriteLog('Zmìny v page_textu: '.$entry.' ulo¾eny!
    57       <a href="page_form.php?ID='.$page_ID.'">'.$page_ID.'</a>', 1);
     57      <a href="page_form.php?ID='.$page_ID.'">'.$page_ID.'</a>', 7);
    5858      $Database->SQLCommand("DELETE FROM `page_vote` WHERE `page_vote`.`IDpage` = ".$page_ID);
    5959    }

  • quests/statistic.php

    r293 r295  
    66
    77<b>Statistika:</b><br>
    8  <img alt="quests" src="img_statistic.php?TypeText=quests" title="statistika pøekladu úkolù" style="margin: 5px 0px 0px 0px;"><br />
    9  <img alt="npc_text" src="img_statistic.php?TypeText=npc_text" title="statistika pøekladu NPC_textù" style="margin: 5px 0px 0px 0px;"><br />
    10  <img alt="page_text" src="img_statistic.php?TypeText=page_text" title="statistika pøekladu page_textù" style="margin: 5px 0px 0px 0px;"><br />
     8 <img alt="quests" src="img_statistic.php?TypeText=quests" title="statistika pøekladu úkolù" style="margin: 2px 0px 0px 0px;"><br />
     9 <img alt="npc_text" src="img_statistic.php?TypeText=npc_text" title="statistika pøekladu NPC_textù" style="margin: 2px 0px 0px 0px;"><br />
     10 <img alt="page_text" src="img_statistic.php?TypeText=page_text" title="statistika pøekladu page_textù" style="margin: 2px 0px 0px 0px;"><br />
     11<?php // <img alt="page_text" src="img_statistic.php?TypeText=client_text" title="statistika pøekladu client_textù" style="margin: 2px 0px 0px 0px;"><br />
     12?>
    1113
    1214<br>
    … …  
    3638
    3739  echo '<tr><th><a href="statistic.php?order=user&amp;desc='.$desc.'">Jméno</a></th>
    38   <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'" Title="Poèet pøelo¾ených questù">Pøelo¾ených</a></th>
    39   <th><a href="statistic.php?order=Vote&amp;desc='.$desc.'" Title="Prùmìrná známka questù">Prùmìrná známka</a></th>
     40  <th><a href="statistic.php?order=NumberTranslate&amp;desc='.$desc.'" Title="Poèet pøelo¾ených textù">Pøelo¾ených</a></th>
     41  <th><a href="statistic.php?order=Vote&amp;desc='.$desc.'" Title="Prùmìrná známka textù">Prùmìrná známka</a></th>
    4042  <th><a href="statistic.php?order=GM&amp;desc='.$desc.'">Oprávnìní</a></th>
    4143  <th><a href="statistic.php?order=LastLogin&amp;desc='.$desc.'">Poslední pøipojení</a></th></tr>';
    … …  
    5759  $ID = $Database->SQLCommand("
    5860  SELECT ID,user, LastLogin, GM, (
    59      (SELECT count(*) FROM `quests` WHERE User = user.ID AND Complete = 1 AND Language <> 0) +
    60      (SELECT count(*) FROM `npc_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0) +
    61      (SELECT count(*) FROM `page_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0)
     61     (SELECT count(*) FROM `quests` WHERE User = user.ID AND Complete = 1 AND Language <> 0)
     62    + (SELECT count(*) FROM `npc_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0)
     63    + (SELECT count(*) FROM `page_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0)
     64    + (SELECT count(*) FROM `client_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0)
    6265   ) as NumberTranslate, (
    6366       IFNULL((SELECT sum(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1 AND Language <> 0),0)
    6467     + IFNULL((SELECT sum(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1 AND Language <> 0),0)
    6568     + IFNULL((SELECT sum(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1 AND Language <> 0),0)
     69     + IFNULL((SELECT sum(Vote) AS Vote FROM `client_text` WHERE User = user.ID AND Complete =1 AND Language <> 0),0)
    6670     ) / (
    6771       (SELECT count(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1 AND Language <> 0)
    6872     + (SELECT count(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1 AND Language <> 0)
    6973     + (SELECT count(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1 AND Language <> 0)
     74     + (SELECT count(Vote) AS Vote FROM `client_text` WHERE User = user.ID AND Complete =1 AND Language <> 0)
    7075     ) AS Vote
    7176   FROM `user` ORDER BY $order $desc");

  • quests/structure/npc_vote.sql

    r251 r295  
    1010  PRIMARY KEY  (`ID`),
    1111  KEY `IDuser` (`IDuser`),
    12   KEY `IDquest` (`IDnpc`)
     12  KEY `IDnpc` (`IDnpc`)
    1313) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=85 ;
    1414

  • quests/structure/page_vote.sql

    r280 r295  
    1111  PRIMARY KEY  (`ID`),
    1212  KEY `IDuser` (`IDpage`),
    13   KEY `IDquest` (`IDpage`)
     13  KEY `IDpage` (`IDpage`)
    1414) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=88 ;
Note: See TracChangeset for help on using the changeset viewer.