1
gruessle
[code] block bg color change => how to?
  • 2006/7/5 1:19

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


Hi

I am sure this should be possible but everything I searched is about some theme question.

How do I change the background color
le="color: #000000"><?php In Here

or the size of size=xx-large

Thanks
Grüssle
......

http://www.vmclinks.com



2
gruessle
Xoops Categories
  • 2006/6/28 18:09

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


One of the bast futures of XOOPS is the power of GROUPS.

I would like to suggest one more future and that is XOOPS CATEGORIES.

1) Group dependend categories
2) Module dependent categories
3) Personal categories
4) See below

Global
Admin should be able to set categories and select which modules should have each category available and which Group of users may see/access them.

Group Categories
Each Group moderator can create module dependent group wide categories.

Personal
Each user should be able to create module dependent XOOPS categories like the admin but just for his own use.

4) One mode added future and you would never have to run more then one XOOPS again.
All groups and categories to be domain/subdomain dependent.
Imagine this:
You have an "Anonymous Users" entering the site though a subdomain. So if user enters your site via sub1.example.com he will see one thing and another if he enters your site via sub2.example.com.

5) Selectable themes per subdomain and you have the perfect xoops. You could even host XOOPS sides for others on one instance of XOOPS and they would newer know.

How do you like that?
Grüssle
......

http://www.vmclinks.com



3
gruessle
Going down for reboot be back in 2 min.
  • 2006/6/23 21:30

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


Is that something we can do with xoops.
You know send a popup window or something:

Server going down for reboot will be back up in 2 min.
Please stand by
Grüssle
......

http://www.vmclinks.com



4
gruessle
Re: Trouble implementing SSL login
  • 2006/6/18 19:53

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


Any solution to this yet?
Grüssle
......

http://www.vmclinks.com



5
gruessle
Re: SQL error: query requires a full tablescan
  • 2006/6/18 14:10

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


Yes and it worked
Grüssle
......

http://www.vmclinks.com



6
gruessle
Re: SQL error: query requires a full tablescan
  • 2006/6/17 18:51

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


OK

Disabled the protector and removed the two protector lines from mainfile.php.

Site is back up without protector now.

What do I need to do to get protector working again?
Grüssle
......

http://www.vmclinks.com



7
gruessle
Re: SQL error: query requires a full tablescan
  • 2006/6/17 18:31

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


I got in to the admin site like I said it shows me that green message that this is my first time in the admin area. Like on a new install.

When I clicked cancel it let me in to the admin area and I disabled the "Xoops Protector".
Now the site shows up in the user area.
Still have that Warning on top
le="color: #000000"><?php Warning: mysql_query(): Your query requires a full tablescan (table ty_config, 242 rows affected). Use EXPLAIN to optimize your query. in /home/vmc/public_html/x/modules/protector/class/protector.php on line 44


When I log out and back in I get that green "First time in admin area message"

Some thing is very wrong
Grüssle
......

http://www.vmclinks.com



8
gruessle
Re: SQL error: query requires a full tablescan
  • 2006/6/17 18:25

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


Quote:

Dave_L wrote:
EXPLAIN goes before SELECT, not after it.

But you can't just add EXPLAIN to a query in XOOPS, since the query will output diagnostics, not the needed data from the database.

You would run the EXPLAIN query using phpMyAdmin, outside of XOOPS>


OK this is what I get

le="color: #000000"><?php SQL query: EXPLAIN SELECT * FROM `ty_config` WHERE `conf_title` LIKE '_MI_PROTECTOR%' [Edit] [Skip Explain SQL] [Create PHP Code] table type possible_keys key key_len ref rows Extra ty_config ALL NULL NULL NULL NULL 242 Using where
Grüssle
......

http://www.vmclinks.com



9
gruessle
Re: SQL error: query requires a full tablescan
  • 2006/6/17 18:15

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


I also followed the blank screen instractions from the FAQ

I can login now at http://www.vmclinks.com/x/user.php

But when I go to the admin page I get
Quote:

This is your first time to enter the administration section. Press the button below to proceed."



Any ideas?
Grüssle
......

http://www.vmclinks.com



10
gruessle
Re: SQL error: query requires a full tablescan
  • 2006/6/17 17:59

  • gruessle

  • Friend of XOOPS

  • Posts: 348

  • Since: 2003/9/20


When I add EXPLAIN after SELECT the error becomes like this:
le="color: #000000"><?php Warning: mysql_query(): You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXPLAIN conf_name,conf_value FROM ty_config WHERE conf_title li in /home/vmc/public_html/x/modules/protector/class/protector.php on line 44 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/vmc/public_html/x/modules/protector/class/protector.php on line 45



When I run the QUERY in phpmyadmin I get no errors and it works fine.
le="color: #000000"><?php SELECT * FROM `ty_config` WHERE `conf_title` LIKE '_MI_PROTECTOR%'



You can check the error at
http://www.vmclinks.com/

Thank you

Gruessle
Grüssle
......

http://www.vmclinks.com




TopTop
(1) 2 3 4 ... 31 »