[Arcturus] - To add a item in bank

[Twilight]

The [GUIDE]. Acturus:
We add a item in bank of an account.
1. Clear bank of items.
2. We add in bank the items which is necessary.
3. It is necessary to define a code of a item executed a command:

select ' 0x ' +upper (SHO.dbo.ufn_VarbinaryToVarcharHex ((select blobITEMS from SHO.. tblGS_BANK where txtACCOUNT ='accountname ')))

accountname - it is necessary to change to your or any another.
We have received a code of a :
0x0A3E0100000000000000000000000000000000000000000000000000.....
4. Now using stored procedure it is possible to add a item independently using php or other programming language.

exec sp_warehousedeposit 'accountname', '0A3E0900000000000000000000'

 

[Flowan]

How can you put an item into the platinum storage? And how do you use a stored procedure with php?

Thanks in advance.

 

[Flowan]

Anyone? :x

 

[Twilight]

And how do you use a stored procedure with php?

Thanks in advance.

<?
//***** IME - (ITEM MALL ENGINE)******

//Config----------------------------
$mysecretfile='LogItemMallProcess.txt';
$myServer = "IPDB";
$myUser = "DBUSER";
$myPass = "DBPASSWD";
$myDB = "SHO";

echo "Add item and All Close\r\n";
//Data from FORM------------------
$AccountName=$_POST['username'];
echo $AccountName . "-";
$ItemCode=$_POST['BinCode'];
echo $ItemCode;
$conn=mssql_connect($myServer,$myUser,$myPass);
mssql_select_db($myDB);
$sql = "exec sp_warehousedeposit \"$AccountName\",\"$ItemCode\"";
$res = mssql_query($sql);
if(!$res) {
   die("ERROR!");
mssql_close($conn);
} else {
mssql_close($conn);
$f=fopen($mysecretfile,"a");
fputs($f, "User -".$AccountName." ItemCode - ".$ItemCode.' '.date("d.m.Y H:i",time())."\r\n");
fclose($f);
print "Tnx!!!";
}
?>

 

[Twilight]

The small engine. The tool.
Test, add, modify.
It is free.
PS:
Unfortunately I have no a lot of time for creation of the big engine.

 

[buzbee]

great release..

unfortunately i have a small problem

Add item and All Close
buzbee2 - A3E01000000000000000000000
Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'SHO.dbo.ufn_VarbinaryToVarcharHex'. (severity 16) in C:\xampp\htdocs\xxxx\CloseAll.php on line 21

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'SHO.dbo.ufn_VarbinaryToVarcharHex'. (severity 16) in C:\xampp\htdocs\xxxx\CloseAll.php on line 21

Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near the keyword 'WHERE'. (severity 15) in C:\xampp\htdocs\xxxx\CloseAll.php on line 21

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\xxxx\CloseAll.php on line 21

it seems to place the item in my storage, but it also isnt an item
hover over it and game crashes

 

[Twilight]

great release..

unfortunately i have a small problem

Add item and All Close
buzbee2 - A3E01000000000000000000000
Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'SHO.dbo.ufn_VarbinaryToVarcharHex'. (severity 16) in C:\xampp\htdocs\xxxx\CloseAll.php on line 21

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'SHO.dbo.ufn_VarbinaryToVarcharHex'. (severity 16) in C:\xampp\htdocs\xxxx\CloseAll.php on line 21

Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near the keyword 'WHERE'. (severity 15) in C:\xampp\htdocs\xxxx\CloseAll.php on line 21

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\xxxx\CloseAll.php on line 21

it seems to place the item in my storage, but it also isnt an item
hover over it and game crashes

1. Delete row in tblGS_BANK whit name buzbee2 for correct crash
2. Delete row in item_mail
3. New query

INSERT INTO item_mall (ItemName,BinCode,Description,ItemCount) VALUES('Christmas Tree','0A3E0100000000000000000000','Christmas Tree 1',1)

PS: i repack attach...
sorry..I wish to sleep..

and warning..u need setup output warnings on web server//or use ini_set("display_errors","0"); //disable warning in php scripts...

You must be registered to see links

oh ZZzzzzzzz.................

 

[buzbee]

okay im not understanding this i guess
0A3E01 = the item id in hex?

0A = 10 = usable items

3E = 62????

what i am not understanding is how you get the item id in hex

i have tried several different ways to do this but i am still stuck

if you could help i would appreciate it

 

[buzbee]

bump?

 

[mime]

You can try this. To get the hex id for the item, put the item in the storage. Open "tblGS_BANK" tables in your "SHO" or whatever your named it in MSSQL database. Open blob field, then you can see the hex for you item. Use EMS SQL Manager to view blob field.

 

[buzbee]

okay i was finally able to get my items to show up

i had to edit something in the user defined functions, ufn_varbinarytovarcharhex
its was still trying to find SHO and obviously my database isnt named SHO anymore

now can someone give me a clue as to making the item drop in the platinum storage tab,
dont like the idea of overwriting existing items in the bank

 

[HKRnew]

Add item and All Close
HKRnewADM - 0A3E0100000000000000000000
Warning: mssql_query() [function.mssql-query]: message: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). (severity 16) in D:\xampplite\htdocs\rose\CloseAll.php on line 21

Warning: mssql_query() [function.mssql-query]: Query failed in D:\xampplite\htdocs\rose\CloseAll.php on line 21
ERROR!

 

[Purpleyouko]

I may be wrong but it looks like you have too many open queries.

You might need to close some of your queries with mssql_close(); in your php code

 

[daniel369]

i'm geting this error:
Add item and All Close

name - 0A3E0100000000000000000000
Warning: mssql_query() [function.mssql-query]: message: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). (severity 16) in C:\AppServ\www\mall\CloseAll.php on line 15

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\mall\CloseAll.php on line 15
ERROR!

And i have no idea why -.-

 

[buzbee]

try adding some more items to your db

seems after i added all my items the error stopped displaying

 

[daniel369]

can you give me some random codes?
have no idea how get them

 

[MasterofOrder]

Ok here is what you do open up windows notepad and put this line it.

select ' 0x ' +upper (SHO.dbo.ufn_VarbinaryToVarcharHex ((select blobITEMS from SHO.. tblGS_BANK where txtACCOUNT ='accountname ')))

Then click on file in the upper left corner and go down to save as and click on that and save it to whatevername.sql

Then open up your mssql analizer and you will see a box in the middle on the tool bar make sure it say's sho or what ever you named sho.

Then goto file then click on open and click on the sql file you just made...Then click on the geen arrow that is pointing to the right.

Now you will see a box open up below the sql file box and there is your code.

I hope this helped.

 

[daniel369]

thanks .
but i already know how to do that
the thing is , i don't know what
"0A3E01" means :
10100011111000000001
int binary
so for example i want to add a T7 into some1's storage.
the id of T7 is 337
type - 11
the number of items i want , 2

so how can i do that?

 

[Twilight]

omg

thanks .
so for example i want to add a T7 into some1's storage.
the id of T7 is 337
type - 11
the number of items i want , 2

so how can i do that?

/item 11 337 1

for itemmask,weapon...etc Slot -1; Amount - 1
and
for materials,ammo,etc Slot-1;Amount - 100

The [GUIDE]. Acturus:
We add a item in bank of an account.
1. Clear bank of items.
2. We add in bank the items which is necessary.
3. It is necessary to define a code of a item executed a command:

select ' 0x ' +upper (SHO.dbo.ufn_VarbinaryToVarcharHex ((select blobITEMS from SHO.. tblGS_BANK where txtACCOUNT ='accountname ')))

 

[daniel369]

you got me all wrong..
i ment :
0A3E01
is :
10100011111000000001

so if i take a T7 , how can i get the hex value of it?
what should i write in the binry form