[REQ][2000 credits][PHP]From file to database

[galaxyAbstractor]

I got a script that reads user info from files... I want it to read from sql instead.

This is the database-structure I am usinf:

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL auto_increment,
  `auth_username` varchar(30) NOT NULL,
  `auth_password` varchar(30) NOT NULL,
  `auth_mode` varchar(30) NOT NULL,
  `auth_confirmation` varchar(30) default NULL,
  `nickname` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `fullname` varchar(255) default NULL,
  `dob` varchar(255) default NULL,
  `gender` varchar(255) default NULL,
  `postcode` int(30) default NULL,
  `country` varchar(255) default NULL,
  `language` varchar(255) default NULL,
  `timezone` varchar(255) default NULL,
  `public` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
)

This is the file that needs to be rewritten to use ^those^ instead of a file:
http://pastebin.com/f2b351861

Could anyone please do this? It's basically change everything in the script to read the userinfo from that table

[NaHoW]

Can I do that? I will manually insert them if you give me access to your PHPMyAdmin

[galaxyAbstractor]

Can I do that? I will manually insert them if you give me access to your PHPMyAdmin

What do you mean? I have already made the database part and the registration part. I need the rest of the script to use mySQL to read the user data instead of the file.

Because if you do ?user=vigge_sWe, it will look after vigge_sWe.auth file where the settings are saved. I want it to check in the table "users" under the correct user

*closed, tnl2k7 said he will try*

[galaxyAbstractor]

Ok I need this again, but I will offer 2000 credits now.

[compwhizii]

I think I might be able to do it, lemme give it a swing

[compwhizii]

Nevermind, I can't do this. Who am I kidding.

[xPlozion]

ok, hold on. i'll try this now. i need the 2000 points :D

couple of questions, what's the t() and set_t()? what do those functions do and look like?

[balaji2u]

i think i can do this.send me all the script files that depend on the file to read the data and also the sample of data may be a database containing two or three records or just give me authentication to ur panel.im comfortable with any of these methods.

[xPlozion]

do you have an example auth file that i can work off of?

[galaxyAbstractor]

a:4:{s:13:"auth_username";s:5:"admin";s:13:"auth_p assword";s:32:"9cdfb439c7876e703e307864c9167a15";s :9:"auth_mode";s:4:"form";s:12:"auth_confirm";b:1; }
a:0:{}
a:9:{s:8:"nickname";s:9:"vigge_sWe";s:5:"email";s: 19:"test@gmail.com";s:8:"fullname";s:11:"test test";s:3:"dob";s:10:"1992-11-24";s:6:"gender";s:1:"M";s:8:"postcode";s:5:"44330 ";s:7:"country";s:2:"SE";s:8:"language";s:2:"sv";s :8:"timezone";s:16:"Europe/Stockholm";}

If you mean the database, just create an new user at the register.php file