[Tool/Web/Other] MySQL UCP Framework

[Tool/Web/Other] MySQL UCP Framework - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+---- Forum: Tools and Files (https://sampforum.blast.hk/forumdisplay.php?fid=82)
+---- Thread: [Tool/Web/Other] MySQL UCP Framework (/showthread.php?tid=381573)

MySQL UCP Starter Package - SchurmanCQC - 30.09.2012

MySQL UCP Starter Package 2

YOU NEED TO KNOW A LITTLE BIT OF HTML AND PHP TO USE THIS. YOU DO NOT NEED TO BE A PRO, BUT YOU CAN'T BE A NEWBIE EITHER!

This project is old, and I no longer support it. I do not play SA-MP that much, and I'm busy with school, etc, I could go on and on. Here's something to sum it up:
AIN'T NOBODY GOT TIME FO DAT

What is this?

This is a User Control Panel Starter Package. A User Control Panel allows users in a server to access their account, change settings, view info, and much more.

How do I install this?

First of all, you need to know how to code only a small bit of HTML and PHP. You also need to know how to use a computer. I will not provide a tutorial for this release. If you are a newbie and would like me to install this on your webserver, I will do that for you if you PM me! So, instead of having to install it yourself with a "how to", I'll even do it for you.

Why are you releasing this?

I'm releasing this because it isn't much. And people would die for a working UCP! It is completely bare, doesn't have a skin, and doesn't have any "extra" features.

Features

Fully secure with session IDs
Login/logout functions
Dashboard that displays user info
Skins images that display in the Dashboard

Package Contents

display (File Folder)

SKINS (File Folder)

0-299.jpg Skins images. From 0 to 299 not including missing skins.

index.php Has the login form. If you are already logged in, it will redirect to the dashboard.
checkcreds.php Check's the user's credentials when logging in.
connection.php INCLUDE that contains the MySQL information required for the connection.
dashboard.php Dashboard of the UCP. Shows the user's info and allows them to login and logout.
logout.php Logs the user out.

Updates, Bugfixes and Additions

-------------------------Package Two-------------------------

Fixed some critical bugs. Here's a list of bugfixes and additions:

Fixed the deprecated mysql_escape_string function by changing it to mysql_real_escape_string.
Added comments that explains every function and operation in this package!
Fixed redirecting to "index.html" instead of "index.php".

-------------------------Package One-------------------------

First release. Nothing to see here.

Download pls?

Package Two (See Updates Above)
Download Here (RECOMMENDED!)

Package One (First Release)
Download Removed - Contains Critical Bugs

ucpsessids SQL Dump

Код:

--
-- Table structure for table `ucpsessids`
--

CREATE TABLE IF NOT EXISTS `ucpsessids` (
  `sessid` varchar(20) NOT NULL,
  `name` varchar(25) NOT NULL,
  `ip` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Like this? Rep me. Not too much to ask I hope.

Re: MySQL UCP Framework - davelord - 30.09.2012

Oh my God. Could I suck your dick please? I've waited for something like this SO long.

Re: MySQL UCP Framework - Alcatraz Gaming - 30.09.2012

Great job, i will reply back when i have downloaded and tested the files.

Re: MySQL UCP Framework - SchurmanCQC - 30.09.2012

Thanks guys. I had this lying around from making UCPs for other servers, and I thought I might package it up and release it.. I guess you guys were waiting for something like this...

Re: MySQL UCP Framework - Ronaldo_raul™ - 30.09.2012

Something we all need. GREAT JOB!

Re: MySQL UCP Framework - SchurmanCQC - 30.09.2012

INFO UPDATE

Later on in the year I might package up and release the FLAT FILE/INI COMPATIBLE UCP, which not many people see/know how to make. I have this package currently in development PRIVATELY for a server, but after it is complete and given to them, I will release the INI compatible starter package.

PACKAGE UPDATE (Starter Package Two)
See change log in main post.

Re: MySQL UCP Framework - Glint - 30.09.2012

Really nice job.

Re: MySQL UCP Framework - Johndaonee - 30.09.2012

Is there any preview mate?

And good job for sharing your work on a UCP

Re: MySQL UCP Framework - SchurmanCQC - 01.10.2012

Quote:

Originally Posted by Johndaonee

Is there any preview mate?

And good job for sharing your work on a UCP

Not really. It's a framework not a fully working, nice looking release.

Re: MySQL UCP Framework - SchurmanCQC - 01.10.2012

Quote:

Originally Posted by Garu

sessions table should consist of expiring timestamp, so any inactive sessions can be garbage collected..

Edit 1: This is not a framework as well, If it is show me some MVC/HMVC/MVVM? This is more like a micro auth system...

Edit 2: This auth system is vulnerable to XSS/CSRF. Please consider developing csrf tokens/xss filters.

1. Will be done.

2. You could call it that...

3. I don't think it is vulnerable to CSRF. You can't change your password or do anything that can alter the player's account. If the user of the "micro auth system" decided to add a page that allows a player to change a password, or edit an In Game Skin, it's up to the user to decide whether he will add such a system to prevent CSRF.