Profiles wont open?

Hello,

Iv been trying to get Swift EMU working and i have bumped into a few issues!

When you click to view someones profile it does not open / show.

I have also tried Leensters edition however i still have the same issue.

I use Illumina CMS so it could be down to that but i currently use PlusEMU and the profiles work.

If anyone could help that would be fab :)

Thanks!

I just had the same problem yesterday, it's because Illumina CMS does not save user_info when someone registers. user_info (in your mysql database) is the location for the profile information. You can use Uber CMS 2.0.1 which supports profiles instead.

Quote:

---

Originally Posted by below50

I just had the same problem yesterday, it's because Illumina CMS does not save user_info when someone registers. user_info (in your mysql database) is the location for the profile information. You can use Uber CMS 2.0.1 which supports profiles instead.

---

Yeah i thought it could be that!

Do you have any idea how i could upgrade to Uber CMS from this CMS because i don't want to lose my users etc?

Heh, sorry i cant help you there. I'm still learning just like you are ahah

Quote:

---

Originally Posted by below50

Heh, sorry i cant help you there. I'm still learning just like you are ahah

---

Ahah no problem :P

Just delete "sites" tables and import UberCMS "sites" tables.

Sent from my GT-I8160 using Tapatalk 2

Quote:

---

Originally Posted by Dokotrs

Just delete "sites" tables and import UberCMS "sites" tables.

Sent from my GT-I8160 using Tapatalk 2

---

Does UberCMS not have a different password decryption meaning all the users cannot login?

I don't think so.

Sent from my GT-I8160 using Tapatalk 2

Quote:

---

Originally Posted by Dokotrs

I don't think so.

Sent from my GT-I8160 using Tapatalk 2

---

Ooo seems to of worked i will do some testing later thanks m8.

Also would this fix the profile thing because all the current users won't have anything in the user_info

Quote:

---

Originally Posted by Mrdevy

Ooo seems to of worked i will do some testing later thanks m8.

Also would this fix the profile thing because all the current users won't have anything in the user_info

---

For current users there's profile won't work. Only for new users. If you want you can use HabboPHP. In this cms user_info updates when user goes to me page.

Sent from my GT-I8160 using Tapatalk 2

I'll take a look at that :) Just depends on the way the passwords are done tbh.

Quote:

---

Originally Posted by Dokotrs

For current users there's profile won't work. Only for new users. If you want you can use HabboPHP. In this cms user_info updates when user goes to me page.

Sent from my GT-I8160 using Tapatalk 2

---

Do you think it could be possible to code it on ubercms do they update when they go onto the me page?

Quote:

---

Originally Posted by Mrdevy

I'll take a look at that :) Just depends on the way the passwords are done tbh.



Do you think it could be possible to code it on ubercms do they update when they go onto the me page?

---

You can try. :)
http://forum.ragezone.com/showthread.php?p=7665015

Sent from my GT-I8160 using Tapatalk 2

Quote:

---

Originally Posted by Dokotrs

You can try. :)
User_info fix for HabboPHP - RaGEZONE forums

Sent from my GT-I8160 using Tapatalk 2

---

Kinda worked however it made them all 0

Screenshot by Lightshot

This is because theres something wrong with the structure in LoadProfile function (i guess)

Quote:

---

Originally Posted by Ryan

This is because theres something wrong with the structure in LoadProfile function (i guess)

---

Do you know of any possible fix?

Quote:

---

Originally Posted by Dokotrs

You can try. :)
User_info fix for HabboPHP - RaGEZONE forums

Sent from my GT-I8160 using Tapatalk 2

---

Do you think you could make a code for Illumina's CMS so it updates the user_info?

Update -

I also get
Access denied for user ''@'localhost' (using password: NO)

Quote:

---

Originally Posted by Ryan

This is because theres something wrong with the structure in LoadProfile function (i guess)

---

Nothing is wrong with LoadProfile structure server-side speaking. But ofc it was coded for UberCMS 2 user_info imputs.

Quote:

---

Originally Posted by AKllX

Nothing is wrong with LoadProfile structure server-side speaking. But ofc it was coded for UberCMS 2 user_info imputs.

---

What would be the best way to merge it over to your db seeming as the users db has loads more fields and also with the user_info been empty i need someway to create them for the users because i cannot start all over again.

Better have backed up that old db...

Quote:

---

Originally Posted by Kudzo

Better have backed up that old db...

---

huh?...

The old db you was using when you said you don't wanna lose your users registered, you better have backed up that db.

Quote:

---

Originally Posted by Kudzo

The old db you was using when you said you don't wanna lose your users registered, you better have backed up that db.

---

Oh ahah yes i have :P

Paying someone who can create the codes for Illumina CMS!

Offtopic - You mind giving me the swfs you use? I have some but they don't have c_images and hof_furni so it would be nice if you could pm a download link or where you got your from.

Ontopic - Why pay for something when this is a free forum and we are all here to help each other.

Quote:

---

Originally Posted by Kudzo

Offtopic - You mind giving me the swfs you use? I have some but they don't have c_images and hof_furni so it would be nice if you could pm a download link or where you got your from.

Ontopic - Why pay for something when this is a free forum and we are all here to help each other.

---

What EMU are you using m8?

Quote:

---

Originally Posted by Mrdevy

What EMU are you using m8?

---

Swift/fStorm Emu

Quote:

---

Originally Posted by Kudzo

Swift/fStorm Emu

---

http://forum.ragezone.com/f353/relea...-edits-931655/

The swf link is in the official thread just copy the swfs folder out of the zip and add it into your retros folder :)

862 MB!!! Naw, I'll pass...

Quote:

---

Originally Posted by Kudzo

862 MB!!! Naw, I'll pass...

---

Want me to zip them up and upload them for you then LOL?

Quote:

---

Originally Posted by Mrdevy

Want me to zip them up and upload them for you then LOL?

---

Sure, I really just need c_images and hof_furni because my hotel furni and icons won't load,.

Quote:

---

Originally Posted by Kudzo

Sure, I really just need c_images and hof_furni because my hotel furni and icons won't load,.

---

http://habboland.net/download.zip

Still a big file though m8!

Quote:

---

Originally Posted by Mrdevy

http://habboland.net/download.zip

Still a big file though m8!

---

Running on a low RAM this would just lag my hotel, no thanks.

Quote:

---

Originally Posted by Kudzo

862 MB!!! Naw, I'll pass...

---

NONONO. Just copy that address(mega.co.nz..) in SwiftEmu thread and paste in browser

Sent from my GT-I8160 using Tapatalk 2

Quote:

---

Originally Posted by Kudzo

Running on a low RAM this would just lag my hotel, no thanks.

---

All swfs are just about the same file size js.

Check DB settings..

Quote:

---

Originally Posted by vikingboy

Check DB settings..

---

Its nothing to do with the database

Still not fixed.. Can anyone help ;P

Use this PHP script to add al your excisting users to user_info. (I haven't tested this by the way)

Spoiler:

PHP Code:

---

<?php 
$query = mysql_query("SELECT id, account_created, last_online FROM users");  
while($row = mysql_fetch_assoc($query)){    
mysql_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive, id)    VALUES (" . $row["id"] . ", 0, 0, " . $row["account_created"] . ", " . $row["last_online"] . ", 0, 0, 0)") or die (mysql_error()); 
}
?>

---

If it worked, I can help you with adding future users to user_info. (:

Quote:

---

Originally Posted by BaasHotel

Use this PHP script to add al your excisting users to user_info. (I haven't tested this by the way)

Spoiler:

PHP Code:

---

<?php 
$query = mysql_query("SELECT id, account_created, last_online FROM users");  
while($row = mysql_fetch_assoc($query)){    
mysql_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive, id)    VALUES (" . $row["id"] . ", 0, 0, " . $row["account_created"] . ", " . $row["last_online"] . ", 0, 0, 0)") or die (mysql_error()); 
}
?>

---

If it worked, I can help you with adding future users to user_info. (:

---

Where shall i add that m8?

Quote:

---

Originally Posted by Mrdevy

Where shall i add that m8?

---

Just make a new PHP file somewhere in your cms, include/require your database connection(or make one in that file) and open that PHP file in your internet browser. It will then execute the script or give an error. If it's correctly executed, all your users will be in user_info.

Just remember that you have to delete the file after it's correctly executed and all your users are in user_info.

Quote:

---

Originally Posted by BaasHotel

Just make a new PHP file somewhere in your cms, include/require your database connection(or make one in that file) and open that PHP file in your internet browser. It will then execute the script or give an error. If it's correctly executed, all your users will be in user_info.

Just remember that you have to delete the file after it's correctly executed and all your users are in user_info.

---

Didn't work m8

Just to check

<?php
require_once 'required.php';
$query = mysql_query("SELECT id, account_created, last_online FROM users");
while($row = mysql_fetch_assoc($query)){
mysql_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive, id) VALUES (" . $row["id"] . ", 0, 0, " . $row["account_created"] . ", " . $row["last_online"] . ", 0, 0, 0)") or die (mysql_error());
}
?>

I put that in the file.

It didn't even create anything in the db however does not show any error on the page.

Quote:

---

Originally Posted by Mrdevy

Didn't work m8

Just to check

<?php
require_once 'required.php';
$query = mysql_query("SELECT id, account_created, last_online FROM users");
while($row = mysql_fetch_assoc($query)){
mysql_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive, id) VALUES (" . $row["id"] . ", 0, 0, " . $row["account_created"] . ", " . $row["last_online"] . ", 0, 0, 0)") or die (mysql_error());
}
?>

I put that in the file.

It didn't even create anything in the db however does not show any error on the page.

---

Do you use mysql or mysqli?

You can also try this one by the way, could be that your account_created and last_online aren't integers/you're using a strict db.

Spoiler:

PHP Code:

---

<?php
require_once 'required.php';
$query = mysql_query("SELECT * FROM users"); 
while($row = mysql_fetch_assoc($query)){ 
mysql_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive, id) VALUES ('" . $row["id"] . "', '0', '0', '1234', '1234', '0', '0', '0')") or die (mysql_error()); 
}
?>

---

Quote:

---

Originally Posted by BaasHotel

Do you use mysql or mysqli?

You can also try this one by the way, could be that your account_created and last_online aren't integers/you're using a strict db.

Spoiler:

PHP Code:

---

<?php
require_once 'required.php';
$query = mysql_query("SELECT * FROM users"); 
while($row = mysql_fetch_assoc($query)){ 
mysql_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive, id) VALUES ('" . $row["id"] . "', '0', '0', '1234', '1234', '0', '0', '0')") or die (mysql_error()); 
}
?>

---

---

Using Mysql

The database just remains empty when i do that and still no error just a white page
Screenshot by Lightshot

Quote:

---

Originally Posted by Mrdevy

Using Mysql

The database just remains empty when i do that and still no error just a white page
Screenshot by Lightshot

---

If you'll use this script, it will probably tell you the problem:

Spoiler:

Code:

---

<?php
$username = "yourdbusername";
$password = "yourdbpassword";
$host = "localhost";
$database = "yourdbname";


$connect = mysql_connect($host, $username, $password);
$select = mysql_select_db($database, $connect);


if(!$connect || !$select){
        die("No database connection");
} else {
        $query = mysql_query("SELECT * FROM users");
        if (!$query){
                die("query wasn't successful");
        } else {
                while($row = mysql_fetch_assoc($query)){
                        $query2 = mysql_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive, id) VALUES ('" . $row["id"] . "', '0', '0', '1234', '1234', '0', '0', '0')");
                }
                if (!$query2){
                        echo "query2 wasn't succesful";
                } else {
                        echo "Script was succesful";
                }
        }
}
?>

---

I got mine working with RevCMS!
I edited the class.core and added this,

Code:

---

final public function getInfo()
{
  global $engine;
  return $engine->result("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive, id) VALUES ('" . $row["id"] . "', '0', '0', '1234', '1234', '0', '0', '0'");
}

---

Also for you're CMS.
You could put that script what Baas posted in a new php file and include it in the client?,
so when the user enters it will execute and insert there info into the user_info table.

Quote:

---

Originally Posted by BaasHotel

If you'll use this script, it will probably tell you the problem:

Spoiler:

Code:

---

<?php
$username = "yourdbusername";
$password = "yourdbpassword";
$host = "localhost";
$database = "yourdbname";


$connect = mysql_connect($host, $username, $password);
$select = mysql_select_db($database, $connect);


if(!$connect || !$select){
    die("No database connection");
} else {
    $query = mysql_query("SELECT * FROM users");
    if (!$query){
        die("query wasn't successful");
    } else {
        while($row = mysql_fetch_assoc($query)){
            $query2 = mysql_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive, id) VALUES ('" . $row["id"] . "', '0', '0', '1234', '1234', '0', '0', '0')");
        }
        if (!$query2){
            echo "query2 wasn't succesful";
        } else {
            echo "Script was succesful";
        }
    }
}
?>

---

---

It says query2 wasn't succesful.

Also thanks for your help so far :)

Quote:

---

Originally Posted by XiFy

I got mine working with RevCMS!
I edited the class.core and added this,

Code:

---

final public function getInfo()
{
  global $engine;
  return $engine->result("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive, id) VALUES ('" . $row["id"] . "', '0', '0', '1234', '1234', '0', '0', '0'");
}

---

Also for you're CMS.
You could put that script what Baas posted in a new php file and include it in the client?,
so when the user enters it will execute and insert there info into the user_info table.

---

That code does not seem to work also.

Also yes that might be a good idea :p However the codes not working yet :P

Quote:

---

Originally Posted by Mrdevy

It says query2 wasn't succesful.

Also thanks for your help so far :)



That code does not seem to work also.

Also yes that might be a good idea :p However the codes not working yet :P

---

It should work now:
(I added a column id to query2, but that didn't seem to be in your user_info, that would've been the problem I think.)

Spoiler:

Code:

---

<?php
$username = "yourdbusername";
$password = "yourdbpassword";
$host = "localhost";
$database = "yourdbname";


$connect = mysql_connect($host, $username, $password);
$select = mysql_select_db($database, $connect);


if(!$connect || !$select){
    die("No database connection");
} else {
    $query = mysql_query("SELECT * FROM users");
    if (!$query){
        die("query wasn't successful");
    } else {
        while($row = mysql_fetch_assoc($query)){
            $query2 = mysql_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive) VALUES ('" . $row["id"] . "', '0', '0', '1234', '1234', '0', '0')");
        }
        if (!$query2){
            echo "query2 wasn't succesful";
        } else {
            echo "Script was succesful";
        }
    }
}
?>

---

Wouldn't opening client.php

And finding

Code:

---

$db->real_query("UPDATE users SET ip_last = '" . $_SERVER["REMOTE_ADDR"] . "', auth_ticket = '" . $sso . "' WHERE id = '" . USER_ID . "'");

---

And then just below that add?

Code:

---

$db->real_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive) VALUES ('" . $row["id"] . "', '0', '0', '1234', '1234', '0', '0')");

---

It could work, let me know if it does?

Quote:

---

Originally Posted by BaasHotel

It should work now:
(I added a column id to query2, but that didn't seem to be in your user_info, that would've been the problem I think.)

Spoiler:

Code:

---

<?php
$username = "yourdbusername";
$password = "yourdbpassword";
$host = "localhost";
$database = "yourdbname";


$connect = mysql_connect($host, $username, $password);
$select = mysql_select_db($database, $connect);


if(!$connect || !$select){
    die("No database connection");
} else {
    $query = mysql_query("SELECT * FROM users");
    if (!$query){
        die("query wasn't successful");
    } else {
        while($row = mysql_fetch_assoc($query)){
            $query2 = mysql_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive) VALUES ('" . $row["id"] . "', '0', '0', '1234', '1234', '0', '0')");
        }
        if (!$query2){
            echo "query2 wasn't succesful";
        } else {
            echo "Script was succesful";
        }
    }
}
?>

---

---

Had some progress

Screenshot by Lightshot

its now created 5 pages of that :)

Quote:

---

Originally Posted by XiFy

Wouldn't opening client.php

And finding

Code:

---

$db->real_query("UPDATE users SET ip_last = '" . $_SERVER["REMOTE_ADDR"] . "', auth_ticket = '" . $sso . "' WHERE id = '" . USER_ID . "'");

---

And then just below that add?

Code:

---

$db->real_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive) VALUES ('" . $row["id"] . "', '0', '0', '1234', '1234', '0', '0')");

---

It could work, let me know if it does?

---

In the client.php? Don't forget I'm not using Revcms so the codes might be different m8

Quote:

---

Originally Posted by Mrdevy

Had some progress

Screenshot by Lightshot

its now created 5 pages of that :)

---

Do you mean it has created 5 pages with the same id's or with different? If it created different id's, your profiles will now work. It isn't a good idea to add a query to your client, because it will slow down the page dramatically. If you want this to work when a users registers, you'll have to find the query where a user gets inserted in the DB(INSERT INTO users (blablabla)) and add this query under it:

Code:

---

mysql_query("INSERT INTO user_info (user_id,bans,cautions,reg_timestamp,login_timestamp,cfhs,cfhs_abusive) VALUES ('" . USER ID . "','0','0','" . time(). "','" . time() . "','0','0')");

---

I don't know the correct syntax for your CMS, but it should be something like that.

Something wrong in your config.

Quote:

---

Originally Posted by vikingboy

Something wrong in your config.

---

Maybe it's an idea to first read everything in the thread before you answer.

Quote:

---

Originally Posted by BaasHotel

Do you mean it has created 5 pages with the same id's or with different? If it created different id's, your profiles will now work. It isn't a good idea to add a query to your client, because it will slow down the page dramatically. If you want this to work when a users registers, you'll have to find the query where a user gets inserted in the DB(INSERT INTO users (blablabla)) and add this query under it:

Code:

---

mysql_query("INSERT INTO user_info (user_id,bans,cautions,reg_timestamp,login_timestamp,cfhs,cfhs_abusive) VALUES ('" . USER ID . "','0','0','" . time(). "','" . time() . "','0','0')");

---

I don't know the correct syntax for your CMS, but it should be something like that.

---

Yeah its different IDS's :)

But how is the table going to update such as the time they logged in etc?

Quote:

---

Originally Posted by BaasHotel

Do you mean it has created 5 pages with the same id's or with different? If it created different id's, your profiles will now work. It isn't a good idea to add a query to your client, because it will slow down the page dramatically. If you want this to work when a users registers, you'll have to find the query where a user gets inserted in the DB(INSERT INTO users (blablabla)) and add this query under it:

Code:

---

mysql_query("INSERT INTO user_info (user_id,bans,cautions,reg_timestamp,login_timestamp,cfhs,cfhs_abusive) VALUES ('" . USER ID . "','0','0','" . time(). "','" . time() . "','0','0')");

---

I don't know the correct syntax for your CMS, but it should be something like that.

---

What file am i adding this to?

Quote:

---

Originally Posted by Mrdevy

Yeah its different IDS's :)

But how is the table going to update such as the time they logged in etc?



What file am i adding this to?

---

Your emulator will update the login timestamp and which CMS are you using?

Quote:

---

Originally Posted by BaasHotel

Your emulator will update the login timestamp and which CMS are you using?

---

illumina cms

You use, illuminacms which is MySQLi

So open you're client.php where your CMS is located.

Find this

Code:

---

$db->real_query("UPDATE users SET ip_last = '" . $_SERVER["REMOTE_ADDR"] . "', auth_ticket = '" . $sso . "' WHERE id = '" . USER_ID . "'");

---

And below it,
add this

Code:

---

$db->real_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive) VALUES ('" . $row["id"] . "', '0', '0', '1234', '1234', '0', '0')");

---

Since, you're using SwfEmu the login_timestamp
should not be different just because it's a different CMS -_-

Note: The code may be wrong,
I'm not really use to MySQLi I use MySQL for all my side projects.

Quote:

---

Originally Posted by XiFy

You use, illuminacms which is MySQLi

So open you're client.php where your CMS is located.

Find this

Code:

---

$db->real_query("UPDATE users SET ip_last = '" . $_SERVER["REMOTE_ADDR"] . "', auth_ticket = '" . $sso . "' WHERE id = '" . USER_ID . "'");

---

And below it,
add this

Code:

---

$db->real_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive) VALUES ('" . $row["id"] . "', '0', '0', '1234', '1234', '0', '0')");

---

Since, you're using SwfEmu the login_timestamp
should not be different just because it's a different CMS -_-

Note: The code may be wrong,
I'm not really use to MySQLi I use MySQL for all my side projects.

---

It's not setting the correct register date or user ID

Quote:

---

Originally Posted by BaasHotel

Use this PHP script to add al your excisting users to user_info. (I haven't tested this by the way)

Spoiler:

PHP Code:

---

<?php 
$query = mysql_query("SELECT id, account_created, last_online FROM users");  
while($row = mysql_fetch_assoc($query)){    
mysql_query("INSERT INTO user_info(user_id, bans, cautions, reg_timestamp, login_timestamp, cfhs, cfhs_abusive, id)    VALUES (" . $row["id"] . ", 0, 0, " . $row["account_created"] . ", " . $row["last_online"] . ", 0, 0, 0)") or die (mysql_error()); 
}
?>

---

If it worked, I can help you with adding future users to user_info. (:

---

Where does this go?

Quote:

---

Originally Posted by Mrdevy

illumina cms

---

Go to your wwwroot/htdocs > engine > classes > class_users.php
Find:

Code:

---

public function addUser($username, $passwordHash, $email, $rank, $figure, $sex, $motto, $homeroom) {

---

Change to:

Spoiler:

Code:

---

                public function addUser($username, $passwordHash, $email, $rank, $figure, $sex, $motto, $homeroom, $id) {
                        global $db, $core;
                        if($this->stmt = $db->prepare("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,home_room,credits,activity_points,last_online,account_created,ip_last,ip_reg) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "', '" . $motto . "', '" . $homeroom . "','15000','1000','','" . date('d-M-Y') . "', '".$_SERVER['REMOTE_ADDR']."', '".$_SERVER['REMOTE_ADDR']."')")) {
                                $this->stmt = $db->prepare("INSERT INTO user_info (user_id,bans,cautions,reg_timestamp,login_timestamp,cfhs,cfhs_abusive) VALUES ('" . $id . "','0','0','" . time(). "','" . time() . "','0','0')");
                                $this->stmt->execute();
                                $this->stmt->close();
                        }
                        else {
                                $db->databaseError($db->error);
                        }
                }

---

This should do the trick. (I'm not sure though, I'm not familiar with OOP)

Quote:

---

Originally Posted by Mario1134

Where does this go?

---

I'll quote my post for you:

Quote:

---

Originally Posted by BaasHotel

Just make a new PHP file somewhere in your cms, include/require your database connection(or make one in that file) and open that PHP file in your internet browser. It will then execute the script or give an error. If it's correctly executed, all your users will be in user_info.

Just remember that you have to delete the file after it's correctly executed and all your users are in user_info.

---

Quote:

---

Originally Posted by BaasHotel

Go to your wwwroot/htdocs > engine > classes > class_users.php
Find:

Code:

---

public function addUser($username, $passwordHash, $email, $rank, $figure, $sex, $motto, $homeroom) {

---

Change to:

Spoiler:

Code:

---

                public function addUser($username, $passwordHash, $email, $rank, $figure, $sex, $motto, $homeroom, $id) {
                        global $db, $core;
                        if($this->stmt = $db->prepare("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,home_room,credits,activity_points,last_online,account_created,ip_last,ip_reg) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "', '" . $motto . "', '" . $homeroom . "','15000','1000','','" . date('d-M-Y') . "', '".$_SERVER['REMOTE_ADDR']."', '".$_SERVER['REMOTE_ADDR']."')")) {
                                $this->stmt = $db->prepare("INSERT INTO user_info (user_id,bans,cautions,reg_timestamp,login_timestamp,cfhs,cfhs_abusive) VALUES ('" . $id . "','0','0','" . time(). "','" . time() . "','0','0')");
                                $this->stmt->execute();
                                $this->stmt->close();
                        }
                        else {
                                $db->databaseError($db->error);
                        }
                }

---

This should do the trick. (I'm not sure though, I'm not familiar with OOP)


I'll quote my post for you:

---

It gave me a server error, how do I know if it's been executed successfully?

Quote:

---

Originally Posted by BaasHotel

Go to your wwwroot/htdocs > engine > classes > class_users.php
Find:

Code:

---

public function addUser($username, $passwordHash, $email, $rank, $figure, $sex, $motto, $homeroom) {

---

Change to:

Spoiler:

Code:

---

        public function addUser($username, $passwordHash, $email, $rank, $figure, $sex, $motto, $homeroom, $id) {
            global $db, $core;
            if($this->stmt = $db->prepare("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,home_room,credits,activity_points,last_online,account_created,ip_last,ip_reg) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "', '" . $motto . "', '" . $homeroom . "','15000','1000','','" . date('d-M-Y') . "', '".$_SERVER['REMOTE_ADDR']."', '".$_SERVER['REMOTE_ADDR']."')")) {
                $this->stmt = $db->prepare("INSERT INTO user_info (user_id,bans,cautions,reg_timestamp,login_timestamp,cfhs,cfhs_abusive) VALUES ('" . $id . "','0','0','" . time(). "','" . time() . "','0','0')");
                $this->stmt->execute();
                $this->stmt->close();
            }
            else {
                $db->databaseError($db->error);
            }
        }

---

This should do the trick. (I'm not sure though, I'm not familiar with OOP)


I'll quote my post for you:

---

All sorted now! Thanks for your help :)

Quote:

---

Originally Posted by Mrdevy

All sorted now! Thanks for your help :)

---

You're welcome :D

Quote:

---

Originally Posted by BaasHotel

You're welcome :D

---

Quote:

---

public function addUser($username, $passwordHash, $email, $rank, $figure, $sex, $motto, $homeroom, $id) {
global $db, $core;
if($this->stmt = $db->prepare("INSERT INTO users (username,password,mail,auth_ticket,rank,look,gender,motto,home_room,credits,activity_points,last_online,account_created,ip_last,ip_reg) VALUES ('" . $username . "','" . $passwordHash . "','" . $email . "','','" . $rank . "','" . $figure . "','" . $sex . "', '" . $motto . "', '" . $homeroom . "','15000','1000','','" . date('d-M-Y') . "', '".$_SERVER['REMOTE_ADDR']."', '".$_SERVER['REMOTE_ADDR']."')")) {
$this->stmt = $db->prepare("INSERT INTO user_info (user_id,bans,cautions,reg_timestamp,login_timestamp,cfhs,cfhs_abusive) VALUES ('" . $id . "','0','0','" . time(). "','" . time() . "','0','0')");
$this->stmt->execute();
$this->stmt->close();
}
else {
$db->databaseError($db->error);
}
}

---

Finally got it working. But it says i created the account on 1/1/1970? Ive checked the account_created table, if i put the numbers inside the user_info it works. How do i make sure that users who have logged in its automatically inserted into user_info table?

Why does it say that i registered on 1/1/1970

Quote:

---

Originally Posted by Mario1134

Why does it say that i registered on 1/1/1970

---

Because you probably used a date that actually doesn't excist.

Quote:

---

Originally Posted by BaasHotel

Because you probably used a date that actually doesn't excist.

---

No i did, because if i insert my reg_timestamp from users into user_info it shows i registered on 28/06/2013.

I think its to do with the queries, not sure though.

Quote:

---

Originally Posted by Mario1134

No i did, because if i insert my reg_timestamp from users into user_info it shows i registered on 28/06/2013.

I think its to do with the queries, not sure though.

---

You'll have to use a unix timestamp in your user_info.

Quote:

---

Originally Posted by Mario1134

No i did, because if i insert my reg_timestamp from users into user_info it shows i registered on 28/06/2013.

I think its to do with the queries, not sure though.

---

Use strtotime().

Quote:

---

Originally Posted by Matata

Use strtotime().

---

Where do I put this?