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 


Using Google Sheets for Trainer Validation

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

Joined: 28 Nov 2022
Posts: 50

PostPosted: Sun Aug 20, 2023 4:57 am    Post subject: Using Google Sheets for Trainer Validation Reply with quote

Say I have this google sheets acting as a data base:
https://docs.google.com/spreadsheets/d/1OUBIrbv5ZCIyAA6o8x8re5ty79GhEdnsQgREcye5DdA/edit?usp=sharing

Now I need help with code in LUA so that if User Name and Password match then:
Code:
CETrainer.show()
else if no match then
CETrainer.hide()


The username and password would be put in text box or CEedit in a form by the user.

I know there are many related issues regarding this but for now I just want to learn this basic step before going onto fixing related security issues.

In Summary:
1. User Input Username & Password and press login button
2. Username & Password provided by user is checked against my google sheet record online over the internet
3.If match found then
Code:
CETrainer.show()
else if no match then
CETrainer.hide()


Please help with code. Thanks...
Back to top
View user's profile Send private message
AylinCE
Grandmaster Cheater Supreme
Reputation: 27

Joined: 16 Feb 2017
Posts: 1124

PostPosted: Sun Aug 20, 2023 12:16 pm    Post subject: Reply with quote

Do not confuse the same subject further.
In the previous topic I gave you a code that provides the Trainer Version (Block option for all users.) and Username and ID number (User registration or blocking option).

Examine the code and see what the functions do.
This sample code satisfies all the options you want.

The code is sampled with UDF1. Replace UDF1 with CETrainer.
Code:

local list = yourGoogleDocsList
local key = userID
local check = 0

Sl = createStringList()
Sl.Text = list
for i=0, Sl.count -1 do
 if Sl[i]==key then check=1 end
end
Sl.Destroy()

if check==1 then
 CETrainer.Show()
else
showMessage("You are not a registered user! Trainer is shutting down!")
 -- closeCE() return cafree
end

_________________
Hi Hitler Different Trainer forms for you!
https://forum.cheatengine.org/viewtopic.php?t=619279
Enthusiastic people: Always one step ahead
Do not underestimate me Master: You were a beginner in the past
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
a2z
Advanced Cheater
Reputation: 0

Joined: 28 Nov 2022
Posts: 50

PostPosted: Mon Aug 21, 2023 3:40 am    Post subject: Reply with quote

Apologies. I was not wanting to confuse subject further.

You are using "Google Docs" to keep the user data for the trainer validation.

I wanted to find out if it was possible to use "Google Sheets" instead for the trainer validation.
Back to top
View user's profile Send private message
atom0s
Moderator
Reputation: 194

Joined: 25 Jan 2006
Posts: 8489
Location: 127.0.0.1

PostPosted: Mon Aug 21, 2023 4:25 pm    Post subject: Reply with quote

This is not an advisable means of protecting your trainer. Anyone can get the URL to your sheets and just get the full list of usernames and passwords. Storing passwords like this is incredibly irresponsible as well.
_________________
- Retired.
Back to top
View user's profile Send private message Visit poster's website
AylinCE
Grandmaster Cheater Supreme
Reputation: 27

Joined: 16 Feb 2017
Posts: 1124

PostPosted: Tue Aug 22, 2023 1:38 am    Post subject: Reply with quote

I think @atom0s pointed to a different issue.
This topic is not about the Trainer lua script encryption (Protection), but may be the next step.

We are simply referring to the code that was created to collect users in a list (not necessarily real names) and restrict their use as needed.

This; It does not assume that every user is a Trainer thief. Of course, there might be a few thieves in between. Still, for the remaining users, it's a good list and reading, comparison example.

Encrypting the Trainer lua script, trying to protect it, although not enough as it should be, can be another issue or issue for the Trainer maker.

Topic now; Creating a list of users on the remote server, reading this list in the Trainer, comparing them and, if necessary, allowing or restricting use.
(I guess a few theft exceptions don't affect this rule.)

_________________
Hi Hitler Different Trainer forms for you!
https://forum.cheatengine.org/viewtopic.php?t=619279
Enthusiastic people: Always one step ahead
Do not underestimate me Master: You were a beginner in the past
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
a2z
Advanced Cheater
Reputation: 0

Joined: 28 Nov 2022
Posts: 50

PostPosted: Tue Aug 22, 2023 2:51 am    Post subject: Reply with quote

I think the debate here is different from what my question was originally.

I asked if "Google Sheets" could be used instead of "Google Docs" to keep the user registration. If so what part of code needs to change
Back to top
View user's profile Send private message
AylinCE
Grandmaster Cheater Supreme
Reputation: 27

Joined: 16 Feb 2017
Posts: 1124

PostPosted: Tue Aug 22, 2023 4:34 am    Post subject: Reply with quote

When I'm at the PC for Google Sheets, I'll see what I can do and post the result.
In my case this marks 3 weeks later.

Alternatively, a suggestion for Google Docs;
Table variation example:
1) Username. 2) User ID. 3) Start date. 4) End date. 5) Trainer name.

Google Docs variation:
User name.
User ID.
Starting date.
End date.
Trainer name.
(One blank line and other user records below.)

The information for each user record in the code is accessed as follows:
Code:
local res = 0
UserName = ""
UserID = ""
StartingDate = ""
EndDate = ""
TrainerName = ""
sl = createStringList()
sl.Text = myList
local username=""
  for i=1, sl.Count -1 do
   check1 = sl[i]
    if check1==userKey1 then res=1
     UserName = sl[tonumber(i) - 1]
     UserID = sl[i]
     StartingDate = sl[tonumber(i) + 1]
     EndDate = sl[tonumber(i) + 2]
     TrainerName = sl[tonumber(i) + 3]
     --username=sl[tonumber(i) - 1]
    end
  end
sl.Destroy()

_________________
Hi Hitler Different Trainer forms for you!
https://forum.cheatengine.org/viewtopic.php?t=619279
Enthusiastic people: Always one step ahead
Do not underestimate me Master: You were a beginner in the past
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
a2z
Advanced Cheater
Reputation: 0

Joined: 28 Nov 2022
Posts: 50

PostPosted: Wed Aug 23, 2023 10:57 am    Post subject: Reply with quote

Thank you for this and also looking forward in 3 weeks
Back to top
View user's profile Send private message
a2z
Advanced Cheater
Reputation: 0

Joined: 28 Nov 2022
Posts: 50

PostPosted: Mon Sep 18, 2023 3:13 am    Post subject: Reply with quote

Hi @AylinCE

Were you able to try "Google Sheets" as the database in place of "Google Docs" ?
Back to top
View user's profile Send private message
AylinCE
Grandmaster Cheater Supreme
Reputation: 27

Joined: 16 Feb 2017
Posts: 1124

PostPosted: Mon Sep 18, 2023 2:01 pm    Post subject: Reply with quote

a2z wrote:
Hi @AylinCE

Were you able to try "Google Sheets" as the database in place of "Google Docs" ?


I guess you don't follow the forum very well.
Post the topic you want in the relevant section.
Added some features.
All stages have been tested.

Try it and please write your suggestions under the relevant topic.

Trainer control+VIP registeration+Time limit+Google Spreadsheets
https://forum.cheatengine.org/viewtopic.php?t=621414

_________________
Hi Hitler Different Trainer forms for you!
https://forum.cheatengine.org/viewtopic.php?t=619279
Enthusiastic people: Always one step ahead
Do not underestimate me Master: You were a beginner in the past
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    Cheat Engine Forum Index -> Cheat Engine 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