• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

If i delete account from Database i get php account error

Lopaskurwa

Lopaskurwa

Well-Known Member
Joined
Oct 6, 2017
Messages
936
Solutions
2
Reaction score
57
Hi so i tried to clean my sql and delete all account from id but if i delete accounts and then try to create new accout i get this error
door.png

This is account.php
[C++] <?php /* +I.D.E ENGINE+ Controller of Account for Modern AAC - Powered by ID - Pastebin.com

Where is the problem?
 
Sort by date Sort by votes
Okke said:
Great start we have, I'm proud!

You have a data called "*.sql" in which * could be anything inside your server's folder, open that data with any text editor of your choice, copy the content with ctrl+c. You will now need to login to your phpmyadmin which should be http://localhost/phpmyadmin <- mind this could vary depending on which webserver you installed, you're using windows, which means I wont support you for a long time as this is completely unprofessional and super buggy. Once you're logged to your phpmyadmin page, create a new database, click on it, navigate to the tab SQL, paste the code that you copied from the *.sql file and click on Ok. Tables will be created.

Once your tables were created just open a new tab on your browser, type http://localhost/ and you'll be redirected to the page you made a screenshot of, now copy all of the content of this text field and do the same as you've done with the *.sql file, once you're done with that proceed to the config file of your AAC (in this case Znote), which will be in the webserver's www or html folder. The config file name is config.php, it is there, use a text editor to open it, read and modify the files to your needs, There are plenty of questions about this on OTLand, you're more than welcome to use the search function.

After you edited the configuration file of your AAC, move on to the config.lua inside your distribution folder, configurate it right (give the username, password and database name and port which should be 3306 (default) for the SQL connection, just as you've done to your config.php file).

Done with everything? Start the server (I hate to tell you but you might have a bad time due to using windows, I mentioned 1000 times that people shouldn't use this cheap system to host servers, even for testing purposes...) go to the website, create an account and a player, open your client and log in.

Kindest Regards,
Okke
Click to expand...
Tried and i failed, I surrender have no more motivation to fix this. We can close this thread.
 
Last edited by a moderator:
Upvote 0 Downvote
WibbenZ said:
Tell us your problems insted so we can help you.
We don't close threads unless we have to (spam etc)
Click to expand...
So i don't know, did i made this part or not but he said

"You have a data called "*.sql" in which * could be anything inside your server's folder, open that data with any text editor of your choice, copy the content with ctrl+c. You will now need to login to your phpmyadmin which should be http://localhost/phpmyadmin <- mind this could vary depending on which webserver you installed, you're using windows, which means I wont support you for a long time as this is completely unprofessional and super buggy. Once you're logged to your phpmyadmin page, create a new database, click on it, navigate to the tab SQL, paste the code that you copied from the *.sql file and click on Ok. Tables will be created."

So i insert my old sql to phpmyadmin i create database, i go to localhost then i see this new sql blablabla then he said do same what you did with sql? So what does it mean? I have to replace it with old one or what? And i didn't even reach that second part with cofing.php because he said open config.php and there is google to search functions. Does it mean "go to google and search information how to edit config.php"?
 
Upvote 0 Downvote
No I didn't mean replacing, I meant just adding it via the SQL tab, just like you did with the .sql file that comes with the distribution.

The second question is just about you re-reading my sentences better as they're pretty well formulated so anyone could understand the steps... Setting up an OT for the first time (that's what it feels like with you) might be complicated but you shouldn't quit just because you can't get something done, we're here to help and you should just use the best method for that which is "trial and error".
 
Upvote 0 Downvote
Lopaskurwa said:
So i don't know, did i made this part or not but he said

"You have a data called "*.sql" in which * could be anything inside your server's folder, open that data with any text editor of your choice, copy the content with ctrl+c. You will now need to login to your phpmyadmin which should be http://localhost/phpmyadmin <- mind this could vary depending on which webserver you installed, you're using windows, which means I wont support you for a long time as this is completely unprofessional and super buggy. Once you're logged to your phpmyadmin page, create a new database, click on it, navigate to the tab SQL, paste the code that you copied from the *.sql file and click on Ok. Tables will be created."

So i insert my old sql to phpmyadmin i create database, i go to localhost then i see this new sql blablabla then he said do same what you did with sql? So what does it mean? I have to replace it with old one or what? And i didn't even reach that second part with cofing.php because he said open config.php and there is google to search functions. Does it mean "go to google and search information how to edit config.php"?
Click to expand...

You were able to insert the schema(.sql) to your database(phpmyadmin)?
In that case all you need to know is the name of the database, ex forgottenserver.

Then you enter that in config.lua; forgottenserver/config.lua at master · otland/forgottenserver · GitHub
User = root in most cases unless you changed it
Password = the one you use to login into phpmyadmin
Database = the name of the database

You should also be able to start the server (a good test since it will warn you if the password etc is wrong).
 
Upvote 0 Downvote
WibbenZ said:
You were able to insert the schema(.sql) to your database(phpmyadmin)?
In that case all you need to know is the name of the database, ex forgottenserver.

Then you enter that in config.lua; forgottenserver/config.lua at master · otland/forgottenserver · GitHub
User = root in most cases unless you changed it
Password = the one you use to login into phpmyadmin
Database = the name of the database

You should also be able to start the server (a good test since it will warn you if the password etc is wrong).
Click to expand...
There is no such think as config.lua in ZnoteACC only config.php. Or do i need to create it?
 
Upvote 0 Downvote
WibbenZ said:
config.lua = your server folder, where you have the data folder and forgottenserver.exe~
config.php = your website folder
Click to expand...
Well this stupid website still doesn't launch what i see is only
Code: 
Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'tfs13'@'localhost' (using password: YES) in C:\xampp\htdocs\engine\database\connect.php on line 278
Failed to connect to MySQL: (1045) Access denied for user 'tfs13'@'localhost' (using password: YES)
Install:
[LIST=1]
[*]
Make sure you have imported TFS database. (OTdir/schema.sql OR OTdir/schemas/mysql.sql OR OTdir/forgottenserver.sql)


[*]Import the below schema to a TFS database in phpmyadmin:

[*]Edit config.php with correct mysql connection details.
[/LIST]
I think i'll try to fix my old website because i saw people had same problem in tibiaking so maybe they'll know what to do.
 
Upvote 0 Downvote
Lopaskurwa said:
Well this stupid website still doesn't launch what i see is only
Code: 
Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'tfs13'@'localhost' (using password: YES) in C:\xampp\htdocs\engine\database\connect.php on line 278
Failed to connect to MySQL: (1045) Access denied for user 'tfs13'@'localhost' (using password: YES)
Install:
[LIST=1]
[*]
Make sure you have imported TFS database. (OTdir/schema.sql OR OTdir/schemas/mysql.sql OR OTdir/forgottenserver.sql)


[*]Import the below schema to a TFS database in phpmyadmin:

[*]Edit config.php with correct mysql connection details.
[/LIST]
I think i'll try to fix my old website because i saw people had same problem in tibiaking so maybe they'll know what to do.
Click to expand...

Don't use modernaac you will just cause more problems for yourself unless you know PHP, smarty and codeigniter.
Im not the best on Znote, I mainly use Gesior tbh

But the error says that you have the wrong password or username, if the username on phpmyadmin is tfs13 you have the wrong password.
If it's not tfs13 you have to change the username to w/e that is(you set that when you install xampp / uniformserver).
If you didn't set anything they both default to root.
 
Upvote 0 Downvote
WibbenZ said:
Don't use modernaac you will just cause more problems for yourself unless you know PHP, smarty and codeigniter.
Im not the best on Znote, I mainly use Gesior tbh

But the error says that you have the wrong password or username, if the username on phpmyadmin is tfs13 you have the wrong password.
If it's not tfs13 you have to change the username to w/e that is(you set that when you install xampp / uniformserver).
If you didn't set anything they both default to root.
Click to expand...
I know it's very bad idea to use modernacc because i'm already have more problems with that website. But as you can see i can't set that website it's not for my stupid head -_-
 
Upvote 0 Downvote
Lopaskurwa said:
I know it's very bad idea to use modernacc because i'm already have more problems with that website. But as you can see i can't set that website it's not for my stupid head -_-
Click to expand...

Download teamviewer and pm me the id and password
 
Upvote 0 Downvote
Solution
Lopaskurwa said:
I know it's very bad idea to use modernacc because i'm already have more problems with that website. But as you can see i can't set that website it's not for my stupid head -_-
Click to expand...

It‘s not your stupid head, it‘s your missing knowledge on how stuff works and maybe a bit of lazyness to read and try to understand, read error messages and what can be done to fix the issue. I hope Wibbenz can get it done to you, we will surely meet again in this board.

Have a good one.

Okke
 
Last edited:
Upvote 0 Downvote
Back
Top