viewing paste Unknown #55564 | Athena

Posted on the
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
-   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;
}
Viewed 1265 times, submitted by mnjfx.