PHP Code:
<?php
if (isset($_SESSION['user']))
{
$testa = $_SESSION['user'];
if(isset($_POST['submit'])){
if($_POST['amount'] == "ja"){
mssql_select_db('ACCOUNT_DBF', $link);
mssql_query("DELETE FROM ACCOUNT_TBL WHERE account = '$testa'");
mssql_query("DELETE FROM ACCOUNT_TBL_DETAIL WHERE account = '$testa'");
mssql_select_db('CHARACTER_01_DBF', $link);
mssql_query("DELETE FROM CHARACTER_TBL WHERE account = '$testa'");
mssql_select_db('ACCOUNT_DBF', $link);
session_destroy();
echo '<head><meta http-equiv="refresh" content="5; URL=?mode=home"></head>';
}
elseif($_POST['amount'] =="nein"){
echo 'Mach das nie wieder ;D';
echo '<head><meta http-equiv="refresh" content="5; URL=?mode=home"></head>';
}
}
?>
<form action="#" method="post"><br />
<h3>Möchtest du uns wirklich verlassen?
</h3><br>
<select name="amount">
<option value="nein">Nein</option>
<option value="ja">Ja</option>
</select><br><br>
<input type="submit" name="submit" value="Los" /><br /><br />
</form>
<?php
}
?>
PHP Code:
<?php
if (isset($_SESSION['user']))
{
$testa = $_SESSION['user'];
$inhalt = $_POST['inhalt'];
$betreff = $_POST['betreff'];
if(isset($_POST['submit'])){
if($inhalt == ""){
$error = "Bitte gebe einen Text an";
}
elseif($betreff == ""){
$error = "Bitte gebe ein Betreff an";
}
else{
mssql_select_db('Support', $link);
mssql_query("INSERT INTO tickets ([text], [betreff], [user]) VALUES ('$inhalt', '$betreff', '$testa')");
mssql_select_db('ACCOUNT_DBF', $link);
}
}
?>
<?php
echo $error;
?>
<form action="#" method="post"><br />
Betreff: <input type="text" name="betreff" /><br />
Text (max. 500 Zeichen): <br> <textarea name="inhalt" cols="50" rows="7">
</textarea><br><br>
<input type="submit" name="submit" value="Change Password!" /><br /><br />
</form>
<?php
}
?>
Code:
Folgt
PHP Code:
<?php
if (isset($_SESSION['user']))
{
$testa = $_SESSION['user'];
include("inc/config.php");
$sql1 = "SELECT [account], [m_nLevel], [m_szName] FROM [CHARACTER_TBL] WHERE [account]='$testa' and [m_nLevel]='170'"; $db = @mssql_select_db("CHARACTER_01_DBF");
$rowcount = mssql_num_rows(mssql_query($sql1));
if ($rowcount !="0")
{
echo '<form name="auser" method="post">';
echo '<select name="chaar">';
$result = mssql_query($sql1);
while ($AllyMember = mssql_fetch_array($result)){
echo '<option>'.$AllyMember['m_szName'].'</option>';
}
echo '</select><input type="submit" border="0" name="submit" value="Resten"></form>';
}
else{
echo "<h2>Du hast keinen Chaar der level 170 ist</h2>";
}
if(isset($_POST['submit'])){
$chaar = $_POST['chaar'];
mssql_query("UPDATE [CHARACTER_TBL] SET [m_nLevel]='121' WHERE [m_szName] = '$chaar'");
echo "<h3><font color='\#19ff2f'>Reset erfolgreich</font></h3><br><h3>Bitte warte auf einen Serverrestart.</h3>";
die($error);
$error = "Reset war erfolgreich";
}
?>
<?php
}
?>
PHP Code:
<?php
session_start();
$salt = "kikugalanet";
$server = 'MSSQL Benutztername';
$pw = "mssql Passwort";
// Connect to MSSQL
$link = mssql_connect($server, 'sa', $pw);
if (!$link) {
die('Something went wrong while connecting to MSSQL');
}
$post_username = $_POST['name'];
$post_password = $_POST['pwd'];
if($post_username&&$post_password)
{
if (strlen($post_username)>16||strlen($post_password)>40)
{
die("Passwort oder Username ist zu lang!");
}
else
{
//md5
$post_password = md5($salt.$post_password);
mssql_select_db ('ACCOUNT_DBF', $link);
$login = sprintf("SELECT account, password FROM ACCOUNT_TBL WHERE account='$post_username' AND password='$post_password'");
$sql = mssql_query($login);
$rowcount = mssql_num_rows($sql);
if ($rowcount==1)
{
$_SESSION['user']=$post_username;
echo $_SESSION['user'].", du bist drine! <br> <h2>Bitte warten du wirst eingeloggt</h2><a href='panel/x.php?mode=home'>Weiter</a>";
echo '<head><meta http-equiv="refresh" content="5; URL=panel/x.php?mode=home"></head>';
}
else
die("Falsches Passwort!");
}
}
else {
?>
<form action="login.php" method="post">
Benutzername <br> <input type="text" name="name" size="20"><br> <br>
Kennwort <br> <input type="password" name="pwd" size="20"><br>
<br><input type="submit" value="Einloggen">
</form>
<?php
}
?>
-Votescript
-Chaarname change
-etc.