Colonel Posted August 18, 2008 Share Posted August 18, 2008 When trying to update anything in preeferences i get this error... QUERY ERROR: Unknown column 'pro_name' in 'field list' Am i missing a SQL for my preferences? Quote Link to comment Share on other sites More sharing options...
Spudinski Posted August 18, 2008 Share Posted August 18, 2008 Re: Query error Your missing a column in your table, run the query below via phpMyAdmin as a partial fix. ALTER TABLE `users` ADD `pro_name` TEXT NOT NULL; You really need to learn and find out where and why this is happening. Quote Link to comment Share on other sites More sharing options...
Colonel Posted August 18, 2008 Author Share Posted August 18, 2008 Re: Query error That did not work... Any other suggestions? This has me stumped. Quote Link to comment Share on other sites More sharing options...
Spudinski Posted August 18, 2008 Share Posted August 18, 2008 Re: Query error Via phpMyAdmin, delete the previous column, since it's useless. ALTER TABLE `users` DELETE `pro_name`; Do you perhaps have another table in the database that handles this data? Quote Link to comment Share on other sites More sharing options...
POG1 Posted August 18, 2008 Share Posted August 18, 2008 Re: Query error pro_name? that sounds like 1 of the field names i used for a mod i made for my game... Quote Link to comment Share on other sites More sharing options...
Colonel Posted August 19, 2008 Author Share Posted August 19, 2008 Re: Query error Here is most of the preferences.php file without the flags part listed. Is there something i am missing?? <?php class bbcode { var $engine=""; function bbcode() { require "bbcode_engine.php"; $this->engine= new bbcode_engine; $this->engine->cust_tag("/</","<"); $this->engine->cust_tag("/>/",">"); //Since \n and screw up preg, convert them out. $this->engine->cust_tag("/\n/","&nbrlb;"); $this->engine->simple_bbcode_tag("b"); $this->engine->simple_bbcode_tag("i"); $this->engine->simple_bbcode_tag("u"); $this->engine->simple_bbcode_tag("s"); $this->engine->simple_bbcode_tag("sub"); $this->engine->simple_bbcode_tag("sup"); $this->engine->simple_bbcode_tag("big"); $this->engine->simple_bbcode_tag("small"); $this->engine->adv_bbcode_tag("list","ul"); $this->engine->adv_bbcode_tag("olist","ol"); $this->engine->adv_bbcode_tag("item","li"); $this->engine->adv_option_tag("font","font","family"); $this->engine->adv_option_tag("size","font","size"); $this->engine->adv_option_tag("url","a","href"); $this->engine->adv_option_tag("color","font","color"); $this->engine->adv_option_tag("style","span","style"); $this->engine->simp_option_notext("img","src"); $this->engine->simp_bbcode_att("img","src"); $this->engine->cust_tag("/\(c\)/","©"); $this->engine->cust_tag("/\(tm\)/","?"); $this->engine->cust_tag("/\(r\)/","®"); $this->engine->adv_option_tag_em("email","a","href"); $this->engine->adv_bbcode_att_em("email","a","href"); $this->engine->cust_tag("/\[left\](.+?)\[\/left\]/","<div align='left'>\\1</div>"); $this->engine->cust_tag("/\[center\](.+?)\[\/center\]/","<div align='center'>\\1</div>"); $this->engine->cust_tag("/\[right\](.+?)\[\/right\]/","<div align='right'>\\1</div>"); $this->engine->cust_tag("/\[quote="(.+?)\"](.+?)\[\/quote\]/","<div class='quotetop'>QUOTE(\\1)</div><div class='quotemain'>\\2</div>"); $this->engine->cust_tag("/\[quote\](.+?)\[\/quote\]/","<div class='quotetop'>QUOTE</div><div class='quotemain'>\\1</div>"); $this->engine->cust_tag("/\[code\](.+?)\[\/code\]/","<div class='codetop'>CODE</div><div class='codemain'><code>\\1</code></div>"); $this->engine->cust_tag("/\[codebox\](.+?)\[\/codebox\]/","<div class='codetop'>CODE</div><div class='codemain' style='height:200px;white-space:pre;overflow:auto'>\\1</div>"); $this->engine->cust_tag("/&nbrlb;/"," \n"); } function bbcode_parse($html) { return $this->engine->parse_bbcode($html); } } function strip_html_tags($text) { return preg_replace("/<(.+?)>/is","", $text); } require "globals.php"; $bbc = new bbcode; switch($_GET['action']) { case 'changeflag': flag_change(); break; case 'submitflag': flag_submit(); break; case 'sexchange2': do_sex_change(); break; case 'sexchange': conf_sex_change(); break; case 'passchange2': do_pass_change(); break; case 'passchange': pass_change(); break; case 'namechange2': do_name_change(); break; case 'namechange': name_change(); break; case 'infochange2': do_info_change(); break; case 'infochange': info_change(); break; case 'picchange2': do_pic_change(); break; case 'picchange': pic_change(); break; case 'forumchange2': do_forum_change(); break; case 'forumchange': forum_change(); break; case 'sigchange': sig_change(); break; case 'sigchange2': do_sig_change(); break; default: prefs_home(); break; } function prefs_home() { global $db,$ir,$c,$userid,$h; print " <h2>Preferences</h2> <table width='100%' style='border: 1px solid #666;' cellspacing='0' class='ce_hover'> <tr> <th colspan='3' style='border-bottom: 1px dashed #666; padding-left: 15px;'><span style='font-weight: bold; font-size: 15pt;'>Character/Profile Preferences</span></th> </tr> <tr> <td width='33%' style='height: 30px; text-align: center; border-right: 1px dashed #666666; border-bottom: 1px dashed #666666;' valign='top' onMouseOver = 'this.style.backgroundColor = '#333333'' onMouseOut = 'this.style.backgroundColor = '#000000''> [url='preferences.php?action=sexchange']Sex Change[/url] Toggles between Male and Female.</td> <td width='33%' style='height: 30px; text-align: center; border-right: 1px dashed #666; border-bottom: 1px dashed #666;' valign='top' onMouseOver = 'this.style.backgroundColor = '#333'' onMouseOut = 'this.style.backgroundColor = '#000''>[url='preferences.php?action=passchange']Password Change[/url] Changes your password.</td> <td width='33%' style='height: 30px; text-align: center; border-right: 1px dashed #666; border-bottom: 1px dashed #666;' valign='top' onMouseOver = 'this.style.backgroundColor = '#333'' onMouseOut = 'this.style.backgroundColor = '#000''>[url='preferences.php?action=namechange']Name Change[/url] Changes your [i]displayed[/i] name.</td> </tr> <tr> <td style='height: 30px; text-align: center; border-right: 1px dashed #666; border-bottom: 1px dashed #666;' valign='top' onMouseOver = 'this.style.backgroundColor = '#333'' onMouseOut = 'this.style.backgroundColor = '#000''>[url='preferences.php?action=picchange']Display Pic Change[/url] Changes your display picture on your profile.</td> <td style='height: 30px; text-align: center; border-right: 1px dashed #666; border-bottom: 1px dashed #666;' valign='top' onMouseOver = 'this.style.backgroundColor = '#333'' onMouseOut = 'this.style.backgroundColor = '#000''>[url='preferences.php?action=changeflag']Change your counry[/url] Changes your country flag on your profle.</td> <td style='height: 30px; text-align: center; border-right: 1px dashed #666; border-bottom: 1px dashed #666;' valign='top' onMouseOver = 'this.style.backgroundColor = '#333'' onMouseOut = 'this.style.backgroundColor = '#000''>[url='preferences.php?action=sigchange']Profie Signature[/url] Changes Your profile signature.</td> </tr> <tr> <td style='height: 30px; text-align: center; border-right: 1px dashed #666; border-bottom: 1px dashed #666;' valign='top' onMouseOver = 'this.style.backgroundColor = '#333'' onMouseOut = 'this.style.backgroundColor = '#000''>[url='preferences.php?action=infochange']Personal Informaton[/url] Change your personal information on your profile.</td> <td style='height: 30px; text-align: center; border-right: 1px dashed #666; border-bottom: 1px dashed #666;' valign='top' onMouseOver = 'this.style.backgroundColor = '#333'' onMouseOut = 'this.style.backgroundColor = '#000''>[url='preferences.php?action=blogs.php']Blog[/url] Edit your blog.</td> <td style='height: 30px; text-align: center; border-right: 1px dashed #666; border-bottom: 1px dashed #666;' valign='top' onMouseOver = 'this.style.backgroundColor = '#333'' onMouseOut = 'this.style.backgroundColor = '#000''>[url='viewuser.php?u={$ir[']Go To Your Profile![/url] Takes you to your personal profile.</td> </tr> </table></center></center></div> </div> </div> </div> </div>"; } function conf_sex_change() { global $ir,$c,$userid,$h; if($ir['gender'] == "Male") { $g="Female"; } else { $g="Male"; } print "Are you sure you want to become a $g? [url='preferences.php?action=sexchange2']Yes[/url] | [url='preferences.php']No[/url]"; } function do_sex_change() { global $db,$ir,$c,$userid,$h; if($ir['gender'] == "Male") { $g="Female"; } else { $g="Male"; } $db->query("UPDATE users SET gender='$g' WHERE userid=$userid"); print "Success, you are now $g! [url='preferences.php']Back[/url]"; } function pass_change() { global $ir,$c,$userid,$h; print "<h3>Password Change</h3><form action='preferences.php?action=passchange2' method='post'>Current Password: <input type='password' name='oldpw' /> New Password: <input type='password' name='newpw' /> Confirm: <input type='password' name='newpw2' /> <input type='submit' value='Change PW' /></form>"; } function do_pass_change() { global $db,$ir,$c,$userid,$h; if(md5($_POST['oldpw']) != $ir['userpass']) { print "The current password you entered was wrong. [url='preferences.php?action=passchange']> Back[/url]"; } else if($_POST['newpw'] !== $_POST['newpw2']) { print "The new passwords you entered did not match! [url='preferences.php?action=passchange']> Back[/url]"; } else { $db->query("UPDATE users SET userpass=md5('{$_POST['newpw']}') WHERE userid=$userid"); print "Password changed!"; } } function name_change() { global $ir,$c,$userid,$h; print "<h3>Name Change</h3> Please note that you still use the same name to login, this procedure simply changes the name that is displayed. <form action='preferences.php?action=namechange2' method='post'> New Name: <input type='text' name='newname' /> <input type='submit' value='Change Name' /></form>"; } function do_name_change() { global $db,$ir,$c,$userid,$h; if($_POST['newname'] == "") { print "You did not enter a new name. [url='preferences.php?action=namechange']> Back[/url]"; } else { $_POST['newname']=str_replace(array("<", ">", "\\\'"), array("<", ">", "'"), $_POST['newname']); $db->query("UPDATE users SET username='{$_POST['newname']}' WHERE userid=$userid"); print "Username changed! [url='preferences.php']>Back[/url]"; } } function info_change() { global $ir,$c,$userid,$h; print "<h3>Personal Information Change</h3>You will need to fill in all boxes or it will delete what was there <form action=preferences.php?action=infochange2 method=post>Real Name: <input type='text' name='pro_name'> Country: <input type=text name=pro_country> Age: <input type=text name=pro_age> E-Mail: <input type=text name=pro_email> You an choose if you want your info to be shown or not Show -<input type='radio' name='infoshow' value='0'> <input type='radio' name='infoshow' value='1'>- Hide <input type=submit value=Submit></form> "; } function do_info_change() { global $db,$ir,$c,$userid,$h; $_POST['pro_name']=str_replace(array("<", ">", "\\\'"), array("<", ">", "'"), $_POST['pro_name']); $db->query("UPDATE users SET pro_name='{$_POST['pro_name']}' WHERE userid=$userid"); $db->query("UPDATE users SET pro_country='{$_POST['pro_country']}' WHERE userid=$userid"); $db->query("UPDATE users SET pro_age='{$_POST['pro_age']}' WHERE userid=$userid"); $db->query("UPDATE users SET pro_email='{$_POST['pro_email']}' WHERE userid=$userid"); $db->query("UPDATE users SET infoshow='{$_POST['infoshow']}' WHERE userid=$userid"); print "Details changed! [url='preferences.php']>Back[/url]"; } function pic_change() { global $ir,$c,$userid,$h; print "<h3>Pic Change</h3> Please note that this must be externally hosted, [url='http://imageshack.us']ImageShack[/url] is our recommendation. Any images that are not 150x150 will be automatically resized <form action='preferences.php?action=picchange2' method='post'> New Pic: <input type='text' name='newpic' value='{$ir['display_pic']}' /> <input type='submit' value='Change Name' /></form>"; } function do_pic_change() { global $db,$ir,$c,$userid,$h; if($_POST['newpic'] == "") { print "You did not enter a new pic. [url='preferences.php']>Back[/url]"; } else { $_POST['newpic']=str_replace('\\\'',''', $_POST['newpic']); $db->query("UPDATE users SET display_pic='{$_POST['newpic']}' WHERE userid=$userid"); print "Pic changed! [url='preferences.php']>Back[/url]"; } } function forum_change() { global $ir,$c,$userid,$h; print "<h3>Forum Info Change</h3> Please note that the avatar must be externally hosted, [url='http://imageshack.us']ImageShack[/url] is our recommendation. Any avatars that are not 100x100 will be automatically resized <form action='preferences.php?action=forumchange2' method='post'> Avatar: <input type='text' name='forums_avatar' value='{$ir['forums_avatar']}' /> Signature (you may use BBcode): <textarea rows=10 cols=50 name='forums_signature'>{$ir['forums_signature']}</textarea> <input type='submit' value='Change Info' /></form>"; } function do_forum_change() { global $db,$ir,$c,$userid,$h; $_POST['forums_avatar']=str_replace(array("<", ">"), array("<", ">"), $_POST['forums_avatar']); $db->query("UPDATE users SET forums_avatar='{$_POST['forums_avatar']}', forums_signature='{$_POST['forums_signature']}' WHERE userid=$userid"); print "Forum Info changed! [url='preferences.php']>Back[/url]"; } function sig_change() { global $ir,$c,$userid,$h; print "<h3>Profile Signature Change</h3> Profile sig goes here. *note* big signatures look poo. 'less is more' No BBcode yet. sorry :(<form action='preferences.php?action=sigchange2' method='post'><textarea rows=10 cols=80 name='pro_sig'> ".htmlspecialchars($ir['pro_sig'])."</textarea> <input type='submit' value='Change Info' /></form>"; } function do_sig_change() { global $db,$ir,$c,$userid,$h; $_POST['pro_sig']=str_replace(array("<", ">"), array("<", ">"), $_POST['pro_sig']); $db->query("UPDATE users SET pro_sig='{$_POST['pro_sig']}', pro_sig='{$_POST['pro_sig']}' WHERE userid=$userid"); print "Profile signature changed! [url='preferences.php']>Back[/url]"; } Quote Link to comment Share on other sites More sharing options...
POG1 Posted August 19, 2008 Share Posted August 19, 2008 Re: Query error wtf! where did u get that? i made that for my game... Quote Link to comment Share on other sites More sharing options...
Colonel Posted August 19, 2008 Author Share Posted August 19, 2008 Re: Query error Copied and pasted from a thread here that was a free mod. Quote Link to comment Share on other sites More sharing options...
POG1 Posted August 19, 2008 Share Posted August 19, 2008 Re: Query error Whats the link? It shouldn't be on here :S Quote Link to comment Share on other sites More sharing options...
Colonel Posted August 19, 2008 Author Share Posted August 19, 2008 Re: Query error http://criminalexistence.com/ceforums/i ... ic=20270.0 Now then, since you said you created it could you possibly assist me in fixing it? Quote Link to comment Share on other sites More sharing options...
Colonel Posted August 19, 2008 Author Share Posted August 19, 2008 Re: Query error I take that as a NO Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.