Nicht eingeloggt
 Registrieren
 Login
|
Micki
Neuling
|
 - 12.02.10 21:15 Uhr |
|
hi,
da ich diese Forum bald benutzen, möchte ich diese Tabelle: users (von diese Forum) zu user_data ändern (Da ich Iv-CMS benutzen). Nun möchte ich wissen, welche Dateien davon ich ändern soll, wo es Tabelle Name "users" liegt. Da ich kein bock habe, dass alle 2x registrieren muss.
Naja, ansonst schöne Wochenende.
Gruss, Micki
|
Micki
Neuling
|
| - 20.02.10 20:25 Uhr |
|
Komisch. bei mir gehen nicht, wenn ich mich einloggen kommt ein Meldung, das Daten nicht stimmen, aber ich geben meine richtige Daten.
Code user.php:
Code:
<?php // 25. Mai 2007 • Copyright (C) Itschi.Net
class user
{
var $data;
var $session = 'forum_user_id';
var $cookie_username = 'forum_d_username';
var $cookie_password = 'forum_d_password';
var $cookie_lifetime = 1209600; // 14 Tage in Sek
function user()
{
session_start();
$this->autologin();
$this->update_vars();
$this->update_online();
$this->update_time(true);
$this->check_ban();
}
function autologin()
{
if (isset($_SESSION[$this->session]))
{
return;
}
if (isset($_COOKIE[$this->cookie_username]))
{
$this->login(
$_COOKIE[$this->cookie_username],
$_COOKIE[$this->cookie_password],
true
);
}
}
function login($username, $password, $set_cookie)
{
$res = mysql_query("
SELECT * FROM " . PREFIX . "user_data
WHERE name = '" . mysql_real_escape_string($username) . "'
");
$row = mysql_fetch_array($res);
mysql_free_result($res);
if (!$row || $password != $row['pass'])
{
return false;
}
else
{
$this->data = $row;
$_SESSION[$this->session] = $this->data['id'];
mysql_query('
UPDATE ' . PREFIX . 'user_data
SET login = ' . time() . ",
ip = '" . $_SERVER['REMOTE_ADDR'] . "'
WHERE id = " . $this->data['id']
);
if ($set_cookie)
{
$this->cookie(true);
}
$this->check_ban();
$this->update_online();
$this->update_time(true);
return true;
}
}
function update_online()
{
$file = mysql_real_escape_string(basename($_SERVER['PHP_SELF']) . ($_SERVER['QUERY_STRING'] ? '?' . $_SERVER['QUERY_STRING'] : ''));
$user_id = isset($this->data['id']) ? $this->data['id'] : 0;
$res = mysql_query("
SELECT COUNT(*)
FROM " . PREFIX . "online
WHERE online_ip = '" . $_SERVER['REMOTE_ADDR'] . "'
");
$row = mysql_result($res, 0);
mysql_free_result($res);
if ($row > 0)
{
mysql_query('
UPDATE ' . PREFIX . 'online
SET user_id = ' . $user_id . ',
online_time = ' . time() . ",
online_file = '" . $file . "',
online_agent = '" . $_SERVER['HTTP_USER_AGENT'] . "'
WHERE online_ip = '" . $_SERVER['REMOTE_ADDR'] . "'
");
}
else
{
mysql_query('
INSERT INTO ' . PREFIX . 'online
(user_id, online_time, online_ip, online_file, online_agent) VALUES
(' . $user_id . ', ' . time() . ", '" . $_SERVER['REMOTE_ADDR'] . "', '" . $file . "', '" . $_SERVER['HTTP_USER_AGENT'] . "')
");
}
mysql_query('
DELETE FROM ' . PREFIX . 'online
WHERE online_time < ' . (time() - 300)
);
}
function update_time($online)
{
mysql_query('
UPDATE ' . PREFIX . 'user_data
SET online = ' . ($online ? time() : 0) . '
WHERE id = ' . $this->data['id']
);
}
function update_vars()
{
if (!isset($_SESSION[$this->session]))
{
return false;
}
$res = mysql_query('
SELECT * FROM ' . PREFIX . 'user_data
WHERE id = ' . $_SESSION[$this->session]
);
$this->data = mysql_fetch_array($res);
mysql_free_result($res);
}
function cookie($set)
{
setcookie(
$this->cookie_username,
$this->data['name'],
time() + ($set ? $this->cookie_lifetime : -$this->cookie_lifetime),
'/'
);
setcookie(
$this->cookie_password,
$this->data['pass'],
time() + ($set ? $this->cookie_lifetime : -$this->cookie_lifetime),
'/'
);
}
function logout()
{
if (empty($_SESSION[$this->session]) && empty($this->data))
{
return false;
}
$this->cookie(false);
$this->update_time(false);
unset($_SESSION[$this->session]);
unset($this->data);
session_destroy();
$this->update_online();
return true;
}
function check_ban()
{
if ($this->data['ban'] == 1)
{
$this->logout();
header ('location:index.php?ban=1');
}
}
function is_online()
{
return isset($this->data['id']) ? true : false;
}
function is_admin()
{
return ($this->data['level'] == 2) ? true : false;
}
function is_mod()
{
return ($this->data['level'] > 0) ? true : false;
}
function online_time()
{
return ($this->data['id']) ? floor((time() - $this->data['login']) / 60) : false;
}
function legende($id, $level)
{
switch ($level)
{
case 2: return 'mod';
case 1: return 'admin';
default: return '';
}}
function rank($ban, $level, $posts)
{
if ($ban == 1)
{
return 'Gesperrt';
}
else if ($level == 2)
{
return 'Administrator';
}
else if ($level == 1)
{
return 'Moderator';
}
else
{
$res = mysql_query('
SELECT rank_name FROM ' . PREFIX . 'ranks
WHERE rank_posts <= ' . (int)$posts . '
ORDER BY rank_posts DESC LIMIT 1
');
$row = mysql_fetch_array($res);
mysql_free_result($res);
return $row['rank_name'];
}
}
function rank_icon($ban, $level, $posts)
{
$res = mysql_query('
SELECT rank_repeat, rank_image FROM ' . PREFIX . 'ranks
WHERE rank_posts <= ' . (int)$posts . '
ORDER BY rank_posts DESC LIMIT 1
');
while ($row = mysql_fetch_array($res))
{
do
{
$rang .= '<img src="images/ranks/' . $row['rank_image'] . '" border="0" /> ';
}
while ($row['rank_repeat']--);
}
mysql_free_result($res);
return $rang;
}
function online()
{
$res = mysql_query('SELECT COUNT(*) FROM ' . PREFIX . 'online');
$row = mysql_result($res, 0);
mysql_free_result($res);
return $row;
}
function online_users()
{
$res = mysql_query('
SELECT COUNT(*) FROM ' . PREFIX . 'online
WHERE online_time > ' . (time() - 300) . ' AND user_id <> 0
');
$row = mysql_result($res, 0);
mysql_free_result($res);
return $row;
}
function online_bots()
{
$res = mysql_query("
SELECT COUNT(*)
FROM " . PREFIX . "online o, " . PREFIX . "bots b
WHERE o.online_agent LIKE CONCAT('%',b.bot_agent,'%')
AND o.online_time > " . (time() - 300) . '
AND o.id = 0
GROUP BY b.bot_name
');
$row = mysql_result($res, 0);
mysql_free_result($res);
return $row;
}
}
?>
------------------------------------------------------------------------
und index.php Code:
Code:
<?php // 25. Mai 2007 • Copyright (C) Itschi.Net
include('config.php');
include('includes/user.php');
include('includes/functions.php');
$user = new user();
$config = config_vars();
$page_title = ' | Startseite';
$error = '';
if (isset($_GET['logout']))
{
$time = round((time()-$user->data['login'])/60,0);
if ($user->logout())
{
$error = 2;
}
}
else if (!empty($_POST['name']) && !empty($_POST['pass']))
{
if (!$user->login($_POST['name'], md5($_POST['pass']), isset($_POST['merke'])))
{
$error = 1;
}
}
if (isset($_GET['ban']))
{
$error = 3;
}
include('template/header.php');
if (!$user->is_online())
{
switch ($error)
{
case 1: ?><div id="info"><big><b><font color="red">Die Zugangsdaten stimmen nicht!</font></b></big> - Versuche es bitte erneut!</div><? break;
case 2: ?><div id="info"><big><b><font color="green">Du wurdest ausgeloggt!</font></b></big> - Du warst <?= $time ?> Minute<? if ($time != 1) { ?>n<? } ?> online - Es ist <?= date('H:i') ?> Uhr</div><? break;
case 3: ?><div id="info"><big><b><font color="red">Du wurdest gesperrt!</font></b></big></div><? break;
}
?>
<div class="solid"><strong>Startseite</strong></div>
<table width="100%" cellpadding="4" cellspacing="0">
<tr>
<td class="top" style="padding-left:20px;border-top:1px solid #e7e7e7;" width="500">
<br />
<strong>Willkommen!</strong><br />Gib rechts deine Zugangsdaten ein!
<br />
<br />
</td>
<td class="side top" style="border-top:1px solid #e7e7e7;">
<br />
<div class="solid"><b>Login</b></div>
<div class="solid">
<form action="index.php" method="post">
Benutzername:<br /><input style="width:170px" type="text" name="name" /><br />
Passwort:<br /><input style="width:170px" name="pass" type="password" /><br />
<font style="line-height:34px"><input type="checkbox" id="merke" name="merke" /> <label for="merke">Eingeloggt bleiben</label><br />
<input type="submit" class="button" value="Anmelden" /></font><br /><br />
</form>
</div>
</div>
<br />
</td>
</tr>
</table>
<?
}
else
{
?>
<div class="solid"><strong>Startseite</strong></div>
<table width="100%" cellpadding="4" cellspacing="0">
<tr>
<td class="top" style="padding-left:20px;border-top:1px solid #e7e7e7;" width="500">
</td>
<td class="side top" style="border-top:1px solid #e7e7e7;">
<br /><strong>Titel</strong><br /><br />
Text
</td>
</tr>
</table>
<?
}
include('template/footer.php');
?>
user_data Tabelle:
id
name
pass
Der Eintrag wurde am 20.02.10 20:27 Uhr von Micki geändert.
|
|
Facebook
Twitter
(X)HTML, JavaScript, Ajax
Forum
Mitglieder
Newsletter
Fotos
Geburtstage
