Leonardo support forum • View topic - Standalone version?

Standalone version?

support forum

Standalone version?

Postby yli » Thu May 25, 2006 3:56 am

i'm looking for standalone version or joomla version.
i saw in config.php
this...
// opMode
// 1 = PHPnuke module
// 2 = phbb2 module
// 3 = standalone -- still work in progress
@include_once dirname(__FILE__)."/config_op_mode.php";

can i be a beta tester¿
thanks
yli
 
Posts: 2
Joined: Thu May 25, 2006 3:54 am

Postby manolis » Fri Jun 09, 2006 12:57 pm

Sure, but the code is not there yet !!!
if you feel you can help with it , please try, there are some files in the user/
dir to get you started
manolis
Site Admin
 
Posts: 152
Joined: Fri Jun 24, 2005 2:04 pm

Postby pingo » Tue Nov 27, 2007 3:18 am

Hallo
Is anybody find the solution for installing XC server in Joomla or standalone , or is that still in progress?

Best regards,
pingo
pingo
 
Posts: 5
Joined: Tue Nov 20, 2007 6:43 pm

Postby manolis » Tue Nov 27, 2007 10:15 am

Hi Pingo,

The new version 3.0 will have also support for standalone/joomla/discuz installations. Should be out before end of year.
manolis
Site Admin
 
Posts: 152
Joined: Fri Jun 24, 2005 2:04 pm

Postby manolis » Wed Dec 19, 2007 1:27 pm

v 2.9.0 is out check the downloads
manolis
Site Admin
 
Posts: 152
Joined: Fri Jun 24, 2005 2:04 pm

Postby jbrichau » Sun Dec 23, 2007 5:15 pm

This is excellent news! I managed to install a standalone version. Here are some suggestions:

Since I do not have any phpbb installed on my system, I had to create users and session tables myself, with the correct settings. I had some troubles because the user_id (== pilot_id) that was generated at first was a '0' (which is detected as a non-logged user). Anyway, I attach the sql file to generate the tables for use in a standalone version.

User registration processing wanted to insert records in the table named $users_table. However, in the standalone config, this did not seem to exist. I therefore included the following line in the /site/predefined/3/config.php file:
$users_table = 'leonardo_users';
(leonard_users is the table I created for the standalone users)

Next, a bug: My admin user did not have access to the User Administration page.
FIX: In /users/admin.php, line 15: replace the functioncall to ' is_leo_admin ' by ' auth::isAdmin '

Further, the use of output caching in mainfile.php (ob_start() ) does not seem to work (no output is generated at the end). So I turned this off.

But it all seems to run very well. I did not install maps and the OLC server yet though. But keep up the good work Manolis! And enjoy the holidays!

======= LEONARDO-STANDALONE.sql ==========
CREATE TABLE `leonardo_sessions` (
`session_id` char(32) NOT NULL,
`session_user_id` mediumint(9) NOT NULL,
`session_start` int(11) NOT NULL,
`session_time` int(11) NOT NULL,
`session_ip` char(8) NOT NULL,
`session_page` int(11) NOT NULL,
`session_logged_in` tinyint(4) NOT NULL,
`session_admin` tinyint(4) NOT NULL,
PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `leonardo_users`
--

CREATE TABLE `leonardo_users` (
`user_id` mediumint(8) NOT NULL auto_increment,
`user_active` tinyint(1) default '1',
`username` varchar(25) NOT NULL,
`user_password` varchar(32) NOT NULL,
`user_session_time` int(11) NOT NULL default '0',
`user_session_page` smallint(5) NOT NULL default '0',
`user_lastvisit` int(11) NOT NULL default '0',
`user_regdate` int(11) NOT NULL default '0',
`user_level` tinyint(4) default '0',
`user_posts` mediumint(8) unsigned NOT NULL default '0',
`user_timezone` decimal(5,2) NOT NULL default '0.00',
`user_style` tinyint(4) default NULL,
`user_lang` varchar(255) default NULL,
`user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
`user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
`user_last_privmsg` int(11) NOT NULL default '0',
`user_login_tries` smallint(5) unsigned NOT NULL default '0',
`user_last_login_try` int(11) NOT NULL default '0',
`user_emailtime` int(11) default NULL,
`user_viewemail` tinyint(1) default NULL,
`user_attachsig` tinyint(1) default NULL,
`user_allowhtml` tinyint(1) default '1',
`user_allowbbcode` tinyint(1) default '1',
`user_allowsmile` tinyint(1) default '1',
`user_allowavatar` tinyint(1) NOT NULL default '1',
`user_allow_pm` tinyint(1) NOT NULL default '1',
`user_allow_viewonline` tinyint(1) NOT NULL default '1',
`user_notify` tinyint(1) NOT NULL default '1',
`user_notify_pm` tinyint(1) NOT NULL default '0',
`user_popup_pm` tinyint(1) NOT NULL default '0',
`user_rank` int(11) default '0',
`user_avatar` varchar(100) default NULL,
`user_avatar_type` tinyint(4) NOT NULL default '0',
`user_email` varchar(255) default NULL,
`user_icq` varchar(15) default NULL,
`user_website` varchar(100) default NULL,
`user_from` varchar(100) default NULL,
`user_sig` text,
`user_sig_bbcode_uid` char(10) default NULL,
`user_aim` varchar(255) default NULL,
`user_yim` varchar(255) default NULL,
`user_msnm` varchar(255) default NULL,
`user_occ` varchar(100) default NULL,
`user_interests` varchar(255) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
PRIMARY KEY (`user_id`),
KEY `user_session_time` (`user_session_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
jbrichau
 
Posts: 7
Joined: Mon Dec 10, 2007 8:34 am

Postby pingo » Fri Feb 22, 2008 5:30 pm

Hi, I would like to install standalone version of leonardo, but I still have troubles.

I used fresh install of 2.9.02 version. Also downloaded site_2.9.01.zip renamed site_phpbb to site. Created table mentioned in post above, changed /site/predefined/3/config.php, changed config_db.php with my data, in config.php I use $opMode= 3 and also in config_op_mode.php.


When I access url i get:
-----------------------------------------------------------------------
phpBB : Critical_Error

Could not obtain lastvisit data from user table

DEBUG MODE

SQL Error : 1146 Table 'luftmandlc_leonardo.phpbb_users' doesn't exist

SELECT * FROM phpbb_users WHERE user_id = -1

Line : 70
File : /web/luftmandlc/html/leonardo/site/predefined/3/sessions.php

-----------------------------------------------------------------------


What am I missing here?
pingo
 
Posts: 5
Joined: Tue Nov 20, 2007 6:43 pm

Postby jbrichau » Mon Mar 03, 2008 8:52 pm

It seems the users table cannot be found. Which tables do you have in your database?
jbrichau
 
Posts: 7
Joined: Mon Dec 10, 2007 8:34 am

Postby pingo » Tue Mar 04, 2008 12:40 pm

I have created new database called luftmandlc_leonardo. Inside i have those tables:
+-------------------------------+
| Tables_in_luftmandlc_leonardo |
+-------------------------------+
| leonardo_airspace |
| leonardo_areas |
| leonardo_areas_takeoffs |
| leonardo_clubs |
| leonardo_clubs_flights |
| leonardo_clubs_pilots |
| leonardo_flights |
| leonardo_log |
| leonardo_maps |
| leonardo_nac_clubs |
| leonardo_photos |
| leonardo_pilots |
| leonardo_remote_pilots |
| leonardo_servers |
| leonardo_sessions |
| leonardo_stats |
| leonardo_users |
| leonardo_waypoints |
+-------------------------------+


The leonardo_users is described as:

+-----------------------+-----------------------+------+-----+-----------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+-----------------------+------+-----+-----------+----------------+
| user_id | mediumint(8) | NO | PRI | NULL | auto_increment |
| user_active | tinyint(1) | YES | | 1 | |
| username | varchar(25) | NO | | | |
| user_password | varchar(32) | NO | | | |
| user_session_time | int(11) | NO | MUL | 0 | |
| user_session_page | smallint(5) | NO | | 0 | |
| user_lastvisit | int(11) | NO | | 0 | |
| user_regdate | int(11) | NO | | 0 | |
| user_level | tinyint(4) | YES | | 0 | |
| user_posts | mediumint(8) unsigned | NO | | 0 | |
| user_timezone | decimal(5,2) | NO | | 0.00 | |
| user_style | tinyint(4) | YES | | NULL | |
| user_lang | varchar(255) | YES | | NULL | |
| user_dateformat | varchar(14) | NO | | d M Y H:i | |
| user_new_privmsg | smallint(5) unsigned | NO | | 0 | |
| user_unread_privmsg | smallint(5) unsigned | NO | | 0 | |
| user_last_privmsg | int(11) | NO | | 0 | |
| user_login_tries | smallint(5) unsigned | NO | | 0 | |
| user_last_login_try | int(11) | NO | | 0 | |
| user_emailtime | int(11) | YES | | NULL | |
| user_viewemail | tinyint(1) | YES | | NULL | |
| user_attachsig | tinyint(1) | YES | | NULL | |
| user_allowhtml | tinyint(1) | YES | | 1 | |
| user_allowbbcode | tinyint(1) | YES | | 1 | |
| user_allowsmile | tinyint(1) | YES | | 1 | |
| user_allowavatar | tinyint(1) | NO | | 1 | |
| user_allow_pm | tinyint(1) | NO | | 1 | |
| user_allow_viewonline | tinyint(1) | NO | | 1 | |
| user_notify | tinyint(1) | NO | | 1 | |
| user_notify_pm | tinyint(1) | NO | | 0 | |
| user_popup_pm | tinyint(1) | NO | | 0 | |
| user_rank | int(11) | YES | | 0 | |
| user_avatar | varchar(100) | YES | | NULL | |
| user_avatar_type | tinyint(4) | NO | | 0 | |
| user_email | varchar(255) | YES | | NULL | |
| user_icq | varchar(15) | YES | | NULL | |
| user_website | varchar(100) | YES | | NULL | |
| user_from | varchar(100) | YES | | NULL | |
| user_sig | text | YES | | NULL | |
| user_sig_bbcode_uid | char(10) | YES | | NULL | |
| user_aim | varchar(255) | YES | | NULL | |
| user_yim | varchar(255) | YES | | NULL | |
| user_msnm | varchar(255) | YES | | NULL | |
| user_occ | varchar(100) | YES | | NULL | |
| user_interests | varchar(255) | YES | | NULL | |
| user_actkey | varchar(32) | YES | | NULL | |
| user_newpasswd | varchar(32) | YES | | NULL | |


But somehow the program still searches for the 'luftmandlc_leonardo.phpbb_users'
pingo
 
Posts: 5
Joined: Tue Nov 20, 2007 6:43 pm

Postby jbrichau » Sun Mar 09, 2008 11:46 am

I guess you should look at line 70 of the predefined/3/config.php file (it's mentioned in the error message :wink: )

This is what my config file reads at those lines. Mind that I suspect that several variables defined here are not used, but I got it to work that way.

Code: Select all
// other settings that are needed

$prefix = 'phpbb';
$users_table = 'leonardo_users';
define('USERS_TABLE','leonardo_users');
define('SESSIONS_TABLE','leonardo_sessions');
define('ANONYMOUS',-1);
jbrichau
 
Posts: 7
Joined: Mon Dec 10, 2007 8:34 am

Postby pingo » Sun Mar 09, 2008 4:08 pm

All Right !

I missed that one. I changed line 28 but not 70.

Now the page actually opens, I can see template of page but also this error:

Fatal error: Cannot redeclare class ltemplate in /web/luftmandlc/html/leonardo/CL_template.php on line 30
pingo
 
Posts: 5
Joined: Tue Nov 20, 2007 6:43 pm

Postby teuzzo » Mon Dec 01, 2008 12:47 pm

Hi,
is it ready the stand-alone version?
teuzzo
 
Posts: 3
Joined: Mon Dec 01, 2008 12:38 pm


Return to Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron
Bridge by mehdiplugins.com