PierxCMS v.1.0.1 [BASADA EN SexyCMS] [XAMPP & IIS] [Tripolyn]

<?php
$habbo_web = "63_1dc60c6d6ea6e089c6893ab4e0541ee0";

$MySQLhostname = "localhost"; // tu hosting - por lo general es localhost
$MySQLusername = "root"; // usuario - por lo general es root
$MySQLpassword =  "Pones Tu Contraseña De DB"; // tu contraseña
$MySQLdb =  "Pones Tu DB"; // database
$cms_version = "1.0.4"; // No mover
$cms_server =  "Aca Pones La URL De Tu Hotel (eje: .sytes.net zapto.org)"; // Sin http:// y sin la / del final
$avatar = "http://www.habbo.com.tr/habbo-imaging/avatarimage?figure="; // No mover
$BUILD_CMS = "63_1dc60c6d6ea6e089c6893ab4e0541ee0/1869";

<?php

// Web //
$logo = "http://Tu URL (eje: .sytes.net , zapto.org) /images/logo.png"; //Logo de tu web

$kekotop = "http://kekotop.com/index.php?a=in&u=iCredit"; // URL de tu kekotop

$avatar = "http://www.habbo.com.tr/habbo-imaging/avatarimage?figure="; // No mover

$adf1 = "/life"; // Si tienes adf.ly cambia el /life por el )

$adf2 = "/client"; // Tu adf.ly para el client (Si no tienes adf.ly solo pon "/client")

$facebook = "http://facebook.com/HabboiCredit"; // Facebook de la page


// PREMIUM //

$creditospremium = "250000"; // Creditos al comprar premium

$pixelespremium = "5000"; // Duckets al comprar premium

$cristalespremium = "2000"; // Cristales al comprar premium


// Registro //

$creditosiniciales = "50000"; // Creditos al registrarse

$pixelesiniciales = "2500"; // Duckets al registrarse

$cristalesiniciales = "1000"; // Cristales al registrarse

DELIMITER $$
--
-- Procedures
--
DROP PROCEDURE IF EXISTS `dofastfoodlogin`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `dofastfoodlogin`(IN `sso_ticket` VARCHAR(50))
    NO SQL
BEGIN
 SELECT users.username, users.id, users.credits, users.look, users.gender, user_fastfood.fastGames, user_fastfood.parachute, user_fastfood.missile, user_fastfood.shield, user_fastfood.ff_points FROM users
 LEFT JOIN user_fastfood ON (user_fastfood.userid =users.id)
 RIGHT JOIN user_tickets ON (user_tickets.userid = users.id)
 WHERE user_tickets.sessionticket=sso_ticket;
END$$

DROP PROCEDURE IF EXISTS `getroomitems`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `getroomitems`(IN `roomid` INT(10) UNSIGNED)
BEGIN

 SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.data, items_limited.limited_number, items_group.data

 FROM items_rooms

 JOIN items ON (items.item_id = items_rooms.item_id)

 LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)

 LEFT JOIN items_limited ON (items_limited.item_id = items.item_id)

 LEFT JOIN items_group ON (items_group.id = items.item_id)
        
 WHERE items_rooms.room_id = roomid;

END$$

DROP PROCEDURE IF EXISTS `getusergroups`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `getusergroups`(IN `userid` INT(10) UNSIGNED)
BEGIN
 
        SELECT groups.*
        
        FROM groups_users
        
        JOIN groups ON (groups.id = groups_users.groupid)
        
        WHERE groups_users.userid = userid AND groups_users.acepted = '1';
                                        
END$$

DROP PROCEDURE IF EXISTS `getuseritems`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `getuseritems`(IN `userid` INT(10) UNSIGNED)
BEGIN

 SELECT items_users.item_id, items.base_id, items_extradata.data, items_limited.limited_number, items_group.data

 FROM items_users

 JOIN items ON (items.item_id = items_users.item_id)

 LEFT JOIN items_extradata ON (items_extradata.item_id = items.item_id)
        
        LEFT JOIN items_limited ON (items_limited.item_id = items.item_id)
        
        LEFT JOIN items_group ON (items_group.id = items.item_id)

 WHERE items_users.user_id = userid;

END$$

--
-- Functions
--
DROP FUNCTION IF EXISTS `convToSmallInt`$$
CREATE DEFINER=`root`@`localhost` FUNCTION `convToSmallInt`(n INTEGER) RETURNS smallint(6)
RETURN n$$

DELIMITER ;