• Data Tables

Posted: **Thu Mar 20, 2008 11:55 am**

Sorry i have a newb question here. How do i edit a data table? IE: Change the MOTD on my server. or deleting an entry in a data table. cause i have about 8 different naggy's in my npc table just from playing around with the variables. could anyone type out the syntax or point me to a good tut. on how to do so? T.I.A.

Posted: **Thu Mar 20, 2008 3:34 pm**

are you using heidiSQL or command line?

Posted: **Thu Mar 20, 2008 4:23 pm**

ZexisStryfe wrote:are you using heidiSQL or command line?

HeidiSQL

Posted: **Thu Mar 20, 2008 6:55 pm**

Change the data for the "motd" variable in the `variables` table. If you are using a GUI, you should see this clearly.
Or you can run this SQL command:

Code: Select all

UPDATE `variables` set variable_value = 'My New MOTD' where variable_name = 'motd';

Replace "My New MOTD" with your text... no apostrophes.

Posted: **Thu Mar 20, 2008 7:50 pm**

John Adams wrote:Change the data for the "motd" variable in the `variables` table. If you are using a GUI, you should see this clearly.
Or you can run this SQL command:
Code: Select all
UPDATE `variables` set variable_value = 'My New MOTD' where variable_name = 'motd';
Replace "My New MOTD" with your text... no apostrophes.

Thanks so much for your help