Trying to submit a forum...need help

[Chris_Seahorn]

I need someone with a PHP4 server and MySQL 4 databse server to test a forum submission. Wilbert has been trying but he's on a SQL5/PHP5 platform and the code won't work there. Anyone have some time today so I can get this tested and submitted?

WILBERT:

If I get a good test on this platform I'll send in a new package with those buttons I missed cleaned up and a few other things. Don't submit the one I sent....I'll link you to a new one if we get this sorted. :thumbsup: :grouphug:

[blanius]

Chris I tried it as well and it didn't install corretly. I believe the problem is your are trying to create a database on the server and Most often that is not allowed. Many hosting pkgs only allow one db. You should just use existing DB (query user for db name) and then create tables prefixed with bbs or something to set them appart and not conflict with other possible tables.

[Chris_Seahorn]

OK. Pull it. Thanks for the confirm. I'll submit again.

[blanius]

Email if I can help in anyway.

[Chris_Seahorn]

Submitting the replacement this minute. I dropped the swf installer and have the user fill in the blanks in the "setup.php". I can't use a dump because I need them to choose an admin account so it has to be part of the setup.php one way or another (oh what a headache I have).

Wish I had taken the easy way out because that installer took forever to make and held me up all night testing it. Just learned a lesson.

Now I'm going to catch up on that life I set aside for two months.

[blanius]

LOL sorry Chris. Installing on servers is a complex business. I've seen a number of them have issues.

[blanius]

Chris it made tables, and you can login or register but the forums don't show.

http://bretlanius.com/bbs/

[Chris_Seahorn]

Sorry...passed out. I wonder If I code you a different frontend with loadVariables for the forum cats so we can test if you would try it for me? Just a matter of swapping the swf out if it's cool.

[blanius]

send it..

[Stoke Laurie]

Just did a test login as new user on brets board, will let you log in and recognises who you are but no forum output, hope that confirms your findings.

[Chris_Seahorn]

OK...building it now. Bret...can you smoke the exchange file? I'd rather we get something there more universal than how this is going. I'm making you a new one.

WHy those aren't showing has me baffled. Is it the scripted mask?...the loadvars?....hard for me since it works here. I'm falling back to the way I used to code forum dupes and will build you one of those to test.

[Chris_Seahorn]

Hey bret...yours looks like it wants to load. Inside the forumcats clip on frame 2 there is a stop command...delete that command and give it a try....it s on the same frame as the loadvars command before the loop on frame 9 that checks to see if forumCount is empty.

I think it's not getting past that command on commercial servers.
If not I also have a test with loadvariables but I think it's the stop command.

Each major section has one (forumcats,threads,posted clips). Either way I neeed to resubmit but this would help me see which to submit.

[Chris_Seahorn]

I PM'd you a link to a package with two new fun files and one new setup.php

One fun file is the loadVars type and one is the loadVariables type. The swf in the package is the exported loadVariables type. Hopefully one of these works for you...I have one confirm and two confirms respectively but want this to work for you.

[Chris_Seahorn]

I tried to submit the one with both flavors to the Exchange to update Bret but the file is too big (4.3 megs with two fun files) . I don't know what to do now and will have to either wait for you to reply that one or the other is working so I can drop one of the fun files inside to get the size down or I will haveto figure something else out.

Nobody else is jumping in to help so if you fail to help me or simply cannot get the forum to work properly...I'm gonna ask if the download can be removed since the one listed there now is prior to these fixes and I will have to buy commercial webspace to handle it myself.

[blanius]

Chris in frame 2 of forumcats is

_root.tranny.gotoAndPlay("go");
result_lv.forumCount="";
var result_lv= new LoadVars();
result_lv.onLoad = function(success) {
if (success) {

gotoAndPlay("cont");


} else {

// txt1.htmlText= "Error In The Follies Module!";

}
};
var send_lv = new LoadVars();
send_lv.action = "getcats";

send_lv.sendAndLoad("./board.php", result_lv, "POST");
}

[Chris_Seahorn]

I don't know man. I think everything happens for a reason and this is no different. Just leave it off the Exchange. I'm just going to use it as personal code and will revisit it when I'm back on a production server. Thanks for the tries.

I haven't heard back from Planet but will notify him of the same. It must only work here out of the box. I'm going to go back through my posts and remove references of myBBS as a download to avoid confusion since I won't be resubmitting.

Thanks to Wilbert too for the help.

[blanius]

Chris I think it's in the PHP code

I changed the line in board.php
//$action = $_POST["action"];
to
$action = $_GET["action"];

so I could test the board.php

I got an error on line 300 that fail was unsupported command. Changed line 300 for fail to die and now get database error!

[blanius]

GOT IT!!! line 297 in board.php

change
$query = "SELECT * FROM myBBS_forums ORDER BY displayOrder ASC";
to
$query = "SELECT * FROM mybbs_forums ORDER BY displayOrder ASC";

and it works.

[Chris_Seahorn]

That is code reused from other backends (one of my cms systems...fail is a function) . Change it to "exit;"

[Chris_Seahorn]

It's not the backends. You can direct hit them. Force an action:

action="getcats" will force the list of categories on direct hit (since it needs no other variables it's the quickest to force test for example)

depending on what action you force...and supply actual variables for if needed...you can test every section with direct hit. Thats not it though a good thought.

Since the coding is no different than every other mysql item i've submitted...I think this is Gods way of telling me something. Don't waste another minute on it Bret...really.

I wanted a forum...so I built one and I'm using it. I tried to share it but sometimes that can't be. Now I just want to move on after so much time stressing it.

[blanius]

No really It seems my server is just case sensitive found another one at line
386

I did exactly what you suggested using GET and it failed. That's what I'm saying. So I looked at the line that failed and it was the keyword fail not supported and the upper case BBS in those lines. I changed them to die for fail and bbs instead of BBS and it works

I've almost got it working completly

[Chris_Seahorn]

Good deal. Just keep it off the Exchange.

[Chris_Seahorn]

Actually....just do what you think is best. I promised I would deliver a forum when I bought in and I try to never break a promise. Put your name and Wilberts inside the files next to mine and zip it.

That is my last submission. I promise.

[Chris_Seahorn]

People are reading my last comment as I am mad or something. I'm not...why would I be?. The file is submitted...I kept my promise of months ago and am simply walking away from file submissions. After submitting my share, I earned that choice (I think).

Like I said in earlier posts...I always wanted to submit a forum for Swish but did not want conflict with Swish-DB (who sells a swish one). IN KM...Remus is the only other KM user I know of with a forum...he doesn't sell it or distribute it ( I waited a fair amount of time to see before I started mine) so I felt a forum was fair game and something that KM users might want. I coded it because I need a forum and sharing it was a decision after the fact because I have a history of sharing. That's really the simple truth and as you see at my site...I'm using it.

Relax....I'm the hole in the head nobody is gonna miss ;)

[Chris_Seahorn]

Forgot. Had Bret and Wilbert not found the three letters (case sensitive) that were hanging the forum on production servers...it wouldn't be a submission at all. I would like the repackaged ZIP to place Brets name and Wilberts name inside the zip in each file next to mine if they would in the credits. As I understand it, Wilbert even updated the backends so it will work with PHP5 and sql5 which I couldn't do since I'm on a PHP4/SQL4 server (and like it) and could not code that since I could not test it while building on a 4 platform. This way it works across more server platforms and ends up making the package that much more appealing (Thanks WIlbert!). They deserve as much credit for it being listed there as me.

If someone could do that for me before listing the fixed submission...that would be great!

[w.brants]

Wilbert even updated the backends so it will work with PHP5 and sql5
That wasn't required Chris. I only tested it on PHP5/MySQL5 and it worked fine once the case sensitivity problems were fixed. Both Bret and I feel we don't want to be included in the credits for changing some uppercase characters to lowercase just because your server is case insensitive.
We made no other changes to the package itself nor to the forum only corrected a small problem.
Anyway, the updated package is available for download.
I did change the description a bit because you indicated on your forum there won't follow a second step (admin interface). If you feel something in the description should be different, please let us know.

Wilbert

[Chris_Seahorn]

Looks OK to me Wilbert. I appreciate your being humble but those three letters were paramount and I would never have found them with my board not halting.

I'm going to add your names to the one I submit to Flashkit. They've just been waiting for me to let them know it's all good. Thanks to you two..it is :thumbsup:

[Chris_Seahorn]

Here is the new credits inside each file as I will submit to Flashkit. If you guys want contact info or web addresses added just let me know:

/*
myBBS Flash Forum For Koolmoves (5.5)
Originally coded 2006 Chris Seahorn
HTTP: http://actionscript.hobby-site.com
Quality control and bug checks by Bret Lanius and Wilbert Brants
See included license for details of use.
*/

[Chris_Seahorn]

Last post on this...promise.

I added an extra level of security for admin and also fixed a minor problem with userlevels while I was setting it up for Flashkit. I'm PMing you and Bret a copy with the fixes so you can swap it out for the one in the KME now. It's a must have and will match the FK version that way ;)

Any other updates I'll handle from my board and will let you guys get some rest :thumbsup:

[w.brants]

It's swapped. :)

[Chris_Seahorn]

:thumbsup: :thumbsup:

[Chris_Seahorn]

WOW...that was fast. My last koolmoves submission to FK took three days to get listed (pretty much the norm in my experience) and myBBS is already listed! Submitted in the afternoon too!

Now...when users search the word forum in the movie section (oh...and they will) they will get introduced to Koolmoves. My blatent attempts to bend the will of the people to this platform through any means possible knows no bounds. Try me. Would I use code as bait? ...sure...why not. It's not like they don't get something in return...in this case they get a forum (and anything else listed to boot) :)

[blanius]

speed just depends on one of us knowing it's there..... And being online. I try to check the exchange daily if I can. We also get notified via email when a new submission has arrived.

[Chris_Seahorn]

You guys are always fast :thumbsup:

I'm talking about Flashkits movie section...usually it's at least a two day there just due to it being more scheduled. I think Planet gave it special consideration ...had to......because I figured it wouldn't show till at least tomorrow night at best.