AAC Reborn status on the page HELP!

[redakcja11]

"players">> "reborns"

 

[redakcja11]

bump

 

[slaw]

Did you wrote the query yourself?

Also, FYI: You're just fetching info from db. You need to output (write) it somewhere.

Also, I optimized your query a bit, cause you were selecting all (with *), but you just need reborns I suppose?

$reborns_query = $SQL->query('SELECT reborns FROM ' . $SQL->tableName('player') . ' WHERE ' . $SQL->fieldName('reborns') . ' IN (1,4) OR ((' . $SQL->fieldName('reborns') . ' >= (UNIX_TIMESTAMP() - 604800) OR ' . $SQL->fieldName('reborns') . ' = 0) AND ' . $SQL->fieldName('reborns') . ' IN (0,5));')->fetch();

Then, as I said, you need to output it somewhere, you can do it either with echo, when using MyAAC:

echo $reborns['reborns'];

Or, by editing $main_content variable when using Gesior, like this:

$main_content .= $reborns['reborns'];

 

[redakcja11]

bump

@up Parse error: syntax error, unexpected '$main_content' (T_VARIABLE) in C:\xampp\htdocs\pages\characters.php on line 67
67:

 

[MyAAC]

Add a semicolon after that line: (semicolon - ;;;;;

$reborns_query = $SQL->query ...;

 

[redakcja11]

xxx

 

[MyAAC]

I modified the query a bit:

$reborns = $SQL->query('SELECT reborns FROM ' . $SQL->tableName('players') . ' WHERE `id` = ' . $player->getID())->fetch();

Now it selects player id and also I removed some (i think) useless WHERE clause.

 

[redakcja11]

I modified the query a bit:

$reborns = $SQL->query('SELECT reborns FROM ' . $SQL->tableName('players') . ' WHERE `id` = ' . $player->getID())->fetch();

Now it selects player id and also I removed some (i think) useless WHERE clause.

Yes Yes Yes!!! Thank You