51

(95 replies, posted in News)

Can i use hdiff with moded files

52

(5 replies, posted in PunBB 1.2 discussion)

I prefer to use CSS in web projects, Or use Tahoma font if use one font name.

53

(5 replies, posted in PunBB 1.2 discussion)

Not only Arabic have this problem, Hebrew has it, and that as like as Arabic users use Tahoma for best reading. Microsoft doing that look at the Office and you will found Tahoma there.
But some users not have Tahoma font, and i think thay are not arabs (because all of arabs useing Microsoft products), so browser will choose the second font listed in your css.

Oxygen.css

.pun PRE {FONT-FAMILY: Tahoma, monaco, "Bitstream Vera Sans Mono", "Courier New", courier, monospace}

File is functions.php
line about 818

function redirect($destination_url, $message)
{
    global $db, $pun_config, $lang_common, $pun_user;

    if ($destination_url == '')
        $destination_url = 'index.php';

Not easy to copy functions.php but if your site have already PunBB you can use it and use this function.

55

(8 replies, posted in General discussion)

I tested flyspray before long time but it is not like PunBB, i will retest it again.

I maked DBLayer for firebird 2 not 1.5, the problem in 1.5 have no LOWER function,  so i wait about a year for Firebird 2 and use it's features.

That mean not all databases support all SQL standard. and we will make some hacks and runtime modified before run the sql statment, Here you are right.
The best samples is LIMIT, Auto Increment fields, and reserved words.
DBLayer is more simple than ADOdb or others that make stupid query to retrive information not need to it, but just for make compatiple with all databases.

Before make a perfect DBLayer we must define what kind of sql we make it as start point, PunBB define a MySQL, and that put as to hack the sql statment of MySQL statment not hack the Standard SQL, and that the bad point in DBLayer.

About the coffee

When i ask my wife to make a cup of Tea, she make a Milk with Banana cocktail, just cocktail with PHP code smile

57

(8 replies, posted in General discussion)

if you have time to code, why not make somthing we need it. like as a simple bug tracker (fast and simple as PunBB).

- You can not expect what ADOdb emulate a feature not support in a database, and that emulate will make more slow to your query and more count of queries.
The best idea to make project support Standard SQL, and use databases support a Standard SQL,

- What you mean "native caching"

I think PunBB is great for both PHP veterans and newbies alike.  It's ridiculously easy to mod for veterans and is a great start for newbies to learn the scripting language.

That is right, I started with PunBB when i learned PHP, so Rickard is my teacher here without he know about that smile (without hypocrisy).

Pascal
You want to fill your gun with a bullet, but you can not find any one of it.

Visual Basic
You shoot your foot, but the bullet just drop down to your foot.

60

(17 replies, posted in PunBB 1.2 discussion)

Yeah, my coding style is actually loosely based on PunBB's style

That was i want to say, and what happen is Who taste the honey cant feel with the sugar, and every time download any script not like PunBB code i will not accept, We stick here for ever.

This is not MOD or release to download, it is just to test supporting firebird.

Download it from punbb-1.2.14-firebird-v1.zip
Install Firebird SQL 2 engine from www.firebirdsql.org, be sure it is version 2
install FlameRobin (www.flamerobin.org)
enable php_interbase.dll in php.ini
Create new database with flamerobin as "c:\temp\punbb.fdb" for example and use it in install punbb as it in "Database name" field
the default user for Firebird is SYSDBA and password MASTERKEY

Go to your forum and install PunBB with install.php

This is not MOD or Branch PunBB becuase it is hard to re MOD this PunBB every time released.

1 - insert_id function removed

There is a dblayer for Firebird2 but Firebird not have mysql_insert_id funtion
i resolved this probelm with RETURNING feature in Firebird

  insert into posts ..... returning id
 
and the firebird make it as select and retrun id value after insert the record
i pass the 'id' field name in function "execute" instead of function "query"

function execute($sql, $field_id)

2 - num_rows function removed
mysql_insert_id not found in firebird and if i emualte it useing COUNT that make PunBB so slowly
the easy way it recode the punbb and remove all uses num_rows
num_rows is uses about 70 time in all code, almost of them used to check if there is a rows result only
i replaced with fetch_row to take the same effect

and it used to take the number of rows and make a for loop, i converted to while loop

3 - function result changed

function result($query_id = 0, $row = 0);

function result($query_id = 0);

mysql_result not found in firebird so seeked record not allow in client side.

/*    $result = $db->query('SELECT id FROM '.$db->prefix.'posts WHERE topic_id='.$id.' ORDER BY posted') or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());
    $num_posts = $db->num_ro ws($result);

    for ($i = 0; $i < $num_posts; ++$i)
    {
        $cur_id = $db->result($result, $i);
        if ($cur_id == $pid)
            break;
    }
    ++$i;    // we started at 0*/
    $result = $db->query('SELECT count(id) FROM '.$db->prefix.'posts WHERE topic_id='.$id.' and id<='.$pid.' ') or error('Unable to fetch post count info', __FILE__, __LINE__, $db->error());
    //ORDER BY posted removed but ????
    //May be there is a post date less and id greater???
    $i = $db->result($result);

but we will lost the date sorted here i need some help?

4 - LIMIT changed to ROWS in DBLayer, just runtime hack to keep compatible with MYSQL

5 - "password", "message" are reserved words, i maked dummy tuntime hack to escape it but that bad,
    and change all this word in whole code by add mysql quote escape.
    i prefer change the field name

So here i ask Reckard what must i do after that:
- Keep it as Huge MOD (outch) or Branch.
- Modify PunBB 1.3 to able to be firebird support and wait for 1.3
- Nothing of above (Easy to say it smile )

62

(10 replies, posted in General discussion)

Good idea lol

That East Poll.
The problem in code viewpoll.php
Ok open viewpoll.php
goto line 212

<table style="WIDTH: auto; TABLE-LAYOUT: auto; TEXT-ALIGN: left; BORDER: 0; CELLSPACING: 0; CELLPADDING: 0;">

look at TEXT-ALIGN: left;
change it to Right but you will have problem in English, and if you removed you will have centered in IE.
i changed it to
TEXT-ALIGN: justify;
and it worked good, i do not know why but just worked smile

HI, i tried to download it from
http://www.punres.org/download.php?id=161

From wher you get it PunPoll

I will try it this night.

I login as administrator with english language to keep LTR.
About RTL in opera and firefox thay are not right support CSS RTL reading, I have some problem with backgrounds with FF and Opera, in FF i have problem with Lists squares etc..., about me i have problem to understand CSS smile .
IE is good, Microsoft always has good customers in the Middleeast big_smile

67

(5 replies, posted in Programming)

Thanks, It is not stable yet, but i am using now for make PunBB support Firebird SQL, i feel need some features like search in folders.

68

(0 replies, posted in PunBB 1.2 discussion)

Hi, i found new arabic translation come to download page, there is many changes in it.
The idea this the new one it's depend on popular arabic forums, useing some word not exaclty must be in forums, and it is done the same first by my sister as like Fhd do it, but i found as in official must have a pure arabic language agreeable with all accents, i make many changes on my sister translation try like

Thay translat
Post -> ??????
But ?????? mean "subscription"
also subscription translated as same word
subscription -> ??????

My translation
Post -> ??????
?????? mean arabic to english interposition or post and used in real forums like poem forum on TV for example

I spent a long time to make it, there is many words i care about it to remove confused ones, and also may be have a grammer mistakes.

Fhd return to the old translation as my sister (Ruba) maked, bofore that he discuses with me in my forum about some mistakes in my tranlation without mention it at all, the post in 2006-01-20
http://www.parmaja.com/forums/viewtopic.php?id=76

if you like you can make Fhd translation as a colloquial trqnslation in download page

69

(1,382 replies, posted in General discussion)

we

you need only, and it is compatible with 1.2.12
punbb-1.2.11-style_rtl.zip
extract it and apply the MOD readme

71

(5 replies, posted in Programming)

This my editor i used at my home and work for PHP, in this days i am stuck with a hard contract (about one month), and i have no time to more testing, if you like a simple editor then try it and post the bugs in sourceforge.

I hope it be useful for one another of me smile

PHP editor, Maked to be light, easy and simple, integrated with PHP by php4delphi component, Highlight by SynEdit component, Debuging XDebug.org DBGp protocol, has internal console for learning php easy, Run, Check, Breakpoints and Watches

http://sourceforge.net/projects/lightphpedit/

72

(1,382 replies, posted in General discussion)

me

73

(114 replies, posted in Programming)

I worked in the past on 8088 with green monitor, 80 char is wide of screen when you write a program.
Now i always disable the right margine in my editor because i like to write long lines, i hate wrape lines.

I released Alpha version of my editor (PHP Light Edit) in sourceforge.net but still need testing and testing, i tried to force my friend to use it, but thay like the huge editors with many features.

For that i asked what mean "Unix tabs", but why want it how old you tongue ?

74

(1,382 replies, posted in General discussion)

zoom

75

(114 replies, posted in Programming)

What mean "Unix tabs"?