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
In Here

or the size of [size=xx-large]size=xx-large[/size]

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
Warningmysql_query(): Your query requires a full tablescan (table ty_config242 rows affected). Use EXPLAIN to optimize your queryin /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

SQL query
EXPLAIN SELECT *
FROM `ty_config`
WHERE `conf_titleLIKE '_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:
Warningmysql_query(): You have an error in your SQL syntaxCheck 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.
SELECT *  FROM `ty_configWHERE `conf_titleLIKE '_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 »



Login

Who's Online

152 user(s) are online (105 user(s) are browsing Support Forums)


Members: 0


Guests: 152


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Dec 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits