Search options

2012-04-01 14:35:45

Sveiki,pasidariau koda. viskas veikia išskyrus viena dalykėlį.
Man reikia,kad

else {
$irasome=mysql_query("UPDATE VIP SET timeleft = '$timeleft' WHERE username = '$ip'");

kai darysiu pratesimą VIP. tipo laikas, tas timeleft dar prasitęstu +30d. ($dienos)
man reik kažką padaryti su

$date2 = new Datetime("$timeleft"); //neliesti
$date2->modify("+$dienos day"); //neliesti
$timeleft = $date2->format("Y-m-d"); //neliesti

bet nežinau ką. visaip bandžiau - neišėjo
štai pats kodas.

<?php
include('mysql.php');
$imame=mysql_query("SELECT * FROM `nariai`");
while($stulpelis=mysql_fetch_array($imame)){
print"
            <div id=\"page_box\" class=\"bround_top\">    
            <div style=\"padding-top: 1px\">
            <div class=\"message warning\" style=\"margin: 10px 10px 5px 10px;\"><p>Slapyvardis:<b> ".$stulpelis['slapyvardis']." </b></p></div>
            <div class=\"message warning\" style=\"margin: 10px 10px 5px 10px;\"><p>IP:<b> ".$stulpelis['ip']."  </b></p></div>
            <div class=\"message warning\" style=\"margin: 10px 10px 5px 10px;\"><p>Liko pakvietimu:<b> ".$stulpelis['pakviete']."</b></p></div>"; 
}

$imame=mysql_query("SELECT * FROM `nariai`");
while($stulpelis=mysql_fetch_array($imame)){
$slapyvardis=$stulpelis['slapyvardis']; //neliesti
$vip123=$stulpelis['vip']; //neliesti
$ip=$stulpelis['ip']; //neliesti
$sk = "1"; //neliesti
$dienos = "30"; // Laikas kiek dienu gales turet VIP tas IP
$pakvietimai = "30"; // Kiek pakvietimu reiks,kad gautu vip
$flags = "de"; // Neliesiti
$access = "bit"; // Galima keisti,pagal savo norimus access'us
$pakviete=$stulpelis['pakviete']; //neliesti
$dabar = date("Y-m-d"); //neliesti
$date2 = new Datetime("$timeleft"); //neliesti
$date2->modify("+$dienos day"); //neliesti
$timeleft = $date2->format("Y-m-d"); //neliesti 
$lankytojoip = $_SERVER['REMOTE_ADDR']; //neliesti
        
if ($pakvietimai<=$pakviete) {
if ($vip123!=$sk) {
$irasome=mysql_query("INSERT INTO `VIP` SET `username`='$ip' , `password`='' , `access`='$access'  , `flags`='$flags'  , `steamid`=''  , `nickname`='$ip'  , `regtime`='$dabar' , `timeleft`='$timeleft' , `nupirko`='1' , `status`='' , `nr`=''");
$irasome=mysql_query("UPDATE nariai SET pakviete = pakviete-'$pakvietimai' WHERE slapyvardis = '$slapyvardis'");
print "<div class=\"message warning\" style=\"margin: 10px 10px 5px 10px;\"><p><b><center><font color='#12ff00'>Vip uzsakytas.</font></center></p></div>";
$irasome = mysql_query("DELETE FROM VIP WHERE `nupirko`='1' AND `timeleft`<'$dabar' ");
$irasome=mysql_query("UPDATE nariai SET vip = '1'");
}
else {
$irasome=mysql_query("UPDATE VIP SET timeleft = '$timeleft' WHERE username = '$ip'"); 
$irasome=mysql_query("UPDATE nariai SET pakviete = pakviete-'$pakvietimai' WHERE slapyvardis = '$slapyvardis'");
print "<div class=\"message warning\" style=\"margin: 10px 10px 5px 10px;\"><p><b><center><font color='#12ff00'>Vip pratestas.</font></center></p></div>";
$irasome = mysql_query("DELETE FROM VIP WHERE `nupirko`='1' AND `timeleft`<'$dabar' ");
}
}
else { print "<div class=\"message warning\" style=\"margin: 10px 10px 5px 10px;\"><p><b><center><font color='#ff0000'>Neturi pakankami pakvietimu,kad gutum nemokama vip!</font></center></p></div>"; }
}
?>

2011-06-02 13:04:12

Aš susiradau kitą reg ir login scriptą. Tačiau nemoku susitvarkyt su scriptu kuris uždraustu prisijungt prie puslapio po prisijungimo...
Register.php

<?PHP

//Database Information

$dbhost = "localhost";
$dbname = "dbname";
$dbuser = "dbuser";
$dbpass = "dbpass ";

//Connect to database

mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

    
$name = $_POST['name'];
$email = $_POST['email'];    
$username = $_POST['username'];
$password = md5($_POST['password']);
$passwordemail = $_POST['password'];

// lets check to see if the username already exists

$checkuser = mysql_query("SELECT username FROM users WHERE username='$username'"); 

$username_exist = mysql_num_rows($checkuser);

if($username_exist > 0){
    echo "I'm sorry but the username you specified has already been taken.  Please pick another one.";
    unset($username);
    include 'register.html';
    exit();
} 

// lf no errors present with the username
// use a query to insert the data into the database.

$query = "INSERT INTO users (name, email, username, password)
VALUES('$name', '$email', '$username', '$password')";
mysql_query($query) or die(mysql_error());
mysql_close();

echo "You have successfully Registered";
    
// mail user their information

$yoursite = 'www.blahblah.com';
$webmaster = 'yourname';
$youremail = 'youremail';
    
$subject = "You have successfully registered at $yoursite...";
$message = "Dear $name, you are now registered at our web site.  
    To login, simply go to our web page and enter in the following details in the login form:
    Username: $username
    Password: $passwordemail
    
    Please print this information out and store it for future reference.
    
    Thanks,
    $webmaster";
    
mail($email, $subject, $message, "From: $yoursite <$youremail>\nX-Mailer:PHP/" . phpversion());
    
echo "Your information has been mailed to your email address.";

?>

register.html

<form name="login" method="post" action="register.php">
<table border="0" width="225" align="center">
    <tr>
        <td width="219" bgcolor="#999999">
            <p align="center"><font color="white"><span style="font-size:12pt;"><b>Registration</b></span></font></p>
        </td>
    </tr>
    <tr>
        <td width="219">
            <table border="0" width="282" align="center">
                    <tr>
                        <td width="116"><span style="font-size:10pt;">Name:</span></td>
                        <td width="156"><input type="text" name="name" maxlength="100"></td>
                    </tr>
                    <tr>
                        <td width="116"><span style="font-size:10pt;">Email:</span></td>
                        <td width="156"><input type="text" name="email" maxlength="100"></td>
                    </tr>
                <tr>
                    <td width="116"><span style="font-size:10pt;">Username:</span></td>
                    <td width="156"><input type="text" name="username"></td>
                </tr>
                <tr>
                    <td width="116"><span style="font-size:10pt;">Password:</span></td>
                    <td width="156"><input type="password" name="password"></td>
                </tr>
                <tr>
                    <td width="116">&nbsp;</td>
                        <td width="156">
                            <p align="right"><input type="submit" name="submit" value="Submit"></p>
                        </td>
                </tr>
            </table>
        </td>
    </tr>
    <tr>
        <td width="219" bgcolor="#999999">&nbsp;</td>
    </tr>
</table>
</form>

login.php

<?php

//Database Information

$dbhost = "localhost";
$dbname = "dbname";
$dbuser = "dbuser";
$dbpass = "dbpass";

//Connect to database

mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

session_start();
$username = $_POST['username'];
$password = md5($_POST['password']);

$query = "select * from users where username='$username' and password='$password'";

$result = mysql_query($query);

if (mysql_num_rows($result) != 1) {
$error = "Bad Login";
    include "login.html";

} else {
    $_SESSION['username'] = "$username";
    include "memberspage.php";
}

?>

login.html

<form name="login" method="post" action="login.php">
<table border="0" width="225" align="center">
    <tr>
        <td width="219" bgcolor="#999999">
            <p align="center"><font color="white"><span style="font-size:12pt;"><b>Login</b></span></font></p>
        </td>
    </tr>
    <tr>
        <td width="219">
            <table border="0" width="220" align="center">
                <tr>
                    <td width="71"><span style="font-size:10pt;">Username:</span></td>
                    <td width="139"><input type="text" name="username"></td>
                </tr>
                <tr>
                    <td width="71"><span style="font-size:10pt;">Password:</span></td>
                    <td width="139"><input type="password" name="password"></td>
                </tr>
                <tr>
                    <td width="71">&nbsp;</td>
                        <td width="139">
                            <p align="right"><input type="submit" name="submit" value="Submit"></p>
                        </td>
                </tr>
            </table>
        </td>
    </tr>
    <tr>
        <td width="219" bgcolor="#999999"><font color="white">Not Registered? </font><a href="register.html" target="_self"><font color="white">Register</font></a><font color="white"> </font><b><i><font color="white">Now!</font></i></b></td>
    </tr>
</table>
</form>

table.sql

CREATE TABLE users (
  userid int(25) NOT NULL auto_increment,
  name varchar(25) NOT NULL default '',
  email varchar(255) NOT NULL default '',
  username varchar(25) NOT NULL default '',
  password varchar(255) NOT NULL default '',
  PRIMARY KEY  (userid),
  UNIQUE KEY username (username)
) TYPE=MyISAM COMMENT='Members';

Tai vat. Prisijungus atsidaro memberspage.php. ir siaip įmanoma į jį prisijungt. Tačiau yra scriptas kuris neleistu neužsiregistravusiems įeit į memberspage.php t.y

<?

// members page

session_start();

if ( empty( $username ) ) {

    print "Please login below!";

    include 'login.html';

} else {

// you can use regular html coding below the ?> 
// and before the <?

?>

<html>
<head>
<title>MEMBERS ONLY</title>
</head>
<body>
Your Members Page....
</body>
</html>

<?

?>

Tik jis su klaidom... Kaip su juo susitvarkyt? :?

2011-06-02 07:02:35

štai turiu veikianti registracijos scriptą su duomenų baze. Tačiau dabar reik man persidaryt į prisijungimo. Gal kas gali padėt?

do_reg.php
PHP kodas:

<?php 
 /* Jungies i DB */ 
$connection = mysql_connect("localhost","username","password"); 
$db = mysql_select_db("database"); 
  
/* Isgaunam duomenis is formos */ 
$name = $_POST[username]; 
$pass = $_POST[password]; 
$pass_conf = $_POST[pass_conf]; 
$email = $_POST[email]; 
$ip = $_SERVER[REMOTE_ADDR]; 

/* Tikrinam duomenis ar jie ivesti */ 

if($name == "" || $pass == "" || $pass_conf == "" || $email == ""){ 
$error="Prašome užpildyti visus laukus"; 
}; 
if($pass != $pass_conf) { 
$error = "Slaptažodžiai nesutapo"; 
}  

/* JEIGU $error yra tuscias t.y. klaidos nera vykdomas zemiau pateiktas skriptas */ 

if($error == ""){ 
$result = mysql_query("INSERT INTO `user` SET `username`='$name' ,`password`='$pass',`email`='$email',`ip`='$ip'") or die (mysql_error()); 
$error = "Aciu už registracija"; 
}; 
echo $error ; 
?>

register.php
PHP kodas:

<?php 
$IP = $_SERVER[REMOTE_ADDR]; 
?> 

<form name="reg" action="do_reg.php" method="post"> 
Username: <input type="text" name="username"><br> 
Password: <input type="password" name="password"><br> 
Conf: <input type="password" name="pass_conf"><br> 
email: <input type="text" name="email"><br> 
<input type="hidden" name="ip" value='<?php echo $ip ?>'> 
<input type="submit" value="Registratint"> 
</form>

table.sql
PHP kodas:

CREATE TABLE `user` ( 
`id` int(10) unsigned NOT NULL auto_increment, 
`username` varchar(20) NOT NULL default '', 
`password` varchar(50) NOT NULL default '', 
`email` varchar(40) NOT NULL default '', 
`ip` varchar(20) NOT NULL default '', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Search options

Posts found: 3

1 Topic by bimuxas 2012-04-01 14:35:45

Topic: Padekit,reik kad dar +30d. prisidetu (0 replies, posted in SQL užklausos ir duomenų struktūros)

2 Reply by bimuxas 2011-06-02 13:04:12

Re: Padekit,reik padaryt prisijungimo script php. (7 replies, posted in PHP)

3 Topic by bimuxas 2011-06-02 07:02:35

Topic: Padekit,reik padaryt prisijungimo script php. (7 replies, posted in PHP)

Posts found: 3