src/game/server/database/login_packages/login.plsqlh

   1 create or replace package login
   2 as
   3         type refcursor is ref cursor;
   4         subtype objectid is number;
   5
   6         procedure register_new_cluster(p_cluster_name in varchar2, p_address in varchar2, p_cluster_id out number);
   7         function get_cluster_list(p_group in number) return refcursor;
   8         function get_avatar_list (p_station_id number, p_cluster_group number) return refcursor;
   9         function get_open_character_slots(p_station_id number, p_cluster_id number) return refcursor;
  10         function get_only_open_character_slots(p_station_id number, p_cluster_id number) return refcursor;
  11         function is_cluster_at_limit(p_cluster_id number) return number;
  12         function is_account_at_limit(p_station_id number) return number;
  13         procedure delete_character(p_cluster_id number, p_character_id number, p_station_id number);
  14         procedure rename_character(p_cluster_id number, p_character_id number, p_new_name varchar2);
  15         procedure create_character(p_cluster_id number, p_station_id number, p_character_name varchar2, p_character_id number, p_template_id number, p_character_type number);
  16         function restore_character(p_cluster_id number, p_station_id number, p_character_name varchar2, p_character_id number, p_template_id number, p_character_type number) return number;
  17         procedure set_character_slots(p_cluster_id number, p_station_id number, p_slot_type number, p_num_slots number);
  18         procedure set_character_type(p_cluster_id number, p_station_id number, p_character_id number, p_slot_type number);
  19         function has_extra_character_slot(p_station_id number, p_character_type number) return number;
  20         procedure toggle_disable_character(p_cluster_id number, p_character_id number, p_station_id number, p_enabled varchar2);
  21         function enable_disable_character(p_station_id number, p_character_id number, p_enabled varchar2) return number;
  22         function get_completed_tutorial(p_station_id number) return refcursor;
  23         procedure toggle_completed_tutorial(p_station_id number, p_completed varchar2);
  24         function get_consumed_reward_events(p_station_id number) return refcursor;
  25         function get_claimed_reward_items(p_station_id number) return refcursor;
  26         function consume_reward_event(p_station_id number, p_character_id number, p_cluster_id number, p_event_id varchar2) return number;
  27         function claim_reward_item(p_station_id number, p_character_id number, p_cluster_id number, p_item_id varchar2) return number;
  28         function get_feature_id_transactions(p_station_id in number, p_cluster_id in number, p_character_id in number) return refcursor;
  29         function update_feature_id_transaction(p_station_id in number, p_cluster_id in number, p_character_id in number, p_item_id in varchar2, p_count_adjustment in number) return number;
  30 end;
  31 /
  32 grant execute on login to public;