RawSnippets/public.php at main · rawsta/RawSnippets · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
<?php

	session_start();

	include 'database/connect.php';
	include 'langCheck.php';

	$id = $_GET['id'];

	$query = $con->prepare("SELECT public FROM snippets WHERE id = ?");
	$query->bind_param("s", $id);
	$query->execute();
	$query->bind_result($public);
	$query->fetch();
	$query->close();

	if($public === 1 && isset($_GET['id']) && is_numeric($id)){
		$query = $con->prepare("SELECT snippet FROM snippets WHERE id = ?");
		$query->bind_param("s", $id);
		$query->execute();
		$query->bind_result($code);
		$query->fetch();
		$query->close();

		$code = htmlentities($code);

		$query = $con->prepare("SELECT title, description, date FROM snippets WHERE id = ?");
		$query->bind_param("s", $id);
		$query->execute();
		$query->bind_result($title, $description, $date);
		$query->fetch();
		$query->close();

		$query = $con->prepare("SELECT tags FROM tags_snippets WHERE snippets_id = ?");
		$query->bind_param("s", $id);
		$query->execute();
		$query->bind_result($tag);
		while($query->fetch()){
			$temp[] = "#".$tag;
		}
		$query->close();
		$tagsList = implode(", ", $temp);
?>
<!DOCTYPE html>
<html lang="<?php if(isset($_SESSION['lang'])) { echo $_SESSION['lang']; } else { echo "en"; }?>">
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width,initial-scale=1">
	<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

	<title><?php echo $lang['pageTitle']; ?> - <?php echo $title; ?></title>

    <link rel="stylesheet" href="assets/css/fonts.css">
    <link rel="stylesheet" href="assets/css/public.css">

    <script src="lib/jquery/jquery-3.6.0.min.js"></script>
    <script src="lib/prism/prism.js"></script>
</head>
<body>

	<main class="window">
		<div class="title-area">
			<a href="index.php"><h2 title="<?php echo $lang['goHome']; ?>" class="appTitle"><?php echo $lang['pageTitle']; ?></h2></a>
		</div>

		<div class="details-window-top">
			<h3 id="detail-title"><?php echo $title; ?></h3>
			<span id="date-label"> - <?php echo $lang['created']; ?> (<?php echo $date; ?>) </span>
		</div>
		<div class="details-window-under">
			<span><?php echo $lang['description']; ?>:</span><br>
			<span id="detail-desc"><?php echo $description; ?></span><br><br>
			<span id="detail-tags"><?php echo $tagsList; ?></span>
		</div>

		<pre class="pre-code <?=$linenumbers?> language-<?=$date; ?> rainbow-braces">
			<code id="code-block" class="language-<?=$date; ?>">
				<?=$code?>
			</code>
		</pre>
	</main>

</body>
</html>
<?php }else{ ?>
<!DOCTYPE html>
<html lang="<?php if(isset($_SESSION['lang'])) { echo $_SESSION['lang']; } else { echo "en"; }?>">
<head>
    <meta name="viewport" content="width=device-width,initial-scale=1">
	<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta charset="utf-8">

	<title><?php echo $lang['pageTitle']; ?> - <?php echo $lang['notFound']; ?></title>

    <link rel="stylesheet" href="assets/css/fonts.css">
    <link rel="stylesheet" href="assets/css/public.css">

    <script src="lib/jquery/jquery-3.6.0.min.js"></script>
    <script src="lib/prism/prism.js"></script>
</head>
<body>
	<div class="wrap">
		<a href="index.php"><h2 class="main-label"><?php echo $lang['pageTitle']; ?></h2></a>
		<p id="message"><?php echo $lang['snippetNotFound']; ?></p>
	</div>

</body>
</html>
<?php } ?>