RevCMS for Arcturus!

Page 1 of 5 12345 LastLast
Results 1 to 15 of 68
  1. #1
    Alpha Member Glee is offline
    Alpha MaleRank
    Jun 2009 Join Date
    Niagara Falls,Location
    2,243Posts

    RevCMS for Arcturus!

    RevCMS for Arcturus!
    Hey RaGEZONE Users,

    Today I'm releasing my RevCMS Edit for Arcturus Emulator

    FEATURE:

    - Removed seckey from the CMS
    - Added Report Tool (Reviewed from the Database)
    - Random Groups and Users
    - News Comments 100%

    BUGS:

    - Banned Page when banning the user from the client


    Images:











    NOTE:

    - No Housekeeping as it's being coded for Arcturus

    P.S: Please No Hate Comments as I'm still learning.

    CMS:

    Download

    SQL:

    Import This into your current Database

    NOTE: Permissions table has 11 ranks as I have more ranks in my hotel


    PHP Code:
    CREATE TABLE `cms_comments` (
      `
    idint(11NOT NULL,
      `
    articleint(11NOT NULL,
      `
    useridint(11NOT NULL,
      `
    commentvarchar(500NOT NULL,
      `
    posted_onvarchar(150NOT NULL DEFAULT '',
      `
    authorvarchar(255NOT NULL
    ENGINE=InnoDB DEFAULT CHARSET=latin1;

    -- --------------------------------------------------------

    --
    -- 
    Table structure for table `cms_news`
    --

    CREATE TABLE `cms_news` (
      `
    idint(11NOT NULL,
      `
    titlevarchar(100NOT NULL,
      `
    imagevarchar(100NOT NULL,
      `
    shortstorytext NOT NULL,
      `
    longstorytext NOT NULL,
      `
    authorvarchar(100NOT NULL,
      `
    author_idvarchar(100NOT NULL,
      `
    dateint(11NOT NULL,
      `
    typeenum('1','0'NOT NULL,
      `
    roomidvarchar(100NOT NULL,
      `
    updatedenum('0','1'NOT NULL DEFAULT '0',
      `
    publishedvarchar(60) DEFAULT NULL
    ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- 
    Dumping data for table `cms_news`
    --

    INSERT INTO `cms_news` (`id`, `title`, `image`, `shortstory`, `longstory`, `author`, `author_id`, `date`, `type`, `roomid`, `updated`, `published`) VALUES
    (1'New Updates''baw_promo.png''Updates!!''<p>\r\n    Testing 1,2,3,4,5,6,7,8,9</p>\r\n''Glee''1'1506805664'1''''0''1506805664');

    -- --------------------------------------------------------

    --
    -- 
    Table structure for table `permissions`
    --

    CREATE TABLE `permissions` (
      `
    idint(11NOT NULL,
      `
    rank_namevarchar(25NOT NULL,
      `
    levelint(2NOT NULL DEFAULT '1',
      `
    room_effectint(11NOT NULL DEFAULT '0',
      `
    log_commandsenum('0','1'NOT NULL DEFAULT '0',
      `
    prefixvarchar(5NOT NULL,
      `
    prefix_colorvarchar(7NOT NULL,
      `
    cmd_aboutenum('0','1'NOT NULL DEFAULT '1',
      `
    cmd_alertenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_allow_tradingenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_badgeenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_banenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_blockalertenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_botsenum('0','1','2'NOT NULL DEFAULT '1',
      `
    cmd_bundleenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_changenameenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_chatcolorenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_commandsenum('0','1'NOT NULL DEFAULT '1',
      `
    cmd_connect_cameraenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_controlenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_coordsenum('0','1','2'NOT NULL DEFAULT '2',
      `
    cmd_creditsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_danceallenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_diagonalenum('0','1','2'NOT NULL DEFAULT '1',
      `
    cmd_disconnectenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_ducketsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_ejectallenum('0','1','2'NOT NULL DEFAULT '2',
      `
    cmd_emptyenum('0','1'NOT NULL DEFAULT '1',
      `
    cmd_empty_botsenum('0','1'NOT NULL DEFAULT '1',
      `
    cmd_empty_petsenum('0','1'NOT NULL DEFAULT '1',
      `
    cmd_enableenum('0','1','2'NOT NULL DEFAULT '1',
      `
    cmd_eventenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_facelessenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_fastwalkenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_freezeenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_freeze_botsenum('0','1','2'NOT NULL DEFAULT '1',
      `
    cmd_giftenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_give_rankenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_haenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_halenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_ip_banenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_machine_banenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_hand_itemenum('0','1','2'NOT NULL DEFAULT '1',
      `
    cmd_happyhourenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_kickallenum('0','1','2'NOT NULL DEFAULT '2',
      `
    cmd_massbadgeenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_masscreditsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_massducketsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_massgiftenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_masspointsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_moonwalkenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_mimicenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_multienum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_muteenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_pet_infoenum('0','1','2'NOT NULL DEFAULT '2',
      `
    cmd_pickallenum('0','1'NOT NULL DEFAULT '1',
      `
    cmd_pluginsenum('0','1'NOT NULL DEFAULT '1',
      `
    cmd_pointsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_pullenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_pushenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_redeemenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_reload_roomenum('0','1','2'NOT NULL DEFAULT '2',
      `
    cmd_roomalertenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_roomcreditsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_roomeffectenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_roomgiftenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_roomitemenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_roommuteenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_roompixelsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_roompointsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_sayenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_say_allenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_setmaxenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_set_pollenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_setpublicenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_setspeedenum('0','1','2'NOT NULL DEFAULT '1',
      `
    cmd_shoutenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_shout_allenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_shutdownenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_sitdownenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_staffalertenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_staffonlineenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_summonenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_summonrankenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_super_banenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_stalkenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_superpullenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_take_badgeenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_talkenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_teleportenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_trashenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_transformenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_unbanenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_unloadenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_unmuteenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_botsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_catalogueenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_configenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_guildpartsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_hotel_viewenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_itemsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_navigatorenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_permissionsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_pet_dataenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_pluginsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_pollsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_textsenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_update_wordfilterenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_userinfoenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_word_quizenum('0','1','2'NOT NULL DEFAULT '0',
      `
    cmd_warpenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_anychatcolorenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_anyroomownerenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_empty_othersenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_enable_othersenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_see_whispersenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_superwiredenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_supporttoolenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_unkickableenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_guildgateenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_moverotateenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_placefurnienum('0','1'NOT NULL DEFAULT '0',
      `
    acc_unlimited_botsenum('0','1','2'NOT NULL DEFAULT '0' COMMENT 'Overrides the bot restriction to the inventory and room.',
      `
    acc_unlimited_petsenum('0','1','2'NOT NULL DEFAULT '0' COMMENT 'Overrides the pet restriction to the inventory and room.',
      `
    acc_hide_ipenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_not_mimicedenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_chat_no_floodenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_staff_chatenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_staff_pickenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_enteranyroomenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_fullroomsenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_infinite_creditsenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_infinite_pixelsenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_infinite_pointsenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_ambassadorenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_debugenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_chat_no_limitenum('0','1'NOT NULL DEFAULT '0' COMMENT 'People with this permission node are always heard and can see all chat in the room regarding of maximum hearing distance in the room settings (In game)',
      `
    acc_chat_no_filterenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_nomuteenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_guild_adminenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_catalog_idsenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_modtool_ticket_qenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_modtool_user_logsenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_modtool_user_alertenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_modtool_user_kickenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_modtool_user_banenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_modtool_room_infoenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_modtool_room_logsenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_trade_anywhereenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_update_notificationsenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_helper_use_guide_toolenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_helper_give_guide_toursenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_helper_judge_chat_reviewsenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_floorplan_editorenum('0','1'NOT NULL DEFAULT '0',
      `
    acc_cameraenum('0','1'NOT NULL DEFAULT '0',
      `
    cmd_wordquizenum('0','1','2'NOT NULL DEFAULT '0',
      `
    acc_room_staff_tagsenum('0','1'NOT NULL DEFAULT '0'
    ENGINE=InnoDB DEFAULT CHARSET=utf8;

    --
    -- 
    Dumping data for table `permissions`
    --

    INSERT INTO `permissions` (`id`, `rank_name`, `level`, `room_effect`, `log_commands`, `prefix`, `prefix_color`, `cmd_about`, `cmd_alert`, `cmd_allow_trading`, `cmd_badge`, `cmd_ban`, `cmd_blockalert`, `cmd_bots`, `cmd_bundle`, `cmd_changename`, `cmd_chatcolor`, `cmd_commands`, `cmd_connect_camera`, `cmd_control`, `cmd_coords`, `cmd_credits`, `cmd_danceall`, `cmd_diagonal`, `cmd_disconnect`, `cmd_duckets`, `cmd_ejectall`, `cmd_empty`, `cmd_empty_bots`, `cmd_empty_pets`, `cmd_enable`, `cmd_event`, `cmd_faceless`, `cmd_fastwalk`, `cmd_freeze`, `cmd_freeze_bots`, `cmd_gift`, `cmd_give_rank`, `cmd_ha`, `cmd_hal`, `cmd_ip_ban`, `cmd_machine_ban`, `cmd_hand_item`, `cmd_happyhour`, `cmd_kickall`, `cmd_massbadge`, `cmd_masscredits`, `cmd_massduckets`, `cmd_massgift`, `cmd_masspoints`, `cmd_moonwalk`, `cmd_mimic`, `cmd_multi`, `cmd_mute`, `cmd_pet_info`, `cmd_pickall`, `cmd_plugins`, `cmd_points`, `cmd_pull`, `cmd_push`, `cmd_redeem`, `cmd_reload_room`, `cmd_roomalert`, `cmd_roomcredits`, `cmd_roomeffect`, `cmd_roomgift`, `cmd_roomitem`, `cmd_roommute`, `cmd_roompixels`, `cmd_roompoints`, `cmd_say`, `cmd_say_all`, `cmd_setmax`, `cmd_set_poll`, `cmd_setpublic`, `cmd_setspeed`, `cmd_shout`, `cmd_shout_all`, `cmd_shutdown`, `cmd_sitdown`, `cmd_staffalert`, `cmd_staffonline`, `cmd_summon`, `cmd_summonrank`, `cmd_super_ban`, `cmd_stalk`, `cmd_superpull`, `cmd_take_badge`, `cmd_talk`, `cmd_teleport`, `cmd_trash`, `cmd_transform`, `cmd_unban`, `cmd_unload`, `cmd_unmute`, `cmd_update_bots`, `cmd_update_catalogue`, `cmd_update_config`, `cmd_update_guildparts`, `cmd_update_hotel_view`, `cmd_update_items`, `cmd_update_navigator`, `cmd_update_permissions`, `cmd_update_pet_data`, `cmd_update_plugins`, `cmd_update_polls`, `cmd_update_texts`, `cmd_update_wordfilter`, `cmd_userinfo`, `cmd_word_quiz`, `cmd_warp`, `acc_anychatcolor`, `acc_anyroomowner`, `acc_empty_others`, `acc_enable_others`, `acc_see_whispers`, `acc_superwired`, `acc_supporttool`, `acc_unkickable`, `acc_guildgate`, `acc_moverotate`, `acc_placefurni`, `acc_unlimited_bots`, `acc_unlimited_pets`, `acc_hide_ip`, `acc_not_mimiced`, `acc_chat_no_flood`, `acc_staff_chat`, `acc_staff_pick`, `acc_enteranyroom`, `acc_fullrooms`, `acc_infinite_credits`, `acc_infinite_pixels`, `acc_infinite_points`, `acc_ambassador`, `acc_debug`, `acc_chat_no_limit`, `acc_chat_no_filter`, `acc_nomute`, `acc_guild_admin`, `acc_catalog_ids`, `acc_modtool_ticket_q`, `acc_modtool_user_logs`, `acc_modtool_user_alert`, `acc_modtool_user_kick`, `acc_modtool_user_ban`, `acc_modtool_room_info`, `acc_modtool_room_logs`, `acc_trade_anywhere`, `acc_update_notifications`, `acc_helper_use_guide_tool`, `acc_helper_give_guide_tours`, `acc_helper_judge_chat_reviews`, `acc_floorplan_editor`, `acc_camera`, `cmd_wordquiz`, `acc_room_staff_tags`) VALUES
    (1'Member'10'0''''''1''0''0''0''0''0''1''0''0''0''1''0''0''1''0''0''1''0''0''1''1''1''1''1''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''2''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0'),
    (
    2'Silver VIP'10'0''''''1''0''0''0''0''0''1''0''0''0''1''0''0''0''0''0''1''0''0''1''1''1''1''1''0''0''0''0''1''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''1''1''0''0''0''0''2''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''1''1''1''1''1''1''1''0''0''0''0''0''0''0''0''0'),
    (
    3'Gold VIP'10'0''''''1''0''0''0''0''0''1''0''0''0''1''0''0''0''0''0''1''0''0''1''1''1''1''1''0''0''0''0''1''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''1''1''0''0''0''0''2''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''1''1''1''1''1''1''1''0''0''0''0''0''0''0''0''0'),
    (
    4'Event Staff'10'1''''''1''0''0''0''0''0''1''0''0''0''1''0''0''0''0''0''1''0''0''1''1''1''1''1''0''0''0''0''1''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''1''1''0''0''0''0''2''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''1''1''1''1''1''1''1''0''0''0''0''0''0''0''0''0'),
    (
    5'Trial Moderator'10'1''''''1''0''0''0''0''0''1''0''0''0''1''0''0''0''0''0''1''0''0''1''1''1''1''1''0''0''0''0''1''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''1''1''0''0''0''0''2''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''1''1''1''1''1''1''1''0''0''0''0''0''0''0''0''0'),
    (
    6'Moderator'10'1''''''1''0''0''0''0''0''1''0''0''0''1''0''0''0''0''0''1''0''0''1''1''1''1''1''0''0''0''0''1''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''1''1''0''0''0''0''2''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0''0'),
    (
    7'Senior Moderator'10'1''''''1''1''0''1''1''1''1''1''0''1''1''0''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''0''1''0''0''0''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''2''0''0''1''0''1''0''0''0''1''1''0''0''1''1''1''1''1''1''0''1''1''1''0''1''1''0''1''1''1''0''1''1''0''0''1''1''1''0''1''0''1''1''1''0''1''1''1''0''1''1''1''0''0''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''0''0''0''0''0''0''1''0''0'),
    (
    8'Administrator'10'1''''''1''1''1''1''1''1''1''0''1''1''1''0''0''2''1''0''1''0''1''2''1''1''1''1''1''1''1''1''1''0''0''1''1''1''0''1''0''2''0''0''0''0''0''1''1''0''1''2''1''1''0''1''1''1''2''1''0''0''0''0''1''0''0''0''0''0''0''0''1''0''0''0''1''1''1''1''0''1''1''0''0''0''0''0''0''0''0''1''0''0''0''0''0''0''0''0''0''0''0''0''0''1''0''0''1''1''0''0''1''1''1''1''1''0''0''0''0''0''0''0''1''1''0''0''0''0''0''0''0''0''0''0''0''0''1''1''1''1''1''1''1''0''0''0''0''0''0''1''0''0'),
    (
    9'Managers'10'1''''''1''1''1''1''1''1''1''1''1''1''1''1''0''2''1''1''1''1''1''2''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''2''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''2''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''0''0''0''0''0''0''0''1''0''1''1''1''1''1''1''1''1''0''1''1''1''1''1''1''0''0''1''1''0''0''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1'),
    (
    10'Co-Owners'10'1''''''1''1''1''1''1''1''1''1''1''1''1''1''1''2''1''1''1''1''1''2''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''2''1''1''1''1''1''1''1''1''1''2''1''1''1''1''1''1''2''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1'),
    (
    11'Owner'10'1''''''1''1''1''1''1''1''1''1''1''1''1''1''1''2''1''1''1''1''1''2''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''2''1''1''1''1''1''1''1''1''1''2''1''1''1''1''1''1''2''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1''1');

    --
    -- 
    Indexes for dumped tables
    --

    --
    -- 
    Indexes for table `cms_comments`
    --
    ALTER TABLE `cms_comments`
      
    ADD PRIMARY KEY (`id`);

    --
    -- 
    Indexes for table `cms_news`
    --
    ALTER TABLE `cms_news`
      
    ADD PRIMARY KEY (`id`);

    --
    -- 
    Indexes for table `permissions`
    --
    ALTER TABLE `permissions`
      
    ADD PRIMARY KEY (`id`);

    --
    -- 
    AUTO_INCREMENT for dumped tables
    --

    --
    -- 
    AUTO_INCREMENT for table `cms_comments`
    --
    ALTER TABLE `cms_comments`
      
    MODIFY `idint(11NOT NULL AUTO_INCREMENT;
    --
    -- 
    AUTO_INCREMENT for table `cms_news`
    --
    ALTER TABLE `cms_news`
      
    MODIFY `idint(11NOT NULL AUTO_INCREMENTAUTO_INCREMENT=2;
    --
    -- 
    AUTO_INCREMENT for table `permissions`
    --
    ALTER TABLE `permissions`
      
    MODIFY `idint(11NOT NULL AUTO_INCREMENTAUTO_INCREMENT=12;COMMIT;

    CREATE TABLE `staff_report` (
      `
    idint(10UNSIGNED NOT NULL,
      `
    complaintvarchar(64) DEFAULT NULL,
      `
    staffvarchar(25) DEFAULT NULL,
      `
    explanationtext NOT NULL,
      `
    moreinfotext NOT NULL
    ENGINE=InnoDB DEFAULT CHARSET=utf8;

    --
    -- 
    Dumping data for table `staff_report`
    --

    INSERT INTO `staff_report` (`id`, `complaint`, `staff`, `explanation`, `moreinfo`) VALUES
    (1'Complaint against a member of staff''MOD-AccountTest''rejhkerhjkerthkjrtkhj''jfrjkhfdhjkdfhjkfgdkhjgfjkh');

    --
    -- 
    Indexes for dumped tables
    --

    --
    -- 
    Indexes for table `staff_report`
    --
    ALTER TABLE `staff_report`
      
    ADD PRIMARY KEY (`id`);

    --
    -- 
    AUTO_INCREMENT for dumped tables
    --

    --
    -- 
    AUTO_INCREMENT for table `staff_report`
    --
    ALTER TABLE `staff_report`
      
    MODIFY `idint(10UNSIGNED NOT NULL AUTO_INCREMENTAUTO_INCREMENT=2;COMMIT
    Credits:
    @The General - Arcturus Emulator
    @Glee - Customize RevCMS for Arcturus Emulator
    Retro Community for assisting me PHP Coding from the Help Section! :)

    If you have suggestion to add into the CMS please let me know!

    PS2: I'm willing to make some badges for your hotel to host on the staff page!! It might take some time as I do have a life!

    UPDATES:

    go into includes/subnavi.php and remove

    PHP Code:
    // 
    from the beginning

    Coded Home.php with Publish of the Camera!

    Replace your old home.php with this

    - Selects the badges and Camera Images

    PHP Code:
    <!DOCTYPE html>
    <html lang="en">
        <head>
            <meta http-equiv="content-type" content="text/html; charset=utf-8">
            <title>{hotelName} - {username}</title>
            
            <link rel="shortcut icon" href="https://images.boon.pw/web-gallery/v2/favicon.ico" type="image/vnd.microsoft.icon"/>
    <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/common.css" type="text/css"/>

    <script src="{url}/app/tpl/skins/Habbo/js/libs2.js" type="text/javascript"></script>
    <script src="{url}/app/tpl/skins/Habbo/js/visual.js" type="text/javascript"></script>
    <script src="{url}/app/tpl/skins/Habbo/js/libs.js" type="text/javascript"></script>
    <script src="{url}/app/tpl/skins/Habbo/js/common.js" type="text/javascript"></script>
    <script src="{url}/app/tpl/skins/Habbo/js/fullcontent.js" type="text/javascript"></script>

            <script type="text/javascript">
                document.habboLoggedIn = true;
                var habboName = "{username}";
                var habboId = {userid};
                var habboReqPath = "";
                var habboStaticFilePath = "{url}/app/tpl/skins/Habbo";
                var habboImagerUrl = "http://www.habbo.com/habbo-imaging/";
                var habboPartner = "";
                var habboDefaultClientPopupUrl = "{url}/client";
                window.name = "habboMain";
                if (typeof HabboClient != "undefined") {
                    HabboClient.windowName = "eac955c8dbc88172421193892a3e98fc7402021a";
                    HabboClient.maximizeWindow = true;
                }
            </script>

    <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/home.css" type="text/css"/>
    <link href="{url}/app/tpl/skins/Habbo/styles/other.css" type="text/css" rel="stylesheet"/>
    <link href="{url}/app/tpl/skins/Habbo/styles/backgrounds.css" type="text/css" rel="stylesheet"/>
    <link href="{url}/app/tpl/skins/Habbo/styles/stickers.css" type="text/css" rel="stylesheet"/>
     
    <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/lightwindow.css" type="text/css"/>
     
    <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/group.css" type="text/css"/>
    <style type="text/css">#playground,#playground-outer{width:752px;height:1360px;}</style>

    <script type="text/javascript">
        document.observe("dom:loaded", function() { initView(55331348, 55331348); });
        </script>

    <body id="home">
        <?php 

    $navigatorID 
    1;
    require_once (
    'includes/header.php'); 

    ?>
                </div>
                </div>
            </div>
            <div id="content-container">
                <div id="navi2-container" class="pngbg">
                    <div id="navi2" class="pngbg clearfix">
                        <ul>
                            <?php 

    $subNavigatorID 
    2;
    require_once (
    'includes/subnavi.php'); 

    ?>
    </ul>
    </div>
    </div>
    </div>

    <div id="container">
    <div id="content" style="position: relative" class="clearfix">
    <div id="column2" class="column">
    <div class="habblet-container ">
    <div class="cbb clearfix pixeldarkblue ">
    <h2 class="title"><span style="float: left;">{username}</span></h2>
    <div class="box-content"><table width="107%" style="padding: 5px; margin-left: -15px; background-color: #fff;">
                                                                                                       
                <?php 
                                    $getUserInfo 
    mysql_query("SELECT * FROM `users` WHERE id = '".$_SESSION[user][id]."'");
                                    while (
    $userInfomysql_fetch_assoc($getUserInfo))
                                         {
                                    echo 

    <tbody>
    <tr>
    <td valign="middle" width="25">
    <img style="margin-top: -10px;" src="http://www.habbo.com/habbo-imaging/avatarimage?figure=' 
    .$userInfo['look'] . '&size=m&gesture=sml">
    </td>
    <td valign="top">
    <p style="font-size: 90%;">Username: <strong>' 
    .$userInfo['username'] . '</strong>
    <br>Motto: <strong>' 
    .$userInfo['motto'] . '</strong>
    <br><i>Last Online: {lastSignedIn}</i></p>
    <br/></td>
    <td valign="top" style="float: right;">
    . (($userInfo['online'] == "1") ? '
    <img src="../app/tpl/skins/Habbo/web-gallery/v2/images/habbo_online.gif"/>'
    :'<img src="../app/tpl/skins/Habbo/web-gallery/v2/images/habbo_offline.gif"/>') . '
    </td>
    </tr>
    </tbody>
    </table>
    <tbody>
    <tr>
    '
    ;
                                   
                                   }
                                    
    ?>                                    
                                        
    </div>
    </div>
    </div>

    <div id="column2" class="column">
    <div class="habblet-container ">
    <div class="cbb clearfix blue ">
    <h2 class="title">Badges</h2>
    <div class="habblet box-content" style="align:left">

    <?php 
                                    $getUserBadges 
    mysql_query("SELECT * FROM `users_badges` WHERE user_id = '".$_SESSION[user][id]."'");
                                    while (
    $userBadgesmysql_fetch_assoc($getUserBadges))
                                         {
                                    echo 
    '<img title="' .$userBadges[badge_code]. '" src="{url}/swfs/c_images/album1584/' .$userBadges[badge_code]. '.gif">';
                                         }
    ?>

    </div>
    </div>
    </div>
    </div>
    </div>
                    


    <?php 
                                    $getUserCam 
    mysql_query("SELECT * FROM `camera_web` WHERE user_id = '".$_SESSION[user][id]."'");
                                    while (
    $userCammysql_fetch_assoc($getUserCam))
                                         {
                                    echo 
    '
                                    
                                    <div id="column1" class="column">
    <div class="habblet-container ">
    <div class="cbb clearfix green ">
    <div class="habblet box-content" style="align:left">
                                    <b>Posted on: ' 
    date('l d F Y g:i:s'$userCam['timestamp']) . '</b>
                                    <hr>
                                    <div><img src="' 
    .$userCam[url]. '">
                                    <hr>
                                    </div>
                                    </div>
                                    </div>
                                    '
    ;
                                         }
    ?>    
                                                

    </div>
    </div>
    </tr>
    </table>
    <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
    <script type="text/javascript">
        Event.observe(window, "load", observeAnim);
        document.observe("dom:loaded", function() {
            initDraggableDialogs();
            repositionInvalidItems();
        });
    </script>
        </div>
        </div>
            <script type="text/javascript">
                HabboView.run();
            </script>
            
                    <!--[if lt IE 7]>
            <script type="text/javascript">
            Pngfix.doPngImageFix();
            </script>
            <![endif]-->
            </div>
            </td>
            <div id="footer">
                        <br />
                        </div>
                        <?php  include('includes/footer.php'); ?>
                            <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
                </div>
            </div>
        </div>
    </div>

    </body>
    </html>
    Last edited by Glee; 28-10-17 at 11:27 PM. Reason: Update 2


  2. #2
    Death from above! The General is offline
    DeveloperRank
    Aug 2011 Join Date
    9,038Posts

    Re: RevCMS for Arcturus!

    Thats pretty cool. Gives people more choice besides HabboAPI and chocolatey.
    Feel free to add me on Discord: tdid#5193 :)

  3. #3
    Member Wilcock is offline
    MemberRank
    Sep 2012 Join Date
    PlutoLocation
    56Posts

    Re: RevCMS for Arcturus!

    I was actually waiting for a RevCMS release to start my hotel. Looks nice and thanks.

  4. #4
    Account Upgraded | Title Enabled! FunHotel is offline
    True MemberRank
    Feb 2013 Join Date
    200Posts

    Re: RevCMS for Arcturus!

    The "My page", you should make it able to scroll trough pictures and not multiple boxes for each picture. That way you will keep the size of the page small.

  5. #5
    Alpha Member Glee is offline
    Alpha MaleRank
    Jun 2009 Join Date
    Niagara Falls,Location
    2,243Posts

    Re: RevCMS for Arcturus!

    Quote Originally Posted by FunHotel View Post
    The "My page", you should make it able to scroll trough pictures and not multiple boxes for each picture. That way you will keep the size of the page small.
    Add:

    PHP Code:
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
    <script>
    x = 0;
    $(document).ready(function(){
        $("div").scroll(function(){
            $("span").text( x+= 1);
        });
    });
    </script> 
    Under:

    PHP Code:
    <link rel="shortcut icon" href="https://images.boon.pw/web-gallery/v2/favicon.ico" type="image/vnd.microsoft.icon"/>
    <
    link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/common.css" type="text/css"/> 
    Add:

    PHP Code:
    <div id="column1" class="column" style="border:6px solid clear;width:400px;height:392px;overflow:scroll;"
    Under:

    PHP Code:
    </div>
    </
    div>
    </
    div>
    </
    div>
    </
    div
    Place the whole Camera Code with this:

    PHP Code:
    <?php 
                                    $getUserCam 
    mysql_query("SELECT * FROM `camera_web` WHERE user_id = '".$_SESSION[user][id]."' ORDER BY timestamp");
                                    while (
    $userCammysql_fetch_assoc($getUserCam))
                                         {
                                    echo 
    '
                                    
                                    
    <div class="habblet-container">
    <div class="cbb clearfix green">
    <div class="habblet box-content" style="align:left">
                                    <b>Posted on: ' 
    date('l d F Y g:i:s'$userCam['timestamp']) . '</b>
                                    <hr>
                                    <div><img src="' 
    .$userCam[url]. '">
                                    <hr>
                                    </div>
                                    </div>
                                    </div>
                                    </div>
                                    '
    ;
                                         }
    ?>
    Video of what it should look like:

    https://youtu.be/VhotOm5bvGI

    OR the code code:

    PHP Code:

    <!DOCTYPE html>
    <html lang="en">
        <head>
            <meta http-equiv="content-type" content="text/html; charset=utf-8">
            <title>{hotelName} - {username}</title>
            
            <link rel="shortcut icon" href="https://images.boon.pw/web-gallery/v2/favicon.ico" type="image/vnd.microsoft.icon"/>
    <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/common.css" type="text/css"/>


    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
    <script>
    x = 0;
    $(document).ready(function(){
        $("div").scroll(function(){
            $("span").text( x+= 1);
        });
    });
    </script>

    <script src="{url}/app/tpl/skins/Habbo/js/libs2.js" type="text/javascript"></script>
    <script src="{url}/app/tpl/skins/Habbo/js/visual.js" type="text/javascript"></script>
    <script src="{url}/app/tpl/skins/Habbo/js/libs.js" type="text/javascript"></script>
    <script src="{url}/app/tpl/skins/Habbo/js/common.js" type="text/javascript"></script>
    <script src="{url}/app/tpl/skins/Habbo/js/fullcontent.js" type="text/javascript"></script>

            <script type="text/javascript">
                document.habboLoggedIn = true;
                var habboName = "{username}";
                var habboId = {userid};
                var habboReqPath = "";
                var habboStaticFilePath = "{url}/app/tpl/skins/Habbo";
                var habboImagerUrl = "http://www.habbo.com/habbo-imaging/";
                var habboPartner = "";
                var habboDefaultClientPopupUrl = "{url}/client";
                window.name = "habboMain";
                if (typeof HabboClient != "undefined") {
                    HabboClient.windowName = "eac955c8dbc88172421193892a3e98fc7402021a";
                    HabboClient.maximizeWindow = true;
                }
            </script>

    <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/home.css" type="text/css"/>
    <link href="{url}/app/tpl/skins/Habbo/styles/other.css" type="text/css" rel="stylesheet"/>
    <link href="{url}/app/tpl/skins/Habbo/styles/backgrounds.css" type="text/css" rel="stylesheet"/>
    <link href="{url}/app/tpl/skins/Habbo/styles/stickers.css" type="text/css" rel="stylesheet"/>
     
    <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/lightwindow.css" type="text/css"/>
     
    <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/group.css" type="text/css"/>
    <style type="text/css">#playground,#playground-outer{width:752px;height:1360px;}</style>

    <script type="text/javascript">
        document.observe("dom:loaded", function() { initView(55331348, 55331348); });
        </script>

    <body id="home">
        <?php 

    $navigatorID 
    1;
    require_once (
    'includes/header.php'); 

    ?>
                </div>
                </div>
            </div>
            <div id="content-container">
                <div id="navi2-container" class="pngbg">
                    <div id="navi2" class="pngbg clearfix">
                        <ul>
                            <?php 

    $subNavigatorID 
    2;
    require_once (
    'includes/subnavi.php'); 

    ?>
    </ul>
    </div>
    </div>
    </div>

    <div id="container">
    <div id="content" style="position: relative" class="clearfix">
    <div id="column2" class="column">
    <div class="habblet-container ">
    <div class="cbb clearfix pixeldarkblue ">
    <h2 class="title"><span style="float: left;">{username}</span></h2>
    <div class="box-content"><table width="107%" style="padding: 5px; margin-left: -15px; background-color: #fff;">
                                                                                                       
                <?php 
                                    $getUserInfo 
    mysql_query("SELECT * FROM `users` WHERE id = '".$_SESSION[user][id]."'");
                                    while (
    $userInfomysql_fetch_assoc($getUserInfo))
                                         {
                                    echo 

    <tbody>
    <tr>
    <td valign="middle" width="25">
    <img style="margin-top: -10px;" src="http://www.habbo.com/habbo-imaging/avatarimage?figure=' 
    .$userInfo['look'] . '&size=m&gesture=sml">
    </td>
    <td valign="top">
    <p style="font-size: 90%;">Username: <strong>' 
    .$userInfo['username'] . '</strong>
    <br>Motto: <strong>' 
    .$userInfo['motto'] . '</strong>
    <br><i>Last Online: {lastSignedIn}</i></p>
    <br/></td>
    <td valign="top" style="float: right;">
    . (($userInfo['online'] == "1") ? '
    <img src="../app/tpl/skins/Habbo/web-gallery/v2/images/habbo_online.gif"/>'
    :'<img src="../app/tpl/skins/Habbo/web-gallery/v2/images/habbo_offline.gif"/>') . '
    </td>
    </tr>
    </tbody>
    </table>
    <tbody>
    <tr>
    '
    ;
                                   
                                   }
                                    
    ?>                                    
                                        
    </div>
    </div>
    </div>

    <div id="column2" class="column">
    <div class="habblet-container ">
    <div class="cbb clearfix blue ">
    <h2 class="title">Badges</h2>
    <div class="habblet box-content" style="align:left">

    <?php 
                                    $getUserBadges 
    mysql_query("SELECT * FROM `users_badges` WHERE user_id = '".$_SESSION[user][id]."'");
                                    while (
    $userBadgesmysql_fetch_assoc($getUserBadges))
                                         {
                                    echo 
    '<img title="' .$userBadges[badge_code]. '" src="{url}/swfs/c_images/album1584/' .$userBadges[badge_code]. '.gif">';
                                         }
    ?>

    </div>
    </div>
    </div>
    </div>
    </div>
                    
                    <div id="column1" class="column" style="border:6px solid clear;width:400px;height:392px;overflow:scroll;">


    <?php 
                                    $getUserCam 
    mysql_query("SELECT * FROM `camera_web` WHERE user_id = '".$_SESSION[user][id]."' ORDER BY timestamp");
                                    while (
    $userCammysql_fetch_assoc($getUserCam))
                                         {
                                    echo 
    '
                                    
                                    
    <div class="habblet-container">
    <div class="cbb clearfix green">
    <div class="habblet box-content" style="align:left">
                                    <b>Posted on: ' 
    date('l d F Y g:i:s'$userCam['timestamp']) . '</b>
                                    <hr>
                                    <div><img src="' 
    .$userCam[url]. '">
                                    <hr>
                                    </div>
                                    </div>
                                    </div>
                                    </div>
                                    '
    ;
                                         }
    ?>    
                                                

    </div>
    </div>
    </div>
    </tr>
    </table>
    <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
    <script type="text/javascript">
        Event.observe(window, "load", observeAnim);
        document.observe("dom:loaded", function() {
            initDraggableDialogs();
            repositionInvalidItems();
        });
    </script>
            <script type="text/javascript">
                HabboView.run();
            </script>
            
            </td>
            <div id="footer">
                        <br />
                        </div>
                        <?php  include('includes/footer.php'); ?>
                            <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
                </div>
            </div>
        </div>
    </div>

    </body>
    </html>

  6. #6
    Registered MatiasLTDv1 is offline
    MemberRank
    Nov 2017 Join Date
    10Posts

    Re: RevCMS for Arcturus!

    error in comments, how can I fix it?
    https://imgur.com/a/kWPyj



  7. #7
    Alpha Member Glee is offline
    Alpha MaleRank
    Jun 2009 Join Date
    Niagara Falls,Location
    2,243Posts

    Re: RevCMS for Arcturus!

    Quote Originally Posted by MatiasLTDv1 View Post
    error in comments, how can I fix it?
    https://imgur.com/a/kWPyj


    PHP Code:
    CREATE TABLE `cms_comments` (
      `
    idint(11NOT NULL,
      `
    articleint(11NOT NULL,
      `
    useridint(11NOT NULL,
      `
    commentvarchar(500NOT NULL,
      `
    posted_onvarchar(150NOT NULL DEFAULT '',
      `
    authorvarchar(255NOT NULL
    ENGINE=InnoDB DEFAULT CHARSET=latin1;

    --
    -- 
    Indexes for dumped tables
    --

    --
    -- 
    Indexes for table `cms_comments`
    --
    ALTER TABLE `cms_comments`
      
    ADD PRIMARY KEY (`id`); 

  8. #8
    Registered MatiasLTDv1 is offline
    MemberRank
    Nov 2017 Join Date
    10Posts

    Re: RevCMS for Arcturus!

    it did not work :( gives the same result

  9. #9
    Account Upgraded | Title Enabled! KyleeIsProzZ is offline
    True MemberRank
    Oct 2012 Join Date
    C:Location
    552Posts

    Re: RevCMS for Arcturus!

    Quote Originally Posted by MatiasLTDv1 View Post
    it did not work :( gives the same result
    Try and run this query below:
    Code:
    ALTER TABLE cms_comments MODIFY id int NOT NULL AUTO_INCREMENT;

  10. #10
    Newbie matiaspicca is offline
    MemberRank
    Sep 2014 Join Date
    2Posts

    Re: RevCMS for Arcturus!

    Already solve thank you
    Last edited by matiaspicca; 07-12-17 at 09:32 PM.

  11. #11
    Death from above! The General is offline
    DeveloperRank
    Aug 2011 Join Date
    9,038Posts

    Re: RevCMS for Arcturus!

    Quote Originally Posted by matiaspicca View Post
    https://imgur.com/a/etI7Dgive another mistake now
    Then add a default value for the author column...
    Feel free to add me on Discord: tdid#5193 :)

  12. #12
    Newbie matiaspicca is offline
    MemberRank
    Sep 2014 Join Date
    2Posts

    Re: RevCMS for Arcturus!

    Error Report Tool as I can fix it does not show me anything in db https://imgur.com/a/SP7zN

  13. #13
    Alpha Member Glee is offline
    Alpha MaleRank
    Jun 2009 Join Date
    Niagara Falls,Location
    2,243Posts

    Re: RevCMS for Arcturus!

    Quote Originally Posted by matiaspicca View Post
    Error Report Tool as I can fix it does not show me anything in db https://imgur.com/a/SP7zN
    Are you clicking the check box before submitting?

  14. #14
    Registered MatiasLTDv1 is offline
    MemberRank
    Nov 2017 Join Date
    10Posts

    Re: RevCMS for Arcturus!

    yes..

  15. #15
    Alpha Member Glee is offline
    Alpha MaleRank
    Jun 2009 Join Date
    Niagara Falls,Location
    2,243Posts

    Re: RevCMS for Arcturus!

    Quote Originally Posted by MatiasLTDv1 View Post
    yes..
    Truncate the table and then try submitting a report.



Page 1 of 5 12345 LastLast

Advertisement