Data Tables

sepultaris · Post by **sepultaris** » 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.

ZexisStryfe · Post by **ZexisStryfe** » Thu Mar 20, 2008 3:34 pm

are you using heidiSQL or command line?

sepultaris · Post by **sepultaris** » Thu Mar 20, 2008 4:23 pm

ZexisStryfe wrote:are you using heidiSQL or command line?

HeidiSQL

Post by **John Adams** » 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.

sepultaris · Post by **sepultaris** » 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

Data Tables

Data Tables

Who is online