[MRLindstrom]

Is there a way to define a different table name for admins other than the default "admin"?

[Zor]

Yes edit the .sma and change the name of the thing...

dbi_query(sql,"CREATE TABLE IF NOT EXISTS <b>admins</b> ( auth varchar(32) NOT NULL default '', password varchar(32) NOT NULL default '', access varchar(32) NOT NULL default '', flags varchar(32) NOT NULL default '' )")
  
  new Result = dbi_query(sql,"SELECT auth,password,access,flags FROM <b>admins</b>")

Then your good to go. Just compile it again and replace the version you have on your server and voila...

Cheers!

[MRLindstrom]

I ran a search on the directory for the string

new Result = dbi_query(sql,"SELECT auth,password,access 

and I couldn't find it in any file... which .sma file is that?

[QwertyAccess]

Originally Posted by Zor Yes edit the .sma and change the name of the thing... dbi_query(sql,"CREATE TABLE IF NOT EXISTS <b>admins</b> ( auth varchar(32) NOT NULL default '', password varchar(32) NOT NULL default '', access varchar(32) NOT NULL default '', flags varchar(32) NOT NULL default '' )")     new Result = dbi_query(sql,"SELECT auth,password,access,flags FROM <b>admins</b>") Then your good to go. Just compile it again and replace the version you have on your server and voila... Cheers!

Zor you nubcakes thats from the admin.sma in 0.20 CVS

[BigBaller]

haha yea

even the dbi module hasnt made its release yet.

[Zor]

Shit...ooops...heheheh...well same shit change the name!! Dam I was tired when I posted that one...Looked int the v0.2 stead o the v0.16! Heheheh....well ok here is the right one!

mysql_query(mysql,"CREATE TABLE IF NOT EXISTS <b><i><u>admins </u></i></b>( auth varchar(32) NOT NULL default '', password varchar(32) NOT NULL default '', access varchar(32) NOT NULL default '', flags varchar(32) NOT NULL default '' ) TYPE=MyISAM")

new mysql = mysql_query(mysql,"SELECT auth,password,access,flags FROM <b><i><u>admins</u></i></b>")

There! Hehehe....took a bit to find the old version!

Cheers