[REL/DEV] UberCMS 2 [PHP, MySQL, OOP]

Quote:

---

Originally Posted by sholomon25

how to fix this problem ?

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 17 in C:\xampp\htdocs\includes\class.core.php on line 191

---

Run this:

Code:

---

INSERT INTO `site_config` VALUES ('1', '0');

---

Quote:

---

Originally Posted by iHarrison

Run this:

Code:

---

INSERT INTO `site_config` VALUES ('1', '0');

---

---

Thanks .>> By the way I got this problem when I startup the client


Title: Table 'uber2.user_tickets' doesn't exist
Text: Table 'uber2.user_tickets' doesn't exist

Quote:

---

Originally Posted by sholomon25

Thanks .>> By the way I got this problem when I startup the client


Title: Table 'uber2.user_tickets' doesn't exist
Text: Table 'uber2.user_tickets' doesn't exist

---

Here you go, try searching up in the thread, Jonteh has posted most of the queries that you'll need

Code:

---

CREATE TABLE IF NOT EXISTS `user_tickets` (
`userid` int(10) unsigned NOT NULL,
`sessionticket` varchar(100) NOT NULL,
`ipaddress` varchar(20) NOT NULL,
PRIMARY KEY (`sessionticket`,`ipaddress`),
UNIQUE KEY `index_id` (`userid`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

---

Quote:

---

Originally Posted by iHarrison

Here you go, try searching up in the thread, Jonteh has posted most of the queries that you'll need

Code:

---

CREATE TABLE IF NOT EXISTS `user_tickets` (
`userid` int(10) unsigned NOT NULL,
`sessionticket` varchar(100) NOT NULL,
`ipaddress` varchar(20) NOT NULL,
PRIMARY KEY (`sessionticket`,`ipaddress`),
UNIQUE KEY `index_id` (`userid`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

---

---

THanks again ^^ But CLIENT is the biggest problem I got... It says



Please update your Flash Player to the latest version.
You can install and download Adobe Flash Player here: Install flash player. More instructions for installation can be found here: More information


urghh...

Quote:

---

Originally Posted by iHarrison

Here you go, try searching up in the thread, Jonteh has posted most of the queries that you'll need

Code:

---

CREATE TABLE IF NOT EXISTS `user_tickets` (
`userid` int(10) unsigned NOT NULL,
`sessionticket` varchar(100) NOT NULL,
`ipaddress` varchar(20) NOT NULL,
PRIMARY KEY (`sessionticket`,`ipaddress`),
UNIQUE KEY `index_id` (`userid`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

---

---

THanks again ^^ But CLIENT is the biggest problem I got... It says



Please update your Flash Player to the latest version.
You can install and download Adobe Flash Player here: Install flash player. More instructions for installation can be found here: More information


urghh...

Quote:

---

Originally Posted by iHarrison

Here you go, try searching up in the thread, Jonteh has posted most of the queries that you'll need

Code:

---

CREATE TABLE IF NOT EXISTS `user_tickets` (
`userid` int(10) unsigned NOT NULL,
`sessionticket` varchar(100) NOT NULL,
`ipaddress` varchar(20) NOT NULL,
PRIMARY KEY (`sessionticket`,`ipaddress`),
UNIQUE KEY `index_id` (`userid`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

---

---

THanks again ^^ But CLIENT is the biggest problem I got... It says



Please update your Flash Player to the latest version.
You can install and download Adobe Flash Player here: Install flash player. More instructions for installation can be found here: More information


urghh...

Quote:

---

Originally Posted by sholomon25

THanks again ^^ But CLIENT is the biggest problem I got... It says



Please update your Flash Player to the latest version.
You can install and download Adobe Flash Player here: Install flash player. More instructions for installation can be found here: More information


urghh...

---

Scroll up the thread and you'll see I posted a quote of the fix of the client that Jonteh posted. It doesn't read the client config from the ubercms_config.php file though so you'll have to enter those manually.

oh ok thanks :)

I need a client fix, I go to ../client and it re-directs me to ../WWW/client. Then when I go to newclient.php it's a flash error..

Quote:

---

Originally Posted by iHarrison

Scroll up the thread and you'll see I posted a quote of the fix of the client that Jonteh posted. It doesn't read the client config from the ubercms_config.php file though so you'll have to enter those manually.

---

I cant see the problem. please hell me :(

my ubercms_config.php

Quote:

---

$client['connection_info_host'] = "127.0.0.1";
$client['connection_info_port'] = "30000";
$client['productdata_load_url'] = "http://127.0.0.1/gamedata/productdata.txt";
$client['furnidata_load_url'] = "http://127.0.0.1/gamedata/furnidata.txt";
$client['external_texts_txt'] = "http://127.0.0.1/gamedata/external_texts.txt";
$client['external_variables_txt'] = "http://127.0.0.1/gamedata/external_variables.txt";
$client['swf_base_dir'] = "http://127.0.0.1/gordon/";
$client['habbo_swf'] = "http://127.0.0.1/gordon/Habbo.swf";
$client['client_starting'] = "Please wait. YuNi is starting.";

---

I'm using IIS , I can't enter housekeeping .
Already Installed Helicon Ape , But still doesn't work .
anyone can help me? :)

Have you got a database compatible with uber 2.0 and phoenix?

It is compatible with Phoenix, but a few changes/additions need to be added by you.

Quote:

---

Originally Posted by FullmetalPride

It is compatible with Phoenix, but a few changes/additions need to be added by you.

---

Your hotel using IIS or Xampp?
If IIS , help me fix with my hotel :'(
I can't enter housekeeping :S

Quote:

---

Originally Posted by PrinceOren

Your hotel using IIS or Xampp?
If IIS , help me fix with my hotel :'(
I can't enter housekeeping :S

---

You need to do the global.php fix that Jonteh mentioned earlier, but instead with the /allseeingeye/adminglobal.php file.

Here's how to do it. You just need to replace:

Code:

---

$headers = @apache_request_headers();

---

with this:

Code:

---

// $headers = @apache_request_headers();

---

Quote:

---

Originally Posted by iHarrison

You need to do the global.php fix that Jonteh mentioned earlier, but instead with the /allseeingeye/adminglobal.php file.

Here's how to do it. You just need to replace:

Code:

---

$headers = @apache_request_headers();

---

with this:

Code:

---

// $headers = @apache_request_headers();

---

---

I tried Before , But still same :S
EDIT : Fixed ! Forgot to change the adminglobal.php xD
Thanks !
:D

Avatar Fix:

To those having a slight error with Avatar Imaging, just use Habbo's avatar image. This fix is for the "me" page. Use your brain and fix the other pages, it's too much to explain every other page for you.

>(your web path in windows explorer)>includes>tpl>comp-me.tpl
After opening in Notepad..
>Edit>Replace

Now find this:
%www%/includes/imager.php?figure=%look%&size=b&direction=2&head_direction=3&gesture=sml&size=m

And replace with:

http://habbo.com/habbo-imaging/avata...n=&gesture=sml

I have absolutely no idea why it wasn't working for me, but when I did this, it worked. If it still doesn't work, you gotta keep trying.

Again, this doesn't work for all pages containing your avatar, or another, I'm fixing the staff avatars page atm.

Quote:

---

Originally Posted by iHarrison

You need to do the global.php fix that Jonteh mentioned earlier, but instead with the /allseeingeye/adminglobal.php file.

Here's how to do it. You just need to replace:

Code:

---

$headers = @apache_request_headers();

---

with this:

Code:

---

// $headers = @apache_request_headers();

---

---

This ain't working :P

How would I change all my current passwords in the database to a new password encryption?

Quote:

---

Originally Posted by JoshuaLuke

How would I change all my current passwords in the database to a new password encryption?

---

It depends on which CMS you previously used. Most passwords for Habbo stuff are encrypted in MD5.

PhoenixCF Encrypts the passwords in MD5, but the letters are capitalized. I think..

The problem is that the decryption sites for MD5 rely on the database of their encrypted passwords to decrypt them. Basically someone has to encrypt cheese so that we can decrypt the MD5 string for cheese. That means we can't find the encryption for them that well.

I'll find the encryption if you tell me the CMS.

Quote:

---

Originally Posted by FullmetalPride

It depends on which CMS you previously used. Most passwords for Habbo stuff are encrypted in MD5.

PhoenixCF Encrypts the passwords in MD5, but the letters are capitalized. I think..

The problem is that the decryption sites for MD5 rely on the database of their encrypted passwords to decrypt them. Basically someone has to encrypt cheese so that we can decrypt the MD5 string for cheese. That means we can't find the encryption for them that well.

I'll find the encryption if you tell me the CMS.

---

My passwords are decrypted into MD5 currently. I need to convert them to what ever this uses, but I cant do them all manually considering I have over 1500 accounts in the table

It's all MD5 encrypted.

Quote:

---

Originally Posted by FullmetalPride

It's all MD5 encrypted.

---

This isn't MD5 is it?.. I imported my database from my VPS and I couldn't login...

:L I sure thought so..It kinda sucks that we can't figure out the encryption.

I can't get my client to connect with Phoenix. I added the new client, and everything..maybe I didn't edit it to say that I'm not using butterfly..

Will all these fixes be included in 2.0.1 ? Also in 2.0.1 will you include tutorial on how to set it up with Phoenix.

Few things;

Can you release all the homes fix?
Can you release the web-gallery for our server?

Thanks
Josh

Yeah homes don't work for me either.

Homes not working for me either.


I can't figure out why I can't restore my items to their previous state. I inserted my room, the room model, and the items. They all correspond, but the emu says it's crashing out. Fuck you, Phoenix...

Anyone come accross anything like this?