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,040
Trophies
2
Age
25
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
6,001
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,040
Trophies
2
Age
25
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
6,001
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,088
Trophies
2
XP
2,650
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,040
Trophies
2
Age
25
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
6,001
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,040
Trophies
2
Age
25
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
6,001
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,040
Trophies
2
Age
25
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
6,001
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,040
Trophies
2
Age
25
Location
https://gs2012.xyz
Website
gs2012.xyz
XP
6,001
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
  • Sicklyboy @ Sicklyboy:
    I got the Google Pixel Pro buds, they're good enough for when I need portable audio. And some really cheap IEMs that Dankpods recommends, I think the KZ ZSN Pro
    +1
  • K3Nv2 @ K3Nv2:
    I'd stick with cheapo Chinese $10 ones quality is actually becoming on pair with name brand since name Brand usually quads the price up anyway loose one bud that's another $200
  • Sicklyboy @ Sicklyboy:
    My Pixel Pro buds shit the bed a month or two ago. My wireless charger (which they do support Qi charging) absolutely COOKED them. Caused some problem that caused the case to heat up to 180F+
  • Sicklyboy @ Sicklyboy:
    They were like 9 months out of warranty but I hit up Google support anyway and told them how hot they were getting and they replaced them with new ones because they wanted these for failure analysis lol
  • Psionic Roshambo @ Psionic Roshambo:
    lol wireless charging
  • K3Nv2 @ K3Nv2:
    Yeah that's why I can't bring myself to even spend $100 on wireless earbuds
  • Psionic Roshambo @ Psionic Roshambo:
    I think it's a cool idea but damn
  • Sicklyboy @ Sicklyboy:
    Apparently the case has a problem with >15W wireless chargers. Google design fault, that one.
  • K3Nv2 @ K3Nv2:
    I could live with wireless charging if the damn standard case doesn't block connection
  • Xdqwerty @ Xdqwerty:
    how is wireless charging possible?
  • K3Nv2 @ K3Nv2:
    Dbz said everyone has raging energy senses
    +1
  • cearp @ cearp:
    you mean generally, how does the concept work?
    +1
  • K3Nv2 @ K3Nv2:
    Copper conducting electricity or something
  • Sicklyboy @ Sicklyboy:
    @Xdqwerty, power through a coil of wire causes an electromagnetic field to be generated. Another coil of wire can be set up to harness the power from that electromagnetic field and turn it into usable energy for charging a device
  • Sicklyboy @ Sicklyboy:
    Two good videos from ElectroBOOM that touch on the subject:

    https://www.youtube.com/watch?v=TQwGjhwPEik

    https://www.youtube.com/watch?v=M2YwkAWg0_g
    +1
  • K3Nv2 @ K3Nv2:
    Elements on earth are actually more powerful than we think
  • Sicklyboy @ Sicklyboy:
    Wow I can't believe I've been watching ElectroBOOM for that long. I remember when that first video came out lol
  • Xdqwerty @ Xdqwerty:
    @Sicklyboy, i think wire chargers are more practical
  • Xdqwerty @ Xdqwerty:
    but im too stupid to know
  • K3Nv2 @ K3Nv2:
    Wired is better for faster charge but if you just leave it all night while you sleep it's good
  • K3Nv2 @ K3Nv2:
    Most wireless pads can only max 15w while average bricks are 65w
  • Xdqwerty @ Xdqwerty:
    @K3Nv2, i heard it isnt good
    Xdqwerty @ Xdqwerty: @K3Nv2, i heard it isnt good