username wegschrijven bij shoutbox
ik gebruik een shoutbox en nu wil ik dat het username veld niet gebruikt word, maar hij automatisch de username van het hostsysteem gebruikt.
In de database van het host systeem is een tabel [users]en in die tabel staan alle usernames in de kolom login
ik gebruik onderstaande code voor de shoutbox, maar hij schrijft de username niet weg in de database, waardoor deze dus ook niet geprint word in de shoutbox.
Code (php)
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
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
<?php
include "includes/config.php";
include "includes/functions.php";
checkDB();
if(isset($_POST["shoutboxUsername"])) {
$shoutboxUsername = sanitize($_POST["shoutboxUsername"]);
$shoutboxMessage = sanitize($_POST["shoutboxMessage"]);
if(strlen($shoutboxMessage) > $scfg["shoutboxCharacterLimit"]) $shoutboxMessage = substr($shoutboxMessage, 0, $scfg["shoutboxCharacterLimit"]);
if(strlen($shoutboxUsername) > $scfg["shoutboxCharacterLimit"]) $shoutboxUsername = substr($shoutboxUsername, 0, $scfg["shoutboxCharacterLimit"]);
if($shoutboxUsername != "" && $shoutboxMessage != "" && $shoutboxUsername != "Name") {
$sql = "INSERT INTO `".$scfg["databaseTable"]."` (`username`, `message`,`date` ) VALUES ('$login', '$shoutboxMessage', NOW())";
mysql_query($sql);
}
} elseif(isset($_GET["update"])) {
printShouts($scfg["databaseTable"], $scfg["shoutboxLines"], $scfg["shoutboxSeperateLines"]);
} elseif(isset($_GET["view"]) && $_GET["view"] == "all") {
echo "<link rel='stylesheet' type='text/css' href='".$scfg["pathToShoutbox"]."/shoutbox_".$scfg["shoutboxTheme"].".css'></style>";
printShouts($scfg["databaseTable"], 0, $scfg["shoutboxSeperateLines"]);
} else {
?>
<script type='text/javascript' src='<?php echo $scfg["pathToShoutbox"]; ?>/includes/jquery-1.4.1.min.js'></script>
<script type='text/javascript' src='<?php echo $scfg["pathToShoutbox"]; ?>/includes/shoutbox.js'></script>
<script type='text/javascript' src='<?php echo $scfg["pathToShoutbox"]; ?>/includes/jquery-plugin-arte.js'></script>
<link rel='stylesheet' type='text/css' href='<?php echo $scfg["pathToShoutbox"]; ?>/css/shoutbox.css'/>
<?php ?>
<script type="text/javascript">
<!--
//activate arte j-query plugin
$(document).ready(function() {
$.arte({"ajax_url":'<?php echo $scfg["pathToShoutbox"]; ?>/shoutbox.php?update=1', "on_success":updateShoutbox}).start();
});
-->
</script>
<?php ?>
<div id='shoutboxContainer'>
<div id='shoutboxShouts'>
<?php
printShouts($scfg["databaseTable"], $scfg["shoutboxLines"], $scfg["shoutboxSeperateLines"]); ?>
</div>
</div>
<?php } ?>
include "includes/config.php";
include "includes/functions.php";
checkDB();
if(isset($_POST["shoutboxUsername"])) {
$shoutboxUsername = sanitize($_POST["shoutboxUsername"]);
$shoutboxMessage = sanitize($_POST["shoutboxMessage"]);
if(strlen($shoutboxMessage) > $scfg["shoutboxCharacterLimit"]) $shoutboxMessage = substr($shoutboxMessage, 0, $scfg["shoutboxCharacterLimit"]);
if(strlen($shoutboxUsername) > $scfg["shoutboxCharacterLimit"]) $shoutboxUsername = substr($shoutboxUsername, 0, $scfg["shoutboxCharacterLimit"]);
if($shoutboxUsername != "" && $shoutboxMessage != "" && $shoutboxUsername != "Name") {
$sql = "INSERT INTO `".$scfg["databaseTable"]."` (`username`, `message`,`date` ) VALUES ('$login', '$shoutboxMessage', NOW())";
mysql_query($sql);
}
} elseif(isset($_GET["update"])) {
printShouts($scfg["databaseTable"], $scfg["shoutboxLines"], $scfg["shoutboxSeperateLines"]);
} elseif(isset($_GET["view"]) && $_GET["view"] == "all") {
echo "<link rel='stylesheet' type='text/css' href='".$scfg["pathToShoutbox"]."/shoutbox_".$scfg["shoutboxTheme"].".css'></style>";
printShouts($scfg["databaseTable"], 0, $scfg["shoutboxSeperateLines"]);
} else {
?>
<script type='text/javascript' src='<?php echo $scfg["pathToShoutbox"]; ?>/includes/jquery-1.4.1.min.js'></script>
<script type='text/javascript' src='<?php echo $scfg["pathToShoutbox"]; ?>/includes/shoutbox.js'></script>
<script type='text/javascript' src='<?php echo $scfg["pathToShoutbox"]; ?>/includes/jquery-plugin-arte.js'></script>
<link rel='stylesheet' type='text/css' href='<?php echo $scfg["pathToShoutbox"]; ?>/css/shoutbox.css'/>
<?php ?>
<script type="text/javascript">
<!--
//activate arte j-query plugin
$(document).ready(function() {
$.arte({"ajax_url":'<?php echo $scfg["pathToShoutbox"]; ?>/shoutbox.php?update=1', "on_success":updateShoutbox}).start();
});
-->
</script>
<?php ?>
<div id='shoutboxContainer'>
<div id='shoutboxShouts'>
<?php
printShouts($scfg["databaseTable"], $scfg["shoutboxLines"], $scfg["shoutboxSeperateLines"]); ?>
</div>
</div>
<?php } ?>
ik heb in onderstaande regel $login toegevoegd waar oorspronkelijk $Shoutboxusername stond
Code (php)
1
$sql = "INSERT INTO `".$scfg["databaseTable"]."` (`username`, `message`,`date` ) VALUES ('$login', '$shoutboxMessage', NOW())";
Indien er nog meer files benodigd zijn om mij een antwoord te kunnen geven, zoals config.php en functions.php kan ik deze posten als het nodig is.
Gewijzigd op 28/09/2010 16:15:21 door Joshua Tijssen
Code (php)
1
2
3
4
5
6
2
3
4
5
6
<?php
ini_set('display_errors', 1); // 0 = uit, 1 = aan
error_reporting(E_ALL);
// rest
?>
ini_set('display_errors', 1); // 0 = uit, 1 = aan
error_reporting(E_ALL);
// rest
?>
Gewijzigd op 28/09/2010 16:26:26 door - SanThe -
Heb $login veranderd in $data en nu doet hij precies wat ik wil