User Tag List

Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 8 to 14 of 17

Thread: [CPP] EmuDevs Premium System

  1. #8
    Original Poster
    Mad Scientist <span style='color: #008000'><span class='glow_006400'>slp13at420</span></span>'s Avatar



    Join Date
    Dec 2013
    Location
    Idaho
    Posts
    2,480
    XP
    20,134,655
    Level
    500
    Thanks
    1,086
    Thanked 329 Times in 211 Posts
    lol yea its a rough draft so far that compiles, the conf settings seems to work, and the buff command works, the coin works, and fall damage works . I just tested the basics.
    I will go back thru and see what I missed :p
    Achievements:
    Shopper Got a Sticky! Member 1 year registered Level XL Level D
    Awards:
    Pot Head LOL Raffle Winner Top Tagger Donator Hangman Scripter Repacker Drunk Support Member of Staff Da Bomb!
    "Cuz PvP's better with a bag 'o' weed"
    !! King Spade !!

    -Guild Plot System-
    Grumbo'z Guild Warz


    -VIP System-
    Grumbo'z VIP System

  2. #9
    Original Poster
    Mad Scientist <span style='color: #008000'><span class='glow_006400'>slp13at420</span></span>'s Avatar



    Join Date
    Dec 2013
    Location
    Idaho
    Posts
    2,480
    XP
    20,134,655
    Level
    500
    Thanks
    1,086
    Thanked 329 Times in 211 Posts
    8-14-2016
    added the command : .prem learn all my spells
    this will teach the player all there class spells.

    8-14-2016
    added the command : .prem unlearn all my spells
    this will remove all the players class spells.

    8-14-2016
    added the command : .prem who
    this will list all online premium players.

    8-14-2016
    added the command: .prem appear [playername]
    allows a premium player to teleport to another player.

    8-14-2016
    added the command: .prem dnd appear on/off
    allows a premium player to activate a DnD mode so other premium players cannot appear to them.
    Last edited by slp13at420; 08-15-2016 at 03:21 AM.
    Achievements:
    Shopper Got a Sticky! Member 1 year registered Level XL Level D
    Awards:
    Pot Head LOL Raffle Winner Top Tagger Donator Hangman Scripter Repacker Drunk Support Member of Staff Da Bomb!
    "Cuz PvP's better with a bag 'o' weed"
    !! King Spade !!

    -Guild Plot System-
    Grumbo'z Guild Warz


    -VIP System-
    Grumbo'z VIP System

  3. #10
    Original Poster
    Mad Scientist <span style='color: #008000'><span class='glow_006400'>slp13at420</span></span>'s Avatar



    Join Date
    Dec 2013
    Location
    Idaho
    Posts
    2,480
    XP
    20,134,655
    Level
    500
    Thanks
    1,086
    Thanked 329 Times in 211 Posts
    Update 11-29-2016:
    During our down time I went ahead and updated the System making it a little more efficient and now able to be #includ'd in any other scripts.
    I updated it using @Tommy 's example. Still did it by hand rather than copy/paste lol I prefer to just get down and dirty and get to know every char of every line and why its there .


    * easy to read colored instructions included.

    feedback and issues can be posted below :)
    Last edited by slp13at420; 11-29-2016 at 08:52 PM.
    Achievements:
    Shopper Got a Sticky! Member 1 year registered Level XL Level D
    Awards:
    Pot Head LOL Raffle Winner Top Tagger Donator Hangman Scripter Repacker Drunk Support Member of Staff Da Bomb!
    "Cuz PvP's better with a bag 'o' weed"
    !! King Spade !!

    -Guild Plot System-
    Grumbo'z Guild Warz


    -VIP System-
    Grumbo'z VIP System

  4. #11
    Enthusiast
    Join Date
    Dec 2013
    Posts
    8
    XP
    2,393
    Level
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello. I have an error when I'm trying to execute WORLD_DB_custom_tables.sql

    So I took this query:
    [CODE]
    CREATE TABLE `premium_locations` (
    `team_id` TINYINT(1) UNSIGNED NOT NULL,
    `map_id` MEDIUMINT(8) UNSIGNED NOT NULL,
    `x` FLOAT UNSIGNED NOT NULL,
    `y` FLOAT UNSIGNED NOT NULL,
    `z` FLOAT UNSIGNED NOT NULL,
    `o` FLOAT UNSIGNED NOT NULL
    )
    UNIQUE INDEX `team_id` (`team_id`)
    COMMENT='other premium only teleport locations.\r\ntype 0 = premium only location\r\ntype 1 = public location'
    ENGINE=InnoDB
    ;
    [CODE]

    Executed this fist with SQLyog and have this error:
    Error Code : 1064
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNIQUE INDEX `team_id` (`team_id`)
    COMMENT='other premium only teleport location' at line 9
    (0 ms taken)
    I think the problem is that 'UNIQUE INDEX' but i have no idea how to fix it.
    Last edited by slp13at420; 01-09-2017 at 03:51 PM.
    Achievements:
    Member 1 year registered Level X

  5. #12
    Original Poster
    Mad Scientist <span style='color: #008000'><span class='glow_006400'>slp13at420</span></span>'s Avatar



    Join Date
    Dec 2013
    Location
    Idaho
    Posts
    2,480
    XP
    20,134,655
    Level
    500
    Thanks
    1,086
    Thanked 329 Times in 211 Posts
    Quote Originally Posted by Flameshot View Post
    Hello. I have an error when I'm trying to execute WORLD_DB_custom_tables.sql

    So I took this query:
    Code:
    CREATE TABLE `premium_locations` (
    	`team_id` TINYINT(1) UNSIGNED NOT NULL,
    	`map_id` MEDIUMINT(8) UNSIGNED NOT NULL,
    	`x` FLOAT UNSIGNED NOT NULL,
    	`y` FLOAT UNSIGNED NOT NULL,
    	`z` FLOAT UNSIGNED NOT NULL,
    	`o` FLOAT UNSIGNED NOT NULL
    )
    UNIQUE INDEX `team_id` (`team_id`)
    COMMENT='other premium only teleport locations.\r\ntype 0 = premium only location\r\ntype 1 = public location'
    ENGINE=InnoDB
    ;
    I think the problem is that 'UNIQUE INDEX' but i have no idea how to fix it.
    change
    Code:
    UNIQUE INDEX  `team_id` (`team_id`)
    to
    Code:
    UNIQUE KEY `team_id` (`team_id`)
    that should fix your issue ;)

    and I updated the sql file with this.
    Dunno what happened there lol musta not been high enough to catch that lol
    Last edited by slp13at420; 01-09-2017 at 04:01 PM.
    Achievements:
    Shopper Got a Sticky! Member 1 year registered Level XL Level D
    Awards:
    Pot Head LOL Raffle Winner Top Tagger Donator Hangman Scripter Repacker Drunk Support Member of Staff Da Bomb!
    "Cuz PvP's better with a bag 'o' weed"
    !! King Spade !!

    -Guild Plot System-
    Grumbo'z Guild Warz


    -VIP System-
    Grumbo'z VIP System

  6. #13
    Enthusiast
    Join Date
    Dec 2013
    Posts
    8
    XP
    2,393
    Level
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts
    CREATE TABLE `premium_locations` (
    `team_id` TINYINT(1) UNSIGNED NOT NULL,
    `map_id` MEDIUMINT(8) UNSIGNED NOT NULL,
    `x` FLOAT UNSIGNED NOT NULL,
    `y` FLOAT UNSIGNED NOT NULL,
    `z` FLOAT UNSIGNED NOT NULL,
    `o` FLOAT UNSIGNED NOT NULL
    )
    UNIQUE KEY `team_id` (`team_id`)
    COMMENT='other premium only teleport locations.\r\ntype 0 = premium only location\r\ntype 1 = public location'
    ENGINE=InnoDB
    ;

    Have this error now:
    Error Code : 1064
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNIQUE KEY `team_id` (`team_id`)
    COMMENT='other premium only teleport locations.' at line 9
    (0 ms taken)

  7. #14
    Original Poster
    Mad Scientist <span style='color: #008000'><span class='glow_006400'>slp13at420</span></span>'s Avatar



    Join Date
    Dec 2013
    Location
    Idaho
    Posts
    2,480
    XP
    20,134,655
    Level
    500
    Thanks
    1,086
    Thanked 329 Times in 211 Posts
    did it ever create the table in your world DB? if so make sure you drop it first then re-run the sql again.
    Last edited by slp13at420; 01-09-2017 at 10:54 PM.
    Achievements:
    Shopper Got a Sticky! Member 1 year registered Level XL Level D
    Awards:
    Pot Head LOL Raffle Winner Top Tagger Donator Hangman Scripter Repacker Drunk Support Member of Staff Da Bomb!
    "Cuz PvP's better with a bag 'o' weed"
    !! King Spade !!

    -Guild Plot System-
    Grumbo'z Guild Warz


    -VIP System-
    Grumbo'z VIP System

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •