Hacking [RELEASE]Moon Whitelister - Play whitelist-blocked games on the PlayStation (Vita) TV

gnmmarechal

Well-Known Member
OP
Member
GBAtemp Patron
Joined
Jul 13, 2014
Messages
6,038
Trophies
2
Age
25
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
5,983
Country
Portugal
Moon Whitelister is my own implementation of the whitelist patch described here. Since the whitelist resets when you shut down the system, you must run this application every time you boot (after enabling HENkaku, of course), if you want to play blocked games (like Gravity Rush, WipeOut 2048, etc.).

You can download this application through my website:
http://gs2012.xyz/psv/moon-whitelister


Credits

- Wololo for posting that tutorial on patching the whitelist and providing the two required files.
- @Rinnegatamante for Lua Player Plus Vita and testing.


This doesn't use any code from the other available whitelist app. About the similarities between icons/images used, that's because I was the one who made them for the other app in the first place, and even then I didn't really have any ideas, so I ended up re-using those and changing the colour of the icon and adding a Lua logo. Also, I came up with the idea to automate this before the author published his app, so I decided to do it anyway to check out LPP-Vita.
 

gnmmarechal

Well-Known Member
OP
Member
GBAtemp Patron
Joined
Jul 13, 2014
Messages
6,038
Trophies
2
Age
25
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
5,983
Country
Portugal
Last edited by gnmmarechal,
D

Deleted User

Guest
Hey, this looks to be a very useful application for users! The fact that it patches automatically at the touch of a button will make it even easier and quicker than the existing methods at the moment! :)
 

metroid maniac

An idiot with an opinion
Member
Joined
May 16, 2009
Messages
2,079
Trophies
2
XP
2,612
Country
If you could point me to a more recent patch, I'd certainly add it.

To install the v2 whitelist hack you need to execute the following SQL query on app.db
Code:
CREATE TRIGGER CHANGE_CATEGORY_GPC AFTER INSERT ON tbl_appinfo WHEN new.val LIKE 'gpc' BEGIN UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid; END; CREATE TRIGGER CHANGE_CATEGORY_GP AFTER INSERT ON tbl_appinfo WHEN new.val LIKE 'gp' BEGIN UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid; END; CREATE TRIGGER CHANGE_CATEGORY_GDC AFTER INSERT ON tbl_appinfo WHEN new.val LIKE 'gdc' BEGIN UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid; END; CREATE TRIGGER CHANGE_CATEGORY_GD AFTER INSERT ON tbl_appinfo WHEN new.val LIKE 'gd' BEGIN UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid; END;
 

gnmmarechal

Well-Known Member
OP
Member
GBAtemp Patron
Joined
Jul 13, 2014
Messages
6,038
Trophies
2
Age
25
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
5,983
Country
Portugal
To install the v2 whitelist hack you need to execute the following SQL query on app.db
Code:
CREATE TRIGGER CHANGE_CATEGORY_GPC AFTER INSERT ON tbl_appinfo WHEN new.val LIKE 'gpc' BEGIN UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid; END; CREATE TRIGGER CHANGE_CATEGORY_GP AFTER INSERT ON tbl_appinfo WHEN new.val LIKE 'gp' BEGIN UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid; END; CREATE TRIGGER CHANGE_CATEGORY_GDC AFTER INSERT ON tbl_appinfo WHEN new.val LIKE 'gdc' BEGIN UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid; END; CREATE TRIGGER CHANGE_CATEGORY_GD AFTER INSERT ON tbl_appinfo WHEN new.val LIKE 'gd' BEGIN UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid; END;
Huh, apparently, I won't be able to do this in Lua. I'll look into doing it in C, but I have little experience with it, so I might end up not doing it.
 

gnmmarechal

Well-Known Member
OP
Member
GBAtemp Patron
Joined
Jul 13, 2014
Messages
6,038
Trophies
2
Age
25
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
5,983
Country
Portugal
To install the v2 whitelist hack you need to execute the following SQL query on app.db
Code:
CREATE TRIGGER CHANGE_CATEGORY_GPC AFTER INSERT ON tbl_appinfo WHEN new.val LIKE 'gpc' BEGIN UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid; END; CREATE TRIGGER CHANGE_CATEGORY_GP AFTER INSERT ON tbl_appinfo WHEN new.val LIKE 'gp' BEGIN UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid; END; CREATE TRIGGER CHANGE_CATEGORY_GDC AFTER INSERT ON tbl_appinfo WHEN new.val LIKE 'gdc' BEGIN UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid; END; CREATE TRIGGER CHANGE_CATEGORY_GD AFTER INSERT ON tbl_appinfo WHEN new.val LIKE 'gd' BEGIN UPDATE tbl_appinfo SET val='gdb' WHERE key='566916785' and titleid=new.titleid; END;
Huh, @Rinnegatamante seems to have started work on a v1+v2 patcher :)
If he gets that to work, it'll be cool.

EDIT: is v2 permanent, and is it a replacement for v1, or must it be used alongside v1?

Sent from my Nokia 3310 using Tapatalk
 
Last edited by gnmmarechal,

gnmmarechal

Well-Known Member
OP
Member
GBAtemp Patron
Joined
Jul 13, 2014
Messages
6,038
Trophies
2
Age
25
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
5,983
Country
Portugal
Why don't you white list people update the version dat too? Then it shouldn't reset on reboot/update.
Huh, what do you mean exactly? I'll look into it, if possible it'll be awesome. I'll boot my PC in a little while to research this.
 
  • Like
Reactions: xande333

gnmmarechal

Well-Known Member
OP
Member
GBAtemp Patron
Joined
Jul 13, 2014
Messages
6,038
Trophies
2
Age
25
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
5,983
Country
Portugal
Why do you need a pc app? You can build sqlite for vita.
@Rinnegatamante started writing a v2 patcher for the Vita with SQLite, but apparently sqlite for the Vita seems to broken, and he didn't get it to work.
 

Site & Scene News

Popular threads in this forum

General chit-chat
Help Users
    Xdqwerty @ Xdqwerty: I cant tell what my favorite N64 game is