[Release] OsDs Control Panel

Page 6 of 12 « First 45 6 78 Last »
11/12/2009 20:38 Slash003#76
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.
11/12/2009 20:56 janvier123#77
google :)

Quote:
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.
11/13/2009 12:37 nobleman80#78
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?
11/13/2009 13:57 janvier123#79
you installed it wrongly, its a safety feature
11/13/2009 15:17 nobleman80#80
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

any idea for this 2 errors?
11/13/2009 16:50 ReallyDARK#81
im a lil bit confusted with errors like 'no access', i did something wrong, im sure ;)
Can some1 tell me what ? :) ICQ -> 567 446 932 =DDDDDD
11/21/2009 19:50 gedimazs#82
Quote:
Originally Posted by janvier123 View Post
Mine is working:

if you download this and remake the file, then it does not work, i cant help you, the problem is on your side:
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:
Code:
  } else {
            mssql_query("UPDATE
                    character.dbo.user_character 
                SET
                    character_name = '".$_POST['new_charname']."',
                    dwExp = '".$_POST['new_exp']."',
                    dwMoney = '".$_POST['new_inv_money']."',
                    dwStoreMoney = '".$_POST['new_war_money']."',
                    wStr = '".$_POST['new_str']."',
                    wDex = '".$_POST['new_dex']."',
                    wCon = '".$_POST['new_con']."',
                    wSpr = '".$_POST['new_spr']."',
                    wRetPosX = '".$_POST['new_ret_x']."',
                    wRetPosY = '".$_POST['new_ret_y']."',
                    wRetMapIndex = '".$_POST['new_ret_map']."',
                   [COLOR="Red"] wStatPoint = '".$_POST['new_statsreset']."',
                    wSkillPoint = '".$_POST['new_skillreset']."',[/COLOR]
                    wLevel = '".$_POST['new_lvl']."',
                    byPCClass = '".$_POST['new_class']."',
                    wPKCount = '".$_POST['new_pk']."',
                    wChaoticLevel = '".$_POST['new_chaotic']."',
                    dwPVPPoint = '".$_POST['new_pvp_t']."',
                    wWinRecord = '".$_POST['new_pvp_w']."',
                    wLoseRecord = '".$_POST['new_pvp_l']."',
                    wDrawRecord = '".$_POST['new_pvp_d']."',
                    Reborn = '".$_POST['new_reborn']."',
                    bySkillClearCount = '".$_POST['new_skillreset']."',
                    byStatClearCount = '".$_POST['new_statreset']."',
                    dwAdv = '".$_POST['new_adv']."',
                    nHP = '".$_POST['new_hp']."',
                    nMP = '".$_POST['new_mp']."',
                    nShield = '".$_POST['new_shield']."'
                WHERE
                    character_no = '".$_POST['char_no']."'",$ms_con);
Now you see?? So how it could change anything when after pressing edit it is reseting not changing.
11/22/2009 04:09 janvier123#83
ye your right

just change

PHP Code:
                    wStatPoint = '".$_POST['new_statsreset']."',
                    wSkillPoint = '".$_POST['new_skillreset']."', 
into
PHP Code:
                    wStatPoint = '".$_POST['new_stats']."',
                    wSkillPoint = '".$_POST['new_skill']."', 
11/22/2009 07:20 gedimazs#84
I did it before I have posted.
12/04/2009 21:43 ryufireblade#85
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!
12/04/2009 22:05 janvier123#86
[Only registered and activated users can see links. Click Here To Register...]
look there
12/04/2009 23:39 ryufireblade#87
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?
12/05/2009 01:01 janvier123#88
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
12/05/2009 04:49 fiore14#89
Quote:
Originally Posted by ryufireblade View Post
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

[Only registered and activated users can see links. Click Here To Register...]


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
12/05/2009 11:38 janvier123#90
Line 123

PHP Code:
        $ms_con = mysql_connect($mssql['host'],$mssql['user'],$mssql['pass']); 
fixed and added
[Only registered and activated users can see links. Click Here To Register...]
Page 6 of 12 « First 45 6 78 Last »