Gesior character creation date.

[Lucenzo]

Heya


I have this

 $main_content .= '<TR BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20%>Created:</TD><TD>'.date("j F Y, g:i a", $account->getCreated()).'</TD></TR>';

But for some reason all characters have creation date "Created: 1 January 1970, 1:00 am"

How can i fix the date of creation?

Thanks x x

 

[Cykotitan]

I personally use imgur

 

[Lucenzo]

Sorry to be asking again for some help, would you be able to add the house information ? :L

Tibia - Free Multiplayer Online Role Playing Game - Community

If player has house then it should show, if no house then nothing should show.

Thanks in Advance x x

 

[Cykotitan]

 <?PHP $name = isset($_REQUEST['name']) ? stripslashes(trim($_REQUEST['name'])) - Pastebin.com[/url]

 

[Lucenzo]

Hey, me again


There seems to be a small problem with people who have characters with ' in their nicks.
for example Hashi'ma, the page goes blank and it's only for those with names (') that are not working

Any ideas?

Thanks x x

 

[Kofels]

These characters are escaped by either PHP function. It's bug, yes - common mistake.

 

[Cykotitan]

shouldn't have allowed them in the first place. they're not allowed in real tibia.

WHERE players.name=\''.[B][COLOR="red"]mysql_escape_string([/COLOR][/B]$name[B][COLOR="red"])[/COLOR][/B].'\' AND

 

[Lucenzo]

Hey


What would i have to do to block people from creating characters with ' ? x x

 

[Cykotitan]

http://otland.net/f132/cipsoft-account-creation-page-125980/#post1221869

 

[Kofels]

Hint about this in rules.
Simply add for ex. simple statment:

if( strpos("'", $name) === true )

in your character creation code.

 

[Cykotitan]

Hint about this in rules.
Simply add for ex. simple statment:

in your character creation code.

I used this:

	elseif(preg_match('/[^a-zA-Z ]/', $s))
		$e['name'] = 'This name contains invalid letters. Please use only A-Z, a-z and space!';

 

[Lucenzo]

I decided to keep the old creation page, as it has town support and few other things working, blocking illegal names for e.g Account Manager, and whatever names i desire in config.php

What you did looks great in the other thread but dislike missing towns support! :L

Also not sure what is the layout you provided for in your download? i have added .php file and the account folder and it seems to work fine without any errors or bugs?
So not sure why the layout? x x

Cheers x x

 

[Cykotitan]

layout because the container column on the right breaks after replacing the css file

 

[Lucenzo]

How can i fix that without using your layout?
Would love to keep my layout as it is :L

 

[Cykotitan]

it's the same layout. it's not mine but lucasolzon's, i just moved the divs to fix them.

 

[Lucenzo]

Aeron.mine.nu

Don't think he uses the layout that i do.
This happend while ex-changing layout.php file.

 

[Lucenzo]

Where do i add this ? :L

WHERE players.name=\''.mysql_escape_string($name).'\' AND

Hope this can fix the ' < bug.

 

[Cykotitan]

add the function around the original part in the script (line 6)

	$p = $SQL->query('SELECT players.id,players.name,world_id,players.group_id,account_id,level,vocation,town_id,sex,lastlogin,rank_id,online,marriage,promotion,deleted,old_name,hide_char,comment'.($config['server']['freePremium'] ? '' : ',premdays,lastday').',accounts.created,rlname,location FROM players,accounts WHERE players.name=\''.mysql_escape_string($name).'\' AND players.account_id=accounts.id LIMIT 1')->fetch();