انا ظبتلك query بالنسبة اللى انتا عاوزها بس ده اخرو D12 ولو السيرفر عندك D13 or D14 قولى وهقولك على الطريقة تعملها إزاى
+1 الى +4 100% و +5 60% و +6 +7 90% و +8 60% و + 9 50% و +10 40% و + 11 20 % و +12 1%
ومن الـــ query تقدر تفهم انت بتعدل على ايه يعنى شارح نفسة
اتفضل
كود PHP:
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2044'
المشاركة الأصلية كتبت بواسطة GM_Jo
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
وعليكم السلام
لو عاوز تظبط نسبة نجاح البلص
انا ظبتلك query بالنسبة اللى انتا عاوزها بس ده اخرو D12 ولو السيرفر عندك D13 or D14 قولى وهقولك على الطريقة تعملها إزاى
+1 الى +4 100% و +5 60% و +6 +7 90% و +8 60% و + 9 50% و +10 40% و + 11 20 % و +12 1%
ومن الـــ query تقدر تفهم انت بتعدل على ايه يعنى شارح نفسة
اتفضل
كود PHP:
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1012554300',Param3='1012554300',Param4='841487361' where ID='2044'
المشاركة الأصلية كتبت بواسطة ™_Zezo_™
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
بص معلش انا جديد تمام فا اشرحلى ازاى اعمل عليهم من ال RefObjItem
ياريت خضرتك لو تظبطلى انت نسبة النحاج
من 1 الى 4 100% و+5 60% +6 +7 80% +8 +9 +10 55% +11 35% +12 20%
اتفضل
كود PHP:
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2044'
المشاركة الأصلية كتبت بواسطة GM_Jo
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
اتفضل
كود PHP:
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1011896375',Param4='926360340' where ID='2044'
[/CENTER]
تمام ازاى بقى اظبطو علشان استخدمو ؟ ولا استخدمو كدا على طول ؟
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1346772580',Param4='504632325' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1346772580',Param4='504632325' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1346772580',Param4='504632325' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1346772580',Param4='504632325' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1346772580',Param4='504632325' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1346772580',Param4='504632325' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1346772580',Param4='504632325' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1346772580',Param4='504632325' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1346772580',Param4='504632325' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1346772580',Param4='504632325' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1346772580',Param4='504632325' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1346772580',Param4='504632325' where ID='2044'