abdhay's blog

Hi,
Just to update about XOOPS porting.
Finished until step 10 out of 14 of the XOOPS installation process. All table created successfully.
 
Latest script:-

Hi,
I am stuck with this function mssql_insert_id()
I have try adding with this custom code but with NO LUCK
===============================
// New function added function mssql_insert_id() { $id = ""; $rs = mssql_query("SELECT @@identity AS id"); if ($row = mssql_fetch_row($rs)) { $id = trim($row[0]); } mssql_free_result($rs); return $id; }
=========================
The return $id is always empty.
Any ideas or solution?
 
Thanks!
 
 

Resume porting XOOPS to MS SQL.
TODO List:
1. Complete the installation insert failure for these table:-
a. groups [Done]
b. groups_users_link [Done]
c. groups_permission
d. tplsource
e. tplfile
f. newblocks
g. config [Done]
 
2. Re-test the installation process
 
[Lesson Learned for today]
1. After look around, I found out that in the word "uid" is a Microsoft SQL Server reserved word --- argh!! Now i have to re-create the table again. :D
 

Yeah! Berjaya manually porting XOOPS to MSSQL.
[at 2:52 am]

TODO List:-
1. REWRITE the file "mssql.structure.sql" to improve readability [COMPLETED @ 8:41PM]
2. Write additional CREATE INDEX to improve system performance [COMPLETED @ 8:41PM]
3. Do code tuning [IN PROGRESS]
4. Perform code reviews to find any vulnerabilities (before somebody else hack me)
5. Apply Security Patterns to XOOPS code base
6. Do Application Performance (Load and Stress) Testing using Rational Robots

Hi admin,
Can you help / check why my account suspended?
Thanks
 
 

TO DO LIST:
1. Porting XOOPS install file to use MS SQL data type. [Completed]
(1.1) Edit source code htdocs\install\page_dbsettings.php
(1.2) Create new file htdocs\install\sql\mssql.data.sql
(1.3) Create new file htdocs\install\sql\mssql.structure.sql
 
2. Do final code reviews [In going work]
 
3. FTP the new code to server [In progress]
(3.1) Need to use better and faster FTP client. Current FTP software (Core FTP Lite) is not good enough.

TO DO LIST:-
1. Understand the XOOPS architecture [in progress]
- Found a book on XOOPS --> Packt Publishing - Building Websites with Xoops
 
2. Porting the installation code to use MSSQL table data type [will do it at 9pm tonight]
 
 
 

Today's TO DO list:

My TODO list:-
1. Getting familiar with web hosting environment [Done]
1.1 The PHP Version is 5.2.6 --> Ok good!
1.2 Is the FastCGI is up and running to run PHP? --> Yup!
1.3 MSSQL Support? --> Yes!
1.4 MS SQL Library version ? --? 7.0
1.5 ODBC Support ? --? Yes
 
Nampaknya web server environment semuanya sudah ready untuk menerima aplikasi Xoops saya... hahahaha... :P
 
2. Log in to Parallels Plesk Panel [Done]