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

gnmmarechal

Local RuneScape Enjoyer
OP
Member
GBAtemp Patron
Joined
Jul 13, 2014
Messages
6,116
Trophies
4
Age
26
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
6,437
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

Local RuneScape Enjoyer
OP
Member
GBAtemp Patron
Joined
Jul 13, 2014
Messages
6,116
Trophies
4
Age
26
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
6,437
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,164
Trophies
2
XP
3,294
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

Local RuneScape Enjoyer
OP
Member
GBAtemp Patron
Joined
Jul 13, 2014
Messages
6,116
Trophies
4
Age
26
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
6,437
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

Local RuneScape Enjoyer
OP
Member
GBAtemp Patron
Joined
Jul 13, 2014
Messages
6,116
Trophies
4
Age
26
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
6,437
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

Local RuneScape Enjoyer
OP
Member
GBAtemp Patron
Joined
Jul 13, 2014
Messages
6,116
Trophies
4
Age
26
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
6,437
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

Local RuneScape Enjoyer
OP
Member
GBAtemp Patron
Joined
Jul 13, 2014
Messages
6,116
Trophies
4
Age
26
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
6,437
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
  • No one is chatting at the moment.
  • Sicklyboy @ Sicklyboy:
    Lookin at buying another pair of regular glasses too. And maybe prescription sunglasses
  • K3Nv3 @ K3Nv3:
    Yeah most just ship off to a lab could always call around to see if new ones have in office glass cutters
  • Sicklyboy @ Sicklyboy:
    too much effort + im shy and social anxiety :( lmao
  • K3Nv3 @ K3Nv3:
    I just wear them when I drive cause I'd like to actually read signs
  • K3Nv3 @ K3Nv3:
    Think they said I'm far sighted or some bs
  • Sicklyboy @ Sicklyboy:
    My eyes aren't that bad, I need mine for driving but ever since I got my latest pair I wear them all the time when I'm home now, I never used to before
  • Sicklyboy @ Sicklyboy:
    I'm near sighted though
  • K3Nv3 @ K3Nv3:
    I feel like docs just say you're this and that for the insurance claims half the time
    +1
  • Sicklyboy @ Sicklyboy:
    But even my computer monitors, that are like 3ft away when I'm leaning back in my chair, so much easier to see now with my glasses than without
  • Sicklyboy @ Sicklyboy:
    Doc was cool though, he measured my old glasses and I wanted to try different contacts than I had had previously and he's like "hmmm I bet you're this strength and that strength" and damn dude was dead on the money
  • Sicklyboy @ Sicklyboy:
    lmao that clip
  • K3Nv3 @ K3Nv3:
    Know a guy who did laser surgery for like 2g but argued you'd never need glasses again
  • Sicklyboy @ Sicklyboy:
    laser eye surgery scares me
  • Sicklyboy @ Sicklyboy:
    The thought of any kind of surgery shit being done on my eyes gives me unbelievable amounts of dread and anxiety, and with the potential risks or side effects that laser eye surgery has, I don't think my eyes are bad enough to warrant it. I can see without my glasses - not great, but not bad either.
  • K3Nv3 @ K3Nv3:
    Yeah I feel that if it gets to the point where all I see is blurry then I might consider if
  • Skelletonike @ Skelletonike:
    Just do it like in Minority Report. Won't feel a thing.
  • Skelletonike @ Skelletonike:
    Is it the full van? If so t's suspiciously cheap.
  • Skelletonike @ Skelletonike:
    Ah, the 2000€ is only the deposit
  • SylverReZ @ SylverReZ:
    Hello? :ninja:
  • bowlerhat @ bowlerhat:
    hello
  • K @ Kai_98:
    I made a Gimp file that traces out the entire DAT0 point for the Switch OLED. Am I cool to post this in the Switch modding part of the forums?
  • Skelletonike @ Skelletonike:
    You can post anything yo
    u want (as long as it's within the rules).
    +1
    Skelletonike @ Skelletonike: You can post anything yo u want (as long as it's within the rules). +1