Hello & Welcome to our community. Is this your first visit? Register

Page 2 of 6 FirstFirst 123456 LastLast
Results 16 to 30 of 76
  1. #16
    Pee Aitch Pee Dave's Avatar

    Rank
    True Member
    Join Date
    Mar 2011
    Location
    The Netherlands
    Posts
    673

    Re: SW Administration Panel

    Stupid Megaupload... uploaded to Sendspace.
    [Only registered and activated users can see links. ]

  2. #17
    Registered

    Rank
    Member
    Join Date
    Mar 2009
    Posts
    16

    Re: SW Administration Panel

    Can you help The admin Panel say: You have no access to the admin panel!

    I have eveything perfect

    Someone can help me

  3. #18
    Pee Aitch Pee Dave's Avatar

    Rank
    True Member
    Join Date
    Mar 2011
    Location
    The Netherlands
    Posts
    673

    Re: SW Administration Panel

    Quote Originally Posted by Echoki View Post
    Can you help The admin Panel say: You have no access to the admin panel!

    I have eveything perfect

    Someone can help me
    Then change $accopt to 1 in the settings.php file.
    If your $accopt is 0 then you have to add your account name in the $accs array in the settings.php file.

  4. #19
    DRGunZ 2 Creator wesman2232's Avatar

    Rank
    The Omega
    Join Date
    Jan 2007
    Location
    Huntington, WV
    Posts
    5,110

    Re: SW Administration Panel

    Nice, I really love the design and it is a very nice panel.

    For the people who are having trouble with the mssql_connect function, I don't mean to take away SuperWaffle's help part of the release, but there is the condition where it might be the .dll problem. How to fix that and where to get it is in my thread Unofficial Fix Thread.

  5. #20
    Chupacabraj. Elian's Avatar

    Rank
    True Member
    Join Date
    Sep 2009
    Location
    Horn, Netherlan
    Posts
    1,435

    Re: SW Administration Panel

    Wow, thanks for sharing this with us :O

    9.9/10 -0.1 for the design ;p its not my style but that doesnt matter.

    People will definatly use this.

  6. #21
    sunflower samurai Irahnik's Avatar

    Rank
    Alpha Male
    Join Date
    Mar 2010
    Location
    127.0.0.1
    Posts
    1,662

    Re: SW Administration Panel

    Quote Originally Posted by ExelcysPrime View Post
    Wow, thanks for sharing this with us :O

    9.9/10 -0.1 for the design ;p its not my style but that doesnt matter.

    People will definatly use this.
    you're welcome for designing it

  7. #22

    Re: SW Administration Panel

    Tested it out, it's awesome but..

    Issues/Bugs that need fixing:

    • Make the Name hyperlink more obvious in the panel's results. (I thought nothing was click-able when I first tested it =P)
    • Search does not work that well. (e.g. Try typing 252, select account, UGradeID. Nothing shows up and when you click search, it refreshes with nothing. You need to select account, UGradeID and then type 252, to make Search work.)
    • Use session_unset() before session_destroy() to unset all session variables in the panel. In some cases while doing an action on the panel, you might randomly get an error message "Login first", and when you try to relogin, it repeats that message over and over again.
    • Last Login Date issue. Some users who last logged in over a year ago are seen in the Last 20 Online on Accounts and Characters.
    • convertgrade() does not have a default return value for custom UGradeIDs due to hard-coded returns? (View the code all the way below)


    Last Login Date Issue (template_account.php, template_character.php)

    Do not use:
    template_character.php
    PHP Code:
    SELECT TOP(20)* FROM Account WHERE LastLoginTime LastLogoutTime 
    instead, use
    template_character.php
    PHP Code:
    SELECT TOP(20)* FROM Login ORDER BY LastConnDate DESC 
    The same can be done to template_account.php by doing an INNER JOIN on the query, and not using LastLoginTime from the Account table in the query result as it is inaccurate:

    PHP Code:
    SELECT TOP(20a.AIDa.UserIDa.UGradeIDl.LastConnDatea.Email FROM Account a INNER JOIN Login l ON a.AID l.AID ORDER BY l.LastConnDate DESC 


    Things you can add:


    • Add an advanced configuration section.
      Allow the customization of UGradeIDs in a variable so that it can be used in the "Account" UGradeID tab without editing the hard-coded definitions, if the user has custom UGradeIDs. Then, you can list each element with its sub-element in the array in convertgrade(). (Example below)
    • Add a $coinstable variable in settings.php for users with "Coins" on a different table.
    • Add a "Previous / Next 50" to select the previous/next 50 results in Search.
    • Add an [x] beside the name in Notes From Staff, if the user is in $admins at settings.php, to allow the removal of messages.


    PHP Code:
    // Configuration
    $config_UGID = array(=> "Normal Member",
                         
    255 => "Administrator");

    // Listing at convertgrade()
    public function convertgrade($grade)
    {
        
    $parsed "";
        
    $found 0;

        foreach (
    $config_UGID as $uid => $value)
        {
            if (
    $grade == $uid)
            {
                
    $found 1;
                
    $parsed .= '<option value="' $uid '" SELECTED>' $value '(' $uid ')</option>';
            }
            else
                
    $parsed .= '<option value="' $uid '">' $value '(' $uid ')</option>';
        }

        if (
    $found == 0)
            
    $parsed .= '<option value="' $uid '" SELECTED>Unknown (' $grade ')</option>';
            
        return 
    $parsed;

    Just whipped up that code - it's pretty much pseudo, so pardon me if I have any errors/syntax errors.

    :)
    Last edited by Linear88; 23-06-11 at 06:14 AM.
    "You’ve nothing to gain from holding on to your ideas; they may feel precious, but the more you share, the more new ideas you’ll have."

    Visit my development blog

  8. #23
    Pee Aitch Pee Dave's Avatar

    Rank
    True Member
    Join Date
    Mar 2011
    Location
    The Netherlands
    Posts
    673

    Re: SW Administration Panel

    @Linear
    Thanks, once I've installed all my shit on my SSD I will add/fix some things and change how some of the functions work.

  9. #24
    Chupacabraj. Elian's Avatar

    Rank
    True Member
    Join Date
    Sep 2009
    Location
    Horn, Netherlan
    Posts
    1,435

    Re: SW Administration Panel

    I didnt mean that it isnt fcking awesome xD its just to square like for me, i know your other work and your great.

  10. #25
    Registered

    Rank
    Member
    Join Date
    Dec 2009
    Posts
    19

    Re: SW Administration Panel

    Another admin panel?. . .

  11. #26
    Member bajay0124's Avatar

    Rank
    Member
    Join Date
    Jun 2010
    Posts
    54

    Re: SW Administration Panel

    err.. how do I Execute sql.txt to my mssql @.@
    ?

    I'm getting my Report paper ready.


  12. #27
    sunflower samurai Irahnik's Avatar

    Rank
    Alpha Male
    Join Date
    Mar 2010
    Location
    127.0.0.1
    Posts
    1,662

    Re: SW Administration Panel

    Quote Originally Posted by [+]Python View Post
    Another admin panel?. . .
    Problem, officer?

  13. #28
    Pee Aitch Pee Dave's Avatar

    Rank
    True Member
    Join Date
    Mar 2011
    Location
    The Netherlands
    Posts
    673

    Re: SW Administration Panel

    Updated the admin panel to V1.1

    Changes:
    - Account/character/clan names are now the color Maroon at the search function so it's obvious you can click on it.
    - Added session_unset(); before all session_destroy();.
    - Fixed last login date issue at account and character.
    - Configuration settings are now stored in the $_CONFIG array.
    - Added $_CONFIG['coinstable'] variable. I guess I don't need to explain what it does.
    - In case you got custom UGradeID's you can add them with ease in the $_CONFIG['uids'] array.
    - Admins can now delete messages in the notice box by pressing the X behind the name.
    - At the admin part at the view log entries function you can change the url &amount= to a number to show a specific amount.
    - Fixed the sql.txt so you can execute it without problems.

    Thanks to Linear for suggestions.
    Next version will have some -non important- changes in functions.

    @bajay0124
    Simply connect to your GunzDB, press "New Query" and paste it all there and press the red !.
    Last edited by Dave; 24-06-11 at 03:42 PM.

  14. #29

    Re: SW Administration Panel

    Thanks for considering my suggestions. :)

    There's a frustrating issue: Search - select the option Character and Name, type something, erase/add text.

    It doesn't return any result in some cases and when you click "Search" on the nav bar again, it gives an error "Login first", and when you Login, you might get "Login IP and current IP do not match".

    Another bug:

    • Character gender - convertgender2()
      - The values were filled wrongly.


    Fixed code below: (fixed options, added support for Unknown gender in it)
    PHP Code:
      public function convertgender2($gender)
      {
        if(
    $gender == 1)
        {
          return 
    '<option value="1" SELECTED>Female</option><option value="0">Male</option>';
        }
        elseif(
    $gender == 0)
        {
          return 
    '<option value="1">Female</option><option value="0" SELECTED>Male</option>';
        }
        else
        {
          return 
    '<option value="' $gender '">UNKNOWN ("' $gender '")</option><option value="0">Female</option><option value="1">Male</option>';
        }
      } 
    EDIT: More bugs.


    • Login IP checking is inaccurate, sometimes, $_SERVER['REMOTE_ADDR'] returns a wrong IP, invalidating the session.
    • Logging off will produce a blank page.
    Last edited by Linear88; 24-06-11 at 04:57 PM.
    "You’ve nothing to gain from holding on to your ideas; they may feel precious, but the more you share, the more new ideas you’ll have."

    Visit my development blog

  15. #30
    Pee Aitch Pee Dave's Avatar

    Rank
    True Member
    Join Date
    Mar 2011
    Location
    The Netherlands
    Posts
    673

    Re: SW Administration Panel

    - Yea $_SERVER['REMOTE_ADDR'] sometimes doesn't give the correct IP, since that's the only way I know to get an IP in PHP, I will remove the IP check function.
    - Logout function works normally to me. Can't reproduce the problem. (It redirects you to index.php after logging out.)
    - Can't reproduce the problem with the search function either. I will remove the "Search" button since it's not needed and doesn't work anyways.
    Last edited by Dave; 24-06-11 at 05:33 PM.

 

 
Page 2 of 6 FirstFirst 123456 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HyperFilter
Sponsored by HyperFilter , secured by Incapsula , powered by LiteSpeed.
Mods by DBTech. All times are GMT +1. The time now is 08:46 AM.
Powered by vBulletin® Copyright , Jelsoft Enterprises Ltd.