Mysidia Adoptables v1.3.0[Security Release]

[Chibi_Chicken]

So I have started with a fresh install of myBB 1.6.6 and Mysidia 1.3.0
I put myBB in root/forum and Mysidia in root/mys130

I made the changes to the config_forum.php

Now when I am on the forums I can still create a new account.
When I jump to the mysidia registration page I can create a new accout. The info is created to both databases.

I can log in to both sites however when I log in to one it doesnt show up in the other.

When logged in to the mysidia portion of the site I can change my email and the effects take place on the adopt db but not the forum db. I can not seem to change my password.
When i go to the forum user CP I can change my password. The new password only works for the forum login but not the mysidia login.


Also on the mysidia site I can not view my profile I get:
( ! ) Notice: Undefined index: page in C:\wamp\www\mys130\profile.php on line 18
Call Stack
# Time Memory Function Location
1 0.0011 456936 {main}( ) ..\profile.php:0

( ! ) Parse error: syntax error, unexpected $end in C:\wamp\www\mys130\inc\tabs.php on line 20
Call Stack
# Time Memory Function Location
1 0.0011 456936 {main}( ) ..\profile.php:0


When I try to jump to the forum from the mysidia top tabs I get
404
Not Found

The requested URL /mys130/forum.php was not found on this server.


My main question is how do I set up the two software so it can reconizie that I have logged in to the forum login and dont need to do it in the mysidia site or vice versa. I am guessing it is the cookies but I am not sure.

Oh and I am useing wamp
Apache Version :
2.2.21
PHP Version :
5.3.8
MySQL Version :
5.5.16

 

[Hall of Famer]

@ Corsair:
It is weird though... Does this happen to your admin user, or every registered user? Check your /functions/functions.php file and see if the passencr() function is missing or malfunctioning.

@ Silverdragontears:
Well '->' is the most basic operator used to access object properties and methods, while $stmt is just like $result we had before. This script is moving towards the direction we called object-oriented programming. I did it for the security release 'cause I am making a point clear what directions new Addons/Mods for Mys v1.3.x. should follow. But yeah I agree creating addons/mods may be more difficult for beginners nowadays, you need intermediate programming skills to interpret objects and OOP design.

@ Chibi_Chicken:
For now the only thing Mybb forum integration does is to create user in both adoptables and forums database. In future I will make a better bridge between Mys and MyBB, and perhaps adding another tab to user profiles to show users forum activities. I still need to browse more into MyBB's database structure and programming conventions at this point.

 

[AlexC]

Apparently I'm having trouble with registering? My account works fine on both forums, it appears - but when I try to make a new account via the adoptable site, I get this message;

Deprecated: Function eregi() is deprecated in /home/gloometh/public_html/register.php on line 81
Failed to create forum account

However, I do have a new user on the adoptable site.

 

[Hall of Famer]

umm what version of PHP are you using? It seems that function eregi() is used to validate email addresses but for certain version of PHP it aint working. No idea why it happens, but at times...

 

[SilverDragonTears]

How do I get a number for this? Now that I can't use this format :/

$query = "SELECT * FROM ".$prefix."owned_adoptables WHERE owner='".$loggedinname."' AND currentlevel<='3' AND isfrozen='no'";
$result = mysql_query($query);
$num = mysql_num_rows($result);

if($num >= 5){
$canadopt = "no";
$article_title = "Too many eggs!";
$article_content = "You already have too many eggs to take care of! Come back once you have hatched an egg!";
}

 

[fadillzzz]

umm what version of PHP are you using? It seems that function eregi() is used to validate email addresses but for certain version of PHP it aint working. No idea why it happens, but at times...

HoF, just change eregi() to preg_match(), then it will go away

 

[Hall of Famer]

@ Silverdragontears:
You mean to count number of rows? With the new script you will have to write these:

$stmt = $adopts->query("SELECT * FROM ".$prefix."owned_adoptables WHERE owner='".$loggedinname."' AND currentlevel<='3' AND isfrozen='no'");
$data = $stmt->fetchAll();
$num = count($data);

if($num >= 5){ 
$canadopt = "no"; 
$article_title = "Too many eggs!"; $article_content = "You already have too many eggs to take care of! Come back once you have hatched an egg!"; 
}

In future we will implement a database class that comes with a num_rows() method so you can call easily.

@Fadillzzz:
I see, its weird how I never noticed eregi() being used in the script right from the start. Was it deprecated in the new PHP versions? If so, we have to update the script asap.

 

[fadillzzz]

@HoF:
Yes, it's deprecated since PHP 5.3
I guess Gloometh is using PHP 5.3+

 

[Hall of Famer]

I see, should have tested the script on my new server then. XD It worked flawlessly on the old one using PHP 5.2.17, lol.

 

[SilverDragonTears]

Thanks for the code HoF

 

[AlexC]

Yes, I checked and I've got 5.3.8. oops. xD Do I have to wait then?

 

[Hall of Famer]

@Silverdragontears:
Well you aint suppose to tell people to check out your site in a thread like this one when its sole purpose is to offer supports, but good site so far. The layout looks quite spectacular.

@Gloometh:
You do not need to wait anything. Did not Fadillzzz offer a solution? Try it and I suppose this should suffice.

 

[PokePets]

*Installing*
I'm so happy

 

[Corsair]

? for some reason now I can login.

 

[PokePets]

Ok, I installed the Mys script, anything works.
Then I installed the forum script and edited the config_forum fille.
Now I get this on the index of my Mys site;

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000] [1044] Access denied for user 'u693722181_niels'@'10.1.2.2' to database 'u693722181_beta'' in /home/u693722181/public_html/Beta/functions/functions.php:11 Stack trace: #0 /home/u693722181/public_html/Beta/functions/functions.php(11): PDO->__construct('mysql:host=mysq...', 'u693722181_niel...', 'MyPASSWORD') #1 /home/u693722181/public_html/Beta/index.php(3): include('/home/u69372218...') #2 {main} thrown in /home/u693722181/public_html/Beta/functions/functions.php on line 11

I didn't change my username or so and the forum is in another database.
Help?

EDIT; OMG OMG OMG Q___Q
ALL MY DATABASE'S GOT COMPLETLY DELETED?!

 

[Hall of Famer]

@ Corsair:
Perhaps it has something to do with your cookies and browser cache. Glad you can log in now.

@ Pokepet:
Did you forget to give the forum database user all access privileges? Access denied error is usually present when you have such a problem, though its also possible that you entered database info incorrectly.

And your databases got deleted? Can you please explain it a bit more clear? Was it just the adoptables database, or your forum database too? It is weird though, I do not think there is a line in this script that drops tables from database.

 

[Corsair]

It seems when I register a new account I can't login but for some reason after a certain time I can.

 

[PokePets]

@HoF;
My database from the old Mys script is completly deleted.
Well, the database still excist but all the fields inside are deleted.

Maybe it has something to do with my host? I don't know how it's possible...

As for the forum error, I did anything like in the MyBB installation guide but I will install again.

 

[Hall of Famer]

@Corsair:
Umm interesting. Now try to register on my dev demo site and see if you have the same problem. Its strange how you can log in like after a certain time. Id say your cookies and browser cache settings may be the cause of it:
http://www.mysidiaadoptables.com/mys130b/index.php

@Pokepet:
The old Mys script? What do you mean by that? You are talking about your old adoptables site made with Mys v1.2.x or v1.1.x? What version were you using? I thought you had a customized rusnak script...

And yeah, your host can possibly do that since you may be using too many database queries, tables and rows. Contact them for info and see if it is the case.

 

[PokePets]

Yes my old adopt site is made with mys version 1.2
The newest verwion before the version that is yesterday released.