Cheat Engine Forum Index Cheat Engine
The Official Site of Cheat Engine
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


How to make a login system that uses database?

 
Post new topic   Reply to topic    Cheat Engine Forum Index -> General programming
View previous topic :: View next topic  
Author Message
XxRaPiDK3LLERxX84
Advanced Cheater
Reputation: 0

Joined: 11 Oct 2015
Posts: 63

PostPosted: Wed Dec 30, 2015 4:50 pm    Post subject: How to make a login system that uses database? Reply with quote

This is the feature I keep on getting stuck on, I'm trying to improve my program that I've been working on for my steam group, however this feature is complicated. Can anyone help me? Also I'm using Visual Basics.

Thanks!
Back to top
View user's profile Send private message Send e-mail
Zanzer
I post too much
Reputation: 126

Joined: 09 Jun 2013
Posts: 3278

PostPosted: Wed Dec 30, 2015 5:24 pm    Post subject: Reply with quote

Considering a database would be useless locally, you would need to host a database and web server online.
From your client program, submit the username and password to your web server.
The web server would lookup the values within the database and return a success/failure.
Your client application would then accept/reject the login.
Of course, this approach would be easy to simply hack your client application to always receive a success message.
You would, instead, need to host all of the content online as well and your client application is merely an interface.
Good luck!
Back to top
View user's profile Send private message
Dark Byte
Site Admin
Reputation: 470

Joined: 09 May 2003
Posts: 25794
Location: The netherlands

PostPosted: Wed Dec 30, 2015 5:44 pm    Post subject: Reply with quote

Unless you trust the users 100% do NOT let it connect to the database directly, and do NOT let the user send SQL queries.

Write a web API that exposes procedures and functions which will do what you wish to the database, but only limit to what they are supposed to do.

e.g:
login(username, password) would query the database and then send a sessionid back to the user if a match. (and store the sessionid with ip in a table in the database)
example url fetch request: http://bla.com/login.php?username=xxx&password=xxx
(Which would then return a sessionid raw or in an xml file, or whatever you like to use)

fetchStats(currentsessionid) would then query the database, fetch the stats, and then send them to the user (if the ip matches the session)
example url fetch request: http://bla.com/fetchStats.php?sessionid=xxx

alternate methods:
http://bla.com/api.php?command=login&username=xxx&password=xxx
http://bla.com/api.php?command=fetchStats&sessionid=xxx

Just use your imagination

_________________
Do not ask me about online cheats. I don't know any and wont help finding them.

Like my help? Join me on Patreon so i can keep helping
Back to top
View user's profile Send private message MSN Messenger
pkedpker
Master Cheater
Reputation: 1

Joined: 11 Oct 2006
Posts: 412

PostPosted: Wed Dec 30, 2015 7:51 pm    Post subject: Reply with quote

Haha I know of 1 application for the game I play which uses MySQL for it's backend where it grabs the lastest item id list and prices and stuff like that..

I just wanted to see if it's possible I decompiled it and found the hostname to the MySQL server and tried connecting it remotely using my MySQL Query Manager and to my surprise it worked xD I seen all the tables etc.. I backed them up to my computer in case, some other guys do what I did and drop all the tables.. I did drop 1 of the tables to see if it was possible and it worked but I restored my backup after it..

Wonder if that's a security risk to the hostname as well..? since I could probably upload backdoor php scripts using the SQL query no?.

Brings me back.. when I ran a private server I wanted people to put screenshots on my little website and next day I check my computer's screenshot folder and there was a bunch of Shell.php files in there, glad those assholes didn't delete any my files, haha I checked one of them out it had full access to all my folders etc.. I got really scared and ya that's how I think my private server files got leaked.

_________________
Hacks I made for kongregate.
Kongregate Universal Badge Hack: http://forum.cheatengine.org/viewtopic.php?p=4129411
Kongreate Auto Rating/Voter hack: http://forum.cheatengine.org/viewtopic.php?t=263576
Took a test lol
Back to top
View user's profile Send private message
XxRaPiDK3LLERxX84
Advanced Cheater
Reputation: 0

Joined: 11 Oct 2015
Posts: 63

PostPosted: Thu Dec 31, 2015 3:33 am    Post subject: Reply with quote

Thanks a lot for the information! I'm currently registering MySQL which gives you 5MB of space... is that less?
Back to top
View user's profile Send private message Send e-mail
atom0s
Moderator
Reputation: 205

Joined: 25 Jan 2006
Posts: 8587
Location: 127.0.0.1

PostPosted: Fri Jan 01, 2016 3:37 am    Post subject: Reply with quote

5MB is not much space to hold information in a database. It wont take long to fill that if you store a handful of data.
_________________
- Retired.
Back to top
View user's profile Send private message Visit poster's website
XxRaPiDK3LLERxX84
Advanced Cheater
Reputation: 0

Joined: 11 Oct 2015
Posts: 63

PostPosted: Fri Jan 01, 2016 9:25 pm    Post subject: Reply with quote

atom0s wrote:
5MB is not much space to hold information in a database. It wont take long to fill that if you store a handful of data.

Thanks for the help, I'm going to try it out soon, at the moment, I'm concentrating on my cheat tables.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    Cheat Engine Forum Index -> General programming All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group

CE Wiki   IRC (#CEF)   Twitter
Third party websites