Guest dizzy Posted January 18, 2012 Share Posted January 18, 2012 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 More sharing options...
Recommended Posts