how to add your emoney in the DB

03/01/2008 13:46 pfj511#1
do you find if you change the emoney number of your role in cq_user ,some time you cant log the game ,lol!

now i will tell you how to add your emoney in the db easily and you still can log the game!

find those column in this cq_user table : account_id emoney chk_sum

if the account_id=1 emoney=1000000000 the chk_sum must be 1001740739
if the account_id=2 emoney=1000000000 the chk_sum must be 1001740740
if the account_id=3 emoney=1000000000 the chk_sum must be 1001740741
.................................................. ...
if the account_id=n emoney=1000000000 the chk_sum must be (1001740739+n)

and here you are a new cq_user table with the right column:
Code:
name	varchar	15	0	0	0	0	0	-1		0					0	0
mate	varchar	15	0	0	0	0	0	-1	无	0					0	0
lookface	int	4	0	0	0	-1	0	0	0	0					0	0
hair	smallint	2	0	0	0	-1	0	0	0	0					0	0
length	tinyint	4	0	0	0	0	0	0	0	0					0	0
fat	tinyint	4	0	0	0	0	0	0	0	0					0	0
money	int	4	0	0	0	-1	0	0	10000000	0					0	0
money_saved	bigint	4	0	0	0	-1	0	0	350000000	0					0	0
task_data	int	3	0	0	0	-1	0	0	0	0					0	0
level	int	4	0	0	0	-1	0	0	1	0					0	0
exp	bigint	4	0	0	0	0	0	0	0	0					0	0
power	smallint	2	0	0	0	-1	0	0	0	0					0	0
constitution	smallint	2	0	0	0	-1	0	0	0	0					0	0
dexterity	smallint	2	0	0	0	-1	0	0	0	0					0	0
Speed	smallint	2	0	0	0	-1	0	0	100	0					0	0
health	smallint	6	0	0	0	-1	0	0	0	0					0	0
soul	smallint	2	0	0	0	-1	0	0	0	0					0	0
additional_point	smallint	2	0	0	0	-1	0	0	10	0					0	0
auto_allot	tinyint	1	0	0	0	-1	0	0	1	0					0	0
life	smallint	6	0	0	0	-1	0	0	0	0					0	0
mana	smallint	6	0	0	0	-1	0	0	0	0					0	0
profession	tinyint	2	0	0	0	-1	0	0	0	0					0	0
potential	int	4	0	0	0	0	0	0	0	0					0	0
pk	smallint	4	0	0	0	0	0	0	0	0					0	0
nobility	tinyint	1	0	0	0	-1	0	0	0	0					0	0
medal	varchar	64	0	0	0	0	0	0	无	0					0	0
medal_select	int	4	0	0	0	-1	0	0	2	0					0	0
metempsychosis	tinyint	1	0	0	0	-1	0	0	0	0					0	0
syndicate_id	int	4	0	0	0	-1	0	0	0	0					0	0
recordmap_id	int	4	0	0	0	-1	0	0	0	0					0	0
recordx	smallint	2	0	0	0	-1	0	0	0	0					0	0
recordy	smallint	2	0	0	0	-1	0	0	0	0					0	0
account_id	int	4	0	0	0	-1	0	0	0	0					0	0
id	int	4	0	0	-1	-1	0	0		0					-1	0
last_login	int	8	0	0	0	-1	0	0	0	0					0	0
account	varchar	15	0	0	0	0	0	0	无	0					0	0
password	varchar	15	0	0	0	0	0	0	无	0					0	0
task_mask	int	4	0	0	0	-1	-1	0	0000	0					0	0
time_of_life	int	4	0	0	0	-1	-1	0	0000	0					0	0
virtue	int	4	0	0	0	-1	-1	0	0000	0					0	0
home_id	int	4	0	0	0	-1	-1	0	0000	0					0	0
title	varchar	64	0	0	0	0	0	0		0					0	0
title_select	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
tutor_exp	int	4	0	0	0	0	0	0	0	0					0	0
tutor_level	tinyint	4	0	0	0	-1	0	0	0	0					0	0
maxlife_percent	int	4	0	0	0	-1	0	0	1000	0					0	0
mercenary_rank	tinyint	4	0	0	0	-1	0	0	0	0					0	0
mercenary_exp	smallint	4	0	0	0	-1	0	0	0	0					0	0
nobility_rank	tinyint	4	0	0	0	-1	0	0	0	0					0	0
exploit	int	4	0	0	0	-1	0	0	0	0					0	0
eud_pack_size	tinyint	4	0	0	0	0	0	0	6	0					0	0
disableFlag	int	4	0	0	0	0	0	0	0	0					0	0
soulcollected	int	10	0	-1	0	-1	-1	0	0000000000	0					0	0
soulpicelevel1	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soulpicelevel2	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soulpicelevel3	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soulpicelevel4	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soulpicelevel5	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soulpicelevel6	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soulpicelevel7	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soul_value	int	10	0	0	0	-1	-1	0	0000000000	0					0	0
brood_times	int	4	0	0	0	-1	0	0	0	0					0	0
emoney	int	4	0	0	0	-1	0	0	0	0					0	0
chk_sum	int	4	0	0	0	-1	0	0	0	0					0	0
elock	varchar	16	0	0	0	0	0	0		0					0	0
ExpBallUsage	int	4	0	0	0	0	0	0	0	0					0	0
ExpCrystalUsage	smallint	4	0	0	0	-1	0	0	0	0					0	0
cheat_time	int	4	0	0	0	-1	0	0	0	0					0	0
online_time	tinyint	4	0	0	0	0	0	0	0	0					0	0
auto_exercise	tinyint	4	0	0	0	0	0	0	0	0					0	0
last_logout	int	4	0	0	0	-1	0	0	0	0					0	0
god_status	int	4	0	0	0	-1	0	0	0	0					0	0
big_prize_fails	tinyint	4	0	0	0	-1	0	0	0	0					0	0
small_prize_fails	tinyint	4	0	0	0	-1	0	0	0	0					0	0
bonus_points	int	4	0	0	0	-1	0	0	0	0					0	0
flower	int	4	0	-1	0	-1	0	0	0	0					0	0
flower_w	int	4	0	0	0	-1	0	0	0	0					0	0
income	bigint	4	0	0	0	0	0	0	0	0					0	0
illu_ButterFly	bigint	8	0	0	0	-1	0	0	0	0					0	0
illu_Fish	bigint	8	0	0	0	-1	0	0	0	0					0	0
illu_Shell	bigint	8	0	0	0	-1	0	0	0	0					0	0
illu_Herbal	bigint	8	0	0	0	-1	0	0	0	0					0	0
illu_Ore	bigint	8	0	0	0	-1	0	0	0	0					0	0
password_id	int	4	0	0	0	0	0	0	0	0					0	0
quiz_point	int	4	0	0	0	-1	0	0	0	0					0	0
protect_state	tinyint	2	0	0	0	-1	0	0	0	0					0	0
donation	bigint	4	0	0	0	-1	0	0	0	0					0	0
wood	int	4	0	0	0	0	0	0	0	0					0	0
stone	int	4	0	0	0	-1	0	0	0	0					0	0
todo_list_mask1	int	4	0	0	0	-1	0	0	0	0					0	0
todo_list1	int	4	0	0	0	-1	0	0	0	0					0	0
todo_list_hex1	int	4	0	0	0	-1	0	0	0	0					0	0
coach	smallint	2	0	0	0	-1	0	0	0	0					0	0
coach_time	smallint	2	0	0	0	-1	0	0	0	0					0	0
coach_dead	smallint	2	0	0	0	-1	0	0	0	0					0	0
coach_date	smallint	4	0	0	0	-1	0	0	0	0					0	0
03/01/2008 20:13 DarkBebi#2
wow, pfj511, this is very helpfull, thank you so much
03/01/2008 23:13 harrypotter2#3
wow u just gave a user and pass away lo varchar varchar
04/19/2008 07:27 crueby#4
Thanks!
03/10/2009 10:53 nateije#5
Quote:
Originally Posted by pfj511 View Post
do you find if you change the emoney number of your role in cq_user ,some time you cant log the game ,lol!

now i will tell you how to add your emoney in the db easily and you still can log the game!

find those column in this cq_user table : account_id emoney chk_sum

if the account_id=1 emoney=1000000000 the chk_sum must be 1001740739
if the account_id=2 emoney=1000000000 the chk_sum must be 1001740740
if the account_id=3 emoney=1000000000 the chk_sum must be 1001740741
.................................................. ...
if the account_id=n emoney=1000000000 the chk_sum must be (1001740739+n)

and here you are a new cq_user table with the right column:
Code:
name	varchar	15	0	0	0	0	0	-1		0					0	0
mate	varchar	15	0	0	0	0	0	-1	无	0					0	0
lookface	int	4	0	0	0	-1	0	0	0	0					0	0
hair	smallint	2	0	0	0	-1	0	0	0	0					0	0
length	tinyint	4	0	0	0	0	0	0	0	0					0	0
fat	tinyint	4	0	0	0	0	0	0	0	0					0	0
money	int	4	0	0	0	-1	0	0	10000000	0					0	0
money_saved	bigint	4	0	0	0	-1	0	0	350000000	0					0	0
task_data	int	3	0	0	0	-1	0	0	0	0					0	0
level	int	4	0	0	0	-1	0	0	1	0					0	0
exp	bigint	4	0	0	0	0	0	0	0	0					0	0
power	smallint	2	0	0	0	-1	0	0	0	0					0	0
constitution	smallint	2	0	0	0	-1	0	0	0	0					0	0
dexterity	smallint	2	0	0	0	-1	0	0	0	0					0	0
Speed	smallint	2	0	0	0	-1	0	0	100	0					0	0
health	smallint	6	0	0	0	-1	0	0	0	0					0	0
soul	smallint	2	0	0	0	-1	0	0	0	0					0	0
additional_point	smallint	2	0	0	0	-1	0	0	10	0					0	0
auto_allot	tinyint	1	0	0	0	-1	0	0	1	0					0	0
life	smallint	6	0	0	0	-1	0	0	0	0					0	0
mana	smallint	6	0	0	0	-1	0	0	0	0					0	0
profession	tinyint	2	0	0	0	-1	0	0	0	0					0	0
potential	int	4	0	0	0	0	0	0	0	0					0	0
pk	smallint	4	0	0	0	0	0	0	0	0					0	0
nobility	tinyint	1	0	0	0	-1	0	0	0	0					0	0
medal	varchar	64	0	0	0	0	0	0	无	0					0	0
medal_select	int	4	0	0	0	-1	0	0	2	0					0	0
metempsychosis	tinyint	1	0	0	0	-1	0	0	0	0					0	0
syndicate_id	int	4	0	0	0	-1	0	0	0	0					0	0
recordmap_id	int	4	0	0	0	-1	0	0	0	0					0	0
recordx	smallint	2	0	0	0	-1	0	0	0	0					0	0
recordy	smallint	2	0	0	0	-1	0	0	0	0					0	0
account_id	int	4	0	0	0	-1	0	0	0	0					0	0
id	int	4	0	0	-1	-1	0	0		0					-1	0
last_login	int	8	0	0	0	-1	0	0	0	0					0	0
account	varchar	15	0	0	0	0	0	0	无	0					0	0
password	varchar	15	0	0	0	0	0	0	无	0					0	0
task_mask	int	4	0	0	0	-1	-1	0	0000	0					0	0
time_of_life	int	4	0	0	0	-1	-1	0	0000	0					0	0
virtue	int	4	0	0	0	-1	-1	0	0000	0					0	0
home_id	int	4	0	0	0	-1	-1	0	0000	0					0	0
title	varchar	64	0	0	0	0	0	0		0					0	0
title_select	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
tutor_exp	int	4	0	0	0	0	0	0	0	0					0	0
tutor_level	tinyint	4	0	0	0	-1	0	0	0	0					0	0
maxlife_percent	int	4	0	0	0	-1	0	0	1000	0					0	0
mercenary_rank	tinyint	4	0	0	0	-1	0	0	0	0					0	0
mercenary_exp	smallint	4	0	0	0	-1	0	0	0	0					0	0
nobility_rank	tinyint	4	0	0	0	-1	0	0	0	0					0	0
exploit	int	4	0	0	0	-1	0	0	0	0					0	0
eud_pack_size	tinyint	4	0	0	0	0	0	0	6	0					0	0
disableFlag	int	4	0	0	0	0	0	0	0	0					0	0
soulcollected	int	10	0	-1	0	-1	-1	0	0000000000	0					0	0
soulpicelevel1	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soulpicelevel2	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soulpicelevel3	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soulpicelevel4	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soulpicelevel5	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soulpicelevel6	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soulpicelevel7	tinyint	4	0	0	0	-1	-1	0	0000	0					0	0
soul_value	int	10	0	0	0	-1	-1	0	0000000000	0					0	0
brood_times	int	4	0	0	0	-1	0	0	0	0					0	0
emoney	int	4	0	0	0	-1	0	0	0	0					0	0
chk_sum	int	4	0	0	0	-1	0	0	0	0					0	0
elock	varchar	16	0	0	0	0	0	0		0					0	0
ExpBallUsage	int	4	0	0	0	0	0	0	0	0					0	0
ExpCrystalUsage	smallint	4	0	0	0	-1	0	0	0	0					0	0
cheat_time	int	4	0	0	0	-1	0	0	0	0					0	0
online_time	tinyint	4	0	0	0	0	0	0	0	0					0	0
auto_exercise	tinyint	4	0	0	0	0	0	0	0	0					0	0
last_logout	int	4	0	0	0	-1	0	0	0	0					0	0
god_status	int	4	0	0	0	-1	0	0	0	0					0	0
big_prize_fails	tinyint	4	0	0	0	-1	0	0	0	0					0	0
small_prize_fails	tinyint	4	0	0	0	-1	0	0	0	0					0	0
bonus_points	int	4	0	0	0	-1	0	0	0	0					0	0
flower	int	4	0	-1	0	-1	0	0	0	0					0	0
flower_w	int	4	0	0	0	-1	0	0	0	0					0	0
income	bigint	4	0	0	0	0	0	0	0	0					0	0
illu_ButterFly	bigint	8	0	0	0	-1	0	0	0	0					0	0
illu_Fish	bigint	8	0	0	0	-1	0	0	0	0					0	0
illu_Shell	bigint	8	0	0	0	-1	0	0	0	0					0	0
illu_Herbal	bigint	8	0	0	0	-1	0	0	0	0					0	0
illu_Ore	bigint	8	0	0	0	-1	0	0	0	0					0	0
password_id	int	4	0	0	0	0	0	0	0	0					0	0
quiz_point	int	4	0	0	0	-1	0	0	0	0					0	0
protect_state	tinyint	2	0	0	0	-1	0	0	0	0					0	0
donation	bigint	4	0	0	0	-1	0	0	0	0					0	0
wood	int	4	0	0	0	0	0	0	0	0					0	0
stone	int	4	0	0	0	-1	0	0	0	0					0	0
todo_list_mask1	int	4	0	0	0	-1	0	0	0	0					0	0
todo_list1	int	4	0	0	0	-1	0	0	0	0					0	0
todo_list_hex1	int	4	0	0	0	-1	0	0	0	0					0	0
coach	smallint	2	0	0	0	-1	0	0	0	0					0	0
coach_time	smallint	2	0	0	0	-1	0	0	0	0					0	0
coach_dead	smallint	2	0	0	0	-1	0	0	0	0					0	0
coach_date	smallint	4	0	0	0	-1	0	0	0	0					0	0
erk.... wat type file must i put this code... pls show screen shot or else plsss........ im still noob about hack
03/10/2009 11:01 apoxdeath#6
lmao, this post is SOOO old nateije lmfao funny
03/10/2009 14:26 nateije#7
ops....i dun look the date la............ it still work??