Deleting User Account With PhpMyAdmin And PhpBB
I've got phpBB v2.0.4 (message board) running and I'd like to delete an account. The problem is...I've never used phpMyAdmin before and I'm a bit stuck.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Deleting Mails In POP3 Account
I am getting lot of mails after submiting my site to some FFA link site. I am using Yahoo! mail ( User name : w3boby Password: bobee ) to receive all these Junk mails. They allow POP3 access. I want to delete all these mails in a single go. My PHP doesn't have IMAP support. Can i use socket to connect to POP3 mail box and Delete all mails inside.
PHPMyAdmin ... Deleting A Database?
I just want to delete a test database that I made, thats it. There is no upfront obvious way of doing this from my pov so thats why I'm asking.
PHPmyadmin Access Denied For User 'user'@'localhost'
WinMe machine as server, with Apache 2 installed and working PHP4 installed and working ( had PHP 5.05 installed and working, but i couldnt get the mysql extensions to load - phpinfo() didnt list mysql :(, so i installed PHP4, which now lists mysql when i run phpinfo). MYSQL 4.1 installed and working. I dont know the console commands too well, but i know its working ok, cos I have used a few simple DOS prompt commands to check its alive and I can connect to the database using MyODBC frontend/driver 3.51 and also using Navicat 2004. When i try to connect to the database via PHPmyadmin from another network PC I have an error: #1045 - Access denied for user 'user'@'localhost' (using password: YES) I have played around alot with different settings in the config.inc.php file.... nothing seems to work. This almost appears to be a simple login problem ( probably is too), but I can access the database locally from the Winme machine with the username and password that wont work over the network! I have tried not using 'localhost' as the host name but the IP address of the Winme PC but I get this error: #1130 - Host 'MYSERVERNAME' is not allowed to connect to this MySQL server
Logging In Twice With One User Account
Is there a way to prevent one user-account from logging in twice on the same system when using sessions? I also put the session of a user in a mysql database : CREATE TABLE `login_sessions` ( `login_id` int(10) unsigned NOT NULL auto_increment, `login_session_id` varchar(32) NOT NULL default '', `login_user_id` int(10) unsigned NOT NULL default Ɔ', `login_date` int(14) unsigned NOT NULL default Ɔ', PRIMARY KEY (`login_id`) ) ENGINE=MyISAM AUTO_INCREMENT=154 DEFAULT CHARSET=utf8 AUTO_INCREMENT=154 ; I can check whether the user_id is already in the database, but what if the user doesn't log out properly?
How To Create New Linux User Account By PHP?
how to create a new Linux user account by PHP, so that only that user could go to his won account? I tried system("useradd xxx") but didn't work...did I forget anything? or are there any other ways to do that?
Prevent Multiple Login For Single User Account?
how to prevent multiple login for single user account? eg user A login AccountA in german while user B also login AccountA in netherland(at the same time) that website.. how to prevent this? set login status in mysql or?
Deleting Sessions If User Restarts
A user submits a form and thus a session has been created. What I want to do is if the user presses the back button or decides to re-submit another form, it'll overwrite the current one. How can I do this ?
Auto Increment + Deleting A User
On my User table, occasionally, I will have to delete a member. ID is set to auto_increment, so, each time information is imported, that number will increase by one... However. There is one issue. When I delete a row from the table (so, I deleted a user), that ID becomes unavailable for use. So, there is three members. I delete the third one. When another user registers, I want them to have the ID that was deleted beforehand, which would be three. However, the user will have four.
PhpMYAdmin #1045 - Access Denied For User: 'root@localhost'
I have set my config file for a password with Mysql and phpMyadmin but when i try to load the phpMyAdmin page i get this error. ################# Error MySQL said: #1045 - Access denied for user: 'root@localhost' (Using password: YES) ################### I have set a password and want it to ask me for one but dont know how to go about it. If i dont set any password I can enter phpMyadmin no problem but soon as I change the configuration to have a password it wont let me in and wont ask for a password to authorize me. Is there a step im missing or somewhere I can read to learn how to get this working with the password.
Batch File Deleting And Folder Deleting
I have a folder in my web site where I used php to create and copy in files. but now I can't delete them easily. The only way I know how that is possible is through php. I get an error the following ftp error: 550 th: Permission denied I had the chmod() set to 0777 on every file and folder. But I still seem to loss control over the files when I try and do things with them through other means. I think it is because the user I use to access the files via ftp a diffrent user. So I tryed to add a function with chown() for the new files I was posting and uploading. It didn't work on those new files. so it looks like the only thing I can do is use the unlink() function which deletes the files fine. The only problem is now I have something like 100 sub directories all with files in them. I need to figure out a way to batch delete them. I can't find a script that goes through and finds all file contents including all sub directories and unlink those things. I found some that will use a for loop to list out the contents of a folder but it is just files. No sub directories. Any body got any ideas on which functions I should use or know where a script is that I can base mine off of. I am not sure how to approach this since what I tryed with chown and chmod has failed thus far. I currently have no code and am starting from scratch on this batch flushing of my directory.
Phpbb
for those of you who are familiar with it: what do I do with the phpBB file once I have downloaded it??
How To Hack PhpBB?
Well the title might be a bit misleading: Some time ago I was trying to reverse engineer the authentification system in phpBB because I was building a community site in which there was a phpBB Forum integrated as central component. The idea was to give the users the possibility to log in once and then move on the entire site without having to bother about login again. It didn't go very well, I was able to use the login data and some other stuff, but the autologin stuff didn't work and in some cases my login attempt was just refused. Now my question is: is there any good resource on how to integrate phpBB into community sites (or better, build community sites around phpBB). This includes: - Login system - Autologin system - Profile data - Using polls from phpBB outside phpBB - Using threads as News (and subsequent answers as comments)
Help On Editing PHPBB
I do manage a website and it includes a PHPBB forum, obviously placed at /forum (¿why to use a weirder path? :P). The thing is that my site is more than a forum, it has more content. I have menus almost everywhere, it's very navigable; but if you go into the forum, you can only get back to the other sections of the site using the back buton or removing everything starting from /forum in the address bar. Of course, this doesn't fit my site's philisophy, which is almost to put menus even inside the menus in every page, so you can go from everywhere to everywhere... I hope you cacth it. I've noticed that it shows the domain and title I put in the admin panel. Well, what I'd like to do is to make this text link to my homepage, placed at /index.php or simply /. The problem is that I'm completely lost when trying to do something in PHPBB's source files. I don't know which file should I edit, nor where should I add the code. These files are a code labirynth for me, and I need to edit them to fit my site's needs.
PhpBB Nesting?
Is it possible to configure phpBB to display threads "newsgroup style"? What I mean by this is to show replies to the top level post indented in a tree structure. One thing I cannot stand about phpBB is that all replies to a top-level topic are in a long train. You never know if somebody is replying to the person before him or the original poster, etc. If not, does anybody know another open source forum tool that does this, besides mwforum?
Phpbb And Php Pages
I have a phpbb message board that I am using. I also have some pages I created that use HTML and PHP. I am curious if there is someway for me to use the login inside the phpbb to use as a login to my other pages. Is there an easy way to have these 2 integrated so that they can only access either one if they are logged in? Or will I have to set up a separate loging for my other PHP pages?
Phpbb Login
We run a medium sized website that hosts a phpbb forum. We want to create a custom login/logout script, and I have tried really hard to decrypt the phpbb code but find it really difficult. Does anyone have a basic login/logout script that works with the phpbb database? So writing the sessions/cookies etc. I want to be able to create a single login/logout page where i process everything - ie: set sessions/cookies for login (but finding it hard to work out what values/names to set).
PhpBB Login
i'm currently using the following code to place a phpBB3 login box anywhere on my website. As you can see, it uses the phpBB3 "ucp.php?mode=login" code to process everything. Is there a way that I can send the form data to "ucp.php?mode=login" and then KEEP all the post data and redirect it to a new page to use the post data again? Here is the code:
Account With Php.
I have already understood the general features of working with PHP. However, what I cannot make yet is to organise user's file access with PHP. In more detail users should be identified by user name and password and then different users have to receive differen permission to existing HTML files. Do you know how one can make it?
Adding Users In PhpBB 2.0.x
I've been looking through the phpbb2.0 forum looking for tips on how to add a user without using the registration form. While phpbb 3 seems to have a simple way, the 2.0 search turned up empty. I've tried adding users via php, into the phpbb_users table, but these users cannot login - they get the error message 'You have specified an...
PhpBB Pagination Error -
I've got pagination errors in a phpBB board. Some forums are showing "page 1 of 0". Previous enquiries both here and at the phpBB forum have given me half-answers, the latest of which contained this advice: For each forum in phpbb_forums: -) Get the number of posts that belong to a forum from phpbb_posts select count(*) as count from phpbb_posts where forum_id=$forum_id update phpbb_forums set forum_posts=$count where forum_id=$forum_id -) Get the number of topics that belong to a forum from phpbb_topics select count(*) as count from phpbb_topics where forum_id=$forum_id update phpbb_forums set forum_posts=$count where forum_id=$forum_id I understand that I have to enter some of this code into phpMyAdmin to correct the error in the MySQL database - but I don't understand how! I've tried copying and pasting the uncommented lines into the "queries" box in phpMyAdmin, but I get syntax error messages back which I can't fathom. (I'm not even sure whether I'm entering them into the right place.) I'm running: phpBB 2.0.6 phpMyAdmin 2.5.4 My ISP is running: MySQL 4.0.15a php 4.3.2 If anyone can provide an "idiot's guide" to correcting this problem I'd be most grateful. I've been trying since the middle of December to fix it!
PhpBB Installation, Permissions
Just a quick item of note: Installation Guide says: chmod -rw-rw-rw- config.php Most often this would be done using an FTP client. I have been unable to do this, and assume its because the dir does not have 'w' set for group, other. I know when creating dir's on a Unix host, the dir takes on the permissions of its parent. I'm also guessing that its rare for "htdocs" directories to have 'w' set and to do a chmod for config.php requires changing every dir on the tree. I also noticed some hosts have installers or fantastico to install phpBB. Is there any difference, compared to doing it manually ? Any comments ? ( I know this isn't specifically a PHP question; didn't know a better group )
PhpBB Database Requirements
I'm looking into setting up a forum for a client's website. phpBB and Invision Power Board seem to be the two most popular. For the moment I am starting with phpBB because I don't like the "free trial" language on Invision's site. I'll be setting up phpBB with MySQL. Does it require its own database, or can I use an existing MySQL database that already has tables in it?
PhpBB And Wordpress Template
I have created a template for my site and now I want to use the same template for phpBB and wordpress, please help me that is there some specific way to slice the template for phpBB and wodpress or there is some other method...
Converter For PhpBB To VBullettin
I want to convert an existing site in phpBB to Vbullettin.Is there any converters available for the same.Please let me know more about this as this is an urgent requirement
PhpBB And Displaying Images
I need to add upload functionality of images to phpBB 1.4.4. I have decided to have the images upload directly into mysql as binary data. I have been succesful in adding upload code into phpBB to allow it to upload images. What I am having a problem with is displaying those uploaded images on the viewtopic.php page. I have taken a look at the tutorial on phpbuilder that talks about uploading and viewing binary data in mysql and I have followed the examples. here's the link if interested: http://www.phpbuilder.com/columns/florian19991014.php3 So basically this tutorial has the user create another file that will be called to grab and format (with proper header info -- image/gif) the image and send it back to the relevant page. So within my viewtopic page - where I want the image to appear I provide the following code. post_id is a parameter that tells getdata.php where the image field is located for that record. PHP Code:
PhpBB Sites Hacked.
The phpBB sites are hacked. If you search for "HACKED BY CYBER-ATTACK" on msn.com you will get a list of all the sites hacked. Anyone knows what is the way to clean this up ?
Get Emails From A POP Account.
I would like to make a script where i would get all the emails form a POP# account and send it all to a email, what code would i use to do this ...
Two Domains On The Same Account
I don't know if this is the right place (because I don't know if it's PHP-related). I've registrered two .com-domains (the will go to two dofferent unrelated sites) which I have on the same account on the sama webhost. When I asked my webhost about it they told me that I should use som sort of script. The reality is that I have no idea of what script (and type of script) I should use, and how it'll work. I've also asked them if they could direct it to different webroots, but they insist that I should use a script. Someone that have the script?
Php,PhPBB,Apache,MySQL,Linux
The problem is that i must run a BulletinBoard like Helpdesk program. Somebody else made this program. but in the vacation the shutted down the linux server. Now the Database doesn't work anymore. The error he gives is: phpBB : Critical Error Could not connect to the database I installed al programs again (Apache,Php,MySQL). And then i put back the backup from the database/phpBB program. I already asked some people and they say it is maybe the link between the database and the MySQL.
Phpbb Directory Permissions On Windows?
What should the directory permissions look like on the various folders in a typical phpbb install? I was looking at a server today that had phpbb installed on a box with IIS installed on it and many of the folders had read,write and modify flags set for the IUSR_MACHINENAME account. Im thinking this should be changed to read-only.
PhpBB Automated Module Installation
I hope this is the right forum for this post. Does anybody know if a program already exists to automate the process of installing phpBB modules? I couldn't find one, so I was going to write one; but I don't want to if one exists. It kind of seems like there might be one already, looking at the way the installation files are formatted. It's really annoying to me that they don't pass out diff patches along with the module instructions.
Parse Error In Phpbb Registration
I keep getting this error: Parse error: parse error, unexpected $ in /........./phpBB2/includes/usercp_register.php on line 1401 Here is around the lines (1401) in question, I'm pretty new to all this so I'm not sure what to look at or do, any help would be appreciated, considering I can't register any new users until I get this figured out. Here is the lines in question:
[MySQL] PhpBB Not Displaying Topics
Yes, I know there exists a suport forum for discussion about problems with phpBB, but noone there seems to know the solution to my problem... so I ask here. I've been messing around with phpbb_ tables in my database... I'm trying to convert a incomplete Ikonboard forum to phpBB, and had to do lots of stuff manually (which is fine as I'm familliar with MySQL). And, now I'm stuck and can't figure out the problem... The forum in question is: http://fly.srk.fer.hr/~nick/remorkeri/phpBB2/ The situation is this: a) from the outside: On index.php I can see numer of topics, number of posts and info about last post. On viewforum.php I get "There are no posts in this forum.". b) from the inside: select post_id, topic_id, forum_id from phpbb_posts; returns a whole bunch of everything, so this table seems OK. select post_id, post_text from phpbb_posts_text; same thing. select topic_id, forum_id, topic_title from phpbb_topics; same thing. So, form the inside everything seems nice. So, why viewforum.php doesn't see the articles? I tried to figure out the PHP code, but couldn't, haven't got all the time in the world...
PHPNuke To PhpBB Integration Question
I have a standalone phpBB forums and just recently installed PHPNuke on my website. I know phpnuke comes with it's own version of phpBB. How can I make it possible for members who register through phpnuke to automatically be register with my standalone phpBB? If this is not possible, how can I transport my standalone phpbb to the one that is included with PHPNuke?
Webpage PhpBB Login Integration.
On my website i have a login username/password box i have it when you enter your login details it'll log you into the forums. When no ones loged in theres no problems but when someone logs in i get the error on my index page QuoteWarning: Cannot modify header information - headers already sent by (output started at /home/adaminc/public_html/index-test.php:5) in /home/adaminc/public_html/forums/includes/sessions.php on line 254 Code:
Phpbb Auto Increment Question?
Is anyone familiar with the way phpbb works in terms of adding a new user to the database. If i am right it doesnt seem to auto increment? When a new user registers fir my site, I also have an sql insert into the phpbb_user table too so they can then logon to the forum. But the id seems to go in as just 0 and wont increment! Is there any reason for this?
Variable Being Passed From Site Into PhpBB
I am creating an autologin feature where my site members are logged into the bulletin board automaticly the only variable I find that is global is $sAuth it stores the members id #... I can user this to pull the name and password out of the database and set name and password in the forum to eaqual these... is this a security issue? or can $sAuth only be set by script on my site??? I am rather new and want to make sure this variable can not be asigned in another way.
Linking A Page With Phpbb Forum
iv been trying to do this for a while, link my website users with phpBB forum users so they only need to register once. Now someone was kind enough to give me this code to get the users information: Code:
Upload Phpbb, Instead Of 1 File At A Time?
It says i have to upload the whole folder to my server, and im using cpanel so i have to do it like a few files a time, how do i upload the whole folder at once? is their a way of uploading a zip and extracting it to my site, or is their a way on ftp i can do this?..
PhpBB Classified Ad Extention Installation
Trying to install the phpBB classified ad extension for phpBB. Getting the following error/s Warning: include(./language/lang_english/lang_main_ads.php) [function.include]: failed to open stream: No such file or directory in /home/namibiac/public_html/ads_mod/ads_common.php on line 37 ...
Email Account Verification
Is there a way to verify whether an email account exists or not without send an email to that address. I know that most of the time a regular expression is used but it only checks the format i.e. it will even match fake@isp.com A work around to this problem is connect to that server and then check for the user name but HOW?
Gmail POP Account Script
I have gmail account! I have enabled POP forwarding into my gmail account. Now I need a ready-made script for running to access my POP account... I just dont have enuf time to write all the scripts down...
Account Activation Via Email
I'm supposed to do the account activation via email. I mean *not* sending the activation link like http://foo.com/foo.php?actcode=foo. But, I would like it to be like <actcode>-activation@domain.com or so. I remember, once I did it by checking the POP3 server. Now, I totally forgot how I did it in PHP or server. Also, I couldn't find any solution/script by Googling. Anyone has the idea?
Sendmail Account Setup
I want to be able to create a sendmail account by commands sent from a web page. I am using php. After everything is done, I want to enter his info into the database (easy) and create this sendmail account. Can anyone give me pointers to explanations/excamples? I have done a quick search on the web, but haven't turned up anything. In addition, I do NOT want to create a regular user account on the server -- only a sendmail account.
Scheduled AT Job Reports 'The Account Is Currently Not Available'
I am scheduling an AT task from a php file using sudo and user 'joe' that reports correctly when using atq from the command line. However, although the script being executed by the job runs ok from the command line I get a mail message saying 'The account is currently not available' when the job is scheduled by php? It's not an 'apache' user problem as far as I can see as the task is getting scheduled as 'joe'.
Configuring Account Balance's
I have a file that has money balance's in it. What I am trying to do is format the file so that anything with a balance of .$.01 - $2.00 is named a "Low" balance. Everything with a $-.01 or less is a "Negitive" balance and the even ($0.00) balances will be thrown out. Below is what I have came up with so far but does not work of course. Code:
|