Jump to content
Addicted2 Romania
Aplicatiile pentru functia de "Helper" pentru serverul de Minecraft sunt deschise !

[Mu][Tutorial] Mssql Querys


Guest dizzy

Recommended Posts

General querys

Fix Zen

	  		UPDATE Character		SET Money=2000000000		WHERE Money<-1
//ZenBUG (cand dai zenul peste cap). Acest query va fixa zenul tuturor caracterelor. Starting Zen
				UPDATE Character		SET Money=2000000000		WHERE Money<1000000 Lorencia Bar[/b][/code]


[color=#4A4A4A]// Banuiesc ca nu este nevoie de explicatii... Va da cu 2 miliarde zen de la inceput![/color]







[b]Move Exile - Lorencia[/b]

		   
[code] UPDATE Character SET MapNumber=0, MapPosX=125, MapPosY=125 WHERE MapNumber=5[/code]
[color=#4A4A4A]//Pentru serverele care dau 'Exile' (muta userul intr'o harta care nu exista in client, efectul unui ban, numai ca userul respectiv va primi o eroare), pentru a nu sta sa mutati fiecare caracter manual din editor, folositi accest query.[/color] [b]Unban all[/b]
[code] UPDATE Character SET CtlCode=0 WHERE CtlCode=1[/code]
[color=#4A4A4A]//Acest query va da unban la toate [/color][i]caracterele[/i][color=#4A4A4A] banate, nu si la conturi![/color] [b]Remove GMs[/b]
[code] UPDATE Character SET CtlCode=0 WHERE CtlCode=32[/code]
[color=#4A4A4A]//Acest query va face caracterele GameMaster normale.[/color] [color=#4A4A4A]//Pentru 0.97D sau versiunile care folosesc ca si CTL CODE la Game Master '8' folositi acest query[/color]
[code] UPDATE Character SET CtlCode=0 WHERE CtlCode=8[/code]
[b]Guild BUG[/b]
[code] UPDATE Guild SET G_Score=0 WHERE G_Score<-1[/code]
[color=#4A4A4A]//Pe unele versiuni guildurile au scoruri negative, neputand castiga waruri.[/color] [b]Stats fixer[/b]
[code] UPDATE Character SET Character.Strength=32766 WHERE Character.Strength<1[/code]
[code] UPDATE Character SET Character.Dexterity=32766 WHERE Character.Dexterity<1[/code]
[code] UPDATE Character SET Character.Vitality=32766 WHERE Character.Vitality<1[/code]
[code] UPDATE Character SET Character.Energy=32766 WHERE Character.Energy<1[/code]
[code] UPDATE Character SET Character.Leadership=32766 WHERE Character.Leadership<1[/code]
[color=#4A4A4A]//Aceste queryuri vor fixa singurele toate statsurile atata timp cat sunt mai mici de 1.[/color] [color=#4A4A4A]//Cum am zis am testat pe 0.97D dar daca imi aduc bine aminte, 'Command' este 'Leadership', sper sa nu ma insel.[/color] [color=#4A4A4A]//Pentru cei care folosesc versiuni cu max stats 65000 folositi aceste queryuri[/color]
[code] UPDATE Character SET Character.Strength=65000 WHERE Character.Strength<1[/code]
[code] UPDATE Character SET Character.Dexterity=65000 WHERE Character.Dexterity<1[/code]
[code]UPDATE Character SET Character.Vitality=65000 WHERE Character.Vitality<1[/code]
[code] UPDATE Character SET Character.Energy=65000 WHERE Character.Energy<1[/code]
[code] UPDATE Character SET Character.Leadership=32766 WHERE Character.Leadership<1[/code]
[b]Personal ID Number[/b]
[code]UPDATE MEMB_INFO SET sno__numb='' WHERE sno__numb>1[/code]
[color=#4A4A4A]//Dupa cum suna, scapati de 'Your personal id number is invalid'[/color] [color=#4A4A4A][b][color=red]Danger querys[/color][/b][/color] [b]Clear resets[/b]
[code]UPDATE Character SET Resets=0 WHERE Resets>0[/code]
[color=#4A4A4A]//Sterge toate reseturile de pe toate caracterele[/color] [b]Clear vaults[/b]
[code]UPDATE warehouse SET Items=''[/code]
[color=#4A4A4A]//Sterge toate itemele din toate valuturile[/color] [b]Clear inventory[/b]
[code]UPDATE Character SET Inventory=''[/code]
[color=#4A4A4A]//Sterge toate itemele din toate inventoryurile[/color] [b]Clear level up points[/b]
[CODE] UPDATE Character SET LevelUpPoints=0 WHERE LevelUpPoints>0[/code]

[color=#4A4A4A]//Sterge toate punctele 'free', adica cele de pe bara, care pot fii adaugate![/color]

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
  • Recently Browsing

    • No registered users viewing this page.
  • Popular Contributors

    Nobody has received reputation this week.

×
×
  • Create New...