Phoenix CMS [UberEmu Compatible]

Quote:

---

Originally Posted by Sojobo

run this SQL;

DELETE FROM navigator_publics WHERE id = 8 LIMIT 1;

Reboot the hotel and that should fix it.

---

Ah thank you very much :)

For those getting a black screen on the client using texts.cfm, please use the new database, I forgot to include cms_texts
Alternatively you can just run this;

Code:

---

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `cms_texts`
-- ----------------------------
DROP TABLE IF EXISTS `cms_texts`;
CREATE TABLE `cms_texts` (
  `name` varchar(100) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

Quote:

---

Originally Posted by Bjork

Think to delete your cache and cookies. I do this and that worked ;)



I had this problem, i deleted hidden folders ".svn" in each folders of the cms and that worked ;)

---

Thanks, this worked great, I had a feeling it was this because the links were going to the svn folders. it must be set up to go the top folder and the svn was.

Quote:

---

Originally Posted by Admiral-Speedy

Thanks, this worked great, I had a feeling it was this because the links were going to the svn folders. it must be set up to go the top folder and the svn was.

---

The latest SVN build fixes that bug, don't remove the .svn folder, just update from SVN.

Quote:

---

Originally Posted by Sojobo

The latest SVN build fixes that bug, don't remove the .svn folder, just update from SVN.

---

Ok, and how do I add campaigns and news?

Quote:

---

Originally Posted by Admiral-Speedy

Ok, and how do I add campaigns and news?

---

Go into phpMyAdmin and on the cms_news press insert ;)

im making a project like this gonna fail hard imma rename uber

Quote:

---

Originally Posted by Admiral-Speedy

Ok, and how do I add campaigns and news?

---

You need to do it via SQL atm, like Hejula said.

Quote:

---

Originally Posted by Hejula

Go into phpMyAdmin and on the cms_news press insert ;)

---

Hoping to get started on the Housekeeping soon, just making sure everything that's in so far is working heh.

Quote:

---

Originally Posted by ¢rashh™

im making a project like this gonna fail hard imma rename uber

---

Huh? What you on about?

Quote:

---

Originally Posted by Sojobo

You need to do it via SQL atm, like Hejula said.

Hoping to get started on the Housekeeping soon, just making sure everything that's in so far is working heh.

Huh? What you on about?

---

There is another error on news,

Code:

---

Error Executing Database Query.

Table 'phoenix.cms_comments' doesn't exist

---

just noticed it :P

Quote:

---

Originally Posted by Hejula

Go into phpMyAdmin and on the cms_news press insert ;)

---

Ok, and what about campaigns

i got the same error as hejula

Quote:

---

Originally Posted by Hejula

There is another error on news,

Code:

---

Error Executing Database Query.

Table 'phoenix.cms_comments' doesn't exist

---

just noticed it :P

---

I have no errors on my news page

I also figured out campaigns

Quote:

---

Originally Posted by Admiral-Speedy

Ok, and what about campaigns

---

If you want to set an article as a campaign, in the database, go into cms_news and press edit on the article you want to make into a campaign, and set campaign to 1 and set campaignimg to the url for the image on the left of the campaign! :)

EDIT: all the images are in /Public/Images/campaign so go into there, find the image you want and get the name, and for campaignimg put "/Public/Images/campaign/imagename.gif" without the quotation marks obviously!

Quote:

---

Originally Posted by Sojobo

You need to do it via SQL atm, like Hejula said.

Hoping to get started on the Housekeeping soon, just making sure everything that's in so far is working heh.

Huh? What you on about?

---

I have it set up, there isn't a single problem, it's flawless, and the people with the sql errors most likely aren't using the provided DB

Quote:

---

Originally Posted by Hejula

There is another error on news,

Code:

---

Error Executing Database Query.

Table 'phoenix.cms_comments' doesn't exist

---

just noticed it :P

---

Use the updated SQL file or execute the following SQL command;

Code:

---

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `cms_comments`
-- ----------------------------
DROP TABLE IF EXISTS `cms_comments`;
CREATE TABLE `cms_comments` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `story` int(6) NOT NULL,
  `comment` text NOT NULL,
  `date` int(10) NOT NULL,
  `author` int(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

Literally as soon as Admiral said he has no problems, I did an svn upadte and put on the new db ;) But thanks :)

I have customized a lot of things, I've changed names in the navbar, and I have everything working, I have people on the staff and expert pages, I have news and campaigns, and I removed the games tab, and the forum linking option, as well as changed the logo, removed ads, and changed some of the text.

I alos just changed the credits and pixels numbers to white

Im using habboons swfs. But it gets stuck at


http://i53.tinypic.com/2gwco0m.jpg


I get this too even when emu is up. And, I just got it to load both bars etc. But it just didnt load client...

Quote:

---

Originally Posted by thetrev14

Im using habboons swfs. But it gets stuck at


http://i53.tinypic.com/2gwco0m.jpg


I get this too even when emu is up. And, I just got it to load both bars etc. But it just didnt load client...

---

Habboons SWFs are domain locked, you won't be able to use them.

Well i tried my r63 swfs and it wouldnt work :\ And r59 :\

Wanna help me???

@Aaron, check your Otaku inbox. :)

Quote:

---

Originally Posted by Grant

@Aaron, check your Otaku inbox. :)

---

Dude, you should have "pm'd" him that on "RaGEZONE"
second..
he has a billion inbox messages, and he only checks Staff Member Private Messages

Really good CMS, We have it set up from the help of Aaron xD, Soon to have the emulator, I recommend you to install this, It works with normal uber databases by the way.

aha i have long awaited this :D

love the pics, ive never used coldfusion before and i quit college as we were about to learn it! so ive set it up right the front page works but wen i clik register the page turns to text. any help

Download Coldfusion 8. I had 9 and i had same problem. Get 8 and it works fine.