Hola amigos, de nuevo solicitando su ayuda, ya que cuando intento cambiar el item mall me sale un error, ya borre lo que tenia anterior mente y nada :c, y cuando intento y intento me sale el mismo error, les dejo una imagen para que vean, si alguien me puede ayudar gracias :c.
from where di you got that query o.O
its should be something like this
Quote:
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('30 Day Items','1',0,100043,1,100051,1,100053,1,100056,1,1 00072,1,100073,1,100074,1,100075,1,100076,1,100165 ,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0)
zackfail, la secuencia de comando (script) deve tener primero donde es donde vas a actualizar, es decir la tabla. Que en este case seria la tabla [PS_GameDefs].[dbo].[ProductList] ... y deve decir asi para ke sepa donde (INSERT INTO [PS_GameDefs].[dbo].[ProductList]) <- siempre deve comenzar asi ya de ahi se le ponen el valor ke vas a actualizar que en este caso por ejemplo deve ser (('30 Day Items','1',0,100043,1,100051,1,100053,1,100056,1,1 00072,1,100073,1,100074,1,100075,1,100076,1,100165 ,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0)) ese ejemplo le pone en la tabla ke el primer item en el item amll se llama "30 Day Items"..etc. Pero para que se te aga mas facil, te sujiero ke uses el programa llamado sHStudio, que se encuentra , necesitas saver como usarlo y en ese tema te explica muy bien
i dont understand what u guys saying but the answer is simple.
Just add
Code:
USE [PS_GameDefs]
in first line of your query.
Hi zokylove, yes i already explained to him that part on the last post, and told him he should use the shstudio program but according to him it doesnt work. lol i think hes doing some things wrong or still doesnt have good knowledge about how to use it
Quote:
Originally Posted by zackfail
es el que intento usar pero no me sirve :c
zack porque dices que no funsiona?, te da el script o no?, para usarlo deves tener el Cash.sdata abierto con ese programa, y cuando lo abra de ahi debes hacer los cambios, y cuando le haces click a Save (guardar), el script te deve salir automaticamente en la carpeta donde configuraste que se aguarde
<< Just add USE [PS_GameDefs] >>
incorrect, the error msg is NOT "base / table not found".
<< use the shstudio program but according to him it doesnt work >>
shStudio does word, but it does not replace the user's brain (already explained too).
the error message is "THE NUMBER OF COLUMNS DO NOT MATCH" !!
is it that hard to read ???
I already explain, several times, that some tables around there do contain an identity RowID column and other don't contain it, or don't set it as identity.
the SQL script generated by shStudio can NOT contain more information - it can NOT be more comprehensible not understandable - because it does include the name of used columns -- the first advice "INSERT INTO [PS_GameDefs].[dbo].[ProductList] values (foo, bar, thing)" was a bad mind since it miss these columns name and thus does a lot of assumptions.
so compare your table structure with the insert statement and fix your table.
<< Just add USE [PS_GameDefs] >>
incorrect, the error msg is NOT "base / table not found".
<< use the shstudio program but according to him it doesnt work >>
shStudio does word, but it does not replace the user's brain (already explained too).
the error message is "THE NUMBER OF COLUMNS DO NOT MATCH" !!
is it that hard to read ???
I already explain, several times, that some tables around there do contain an identity RowID column and other don't contain it, or don't set it as identity.
the SQL script generated by shStudio can NOT contain more information - it can NOT be more comprehensible not understandable - because it does include the name of used columns -- the first advice "INSERT INTO [PS_GameDefs].[dbo].[ProductList] values (foo, bar, thing)" was a bad mind since it miss these columns name and thus does a lot of assumptions.
so compare your table structure with the insert statement and fix your table.
Talking about the brain.exe castor i used google translator and translated this part:
Code:
No se encuentra el objeto "ProductList" porque no existe o no tiene permision.
Table ProductList do not exist or user dont have permision,so or hi using the wrong database,or user dont have owner permision.And if u take a carefull look at pic hi is trying to run the query using master db.
Actually the Error Msg says "El Nombre de Objeto [Productlist] no es valido" or "the Name of object [Productlist] is not valid... still not sure if thats what you were reffering to castor, if it wasnt then disregard this. But everything else.... yes indeed you are right
This is actually, once again, the perfect prototype of a question for which several persons spend time to imagine all possible conditions and propose solutions while only the author can know the exact reason of his error and would be a great effort of about 5 seconds to fix it ... once again.
the combo present in the SQL editor icon-bar indicates that the "master" schema is selected, and zack would need 5 sec. to select the right base.
mira
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('30 Day Items','1',0,100043,1,100051,1,100053,1,100056,1,1 00072,1,100073,1,100074,1,100075,1,100076,1,100165 ,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0)
en ese esta bien pero le falta una cosa realmente es asi
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('30 Day','Items','1',0,100043,1,100051,1,100053,1,1000 56,1,100072,1,100073,1,100074,1,100075,1,100076,1, 100165 ,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0)
this problem is because instead of Master had to select PS_GameDefs would do this if the problem would not have found, for a correct use ShStudio use the cash that works 100%
ESTO FUNCIONA ASI
INSERT INTO [PS_GameDefs].[dbo].[ProductList] values ('30','Day Items','1',0,100043,1,100051,1,100053,1,100056,1,1 00072,1,100073,1,100074,1,100075,1,100076,1,100165 ,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0)
solo debes agregar despues del primer nombre ',' esto y ya esta
Item Mall Dc Bug 10/10/2019 - SRO Private Server - 7 Replies yo , i had this prob before , but when i made a new server , i got this , last time i fixed it by renaming dbs , but now its not working , wht can i do ?
btw the error is u buy something from item mall u get dc , when u login u find the item in ur inv and the silks are not removed .
Please help me for mod the item mall 08/23/2013 - Shaiya Private Server - 23 Replies Hi all.
I have a problem with the item shop.
I launched shaiya data file tool, I selected the data file in directorty of my game
With shaiya data file tool I extracted the data.saf on my desktop.
As soon as he finished, I opened sh study.
I opened the file Cash, I modified the costs of the item.
I On the server, I launched the game.exe but wrong.
tells me can not find the item.
How do I?
I have to connect to the database?
[Mall] Item Mall Problem 02/01/2013 - SRO Private Server - 0 Replies when buying items in ITEM MALL = dc
but have item in inv after log in again
we want fix it
[REQUEST] Item mall item for 0 silk 12/02/2011 - SRO Private Server - 11 Replies Hello ,
I am trying to make some item mall items to 0 silk but there is a problem when i put the cost to 0 silk the users can not purchase the items.
Only cost to 1 or more is working ...
Any idea where is the restriction about this ( maybe a stored procedure ? )
Cordialy,
[Help] Item Mall 05/03/2011 - Shaiya - 1 Replies Just a quick question... how Do i add things to the item mall and add different tabs????
If ineed software please say the names and if you can a d/l link :)
, necesitas saver como usarlo y en ese tema te explica muy bien
