[AYUDA] Problemas en Servidor

Quote:

Originally Posted by adm..rouser erick ya no le contestes mas a estos pelotudos. esta lleno de ellos. cuando andes por skype pasa a saludar.

Quote:

Originally Posted by elitevepersst Hola, disculpen las molestias tengo un par de inconvenientes en mi servidor, y queria saber si alguien tiene alguna sugerencia o solución, La primera es con los altares su hp queda bugeada y solo se ve una pequeña parte de ella pareciendo que el altar esta por morir y la segunda es como evitar que el player sube de nivel tan rapido durante pvp? trate de elevar la experiencia desde dbo.ExpDefs y no da resultado alguno el cambio. ---------------------------------English---------------------------------- Hi, sorry I have a couple of drawbacks to my server, and wanted to know if anyone has any suggestions or solutions, the first is with the altars their hp is bugeada and only a small part of it is looking to the altar this by die and the second is how to prevent the player level up so fast during pvp? try to elevate the experience from dbo.ExpDefs and does not give any result change.

• PS_GameDefs < Tables < dbo.Mobs, Script Table as, SELECT TO, New Query, le das a ejecutar y abajo te aparece la lista, entonces, Save Reults as, lo guardas como Mobs y al costado de "Save" aparece una pestañita, le das a esa y en la lista le das a ANSI

• PS_GameDefs < Tables < dbo.MobsItems, y haces lo mismo ( Esto es para que despues no se reseteen tus drops y quede guardado en la edicion

• Despues abris tu ShStudio, e importas los dos archivos que te dije antes, Mobs y MobsItems, de ahi editas y se te va a guardar un archivo . SQL, entonces con eso actualizas para que coincidan tanto cliente como tu
  Base de datos

 Originally Posted by ShaiyaHaven View Post
Just use the SELECT function to grab the info you want:
Code:

SELECT * FROM PS_DatabaseName.dbo.TableName

Fill in the DatabaseName and TableName parts with the real DB and Table names, obviously; like PS_GameData.dbo.Chars, or PS_GameDefs.dbo.Mobs, etc.

Before the next step, make sure you have SQL set to save the headers of the table, if you need them (if not, skip this). If this is for ShStudio, you will indeed have to do this. You'll find the option here:

       SQL Management Studio Tools menu > Options > Query Results > SQL Server > Results to Grid > check box for "Include column headers when copying or saving the results" > Ok


You may want to restart Management Studio to make sure those changes take effect, in which case you will need to run the SELECT query again before moving on. Then, click on the top left square of the results window, the one that highlights the entire results grid. Right click, Save Results As... The save window pops up. Just make sure the file type is CSV, and you're good to go.

[B]If this is specifically for making a Monster.EX for ShStudio, it goes a little further. Type the name of the file (Mobs or MobItems). Instead of just hitting the "Save" button, click the tiny black arrow next to it and select "Save with encoding". Change the dropdown option to ANSI, then hit OK and it should save. Then open the Monster.Sdata and File > Import, import BOTH files before saving, then save. A Monster.EX should have been generated.[/B]

Good luck to you on your journey!