Profiles wont open?

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