Inserting an item from database.

[sarkoplata]

Hello community,

For example, I want to make a web-item-shop. How will add them to database programatically?

I know I should first add item to Item database, then get the item id and add to the inventory database. But I'm having problems with the 'Serial64' Column.
What should I do with it?

Thanks in advance.

[✗EpicSoul✗]

well first you need to know a lot of php,sql

you could use some easy queries to add the items to players.
-for example

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'YourCharName'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,10

this query would give the character 1 egyptian staff + 10

[sarkoplata]

Thank you, that was what i was looking for

[LemoniscooL]

yeah i knew that, but how to add magic options to the items created? like full blue and 100% on all stats?

[sarkoplata]

Originally Posted by LemoniscooL

yeah i knew that, but how to add magic options to the items created? like full blue and 100% on all stats?

Take a look at _SMC_ITEM_ADD function. (or something like that)
Or, after adding item to database you can get it's id and edit params yourself. It will be pain in the ass

Here is a quick php script to add an item to every character on the database:

PHP Code:

<?php

$a = '';
$b = 'ITEM_EU_TSTAFF_01'; // your item code. this is an example
$c = 1;                  // amount
$d = 8;                  // plusvalue +8

$connection = odbc_connect("Driver={SQL Server};Server=YOURPC\SQL;Database=YOURSHARDDATABASENAME;", "YOURSQLUSERNAME", "YOURSQLPASS");
$query = odbc_exec($connection, "SELECT * FROM _Char");

while($extracted = odbc_fetch_array($query))
{
    $a = $extracted['CharName16'];
    $stmt    = odbc_prepare($connection, "{CALL _ADD_ITEM_EXTERN('$a', '$b', '$c', '$d')}");
    $success = odbc_execute($stmt, array());
    
}

?>

[✗EpicSoul✗]

Originally Posted by sarkoplata

Take a look at _SMC_ITEM_ADD function. (or something like that)
Or, after adding item to database you can get it's id and edit params yourself. It will be pain in the ass

Here is a quick php script to add an item to every character on the database:

PHP Code:

<?php

$a = '';
$b = 'ITEM_EU_TSTAFF_01'; // your item code. this is an example
$c = 1;                  // amount
$d = 8;                  // plusvalue +8

$connection = odbc_connect("Driver={SQL Server};Server=YOURPC\SQL;Database=YOURSHARDDATABASENAME;", "YOURSQLUSERNAME", "YOURSQLPASS");
$query = odbc_exec($connection, "SELECT * FROM _Char");

while($extracted = odbc_fetch_array($query))
{
    $a = $extracted['CharName16'];
    $stmt    = odbc_prepare($connection, "{CALL _ADD_ITEM_EXTERN('$a', '$b', '$c', '$d')}");
    $success = odbc_execute($stmt, array());
    
}

?>

nice !!

[LemoniscooL]

yeah well thats an easy one .. also what use does it have to add an tem to all chars on server? Oo if you want to build an item shop online you need something that will add an item into an accounts storage (chest in smc) maybe ill write a small script for that later

[sarkoplata]

Originally Posted by LemoniscooL

yeah well thats an easy one .. also what use does it have to add an tem to all chars on server? Oo if you want to build an item shop online you need something that will add an item into an accounts storage (chest in smc) maybe ill write a small script for that later

web-shop was an example to explain. The script does my job^^