Threaded Mode | Linear Mode

Ultima One · 01-07-2013 01:04 PM

change sphere_serv_trigs.scp to contain this:

Code:

// Update accounts from database

[function f_acc_update]

if ( <DB.connected> )

    DB.QUERY "SELECT * FROM accounts WHERE status='0'"

    if (<DB.ROW.NUMROWS> > 0)

        for R 0 <eval <DB.ROW.NUMROWS>-1>

            serv.account add <DB.ROW.<eval <LOCAL.R>>.login> <DB.ROW.<eval <LOCAL.R>>.password>

            DB.EXECUTE "UPDATE accounts SET status='1' WHERE login='<DB.ROW.<eval <LOCAL.R>>.login>'"

            serv.log MySQL Debug: #<eval <LOCAL.R>> Account <DB.ROW.<eval <LOCAL.R>>.login> has been created!

        end

    endif

endif

[FUNCTION f_onserver_timer]

serv.f_acc_update

ACCOUNT.UPDATE

In Sphere.ini set the TimerCall to 10, and activate SQL if not already done:

Code:

// MySql configuration.

MYSQL=1

MySqlHost=127.0.0.1

MySqlUser=username

MySqlPassword=password

MySqlDatabase=dbNAme

// Amount of minutes to call f_onserver_timer (0 disables this, default)

TimerCall=10

Create a file called db.php (to connect to your database):

PHP Code:

<?php

$username = "yourUserNAme";
$password = "yourPAssword";
$hostname = "localhost";
$db = "theDbName";

try {
    $con = new PDO("mysql:host=$hostname;dbname=$db", $username, $password);
     }
    catch(PDOException $e)
    {
        echo $e->getMessage();
    }
?>

Then, create a file called register.php :

PHP Code:

<?php

session_start();
include('db.php');
$account = $_POST['account'];
$password = $_POST['password'];
$email = $_POST['email'];
$ip = $_SERVER['REMOTE_ADDR'];
    if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
        $ip = $_SERVER['HTTP_CLIENT_IP'];
    } elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
        $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
    }

$sql = "SELECT * FROM accounts WHERE login = '".$account."'";
$rows = $con->prepare($sql);
$rows->execute();
if($rows->rowCount() > 0){
    header('Location: signup.php?regError=Username%20already%20in%20use');
}else{
    $sql2 = "INSERT INTO accounts (`login`, `password`, `email`, `ip`) VALUES ('".$account."','".$password."','".$email."','".$ip."')";
    $rows2 = $con->prepare($sql2);
    $rows2->execute();
    $_SESSION['account'] = $account;
    header('Location: signup.php');
}
?>

Then, create signup.php:

PHP Code:

<?php
session_start();
if(isset($_SESSION['account'])){
echo "Thank you for Registering. Your account will be activated within 10 minutes.";
}else{
?>
<h1>Fill in the form below to sign up!</h1>
<form id="regForm" action="register.php" method="post">
            <?php if(isset($_GET['regError'])){ echo "<span class='error'>".$_GET['regError']."</span><br />"; } ?>
            <label for="accountr">Account:</label>
            <input id="accountr" type="text" value="" name="account" />
            <label for="passwordr">Password:</label>
            <input id="passwordr" type="password" value="" name="password" />
            <label for="emailr">Email:</label>
            <input id="emailr" type="email" value="" name="email" />
            <input id="register" type="submit" value="Register" />
        </form>
<?php
} 

This is a simplified version of the script I wrote for our server (can see it at theuoproject.co.uk)

Hope that helps.

Threaded Mode \| Linear Mode Auto account PHP web
Author	Message