can someone teach me how to create an account use mysql and how to add [GM} after the name.
insert into account.account (name, password) values ('[b]USERNAME[/b]',md5(concat('[b]PASSWORD[/b]',char(0xA3,0xAC,0xA1,0xA3),"fdjf,jkgfkl"))
i had tried.. but it gives me error.Quote:
both USERNAME and PASSWORD are in clear text.Code:insert into account.account (name, password) values ('[b]USERNAME[/b]',md5(concat('[b]PASSWORD[/b]',char(0xA3,0xAC,0xA1,0xA3),"fdjf,jkgfkl"))
change account.account to my.account if you don't have account database.
Looks like you need one more ")" at the end before the semi-colon.Quote:
i had tried.. but it gives me error.
mysql> insert into account.account (name, password) values ('power',md5(concat('newbie',char(0xA3,0xAC,0xA1,0 xA3),"fdjf,jkgfkl"));
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql>
can you help me with this? thanks..
my problem solved.. thank you :)Quote:
Ok, take the rar listed below. Extract. Then click on it, put user name and password.
Copy the line it created. Then go to mysql. And click on MY or MY2 depends which data base you are using then on the top go to Console pacte code but delete one of the account.
Here is the example: User name test, password test
insert into account.account (name,password) values('test','53b6320eb06e2c62888a6d1739cd24bd'); this is the line that was given from that EO.htm
Now this is what u gonna insert into console
insert into account (name,password) values('test','53b6320eb06e2c62888a6d1739cd24bd');
Hope this helped.