Search the Community
Showing results for tags 'sql'.
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 va
Hey guys, I have another question for you..... Whenever i try to name a pet inside game I got this error: This is the image of the problem.... Sorry for quallity I did it with phone.... Here is the SQL of my pets table in my DB -- Table structure for pets -- ---------------------------- DROP TABLE IF EXISTS `pets`; CREATE TABLE `pets` ( `item_obj_id` int(10) unsigned NOT NULL, `name` varchar(16) DEFAULT NULL, `level` smallint(2) unsigned NOT NULL, `curHp` int(9) unsigned DEFAULT '0', `curMp` int(9) unsigned DEFAULT '0', `exp` bigint(20) unsigned DEFAULT