Add new Field to MySql Database

~~kinshi88~~ · 07/21/2008, 07:59

How would I add a new field into a table (like Characters, etc)? (LOTF source)

Like in the Characters table, there is CharName and Account and Level, etc. How would I add a new field?

emmanication · 07/21/2008, 08:25

if u dont know how to. then u dont deserve to host a server ^^

Hiyoal · 07/21/2008, 08:39

There you go

Hiyoal

SpInKsTaR · 07/21/2008, 08:42

Depends how you want to insert it..
phpMyAdmin, through the actualy mySql server cPanel etc etc
gotta explain more :X

~~kinshi88~~ · 07/21/2008, 09:32

Just 1 new field.

Lol, I can't believe I missed that, I feel retarded =P
Thanks a lot.

The_Real_Slim_Shady · 07/22/2008, 12:16

can someone put screenshot or video on how to make a new account pls ty.

nTL3fTy · 07/22/2008, 16:31

Quote:

Originally Posted by The_Real_Slim_Shady

can someone put screenshot or video on how to make a new account pls ty.

Password is set on login.

Non-GM:

Code:

INSERT INTO `accounts` (`AccountID`)
VALUES ('account_id_here');

GM:

Code:

INSERT INTO `accounts` (`AccountID`,`Status`)
VALUES ('account_id_here','8');

The_Real_Slim_Shady · 07/22/2008, 16:44

ok man but i know where to click to go to the account creation page i need picture i put in my web browser :localhost/phpmyadmin and then dont know what to do pls help me