YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register.
3 Pages123>
Post your Modifications, Patches, Themes and Language Files In This Forum
Options
View
Go to last post Go to first unread
Previous Topic Next Topic
Offline Jaben  
#1 Posted : Thursday, December 21, 2006 1:32:13 AM(UTC)
Jaben


Rank: YAF Developer

Reputation:

Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.YAF.NET Supporter: Loves YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

Joined: 10/9/2004(UTC)
Posts: 2,547
Location: United States

Thanks: 142 times
Was thanked: 353 time(s) in 196 post(s)
Welcome to the Modifications and Patches Forum

This is the only forum that allows file uploading (max 5 megs).

Please enhance the YAF community by posting your:

  • Modifications
  • Bug fixes/Patches
  • Smiles Packs
  • Avatars Packs
  • Themes
  • Updated Language Files

    If you are posting a Theme please attach a screen shot of the theme. For all items explain WHICH version of YAF they are designed for.

    Thanks!

    -Jaben

    Edited by user Saturday, October 6, 2007 12:11:46 AM(UTC)  | Reason: Not specified

    • UserPostedImage
    Back to top
    Sponsor
    Back to top  

    Wanna join the discussion?! Login to your YAF.NET Support Forum forum accountor Register a new forum account.
    Back to top  
    Offline Jaben  
    #2 Posted : Thursday, December 21, 2006 1:48:30 AM(UTC)
    Jaben


    Rank: YAF Developer

    Reputation:

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.YAF.NET Supporter: Loves YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

    Joined: 10/9/2004(UTC)
    Posts: 2,547
    Location: United States

    Thanks: 142 times
    Was thanked: 353 time(s) in 196 post(s)
    How do you post a file?

    First, create a new topic like usual and click "Post". Then, after your new topic has been created, you click the "Attach" button on your new post. From there, you can easily upload multiple files.
    UserPostedImage
    Back to top
    Offline alii  
    #3 Posted : Wednesday, July 23, 2008 6:10:14 AM(UTC)
    alii


    Rank: YAF Forumling

    Reputation:

    Joined: 7/23/2008(UTC)
    Posts: 1
    Where can I have file for translating from English?
    Back to top
    Offline bbobb  
    #4 Posted : Sunday, January 18, 2009 4:18:16 PM(UTC)
    bbobb


    Rank: YAF Developer

    Reputation:

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support King: Given for answering tons of support questions and generally helping the community.Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 1,558
    Man
    Russian Federation
    Location: Moscow

    Thanks: 51 times
    Was thanked: 287 time(s) in 253 post(s)
    Simply patch for data layer.
    MySQLPostgreFirebird for YAF
    UserPostedImage
    Back to top
    Offline bbobb  
    #5 Posted : Sunday, January 18, 2009 4:20:26 PM(UTC)
    bbobb


    Rank: YAF Developer

    Reputation:

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support King: Given for answering tons of support questions and generally helping the community.Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 1,558
    Man
    Russian Federation
    Location: Moscow

    Thanks: 51 times
    Was thanked: 287 time(s) in 253 post(s)
    Simply patch for data layer.
    File Attachment(s):
    sp_report_copyover.diff.zip (1kb) downloaded 204 time(s).
    MySQLPostgreFirebird for YAF
    UserPostedImage
    Back to top
    Offline bbobb  
    #6 Posted : Friday, January 23, 2009 10:36:31 PM(UTC)
    bbobb


    Rank: YAF Developer

    Reputation:

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support King: Given for answering tons of support questions and generally helping the community.Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 1,558
    Man
    Russian Federation
    Location: Moscow

    Thanks: 51 times
    Was thanked: 287 time(s) in 253 post(s)
    A patch to begin separate data layer remnants from core code(harmless one).
    On applying, the /YetAnotherForum.Net/ folder will be completly cleared from MS SQL database code. And it's completly safe and tested.
    After this all the DB related code should be separated at last:-d .

    Edited by user Monday, January 26, 2009 4:48:36 AM(UTC)  | Reason: Patch additions

    File Attachment(s):
    data_layer_separation4.patch.zip (7kb) downloaded 143 time(s).
    MySQLPostgreFirebird for YAF
    UserPostedImage
    Back to top
    Offline bbobb  
    #7 Posted : Sunday, February 1, 2009 7:32:02 AM(UTC)
    bbobb


    Rank: YAF Developer

    Reputation:

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support King: Given for answering tons of support questions and generally helping the community.Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 1,558
    Man
    Russian Federation
    Location: Moscow

    Thanks: 51 times
    Was thanked: 287 time(s) in 253 post(s)
    Missing conversion hacks for other data layers
    File Attachment(s):
    universal_casts_for_other_datalayers_r1.txt (3kb) downloaded 187 time(s).
    MySQLPostgreFirebird for YAF
    UserPostedImage
    Back to top
    Offline RavenDev  
    #8 Posted : Thursday, February 12, 2009 11:14:08 PM(UTC)
    RavenDev


    Rank: YAF Forumling

    Reputation:

    Joined: 2/12/2009(UTC)
    Posts: 2
    Lithuanian Language

    my forum at web adress www.ravendev.lt/forum


    File Attachment(s):
    lithuanian.xml (39kb) downloaded 154 time(s).
    Back to top
    Offline test2005  
    #9 Posted : Friday, February 13, 2009 11:33:28 PM(UTC)
    test2005


    Rank: YAF MVP

    Reputation:

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.

    Joined: 2/12/2005(UTC)
    Posts: 761

    Was thanked: 1 time(s) in 1 post(s)
    RavenDev wrote:
    Lithuanian Language

    my forum at web adress www.ravendev.lt/forum




    Thanks for the contribution! :)
    .....the man in black fled across the desert..........and the gunslinger followed.....
    Back to top
    Offline RavenDev  
    #10 Posted : Sunday, February 15, 2009 11:17:34 PM(UTC)
    RavenDev


    Rank: YAF Forumling

    Reputation:

    Joined: 2/12/2009(UTC)
    Posts: 2
    from my forum you can get image files with Lithuanian language
    Back to top
    Offline bbobb  
    #11 Posted : Tuesday, February 17, 2009 7:30:56 AM(UTC)
    bbobb


    Rank: YAF Developer

    Reputation:

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support King: Given for answering tons of support questions and generally helping the community.Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 1,558
    Man
    Russian Federation
    Location: Moscow

    Thanks: 51 times
    Was thanked: 287 time(s) in 253 post(s)
    The proposed patch to make all data layers almost safe proof compatable in future.
    It's for MS SQL data layer, but the only difference is in the DBAccess.cs file and class CoolCoverter.
    For MySQL it reads for any data layer like this^
    Quote:

    public static class CoolConverter
    {
    public static int VerifyInt32(object value)
    {
    if (value == DBNull.Value) return 0;
    return Convert.ToInt32(value);
    }
    public static bool VeryfyBool(object value)
    {
    if (value == DBNull.Value || value.ToString() == "0") return false;
    if ( value.ToString() == "1") return true;
    return Convert.ToBoolean(value);
    }
    }

    For postgreSQL it's like this
    Quote:
    public static class CoolConverter
    {

    public static int VerifyInt32(object o)
    {
    //if (o == DBNull.Value || o =="f" ) o = 0;
    // if (o == "t") o = 1;
    return Convert.ToInt32(o);
    }
    public static bool VeryfyBool(object o)
    {
    if (o.ToString() == "t") { return true; }
    if (o.ToString() == "f") { return false; }
    return false;
    }
    }

    For MS SQL Server it's simply
    Quote:
    public static class CoolConverter
    + {
    + public static int VerifyInt32(object o)
    + {
    + return (int)o;
    + }
    + public static bool VeryfyBool(object o)
    + {
    + return (bool)o;
    + }
    + }


    In the last case it's much more faster than using Convert.ToInt32 or Convert.ToBool :wink:

    Edited by user Tuesday, February 17, 2009 7:38:23 AM(UTC)  | Reason: Not specified

    MySQLPostgreFirebird for YAF
    UserPostedImage
    Back to top
    Offline Jaben  
    #12 Posted : Wednesday, February 18, 2009 1:03:03 AM(UTC)
    Jaben


    Rank: YAF Developer

    Reputation:

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.YAF.NET Supporter: Loves YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

    Joined: 10/9/2004(UTC)
    Posts: 2,547
    Location: United States

    Thanks: 142 times
    Was thanked: 353 time(s) in 196 post(s)
    On little thing... I have to change the name to "SqlDataLayerConverter".

    CoolConverter just isn't proper naming for the class.

    Thank you for all your help though, bbobb.
    UserPostedImage
    Back to top
    Offline bbobb  
    #13 Posted : Wednesday, February 18, 2009 3:33:17 AM(UTC)
    bbobb


    Rank: YAF Developer

    Reputation:

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support King: Given for answering tons of support questions and generally helping the community.Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 1,558
    Man
    Russian Federation
    Location: Moscow

    Thanks: 51 times
    Was thanked: 287 time(s) in 253 post(s)
    Jaben wrote:
    On little thing... I have to change the name to "SqlDataLayerConverter".
    CoolConverter just isn't proper naming for the class.

    No matter, it was a temporary example class name anyway. I wait while it appears and verify data layers again to avoid any possible bugs.
    Thanks that you found time for it:)
    MySQLPostgreFirebird for YAF
    UserPostedImage
    Back to top
    Offline bbobb  
    #14 Posted : Thursday, February 19, 2009 1:43:16 PM(UTC)
    bbobb


    Rank: YAF Developer

    Reputation:

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support King: Given for answering tons of support questions and generally helping the community.Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

    Joined: 10/21/2008(UTC)
    Posts: 1,558
    Man
    Russian Federation
    Location: Moscow

    Thanks: 51 times
    Was thanked: 287 time(s) in 253 post(s)
    No, I was wrong.
    The class for MSSQL
    public static class SqlDataLayerConverter
    + {
    + public static int VerifyInt32(object o)
    + {
    + return (int)o;
    + }
    + public static bool VeryfyBool(object o)
    + {
    + return (bool)o;
    + }
    + }
    doesn't work, because unboxing doesn't work safe in the case though it's fast.
    Convert.To... should be used anyway:cry:
    This makes boxing of DataRow value which is already filled by a value.
    I was somehow completly sure that it should work.
    And it's impossible to make dynamic conversion class without code deep changing in many places.
    Sorry.

    Edited by user Thursday, February 19, 2009 1:45:11 PM(UTC)  | Reason: Not specified

    MySQLPostgreFirebird for YAF
    UserPostedImage
    Back to top
    Offline Jaben  
    #15 Posted : Thursday, February 19, 2009 3:23:42 PM(UTC)
    Jaben


    Rank: YAF Developer

    Reputation:

    Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.YAF.NET Supporter: Loves YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.

    Joined: 10/9/2004(UTC)
    Posts: 2,547
    Location: United States

    Thanks: 142 times
    Was thanked: 353 time(s) in 196 post(s)
    Interestingly, I haven't applied the conversion code yet. So I'll just hold off for now. I did apply the data layer centralization changes.
    UserPostedImage
    Back to top
    Rss Feed  Atom Feed
    Users browsing this topic
    3 Pages123>
    Forum Jump  
    You cannot post new topics in this forum.
    You cannot reply to topics in this forum.
    You cannot delete your posts in this forum.
    You cannot edit your posts in this forum.
    You cannot create polls in this forum.
    You cannot vote in polls in this forum.

    Powered by YAF.NET 2.2.4.9 | YAF.NET © 2003-2018, Yet Another Forum.NET
    This page was generated in 0.175 seconds.

    Notification

    Icon
    Error

    About

    The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

    Project Twitter Updates

    Contact Us

    Email: Email Contact

    Stay Connected

    Powered by Resharper

    Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved Privacy Policy