[Help]See inside

[kenjii012]

can someone help me how to set cash and GP

via SQL??

need answers ASAP


thx in advance

 

[shiningriver]

There's a table there... I think it's dbo.GoodsListInfo There's a column there that says "Cash", with allowed values of "True" or "False" (boolean). Change all of them to "False" so you won't have to deal with cash...

this is the only method I know. sorry.

 

[DF08Said]

There's a table there... I think it's dbo.GoodsListInfo There's a column there that says "Cash", with allowed values of "True" or "False" (boolean). Change all of them to "False" so you won't have to deal with cash...

this is the only method I know. sorry.

Offtopic- Do i know u..?
Second i like ur style u have Figured out stuff allready. Second yes its Dbo.goodslistinfo. u can edit the cash to GP if thats what u wish to do insteed of Cash. Else u can get the Cash Working like i did but that u will have to figure out yourself ;D

 

[shiningriver]

Offtopic:
I do not know if you know me.

Anyway, if you're dearly serious, you can code yourself a program that directly accesses your account file. Could be possible with Visual.Net++

 

[kent666]

@kenjii012
OR for cash, you can use the webshop like Metalknuxx Webshop posted here http://forum.ragezone.com/f538/metalknuxx-webshop-532885/

For items in the server side editing you can go to dbo.GoodsInfoList. Everything is in there from price to stats and that's server side. Just check it out.

 

[kenjii012]

what i mean is how to edit CASH AND GP IN GAME??

 

[shiningriver]

Ah.
Try making a column under the dbo.users table, named "Cash", value: int, not null. Put in a value there, any amount. try and see if it will work.

 

[kenjii012]

not working...

 

[invalidphp]

are you trying to make it usable to the public? if it's just you (or those with access to the SQL database) you could just use the table, the goodsinfo I think, the one with the long list of Item ID's, find the one you want and add them to your inventory in the other goods table.

if you want to have this public and in game, then I'm not sure yet, I'm trying to do that also. lol