AIM

MSN

Website URL

ICQ

Yahoo

Jabber

Skype

Location

Interests

Hi guys.
I have just one question regarding core side and using the SQL statements to update/insert datas into the database.
How could i implement the following query when a new character is created?
("UPDATE characters SET botprev_fail_account = (SELECT botprev_fail_account FROM accounts WHERE account_name=login")
I want that the new character that's created on the same account to have the botprev_fail_account value taken from the ACCOUNTS table and inserted into botprev_fail_account from CHARACTERS table.
The account_name and login have the same value.
The following code that i tried doesn't work:
try (Connection con2 = DatabaseFactory.getConnection())
{
PreparedStatement statement2 = con2.prepareStatement("UPDATE characters SET botprev_fail_account = (SELECT botprev_fail_account FROM accounts WHERE account_name=?");
statement2.setString(1, _accountName);
statement2.executeUpdate();
statement2.close();
}

Welcome to SellersAndFriends.com
DELIVERY IN 60 SECONDS* - FASTEST on the market!
AFFORDABLE PRICES - we are not the cheapest but is it worth to risk $ with super cheap prices?
200+ LOCAL PAYMENTS via G2A PAY - Visa / MasterCard / PayPal / Skrill / WM / WeChat and more!
END-GAME ITEMS - gear up now and stop wasting time on farming
BONUS ADENA TO EVERY PURCHASE - more you buy = bigger the bonus
AFFILIATE PROGRAM - recommend us to others and get commissions for their orders
TRUSTED PREMIUM SERVICE - Guaranteed protection against fraud!
PRE-ORDER ADENA and ITEMS - pre-order what u need and we will inform you when it's available
WTS Adena and Items on: NCwest NA servers [CHRONOS] [NAIA]
[TALKING-ISLAND ] [GLUDIO ] [GIRAN] [ADEN] Innova EU servers [CORE] [SKELTH] [TIAT]
even up to 15% BONUS in ADENA for your PURCHASE
*instant delivery available during our business hours: 6am - 12am UTC+1
Are you looking for someone who could constantly buy Aden and items from you?
No more time to play and you would like to quit?
CONTACT US! And let's make a DEAL :)
Stay in Touch with us!
About SellersAndFriends.com
Don't know what service You should choose? Check what makes us different from other vendors!
All you need to know about delivery time, stocks, end game item orders, and smart trading
All you need to know about supplier partnership, cash outs, gold transfer and middleman service

L2 - Core/Ramona
Cashing out and moving to the new server?
Looking for a person you can trust?
Please dont hesitate to contact me on skype!
Add me on Skype: replix-l2
I bought and sold alot of adena and chars before from people on this forum, i always payed first and received adena afterwards.
So i will use the same method, First payment by paypall only (friends and family option) and i'll log straight into the game mailing/trading you the adena.
Feel free to add me on skype, the trade will happen instantly during weekdays after 7pm cet - 1am cet (gmt +1) or on weekends olmost 24/7

WTB 2x 1x Feoh accounts on Core. Can be dualclass as well.
Preferably without gear, but brooch jewels / shirt / talisman included.
Budget is 180 EUR 300 EUR for both, price depends on the level / equipment.
I am old member here and mostly doing private trades, so first the account -> then the money. In case you wish we can use official and known middleman.
Thanks!

Hello all, I am selling adena in Innova core official server.
Price per bil: 9 eu
Stock: Medium
I accept only paypal friends & family option, please don't ask for adena first.
In case you live in Greece I also accept bank transfer.
Please send me a private message in forum, I normally respond very fast.
In the past I made successful trades with the following people:
aydeeli, SuperSale2015, Sobieski, luki133, marek29, ioakeimtar, LangGrenis
​looking for more successful trades O0

Hello, we are offering Driver services in any server needed, we have enough knowledge of any L2 update required just contact us. skype: charliedvm
you can check our other post:
core characters: http://www.maxcheaters.com/topic/180377-core-characters-feoh-99-yul-100-sos-99-iss-100-and-more/page-2

Rogue 102 / Archer 101 dual
16 AP on both ofc
All exhalted quests done.
5 slot Brouch
Four level 4 brouches (including Ruby, Amethyst, Obsidian)
Three level 3 brouches (including Red Cat Eye)
+10 Physical Reflect Shirt
+10 Shiny Shirt
Longing Talisman SOLD
Lots of ++ skills on main and sub
Augments: Giant Critical damage (+15%) / Giant Celestial and some other less important.
I would like to sell this toon with the weapon, ++++ Blessed ama dagger 2ble SA with augment +15% Skill crit damage. Weapon estimated value is ~20b. But I can sell it separately as well. SOLD
In the account there are more toons, some 97 - 98 level toons and Anakim and Lilith toons.
This toon will not be sold unless the offer is good, so calculate the items and plz don't waste my time with crap offers.
Also 2nd toon
Iss Hierophant 101 (16 AP) with subclass 97 sos tank.
Sonatas +10, PoM +10. SOLD
ITEMS FOR SALE:
Abundance level 1 talisman SOLD
7s Talisman SOLD
Sell for adena or euros.
ADENA:
Stock: 10b. Price= 10Euro/bil. SOLD
Selling method is paypal, friends n family, money first.
__________________________________________________________________________________________________________
PM on this forum, or leave your skype and I will get in touch with you when I can.