- script testdbidquery -1,{
OnInit:
bindatcmd "dbid", strnpcinfo(3)+"::OnDBTest",0,90;
end;
OnDBTest:
.@itemtoget = getequipid(8);
.@itemtype = getiteminfo( .@itemtoget, 17 );
.@query$ = "SELECT `id`,`char_id`,`nameid`,`refine`,`unique_id`";
.@query$ += " From `inventory` WHERE `nameid` = "+.@itemtype;
.@ab = query_sql(.@query$, .@id, .@charid, .@itemid, .@refinelevel, .@unique);
dispbottom "~ id: "+.@id;
dispbottom "~ char name: "+strcharinfo(0);
dispbottom "~ item name: "+getitemname(.@itemid);
dispbottom "~ refine: +"+.@refinelevel;
dispbottom "~ unique id: "+.@unique;;
end;
}