Leaderboard

Give it time, it took a while to sync up. Last night I was getting alerts about stuff hours after the fact, I'm now getting email in ~a min.

All dns changes take time to propagate, though that's sorta weird, my cname change instantly took effect and mail.shinryuu.net redirects to the live.com login, I want to mess with it a little more though. As for making it a selling point we kinda do, maybe if we make walkthroughs for offloading mail on the wiki and told people where to look to get email running that way on our systems we'd be able to up the per-day limit of 50 emails a day a tiny bit. Here's the email features page on the home site though, look under the header custom mail. I was talking with an admin yesterday about making walkthroughs for services like CloudFlare which also lighten our server load, we'll let you know of any important developments with that stuff.

Should be $query = \"DELETE FROM login WHERE custID={$_POST['custid']} LIMIT 1\"; You don't need to specify columns when you're deleting rows from a table Also in this query Where are $custid, $user_name, $pass, $authtype, and $qns coming from? It also looks like you missed the '$'s on a few of the variables so the query should look like INSERT INTO banned_users(userid, user_name, user_password, user_type, question, ans, suspend_date) VALUES( '$custid', '$user_name', '$pass', '$authtype', '$qns', '$ans', '$suspend_date') You should really be using prepared statements though. Even if the data is coming from a "trusted source" they're much safer and prevent SQL-Injection attacks Thanks for the help on the first part; it makes sense. Now, "user_name," "pass," "authtype," "qns," and "ans" are login table fields. "custid" is a customer table field. Now, like I said. Since, I'm suspending the login, I'm not sure if I need the following: '$custid,' '$qns', and '$ans.' I just added them for security reasons in order to keep customers or tellers from going through a back door and entering their account if I suspend them. Maybe, I just need the "user_name," "pass," "authtype," and "suspend_date" fields along with the '$user_name', '$pass', '$authtype' and '$suspend_date' variables. Also need help with making sure that the info will delete from "login" and insert into "banned_users." Thanks. I even just tried the following for the version 6 code, but it didn't work either: <?php require '. ./db_connect.php'; //Connect mysql database if (isset($_GET['custid'])) { $query = "SELECT user_name FROM login\"; if ($r = mysql_query($query, $link)) { if (isset($_POST['custid'])) { $query = \"DELETE FROM login WHERE user_name\"; $r = mysql_query($query, $link); $query = \"INSERT INTO banned_users ( user_name, user_password, user_type, question, ans, suspend_date) VALUES ( '$user_name', '$pass', '$authtype', '$qns', '$ans', '$suspend_date')\"; if (@mysql_query($query, $link)) { echo \"Account Suspended Successfully\"; echo \"<p>Click <a href='admin_ban_cust_sel.php'>here</a> to suspend another\"; exit(0); } else { echo \"Could not suspend account\"; echo \"<p>Click <a href='admin_ban_cust_sel.php'>here</a> to try again\"; exit(0); } } } } $db_close=mysql_close(); ?> Really, $custid is for echoing the info into the dropdown menu on the previous page.

A combination of both probably, if you had both at priority 0 there might've been problems deciding which record to use. Anyways glad I could help, let us know if you have any other problems, I'll add the walkthrough to the wiki for future reference some time later.

Hey guys, Just registered for an account. I have a question in regards to pointing my domain to hosting (PS: I did try searching for an answer but couldnt get anything relevant) -- I do not want to change my current name servers and would prefer using my DNS to point to heliohost, how do i go about it? Name servers to be used ns1.heliohost.org. 14400 IN A 65.19.143.3 ns2.heliohost.org. 14360 IN A 64.62.211.133 I obviously cant point to one of the IPs from above. If I had selected sub domain option i could have got my IP but in this case, how do I get IP for my domain name which is currently pointing elsewhere ? -- Another question. Can I brand my name servers ? like ns1.roshanrathod.com and ns2.roshanrathod.com pointing to above IPs? and add relevant A records in current cPanel i.e at heliohost? Anyhelp would be highly appreciated! Cheers! -R

Should be $query = \"DELETE FROM login WHERE custID={$_POST['custid']} LIMIT 1\"; You don't need to specify columns when you're deleting rows from a table Also in this query Where are $custid, $user_name, $pass, $authtype, and $qns coming from? It also looks like you missed the '$'s on a few of the variables so the query should look like INSERT INTO banned_users(userid, user_name, user_password, user_type, question, ans, suspend_date) VALUES( '$custid', '$user_name', '$pass', '$authtype', '$qns', '$ans', '$suspend_date') You should really be using prepared statements though. Even if the data is coming from a "trusted source" they're much safer and prevent SQL-Injection attacks