Search found 335 matches

by markus_petrux
Wed Jan 04, 2006 2:11 am
Forum: SQL Parser
Topic: < & > supported?
Replies: 12
Views: 30119

Re: < & > supported?

Not sure what you mean, Nux. The SQL Parser doesn't support SELECT statements.

As per the comment about the MODSDB, oh well, anyone is free to get MODs from other sources, but that is under their own risk. ;)
by markus_petrux
Wed Jan 04, 2006 2:06 am
Forum: SQL Parser
Topic: AFTER supported y/n?
Replies: 14
Views: 29177

Re: AFTER supported y/n?

hmm... I may try to improve the parser so it generates more understandable warnings/errors. That's not easy though. Look for example the errors reported by MySQL itself "You have an error near ...". However, these things should be detected by MOD authors in the first place, so they may hav...
by markus_petrux
Wed Jan 04, 2006 2:01 am
Forum: SQL Parser
Topic: Primary Key issues
Replies: 2
Views: 9057

Re: Primary Key issues

The second syntax is what we've been seen/using, so that's the one supported by the parser. The first syntax, while it might be valid in MySQL it would make the parser more complex. Therefore, it is not supported. I believe the goal here is not to support all the possibilities of the MySQL syntax, b...
by markus_petrux
Sun Jan 01, 2006 5:04 pm
Forum: [3.0/Olympus] Discussion
Topic: "easymod" for olympus ?
Replies: 7
Views: 9070

Re: "easymod" for olympus ?

Probably, bacause (sadly) it is not possible to warrantee that EasyMOD works on all environments officially supported by phpBB itself.
by markus_petrux
Sun Jan 01, 2006 5:01 pm
Forum: SQL Parser
Topic: < & > supported?
Replies: 12
Views: 30119

Re: < & > supported?

hmm... since this is something that is dealt with by the DBAL itself, I believe any documentation related to the usage of SQL in phpBB should apply. At this moment, the SQL Parser does not perform any check against these kind of statements. Nuttzy's SQL parser was pretty similar here: INSERT and UPD...
by markus_petrux
Sun Jan 01, 2006 5:46 am
Forum: SQL Parser
Topic: < & > supported?
Replies: 12
Views: 30119

Re: < & > supported?

UPDATE, INSERT and DELETE are not touched by the parser (the phpBB DBAL should be able to handle them already). As wGEric noted, this is probably an implementation issue that affects EM 0.3.0 (and maybe the rewrite). You can always check your SQL statements here: http://sql.phpmix.com/" target=...
by markus_petrux
Sun Jan 01, 2006 5:39 am
Forum: SQL Parser
Topic: No index_name for primary keys?
Replies: 2
Views: 8910

Re: No index_name for primary keys?

The document might be confusing. I have just figured the syntax for <index_key_definiton> was not completely correct, fixed now. Ok, the index_name shouldn't be specified for PRIMARY KEYs. It is only allowed (optional) for the other type of indexes (KEY or UNIQUE). As per the document, the syntax fo...
by markus_petrux
Thu Dec 29, 2005 11:04 am
Forum: SQL Parser
Topic: AFTER supported y/n?
Replies: 14
Views: 29177

Re: AFTER supported y/n?

:)

Ah, there will probably be a good oportunity to scan all MODs for this kind of issues ...when Olympus...
by markus_petrux
Thu Dec 29, 2005 10:51 am
Forum: [3.0/Olympus] New features discussion
Topic: 1000 to 1,000
Replies: 27
Views: 28122

Re: 1000 to 1,000

:) Here's a function I wrote some time ago for the purpose (a portal I was writting). /** * Wrapper for the PHP function number_format. * * Note thousands separator and decimal point are language dependent. * * @access public * @param float The number. * @param integer Number of decimals. * @return ...
by markus_petrux
Tue Dec 27, 2005 7:49 pm
Forum: SQL Parser
Topic: AFTER supported y/n?
Replies: 14
Views: 29177

Re: AFTER supported y/n?

Well, I don't wish to decide what's a good or bad practice. Probably this is something I have not enough knowledge to do. However, while working on the parser I figured there are some things that we all have been doing that aren't completely correct. Probably because, instead of looking at all the c...