Mobis do inventário sumindo 05.03.13 0:16 Re: Mobis do inventário sumindo 05.03.13 11:39 Re: Mobis do inventário sumindo 05.03.13 12:04 Re: Mobis do inventário sumindo 05.03.13 13:16 Re: Mobis do inventário sumindo 05.03.13 16:28
syster • 05.03.13 0:16
Cen0n • 05.03.13 11:39
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
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=`root`@`localhost` 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 ; Re: Mobis do inventário sumindo 05.03.13 21:49 Re: Mobis do inventário sumindo 06.03.13 15:23Utilize outra database
Re: Mobis do inventário sumindo 06.03.13 19:43
http://www.mediafire.com/view/?nxs37umcrluhuhh Re: Mobis do inventário sumindo 07.03.13 12:52 Re: Mobis do inventário sumindo 08.03.13 8:45 Re: Mobis do inventário sumindo 08.03.13 10:05Primeiramente você poderá pegar uma CMS e um emulador:
- Clicando aqui:
CMS--
CMS's Phoenix
Plane CMS - https://www.power-pixel.net/t21450-download-planecms-v20-phoenix-planeteam
NovaCMS - https://www.power-pixel.net/t26601-cms-novacms-phoenix-borboleta-uber-php-mysql
NovaPhoenix - https://www.power-pixel.net/t26884-nova-phoenix-com-designer-inovador
CMSPhoenix New - https://www.power-pixel.net/t19181-cms-phoenix-new
AllanDesign - https://www.power-pixel.net/t26569-phoenix-cms-by-alan-editada
TeenTeam - https://www.power-pixel.net/t23711-nova-teenteam-cms10
rTiago v2 - https://www.power-pixel.net/t23959-rtiag0cms-v20-estabilidade-seguranca-rapida
Powerv5 - https://www.power-pixel.net/t23588-power-cms-v5-editada-por-lince
XDR
Remix 4.0 - https://www.power-pixel.net/t26979-down-remix-cms-v40-new-crypto
Necr0 v2 - https://www.power-pixel.net/t22592-download-necr0-cms-r2-free-edition
Gavvos v1 - https://www.power-pixel.net/t26959-new-gavvo-cms-r1-nova-cripto
Remix 3.0 - https://www.power-pixel.net/t23486-new-remix-cms-v30
KashCMS - https://www.power-pixel.net/t26578-down-kashcms-v10-lavvos-new-crypto-habbolatino-atom
Globe v2 - https://www.power-pixel.net/t26823-new-globe-cms-r2
OnlyV5 - https://www.power-pixel.net/t26512-downonlycms-v5-atom-emulador-butterfly-hl-e-aemu
LinkedR2 - https://www.power-pixel.net/t25899-projetolinked-cms-r2-new-games-index-diferenciada-80novos-prints
Only v2 - https://www.power-pixel.net/t16437-download-onlycms-download
TenceCMS - https://www.power-pixel.net/t26643-cms-tence-cms-cms
Outras
Habbitos - https://www.power-pixel.net/t26678-download-habitos-cms
LasteCMS - https://www.power-pixel.net/t25554-lestecmsv1
Zitack - https://www.power-pixel.net/t24168-zitack-cms-r6
Hamp - https://www.power-pixel.net/t23196-hamp-cms-v2-confira-imperdivel
Lennex - https://www.power-pixel.net/t26331-lennex-cms-divertida-gratis-completa-original
Habbing v2 - https://www.power-pixel.net/t26360-habbing-cms-v2
Feitas do Zero
inCMS - https://www.power-pixel.net/t26466-incms-what-else-power-pixel-cms
Projj - https://www.power-pixel.net/t18242-projj-cms-162-nova-atualizacao-o-php-sso-opensource
EMU--
Based on Butterfly
aEMU - https://www.power-pixel.net/t26537-aemu-20-estavel
ButterStorm - https://www.power-pixel.net/t24890-emuhabbolatino-emulador-based-butterflyemu
Outros (New Crypto)
Azure - https://www.power-pixel.net/t17682-new-azure-emulador-com-pet-cavalo-montando-new
Habs0ck3t - https://www.power-pixel.net/t25294-novo-emulador-habbosockt3-nova-crypto-gratis
Phoenix
Fonix 3.8.1 - https://www.power-pixel.net/t23235-fonix-emulador-381-r63-beta-fonix
Phoenix 3.8.1 - https://www.power-pixel.net/t24835-phoenix-emulador-381-atualizado
Phoenix 3.9.0 - https://www.power-pixel.net/t26538-emulador-phoenix-390-nao-crackeado
Phoenix 3.7.1 - https://www.power-pixel.net/t19967-oficial-phoenix-emulador-371-open-source
Outros
R58 --
ZeroEMU - https://www.power-pixel.net/t376-wiredfurnizeroemulatorr58swf
LavvoEMU - https://www.power-pixel.net/t330-lavvo-emulador-v58
LatinEMU - https://www.power-pixel.net/t357-holograph-latinemu
Holograph --
v59 - https://www.power-pixel.net/t323-holograph-emulator-v59-wired-furniture-battle-banzai
UberEMU --
v63 - https://www.power-pixel.net/t3390-r63-uberemulator-breakz0nes-editar
RPG
LifeEMU - https://www.power-pixel.net/t23134-life-emulador-rpg
- Database:
- SWF:
Re: Mobis do inventário sumindo 08.03.13 10:52 Re: Mobis do inventário sumindo 08.03.13 11:51syster escreveu:Cade link da database Live ?
@Marcos não consigo executar essa sql no meu phpmyadmin ele fica so carregando e depois que execeu o limite de segundos.
Re: Mobis do inventário sumindo 08.03.13 16:34
Strik3 • 08.03.13 8:45
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; Re: Mobis do inventário sumindo 10.03.13 2:24Recomendamos a BH Servers com proteção DDOS gratuita em Cloud Server de alta performance. Entrega imediata.
