[ZNOTE] Help Show Marriage on character proffile

[lubunttu]

I need some help to show marriage on characterproffile.php in my znote aac

I'm using this marriage system:
https://otland.net/threads/marriage-system-8-6-fixed.161590/

Check in DB show it
id | player_id | partner | marriage_date
0 | 18 | 17 | 1467002917

I tried:
http://hastebin.com/ixivefaqaz.xml

But every time show:
Married to: No-one.

Even if have married...

Someone could help me to fix?

 

[lubunttu]

bump

 

[lubunttu]

bump

 

[Zoe Skandinavia]

Try to change this:

 <?php $married_to = mysql_select_single("SELECT 'partner' FROM `marriage_system` WHERE $user_id = 'id'"); ?>

To:

 <?php $married_to = mysql_select_single("SELECT `partner` FROM `marriage_system` WHERE `id` = ".$user_id.";"); ?>

 

[lubunttu]

Try to change this:

 <?php $married_to = mysql_select_single("SELECT 'partner' FROM `marriage_system` WHERE $user_id = 'id'"); ?>

To:

 <?php $married_to = mysql_select_single("SELECT `partner` FROM `marriage_system` WHERE `id` = ".$user_id.";"); ?>

Still showing Married to: No-one.

If have married or not...

I think to take this way i need to change something on script, but im noob on MYSQL things

 

[Zoe Skandinavia]

Still showing Married to: No-one.

If have married or not...

I think to take this way i need to change something on script, but im noob on MYSQL things

Well, make sure that there's a partner in player

 

[lubunttu]

Well, make sure that there's a partner in player

Storagens,rings,outfit everything is working...
On DB:

 

[Zoe Skandinavia]

Storagens,rings,outfit everything is working...
On DB:

Try this:
FROM:

 <?php $married_to = mysql_select_single("SELECT `partner` FROM `marriage_system` WHERE `id` = ".$user_id.";"); ?>

TO:

 <?php $married_to = mysql_select_single("SELECT `partner` FROM `marriage_system` WHERE `player_id` = ".$user_id.";"); ?>

This MUST work.

 

[lubunttu]

Try this:
FROM:

 <?php $married_to = mysql_select_single("SELECT `partner` FROM `marriage_system` WHERE `id` = ".$user_id.";"); ?>

TO:

 <?php $married_to = mysql_select_single("SELECT `partner` FROM `marriage_system` WHERE `player_id` = ".$user_id.";"); ?>

This MUST work.

In man show:
Married to: No-one.

In girl show:
Married to: Array

and Array does not exist. when i clicked

 

[lubunttu]

bump

 

[Zoe Skandinavia]

In man show:
Married to: No-one.

In girl show:
Married to: Array

and Array does not exist. when i clicked

Im seeing something else.
Here:

<li><b>Married to:</b> <a href="characterprofile.php?name=<?php echo $married_to; ?>"><?php echo $married_to; ?></a></li>

Right on <a href="characterprofile.php?name=<?php echo $married_to; ?>"><?php echo $married_to; ?> It's really wrong.
In db, the partner field is a number, so, this gonna call a number and not the player name.
For example:
characterprofile.php?name=17

Do you understand me? You must add the partner name in db instead his id.

 

[newby]

Im seeing something else.
Here:

<li><b>Married to:</b> <a href="characterprofile.php?name=<?php echo $married_to; ?>"><?php echo $married_to; ?></a></li>

Right on <a href="characterprofile.php?name=<?php echo $married_to; ?>"><?php echo $married_to; ?> It's really wrong.
In db, the partner field is a number, so, this gonna call a number and not the player name.
For example:
characterprofile.php?name=17

Do you understand me? You must add the partner name in db instead his id.

if you do it, you will fix in web and break in game...

 

[Zoe Skandinavia]

if you do it, you will fix in web and break in game...

Maybe, but if this happens, he must modify the script. It's not hard.

 

[lubunttu]

Maybe, but if this happens, he must modify the script. It's not hard.

I have no idea to how to change in script and fix bugs
There is no way to search character by ID on znote?

 

[lubunttu]

bump

 

[Zoe Skandinavia]

I have no idea to how to change in script and fix bugs
There is no way to search character by ID on znote?

Of course there's a way

 

[caquinha]

Anyone know the way?

 

[caquinha]

bump

 

[caquinha]

bump

 

[caquinha]

bump!