Help gm permissions

[xyoyx]

Hi all,

I have a problem, i have new p-serv and I attempt to be gm, so i go on charac table and change permission to 1. don't work.
After i see a table "Allowedcommandforpermission" but the table is empty, i search a little on the forum and i find that code :

 Spoiler

use Telecaster
update dbo.Character
set permission = 1
where sid = 5

but when i run the query write "0 Rows affected" so i don't know how i can be gm, help me please :3

bye and ty

ps:sorry for my bad english

[Player95]

GM permission is 100.

[xyoyx]

I have solved my problem, i will show you :

I use this code :

 Spoiler

USE [Telecaster]
GO
/****** Object: Table [dbo].[AllowedCommandsForPermission] Script Date: 03/06/2012 00:07:18 ******/
DROP TABLE [dbo].[AllowedCommandsForPermission]
GO
/****** Object: Table [dbo].[AllowedCommandsForPermission] Script Date: 03/06/2012 00:07:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AllowedCommandsForPermission](
[sid] [int] NULL,
[permission] [int] NULL,
[command] [varchar](max) NULL,
[parameter] [varchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (1, 1, N'suicide', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (2, 1, N'set_huntaholic_point', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (3, 1, N'show_huntaholic_lobby_window', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (4, 1, N'exit_huntaholic_lobby', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (5, 1, N'warp_to_huntaholic_lobby', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (6, 1, N'show_auction_window', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (7, 1, N'reset_summon_skill', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (8, 1, N'creature_name_change_box', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (9, 1, N'get_creature_name_id', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (10, 1, N'set_continuous_play_time', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (11, 1, N'set_pcbang_user', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (12, 1, N'donation_reward', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (13, 1, N'show_donation_prop', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (14, 1, N'update_gold_chaos', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (15, 1, N'get_local_info', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (16, 1, N'open_popup_and_set_size', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (17, 1, N'open_popup', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (18, 1, N'open_url', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (19, 1, N'clear_auto_account', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (20, 1, N'set_auto_account', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (21, 1, N'set_auto_user', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (22, 1, N'find_npc', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (23, 1, N'get_server_category', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (24, 1, N'warp_to_revive_position', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (25, 1, N'recall_feather', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (26, 1, N'set_way_point_speed', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (27, 1, N'set_way_point_type', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (28, 1, N'add_way_point', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (29, 1, N'draw_tax_chaos', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (30, 1, N'draw_tax', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (31, 1, N'get_tax_chaos_amount', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (32, 1, N'get_tax_amount', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (33, 1, N'set_tax_rate', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (34, 1, N'get_tax_rate', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (35, 1, N'get_dungeon_relation', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (36, 1, N'get_own_guild_name', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (37, 1, N'get_guild_block_time', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (38, 1, N'set_guild_block_time', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (39, 1, N'is_guild_leader', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (40, 1, N'update_guild_info', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (41, 1, N'show_channel_set', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (42, 1, N'equip_summon_card', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (43, 1, N'get_summon_name_id', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (44, 1, N'get_layer_of_channel', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (45, 1, N'get_user_count_in_channel', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (46, 1, N'get_max_channel_num', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (47, 1, N'get_min_channel_num', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (48, 1, N'get_proper_channel_num', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (49, 1, N'creature_learn_skill', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (50, 1, N'call_lc_In', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (51, 1, N'creature_evolution', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (52, 1, N'get_npc_handle', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (53, 1, N'get_npc_id', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (54, 1, N'check_valid_alliance_name', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (55, 1, N'destroy_alliance', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (56, 1, N'create_alliance', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (57, 1, N'check_valid_guild_name', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (58, 1, N'force_promote_guild_leader', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (59, 1, N'force_change_guild_name', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (60, 1, N'show_alliance_create', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (61, 1, N'show_guild_create', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (62, 1, N'destroy_guild', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (63, 1, N'create_guild', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (64, 1, N'get_user_count_near', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (65, 1, N'open_storage', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (66, 1, N'get_creature_handle', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (67, 1, N'get_string', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (68, 1, N'get_env', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (69, 1, N'set_env', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (70, 1, N'remove_cstate', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (71, 1, N'add_cstate', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (72, 1, N'remove_state', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (73, 1, N'get_state_level', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (74, 1, N'add_state', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (75, 1, N'is_changeable_job', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (76, 1, N'message', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (77, 1, N'sconv', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (78, 1, N'show_creature_dialog', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (79, 1, N'get_base_skill_level', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (80, 1, N'learn_creature_all_skill', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (81, 1, N'learn_all_skill', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (82, 1, N'learn_skill', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (83, 1, N'refresh', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (84, 1, N'gametime', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (85, 1, N'open_market', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (86, 1, N'get_monster_id', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (87, 1, N'set_next_attackable_time', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (88, 1, N'monster_skill_cast', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (89, 1, N'respawn_near_monster', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (90, 1, N'save', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (91, 1, N'delete_block_account', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (92, 1, N'shutdown', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (93, 1, N'saveall', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (94, 1, N'setspeed', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (95, 1, N'get_siege_dungeon_id', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (96, 1, N'get_own_dungeon_id', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (97, 1, N'clear_dungeon_core_guardian', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (98, 1, N'change_dungeon_owner', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (99, 1, N'drop_dungeon_owner_ship', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (100, 1, N'enter_dungeon', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (101, 1, N'request_dungeon_raid', N'')
GO
print 'Processed 100 total records'
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (102, 1, N'change_tactical_position_owner', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (103, 1, N'show_dungeon_stone', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (104, 1, N'respawn_guardian_object', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (105, 1, N'is_in_siege_dungeon', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (106, 1, N'recall_player', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (107, 1, N'whisper', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (108, 1, N'kill_target', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (109, 1, N'kill', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (110, 1, N'raid_respawn_rare_mob', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (111, 1, N'raid_respawn', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (112, 1, N'respawn_roaming_mob', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (113, 1, N'respawn_rare_mob', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (114, 1, N'respawn_guardian', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (115, 1, N'respawn', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (116, 1, N'add_npc_to_world', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (117, 1, N'add_npc', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (118, 1, N'env', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (119, 1, N'force_unregister_account', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (120, 1, N'kick', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (121, 1, N'get_last_accept_quest', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (122, 1, N'get_quest_progress', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (123, 1, N'quest_info', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (124, 1, N'end_quest', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (125, 1, N'force_start_quest', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (126, 1, N'start_quest', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (127, 1, N'dlg_text_without_quest_menu', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (128, 1, N'quest_text_without_quest_menu', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (129, 1, N'dlg_show', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (130, 1, N'dlg_menu', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (131, 1, N'dlg_text', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (132, 1, N'dlg_title', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (133, 1, N'get_max_alliance_member_count', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (134, 1, N'increase_max_alliance_member_count', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (135, 1, N'is_alliance_leader', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (136, 1, N'set_pk_mode', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (137, 1, N'del_flag', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (138, 1, N'set_flag', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (139, 1, N'get_flag', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (140, 1, N'emcv', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (141, 1, N'gmcv', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (142, 1, N'gcv', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (143, 1, N'smcv', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (144, 1, N'scv', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (145, 1, N'change_creature_name', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (146, 1, N'get_creature_value', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (147, 1, N'set_creature_value', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (148, 1, N'get_all_value', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (149, 1, N'ev', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (150, 1, N'sv', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (151, 1, N'av', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (152, 1, N'gv', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (153, 1, N'echo_value', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (154, 1, N'set_value', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (155, 1, N'add_value', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (156, 1, N'get_value', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (157, 1, N'supply_event_item', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (158, 1, N'stop_event_supply', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (159, 1, N'start_event_supply', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (160, 1, N'refresh_event_supply', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (161, 1, N'event_supply', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (162, 1, N'stop_event_drop', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (163, 1, N'start_event_drop', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (164, 1, N'refresh_event_drop', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (165, 1, N'event_drop', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (166, 1, N'show_soulstone_repair_window', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (167, 1, N'get_max_item_soulstone_endurance', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (168, 1, N'get_item_soulstone_endurance', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (169, 1, N'show_soulstone_craft_window', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (170, 1, N'get_wear_item_handle', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (171, 1, N'get_item_name_id', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (172, 1, N'get_item_name_by_code', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (173, 1, N'set_socket_info', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (174, 1, N'get_socket_info', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (175, 1, N'set_item_endurance', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (176, 1, N'get_item_endurance', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (177, 1, N'get_item_price', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (178, 1, N'get_item_rank', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (179, 1, N'get_item_enhance', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (180, 1, N'set_item_enhance', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (181, 1, N'set_item_level', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (182, 1, N'get_item_level', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (183, 1, N'get_item_code', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (184, 1, N'get_item_name', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (185, 1, N'get_item_handle', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (186, 1, N'has_item', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (187, 1, N'insert_gold', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (188, 1, N'drop_gold', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (189, 1, N'drop_item', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (190, 1, N'find_item', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (191, 1, N'is_erasable_item', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (192, 1, N'delete_item', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (193, 1, N'insert_item', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (194, 1, N'notice', N'')
INSERT [dbo].[AllowedCommandsForPermission] ([sid], [permission], [command], [parameter]) VALUES (195, 1, N'warp', N'')

After i use that :

 Spoiler

USE Telecaster
UPDATE dbo.AllowedCommandsForPermission set permission=100

Ad finally i change my char permission to 100

and it works byebye

[c1ph3r]

Originally Posted by xyoyx

I have solved my problem, i will show you :

I use this code :

 Spoiler

useless

After i use that :

 Spoiler

useless

Ad finally i change my char permission to 100

and it works byebye

Sorry to say that but you are doing it on a very difficult way. Let's check what your steps:

First you will delete your dbo.AllowedCommandsForPermission and fill it with all commands and permission 1

Then you will update dbo.AllowedCommandsForPermission permission column with permission 100 (instead of setting them to 100 in your first step)

At the end you will give permission 100 to your character.

BUT permission 100 is the internal adminpermission which will allow to execute all commands (even if your dbo.allowedcommandsforpermission table is empty)

That means the one and only step you have to do is to change your character permission to 100.