Printable View
Hello,Ragezoner.
Simple query to change inventorysize by character name. Enjoy
PHP Code:USE [SRO_VT_SHARD_INIT]
GO
--by Atossuper
Declare @CharName Varchar (64)
Set @CharName = 'Put Chr name here'
UPDATE dbo._Char
--change 77 to any number you want for make 3 inv put number 109
SET InventorySize= 77
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
USE SRO_VT_SHARD --shard db name
update _Char set InventorySize = 109 where CharName16 = 'Charname'
IF you put more than 109 > crash on login :)
this query is much easier idk why you are using CharID and making it so complicated :)
Hmp, thats a nice query if you want all chars to start with max inv space. Just put this quert inside the make char procedure, alter the name to fit the procesure and ur rdy to go ^^
You are right!!
I need help about something guys i will be very thankful for the person who will help me.
i registerd my web site at paymentwall and they asked me about valude after uid and i puted Struserid and they replay to me and said its wrong, anyone can help me and explain what i have to do exactly to make the payment work. couse they did not approve it till i fix this problem.
<iframe src="http://wallapi.com/api/ps/?key=d1db9d0244b4018c4056a56e4cc88b4b&uid=[StrUserID]&widget=p4_1" width="610" height="450"
That depends on the pingback script you have made for charge the silk, if you dont know the basis of asp and sql forget about making your server work with paymentwall.Quote:
Originally Posted by atossuper