Lo skin for revcms!

Status
Not open for further replies.

James6213

Member
Nov 13, 2011
99
13
New update on Boom​
53fcfb696c1b50bb6b7630f9cd13775a.png
All done in MySQL :D
 

JoinHotel

Member
Feb 18, 2012
118
2
anyone know how to fix this
Deprecated: Assigning the return value of new by reference is deprecated in C:\xampp\php\PEAR\Config.php on line 80

Deprecated: Assigning the return value of new by reference is deprecated in C:\xampp\php\PEAR\Config.php on line 166

anyone can help me with that??
 

James6213

Member
Nov 13, 2011
99
13
Maybe you should release this stuff.... Ive done my part do yours.

Sure thing man codes are bellow & any idea how to make the Facebook comments work?!

MeRight.php

Code:
<div id="main_content" style="width:275px;">
            <h2 class="title"><i>User Of The Week</i></h2>
            <center>
<?php
$check = mysql_query("SELECT user_id FROM user_of_the_week");
list ($useridoftheweek) = mysql_fetch_array($check);
//user_id    badge_id    badge_slot
$getuserinfo = mysql_query("SELECT username,look,motto,online, user_badges.badge_id as badge FROM `users` LEFT JOIN user_badges ON id = user_badges.user_id WHERE users.id = '".mysql_real_escape_string($useridoftheweek)."' GROUP BY users.id LIMIT 1");
while ($m = mysql_fetch_array($getuserinfo)){
print('<b><center><span style="display:block; color:#972F89; float:center; padding:0px; background:url(http://dghotel.co.uk/app/tpl/skins/Mango/images/6.gif)">'.$m['username'].'</span></b></center><img style="float:center" id="user" src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$m['look'].'"><br><b>Motto:</b> '.$m['motto'].'');
}
?>
 
</div>

MySQL Code;
Code:
/*
Navicat MySQL Data Transfer
 
Source Server        : localhost_3306
Source Server Version : 50157
Source Host          : localhost:3306
Source Database      : phoenix3
 
Target Server Type    : MYSQL
Target Server Version : 50157
File Encoding        : 65001
 
Date: 2012-03-18 23:24:36
*/
 
SET FOREIGN_KEY_CHECKS=0;
 
-- ----------------------------
-- Table structure for `user_of_the_week`
-- ----------------------------
DROP TABLE IF EXISTS `user_of_the_week`;
CREATE TABLE `user_of_the_week` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
 
-- ----------------------------
-- Records of user_of_the_week
-- ----------------------------
INSERT INTO `user_of_the_week` VALUES ('1', '132928');
 

Sledmur

Web-Developer
Nov 29, 2011
459
98
Sure thing man codes are bellow & any idea how to make the Facebook comments work?!

MeRight.php

Code:
<div id="main_content" style="width:275px;">
            <h2 class="title"><i>User Of The Week</i></h2>
            <center>
<?php
$check = mysql_query("SELECT user_id FROM user_of_the_week");
list ($useridoftheweek) = mysql_fetch_array($check);
//user_id    badge_id    badge_slot
$getuserinfo = mysql_query("SELECT username,look,motto,online, user_badges.badge_id as badge FROM `users` LEFT JOIN user_badges ON id = user_badges.user_id WHERE users.id = '".mysql_real_escape_string($useridoftheweek)."' GROUP BY users.id LIMIT 1");
while ($m = mysql_fetch_array($getuserinfo)){
print('<b><center><span style="display:block; color:#972F89; float:center; padding:0px; background:url(http://dghotel.co.uk/app/tpl/skins/Mango/images/6.gif)">'.$m['username'].'</span></b></center><img style="float:center" id="user" src="http://www.habbo.com/habbo-imaging/avatarimage?figure='.$m['look'].'"><br><b>Motto:</b> '.$m['motto'].'');
}
?>
 
</div>

MySQL Code;
Code:
/*
Navicat MySQL Data Transfer
 
Source Server        : localhost_3306
Source Server Version : 50157
Source Host          : localhost:3306
Source Database      : phoenix3
 
Target Server Type    : MYSQL
Target Server Version : 50157
File Encoding        : 65001
 
Date: 2012-03-18 23:24:36
*/
 
SET FOREIGN_KEY_CHECKS=0;
 
-- ----------------------------
-- Table structure for `user_of_the_week`
-- ----------------------------
DROP TABLE IF EXISTS `user_of_the_week`;
CREATE TABLE `user_of_the_week` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
 
-- ----------------------------
-- Records of user_of_the_week
-- ----------------------------
INSERT INTO `user_of_the_week` VALUES ('1', '132928');
<div id="fb-root"></div>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/en_US/all.js#xfbml=1&appId=138881106159184";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>


Add that to the header...
 

James6213

Member
Nov 13, 2011
99
13
<div id="fb-root"></div>
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/en_US/all.js#xfbml=1&appId=138881106159184";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script>


Add that to the header...

Cheers Bro
 

KyleVonnie

Come @ me Bro!
Oct 26, 2011
993
176
i atually love it, but u need to edit some pages for them to work but its awesome! 10/10!
 
Status
Not open for further replies.

Users who are viewing this thread

Top