Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Q&A
RevCMS News not working..
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="MadMonsterMan" data-source="post: 374966" data-attributes="member: 67188"><p>[CODE]-- phpMyAdmin SQL Dump</p><p>-- version 4.4.15.5</p><p>-- http://www.phpmyadmin.net</p><p>--</p><p>-- Host: localhost</p><p>-- Generation Time: May 18, 2016 at 01:10 AM</p><p>-- Server version: 5.6.28-log</p><p>-- PHP Version: 5.3.28</p><p></p><p>SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";</p><p>SET time_zone = "+00:00";</p><p></p><p></p><p>/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;</p><p>/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;</p><p>/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;</p><p>/*!40101 SET NAMES utf8mb4 */;</p><p></p><p>--</p><p>-- Database: `pluz?1`</p><p>--</p><p></p><p>-- --------------------------------------------------------</p><p></p><p>--</p><p>-- Table structure for table `cms_news`</p><p>--</p><p></p><p>CREATE TABLE IF NOT EXISTS `cms_news` (</p><p> `id` int(11) NOT NULL,</p><p> `title` varchar(100) NOT NULL,</p><p> `image` varchar(100) NOT NULL DEFAULT '0',</p><p> `shortstory` text NOT NULL,</p><p> `longstory` text,</p><p> `author` varchar(25) NOT NULL,</p><p> `date` varchar(11) NOT NULL DEFAULT '0',</p><p> `type` varchar(100) NOT NULL DEFAULT '1',</p><p> `roomid` varchar(100) NOT NULL DEFAULT '1',</p><p> `updated` enum('0','1') NOT NULL DEFAULT '0'</p><p>) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;</p><p></p><p>--</p><p>-- Dumping data for table `cms_news`</p><p>--</p><p></p><p>INSERT INTO `cms_news` (`id`, `title`, `image`, `shortstory`, `longstory`, `author`, `date`, `type`, `roomid`, `updated`) VALUES</p><p>(2, 'Updates...', 'lpromo_gen_bday_4.png', 'As you can see..', 'HabSocial has made some changes around the layout part of HabSocial. We will continue to make & add more fun things to the website.', 'Tom', '0', '1', '1', '1'),</p><p>(3, 'Welcome to HabSocial!', 'webpromo_permeffects.png', 'Let''s get moving..', 'Welcome new users, we are very happy that you chose to play. We have a lot of new updates coming up and already have happen.\r\nNew commands:\r\n:cut ( cuts users head off)\r\n:heal (to heal all wounds)\r\n:hit ( hit another user)\r\n:hug ( hug another user)\r\nUpcoming commands:\r\n:slapAss ( slap another users ass)\r\n:buy & sell rooms ( already on habsocial but needs fixing)\r\nNew pets \r\n2016 HC furniture\r\nSmooth dragons\r\nMuch more!! Stay tuned on HabSocial...', '', '0', '1', '1', '0'),</p><p>(4, 'Whats your thoughts?', 'bouwteam_topstory.png', 'We want to know your opinion!', 'HabSocial wants to know your thoughts on how the new layout looks? You can email:<b>christianrecordstomuch@gmail.com<b> or you can submit a message here: <a href="http://habsocial.com/thoughts.php">Click Here!</a>\r\n', '', '0/1/13', '1', '1', '0');</p><p></p><p>--</p><p>-- Indexes for dumped tables</p><p>--</p><p></p><p>--</p><p>-- Indexes for table `cms_news`</p><p>--</p><p>ALTER TABLE `cms_news`</p><p> ADD PRIMARY KEY (`id`);</p><p></p><p>--</p><p>-- AUTO_INCREMENT for dumped tables</p><p>--</p><p></p><p>--</p><p>-- AUTO_INCREMENT for table `cms_news`</p><p>--</p><p>ALTER TABLE `cms_news`</p><p> MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;</p><p>DELIMITER $$</p><p>--</p><p>-- Events</p><p>--</p><p>CREATE DEFINER=`root`@`localhost` EVENT `daily_pet_respect_points` ON SCHEDULE EVERY 24 HOUR STARTS '2015-02-10 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO update users_stats set daily_pet_respect_points = 5 where daily_pet_respect_points = 0$$</p><p></p><p>CREATE DEFINER=`root`@`localhost` EVENT `daily_respect_points` ON SCHEDULE EVERY 24 HOUR STARTS '2015-01-12 21:39:07' ON COMPLETION NOT PRESERVE ENABLE DO update users_stats set daily_respect_points = 5 where daily_respect_points = 0$$</p><p></p><p>CREATE DEFINER=`root`@`localhost` EVENT `respect_fixen_MoIsKoel` ON SCHEDULE EVERY 24 HOUR STARTS '2012-01-01 23:59:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE user_stats</p><p>SET</p><p>DailyRespectPoints = '20',</p><p>DailyPetRespectPoints = '20'$$</p><p></p><p>DELIMITER ;</p><p></p><p>/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;</p><p>/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;</p><p>/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;</p><p>[/CODE]</p></blockquote><p></p>
[QUOTE="MadMonsterMan, post: 374966, member: 67188"] [CODE]-- phpMyAdmin SQL Dump -- version 4.4.15.5 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 18, 2016 at 01:10 AM -- Server version: 5.6.28-log -- PHP Version: 5.3.28 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `pluz?1` -- -- -------------------------------------------------------- -- -- Table structure for table `cms_news` -- CREATE TABLE IF NOT EXISTS `cms_news` ( `id` int(11) NOT NULL, `title` varchar(100) NOT NULL, `image` varchar(100) NOT NULL DEFAULT '0', `shortstory` text NOT NULL, `longstory` text, `author` varchar(25) NOT NULL, `date` varchar(11) NOT NULL DEFAULT '0', `type` varchar(100) NOT NULL DEFAULT '1', `roomid` varchar(100) NOT NULL DEFAULT '1', `updated` enum('0','1') NOT NULL DEFAULT '0' ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- -- Dumping data for table `cms_news` -- INSERT INTO `cms_news` (`id`, `title`, `image`, `shortstory`, `longstory`, `author`, `date`, `type`, `roomid`, `updated`) VALUES (2, 'Updates...', 'lpromo_gen_bday_4.png', 'As you can see..', 'HabSocial has made some changes around the layout part of HabSocial. We will continue to make & add more fun things to the website.', 'Tom', '0', '1', '1', '1'), (3, 'Welcome to HabSocial!', 'webpromo_permeffects.png', 'Let''s get moving..', 'Welcome new users, we are very happy that you chose to play. We have a lot of new updates coming up and already have happen.\r\nNew commands:\r\n:cut ( cuts users head off)\r\n:heal (to heal all wounds)\r\n:hit ( hit another user)\r\n:hug ( hug another user)\r\nUpcoming commands:\r\n:slapAss ( slap another users ass)\r\n:buy & sell rooms ( already on habsocial but needs fixing)\r\nNew pets \r\n2016 HC furniture\r\nSmooth dragons\r\nMuch more!! Stay tuned on HabSocial...', '', '0', '1', '1', '0'), (4, 'Whats your thoughts?', 'bouwteam_topstory.png', 'We want to know your opinion!', 'HabSocial wants to know your thoughts on how the new layout looks? You can email:<b>christianrecordstomuch@gmail.com<b> or you can submit a message here: <a href="http://habsocial.com/thoughts.php">Click Here!</a>\r\n', '', '0/1/13', '1', '1', '0'); -- -- Indexes for dumped tables -- -- -- Indexes for table `cms_news` -- ALTER TABLE `cms_news` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `cms_news` -- ALTER TABLE `cms_news` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5; DELIMITER $$ -- -- Events -- CREATE DEFINER=`root`@`localhost` EVENT `daily_pet_respect_points` ON SCHEDULE EVERY 24 HOUR STARTS '2015-02-10 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO update users_stats set daily_pet_respect_points = 5 where daily_pet_respect_points = 0$$ CREATE DEFINER=`root`@`localhost` EVENT `daily_respect_points` ON SCHEDULE EVERY 24 HOUR STARTS '2015-01-12 21:39:07' ON COMPLETION NOT PRESERVE ENABLE DO update users_stats set daily_respect_points = 5 where daily_respect_points = 0$$ CREATE DEFINER=`root`@`localhost` EVENT `respect_fixen_MoIsKoel` ON SCHEDULE EVERY 24 HOUR STARTS '2012-01-01 23:59:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE user_stats SET DailyRespectPoints = '20', DailyPetRespectPoints = '20'$$ DELIMITER ; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; [/CODE] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
RevCMS News not working..
Top