circlepic.js

function returnImage(who, locale, source) {

    var dbtable = ""
    switch (locale) {
    case "temp":
        dbtable = "TempCards"
        break
    case "region":
        dbtable = "RegCards"
        break
    case "global":
        dbtable = "GlobCards"
        break
    case "saved":
        dbtable = "SavedCards"
        break
    case "mycard":
        dbtable = "Card"
        break
    default:
        dbtable = "TempCards"
        break
    }

    var dataStr = "SELECT avatar FROM " + dbtable + " WHERE id ='" + who + "'"
    var ava = ""

    if (source.length > 4) {

        if (source.search("/9j/4A") !== -1 && source.search(
                    "data:image/jpeg;base64") === -1) {
            ava = "data:image/jpeg;base64, " + source.replace(/ /g, "+")
            fixpic = ava
        } else {
            fixpic = source
        }
    } else if (locale.length > 1) {

        if (locale !== "mycard") {
            db.transaction(function (tx) {

                tx.executeSql(
                            'CREATE TABLE IF NOT EXISTS TempCards(id INT UNIQUE, name TEXT, phone TEXT, email TEXT,company TEXT,alias TEXT, motto TEXT,main TEXT,website1 TEXT,website2 TEXT,website3 TEXT,website4 TEXT,avatar TEXT, cardback TEXT,stamp INT,cat TEXT,cardsop INT)')

                tx.executeSql(
                            'CREATE TABLE IF NOT EXISTS RegCards(id INT UNIQUE, name TEXT, phone TEXT, email TEXT,company TEXT,alias TEXT, motto TEXT,main TEXT,website1 TEXT,website2 TEXT,website3 TEXT,website4 TEXT,avatar TEXT, cardback TEXT,stamp INT,cat TEXT,cardsop INT)')

                tx.executeSql(
                            'CREATE TABLE IF NOT EXISTS SavedCards(id INT UNIQUE, name TEXT,phone TEXT,email TEXT,company TEXT,alias TEXT, motto TEXT,main TEXT,website1 TEXT,website2 TEXT,website3 TEXT,website4 TEXT,avatar TEXT, cardback TEXT,cat TEXT,cardsop INT)')

                tx.executeSql(
                            'CREATE TABLE IF NOT EXISTS GlobCards(id INT UNIQUE, name TEXT, phone TEXT, email TEXT,company TEXT,alias TEXT, motto TEXT,main TEXT,website1 TEXT,website2 TEXT,website3 TEXT,website4 TEXT,avatar TEXT, cardback TEXT,stamp INT,cat TEXT,cardsop INT)')

                var pull = tx.executeSql(dataStr)

                if (pull.rows.length === 1) {

                    if (pull.rows.item(0).avatar === null) {
                        ava = "img/default_avatar.png"
                    } else {
                        ava = pull.rows.item(0).avatar
                        if (ava.search("/9j/4A") != -1 && ava.search(
                                    "data:image/jpeg;base64") == -1) {
                            ava = "data:image/jpeg;base64, " + ava.replace(
                                        / /g, "+")
                        }
                    }
                    fixpic = ava
                } else {
                    ava = currentcard_avatarimg
                }
            })
            fixpic = ava
        } else {

            dataStr = "SELECT avatar FROM " + dbtable + " WHERE 1"

            db.transaction(function (tx) {
                var pull = tx.executeSql(dataStr)

                if (pull.rows.item(0).avatar.length < 4) {
                    ava = "./img/default_avatar.png"
                } else {
                    ava = pull.rows.item(0).avatar
                    if (ava.search("/9j/4A") != -1 && ava.search(
                                "data:image/jpeg;base64") == -1) {
                        ava = "data:image/jpeg;base64, " + ava.replace(/ /g,
                                                                       "+")
                    }
                }

                fixpic = ava
            })
        }
    }

    return ava
}