Connect Item and Stored Procedur

[BlackNova]

Is there a way to do this ?
How does a Skill reset item or smth like this work ?
Im already looking for it but cant find a column like that. Would be nice if know how to do smth like that.

edit: or Inventory Expension item

[MentaL]

[benike1]

these functions/triggers are coded into the gameserver.

[ZeAphexTwin]

That one is easy, problem is if i want a scroll to teleport so the effect will be activated..

[Royalblade]

If you want to create an item that teleports you or does something else.... you can check the GS.exe itself... your name title says "I love coding" so you might wanna look into it.
Just found something intrested... most likely its linked to the Char Skin Change Scroll...

LABEL_17:
    v11 = *(_DWORD *)(a2 + 52);
    if ( a1 != *(_DWORD *)(v11 + 40) )
    {
      if ( dword_DC0F44 & 1 )
        *(_DWORD *)(v11 + 40) = a1;
      else
        sub_9CE0C0();
    }
    v12 = *(_DWORD *)(a2 + 52);
    if ( a3 != *(_BYTE *)(v12 + 100) )
    {
      if ( dword_DC0F44 & 1 )
        *(_BYTE *)(v12 + 100) = a3;
      else
        sub_9CE0C0();
    }
    *(_DWORD *)(*(_DWORD *)(a2 + 52) + 24) = 0;
    (*(void (**)(void))(**(_DWORD **)(a2 + 52) + 36))();
    v13 = *(_DWORD *)(a2 + 52);
    v14 = *(_DWORD *)(v13 + 12);
    *(_DWORD *)(v13 + 8) |= 0x20u;
    *(_DWORD *)(v13 + 12) = v14;
    v15 = (*(int (__thiscall **)(int))(*(_DWORD *)a2 + 960))(a2);
    if ( !sub_426000("UPDATE _CHAR SET REFOBJID = %d, SCALE = %d WHERE CHARID = %d", a1, a3, v15) )
    {
      sub_444730(&v18);
      (*(void (__thiscall **)(int, signed int))(*(_DWORD *)a2 + 1384))(a2, 64);
      if ( *(_DWORD *)(a2 + 7396) )
      {
        v16 = (*(int (__thiscall **)(int))(*(_DWORD *)a2 + 960))(a2);
        sub_601D20(*(_DWORD *)(a2 + 7396), v16, 7, a1);
      }
      sub_4ED130(a2, 0, 1, 3u, 1.0, 4);
      return 1;
    }
    sub_9CE0C0();
    return 2;
  }