[Pack spd 6.0 ! Bug mobs somem em| Host]

Código:

 #1045 - Access denied for user 'galaxyho'@'localhost' (using password: YES)

Código:

 GRANT ALL ON *.* TO 'galaxyho'@'galaxyhotelv3.com' WITH GRANT OPTION;

Código:


DELIMITER $$
--
-- Procedimientos
--
CREATE DEFINER=`galaxyho`@`galaxyhotelv3.com` 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
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)
WHERE items_rooms.room_id = roomid;
END$$

CREATE DEFINER=`galaxyho`@`galaxyhotelv3.com` PROCEDURE `getuseritems`(
IN userid int(10) unsigned
)
BEGIN
SELECT items_users.item_id, items.base_id, items_extradata.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)
WHERE items_users.user_id = userid;
END$$

DELIMITER ;


Código:


Erro
consulta SQL:

DELIMITER $$--
-- Procedimientos
--
CREATE DEFINER =  `galaxyho`@`galaxyhotelv3.com` 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
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 )
WHERE items_rooms.room_id = roomid;

END$$

Mensagens do MySQL :

#1227 - Access denied; you need the SUPER privilege for this operation


-Live escreveu:

Ola ,


Utilize este pacote:

DOWNLOAD:

Emulador: http://www.mediafire.com/?pqs1sdcwwrjmw8s

DB: http://www.mediafire.com/?fjm3wx3e2yqvcts

MySQL Connector: 4shared.com /file/XI2fV0A5/mysql-connector-net-654.html

SWF RELEASE63-201211141113-913728051 compatível: https://www.power-pixel.net/t33889-

Source: http://www.mediafire.com/?ivnfl07032oh3hb

Scan: Não precisa, mediafire tem brguard.

Código:

Erro
consulta SQL:

--
-- Base de datos: `jamrprod`
--
DELIMITER $$--
-- Procedimientos
--
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.rareid, 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 )
WHERE items_rooms.room_id = roomid;

END$$

Mensagens do MySQL :

#1227 - Access denied; you need the SUPER privilege for this operation

Marcos Henrique. escreveu:

Olá Convidado,

Tente esse novo SQL:

Código:

SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.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)
WHERE items_rooms.room_id = roomid;

SELECT items_users.item_id, items.base_id, items_extradata.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)
WHERE items_users.user_id = userid;

Até.

Código:

Erro
consulta SQL:

SELECT items_rooms.item_id, items_rooms.x, items_rooms.y, items_rooms.n, items.base_id, items_extradata.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 )
WHERE items_rooms.room_id = roomid;


Mensagens do MySQL :

#1054 - Unknown column 'roomid' in 'where clause'