[Help]How to make new account or id using navicat??

Page 1 of 2

05/19/2010 16:36 jalal85#1

hi all..i wanna ask about this..i just download client and Db..running good..
now i need to make new account/ID..can i use navicat??and i need to use this account as
[PM] account..
if can..can sameone tell me how..plss..i need ur help

05/19/2010 17:17 King_Arthur#2

Quote:

Originally Posted by jalal85

hi all..i wanna ask about this..i just download client and Db..running good..
now i need to make new account/ID..can i use navicat??

To use navicat to make an account run:

Code:

insert into account (name, password) values ('USERNAME',md5(concat('PASSWORD',char(0xA3,0xAC,0xA1,0xA3),"fdjf,jkgfkl")));

If you have a separate account database, run this on that database. If you only have one (my or my2) just run it as normal.

Quote:

Originally Posted by jalal85

and i need to use this account as
[PM] account..
if can..can sameone tell me how..plss..i need ur help

After you have made your character on your account run:

Code:

update cq_user set name = 'USER[PM]' where name = 'USER';

For more help on getting started running a server consider reviewing this guide: [Only registered and activated users can see links. Click Here To Register...]. Both of these questions were answered throughout the thread (not just the first post).

05/19/2010 18:10 jalal85#3

about the creating other account using navicat..Thanks...now i have made it successfully..but i cant understand how to make account PM..can u show me simple tutorial how to make...because im still newbie..plss show me.

05/19/2010 21:48 .Ash#4

Just put [PM] anywhere in your name, Like my name lol I'm FishnChips[PM]

Also, like your title, [Help]How to make new account or id using navicat??. Try [Only registered and activated users can see links. Click Here To Register...].

05/19/2010 21:52 King_Arthur#5

Quote:

Originally Posted by jalal85

about the creating other account using navicat..Thanks...now i have made it successfully..but i cant understand how to make account PM..can u show me simple tutorial how to make...because im still newbie..plss show me.

You don't make an account a PM account. You make the character a PM, it doesn't need any special account. The second script I gave you above changes the character name to include the [PM] at the end.

05/20/2010 05:37 jalal85#6

hahahhaa..i got it..thanks king_athur..nice person here..
but..now got a problem...My character Health Bar always keep low...after i take Hp potion..still the same..how to fix the character health bar??

05/20/2010 21:51 xCookieZx#7

Quote:

Originally Posted by jalal85

hahahhaa..i got it..thanks king_athur..nice person here..
but..now got a problem...My character Health Bar always keep low...after i take Hp potion..still the same..how to fix the character health bar??

in cq user just go to life and add whatever, this is moust likely happening because you have your health wayyyy too high, if you use an hp potion it brings yer health back down

06/11/2010 10:55 nadzirulx#8

hello king_arthur

i dont understand this :

Code:

insert into account (name, password) values ('USERNAME',md5(concat('PASSWORD',char(0xA3,0xAC,0 xA1,0xA3),"fdj

(name,password)

name : anyname?/password : anypassword ?

06/11/2010 11:33 javairc#9

Quote:

Originally Posted by nadzirulx

hello king_arthur

i dont understand this :

Code:

insert into account (name, password) values ('USERNAME',md5(concat('PASSWORD',char(0xA3,0xAC,0 xA1,0xA3),"fdj

(name,password)

name : anyname?/password : anypassword ?

dont lazy to learn.. u can use this then put in navicat

11/20/2010 16:31 koloidal69#10

I have finally set up a running server, now I want to create a new account/ID and password. There's only one problem. I have looked over the entire directory for the client and server files, but I have not found account.account. Where is this located? Navicat returns the message that it can't find account.account. Where is this file supposed to go and how do I create one for it to modify?

Thanks for any and all help on this> :)

11/20/2010 17:06 King_Arthur#11

Quote:

Originally Posted by koloidal69

I have finally set up a running server, now I want to create a new account/ID and password. There's only one problem. I have looked over the entire directory for the client and server files, but I have not found account.account. Where is this located? Navicat returns the message that it can't find account.account. Where is this file supposed to go and how do I create one for it to modify?

Thanks for any and all help on this> :)

Do you see an account database at all in Navicat, or do you just see a my/my2 database? If the later, you need to make an account in the account table of your my/my2 database. So you could run my query in post #2 inside your my/my2 database and then be able to login.

11/21/2010 03:18 koloidal69#12

Thanks King Arthur! I noticed that you had typed only "account", not "account.account". I took out the ".account" part (and actually did a query on "my" :rolleyes:) and Navicat ran it fine. I double checked that it had added the account id into account in "my", and there it was! I restarted the server and tried logging in under the new account. It told me the account ID or password was invalid. Not sure why it's saying that. Tried 4 times to relog in making sure I typed everything correctly but to no avail. After playing with the account for a bit, I realized that Mannequin allows for extra characters to be made under the main account ID. Problem solved! :)

Thanks again for all your help.

Best regards.

04/21/2011 07:16 fate819#13

pls upload sone pics so we know how to make a new acc in navicat pls

06/05/2011 21:59 272natan#14

i agree please provide us with some pictures on how to make a new account on navicat because we are newbies

06/05/2011 22:07 ~Sword~Stalker~.#15

he already gave the query . should he make a screenshot for clicking on copy and paste ?

Page 1 of 2