Beiträge von London1312

London1312 · 15. März 2019

Tausend küsse an dich #NOhomo

Hat nur register_ip & last_ip gefehlt

London1312 · 15. März 2019

PHP

<?php
class Database
{
private static $connection;
private static $settings = array(
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8",
PDO::ATTR_EMULATE_PREPARES => false,
);
public static function connect($host, $username, $password, $dbname) {
if (!isset(self::$connection)) {
self::$connection = @new PDO(
"mysql:host=$host;dbname=$dbname",
$username,
$password,
self::$settings
);
}
}
// Return the 1st row
public static function queryAlone($query, $parameters = array()) {
$result = self::$connection->prepare($query);
$result->execute($parameters);
return $result->fetch();
}
// Return all rows
public static function queryAll($query, $parameters = array()) {
$result = self::$connection->prepare($query);
$result->execute($parameters);
return $result->fetchAll();
}
// Return the number of affected rows
public static function query($query, $parameters = array()) {
$result = self::$connection->prepare($query);
$result->execute($parameters);
return $result->rowCount();
}
}

Alles anzeigen

wenn ich Ahnung von php hätte würde ich den Fehler selbst abstellen
so hier ist die database.class ich seh da kein fehler du ?

London1312 · 15. März 2019

Code

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'register_ip' in 'field list'' in /home/webpages/lima-city/london13/empty-install/inc/classes/Database.class.php:41 Stack trace: #0 /home/webpages/lima-city/london13/empty-install/inc/classes/Database.class.php(41): PDO->prepare('INSERT INTO acc...') #1 /home/webpages/lima-city/london13/empty-install/inc/classes/Registration.class.php(251): Database::query('INSERT INTO acc...', Array) #2 /home/webpages/lima-city/london13/empty-install/pages/register.php(58): Registration->register('test123', 'test123', 'testtest123@gma...', '1234567') #3 /home/webpages/lima-city/london13/empty-install/inc/classes/Router.class.php(29): require_once('/home/webpages/...') #4 /home/webpages/lima-city/london13/empty-install/index.php(171): Router->__construct() #5 {main} thrown in /home/webpages/lima-city/london13/empty-install/inc/classes/Database.class.php on line 41

dann wirft er mir das hier aus

London1312 · 15. März 2019

Gute frage wie mache ich das genau nicht das ich irgend ein fehler dort gemacht habe

London1312 · 15. März 2019

An die PHP'ler unter eucht habe mal mit einer anderen Regi verglichen bei der es funktioniert kann jemand mal schauen und mir sagen ob es daran liegt das nicht account.account drin steht ?

Code

public function register($username, $password, $email, $delcode)
{
$db = Core::getAccountDatabase();
$query = Database::query(
"INSERT INTO ".$db.".account (`login`, `password`, `social_id`, `email`,`create_time`,
`status`, `gold_expire`, `silver_expire`, `safebox_expire`, `autoloot_expire`, `fish_mind_expire`,
`marriage_fast_expire`, `money_drop_rate_expire`,`".Core::getCoinsColumn()."`, `web_admin`, `register_ip`, `last_ip`) VALUES
(?, PASSWORD(?), ?, ?, ?, 'OK', ?, ?, ?, ?, ?, ?, ?, ?, 0, ?, '')", array($username, $password, $delcode,
$email, date('Y-m-d H:i:s'), self::getGoldExpire(), self::getSilverExpire(), self::getSafeboxExpire(),
self::getAutolootExpire(), self::getFishExpire(), self::getMarriageExpire(), self::getMoneyExpire(),
self::getRegCoins(), $_SERVER["REMOTE_ADDR"]));
return $query;
}

Alles anzeigen

oben die nicht funktionierende unten eine die funktioniert

Code

$sqlCmd = "INSERT INTO account.account
(login,password,real_name,email,social_id,question1,answer1,create_time,status,coins,autoloot_expire,safebox_expire,web_aktiviert,last_play,web_ip,first_login,free_shop,marken)
VALUES
('".$_POST['account']."',PASSWORD('".$userpass."'),'".mysql_real_escape_string($_POST['uname'])."','".mysql_real_escape_string($_POST['email'])."','".$lcode."','".$sfNum."','".$hashSF."','".$sqlZeit."','".$accountStatus."','".$regCoins."','".$expireDate."','".$expireDate."','".$aktivHash."','1990-1-1 10:00:00','','0','0','0')";
$sqlQry = mysql_query($sqlCmd,$sqlServ);

Bitte dringend um Hilfe

London1312 · 14. März 2019

PHP

<div class="box">
<h2><?= Language::getTranslation("regTitle");?></h2>
<?php
if(User::isLogged())
{
echo "<p>".Language::getTranslation("alreadyLogged")."</p>";
} else {
$reg = new Registration();
$ref = new Referral();
if (Core::isCaptchaEnabled()) {
$securimage = new Securimage();
}
if (!$reg->isEnabled()) {
echo '<p>' . Language::getTranslation("regDisabled") . '</p>';
} else {
if(isset($_GET['ref']) AND ctype_digit($_GET['ref']) AND Core::referralSystemEnabled())
{
$_SESSION["ref"] = $_GET["ref"];
}
if (isset($_POST["reg"])) {
$username = $_POST["username"];
$email = $_POST["email"];
$pw = $_POST["pw"];
$pw2 = $_POST["pw2"];
$dcode = $_POST["deleteCode"];
if (Core::isCaptchaEnabled()) {
$captcha = $_POST["captcha"];
}
if (empty($username) OR empty($email) OR empty($pw) OR empty($pw2) OR empty($dcode)) {
$result = Core::result(Language::getTranslation("fillInAllFields"), 2);
} elseif (!ctype_alnum($username)) {
$result = Core::result(Language::getTranslation("regAlphanumeric"), 2);
} elseif (mb_strlen($username) < Registration::getUsernameMin() OR mb_strlen($username) > Registration::getPasswordMax()) {
$result = Core::result(Language::getTranslation("regUsernameRange"), 2);
} elseif (filter_var($email, FILTER_VALIDATE_EMAIL) == false) {
$result = Core::result(Language::getTranslation("emailNotValid"), 2);
} elseif ($reg->emailExists($email)) {
$result = Core::result(Language::getTranslation("emailExists"), 2);
} elseif ($reg->usernameExists($username)) {
$result = Core::result(Language::getTranslation("usernameExists"), 2);
} elseif (mb_strlen($pw) < Registration::getPasswordMin() OR mb_strlen($pw) > Registration::getPasswordMax()) {
$result = Core::result(Language::getTranslation("regPasswordRange"), 2);
} elseif (Registration::needToContainNumber() AND !preg_match('@[0-9]@', $pw)) {
$result = Core::result(Language::getTranslation("regPasswordNeedNumber"), 2);
} elseif ($pw != $pw2) {
$result = Core::result(Language::getTranslation("pwDontMatchPw2"), 2);
} elseif (mb_strlen($dcode) != 7 OR !ctype_alnum($dcode)) {
$result = Core::result(Language::getTranslation("regDeleteCode"), 2);
} elseif (Registration::weakPasswordListEnabled() AND Registration::isWeakPassword($pw)) {
$result = Core::result(Language::getTranslation("weakPassword"), 2);
} else {
// Let's register
if ($reg->register($username, $pw, $email, $dcode) > 0) {
$result = Core::result(Language::getTranslation("regSuccessful"), 1);
if(isset($_POST["ref"]) AND User::idExists($_POST["ref"]) AND
$ref->remainingUserLimit(User::getUserNameFromId($_POST["ref"])) != 0 AND Core::referralSystemEnabled()) {
Referral::updateReferrer($username, $_POST["ref"]);
}
}
}
}
if (isset($result)) {
echo $result;
}
?>
<p><?= Language::getTranslation("regDesc"); ?></p>
<ul>
<li><?= Language::getTranslation("regAlphanumeric"); ?></li>
<li><?= Language::getTranslation("regUsernameRange"); ?></li>
<li><?= Language::getTranslation("regPasswordRange"); ?></li>
<?php
if (Registration::needToContainNumber()) {
echo "<li>" . Language::getTranslation('regPasswordNeedNumber') . "</li>";
}
?>
<li><?= Language::getTranslation("regDeleteCode"); ?></li>
</ul>
<form method="post" action="<?= Links::getUrl("register"); ?>">
<div class="form-group">
<label for="reg_username"><?= Language::getTranslation("regUsername"); ?></label>
<input type="text" name="username" class="form-control" id="reg_username"
maxlength="<?= Registration::getUsernameMax(); ?>"
placeholder="<?= Language::getTranslation("regEnter") . " " . Language::getTranslation("regUsername"); ?>"
required>
</div>
<div class="form-group">
<label for="reg_email"><?= Language::getTranslation("regEmail"); ?></label>
<input type="email" name="email" class="form-control" id="reg_email"
placeholder="<?= Language::getTranslation("regEnter") . " " . Language::getTranslation("regEmail"); ?>"
required>
</div>
<div class="form-group">
<label for="reg_pass"><?= Language::getTranslation("regPassword"); ?></label>
<input type="password" maxlength="<?= Registration::getPasswordMax(); ?>" name="pw" class="form-control"
id="reg_pass" placeholder="<?= Language::getTranslation("regPassword"); ?>" required>
</div>
<div class="form-group">
<label for="reg_pass2"><?= Language::getTranslation("regPasswordAgain"); ?></label>
<input type="password" maxlength="<?= Registration::getPasswordMax(); ?>" name="pw2"
class="form-control" id="reg_pass2" placeholder="<?= Language::getTranslation("regPassword"); ?>"
required>
</div>
<div class="form-group">
<label for="reg_delete"><?= Language::getTranslation("regDelete"); ?></label>
<input type="text" maxlength="7" name="deleteCode" class="form-control" id="reg_delete"
placeholder="<?= Language::getTranslation("regEnter") . " " . Language::getTranslation("regDelete"); ?>"
required>
</div>
<?php
if (Core::isCaptchaEnabled()) {
?>
<div class="form-group">
<label for="captcha"><img id="captcha" src="assets/securimage/securimage_show.php"
alt="CAPTCHA Image"/>
<a href="#"
onclick="document.getElementById('captcha').src = 'assets/securimage/securimage_show.php?' + Math.random(); return false">[ <?= Language::getTranslation("anotherCaptcha"); ?>
]</a>
</label>
<input type="text" name="captcha" class="form-control" id="captcha"
placeholder="<?= Language::getTranslation("regCaptcha"); ?>" required>
</div>
<?php
}
if(isset($_GET['ref']) AND ctype_digit($_GET['ref']) AND Core::referralSystemEnabled())
{
echo '<input type="hidden" name="ref" value="'.$_GET['ref'].'">';
} elseif(isset($_SESSION["ref"]) AND ctype_digit($_SESSION["ref"]) AND Core::referralSystemEnabled()) {
echo '<input type="hidden" name="ref" value="'.$_SESSION['ref'].'">';
}
?>
<button type="submit" name="reg"
class="btn btn-primary"><?= Language::getTranslation("register"); ?></button>
</form>
<?php
}
}
?>
</div>

Alles anzeigen

Code

1 ID *PW 0.0.0000 00:00:00 0 OK 0 0 0 0.0.0000 00:00:00 0 0 0.0.0000 00:00:00 5.5.2035 21:00:00 5.5.2035 21:00:00 5.5.2035 21:00:00 5.5.2035 21:00:00 5.5.2035 21:00:00 0.0.0000 00:00:00 0 0 14.3.2019 20:19:39 0 0 0 0 0

Ich hoffe die Struktur ist richtig wenn nicht kurze info wie ich die bekomme

London1312 · 14. März 2019

servus,

Habe die 40k files und bin aktuell am HP testen habe die MT2Grand CMS HP und alles läuft nur die Account erstellung nicht.

Habe schon alles durch geschaut aber die Register.php sieht viel anders aus als bei anderen Hp's kennt sich jemand damit aus oder hatte auch mal das Problem ?

Beiträge von London1312

PHP Fehler bei Database connect

PHP Fehler bei Database connect

PHP Fehler bei Database connect

PHP Fehler bei Database connect

PHP Fehler bei Database connect

PHP Fehler bei Database connect

PHP Fehler bei Database connect