I know someone throws this error when trying to install OSDs?
Warning: mssql_query() [function.mssql-query]: message: Column names in each table must be unique. Column name 'Reborn' in table 'user_character' is specified more than once. (severity 16) in E:\xampp\htdocs\osds\config\install.php on line 96
Warning: mssql_query() [function.mssql-query]: Query failed in E:\xampp\htdocs\osds\config\install.php on line 96
IF you see this message without any errors, it means everyhting went ok
and i've added the Reborn to user_character for the reborn system.
You are now ready to enter OsDs Gm Control Panel.
Column names in each table must be unique. Column name '%.*ls' in table '%.*ls' is specified more than once.
By : Frank Kalis
Sep 08, 2007
Error Message:
Msg 2705, Level 16, State 3, Line 1
Column names in each table must be unique. Column name '%.*ls' in table '%.*ls' is specified more than once.
Severity level:
16.
Description:
This error message appears when you try to specify a name for a column more than once upon creation of a table.
Consequences:
The T-SQL statement can be parsed, but causes the error at runtime.
Resolution:
Error of the Severity Level 16 are generated by the user and are corrigible by the user. The statement cannot be executed this way. Columns names within a table must be unique.
Versions:
All versions of SQL Server
Example(s):
USE tempdb;
GO
IF OBJECT_ID('tempdb..#t') > 0
DROP TABLE #t
GO
CREATE TABLE #t
(
id INT
CONSTRAINT PK_t PRIMARY KEY,
id INT
)
Remarks:
In the above example we try to use the name ID for more than one column in the same table. This raises the error.
i m facing errors. i can log in osbs admin. but when i selected any function in the page. it will bring me to woooph ERROR PLEASE LOGIN AGAIN. Any idea?
Warning: mssql_query() [function.mssql-query]: message: Column names in each table must be unique. Column name 'Reborn' in table 'user_character' is specified more than once. (severity 16) in C:\xampp\htdocs\osds\config\install.php on line 96
Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\osds\config\install.php on line 96
IF you see this message without any errors, it means everyhting went ok
and i've added the Reborn to user_character for the reborn system.
You are now ready to enter OsDs Gm Control Panel
<tr>
<td align='left' colspan='3'>
<input type='hidden' name='select' value='2'>
<input type='hidden' name='char_no' value='".$row2[0]."'>
<input type='hidden' name='user_no' value='".$row2[1]."'>
<input type='hidden' name='char_name' value='".$_POST['charname']."'>
<input type='submit' value='Set new Character Stats'>
</td>
</tr>
</table>
</form></center>";
}
} elseif($_POST['select'] == '2') {
$ms_con = mssql_connect($mssql['host'],$mssql['user'],$mssql['pass']);
$result1 = mssql_query("SELECT login_flag FROM account.dbo.USER_PROFILE WHERE user_no = '".$_POST['user_no']."'",$ms_con);
$row1 = mssql_fetch_row($result1);
if($row1[0] == '1100') {
$result2 = mssql_query("SELECT character_no FROM character.dbo.user_character WHERE user_no = '".$_POST['user_no']."' ORDER by login_time DESC",$ms_con);
$row2 = mssql_fetch_row($result2);
}
if($row1[0] == '1100' && $row2[0] == $_POST['char_no']) {
echo "<br>This character can not currently be edited, since it is online.<br><a href='javascript:history.back()'>Go Back</a>";
echo "<br>The new character's name is not just letters and numbers or is shorter than 3 characters or longer than 20 characters.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_exp'])) {
echo "<br>Experience does not only consist of numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_lvl'])) {
echo "<br>The level indication does not only consist of numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_str'])) {
echo "<br>The data points Str consists not only of numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_dex'])) {
echo "<br>The Dex data points is not just numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_con'])) {
echo "<br>The Con data points is not just numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_spr'])) {
echo "<br>The Spr data points is not just numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_inv_money'])) {
echo "<br>The new DIL Inventory consists not only of numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_war_money'])) {
echo "<br>The new DIL Warehouse does not only consist of numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_ret_x'])) {
echo "<br>The new return point X is not just numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_ret_y'])) {
echo "<br>The new return point Y is not just numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_stats'])) {
echo "<br>The stats point is not just numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_skill'])) {
echo "<br>The skill points is not just numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_pk'])) {
echo "<br>The PK count is not just numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_chaotic'])) {
echo "<br>The Chaotic level does not only consist of numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_reborn'])) {
echo "<br>Invalid Reborn Number<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_skillreset'])) {
echo "<br>Invalid Skill Reset Number Can only be 1 of 0<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_statreset'])) {
echo "<br>Invalid Stats Reset Number Can only be 1 of 0<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_adv'])) {
echo "<br>The Adv count is not just numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_hp'])) {
echo "<br>The HP count is not just numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_mp'])) {
echo "<br>The MP count is not just numbers.<br><a href='javascript:history.back()'>Go Back</a>";
} elseif(!preg_match("/[0-9]?/", $_POST['new_shield'])) {
echo "<br>The Shield count is not just numbers.<br><a href='javascript:history.back()'>Go Back</a>";
echo "<br>".$_POST['new_charname']." Edited!<br> Remember the changes successfully when you are new in the account has logged.";
}
} else {
echo "<br>This function does not exist.";
}
?>
</center>
It's me again, about stats and skill editing. Now take a look what you were giving to us and saying IT IS WORKING FOR ME:
I have found where is the problem why it is not editing free skills and stats and making always to 0. Take a look at your script:
I am having a problem with the send weapons page. The available weapons option is blank for all characters. Most of the other pages are working. Is this fixed in the update? If so, can someone fix the link to the update page? I click the download button and nothing happens. Thanks!
Thanks for the link to the update, but it doesn't have the osds.b3 download. What can I look for to see why the available weapons would not be populating correctly?
i have no DB nor server so i cant test it know, but i can say that it does work when i made it
the code looks ok, i can only guess that osds db is not correctly installed, i can be wrong
Thanks for the link to the update, but it doesn't have the osds.b3 download. What can I look for to see why the available weapons would not be populating correctly?
Use this link to get a working Weapons.php
Janvier, I looked at the script. There was one tiny issue. One of the mssql was set to mysql. Just quick switch back to mssql and the weapons send worked nicely
[MY FINAL RELEASE] CONTROL PANEL SERVER 06/08/2013 - CO2 PServer Guides & Releases - 10 Replies My Last Release
Please read the README File as it does give credits to a few... and says my last good byes =]]
anyway no if you message me saying you want the whole thing you can wait a billion years you wont get reply..
email [email protected] << MY FRIEND he can help with C# and lotf but mostly lotf he told me that
to learn how to send him a message read the README file..
[RELEASE] NEW XAMPP Control Panel 03/18/2010 - Flyff Hacks, Bots, Cheats, Exploits & Macros - 2 Replies Hiermit veröffentliche ich meinen selbst geschriebenen XAMPP Control Panel
Installationspfad : C:\XAMPP
Setup : Vorhanden ( automatisch )
Version : 2.0
Convertiert zur : exe
Scriptsprache : BATCH
Sprache : Englisch oder Deutsch
Was ist so besonders an den Neuen XAMPP Control Panel ?
[RELEASE] Control Panel for TQ Binary 09/22/2009 - CO2 PServer Guides & Releases - 25 Replies Ok this wasnt made by me it was made by a friend, id like you guys to have it to, its a control panel which auto types in the commands you're client must be in full screen, If you have any problems let me know il guide you, Also if this isnt allowed mod please remove it, Thanks!