Noob needs help :( phpraid

[cider]

OK,

 

I use a page called "PHPRAID" to organise raids for my wow guild.

 

I have to manualy add each raid setting the time/date.

 

Now im trying to use the "import" function to add them via a file and so far i have got

 

INSERT INTO `phpraid_raids` VALUES(89, 'Kara', 1, '1192818600', 'Karazhan', 'Cider', 0, '1192920400', 2, 1, 2, 2, 2, 2, 2, 2, 2, 70, 70, '10');

INSERT INTO `phpraid_raids` VALUES(84, 'Kara', 1, '1192818600', 'Karazhan', 'Cider', 0, '1193020400', 2, 1, 2, 2, 2, 2, 2, 2, 2, 70, 70, '10');

 

Now from my understanding the "'1192818600'" and "'1193020400'" set the date, invite time and start time, but i have NO idea how it works lol

 

can anyone shed any light onto this?

 

[Orio]

That's what's called a Unix timestamp. Basically, it's the number of seconds since 1.1.1970. PHP, MySQL, and many more programming/scripting languages and systems use these timestamps to keep track of dates- it's an easy way to handle dates and it can be manipulated easily.

 

Orio.

[cider]

seconds!!! hmm ok

 

i assume theres no other format i can put in for it?

[simcoweb]

There are several 'date' styles and commands in PHP. You could have it say:

 

January 1, 2007 Friday 11:30am

 

for example. What code is creating those values that are being inserted? Can you post that please?

[cider]

i wish i knew where i would find that :S

 

When selecting the date/time its in a drop down box from the raid page, would giving you a link to the site help?

[Moocat]

if you don't want to have to deal with this, cider, i recommend moving to EQDKP. there's a package called EQDKP plus which is highly modded for WoW, and has it's own plugins you can download from their website. Get the one called raid planner. You don't need to do any manual database insertion to set up raids with it