package Ġcom . d zen . camp fire . server . tables Ċ Ċ import Ġcom . sup . dev . java _ pc . sql . Sql Ċ Ċ object ĠT Public ations K arma Transactions Ġ{ ĊĊĠĠĠ Ġval ĠNAME Ġ= Ġ" units _ karma _ transactions " ĊĊĠĠĠ Ġval Ġid Ġ= Ġ" id " ĊĠĠĠ Ġval Ġf andom _ id Ġ= Ġ" f andom _ id " ĊĠĠĠ Ġval Ġlanguage _ id Ġ= Ġ" language _ id " ĊĠĠĠ Ġval Ġfrom _ account _ id Ġ= Ġ" from _ account _ id " ĊĠĠĠ Ġval Ġtarget _ account _ id Ġ= Ġ" target _ account _ id " ĊĠĠĠ Ġval Ġdate _ create Ġ= Ġ" date _ create " ĊĠĠĠ Ġval Ġpublication _ id Ġ= Ġ" unit _ id " ĊĠĠĠ Ġval Ġk arma _ count Ġ= Ġ" karma _ count " ĊĠĠĠ Ġval Ġchange _ account _ karma Ġ= Ġ" change _ account _ karma " ĊĠĠĠ Ġval Ġk arma _ co f Ġ= Ġ" karma _ co f " ĊĠĠĠ Ġval Ġanonymous Ġ= Ġ" anonymous " ĊĊĠĠĠ Ġval ĠPUBLIC ATION _ TYPE Ġ= ĠSql . IF NULL ("( SELECT Ġ${ TP ublic ations . publication _ type } ĠFROM Ġ${ TP ublic ations . NAME } ĠWHERE Ġ${ TP ublic ations . id } =$ publication _ id )", Ġ 0 ) ĊĠĠĠ Ġval ĠPUBLIC ATION _ PARENT _ ID Ġ= ĠSql . IF NULL ("( SELECT Ġ${ TP ublic ations . parent _ publication _ id } ĠFROM Ġ${ TP ublic ations . NAME } ĠWHERE Ġ${ TP ublic ations . id } =$ publication _ id )", Ġ 0 ) ĊĠĠĠ Ġval ĠPUBLIC ATION _ PARENT _ TYPE Ġ= ĠSql . IF NULL ("( SELECT Ġ${ TP ublic ations . publication _ type } ĠFROM Ġ${ TP ublic ations . NAME } ĠWHERE Ġ${ TP ublic ations . id } =$ PUBLIC ATION _ PARENT _ ID )", Ġ 0 ) ĊĠĠĠ Ġval ĠPUBLIC ATION _ STATUS Ġ= Ġ"( SELECT Ġ${ TP ublic ations . status } ĠFROM Ġ${ TP ublic ations . NAME } ĠWHERE Ġ${ TP ublic ations . id } =$ publication _ id )" ĊĠĠĠ Ġval ĠPUBLIC ATION _ PARENT _ STATUS Ġ= ĠSql . IF NULL ("( SELECT Ġ${ TP ublic ations . status } ĠFROM Ġ${ TP ublic ations . NAME } ĠWHERE Ġ${ TP ublic ations . id } =$ PUBLIC ATION _ PARENT _ ID )", Ġ 0 ) ĊĠĠĠ Ġval ĠFROM _ LEVEL Ġ= Ġ"( SELECT Ġ${ T Accounts . lvl } ĠFROM Ġ${ T Accounts . NAME } ĠWHERE Ġ${ T Accounts . id } =$ from _ account _ id )" ĊĠĠĠ Ġval ĠFROM _ LAST _ ON LINE _ TIME Ġ= Ġ"( SELECT Ġ${ T Accounts . last _ online _ time } ĠFROM Ġ${ T Accounts . NAME } ĠWHERE Ġ${ T Accounts . id } =$ from _ account _ id )" ĊĠĠĠ Ġval ĠFROM _ NAME Ġ= Ġ"( SELECT Ġ${ T Accounts . name } ĠFROM Ġ${ T Accounts . NAME } ĠWHERE Ġ${ T Accounts . id } =$ from _ account _ id )" ĊĠĠĠ Ġval ĠFROM _ IMAGE _ ID Ġ= Ġ"( SELECT Ġ${ T Accounts . img _ id } ĠFROM Ġ${ T Accounts . NAME } ĠWHERE Ġ${ T Accounts . id } =$ from _ account _ id )" ĊĠĠĠ Ġval ĠFROM _ SE X Ġ= Ġ"( SELECT Ġ${ T Accounts . sex } ĠFROM Ġ${ T Accounts . NAME } ĠWHERE Ġ${ T Accounts . id } =$ from _ account _ id )" ĊĠĠĠ Ġval ĠFROM _ K AR MA _ 3 0 Ġ= Ġ"( SELECT Ġ${ T Accounts . karma _ count _ 3 0 } ĠFROM Ġ${ T Accounts . NAME } ĠWHERE Ġ${ T Accounts . id } =$ from _ account _ id )" ĊĠĠĠ Ġval ĠF AN DOM _ NAME Ġ= Ġ"( SELECT Ġ${ TF andom s . name } ĠFROM Ġ${ TF andom s . NAME } ĠWHERE Ġ${ TF andom s . id } =$ f andom _ id )" ĊĠĠĠ Ġval ĠF AN DOM _ IMAGE _ ID Ġ= Ġ"( SELECT Ġ${ TF andom s . image _ id } ĠFROM Ġ${ TF andom s . NAME } ĠWHERE Ġ${ TF andom s . id } =$ f andom _ id )" ĊĠĠĠ Ġval ĠF AN DOM _ CLOSED Ġ= Ġ"( SELECT Ġ${ TF andom s . f andom _ closed } ĠFROM Ġ${ TF andom s . NAME } ĠWHERE Ġ${ TF andom s . id } =$ f andom _ id )" ĊĠĠĠ Ġval ĠF AN DOM _ K AR MA _ CO F Ġ= Ġ"( SELECT Ġ${ TF andom s . karma _ co f } ĠFROM Ġ${ TF andom s . NAME } ĠWHERE Ġ${ TF andom s . id } =$ f andom _ id )" ĊĠĠĠ Ġval ĠF AN DOM _ STATUS Ġ= Ġ"( SELECT Ġ${ TF andom s . status } ĠFROM Ġ${ TF andom s . NAME } ĠWHERE Ġ${ TF andom s . id } =$ f andom _ id )" ĊĊ Ċ } Ċ