UBB.Developers Forums General Discussion Chit Chat Who uses PhotoPost with their threads?

Fishtails,

All is not lost so don't dispair

If you cannot rename the database fields, try this approach:

First of all make sure that your cookies in the threads are set to be site wide ("/" option for cookies path in the config.inc.php)

If you haven't set a cookie prefix:

I assume (from what you wrote) that your prefix on the tables is threads (so instead of w3t_users you have threadsusers)

Go to the Photopost folder (usually forum/gallery - or something similar)

Open showphoto.php

Goto line 673, find this

code:

$query = "SELECT U_Username,U_Homepage,U_Totalposts,U_Title,U_Registered FROM w3t_Users WHERE U_Number=$cuserid LIMIT 1";

---

and CHANGE it to this

code:

$query = "SELECT U_Username,U_Homepage,U_Totalposts,U_Title,U_Registered FROM threadsUsers WHERE U_Number=$cuserid LIMIT 1";

---

Open pp-inc.php

Goto line 750, find this

code:

$query = "SELECT U_TimeOffset FROM w3t_Users WHERE U_Number='$userid'";

---

and CHANGE it to this

code:

$query = "SELECT U_TimeOffset FROM threadsUsers WHERE U_Number='$userid'";

---

Goto line 845, find this

code:

$query = "SELECT U_Number,U_Username,U_Email FROM w3t_Users WHERE U_Number='$user'";

---

and CHANGE it to this

code:

$query = "SELECT U_Number,U_Username,U_Email FROM threadsUsers WHERE U_Number='$user'";

---

Goto line 885, find this

code:

$query = "SELECT * FROM w3t_Users";

---

and CHANGE it to this

code:

$query = "SELECT * FROM threadsUsers";

---

Goto line 915, find this

code:

$query = "SELECT U_Username FROM w3t_Users WHERE U_Number=$tuserid LIMIT 1";

---

and CHANGE it to this

code:

$query = "SELECT U_Username FROM threadsUsers WHERE U_Number=$tuserid LIMIT 1";

---

Goto line 1444, find this

code:

$query = "UPDATE w3t_Users SET U_Totalposts=U_Totalposts$do_inc WHERE U_Number=$user";

---

and CHANGE it to this

code:

$query = "UPDATE threadsUsers SET U_Totalposts=U_Totalposts$do_inc WHERE U_Number=$user";

---

Open login.php

Goto line 46, find this

code:

$query = "SELECT U_Password from w3t_Users where U_Username = '$user' limit 1"; 

---

and CHANGE it to this

code:

$query = "SELECT U_Password from threadsUsers where U_Username = '$user' limit 1"; 

---

Open login-inc.php

Goto line 154, find this

code:

$query = "SELECT U_Username, U_Number, U_Groups, U_SessionId, U_Password, U_TempPass FROM w3t_Users WHERE U_Number='-1' LIMIT 1";

---

and CHANGE it to this

code:

$query = "SELECT U_Username, U_Number, U_Groups, U_SessionId, U_Password, U_TempPass FROM threadsUsers WHERE U_Number='-1' LIMIT 1";

---

Goto line 158, find this

code:

$query = "SELECT U_Username, U_Number, U_Groups, U_SessionId, U_Password, U_TempPass FROM w3t_Users WHERE U_Number='$userid' LIMIT 1";

---

and CHANGE it to this

code:

$query = "SELECT U_Username, U_Number, U_Groups, U_SessionId, U_Password, U_TempPass FROM threadsUsers WHERE U_Number='$userid' LIMIT 1";

---

Goto line 163, find this

code:

$query = "SELECT U_Username, U_Number, U_Groups, U_SessionId, U_Password, U_TempPass FROM w3t_Users WHERE U_Username='$cookuser' LIMIT 1";

---

and CHANGE it to this

code:

$query = "SELECT U_Username, U_Number, U_Groups, U_SessionId, U_Password, U_TempPass FROM threadsUsers WHERE U_Username='$cookuser' LIMIT 1";

---

Goto line 175, find this

code:

$query = "SELECT U_Username, U_Number, U_Groups, U_SessionId, U_Password, U_TempPass FROM w3t_Users WHERE U_Username='$cookuser' LIMIT 1";

---

and CHANGE it to this

code:

$query = "SELECT U_Username, U_Number, U_Groups, U_SessionId, U_Password, U_TempPass FROM threadsUsers WHERE U_Username='$cookuser' LIMIT 1";

---

Open install.php

Goto line 559, find this

code:

$query = "SELECT G_Id, G_Name FROM w3t_Groups";

---

and CHANGE it to this

code:

$query = "SELECT G_Id, G_Name FROM threadsGroups";

---

Open ecard.php

Goto line 243, find this

code:

$query = "SELECT U_Email FROM w3t_Users WHERE U_Username='$touser' LIMIT 1";

---

and CHANGE it to this

code:

$query = "SELECT U_Email FROM threadsUsers WHERE U_Username='$touser' LIMIT 1";

---

Open adm-userg.php

Goto line 164, find this

code:

$query = "SELECT G_Id, G_Name FROM w3t_Groups";

---

and CHANGE it to this

code:

$query = "SELECT G_Id, G_Name FROM threadsGroups";

---

If you have set a cookie prefix I suggest you take it out (set in config.inc.php) unless it's absolutely necessary for you to have that prefix. If you do need it, please wait for version 2 of this post. I need to check things first before I suggest anything about cookies.

I hope this helps

Warm regards

Nikos