Yabb SE on Ms Sql instead of Mysql

[Necranom]

Hello,

I currently run a site with several thousand registered users.  I am currently ussing YABB Gold and I would like to move to YABB SE.

One of my main reasons for wanting to move to SE is the fact that it uses a DB.  I would like to be able to store all of the board and member data in a MS SQL server instead of MySQL.

I will then write a simple two way trigger that keeps my current user information in synch with the YABB SE usernames and passwords.

Is anyone aware of any attemp to run SE on MS SQL 7 or 2000?  If not could someone help me convert the DB calls to point to a MS server instead of MYSQL?

Any advice, help, or ridicule will be ost welcome.

Thanx,
Necranom

[Chris Cromer]

Right now there isn't a way to use a MSSQL database(it would require YaBBSE to be rewritten).

YaBBSE2 will have multiple database types including MSSQL when it comes out. So until then you are either going to have to use a MySQL database, or wait for YaBBSE2.

[Necranom]

Ok,

I guess I will just monkey with it until the next release...

On another note, could you tell me how to get YABBSE to store the user passwords in clear text rather than encoding them?

[Spaceman-Spiff]

wouldn't that be UNSECURE?

[Chris Cromer]

They are encrypted to keep members passwords secure. They cannot be unencrypted(without a TON of effort and time).

[Necranom]

First of all thank you for taking the time to answer my questions.

I do realize that by not encrypting the passwords the system is unsecure.  I wanted to look at teh section(s) of code in SE, that handle the encryption to see if I could a) bypass or b) modify them.

The reason I want to do this is because my other systems use a custom encryption method and I want to be able to match up vlaues from one system to another.

If the code to encrypt the passwords is spread all over the place, nevermind.  If however it is in just a few them I would greatly appreciate it if you could point me in the right direction.


Thanks again for all your help,
Necranom

[groundup]

just search for the instances of crypt(). the reason that yse won't work with mssql is because mysql isn't ascii compatible and there are queries written for mysql. If you were to take a look at all of the queries and make sure they worked in mssql, than you could. THey would probably require a lot of small changes all over the place.

[irbrian]

The biggest incompatibility I'm aware of between MySQL and MS SQL, as far as YaBB SE Classic (1.x) is concerned, is MySQL's LIMIT clause.

So far, I have not found a decent way to emulate this capability with MS SQL (or any other SQL-based database server) without adding additional lines of code.

[noir]

InterBase/Firebird 1.0 has very similar SELECT FIRST n SKIP m construction.  And SP's can do anything on the Earth anyway ... Slowly, but  still faster than PHP code itself

But after little dabbling in SE code i'd agree - porting it to anything not MySql would be tough, and optimization will be trashed completely.