Need help with Ipower V-Bulletin server

~~BMG_Cya=-~~ · Jan 5, 2004, 01:33 AM

My whizz kid/sim buddy at this stuff has gone back to school, and I did tell him to make the forums at my site
inaccessible while they were being worked on...but...

I can't even get in my own damn forums...to make forums...locked up like Fort Knox.

I go to my V-Deck Log-in...and can see my database for the forums, which we just switched to V-Bulletin,
but all this User_admin...user_access....User_id stuff just goes clear over my head. Edit...browse..insert..

WTF?!!!!

Pretend you own a server....pretend you have no clue how to do anything except run the forums
from the forum admin CP...once you can get in there.

Feels like shi7 doesn't it? That's me...

Little uhhh help here?

It's a Linux server I believe....phpbb...v-bulletin....MySQL...some kinda shi7. This ios more frustrating
than fun.

UberLord · Jan 5, 2004, 08:30 AM

Can you log into the vB admin panel? You're not clear if you can or can't in your post

~~BMG_Cya=-~~ · Jan 5, 2004, 10:20 AM

Ahhh...a response...thank you.

Here is what I can do.

I can go to my V-Deck Admin king of the fucking hill log-in. I can log in. I can see all the database
stuff in there. I have a coupla buddies in there who are supposed to help...I could kick all their shit
out the door, and right to the damn curb. I can get access to anything...except something I
understand.

Do me a favor...go to http://f1velo-city.com

Try to get in the forums...click on members....calender...usercp...can't get in right?
Can't go anywhere...it just clicks and reloads the same damn page. Try the drop down menu
...same shit.

Now here is a sample of what I can get to...

Quote:

access Browse Select Insert Properties Drop Empty 2 MyISAM 7.0 KB
adminlog Browse Select Insert Properties Drop Empty 270 MyISAM 20.6 KB
adminutil Browse Select Insert Properties Drop Empty 1 MyISAM 2.0 KB
announcement Browse Select Insert Properties Drop Empty 0 MyISAM 3.6 KB
attachment Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
avatar Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
bbcode Browse Select Insert Properties Drop Empty 9 MyISAM 3.0 KB
calendar_events Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
customavatar Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
forum Browse Select Insert Properties Drop Empty 8 MyISAM 11.4 KB
forumpermission Browse Select Insert Properties Drop Empty 5 MyISAM 5.2 KB
icon Browse Select Insert Properties Drop Empty 14 MyISAM 4.8 KB
moderator Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
poll Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
pollvote Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
post Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
privatemessage Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
profilefield Browse Select Insert Properties Drop Empty 4 MyISAM 3.2 KB
regimage Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
replacement Browse Select Insert Properties Drop Empty 59 MyISAM 5.6 KB
replacementset Browse Select Insert Properties Drop Empty 1 MyISAM 2.2 KB
search Browse Select Insert Properties Drop Empty 1 MyISAM 4.1 KB
searchindex Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB
session Browse Select Insert Properties Drop Empty 15 HEAP 151.2 KB
setting Browse Select Insert Properties Drop Empty 172 MyISAM 45.7 KB
settinggroup Browse Select Insert Properties

Then you go somewhere else...and want an explanation about something and get this kind of
shit.

Quote:

regular expression (regex) is a powerful way of specifying a complex search.

MySQL uses Henry Spencer's implementation of regular expressions, which is aimed at conformance with POSIX 1003.2. MySQL uses the extended version.

This is a simplistic reference that skips the details. To get more exact information, see Henry Spencer's regex(7) manual page that is included in the source distribution. See section C Credits.

A regular expression describes a set of strings. The simplest regexp is one that has no special characters in it. For example, the regexp hello matches hello and nothing else.

Non-trivial regular expressions use certain special constructs so that they can match more than one string. For example, the regexp hello|word matches either the string hello or the string word.

As a more complex example, the regexp B[an]*s matches any of the strings Bananas, Baaaaas, Bs, and any other string starting with a B, ending with an s, and containing any number of a or n characters in between.

A regular expression may use any of the following special characters/constructs:

^
Match the beginning of a string.
mysql> SELECT "fo\nfo" REGEXP "^fo$"; -> 0
mysql> SELECT "fofo" REGEXP "^fo"; -> 1
$
Match the end of a string.
mysql> SELECT "fo\no" REGEXP "^fo\no$"; -> 1
mysql> SELECT "fo\no" REGEXP "^fo$"; -> 0
.
Match any character (including newline).
mysql> SELECT "fofo" REGEXP "^f.*"; -> 1
mysql> SELECT "fo\nfo" REGEXP "^f.*";

Now who the fuk would even want to read more than two lines of that shit, much less try and understand it? Might as well be saying...gsdgjaklCC8IHECLc ???l wisdghc hdwi

~~BMG_Cya=-~~ · Jan 5, 2004, 10:24 AM

Then it will give you an answer to something, but only if you have read Steve's How to Hump
Binaries guide back in the Feb 2002 Forums...article 8666735rrPPPl9836.../7.

If not go here and download this shit...then find that article....if it's not posted anywhere,
maybe someone will happen by and you can get it from them. In the meantime...
"Ghgaffg%%$bdfjwocj9oejfk>>>>--__><>KLKJJKojwioeocj

~~BMG_Cya=-~~ · Jan 5, 2004, 10:36 AM

[QUOTE][QUOTE]The is a more general way of writing regexps that match many occurrences of the previous atom. The is a more general way of writing regexps that match many occurrences of the previous atom.

Quote:

The is a more general way of writing regexps that match many occurrences of the previous atom. The is a more general way of writing regexps that match many occurrences of the previous atom.
a*
Can be written as a{0,}.
a+
Can be written as a{1,}.
a?
Can be written as a{0,1}.
To be more precise, an atom followed by a bound containing one integer i and no comma matches a sequence of exactly i matches of the atom. An atom followed by a bound containing one integer i and a comma matches a sequence of i or more matches of the atom. An atom followed by a bound containing two integers i and j matches a sequence of i through j (inclusive) matches of the atom. Both arguments must be in the range from 0 to RE_DUP_MAX (default 255), inclusive. If there are two arguments, the second must be greater than or equal to the first.
[a-dX]
[^a-dX]
Matches any character which is (or is not, if ^ is used) either a, b, c, d or X. To include a literal ] character, it must immediately follow the opening bracket [. To include a literal - character, it must be written first or last. So [0-9] matches any decimal digit. Any character that does not have a defined meaning inside a [] pair has no special meaning and matches only itself.
mysql> SELECT "aXbc" REGEXP "[a-dXYZ]"; -> 1
mysql> SELECT "aXbc" REGEXP "^[a-dXYZ]$"; -> 0
mysql> SELECT "aXbc" REGEXP "^[a-dXYZ]+$"; -> 1
mysql> SELECT "aXbc" REGEXP "^[^a-dXYZ]+$"; -> 0
mysql> SELECT "gheis" REGEXP "^[^a-dXYZ]+$"; -> 1
mysql> SELECT "gheisa" REGEXP "^[^a-dXYZ]+$"; -> 0
[[.characters.]]
The sequence of characters of that collating element. characters is either a single character or a character name like newline. You can find the full list of character names in `regexp/cname.h'.
[=character_class=]
An equivalence class, standing for the sequences of characters of all collating elements equivalent to that one, including itself. For example, if o and (+) are the members of an equivalence class, then [[=o=]], [[=(+)=]], and [o(+)] are all synonymous. An equivalence class may not be an endpoint of a range.
[:character_class:]
Within a bracket expression, the name of a character class enclosed in [: and :] stands for the list of all characters belonging to that class. Standard character class names are: Name Name Name
alnum digit punct
alpha graph space
blank lower upper
cntrl print xdigit
These stand for the character classes defined in the ctype(3) manual page. A locale may provide others. A character class may not be used as an endpoint of a range.
mysql> SELECT "justalnums" REGEXP "[[:alnum:]]+"; -> 1
mysql> SELECT "!!" REGEXP "[[:alnum:]]+"; -> 0
[[:<:]]
[[:>:]]
These match the null string at the beginning and end of a word respectively. A word is defined as a sequence of word characters which is neither preceded nor followed by word characters. A word character is an alnum character (as defined by ctype(3)) or an underscore (_).
mysql> SELECT "a word a" REGEXP "[[:<:]]word[[:>:]]"; -> 1
mysql> SELECT "a xword a" REGEXP "[[:<:]]word[[:>:]]"; -> 0
mysql> SELECT "weeknights" REGEXP "^(wee|week)(knights|nights)$"; -> 1
User Comments
Posted by dmean on May 30 2003 10:17am [Delete] [Edit]

If you are searching for literal parentheses, you have to enclose each parenthesis in brackets; otherwise, mySQL thinks they're part of the regular expression syntax. For instance:

WHERE phone REGEXP '(435)';

would return any phone numbers that have the sequence 435 in any part of the string, such as "1(801)555-4351". However:

WHERE phone REGEXP '[(]435[)]';

would return only phone numbers with (435), such as "1(435)555-5555".

Posted by dmean on May 30 2003 10:46am [Delete] [Edit]

There really should be a "see also" link to Section 3.3.4.7 "Pattern Matching" (http://www.mysql.com/doc/en/Pattern_matching.html) somewhere on this doc page. I couldn't get REGEXP to work right for me till I found a very important note on the Pattern Matching page regarding CASE-SENSITIVITY:

"Prior to MySQL Version 3.23.4, REGEXP is case sensitive.... From MySQL 3.23.4 on, to force a REGEXP comparison to be case sensitive, use the BINARY keyword to make one of the strings a binary string."

So I finally got my REGEXP (which searches for any uppercase letters in a user id) to work correctly:

mysql> SELECT * FROM user WHERE id REGEXP BINARY "[A-Z]";

Posted by Marcello Alves on June 5 2003 10:11am [Delete] [Edit]

It's far beyond the scope of this documentation to dwell on all the gory details of regular expressions. Should you have any doubts, please refer to a good book on the subject like "Mastering Regular Expressions" (http://www.oreilly.com/catalog/regex/). References online include http://sitescooper.org/tao_regexps.html and http://www.regexlib.com/

Posted by a j stiles on November 3 2003 4:30am [Delete] [Edit]

The regular expression support in MySQL seems to be based on traditional-style regex (like ereg() in PHP), not the more sophisticated regular expression matching found in Perl or PHP's preg_match(). And in case the above doesn't make it clear (being mostly SELECT statements using the function directly to return a 1 or 0), you typically would use the REGEXP function in a WHERE clause like this:

SELECT * FROM foo WHERE bar REGEXP "baz"

To match a "special" character such as $, you need to prefix it with the backslash \ character. So \$ matches an actual dollar sign. However, in almost any programming language that claims a "C-like" syntax, that backslash is likely to get picked up on as a special character. So you may need to use an extra backslash. Also, at least in Perl and PHP, the $ is a special character itself, because it indicates that what follows is a variable name - so it will need a backslash too.

In Perl or PHP, you probably will write something like this to match on a line starting with a $ sign:

$query = "SELECT * FROM `foo` WHERE `bar` REGEXP \"^\\\$\""

I'll explain the special characters in that and what they mean:
backslash, speech mark = a literal speech mark
HAT sign = beginning of line
two backslashes = a literal backslash
backslash, dollar = a literal dollar sign
backslash, speech mark = a literal speech mark

Now if you print $query, it will have the value
SELECT * FROM `foo` WHERE `bar` REGEXP "^\$"
which is what you really want, and how you would type it into the mysql command line. Remember also that PHPMyAdmin expects you to put a backslash before a backslash or apostrophe. So in PHPMyAdmin you would enter
SELECT * FROM `foo` WHERE `bar` REGEXP "^\\$"

I guess if you only want to use . and .* regular expressions, you may as well stick to using LIKE with the _ and % wildcards, as that is probably a bit faster. Finally, when using regular expressions in *any* language you need to watch out, because it is very easy to write ones that will always match, and almost as easy to write ones that will never match anything. So do check!

Posted by Joel Steele on November 13 2003 4:49pm [Delete] [Edit]

One thing to keep in mind when working with Regular Expressions in MySQL is that since the pattern is enclosed in double-quotes any character that you are attempting to escape with a \ must have two \'s

Example:

mysql> select "2c32f32g3" regexp "2.3";

+--------------------------+| "2c32f32g3" regexp "2.3" |+--------------------------+| 1 |+--------------------------+1 row in set (0.00 sec)

No good lets try escaping it.

mysql> select "2c32f32g3" regexp "2\.3";

+---------------------------+| "2c32f32g3" regexp "2\.3" |+---------------------------+| 1 |+---------------------------+1 row in set (0.00 sec)

Still no good lets try another escape to escape the escape character.

mysql> select "2c32f32g3" regexp "2\\.3";

+----------------------------+| "2c32f32g3" regexp "2\\.3" |+----------------------------+| 0 |+----------------------------+
Sweet! it worked.

Just something to keep in mind.

Posted by [name withheld] on December 1 2003 8:01am [Delete] [Edit]

A good regex book:

UberLord · Jan 5, 2004, 10:52 AM

Any chance you could state what the problem is exactly? In simple words. Maybe without as much swearing

BTW, I can't resolv that f1 address - but my works ISPs DNS servers have been shitty for months :/

~~BMG_Cya=-~~ · Jan 5, 2004, 11:16 AM

The problem is...I cannot get into my forums...which leads to my Lap Tables....which leads to
everything else in there or that will be there. I understand the Admin CP in a Forum context.
I don't understand SQL syntax and/or how to run a forum and database from the
number-crunching/programming end of things.

It's like you can get in here and know what's going on right?

People posting, cussing...]

But, if you were to go behind all this and look at the Syntax, templates, Forum persmissions
non-permissions, Drop, Hold, search, Inquire...yada yada ya...you might not know what the heck
was going on. Correct again?

I cannot get into my forums. No one I know of can get in there except one 14 year old kid
from England who is either on a LOOOOOOOOOOOOOOOOOOOOONG holiday or is back
in school. I have things I have to do to get the site up to speed to coincide with the upcoming
Formula 1 season.

I can do nothing except gain access to nerd gibberish.

UberLord · Jan 5, 2004, 11:28 AM

OK - I've finally resolved your link.
I get a default v-deck screen without any links and it just says "come back tomorrow".

Great

Get me on IM if you can - or want - to give me root access or some sort of admin access
uberlord@jabber.org (jabber)
uberl0rd@hotmail.com (msn)

Jan 5, 2004, 01:33 AM	#1
~~BMG_Cya=-~~ Banned Join Date: Mar 2003 Location: U.S.A. Posts: 721 Rep Power: 0	Need help with Ipower V-Bulletin server My whizz kid/sim buddy at this stuff has gone back to school, and I did tell him to make the forums at my site inaccessible while they were being worked on...but... I can't even get in my own damn forums...to make forums...locked up like Fort Knox. I go to my V-Deck Log-in...and can see my database for the forums, which we just switched to V-Bulletin, but all this User_admin...user_access....User_id stuff just goes clear over my head. Edit...browse..insert.. WTF?!!!! Pretend you own a server....pretend you have no clue how to do anything except run the forums from the forum admin CP...once you can get in there. Feels like shi7 doesn't it? That's me... Little uhhh help here? It's a Linux server I believe....phpbb...v-bulletin....MySQL...some kinda shi7. This ios more frustrating than fun.

Jan 5, 2004, 08:30 AM	#2
UberLord A Legend in Underwear Join Date: May 2002 Location: Unknown Posts: 5,256 Rep Power: 0	Can you log into the vB admin panel? You're not clear if you can or can't in your post __________________ Gentoo Linux - Developer (baselayout) Read my blog "I contend that we are both atheists. I just believe in one fewer god than you do. When you understand why you dismiss all the other possible gods, you will understand why I dismiss yours." Stephen Roberts

Jan 5, 2004, 10:52 AM	#6
UberLord A Legend in Underwear Join Date: May 2002 Location: Unknown Posts: 5,256 Rep Power: 0	Any chance you could state what the problem is exactly? In simple words. Maybe without as much swearing BTW, I can't resolv that f1 address - but my works ISPs DNS servers have been shitty for months :/ __________________ Gentoo Linux - Developer (baselayout) Read my blog "I contend that we are both atheists. I just believe in one fewer god than you do. When you understand why you dismiss all the other possible gods, you will understand why I dismiss yours." Stephen Roberts

Jan 5, 2004, 11:28 AM	#8
UberLord A Legend in Underwear Join Date: May 2002 Location: Unknown Posts: 5,256 Rep Power: 0	OK - I've finally resolved your link. I get a default v-deck screen without any links and it just says "come back tomorrow". Great Get me on IM if you can - or want - to give me root access or some sort of admin access uberlord@jabber.org (jabber) uberl0rd@hotmail.com (msn) __________________ Gentoo Linux - Developer (baselayout) Read my blog "I contend that we are both atheists. I just believe in one fewer god than you do. When you understand why you dismiss all the other possible gods, you will understand why I dismiss yours." Stephen Roberts

Jan 5, 2004, 10:24 AM	#4
~~BMG_Cya=-~~ Banned Join Date: Mar 2003 Location: U.S.A. Posts: 721 Rep Power: 0	Then it will give you an answer to something, but only if you have read Steve's How to Hump Binaries guide back in the Feb 2002 Forums...article 8666735rrPPPl9836.../7. If not go here and download this shit...then find that article....if it's not posted anywhere, maybe someone will happen by and you can get it from them. In the meantime... "Ghgaffg%%$bdfjwocj9oejfk>>>>--__><>KLKJJKojwioeocj

Jan 5, 2004, 11:16 AM	#7
~~BMG_Cya=-~~ Banned Join Date: Mar 2003 Location: U.S.A. Posts: 721 Rep Power: 0	The problem is...I cannot get into my forums...which leads to my Lap Tables....which leads to everything else in there or that will be there. I understand the Admin CP in a Forum context. I don't understand SQL syntax and/or how to run a forum and database from the number-crunching/programming end of things. It's like you can get in here and know what's going on right? People posting, cussing...] But, if you were to go behind all this and look at the Syntax, templates, Forum persmissions non-permissions, Drop, Hold, search, Inquire...yada yada ya...you might not know what the heck was going on. Correct again? I cannot get into my forums. No one I know of can get in there except one 14 year old kid from England who is either on a LOOOOOOOOOOOOOOOOOOOOONG holiday or is back in school. I have things I have to do to get the site up to speed to coincide with the upcoming Formula 1 season. I can do nothing except gain access to nerd gibberish.