MuWeb Shop Query Analizer Scripts

[Bios]

Hi! I hawe write some WebShop scripts for Query Analizer!

This script manage user credits (example):

update [MEMB_CREDITS] set [credits]=('1000') where [memb___id]=('Bios')

This script will show you how much credits hawe from selected user (example):

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!

[MentaL]

[serrinha]

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.

[Pinoyrealm]

This should be in guide section... Good scripter but not a good poster come on guys

[siikaisz]

also in query analyzer we can run shortest way ^^

exec XCredits 'character',100

[AdidasS]

Bios, ur script is bad, because it SET credit, don't UPDATED

[Kudo^]

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:

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

[JaneX]

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

Anyways, here is the done job:

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