Thread: os-scape 171 server

Page 1 of 8 123 ... LastLast
Results 1 to 10 of 72
  1. #1 os-scape 171 server 
    Respected Member

    Join Date
    Jan 2009
    Posts
    5,680
    Thanks given
    1,087
    Thanks received
    3,478
    Rep Power
    5000




    we bought this from Velocity

    [Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]

    these are the original files given to us by Velocity himself, not single a thing has been changed or edited, do as you please with it, I will not help with setting it up or anything as such so don't expect any guides. Hopefully with the release of this and the way more updated Kronos(runite), people will move away from 317 junk!

    Credits:
    Situations
    Velocity
    Savions
    Shadowy


    Edit

    Spoiler for Click here for additional instructions:

    UTF-8 encoding fix: [Only registered and activated users can see links. ]

    Only thing you need to do is set

    Code:
    public static boolean disableIngameCreation = true;
    to false

    For the friends part of the game to work correctly, these following postgres functions need importing with the schema.
    Code:
    create function canprivatemessage(my_id integer, their_name citext)
      returns TABLE(target_id integer, result boolean)
    language plpgsql
    as $$
    DECLARE their_id INTEGER;
    BEGIN
    
    
        SELECT id
        INTO their_id
        FROM accounts
        WHERE displayname ILIKE their_name;
    
    
        RETURN QUERY SELECT their_id as target_id, (CASE
                                                    --Couldn't find player
                                                    WHEN (their_id IS NULL)
                                                        THEN FALSE
    
    
                                                    --They aren't even online
                                                    WHEN (SELECT count(*)
                                                          FROM online_characters oc
                                                          WHERE oc.account_id = their_id) <= 0
                                                        THEN FALSE
    
    
                                                    --On their ignore list
                                                    WHEN (SELECT count(*)
                                                          FROM ignores
                                                          WHERE account_id = their_id AND friend_id = my_id) > 0
                                                        THEN FALSE
    
    
                                                    -- PMStatus Offline
                                                    WHEN (SELECT pmstatus
                                                          FROM characters c
                                                          WHERE c.account_id = their_id AND c.id = (SELECT oc.character_id
                                                                                                    FROM online_characters oc
                                                                                                    WHERE oc.account_id = their_id)) =
                                                         2
                                                        THEN FALSE
    
    
                                                    -- PMStatus Friends only
                                                    WHEN (SELECT pmstatus
                                                          FROM characters c
                                                          WHERE c.account_id = their_id AND c.id = (SELECT oc.character_id
                                                                                                    FROM online_characters oc
                                                                                                    WHERE oc.account_id = their_id)) =
                                                         1
                                                        THEN (CASE WHEN (SELECT count(*)
                                                                         FROM friends f2
                                                                         WHERE f2.account_id = their_id AND f2.friend_id = my_id) > 0
                                                            THEN TRUE
                                                              ELSE FALSE END)
    
    
                                                    -- Otherwise we can pm them :)
                                                    ELSE TRUE
                                                    END) AS result;
    END;
    $$;
    
    
    create function getfriendsfor(my_id integer)
      returns TABLE(accout_id integer, friend_id integer, world_id integer, service_id integer, character_id integer, displayname character varying, lastname character varying, rights smallint, clanrank integer)
    language plpgsql
    as $$
    BEGIN
        RETURN QUERY SELECT
                         f1.account_id,
                         f1.friend_id,
                         (CASE
                          WHEN ch.pmstatus = 2 --Offline
                              THEN 0
                          WHEN ch.pmstatus = 1 --Friends only
                              THEN (CASE WHEN (SELECT count(*)
                                               FROM friends f2
                                               WHERE f2.account_id = f1.friend_id AND f2.friend_id = f1.account_id) > 0
                                  THEN oc.world_id
                                    ELSE 0 END)
                          ELSE oc.world_id --Normal
                          END) AS world_id,
                         oc.service_id,
                         oc.character_id,
                         a.displayname,
                         a.lastname,
                         a.rights,
                         f1.clanrank
                     FROM friends AS f1
                         LEFT JOIN online_characters AS oc
                             ON oc.account_id = f1.friend_id
                         LEFT JOIN accounts AS a
                             ON f1.friend_id = a.id
                         LEFT JOIN characters AS ch
                             ON ch.id = oc.character_id
                     WHERE f1.account_id = my_id;
    END;
    $$;
    
    
    create function getfriendsfor(my_id integer, pmstatus integer)
      returns TABLE(accout_id integer, friend_id integer, world_id integer, service_id integer, character_id integer, displayname character varying, lastname character varying, rights smallint, clanrank integer)
    language plpgsql
    as $$
    BEGIN
        RETURN QUERY SELECT
                         f1.account_id,
                         f1.friend_id,
                         CASE
                         WHEN oc.world_id IS NULL OR oc.world_id = 0
                             THEN oc.world_id --If their world is null or 0 they are offline already
    
    
                         WHEN pmstatus = 1 AND (SELECT count(*)
                                                FROM friends AS f2
                                                WHERE f2.friend_id = f1.account_id AND f2.account_id = f1.friend_id) > 0
                             THEN oc.world_id --If other person is friends only and we are on their friends list then show the real world
    
    
                         WHEN pmstatus != 1
                             THEN oc.world_id --Other person isn't on friends only, we all good :)
    
    
                         ELSE 0 --Other person is friends only and we are no on their friends list. make them appear offline
    
    
                         END AS world_id,
                         oc.service_id,
                         oc.character_id,
                         a.displayname,
                         a.lastname,
                         a.rights,
                         f1.clanrank
                     FROM friends AS f1
                         LEFT JOIN online_characters AS oc
                             ON oc.account_id = f1.friend_id
                         LEFT JOIN accounts AS a
                             ON f1.friend_id = a.id
                     WHERE f1.account_id = my_id;
    END;
    $$;
    Last edited by Spooky; 02-19-2021 at 12:19 PM.
    Reply With Quote  
     


  2. #2  
    zen2
    Corey's Avatar
    Join Date
    Feb 2012
    Age
    23
    Posts
    1,376
    Thanks given
    1,070
    Thanks received
    1,437
    Rep Power
    5000
    Very cool, hope more get into osrs
    [Only registered and activated users can see links. ]
    Reply With Quote  
     

  3. Thankful user:


  4. #3  
    Rune-Server Affiliate
    .css's Avatar
    Join Date
    Dec 2018
    Age
    26
    Posts
    290
    Thanks given
    45
    Thanks received
    85
    Rep Power
    107
    Noice. I'll check this out. Thanks for the contribution.

    Check out Neos! A #718 RSPS. Click below, or join by [Only registered and activated users can see links. ]
    [Only registered and activated users can see links. ]

    Zed#3343
    Reply With Quote  
     

  5. #4  
    #1 Interface Services

    Herb's Avatar
    Join Date
    Nov 2015
    Posts
    565
    Thanks given
    124
    Thanks received
    635
    Rep Power
    3613
    Dayumm solid release! I'm sure someone finds this very useful
    Thanks for the release!
    Spoiler for signature:


    [Only registered and activated users can see links. ]
    Reply With Quote  
     

  6. #5  
    Nes
    Nes is offline
    RSPS Youtuber at youtube.com/nesrsps

    Nes's Avatar
    Join Date
    Aug 2014
    Age
    22
    Posts
    272
    Thanks given
    89
    Thanks received
    105
    Rep Power
    204
    Good stuff !
    [Only registered and activated users can see links. ]
    Watch good content, find a new RSPS or advertise your RSPS!
    Reply With Quote  
     

  7. #6  
    Community Veteran

    George's Avatar
    Join Date
    Mar 2009
    Posts
    7,058
    Thanks given
    2,093
    Thanks received
    2,930
    Rep Power
    5000
    Very nice contribution


    Reply With Quote  
     

  8. #7  
    Banned

    Join Date
    Jun 2010
    Age
    23
    Posts
    4,728
    Thanks given
    1,646
    Thanks received
    1,522
    Rep Power
    0
    This is a luxurious goat that you have bestowed on us, thank u very much for this. Thanks, u.
    Reply With Quote  
     

  9. #8  
    Registered Member
    Velocity's Avatar
    Join Date
    Jan 2009
    Age
    25
    Posts
    2,025
    Thanks given
    1,012
    Thanks received
    2,362
    Rep Power
    4112
    i did what? i don't even know you nor have any dms from anyone in january but thanks for the credits, I hope someone has use for it???

    i also just realized january 2019 was like 2 months after I sold it so don't try to rat me out for shit i don't do, pussy bitch
    xxxxxxx
    Reply With Quote  
     

  10. Thankful users:


  11. #9  
    Imagine V2 s00n
    Hank's Avatar
    Join Date
    Aug 2010
    Posts
    4,346
    Thanks given
    1,731
    Thanks received
    2,007
    Rep Power
    3837
    Quote Originally Posted by Velocity View Post
    i did what? i don't even know you nor have any dms from anyone in january but thanks for the credits, I hope someone has use for it???

    i also just realized january 2019 was like 2 months after I sold it so don't try to rat me out for shit i don't do, pussy bitch

    Now hopefully ppl will stop scamming a bunch of dumb kids by selling it l0l
    [Only registered and activated users can see links. ]
    Reply With Quote  
     

  12. #10  
    I live to die another day.

    Slayer.'s Avatar
    Join Date
    Feb 2018
    Posts
    429
    Thanks given
    2
    Thanks received
    41
    Rep Power
    130
    Quote Originally Posted by Tyluur View Post
    This is a luxurious goat that you have bestowed on us, thank u very much for this. Thanks, u.
    Would you stfu, you smell like a fuckin goat.
    Reply With Quote  
     

  13. Thankful user:


Page 1 of 8 123 ... LastLast

Thread Information
Users Browsing this Thread

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


User Tag List

Similar Threads

  1. Replies: 100
    Last Post: 12-28-2019, 01:13 AM
  2. OS-Scape ECO server gp for sale!! 150m!!
    By lary_30 in forum Selling
    Replies: 13
    Last Post: 06-20-2016, 05:19 PM
  3. OS-Scape Blood Money (PvP Server)
    By Affliction in forum Buying
    Replies: 6
    Last Post: 03-19-2016, 03:55 AM
  4. Maulzz-Scape 508 Server Release !
    By Lenin in forum Downloads
    Replies: 47
    Last Post: 08-17-2009, 11:28 PM
  5. Legend-Scape - ::Pickup Server -
    By Smithy in forum Advertise
    Replies: 1
    Last Post: 05-15-2009, 09:53 PM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •