source: action.php@ 36

Last change on this file since 36 was 36, checked in by maron, 17 years ago

Vkládání do shoutboxu pouze pro registrované

File size: 5.0 KB
Line 
1<?php
2
3 include('includes/global.php');
4
5 if (array_key_exists('delete', $_GET) and Licence(1)) {
6 $QuestID = $_GET['ID'];
7 $Database->SQLCommand("DELETE FROM quests WHERE ID = '$QuestID' AND Language <> '0'");
8 echo 'P�eklad byl smaz�n!';
9 WriteLog('P�eklad smaz�n! <a href="form.php?ID='.$QuestID.'">'.$QuestID.'</a>', 4);
10 }
11
12 if (array_key_exists('type_translation', $_POST) and Licence(1)) {
13 if (array_key_exists('1', $_POST))
14 $check = 1;
15 else $check = 0;
16 $ID_translation = $_POST['ID_translation'];
17 $type_translation = $_POST['type_translation'];
18 $Database->SQLCommand("DELETE FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND ID_translation = $ID_translation AND type_translation = $type_translation");
19 $Database->SQLCommand("INSERT INTO `tag` ( `type_translation` , `ID_translation` , `ID_user` , `tag` )
20 VALUES ('$type_translation', '$ID_translation', '".$_SESSION['UserID']."', '$check')");
21 echo 'P�eklad ozna�en!';
22 if ($type_translation == 1)
23 WriteLog('P�eklad ozna�en: '.$check.' <a href="form.php?ID='.$ID_translation.'">'.$ID_translation.'</a>', 5);
24 if ($type_translation == 2)
25 WriteLog('P�eklad ozna�en: '.$check.' <a href="npc_form.php?ID='.$ID_translation.'">'.$ID_translation.'</a>', 5);
26 if ($type_translation == 3)
27 WriteLog('P�eklad ozna�en: '.$check.' <a href="page_form.php?ID='.$ID_translation.'">'.$ID_translation.'</a>', 5);
28 }
29
30 if (array_key_exists('admin_check', $_GET) and Licence(2)) {
31 $ID = $_GET['ID'];
32 $admin_check = $_GET['admin_check'];
33 $entry = mysql_fetch_array($Database->SQLCommand("SELECT entry FROM quests Where ID = $ID"));
34 $Database->SQLCommand("UPDATE quests SET admin_check = '0' WHERE entry = '".$entry['entry']."' AND Language <> '0'");
35 $Database->SQLCommand("UPDATE quests SET admin_check = '$admin_check' WHERE ID = '$ID' AND Language <> '0'");
36 if ($admin_check == 1) {
37 echo 'P�eklad byl zkontrolov�n!';
38 WriteLog('P�eklad byl zkontrolov�n! <a href="form.php?ID='.$ID.'">'.$ID.'</a>', 4);
39 } else {
40 echo 'U p�ekladu bylo zru�eno zkontrolov�n�!';
41 WriteLog('U p�ekladu bylo zru�eno zkontrolov�n�! <a href="form.php?ID='.$ID.'">'.$ID.'</a>', 4);
42 }
43 }
44
45 if (array_key_exists('NotComplete', $_GET) and Licence(1)) {
46 $QuestID = $_GET['ID'];
47 $Database->SQLCommand("UPDATE quests SET Complete = '0' WHERE ID = '$QuestID'");
48 echo 'P�eklad byl vr�cen k oprav�!';
49 WriteLog('P�eklad byl vr�cen k oprav� <a href="form.php?ID='.$QuestID.'">'.$QuestID.'</a>', 4);
50 }
51
52 if (array_key_exists('shoutbox', $_GET)) {
53 $shoutbox = $_GET['shoutbox'];
54 if ($shoutbox == '') {
55 echo '<form action="action.php?shoutbox=1" method="post">
56 U�ivatel: ';
57 if (Licence(0)) echo '<b>'.$_SESSION['User'].'</b><br />'; else echo '<input type="text" name="user"><br />';
58 echo 'Text zpr�vy: <br>
59 <textarea name="text" cols="40"></textarea> <br>
60 <input type="submit" value="Ulo�it"><br />
61 </form>';
62 } else {
63 if (Licence(0)) $user = $_SESSION['User']; else {
64 die('Pro vkladani musite byt registrovani!');
65 }
66 $text = $_POST['text'];
67 $Database->SQLCommand("INSERT INTO `shoutbox` ( `user` , `text` , `date` , `IP` )
68 VALUES ( '$user', '$text', now(), '".$_SERVER['REMOTE_ADDR']."');");
69 echo 'Zpr�va vlo�ena!<br>Budete p�esm�rov�ni...';
70 echo '
71 <script type="text/javascript" language="JavaScript" charset="iso-8859-2">
72 setTimeout("parent.location.href=\'index.php\'",1000)
73 </script>';
74
75 }
76 }
77
78 if (array_key_exists('vote', $_GET)) {
79 $questID = $_GET['ID'];
80 $vote = $_GET['vote'];
81 $IDuser = $_SESSION['UserID'];
82
83 if (($vote > 5) OR ($vote < 1)) die ('�patn� zn�mka');
84
85
86 $Line = mysql_fetch_row($Database->SQLCommand("SELECT * FROM quests_vote WHERE IDuser = '$IDuser' AND IDquest = '$questID'"));
87 if ((!$Line) and (Licence(0))) {
88 $Line = mysql_fetch_array($Database->SQLCommand("SELECT Vote,CountVote FROM quests WHERE ID = '$questID'"));
89 $CountVote = $Line['CountVote']+1;
90 $OldVote = $Line['Vote']*$Line['CountVote'];
91 $NewVote = ($OldVote+$vote)/$CountVote;
92
93 $Database->SQLCommand("UPDATE quests SET Vote = '$NewVote', CountVote = '$CountVote' WHERE ID = '$questID'");
94
95 $Database->SQLCommand("INSERT INTO `quests_vote` ( `IDquest` , `IDuser` , `vote` ) VALUES ( '$questID', '$IDuser', '$vote');");
96 echo 'Hlas byl ulo�en! Hlasoval jste: '.$vote.'<br /> Nyn� je zn�mka p�ekladu '.$NewVote;
97
98 WriteLog('U�ivatel hlasoval: '.$vote.'! Nyn� je zn�mka p�ekladu (<a href="form.php?ID='.$questID.'">'.$questID.'</a>): '.$NewVote, 5);
99 } else echo 'Ji� jste hlasoval nebo nem��ete hlasovat!';
100 }
101
102 ShowFooter();
103?>
104
Note: See TracBrowser for help on using the repository browser.