Most visitors online was 10613 , on 26 Apr 2024
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!fix football please....
Did you read more as the main post?
(No)
Check please 2 pages back lol
but you will not pass the code...
[COLOR=#4E565E][I]-- ----------------------------[/I][/COLOR]
[COLOR=#4E565E][I]-- Procedure definition for `dofastfoodlogin`[/I][/COLOR]
[COLOR=#4E565E][I]-- ----------------------------[/I][/COLOR]
[COLOR=#4E565E][I]DROP PROCEDURE IF EXISTS `dofastfoodlogin`;[/I][/COLOR]
[COLOR=#4E565E][I]DELIMITER ;;[/I][/COLOR]
[COLOR=#4E565E][I]CREATE DEFINER=`root`@`localhost` PROCEDURE `dofastfoodlogin`(IN `sso_ticket` VARCHAR(50))[/I][/COLOR]
[COLOR=#4E565E][I] NO SQL[/I][/COLOR]
[COLOR=#4E565E][I]BEGIN[/I][/COLOR]
[COLOR=#4E565E][I] 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[/I][/COLOR]
[COLOR=#4E565E][I] LEFT JOIN user_fastfood ON (user_fastfood.userid =users.id)[/I][/COLOR]
[COLOR=#4E565E][I] RIGHT JOIN user_tickets ON (user_tickets.userid = users.id)[/I][/COLOR]
[COLOR=#4E565E][I] WHERE user_tickets.sessionticket=sso_ticket;[/I][/COLOR]
[COLOR=#4E565E][I]END[/I][/COLOR]
[COLOR=#4E565E][I];;[/I][/COLOR]
[COLOR=#4E565E][I]DELIMITER ;
Make sure you have the tables too ofc.
[/I][/COLOR]Code:[COLOR=#4E565E][I]-- ----------------------------[/I][/COLOR] [COLOR=#4E565E][I]-- Procedure definition for `dofastfoodlogin`[/I][/COLOR] [COLOR=#4E565E][I]-- ----------------------------[/I][/COLOR] [COLOR=#4E565E][I]DROP PROCEDURE IF EXISTS `dofastfoodlogin`;[/I][/COLOR] [COLOR=#4E565E][I]DELIMITER ;;[/I][/COLOR] [COLOR=#4E565E][I]CREATE DEFINER=`root`@`localhost` PROCEDURE `dofastfoodlogin`(IN `sso_ticket` VARCHAR(50))[/I][/COLOR] [COLOR=#4E565E][I] NO SQL[/I][/COLOR] [COLOR=#4E565E][I]BEGIN[/I][/COLOR] [COLOR=#4E565E][I] 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[/I][/COLOR] [COLOR=#4E565E][I] LEFT JOIN user_fastfood ON (user_fastfood.userid =users.id)[/I][/COLOR] [COLOR=#4E565E][I] RIGHT JOIN user_tickets ON (user_tickets.userid = users.id)[/I][/COLOR] [COLOR=#4E565E][I] WHERE user_tickets.sessionticket=sso_ticket;[/I][/COLOR] [COLOR=#4E565E][I]END[/I][/COLOR] [COLOR=#4E565E][I];;[/I][/COLOR] [COLOR=#4E565E][I]DELIMITER ;
If you can't pick up furniture, edit your "items" table.
Change the type of the column "room_id" from "int" to "varchar"
If you're having problems with the x, y and z column in the "items" table, change those to "varchar" aswell.
CREATE TABLE `user_playlistyoutube` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`videoid` varchar(20) NOT NULL,
`titre` varchar(50) NOT NULL,
`descri` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED
internal void GetPlaylistYoutube()
{
uint ItemId = Request.PopWiredUInt();
DataTable Ytplaylist;
Room room = ButterflyEnvironment.GetGame().GetRoomManager().GetRoom(this.Session.GetHabbo().CurrentRoomId);
if (room == null || !room.CheckRights(this.Session, true))
return;
using (IQueryAdapter dbClient = ButterflyEnvironment.GetDatabaseManager().getQueryreactor())
{
dbClient.setQuery("SELECT videoid, titre, descri FROM user_playlistyoutube WHERE user_id=@id LIMIT 20");
dbClient.addParameter("id", room.OwnerId);
Ytplaylist = dbClient.getTable();
}
int CountVideo = Ytplaylist.Rows.Count;
if (CountVideo == 0)
return;
GetResponse().Init(Outgoing.GetPlaylistYoutube);
GetResponse().AppendUInt(ItemId); // Id ITEM
GetResponse().AppendInt32(CountVideo); // Count Video
foreach (DataRow Row in Ytplaylist.Rows)
{
GetResponse().AppendStringWithBreak(Row["videoid"].ToString()); //Id Video
GetResponse().AppendStringWithBreak(Row["titre"].ToString()); // Title
GetResponse().AppendStringWithBreak(Row["descri"].ToString()); // desc
}
GetResponse().AppendStringWithBreak("La playlist de " + room.Owner ); // Text box
SendResponse();
}
internal void PlayVideoYoutube()
{
GetResponse().Init(Outgoing.PlayVideoYoutube);
GetResponse().AppendInt32(Request.PopWiredInt32()); // Id ITEM
GetResponse().AppendStringWithBreak(Request.PopFixedString()); //Id VIDEO
GetResponse().AppendInt32(0); // ???
GetResponse().AppendInt32(0); // ???
SendResponse();
}