Welcome!

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!

MuWeb Shop Query Analizer Scripts

Newbie Spellweaver
Joined
Nov 27, 2007
Messages
11
Reaction score
0
Hi! I hawe write some WebShop scripts for Query Analizer!

This script manage user credits (example):

Code:
update [MEMB_CREDITS] set [credits]=('1000') where [memb___id]=('Bios')
This script will show you how much credits hawe from selected user (example):

Code:
select [credits] as QueryResult from [MEMB_CREDITS] where [memb___id]=('Bios')
It's not a BIG JOB and if you don't need or don't like this script DON'T POST HERE!
For beginners this scripts is necessary!
 
Junior Spellweaver
Joined
Nov 22, 2006
Messages
167
Reaction score
18
Re: [Release] MuWeb Shop Query Analizer Scripts

to insert correct Isis Crystal and Flame of Condor in Savoy Webshop:

Original, dont work for me:
/* Isis Crystal */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansellitem) VALUES (84,'Isis Crystal',0,1,2,14,-1,0,0,0,0,0,1,0,0,0,0,13,0,0,0,0,1);

/* Condor Flame */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansellitem) VALUES (85,'Condor Flame',0,1,2,14,-1,0,0,0,0,0,1,0,0,0,0,14,0,0,0,0,1);

so change to:
/* Isis Crystal */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansellitem) VALUES (52,'Isis Crystal',0,1,2,12,-1,0,0,0,0,0,1,0,0,0,0,13,0,0,0,0,1);

/* Condor Flame */
INSERT INTO [WebShop] (id,name,credits,X,Y,type,ex_type,str,agi,luck,skill,hasLevel,default_durability,nrg,cmd,hasOption,optionType,category,stickLevel,maxitop,maxitlv,maxitxl,cansellitem) VALUES (53,'Condor Flame',0,1,2,12,-1,0,0,0,0,0,1,0,0,0,0,14,0,0,0,0,1);

for me work fine...

sry bad english.
 
Junior Spellweaver
Joined
Jan 23, 2007
Messages
147
Reaction score
26
Re: [Release] MuWeb Shop Query Analizer Scripts

This should be in guide section... Good scripter but not a good poster come on guys
 
Newbie Spellweaver
Joined
Jan 26, 2005
Messages
29
Reaction score
2
Re: [Release] MuWeb Shop Query Analizer Scripts

also in query analyzer we can run shortest way ^^
Code:
exec XCredits 'character',100
 
Junior Spellweaver
Joined
Jun 5, 2005
Messages
110
Reaction score
1
Re: [Release] MuWeb Shop Query Analizer Scripts

Bios, ur script is bad, because it SET credit, don't UPDATED
 
Junior Spellweaver
Joined
Jul 5, 2007
Messages
181
Reaction score
9
Re: [Release] MuWeb Shop Query Analizer Scripts

Bios, ur script is bad, because it SET credit, don't UPDATED
What's the problem? Just modify it for your needs...

Anyways, here is the done job:

PHP:
UPDATE MEMB_CREDITS SET Credits = Credits+1000 WHERE memb___id='maxiline'

 
Joined
Jan 9, 2005
Messages
669
Reaction score
83
Re: [Release] MuWeb Shop Query Analizer Scripts

What's the problem? Just modify it for your needs...

Anyways, here is the done job:

PHP:
UPDATE MEMB_CREDITS SET Credits = Credits+1000 WHERE memb___id='maxiline'

Hello sir, Do you mind if you could write a script that is similar in this quoted post but with required resets before + 1000 credits? like:

if Resets != 0 , then give 1000 credit.

thanks sir xD
 
Last edited:
Back
Top