Time related **CLOSED**

[Legacy_Supreme_Pizza]

                                       //Put the new item in "vault_items"
                        string sSQLw = "insert into vault_items (player, tag, container, item, count, identified)VALUES("+ sPlayerLoginID +","+ sPlayerCharacterName +"," + sVaultTag +"," + sItem +", 1, 1)";
                        SQLExecDirect(sSQLw);
                    }
                    else
                    {
                        //Generate new item tag from list at stocks_inc_const
                        string sItem = "sStock" + "sDSixPosTagSum";

                        //get "player" and "tag" from "temp_vault"
                        string sSQLx = "SELECT `player`, `tag` , FROM temp_vault Where columnid = '" + sRowCount + "'";
                        SQLExecDirect(sSQLx);
                        string sPlayerLoginID = SQLGetData(1);
                        string sPlayerCharacterName = (SQLGetData(2));

                        //Put the new item in "vault_items"
                        string sSQLw = "insert into vault_items (player, tag, container, item, count, identified)VALUES("+ sPlayerLoginID +","+ sPlayerCharacterName +"," + sVaultTag +"," + sItem +", 1, 1)";
                        SQLExecDirect(sSQLw);
                    }
                }
                //If item is a stock
                else if (sStockCheckString == "stock")
                {
                    if (iDDFourPosTagSum >= 50)
                    {
                        //Generate new item tag from list at stocks_inc_const
                        string sItem = sStock50;

                        //get "player" and "tag" from "temp_vault"
                        string sSQLx = "SELECT `player`, `tag` , FROM temp_vault Where columnid = '" + sRowCount + "'";
                        SQLExecDirect(sSQLx);
                        string sPlayerLoginID = SQLGetData(1);
                        string sPlayerCharacterName = (SQLGetData(2));

                        //Put the new item in "vault_items"
                        string sSQLw = "insert into vault_items (player, tag, container, item, count, identified)VALUES("+ sPlayerLoginID +","+ sPlayerCharacterName +"," + sVaultTag +"," + sItem +", 1, 1)";
                        SQLExecDirect(sSQLw);
                    }
                    else
                    {
                        //Generate new item tag from list at stocks_inc_const
                        string sItem = "sStock" + "sDDFourPosTagSum";

                        //get "player" and "tag" from "temp_vault"
                        string sSQLx = "SELECT `player`, `tag` , FROM temp_vault Where columnid = '" + sRowCount + "'";
                        SQLExecDirect(sSQLx);
                        string sPlayerLoginID = SQLGetData(1);
                        string sPlayerCharacterName = (SQLGetData(2));

                        //Put the new item in "vault_items"
                        string sSQLw = "insert into vault_items (player, tag, container, item, count, identified)VALUES("+ sPlayerLoginID +","+ sPlayerCharacterName +"," + sVaultTag +"," + sItem +", 1, 1)";
                        SQLExecDirect(sSQLw);
                    }
                }
            }
        iItemCount++;
        }
    iRowCount++;
    }
string sSQLy = "DROP TABLE temp_vault";
SQLExecDirect(sSQLy);
}

Any help would be great.

Thanks!
Eli