1 Topic by bmpwe

(2 replies, posted in PunBB 1.2 modifications, plugins and integrations)

I'm looking to hire a devloper to code a administrative interface to the following MySQL tables:

-- phpMyAdmin SQL Dump

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Table structure for table `orgs`
-- 

CREATE TABLE `orgs` (
  `key` int(6) NOT NULL auto_increment,
  `name_long` varchar(50) NOT NULL default '',
  `name_short` varchar(30) NOT NULL default '',
  `street` varchar(30) NOT NULL default '',
  `city` varchar(20) NOT NULL default '',
  `state` char(2) NOT NULL default '',
  `zip` varchar(5) NOT NULL default '',
  `advisor_email` varchar(50) NOT NULL default '',
  `advisor_street` varchar(30) NOT NULL default '',
  `advisor_city` varchar(20) NOT NULL default '',
  `advisor_state` char(2) NOT NULL default '',
  `advisor_zip` int(5) NOT NULL default '0',
  `advisor_firstname` varchar(20) NOT NULL default '',
  `advisor_lastname` varchar(20) NOT NULL default '',
  `advisor_phone` varchar(15) NOT NULL default '',
  `org_url` varchar(100) NOT NULL default '',
  `school_id` varchar(4) NOT NULL default '',
  `contact_firstname` varchar(20) NOT NULL default '',
  `contact_lastname` varchar(20) NOT NULL default '',
  `contact_phone` varchar(15) NOT NULL default '',
  `contact_email` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`key`),
  UNIQUE KEY `org_url` (`org_url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `orgs`
-- 

-- 
-- Table structure for table `schools`
-- 

CREATE TABLE `schools` (
  `key` int(4) NOT NULL auto_increment,
  `name_long` varchar(50) NOT NULL default '',
  `name_short` varchar(30) NOT NULL default '',
  `street` varchar(30) NOT NULL default '',
  `city` varchar(20) NOT NULL default '',
  `state` char(2) NOT NULL default '',
  `zip` int(5) NOT NULL default '0',
  `org_phone` varchar(15) NOT NULL default '',
  `directory_phone` varchar(15) NOT NULL default '',
  `school_url` varchar(100) NOT NULL default '',
  `directory_url` varchar(100) NOT NULL default '',
  `notes` longtext NOT NULL,
  PRIMARY KEY  (`key`),
  UNIQUE KEY `name_long` (`name_long`,`name_short`,`org_phone`,`directory_phone`,`school_url`,`directory_url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `schools`
-- 

-- 
-- Table structure for table `students`
-- 

CREATE TABLE `students` (
  `key` int(8) NOT NULL auto_increment,
  `name_first` varchar(20) NOT NULL default '',
  `name_last` varchar(20) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `org_id` int(6) NOT NULL default '0',
  `school_id` int(4) NOT NULL default '0',
  PRIMARY KEY  (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `students`
-- 

-------------------------------------------------------------------------------

* I'd like the state fields to dropdowns with the state abbreviations.
* When a new org is added, the school is assigned by selecting the state from a drop down and then the school is selected from a drop down where school = selected state
* When a new org is added and assigned to a school, the city state and zip shall be defaultly copied from the school, but still be able to be edited.

Please respond by email, this thread, or 602-761-0565 with a quote. Please also include expected delivery time and information about your portifolio.

Depending on your reputation around here, I'm open to 1/3 upfront, 1/3 once completed (on your server), and 1/3 when installed to my server (virgin pun install). This all depends on the quote size. If the quote is small, we can work something out.

Also, if things work out between us, there is an oppertunity for alot of well paid, additional work.

Thanks! Hope to hear from you guys soon.

Go to forum: PunBB 1.2 modifications, plugins and integrations

2 Topic by bmpwe

(5 replies, posted in PunBB 1.2 discussion)

Hey guys,

I'm looking for someone to do some contract work. It will be some general php/mysql code that ties in with Pun.

This will be a rather large project with multiple phases. If you have a good reputation around here I wouldn't mind paying a portion up front as a good faith gesture.

If you're a developer with experience, please reply with your email and I will be incontact with you shortly.

Thanks!

Go to forum: PunBB 1.2 discussion

3 Reply by bmpwe

(5 replies, posted in PunBB 1.2 discussion)

Rickard wrote:
bmpwe wrote:

Also, if I created a few extensions (what I'm thinking of doing would be more of an addon than an extension of a current feature), and hosted the project, could I charge for the service?

If I understand you correctly, yes. The terms and conditions of the GPL only apply when and if you decide to release your derived works so that people can download them. The GPL doesn't prevent you from downloading PunBB, modifying it to your needs and using it to host a commercial service of some kind.

Thanks Rickard (and others). Keep up the good work... can't wait for 1.3!!

Go to forum: PunBB 1.2 discussion

4 Topic by bmpwe

(5 replies, posted in PunBB 1.2 discussion)

Ok, I've looked around and from what I can see selling a Extension to Punbb would go against the GPL. Is this true? Also, if I created a few extensions (what I'm thinking of doing would be more of an addon than an extension of a current feature), and hosted the project, could I charge for the service?

Thanks, guys.

Go to forum: PunBB 1.2 discussion

5 Topic by bmpwe

(1 replies, posted in PunBB 1.2 discussion)

I need to create a few hundred forums. The forum admin page seems to get a bit cumbersome after about 50.... so, I'd like to do it with php.

I've found this chunk of code in admin_forums.php (around line 37) that I believe will do the trick:

if (isset($_POST['add_forum']))
{
    confirm_referrer('admin_forums.php');

    $add_to_cat = intval($_POST['add_to_cat']);
    if ($add_to_cat < 1)
        message($lang_common['Bad request']);

    $db->query('INSERT INTO '.$db->prefix.'forums (cat_id) VALUES('.$add_to_cat.')') or error('Unable to create forum', __FILE__, __LINE__, $db->error());

How can I modify this code to simply insert a forum named $forum_name into a categorie named $categorie_name?

Thanks for any help!

Go to forum: PunBB 1.2 discussion

6 Topic by bmpwe

(0 replies, posted in Programming)

<form id="id" name="name" method="post" action="">
    <input name="textfield" value="Group #" size="7" type="text">
    <input name="Submit" value="Go!" type="submit">
</form>

Any idea how I could direct the user to 'viewtopic.php?id=foo' when foo is entered into textfield and submit is clicked?

Any ideas are welcome. thanks.

Go to forum: Programming

7 Reply by bmpwe

(2 replies, posted in PunBB 1.2 troubleshooting)

That actually worked pretty well.

Is there any way I can keep the normal links on the top and the "more links" on the side?

If you quote any code, please assume I've made the changes you reccomended above.

Thanks so much for your help.

Go to forum: PunBB 1.2 troubleshooting

8 Topic by bmpwe

(2 replies, posted in PunBB 1.2 troubleshooting)

Can anyone give me an idea how to put a sidebar like in the admin section on all pages?

I've looked at admin.tpl and it looks very simular to main.tpl. In fact I copied the contents of admin.tpl to main.tpl and nothing changed! (yes, I've made sure the file was uploaded correctly.)

I'm really frustrated about this.

Any ideas?

Go to forum: PunBB 1.2 troubleshooting

9 Reply by bmpwe

(2 replies, posted in PunBB 1.2 modifications, plugins and integrations)

mat wrote:

can u be more specific about the case?
there is no mail.tpl, only main.tpl

I ment main.tpl, error corrected.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html dir="<pun_content_direction>">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<pun_char_encoding>" />
<pun_head>
</head>
<body>

<div id="punwrap">
<div id="pun<pun_page>" class="pun">

<div id="brdheader" class="block">
    <div class="box">
        <div id="brdtitle" class="inbox">
            <pun_title>
            <pun_desc>
        </div>
        <pun_navlinks>
        <pun_status>
    </div>
</div>

<pun_announcement>

<pun_advertisement>

<pun_information>

<pun_guest_information>

<pun_main>

<pun_footer>

</div>
</div>

</body>
</html>

Go to forum: PunBB 1.2 modifications, plugins and integrations

10 Topic by bmpwe

(2 replies, posted in PunBB 1.2 modifications, plugins and integrations)

I've edited main.tpl, saved, uploaded, but nothing has changed. Any ideas?

Go to forum: PunBB 1.2 modifications, plugins and integrations

11 Topic by bmpwe

(0 replies, posted in PunBB 1.2 troubleshooting)

What I really need is sub forums. These aren't available right? Do any of you know of a free bulliten board that offers sub forums? I'd like to use punBB because of it's simplicity and small footprint... but I just don't think it's gonna work.

To try and get around the problem I've thought about using  multipal forums, such as:

/forums/business/
/forums/engineering/
/forums/nursing/
...and so on...

I htought this would work very well... but then I though of the user information. Each user would have to register in each forum.

What should I do?

Go to forum: PunBB 1.2 troubleshooting