Festive Holidays Over....

[Happy Axeman]

Ok So Christmas and the New Year celebrations have now been and gone...


Did you have a good one? 


With this festive season being here, and with so many city matches to watch, there really has not been much development I'm afraid.


I have been working on a new City site though, just nothing I can show you as of yet... but once i get the initial system working, new features and stuff should appear more regularly.


So this is an appeal for any City fan to send me some content... I really need season reviews from the last two seasons, player profiles of the players we currently have, and profiles on previous player like never before...

[stevenryals]

nice one..

i'll try to find some time to help.. but i have too many jobs already LOL

[Happy Axeman]

lol Have you managed to convince Shellina to change name to the Blue Shakes Band yet? lol

I'm currently having a bit of difficulty with the backend of the database system for the city site.
think I'll just get the index page up and running, upload it and then go from there. lol

[stevenryals]

whats the database problem you're having? 

[Happy Axeman]

lol getting it all working!
gonna have to re-write some stuff... for example I want to input a match details, then it will update players, managers and every other stat available in my DB... I keep messing it up. lmao
I'm also not completly happy with the way my template loads... it still needs lots of work on it.

[stevenryals]

looks like u have a few years of stats to update  lol

i wonder if you could write a quick script to scrape another site to get the records updated??

do you have an 'event' table?
where you input all the events (goals, appearances, subs, cards, etc etc)
each player would have an id (pk) and you could pull the stats from that database with a simple sql string.. select * from events and $_POST the data as needed to variables.. then use the count function to determine how many of each event per player? 
this could be updated when you put in match details..  ?? 
just a thought

[Happy Axeman]

lol yeah all my databases are linked... i have one for each of fixtures, players, playerstats, managers, managers stats, seasons...
I will have to make a new one for match stats, which each entry is one player, otherwise there would end up with over 70 fields per entry.. lol
its the controls and admin features which is the pain in the arse... i hate forms. lol

[stevenryals]

u using php?  makes life a bit easier for this type shit..

and yes.. forms blow..

i've started using a out of the box wysiwyg editor for my forms..  makes it a step quicker, and easier to format to form to make it look nice enough.. 

good luck.. let me know if you want a hand.. i'll try to help if possible..

[Happy Axeman]

yeah, Php and Mysql

I could upload what i have done so far, but then nothing would work properly... I want the index page to have something from everything the city site offers... the way my template is made, i can get the content bits all working fine, but i want all DB actions done before it creates the html, and this is my problem... i have a side bar where all the info will be heading... but i cant get it worikng pre-html... lol does that make sense? lol

[stevenryals]

yea i get you.. 
not sure what data you're wanting to put where.. but I'm assuming you're storing your sql query results in an array..  if thats the case and you have multiple arrays containing the data...  could you program against the arrays with your html output?


are you worried that the site will be slow if you are processing sql front end ?

[Happy Axeman]

lol no it has nothing to do with slowing the site down, i want the site to be secure as possible. doing all the sql queries before the html is loaded is the way to go

[stevenryals]

i hear ya.. i have a friend who's head of IT security and is a hell of a programer.. if you run into any roadblocks, security wise, i'll see if he'll give u a hand 

[Happy Axeman]

I may have to give him my whole site, so he can tell me how it should be done. lmao

[stevenryals]

LOL  not sure i could get that type of work for free LOL