Bubble Creator for TheFlow's PSOne Loader

Bubble Creator for TheFlow's PSOne Loader

by szcz uru

HTML

<h1>Bubble Creator for TheFlow's PSOne Loader</h1>
<div style="text-align: left"><small>by @cm_pony, edited by szczuru for new PSOne Loader by TheFlow</small></div><br/>
<label>Bubble name:</label>
<input id="bubblename" />
<br/>
<label>Custom TitleID:</label>
<input id="titleid" maxlength="9" />
<br/>
<label>Settings game TitleID:<ll class="info">[?] <span>There's a trick to automatically use settings of an other PSone game: For example you use Tekken 2 game as base with ID SLES00255 so modify the DISC_ID of your EBOOT.PBP to SLES00255 and use SLES00255 here too. Now when you change settings in Tekken 2 and your custom PSone game will have the same settings too. <font color=red>Otherwise enter Custom TitleID here</font>.</span></ll></label>
<input id="settings" maxlength="9" />
<br/>
<label>Custom bubble icon:</label>
<input id="bubicon" />
<br/>
<label>Position at last screen:</label>
<input id="pos" type="number" max="9" />
<a href="http://hackinformer.com/PlayStationGuide/PSV/tutorials/images/appdb_iconpositions.png" target="_blank" style="text-decoration: none">Hint</a>
<br/>
<a href="#" id="doit">Generate!</a>
<br/> Paste this into SqliteBrowser:
<br/>
<textarea id="result" onclick="this.focus();this.select()"></textarea>

CSS

body {
  font-family: sans-serif
}

a:link,
a:visited {
  background-color: #f44336;
  color: white;
  padding: 10px 15px;
  text-align: center;
  text-decoration: none;
  display: inline-block;
  font-family: monospace;
}

a:hover,
a:active {
  background-color: blue;
}

input {
  width: 800px;
}

label{
    width: 200px;
    display: inline-block
}

input[type="number"] {
  width: 30px
}

a {
  font-size: 20px;
  font-weight: bold;
  margin: 20px 0px;
  display: inline-block;
}

p,
li {
  font-size: 1.4em;
}

h1 {
  font-size: 1.1em;
}

h3 {
  font-size: 1.6em;
}

page-wrap {
  margin: 20px auto;
  width: 750px;
}

textarea {
  width: 800px;
  height: 460px;
  border: 3px solid #cccccc;
  padding: 5px;
  font-family: Tahoma, sans-serif;
  color: white;
  white-space: pre;
  word-wrap: normal;
  overflow-x: scroll;
  background-image: url(http://pre10.deviantart.net/7578/th/pre/i/2005/291/e/2/psp_wallpaper_by_winterbird.jpg);
  background-position: center;
  background-size: cover;
  background-repeat: repeat;
}
ll.info{
    position:relative; /*this is the key*/
    color:#000;
    top:-1px;
    left:3px;
    text-decoration:none;
    font-weight: bold;
    text-align:center;
  }



ll.info span{display: none}

ll.info:hover span{ /*the span will display just on :hover state*/
    display:block;
    position:absolute;
    top:-110px;
    width:45em;
    border:5px solid #0cf;
    background-color:#cff; color:#000;
    text-align: center;
    padding:10px;
  }

  ll.info:hover span:after{ /*the span will display just on :hover state*/
    content:'';
    position:absolute;
    bottom:-11px;
    width:10px;
    height:10px;
    border-bottom:5px solid #0cf;
    border-right:5px solid #0cf;
    background:#cff;
    left:50%;
    margin-left:-5px;
    -moz-transform:rotate(45deg);
    -webkit-transform:rotate(45deg);
    transform:rotate(45deg);
  }

JavaScript

function defaultvalues() {
  $("#bubicon").val("vs0:app/NPXS10031/sce_sys/icon0.png");
  $("#bubblename").val("Custom Bubble Title");
  $("#titleid").val("SLES00000");
  $("#settings").val("SLES00000");
  $("#pos").val("9");
}

defaultvalues();
var sql_ph = '\
insert into `tbl_appinfo` values ("%SLES00000%", "414472871", CURRENT_TIMESTAMP);\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "566916785", "mba");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "572932585", "%BUBBLENAME%");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "714773139", "0");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "1203824812", "6.00");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "1247674377", "1");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "1615533524", "1");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "2026852709", "1");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "2275227917", "2");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "2593862978", "originalpath=ux0:pspemu/PSP/GAME/%SLES00000%&selfpath=ux0:pspemu/PSP/GAME/%SLES00000%/EBOOT.PBP&discid=%SETTINGS%&parentallevel=0&gamedataid=&appver=00.00&bootable=1&category=ME");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "2630610402", NULL);\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "2722548093", CURRENT_TIMESTAMP);\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "2840145610", "1");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "2853576962", "0");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "3022202214", "vs0:app/NPXS10028/eboot.bin");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "3168212510", "00.00");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "3480795629", "1");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "3705752058", "0");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "3794959877", "500");\r\n\
insert into `tbl_appinfo` values ("%SLES00000%", "3931254609", "0");\r\n\
insert...