The page where you register is http://www.apolitical.info/private/teleleegame
The registration does what it's supposed to: put your email, password and a random code into a MySQL database called 'pending', and send you an email with a link.
The link goes to another page, which does *most* of what it's supposed to:
"roll up' your characters (works)
delete you from the 'pending' database (works)
put you into the 'current' database (works)
but it doesn't put your character's details into the 'characters' database properly.
Here's an example of the MySQL command which is supposed to do that:
Code: Select all
INSERT INTO characters (email,background,Stamina,Luck,Willpower,Perception,Technology,Magic,Combat,Stealth,Streetwise,Wilderness,Riding,Charisma,Healing,Shells,keyword 1,keyword 2,vice,toedit) VALUES ('news@apolitical.info','travelling merchant',8,5,1,0,0,-2,0,-2,-1,1,1,1,0,6,' ',' ','being virtuous when those around them were not',1)
I've checked that the 'characters' database has the right types for all the columns eg 'email' is varchar(50) while 'Magic' is int(2).
But it still doesn't work.
PS Not sure if this is relevant, but I have it in the form
Code: Select all
$result=mysql_query($w1,$link)