php...cms....blah

[b-riz]

hey im makin a site for a pretty big clan. and the site will get a lot of traffic/use. I hate having to do all the updating myself like when they wanna add new players to the roster or something like that. I know how to use simple news scripts like zNews and stuff, but i need something bigger and better, i just dont know how to make it all fit together. I thought about a CMS like PHP-Nuke but then u cant really use 'your own' design. bah :?:

k well just lemme know wut u think i could use, i've also heard of phpmyadmin, but dont really know wut it is. gimme a holla 8O

[NMO]

i've also heard of phpmyadmin, but dont really know wut it is.
That manages mysql databases, it's not a cms, if I was you, I would stay away from cms programs, I would learn some php and code it myself, it's fairly easy and you can configure it to your own needs.

[Threeboy]

i'd just use a collection of scripts.

also, i dont think clan sites get much traffic, with the exception of 3D.

[b-riz]

have u heard of LFS? Legion of fallen souls, i think theyre pretty good, theyre goin to cpl.

but yah i only need a script for roster, matches, etc.

lemme know if u know any good scripts for roster and matches, i already have a news script. thx

[SileNceR]

alternative is to learn up to about intermediate PHP and MySQL (as needed) to complete the project - a lot more reqarding and you'll probably find that what you learn in the process will be useful to you in more and more things as you can build something to do exactly what you need.

[drake]

a CMS isn't going to help you with a roster script. I mean you can use a one of those clan CMSes but honestly you know I hate them. A Roster script is a simple 2 parts. A script that grabs the data from the database and displays it in a table or whatever, and then an administration script that manipulates the database. One of the easiest scripts ever. Also to protect it all you have to use if your not wanting to worry about a security system is use HTTP Authentication.

[b-riz]

so would i have to write my own script or is there any available for downloading?...

[pacman]

This should get you started. I just took a script that I made for my clan a long time ago and made a few changes.

http://jacobsonheating.com/roster.zip

now to install. First of all open up rsos.sql and through phpmyadmin add all the contents in that file (copy paste into phpmyadmin where it says run script).

Next you need to open up members/config.php and configure that to your mysql database (pretty straightforward).

Now open up admin.php and at the top where it says add admin, go through all that and add an admin account.

Now that you have an admin account you can now use that to login to the add edit and delete sections.

Wala there you go. If you don't understand any of what I said then I recommend grabbing a php mySQL book and read at least the first chapter. That should clear everything up for you. I cannot spoonfeed you anymore than this.

[SileNceR]

or read the start of both manuals, available for free

[b-riz]

hmmmmmmmmm....thx pac......
but what exactly does this script do? like wut is it for?
im a little confused right now :?
not really sure what to do with that cmos file, so i cant test out the prog until i figure it out, bah....help??

[pacman]

what the script does is allows you to add members of your clan, edit them, delete them and view them.

cmos?

[b-riz]

RSOS!

[pacman]

rsos was my clans abreviation. YOu can change all that, I just wasnt gonna waste my time with all that I was just showing you how to do it.

[b-riz]

o ok, im just confused as to what to do with that file

[pacman]

You need to enter all that info into the MySql database. If you don't know how to do that, then this is gonna be too advanced for you and you need to do some reading.

[b-riz]

ok i figured it out, got to the part where u add the admin

"Insertion into database failed"

i did all my info in config.php properly, i dunno why its sayin that...

[pacman]

you got all the info into the database correctly?

[b-riz]

OKAY, IGNORE ALL OF THOSE POSTS, IM A STUPID NUB

K ANYWAYS I GOT IT ALL WORKING NOW

the next step is how to include it into a website :shock:;)

[pacman]

make a header page a footer page and then just use the include function to include those too files. Header would be all the html code up to where you want the info to be displayed and footer is all the html code after that. To include just copy the include code from the top of the page and put it right under that and make it go to header. The footer include function should go at the bottom, but other than that its the same as the header and config only it points to the footer.

Or the simple way, but less convenient (sp is off on that one), when you want the info to show up on your page just put the include function pointing to the display.php file.

Hope you can make sense of this.

[drake]

Server Side Includes are the shit although they are kind of useless now of days with PHP being around.

[SileNceR]

yeah, just use readfile('filename') commands and call the php file instead of SSI

[drake]

SSI is good in the case where you don't need PHP on every page. Like if you have a personal site like my domain that doesn't need snazzy stuff like some of my other sites.

[SileNceR]

true, ocmelbourne.com still runs on shtml (ssi for header and footer); although when I start/finish the redesign will be dynamic and hence PHP/mysql.

[b-riz]

k well i did everything and now im trying to include it into the page i made, i just wrote in the include function (no header or footer thingys).... but when i look at the final page, all that comes up is "Members" at the top.

i go into the admin panel and add members but they dont show up on the page?!

the page is http://lfs.clanhostings.com/roster.php

thanks

[drake]

I am getting PHP warnings which imply that your includes aren't setup correctly. Maybe you didnt' upload the files or maybe you didn't point them correctly in the code.

[b-riz]

ya cuz i just got mad and deleted the whole folder, but i think it got all screwed up cuz i altered everything to how i wanted it.

now i wanna just get the original script back, but the link pacman gave me doesnt work anymore :(

pacman can u re upload it for me? or if anyone else has it?....



i tried it all over again and heres what i get: http://lfs.clanhostings.com/roster/members/display.php

i DID add members but nothing comes up there... in my display.php it looks like this:

<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#000000">
<tr>
<td width="43" align="left"><font size="2">Game Handle</font></td>
<td width="382"><font size="2"><? echo $membername ?></font></td>
</tr>
<tr>
<td align="left"><font size="2">Real Name</font></td>
<td><font size="2"><? echo $memberrealname ?></a></font></td>
</tr>

so shouldnt that table be showing up when i look at display.php????

im prob pissing a few ppl off with this, but i really need help.... :(

thx


(PS: the code i just posted is only a small part of display.php)

[drake]

Well for one that isn't the whole file and I have no idea where your trying to pull $memberrealname from so I can't figure out your program.

If you want, send me all your code to john@drakesland.com and I will run it on my local web server and get it to work correctly and mail it back to you.

[drake]

ok you have a few problems and I will do my best to explain them.

First off your SQL statement to add members isn't correct syntax. You didn't know this because you don't have it outputting error messages when it doesn't work and you have no way of knowing.

Solution: use the statement "or die(mysql_error());" on the end of the mysql_query in order to get the errror. This will reveal that you are trying to add content to fields that don't even exist. For example "memberaim"

Next this is that once you get it to not output a MySQL error and add a new row to the table. It turns out that nothing is added except a number. This is because your check to see if the form has been submitted isn't correct. if($add=1) { do stuff } will not be executed correctly to recieve form input.

Solution: Edit the if statement to look like if($add == 1) { do stuff } and then down where you have your form elements add the following "<input type="hidden" name="add" value="1">"

Once you have done those things and updated the insert statement to actually fill in the fields you have in your form, it should work and actually add entries to the database. It did for me. I must admit though, your display table is crude and hard on my eyes and I strongly recommend something that doesn't hurt so much when you actually using this script.

[Hektic]

After reading some of the posts I feel like all the time I spent writing one was worthless! But in any case, over the course of a little over a year I developed a fully featured clan management system with probably more features than you needed.

But in any case, www.kliptmedia.com. This is the same CMS that the Phlop kid tried to steal and copyright. It's got a simple installation and from there all you need to do is add some lines of code to your site and set up templates to set your site apart from others.

[Threeboy]

phlop is a fucking idiot.

and yep, that clan CMS will be on www.teamnerve.com soon.