: [Download] Advanced MuOnline WebShop Automático S4 [ Jump ]

Mensagens : 3 Data de inscrição : 08/11/2009

O Shop esta com a Season 4 pura sem novos itens nem dbz nem naruto essas mer.... cadorias ae.

Este Shop é automático com sistema de créditos ou golds como queiram chamar, ele nao apaga o bau para por o item, simplesmente ele procura um espaco vazio onde seja possivel por o item comprado e adiciona neste espaço.

A segurança sempre é discutida, creio que esta 99%, nao digo 100% pq nem o FBI é.

[ FOTO ]

[Tens de ter uma conta e sessão iniciada para poderes visualizar esta imagem]

DOWNLOADS

Todos abaixo ja vem com as querys.

4SHARED = [Tens de ter uma conta e sessão iniciada para poderes visualizar este link]
RapidShare = [Tens de ter uma conta e sessão iniciada para poderes visualizar este link]
MegaUpload = [Tens de ter uma conta e sessão iniciada para poderes visualizar este link]

Após baixar o Shop.

Configure o arquivo wshconf.php colocando seu usuario e senha o SQL.
Para logar como ADM do shop procure pela seguinte linha no mesmo arquivo:

$webshop['misc']['admins'] = 'muhero'; <-- aqui coloque seu login nao retire os ' '

ATENÇÃO

1 - Se você ja usa esse shop com a S3 Ep2 então apenas add-s4.sql

2 - Se você não usa o shop então rode a query create_proc.sql que esta na pasta install.

3 - Após isso rode a query tables.sql.

4 - Agora rode a query WebShop.sql, lembre rode esta query apenas se voce ainda nao usa o shop.

4.1 - Para mudar os valores dos itens, voce tera que faze-lo um a um, com um pouco de paciencia vc xega lá.

5 - Rode grupo.sql para add os Grupos de Sets, são 54 sets ao todo.

5.1 - Para mudar os valores dos Grupos de Sets, vc tem que deletar os grupos e cria-los novamente com o mesmo numero, va no menu IGroup Manage. Exemplo: o Set Leather tem que ser o 1, bronze o 2 e assim por diante.
Use sempre os mesmos numeros como base.

Por favor nao me peça para add itens custom nao tenho tempo para esse tipo de ajuda, todos os dados necessários para isso esta postado aqui e no outro topico.

Na pasta Items do shop existe varias fotos de itens custom para facilitar a vida de quem se aventurar a personalizar seu shop.

Os valores dos itens nao estão configurados, recomendo que se use a query que instala todos os itens se for possivel.
Como ja falei antes, nao tenho conhecimento suficiente em PHP, nao sei como mudar o layout do Shop.

JOB para resetao ganhar creditos....
Citação:
declare @AccountID varchar (10)
declare @Name varchar (10)

Select @AccountID=AccountID,@Name=Name from character
JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
where
resets >= 400
AND MEMB_STAT.ConnectStat = 0
AND CtlCode = 0

Update memb_credits set credits=credits+375 where memb___id=@AccountID

Update character set
resets = 0,
mreset=mreset+1,
LevelUpPoint=(mreset+1)*500,
Strength = 30,
Dexterity = 30,
Vitality = 30,
Energy = 30,
Leadership = 0
where Name=@Name
JOB para ranking semanal ganhar creditos
Citação:
Use MuOnline

declare @AccountID varchar (10)
declare @AccountID2 varchar (10)
declare @AccountID3 varchar (10)

declare @Name varchar(10)
declare @Name2 varchar(10)
declare @Name3 varchar(10)

Select top 1 @AccountID=AccountID,@Name=Name from character order by semanaldif desc, name desc
Select top 1 @AccountID2=AccountID,@Name2=Name from character where Name<>@Name order by semanaldif desc, name desc
Select top 1 @AccountID3=AccountID,@Name3=Name from character where Name<>@Name and Name<>@Name2 order by semanaldif desc, name desc

Update MEMB_CREDITS set credits=credits+100 where memb___id=@AccountID
Update MEMB_CREDITS set credits=credits+50 where memb___id=@AccountID2
Update MEMB_CREDITS set credits=credits+25 where memb___id=@AccountID3

Update character set semanaldif=0
JOB para dar creditos aos GM's, vc pode por esse job para rodar 1 vez por semana ou a seu cretério.
esse job nao acumula os creditos, ou seja, se o gm nao usar ele ficara com o mesmo valor em creditos.
Citação:
USE MUONLINE
update memb_credits
set credits = 650
where memb___id = 'gm1'

update memb_credits
set credits = 650
where memb___id = 'gm2'

update memb_credits
set credits = 650
where memb___id = 'gm3'
OBS: quando se compra um item S4 full inicialmente nao vem as opcoes de socket, mas basta vc usar o item e retira-lo que as opcoes aparecem, vazias claro.

Espero que seja util para voces como esta sendo para mim....

Por favor se for postar em outro forum manter os creditos e se for fazer uma versao em cima dessa nao diga que foi vc que traduziu ou fez o que nao fez.
Tem um post com esse shop aki na RZ pra versao 97d/99z que o cara disse q ele traduziu, e até o erro que eu cometi na tradução ta la tb...
ou seja, ele usou a minha tradução e disse q ele traduziu... que feio!

Creditos do WebShop
Jump
Tradução e Personalização para S4
MuHero

[- Em Breve Postarei mais Web Shops e Web Sites Entradas -] Coisa e tals ' [ ATT: Jump ]

Assunto: Cara Topico Qua Nov 11, 2009 4:33 am

Cara seu topico esta bom so h que so falta arumar nao colocar os codigo da quer com citacao e organicar Wink

Mensagens : 1 Data de inscrição : 13/06/2010

boa cara

Mensagens : 1 Data de inscrição : 18/12/2010

Amigo gostaria de saber ond rodo o add-s4.sql pois rodei no Sql Query Analizer usando a db MuOnline e deu erro em todas as linha, Veja.

Código:: Server: Msg 128, Level 15, State 1, Line 1
The name 'Flamberge' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 2
The name 'Sword' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 3
The name 'Imperial' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 4
The name 'Frost' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 5
The name 'Absolute' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 6
The name 'Stinger' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 7
The name 'Deadly' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 8
The name 'Imperial' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 9
The name 'CrimsonGlory' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 10
The name 'Salamander' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 11
The name 'Guardian' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 12
The name 'Frost' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 13
The name 'Seraphim' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 14
The name 'Faith' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 15
The name 'Hades' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 16
The name 'Titan' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 17
The name 'Brave' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 18
The name 'Destory' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 19
The name 'Phantom' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 20
The name 'Seraphim' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 21
The name 'Faith' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 22
The name 'Paewang' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 23
The name 'Hades' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 24
The name 'Titan' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 25
The name 'Brave' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 26
The name 'Destory' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 27
The name 'Phantom' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 28
The name 'Seraphim' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 29
The name 'Faith' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 30
The name 'Paewang' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 31
The name 'Hades' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 32
The name 'Titan' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 33
The name 'Brave' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 34
The name 'Destory' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 35
The name 'Phantom' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 36
The name 'Seraphim' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 37
The name 'Faith' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 38
The name 'Paewang' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 39
The name 'Hades' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 40
The name 'Brave' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 41
The name 'Destory' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 42
The name 'Phantom' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 43
The name 'Seraphim' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 44
The name 'Faith' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 45
The name 'Phaewang' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 46
The name 'Hades' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 47
The name 'Paewang' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 48
The name 'Titan' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 49
The name 'Brave' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
Server: Msg 128, Level 15, State 1, Line 50
The name 'Titan' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.

Desde já obg

Mensagens : 1 Data de inscrição : 23/03/2012

Mano os links estao offs Sad

coloca novos links ai please ;D

Mensagens : 1 Data de inscrição : 22/04/2013

podem upar os links sff?? agradecia muito!!

» WebShop automatico By Desnutrido
» Entrada editada por mim !! :) JUMP